Back to projects

Jan – Feb 2026

Company ERP — loan management module

A loan management module for a Bangladeshi company's PHP/MySQL accounting ERP, where every loan movement posts as a balanced double-entry voucher.

My role
Built the loan module within an existing team ERP
PHPMySQLPDOjQueryBootstrapDataTables

The problem

The company's ERP couldn't track loans given to borrowers, and every cash posting went to one fixed cash account, which limited cash reporting.

My approach

I built the loan module end to end: borrowers, a loan dashboard, loan details with due dates, repayments with an outstanding-balance check, and a borrower ledger. I connected it to the general ledger: each loan issue and repayment posts a balanced voucher inside one database transaction, and edits soft-delete and re-post instead of changing history. I also added cash and bank account selection to the payment and collection screens, and a cash book filtered by account.

The outcome

The loan module was merged into the ERP's main branch in February 2026.