Skip to Content

<- Back

ITC Reconciliation Tool 2.0


Are you a CA, Tax Consultant, or Finance Manager dreading the annual filing process? The complex and manual task of reconciling the voluminous Purchase Register (PR) against the dynamic GSTR 2B is a major drain on time, increases compliance risk, and directly impacts your ITC.

Excel Utilities presents the ultimate solution: The all-new ITC Reconciliation Tool 2.0 empowers tax professionals to process unlimited GSTINs, catch every missing invoice, and generate audit-ready reports with a single click.

The Hidden Cost of Manual ITC Matching

If you are managing GST compliance for multiple clients or a mid-to-large enterprise, you already know that month-end reconciliation is a high-stress race against the clock.

You download massive, messy GSTR-2B JSON or Excel files from the GST portal, try to align them with your internal, multi-branch Purchase Registers (PR), and pray your VLOOKUP formulas don't break.

The reality of manual matching is costing your practice:

  • Blocked Working Capital: A single typo by a vendor (e.g., billing ₹10,000.50 instead of ₹10,000) causes an unmatched invoice, delaying your legitimate ITC claims.

  • The Amendment Trap: Vendors often file B2B amendments (B2BA) or amend credit notes (CDNRA). Manually tracking these down often leads to double-counting and inevitable departmental notices (ASMT-10).

  • Wasted Billable Hours: Highly paid tax professionals are reduced to data-entry clerks, spending 20+ hours a month fixing date formats (dd-mm-yyyy vs mm/dd/yyyy) and cleaning data instead of advising clients.

It doesn’t have to be this way.

Meet the ITC Reconciliation Tool 2.0

We didn't just build a macro; we built an intelligent compliance engine. The ITC Reconciliation Tool 2.0 operates entirely on your desktop within Microsoft Excel.

  • Zero Data Privacy Risks: Your highly sensitive data never leaves your computer. No cloud uploads, no third-party servers.

  • Zero Per-GSTIN Limits: Whether you process 5 clients or 500, you pay one flat subscription fee for the device.

  • Zero Coding Required: A beautiful, intuitive dashboard lets you control everything with a click.



Transform Your Workflow to Automation & Mitigate the Risk.

Our tool is designed to systematically eliminate the biggest challenges you face, transforming your ITC reconciliation workflow from a liability into an asset.

  • Dynamic Tolerance Engine 
  • Stop losing sleep over rounding errors. Vendors make mistakes. You shouldn't pay for them. Right from the dashboard, you can define exactly how strict the matching engine should be. Set a Value Tolerance (₹) (e.g., allow up to ₹5 difference) and a Date Tolerance (e.g., allow a 3-day variance). The engine dynamically pairs these "Suggested Matches," saving you from manually netting off tiny discrepancies.


  • 5-Tier Intelligent Matching Algorithm 

  • Beyond simple formulas. Our engine processes thousands of rows through 5 rigorous phases in seconds:

    1. Exact Match: Perfect alignment of GSTIN, Invoice Number, Date, and Tax Values.

    2. Fuzzy Match: Leverages your custom tolerances to catch minor vendor typos.

    3. Amount-Based Search: Catches instances where the vendor completely botched the invoice number, but the GSTIN, Date, and exact tax amounts align perfectly.

    4. GSTIN-Level Netting: A revolutionary feature that aggregates all remaining unmatched invoices by Supplier and Month, clearing them if the total variance is under ₹5.


  • Smart Amendment (B2BA/CDNRA) Isolation 

  • Audit-proof your claims. The tool features a pre-reconciliation sweep that automatically detects amended transactions. It instantly traces and tags the superseded original invoices, isolating them so they are never double-counted in your active ITC pool.


  • Seamless Carry Forward (C/F) Integration 
  • Never forget a pending invoice. Have invoices sitting in "Addition in PR" because the vendor hasn't filed their GSTR-1 yet? With one click, import last month's pending list. The tool automatically appends these unfiled transactions into your current month’s reconciliation, maintaining a continuous, flawless tracker.

  • Multi-Branch Consolidation 
  • One master view. For businesses operating across multiple states or branches, the tool allows you to seamlessly consolidate disparate Purchase Registers into one master working sheet before matching begins.

