7-Sheet GSTR-1 Excel Workbook Architecture
In SuperGST > Reports (/app/reports), select your tax period and click Download GSTR-1 Full Report. SuperGST compiles all finalized invoices and sales returns into a comprehensive 7-sheet Excel workbook (.xlsx) formatted for your Chartered Accountant, ClearTax, or the GST Offline Tool:
- Sheet 1: B2B (Table 4A): All sales to registered businesses with valid buyer GSTINs, state-wise tax breakdowns, and invoice dates.
- Sheet 2: B2CS (Table 7): Intra-state consumer sales, and inter-state consumer sales below the B2C Large threshold, aggregated by Place of Supply (POS) and tax rate, adjusted for customer refunds.
- Sheet 3: B2CL (Table 5): Inter-state consumer sales exceeding ₹1,00,000 (updated per GST Notification No. 12/2024-Central Tax).
- Sheet 4: CDNR (Table 9B): Credit notes issued against registered B2B buyers.
- Sheet 5: CDNUR (Table 9B): Credit notes issued against unregistered B2CL consumer sales.
- Sheet 6: HSN (Table 12): Net item summary grouped by HSN code and Unit Quantity Code (UQC), showing total quantity, net taxable value, and tax splits netted against credit notes.
- Sheet 7: GSTR-3B Table 3.2: State-wise summary of inter-State outward taxable supplies made to unregistered persons, adjusted for returns.
Individual GST Offline Tool CSV Exports
In addition to the consolidated Excel workbook, SuperGST provides 1-click individual CSV exports formatted specifically for the government GST Offline Tool:
- GSTR-1 B2B Offline (CSV): Section 4A registered business supplies.
- GSTR-1 B2C Offline Small (CSV): Section 7 small consumer supplies adjusted for refunds.
- GSTR-1 B2CL Offline (CSV): Section 5 large inter-state retail invoices.
- GSTR-1 CDNR Offline (CSV): Section 9B credit notes for B2B invoices.
- GSTR-1 CDNUR Offline (CSV): Section 9B credit notes for unregistered invoices.
- HSN-wise Summary of Outward Supplies (CSV): Section 12 HSN data for rapid upload.
Monthly & QRMP Quarterly Periods & ₹1 Lakh Threshold
- Filing Periods: SuperGST supports both Monthly filing (last 12 calendar months) and QRMP Quarterly filing (Quarter 1 Apr–Jun, Quarter 2 Jul–Sep, Quarter 3 Oct–Dec, Quarter 4 Jan–Mar).
- ₹1 Lakh B2C Large Threshold: Under Notification No. 12/2024-Central Tax, the government reduced the B2C Large threshold from ₹2,50,000 to ₹1,00,000. SuperGST automatically applies this rule, routing inter-state retail orders over ₹1,00,000 directly into the B2CL tab.
GSTR-3B Quick Filing Card
SuperGST also displays a real-time summary card for Table 3.1(a) Outward Taxable Supplies:
- Total Net Taxable Turnover (netted against sales returns)
- Total Integrated Tax (IGST)
- Total Central Tax (CGST)
- Total State Tax (SGST)
Share this summary directly with your accountant for rapid 2-minute monthly filing.