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 payment ledger. A roll gives you balances and the ledger gives you timing, and since every figure is computed from one table, the ledger is the one to lead with: it is where the early signal is. A rent roll uploaded alongside is read and returned as a download, and the report says whether the two look related, but balances and payments are not brought together into one number.

Lease start and end dates make the expiry calendar possible, so they belong on whichever file you lead with. A PDF from the agent is workable, since tables are lifted out of it, though a spreadsheet export is better.