Free report checker
Check your Glowroad report before you file
2 Glowroad reports, one GSTR-1. Check the file below, then import it free and download GST portal JSON or Tally XML.
- Glowroad B2C TCS Report
- Glowroad B2B TCS Report
Will it import?
Glowroad reports and the columns they need
| Report | File | Columns FileKey needs | Goes to |
|---|---|---|---|
| Glowroad B2C TCS Report | XLSX, CSV | seller gstin buyer state base amount for gst product hsn code gst % | B2C (Table 7) |
| Glowroad B2B TCS Report | XLSX | base amount for gst seller gstin product hsn code gst % customer invoice value (gmv) buyer gstin buyer name order invoice id order invoice date | B2B (Table 4A) |
Glowroad report
FileKey review
GSTR-1 JSON · Tally XML
A few more things FileKey handles
The upload form asks for the e-commerce operator GSTIN (pre-filled; valid e-commerce GSTIN with 'C' as the 14th character).- A blank 'Base amount for GST' cell on a row of the client's GSTIN stops the upload with 'Taxable value column missing.'
- Rows with a blank Buyer State are skipped; only rows whose Seller GSTIN matches the client's GSTIN are imported ('No record found.' if there is no Seller GSTIN cell at all, else 'Seller GSTIN Mismatch').
- Taxes are recomputed from GST % x taxable value, quantity is stored as 0 and dots are removed from HSN codes.
- On rows of the client's GSTIN: Buyer GSTIN equal to the client's stops the upload ('Seller and Buyer GST numbers cannot be the same.'); an Order Invoice ID longer than 16 characters stops it ('Invoice numbers are only allowed up to 16 characters.'), and for negative rows a credit-note ID longer than 16 ('Customer note numbers are only allowed up to 16 characters.').
- A blank 'Base amount for GST ' cell on a row that has a Seller GSTIN stops the upload with 'Taxable value column missing.'
Good to know
Is the Glowroad 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 Glowroad 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 Glowroad reports can FileKey import?
Glowroad B2C TCS Report and Glowroad B2B TCS Report.
What does FileKey make from Glowroad 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 Glowroad?
No. FileKey is an independent tool for sellers and CAs. Glowroad is a trademark of its owner.