Introduction

​In today's complex regulatory environment, GSTR-2B reconciliation has become a critical yet time-consuming task for every practicing Chartered Accountant and business. The manual process of matching thousands of invoices between books of accounts and the GSTR-2B portal is prone to human error, leading to incorrect Input Tax Credit (ITC) claims, potential notices, and significant time investment.

​Developed as part of the ICAI AI Hackathon, this GSTR-2B Reconciliation Tool is engineered to transform this cumbersome process into a swift, accurate, and automated workflow. It moves beyond simple VLOOKUPs and manual checks, offering an intelligent, secure, and comprehensive solution built for professionals.

​## Core Features & Capabilities 💡

​This tool is designed from the ground up to address the real-world challenges of GST reconciliation.

​✅ Intelligent Client Management

​The application securely saves settings and column mapping preferences for each client. This "set it and forget it" approach means you spend seconds on setup for recurring reconciliations, not minutes.

​✅ Flexible & Powerful Data Upload

1. ​Multiple File Formats: Upload your Purchase Register, Journal Vouchers, and Payment data in .xlsx format.
2. ​Bulk GSTR-2B Handling: Reconcile for a quarter or an entire year by uploading multiple GSTR-2B files at once. The tool intelligently consolidates all the data seamlessly.

​✅ Smart Column Mapping with Auto-Suggestion

​The tool's most significant time-saver. It automatically detects column headers from your Excel files and suggests the correct mappings for fields like "Invoice Number," "Supplier GSTIN," and "Invoice Value," drastically reducing manual setup.

​✅ Pre-Validation and Data Preview

​Before running the reconciliation, the tool shows you a preview of your data and flags potential errors like invalid GSTIN formats or incorrect dates. This ensures data integrity from the start, preventing garbage-in, garbage-out results.

​✅ Advanced 3-Tier Reconciliation Engine

​This is the heart of the application, going far beyond simple one-to-one matching:

1. ​Exact Matching: Instantly finds and matches all perfect one-to-one entries.
2. ​Partial Matching: Intelligently identifies and flags invoices where key details like GSTIN and Invoice Number match, but dates or amounts differ. It presents them side-by-side with differences highlighted.
3. ​Fuzzy Matching (Probable Matches): The tool's most unique feature. It uses advanced algorithms to find and suggest matches even with typos, extra spaces, or format differences (e.g., INV/001 vs INV-1). This single feature finds matches that are almost impossible to locate manually.

​✅ Interactive Dashboard & Visual Reports 📊

​The moment the reconciliation is complete, you get an instant, high-level overview with Chart.js powered graphs. A doughnut chart shows the ITC value breakdown (Matched, In Books Only, In 2B Only), giving you immediate insight into the scale of discrepancies.

​✅ Offline, Secure, and Standalone

​As a standalone desktop application, all your sensitive client financial data remains on your computer. There is no cloud upload, ensuring complete data privacy and security.

​## A Practical Use Case Scenario

​Imagine a new client provides you with a purchase register for an entire year with over 15,000 entries. The data is messy, with inconsistent column names and typos in invoice numbers.

1. ​Instant Setup: You create the client in the app. You upload their purchase register and all 12 GSTR-2B files for the year.
2. ​Effortless Mapping: The tool’s Smart Mapping feature instantly suggests 90% of the column mappings. You quickly confirm them.
3. ​Intelligent Reconciliation: You click "Start Reconciliation." The app's Web Worker runs the entire process in the background without freezing.
4. ​Immediate Insights: Within minutes, the Dashboard appears. You instantly see that 85% of the ITC is matched, 10% is present only in the books, and 5% requires investigation.
5. ​Actionable Results: You navigate to the "In Books, Not in 2B" tab. The data is already sorted, and you use the built-in notes and status dropdowns to mark entries for follow-up with the client. The Fuzzy Match tab shows you 50+ invoices that were missed due to typos, instantly recovering potential ITC.
6. ​Professional Export: You click "Download Report." A professionally styled, multi-sheet Excel workbook is generated. You can now send this clean, actionable report directly to your client.

​What took days of manual effort is now completed with accuracy and clarity in under 30 minutes.