Free report checker
Check your CityMall report before you file
Not sure your CityMall file has the right columns? Check it here, right in your browser, then import it free.
Every month the CityMall panel gives you a report with its own column names. FileKey maps them to GSTR-1 for you, client by client.
Will it import?
CityMall reports and the columns they need
| Report | File | Columns FileKey needs | Goes to |
|---|---|---|---|
| CityMall Report | XLSX, CSV | customer_state seller_gstin tcs_taxable hsn_code quantity gst_rate_on_product | B2C (Table 7) |
CityMall 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 tcs_taxable on a row of the client's GSTIN stops the upload with 'Taxable value column missing.'
Rows with a blank customer_state are skipped; only rows whose seller_gstin matches the client's GSTIN are imported ('No record found.' if no seller_gstin cell exists, else 'Seller GSTIN Mismatch').
Good to know
Is the CityMall 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 CityMall 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 CityMall reports can FileKey import?
CityMall Report.
What does FileKey make from CityMall 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 CityMall?
No. FileKey is an independent tool for sellers and CAs. CityMall is a trademark of its owner.