Glossary · Accounting & Bookkeeping
Marketplace Settlement Reconciliation
Definition
Marketplace settlement reconciliation is the matching of the payout an e-commerce platform sends a seller with the orders behind it. Each deduction, such as commission, shipping fees, returns, GST TCS and income-tax TDS, is checked and posted to its own ledger. The net figure is then agreed to the amount credited in the bank.
At a glance
- Category
- Accounting & Bookkeeping
- In this entry
- What it means for Indian online sellers How it works · Example
In practice
01 What it means for Indian online sellers
When a customer buys on a marketplace, the platform collects the money and later pays the seller a net amount. That payout never equals the invoice value, because many charges are taken out first. Reconciliation takes the payout apart and confirms the seller was paid what it was owed.
It is a three-way match: the seller's sales register, the platform's settlement report and the bank credit. A payout can agree with the bank and still hide a wrong commission or a missing return credit. Ordinary bank reconciliation, which only matches the books with the bank statement, would not catch that.
| Usual deduction | Where it goes in the books |
|---|---|
| Commission, closing and fixed fees, shipping, ads | Selling expenses (GST on these fees is input tax credit if eligible) |
| Customer returns and RTO (undelivered orders) | Reversed from sales |
| GST TCS under section 52 of the CGST Act: 0.5% of net taxable value (0.25% CGST + 0.25% SGST, or 0.5% IGST) from 10 July 2024 | Credit in the seller's electronic cash ledger once the platform files GSTR-8 |
| Income-tax TDS on e-commerce sales: 0.1% from 1 October 2024 | Tax credit for the seller. Section 194-O of the 1961 Act for FY 2025-26 and earlier; from tax year 2026-27, the corresponding provision of the 2025 Act (Table, serial 8(v)): 0.1% of the gross amount of sales |
How it works
02 How it works
- Download the settlement report
For the cycle.
- Match orders to the sales register
So gross sales are complete.
- Check fees against the agreed rate card
And flag overcharges.
- Confirm returns, TCS and TDS
Match TCS to the platform's GSTR-8.
- Agree the net payout to the bank
And post each element to its ledger.
Worked example
03 Example
An example, not advice on your facts.
A fashion seller in Delhi receives one weekly settlement.
| Particulars | Amount (₹) | Treatment |
|---|---|---|
| Gross sales | 6,00,000 | Sales |
| Less: commission and fees | 1,20,000 | Selling expenses |
| Less: returns credited | 50,000 | Reversed from sales |
| Less: GST TCS (0.5% of ₹5,50,000) | 2,750 | GST cash ledger credit |
| Less: TDS (0.1% of ₹5,50,000) | 550 | Income-tax credit |
| Net payout to bank | 4,26,700 | Agreed to the bank credit |
Checking the commission against the rate card shows a ₹6,000 overcharge, which the seller claims back from the platform.
Watch out
04 Common mistakes
- Recording only the bank credit as sales, which hides commission, fees and returns.
- Trusting the platform's fee deductions without checking the rate card.
- Not confirming that each return was credited back.
- Not matching TCS with GSTR-8, so the cash ledger credit is missed.
Need help with marketplace settlement reconciliation? See our E-commerce Accounting Services or Accounts Reconciliation.
