Gstr 2a And 3b Reconciliation In Excel Format Download [portable] 💯 Must Watch

This is a dynamic, view-only statement of inward supplies (purchases) auto-populated from the returns filed by your suppliers. It provides a real-time view of all supplies made to you and updates whenever a supplier modifies their GSTR-1, GSTR-5, or GSTR-6.

If you need help building this spreadsheet or automating specific lookup formulas, let me know or how many purchase invoices you handle monthly so I can customize the steps for you. Share public link

Paste your GSTR-3B Table-4 data:

To automate the matching process, utilize these standard Excel formulas: XLOOKUP / VLOOKUP

You can download a GSTR 2A and 3B reconciliation Excel template from various online sources, such as:

To make the reconciliation process easier, we have created a downloadable Excel template. The template includes the following sheets: This is a dynamic, view-only statement of inward

: Export your internal purchase records from your accounting software (e.g., Tally, SAP, Zoho). Format Your Sheet : Create columns for: Supplier GSTIN Invoice Number & Date Taxable Value Tax Amount (IGST, CGST, SGST) Status (Matched, Mismatched, Missing in 2A, etc.). Apply Excel Formulas :

No. As per Section 16(2) of the CGST Act, ITC can be claimed only if the supplier has reported the invoice in their GSTR‑1, which populates GSTR‑2A. You must follow up with the supplier to get the invoice uploaded. Share public link Paste your GSTR-3B Table-4 data:

Guide to Reconciling GSTR 2A and GSTR 3B in Excel Reconciling GSTR 2A with GSTR 3B is essential for ensuring that the Input Tax Credit (ITC) claimed in your monthly summary return (GSTR 3B) matches the data auto-populated from your suppliers' filings (GSTR 2A). This process helps identify missing invoices and avoid legal notices from tax authorities. Step-by-Step Reconciliation Process GSTR2A & GSTR2B Automatic Reconciliation Excel Tool