By downloading the right Excel format, following a systematic approach, and staying informed about the latest GST updates, you can turn reconciliation from a tedious chore into a strategic advantage for your business or practice.
Create a status column to highlight variances automatically. =IF(PR_IGST = GSTR2A_IGST, "Matched", "Mismatch") Use code with caution. SUMIF / SUMIFS
What do you use? (Tally, Zoho, SAP, etc.)
| Invoice No | Supplier GSTIN | ITC in 2A | ITC in 3B | Difference | Status | Reason | |------------|----------------|-----------|-----------|------------|--------|--------| | INV-101 | 27AAACA1234R1Z | 1,800 | 1,800 | 0 | Matched | OK | | INV-102 | 27AAACA1234R1Z | 0 | 1,800 | 1,800 | Mismatch | Missing in 2A | | INV-103 | 27AAACA1234R1Z | 2,500 | 0 | -2,500 | Mismatch | Supplier not filed GSTR-1 | gstr 2a and 3b reconciliation in excel format download
| Columns | Description | |---------|-------------| | GSTIN of Supplier | 15-digit | | Invoice No. | | | Invoice Date | | | Taxable Value | | | CGST | | | SGST | | | IGST | | | Cess | | | Total Tax | | | Month | (e.g., Oct 2024) |
GSTR 2A and 3B reconciliation is a critical process for every GST-registered taxpayer. It ensures that the Input Tax Credit (ITC) claimed in the monthly return (GSTR-3B) matches the data uploaded by suppliers (GSTR-2A). Discrepancies can lead to tax notices, interest penalties, or loss of credit.
: Pull your internal purchase register for the corresponding period. By downloading the right Excel format, following a
🚫 The GST department uses data from supplier returns to verify your ITC claims. Large and unexplained discrepancies can trigger automated notices, audits, and penalties, eroding your compliance standing.
Here is a step-by-step guide to performing the reconciliation within Excel.
| 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 | SUMIF / SUMIFS What do you use
Create a new Excel file with :
=XLOOKUP(A2&B2, 'GSTR 2A Data'!$A$2:$A$1000&'GSTR 2A Data'!$B$2:$B$1000, 'GSTR 2A Data'!$C$2:$C$1000, 0) Use code with caution. (Where A2 is the GSTIN and B2 is the Invoice Number). Step 3: Categorizing Differences via IF Statements