Book a call

Inventory accounting for inventory businesses: how the numbers should move from purchase order to margin

Your stock count looks right, your bank balance looks right, and your gross margin still moves in ways nobody can explain. This post walks through how inventory accounting works, where it drifts once Cin7 and QuickBooks Online or Xero are involved, and what to check this week.

Fiskal6 min readUpdated
On this page
  1. What is inventory accounting?
  2. Which inventory costing method should you use?
  3. Where does inventory accounting drift in a Cin7 setup?
  4. How do timing differences between Cin7 and QuickBooks Online show up?
  5. How do you keep inventory accounting accurate week to week?
  6. When should you patch, reconfigure, or rebuild?
  7. Frequently asked questions

TL;DR

  • Inventory accounting records stock as an asset when you buy it and moves its cost to cost of goods sold (COGS) only when it sells, so every upstream cost error lands in gross margin.
  • Your costing method is a long-term decision: QuickBooks Online offers FIFO or moving average cost and the choice can't be changed later, Xero tracked inventory uses weighted average cost, and Cin7 Core costs from actual purchase cost using FIFO or FEFO.
  • Landed cost sitting in expenses instead of inventory is the most common reason margins look better than the bank account.
  • A lock date in QuickBooks Online or Xero does not protect a closed month in Cin7 Core, which has its own lock date that is off by default.
  • A weekly check of receipts, landed costs, lock dates, and the inventory valuation report keeps the ledger and the warehouse telling the same story.

You close the month and the numbers look reasonable. Then COGS shifts after the books are locked, your stock count and balance sheet disagree, and the bookkeeper plugs the gap with a manual journal.

This post covers what inventory accounting is, how the main costing methods behave, where a Cin7 setup connected to QuickBooks Online (QBO) or Xero drifts, and a weekly routine that stops the drift coming back. Fiskal's inventory accounting service ties each step of purchasing, receiving, landing, and shipping to the ledger.

What is inventory accounting?

Inventory accounting is the process of tracking, valuing, and managing inventory from purchase to sale, so you know the true cost and value of the goods you own. QuickBooks debits the Inventory Asset account when you buy stock, and COGS is debited only when you sell inventory items.

Get the Inventory Asset rule wrong and every downstream margin is wrong too. If a cost never reaches the Inventory Asset account, it never reaches COGS at the right time, and gross margin is wrong from the first sale. A margin that looks off is rarely a pricing issue.

Which inventory costing method should you use?

Choose the method your platform and your accounting system can both support, then apply it consistently. The methods differ in which purchase cost leaves the balance sheet first when a unit sells.

FIFO assumes your oldest inventory sells first, so older costs go into COGS. LIFO assumes your newest inventory sells first, so the latest costs hit COGS. When prices rise, FIFO shows higher profit and higher taxes, while LIFO shows lower profit and lower taxes. In the US, electing LIFO means filing IRS Form 970 and using LIFO in your financial reports too, which is one reason most Cin7 businesses stay on FIFO or an average method.

SystemCosting method availableWhat to check
QuickBooks OnlineFIFO or Moving Average Cost, and the choice can't be changed laterIf you create an inventory item before choosing, QBO defaults to FIFO
XeroTracked inventory for up to 4000 items using average cost valuationFits invoice-led businesses with simpler stock flows
Cin7 Core, the inventory platform formerly called DEAR SystemsFIFO or FEFO (first expired, first out), costed from the actual purchase cost of the picked itemGoes by receipt date for FIFO and by expiry date for FEFO

For a $1m to $100m inventory business, let Cin7 Core own the cost. When Cin7 Core drives inventory and COGS, the accounting system should receive journals, not recalculate cost on its own.

Where does inventory accounting drift in a Cin7 setup?

It drifts at the points where a physical event and a financial event happen on different dates. Cin7 Core logs the warehouse movement against the date stock was picked, shipped, or received, while the accounting system logs its own transaction against an invoice or bill date. That mismatch repeats every close cycle.

Three patterns show up again and again when we trace a difference back to its source.

Landed cost that never reaches inventory

Cin7 calculates landed cost from what is entered and nothing more, so freight coded to a general expense account never reaches unit cost. The symptom is a healthy gross margin and a bank balance that disagrees. The root cause is freight, duties, or brokerage paid outside the purchasing workflow. Fiskal's fix is to add each freight, duty, and brokerage invoice as an additional cost line on the purchase order the week it arrives, so the cost lands in unit cost before the stock sells. If your margins already look off, landed cost in Cin7 and why your margins don't add up walks through the diagnosis, and configuring Cin7 to track landed costs covers the setup.

Quantity that matches while value does not

A stock take reconciles quantity. It does not reconcile value. If adjustments are made without assigning cost, quantity may be correct while inventory value stays unchanged. A second stock take rarely closes the gap between Cin7 and the balance sheet for that reason. The full breakdown is in what to do when inventory doesn't match your books in Cin7.

A closed month that keeps changing

