How to Track Rental Income and Expenses

If you're manually reconciling bank statements at tax time — scanning transactions, trying to remember whether that $340 charge in October was a plumbing repair or a personal purchase — you already know the system isn't working. For landlords managing two to five properties, this is the norm. Rent comes in through Venmo or Zelle, expenses hit a personal credit card, and the “rental spreadsheet” gets updated whenever there's a spare hour (which isn't often).

The cost isn't just stress. It's missed deductions, a weaker paper trail if you ever face an audit, and a thinner case when you go to refinance or buy your next property. Lenders want to see documented rental income. The IRS wants categorized expenses. Your CPA wants organized records — not a folder of forwarded emails. Good tracking habits pay for themselves.

This guide covers exactly how to track rental income and expenses as a small landlord: what to record, which categories matter for Schedule E, the real limits of the spreadsheet approach, and the mistakes that cost landlords money every year.

Why Tracking Rental Income and Expenses Actually Matters

There are three concrete reasons to keep accurate rental property records — beyond “the IRS requires it.”

Tax deductions. Every dollar of legitimate rental expense you document reduces your taxable income. A landlord managing three properties with $18,000 in annual deductible expenses who only documents $14,000 is overpaying taxes on $4,000 in income — roughly $960 extra at a 24% bracket, every year, until they fix the system. Deductions don't capture themselves.

Cash flow visibility. Do you actually know which of your properties is making money and which is breaking even? Most landlords have a rough sense but no clean answer. Property-level income and expense tracking gives you a per-unit P&L — a number that tells you whether a rent increase is warranted, whether a recurring repair is eating margin, and whether a property should be sold.

Proof for financing. When you refinance or apply for a new mortgage, lenders look at rental income documentation. Two years of organized Schedule E filings — backed by clean records — make that conversation much easier than handing over a folder and saying “most of it's in here.”

What to Track: Income and Expenses

Most landlords track rent payments. Fewer track everything else. Here's the full picture of what a rental income tracker should capture.

Income to record:

• Monthly rent — record it per property with the payment date. Note whether it was on time.
• Late fees — taxable income in the year collected. Most landlords forget to log them.
• Security deposits retained — if you keep all or part of a security deposit at move-out to cover damages, that amount is taxable income. Refunded deposits are not income.
• Pet fees, parking fees, storage fees — any recurring ancillary income attached to the tenancy.

Expenses to record (Schedule E categories):

• Repairs — restoring something to working condition. Fully deductible in the year paid. Replacing a broken water heater, patching a roof leak, repainting after tenant damage.
• Improvements — adding value or extending useful life (new kitchen, addition, deck installation). Must be capitalized and depreciated over time, not expensed immediately. This distinction carries significant Schedule E implications — more on it below.
• Insurance — landlord policy, dwelling fire insurance, umbrella coverage that includes rental activity.
• Mortgage interest — the interest portion only, not principal. Your lender sends a 1098 each year, but track it per property.
• Depreciation — a non-cash deduction of the building's cost over 27.5 years. One of the most valuable deductions in rental property accounting and one of the most underutilized.
• Property taxes — annual real estate taxes per rental unit.
• Management fees — property management company fees, software subscription costs, payment processing fees on rent collection.
• Mileage — every drive to show a unit, meet a contractor, pick up repair supplies, or collect rent. The IRS standard mileage rate for 2025 is 70 cents per mile. A landlord who makes 50 property-related trips per year averaging 10 miles round-trip has a $350 deduction — but only if they logged it.
• Professional services — accounting fees, legal fees related to the rental, eviction attorney costs.
• Utilities you pay — water, trash, common-area gas or electricity not passed to the tenant.

For a deeper dive on the expense side specifically, see our guide to landlord expense tracking.

The Rental Income Spreadsheet: Where It Works and Where It Breaks

A spreadsheet is the default rental income tracker for most small landlords, and for a single property with light transaction volume, it's a reasonable starting point. A well-built rental income spreadsheet has:

• A separate tab per property
• Columns for date, Schedule E category, description, amount, and payment method
• Monthly income and expense subtotals
• An annual rollup tab that pulls from each property tab
• A receipt reference column — even just a file name or email subject

The problems start when the spreadsheet meets reality:

Receipts don't live in the spreadsheet. A row that says “$385 — plumbing repair — Nov 3” is a note, not documentation. The actual invoice is in your email, your phone's photo roll, or a paper folder you haven't touched since February. Connecting receipts to the right rows at tax time is a multi-hour project every year — assuming you can still find them.

