1. Problem Statement

Every CA firm in India performs GSTR-2B reconciliation monthly for each of their clients - matching the client's Purchase Register against GSTR-2B data downloaded from the GST portal. This process involves identifying:

1. Invoices that match cleanly between books and GSTR-2B
2. Invoices with tax amount mismatches
3. Invoices present in books but missing in GSTR-2B (ITC at risk)
4. Invoices present in GSTR-2B but not recorded in books (missed ITC claim)

For a client with 200–300 invoices, this manual process takes 2–3 hours. A CA firm handling 30 clients spends 60–90 hours every month on reconciliation alone - time that could be spent on advisory, compliance review, or higher-value client service.

The risk is equally significant. A missed mismatch means incorrect ITC claimed, which leads to GST notices, interest under Section 50, and potential penalties. Manual reconciliation is error-prone by nature, not by negligence.

2. Existing Solutions and the Gap

Enterprise tools such as ClearTax, IRIS GST, and Tally Prime integrations offer reconciliation features. However:

1. They are subscription-based, typically costing Rs. 10,000–50,000 annually
2. They are cloud-dependent, raising data privacy concerns for sensitive client financials
3. They require onboarding, migration, and staff training
4. They are designed for large enterprises, not mid-size CA practices

The majority of CA firms in India - particularly those with 5–50 staff - continue to perform reconciliation manually in Excel. There is no accessible, offline, zero-subscription solution built specifically for how CA firms actually work. This is the gap the tool addresses.

3. Solution

An Excel-based automated GSTR-2B reconciliation tool built using VBA (Visual Basic for Applications), designed specifically for CA firms and tax consultants.

The tool accepts two inputs - the client's Purchase Register and GSTR-2B data - and produces a fully categorised reconciliation output in seconds, with colour-coded results for immediate readability.

Reconciliation Output Categories

1. Matched - invoices reconciled cleanly, no action required
2. Matched with Amount Mismatch - same invoice identified, but tax amount differs; exact difference shown per tax head
3. In Books Not in 2B - ITC at risk due to supplier non-filing or filing delay
4. In 2B Not in Books - potential missed ITC claim by the client

Key Technical Features

1. Header-based column detection - robust to structural variations in input data; no hardcoded column positions
2. GSTIN-based primary matching with Trade Name and Invoice Number fallback for records with missing GSTIN
3. Automatic Total Tax computation across IGST, CGST, SGST, and CESS
4. Duplicate detection within input data before reconciliation runs
5. License-based access control with machine-level fingerprinting for copy protection - works fully offline
6. No internet dependency - all data remains local on the user's system

Technology Used

1. Microsoft Excel VBA - core automation and reconciliation engine
2. Claude AI (Anthropic) - used as a development partner for writing and debugging VBA logic, structuring the matching algorithm, and handling edge cases
3. Domain logic, matching rules, exception handling, and output design - built entirely on CA practice experience and GST compliance knowledge

4. Impact and Benefits

5. Industry Relevance

1. Applicable to every GST-registered business and every CA firm handling GST compliance across India
2. Directly reduces ITC leakage and month-end compliance risk
3. Empowers smaller and mid-size CA firms with reconciliation capabilities previously available only to large practices with enterprise software budgets
4. Frees CA professionals from mechanical, repetitive matching work to focus on advisory, review, and judgment-based tasks
5. No learning curve - built inside Microsoft Excel, the software CA firms already use daily
6. No data leaves the client environment - critical for firms handling sensitive financial data across multiple clients

6. Roadmap

The current version handles the core reconciliation workflow. The following enhancements are planned:

1. Eligible and Ineligible ITC Classification - automatic classification of ITC into eligible and blocked credits under Section 17(5), so the CA not only sees what is mismatched but also knows what ITC can actually be claimed
2. Cross-Period Reconciliation - handling invoices booked in one period but reflected in a subsequent month's GSTR-2B, which is a common timing difference in practice

7. Conclusion

This tool demonstrates that meaningful automation in the CA profession does not require expensive software, cloud infrastructure, or a large technology team. Built by a Chartered Accountant using accessible technology, it addresses a real, recurring pain point faced by every GST practice in India.

The result is faster reconciliation, reduced ITC risk, lower compliance cost, and more time for CAs to focus on work that requires professional judgment - not manual data matching.

The core insight is simple: the problem is not that CA firms lack tools. It is that available tools are either too expensive or too complex for day-to-day practice. This is built by a CA, for CA firms, in the software they already use.