Locking the month in Xero or QBO does not protect it in Cin7 Core, which needs its own lock date under General Settings and Financial Settings. That lock date is disabled by default. A backdated purchase invoice or a late Shopify return can then recalculate FIFO cost layers and move COGS in a period you already reported. See why your closed month in Cin7 keeps changing for the full mechanics.

SymptomLikely root causeFix
Margin looks high, cash looks lowFreight or duties coded to expensesAllocate additional costs on the purchase order
Stock count right, balance sheet wrongAdjustments made without costReview adjustments for value, not just quantity
COGS changes after closeNo Cin7 lock date, backdated transactionsSet and advance the Cin7 lock date each period
Inventory on hand lags receiptsPartially received purchase orders sitting in accrualsReview partial receipts before close

How do timing differences between Cin7 and QuickBooks Online show up?

They show up as small, predictable gaps that grow when nobody owns them. Revenue is recognised when you invoice, COGS hits when stock is picked, packed, or shipped, and partially received purchase orders sit in goods received not invoiced until complete. A timing difference is normal. An unmanaged one is a reconciliation problem.

The reconciliation step is where bookkeeping meets system knowledge. Matching two totals is the easy part. The specialist work is tracing a $14,000 gap to a Beginning Balance that shifted when a backdated bill recalculated the FIFO layers, then correcting it at the source rather than in the ledger. bookkeeping for inventory businesses is built to close that gap. For a step-by-step walkthrough, see the Cin7 Core and QuickBooks Online reconciliation guide.

How do you keep inventory accounting accurate week to week?

Run a short routine every week and assign an owner to each step. Governance stops the problem returning, and it comes down to unglamorous tasks with a name against them, such as who advances the Cin7 lock date each close and who signs off a backdated transaction.

  1. Match every receipt to its purchase order line by line. Partial deliveries are where stock on the water gets counted as stock on the shelf.
  2. Attach freight, duties, and brokerage to the purchase order the week the invoice arrives. Late landed cost creates a second COGS journal dated when the cost was authorised.
  3. Check the Cin7 lock date and the accounting lock date together. Advance both at every close, and name one person who does it.
  4. Review stock adjustments for cost, not only quantity. An adjustment without a cost leaves value unchanged.
  5. Compare the inventory valuation report to the balance sheet. Do it weekly, before the gap has a month to grow.
  6. Write a retroactive change policy. Decide who can backdate a transaction, and what approval it needs, so a late return does not rewrite a closed period.
  7. Ban recurring manual journals to fix COGS. If the same journal appears two months running, trace the cause instead.

To see which of these steps is weakest in your own setup, the Fiskal Score measures People, Systems, and Finance and points at the exact group that needs work. If your team has set the system up but is not using it the way it was designed, Cin7 onboarding support covers system adoption alongside configuration.

When should you patch, reconfigure, or rebuild?

Patch when one setting is wrong, reconfigure when a workflow does not match the system, and rebuild when the cost flow itself was never designed. The test is how often the same difference returns.

SituationApproach
One account mapped wrongly, nothing else driftingPatch the mapping and monitor for one close
Landed cost, lock dates, and receipts all handled inconsistentlyReconfigure the purchasing and close workflow
Costing method, chart of accounts, and integration all disagreeRebuild, then govern

A manual journal clears the variance on the report while the cause keeps feeding it, and the same gap returns at the next close.

Frequently asked questions

What is inventory accounting?

Inventory accounting records stock as an asset when you buy it and moves its cost to COGS when it sells. It covers valuation, costing method, landed cost, and reconciliation between your inventory platform and your ledger.

Which inventory costing method is best for an ecommerce or wholesale business?

FIFO suits most inventory businesses because it follows how stock physically moves and it works in QuickBooks Online and Cin7 Core. Average cost methods smooth supplier price swings. Whichever you choose, apply it consistently, because switching is a tax and reporting event.

Why does my Cin7 inventory not match QuickBooks Online or Xero?

The two systems record the same event on different dates, such as shipment versus invoice, or receipt versus bill. Landed cost in expenses, partially received purchase orders, and backdated transactions widen the gap. The difference needs to be traced back to the source rather than cleared with a journal.

Does locking the month in Xero or QBO protect Cin7 data?

No. Cin7 Core has its own lock date, which is disabled by default and has to be advanced each period. Without it, a backdated transaction can change COGS in a month you already closed.

How often should inventory be reconciled to the books?

Weekly for the valuation report against the balance sheet, and fully at each month-end close. A short weekly check catches a landed cost or receipt error before it compounds across periods.

If the same difference keeps returning, Fiskal traces the source through its controlling and inventory accounting work, then builds the governance that holds the fix.

The Fiskal Score //

Want this sorted in your business?

We start with the Fiskal Score, a 100 point read on your people, process and technology.

Keep reading

Cin7 Core vs Cin7 Omni: which one fits your business

Cin7 Core is the self-serve platform with published plans, and Cin7 Omni is the customisable platform quoted by demo. This post shows how to pick between them by tracing one order through to QBO or Xero.

Fiskal6 min read