How It Works: A Deep Dive into 4 Simple Steps

Our tool is incredibly intuitive, but beneath the surface lies a powerful, multi-module engine engineered for precise GST compliance. You don't need to be an Excel VBA expert to harness its full potential.

Step 1: Tool Setup & Configuration

  1. Open the downloaded tool and ensure you click Enable Macros when prompted (this is essential for the engine to function).
  2. Navigate to the Dashboard sheet.
  3. Locate the Reconciliation Settings dropdowns. Set your desired Value Tolerance (₹) (e.g., ₹1, ₹5) and Date Tolerance (Days) (e.g., 3, 31). The engine will use these exact rules to pair invoices.

Step 2: Import GSTR-2B Data

  1. On the Dashboard, click the IMPORT GSTR 2B button.
  2. Select the GSTR-2B Excel file(s) downloaded directly from the GST portal.
  3. The tool will automatically extract B2B, CDNR, B2BA, and CDNRA data, format the dates, align the columns, and prepare the data for matching.

Step 3: Prepare Purchase Register (PR) Data

  1. Navigate to the PR (Books) sheet.
  2. Paste your internal purchase data into the designated columns. Ensure mandatory fields like GSTINs, Invoice Number, Invoice Date, and Tax Values are filled accurately.

Step 4: Import Carry-Forward Data (Optional)

  1. If you have unresolved "Addition in PR" or "Addition in 2B" items from the previous month's reconciliation, click the ADD C/F button on the Dashboard.
  2. Select last month's generated report file. The tool will automatically append those pending transactions to the bottom of your current PR and 2B sheets.

Step 5: Run Normal Reconciliation

  1. Click the RECONCILE button on the Dashboard.

  2. The engine will instantly run through 4 critical phases:

    • Pre-Check: Isolates and tags amended invoices.
    • Level 1 (Exact Match): Pairs invoices with identical GSTINs, Dates, and Tax Values.
    • Level 2 (Fuzzy Match): Pairs invoices using your Dashboard Tolerance settings.
    • Level 3 & 4 (Amount-Based & Loose Match): Catches invoices where vendors made typos in the invoice numbers but the amounts and dates align perfectly.
  3. The Dashboard counts will update automatically, giving you a bird's-eye view of your matched and mismatched data.

Step 6: GSTIN Level Reconciliation (When needed)

  1. If you still have significant unmatched data, click the GSTIN LVL RECON button.
  2. Important: This can only be run after the Normal Reconciliation is complete. It aggregates all remaining unmatched data by Supplier GSTIN and Month, matching them if the total variance across all invoices is under ₹5.00.

Step 7: Analyze & Generate Reports

  1. Review the generated remarks in the PR vs 2B sheet.
  2. Click the EXTRACT REPORT button on the Dashboard.
  3. The tool will instantly generate your working files and a Vendor-Wise Addition Report (creating individual sheets for every defaulting vendor), saving them neatly into a new, timestamped folder in the same location your tool is saved.

Understanding Reconciliation Remarks

The tool communicates its findings line-by-line using standard remarks. Here is exactly what they mean:

Remark Tag

What it Means

Next Action

Match

The invoice perfectly matched between Books and 2B (or fell within your accepted tolerance).

None. Ready for ITC claim.

Suggested Match

The engine found the invoice, but a key detail (like the exact date or invoice number) was heavily misspelled by the vendor.

Review manually. If correct, no action needed.

Match (GSTIN)

Individual invoices didn't align, but the total monthly tax amount from this vendor perfectly matches your books.

None. The overall financial impact is netted to zero.

Addition in PR

You have this invoice in your books, but the vendor has not filed it in their GSTR-1/IFF.

