Introduction

In large manufacturing enterprises operating on SAP HANA/ERP System, vendor reconciliation is one of the most critical yet time-consuming month-end activities. Discrepancies between vendor-submitted statements and ledger data can lead to incorrect liabilities, GST mismatches, and delayed payments — all of which directly impact audit quality and working capital management.

This use case presents a full-stack AI-powered Vendor Reconciliation Portal (VRP) developed and deployed at the plant finance level, demonstrating how a Chartered Accountant can independently architect and implement an enterprise-grade automation solution using modern AI tools.

Problem Statement

Finance teams at organisation face the following reconciliation challenges:

1. Vendors submit ledger statements in inconsistent formats — Excel, PDF, Word, or image-based scans — making standardized processing impossible
2. Manual matching of vendor ledger lines against SAP open items is prone to errors and consumes 3–5 working days per month-end cycle
3. There is no centralized audit trail of reconciliation communications — emails are scattered, versions are untracked
4. Escalation and vendor follow-up depend entirely on individual team members rather than a system-driven workflow
5. Sensitive financial data is shared via insecure channels without any access control

Technology Used

Solution — How the VRP Works

1. Vendor Onboarding & Secure Upload Each vendor receives a unique login to the portal. They upload their ledger statement in any format — PDF, Excel, CSV, or image. The portal accepts all without requiring any standardization from the vendor's side.

2. AI-Powered Ledger Parsing The API acts as the intelligence layer. Regardless of whether the vendor sends a scanned PDF or a multi-column Excel, AI reads, understands the document structure, and extracts line-item data — invoice number, date, amount, debit/credit — into a standardized JSON format.

3. Automated Reconciliation Engine The extracted vendor data is matched against the open items pulled for that vendor. The system applies a three-level matching logic:

1. Company/AP ledger is the base and vendor ledger is compared against it.
2. Closing balance must match within Rs 1; otherwise reconciliation is not closed.
3. Invoices match mainly by normalized invoice number, then gross value, date, GST, and TDS.
4. Score 82%+ is matched, 45%-81% is partial, and below 45% is unmatched.
5. Payments, credit notes, debit notes, duplicates, and missing entries are separately checked and flagged.

4. Discrepancy Report Generation A structured reconciliation report is auto-generated, showing matched items, unmatched items (with reasons), and the net reconciling difference. This is stored in Local Folder with a full audit trail.

5. Automated Email Communication via Google Script The system dispatches a personalized email to the vendor with the reconciliation report attached — without any manual intervention from the finance team. Escalation reminders are also triggered if the vendor does not respond within a defined SLA.

Benefits Delivered

Innovation & Differentiators

1. Format-agnostic AI parsing: Unlike conventional reconciliation tools that require templated inputs, VRP accepts any vendor ledger format — a true enterprise-grade capability
2. Fully self-built by a CA: Designed, developed, and deployed by a Chartered Accountant — demonstrating the expanding role of CAs as finance technology architects
3. SAP-integrated workflow: Directly aligned with SAP HANA data without any middleware cost
4. Data privacy: Runs on a locally hosted or company-controlled server — no vendor data is shared with third-party SaaS platforms
5. Scalable across plants: The same portal can be extended to cover all type of organisation codes and vendor bases with minimal configuration
6. Local Machine Learning: The local machine also learns from the AI results leading improvement in the solution provided

Conclusion

The AI-based Vendor Reconciliation Portal demonstrates how finance professionals can leverage cutting-edge AI tools to solve real, high-stakes operational problems — without dependence on expensive ERP add-ons. By combining the AI API with a robust Node.js backend, local database, and Gmail automation, this solution transforms a process that once took days into one that completes in minutes.

This use case reflects ICAI's vision of Chartered Accountants as digital transformation leaders — capable of not just using AI, but architecting AI-native solutions for the Indian finance ecosystem.