Settlement reconciliation
Exact figures taken from your Amazon file: sales, refunds, fees, advertising, reserves and reimbursements, checked line by line against what Amazon paid you.
Free tool for Amazon sellers
Amazon Settlement Statement Checker
Reconcile your Amazon settlement and estimate product contribution.
See where your payout went and check that every line adds up to what Amazon paid you. The product estimate uses the unit costs you enter and leaves out other business costs, such as overheads, stock you have not yet sold and VAT you owe, so it is not your net profit. Your settlement file is read on your own device and is never uploaded.
Check your settlement
- Full breakdown of sales, refunds, fees, advertising and reserves
- Reconciles every line to Amazon’s payout
- The money Amazon kept back, and why
- An estimated contribution by product once you add your unit costs
- Load one settlement or several at once
No sign-up needed. Your file is read on this device and never uploaded to our website.
What the checker shows
Two different answers, clearly labelled
The checker is for Amazon FBA and FBM sellers on any marketplace that offers the “Flat File V2” settlement report. It gives you two kinds of figure, and it is worth knowing the difference.
Estimated product contribution
An estimate of what each product earns after Amazon’s fees and the unit costs you enter. It is only as accurate as those costs, and Amazon’s figures include VAT where it was charged.
Not your net profit
Net profit also depends on VAT owed, unsold stock, other business costs and tax, none of which are in a settlement report. That comes from properly prepared accounts.
What you will see
The results look like this example, which uses made-up figures. Below it you will find the full breakdown, the money Amazon kept back, each settlement’s reconciliation and the product table.
Where we can help next
- Amazon settlement reconciliation and posting to Xero
- A review of your fees, refunds and reimbursements
- Bookkeeping set-up for stock, cost of goods sold and VAT
- Monthly e-commerce management accounts
Amazon.co.uk · 2 settlements · 1 Sept – 30 Sept
Paid to you£6,302.63✓ Reconciled to Amazon’s payout
Net sales£11,052.00after £492.00 refunds and £188.00 promotions
Amazon fees31.8%£3,514.54 of net sales
Advertising9.6%£1,060.99 of net sales
Refund rate4.2%£492.00 refunded, against gross sales
- Refunds & promotions 5.8%
- Amazon fees 30.0%
- Advertising 9.0%
- Reserve & other 1.5%
- Paid to you 53.7%
Bar: per £100 of gross sales (£11,732.00). Amazon fees and advertising above are measured against net sales. The refund rate is refunds alone; the bar’s 5.8% adds the £188.00 of promotions.
Before you start
How to download your settlement report
Open your statements
In Seller Central, go to Reports › Payments, then All Statements.
Choose a settlement
Find the settlement period you want to check. Each one is a single Amazon payout.
Download “Flat File V2”
Click Download Flat File V2, then drop the .txt file into the checker above.
Good to know
Questions about the checker
Is my Amazon data safe?
Yes. The checker works inside your web browser. Your settlement file and any product costs you enter stay on your device and are never sent to us. You don’t need to sign up. We only receive your details if you send us an enquiry through the Contact form, together with a short summary of your figures if you choose to include it. You can read and edit that summary before sending.
Which marketplaces does it work with?
Any Amazon marketplace that provides the Flat File V2 settlement report, including Amazon.co.uk, the EU marketplaces and Amazon.com. Settlements in different currencies are shown separately.
Why doesn’t my payout match my sales?
Amazon deducts fees, refunds, advertising and storage, and can hold back a reserve that is released in a later payout. The breakdown shows each of these, and the reconciliation confirms every line adds up to what you were paid.
Does this replace an accountant?
No. It is a quick check to help you understand your payouts. For accounts, VAT and posting your settlements to Xero, book a consultation.
This checker is provided as a guide and is not accounting or tax advice. Figures are calculated from the file you provide.
Want this done for every payout?
We reconcile every Amazon settlement, post it to Xero and track your stock costs and VAT.