| ITC Type | Available in 2A (sum) | Claimed in 3B | Difference | |----------|----------------------|---------------|------------| | IGST | =SUMIFS(...) | Manual entry | Available - Claimed | | CGST | | | | | SGST | | | |
=VLOOKUP(A2, 'GSTR-2A'!A:H, 5, 0) – To pull taxable value from 2A. gstr 2a and 3b reconciliation in excel format download
Reconciling GSTR 2A and GSTR 3B is a critical compliance process to ensure that the Input Tax Credit (ITC) you self-declare in your summary return (GSTR 3B) matches what your suppliers have reported (GSTR 2A) . | ITC Type | Available in 2A (sum)
Using Excel for reconciliation is highly effective for most small to medium enterprises but requires specific data-handling techniques: : gstr 2a and 3b reconciliation in excel format download
| Issue | Solution | |-------|----------| | Supplier hasn't filed GSTR-1 | Follow up with supplier | | Wrong invoice number/date in books | Correct purchase entry | | ITC claimed on ineligible supplies | Reverse in next month’s 3B | | Time lag in reporting | Adjust in subsequent month |