The problem: a loan book that outgrew the spreadsheet
Managing a loan book on Excel works until it doesn’t. While manual management is manageable when the book is small, however, it quickly breaks down once volumes climb.
For this lender, growth exposed the cracks:
- Repayment schedules that didn’t match reality
- Fees and charges forgotten, quietly leaking revenue
- Settlement amounts that were wrong more often than they were right
- Account statements showing balances the team couldn’t fully stand behind
Consequently, the knock-on effect hit collections hardest. Specifically, the team couldn’t reliably identify overdue accounts, which led to incorrect settlement figures and missed fees. As a result, this escalated into a customer service problem as well, because the team couldn’t produce accurate settlement quotes or explain balances with confidence
What started as a processing inconvenience became a business problem. As the book grew, more time went into correcting it than growing it.
The solution: one controlled environment instead of a dozen spreadsheets
Acquire moved the lender from manual, Excel-based administration into a single, automated loan management environment, covering the full lifecycle from contract setup to repayment, collections, and settlement.
With business rules and calculations applied consistently, the team can now:
- Generate and maintain repayment schedules automatically
- Apply interest rate changes according to configured rules
- Calculate interest, fees, and charges without manual intervention
- Allocate receipts accurately
- Produce up-to-date outstanding balances and settlement figures on demand
- Pull a complete transaction history for any account, instantly
Collections improved because the team could finally see the book clearly, no more scanning spreadsheets to find overdue accounts. Fee leakage dropped because charges were built into the system’s rules rather than left to memory. And customer service stopped depending on someone reconciling a spreadsheet before they could answer a query.
Most importantly, the business could grow its book without growing its admin headcount to match.
Before Acquire → With Acquire
|
Before Acquire |
With Acquire |
| Excel-based loan management | Centralised loan management platform |
| Manual repayment calculations | Automated repayment schedules |
| Manual interest rate changes | Configured interest rules |
| Manual fee application | Automated fee capture |
| Manual receipt allocation | Controlled receipt allocation |
| Difficult to spot arrears | Clear visibility of overdue accounts |
| Incorrect settlement quotes | Accurate, up-to-date settlements |
| Inconsistent statement balances | Reliable, current account information |
| Fee and income leakage | Consistent fee capture |
| Growth capped by admin capacity | Scalable loan management environment |
The outcome
The lender moved from a manual, error-prone process to a controlled, automated one, gaining accuracy across schedules, fees, receipts, and settlements, while freeing the team to manage the business instead of correcting it.
“Implementing the Acquire loan management system has transformed our operations. It has streamlined our processes, and significantly boosted productivity and turnaround in finalising supplier payouts. The solution has truly enhanced our efficiency and accuracy.”
— COO, Equipment Rental Company, Johannesburg
If manual processes are creating this kind of pressure on your debtors book, let’s talk about what a controlled system could look like for you.
