Loans and credit sales: where late-interest calculations go wrong
Interest calculated wrongly doesn't throw an error: it gives a plausible number. And across a loan book, a small error repeated a thousand times is a lot of money.
The worst error is the one that looks right
In a loan book, calculation errors don't produce error messages: they produce instalments slightly different from what they should be. And because they look reasonable, nobody checks them.
Multiplied by hundreds of customers and dozens of instalments, a small systematic error is a lot of money — and, depending on the case, a problem with the customer or with the regulator.
Where the calculations go wrong
- The day-count basis. Calculating on 360 or on 365 days gives different results. Neither is wrong; mixing them is.
- Which balance late interest runs on. On the overdue instalment, on that instalment's principal, on the whole loan? They're three very different figures, and you have to pick one, write it down and stick to it.
- The order payments are applied in. A payment that doesn't cover everything — what does it go to first: late interest, interest or principal? The order changes the final balance and the term.
- Grace days. If they exist, does late interest run from the due date or from the end of grace? Both get implemented, and they give different numbers.
- Rounding. Rounding each instalment or rounding at the end changes the total. It's cents per instalment, and thousands across the book.
The check that reveals it: take a real loan, work out the schedule by hand in a spreadsheet and compare it with the system's, instalment by instalment. If there's a difference at instalment 18, there'll be one in every loan.
The cases that break systems
Anyone can do the normal calculation. What sets a serious lending system apart is how it handles what isn't normal:
- The extra payment to principal. Does it cut the instalment or the term? The customer should be able to choose, and the schedule gets rebuilt.
- Refinancing. A loan that's restructured isn't a new one: the history has to be kept.
- The repeated part payment. Someone who always pays a bit less creates a carry-forward that has to be tracked precisely.
- Waivers. Forgiving late interest is a decision with a name and a reason, not an adjustment.
And what you need to see of the book
Beyond the individual calculation, the management question is how much of what you lent you'll get back. That means seeing the book by arrears buckets, its trend, and how much sits with a few customers — the same reasoning as in ageing reports, with higher stakes.
Lending is regulated differently in every country, with limits and requirements to meet. Confirm your framework with an adviser before setting rates and charges.