Reconciliations for GST Audits Through Automation

1. VARIOUS RECONCILIATIONS - EXPLANATIONS

A. Supplier-side Reconciliations

1. GSTR-2A vs Books (Purchase Register)

• Purpose: Identify missing credits, excess credits, ineligible credits.
• Key mismatches: Vendor not filed GSTR-1, wrong GSTIN, wrong tax rate, debit/credit notes not updated.

2. GSTR-2B vs Books

• Static statement basis for ITC availment.
• Key checks: ITC eligibility, blocked credits, ITC deferred due to time of supply issues.

3. Purchase Register vs GSTR-3B ITC Claimed

• Validates ITC actually claimed vs eligible ITC.
• Helpful in detection of wrong ITC, RCM missed entries.

B. Outward Supply Reconciliations

1. GSTR-1 vs Books (Sales Register)

• Ensures outward supplies reported accurately.
• Typical mismatches: Unreported invoices, amendments not passed, credit notes timing issues.

2. GSTR-1 vs GSTR-3B (Tax Liability)

• Identifies under-reporting/over-reporting of liability.
• Checks correctness of tax rate, place of supply, reverse charge liability reporting.

3. E-Invoices vs GSTR-1

• Ensures e-invoice IRN details match GSTR-1 auto-population.
• Identifies e-invoice errors or cancelled e-invoices not updated in returns.

4. E-Way Bills vs GSTR-1

• Ensures movement of goods is properly reported.
• Detects cases where goods moved but not reported in GSTR-1.

C. Other Critical Audit Reconciliations

• Books vs Annual Return (GSTR-9)
• Financial Statements vs GST Returns
• RCM Register vs GSTR-3B
• Turnover Reconciliation for Income Tax vs GST
• HSN-Wise Reconciliations
• Reconciliation of Advances vs Tax Payment under Time of Supply
• Credit Note/Debit Note Reconciliations
• Reconciliation of ITC Reversal under Rules 42/43

2. DEMO - RECONCILIATIONS ON THE AUTOMATION TOOL

You can structure your demonstration as follows:

A. Importing Data

• Upload GSTR-1 JSON/ Excel
• Upload GSTR-3B
• Upload 2A/2B
• Upload Purchase & Sales Registers

B. Automated Comparison Modules

1. 3-way purchase reconciliation (Books vs 2A vs 2B)
2. Sales reconciliation (Books vs GSTR-1 vs e-invoice)
3. GST computation auto-validation with GSTR-3B
4. PAN-level vendor summarisation
5. Invoice-level matching with mismatch reasons (automated classification):

• Tax difference
• Date difference
• Invoice not in 2A/2B
• Supplier not filed GSTR-1
• Wrong GSTIN
• Duplicate invoices
• B2B treated as B2C etc.

C. Automated Exception Reports

• Missing invoices
• Excess ITC
• Ineligible ITC
• Tax rate mismatch
• Turnover mismatch

D. Export & Sharing

• Export mismatch sheets
• Export reconciled data
• How students can use their own login to perform reconciliations

Exclusive for All Participants - Lifetime Tool Access

1. Every student attending this lecture will receive lifetime free access to the GST Reconciliation Automation Tool.
2. Access will be provided through their registered email ID.
3. Students can independently perform:

• GSTR-1, GSTR-3B, 2A/2B reconciliations
• Purchase/Sales register analysis
• Vendor-wise ITC matching
• Automated exception reporting
• Monthly and annual GST audit reconciliations