Property Management Profit Tracker Excel for your rental portfolio — rent roll by property, rent collection, maintenance work orders, and a monthly P and L dashboard. Know what every property actually earns — and…
About this template
Property Management Profit Tracker Excel for your rental portfolio — rent roll by property, rent collection, maintenance work orders, and a monthly P and L dashboard. Know what every property actually earns — and whether the month actually made money. Built for property managers and small landlords who need to know, property by property and tenant by tenant, what the fees cover, who paid, and which maintenance jobs came out of your pocket instead of the owner's — without accounting software. If one repair wipes out the month, this workbook shows why.
$49
Excel & Google Sheets template — instant download on Etsy
Properties and Rent Roll — property, units, rent per unit, occupied and vacant units, occupancy percent, gross potential rent, actual rent collected, vacancy loss, management fee percent, and fee income for every property. Change a fee percent and the whole month updates.
Rent Collection — tenant, property, rent due, amount paid, date paid, fee percent (pulled from sheet 1), management fee, late fee, and balance due for a 20-tenant sample. Fee percent, management fee and balance due fill in by formula.
Maintenance and Repairs — work order, property, vendor, category, cost, whether it was billed to the owner, net cost to the manager, date, and status. Owner-billed work is a pass-through, not your expense.
Monthly P and L — revenue, software, office, mileage, marketing, insurance, maintenance (manager-paid only), contractor and other expenses by month, Jan-Dec, with net profit and margin. Revenue is the full fee income plus late fees.
Dashboard — total revenue, properties, units, occupancy, rent collected, vacancy loss, fee income, maintenance split, expenses, net profit and margin, best and worst properties, and the biggest job.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Property Management Profit Tracker track?
The Property Management Profit Tracker tracks Properties and Rent Roll; Rent Collection; Maintenance and Repairs; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: 8 properties, 69 units, 61 occupied, 8 vacant; occupancy 88.4 percent.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.