Rental Income Tracker

Description

The Rental Income Tracker is a comprehensive spreadsheet template designed for landlords and real estate investors to systematically record rental income, track deductible expenses, and prepare Schedule E (Supplemental Income and Loss) data for their U.S. federal tax return. Whether you own a single rental property or a portfolio of investment properties, this template provides a structured framework for capturing every financial transaction associated with your rental activities throughout the tax year. The income section tracks gross rents received, security deposits (distinguishing between refundable deposits that are not income and forfeited deposits that are), advance rent payments, and any other income such as late fees or lease cancellation payments. The expense section is organized to match the line items on Schedule E, covering advertising, auto and travel expenses, cleaning and maintenance, commissions, insurance, legal and professional fees, management fees, mortgage interest, other interest, repairs, supplies, taxes, utilities, depreciation, and other expenses. Each expense entry captures the date, amount, vendor, property address, and description, creating a detailed audit trail that stands up to IRS scrutiny. For taxpayers with multiple rental properties, the template includes separate tabs for each property with a consolidated summary that automatically aggregates totals for Schedule E reporting. The depreciation section helps you track the basis, placed-in-service date, useful life, and accumulated depreciation for each property and any improvements, using the Modified Accelerated Cost Recovery System (MACRS) applicable to residential and commercial rental property. Additional features include a rent roll for tracking tenant payments and balances, a capital improvement log for distinguishing between deductible repairs and capitalizable improvements, and a section for tracking passive activity loss limitations that may restrict your ability to deduct rental losses against other income.

Steps

Applicable Forms

Target Audience

Landlords, real estate investors, and property managers tracking rental property income and expenses for tax purposes

Frequently Asked Questions