Guide
The Best Free Landlord Bookkeeping Spreadsheet (2026)
Landlord bookkeeping does not need expensive software - a well-built spreadsheet tracks income, expenses and profit per property and makes tax time painless. Here is what a good one must do in 2026.
What it must track
- Rent income per unit, month by month, including late or partial payments.
- Every deductible expense - repairs, maintenance, management, insurance, taxes, mortgage interest, supplies - categorised the way your tax return wants them.
- Net profit per property, not just a single combined total.
- Year-to-date totals ready for tax season.
- Multiple properties if you own more than one.
What to avoid
- A single column of transactions with no category roll-up - useless at tax time.
- No per-property split - you cannot tell which rental actually makes money.
- Tools that lock your data behind a monthly fee.
Frequently asked questions
Do I need accounting software to be a landlord?
Not for a small portfolio. A well-structured spreadsheet that tracks rent, categorised expenses and net profit per property, with year-to-date totals for taxes, handles most landlords' needs without a monthly software fee.
What expenses can landlords track for taxes?
Common deductible categories include repairs and maintenance, property management, insurance, property taxes, mortgage interest, supplies, and travel related to the rental. A bookkeeping spreadsheet should categorise these the way your tax return expects.
How should I track multiple rental properties?
Keep income and expenses separated per property so you can see which rental actually makes money, with a combined portfolio total on top. Per-property net profit and year-to-date figures make both decisions and tax filing far easier.
Related guides & free tools
- The Best Free Meal Planner Template (2026)How to choose a meal planner template in 2026 - linking meals to a grocery list and budget
- How Much Does a Wedding Cost in 2026? Full Budget BreakdownThe average US wedding costs about $34,000 (The Knot, 2026). See a full cost breakdown by category,
- Wedding Budget Percentages: How to Split Your Budget (2026)Spend ~50% on venue and catering, 12% on photography, and keep a 5% buffer. See the full 2
- Free Wedding Budget CalculatorFree tool · no signup
- Wedding Cost Estimator by Guest CountFree tool · no signup
The Plannful list
Join the Plannful list
Occasional wedding-planning emails from Plannful, and a note when a new template is ready. No spam, unsubscribe anytime.