Why e-commerce margin is wrong when COGS is a percentage estimate
Cost of goods sold booked as a percentage estimate produces a margin figure that cannot be used to make ad spend decisions, because the estimate hides both the freight and duty that belong in landed cost and the difference between ledger stock and what is physically in the warehouse. This is an illustrative example of how Salt approaches e-commerce inventory accounting, using a US brand across three warehouses as the profile.
Scenario — an illustrative example of how Salt approaches this problem. Not a description of a specific client engagement.
The business shape it describes: US e-commerce brand, 3 warehouses, around 5,600 transactions a month.
- Scenario covers
- Bookkeeping, inventory reconciliation and per-SKU margin reporting
- Jurisdiction
- United States
- Sector
- E-commerce
- Take a US e-commerce brand holding inventory in three locations, with around 5,600 transactions a month and no reconciliation of physical stock to the ledger.
- Cost of goods sold is booked as a percentage of revenue, and paid media decisions are made against the margin that estimate produces.
- Ledger inventory diverging from physical counts across all three locations, with no cycle count process to catch the drift as it happens.
- Landed cost excluding inbound freight, duty and customs brokerage, which understates cost of goods sold on every unit.
- Returns and damaged stock not written down, so inventory on the balance sheet includes units that will never sell at full price.
- No per-SKU margin at all, so a product line scaled on paid media could be unprofitable at real cost without anything in the reporting revealing it.
- Reconcile each warehouse to the ledger and establish a recurring cycle count, so the difference is found monthly rather than annually.
- Move to landed cost, capitalising inbound freight, duty and brokerage into inventory rather than expensing them separately.
- Restate the affected periods so the margin trend is comparable rather than stepping at the date of the change.
- Write down returns and damaged stock on a documented policy rather than leaving them at full cost.
- Rebuild margin reporting at SKU level on landed cost, and put it in front of whoever sets the paid media budget.
- Stock held across three locations and a cost of goods sold that omits freight and duty are the two things that make e-commerce margin unreliable, and neither is fixed by better reporting on the same numbers.
- Reconciling physical counts to the ledger and restating the affected periods is slow, unglamorous work that has to finish before a single per-SKU figure can be trusted.
- The brand would be able to see margin per SKU on landed cost, which is the number a paid media decision actually requires.
- Inventory on the balance sheet would reflect what is in the warehouse and what it is worth, rather than a rolling estimate.
- The gap between ledger and physical stock would be found by a cycle count each month instead of at year end.
What we'd flag
Restated margin is usually worse across most of the catalogue, because landed cost is always higher than an estimate that omits freight and duty. The restatement changes the understanding of the cash position, not the cash position itself.
Why e-commerce margin is wrong when COGS is a percentage estimate
Recognise this shape in your own books?
Tell us where you trade and what shape the books are in. You get scope, price and a start date in writing within one business day — no obligation.