Gstr 2a And 3b Reconciliation In Excel Format [top] Download Site
+------------------------------------+---------------+---------------+---------------+ | Component | IGST (INR) | CGST (INR) | SGST (INR) | +------------------------------------+---------------+---------------+---------------+ | Total ITC As Per Books (GSTR-3B) | [Sum Books] | [Sum Books] | [Sum Books] | | Total ITC As Per Portal (GSTR-2A) | [Sum 2A] | [Sum 2A] | [Sum 2A] | +------------------------------------+---------------+---------------+---------------+ | Variance / Mismatch | [Difference] | [Difference] | [Difference] | +------------------------------------+---------------+---------------+---------------+ Best Practices for Seamless GST Reconciliation
✅ Always reconcile your GSTR-2A data with your GSTR-3B filings before the end of the financial year to make any necessary amendments in the September return.
Reconciling is not just a compliance requirement but a best practice for financial hygiene. By downloading GSTR-2A in Excel format and comparing it with your purchase register or GSTR-3B ITC table, you can: gstr 2a and 3b reconciliation in excel format download
An Excel spreadsheet is the most accessible and flexible tool for manual or semi-automated reconciliation. Follow this structure to build your own template: 1. The GSTR 2A Data Sheet
Tracking mismatches ensures you can follow up with defaulting vendors who have either not filed their returns or have uploaded incorrect invoice details. Follow this structure to build your own template: 1
Paste the data downloaded from the GST portal here.
The invoice is in GSTR 2A, but not in your accounting books. The invoice is in GSTR 2A, but not in your accounting books
Follow a similar path on the dashboard to view your filed GSTR 3B.
Reconciling GSTR‑2A with GSTR‑3B allows businesses to verify the accuracy of their tax credit claims. The basic premise is simple:
| ITC Type | Available in 2A (sum) | Claimed in 3B | Difference | |----------|----------------------|---------------|------------| | IGST | =SUMIFS(...) | Manual entry | Available - Claimed | | CGST | | | | | SGST | | | |