Rental Property Spreadsheet Template Guide: Build Your Own in 2026

A well-structured spreadsheet is the entry point for almost every landlord's financial tracking system. It's free, flexible, and — if set up correctly — surprisingly powerful. The problem is that most landlords start with a random template they found online, never customize it properly, and end up with a disorganized mess that makes tax season a nightmare. This guide walks you through building a rental property spreadsheet from scratch, with every column, formula, and tab you need.

The Spreadsheet Structure: 6 Essential Tabs

A proper rental property spreadsheet isn't a single sheet — it's a workbook with multiple connected tabs. Here's the structure:

1. Dashboard: Summary overview of all properties
2. Property Info: Key details about each property
3. Income Tracker: Monthly rent and other income by property
4. Expense Tracker: Every expense, categorized by Schedule E line items
5. Cash Flow Summary: Monthly and annual cash flow per property
6. Tax Summary: Year-end report formatted for Schedule E

Tab 1: Dashboard

The dashboard is your command center — a single page showing the health of your entire portfolio at a glance. Create it last (after the other tabs) so it pulls data from them.

Columns and Layout

• Property name (row 1 for each property)
• Address
• Monthly rent (pulled from Income Tracker)
• YTD income (SUMIF from Income Tracker)
• YTD expenses (SUMIF from Expense Tracker)
• YTD cash flow (income minus expenses)
• Cash-on-cash return YTD (cash flow ÷ cash invested)
• Occupancy status (rented/vacant)
• Lease end date
• Next rent increase date

Use conditional formatting: green for positive cash flow, red for negative. Add a "Portfolio Total" row at the bottom that sums all properties.

Tab 2: Property Info

This tab holds the static data for each property. It's your reference sheet.

Columns

• Property ID (e.g., "P1", "P2")
• Property name (e.g., "123 Main St")
• Address
• City, State, ZIP
• Property type (single-family, duplex, condo, etc.)
• Purchase date
• Purchase price
• Land value (for depreciation calculation)
• Building value (purchase price − land value)
• Annual depreciation (building value ÷ 27.5)
• Down payment
• Closing costs
• Initial rehab costs
• Total cash invested (down payment + closing + rehab)
• Loan amount
• Interest rate
• Monthly P&I payment
• Monthly property taxes
• Monthly insurance
• Monthly rent
• Security deposit held
• Current tenant name
• Lease start date
• Lease end date

This tab rarely changes. Update it when you buy/sell a property, refinance, or sign a new lease.

Tab 3: Income Tracker

This tab records every dollar of rental income. Each row is one payment.

Columns (A–J)

• A — Date: When payment was received
• B — Property ID: Link to Property Info tab (dropdown)
• C — Income Type: Dropdown — Rent, Late Fee, Pet Fee, Laundry, Parking, Other
• D — Description: Brief note (e.g., "March rent", "Late fee — February")
• E — Amount: Dollar amount received
• F — Payment Method: Dropdown — Check, ACH, Cash, Card, Venmo, Zelle, Other
• G — Month: What month is this payment for (dropdown, Jan–Dec)
• H — Year: Year (2026)
• I — Status: Dropdown — Received, Pending, Bounced
• J — Notes: Any relevant notes

Key Formulas

Total monthly income per property:

=SUMIFS(E:E, B:B, "P1", G:G, "Jan", H:H, 2026)

YTD income per property:

=SUMIFS(E:E, B:B, "P1", H:H, 2026)

Total portfolio income YTD:

=SUMIFS(E:E, H:H, 2026)

Tab 4: Expense Tracker

This is the most important tab for tax purposes. Every expense goes here, categorized by Schedule E line items. This is where the spreadsheet earns its keep.

Columns (A–K)

• A — Date: When expense was incurred
• B — Property ID: Dropdown (same as Income Tracker)
• C — Category: Dropdown matching Schedule E line items (see below)
• D — Sub-Category: More specific (e.g., "HVAC repair" under "Repairs")
• E — Vendor: Who you paid
• F — Description: What was done/bought
• G — Amount: Dollar amount
• H — Payment Method: Dropdown — Check, ACH, Credit Card, Cash, Debit
• I — Receipt: Link to digital receipt (Google Drive link, etc.)
• J — Reimbursable: Yes/No — was this reimbursed by tenant or insurance?
• K — Notes: Any relevant context

Expense Categories (Matching Schedule E)

Use these exact categories — they map directly to Schedule E line items:

1. Advertising
2. Auto and Travel (mileage at 70¢/mile or actual costs)
3. Cleaning and Maintenance
4. Commissions (leasing fees)
5. Depreciation (calculated on Tax Summary tab, not entered manually)
6. Insurance
7. Legal and Professional Fees
8. Management Fees
9. Mortgage Interest (from Form 1098)
10. Other Interest
11. Repairs
12. Supplies
13. Taxes (property taxes)
14. Utilities
15. HOA Fees/Dues
16. Pest Control
17. Lawn Care/Snow Removal
18. Tenant Screening
19. Software/Subscriptions
20. Licenses/Permits
21. Other (with sub-category)

Key Formulas

Total expenses by category for Schedule E:

=SUMIFS(G:G, C:C, "Repairs", B:B, "P1")

YTD total expenses per property:

=SUMIFS(G:G, B:B, "P1", A:A, ">="&DATE(2026,1,1), A:A, "<="&DATE(2026,12,31))

Repairs vs. Improvements ratio (for your own analysis):

=SUMIFS(G:G, C:C, "Repairs") / SUMIFS(G:G, C:C, "Improvements")

Tab 5: Cash Flow Summary

