Guide
How to use the True Profit per SKU
1. Download the reports
Payments transaction report (recommended)
- 1In Seller Central go to Reports → Payments → Date Range Reports.
- 2Click Generate Report, choose Transaction, and pick a full month (or any range).
- 3When it's ready, click Download (CSV). Upload it here unchanged.
Or: settlement flat file
- 1Go to Reports → Payments → All Statements.
- 2Next to a settlement period, choose Download Flat File V2.
Menu names in Seller Central change now and then. If a label looks different, search the report name in Seller Central's search bar.
2. Read the results
Profit by SKU
Sales, Amazon fees, refunds, GST on sales and what Amazon actually paid, per SKU. Type your cost per unit and profit, profit per unit and margin fill in. Costs are remembered in your browser only.
Losing money
SKUs whose profit is negative after everything. These are your first fixes.
Possible overcharges
Orders where the weight-handling / fulfilment fee per unit was clearly higher than you normally pay for that SKU: usually a wrong weight or dimension on Amazon's side.
Account charges
Costs not tied to a SKU: storage, subscription, advertising paid from your balance, reimbursements and adjustments.
3. What to do next
- For a losing SKU: check its fee % first. A small price increase that moves it into a lower referral or weight slab can turn it profitable; otherwise stop advertising it or switch fulfilment method.
- For overcharges: open the product in Seller Central and compare Amazon's weight and dimensions with your packed parcel. If Amazon's are wrong, raise a case under Fees → Weight handling / dimensions and include the order IDs (use Copy order IDs).
- Refund-heavy SKUs: open the Returns & SAFE-T tracker to see why customers return them.
4. Good to know
- •Enter cost excluding GST if you are GST-registered and claim input tax credit; otherwise include it.
- •TCS and TDS deducted by Amazon are added back to profit because you can claim them as tax credit.
- •Advertising is usually billed to your card, so it won't be in this report. Subtract it separately, or use the Ads Waste Finder to reduce it.
5. FAQ
Why is "Amazon paid" lower than sales minus fees?
It also includes refunds, TCS/TDS withheld and any adjustments on that SKU.
Which fees count as fulfilment fees for overcharges?
The "fba fees" column (or FBA / weight-handling / pick & pack fees in the settlement file), which covers Easy Ship and FBA weight handling.
Is my payments data uploaded?
No. The file is read by your browser; nothing is sent to our server.
It says a column is missing. What now?
You probably uploaded a different report, or Amazon renamed a column. Download the report exactly as in step 1. If it still fails, tell us the report name and we'll add support.