Shared Flat Room Rental Tracker – Excel Template

For landlords and lead tenants of shared flats: rent per room, utility shares, deposits and who has paid this month.

• Automatic summary: Rooms, Vacant rooms, Rent roll (occupied), Collected this month, Outstanding, Utility shares check (should be 100%)
• Calculated for you: Utilities due, Total due, Balance, Status
• Colour-coded status and progress highlights
• Example rows and a step-by-step "How to Use" sheet

Instant download (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.