How to Track Rental Property Income and Expenses for Taxes in a Spreadsheet

It’s April 12th. Your rental property’s tax numbers are spread across a bank statement, a shoebox of hardware-store receipts, a few Venmo notes from a tenant, and your memory of that plumber who took cash. Now you — or your accountant, at $200 an hour — have to turn that into a clean Schedule E. Every year you promise it’ll be different, and every year it isn’t.

The fix isn’t working harder in April. It’s spending ninety seconds a week the rest of the year so April becomes a copy-and-paste job.

Why “I’ll Sort It Out at Tax Time” Costs You Money

Reconstructing a year of rental activity from memory doesn’t just eat a weekend — it quietly loses you deductions. The plumber you paid in cash and forgot. The mileage to the property you never logged. The portion of your phone bill and home office you were entitled to claim. Under-tracked landlords routinely leave hundreds or thousands of dollars in legitimate deductions on the table simply because the record wasn’t there when the return was due.

There’s a second, bigger risk. Residential rental property is depreciated over 27.5 years on a straight-line basis, which means a landlord with a $300,000 building (land isn’t depreciable) can deduct roughly $10,900 a year in depreciation — a real deduction that requires no cash outlay. New landlords miss it constantly because nothing in their bank statement reminds them it exists. A spreadsheet that calculates it automatically makes sure you never forget the single largest deduction most rentals have.

Set Up Your Categories to Match Schedule E

Here’s the decision that turns tax prep from hours into minutes: name your expense categories exactly the way the IRS does, from day one.

Schedule E, the form landlords use to report rental income and expenses, has a fixed list of expense lines. If your spreadsheet uses those same labels, filling out the form becomes a matter of copying one total into one box. Set up these categories:

• Advertising — listing fees, signs, photos
• Auto and travel — trips to the property, logged by mileage
• Cleaning and maintenance — turnover cleaning, lawn care, pest control
• Commissions — leasing agent fees
• Insurance — landlord/dwelling policy premiums
• Legal and professional fees — attorney, accountant, eviction filings
• Management fees — property manager’s cut
• Mortgage interest — the interest portion only, not principal
• Repairs — fixing what’s broken (fully deductible now)
• Supplies — tools, filters, small parts
• Property taxes — county/city real estate tax
• Utilities — any you pay: water, trash, gas, electric
• Depreciation — calculated, not spent
• Other — HOA dues, licenses, bank fees

On the income side, track rent, late fees, pet fees, parking, laundry, application fees, and other income separately. The IRS wants gross rents reported, and lumping a late fee into “rent” makes your numbers harder to defend if questioned.

Separate Repairs From Improvements As You Go

The costliest mistake new landlords make on their return is treating an improvement like a repair. A repair keeps the property running and is deductible this year — a $250 plumber visit, a $90 window pane. An improvement adds value or life and must be depreciated over years — a $9,000 roof, a $15,000 kitchen.

The time to make this call is the moment you enter the expense, while you remember what the work actually was. A spreadsheet column that forces you to tag each maintenance entry as “repair” or “improvement” (with a deductibility flag) means you never have to reconstruct the distinction a year later — and you have a defensible record if the IRS ever asks.

What a Tax-Ready Rental Spreadsheet Actually Does

A good rental tracker isn’t just a list of transactions. It should:

1. Log every dollar in and out, dated and categorized, per property.
2. Roll each property up into an annual total that mirrors Schedule E line by line.
3. Calculate depreciation automatically from the purchase price and placed-in-service date.
4. Flag repairs vs. improvements so nothing is misclassified.
5. Track maintenance with vendor, cost, and tax-deductibility so you can prove each write-off.

If your workbook does those five things, your accountant’s job — or your own hour with TurboTauto — shrinks to transcribing totals. That’s exactly what the Rental Property Income & Expense Tracker from ReadySheetGo is built to do: its Tax Deduction Summary tab maps directly to Schedule E, auto-calculates 27.5-year straight-line depreciation from your purchase price, and keeps a maintenance log with a deductibility column for every repair.

The Weekly Habit That Makes April Disappear

Pick a day. Sunday works for most landlords. Open the spreadsheet, enter any rent that came in and any expense that went out that week, tag the category, and close it. Ninety seconds. Over a year that’s under an hour of total effort — versus a lost weekend every April reconstructing the same information under deadline pressure, minus the deductions you can no longer prove.

The landlords who dread tax season are the ones treating it as an annual event. The ones who barely notice it treat it as a weekly one.

Featured on ReadySheetGo

Rental Property Income & Expense Tracker — Track up to 10 rental properties in one workbook with 300+ auto-calculating formulas. Includes a per-property income and expense tracker, a Tax Deduction Summary that maps to Schedule E with auto-calculated 27.5-year depreciation, a maintenance log with tax-deductibility flags, a tenant tracker, and a portfolio dashboard showing cash flow, ROI, and cap rate. Works in Excel and Google Sheets, no macros. One-time purchase — $19.99 (currently $11.99 with code LAUNCH40).