Gstr 2a And 3b Reconciliation In Excel Format New! Download Jun 2026

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.

Invoices formatted differently (e.g., INV-001 vs INV001 ) break formulas. Clean them up by removing special characters using a formula block: =SUBSTITUTE(SUBSTITUTE(A2, "-", ""), "/", "") Use code with caution. Step 2: Extracting Matching Data Using XLOOKUP or VLOOKUP

Approximately your business handles each month? gstr 2a and 3b reconciliation in excel format download

Instead of deep diving into individual invoices, run a quick Pivot Table grouped by Supplier GSTIN to isolate which specific vendors are causing the largest overall variances.

Need a ready-made template? Copy the column headers provided in this article into a new Excel sheet, add VLOOKUPs, and you have your own GSTR-2A vs GSTR-3B reconciliation tool – completely free. This public link is valid for 7 days

If you are looking for a , you can build a robust template using these columns: Sheet 1: Data from Books Vendor Name Invoice No Taxable Value Sheet 2: Data from GSTR-2A Supplier Name Invoice No Taxable Value Sheet 3: Reconciliation Summary

✅ Always keep a master copy of the blank reconciliation format. Every month, paste fresh GSTR-2A and GSTR-3B data into the respective tabs – all formulas will auto-update. Can’t copy the link right now

Before starting your Excel reconciliation, you must extract the live government data from the official portal. Log in to the GST Portal. Navigate to > Returns > Returns Dashboard [ 0.5.1 ].

| A | B | C | D | E | F | G | H | I | |---|---|---|---|---|---|---|---|---| | | Supplier GSTIN | Taxable Value (2A) | Total Tax (2A) | ITC as per 2A | ITC Claimed in 3B (same period) | Difference (H - E) | Status | Reason for Mismatch |