Marketplace Settlement Reconciliation Guide
A step-by-step process to reconcile your marketplace settlements and identify payment discrepancies
Settlement reconciliation is the process of comparing what you expected to receive from a marketplace against what you actually received. It involves matching your order records with the marketplace's payment/settlement records to identify discrepancies.
For Indian e-commerce sellers managing multiple marketplaces, reconciliation is essential to ensure you're being paid correctly and to catch any missing or incorrect deductions.
What is Settlement Reconciliation?
Settlement reconciliation involves:
- Collecting your order data: Records of all orders placed during a specific period
- Collecting marketplace settlement data: The payment/settlement report from the marketplace
- Matching orders: Comparing each order in your records against the settlement report
- Identifying discrepancies: Finding orders where the settlement doesn't match your expectations
- Resolving differences: Understanding why discrepancies exist and taking corrective action
Why Reconciliation Matters
- Missing payments: Identify orders where payment hasn't been received despite delivery
- Incorrect deductions: Catch overcharged commissions, excess shipping fees, or wrong penalty charges
- Duplicate charges: Spot cases where the same charge appears multiple times
- TDS verification: Ensure Tax Deducted at Source is calculated correctly
- GST reconciliation: Match GST charged with your records for accurate tax filing
- Business health: Accurate reconciliation gives you a true picture of your business profitability
The Reconciliation Process: Step by Step
Download Order and Payment Files
Download your order file and payment/settlement file from each marketplace for the period you want to reconcile.
Import Data into a Reconciliation Tool
Import both files into a tool that can process and match the data. Manual matching in spreadsheets is possible but extremely time-consuming for sellers with high order volumes.
Match Orders with Settlements
Match each order from the order file with its corresponding entry in the settlement report. This is the core reconciliation step.
Identify Discrepancies
Find orders where the expected payment doesn't match the actual settlement amount, or where orders have no settlement entry at all.
Analyze Discrepancy Types
Classify discrepancies into categories: missing payments, incorrect deductions, delayed settlements, commission errors, etc.
Raise Disputes and Follow Up
For identified discrepancies, raise disputes with the marketplace and follow up until resolution. Maintain records of all disputes for future reference.
Common Types of Discrepancies
| Discrepancy Type | Description |
|---|---|
| Missing Payment | Order appears delivered but no corresponding settlement entry exists |
| Wrong Commission | Commission charged at a higher rate than the agreed category rate |
| Excess Shipping | Shipping charges higher than expected for the given weight/zone |
| Duplicate Deduction | Same charge applied multiple times for the same order |
| Delayed Settlement | Payment for delivered orders appearing in a later settlement cycle |
| Incorrect TDS | TDS deducted at a rate different from what's applicable |
| Missing Reimbursement | Approved reimbursement not reflected in the settlement |
Challenges in Manual Reconciliation
- Volume: Sellers with hundreds or thousands of orders cannot manually match each one
- Multiple marketplaces: Each marketplace has a different file format and settlement structure
- Time-consuming: Manual reconciliation can take days for a single settlement period
- Error-prone: Manual matching in spreadsheets leads to errors, especially with large datasets
- Delayed identification: Discrepancies found late are harder to dispute and resolve
Automate Reconciliation with EcomPL
EcomPL automates the entire settlement reconciliation process. As an offline desktop software, it processes your marketplace order and payment files and automatically:
- Matches orders with settlement entries
- Identifies missing or unmatched payments
- Shows order-wise expected vs. actual payment comparison
- Highlights discrepancies for further review
- Works across Meesho, Flipkart, Amazon, and Myntra
Instead of spending days manually matching entries in spreadsheets, EcomPL provides reconciliation reports in minutes.