| 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 |
Calculate the difference between your books and the portal data: =Books_IGST - Portal_IGST Common Reasons for Mismatches gstr 2a and 3b reconciliation in excel format download
GSTR‑2A is a that shows details of all purchases made by a business from its suppliers. It is automatically generated when suppliers file their GSTR‑1 returns, which contain details of their sales. GSTR‑2A provides a summarised view of all the input tax credit (ITC) available to the buyer for a specific tax period. | Issue | Solution | |-------|----------| | Supplier
: Maintaining a month-on-month reconciliation register in Excel serves as vital documentation during GST audits or when responding to scrutiny notices. Step-by-Step Guide to Reconcile in Excel Protect Your Cash Flow The document contains supplier
The Goods and Services Tax Network (GSTN) tracks mismatches between auto-generated data and self-declared returns. If your claimed ITC in GSTR-3B exceeds the ITC available in GSTR-2A/2B, tax authorities will issue automated demand notices (such as Form DRC-01C). Protect Your Cash Flow
The document contains supplier GSTIN, invoice number, invoice date, taxable value, applicable tax rates (CGST, SGST, or IGST), and the amount of tax paid.
Or use the manual template above – it takes ~10 minutes to set up and saves hours of audit scrutiny.