This tab calculates monthly cash flow for each property, showing whether each unit is profitable.

Layout

Rows: Each property (P1, P2, P3...)
Columns: January through December + YTD Total

For each cell, calculate:

Monthly Income − Monthly Expenses − Mortgage Payment

Income formula (from Income Tracker):

=SUMIFS('Income Tracker'!E:E, 'Income Tracker'!B:B, "P1", 'Income Tracker'!G:G, "Jan", 'Income Tracker'!H:H, 2026)

Expenses formula (from Expense Tracker):

=SUMIFS('Expense Tracker'!G:G, 'Expense Tracker'!B:B, "P1", 'Expense Tracker'!A:A, ">="&DATE(2026,1,1), 'Expense Tracker'!A:A, "<="&DATE(2026,1,31))

Mortgage payment (from Property Info):

='Property Info'!P2 (monthly P&I)

Monthly cash flow:

=Income − Expenses − Mortgage

Add conditional formatting: positive = green, negative = red. This gives you instant visual feedback on which properties are performing.

Annual Cash Flow per Property

YTD Total column: =SUM(B2:M2) (Jan through Dec for that property)

Portfolio Total Row

Bottom row sums all properties per month: =SUM(B2:B10)

Tab 6: Tax Summary

This tab generates your Schedule E-ready report. It's the payoff for keeping your data organized all year.

Layout

Rows: Each Schedule E line item
Columns: One per property + Total column

Schedule E Line Items (Rows)

1. Gross rents (from Income Tracker, "Rent" type only)
2. Advertising
3. Auto and travel
4. Cleaning and maintenance
5. Commissions
6. Insurance
7. Legal and professional fees
8. Management fees
9. Mortgage interest (from 1098)
10. Other interest
11. Repairs
12. Supplies
13. Taxes
14. Utilities
15. HOA fees
16. Depreciation (from Property Info: building value ÷ 27.5)
17. Other expenses (pest, lawn, screening, software, licenses)
18. Total expenses (sum of rows 2–17)
19. Taxable income (row 1 − row 18)

Formula Example for Each Cell

Advertising for P1:

=SUMIFS('Expense Tracker'!G:G, 'Expense Tracker'!B:B, "P1", 'Expense Tracker'!C:C, "Advertising")

Gross rents for P1:

=SUMIFS('Income Tracker'!E:E, 'Income Tracker'!B:B, "P1", 'Income Tracker'!C:C, "Rent")

Depreciation for P1 (annual, from Property Info):

='Property Info'!J2 (where J2 contains building value ÷ 27.5)

At tax time, hand this tab to your CPA or transfer the numbers directly to Schedule E. Each column maps to one property's Schedule E entry. Total time: 15 minutes instead of hours of hunting through receipts.

Advanced Features to Add Later

Vacancy Tracking

Add a column to Income Tracker for "Expected Rent" vs "Actual Rent." The difference reveals vacancy losses. If expected rent for P1 in March is $1,800 but actual is $0, you know the unit was vacant.

Maintenance Reserve Tracking

Add a column in the Property Info tab for "Capex Reserve" — the amount you set aside each month for capital expenditures. A common rule: $100–$200/unit/month. Track the balance like a savings account within the spreadsheet.

ROI and Cap Rate Calculations

Add a section to the Dashboard:

• Cap rate: =NOI / Property Value (annual)
• Cash-on-cash return: =Annual Cash Flow / Cash Invested
• Total ROI: =(Cash Flow + Appreciation + Loan Paydown) / Cash Invested

Mortgage Amortization

Add a tab with a mortgage amortization schedule for each property. This shows how much of each payment is interest (deductible) vs. principal (not deductible). Essential for accurate tax tracking.

Common Spreadsheet Mistakes to Avoid

• Not using data validation. Without dropdowns, you'll get "repairs," "repair," "Repairs," and "REPAIRS" — four entries that your SUMIFS formulas won't catch. Enforce consistent spelling with dropdowns.
• Mixing personal and business. Don't put personal expenses in your rental spreadsheet. It corrupts your data and makes tax prep a nightmare.
• Not backing up. If using Excel locally, save to cloud storage. Google Sheets auto-saves, but download a copy monthly as backup.
• Overcomplicating. Don't add 50 columns you'll never use. Start with the essentials above and add columns only when you find yourself needing data you can't currently track.
• No receipt links. Enter the receipt link (Google Drive, Dropbox) at the same time you enter the expense. No receipt = potential lost deduction in an audit.
• Forgetting depreciation. Depreciation isn't a cash expense, so it's easy to forget. Calculate it on the Property Info tab and auto-populate the Tax Summary. A $200,000 building generates $7,273/year in deductions — don't miss it.

When to Upgrade from Spreadsheet to Software

Spreadsheets work well up to about 3 properties. Beyond that, the time investment grows faster than linear:

• 1 property: 30–45 min/month on spreadsheet maintenance
• 2 properties: 1–1.5 hours/month
• 3 properties: 2–2.5 hours/month
• 5 properties: 4–5 hours/month (errors increase)
• 10+ properties: 8–10 hours/month (unsustainable)

When you spend more than 2 hours/month on your spreadsheet, it's time to consider property management software like RentalsHandled. At $20–$50/month, the time savings alone justify the switch, and you also get automatic rent collection, late fee calculation, tenant reminders, and instant Schedule E reports.

A good spreadsheet is a tool, not a permanent solution. Build it well, maintain it diligently, and when your portfolio outgrows it, migrate to software. The discipline you learned keeping the spreadsheet accurate will carry over — and the software will feel like magic.