Ecommerce Inventory Accounting
Follow inventory from purchase to sale and return. Learn how to check stock value, cost of goods sold, marketplace inventory, and accounting software fit.
An online store can know exactly how many units are available and still report the wrong profit. Stock management answers how many units are where. Inventory accounting answers what the unsold stock is worth and when its cost becomes cost of goods sold (COGS). Those records need to agree, especially when sales, returns, and stock movements happen across several channels.
This guide gives store owners a way to inspect that flow. Your accountant should approve the valuation method and treatment of freight, duties, write-offs, and tax under the rules that apply to your business.
Follow one unit through the books
- Purchase: Record the supplier bill and quantity received. A deposit or payment is not, by itself, proof that every unit has arrived.
- Receipt: Confirm the SKU, quantity, location, and unit cost. Account for approved costs that belong in inventory value under your accounting policy.
- Sale: Reduce units available. Transfer the relevant unit cost from inventory into COGS when the sale is recognized under your policy.
- Return: Check whether the item came back, whether it can be sold again, and whether the sale and COGS entries need reversing or adjusting.
- Adjustment: Record damaged, lost, or counted stock differences with a reason and supporting evidence.
In a simple example, a store buys 100 units at $20 each. Before any sales, the $2,000 cost is associated with unsold stock. If 10 units sell at that unit cost, $200 moves into COGS and $1,800 remains associated with the 90 unsold units, before other approved costs or adjustments. The purchase may create a payable before cash leaves the bank; the cost reaches the profit and loss statement as units are sold.
Where ecommerce records diverge
Store quantity versus accounting value. Shopify or a marketplace may track available units, while your accounting system tracks their cost. A stock sync that sends only quantities cannot establish accurate COGS if supplier prices, freight, and returns are missing.
Several locations. Units can sit with a supplier, at your warehouse, with a 3PL, or at an Amazon fulfillment center. Moving units between locations should not automatically create a sale or a second purchase. Check each location's closing quantity and the total value reported in the books.
Returns and replacements. A refund is a money event; a returned item is a stock event. If the item is unsellable, restoring it to available inventory overstates stock. If it is resellable, failing to record its return can overstate COGS. Check the physical disposition of the item.
Changing unit costs. A new supplier price should not silently rewrite the cost assigned to all earlier sales. The valuation method and system settings determine how costs flow. Ask your accountant to confirm the approach before migrating historical stock.
Choosing inventory accounting software
Do not buy from a feature checklist alone. Run this test with your own records:
| Test | What you should be able to show |
|---|---|
| Receive ordered stock | Units and approved cost appear once, at the right location |
| Sell through two channels | Both channels reduce the correct SKU without double-counting |
| Reconcile a payout | Sales, fees, tax, and bank deposit match independently of inventory cost |
| Return one sellable and one damaged item | Refund and stock outcomes are recorded separately |
| Close the month | Stock valuation agrees with the accounting balance after explained adjustments |
If you have many SKUs, locations, bundles, or fulfillment partners, a dedicated inventory system may be appropriate. Its value still has to reconcile to the ledger; a stock dashboard and a P&L that disagree are not solved by adding another app.
A monthly inventory check
- Export quantity by SKU and location from the operational source.
- Explain receipts, sales, returns, transfers, and adjustments since the last close.
- Compare the inventory valuation report with the balance-sheet inventory account.
- Compare sold units and assigned costs with COGS on the P&L.
- Investigate negative stock, missing costs, duplicate SKUs, and unexplained write-offs.
- Save the reports and adjustments so next month's reviewer can trace the changes.
Nummbas can help you read financial results alongside connected store data when the sources are complete. It does not maintain inventory accounting entries. Accurate product and business profit still depend on reliable cost data and a reviewed set of books.