The day you add a second sales channel, your inventory stops being a number and becomes an argument between systems. Here is how to settle it.
Most sellers think their inventory problem is a counting problem. It is not. It is a reconciliation problem. A unit sitting in an Amazon fulfillment center, a unit in a third-party warehouse in Kentucky, and a unit on a shelf in your own garage are all the same SKU on your balance sheet, but four different systems each insist they own the truth about how many you have and what each one cost. When those four numbers disagree, and they always do, your cost of goods sold is wrong, your margin is fiction, and the tax return built on top of it is exposed.
This is the defining accounting headache of multi-channel ecommerce, and it gets worse with every channel you add. A single-channel Amazon seller has one inventory pool to reconcile. A seller running Amazon FBA, Shopify fulfilled through a 3PL, and Walmart shipped from a home warehouse has at least five places a unit can physically live, each tracked by a different system with a different definition of "available."
When you sell on one platform, the platform's seller dashboard is a workable proxy for reality. Amazon tells you what is in FBA, you trust it, you move on. The fiction holds because there is only one source.
Add a second channel and the fiction collapses. Now a unit can be in FBA, in transit to FBA, at a 3PL allocated to Shopify orders, at the same 3PL allocated to Walmart, or in your own storage. The same physical SKU is scattered, and no single platform sees the whole picture. Amazon does not know about your 3PL stock. Your 3PL does not know what Walmart sold. Your accounting system, if you are lucky, sees deposits and nothing else.
The accounting consequence is specific. Inventory is an asset on your balance sheet until it sells, at which point its cost moves to COGS on your P&L. If you cannot say with confidence how many units you hold and what each one cost, you cannot state your inventory asset, you cannot calculate COGS, and every downstream number inherits the error.
Before you can build one source of truth, you have to enumerate the locations. For a typical multi-channel seller, a SKU exists in some combination of these:
| LOCATION | OWNS THE COUNT | ACCOUNTING STATUS |
| Amazon FBA | Amazon Seller Central | Your asset, in Amazon's custody |
| In transit to FBA | Your shipment records | Your asset, in motion |
| 3PL warehouse | 3PL WMS | Your asset, in third-party custody |
| Your own warehouse | Your spreadsheet or WMS | Your asset, in your custody |
| In transit from supplier | PO and freight docs | Your asset once title passes |
Every one of those buckets holds units you own and must account for. The location does not change ownership. A unit at a 3PL is still your inventory asset, not the 3PL's. The mistake sellers make is treating "inventory" as "what Amazon shows me," which silently writes off everything sitting everywhere else.
Location is only half the problem. The other half is cost. Inventory is not just a count, it is a count multiplied by a per-unit cost. And the cost of a unit depends on which production run or purchase order it came from.
Say you bought 1,000 units at $4.10 in March and another 1,000 at $4.85 in May because your supplier raised prices. You now hold units at two different costs. When you sell 1,200 units across Amazon and Shopify in June, which cost do you assign? Under FIFO, the first 1,000 sold carry the $4.10 cost and the next 200 carry $4.85. Get this wrong and your gross margin swings by hundreds or thousands of dollars per SKU per month, in a direction you did not choose.
Now multiply that by every channel selling the same SKU from different physical locations, and you see why a spreadsheet breaks. You are not tracking one cost layer, you are tracking cost layers consumed in an order set by which channel sold first, across pools that do not talk to each other.
A real source of truth for multi-channel inventory has to do four things at once:
This is exactly the gap ConnectBooks closes with ConnectStock, its multi-location inventory tracking. ConnectStock tracks units across FBA, 3PL, home warehouse, and in transit as one pool, applies FIFO cost per unit, and feeds the cost of each sold unit into per-channel P&L inside QuickBooks Online, QuickBooks Desktop, or Xero. ConnectStock is bundled with the Platinum plan and available as an add-on on Gold and Diamond.
Aggregating to one count does not mean blurring your channels. You still need to know that Amazon is a 42% gross margin channel and Walmart is 28% after fees, because that decides where you spend ad dollars and where you raise prices. The point of one source of truth is not to flatten the channels. It is to make sure the same unit is never counted twice and never costed two different ways, so the per-channel margins you compare are built on the same foundation.
The test of any inventory system is whether it reconciles. At period close, take your inventory asset balance, divide it into units on hand by location, and confirm that the total cost equals what your books say. Then take the units you sold during the period, confirm the cost that moved to COGS matches the cost layers consumed, and confirm the deposits from each channel reconcile to recorded sales net of fees. When all three tie, your numbers are defensible. When they do not, you have found exactly where a channel, a location, or a cost layer is leaking.
It is the practice of tracking one SKU across every place it physically lives, FBA, a 3PL, your own warehouse, and in transit, as a single inventory asset, then moving the correct per-unit cost to COGS each time any channel sells a unit. The goal is one count and one costing method across all channels.
Because Amazon only sees the units in its own fulfillment centers. The moment you hold stock at a 3PL or in your own warehouse, the Amazon dashboard understates your real inventory asset. Trusting it alone silently writes off everything stored elsewhere.
FIFO assigns the oldest available cost layer to the next unit sold, regardless of which channel sells it. If Amazon sells before Shopify, Amazon consumes the older, cheaper layer first. A correct system applies one FIFO queue per SKU across all channels rather than running separate queues per platform.
Yes. Physical custody does not change ownership. Units at a 3PL are your inventory asset on your balance sheet until they sell, exactly like units in your own warehouse. The same is true for units in FBA and units in transit.
Yes, through ConnectStock, its multi-location inventory feature covering FBA, 3PL, home warehouse, and in transit. It applies FIFO cost per unit and feeds per-channel COGS into QuickBooks or Xero. ConnectStock is bundled with Platinum and available as an add-on on Gold and Diamond.
Stop reconciling five systems by hand. See how ConnectStock unifies multi-location inventory 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
