GSTR for CA portal
GSTR-1 for E-commerce Seller Clients: A CA's Guide to Amazon, Flipkart, Meesho Reports
Online sellers are some of the most demanding GST clients. Sales come from several marketplaces, each with its own report format, thousands of small B2C orders, frequent returns, and TCS collected by the e-commerce operator. A clean GSTR-1 depends on getting the right reports and reading them the same way every month.
This guide lists the reports to request from each marketplace and the points that cause most mismatches.
Reports to ask your client for
- Amazon – MTR B2C and MTR B2B (Reports → Tax Document Library). ZIP files are fine.
- Flipkart – the monthly Sales Report (with the Cash Back sheet), or the "Report for GSTR-1 and GSTR-8".
- Meesho – tcs_sales and tcs_sales_return from the GST report download.
- Myntra – TCS/TDS Packed, RT (return) and RTO reports.
- AJIO dropship – DropShip GST report and DropShip RTV report.
- Own website or offline sales – an invoice register in a simple B2B / B2C template.
Place of supply and B2CS
B2C sales are reported in Table 7 (B2CS) grouped by place of supply and rate. Use the customer's shipping state from the report. Where the seller and buyer are in the same state, report CGST + SGST; otherwise IGST. Group on the tax actually charged in the report so the return matches the marketplace's own TCS data.
Returns, RTO and cashback
Customer returns and RTOs reduce B2C sales in the month they are reported – net them in B2CS rather than raising separate credit notes for unregistered buyers. Flipkart cashback and similar adjustments change the taxable value; include them with the related orders. Credit notes to registered buyers (B2B) go to Table 9B (CDNR).
B2B sales on marketplaces
Amazon Business and some Flipkart orders carry the buyer's GSTIN. These are B2B invoices for Table 4 so the buyer can claim ITC. Check the GSTIN format and checksum; an invalid buyer GSTIN should be moved to B2C.
HSN summary and documents issued
Table 12 now has separate B2B and B2C HSN summaries, and HSN codes are chosen from the portal list. Marketplace reports often carry HSN; where they do not, map each product or style to a code. Table 13 (documents issued) should list each invoice and credit note series from each marketplace. More in our Table 12 guide.
Table 14: supplies through e-commerce operators
Supplies made through operators who collect TCS under section 52 are also reported in Table 14 against the operator's GSTIN. This lets the portal match your client's sales with the operator's GSTR-8. Details in GSTR-1 Table 14 explained.
Do it in minutes
In the GSTR for CA portal, open GSTR-1 preparation for the client and month, drop all the marketplace files together and build the report. You get B2B, B2CS, CDNR, HSN (B2B and B2C), documents and Table 14 as Excel workings and as GST JSON, and you can save the working against the client so the tracker shows it as prepared.
Frequently asked questions
Should I use the Flipkart sales report or the GSTR-1 report?
Either works. The sales report has more detail (cashback, SKUs); the GSTR-1 report is useful for cross-checking and the operator GSTIN.
Are the report files uploaded to your server?
No. They are read in your browser. Only the summary you choose to save is stored for the client.
How are RTOs treated?
They reverse the original sale and reduce B2C taxable value for the period they are reported in.
Can I add sales from the client's own website?
Yes. Fill the B2B / B2C template and upload it with the marketplace files.