SheetSmart Co Studio

Free Schedule E Worksheet for Rental Property

This free Schedule E worksheet for rental property adds up one property's income and expenses by Schedule E line and shows total expenses (line 20) and income or loss (line 21).

Everything runs in your browser. Nothing you type is sent anywhere or saved. Use one worksheet per property, then print it or save it as a PDF for your records or your tax preparer.

Property

Income and expenses for the year

Quick checks

How to use this Schedule E worksheet

  1. Gather your rent records, bank and card statements, Form 1098, insurance and property tax bills.
  2. Total each category for the property (the Schedule E categories guide explains each line).
  3. Enter the totals. Line 18 depreciation usually comes from Form 4562; leave it at 0 if you don't have it yet.
  4. Read the checks, then print. Your tax software or preparer transfers the numbers to Schedule E.

This worksheet is a calculator, not tax advice. It doesn't apply passive loss limits, depreciation rules or vacation-home allocation.

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)

FAQ

Is this Schedule E worksheet free?

Yes. It runs in your browser, needs no sign-up and doesn't send or store your numbers.

Can I use it for more than one property?

Use it once per property and print each one. Our Etsy spreadsheet handles up to 50 properties automatically.

Does it calculate depreciation?

No. Enter the depreciation amount from Form 4562 or your tax preparer on line 18.

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.