Case study · Loan advisory
“Has the CMA come in yet?”
VPinnacle arranges business loans for its clients through banks. Every file needs a teaser, CMA, GST returns, bank statements and collateral papers, and often goes to more than one bank. All of it was tracked across WhatsApp, email and Excel. We built one system that follows each file from first enquiry to disbursal.
The pipeline
One file, six stages, often several banks.
Every enquiry becomes an application, then a loan, then one bank application per lender it goes to.
- 0148LeadsEnquiries from partners, referrals and direct
- 0226ApplicationsDocuments collected and the applicant assessed
- 0321LoansAmount, loan type and salesperson fixed
- 0419Bank applicationsLogged with one or more banks
- 0511SanctionedApproved by a bank, terms agreed
- 068DisbursedMoney released, commission due
Files open in one month, illustrative.
The problem
Four things that slowed every file.
A business loan file passes through the borrower, a channel partner, VPinnacle’s credit team, valuers, advocates and one or more banks. None of them were looking at the same record.
Documents chased in chats
Teasers, CMAs, GST returns and bank statements arrived on WhatsApp and email, often in several versions.
No one knew which version was final
One file, many banks
A file went to several banks at once, and each bank’s status lived in a different sheet.
Status updates depended on memory
Collateral in folders
Valuation reports and legal scrutiny reports sat in folders, separate from the loan they belonged to.
Sanctions held up waiting on an LSR
Commissions worked out by hand
Channel partner payouts were calculated after each disbursal from spreadsheets.
Partners calling to ask what they were owed
One file could be at three banks at once. Its status was whatever someone remembered.
What we did
We followed one file from enquiry to disbursal.
We mapped VPinnacle’s loan processing SOP stage by stage, with the documents each stage needs. When the SOP changed during the build, the system changed with it.
The life of one loan file
- BeforeEnquiryLeads from partners and referrals noted in a shared Excel sheetWith FaxtorEnquiryEach lead gets a profile with source, region, channel partner and timeline
- BeforeDocumentsTeaser, CMA, GST returns and bank statements chased on WhatsApp and emailWith FaxtorDocumentsA checklist per lead. Every document is requested, received and verified in the record
- BeforeBank submissionThe same file sent to several banks, each tracked in a separate sheetWith FaxtorBank submissionOne bank application per lender, each with its own status, reference and remarks
- BeforeCollateralValuation reports and LSRs saved in folders, with no record of who was handling themWith FaxtorCollateralValuation, LSR and the assigned valuer and advocate tracked against each property
- BeforeDisbursal and commissionChannel partner payouts worked out by hand after each disbursalWith FaxtorDisbursal and commissionCommission worked out on disbursal and tracked as pending, partial or paid
What we built
Every file in one record. Every bank on one screen.
Leads, documents, applications, loans, bank applications, collateral and channel partner commissions, linked to each other. It runs in the browser on any laptop, phone or tablet, with access set by role.
- SBI disbursed ₹1.10 CrLN-0412 · Shah Engineering
- CMA uploadedLD-1090 · Joshi Auto Parts
- LSR received from advocateKulkarni Foods · Plot 14, Chakan
- HDFC Bank sanctioned ₹2.00 CrLN-0412 · Shah Engineering
- Axis Bank rejectedLN-0412 · Turnover below threshold
- 01Lead managementLead profile with logs, contacts, documents and timeline. Bulk upload and configurable sources, regions and channels.
- 02ApplicationsApplications linked to leads, with document verification, financial assessment and status from new to converted.
- 03LoansRequested, sanctioned and disbursed amounts, interest rate, loan type and salesperson.
- 04Bank applicationsOne per lender, with bank reference, remarks and status from logged to closed.
- 05Collateral & legal scrutinyProperty records with valuation, LSR upload and document status.
- 06Valuers & advocatesA directory of empanelled valuers and advocates, linked to the cases they handle.
- 07CA repositoryChartered accountant profiles and documents, linked to loan cases.
- 08CustomersQualified leads become customers, with their loan, application and communication history.
- 09Partners & commissionChannel agents linked to leads and loans, with commission worked out on disbursal and agent-wise statements.
- 10Email communicationAutomated and manual emails from templates, with attachments, logged against each record.
- 11Workflow & mandatesStages, checklists and outcomes set by the SOP. Mandates created for bank submissions.
- 12Dashboards, reports & rolesOwner dashboard, configurable charts, custom reports and role-based access by designation.
The project
17 modules. Live in 7 weeks.
The scope grew as VPinnacle’s team used early versions. Collateral, mandates, a CA repository and a valuers and advocates directory were added during delivery.
- 17modules built
- 4modules added during delivery
- 3SOP revisions built in
- 7weeks to go live
The team
- PLProject lead
- UXDesigner
- FS2 full-stack engineers
- QAQA engineer
Built with
- React
- Node.js
- PostgreSQL
- AWS Mumbai
- Automated backups
- Email automation
The results
Every document accounted for. Every bank status in one place.
What changed for the team once every file ran through the system.
- 1 recordFrom enquiry to disbursal
- 5Bank statuses, logged to closed
- Every documentTracked against its lead
- Per agentCommission statements
- By roleWhat each person can see
- Any deviceNo app to install
Documents
Checklist per lead
Before
WhatsApp and emailBank status
Live per lender
Before
A sheet per bankCollateral
Linked to the loan
Before
Saved in foldersCommission
Calculated on disbursal
Before
Worked out by handOwner view
Live dashboard
Before
Weekly catch-up callsProcess
Follows the SOP
Before
In people’s heads
“New advisors know where each file goes from their first week.”
Your files next
More files, more banks, more documents. Let’s put every loan in one pipeline.
Book a no-obligation discovery call. Tell us how your files move today, and we’ll show you exactly where the system saves you hours and money.