Amazon Reconciliation Tool
See what Amazon deducted, what you finally got, Released vs Deferred, and unpaid orders — from your Orders .txt + Transaction View CSV. Runs in your browser; files never leave your device.
Amazon India CSV Reconciliation
Upload Orders (.txt) + Payments → Transaction View (CSV). See what Amazon deducted, what you finally got, Released vs pending, and unpaid orders — all in your browser.
- Orders file (.txt): Login to Amazon Seller Central → Reports → Fulfillment (or All Orders / order reports) → request/download for your date range. Amazon usually downloads this as a .txt file (tab-separated) — upload that .txt here as-is (no need to rename to CSV).
- Settlement / Transaction CSV: Seller Central → Payments → Payments → Transaction View → choose Custom date range → set From / To dates → click Update → then click Download. This downloads a CSV.
- Tip: Use the same From–To dates for both files.
Need a Full Payout Audit?
Share your seller details — we review fees, returns, TCS/TDS and missing settlements.
Your details are 100% secure · Response within 24 hours
Why Amazon Payment Reconciliation Matters for Indian Sellers
Amazon India settlements are rarely a simple “sale amount minus commission.” Each settlement cycle mixes principal, shipping, promotions, referral fees, FBA/Easy Ship logistics, closing fees, refunds, reimbursements, TCS, and adjustments. Without a structured Amazon reconciliation process, underpayments and duplicate fee lines stay buried in flat files.
This free tool gives you a first-pass match: upload your order report and settlement/transaction CSV, then compare sale vs received amount by Order ID + Order Item ID. For deeper fee, return, bank, and claim workflows, use our managed Amazon payment reconciliation service.
Where to Download These Files (Amazon Seller Central)
You download reports from your own Amazon seller account — EcomExpert does not host Amazon files for this free tool.
- Order report (.txt): sellercentral.amazon.in → Reports → Fulfillment / All Orders → request for your dates → download. Amazon usually gives a .txt file — upload it as-is in the tool above.
- Settlement / Transaction CSV: Seller Central → Payments → Payments → Transaction View → select Custom range → set From / To → click Update → click Download (this is a CSV). Use the same dates as the order report.
- Optional returns: Returns reports under Reports help explain refund gaps (full fee audit via our managed Amazon reconciliation).
Reports You Should Reconcile Every Cycle
- Order / Sales report: baseline sale and item identifiers (from Seller Central Reports).
- Settlement / Transaction report: actual credits, fees, and taxes (from Reports → Payments).
- Returns / refunds: RTO and customer-return impact on net payout.
- Bank statement: confirm settlement deposits actually credited (managed audits cover this end-to-end).
Statuses This Tool Highlights
- RECONCILED — settlement is within ₹1 of the sale amount matched.
- UNPAID — order found, no settlement amount matched.
- UNDERPAID / OVERPAID — difference beyond tolerance (fees, refunds, or mapping gaps).
Price Correctly Before You Reconcile
Many “underpayments” start as bad pricing assumptions. Check your unit economics with the Amazon Price Calculator and GST splits with our GST Calculator before you escalate a claim.
When to Escalate Beyond a CSV Match
If you see repeated commission or weight/shipping mismatches, missing settlement IDs, or return fee spikes, you need line-level fee audits — not only order totals. EcomExpert’s team runs that as a managed service under Amazon reconciliation, alongside Amazon account management and Amazon PPC when ads are eating settlement net.
Related Free Tools
Managed Recovery
We audit Amazon fees, returns, TCS/TDS, and bank credits — then open recovery cases where the data supports a claim.
Amazon Reconciliation Service