Follow up with the vendor.

Addition in 2B

The vendor filed this invoice, but you haven't recorded it in your Purchase Register.

Book the invoice internally or reject it if it doesn't belong to your company.

Mismatch

The invoice exists in both places, but the Taxable Value or Tax Amounts differ beyond your set tolerance.

Investigate the difference and request a Credit/Debit note/ amendment if the vendor errored.

Transaction Amended

The original invoice was superseded by a B2BA or CDNRA filing.

None. The tool will automatically match against the new, amended line item.

Ineligible Transaction

The GST portal flagged this ITC as restricted (e.g., POS mismatch).

Can not claim this ITC.


Generate Actionable Insight Report, Not Just Raw Data

Matching the data is only half the battle; acting on it is what saves money. With a single click of the "Extract Reports" button, the tool generates a folder containing:

  • The Premium PR vs 2B Report: A beautiful, side-by-side exact comparison sheet showing which PR row matched which 2B row, complete with precise remarks (e.g., "Mismatch in Taxable Value").

  • Consolidated Additions Summary: A master list of everything missing from your books (Addition in 2B) and everything missing from the portal (Addition in PR).

  • Vendor-Wise Action Sheets: The ultimate AP tool. It instantly creates individual, dedicated Excel sheets for every single defaulting vendor, giving your Accounts Payable team the exact file they need to block vendor payments until returns are filed.



Who is This Tool For?

This tool is a must-have for anyone dealing with the complexities of GST compliance in India:

  • Chartered Accountants (CAs) and CA Firms looking to increase efficiency and accuracy while managing multiple clients.

  • Tax Consultants and Practitioners who need a reliable tool to deliver fast and accurate reconciliation reports.

  • Corporate Accounts Managers and Finance Teams responsible for internal GST compliance and reporting.

  • Small and Medium Business Owners who handle their own accounting and need a simple yet powerful solution to stay compliant.

  • GST and Indirect Tax Professionals.

Download Your Free Demo Today!

Stop Leaving Your Legitimate ITC on the Table. Join the hundreds of tax professionals who have already cut their month-end compliance time by 90%

Click Here to download a Free Demo

Top questions answered

We’ve answered some of the questions you might have in mind.

- GSTR 2B Data: You need the Excel report downloaded from the GST portal's GSTR-2B. Our tool supports bulk import, allowing you to select and consolidate multiple downloaded files at once.
- PR Data: You must prepare your Purchase Register data (from your accounting software/ERP) and paste it into the dedicated sheet.
Yes. For any complex transaction that you manually confirm, simply navigate to the remarks column on the Purchase Register or Table 8A sheet. Update the remark to "Manual Matched" and include the row reference of the linked transaction. Click the 'Refresh' button on the Dashboard. This executes the monthly calculations and pivot table refresh, automatically incorporating your manual changes into the final summary totals.
Absolutely not. The software is licensed per device, not per GSTIN. You can process unlimited client data, making this an incredibly cost-effective solution for growing CA firms and tax consultants.
The tool is highly optimized and can handle lakhs of invoice entries. While Excel itself has a row limit of just over a million, the tool will comfortably handle the typical volume of invoices for small to medium-sized enterprises for any given tax period.
Your subscription provides a single-device license for maximum security. However, if you upgrade your computer, experience a hard drive crash, or need to format your system, simply reach out to our support team on WhatsApp. We will gladly deactivate your old hardware ID and transfer your active subscription to your new device at no extra cost.
If the GST Network (GSTN) updates the standard column layout or format of the downloaded GSTR-2B file, our development team will issue a compatibility patch. All active subscribers receive these critical software updates completely free of charge during their subscription period.
We offer email and WhatsApp support for all licensed users. You can reach out to us at the email address or on WhatsApp number provided in the tool's Help section, and our team at Excel Utilities will be happy to assist you.

Customers testimonials

What our customers are saying about us.


Rating


 
bought ITC Reconciliation Tool 2.0