What's inside
- Up to 20 units: tenant, rent, due day, grace days, late fee (flat or % of rent), lease dates and deposit
- Rent roll for any month: rent, paid, late fee, owed and a status (Paid, Paid late, Not yet due, Late, Fees owed, Vacant) with lease-end alerts
- Late fees done fairly: charged only when rent is unpaid at the end of the grace period; payments go to rent first, so there are never fees on fees
- A 24-month ledger per unit, calculated for you, and a payments log that flags typos and out-of-range dates
- Summary: collected vs due, owed by all tenants, late fees, occupancy, deposits held, leases ending in 60 days
- Sample file: six units over nine months. September: $4,105 of $4,805 collected, one partial payment with a 5% late fee
Checked, not just designed: 7,515 formulas, zero errors, and the whole ledger was rebuilt independently from the raw entries and matched in 6 scenarios.
Works in Excel and Google Sheets. Check your state's rules on late fees. Not legal advice.