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.
Keep clean books
The Plannful Landlord Toolkit tracks rent, categorised expenses and net profit per property with year-to-date totals - in Excel or Google Sheets, a one-time purchase you keep forever.
Analysing a deal before you buy? Use the Rental Property Analyzer.
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 $35,000 in 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
- How to Calculate Airbnb Profit in 2026 (STR Income, Expenses & ROI)Airbnb hosts net about 30-40% of gross revenue after expenses in 2026. Learn how to calcul
- Free Wedding Budget CalculatorFree tool · no signup
- Wedding Cost Estimator by Guest CountFree tool · no signup
Free cheat sheet
Get the 1-page wedding budget cheat sheet
Join the Plannful list for a simple breakdown of how to split your wedding budget by guest count — plus the occasional template discount. No spam, unsubscribe anytime.