apriltax blog
4.9 on Google reviewsWorks with reports from AmazonFlipkartMeesho✓Fixed fees, shown before you start✓Written by Chartered Accountants
GST for online sellers

Flipkart Seller GSTR-1 Filing: From Sales Report to JSON, Step by Step

✓ 5 official and published sources✓ Written for Indian sellers and small businesses

For Flipkart GSTR-1 filing, request the Sales Report under Tax Report in Seller Hub for your period. Report consumer sales, less returns, state-wise in Table 7, any GSTIN buyers in Table 4, then complete Tables 12, 13 and 14. Turn that into a JSON file, upload it on the GST portal and file by the 11th or 13th.

Key points
  • The Flipkart Sales Report lists every sale and return with taxable value, tax rate and delivery state. It is the file to work from.
  • Monthly filers file GSTR-1 by the 11th of the next month. Quarterly filers file by the 13th of the month after the quarter.
  • Report the taxable value from the Sales Report, never the amount Flipkart paid into your bank.
  • Returns reduce Table 7 in the period they happen. They do not reopen the old return.
  • A JSON file is only a carrier for your figures. You still review and file on the portal yourself.
In this guide
  1. Which Flipkart report do you need?
  2. From Sales Report to filed return, step by step
  3. Which table does each sale land in?
  4. How are returns treated?
  5. A worked example
  6. The mistake Flipkart sellers usually make
  7. Do it yourself or hand it over?

Which Flipkart report do you need?

Seller Hub offers more than one report with tax in the name, so the first question is fair: which one? Under Tax Report you will find a Sales Report and a GST Report. Both can be used. The Sales Report is the better starting point because it gives each order line with its delivery state, and GSTR-1 wants your consumer sales state by state.

ReportWhat it holdsUse it for
Sales ReportEach sale and each return: invoice number, date, HSN code, taxable value, GST rate and amount, delivery state, buyer GSTIN if givenAll GSTR-1 tables
GST ReportTax figures already summarised by FlipkartA cross-check on your totals
Payment or settlement reportMoney paid to you after commission, shipping fees and TCSBank reconciliation only, not GSTR-1

The click path is in our guide on downloading the Flipkart GST report.

From Sales Report to filed return, step by step

  1. Request the Sales Report for the full period. One month for monthly filers. For quarterly filers, all three months of the quarter.
  2. Split sales from returns. The report marks each row as a sale or a return. Keep both. Drop nothing by hand.
  3. Check for buyer GSTINs. Rows with a buyer GSTIN are B2B and go to Table 4 invoice by invoice. Everything else is B2C.
  4. Total the B2C rows by state and tax rate. Sales minus returns, for each delivery state and each rate. That is Table 7.
  5. Build the HSN summary. Group the same rows by HSN code, the product classification code, for Table 12. Give at least 4 digits if your turnover is up to Rs 5 crore, 6 digits above that.
  6. Count your documents. Table 13 wants the first and last invoice number of each series, how many were issued and how many cancelled. Do the same for credit notes.
  7. Add Table 14. One row with Flipkart's GSTIN, your net sales through Flipkart and the tax on them.
  8. Create the JSON and file. The JSON is a file in the format the GST portal reads. You can build it with the portal's offline tool or with GST software. Upload it, check the tables on screen, generate the summary and file. The portal steps are in our portal filing guide.
File your GSTR-1 freeAprilTax turns your Amazon, Flipkart and Meesho reports into a GSTR-1 file ready for the GST portal, with the checks done for you.
Open the free tool

Which table does each sale land in?

What happenedGSTR-1 table
Sale to a consumer, any stateTable 7, as state and rate totals
Sale to a buyer with a GSTINTable 4, each invoice
Consumer returnSubtracted inside Table 7
Return by a GSTIN buyerTable 9B, as a credit note
HSN-wise totalsTable 12 (B2B and B2C tabs)
Invoice and credit note seriesTable 13
Net sales through FlipkartTable 14

One rarely used line: an inter-state consumer invoice above Rs 1 lakh goes to Table 5 on its own. Most Flipkart orders are far below that.

Why does Table 14 exist when the sales are already in Tables 4 and 7? Because Flipkart files its own return, GSTR-8, saying how much you sold through it. Table 14 is your side of the same number, and the department compares the two.

How are returns treated?

A customer return is a credit note in GST terms. For consumer sales you do not list credit notes one by one. You report Table 7 net, meaning sales minus returns.

Timing matters. A return belongs to the period in which it was processed, even if the order was shipped earlier. If returns in one state are larger than sales there in a slow month, that state's line can be negative. The portal accepts it. Do not force it to zero.

A worked example

Suppose you sell from Delhi, file quarterly, and your Sales Reports for October to December add up as below. Everything is B2C and taxed at 5%.

ItemTaxable valueGST at 5%
SalesRs 4,50,000Rs 22,500
ReturnsRs 90,000Rs 4,500
NetRs 3,60,000Rs 18,000

