Skip to main content
Daily Product IdeaDaily Product Idea
Coming soonEvidence: Indicative

UOM Bridge: Weight-Based Inventory & COGS Ledger for Specialty Food Retailers

A thin inventory ledger that sits between the existing POS and accounting system rather than replacing either.

Last assessed · Methodology v5.1 · How ideas are researched and assessed

Problem in brief

Speciality food shops buy in 40 lb cases or 60 kg sacks and sell 0.37 lb of cheese or a 12 oz bag, and stock moves between locations. Square sellers report the purchase order feature only accepts whole numbers and doesn't recognise items stocked in lbs, and requests for decimal quantities and variable-weight inventory have run for years without resolution. On the accounting side, multiple unit-of-measure sets are a QuickBooks Desktop Premier or Enterprise feature, so smaller shops have no native case-to-pound conversion, and a roaster wanting to capture the roughly 15% weight loss from green to roasted coffee is left improvising. Many owners switch the inventory module off and rebuild counts and cost of goods in a weekly spreadsheet by hand.

Who has this problem
Owner-operators and bookkeepers of small specialty food retailers (coffee roasters, cheese and deli counters, butcher shops, olive-oil/bulk goods stores) with 1-3 locations who buy in bulk units and sell by weight or fractional measure
How they cope today
Manual spreadsheet inventory counts, avoiding the software's inventory module, or searching forums for a suitable POS
What it costs them
Weekly or ongoing manual reconciliation work and risk of inaccurate inventory and COGS figures

The problem in detail

Their POS sells 0.37 lb of cheese or a 12 oz bag while purchases arrive as 40 lb cases or 60 kg sacks, and the same SKU moves between locations. Square, Toast, Lightspeed and QuickBooks inventory modules assume one unit per SKU and whole-number counts, so owners turn the inventory module off entirely and rebuild counts and COGS in a weekly spreadsheet by hand \u2014 hours of work that still produces margins nobody trusts.

Proposed product

A thin inventory ledger that sits between the existing POS and accounting system rather than replacing either. You map each SKU once to a base unit (grams, ml) with conversion factors for every purchase, transfer, prep and sale unit, including yield loss (roast shrink, trim waste). It then pulls sales from the POS and purchases from invoices/bills, keeps a running theoretical on-hand per location in base units, and outputs a period COGS journal entry to QuickBooks or Xero. Physical counts are entered in whatever unit is convenient and produce a variance report by SKU and location showing shrink in both units and dollars.

Why now

Square's own community shows the gap is durable, not transient: a seller reports the Purchase Order feature is unusable because it only accepts whole numbers and doesn't recognise items stocked in lbs, forcing them to receive stock item-by-item in decimals. A separate request thread for decimal quantities and variable-weight inventory has run for years with a Square product manager participating, with replies continuing into September 2025 still asking for decimal quantity. On the accounting side, a roaster describes needing to move green coffee to roasted stock at roughly 0.85 lb yield per pound without spinning up a WIP account for 15-20 daily batches, and a peer answer plus Intuit help pages indicate multiple unit-of-measure sets are a QuickBooks Desktop Premier/Enterprise feature, absent from QuickBooks Online and the retail edition. So the conversion layer these operators need is missing at both ends of their stack — though the same scan shows Yellow Dog and roaster-focused tools already occupy this position further up-market.

Smallest useful version

A web app for Square sellers only: connect Square, import the item catalog, define base unit + conversion factors + yield percentage per SKU, enter purchases by pasting or uploading supplier invoices, and get two outputs \u2014 a weekly count sheet with theoretical vs actual variance, and a one-click COGS journal entry CSV for QuickBooks. No purchasing, no forecasting, no barcode scanning. Sell at roughly $49/month and validate by replacing one bookkeeper's existing weekly spreadsheet end to end.

Potential ways to charge

  • Flat SaaS subscription per location, around £/$49 a month for a single-location shop, with a step up for 2-3 locations
  • Setup or onboarding fee for building the SKU-to-base-unit conversion map and yield factors from the customer's supplier invoices
  • Bookkeeper/accountant partner plan: one login covering several client shops, billed per client file
  • Per-period COGS close add-on for firms that want the journal entry reviewed and posted rather than exported

Routes to early customers

  • The Square community threads themselves — the sellers asking for decimal quantities and variable-weight inventory are self-identified and reachable
  • Bookkeepers who already maintain weekly inventory spreadsheets for food clients; one such spreadsheet is the stated validation target
  • Speciality coffee roaster forums and groups, where the green-to-roasted yield problem is already being discussed on accounting platforms
  • Direct outreach to cheese counters, butchers and bulk-goods shops in one city, offering to rebuild their current spreadsheet as a paid pilot

Main risks

  • The riskiest assumption stands untested: samples, staff consumption, spoilage, imprecise counter weighing and prep may swamp the variance so the numbers are no more trusted than the spreadsheet they replace.
  • The differentiation evidence actively weakens the idea — Yellow Dog markets the same 'layer between Square and QuickBooks' position with recipe management, food costing and invoice export, and Cropster, RoastLog, Katana, Acctivate and Fishbowl cover roasters and manufacturing. Price and setup simplicity are the only proposed wedge and neither is shown to be an unsolved need.
  • Square could ship decimal quantities and close the most acute part of the pain; a product manager is engaged in the thread.
  • Per-SKU setup of base units, conversions and yield factors is real work for the owner, and abandonment during onboarding is the classic failure mode for inventory tools.
  • No independent demand signal was found: freelance searches returned only generic bookkeeping and QuickBooks cleanup work, and no keyword or search-volume data was retrieved. Willingness to pay is unverified.

