Free report checker
Will your Flipkart file import? Find out in seconds
Drop a Flipkart report below and see in seconds whether FileKey can import it. Then let FileKey prepare GSTR-1 for every client.
Will it import?
Flipkart reports and the columns they need
| Report | File | Columns FileKey needs | Goes to |
|---|---|---|---|
| Flipkart Sales Report | XLSX | seller gstin customer's delivery state taxable value (final invoice amount -taxes) cgst rate sgst rate (or utgst as applicable) igst rate item quantity order id seller gstin customer's delivery state order id taxable value cgst rate sgst rate (or utgst as applicable) igst rate | B2C (Table 7) |
| Flipkart GST Report | XLSX | gstin aggregate taxable value rs. delivered state (pos) gstin aggregate taxable value rs. | B2C (Table 7) |
A few more things FileKey handles
The upload form asks for the e-commerce operator GSTIN (FileKey pre-fills it; it must be a valid e-commerce GSTIN with 'C' as the 14th character).- Must be an .xlsx workbook with at least 3 sheets: FileKey reads the 2nd sheet as Sales and the 3rd sheet as Cashback, by position (the 1st sheet is not read; sheet names don't matter). A CSV or a workbook with fewer sheets is refused with 'Please upload fipkart sales.'
- Rows whose 'Business GST Number' cell exists and is not exactly 'NA' (a blank cell counts as present) are treated as B2B/credit-note rows: on the Sales sheet they also need Buyer Invoice Date, Buyer Invoice ID, Order ID, Beneficiary Name, Event Type and Item Quantity; on the Cashback sheet Credit Note ID/ Debit Note ID and Document Sub Type.
- A blank taxable value on a row of the client's GSTIN stops the upload with 'Taxable value column missing.'
- If no B2C row of the client's GSTIN is found the upload stops with 'Seller GSTIN Mismatch' (even if B2B rows matched); if neither sheet has any Seller GSTIN cell it stops with 'No record found!'.
- On B2B rows a Buyer Invoice ID (Sales) or Credit Note ID/ Debit Note ID (Cashback) over 16 characters stops the upload ('Customer note numbers are only allowed up to 16 characters.').
Good to know
Is the Flipkart report checker free?
Yes. The checker on this page and FileKey itself are free right now, with no limits on clients or uploads.
Does my Flipkart file get uploaded when I check it?
No. The check runs in your browser. The file only reaches FileKey if you import it in the app.
Which Flipkart reports can FileKey import?
Flipkart Sales Report and Flipkart GST Report.
What does FileKey make from Flipkart reports?
GSTR-1 for the period: the B2C and B2B tables, the HSN summary and documents issued, ready to download as GST portal JSON or Tally XML.
Is FileKey affiliated with Flipkart?
No. FileKey is an independent tool for sellers and CAs. Flipkart is a trademark of its owner.