Your QuickBooks Online report says 212 bags of Cinnamon Granola 12 oz on hand. The shelf says 188. Eight shipped on an order nobody invoiced, and sixteen left as tasting samples nobody adjusted out. That gap is most of what quickbooks inventory management means for a small food brand: the software does arithmetic on whatever you post.
This page covers how QuickBooks Online (not QuickBooks Desktop) tracks inventory, which plans include it, why its numbers drift, and where an accounting tool stops being the right place to hold units. Plan tiers change, so confirm them on Intuit’s own plan page.
How does QuickBooks inventory management work?
QuickBooks Online tracks stock through Inventory items on the Plus and Advanced plans. Each item holds a quantity on hand, a cost and an inventory asset account. Sales lower the quantity, bills raise it, and cost of goods sold (COGS) posts using first in, first out (FIFO) costing.
Setup is one record per SKU (stock keeping unit): a name, an initial quantity with an as-of date, a reorder point, and the income, inventory asset and COGS accounts. After that, quantity moves only when a transaction touches the item. An invoice or sales receipt takes units out. A bill with item lines puts units in, which is the step a purchase order feeds. A quantity adjustment books the gap after a count.
The Inventory Valuation Summary report then shows units and value per item, and an item at or below its reorder point shows as low on stock in the product list. That is a tidy loop for one site and one sales channel.
Why does QuickBooks quantity on hand drift from the shelf?
Because quantity changes only when someone posts a transaction. A sale that ships before the invoice is entered, a free sample, a dropped case, or a receipt booked without item lines each leaves the number high or low until a count corrects it. The software is not wrong. It is counting what it was told.
Picture 40 SKUs and a Saturday farmers’ market. You sell 60 units from the van and enter them Tuesday. For three days QuickBooks overstates every one of those SKUs, and anything you sell online in that window sells against units that are gone.
The fix is a rhythm, not a feature. Post sales the day they ship. Receive purchases on a bill with item lines, never a bare expense. Print the Physical Inventory Worksheet, count your top sellers weekly and the rest monthly, then enter one quantity adjustment dated to the count day so the books show when the gap opened.
What can QuickBooks inventory not do?
It keeps one quantity per item, with no stock split across sites. It carries no expiry date on a receipt, offers no count workflow beyond a worksheet and adjustments, and holds one pool of units for every sales channel. These are design limits of an accounting tool, not setup mistakes.
| What you need | What QuickBooks Online does | Common workaround |
|---|---|---|
| Stock in two places | One quantity per item; locations tag reports, not units | One item per site, kept in step by hand |
| Expiry dates | None on a receipt | A date column in your count sheet |
| Count workflow | A worksheet report and quantity adjustments | Weekly counts on top sellers, monthly on the rest |
| Reorder timing | A reorder point you enter yourself | Work it out from lead time first |
| Stock by channel | One pool for every channel | A spreadsheet allocation per channel |
Two of these bite food brands first: sites and dates. A cold-brew brand with 300 cases at a co-packer (a contract manufacturer) and 80 in its own cooler has one number in QuickBooks: 380. That is accurate and no help deciding what ships tonight.
When do you outgrow QuickBooks for inventory?
When stock sits in more than one place, when you sell on more than one channel, or when a count disagrees with the books by more than a few percent two months running. Keep QuickBooks for the books. It values inventory well. It was never built to run a warehouse.
A workable line: let QuickBooks hold value and cost, hold units somewhere built for them, and post the monthly total as a journal entry or a comma-separated (CSV) file import. Many brands reach that point on a spreadsheet first, and that is fine. Whatever you choose, ask on day one how quantities and costs get back to your bookkeeper. The CPG operator’s playbook covers the wider stack, and the reorder point formula gives the reorder point QuickBooks asks you to type in.
What should you do next?
Fix the posting habits first, then decide whether the books should keep holding units.
Set up
- Confirm you are on Plus or Advanced before you rely on inventory tracking.
- Enter an initial quantity with an as-of date for every SKU.
- Enter a reorder point on each item, worked out from lead time.
Keep it honest
- Post shipped orders the day they ship.
- Receive stock on a bill with item lines, never a bare expense.
- Count top sellers weekly, then post one quantity adjustment dated to the count day.
Decide
- Add up the units held outside your main site.
- Note any two months where count and books differ by more than a few percent.
- If either is true, hold units outside QuickBooks and post a monthly total.
Frequently asked questions
Does QuickBooks Online track inventory?
Yes, on the Plus and Advanced plans. Each Inventory item carries a quantity on hand, a cost and an asset account. The lower tiers do not include inventory tracking, and tiers change, so confirm on Intuit's current plan page.
Can QuickBooks track inventory in multiple locations?
Not as separate stock. QuickBooks Online keeps one quantity per item. Location tracking tags transactions for reporting but does not split units by site, so most brands keep one item per site or hold units elsewhere.
Does QuickBooks track expiry dates?
No. QuickBooks Online records a quantity and a cost per item, with no expiry or best-by date on a receipt. Brands with dated products keep dates in a count sheet or another tool.