Questions to test first

  • Take one shop's last 8-13 weeks of Square sales, supplier invoices and physical counts, compute theoretical on-hand by hand, and see whether the variance lands in a range the owner calls believable — this tests the riskiest assumption before any code.
  • Ask five Square sellers from the decimal-quantity threads what they do today and whether they currently pay anyone for it, given no paid-labour market was found.
  • Price-test against Yellow Dog and the roaster tools: get quotes or published pricing and ask three 1-3 location operators why they have or haven't bought them.
  • Run a timed onboarding with one bookkeeper: how long does it actually take to map 150-300 SKUs to base units with conversions and yields?
  • Offer a paid manual service first — you rebuild the weekly count sheet and COGS entry — and see whether anyone renews for a second month.

Evidence and sources

The sources this assessment is based on. Evidence level: Indicative, counted from these sources as described in how ideas are assessed. Findings are what a source shows; anything the research only inferred is marked as an inference.

Research findings

  • SupportsSquare Seller Community feature request thread · 28 September 2025

    Shows: support-forum complaint / feature request on vendor's own community

    A Square seller posts that the Purchase Order feature cannot be used at all because it only allows whole numbers and does not recognise items stocked in lbs; they must open each item individually to receive stock in decimals, which they describe as time-consuming and error-prone. This is a direct, dated support complaint (not a peer discussion board) matching the stated problem: purchase units and weight-based stock units don't reconcile in the POS, so the module gets abandoned or hand-worked.

  • SupportsQuickBooks Community question from a coffee roasting business · 24 September 2020

    Shows: accounting-platform support thread describing yield loss / unit conversion workaround

    A roaster asks how to move green coffee to roasted inventory in QuickBooks, states that a WIP account per 15-20 daily batches is inefficient, and that one pound of green yields about 0.85 lb roasted, a weight loss they need to capture. This is the specific roast-shrink yield-factor requirement the candidate proposes to model, stated by an affected operator rather than inferred.

  • SupportsSquare Seller Community troubleshooting thread (2019 through 2025) · 4 February 2019

    Shows: long-running user complaint thread with vendor product manager participation

    Sellers who sell by weight ask Square for decimal quantity fields and variable-weight inventory (e.g. three chickens of different weights in the freezer); a Square Point of Sale product manager solicits input, and replies continue into September 2025 still reiterating that decimal quantity is the most immediate need. A six-year-old unresolved thread on the vendor's own site indicates the whole-unit assumption is durable, not a quickly-closed gap.

  • SupportsQuickBooks Community thread on buying and selling in cases, boxes, eaches, packs · 11 December 2018

    Shows: peer/expert answer describing limits of incumbent multi-UOM support

    Respondent states multiple unit of measure in QuickBooks is poorly implemented and is only available in Accountant, Contractor or Manufacturing editions, not the retail edition; Intuit help pages confirm multiple UOM sets are a QuickBooks Desktop Premier/Enterprise feature. Small retailers on QuickBooks Online or retail-edition Desktop therefore lack native case-to-pound conversion, supporting the premise that the conversion layer is missing for this segment.

  • Weakens the caseVendor marketing pages (Yellow Dog Software Square integration; Acctivate coffee roasting software) and roundup listings

    Shows: competitor/vendor landscape scan

    Yellow Dog Inventory markets itself as sitting alongside Square with recipe management, physical inventory, food costing and invoice export to QuickBooks — structurally the same 'thin layer between POS and accounting' position. Acctivate, Cropster, RoastLog, Katana and Fishbowl cover roaster/manufacturing inventory with QuickBooks integration. The niche is occupied at the mid-market/enterprise end; differentiation for a 1-3 location tool would have to rest on price and setup simplicity, which these pages do not show as solved (inference).

Where the problem was reported

Public posts in which people described this problem, grouped into one problem before research began.

Looked for, not found

  • Searches for freelance postings showing people paid to rebuild weight-based inventory/COGS by hand returned only generic bookkeeping and inventory-freelancer listings (cleanup, reconciliation, QuickBooks catch-up) with no posting specific to unit-of-measure conversion, weight-based COGS or shrink reconciliation for food retailers. No keyword-volume or search-demand dataset was retrieved either. Whether a paid manual-labour market exists for this specific task is therefore unverified.

This is a researched opportunity, not a guarantee of commercial success. The evidence level and sources show how much is known; the risks and questions to test show what is not.

Related product opportunities

Chosen for a shared category, customer or problem.

  • Small business

    Deal Floor — Walk-Away Price Calculator for Quote-Based Small Businesses

    Owners of small service and custom-retail businesses price each job individually, with no reliable model of what a sale actually nets.

  • Small business · Illustrative example

    Local Access Check

    Many independent shops, cafés and venues want to improve accessibility but do not know which barriers matter most.

  • Small business · Illustrative example

    Quote Chaser

    Freelancers and small service businesses send quotations and then rely on memory, spreadsheets or inbox searches to follow them up.

  • Small business

    Trade Reality Dossiers

    People buying or starting a small business in a trade they have never worked in cannot find trustworthy, practical guidance on how that trade actually operates: which brokers, suppliers and methods are credible, what precautions experienced operators take, and what is realistic at one-shop scale.