Marketplace Settlements: Reconciling Amazon, Flipkart and Meesho

For every marketplace seller, the same monthly drama plays out: a settlement lands in the bank, and the question is what does this amount actually represent? Reconciling settlements against orders is the single most important — and most tedious — accounting discipline for e-commerce. Here is how to do it cleanly.

Why this matters

Without disciplined reconciliation, you have no way to know:

• Whether the marketplace has paid you for every order it owes
• Whether the deductions (fees, returns, adjustments) are correct
• Whether you have actually been short-paid or short-credited
• What your real margin per order is, net of all costs

A surprising share of marketplace settlement disputes are never raised because the seller does not know they are owed money. Reconciliation is what turns that around.

Anatomy of a settlement

A typical marketplace settlement statement contains:

• Gross order value — what customers paid for orders settled in this cycle
• Commission — the marketplace's percentage
• Closing / referral fee — per-order fixed or category-based
• Shipping fee — the marketplace's charge for fulfilment / labels
• Fulfilment fees (if FBA-style)
• Returns — refunds for orders previously credited that were returned
• TCS — Tax Collected at Source @ 1% under GST
• Promotion / discount funding — coupons reimbursed (or not)
• Adjustments — corrections from previous cycles
• Net payable — the amount actually deposited in your bank

Each line has both an accounting treatment and a reconciliation question.

The right account structure

A clean chart of accounts for one marketplace:

• Receivable: [Marketplace name] — debit when an order is dispatched / delivered; credit when settlement reduces it
• Commission / fees: [Marketplace name] — expense
• Shipping: [Marketplace name] — expense (often a separate sub-account from your own shipping)
• Returns reserve: [Marketplace name] — provision for expected returns (optional, more advanced)
• TCS receivable — claimable against GST

Repeat per marketplace. The per-marketplace breakdown is what lets you see if one channel is silently underperforming.

The reconciliation workflow

Per settlement, in order:

• Match orders. Every order on the settlement statement should map to an order in your books. Missing orders are the first red flag — either an unrecorded sale or a mis-attributed payment.
• Verify gross values. Order value on the statement should match invoice value in your books.
• Verify deductions per order. Commission should be the agreed % of order value; closing fees per category; shipping per zone.
• Verify returns. Each return on the statement should map to a sales return in your books, with inventory restored or written off depending on condition.
• Verify TCS. The 1% TCS deducted should match (order value − returns) × 1%.
• Net payable check. Gross − all deductions − TCS = net payable. Should match the deposit.

Anything that doesn't reconcile gets flagged. The most common discrepancies:

• Promotions where the marketplace did not actually fund the discount (you bear the cost)
• Adjustments from prior cycles with no clear reason
• Returns counted twice — once at the time of the original sale's deduction and again later
• Shipping charged at higher zones than the actual delivery zone

What "scale" looks like

For one marketplace doing 50 orders a month, reconciliation is a 30-minute task per settlement. Doable manually.

For 500 orders a month across three marketplaces, manual reconciliation is impossible — you need software that:

• Ingests the marketplace settlement file directly
• Matches orders by order ID
• Computes expected deductions and flags variances
• Surfaces unmatched orders for investigation

For 5,000+ orders, this is a daily process, not a monthly one.

The disputes worth raising

A common pattern: small discrepancies of ₹10–50 per order across hundreds of orders that nobody bothers to dispute. Over a year that becomes lakhs.

What is worth raising:

• Systematic issues — a particular fee being charged too high consistently
• Missing settlements — orders dispatched but never settled
• Wrongful deductions — promotion costs the marketplace was supposed to fund
• Shipping zone errors — recurring

What is rarely worth raising:

• One-off small differences (the time cost exceeds the recovery)
• Issues from too long ago (most marketplaces have a dispute window)

A reconciled book is what lets you tell which is which.

The connection to TCS and GST

The TCS the marketplace deducts is your money — it goes to the government against your GSTIN. You claim it in your GST returns. To do that:

• The TCS amount per marketplace per month needs reconciling against your GSTR-2A / 2B entry for the marketplace
• The total claimed should match what the marketplace actually deducted

Discrepancies here are usually due to timing (TCS deducted in March, marketplace files it in April) and resolve themselves. But check.

Multi-marketplace consolidation

Across all marketplaces, the questions a multi-channel seller wants answered:

• Total marketplace receivable outstanding (with ageing)
• Per-marketplace contribution margin (revenue − COGS − fees − shipping − returns)
• Per-marketplace return rate trend
• Per-marketplace days-to-settlement trend
• TCS accumulated for the GST claim

None of these are produced by any single marketplace statement — they require the consolidated reconciled view in your books.

How Booksmor helps

Booksmor ingests settlement statements from major Indian marketplaces (Amazon, Flipkart, Meesho), matches each line to your order book, flags variances against expected fees, surfaces unmatched and disputed lines, and accumulates TCS for your GST claim. The reconciled view per channel and across channels is one click. Start a 30-day free trial and stop guessing what each settlement actually owes you.