Skip to content
Full-stack Web App

A loan management system for microfinance teams, covering borrower onboarding and identity verification through repayment, delinquency tracking and portfolio reporting.

Small lenders often track individual microloans in spreadsheets, which makes it hard to see who is behind on payments, how much of the portfolio is at risk, or whether anyone actually checked a borrower's ID. Micro Loan Manager covers the whole loan lifecycle in one place, with identity verification for borrowers and guarantors, permission-based roles, and an audit trail for every change.

Dashboard shows principal outstanding, loans behind, PAR 30 and this month's collections, plus what is waiting for review or disbursement and what is due this week

Key features

  • Borrower management: borrower profiles with profile photo capture and KYC document upload and preview. Sri Lankan NICs are validated in both the old and new formats, checked against the date of birth they encode, and stored in one normalized form so the same person can't be registered twice.
  • Identity verification: staff submit a borrower once their ID is uploaded, and an independent auditor verifies them by retyping the ID number from the document, or rejects them with a reason. Whoever onboarded the borrower or uploaded the evidence can't verify them, and editing a verified borrower's identity sends them back for review.
  • KYC document revisions: documents are kept in numbered revisions and never deleted. Two-sided IDs need both the front and the back, and a reviewer who sends a borrower back marks each document as OK or needing attention, so only the flagged ones have to be uploaded again.
  • Guarantors: guarantors are verified exactly like borrowers and can back several loans, up to a configurable limit. Each loan product sets how many verified guarantors a loan needs.
  • Configurable loan products: principal limits, flat or reducing-balance interest, weekly to monthly repayments, fees, grace periods and required guarantors.
  • Application workflow: officers submit applications, and managers or admins approve or reject them with a reason. A loan can't be approved or paid out until the borrower and every guarantor on it are verified, and the panel lists everything that's still blocking it.
  • Disbursement and repayment schedules: each schedule is generated when the loan is paid out, and payments (full or partial) are applied to the oldest unpaid installment first.
  • Delinquency tracking: loans are grouped into standard aging buckets (current, 1–30, 31–60, 61–90 and 90+ days) with overdue markers across the app.
  • Reporting: outstanding portfolio, portfolio at risk, disbursements, collections and write-offs, broken down by officer and product, with CSV export.
  • Rescheduling and write-offs: officers and managers propose reschedules, which someone else must review, and write-offs follow a manager-proposes, admin-approves flow.
  • Reminders and notifications: automated reminders before and after due dates, plus in-app alerts for staff.
  • Roles and permissions: roles are sets of module:action permissions that admins can create and edit, with Admin, Manager, Loan Officer and Auditor roles built in. Nobody can grant a permission they don't hold themselves.
  • Audit trail: field-level history of every change to borrowers, guarantors, loans, payments and roles.

Borrowers lists every borrower with their ID, verification status, open applications and active principal, with search and a verification filter

Borrower verification shows why an auditor rejected a borrower and the full verification history, with the option to submit again once a new copy is uploaded

KYC documents keeps uploads in numbered revisions, carries accepted documents forward and keeps the flagged NIC back in the earlier revision with the reviewer's note

Guarantors lists guarantors with their verification status and sets how many loans one guarantor can back

Loans tracks every loan from pending application through active, closed and written off

Loan approval blocks approving an application while one of its guarantors is still pending review, and lists exactly what is missing

Loan detail shows arrears, records a payment against the oldest unpaid installment, and lists the disbursement and repayment schedule

Delinquency groups overdue loans into aging buckets (1–30, 31–60, 61–90 and 90+ days) for follow-up

Reports breaks down the outstanding portfolio by loan officer and product, with CSV export

Loan products configures principal limits, interest method, repayment frequency, fees and grace periods for each product

Roles creates and edits custom roles by switching individual permissions on or off, grouped by module

Audit log records who changed which field, from what to what, on every borrower, loan, payment and role

Engineering highlights

  • A pnpm monorepo with a NestJS API and a React + Vite frontend. The API publishes an OpenAPI spec, and the frontend generates its typed client from it.
  • PostgreSQL with Prisma. Loans copy their product's terms when the application is created, so later product edits never change existing loans.
  • Every endpoint declares the permission it needs, and a user's permissions are read from the database on each request, so role changes take effect immediately. The frontend gates navigation, pages and actions from the same permissions.
  • Borrowers and guarantors share one verification engine, so the two workflows can't drift apart. Approval re-checks verification in the same transaction, and disbursement checks it again, since verification can be withdrawn in between.
  • The guarantor limit locks the guarantor rows during approval, so two approvals running at the same time can't both slip under it.
  • KYC documents and borrower photos are encrypted with AES-256-GCM before they reach blob storage. Each file is bound to its storage path, and keys can be rotated.
  • Cookie-based JWT sessions with refresh-token rotation and CSRF protection, set up so sessions stay first-party on mobile Safari.
  • Deployed on Vercel (frontend), Render (API) and Neon (Postgres), with GitHub Actions running lint, build and tests on every pull request.

The live demo requires a staff login. Demo access is available on request.

Tools
GitGitHub ActionsVercelRenderNeonPrisma
Skills
ReactTypeScriptNestJSPostgreSQLTanStack QueryTailwind CSS
All projects