Solutions · reviewed 8 October 2026

Settlement reconciliation: find what the marketplaces still owe you

A settlement is not a payment for your orders; it is a list of what the marketplace decided to pay after fees, returns, penalties and taxes it collects on your behalf. Reconciliation is three checks: every dispatched order has a settlement line, every line matches the rate card, and every batch landed in the bank. Most tools run only the first.

The three checks

• Order to settlement line. Was every dispatched order paid for? This cannot be answered from the settlement alone: an order missing from it leaves no trace in it. It needs the order book on one side and the report on the other.
• Line to expected fee. Commission (5–20% by category), fixed fee, collection fee, shipping, return adjustment, each checked against the rate card. A wrong weight slab or a fee applied to a cancelled order shows up here.
• Batch to bank credit. Matched on the UTR, which the marketplace remits under and the bank prints in the narration. Matching on amounts breaks the moment two payouts land the same day, which they routinely do.

TCS and TDS are not fees

Two levies appear in every settlement and are recoverable credit, not cost. Bucketing them with commission overstates the cost of selling by more than a percentage point and hides a real receivable: a channel charging 10% reads as 11%.

Where importers go wrong

• Amazon retired the XML and original flat-file settlement reports in March 2026. Flat File V2 is tab-separated, one row per charge, and its first row is the deposit total with no transaction type: a header, not a charge. Include it and every figure in the batch doubles.
• Flipkart's per-cycle CSV has one row per order and each deduction in its own column, with the settlement reference number as the UTR. Four deductions appear in every settlement: commission, 1% TCS, return adjustments and logistics.
• Meesho's payment report, and other wide-format reports, state deductions as positive numbers in a column named commission. They must be signed on import or the net comes out far too high.

What it costs to do by hand

Sellers download five to eight spreadsheets per marketplace per cycle and spend ten to fifteen hours a week on them. Reconciliation tooling recovers two to five percent of revenue from wrong fees, un-credited returns and missed claims. Those are the research's figures, cited below; your figure comes from the first pass, which is free.

How ezmarketplaces does it

• Settlements are pulled from each channel's own report and matched line by line to orders. Flipkart's report is generated on request and can take minutes, so a period is retried until the report exists rather than recorded as zero.
• Every line is compared with the order it settles. The difference is written to the Recovery ledger with the source line behind every rupee. Nothing is dismissed automatically; each discrepancy is yours to claim, dismiss with a reason, or leave.
• The Recovery ledger is a deadline-ordered worklist: weight discrepancies, short remittances, gateway fees, freight overcharges. Each row drafts the claim text for the marketplace's own form with the evidence attached. Claim windows are stored per channel and editable, because marketplaces change them.
• Freight carries a rate card per carrier and a zone resolver; a charge that does not match the card for that weight and zone becomes a recovery row. The resolver refuses to guess a zone from an incomplete pincode rather than produce a wrong claim.
• Settlements and fees export as vouchers to Tally, Zoho Books and QuickBooks. The export against a live company is not yet verified; the page says so until it is.

Questions

Do I need write access for reconciliation?

No. Read-only access to orders and settlement reports is all the first pass needs, and it does not interfere with another tool holding write access.

Which channels are reconciled today?

Flipkart and Meesho from their reports; Amazon from Flat File V2 once Amazon lists our application (sandbox until then). Bank credits are matched on UTR for all of them.

Will you file the claims?

The claim is drafted with the line and evidence; filing it on the marketplace's console is yours, because it is made in your name. The window is tracked so it is not missed.

How long does Flipkart take to settle a payment?

Seven business days from dispatch for Platinum and Gold sellers, ten for Silver, fifteen for Bronze, per Flipkart's published terms. The settlement reference number on the report is the UTR in your bank narration.

Why is my Meesho payment less than the order value?

The payment report lists commission, shipping, RTO and compensation as separate columns, and wide-format reports state deductions as positive numbers. Signed correctly and matched per order, the difference is either a fee on the rate card or a claim.

Where to go next