Book a call

Notes / Lending

The number the phone says and the number the book says

Reconciliation works when one system holds the loan book and the money movement together, so a repayment is matched to a specific loan on a specific repayment schedule as it arrives. Cash collected in the field passes through an agent's wallet and a collection account before it reaches the book, and the number can drift at every hop. A payment that arrives with no loan behind it should be caught the moment it appears, not at the end of the month.

The number the phone says and the number the book says
Photo: Ikrash Muhammad / Unsplash

The reconciliation gap between mobile money and the loan book, and why it quietly decides which African micro-lenders survive their first year.

A lender in Accra was three days from opening, and he could not sleep.

It was not the money. He had a facility lined up, a small team, an office. The product was simple: short loans to traders and small shops, paid out and collected in the field, all of it moving over mobile money. He had run the numbers a hundred times.

What kept him awake was a smaller thing. In three days, his field agents would start taking cash from customers and paying loans out from their phones. Every one of those movements would land in a mobile money wallet before it ever reached a book. And he had no way, on any given morning, to know whether the number on an agent's phone matched the number in his records.

He put it plainly. "The day those two numbers disagree, how do I know which one is lying?"

That question is the whole business.

Most people think the hard part of lending is the lending. Deciding who to trust. Setting the rate. Chasing repayment. Those are hard. But they are not the part that quietly kills a young lender. The part that kills a young lender is the gap between what the money is actually doing out in the field and what the book says it is doing. Close that gap and everything else is manageable. Leave it open and the book turns into fiction, one small drift at a time.

Where the gap opens

Follow a single repayment.

A customer hands 200 cedis in cash to an agent standing in a market. The agent has the cash. Good. Now that cash has to become a record. The agent pushes it into a mobile money wallet. That is one hop. The money then moves from the agent's wallet toward the lender's collection account. That is a second hop. Inside the lender's system, that payment has to be matched to a specific loan, on a specific repayment schedule, for a specific customer. That is a third hop.

Every hop is a place the number can drift. The agent banks 180 and keeps the rest. A transfer fails halfway and nobody notices for a day. Two customers pay the same amount within a minute of each other, and the payment is matched to the wrong loan. None of this is exotic. All of it happens. And each time, a small space opens between the money and the book.

A spreadsheet cannot hold this. Not because a spreadsheet is weak, but because the job needs one place that knows three things at the same moment: that the loan was paid out, that the repayment came in, and that the two belong to the same schedule. A spreadsheet knows only what the last person typed into it. It does not watch the mobile money account. It does not raise its hand when a payment arrives with no loan to match. It cannot tell you, at nine in the morning, where the money is right now.

That is the real reason a lender outgrows a spreadsheet. Not volume. Truth.

What closes the gap is one system holding the loan book and the money movement together, so the phone and the book stop being two separate stories and become one story that checks itself every time money moves. The payout is recorded against a loan. The repayment schedule is generated from that loan. The mobile money payment, when it lands, is matched against that schedule as it arrives, so a payment with no loan behind it is caught the moment it appears instead of at the end of the month. This is what ERPNext with Frappe Lending does for a lender at this size. ERPNext is the open-source system that runs the accounts and the operations, and Frappe Lending is the part built on top of it that understands loans, schedules and interest.

Why it matters more now

There was a second reason the founder could not sleep, and this one was not in his hands at all.

The Bank of Ghana has been redrawing the map for lenders like him. Under notice BG/GOV/SEC/2026/03, Tier 4 non-deposit-taking micro-credit enterprises, the smallest formal class of lender, are being brought under a new heading: Last-Mile Providers. The fine detail is still settling. The direction is not in doubt. More lenders, sorted more clearly into categories, expected more clearly to report what they are doing.

Here is what that means on a Tuesday morning. A lender who cannot reconcile cannot report. If your book and your money do not agree, you cannot produce a return you would put your name to, and a return you would not put your name to is worse than none at all. The lenders who will struggle under the new rules are not the ones with the wrong product. They are the ones who built on a foundation that could never answer one plain question: where is the money right now.

The founder in Accra saw this before the regulator made him. That is why he could not sleep three days out. Not because the lending was hard, but because he knew that on the first morning the phone and the book disagreed, "let me get back to you" would not be an answer he could afford to give.

The lenders who survive their first year are not the ones with the cleverest credit model. They are the ones who, on any morning, for any loan, could tell you exactly where the money was. Everything else in lending is a decision you can revisit. That one is a foundation you either poured straight, or you did not.