Gstr 2a And 3b Reconciliation In Excel Format =link= Download Jun 2026

(Assumes Col H in 2A sheet says "Yes" if ITC eligible)

Copy the below CSV into a file named reconciliation.csv and open in Excel:

Click (Note: it may take up to 20 minutes to process). GSTR 3B : gstr 2a and 3b reconciliation in excel format download

Suppliers often enter invoice numbers differently than your accounts team (e.g., "INV-001" vs "001").

GSTR-2A and 3B Reconciliation in Excel Format (Downloadable Template) (Assumes Col H in 2A sheet says "Yes"

Reconciling (auto-populated purchase data) with GSTR-3B (self-declared summary return) is a critical compliance activity for every GST-registered business. Ensuring these two match helps you maximize eligible Input Tax Credit (ITC) and avoid receiving scrutiny notices from the tax department.

The most basic "format" is the official Excel file generated by the GST Portal. Log in to the GST Portal. Step 2: Navigate to Services > Returns > Returns Dashboard . Step 3: Select the Financial Year and Return Period. Ensuring these two match helps you maximize eligible

Supplier filed GSTR-1, but after your GSTR-3B deadline.

Create this table starting from :

: Helps track which suppliers have not filed their GSTR-1, allowing you to follow up and ensure your ITC is reflected in GSTR-2A. Audit Readiness