Property Management Spreadsheet | Landlord Excel Template | Rent, Tenants, Expenses & Arrears

Run your rental property business from one organised Excel system.

The BusinessOSLab Property Management / Landlord Business OS is a complete 19-sheet Microsoft Excel management system designed for landlords, property managers and small rental portfolios.

Manage properties, units, tenants, applicants, tenancy dates, rent, payments, arrears, maintenance, inspections, expenses, deposits, suppliers and portfolio performance — all from one organised workbook.

WHAT’S INCLUDED

• Automated property-management Dashboard

• Property portfolio register

• Units / rooms register

• Tenant CRM

• Applicant & viewing tracker

• Lease / tenancy tracker

• Monthly rent roll

• Rent payment register

• Rent arrears tracker

• Maintenance & repair tracker

• Property inspection tracker

• Contractor & supplier register

• Property & business expense tracker

• Deposit tracker

• Compliance & renewal-date register

• Tenant / client communication log

• Mileage & travel tracker

• Monthly portfolio review

• Quick-start / business setup system

BUILT FOR LANDLORDS & PROPERTY MANAGERS

Suitable for:

• Single-property landlords

• Multi-property landlords

• Houses and apartments

• HMOs and room rentals

• Multi-unit properties

• Small property-management businesses

• Owned and managed rental portfolios

MONITOR RENT & ARREARS

Use the dedicated Rent Roll to see:

• Monthly rent due

• Amount paid

• Outstanding balance

• Paid / part-paid / overdue status

• Property, unit and tenant records

The Arrears Tracker keeps overdue balances, contact history, days late and next follow-up dates visible.

TRACK PORTFOLIO PERFORMANCE

The automated Dashboard monitors:

• Rent due

• Rent collected

• Outstanding rent / arrears

• Monthly expenses

• Net cash flow

• Occupied units

• Vacant units

• Occupancy rate

• Open maintenance jobs

• Leases approaching review

MAINTENANCE & PROPERTY CONTROL

Log repairs and maintenance with:

• Property / unit

• Reported issue

• Priority

• Contractor

• Estimated cost

• Actual cost

• Current status

• Completion date

You can also organise inspections, suppliers, expenses, mileage and important property review dates.

EASY TO SET UP

Your download contains a fully populated Example workbook and a separate Blank workbook.

Open the Example version first to see how the complete system works, then use the Blank copy for your own portfolio.

A professionally formatted Quick Start Guide PDF is also included.

YOUR DOWNLOAD INCLUDES

• BusinessOSLab_Property_Management_OS_Example.xlsx — fully populated example workbook

• BusinessOSLab_Property_Management_OS_Blank.xlsx — clean working copy for your portfolio

• BusinessOSLab_Property_Management_OS_Quick_Start_Guide.pdf — setup instructions and sheet-by-sheet guide

• README_Property_Management_OS.txt — compatibility, licence and important information

IMPORTANT INFORMATION

• Instant digital download

• No physical product will be shipped

• Microsoft Excel .xlsx format

• Best used in Microsoft Excel

• Compatibility with other spreadsheet software is not guaranteed

• No subscription required

• Organisational and record-keeping tool only

• Does not provide tenancy, housing, legal, deposit-protection, tax, accounting, safety or regulatory advice

• Requirements vary depending on location and property type

• For the purchaser’s own personal/business use

• Resale, redistribution or sharing is prohibited