Shared access creates versions. If you and a partner both update the file, or if you switch between devices, you end up with conflicting copies. One accidental overwrite corrupts your annual totals without any warning. One wrong cell reference throws off your property totals and you won't catch it without auditing every row.

Scale breaks it. Two properties with 150 transactions each is 300 rows. At five properties, it's 750 rows and a significant reconciliation burden. The spreadsheet doesn't flag errors — it just reflects whatever you typed.

Common Mistakes That Cost Landlords Money

These aren't edge cases. They're patterns that show up in nearly every landlord's records once you look closely.

Mixing personal and rental accounts. Running rental income and expenses through a personal checking account isn't illegal, but it creates a recordkeeping mess. You have to sort every personal transaction to find the rental-related ones. And when the IRS audits a Schedule E, commingled funds are a red flag. Open a dedicated checking account and credit card for rental activity. It takes 20 minutes and saves hours every year.

Not logging mileage. Mileage is one of the most commonly missed deductions in rental property cash flow tracking. It doesn't come with a receipt, so it doesn't get logged. A landlord who drives 1,500 miles per year for rental activity is leaving a $1,050 deduction unclaimed. Log it at the time: date, starting point, destination, purpose, miles. Thirty seconds per trip, worth real money at year-end.

Miscategorizing repairs vs. improvements. This is the most dangerous mistake from a Schedule E standpoint. Replacing a broken water heater is a repair — deduct it this year. Installing a new deck is an improvement — capitalize and depreciate it over time. Deducting a capital improvement as a current-year repair is the kind of error that creates IRS problems. If a project costs more than a few hundred dollars and significantly extends the life or value of the property, treat it as an improvement and confirm the classification with your CPA before filing.

Forgetting retained security deposits. If you keep a tenant's security deposit — fully or partially — at move-out, that money is taxable income in the year you retain it. Most landlords don't instinctively log this as income, which creates an underreporting problem that can surface at audit.

Inconsistent expense categories. Your CPA files one Schedule E per rental property. If your records use “misc,” “contractor,” and “home stuff” as categories, they have to reclassify everything — time you're paying for. Use standard Schedule E categories from the start: repairs, insurance, taxes, mortgage interest, management fees, utilities, professional services, depreciation.

For a fuller system to avoid these issues, see our guide on how to track rental property expenses.

How LeasePlex Handles Rental Income and Expense Tracking

LeasePlex was built for landlords managing 2–10 properties who want something more reliable than a spreadsheet without the complexity of full-scale accounting software. Here's how the income and expense tracking specifically works:

Pre-built Schedule E expense categories. Every expense you log gets tagged to one of the standard Schedule E categories — repairs, insurance, property taxes, mortgage interest, management fees, mileage, professional services, utilities. No free-form “misc” bucket to hide in. When it's time to hand off to your CPA, the categories are already right.

Receipt uploads at the point of payment. When you pay a contractor, snap a photo of the invoice from your phone and attach it to the expense entry in the same workflow. The receipt is stored in the platform, linked to that specific expense, accessible any time. Not in an email thread. Not in a folder on your desktop. In the system, attached to the transaction. When your accountant asks for documentation on a specific repair three months later, you pull it up in 30 seconds.

Automatic rent payment logging. When tenants pay through LeasePlex, rent income is automatically recorded per property — including the payment date, amount, and on-time status. Late fees are recorded as income when assessed. You're not manually reconciling Venmo transactions against a rental income spreadsheet because the payments are already in the system.

For more on moving rent collection online, see how to collect rent online.

Per-property ledger. Every transaction — income or expense — is tagged to a specific property. You can pull a per-property P&L for any month or the full year at any time. If one property is generating less cash flow than expected, you see it immediately — not at tax time when it's too late to act.

One-click export for your CPA. At year-end, export a per-property income and expense summary that maps directly to Schedule E. Your accountant receives organized, categorized data — not a folder of forwarded emails and a spreadsheet they have to reformat. The handoff takes minutes instead of hours, and your CPA's time goes toward strategy — depreciation schedules, cost segregation, entity structure — rather than reconstruction.

The Right Time to Stop Using a Spreadsheet

If your current system is working — you can find every receipt, you know exactly what you're claiming, and your CPA has never had to ask “where did this come from?” — stick with it. A working system is a working system.

But if you've said “I think I have most of it” at any point in the last two tax seasons, that's the signal. Every year of incomplete records is a year of overpaid taxes, higher CPA fees, and a weaker financial picture if you want to buy another property.

LeasePlex runs at $29/month for landlords managing up to 10 properties. One missed mileage deduction worth $350, one receipted repair you couldn't find worth $500 — and the software has already paid for itself for the year. The math isn't complicated.