Gstr 2a And 3b Reconciliation In Excel Format Download !full! Jun 2026

Several tax portals and professionals offer free/paid templates. For a reliable and :

Paste the raw data downloaded from the portal into this sheet. Ensure the following headers are aligned from Column A to H: GSTR2A & GSTR2B Automatic Reconciliation Excel Tool

Invoice not recorded in your accounting software, or it belongs to another business entity (wrong GSTIN entered by supplier).

Invoice numbers are often entered differently by suppliers and your internal team (e.g., "INV-01" vs "INV/01"). To bypass this, create a helper column called in Column H of both sheets. gstr 2a and 3b reconciliation in excel format download

Copy and paste this structured framework into a blank Excel sheet to create your functional reconciliation tool instantly: Vendor Name Invoice No Taxable Amt 2. GSTR 2A Data Vendor Name Invoice No Taxable Amt 3. Recon Sheet Unique Key Portal Tax Action Required Formula Rules for the Recon Sheet

Consolidate your data into one workbook with two distinct tabs: : "GSTR 2A Data" (Portal Data) Tab 2 : "Purchase Register" (Your Book Data) Ensure both tabs contain these standardized columns: Supplier GSTIN Supplier Name Invoice Number Invoice Date Taxable Value Integrated Tax (IGST) Central Tax (CGST) State Tax (SGST) Step 3: Standardize the Invoice Numbers

To simplify your monthly filing process, we have created an automated Excel template designed to handle large datasets, auto-populate formulas, and highlight discrepancies. Invoice numbers are often entered differently by suppliers

If you download a standard reconciliation utility, the workflow generally looks like this:

Suppliers often enter invoice numbers differently (e.g., "INV-001" vs "001"). Use Excel formulas like TRIM and CLEAN to eliminate spaces and special characters. This ensures accurate matching. Step 4: Use VLOOKUP or XLOOKUP for Matching

: Paste your internal purchase register data into the Books Data tab. 4. Execute the Reconciliation Formula Step A : Navigate to the Reconciliation Sheet tab. GSTR 2A Data Vendor Name Invoice No Taxable Amt 3

Verify the original physical invoice and correct the mistake.

Invoice numbers can sometimes format differently. To prevent false mismatches, create a helper column combining the GSTIN and Invoice Number using =A2&C2 . Use this combined key for your XLOOKUP arrays.

You missed recording the invoice in your accounting system, or the supplier entered your GSTIN by mistake.