Rent Roll and Arrears Without Living in Excel

Ask a growing property manager for their rent roll and you often get a pause, then a promise to “send the sheet later.” That sheet is usually someone’s personal Excel file: filters nobody else understands, formulas that broke last month, and a Vacant column that was last updated from memory.

Owners do not care that your process is heroic. They care whether units are occupied, what rent applies, and what is overdue. You need those answers without rebuilding a workbook every reporting cycle.

What a Usable Rent Roll Contains

At minimum, for each unit:

• Property and unit identity
• Current tenant, or a clear vacant state
• Current rent (what applies now)
• How far rent is paid (paid up to)
• Lease end date

If leases escalate, the roll should not pretend starting rent is still current. Show current rent, and keep starting rent / increase schedule available where people need the detail.

That single list answers occupancy and “what should we be collecting?” without opening twenty tenancy chats.

Arrears Is a Different Question

Rent roll answers status. Arrears answers who is behind and by how much.

A good arrears view groups outstanding balances by tenancy (and usually property). It should update from the same payment and lease data you use day to day, not from a parallel “debt” tab someone updates on Fridays.

When arrears and rent roll disagree, owners notice. Pick one system of record.

Why Excel Fails After a Point

Spreadsheets are fine at five units. They struggle when:

• Staff change and the “owner of the sheet” leaves
• Escalating leases need different amounts per period
• Partial payments need period allocation
• You manage for multiple owners who each want their slice
• You need a CSV export that matches what tenants were actually charged

The real cost is not only the hours you spend. You also chase the wrong tenants, send owners incorrect updates, and make renewal decisions from outdated vacancy information.

Reports Managers Actually Use Weekly

Rent roll: portfolio pulse for occupancy, current rents, and lease ends.

Arrears: collection focus for the week.

Payment history: proof of what came in (online and offline).

Financial summary: expected vs collected over a period, with expenses in view.

You do not need all four every morning. You do need them to pull from the same tenancies and payments.

Make the Report Match Reality

• Vacant units should look vacant, not like a “blank tenant name.”
• Filters by property or owner should be first-class if you manage for clients.
• Export to CSV when accountants or owners ask for a file, but treat the live report as source of truth.
• If a report type is locked behind your plan, know that before an owner meeting, not during it.

A Simple Operating Flow

1. After payments post (or after you record offline rent), glance arrears.
2. Weekly, scan rent roll for vacancies and leases ending soon.
3. Monthly, run a financial summary for owners who want a pack.
4. Stop maintaining a shadow Excel copy “just in case.” The shadow copy is where truth goes to die.

Rent roll and arrears are not fancy analytics. They are the difference between sounding organized on a phone call and promising to get back to someone after you “check the sheet.”

---

Property Governors includes Rent Roll, Arrears, Payment History, and Financial Summary reports you can filter and export. They are fed by the same tenancy and payment data you use daily. Explore reports.