Free Rental Property Worksheets For Landlords

Landlord Studio has three free rental property spreadsheets, and each one does a different job. Use the table to pick the right one, then jump to its section.

• Tracking income and expenses for a rental you own? Get the free rental accounting workbook.
• Deciding whether to buy a property? Use the free rental property analysis spreadsheet.
• Building your own expense tracker? Follow our guide to tracking rental property expenses in a spreadsheet.

Free rental property accounting spreadsheet

The free rental accounting workbook is the one to use once you own a rental. It keeps income and expenses for each property in one file, and every cost is coded to its Schedule E line (Schedule E is the IRS form for rental income and expenses) as you enter it, so year-end is a matter of totals rather than sorting receipts.

It includes:

• An income and expense log
• A month-by-month profit and loss statement
• A cash flow dashboard
• Expense categories that follow the lines on Schedule E (Form 1040)

It works in Excel, Google Sheets or as a plain CSV.

Profit and loss is built in

You don't need a separate profit and loss template. The workbook builds a month-by-month statement from the same entries, so you can see what each rental earns without keeping two files. For more on reading one, see our guide to the rental property profit and loss report.

Free rental property analysis spreadsheet

If you're still deciding whether to buy, you need a different kind of spreadsheet. The free rental property analysis spreadsheet takes your offer price, rent, running costs and loan terms, then works out monthly cash flow, cap rate, cash-on-cash return, DSCR and GRM. It also scores the deal against your own buy criteria.

It opens with a sample deal already filled in, so you can see how each number is calculated before you enter your own.

How to track rental property expenses in a spreadsheet

If you'd rather build your own tracker, our guide to the rental property expenses spreadsheet covers which categories to include, how to organize receipts and what to set up for tax time.

What to track about your tenants

We don't have a separate tenant spreadsheet. If you keep tenant details in your own sheet, one row per tenancy works well, with columns for:

• Tenant name, phone and email
• Property and unit
• Lease start and end dates
• Monthly rent and due date
• Security deposit amount and date received
• Notes on renewals, repairs or late payments

Keep security deposit records alongside the lease. Many states set rules on how deposits are held and returned, so check your state's security deposit laws.

When a spreadsheet stops being enough

A spreadsheet works well for one or two rentals. It gets harder once you're chasing rent, matching bank transactions and rebuilding reports every tax season.

Landlord Studio does the same jobs as these spreadsheets, without the manual entry. You can collect rent online with auto-pay, scan receipts with SmartScan, log trips with the mileage tracker and run 15+ accountant-approved reports, including the rent roll and tenant ledger. The free Go plan covers up to 3 units and 1 user. Pro adds bank feeds, which pull transactions in from your bank account automatically, plus automated email rent reminders, lease expiry reminders and Schedule E.

Moving your spreadsheet into Landlord Studio

1. Match your expense categories to Landlord Studio's, which follow the Schedule E lines.
2. Export your expenses as a CSV file.
3. Create your free Landlord Studio account.
4. Add your first property and import its expenses.
5. Add your lease details and past rent payments.

How long this takes depends on how much history you bring across. See how the spreadsheet import works.

Frequently asked questions

Is there a free rental property spreadsheet in Excel?

Yes. The free rental accounting workbook works in Excel, Google Sheets or as a CSV, and the rental property analysis spreadsheet works in Excel or Google Sheets.

Can I use these spreadsheets in Google Sheets?

Yes. Upload the file to Google Drive and open it in Google Sheets. Check that the formulas carried over, then save a copy for each property.

Is there a PDF version?

The spreadsheets are Excel files, not PDFs, because the formulas need a spreadsheet to run. You can print or export any tab as a PDF from Excel or Google Sheets.

Which spreadsheet should I use for tax time?

Use the rental accounting workbook. It codes every expense to a Schedule E line as you enter it. Check your return with a tax professional before you file.

Can one spreadsheet handle multiple properties?

You can, but it gets harder to keep straight as you add units. Once you're past a handful of units, software that reconciles bank transactions for you will save more time than a bigger spreadsheet.