What QuickBooks Online does with inventory

If you buy finished product and resell it, QuickBooks Online handles inventory well. Inventory features are on the Plus and Advanced plans. On Simple Start or Essentials you need Intuit's inventory add-on or an upgrade.

Here's what it does:

• Item types. Inventory items track quantity. Non-inventory items record what you paid or charged and track no quantity. Services track neither.

• Buying. A purchase of an inventory item adds to the Inventory Asset account on the balance sheet.

• Selling. An invoice moves that item's cost out of Inventory Asset and into cost of goods sold.

• Cost method. QuickBooks Online uses FIFO or moving average, defaults to FIFO, and Intuit warns the choice "can't be changed later."

• Counts. A quantity adjustment fixes on-hand and posts the difference to an Inventory Shrinkage account under cost of goods sold.

• Bundles, not assemblies. A bundle groups several items on one sale, like a gift box. It has no quantity of its own.

If you resell someone else's snacks, you can run on that for years. It stops fitting the day you make something.

Where QuickBooks inventory tracking stops for food brands

Here's why. When you make product, your ingredients and packaging turn into something new, and QuickBooks Online has no step that records that change.

Checked October 2026 on Intuit's help pages.

Intuit documents lot and serial numbers for QuickBooks Desktop Enterprise, not QuickBooks Online.

Assemblies, bills of materials, and manufacturing orders exist in Intuit Enterprise Suite, the tier above Advanced. Its manufacturing help doesn't cover lots.

It depends on how you make product

• Turnkey co-packer. They buy the ingredients and invoice you for finished cases. You're buying finished goods, so QuickBooks sees most of it.

• Co-packer using your materials. QuickBooks sees what you bought and what you sold. The run in between is invisible.

• Making it yourself. Same gap. And anything half made that sits overnight never shows up anywhere.

Turning raw materials into finished goods

If your accountant works with food brands, they'll probably ask you a version of this. If $50,000 of raw materials becomes finished goods this month, does anything move on the balance sheet?

In QuickBooks Online alone, no. Inventory Asset holds whatever purchases put there. It stays put until a sale of that same item, or a count adjustment, moves it.

Should ingredients be inventory items?

Not if another system owns quantity. Set ingredients and packaging up as non-inventory items. That way QuickBooks records the spend and stops counting.

If you leave them as inventory items, they pile onto the balance sheet when you buy them. Selling granola never draws down the oats, so the only thing that moves them is a count adjustment.

Split the work between an inventory system and QuickBooks

Give each system one job. The inventory system owns quantities, batches, lots, and the cost of each batch. QuickBooks owns the ledger.

Pick one owner for quantity

Two systems counting the same jar will disagree by Friday. So if the inventory system owns quantity, your products in QuickBooks become non-inventory items.

Do the switch after you've closed and reconciled a month, not halfway through one. Zero the old QuickBooks quantities in one dated adjustment, so your accountant can see exactly where the handover happened.

Keep invoices and bills line by line

Invoices and bills should reach QuickBooks as documents, with their lines, not as summary journal entries. The reason is your bookkeeper reconciles payments against them every week.

A lot of bookkeepers want their QuickBooks file left alone, and that's fair. With this split, all they see is two document types and one monthly entry.

Don't expense everything instead

The shortcut is to post every ingredient bill straight to an expense and skip inventory entirely. It's simple, and it holds up until you have a big run.

On cash books, a $15,000 production run paid in October cuts October's gross profit by $15,000, even if half of it ships in November. So your margins swing month to month for reasons unrelated to the product.

Accrual books with a monthly inventory true-up fix that, with the month-end entry below.

How to close the month across two systems

To close across two systems, you use the periodic method. During the month, inventory purchases collect in one account. At month-end, one entry moves the right amount to cost of goods sold and resets Inventory Asset to what you have.

1. Post inventory purchases to a Purchases account. Ingredients, packaging, co-packer fees, and freight in all go there, with sub-accounts if you like. If bills post straight to COGS, mid-month statements show what you bought, not what you sold.

2. Count on the last day. Count your own shelf. Then get a written count from the co-packer and the 3PL as of the same date.

