Gstr 2a And 3b Reconciliation In Excel Format Download Link Today

| Supplier GSTIN | Invoice No. | Books Value | Portal Value | Value Difference | ITC Books | ITC Portal | ITC Difference | Status | Action Required | |---|---|---|---|---|---|---|---|---|---|

The Goods and Services Tax Network (GSTN) tracks mismatches between auto-populated credits and claimed credits, triggering automated demand notices for discrepancies.

You can construct a highly effective, automated reconciliation workbook by setting up three specific tabs. Copy the column headers below to build your downloadable utility. Tab 1: "GSTR-2A Data" (Portal Download) Column A: Supplier GSTIN Column B: Supplier Legal/Trade Name Column C: Invoice Number Column D: Invoice Type Column E: Invoice Date Column F: Taxable Value Column G: Integrated Tax (IGST) Column H: Central Tax (CGST) Column I: State Tax (SGST) Tab 2: "Purchase Register" (Your Books) Column A: Vendor GSTIN Column B: Vendor Name Column C: Invoice / Voucher Number Column D: Posting Date Column E: Total Taxable Value Column F: IGST Input Column G: CGST Input Column H: SGST Input Tab 3: "Reconciliation Summary Dashboard" gstr 2a and 3b reconciliation in excel format download

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

Ensure that critical fields like Supplier GSTIN , Invoice Number , Invoice Date , and Tax Amount are formatted identically in both sheets (e.g., remove spaces or special characters from invoice numbers). Step 2: Use the VLOOKUP or XLOOKUP Formula | Supplier GSTIN | Invoice No

This paper examines the requirements, challenges, and practical methods for reconciling GSTR‑2A (auto-populated purchase records) with GSTR‑3B (monthly summary return) using Excel-based workflows and a downloadable template. It covers regulatory context, reconciliation objectives, typical mismatches and causes, step‑by‑step procedures to prepare, cleanse, match, and reconcile data in Excel, suggested reconciliation rules and tolerances, automation tips, controls and audit trails, and recommendations for process governance. The paper includes a description of an Excel template structure and sample formulas/macros to implement the reconciliation and a suggested user guide for the downloadable file.

GST laws enforce strict deadlines for claiming ITC for a specific financial year. Timely monthly reconciliation ensures no credit is permanently lost. Copy the column headers below to build your

=IF(B2=C2, "Matched", "Difference") – To flag discrepancies.

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

Download your purchase register (books of accounts) for the same period. Step 2: Standardize the Sheets Open Microsoft Excel and create three sheets: (Your internal purchase register) Sheet 2: "Portal Data" (The downloaded GSTR-2A data) Sheet 3: "Reconciliation Summary" (Where the magic happens)