B2C (Table 7)
Shop101 Reselling report
File: XLSX, CSV
Needs: Customer state, Taxable value, HSN code, GST rate
Before you upload
Shop101 reports to GSTR-1, without the spreadsheet work
Not sure your Shop101 file has the right columns? Check it here, right in your browser, then import it free.
Check your report
What FileKey checks besides the columns
The upload form asks for the e-commerce operator GSTIN (pre-filled; valid e-commerce GSTIN with 'C' as the 14th character).- Up to 5 files per month; each upload is added to the month rather than replacing it ('Exceeding monthly max sheets limit [5].' beyond that).
- A row with an Order Customer State but a blank Price Net of GST stops the upload with 'Taxable value column missing.'
- No seller-GSTIN filter: every row with a customer state is imported. Quantity is stored as 0; tax is recomputed from the rate.
Shop101 and GSTR-1, answered
Is the Shop101 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 Shop101 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 Shop101 reports can FileKey import?
Shop101 Reselling report.
What does FileKey make from Shop101 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 Shop101?
No. FileKey is an independent tool for sellers and CAs. Shop101 is a trademark of its owner.