3. Value the count at cost. Finished goods carry what the batch cost you: ingredients, packaging, and the co-packer's fee. Not the wholesale price. If you need the method, see how to calculate cost per unit.

4. Work out COGS. Cost of goods sold = beginning inventory + purchases - ending inventory.

5. Post one journal entry. Debit COGS, credit Purchases back to zero, and debit or credit Inventory Asset by whatever brings it to the ending value.

Worked example, a granola brand's October close

Say you make granola, and your co-packer runs your oats, honey, and bags. The numbers are illustrative.

The ending number covers ingredients on your shelf, ingredients and finished cases at the co-packer, and cases at the 3PL.

The COGS journal entry, dated Oct 31

Purchases goes back to zero. Inventory Asset drops from $22,000 to $19,500, which matches your count. If inventory had grown instead, Inventory Asset would be a debit and COGS would be smaller.

Splitting shrinkage out of COGS

A lot of brands stop there and book the whole difference to COGS. That works, but every spilled batch and miscount then hides inside your margin.

If your inventory system knows what the units you sold cost, use that. Say it reports $16,750. Then $20,250 should be left ($22,000 + $15,000 - $16,750), and the count says $19,500.

That $750 gap is spoilage, trim, unlogged samples, and miscounts. Give it its own line:

It's the same $17,500 in total. If the shrinkage line climbs three months running, look at production before you look at the books.

What to agree on with your accountant

Sit down with your accountant before the first close, not during it, and agree on these:

• How you make product. In house, a co-packer with your materials, or turnkey. It decides what counts as inventory.

• Who owns quantity. If it isn't QuickBooks, your products should be non-inventory items there.

• Where purchases post. One Purchases account, with sub-accounts for ingredients, packaging, co-packer fees, and freight in.

• The count date. The last day of the month, and who sends the ending inventory value by when.

• Accrual or cash. On cash, one big run wrecks that month's margin.

• The shrinkage line. Whether they want it split out, and at what size it gets a second look.

Common QuickBooks inventory mistakes for food brands

• Forgetting stock at the co-packer. It's yours until it ships. Leave it out of ending inventory and COGS comes out too high. Tracking it is its own job, covered in using a co-packer for the first time.

• Counting a batch twice. Ingredients already used in a run are gone. Count the finished cases, not the finished cases plus the oats that went into them.

• Valuing finished goods at the price list. Ending inventory carries cost. Valuing at wholesale price inflates the asset and shrinks COGS.

• Fixing a vendor credit on the bill only. Say a supplier credits you $12 a bag after an overcharge. A negative bill line balances the money, but the item keeps the old cost. So correct it where you received it.

• Ingredient bills in the wrong account. Bills that land in Supplies or Office never reach the formula. Map them to Purchases.

• Switching owners mid-month. For a few weeks both systems count the same stock, and neither number is right. Close the month first, then switch.

How Peasy handles QuickBooks

Peasy keeps the side QuickBooks can't see. That means what you bought, what each batch used, which lots went where, and what's sitting at the co-packer. QuickBooks keeps the books.

• QuickBooks Online on any plan. All QuickBooks Online plan tiers work, with one QuickBooks company per Peasy account. QuickBooks Desktop isn't supported.

• Documents cross, line by line. Customers and vendors sync both ways. Invoices, bills, and their payments sync in the direction you choose.

• Your products stay tidy. Peasy is the system of record for items and creates one QuickBooks item per product family, not one per pack size.

• A guided switch-over. If QuickBooks already tracks quantity on a product, Review migration replaces it with a non-inventory item. It zeroes the old quantity as a shrinkage adjustment and gives your accountant a summary with a starting journal-entry template.

• The month-end COGS number. The Month-end COGS report downloads what you sold and what it cost, by invoice date. A co-packer batch costs your ingredients plus the maker's charge. The Posting Note column flags estimates.

• The ending count. The Inventory as of a date… report gives you every location on the last day of the month, co-packer included.

Peasy doesn't post COGS or inventory value to QuickBooks. Your accountant books the month-end entry from the file. The QuickBooks sync guide has the setup.

Peasy is free, with no cap on items, users, or orders.