Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →
A seller downloads a marketplace settlement report but cannot read the columns or tie the total to the bank credit.
Read the report as sales minus deductions equals payout; map each column to its external evidence and tie the net total to one bank credit by reference and amount.
The weekly settlement report, the monthly fee invoice, GSTR-2B, the TDS credit statement, the GST TCS credit view and the bank statement.
A tied-out report where the net payable equals the bank credit and each fee, tax and adjustment column agrees to its own source document.
A marketplace settlement report is the itemised statement of every order, fee, tax and adjustment behind one bank credit. Read it as one sum: sales minus deductions equals payout. Each column also appears in another document, such as the fee invoice, your GSTR-2B or your TDS credit statement, which is how you check it.
What do the common columns mean?
Column names differ between marketplaces, but most reports contain these:
- Order ID: the marketplace’s order number. Your main match key.
- SKU: your product code.
- Selling price: what the customer paid for the item.
- Commission or referral fee: the marketplace’s percentage fee.
- Fixed or closing fee: a flat per-order fee.
- Shipping fee: the delivery charge, often by weight slab.
- Collection fee: a fee for collecting payment, where charged.
- GST on fees: GST on the marketplace’s own services, typically 18 percent.
- TCS: GST collected under Section 52 of the CGST Act, 0.5 percent of net taxable value from 10 July 2024.
- TDS: income tax deducted at 0.1 percent of gross sales under Section 194O from 1 October 2024 (Section 393 of the Income-tax Act 2025 from 1 April 2026).
- Return adjustment: reversal of an earlier sale.
- Net payable: what the marketplace will pay you for the row.
Where does each figure show up elsewhere?
| Column | What it means | Where to check it |
|---|---|---|
| Selling price | Gross sale value | Your sales invoice and GSTR-1 |
| Commission and fees | Marketplace charges | Monthly fee tax invoice |
| GST on fees | Tax on those charges | Your GSTR-2B |
| TCS | GST collected by operator | GST portal TCS credit view, then electronic cash ledger |
| TDS | Income tax deducted | Form 26AS, or Form 168 from tax year 2026-27 |
| Return adjustment | Reversed sale | Your returns register and stock |
| Net payable total | The payout | Bank statement |
If a column does not agree with its source, that is your first question for the marketplace.
How do I tie one weekly report to one bank credit?
- Add up the net payable column for the cycle.
- Find the bank credit with the same amount and the payout reference or UTR shown in the report.
- If they differ, look for a carried-forward balance, a reserve or a split payment.
- Spot-check three orders end to end: a delivered one, a returned one and a cancelled one.
- Save the report with the bank entry so the audit trail is complete.
A worked example
A weekly report has three orders. Fees are illustrative.
| Column | Order A (delivered) | Order B (returned earlier sale) | Order C (cancelled) |
|---|---|---|---|
| Selling price | ₹22,000 | minus ₹2,000 | ₹0 |
| Commission | ₹2,200 | ₹0 | ₹0 |
| Fixed and shipping fees | ₹600 | ₹200 reverse shipping | ₹0 |
| GST on fees at 18 percent | ₹504 | ₹36 | ₹0 |
| TCS at 0.5 percent | ₹100 on ₹20,000 taxable | minus ₹10 | ₹0 |
| TDS at 0.1 percent | ₹20 on ₹20,000 | ₹0 | ₹0 |
| Net payable | ₹18,576 | minus ₹2,226 | ₹0 |
Order A: ₹22,000 − ₹2,200 − ₹600 − ₹504 − ₹100 − ₹20 = ₹18,576.
Order B: minus ₹2,000 − ₹200 − ₹36 + ₹10 = minus ₹2,226. The TCS on the returned sale comes back, so it is added.
Adding a ₹2,290 release of an amount held from an earlier cycle (shown as its own adjustment row), the weekly total is ₹18,576 − ₹2,226 + ₹0 + ₹2,290 = ₹18,640, which matches the bank credit.
Order A’s ₹22,000 includes GST, with GST shown separately, so TCS and, in this illustration, TDS are worked out on its ₹20,000 taxable value.
Why archive every report?
The reports are your evidence for input tax credit on fees, for TDS and TCS credits, and for every return you booked. Marketplaces may limit how far back you can download, so save each one the week it arrives, named by cycle date.
What to read next
Download and archive each report as you go, then learn how to record a marketplace settlement in your books. For a hands-on method try the settlement decomposition recipe in Google Sheets, and see Amazon Pay settlement reconciliation. Marketplace settlement reconciliation is on the roadmap for Terra Insight’s payment gateway reconciliation work.
Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →