GST reconciliation software free download in Excel: templates, macros, and browser tools

Every month between the 14th and the 20th, accountants and business owners face the same bottleneck: comparing hundreds of purchase entries against the government portal before filing GSTR-3B. Searching for free reconciliation software usually brings up demo versions of paid software, complex macro sheets that crash under heavy data, or portals demanding your portal credentials. A disciplined reconciliation process does not require paid software, provided you know how to structure your data and understand the legal matching rules.

The legal rule: why invoice matching is mandatory

Under Section 16(2)(aa) of the CGST Act, a registered recipient can claim input tax credit (ITC) only if the supplier has furnished the invoice in their statement of outward supplies (GSTR-1 or IFF) and the details have been communicated to the recipient in Form GSTR-2B. In addition, Rule 36(4) of the CGST Rules removed the earlier provisional credit buffers, restricting ITC strictly to what is reflected in GSTR-2B.

If you claim ITC in Table 4(A)(5) of GSTR-3B that exceeds your GSTR-2B statement beyond notified limits, the GST portal issues an intimation in Form DRC-01C under Rule 88D. You must either pay the differential tax with interest or explain the reasons within seven days. Claiming unverified ITC also exposes the business to 18% annual interest under Section 50(3) if that credit is utilised. Therefore, matching every single invoice is a monthly operational requirement.

Three ways to reconcile without paid software

Small businesses and tax practitioners handle free reconciliation through three main routes. Each comes with clear trade-offs in setup time, speed, and data privacy. You can review our comprehensive GSTR-2B reconciliation software guide for an architectural comparison across tools.

1. Free formula-based Excel template (.xlsx)

A formula-based template uses standard spreadsheet functions such as INDEX, MATCH, and SUMIFS. You paste your purchase register into one tab and the portal GSTR-2B Excel into a second tab. A composite key (Supplier GSTIN combined with invoice number) links both sides.

We provide a dedicated walkthrough and formula structure in our free GSTR-2B reconciliation Excel format guide. While formulas are completely safe and contain no malicious code, manual copy-pasting takes significant time when handling multiple GSTINs or hundreds of invoices.

2. Macro-enabled Excel utilities (.xlsm)

Many tax forums and YouTube channels distribute free Excel utilities powered by Visual Basic for Applications (VBA) macros. These sheets use buttons to automate text cleaning, vlookups, and report generation.

However, macro workbooks have severe practical drawbacks:

• Security blocks: Microsoft Excel automatically blocks macros in files downloaded from the internet under default security policies. Unblocking them requires changing trust center settings.
• Fragility: Macro scripts depend on exact column headers and row positions. If your Tally, Busy, or Zoho Books export has an extra header row or renamed column, the macro halts with a runtime error.
• No updates for portal changes: When GSTN updates the GSTR-2B structure or adds new tables like IMS, older macro sheets fail to process the new format.

3. Private in-browser reconciliation

Modern web standards allow your browser to parse Excel (.xlsx) and JSON files directly on your local device without sending any data to a remote server. You drag and drop the official GSTR-2B download and your purchase register, map the columns visually, and review instant matched, mismatched, and missing invoice buckets.

Step-by-step: how to build a free Excel reconciliation sheet

If you prefer using your own spreadsheet, follow this 4-step workflow to build an exact match model.

Step 1: Download GSTR-2B from the GST portal

Log in to the GST portal after the 14th of the month. Navigate to Services → Returns → Returns Dashboard, choose the financial year and return period, and click Search. Under Form GSTR-2B, click Download and choose the Excel file. The downloaded workbook contains multiple sheets including B2B, B2BA, CDNR, and CDNRA.

Step 2: Clean and normalise invoice numbers

Under Rule 46(b), an invoice number may contain alphabets, numerals, and special characters (hyphen - and slash /) up to 16 characters. Accountants often enter invoice numbers differently than suppliers. For example, a supplier might write INV/26-27/045, while your accounts clerk enters INV-26-27-45 or drops leading zeros.

In your spreadsheet, create a cleaned invoice column using substitution formulas or text functions to strip slashes, hyphens, and leading zeros. This ensures that minor formatting variations do not cause false mismatch reports.

Step 3: Create the unique composite key

Never match on invoice number alone. Rule 46(b) requires invoice numbers to be unique only within the supplier's own series for a financial year. Multiple suppliers can issue invoice number 001. Always combine the supplier GSTIN and the normalised invoice number in a helper column:

=UPPER(TRIM(A2)) & "|" & UPPER(SUBSTITUTE(SUBSTITUTE(B2,"-",""),"/",""))

Step 4: Match and calculate tax differences

Use MATCH to locate the key in the GSTR-2B sheet and INDEX to pull the total tax (Integrated Tax + Central Tax + State Tax). Compute the difference between books tax and 2B tax. Apply a ₹1.00 tolerance for rounding per Section 170:

=IF(ABS(BooksTax - GSTR2BTax) <= 1.00, "Matched", "Value mismatch")

Worked example: sorting invoices into reconciliation buckets

Consider an engineering firm reconciling five purchase invoices for September 2026. The purchase register shows ₹77,400 in total input tax. Here is how the invoices sort after running the reconciliation rules:

The summary results show:

• Eligible matched ITC: ₹55,799.40 across three invoices, ready for claim in GSTR-3B Table 4(A)(5).
• Value mismatch: ₹900 tax gap on invoice TX-504. The supplier declared taxable turnover of ₹45,000 instead of ₹50,000 in GSTR-1. Claim only ₹8,100 now, and request a GSTR-1A amendment.
• ITC at risk: ₹12,600 on invoice SR/102. This invoice is missing from GSTR-2B. You cannot claim this credit in the current month.

Common mistakes in free Excel reconciliation

• Matching only on invoice numbers: Forgetting to include the supplier GSTIN in the lookup key results in mismatched suppliers whenever standard numbers like 001 or 101 repeat.
• Ignoring credit notes: The portal GSTR-2B contains separate tables for CDNR (credit and debit notes). If you reconcile only the B2B sheet, your net ITC claim will be overstated.
• Failing to track amendment tables: Invoices amended by suppliers appear in table B2BA or CDNRA. Basic VLOOKUP formulas that look only at the B2B sheet will miss amended tax amounts.
• Not verifying payment within 180 days: Under the second proviso to Section 16(2) and Rule 37, ITC must be reversed with interest if the supplier is not paid within 180 days of the invoice date. Spreadsheets tracking only tax values overlook invoice aging.

Frequently asked questions

Last checked: 10 October 2026. Sources: CGST Act Section 16, Notification 40/2021-Central Tax (Rule 36(4)), Notification 38/2023-Central Tax (Rule 88D), CGST Rules Rule 46, GSTN IMS FAQ, GSTN GSTR-3B User Manual.