Recommended Free Tools
Reconcile marketplace sales to invoices and outward-supply records—not to the net payout. A settlement is a cash figure after refunds, fees, other adjustments and timing differences; it is not automatically the taxable sales figure for GSTR-1. Keep the sales, settlement and GST TCS checks separate, then connect them with a documented reconciliation.
Why marketplace payouts and GSTR-1 sales do not match
GSTR-1 reports outward supplies, while a marketplace settlement explains cash paid to you. They answer different questions. The settlement may reflect customer collections after refunds, chargebacks or reserves, marketplace charges, taxes collected or withheld, and payment timing. GSTR-1 is built from supply and invoice records, with separate reporting for different types of supplies and adjustments.
For that reason, neither the payout amount nor the marketplace’s headline sales total should be copied into the return without checking its underlying transactions and reporting basis. A payout can be lower than the related sales because of deductions, or fall in a different period because of settlement timing.
| Record | What it helps establish | What it does not establish by itself |
|---|---|---|
| Order and invoice register | Underlying sales, invoice details, buyer type and supply classification | The cash actually paid out by the marketplace |
| Returns, cancellations and credit/debit notes | Which sales were reversed or adjusted, and the records supporting the change | That a refund’s cash date is also the correct supply-reporting period |
| Settlement statement | How customer collections were adjusted to arrive at a payout | The taxable outward-supply total for GSTR-1 |
| Marketplace fee and tax invoices | The basis for commissions and other marketplace charges | That those charges reduce the value of your sales |
| Operator TCS statement and electronic cash ledger | TCS reported by the operator and credit posted to the supplier’s ledger | That every amount shown in a marketplace report has already been credited |
The GST Portal describes GSTR-1 as the outward-supplies statement for normal and casual registered taxpayers. It covers invoice-level details, consumer-supply summaries, credit and debit notes, advances and adjustments, amendments, nil-rated, exempt and non-GST supplies, HSN/SAC summaries, and supplies through ecommerce operators. See the GST Portal’s GSTR-1 guide for the applicable reporting categories.
#1 Best Overall
How to reconcile marketplace settlement reports with GST returns
Use one defined accounting period and retain the source files that support each step. Marketplace report names and cutoff dates vary; use the seller’s current marketplace documentation to identify what each export includes.
- Gather period-matched records. Collect the marketplace order or sales report, seller invoice register, returns and cancellation records, credit/debit notes, settlement statements, fee and tax invoices, and the GST return data for the period. Note each report’s date range and whether its dates reflect order, dispatch, invoice, refund or settlement activity.
- Match orders to invoices. Link each relevant order to its invoice and supporting fulfilment or dispatch evidence, as appropriate to your records. Classify supplies as taxable, exempt or otherwise reportable, and distinguish registered-buyer invoices from consumer sales because GSTR-1 requests different levels of detail.
- Record reversals and amendments against the original sale. Match cancellations and returns to the related order and invoice. Record the relevant credit/debit note or amendment rather than overwriting the original transaction with a later cash refund. A refund paid in one month can relate to a sale in another; the transaction and return record should preserve that history.
- Reconcile marketplace charges separately. Tie commissions, fulfilment or shipping charges, advertising, penalties and other deductions to the marketplace’s own records or invoices. Do not treat a deduction as a reduction in sales unless the underlying documents and applicable accounting and tax treatment support that result.
- Build a cash bridge for each payout. Start with the collections represented in the settlement period, then account for refunds, chargebacks or reserves where applicable, marketplace deductions, taxes collected or withheld, and timing differences. The bridge explains the cash movement; it is an accounting workflow, not a universal settlement format prescribed by GST rules.
- Map the invoice register to GSTR-1. Report each transaction in the applicable outward-supply category, including the relevant invoice, consumer, note, amendment or supply summary. Keep the ecommerce operator disclosures distinct from the underlying sales mapping.
- Reconcile TCS reporting and credit. Compare the marketplace’s TCS statement with the relevant ecommerce disclosure and the credit in the supplier’s electronic cash ledger. Record timing differences and carry them forward for follow-up rather than forcing the figures to match.
- Save the audit trail. Retain source exports, mapping rules, exception lists, return summaries, filed-return acknowledgements and explanations for period differences. This helps support amendments and later-period reconciliations.
How to report ecommerce supplies in GSTR-1
The GST Portal’s GSTR-1 workflow includes ecommerce supplies where an operator is liable to collect TCS under section 52 and supplies where the operator pays tax under section 9(5). The portal guide places these disclosures in table 14, with separate workflows for the two categories. Its fields include the operator’s GSTIN, net supply values and applicable integrated, central, state/UT tax and cess amounts.
The portal guide also notes that table 14 values are not included in the consolidated total-liability calculation for outward supplies other than reverse charge. Check the live portal guidance and return interface for the tax period you are filing, because portal details can change. GSTR-1 can be prepared through online entry, the GST Portal’s Returns Offline Tool, or third-party applications through GST Suvidha Providers, as described in the portal’s GSTR-1 guide. The portal guide to creating GSTR-1 explains the table workflow.
| GSTR-1 ecommerce category | What to check |
|---|---|
| Section 52 | Supplies for which the ecommerce operator is liable to collect TCS; use the operator GSTIN, net supply values and applicable tax amounts requested by the portal. |
| Section 9(5) | Supplies for which the ecommerce operator pays tax; use the separate portal workflow and do not confuse these with section 52 TCS supplies. |
What section 52 TCS means for the reconciliation
Section 52 TCS is not the same thing as marketplace fees or the seller’s outward-supply liability. CBIC explains that the ecommerce operator collects TCS where it collects consideration for taxable supplies made through it. The operator reports supplies and TCS through GSTR-8, and the supplier’s credit is reflected in the electronic cash ledger.
Free tools Windows power users keep installed
One-click scans. No signup required.
CBIC describes the section 52 base as the month’s net value of taxable supplies through the operator, reduced by taxable supplies returned during that month. Services on which the operator pays the entire tax under section 9(5) are excluded from that definition. Because return dates and sales-report periods can differ, a TCS figure and a sales figure need not align month for month. The CBIC Sectoral FAQs on ecommerce and section 52 explain this calculation and reporting mechanism.
Do not rely on an older FAQ’s displayed TCS rate as the rate for a current transaction period. The applicable rate and effective date must be verified against the operative Gazette notification for that period; the GST Council material at the 53rd GST Council Meeting discusses a proposed reduction, but does not by itself establish the current operative rate.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.How to handle TCS timing differences and multiple operators
A marketplace TCS statement is not proof that the supplier’s cash-ledger credit has already posted. GST Council material explains that credit follows the operator’s filing of GSTR-8 and payment to the government. If the marketplace’s statement, your disclosure and the electronic cash ledger differ, first check filing and payment status and period cutoffs; then investigate any continuing value difference.
When more than one ecommerce operator participates in a transaction, do not assume which one is responsible for TCS from the payout alone. CBIC says each transaction must be examined separately under section 52. The GST Council identifies Circular 194/06/2023-GST, dated 17 July 2023, for this issue. Keep the transaction structure and operator records with the reconciliation.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Common reconciliation errors to avoid
- Using net payout as the taxable sales total.
- Netting commissions or other marketplace deductions against sales without checking their supporting documents and tax treatment.
- Omitting returns, credit/debit notes, amendments or differences caused by period cutoffs.
- Combining section 52 TCS supplies with section 9(5) supplies.
- Assuming TCS has reached the supplier’s cash ledger before the operator has filed GSTR-8 and paid it.
- Applying a rate from an older FAQ without confirming the notification and effective period that govern the transaction.
Choosing a reconciliation method
A spreadsheet, accounting system or GST return-preparation tool can support the process if it preserves the underlying transaction trail. The GST Portal permits online entry, offline-tool preparation and third-party applications through GSPs; that does not establish that any particular product supports a seller’s marketplace exports. Assess a method against the seller’s actual records rather than its label.
- Can it import the seller’s current order and settlement formats?
- Does it preserve invoice-level links to orders, returns and credit notes?
- Can it map the applicable GSTR-1 ecommerce disclosures?
- Does it distinguish deductions from sales values and track settlement timing?
- Can it reconcile operator TCS statements to electronic cash-ledger credits?
- Can it export a usable audit trail for the relevant tax periods?
Marketplace export fields, portal screens, tax rules and the seller’s filing obligations can vary or change. This workflow explains the reconciliation, but the correct filing treatment still depends on facts such as registration and filing frequency, product classification, place of supply, and the transaction documents.
Quick Recap
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.
