Gstr 2a And 3b Reconciliation In Excel Format Download _hot_ -

: Auto-highlights unmatched items or value differences in red.

Under GSTR-2A (Auto-drafted details), click Download .

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

Helps identify suppliers who haven't uploaded invoices or filed returns. gstr 2a and 3b reconciliation in excel format download

Use a fuzzy match filter or manually correct the book entry. Minor rounding off differences.

Reconciliation between GSTR 2A and GSTR 3B is a critical compliance process for every GST-registered taxpayer. Ensuring these two returns match helps you claim the correct Input Tax Credit (ITC) and avoids costly legal notices from the tax department.

Supplier GSTIN,Invoice No.,Invoice Date,Taxable Value (GSTR-2A),IGST (GSTR-2A),CGST (GSTR-2A),SGST (GSTR-2A),Total Tax (GSTR-2A),Taxable Value (GSTR-3B),IGST (GSTR-3B),CGST (GSTR-3B),SGST (GSTR-3B),Total Tax (GSTR-3B),Match Status,Difference,Reason / Notes,Action Required,Reconciliation Category 27AAAAA0000A1Z5,INV001,2026-03-10,10000,0,900,900,1800,10000,0,900,900,1800,Match,0,,No action,Matched 27BBBBB1111B2Z6,INV002,2026-03-12,5000,450,0,0,450,5000,0,0,0,0,Mismatch,-450,Supplier filed late,Follow up supplier,Only in 2A 27CCCCC2222C3Z7,INV003,2026-03-15,0,0,0,0,0,2000,180,90,90,360,Only in 3B,360,Claimed but not in 2A,Check supplier filing,Only in 3B : Auto-highlights unmatched items or value differences in

: Tax authorities actively issue scrutiny notices if the ITC claimed in GSTR-3B exceeds the amount available in your auto-populated GSTR-2A/2B.

Manual VLOOKUP‑based reconciliation works for small datasets, but it fails when:

If you want a specific to automate the file merging process? Use a fuzzy match filter or manually correct the book entry

Using an Excel template for GSTR 2A and 3B reconciliation offers several benefits:

GSTR 2A and 3B reconciliation in Excel is a vital process for taxpayers to ensure that the Input Tax Credit (ITC) claimed in their self-declared summary return (GSTR-3B) matches the auto-generated details from suppliers (GSTR-2A). Reconciling in Excel allows for large-scale data manipulation using pivot tables, macros, and lookup functions to identify mismatches quickly. Tally Solutions Key Features & Benefits ITC Verification

: An Excel utility designed for Office 365/Excel 2021 that offers multi-level reconciliation and variance reports.

Copy the figures from your filed GSTR‑3B Table‑4 (ITC claimed on inward supplies) and compare with the supplier‑wise totals from Sheet 4.