Ecommerce operations glossary

What is inventory reconciliation?

Also called Inventory tie-out, Stock reconciliation

Inventory reconciliation is the check that your stock records agree with two other versions of the truth: what is physically on the shelf, and what your general ledger says the inventory is worth. Each gap is traced to a cause, such as a miscount, an unrecorded shipment or a late bill, and then corrected.

Worked example

There are two checks, and the order matters: fix the units first, then the money.

Units against the shelf. Your records say 480 units of a product are on hand. A count finds 462. The 18 missing units cost $6.10 each, so the adjustment is 18 × $6.10 = $109.80 of shrinkage, and the records now say 462.

Value against the ledger. At month end your inventory records value all stock at $52,300. The inventory account in your accounting software says $53,150. The gap is $53,150 − $52,300 = $850.

Tracing it, you find an $850 supplier bill that was entered straight into the accounting software against the inventory account. The goods were never received in the inventory system. The fix is to record the receipt where the stock lives, so both sides move together, not to post a journal that makes the totals agree.

Where the gaps come from

  • One-sided entries. A receipt, return or adjustment recorded in one system and not the other.
  • Manual journals on the inventory account. They make this month agree and leave the cause in place for next month.
  • Timing. Stock received on the 30th and billed on the 2nd can land in different months on each side.
  • Missing accounts. Stock in transit between warehouses, or held at a marketplace warehouse, often sits in its own account. Leave it out and the two sides never meet.

What it is not

A total that agrees is not proof. Two errors in opposite directions, $500 over in one account and $500 under in another, net to zero and hide both. Compare account by account, add the gaps without their signs, and treat “never compared” as a finding rather than a pass.

Questions

How do I reconcile Amazon FBA inventory with QuickBooks Online?

Compare three numbers for the same date: the units in Amazon's inventory ledger, the units your inventory system holds at FBA, and the inventory value in QuickBooks. Explain the unit differences first: shipments in transit, customer returns, removals, and units Amazon lost, damaged or reimbursed. Then check the value: units times unit cost should match the inventory account. Do it every month before you close.

Why do my inventory system and my books disagree?

Usually because something was recorded in one place and not the other: a receipt counted in stock before its bill was posted, an adjustment made only in the inventory system, or COGS posted at a flat percentage instead of from real unit costs. SKU.io compares its own inventory value with the balances of the inventory accounts you earmark in QuickBooks Online or Xero, day by day, so a gap shows up on the day it opens.

More terms: Accounting

Updated · All terms

Ready to see SKU.io in action?

Bring your real numbers and the messy questions — we'll walk the system against an operation like yours, not a slide deck.

Book a Demo

Founder-led demo · 2-day onboarding · no onboarding fees