Amazon Seller Profit Analyzer

About the Amazon Seller Profit Analyzer

Amazon pays you a total; this analyzer shows what it is made of and what is left once your own costs are paid. Open the Date Range transaction report or your settlement reports (flat file V2) for any months, add a sheet of your landed cost per SKU, and it builds a profit and loss by month, by SKU, by ASIN and by marketplace: product sales, shipping and gift wrap credits, promotions and refunds, then every kind of Amazon fee — referral, FBA fulfilment, storage, inbound, removals, advertising, the subscription, coupons and deals, chargebacks — reimbursements, net proceeds, the cost of the units sold, profit, margin and ROI. Taxes Amazon collects and remits for you are kept out of the profit, and every currency keeps its own report.

It also checks the money: each settlement against the sum of its lines, and each transfer to your bank against your bank statement, so a payout that never arrived stands out. And it spots SKUs whose fulfilment fee per unit jumped and stayed up — often a new measurement of the product — and hands them to the Amazon FBA Reimbursement Finder as remeasurement cases.

Without a pass the result is a free preview: the months, SKUs and payouts found and the first rows of each table show with the amounts hidden; the full figures, the workbook, the CSV files and the hand-over unlock with a Premium pass. Your reports are read in your browser and never uploaded.

Common uses

• Seeing which SKUs make money once ads, storage and refunds are counted, not only the referral and FBA fees.
• A monthly profit and loss for your bookkeeper, from the reports Amazon already gives you.
• Finding a payout that never reached the bank, or a settlement that does not add up.
• Catching a fulfilment fee that rose after a new measurement while it can still be claimed back.

Which report to use

• The Date Range transaction report (Seller Central help) lists every order, refund, fee, adjustment and transfer between two dates, one line each, with its settlement ID: the easiest way to see whole months.
• The settlement report (flat file V2) lists every amount of one settlement period, with the total paid out; the analyzer checks that its lines add up to that total.
• Both hold the same money: when you add both, the transaction report is used for the profit and loss and the settlements for their checks, so nothing counts twice. Rows that two downloads of overlapping dates share are counted once too.

Profit, margin and ROI

• Net proceeds = sales + shipping and gift wrap credits + promotions + refunds + Amazon’s fees + reimbursements and other adjustments: what Amazon owes you before your own costs.
• Cost of the units = (units sold − units refunded) × your landed cost, using the cost in force on each day when your sheet has dates.
• Profit = net proceeds − cost of the units; margin = profit ÷ product sales; ROI = profit ÷ cost of the units.
• Taxes collected and withheld by Amazon (marketplace facilitator tax, VAT where Amazon collects it), the reserve held back and the transfers themselves are shown apart and never counted as income or cost. Units with no cost in your sheet are counted and named, and the profit is marked as too high by their cost.

Payouts and the bank

A transfer is matched with a deposit of the same amount, to the cent, from the day of the transfer up to the days you allow; each deposit is used once. Settlements are matched by their deposit date in the same way, and each settlement whose lines do not add up to its total is shown with the difference. A payout is called “Not in the bank” only when your bank file covers every day its money could arrive on; one that falls before the file starts or too near its end is marked as outside the file’s dates, so a statement that stops early raises no false alarm.

Fee jumps

For each SKU the fulfilment fee per unit of every order is followed over time. A fee that rises by more than the share and amount you set, holds for at least 3 units and does not come back down is listed with the fee before, the fee now, the units charged and the first day. A rise can be a new rate card, the holiday peak season, a different price band or a surcharge as well as a new measurement: the reimbursement finder asks you to check which before asking Amazon to measure the item again.

Limitations

• MySmartCoPilot is not affiliated with or endorsed by Amazon.
• An analysis of your own reports, not accounts or tax advice: how sales, fees and taxes are booked is for you and your accountant.
• Costs outside Amazon (shipping to Amazon, prep, your own warehouse) are in the profit only as part of the landed cost you enter.
• Lines the reports describe in another language are placed by their type and wording; anything not recognised goes to other adjustments, which are listed.
• Sellers on amazon.in: the GST and TCS of Indian settlements are better handled by the marketplace payment reconciliation.

Privacy

On this device; its files download once

Your reports, costs and bank statement are read in this browser and never uploaded; only your settings are remembered on this device.