Rental Property Tax Prep Kit Excel for your landlords and rental property owners getting ready for tax season — rent income by property, expenses with repairs vs improvements, depreciation, a tax summary, and a filing…
About this template
Rental Property Tax Prep Kit Excel for your landlords and rental property owners getting ready for tax season — rent income by property, expenses with repairs vs improvements, depreciation, a tax summary, and a filing checklist. Know what each property earned, what you can deduct, and what you still need to file.
$39
Excel & Google Sheets template — instant download on Etsy
Rental Income Log — date, property, tenant or source, rent received, other income, total income, and whether a 1099 arrived, for every rent payment. Vacant months show up as missing rows.
Rental Expense Log — date, property, item, category, amount, and whether it is a repair or an improvement, for every rental expense. Repairs deduct now; improvements are capitalized and deduct 0 this year by formula.
Depreciation Schedule — property or asset, placed-in-service date, purchase price, land value, building basis, and the annual depreciation estimate for every depreciable asset, at 27.5 years for residential rental property.
Tax Summary and Filing Checklist — total rental income, deductible expenses, net before depreciation, depreciation, net rental income or loss, net by property, the passive-loss planning note, the depreciation recapture note, and a checklist of documents still needed.
Dashboard — total rent, months rented, vacant months, vacancy rate, deductible expenses, improvements capitalized, depreciation, net rental income or loss, net by property, largest expense category, and documents still needed.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Rental Property Tax Prep Kit
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Rental Property Tax Prep Kit track?
The Rental Property Tax Prep Kit tracks Rental Income Log; Rental Expense Log; Depreciation Schedule; Tax Summary and Filing Checklist; Dashboard.
What do the example numbers show?
The included example shows: 24 income rows; rent received 31,300; other income 275 (late fee 75, pet fee 200); total rental income 31,575; 22 months rented; 2 vacant months (Mesa condo, March and April); vacancy rate 8.3 percent.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.