Amazon.in settlement report analyser
Your settlement report is the only document that explains the deposit in your bank account. Open it here and it is broken back into what you sold, what Amazon charged, what came back as refunds and reimbursements, what was withheld as tax and what is sitting in the reserve — with every heading adding back up to the payout. The file is read on this device and never leaves it.
Selling on Amazon.com instead? Use the Amazon US version.
Not tax advice — confirm with a CA. GST rules and portal steps change; the GST portal and your CA make the binding call.
Choose your settlement report
In Seller Central go to Reports → Payments → All Statements and use Download Flat File V2 for the settlement period you want. Pick that file here. A .txt or .csv export of the same report works too.
Your file never leaves this browser.It is read and added up on this device. Nothing is uploaded, nothing is stored on a server, and we never see it — close the tab and it is gone. The only thing kept is any per-unit cost you type, in this browser's own storage.
How it reads your file
A Flat File V2 settlement report puts every figure into one column. Instead of a column per kind of charge, each line carries an amount-type, an amount-description and an amount, and the whole settlement is those lines added together. That is exactly what this tool does — see Amazon Seller Central: Settlement Report Summary and Amazon Seller Central: How do I read my Payments report? for Amazon's own description of the file (you may need to be signed in to Seller Central to open them).
- It works out the delimiter and the marketplace itself. Tab-separated, comma-separated and semicolon-separated files all work, and the marketplace is read from the currency and the marketplace name in your own file rather than assumed.
- It copes with the files people actually have. A byte-order mark, a preamble above the header row, quoted fields, blank lines, accounting brackets for negatives, thousands separators, and several settlement periods in one file.
- Every line is counted once.Each line goes under exactly one heading, so the headings always add back up to the payout. The full list of your file's own descriptions is shown underneath, so you can check where anything landed.
- It never assumes a rate. No selling fee percentage, no FBA rate card, no TCS or TDS rate is written into this tool. If a figure is on the screen, it was added up out of your file.
- If the file is not a settlement report it says which columns it needed — at minimum settlement-id, amount-type, amount-description and amount — instead of failing silently. An older Flat File V1 report is recognised and named as such.
TCS, TDS and the reserve
Three kinds of line on an Amazon.in settlement are routinely mistaken for costs when they are not. TCS and TDS are withheld from your proceeds and deposited against your own tax account, so they lower this payout but you claim them through your returns — the tool shows them under their own heading and calls them credits rather than costs. The reserve is balance held back rather than money lost, and it is shown as timing: what is taken in one period usually returns as a release in a later one. Reimbursements go the other way — they are credits Amazon has already given you, and they add to the payout.
The amounts are whatever your file says. No rate is assumed anywhere, and nothing here tells you what you owe or can claim: that is between your books, the portal and your CA.
Why it runs in your browser
A settlement report is your whole business in one file: every order, every SKU, every charge. There is no good reason to send it to somebody else's server to add up a column, so this tool does not. Your browser reads the file, the arithmetic happens on your device, and the result is drawn on the screen. There is no upload, no request carrying your figures, and nothing for us to keep or lose.
The per-unit costs you type are the one thing that is remembered, and they are kept in this browser's own storage on this device — not in an account and not with us. The CSV you download is built on your device too. If you would rather check that than take our word for it, the parsing and the arithmetic live in two small files in the open-source repository and neither of them can make a network call.
Questions Amazon.in sellers ask about settlement reports
Is my settlement report uploaded anywhere?
No. The file is read by your own browser and added up on your own device. There is no upload, no server call carrying your figures and no copy kept by us — close the tab and it is gone. The only thing that stays is any per-unit cost you type, which is saved in your browser's own storage so the table is still filled in next time.
Which file do I download from Seller Central?
In Seller Central go to Reports, then Payments, then All Statements, and use Download Flat File V2 for the settlement period you want. That is a tab-separated text file. A CSV saved from the same report also works, and a file holding several settlement periods is fine — each one is totalled separately.
Does the tool know Amazon's fee rates?
No, and that is deliberate. There is no fee table and no tax table anywhere in it. Every figure it shows is a sum, a difference or a share of numbers that were already in your file, so it cannot be out of date and it cannot be wrong about a rate it never claims to know.
Why are TCS and TDS shown separately instead of as costs?
Because they are not costs of running your business. They are amounts withheld from your proceeds and deposited against your own tax account, so they reduce this payout but you claim them back through your returns. Grouping them with fees would understate your profit. Check the amounts against your own records and your CA.
What does the reserve line mean for my profit?
A reserve is part of your balance held back for a while rather than money you have lost, so the tool shows it as its own line and calls it timing rather than cost. A reserve taken in one settlement usually comes back as a release in a later one, which is why the reserve figure can be negative in one period and positive in the next.
What counts as something worth checking?
Only arithmetic on your own file: a settlement whose lines do not add up to the total it states, refunds that are a large share of sales, a fee heading that takes a much bigger share of sales in one settlement than in the rest of the file, and SKUs that came out negative before your product cost. None of that says Amazon has made a mistake; it points at lines that deserve a second look.
Related free tools
- Amazon.in settlement profit calculator — model a payout from figures you type, when you do not have the file to hand.
- Reorder-point and safety-stock calculator — when to send your next FBA shipment and how much.
- GST APOB tool for Amazon fulfilment centres — the additional place of business paperwork for storing stock in another state.
- Amazon US settlement report analyser — the same tool for Amazon.com sellers.
Free for the first 50 sellers
Want this run for you every settlement? Free during early access
I'm building WidenMargin to do this on its own — read every settlement as it lands, tie it back to your orders and your costs, and tell you what changed. Join the early-access list and we'll email you when it is ready. Your settlement file is never sent to us, here or there.
We only use your email to contact you about WidenMargin early access. Never sold or shared. Ask us to delete it any time. Privacy