RENTAL PROPERTY & LANDLORD BOOKKEEPING SPREADSHEET
For landlords who are currently doing this with a shoebox, a bank app, and a bad feeling in January. Track up to 15 properties. Log rent as it lands, log expenses as they happen, log your mileage the day you drive it. The workbook does the rest. At tax time you open one tab, hit print, and hand your accountant a clean summary already organised by IRS Schedule E line. Works in Google Sheets, Microsoft Excel, and Apple Numbers.
THE PART NOBODY ELSE GETS RIGHT
The IRS changed the business mileage rate in the middle of 2026. This workbook stores a dated rate table and applies the correct rate to every trip automatically, based on the date you drove it.
WHAT IS INSIDE
- START HERE: Instructions and colour key.
- SETUP: Add up to 15 properties; set tax year.
- INCOME LOG: 500 rows for rent, fees, etc.
- EXPENSE LOG: 500 rows tagged to IRS Schedule E categories.
- MILEAGE LOG: 300 rows with automatic rate application.
- TENANTS & LEASES: Tracks lease status/dates.
- DASHBOARD: Portfolio/per property metrics (cash flow, cap rate, etc.).
- SCHEDULE E SUMMARY: Printable page per property.
- REPAIRS VS IMPROVEMENTS: 20 examples and a helper tool.
- LISTS: Powers dropdown menus.
ALSO INCLUDED
Setup Guide PDF, Schedule E Cheat Sheet PDF, Terms of Use.
WHO THIS IS FOR
Landlords with 1-15 units, accidental landlords, Airbnb hosts, and anyone tired of reconstructing expenses from bank statements.
HOW IT WORKS
Buy, download, import to Google Sheets or open in Excel, enter properties, and log as you go. No subscription or monthly fees.
Because this is an instant digital download, all sales are final and no refunds are offered. This is a bookkeeping tool, not tax or financial advice.
