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.

Illustration of two yellow houses with a tree between them

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 you can file from
  • 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

Produced by Landlord Studio

rental accounting cover
Download the Spreadsheet

Other resources you might be interested in

Landlord Studio Icon

Tenant Welcome Letter

Use our welcome letter template to help get your landlord/tenant relationship off to the right start.

Landlord Studio Icon

Landlord Template Bundle

Get 30+ essential landlord templates, including lease agreements, notices and inspection checklists.

Landlord Studio Icon

Rent Receipt Template

Issue clear rent payment receipts so you and your tenants keep accurate records of every payment.