Under the Indian Goods and Services Tax (GST) regime, claiming Input Tax Credit (ITC) has become strictly vendor-dependent. According to Section 16(2)(aa) of the CGST Act, you can only claim ITC on a purchase invoice if your supplier has uploaded it in their GSTR-1 and it appears in your auto-drafted monthly GSTR 2B statement.

Because of this, monthly reconciliation between your Purchase Register (Books) and GSTR 2B has transitioned from a year-end auditing luxury to a mandatory monthly compliance routine. In this guide, we will cover how to structure your files, resolve common mapping issues, and run a fast, styled reconciliation using Audit Apply's 100% local, secure toolkit.

1. What is GSTR 2B Reconciliation and Why is it Critical?

Failure to reconcile your purchase ledger against GSTR 2B leads to two major financial risks:

• Excess ITC Claim: Claiming credit for invoices not present in GSTR 2B can trigger automated GST portal notices (such as Form GST ASMT-10) demanding repayment with interest (18% per annum) and penalties.
• Unclaimed/Lost ITC: If you omit claiming eligible ITC because the supplier has uploaded the invoice but you forgot to record the transaction, you block vital working capital.

2. How to Download GSTR 2B Excel from GST Portal

Log in to the GST Portal, go to Services > Returns > Returns Dashboard, select the financial year and tax period, click Search, and under Auto-drafted ITC Statement GSTR-2B, click 'Download' and choose the Excel format.

3. Structuring Your GSTR 2B Reconciliation Format in Excel

To run a seamless reconciliation, prepare the following two files:

File A: Your Purchase Register (Books)

This is exported from your accounting software (e.g. Tally Prime, Zoho Books, SAP, or Busy). Ensure it contains the following column categories:

• GSTIN/UIN of the suppliers.
• Invoice Number (Document Number).
• Invoice Date.
• Taxable Value (If split across multiple ledger accounts like purchases, packing charges, labour expenses, select all of them during mapping).
• IGST, CGST, and SGST amounts.
• Supplier/Particulars Name (Optional, but highly recommended for sheet generation).

File B: The GSTR 2B Statement

Download the official monthly GSTR 2B Excel workbook from the GST Portal. It typically contains sheets like B2B, B2BA, CDNR, etc. The tool is pre-configured to read and map standard GSTR 2B/2A columns automatically, even if they use portal abbreviations (such as TAX. VAL, INVOICE DT, or VALUE).

4. How to Automate GSTR 2B Matching with Audit Apply

Follow these 5 simple steps to complete your reconciliation:

Step 1: Upload Your Files

Navigate to the GSTR-2B Invoice Reconciliation tab. Drag and drop your Books Purchase Register and your downloaded GSTR 2B Excel statement into their respective upload zones.

Step 2: Smart Columns Mapping

Once you upload your Purchase Register, a Column Mapping Modal will appear. The tool auto-detects matching headers. Review and adjust them:

• Supplier Name: Map this to your ledger's supplier name column (e.g. Particulars or Supplier) to output supplier names in the final reports.
• Multi-Select Taxable Values: If your ledger splits expenses across columns (such as base purchases, freight charges, advertisement expenses, and labour charges), check all applicable boxes. The tool will sum them up automatically for each invoice row.

Step 3: Run the Reconciliation Engine

Click Run Reconciliation. The local engine will clean and process the data instantly. It normalizes invoice numbers (stripping leading zeros, slashes, or dashes) to prevent mismatch false alarms caused by minor notation differences.

Step 4: Analyze Mismatch Categories

Review the results directly on the live dashboard. The invoices are sorted into 4 clear categories:

1. Reconciled (Perfect Matches): Invoices matching on GSTIN, Invoice No, Taxable Value, and Tax amounts.
2. Mismatched Invoices: Invoices matched by document number, but having discrepancies in Taxable Value, Tax amounts, or invoice dates.
3. Missing in GSTR-2B: Invoices present in your Books but not uploaded by the supplier. You should withhold payment of GST to these vendors until they file their returns.
4. Missing in Books (Unrecorded): Invoices uploaded by suppliers on the portal but not recorded in your accounting software. You must book these entries to claim the credit.

Step 5: Export a Premium styled Excel Report

Click Export Reconciled Report (Excel). The assistant will download a beautifully formatted multi-sheet Excel file featuring:

• Zebra Striping & Border Formatting for comfortable data auditing.
• Dynamic Column Autofitting to avoid cropped numeric values.
• Color-Coded Sheet Tabs: Summary is Charcoal Gray, Reconciled is Emerald Green, Mismatches are Orange, Missing in GSTR-2B is Red, and Unrecorded in Books is Blue.
• Flagged Discrepancies: Large tax differences and mismatch reasons are clearly highlighted in red.

5. Why Audit Apply is the Best Free GSTR 2B Reconciliation Tool

Audit Apply's free GSTR 2B reconciliation tool processes all calculation modules, PDF modifications, and Excel reconciliation operations **100% inside your local web browser**. Your financial statements, client GSTINs, and purchase ledgers are never uploaded to our servers, keeping your sensitive client data private and secure.