Rental Property Accounting Spreadsheet for Landlords
Every property in one workbook, coded to Schedule E as you go - in Excel, Sheets or plain CSV. Yours in seconds.
Download the Free Spreadsheet
One workbook for every property you own. Log income and expenses as they happen, log the miles you drive, and the Schedule E Summary tab adds it all up by IRS line number at the end of the year.
With this free template, you’ll be able to:
- Track every property in one workbook - income, expenses, mileage and depreciation
- Code each cost to its IRS Schedule E line and get a per-property summary to hand your accountant
- Apply both 2026 IRS mileage rates automatically, from the date of each trip
- Read a month-by-month statement, a cash flow dashboard and a 20-point deduction checklist
- Work in Excel or Google Sheets, with a plain CSV pack included
This workbook and the guidance on this page are general information, not tax advice. IRS rules and rates change, and how they apply depends on your circumstances. Check your figures with a qualified accountant, or against current IRS guidance, before you file.
Produced by Landlord Studio
Other resources you might be interested in
Tenant Welcome Letter
Use our welcome letter template to help get your landlord/tenant relationship off to the right start.
Landlord Template Bundle
Get 30+ essential landlord templates, including lease agreements, notices and inspection checklists.
Rent Receipt Template
Issue clear rent payment receipts so you and your tenants keep accurate records of every payment.
This workbook still needs you to type in every receipt and bank line, then check the coding again at tax time. Landlord Studio pulls those straight from your bank feed and codes them as they land.