ERPNextCustom DoctypeWorkflow AutomationAP AutomationFrappeMSME CompliancePayment Run

    From email chaos to zero escalations — a custom ERPNext AP engine for INDmoney

    ~Zero

    Escalations post go-live

    Auto-fill

    Bill details from Tracker

    100%

    Invoice visibility

    Overview

    INDmoney's accounts payable process had a structural problem that no off-the-shelf setting could fix: the entire vendor invoice lifecycle — receipt, approval, posting, payment, and vendor communication — was running on email. With hundreds of vendors, MSME compliance obligations, and a finance team processing invoices at fintech scale, the cracks were showing everywhere.

    Invoices got lost in inboxes. L1 and L2 approvers had no unified view — they'd receive a PDF, download it, form their opinion in isolation, and reply by email. Treasury had no reliable way to know which invoices were approved and payment-ready. Vendors chased the finance team for payment advice. MSME payment timelines were tracked manually, if at all.

    XLURSELF designed and built a fully custom Purchase Invoice Tracker on ERPNext — a purpose-built AP automation engine that transformed the entire workflow into a structured, trackable, auditable process from the moment an invoice arrives to the moment the vendor receives their payment advice.

    01

    Challenge

    The root cause wasn't a missing feature — it was the absence of a single system of record for the AP lifecycle. Vendors emailed invoices to individual finance team members. Approvers reviewed PDFs in their inbox with no context about purchase orders, previous invoices, or MSME status. The finance team manually keyed invoice data into ERPNext, duplicating work that already existed in emails. Treasury ran payment batches from a manually compiled list with no guarantee it was complete.

    The consequences were predictable: service interruptions when payments were delayed, MSME compliance risk from missed statutory timelines, significant escalation volume from vendors following up on payment status, and finance team bandwidth consumed by coordination rather than control. No one had a single view of where any invoice stood at any moment.

    02

    Solution

    XLURSELF built the Purchase Invoice Tracker — a custom ERPNext doctype that serves as the single document of record for every invoice, from receipt to payment. The solution centralised vendor invoice submission to a single email address, from which the AP team uploads invoices to the Tracker. Every invoice then flows through a structured L1 → L2 approval workflow on a purpose-built dashboard — a custom web page with Frappe JavaScript — where approvers see a summary view, can review the invoice inline without downloading, and approve or reject with a single action.

    Once approved, one click from the finance team posts the Purchase Invoice in ERPNext with all relevant fields pre-populated from the Tracker — no re-keying, no duplication. Treasury runs a custom Payment Run report that surfaces all approved, payment-ready invoices and drives the payout process. The Tracker maintains the complete lifecycle status — approval stage, Purchase Receipt, Purchase Order, Purchase Invoice reference, and payment status — all in one document. Vendors access their payment advice directly from the dashboard: a richly formatted print format showing invoice count, TDS deducted, and GST paid. Daily automated alerts remind approvers of pending actions before timelines are breached.

    03

    How We Approached It

    01

    AP Process Mapping & Custom Doctype Architecture

    Mapped the full AP lifecycle across vendor, AP team, L1 approver, L2 approver, finance, and treasury touchpoints. Designed the Purchase Invoice Tracker doctype schema to serve as the single record linking every stage — invoice receipt, approval, ERPNext posting, and payment — with MSME flag and timeline fields built in from day one.

    02

    L1/L2 Approver Dashboard (Custom Web Page + JavaScript)

    Built a custom Frappe web page with JavaScript-driven dashboard for approvers — summary card view of all pending invoices, inline document preview eliminating the need to download PDFs, bulk approval actions, and clear drill-down into ERPNext context (PO, PR, vendor history) without navigating standard forms.

    03

    Approval Workflow & Daily Alert Engine

    Configured the ERPNext workflow engine for the L1 → L2 approval chain with state-based transitions, role-based permissions, and rejection routing back to the AP team. Built a daily scheduled alert job that emails each approver their pending invoice summary — eliminating the need for manual follow-up and preventing deadline breaches.

    04

    PR-Based PI Creation with Tracker Auto-Fill

    Added a custom Tracker fetch button during PI creation. User selects the relevant Tracker ID and verified fields auto-fill in the Purchase Invoice — vendor invoice number/date, amount, receipt date, approval details, and invoice attachment. This significantly reduces PI creation time and supports easier MSME compliance through consistent receipt-date capture.

    05

    Treasury Payment Run Report & Interactive Payment Advice

    Built the custom Payment Run report for treasury — filterable by due date, vendor, MSME status, and payment priority — showing all approved, uncleared invoices in a single view for batch processing. Designed the interactive Payment Advice print format: per-vendor output showing invoice list, amounts, TDS deducted, and GST paid — downloadable directly by the vendor from the Tracker dashboard, with no finance team involvement.

    04

    Impact

    ~Zero

    Escalations post go-live

    Vendor payment-status escalations dropped to near zero — vendors now track their own payment status and download advice from the dashboard independently.

    Auto-fill

    Bill details from Tracker

    Verified tracker data and attachments flow into the Purchase Invoice, reducing manual entry effort significantly.

    100%

    Invoice visibility

    Every invoice in the pipeline has a real-time status: pending approval, approved, posted, payment scheduled, paid. No invoice falls through the cracks.

    MSME-safe

    Compliance tracking

    MSME vendor flag and payment timeline tracked at the Tracker level — statutory 45-day payment obligations visible and alertable before breach.

    Key Outcomes

    • Single AP system of record: approval status, PO, PR, Purchase Invoice, and payment all linked in one Tracker document
    • Custom L1/L2 approver dashboard — inline invoice review, no PDF downloads, no email back-and-forth
    • Daily automated approver alerts eliminating payment delays from missed review deadlines
    • Tracker-driven Purchase Invoice auto-fill with verified details and attachment mapping
    • Treasury Payment Run report driving batch payouts from a single, always-accurate approved invoice view
    • Vendor self-service payment advice download — rich print format with TDS, GST, and invoice breakdown
    • MSME vendor payment timeline tracking with statutory deadline visibility

    Facing a similar challenge?

    Let's talk about what's broken in your finance operations. The first conversation is free, focused, and no-pitch.