Amazon India settlement reconciliation
Last reviewed·ReconPe Editorial
Upload your Amazon India MTR and bank statement. ReconPe parses Settlement Report V2 (including GST-aware commission deductions and A-to-Z claim dispositions), matches every order via the ACRE probabilistic engine, flags commission variance against your category rate card, and tracks COD remittance age with per-marketplace SLA semantics. Exceptions from past cycles carry forward automatically — so late settlements from last month link to their original exceptions on this month’s run.
Where Amazon reconciliation breaks down manually
MTR volume keeps growing
A single month of Amazon India activity can produce tens of thousands of Merchant Tax Report lines. Manual VLOOKUP against bank statements breaks around 5,000 rows — performance, error rate, and review time all fall off a cliff.
Commission varies by category, tier, and FBA status
Amazon commission percentages shift by product category, seller tier, and whether the order is FBA or Merchant Fulfilled. Small variance per order compounds into meaningful leakage — and catches no one's attention in a spreadsheet.
COD remittances lag by 14–21 days
Cash-on-delivery orders settle on a different cycle from prepaid. Tracking remittance age per order requires stitching together MTR, payment report, and bank statement — across multiple settlement files.
GST on platform fees needs separate matching
Amazon India charges GST on platform fees (commission, closing, shipping) that must reconcile against your input tax credit claim. ReconPe separates fee components and their GST so you can file with confidence.
How ReconPe handles Amazon India
Rate-card aware commission variance
Upload your Amazon category rate card once. Every settlement line gets compared against expected commission, and variance is flagged per order with the exact rupee impact.
Bayesian match confidence per row
Every order ID match between MTR and bank credit gets a 0–100 confidence score using Fellegi-Sunter probabilistic weights — so you know which rows to review and which are safe to approve in bulk.
The details that decide an Amazon reconciliation
The difference between a reconciliation that ties out and one that quietly leaks is in how the Settlement Report is actually shaped. These are the specifics ReconPe handles because it reads the real file, not an idealised one.
Settlement Report V2 is an event stream, not a table
Each order shows up as several rows — Principal, Commission, FBA fees, promo rebates — on separate amount-type lines. ReconPe aggregates them back to one order before it audits anything, the way Amazon actually structures the file.
A-to-Z and SAFE-T are kept out of the order net
Amazon settles A-to-Z guarantee claims, SAFE-T reimbursements and chargebacks as their own adjustment rows, on their own cycle. ReconPe excludes them from the per-order net so a claim does not double-count against the settlement it lands in.
Commission checked against your category rate card
Load your Amazon category rates once and every order's commission is compared to expected = principal × rate%. Anything off by more than the greater of ₹1 or 0.5% is flagged as a slab mismatch, with the exact rupee over- or under-charge.
GST-on-fees and TCS split for your input credit
GST charged on commission, closing and shipping fees is separated from the fees themselves, and TCS collected under Section 52 is isolated — so the input-credit figure you carry into your filing is reconciled, not estimated.
Frequently asked
How often does Amazon India publish the MTR?
Amazon publishes the Merchant Tax Report weekly, with settlement reports on a 7–14 day cycle depending on seller tier. ReconPe auto-detects whether you've uploaded a weekly MTR or a monthly consolidated report and adjusts the matching window accordingly.
Does ReconPe work with Amazon FBA and Merchant Fulfilled orders together?
Yes. Each order line in the MTR carries the fulfilment type, and ReconPe's rule engine applies the appropriate commission and fee expectations per order. You don't need to split files by fulfilment type.
What commission variance does ReconPe detect on Amazon India settlements?
ReconPe compares actual commission charged against your category rate card for every order. It flags three patterns: commission charged at a higher slab than category allows, closing fee charged outside expected range, and shipping fee variance (weight-banded differences).
How does COD remittance tracking work?
Every COD order is tagged with remittance status and age. ReconPe flags orders where remittance is overdue (more than 14 days for most tiers), produces a remittance ageing report, and matches against bank credits to confirm when funds actually land.
Can ReconPe handle returns and RTO deductions?
Yes. Return and RTO (return-to-origin) entries in the MTR are matched against the original order, and ReconPe flags cases where refund amount differs from original settlement or where return shipping was charged.
Do I need to clean the MTR before uploading?
No. ReconPe's schema detection reads MTR files as-is — the format changes Amazon has pushed over the last 3 years are all supported. No column mapping required for first run.
Why VLOOKUP breaks at 2,000 orders a month
A 3am WhatsApp from a Flipkart seller: 'the file crashed again.' Riya opens it — 4,800 rows, OrderID duplicated six times per order. Direct matching dies at this scale. Set matching is the answer.
Reconcile your next Amazon India settlement in minutes
Free tier — 5 free reconciliations, 1 marketplace. Upload your next MTR and see variance you were missing in Excel.
Start free