AscendryxEvery lending office we have worked with reached the same point, and almost none of them recognised it at the time. The loan ledger itself keeps working. The formulas are correct, the balances add up, and the person who built the file knows it inside out. What breaks is everything around the ledger, and it breaks quietly.
Cash moves before it is recorded
A collector takes payments in the field all morning. Those payments exist as cash in a bag and as pencil marks in a notebook. They become data in the evening, or the next morning, or on Monday, depending on how the week went. In the gap between the payment and the record, the office genuinely does not know what it is owed.
The damage is not usually theft. It is ordinary error that compounds: a payment recorded against the wrong loan, an amount transposed, a receipt written and never encoded. By the time anyone notices, the borrower has a different version of events and there is no way to settle who is right.
The fix is not a better spreadsheet. It is recording the collection where it happens, and then requiring the office to confirm it against the cash that actually arrived. Two steps, deliberately, because one step is how the gap reopens.
Penalties become negotiable
Interest and penalties computed by hand are computed differently by different people, and differently by the same person on a bad day. Once a borrower successfully argues one penalty down, that outcome becomes precedent in their mind and in your collector's. The rule stops being a rule.
Systems are better at this than people not because they are cleverer but because they are indifferent. The same rule runs for every borrower every night, including the ones who complain loudest, and the number is defensible because it is reproducible.
Branches stop reconciling
Each branch keeps its own file. Head office collects them at month end and adds them up. The consolidated figure exists for about a day, is already out of date when it is presented, and nobody can drill into it without ringing a branch manager.
The tell is a question nobody can answer quickly: what is outstanding across the business right now. If answering that takes more than a few seconds, decisions are being made on last month's picture.
The person becomes the system
This is the one that should worry an owner most. The file works because one person understands it. They know which tab is authoritative, which figures to ignore, and which manual step happens every Friday. None of that is written down.
When that person is sick, the month end is late. When they leave, the business discovers how much of its process lived in their head. We have been called in after exactly that happened more than once, and rebuilding from a spreadsheet nobody can explain is considerably more expensive than replacing it while the expert is still there to explain it.
What we would look at first
- How long is the gap between money changing hands and the record existing, and who is accountable in that window.
- Whether two people computing the same penalty get the same number.
- How long it takes to answer what is outstanding across all branches today.
- What happens to month end if one specific person is away for two weeks.
- Whether a correction to a balance leaves a trace of who made it and why.
If the answers are uncomfortable, that is useful information. It does not automatically mean you need a system. Sometimes it means a process needs fixing first, and we will say so rather than quoting. But if you recognise three or more of these, the spreadsheet is no longer the thing holding the operation together, and it is worth knowing that before the person who maintains it hands in their notice.