Edit the highlighted input cells; calculated results update automatically.

What's inside

  • Editable XLSX worksheet with room for 20 properties
  • Rent, insurance, mortgage interest, repairs, taxes, utilities, management, legal, supplies, cleaning, and other expense columns
  • Automatic total expenses and net rental income for each property
  • Portfolio totals for rents, expenses, and net rental income
  • Separate instructions sheet with recordkeeping guidance

Best for: Landlords preparing annual records · Small rental portfolios · Property owners working with a tax professional

What Schedule E is used for

Schedule E (Form 1040) is where US taxpayers report supplemental income and loss, including income from rental real estate. Part I is the rental section: each property gets its own column, with rents received near the top, expense categories in the middle, and net rental income at the bottom.

Most landlords do not file this worksheet with a return. It is a recordkeeping layer that collects the same categories as the form, so completing the official form or handing records to a preparer takes minutes instead of a weekend.

How the worksheet maps to Schedule E lines

The worksheet keeps one row per property and one column per expense category. The table shows how each column lines up with Part I of Schedule E.

Worksheet columnSchedule E Part I lineNotes
Rents receivedLine 3Gross rent collected for the year, before expenses
InsuranceLine 5Premiums paid for the rental period
Mortgage interestLine 6Interest paid to banks and lenders, not principal
RepairsLine 8Fixing what is broken; improvements follow different rules
TaxesLine 9Property taxes paid during the year
UtilitiesLine 10Only utilities the owner pays
Management feesLine 12Property manager and platform management fees
Legal / professionalLine 13Attorney, accounting, and eviction-related professional costs
SuppliesLine 14Consumable supplies bought for the property
Cleaning / maintenanceLine 15Cleaning, lawn, and routine maintenance services
Other expensesLine 19Itemize here: HOA dues, advertising, commissions, and similar costs
Total expensesLine 20Sum of the expense columns
Net rental incomeLine 21Rents received minus total expenses

Which rental expenses belong on the worksheet

The worksheet separates expense categories because the form separates them. Mortgage interest has its own column; loan principal does not appear at all. Repairs that keep the property in working condition are expenses, while improvements that add value or extend the useful life are generally capitalized and recovered through depreciation instead.

Three items cause most of the confusion. A tenant security deposit is not income when you receive it if it must be returned. Escrow payments blend principal, interest, taxes, and insurance, so pull the annual figures from the lender statement rather than the monthly payment. And personal spending from the same account is never a rental expense, which is why many owners keep a dedicated account per property.

A full-year rental property example

The sample Main Street Duplex collected $46,800 of rent. Insurance was $1,800, mortgage interest $21,840, repairs $1,450, property taxes $4,200, management fees $3,744, legal and professional costs $650, supplies $480, cleaning and maintenance $720, and other expenses $300. Total expenses of $35,184 leave $11,616 of net rental income for that property.

The portfolio view totals the same columns across properties: $113,520 of rent and $98,717 of expenses across the three sample properties, for $14,803 of net rental income. One sample property shows a loss for the year, which is normal after heavy turnover or a large repair, and the worksheet is designed to show that clearly rather than hide it.

Common Schedule E recordkeeping mistakes

These are the errors that most often force landlords to reconstruct records late in filing season.

  • Reporting mortgage principal on the mortgage interest line
  • Expensing improvements, such as a new roof or remodel, that should be depreciated
  • Treating a refundable security deposit as rent before it is actually earned
  • Combining several properties into one row instead of giving each property its own column
  • Mixing personal spending with rental spending in the same account
  • Waiting until filing season to rebuild twelve months of records that were never tracked

When to work with a tax professional

The worksheet organizes records; it does not decide how tax rules apply to your situation. Bring in a qualified tax professional for questions about passive activity loss limits, depreciation and cost recovery, repairs versus improvements, short-term rental rules, and multi-state filings.

This worksheet is a recordkeeping aid, not tax advice and not an official IRS form. Using it does not replace filing Schedule E, and the categories shown are simplified. Confirm how the rules apply to your return with a qualified tax professional.

Use in Google Sheets

This download is an XLSX workbook. Import it into your own Google Sheet to use it there.

  1. 1. Download the file, then opensheets.new.
  2. 2. In Google Sheets, choose File > Import > Upload.
  3. 3. Select Replace spreadsheet, then edit the yellow input cells.

Made for practical spreadsheet work by the Digital Store team. Formulas and example values are checked against the downloadable workbook; updated October 7, 2026. Use the file as a planning aid and verify decisions with your own records or professional advisor where appropriate.

Worked example

Three-property sample included in the workbook

Inputs

Properties
Main Street Duplex, Oak Avenue Rental, and Lakeview Short Rental
Total rents received
$113,520
Mortgage interest
$53,400
Cleaning and maintenance
$6,640

Outputs

Main Street total expenses
$35,184
Oak Avenue net rental income
$4,557
Portfolio total expenses
$98,717
Portfolio net rental income
$14,803

The workbook is a recordkeeping aid, not tax advice. Confirm final treatment with a qualified tax professional.

Related free templates

View Rental Property Accounting

Customer feedback

No reviews yet. Try the file and be the first to share how it worked for you.
Write a review

Download this file first to unlock review submission.

Your rating

FAQ

Is this an official IRS form?

No. It is an independent recordkeeping worksheet that mirrors the common Schedule E rental categories. It is not published by the IRS and is not filed with a return. You or your preparer still complete the official Schedule E (Form 1040).

Does mortgage principal go on Schedule E?

No. Only mortgage interest paid to the lender belongs on line 6. Principal payments reduce the loan balance and are not an expense on Schedule E, and principal is separate from depreciation.

How long should I keep rental records?

A common baseline is at least three years after the return was filed, with longer periods in some situations, such as six years when income is substantially understated. Records that support depreciation should be kept for as long as you own the property plus the years the related returns stay open. Confirm the specifics with your tax professional.

Can I use this for multiple properties?

Yes. The worksheet has room for 20 properties, one row each, plus portfolio totals. On Schedule E each property gets its own column in Part I, so keeping one worksheet row per property makes the transfer straightforward.

Is the Schedule E worksheet free to download?

Yes. The worksheet can be downloaded without payment, an account, a credit card, or an email address.

Can I use the worksheet in Google Sheets?

Yes. Download the XLSX file and import it into Google Sheets. The property rows, category columns, and total formulas remain editable.

Questions? Contact us