GSTR for CA portal
GSTR-1 From the Flipkart Sales Report: Sales, Returns, Cashback and Table 14
Flipkart offers sellers two useful tax files every month: the detailed Sales Report (with a separate Cash Back sheet) and a summary "Report for GSTR-1 and GSTR-8". The Sales Report has one row per order item and event, which makes it the best base for an accurate GSTR-1; the summary report is ideal for cross-checking.
Downloading the reports
In Seller Hub, open the reports section (tax or payments reports) and download the monthly Sales Report as Excel. The workbook contains the Sales Report sheet and a Cash Back Report sheet. Download the GSTR-1 report for the same month if you want to cross-check.
Key columns in the Sales Report
- Event Type – Sale, Return, Cancellation and so on.
- Buyer Invoice ID and Buyer Invoice Date.
- Taxable Value (Final Invoice Amount – Taxes).
- IGST / CGST / SGST Amount and rates.
- Customer's Delivery State (and billing state as a fallback).
- HSN Code, Item Quantity, Order Item ID.
- Business GST Number – filled for B2B orders.
Returns and cancellations
Returns appear as separate rows with negative values. They reduce B2C sales for the month in which they are reported. Cancellations before invoicing carry zero value and drop out. For B2B orders, a return is a credit note to a registered buyer and belongs in Table 9B (CDNR).
The Cash Back sheet
The Cash Back Report lists credit and debit notes Flipkart raises on the seller's behalf for offers and cashback, with their own taxable value and tax. They change the net taxable value and must be included. Some rows lack HSN or state; join them to the original sale through the Order Item ID to pick those up.
Mapping to GSTR-1
- B2C sales net of returns and cashback → Table 7 (B2CS) by state and rate; large inter-state B2C invoices → B2CL.
- Orders with a valid Business GST Number → Table 4 (B2B).
- HSN totals → Table 12 (B2B and B2C parts).
- Invoice and credit-note series → Table 13.
- Net value through Flipkart → Table 14 with Flipkart's GSTIN for your state.
Preparing it in the portal
Open GSTR-1 preparation in the GSTR for CA portal, choose the client and month and drop the Flipkart Sales Report workbook (you can include the GSTR-1 report too). The portal reads both sheets, applies returns and cashback, joins missing HSN and state from the original order item, groups B2CS on the tax actually charged and produces the Excel working and GST JSON. If the GSTR-1 report is included it is used for cross-checking and to pick up Flipkart's GSTIN for Table 14.
Cross-check with Flipkart's own GSTR-1 report
The net taxable value and tax from the Sales Report should match Flipkart's "Report for GSTR-1 and GSTR-8" for the month. In our testing on a real seller month, the portal's Flipkart net taxable value matched Flipkart's report to the paisa, along with the invoice series. If you see a difference, check that the Cash Back sheet was included and that returns from an earlier month were not filtered out.
Frequently asked questions
Which is better: the Sales Report or the GSTR-1 report?
Use the Sales Report for the return and the GSTR-1 report to cross-check.
Why is HSN blank on cashback rows?
Flipkart does not repeat it there; it is taken from the original order item.
Do I need to upload both sheets separately?
No. Drop the workbook once; both sheets are read.
How are B2B Flipkart orders identified?
By a valid Business GST Number on the order row.