OneBooks GST imports marketplace sales data from Amazon, Flipkart, Meesho, Myntra, AJIO, and JioMart, plus Excel/CSV for any other channel, and uses that data to prepare GSTR-1 sections such as B2B, B2C, credit/debit notes, and the HSN summary. For each marketplace, a seller generally needs to collect five kinds of reports before GSTR-1 preparation: the sales report, returns/cancellations data, tax breakup, settlement report, and TCS (Tax Collected at Source) details. This article maps out what to gather from each marketplace and how it feeds GSTR-1 filing.
What Is GSTR-1 Marketplace Reconciliation?
Marketplace reconciliation for GSTR-1 is the process of matching every order, return, cancellation, and TCS deduction reported by an online marketplace against what a seller declares in their GST return, so that outward supply values and tax collected line up correctly. Because marketplaces settle payments in batches, deduct TCS, and report returns separately from original sales, this reconciliation step is what prevents GSTR-1 values from silently drifting away from what actually happened on the marketplace.
Which Marketplaces Does OneBooks GST Import Sales From?
OneBooks GST currently imports sales data from Amazon, Flipkart, Meesho, Myntra, AJIO, and JioMart, and accepts a manual Excel/CSV upload for any marketplace or sales channel that doesn't have a direct import path yet. Imports happen through the "Admin > Upload Files" workflow, and the underlying reports are used to build GSTR-1 sections under "Admin > GSTR-1 Details".
What Must You Collect From Each Marketplace for GSTR-1?
Report names, file formats, and download locations differ across marketplace seller portals and change without notice, so the table below describes report types generically rather than exact filenames or column headers. Confirm the current report names and locations in each seller portal before relying on them.
| Marketplace | Sales report | Returns / cancellations | Tax breakup | Settlement report | TCS details |
|---|---|---|---|---|---|
| Amazon | Order/sales report from Seller Central | Return and refund report | Tax invoice/breakup report | Settlement/payment report | TCS/TDS report section |
| Flipkart | Order report from Seller Hub | Return and cancellation report | Tax invoice summary | Payment/settlement report | TCS report section |
| Meesho | Order report from Supplier Panel | Return/RTO report | Tax summary report | Payment report | TCS report section |
| Myntra | Order report from partner portal | Return report | Tax summary report | Payment/settlement report | TCS report section |
| AJIO | Order report from seller portal | Return report | Tax summary report | Payment/settlement report | TCS report section |
| JioMart | Order report from seller portal | Return report | Tax summary report | Payment/settlement report | TCS report section |
| Excel/CSV (other channels) | Manually compiled sales list | Manually compiled returns list | Manually compiled tax breakup | Bank credit or payout record | Manually noted TCS, if applicable |
Exact report names change as marketplaces update their seller portals. Always confirm the current report name and download path directly in the marketplace's own seller dashboard rather than assuming last period's name still applies.
Why Do You Need All Five Report Types, Not Just the Sales Report?
The sales report alone overstates outward supply value if returns and cancellations aren't subtracted, and understates it if the tax breakup shows values the sales report doesn't split out cleanly. The settlement report matters separately because it shows what was actually paid out after marketplace commissions, shipping fees, and TCS deductions, which is not the same figure as gross sales. TCS details matter because sellers are required to reconcile the TCS a marketplace has collected on their behalf against the credit they can claim; missing this reconciliation is a common source of mismatches between a seller's books and the GST portal's auto-populated data.
How Does TCS Reporting Work Across Marketplaces?
Under GST, e-commerce operators are generally required to collect TCS on the net value of taxable supplies made through their platform and report it, which sellers can then claim as credit. The exact TCS rate and reporting mechanics are set by GST law and can change, so verify the current TCS rate and reporting rules on the official GST portal at www.gst.gov.in rather than relying on a fixed figure here. Each marketplace listed above reports TCS collected in its own format, which is why a dedicated TCS reconciliation step, rather than assuming it matches the sales report, is necessary before filing.
How Does OneBooks GST Use These Marketplace Reports?
Once sales, returns, tax breakup, settlement, and TCS data are uploaded for Amazon, Flipkart, Meesho, Myntra, AJIO, or JioMart (or entered via Excel/CSV), OneBooks GST maps that data into GSTR-1 sections: B2B supplies, B2C supplies, credit and debit notes for returns, and the HSN summary, with validation warnings raised for gaps or mismatches before filing. This means a seller uploading marketplace reports each period doesn't need to manually total sales values, subtract returns, or separately track TCS; the platform consolidates that into the return. See GSTR-1 automation for more on how this preparation step works, and the GST calculator for checking rate and tax-breakup figures independently.
What If a Marketplace Report Doesn't Match Your Books?
Mismatches between a marketplace's reported sales and a seller's own records are common, usually due to timing differences (an order placed in one period, settled in the next), returns processed after the original filing, or TCS credited in a later settlement cycle. When OneBooks GST surfaces a validation warning during GSTR-1 preparation, the practical fix is to re-download the relevant report from the marketplace's seller portal for the exact date range in question and re-check it against the settlement report, rather than editing the GSTR-1 figures without a source document. For businesses managing GSTINs across several states or entities, this same reconciliation applies per GSTIN, and multi-GSTIN handling in OneBooks GST keeps each registration's marketplace data and returns separate.
How Often Should Marketplace Data Be Reconciled?
Most sellers reconcile marketplace reports on the same cycle as their GSTR-1 filing period, typically monthly, since that keeps the volume of orders, returns, and settlements manageable and limits how far back a mismatch has to be traced. Waiting until the filing deadline to download every report for the period increases the risk of a seller portal report window closing or a report format changing before it's collected. A monthly rhythm of downloading the sales, returns, tax breakup, settlement, and TCS reports from each active marketplace, then uploading them into OneBooks GST, keeps the GSTR-1 validation warnings limited to genuine discrepancies rather than backlog.
What About Sellers on More Than One Marketplace?
A seller active on several marketplaces, for example Amazon and Meesho together, still needs to collect all five report types separately from each platform, since sales, returns, tax breakup, settlement, and TCS reporting are not shared or consolidated across marketplaces. Amazon's TCS report does not account for Meesho's TCS deduction, and a return processed on Flipkart has no bearing on Myntra's figures. Because GSTR-1 automation in OneBooks GST is built to accept imports from Amazon, Flipkart, Meesho, Myntra, AJIO, and JioMart individually, each marketplace's reports can be uploaded as they become available rather than waiting for every channel to be ready before starting reconciliation for the period.
Frequently Asked Questions
Which marketplaces does OneBooks GST support for GSTR-1 filing?
OneBooks GST imports sales data from Amazon, Flipkart, Meesho, Myntra, AJIO, and JioMart, and accepts Excel/CSV uploads for any other sales channel.
What reports do I need to collect from each marketplace before filing GSTR-1?
You generally need five report types from each marketplace: the sales report, returns/cancellations report, tax breakup, settlement report, and TCS details, since each captures a different part of what GSTR-1 requires.
Why isn't the sales report alone enough for GSTR-1?
The sales report alone doesn't account for returns, cancellations, or TCS deductions, so relying on it alone can overstate or misstate outward supply values compared to what actually settled.
Does OneBooks GST tell me the exact report file names to download from each marketplace?
No. Report names and download locations in marketplace seller portals change over time, so you should confirm the current report name and location directly in each marketplace's seller dashboard before uploading it to OneBooks GST.
How does TCS affect marketplace GST filing?
Marketplaces are generally required to collect TCS on taxable supplies made through their platform, which sellers can claim as credit; the current TCS rate and rules should be verified on the official GST portal at www.gst.gov.in since they can change.
What happens if my marketplace data doesn't match my books?
Mismatches are usually caused by timing differences, late-processed returns, or delayed TCS settlement; the practical fix is re-downloading the relevant marketplace report for the exact period and reconciling it against the settlement report rather than editing return figures without a source document.
