– This is your primary dashboard where the matching calculations occur. 2. Standardize Your Data Layout
| Cause | Explanation | Remedy | |---|---|---| | Supplier has not filed GSTR‑1 | The supplier has not uploaded their outward supplies | Follow up with supplier; consider alternative vendors | | Supplier filed but reported wrong GSTIN | Invoice is uploaded under a different GSTIN of the same supplier | Ask supplier to amend | | Timing difference (cut‑off issue) | Invoice of March appears in April’s GSTR‑2A | ITC can be claimed in April return | | Debit / credit note mismatch | Adjustments not properly recorded by either party | Reconcile and amend in next filing | | ITC claimed on ineligible invoices | Supplier’s invoice appears in GSTR‑2A but goods are blocked under Section 17(5) | Reverse ITC; eligibility must be verified independently | | Invoice number formatting differences | Portal stores "INV/2026/001" but books show "INV2026001" | Use smart matching tools instead of plain VLOOKUP |
: Export your purchase data from your accounting software (e.g., Tally) into a standard Excel format. Use Key Formulas VLOOKUP / XLOOKUP
: The supplier failed to register the transaction as a business-to-business sale. Designing Your Own Excel Template gstr 2a and 3b reconciliation in excel format download
The result is a full year of reconciliation across multiple branches completed in under 60 seconds.
Comparison of GSTR-3B vs GSTR-2A : Importance ... - ClearTax
=IF(Total_ITC_Claimed > (Total_ITC_in_2A * 1.05), "Excess Claim - Disallowed", "Within Limit") – This is your primary dashboard where the
Use COUNTIF to flag invoices where supplier GSTIN exists in GSTR-2A but invoice number does not.
If ITC is wrongly availed and utilised, interest is charged under Section 50, and penalty may be levied under Section 73 or 74 of the CGST Act. The quantum depends on whether the mismatch was due to genuine error or fraudulent intent.
: Allows users to download a PAN-level summary and detailed GSTR-3B vs. GSTR-2A reports in Excel format. Use Key Formulas VLOOKUP / XLOOKUP : The
– Paste the raw data downloaded from the government portal here.
=IFERROR(VLOOKUP(A2&B2, Sheet1!$A$2:$J$1000, 4, FALSE), "Not in 2A")
While Excel is good, for high-volume transactions, automated GST reconciliation software can save significant time. Conclusion