Profitability
Profitability audit: the product-by-product method
A profitability audit sorts products into three groups: push, fix, discontinue.
Key takeaways
- Gather sales, fees, advertising, returns, and purchase price over twelve months.
- Calculate net margin per product, not per category.
- Decide on one action per product and review it every quarter.
What is a product-by-product profitability audit for?
A profitability audit tells you, for each SKU, whether it makes or loses money, and then helps you decide what to do with it. An Amazon account’s total revenue can grow while several products sell at a loss. As long as results are reviewed in aggregate, those products go unnoticed.
The end goal is simple: sort every product into one of three groups. Products to push are profitable and deserve more inventory and visibility. Products to fix have potential but a cost that’s out of control. Products to stop tie up time, inventory, and cash without enough return.
You don’t need complex tools for an audit. A spreadsheet, Seller Central exports, and your purchase invoices are enough to get started.
What data should you gather first?
For each product, gather sales, fees, advertising, returns, and product cost over the last twelve months. Twelve months smooths out seasonality: a product that sells mostly at year-end can look weak over a summer quarter.
- Sales: units sold and net revenue by SKU, available in Seller Central payment and transaction reports.
- Amazon fees: referral fees, Fulfillment by Amazon fees, monthly storage, long-term storage, and removal or disposal fees.
- Advertising: spend per advertised product, from the advertising console.
- Returns and refunds: units returned, amounts refunded, and units that became unsellable after return.
- Landed product cost: unit cost, inbound freight, import duties, packaging.
- Other direct costs: environmental fees, samples, photography, product-specific compliance costs.
Amazon fees usually take the longest to rebuild. If some of them are unfamiliar, Understanding Amazon fees before setting your price covers them one by one.
How do you calculate net margin per product?
Subtract all of a product’s direct costs, including advertising and returns, from its net revenue. The result is the product’s net margin, before company overhead.
Do this per product, not per category. A category that’s profitable on average can contain two products carrying it and three dragging it down. If you sell variations (sizes, colors), start at the parent level, then drill into variations when the gaps look large: one frequently returned size can be enough to sink the result.
| Line | Source |
|---|---|
| Net revenue | Seller Central payment reports |
| Minus landed product cost | Supplier and freight invoices |
| Minus Amazon fees | Transaction reports |
| Minus ad spend | Advertising console |
| Minus returns and refunds | Returns reports |
| Equals product net margin | Your spreadsheet |
Add two useful columns: net margin per unit and net margin as a percentage of revenue. The first shows what each sale really earns; the second lets you compare products at different price points. For advertising, also look at spend relative to the product’s total sales, as explained in ACoS and TACoS: reading your advertising numbers correctly.
How do you decide what to do with each product?
Pick one action per product, just one, and write it down with a review date. Vague decisions like “keep an eye on it” change nothing.
- Push: positive, stable net margin. Possible actions: secure inventory, increase visibility within an ad spending cap, expand to other marketplaces.
- Fix: thin or negative margin, but for an identifiable reason. Examples: poorly targeted ads, a price that’s too low, packaging that pushes the product into a higher fee tier, a high return rate tied to an unclear listing.
- Stop: negative margin with no realistic lever, or slow-moving inventory piling up storage fees. Plan the exit: sell through, remove or liquidate, then close the offer.
For products to fix, change one thing at a time and set a deadline to measure it. If you change price, ads, and images all at once, you won’t know what worked. Returns often deserve special attention; Amazon returns: cutting their cost without hurting your reviews covers the main levers.
How often should you repeat the audit?
Review your decisions every quarter. A quarter gives fixes enough time to show a measurable effect without letting a loss drag on too long.
At each review, check three things:
- Have the products you were fixing moved to another group? If not, should you try a different fix or stop them?
- Have costs changed: supplier price, Amazon fees, freight?
- Are the products you’re pushing still profitable as volume grows? More advertising can lower margin per unit.
Keep every version of the spreadsheet. The history shows which decisions paid off and which changed nothing. It’s also a solid foundation if you ever need to present your business’s profitability to a partner, a lender, or a buyer.
Frequently asked questions
Should overhead be included in per-product margin?
Not at the first level. Calculate each product’s direct margin first, then compare the total of those margins to your overhead to see whether the business as a whole is profitable.
What about a new product without twelve months of history?
Analyze it over the period available and keep it in a separate group. A product in launch is judged on its trajectory, not on a full year.
Should a product with zero margin be discontinued?
Not necessarily. If it brings in customers who then buy other products from the brand, it may have a role. That role should be verified, though, not assumed.


