Free Schedule E Excel Template (Rental Income Worksheet)
What's in the Schedule E template
The template is a single Schedule E sheet laid out as a line-by-line worksheet: rows for each Schedule E line item, columns for Property A, B, and C, and a total column. Because the line labels mirror the IRS form, moving numbers from the worksheet to your actual return (or your CPA's software) is a matter of matching line to line.
It covers up to 3 properties side by side, which is the layout most landlords with a small portfolio actually need — enough to compare properties without a workbook per property.
What calculates automatically
Enter rents received and each expense line for each property, and the Total column sums across Property A, B, and C on that line automatically. The summary rolls everything up into total income, total expenses, and net income across your whole portfolio.
That means you're never re-adding a column of expense lines by hand or reconciling three separate property totals yourself — the worksheet keeps every number consistent as you fill it in.
Why this beats a blank spreadsheet
Building a Schedule E worksheet from scratch means matching your own layout to 20-odd IRS line items, then writing and checking the row and column totals yourself — easy to get subtly wrong right before you hand numbers to your CPA.
This template already has the Schedule E line labels and the totals in place. You're filling in income and expense numbers per property, not building or debugging a worksheet.
How to use it
- Enter rents received for each property in the appropriate column.
- Enter each expense line item per property using the pre-labeled Schedule E rows.
- Check the Total column for the sum across all three properties per line.
- Review total income, total expenses, and net income in the summary before handing numbers to your CPA.
Download the free Free Schedule E Excel Template (Rental Income Worksheet)
No spam — template updates and new free templates only. Unsubscribe anytime.
Real Estate Investor Pack
For a portfolio beyond simple line totals, the paid Real Estate Investor Pack ($39) adds a full Rental P&L with amortization schedule, a Returns Dashboard (NOI, cash flow, cash-on-cash, cap rate, DSCR), plus a development proforma and CMA — three connected workbooks instead of one worksheet.
See the full versionFrequently asked questions
Can I use this Schedule E template in Google Sheets?
Yes. Upload the downloaded file to Google Drive and open it with Sheets — File > Save as Google Sheets keeps the totals working.
Is this template really free?
Yes. You give an email address to download it, and it's yours to reuse every tax year at no further cost.
Is this tax advice?
No. This is a planning and organizing tool only, not tax advice. Verify categories and totals with your CPA before filing.
What if I have more than 3 rental properties?
The worksheet is built for 3 properties. For a larger portfolio, you'd duplicate the sheet or use a more advanced workbook — see the note on the premium pack below.
What's the usage license?
Personal use or use within one business. It isn't meant to be resold or redistributed as a template product.
Does this replace my CPA?
No. It organizes your numbers by Schedule E line so tax time is faster, but a CPA should still review and file your return.