Reconcile marketplace sales from the underlying invoices and credit/debit notes—not from the net payout. Match those records to your books, GSTR-1, the operator’s GSTR-8 and TCS details, and settlement statements. Keep ordinary supplier sales subject to section 52 TCS separate from specified services taxable under section 9(5); they follow different reporting paths.
What records should you reconcile?
For each tax period, build a bridge from the transactions behind the marketplace report to your GST returns and accounting records. A settlement is a cash movement after deductions; it is not, by itself, a measure of taxable sales.
- Marketplace records: order or sales export, returns and refund details, settlement or transaction statement, fee and tax invoices, TCS statement, and payout ledger.
- Your tax records: sales invoices, credit and debit notes, books, and filed or draft GSTR-1.
- Operator records: GSTR-8 and the related TCS information available through the GST Portal.
- Purchase-side records: GSTR-2B and books for a separate inward-supply and input-tax-credit check.
GSTR-1 reports a seller’s outward supplies, including invoice-level or summary details, relevant credit/debit notes, HSN/SAC summaries and supplies through e-commerce operators. The GST Portal describes GSTR-1 and its preparation routes at GST Portal: GSTR-1.
Separate section 52 TCS from section 9(5)
Do not assume that all sales through a marketplace use the same GST treatment. First determine which reporting route applies to each supply. The portal’s table 14 workflow distinguishes supplies where the operator is liable to collect TCS under section 52 from specified supplies where the operator is liable to pay tax under section 9(5). The applicable category depends on the supply, not simply on the platform used.
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Repair Windows errors before they cause bigger problemsFix Now →#1 Best Overall
Supplier-liable sales: section 52
For ordinary supplier sales where the operator collects TCS, report the underlying outward supplies in the applicable GSTR-1 tables. Table 14(a) is an ECO-wise summary of supplies whose liability has already been reported in GSTR-1 tables 4–10; it does not replace those entries. GST Portal guidance also says table 14(a) does not automatically populate taxable value or tax liability in GSTR-3B. See the GST Portal advisory on tables 14 and 15.
Specified operator-liable supplies: section 9(5)
Use the separate section 9(5) route only if the supply falls within a specified category. Table 14(b) is associated with GSTR-3B table 3.1.1(ii); follow the portal’s current instructions for the relevant period. The distinction and reporting relationship are described in the GST Portal advisory on tables 14 and 15 and its GSTR-3B table 3.1.1 advisory.
Build a period-by-period reconciliation
- Fix the scope. Record the GSTIN, tax period, marketplace or marketplaces, and whether you file monthly or quarterly. Keep each source export’s filename and download date so you can reproduce the reconciliation.
- Gather transaction evidence. Download the marketplace sales/order report, settlement statement, return/refund and adjustment details, fee and tax invoices, TCS statement and payout ledger. Gather the corresponding seller invoices and credit/debit notes.
- Create a transaction-level bridge. Use a spreadsheet or accounting system with fields such as order, settlement or invoice reference; invoice date and supply period; buyer GSTIN/status where relevant; place of supply; item or service; HSN/SAC and rate; taxable value and tax; returns or credit notes; platform deductions; TCS; and net payout. This is a practical control layout, not a government-prescribed spreadsheet.
- Classify the supplies. Mark each transaction as supplier-liable section 52 or a qualifying section 9(5) supply before summarising it for GSTR-1. Do not put a sale into the section 9(5) path solely because it occurred on a marketplace.
- Reconcile outward supplies to GSTR-1. Compare the transaction bridge with the invoices, notes and other outward-supply details reported in the return. Then check that the ECO-wise section 52 summary in table 14(a) agrees with the underlying sales already included in tables 4–10.
- Compare the operator’s data. Match the operator’s GSTR-8 information to your period, ECO GSTIN, supplies, returns/credit notes and place-of-supply treatment. CBIC describes GSTR-8 as covering supplies effected through the operator, returns through it and TCS collected; operator data is matched with supplier return data. See the CBIC e-commerce FAQs.
- Reconcile TCS as its own balance. Compare the operator’s TCS statement and portal credit with your books and tax account. CBIC guidance explains that TCS reported by the operator is made available to the supplier and can be used against the supplier’s tax liability subject to applicable rules. Do not treat TCS as payment of the seller’s entire output-tax liability.
- Close purchase-side ITC separately. Reconcile GSTR-2B to books for inward supplies, check for duplicate credit, consider required reversals and review reverse-charge items. GSTR-2B is not the marketplace statement for outward sales. See the GST Portal GSTR-2B FAQs.
- Resolve and document differences before filing. Trace each variance to a source document or a timing/classification explanation; retain the working papers and any correction or follow-up required.
Understand why the payout differs from sales
A platform payout may be reduced by fees, refunds, adjustments, TCS or other ledger entries. Rebuild the sales figure from supplies and their supporting invoices and notes, then reconcile fees and deductions separately to the platform’s statements and invoices. The correct treatment of an individual fee or adjustment depends on its underlying document and facts; there is no universal settlement-to-GST mapping established by the cited official guidance.
In practice, a useful bridge keeps at least three totals distinct: outward supplies and tax supported by invoices and notes; operator-reported TCS; and the net cash payout after settlement entries. Differences between those totals are not automatically errors, but each should be explainable from the source records.
Choose a preparation method that fits your records
| Method | What it offers | What to check |
|---|---|---|
| GST Portal entry | Direct official preparation and filing route. | Prepare and validate the marketplace-to-return mapping before entering it; manual work can be demanding with high transaction volume. |
| GST Portal offline tool | Official option for preparing return data in bulk. | Use the current tool and schema for the tax period being filed. |
| Third-party ASP application through a GSP | A portal-recognized preparation route. | Check platform import support, GSTIN and table mapping, adjustment handling, audit trail, exportability and service availability. The official route description is not an endorsement of a provider or confirmation of particular features. |
The GST Portal identifies portal entry, its offline tool and third-party ASP applications through GSPs as GSTR-1 preparation routes in its GSTR-1 guidance.
Investigate common mismatches systematically
- Period mismatch: Compare invoice and supply dates with the tax period used in your return and the period shown by the operator.
- Missing or amended invoice: Trace the marketplace reference to the seller’s invoice and any amendment or note.
- Returns and credit notes: Check whether the return/refund appears in the platform report and whether its tax treatment is supported by the required records.
- Place-of-supply or state mismatch: Compare invoice details with operator records, since place of supply is relevant to matching.
- B2B/B2C classification: Verify buyer details and return classification instead of relying on a marketplace summary alone.
- Duplicate imports: Check whether overlapping sales, settlement or adjustment exports were imported twice.
- Wrong ECO route: Review whether a supply was incorrectly classified as section 9(5) rather than section 52, or vice versa.
- TCS not matching: Compare the operator statement, GSTR-8/portal credit and seller’s account records for the same GSTIN and period.
Check dates and rates against the filing period
The GST Portal advisory on tables 14 and 15 says those tables became available from January 2024 tax periods, with amendment tables from February 2024. Portal labels and workflows can change, so use the current filing-period instructions rather than relying on an old screenshot or table guide.
The 53rd GST Council meeting material recorded a recommendation for a 0.5% TCS rate (0.25% CGST plus 0.25% SGST/UTGST, or 0.5% IGST). That is a dated Council recommendation, not proof of the operative rate for every transaction or tax period. Verify the effective notification and the applicable period before using a rate in a calculation. See the 53rd GST Council meeting material.
Quick Recap
Best Value
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
