The inventory value on your balance sheet should equal the units you actually own, costed at what you paid. For an FBA seller spread across warehouses and transit, those two numbers drift apart fast.
Inventory reconciliation means proving that the dollar value of inventory on your balance sheet matches the physical units you own, valued correctly. For a single-location seller that is a count and a multiply. For an Amazon FBA seller it is a moving target, because your units are scattered: some at Amazon fulfillment centers, some in transit to Amazon, some at a 3PL, some in your own warehouse, and some lost or damaged inside Amazon's network and not yet reimbursed.
Each of those locations holds value that belongs on your books. Miss a location and your inventory asset is understated, which silently overstates COGS and understates profit. The search term "inventory management for amazon sellers" gets around 110 a month, but the underlying problem touches every seller above a couple of SKUs.
Before you reconcile, account for where your units actually are.
| LOCATION | WHAT IT HOLDS | COMMON RECONCILIATION GAP |
| Amazon FBA (fulfillable) | Sellable units at fulfillment centers | Usually tracked, but counts shift with returns |
| In transit to Amazon | Units shipped but not yet received | Often missing from books entirely |
| 3PL or home warehouse | Stock held outside Amazon | Tracked separately, easy to forget |
| Lost / damaged / disposed | Units Amazon mishandled | Sitting in limbo until reimbursed |
The two that wreck reconciliations are in-transit stock and lost or damaged units. In-transit inventory is yours the moment it ships, so it belongs on your balance sheet even though Amazon has not received it. Lost and damaged units have left the sellable count but may not yet be written off or reimbursed, leaving a gap between Amazon's report and your books.
Run this at month-end as part of your close.
When Amazon loses or damages your inventory, write the units off as a loss once you confirm they are gone. When Amazon reimburses you, record the reimbursement as a recovery against that loss, not as sales. Keeping the write-off and the reimbursement connected is what stops lost inventory from quietly corrupting both your COGS and your margin.
Reconciling four locations by hand, applying FIFO to every batch, and tying it all to COGS each month is the kind of task that gets skipped until an audit or a tax deadline forces it. ConnectBooks applies FIFO COGS per unit as it syncs marketplace data into QuickBooks or Xero, and ConnectStock tracks inventory across multiple locations, FBA, 3PL, home warehouse, and in transit, so the physical picture and the book value stay aligned. ConnectStock is bundled with the Platinum plan from $349/mo and available as an add-on on Gold and Diamond. See /integrations/amazon-accounting.
| NEXT STEPKeep your inventory asset tied to the units you actually own. ConnectStock tracks FBA, 3PL, and in-transit stock across locations. Plans start at $149/mo. See /pricing. |
It means proving that the inventory value on your balance sheet equals the physical units you own, valued at what you paid for them. For an FBA seller that requires counting units across fulfillment centers, in transit, at a 3PL, and in your own warehouse, then valuing them on a consistent costing method like FIFO.
Yes. Units you have shipped to Amazon are yours from the moment they leave, so they belong on your balance sheet as inventory even though Amazon has not received or logged them. Leaving in-transit stock off the books understates your inventory asset and overstates COGS.
Write off the units as a loss once you confirm they are gone from the sellable count. If Amazon later reimburses you, record the reimbursement as a recovery against that loss rather than as sales. Connecting the write-off and the reimbursement keeps your COGS and margin accurate.
Monthly, as part of your close. Reconciling only at year-end lets variances pile up until they are hard to trace and leaves your margins unreliable in the meantime. A monthly reconciliation catches in-transit gaps, lost units, and costing errors while they are still easy to fix.
Usually because of in-transit units not booked, lost or damaged units not written off, returns not added back into the count, or a costing error in how units are valued. Reconciling the four inventory locations against your balance sheet each month surfaces exactly which of these is causing the gap.
Clean, accurate books make this manageable. Start a free trial of ConnectBooks to get settlement-level accuracy and real margin visibility for your ecommerce business. No credit card required.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
