Inventory reconciliation at close is the test that decides whether your COGS, your margins, and your tax return are built on a real number or a guess. Here is the checklist to pass it.
Inventory is the line that quietly breaks more ecommerce books than any other. It sits on the balance sheet as an asset, it feeds COGS on the P&L, and for multi-channel sellers it scatters across locations that no single system fully sees. If inventory does not reconcile at close, nothing built on top of it can be trusted: not margin, not profit, not the tax return. This checklist walks the reconciliation in order, from raw counts to a clean tie-out.
Work it in sequence. Each step depends on the one before, and skipping ahead is how errors hide.
Reconciliation starts with a complete count. Pull on-hand units for the SKU from every place it lives:
The total across all four is your true on-hand quantity. The single most common reconciliation failure is treating one source, usually the Amazon dashboard, as the whole count and silently dropping everything stored or moving elsewhere. Everything you own counts, regardless of custody.
A count is half a number. Each on-hand unit carries the cost of the purchase order or production run it came from. Under FIFO, your remaining inventory should be valued at your most recent cost layers, because the older layers were relieved first as units sold. Confirm that the on-hand units map to the correct cost layers and that your valuation method is applied consistently with prior periods.
This is where a layered system earns its keep. If you hold units bought at $4.10 and units bought at $4.85, the reconciliation has to know which layer the on-hand units belong to, or the inventory asset value will be wrong even if the count is right.
Multiply on-hand units by their cost layers to get total inventory value. Compare that to the inventory asset balance on your balance sheet. They should match.
| RECONCILIATION POINT | SOURCE A | SOURCE B | PASS CONDITION |
| Units on hand | All-location count | Physical or platform counts | Match within tolerance |
| Inventory value | Units x FIFO cost | Balance sheet asset | Values tie |
| COGS for period | Cost layers relieved | P\&L COGS by channel | Reconciles per channel |
If the asset value and the books disagree, the gap is the reconciling item to investigate before you close. Common causes: a shipment received physically but not in the books, a count drift, or a cost layer entered wrong.
Now check the flow side. The cost that moved to COGS during the period should equal the cost of the units actually sold, layer by layer, per channel. Take units sold from settlement data for each channel, match them to the cost layers relieved, and confirm the total ties to the COGS posted on the P&L.
This step catches the errors that the asset check alone misses. You can have a correct ending inventory value and still have booked COGS wrong if sales relieved the wrong layers or a channel's units were not costed at all. Per-channel COGS that reconciles is what makes your per-channel margins trustworthy.
Returns that came back into sellable stock should have added units back to the count and reversed their cost out of COGS. Damaged, lost, or written-off units should have come out of inventory as a loss, not silently vanished. Confirm both:
Unrecorded shrinkage and unhandled returns are a frequent source of a count that will not tie.
For anything that did not tie cleanly, document the reconciling item: what it is, why it exists, and how you resolved it. A shipment in transit that the platform has not yet received, a timing difference between when a sale posted and when COGS relieved, a known count adjustment. Documented reconciling items are the difference between a defensible close and an unexplained one when a lender, an accountant, or the IRS asks how you got your number.
Done manually, this checklist is a multi-day scramble every period: export FBA inventory, pull the 3PL report, count your own shelves, chase open shipments, map cost layers in a spreadsheet, and hope the asset and COGS both tie. Add SKUs and channels and it stops being feasible to do accurately and on time.
ConnectBooks collapses most of it. ConnectStock, its multi-location inventory feature, keeps a live count across FBA, 3PL, home warehouse, and in transit, valued under FIFO per unit. As each channel sells, the correct cost layer is relieved and posted to per-channel COGS in QuickBooks Online, QuickBooks Desktop, or Xero, so the asset and the COGS are reconciled continuously rather than rebuilt at close. ConnectStock is bundled with Platinum and available as an add-on on Gold and Diamond. The mechanics across channels are detailed in multi-channel inventory accounting (/blog-posts/multi-channel-inventory-accounting), and the metric this reconciliation feeds is in inventory turnover ratio (/glossary/inventory-turnover-ratio).
When all six steps tie, your inventory asset is real, your COGS is real, and every margin and tax figure built on them is defensible. That is the entire purpose of the reconciliation: not to produce a number, but to produce a number you can stand behind.
Counting units across every location, attaching the correct cost to each, tying the inventory asset to the balance sheet, reconciling COGS to units sold per channel, accounting for returns and write-offs, and documenting any reconciling items. When all of it ties, the inventory-based figures on your financials are defensible.
Common causes are an incomplete count that misses 3PL or in-transit stock, a shipment received physically but not recorded, a cost layer entered wrong, unrecorded shrinkage, or returns not handled. Work the checklist in order to isolate which one.
Yes. Units in transit, including replenishments to FBA and inbound supplier stock, are your asset and count toward on-hand inventory. Leaving them out understates your inventory asset and breaks the reconciliation.
Match units sold per channel from settlement data to the cost layers relieved during the period, and confirm the total ties to COGS on the P&L. A correct ending balance can still hide a COGS error if sales relieved the wrong layers or a channel went uncosted.
ConnectStock keeps a live, FIFO-costed count across all locations and relieves the correct cost layer to per-channel COGS as sales happen, so the asset and COGS reconcile continuously instead of being rebuilt by hand at close. ConnectStock is bundled with Platinum and available as an add-on on Gold and Diamond.
Close inventory in minutes, not days, with continuously reconciled counts. See ConnectStock at /pricing.
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
