How to Maintain a Rent Roll and Collect Rent in a Spreadsheet

Small portfolios fail collections quietly — one unit three months behind looks like “they’ll catch up” until vacancy stacks on top. A free rent roll spreadsheet tracks units, tenant, rent due, paid, balance, and lease end with arrears highlighting.

One row per unit, updated monthly

1. Unit / property
2. Tenant name
3. Monthly rent — contract amount
4. Paid this period — check, ACH, partial
5. Balance — carried forward
6. Lease end — renewal planning trigger

Filter balance > 0 every month before you approve new maintenance spend — cash flow truth lives here.

Rent roll is billing, not accounting

This sheet answers who owes what today — not full GAAP books. Pair with your bank deposits and tax prep workflow; use the tenant tracker for lease terms and deposit detail the rent roll does not need every month.

Maintenance costs hit the same cash picture

Log repair spend on the maintenance request log with cost per job — compare total arrears vs. open maintenance liability when deciding whether to offer payment plans.

When property management software wins

Online rent collection, tenant portals, and owner statements justify AppFolio-class tools at 20+ units or multi-owner portfolios. Mom-and-pop landlords with a handful of doors often collect faster with a visible rent roll and consistent late-fee policy.

These templates are operational billing logs, not legal lease documents or accounting systems. Follow state landlord-tenant law for notices and collections.