Finance & Operations

Marketplace Settlement Reconciliation: Why Your Payouts Never Match Your Orders

Q: Can reconciliation be done in a simple spreadsheet?

Yes, for straightforward volumes — though as order volume grows across multiple marketplaces, a structured template per platform (matching each one's settlement file format) becomes necessary to keep it accurate and fast.

Almost every seller has had this moment: total order value for the month says one number, and the amount that actually hits the bank account is meaningfully lower, with no clear explanation in sight. The gap is real, but it's rarely a mistake. It's a stack of deductions that need to be reconciled individually, not compared as one lump sum.

Start With the Right Files

Each marketplace produces its own settlement, payment and tax-invoice files, MDirect and PG settlement reports on Myntra, for instance, are structured differently from Flipkart's or Amazon's equivalents. Reconciliation has to start from the platform's actual source files, not a generic sales export.

Match Orders to Payouts Line by Line

Every order should map to a specific payout, refund, or adjustment entry. Aggregating totals and comparing them hides exactly where the mismatch is coming from, line-level matching is the only way to catch a shortfall before it becomes a pattern.

Account for Commission, Shipping and Ad Spend Separately

Marketplace commission, shipping fee deductions and any self-funded ad spend all reduce your settlement independently of tax. Treating them as one unexplained 'gap' makes it much harder to spot which one is actually eating into your margin.

Build a Monthly Habit, Not a Quarterly Scramble

Reconciliation done monthly catches a payout shortfall while it's still fixable with the platform's support team. Left until quarter-end, the same discrepancy is often too old to dispute.

FAQ

Common Questions

Why is my settlement amount always lower than my order total?

Commission, shipping fees, TCS/TDS deductions and any refunds processed in that cycle are all netted out before the payout reaches your account, the gap is expected, but it needs to be reconciled line by line to confirm it's correct.

How often should I reconcile marketplace settlements?

Monthly, at minimum. It's the only cadence that lets you catch and dispute a genuine shortfall while the marketplace's support window is still open.

Can reconciliation be done in a simple spreadsheet?

Yes, for straightforward volumes, though as order volume grows across multiple marketplaces, a structured template per platform (matching each one's settlement file format) becomes necessary to keep it accurate and fast.

Onboarding & Registration ✦ Listing Optimization ✦ Account Management ✦ Settlement Reconciliation ✦ Inventory & Catalog ✦ Growth Strategy ✦ Ads & PPC Management ✦ Onboarding & Registration ✦ Listing Optimization ✦ Account Management ✦ Settlement Reconciliation ✦ Inventory & Catalog ✦ Growth Strategy ✦ Ads & PPC Management ✦ Onboarding & Registration ✦ Listing Optimization ✦ Account Management ✦ Settlement Reconciliation ✦ Inventory & Catalog ✦ Growth Strategy ✦ Ads & PPC Management ✦