How to find money-losing SKUs on Amazon from your settlement
A store can post healthy total revenue and still be quietly bleeding money on individual products. Revenue only tells you what came in; it says nothing about what each SKU cost you in fees and inventory. Once you subtract every Amazon deduction and your own cost of goods, some SKUs turn negative — and they are almost never the ones you would guess. This page is a method, not a rate card, for finding those losers in the one document that already lists what Amazon actually charged you: your settlement report. To run it on your own numbers, drop your report into the free SettleClear tool.
Why revenue hides losers
The problem with judging a SKU by its sales is that the deductions arrive scattered across the settlement — a referral fee here, a fulfillment fee there, a storage line weeks later, a refund and its admin fee in a different period. No single column shows you the product's real bottom line. True net profit for a SKU is the full stack:
True net profit per SKU = product charges − referral (Commission) − FBA fulfillment − storage − promotions − refunds + reimbursements − your per-unit COGS.
Add up only the first item and a SKU looks great. Add up all of them and a product selling well can land below zero. That gap between revenue and true net profit is where the losers hide, and it is why a healthy-looking settlement can still contain products you would be better off dropping.
The hidden killers that flip a SKU negative
A handful of costs are responsible for most negative SKUs. They tend to be underweighted or missed entirely in hand-built spreadsheets. Exact rates change and differ by product, so each of these has a dedicated page — the point here is to know what to look for.
| Hidden killer | Why it flips a SKU | Where to check rates |
|---|---|---|
| Q4 storage and aged inventory | Storage roughly triples in Q4, and an aged-inventory surcharge starts at day 181 and stacks on top of monthly storage. Slow SKUs held through the peak get hit hardest. | Q4 storage fees |
| Low-inventory-level fee | Thin, fast-moving SKUs kept in short supply can draw a per-unit fee that eats a small margin. | Low-inventory fee |
| Inbound placement fee | A charge for how you send stock into the network adds a per-unit cost that spreadsheets rarely allocate back to the SKU. | Inbound placement fee |
| Advertising | Ad spend is usually billed outside the settlement, so a SKU that looks fine in the settlement can still be losing money once its ad cost is added. | — |
| Returns and refund admin fees | Refunds reverse the sale and can carry an admin fee, so a high-return SKU costs more than its gross sales suggest. | Fee glossary |
| Fee overcharges / wrong size tier | A product measured or classified into the wrong size tier is overbilled on fulfillment on every single unit. | Fee overcharges |
The advertising line deserves emphasis: because it typically sits outside the settlement file, a SKU can pass a settlement-only audit and still be unprofitable. Fold your ad spend per SKU in before you call a product a winner.
The method, step by step
The settlement report already contains what Amazon charged. The work is turning it from a flat transaction list into a per-SKU profit ranking, then adding the one number Amazon does not know — your cost of goods.
- Export the Flat File V2 settlement. In Seller Central, download the settlement report in the Flat File V2 format. This is the tab-delimited version SettleClear parses.
- Run it through SettleClear to get net profit per SKU. The tool groups every transaction by SKU and nets out each fee category, so you get net proceeds per product after referral, fulfillment, storage, promotions, refunds, and reimbursements.
- Add per-unit COGS. Net proceeds are still not profit until you subtract what each unit cost you to source and ship in. Add your per-unit COGS to convert net proceeds into true net profit.
- Sort ascending and read the negative rows. Sort by true net profit from lowest up. The tool flags negative-margin SKUs and any unclassified fee lines, so the losers surface at the top of the list rather than being averaged away by your winners.
- For each loser, find the dominant fee and act. Open the worst rows and see which line dominates the loss, then match the fix to the cause: reprice if the margin is simply too thin, cut ad spend if advertising is the drain, switch to FBM if fulfillment is the killer, liquidate aged stock if storage and aged-inventory surcharges are stacking, or fix a wrong size tier if you are being overbilled on fulfillment.
What SettleClear does with the file
SettleClear reads your Flat File V2 settlement entirely in your browser. Nothing is uploaded — the data never leaves your machine. It nets every fee to net proceeds per SKU, flags negative-margin SKUs and fee lines it cannot classify, and exports a per-SKU CSV you can drop your COGS into. It is free.
- Per-SKU net proceeds after every fee category in the settlement.
- Negative-margin SKUs and unclassified fee lines flagged for review.
- A per-SKU CSV export for adding COGS and ad spend offline.
Turning a loser back into a winner
Finding the loser is only half the job; the fix depends on which fee dominates. If storage and the aged-inventory surcharge are the drain, aging stock is the target — see Q4 storage fees for how those surcharges stack past day 181. If fulfillment is eating the margin, weigh how each FBA fee is calculated and whether the SKU belongs on FBM. If the fulfillment number looks too high for the product's size, you may be in the wrong size tier — check fee overcharges. Thin fast-movers may be paying the low-inventory-level fee, and every inbound shipment may carry an inbound placement fee worth allocating back to the SKU. Rates change and sources differ, so confirm current figures in Seller Central before you model a fix.
Related: every FBA fee type and how it's calculated · catch fee overcharges · fee glossary · the full settlement guide.