Amazon India settlement reconciliation
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.
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.
Reconcile your next Amazon India settlement in minutes
Free tier — 3 reconciliations per month, 1 marketplace. Upload your next MTR and see variance you were missing in Excel.
Start free