Loan Management System with EMI – Google Sheets Apps Script

Lending operations for a finance house, a microfinance branch or a committee that lends locally: customers with KYC on file, loans that generate their own EMI schedule, collections organised by group, and late fees that calculate themselves.

From application to disbursement

Customers are onboarded with their KYC documents uploaded and viewable inside the system, each carrying a ledger with a running balance. A loan goes through a multi-step application wizard, then an approval or rejection decision — so an approved loan is a recorded decision rather than a row somebody typed. Existing borrowers can be renewed or topped up without starting from scratch.

The schedule and the collection round

Once a loan is approved the EMI schedule is generated for it, and the payment calendar shows what is due and when. Collection is organised by repayment group, which matches how field collection actually works — one officer, one group, one round — and daily savings collection is handled alongside the loan instalments. Overdue loans are detected automatically and the late fee is applied from your own configured rules rather than worked out on a calculator.

Controls and communication

Logins are OTP-verified at registration, passwords reset by OTP, and three roles — admin, manager and user — decide what each person reaches. Business rules like interest, penalty and limits are configuration, not code edits. Notices and statements email out with a PDF attached, and an email log records what actually went.

Seeing the book

Transaction management keeps every payment against its loan, and collection trend charts show whether recovery is improving or slipping — the number a lending book lives or dies by.