EffCorp GSTR2 vs Purchase Register Reconciliation Tool — Free Desktop App

Description

Stop spending hours on manual VLOOKUP matching. Reconcile your GSTR2A / GSTR2B against your Purchase Register in minutes — free, offline, no Excel formulas needed.

EffCorp GSTR2 Reconciliation Tool is a free Windows desktop application built for accountants, CA firms, and finance teams who need a fast, accurate way to match GST portal data against their books every month.

The Problem It Solves

Every month, businesses must compare invoices appearing in their GSTR2A or GSTR2B (GST Portal) against their Purchase Register to claim accurate Input Tax Credit (ITC). Doing this manually in Excel is time-consuming, error-prone, and gets worse as invoice volumes grow. This tool automates the entire process.

Key Features

Smart 6-Pass Matching Engine The tool attempts to match every invoice through six passes — from strictest to most flexible — so no legitimate match is missed:

• Pass 1: GSTIN + Invoice Number + Invoice Date (exact 3-way match)
• Pass 2: GSTIN + Invoice Number
• Pass 3: GSTIN + Invoice Date
• Pass 4: PAN + Invoice Number + Invoice Date
• Pass 5: PAN + Invoice Number
• Pass 6: PAN + Invoice Date
• Fuzzy Match: Catches near-identical invoice numbers with minor typos or formatting differences (90% similarity threshold)

Flexible Column Mapping Works with any Purchase Register format — SAP, Tally, Busy, or any custom ERP export. You simply map your column names to the required fields before running the reconciliation. No need to reformat your data.

Tolerance Limit Set a rupee tolerance (e.g., ±1.00) to automatically match invoices where tax amounts differ slightly due to rounding — a common real-world scenario.

GSTR2A and GSTR2B Support Fully compatible with both GSTR2A (auto-populated, buyer-facing) and GSTR2B (system-generated, locked) formats as downloaded from the GST Portal.

In-App Summary The moment reconciliation completes, a full summary table appears inside the app — total invoices, matched count, unmatched count, tax amounts by category, and a verification check (Balanced / Mismatch) — without needing to open any file.

14-Sheet Formatted Excel Working File Every run saves a detailed, colour-coded Excel working file containing:

100% Offline and Secure No internet connection required. Your financial data never leaves your computer.

No Installation Required Single .exe file — download and run directly. No Python, no dependencies, nothing to install.

Free Forever No trial. No subscription. No login. Completely free.

Mandatory Input Requirements

Before running the tool, ensure your files meet these requirements:

GSTR2 File (Portal Download)

• Format: .xlsx only
• Source: Downloaded directly from GST Portal (GSTR2A or GSTR2B)
• The tool reads the sheet you select — choose the correct sheet from the dropdown inside the app

Purchase Register File

• Format: .xlsx only
• Must contain at minimum: Supplier GSTIN, Invoice Number, Invoice Date, and at least one tax amount column (IGST / CGST / SGST)
• Column names do not need to match any standard — you map them inside the app

How to Use

Step 1 — Load GSTR2 File Click Browse, select your GSTR2A or GSTR2B Excel file, and choose the relevant sheet from the dropdown. The app shows the row and column count for confirmation.

Step 2 — Load Purchase Register Click Browse, select your Purchase Register Excel file, and choose the sheet containing your invoice data.

Step 3 — Map Columns Match your Purchase Register columns to the required fields:

• Supplier GSTIN
• Invoice Number
• Invoice Date
• IGST, CGST, SGST amounts

Set a tolerance limit if needed (default is 0).

Step 4 — Run and Review Click Run Reconciliation. The in-app summary table populates instantly. Review matched, unmatched, and excluded counts along with tax totals. Click Save Working File to export the full 14-sheet Excel report to your chosen folder.

Who Is This For

• CA firms handling monthly GST compliance for multiple clients
• In-house accounts and finance teams
• Tax professionals preparing ITC reconciliation statements
• Businesses preparing for GST audits or filing annual returns (GSTR-9)

System Requirements

• Windows 10 or Windows 11 (64-bit)
• No additional software required
• Input files must be in .xlsx format

Developed by Efficient Corporates Pvt Ltd Contact: efficientcorporates@gmail.com | +91-74640 98001 Can be used for individual and professional purposes. REDISTRIBUTION IS STRICTLY PROHIBITED