Reconciling GSTR-2A with GSTR-3B is a critical step for verifying Input Tax Credit (ITC). You can obtain reconciliation sheets through several reliable methods, ranging from direct portal downloads to advanced free Excel utilities. 📥 Direct Portal Download (Manual)
Ensure both sheets have consistent headers: gstr 2a and 3b reconciliation in excel format download
Since I cannot attach an actual .xlsx file, I have provided the below. You can copy this into Excel in 2 minutes. Reconciling GSTR-2A with GSTR-3B is a critical step
| Sheet Name | Source | Key Columns | |------------|--------|--------------| | GSTR-2A_Excel | GST Portal download | GSTIN of supplier, Invoice No., Invoice Date, Taxable Value, CGST, SGST, IGST, Cess | | Purchase_Register | Your books (or GSTR-3B Table 4) | Same fields + ITC claimed in 3B | Copy-paste GSTR-2A (from GST portal JSON/Excel export) into
Before we dive into the reconciliation process, let's briefly understand the two forms: