Schedule E Rental Expense Tracker

Track rental income and expenses in Schedule E categories all year, and walk into tax time organized.

Tax season is much easier when your numbers already match the form. This tracker keeps rental income and expenses in the same categories you'll see on Schedule E (Form 1040), month by month, for up to four properties.

Type each month's rents and expenses into yellow cells: advertising, auto and travel, cleaning and maintenance, commissions, insurance, legal and professional fees, management, mortgage and other interest, repairs, supplies, taxes, utilities, depreciation (annual), and other. Gray cells total everything automatically.

The annual rollup gives you:

• Totals per property
• - A combined total you can hand straight to your tax preparer
• - A cash-in-the-door check for combined rents

What's inside: an Inputs tab, a monthly grid for each of four properties, the annual rollup, a How to use tab, and two fictional sample properties (a duplex and a single-family home with a vacant month) so you can see real math right away. Properties 3 and 4 are ready to fill in. No macros; protected without a password.

It works in Excel and Google Sheets. It's an instant download (.xlsx). This is a bookkeeping tool, not tax advice; it does not file a return.

Tags: schedule e, rental expense tracker, landlord tax spreadsheet, rental income tracker, rental property expenses, bookkeeping, google sheets, landlord spreadsheet