A bedding company can afford its next $240,000 container over the quarter and still spend three weeks of that quarter about $64,000 below the cash floor it keeps for payroll and surprises. In the example this post works through, it starts with $250,000 in the bank, finishes the quarter at about $158,000, and drops to about $36,000 in week 6, when the factory balance is due, against a $100,000 floor. A stock system that tracks only units would show nothing wrong.
Ecommerce inventory management is knowing what stock you own, where each unit is, what it cost and when to buy more, across your own store, marketplaces such as Amazon and eBay, and wholesale accounts. Inventory is cash in another form, so the order question is answered in the week your bank balance is lowest, not on the shelf.
Can you afford the next order?
When to reorder and how much belongs to demand forecasting and the planning tools a company already runs. The finance side asks something else: can you afford this order, and when does the cash come back?
The bedding company sells on Shopify, Amazon and to two wholesale accounts. Its sheet set costs $30 at the factory, plus about $1.25 of freight and port charges and $6.75 of duty and fees, so each set lands at $38. The next order is 8,000 sets, so $240,000 to the factory: a $72,000 deposit this week and a $168,000 balance at loading in six weeks. The container already on the water lands in week 2 with $64,000 of freight and duty, and the new one lands in week 12 with another $64,000. After payroll, ads, the 3PL and other running costs, sales add about $15,000 a week net. A wholesale buyer owes $96,000 for 1,500 sets, due in week 9.
| Week | What happens | Cash at week end |
|---|---|---|
| 1 | Deposit on the new order, $72,000 | $193,000 |
| 2 | Freight and duty on the current container, $64,000 | $144,000 |
| 6 | Balance on the new order, $168,000 | $36,000 |
| 9 | Wholesale buyer pays $96,000 | $177,000 |
| 12 | Freight and duty on the new container, $64,000 | $158,000 |
Weeks 3 to 5 climb back to $189,000, and weeks 7 and 8 reach only $51,000 and $66,000, so with a $100,000 floor the company sits under it from week 6 until the wholesale payment in week 9.
None of the answers are about units. You can ask the supplier to move the balance date, split the order into two shipments with two balances, chase the wholesale payment earlier, or bridge the gap with financing, compared in inventory and PO financing. The supplier may say no to new terms, and the buyer may pay late anyway, so it helps to know which lever is in your hands before the purchase order goes out. Waiting has a price too, set out in the cost of a stockout. What you should not do is discover week 6 in week 6. A 13-week cash flow forecast with every deposit, balance and landing cost in its own week makes the order a yes, a no or a yes with conditions, and shows the working capital growth will need.
What does it mean when the inventory count disagrees with the books?
Sooner or later, the 3PL's file plus Amazon's report will not match the units your accounting records say you own. The difference is usually three problems, each with a different effect on the P&L.
Say the bedding company's records show 9,700 sheet sets on hand. The 3PL's file shows 7,050 and Amazon's sellable count shows 2,360, a total of 9,410. The 290 missing units are worth $11,020 at cost:
- 180 units, $6,840 at cost, were shipped from the 3PL to Amazon and have not been checked in. Amazon shows them as inbound, not sellable, so a reconciliation that reads only the sellable count makes them look missing. Nothing is lost; they belong in transit.
- 60 units, $2,280, appear in Amazon's reports as lost or damaged in its fulfillment centers. They come off inventory now, at cost. If you raise a claim, Amazon's reimbursement is booked separately, once the claim is approved or payment is probable.
- 50 units, $1,900, cannot be explained. After a recount, they are shrink, written off in the month they are found. Nobody will learn where they went.
So about $6,800 of the gap is timing, and about $4,200 comes off inventory this month. Booking all $11,020 as shrink would understate gross margin. Check too for refunds Amazon issued where the item never came back, which are a common claim. A monthly comparison by location keeps differences small enough to trace, and inventory accuracy covers the counting side. The year-end count still matters, because it finds what only a physical count can.
How much cash is sitting in your inventory?
On the balance sheet, inventory is worth what it cost to get it ready to sell, not what it will sell for. That cost is landed cost: the factory price plus inbound freight, duty, broker fees and similar costs. The bedding company's sets sell for $129.
| Where the stock is | Units | At landed cost | At selling price |
|---|---|---|---|
| 3PL warehouse | 7,200 | $273,600 | $928,800 |
| Amazon FBA | 2,500 | $95,000 | $322,500 |
| On hand, total | 9,700 | $368,600 | $1,251,300 |
| On the water, factory price paid | 8,000 | $240,000 | Not yet received |
The team talks about "a million and a quarter of stock". The balance sheet shows about $369,000 on hand, the figure a lender reads. Cost is also a ceiling: stock that will sell for less than its cost, after the fees and shipping needed to sell it, is written down to that lower amount, and the write-down lands in the month it is recognized. How to spot that stock early is in dead stock.
The container on the water is the line most spreadsheets drop. The factory has been paid in full and none of those units can be sold yet. Depending on the shipping terms, that $240,000 is inventory in transit or a prepayment to the supplier. Either way the cash has left, so the cash tied up in stock is about $609,000: $368,600 on hand plus $240,000 on the water.
Turnover says how long the stock lasts, not when the order has paid back. At about $2.2 million of cost of goods a year on $400,000 of average stock, the company turns its inventory 5.5 times, about 66 days. The deposit is out much longer: paid on day 0, the container lands around day 80, and the average unit sells around day 146. Selling a unit uses up stock at cost; the cash comes back as net receipts, the price less fees, refunds and ads, on each channel's payment dates, as from factory deposit to payout works through. The full loop is worked through by channel in the cash conversion cycle for ecommerce; category figures are in inventory turnover benchmarks.
Holding stock costs money as well, covered in inventory carrying cost. One part is easy to miss across channels: Amazon charges FBA sellers monthly storage on the space their inventory occupies, plus an aged inventory charge on items stored in a fulfillment center for more than 181 days, according to Amazon's FBA page. Where slow stock sits is a cost decision.
How does multichannel inventory management show up in the books?
Multichannel inventory management usually means keeping counts in step. On the finance side, each location holds your money in a different form and returns it on a different schedule.
| Where the stock is | Who reports the count | How it shows in the books | When it turns into cash |
|---|---|---|---|
| Your own location or 3PL | You, or the 3PL's stock file | Inventory at landed cost | When it sells, on that channel's payout schedule |
| Amazon FBA | Amazon's inventory reports | Inventory at landed cost; you own it, not Amazon | When it sells and the settlement pays out, net of Amazon's fees |
| In transit between locations | The receiving location, as inbound until checked in | Inventory in transit, at the same cost | Not until it lands and sells |
| Sold to a wholesale account | The buyer, once delivered | No longer inventory: cost of goods when ownership passes (at shipment on most terms), and a receivable for the invoice | When the buyer pays, on the agreed terms |
| On the water from the supplier | The supplier and forwarder | Inventory in transit or a supplier prepayment, by terms | After it lands, is received and sells |
Moving stock from the 3PL to FBA does not change what you own, but it spends cash before anything sells. The prep, the freight to Amazon and Amazon's inbound placement fee are part of what it cost to bring those units to where they sell, so they are commonly added to those units' cost and reach cost of goods sold when the units sell. Some CPAs instead treat a move between a company's own locations as a fulfillment expense; either can be acceptable if your CPA agrees and it is applied the same way every month.
A large wholesale order moves stock out of inventory all at once, books the margin when ownership passes (on the day it ships, under most terms), and then holds the cash in a receivable for 30, 60 or 90 days. A month with a big wholesale shipment can look strong on the P&L and leave the bank lower than the month before. Amazon settlements are covered in Amazon FBA accounting.
Which methods and software do ecommerce brands use?
The methods are familiar: perpetual tracking, which updates stock as each sale, receipt and transfer happens, or periodic counts that true up cost of goods at set dates and can swing one month's margin; cycle counts on a rotation; and a costing rule, FIFO or weighted average, chosen with your CPA and compared in FIFO vs LIFO. How a perpetual setup keeps cost of goods current is in inventory accounting for ecommerce.
For ecommerce inventory management software, the useful question is whether a tool tracks units, dollars or both.
| Kind of tool | Usually tracks | Usually leaves to something else |
|---|---|---|
| The store's own stock count (Shopify, for example) | Units at the store's own locations | Amazon and wholesale stock, landed cost |
| Multichannel inventory apps | Units across channels and warehouses, so a product does not sell twice | Freight, duty and the value of stock on hand |
| 3PL portals and warehouse systems | Receipts, bins, picking and shipping in that building | Stock elsewhere, and the accounting |
| ERPs | Units, purchasing and accounting together, depending on the kind; see ecommerce ERP and NetSuite alternatives | Varies by product |
| Accounting software | The inventory balance and cost of goods, when stock is tracked in it | Units by location, unless someone keeps them up |
Most multichannel companies run two or three of these. That works when somebody owns the point where a unit count becomes a dollar figure; when nobody does, the inventory line is whatever was last trued up.
FAQ
What is the best inventory management software for ecommerce?
It depends on what is breaking. If you oversell across channels, a multichannel inventory app fits. If the problem is the warehouse floor, look at a warehouse system or a different 3PL. If units are under control but margin, inventory value and cash are not, the accounting system needs to hold inventory at landed cost.
Is inventory an asset or an expense?
Inventory is an asset on the balance sheet, valued at what it cost to buy and land, until it sells. When a unit ships to a customer, its cost moves to cost of goods sold on the income statement. Stock that is lost or damaged is written off, and stock that will sell for less than its cost after the fees and shipping needed to sell it is written down to that amount.



