Gstr 2a And 3b Reconciliation In Excel Format [extra Quality] Download Jun 2026

=XLOOKUP(C2, 'GSTR 2A Data'!C:C, 'GSTR 2A Data'!F:F, "Not Found")

: Under Section 16(4) of the CGST Act, you can only claim ITC if your supplier has uploaded the invoice.

GSTR-2A is a dynamic, read-only document that automatically generates based on the sales (GSTR-1) filed by your suppliers. It acts as a mirror, showing the input tax credit you should be entitled to. 2. GSTR-3B (The Taxpayer Declaration) gstr 2a and 3b reconciliation in excel format download

Failure to perform this reconciliation can lead to excessive ITC claims, resulting in demand notices (Form ASMT-10), interest liabilities at 18% per annum, and potential penalties. Why You Need a GSTR 2A vs 3B Reconciliation Format in Excel

What (e.g., hundreds or tens of thousands per month) does your business typically process? =XLOOKUP(C2, 'GSTR 2A Data'

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

Export your internal purchase ledger/register for the matching period from your accounting software (e.g., Tally, Zoho, SAP) into Excel. Supplier filed GSTR-1, but after your GSTR-3B deadline

The Goods and Services Tax Network (GSTN) tracks mismatches between auto-generated data and self-declared returns. If your claimed ITC in GSTR-3B exceeds the ITC available in GSTR-2A/2B, tax authorities will issue automated demand notices (such as Form DRC-01C). Protect Your Cash Flow

Select the relevant and Return Filing Period [0.5.1]. Click on Search and locate the Form GSTR-2A tile [0.5.1].

To understand reconciliation, we must first grasp the two core forms involved:

Check who made the data entry error and correct it accordingly. Best Practices for Error-Free GST Compliance