Rental Property Spreadsheet
- ⬇ Files delivered instantly after purchase
- ∞ Lifetime access — download anytime
- ✎ You type in tinted cells; every formula is built & protected
- ♲ Support: message us any time, we answer personally
About this system
One Excel file that answers the three questions every landlord actually has: what did each property make, what do I hand my tax preparer, and who hasn't paid rent.
Type into two logs — income and expenses. Three reports fill themselves:
DASHBOARD — total income, total expenses and net operating income, portfolio-wide and per property. In the included example: 3 properties, $64,005.00 income, $11,474.24 expenses, $52,530.76 NOI for the year.
TAX SUMMARY — expense totals per property across 13 common rental-property recordkeeping categories (repairs, insurance, property taxes, mortgage interest, management fees and more). Year-end becomes a copy-out, not a shoebox sort.
RENT CHECK — a 12-month grid of rent actually received per property, straight from your income log. The example file ships with a July vacancy on Oak Ave so you can see exactly how a missed month looks: a zero you can spot from across the room.
What It Does
- Up to 10 properties, one file
- Income log with categories (rent, late fees, other)
- Expense log with 13 rental recordkeeping categories and notes
- Per-property income, expenses, NOI and rent-months-paid
- Year-end tax category totals per property and portfolio-wide
- Dropdown property and category pickers so names always match
- No macros
What You Get
- EXAMPLE workbook: 3 properties with a full year entered
- BLANK workbook: identical, empty, ready for your numbers
- 2 files in one ZIP, instant download
- Instructions built into the first tab
Honest Notes
- Built and tested in Microsoft Excel. Google Sheets is not tested and is not claimed.
- This spreadsheet is an organizational tool and is not tax, accounting or legal advice. It organizes rental income and expenses using common rental-property recordkeeping categories. Confirm tax classifications with a qualified professional.
- Every formula was machine-verified against an independent calculation engine before publishing (14 of 14 checks passed, to the cent).
- Designed, developed and tested by SwiftBudgetCo using AI-assisted tools.
Instant digital download — nothing is shipped. Message me if anything does not work and I will fix it or refund you.
