Ummeed Esperanza
An NGO and microfinance management platform that replaced spreadsheets and paper files with a single system for beneficiaries, loans, donations, and finances.
The Big Picture
Ummeed Esperanza (“hope” in Urdu and Spanish) is a non-profit in Mandi Bahauddin, Pakistan, running business loan programs, student fee support, sponsorships, and community welfare programs.
We built and continue to maintain the organization's operating system: a web platform that manages the full lifecycle of a beneficiary — from registration and loan disbursement to installment collection — alongside donors, sponsors, staff, assets, and the organization's books.
Core goals:
- One source of truth for beneficiaries, loans, and finances
- Accurate installment tracking and expected receivables
- Transparent donation and sponsorship records for donors
- Financial statements without manual reconciliation
- One-click PDF and Excel exports for every major report
- Simple workflows for non-technical field and office staff
The Challenge
Spreadsheets and Paper Files
Registrations, loans, installments, donations, sponsorships, and staff records were spread across spreadsheets and paper — with no single source of truth.
Slow Financial Reporting
Producing a balance sheet or a loan status report meant manually consolidating records, taking hours for every report.
Installment Discrepancies
Manually tracked installment and donation records drifted out of sync, making it hard to know what each beneficiary actually owed.
No Verifiable History
Without timestamped transactions and running balances, verifying historical activity for donors and management was difficult.
Non-Technical Users
The system had to be usable by field workers and office staff, so workflows had to mirror how the organization already operates.
Aging Technology
The platform started on Laravel 8 and Vue 2. Keeping it secure and maintainable meant a full framework migration without losing years of live data.
How We Built It
Single-Page Application
A Vue 3 + Vuetify 3 SPA served by Laravel, giving staff a fast, app-like interface with Pinia state and router guards that verify the session on every navigation.
RESTful Laravel API
51 API endpoints across 20 controllers, all business logic behind an authenticated /api layer using Eloquent ORM and the query builder.
Relational Data Model
A MySQL schema managed through 24 migrations covering people, loans, installments, cashbooks, accounts, donations, sponsorships, employees, and assets.
Hardened Authentication
Token-based auth with database-stored expiry, a dedicated token-expiry middleware, a rate-limited login endpoint, and secure password changes.
Validated Inputs
19 dedicated Form Request classes validate every write, keeping financial and beneficiary data consistent at the API boundary.
Export-First Reporting
Branded PDF statements (DomPDF on the server, jsPDF + autoTable in the browser) and SheetJS Excel exports on every major data view.
Platform Modules
Beneficiary Registry
Complete beneficiary profiles with photos, guardian and granter details, family and business records, document attachments, and a printable PDF profile — with full loan and installment history on one screen.
Loan Lifecycle Management
Loan creation and disbursement with amount and duration, generated loan invoices, and return processing — linked directly to the beneficiary and the organization's cashbook.
Installment Tracking
Installment payments recorded against each loan, with payable vs. paid installment reports and expected receivables so field staff know exactly what is due and what has been collected.
Multi-Account Ledger
Cash, bank, and mobile-wallet accounts with categorized income and expense entries, per-transaction running balances, inter-account transfers, and date-range filtering.
Donations & Sponsorships
Donor records and contribution history, sponsors linked to beneficiaries, sponsorship payment tracking, and duration-based sponsor reports for donor accountability.
Financial Statements
Balance sheet, trial balance, and cash summary generated from the recorded transactions — replacing hours of spreadsheet reconciliation.
Staff, Payroll & Assets
Employee records with monthly salary payments, an organizational asset register, and office inventory — each with date filters and exports.
Dashboard & Reporting Suite
KPI cards, loan recovery and loans-vs-collections charts, plus yearly, monthly, combined, installment, donation, and sponsor reports — all exportable to branded PDF and Excel.
Architecture & Engineering
Frontend
- Vue 3.5 single-page application with Vuetify 3 components and a customized theme
- Vue Router 4 guards that verify the session token on every navigation
- Pinia stores for shared application state
- ApexCharts dashboards for loan recovery and loans vs. collections
- Branded client-side PDF statements with jsPDF + autoTable
- Excel exports with structured headers and summaries via SheetJS
- Vite 6 build with separate vendor, Vuetify, charts, and PDF chunks
Backend & Data
- Laravel 11 on PHP 8.2 exposing 51 REST endpoints behind token auth
- Token authentication with expiry enforced by dedicated middleware
- Rate-limited login endpoint to block brute-force attempts
- 19 Form Request classes validating every write operation
- MySQL schema managed by 24 migrations across 20 Eloquent models
- Multi-account ledger with running balances and inter-account transfers
- Server-side PDF generation with DomPDF for beneficiary profiles
Modernizing a Live System
The platform has been in use since 2022. Rather than rewrite it, we upgraded the entire stack in place while keeping existing data and schema contracts intact.
Laravel 8 → 11
PHP 7.4 → 8.2, updated middleware, providers, and exception handling; deprecated packages removed.
Vue 2 → Vue 3
Vue Router 3 → 4, Vuex → Pinia, Vuetify 2 → 3 across every view and layout.
Mix → Vite
Webpack/Laravel Mix replaced with Vite 6 and code-split production bundles.
Data Preserved
Legacy table and column names kept as schema contracts, so no historical records were lost.
By the Numbers
Tech Stack
Key Takeaways
Model the Organization, Not the Database
Modules mirror real NGO operations — registration, loans, installments, donors — so non-technical staff adopt the system without retraining their thinking.
Export Is a Core Feature
Donors, auditors, and management live in PDF and Excel. Making every major view exportable was essential, not optional.
Deliver Module by Module
Shipping incrementally and gathering feedback from the people using it kept each module grounded in actual daily workflows.
Upgrade Instead of Rewrite
A careful in-place migration to Laravel 11 and Vue 3 modernized the platform while protecting years of operational data.
Have a Product to Build?
From NGOs and microfinance programs to growing businesses, we build management platforms that replace spreadsheets with systems your team can rely on.