Gstr 2a And 3b Reconciliation In Excel Format Download Here

If you want, I can:

Which would you prefer?

To download a GSTR-2A vs. 3B reconciliation excel format, you can use free templates from compliance platforms like GSTZen or follow a manual structure in Excel to identify Input Tax Credit (ITC) discrepancies. How to Create a Reconciliation Sheet in Excel

If you prefer building your own format, follow these steps to structure your data for matching: Download Source Files:

GSTR-2A: Login to the GST Portal, go to Services > Returns > Returns Dashboard, select the period, and click Download under the GSTR-2A tile to generate an Excel file.

GSTR-3B: Download your filed GSTR-3B details from the portal (typically Table 4A for ITC).

Purchase Register: 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: gstr 2a and 3b reconciliation in excel format download

VLOOKUP/XLOOKUP: Match invoice numbers between GSTR-2A and your purchase register to find missing entries.

Pivot Tables: Summarize data by GSTIN or Supplier Name to identify aggregate differences in tax amounts.

Conditional Formatting: Highlight rows where the tax amount in your books differs from the portal data. Importance of Regular Reconciliation Comparison and Reconciliation of GSTR 3B and GSTR 2A

Below is the exact column structure you should create or download as a template. You can copy these headers into a new Excel workbook.

For Goods and Services Tax (GST) filers in India, one of the most tedious yet critical compliance tasks is reconciling GSTR-2A (the auto-drafted purchase statement) with GSTR-3B (the summary self-declared return). Mismatches between these two forms can lead to denied Input Tax Credit (ITC), interest liabilities, and even show-cause notices from tax authorities.

With the introduction of Rule 36(4) of the CGST Rules (allowing only 5% excess ITC over available GSTR-2A/2B), reconciliation has shifted from “good practice” to “mandatory legal requirement.” If you want, I can:

The most efficient way to perform this reconciliation without expensive software is by using Excel. This article provides a step-by-step guide, a ready-to-use GSTR-2A vs GSTR-3B reconciliation Excel format download, and best practices to ensure 100% ITC utilization.

| GSTIN of Supplier | Invoice Number | Invoice Date | Taxable Value | CGST | SGST/UTGST | IGST | Cess | Total ITC Available | |------------------|----------------|--------------|----------------|------|------------|------|------|----------------------|

A. Find missing invoices in GSTR-2A (vendor not filed)

In Purchase Register sheet, add a column: In GSTR-2A?

=IF(COUNTIFS(GSTR2A!B:B, B2, GSTR2A!C:C, C2, GSTR2A!D:D, D2)>0, "Yes", "No")

(B2 = Supplier GSTIN, C2 = Invoice No., D2 = Date)

Filter “No” – these are invoices where ITC cannot be claimed. Which would you prefer

B. Find amount mismatches

Add column: Difference in Taxable Value

= ABS(Purchase_Reg_Taxable - VLOOKUP(Invoice_No, GSTR2A_Range, Column_Index, 0))

Better to use SUMIFS for multi-condition match.

C. Compare ITC claimed (3B Table 4) vs ITC available (2A)

| ITC Type | Available in 2A (sum) | Claimed in 3B | Difference | |----------|----------------------|---------------|------------| | IGST | =SUMIFS(...) | Manual entry | Available - Claimed | | CGST | | | | | SGST | | | |