
| Commercial Real Estate Properties, Financial Model, Real Estate, Residential Properties |
| Dashboard, Excel, Google Sheet, Tracking |
A maintenance workbook for landlords and small property managers with 1 to 15 properties. Log every repair request as a work order, assign a vendor, and the workbook tracks what is open, what is overdue against your target response times, and what each property cost you this year.
What it covers: work-order log (400 rows) with dropdowns for property, category, priority, vendor and status; overdue flag against target days to close by priority; days open and days to close; tenant charge-backs and net cost by property; vendor list with job count and total paid; preventive maintenance schedule (filters, detectors, gutters, furnace service) with next-due dates and overdue / due-soon flags; dashboard with open and overdue counts, cost by category chart, cost by property, average days to close; built-in checks.
Who it is for: small landlords, house hackers and self-managing owners who want a simple repair history per property for budgeting, tenant charge-backs and year-end records.
Files: .xlsx (Excel 2016+, works in Google Sheets). No macros. Sample data is fictional. Built with AI assistance and checked for formula errors. A record-keeping tool, not legal or tax advice.
What it is used for
Keeping a dated repair history and yearly cost for each rental.
Tabs and structure
Eight tabs: Start Here, Dashboard, Settings, Properties, Vendors, Work Orders, Preventive and Checks.
What you enter
- An as-of date (blank uses today) and target days to close by priority
- Up to 15 properties and 30 vendors
- Work orders: date, property, category, priority, vendor, status, cost, completion date and charge-back amount
- Up to 60 preventive tasks with frequency and last-done date
What it calculates
- Open and overdue flags and days open or to close per work order
- Net cost per property; jobs and total paid per vendor
- Next due date and status per preventive task
- Eight dashboard figures, cost by category with a bar chart, and five checks
How to use it
Fill Settings, Properties and Vendors, delete the sample rows, then add one row per repair request. Every check should read OK.
File and limitations
One .xlsx file for Excel 2016+ and Google Sheets. No macros. Sample data is fictional. Built with AI assistance and checked for formula errors. A record-keeping tool, not tax, legal or accounting advice.
With this comprehensive 5- or 10-year monthly tool, investors can assess the viability of setting up... Read more
The Mobile App Financial Plan Template in Excel allows you to develop financial projections when lau... Read more
The Food Truck Financial Model helps entrepreneurs, founders, business owners, consultants, and anal... Read more
The Green Hydrogen from Wind Financial Model aims to comprehensively forecast a horizon of 40 years ... Read more
Protect your business secrets with ease using our Simple Mutual Non-Disclosure Agreement Template. S... Read more
The Solar Energy Financial Model Spreadsheet Template in Excel assists you in preparing a sophistica... Read more
Starting a restaurant without a financial plan is like driving a car blindfolded. You wouldn´t do i... Read more
You must log in to submit a review.