Of the net figure, Rs 1,20,000 was delivered within Delhi and Rs 2,40,000 to other states. Your GSTR-1, due 13 January, shows:

  • Table 7: Delhi line of Rs 1,20,000 with CGST Rs 3,000 and SGST Rs 3,000. Other states together Rs 2,40,000 with IGST Rs 12,000, one line per state.
  • Table 12, B2C tab: Rs 3,60,000 against your HSN codes.
  • Table 13: your invoice series and credit note series for the quarter.
  • Table 14: Rs 3,60,000 and Rs 18,000 tax against Flipkart's GSTIN.

Flipkart will have collected tax at source (TCS) at 0.5% of the net value, Rs 1,800, and reported it in GSTR-8. You claim it on the portal. See how TCS matching works.

The mistake Flipkart sellers usually make

The usual one is filing from the money received. The settlement amount is what is left after Flipkart takes commission, shipping charges and TCS. GST is charged on what the customer bought, not on what reached your bank. A seller who reports the settled Rs 2,90,000 instead of the Rs 3,60,000 taxable value has under-reported Rs 70,000 of sales. Flipkart's GSTR-8 will still show Rs 3,60,000, and the gap is easy for the department to see.

Others to avoid:

  • Skipping the returns rows. In the example that would mean paying Rs 4,500 of GST you do not owe.
  • Uploading one month's file for a quarterly return. The quarter needs all three months.
  • Editing the report before using it. Deleted or re-sorted rows are the main reason totals stop matching.

The cost of being late is Rs 50 a day, capped at Rs 2,000 per return if your turnover is up to Rs 1.5 crore. The cost of being wrong is harder to undo: a filed GSTR-1 cannot be revised. You get one correction through GSTR-1A before GSTR-3B, or you amend in a later period.

Do it yourself or hand it over?

A single-GSTIN seller with only Flipkart consumer sales can handle this alone. It is mostly careful adding up. Hand it over if you sell on several platforms and through your own website as well, if you have regular B2B orders, or if you simply lose a working day to it every month. Your time has a price too.

How AprilTax can help

AprilTax offers a free GSTR-1 tool for online sellers. You upload the Flipkart Sales Report as downloaded and it prepares the B2B, B2C, HSN summary, documents issued and e-commerce tables, runs about 30 checks and gives you a JSON file that you upload on the GST portal yourself. It also matches the TCS Flipkart reported against your sales.

Frequently asked questions

Which Flipkart report is used for GSTR-1 filing?
Use the Sales Report, requested from Reports, then Request Report, then Tax Report in Flipkart Seller Hub. It lists each sale and return with taxable value, GST and delivery state. The GST Report from the same place can be used as a cross-check.
Do Flipkart sales go in B2B or B2C in GSTR-1?
Most Flipkart orders are from consumers, so they go in Table 7 as state-wise and rate-wise totals. An order where the buyer gave a GSTIN is a B2B sale and goes in Table 4 as an individual invoice.
How do I report Flipkart returns in GSTR-1?
For consumer sales, subtract returns from sales and report the net figure in Table 7, in the period the return was processed. For a buyer with a GSTIN, report the return as a credit note in Table 9B.
What is the GSTR-1 due date for a Flipkart seller?
The 11th of the following month if you file monthly, and the 13th of the month after the quarter if you file quarterly. Quarterly filing is available if your turnover in the previous financial year was up to Rs 5 crore.
What is a GSTR-1 JSON file?
It is a data file in the format the GST portal accepts for upload. It carries the same figures you would otherwise type into each table. After uploading it you still check the tables, generate the summary and file with an OTP or digital signature.
Should I report the amount Flipkart paid me in GSTR-1?
No. Report the taxable value of what customers bought, as shown in the Sales Report. The settlement amount is lower because Flipkart deducts commission, fees and TCS, and using it under-reports your sales.
Is Table 14 compulsory for Flipkart sellers?
Table 14 is where a supplier reports sales made through an e-commerce operator, against the operator's GSTIN. Flipkart reports the same sales in its GSTR-8, so filling Table 14 with matching figures keeps the two returns consistent.
What is the late fee if I file GSTR-1 late?
Rs 50 a day, or Rs 20 a day for a nil return. The total is capped per return at Rs 500 for a nil return, Rs 2,000 if your turnover is up to Rs 1.5 crore, and Rs 5,000 if it is between Rs 1.5 crore and Rs 5 crore.

File your GSTR-1 free

AprilTax turns your Amazon, Flipkart and Meesho reports into a GSTR-1 file ready for the GST portal, with the checks done for you.

Open the free tool
D
CA Daxit

A Chartered Accountant on the AprilTax team who works with online sellers and small businesses every filing season.

Read next

Stuck on a return or registration?

File GSTR-1 free with the tool, or hand it to a Tax Expert at a fixed fee.

← All articles
Talk to AprilTax