Analysis for landlords and letting agents.

A tenant who pays on the twenty-eighth every month is current on every rent roll and is the tenant most likely to be in arrears next quarter.

Reconstruct payment timing from the ledger rather than reading the balance, and rank tenants by the pattern rather than by the number.

Leases ending are individually unremarkable and collectively a cliff. Laid out by month with income attached, a quarter carrying a fifth of the rent becomes visible while there is still time to act.

This is the analysis most worth automating, because its value depends entirely on doing it early and it is the one nobody does until it is late.

Occupied and paying, occupied and not paying, and vacant are collapsed by a single occupancy percentage into one flattering figure.

Count them separately and state the rent at risk in money rather than in units, because two units at different rents are not two units.

The rent roll and the payment ledger. The roll alone gives you balances; the ledger is what turns those into payment behaviour, which is where the early signal is.

Lease start and end dates make the expiry calendar possible. A PDF from the agent is workable, since tables are lifted out and checked against the totals printed on the same page, though a spreadsheet export is better.