Not every PM company needs expensive software from day one. Whether you're managing 10 units or 100, well-designed spreadsheets can handle most of your operational tracking until you're ready to invest in dedicated PM software. Here are the templates you actually need, with exactly what columns to include and how to use them.
1. Rent Roll & Collection Tracker
This is the most important spreadsheet in your PM operation. It tracks every dollar that should come in and whether it actually did.
Columns to Include:
| Column | Purpose | Example |
|---|---|---|
| Property Address | Which property | 123 Oak St, Unit 2B |
| Tenant Name | Who's responsible | Sarah Johnson |
| Lease Start | When lease began | 2025-06-01 |
| Lease End | Expiration tracking | 2026-05-31 |
| Monthly Rent | Contracted amount | $1,450 |
| Security Deposit | Amount held | $1,450 |
| Date Paid | When rent received | 2026-03-01 |
| Amount Paid | What they paid | $1,450 |
| Late Fee | If applicable | $0 |
| Balance | Outstanding amount | $0 |
| Payment Method | Check/ACH/portal | ACH |
| Notes | Any context | Paid on time |
Formulas You Need:
=SUMIF(Owner, "Smith", AmountPaid)— Total collected per owner=COUNTIF(Balance, ">0")— Number of delinquent tenants=AmountPaid/MonthlyRent— Collection rate percentage=IF(DatePaid > DueDate, LateFeeAmount, 0)— Auto-calculate late fees
2. Maintenance Request Log
Every maintenance request needs to be logged, tracked, and closed. This spreadsheet is your maintenance record — critical for owner reporting, vendor management, and legal protection.
Essential Columns:
| Column | Purpose |
|---|---|
| Request # | Unique ID (auto-increment) |
| Date Submitted | When tenant reported |
| Property/Unit | Which unit |
| Tenant | Who reported |
| Category | Plumbing/HVAC/Electrical/Appliance/General |
| Priority | Emergency/Urgent/Routine |
| Description | What's the issue |
| Vendor Assigned | Who's fixing it |
| Date Scheduled | When repair is scheduled |
| Date Completed | When actually fixed |
| Cost | Total repair cost |
| Charged To | Owner/Tenant/Insurance |
| Status | Open/In Progress/Completed/Waiting on Parts |
| Notes | Photos, access info, follow-up |
Key Metrics to Track:
- Average resolution time: Days from request to completion. Target: under 3 days for routine, same-day for emergencies.
- Cost per unit per month: Total maintenance spend ÷ total units. Industry average: $100-200/unit/month.
- Vendor performance: Which vendors are fastest, cheapest, and most reliable? Track it.
- Repeat issues: Same unit, same problem? Might be time for a capital replacement instead of another repair.
3. Tenant Information Database
Quick access to every tenant's key information. No digging through files when someone calls at 10 PM about a water leak.
What to Track:
- Full legal name(s) on lease
- Phone number (primary + emergency)
- Email address
- Property address and unit number
- Lease dates (start, end, renewal options)
- Rent amount and due date
- Security deposit amount and where held
- Pet information (type, breed, weight, pet deposit/fee)
- Vehicle information (make, model, license plate — for parking)
- Emergency contact (name, relationship, phone)
- Move-in condition notes
- Renter's insurance policy number and expiration
4. Expense Tracking & Categorization
Track every dollar spent, categorized for easy tax reporting and owner statements.
Categories to Use:
| Category | Examples | Tax Line |
|---|---|---|
| Repairs & Maintenance | Plumbing fix, paint touch-up, appliance repair | Schedule E, Line 14 |
| Capital Improvements | New roof, HVAC replacement, remodel | Depreciated (Form 4562) |
| Insurance | Property insurance, liability, umbrella | Schedule E, Line 9 |
| Property Taxes | Annual property tax | Schedule E, Line 16 |
| Utilities | Water, sewer, trash, electric (if owner-paid) | Schedule E, Line 17 |
| Management Fees | Your management fee | Schedule E, Line 18 |
| Landscaping | Lawn care, tree trimming, snow removal | Schedule E, Line 14 |
| Legal & Professional | Attorney, CPA, eviction filing fees | Schedule E, Line 10 |
| Advertising | Listing fees, signage, photos | Schedule E, Line 5 |
| Supplies | Cleaning supplies, locks, keys, office supplies | Schedule E, Line 14 |
Monthly Summary Formula:
Use a pivot table or SUMIF formulas to create monthly summaries by property and category. This feeds directly into your owner statements.
5. Owner Reporting Template
Every owner wants to know three things: How much did you collect? How much did you spend? What's my net?
Monthly Owner Statement Should Include:
- Income section: Rent collected, late fees, other income (laundry, parking, pet fees)
- Expense section: Every expense itemized with date, vendor, and amount
- Management fee: Your fee clearly shown
- Net to owner: Income minus expenses minus your fee
- Year-to-date totals: Running YTD for income, expenses, and net
- Maintenance summary: What work was done and why
- Vacancy status: If applicable, marketing activity and showings
6. Lease Expiration Tracker
Never be surprised by an expiring lease again. This simple tracker prevents month-to-month surprises and helps you plan rent increases.
Columns:
- Property/Unit
- Tenant name
- Lease end date
- Notice required (30/60/90 days per state law)
- Renewal notice deadline (lease end minus notice period)
- Current rent
- Proposed new rent
- Renewal status (Sent/Signed/Declined/Month-to-Month)
Use conditional formatting: Red for leases expiring within 30 days, yellow for 60 days, green for 90+ days. Check this weekly.
7. Vacancy & Make-Ready Tracker
From move-out notice to new lease signing — track every step of the turnover process.
| Step | Target Timeline | Track These |
|---|---|---|
| Move-out notice received | Day 0 | Date, tenant, unit |
| Pre-move-out inspection | Day 1-3 | Date, condition notes, estimated turnover cost |
| Unit listed for rent | Day 1 | Listing date, platforms, asking rent |
| Move-out completed | Per lease | Actual date, keys returned |
| Make-ready started | Move-out + 1 day | Vendor assignments, scope of work |
| Make-ready completed | 3-7 days after start | Completion date, total cost |
| Showings | Ongoing | Number of showings, feedback |
| Application received | ASAP | Date, applicant name |
| Lease signed | ASAP | Date, move-in date, rent amount |
| Deposit accounting sent | Per state law | Date sent, amount returned/retained |
Key metric: Days on market (DOM). Industry benchmark for professional PMs: 14-21 days from vacancy to new lease signed. If you're consistently over 30 days, your pricing or marketing needs work.
When to Upgrade from Spreadsheets to Software
Spreadsheets work well up to about 50-75 units. Beyond that, you'll start hitting limitations:
- Multiple users: When 2+ team members need to update the same data, conflicts happen
- Tenant portal: Tenants expect online payment and maintenance requests
- Owner portal: Owners want real-time access to statements and documents
- Trust accounting: Spreadsheets can't properly handle trust account compliance
- Automated communications: Lease renewal reminders, late payment notices, etc.
When you hit these pain points, check out our PM Software Comparison Guide to find the right platform for your size.
Get Professional PM Templates
Our PM Scaling Kit includes professionally designed spreadsheet templates, SOPs, checklists, and operational guides — everything you need to run a tight PM operation.
Get the PM Scaling Kit — $147Related reading: