SheetSmart Co Studio

Rental Property Spreadsheet for Google Sheets, Built Around Schedule E

A rental property spreadsheet is the simplest way for a small landlord to track rent, expenses and taxes without paying for monthly software. This site has free guides and a free Schedule E worksheet, plus the spreadsheet we sell on Etsy.

Rental property spreadsheet: a bank statement imported into Google Sheets and summarized on Schedule E
A bank statement goes in; a per-property Schedule E summary comes out.

Free tools and guides

Free Schedule E worksheet

Add up one property's rent and expenses by Schedule E line, right in your browser.

How to do bookkeeping for rental property

A simple monthly routine for 1–50 rentals.

Schedule E expense categories

Every line 3–21, with examples.

Landlord tax deductions checklist

What rental expenses you can deduct, and what you can't.

Can you deduct mortgage payments?

Interest yes, principal no. Here's how to split it.

Is a security deposit rental income?

When a deposit counts and when it doesn't.

Import a PDF bank statement into Google Sheets

CSV, PDF and AI options compared.

What's in our rental property spreadsheet

Honest limits: the statement import runs in a computer browser, not the Google Sheets phone app. Categories are suggestions you review. It's an organizing tool, not tax advice.

Want this done for you? Our rental property spreadsheet for Google Sheets imports a bank statement (PDF or CSV), suggests a Schedule E category for each line, flags the ones it isn't sure about, and fills in a per-property Schedule E summary. Up to 50 properties, Excel version included. The statement import needs a computer browser.
See it on Etsy ($14.99, one-time)

Last reviewed 2026-11-18. General information for US landlords, not tax, legal or accounting advice. Check your own situation with a tax professional and the IRS sources linked above.