What Came In Today, and What Should Have?

Half an answer is not an answer

Ask a small lender how today went and you hear a cash figure: we collected about ₱38,000. It sounds like information. It is half of one. ₱38,000 against ₱40,000 due is a strong day. ₱38,000 against ₱95,000 due is a quiet emergency wearing a decent number. Without the denominator, the daily cash count is a mood, not a measurement.

The denominator exists. Every amortization schedule you have ever issued says exactly which installments fall due on any given date. The problem is that this knowledge is smeared across hundreds of rows in a spreadsheet, so nobody assembles today's expected total. The book knows. The owner does not.

What should a lender's daily screen show?

The daily view a lender actually needs fits on one screen:

• Expected today: every installment due today across the book, summed, with the list of accounts behind it
• Received today: every payment posted today, cash, GCash, bank transfer, whoever it came from
• The gap: which specific accounts were due today and did not pay, already queued for tomorrow's follow up
• Off schedule money: payments that arrived from past due accounts, which is your collections effort showing up in pesos

Note what the gap column really is: tomorrow's call list, generated free, one day into delinquency instead of one month. The account that misses today and gets a friendly text tomorrow morning rarely becomes the account that needs a field visit in November. The single cheapest moment in all of collections is the day after the first miss, and a daily view is what lets you spend it.

A collection rate you can feel weekly

Run expected versus received for a few weeks and you get the operating metric daily lending actually turns on: collection efficiency, received divided by expected. If your book expects ₱600,000 a month and your daily rate runs at 85 percent, you are leaking ₱90,000 a month into your past due buckets, ₱4,500 or so per banking day. Watching that rate daily means a bad week announces itself as a bad week, not as a bad quarter discovered at reconciliation.

It also settles arguments about growth. Releasing more loans always feels like progress, because releases are visible and misses are quiet. When the daily screen shows efficiency sliding as volume climbs, you have an honest signal that collections capacity, not capital, is the current constraint.

Why can't the spreadsheet answer this?

Nothing in this view is sophisticated. It is a join between two things your operation already produces: schedules and payments. But in a spreadsheet those live in different tabs, in different formats, updated at different times by different people. Assembling today's expected list by hand takes an hour, so it happens never. The received side lags a day or three behind the GCash inbox. The join never occurs, and the owner falls back to counting the drawer.

In a lending system, the join is free. Schedules exist the moment a loan is booked. Payments post with dates and references as they arrive. The daily screen is just those two streams laid against each other, computed while you slept.

The habit it creates

Owners who get this screen check it the way they used to check their phone's GCash balance, first thing, every morning. Yesterday's expected, received, gap, and who is on today's follow up list. Five minutes. The book stops being a monthly mystery reconstructed at closing time and becomes a daily routine with a short memory for problems. That rhythm, more than any single report, is what a lending operation feels like when the ledger finally works for the owner instead of the other way around.