Founders & Small BusinessFree
Amazon Product Profit and Margin Report
Upload your Amazon reports and unit costs, and see the true profit on each product and channel, with storage, ads and refunds charged where they belong.
Upload the settlement, storage and advertising reports from Seller Central, plus what each unit costs you to buy and bring in. River cannot log into your account, so it works from the files you export. It charges every fee to the product that actually caused it and sends back a Sheet with net profit per product per channel, plus a short Doc naming the products that lose money and what to do about each. The Sheet's totals are checked against Amazon's own figure for the month.
The guidance that ranks for this search lists the same cost lines and then splits them the same way. Storage becomes a blended figure per unit sold, which charges a fast-moving small item for the space a slow-moving bulky one is occupying. The referral fee becomes one category percentage, which is not what the published schedule says in several categories. Neither error moves the account total by a cent, so the month still adds up and only the per-product answer is wrong.
Written for sellers running one catalogue across a marketplace, an own store and wholesale, who have to decide which product to reprice and which to stop restocking. Reach for it before the next purchase order rather than after. Tying the period total to the bank is a separate reconciliation, and the goods side of the same period is an order and fulfilment check. A supplier who just moved your landed cost needs an answer to their letter. A product with healthy unit economics that barely sells needs a listing diagnosis instead.
The fee with no order number is the one that decides it
A referral fee arrives with an order number on it. A storage charge does not. It lands as one pooled amount for the month, and how that pool gets split decides which product looks profitable. Managerial accounting has a settled answer here: assign a pooled cost using the activity that actually drives it, rather than one volume-based rate spread across everything. Storage is driven by cubic feet held across days, not by units shipped, so those are the two numbers the split has to use.
Halstow Goods, a fictional home goods seller, sold 2,040 units on Amazon in September against one storage charge of $584.20. Spread across units sold, that is $0.29 a unit and $54.41 to the canvas bin. Charged on cubic-foot-days it is $424.96 to the bin, which sat at 520 units of average cover, and nothing to the apron, which ships off the seller's own shelf. The bin moves from $1.08 of profit a unit to $0.87 of loss. The month's total does not move at all.
The apron carries a different error. Amazon's schedule charges 17% on a Clothing item above $20.00 and 10% between $15.00 and $20.00, against a total price that includes the shipping charge. At $19.90 plus $2.99 postage the sheet read the band off $19.90 and paid $1.99; the schedule says $3.89. That is $1,159.79 across 610 aprons. Add up what the order lines say Amazon kept and $922.62 still separates it from the settlement's own net: storage, plus the inbound placement fee Amazon bills separately.
How it works
Add the reports
Attach the settlement, storage and advertising reports for one month, and your landed cost per product.
Add your other channels
Say where else the same products sell, such as your own store or wholesale, and what each costs.
Get the profit sheet
Net profit per product per channel, how each shared fee was split, and any gap to Amazon's figure.
Work the losers
Ask what a price change does, try a smaller reorder for a slow product, or add the next month.
What you get
- Net profit per product per channel, with every fee charged to whatever actually caused it
- Storage split by the space and time each product used, never averaged across units sold
- Referral fees rechecked against Amazon's published price bands, using the total price including shipping
- Your product totals checked against Amazon's own figure, with any gap shown and explained
- Refunds moved back to the month of the original sale, so good months stop looking bad
- The price change, the smaller reorder or the product to drop, each with the arithmetic shown
Common questions
Seller Central says this product is profitable. Why does your number disagree?
Because the report you are reading only carries the fees that have an order number. Storage, inbound placement, removals and long-term surcharges are billed to the account rather than to an order, so nothing puts them on a product. They are real money and they land unevenly. On the canvas bin above they were the entire difference between profit and loss.
How should a pooled storage charge be split between products?
On cubic-foot-days: the space each SKU occupied multiplied by the days it sat there. That is the thing the charge is actually billed on. Splitting it per unit sold gives a slow bulky product a discount paid for by a fast small one. The account total looks identical either way, so nothing ever flags it.
One ad campaign covers six products. How does that spend reach a SKU?
From the advertising report's own attribution, product by product, rather than from each product's share of total revenue. Where a campaign genuinely cannot be attributed further, the spend stays in a named unallocated row instead of being spread. A pooled cost pushed onto products it never touched is worse than a pooled cost left visible.
A refund landed in September against a July sale. Which month wears it?
July, because that is the month whose margin it changes. Refunds posted in the month they clear make two months wrong at once, and make a good month look bad for something it did not do. The September settlement still has to tie, so cohorted refunds sit on their own reconciling row rather than disappearing.
Does this work for anything other than Amazon?
Any channel where you can produce the fees and the volumes: an own store, Etsy, eBay, TikTok Shop, wholesale, or a market stall. What differs is which costs arrive pooled. Card processing is per order and easy. Warehouse rent and pick labour are pooled, and the same cubic-foot-days rule applies to your own shelf as to a fulfilment centre.
It says a product loses money. Should I delist it?
Usually not first. A loss on one channel is often a stocking decision rather than a product decision. The canvas bin went from a $164.93 loss to a $47.55 profit purely by cutting its cover from 2.7 months to 1.4, at the same price. If the answer really is a price rise, customers on your own store need a note explaining it.
I sell services, not products. Does any of this apply?
The mechanism does, the fee schedule does not. A pooled cost that has to reach a job rather than a SKU is the same problem, and the driver is usually hours or site visits instead of cubic feet. That is a job-level profitability review rather than this one, and it starts from timesheets instead of a settlement.
Amazon Product Profit and Margin Report
Describe what you need, add any files you have, and your workspace opens with the work already underway.