3b Reconciliation In Excel Format Download Patched: Gstr 2a And
While there is no single "official" reconciliation file on the GST Portal
Appendix A — Excel Template Structure (fields per sheet)
- GSTR2A_Raw: SupplierGSTIN, SupplierName, InvoiceNo, InvoiceDate, InvoiceType, POS, TaxableValue, IGST, CGST, SGST, Cess, HSN, OriginalRef (for amendments)
- GSTR3B_Raw: Month, Total_IGST_ITC, Total_CGST_ITC, Total_SGST_ITC, Total_Cess_ITC, Source (Books/GSTR3B)
- Cleaned_Data: Key, SupplierGSTIN, InvoiceNo, InvoiceDate, InvoiceType, TaxableValue, IGST, CGST, SGST, Cess, MatchFlag, MatchReason, MatchedDate
- Reconciliation_Report: Month, GSTR3B_IGST, Matched_IGST, Unmatched_IGST, GSTR3B_CGST, Matched_CGST, Unmatched_CGST, GSTR3B_SGST, Matched_SGST, Unmatched_SGST, TotalVariance
- Exceptions: Key, SupplierGSTIN, InvoiceNo, InvoiceDate, TaxableValue, IGST, CGST, SGST, Cess, IssueType, RecommendedAction, Status, Owner, Comment
- Self-declaration form that summarizes outward supplies, inward supplies, and payment of taxes
- Filed on a monthly basis
- Includes information on outward supplies, ITC claimed, and tax payments
Supplier Compliance: Helps identify suppliers who haven't uploaded invoices or filed returns. gstr 2a and 3b reconciliation in excel format download
Challenges in GSTR 2A and 3B Reconciliation While there is no single "official" reconciliation file
- Option A (Recommended): Download GSTR-3B as JSON/PDF and manually create an Excel extract of ITC claimed (Table 4).
- Option B: Use the Offline Utility for GSTR-3B (Excel-based) available on the portal under Downloads → Offline Tools.
Using an Excel template for GSTR 2A and 3B reconciliation offers several benefits: Zoho) Online tax compliance platforms (e.g.
Pivot Tables: Summarize data by GSTIN or Supplier Name to identify aggregate differences in tax amounts.
- GST Council website
- Accounting and tax preparation software providers (e.g., QuickBooks, Zoho)
- Online tax compliance platforms (e.g., GSTN, ClearTax)
