Settlement reconciliation, explained properly
Last reviewed·ReconPe Editorial
Settlement reconciliation is the process of verifying that the money a marketplace, payment gateway, or bank actually paid you matches what they should have paid — by matching their settlement report against your own records and your bank statement. Done every cycle, it answers two questions: did every sale get paid, and were the deductions correct? This guide covers how settlement works, what’s inside a settlement report, the breaks you’ll actually encounter and how to resolve them — with the Indian marketplace and gateway specifics most guides skip.
Settlement vs clearing vs reconciliation
Three words that get used interchangeably and shouldn’t be. The short version: settlement is money moving, clearing is the routing before it, and reconciliation is you checking the result.
| Settlement | Clearing | Reconciliation | |
|---|---|---|---|
| What it is | Funds actually moving between parties | The plumbing that routes and nets instructions between banks | Verifying that what settled matches what should have settled |
| Who does it | The marketplace, gateway, or bank | Payment networks and clearing houses | You — the seller or finance team |
| When it happens | On a cycle: T+1 to T+15 by rail | Before settlement | After the money lands (or doesn't) |
| Output | A bank credit + a settlement report | Net positions | Matched records + a list of breaks to work |
One order, end to end
Illustrative, with round numbers — a ₹2,499 prepaid marketplace order, from sale to the rupees that actually land. Your category rate card decides the real percentages; the shape is universal.
- Order value (buyer pays)
- ₹2,499.00
- Commission (illustrative 15%)
- − ₹374.85
- Fixed + collection fees
- − ₹55.00
- Shipping fee
- − ₹80.00
- GST on the fees above (18%) — your input credit
- − ₹91.77
- TCS, GST Sec 52 (0.5% of taxable value)
- − ₹12.50
- TDS, Sec 194-O (0.1%)
- − ₹2.50
- Net for this order
- ₹1,882.38
That net doesn’t arrive alone: it’s batched with every other order of the cycle — plus fee rebates, ads charges, storage deductions, and prior-cycle reversals — into one bank NEFT on a T+7 to T+15 cycle. Reconciliation happens at both levels: per order (were the fees right?) and per payout (did the batch tie to the bank?). And the three tax lines above aren’t costs — the fee-GST is claimable input credit and the TCS/TDS are recoverable — but only if your reconciliation separates them instead of lumping them into "deductions".
Settlement cycles: when the money actually comes
Most "missing money" is timing. Knowing each rail’s normal cycle is what separates a break worth investigating from a payment that’s simply not due yet.
| Rail | Typical cycle | What the payout looks like |
|---|---|---|
| Marketplaces (Amazon, Flipkart, Meesho) | T+7 to T+15 from dispatch/delivery, by seller tier | One NEFT nets orders, fees, rebates, ads and tax lines for the cycle |
| Payment gateways (Razorpay etc.) | T+1 to T+3 from capture | Payout batches keyed by UTR; MDR deducted per transaction |
| COD remittance | Courier-dependent; delivered-to-remitted normally runs T+2 to T+7 | Cash collected by the courier, remitted in batches |
| Bank / PSP settlement | Same-day to T+1 | Statement credit is the final truth everything must tie to |
Anatomy of a settlement report
Every marketplace formats it differently — Amazon as an event stream, Flipkart as a multi-sheet workbook — but the money always decomposes into the same lines:
| Line | What it means for you |
|---|---|
| Gross / order value | What the buyer paid — the starting number every deduction hangs off |
| Commission | The marketplace's cut, set by your category rate card — the single most common variance source |
| Fixed / collection / shipping fees | Per-order charges, each on its own slab; some marketplaces split them into separate columns, some into separate sheets |
| GST on fees | 18% GST charged on the fees themselves — this is YOUR input credit to claim, not a cost to swallow |
| TCS (GST Sec 52, 0.5%) | Tax collected at source on the sale value — recoverable as GST credit via GSTR-2B/8 |
| TDS (Sec 194-O, 0.1%) | Income-tax deduction by the marketplace — must appear in your 26AS to be claimed |
| Adjustments / reversals | Returns, claims, and corrections — often landing in a later cycle than the sale they adjust |
| Net payable | What actually hits the bank — per cycle, not per order |
The three kinds of settlement reconciliation
Same discipline, different file dialects. ReconPe covers each with a dedicated guide and native format support:
Marketplace settlement reconciliation
Settlement report ↔ bank credit, with per-order fee audit. Each marketplace has its own file dialect:
Payment gateway reconciliation
Payout batches matched to bank credits by UTR, with MDR variance checked per transaction:
Bank, ledger, and the close
The same discipline applied to books: sub-ledger to GL tie-outs and the month-end close:
The breaks you’ll actually see, and what they mean
Six patterns cover most of what a settlement reconciliation surfaces. The skill is reading the cause from the shape of the break:
| Break | Usual cause | Resolution |
|---|---|---|
| Credit missing entirely | Cycle timing — the sale settled into a later cycle, or COD hasn't been remitted yet | Age it against the expected cycle before treating it as missing money; escalate only past the cycle norm |
| Payout lower than expected | Fees higher than rate card, an adjustment netted in, or a reversal from a prior cycle | Decompose the payout: per-order fee audit against the rate card, then trace adjustment lines to their original orders |
| One credit, many orders | Marketplaces settle in batches — hundreds of orders per NEFT | Aggregate order-level expectations to the payout level before matching against the bank |
| Two credits, one period | Split settlements — part of an invoice period pays out across two cycles | Match across the full period window, not day-by-day |
| Amounts off by paise | Per-line rounding vs bank-recorded totals | A small tolerance band (rupees, not percentages) absorbs rounding without hiding real variance |
| Refund arrived, deduction unclear | Return or claim netted against a later settlement without an obvious link | Trace reversals to original orders by order ID + SKU; distinguish customer returns from courier/logistics returns |
What reconciliation actually recovers: fee leakage
The quiet payoff isn’t finding missing payouts — those announce themselves. It’s the per-order variances that don’t: commission charged at 15% when your category slab says 12%, a premium-service fee on an order that didn’t qualify, shipping billed on a reclassified weight. Each is small; across thousands of orders a month they compound into real money — and marketplace dispute windows are finite, so leakage found late is leakage kept. This is why per-order fee audit against your contracted rate card is part of reconciliation, not a separate exercise: ReconPe checks every order’s commission and fees against the rate card you upload and flags the variance with the exact rupee impact.
Manual vs automated: an honest comparison
A spreadsheet is genuinely fine at low volume — under a few hundred orders a month, one marketplace, no COD, a VLOOKUP against the bank statement works. It stops being fine when payouts batch hundreds of orders into one credit, fees split across sheets, returns net against later cycles, and the person who built the spreadsheet goes on leave. The mechanical work — parsing formats, aggregating orders to payouts, matching with tolerances, checking fees per order — is what software should do; the judgement — approving write-offs, disputing fees, deciding what a break means — is what your team should keep. That split is exactly how ReconPe divides the work: AI agents do the first pass, the deterministic ACRE engine scores every match 0–100, and humans review, approve, and close.
Frequently asked
What is settlement reconciliation?
Settlement reconciliation is the process of verifying that the money a marketplace, payment gateway, or bank actually paid you matches what they should have paid you — by matching the settlement report (their account of orders, fees, taxes, and adjustments) against your own records and your bank statement. It answers two questions every cycle: did every sale get paid, and were the deductions correct?
What is the difference between settlement and reconciliation?
Settlement is the counterparty's action — funds moving to your bank on a cycle, documented by a settlement report. Reconciliation is your action — verifying that settlement against your own data. Settlement happens whether or not you check it; reconciliation is how you find the short payments, wrong fees, and missing remittances inside it.
How do you reconcile a settlement report with a bank statement?
Aggregate the settlement report's order-level rows into the expected payout (marketplaces pay in batches, not per order), then match that expected credit to the bank statement line — usually by UTR and amount within a small rounding tolerance. Anything unmatched is either a timing difference (the cycle hasn't paid yet) or a genuine break to investigate. Order-level fee verification happens inside the report, against your rate card.
Why is my bank credit less than my settlement report total?
Usually one of three reasons: non-order charges (ads, storage, subscription fees) netted into the same payout; reversals or claim adjustments from earlier cycles deducted this cycle; or the report you're reading covers a different window than the payout. Decomposing the payout into its component sheets or line types answers it — which is why reconciling only the orders list makes every payout look short.
How often should settlement reconciliation be done?
Every settlement cycle — which in practice means weekly for most marketplace sellers and daily for gateway-heavy businesses. The dispute windows for wrong fees are finite, COD remittance issues age badly, and a month-end-only reconciliation regularly discovers problems after the window to recover them has closed.
What is a reconciliation break?
A break (or exception) is any record that fails to match: a sale with no corresponding payout, a payout with no matching sale, or a pair that matches on identity but disagrees on amount. Good reconciliation practice classifies breaks by type and severity, assigns an owner, and tracks each to resolution — because a break is a question about money, and unanswered questions compound.
Can settlement reconciliation be automated?
Yes — the mechanical parts are exactly what software does well: parsing marketplace file formats, aggregating orders to payouts, matching against bank credits with tolerances, and auditing fees against a rate card per order. The judgement parts — approving write-offs, disputing fees, deciding what a genuine break means — stay human. ReconPe automates the first pass and routes the judgement calls to your team with the evidence attached.
Reconcile your next settlement in minutes
Upload a settlement report and a bank statement — the free plan includes 5 reconciliations plus 3 GST reconciliations, no credit card required.
Start free