Rental Property Accounting: How to Track Income and Expenses

If you're managing 2–10 rental properties and keeping your books in a spreadsheet — or worse, reconstructing everything in March from bank statements and Venmo screenshots — you already know the problem. Rental property accounting doesn't have to be complicated, but it has to be consistent. One missed receipt or mis-categorized expense and you're either overpaying taxes or inviting scrutiny from the IRS.

This guide covers the practical mechanics: what accounts you need, what income and expenses to track, which accounting method to use, why spreadsheets eventually fail, and what you actually need to hand your accountant in April.

This article is for informational purposes only and is not tax or legal advice. Consult a tax professional for guidance specific to your situation.

Why Rental Property Accounting Actually Matters

Three reasons small landlords need clean books — and none of them are “because it's fun.”

IRS scrutiny. Rental income is one of the areas the IRS focuses on when it comes to underreporting. If your Schedule E shows large, recurring losses — or inconsistent income year over year — it stands out. Documented, organized records are your first line of defense if questions come up.

Deduction maximization. The average small landlord misses hundreds to thousands of dollars in legitimate deductions each year simply because they can't substantiate them. A $200 supply run, $400 in mileage, a $600 plumber visit — these add up. They only reduce your tax bill if you recorded them. See our full landlord tax deductions guide for the complete list.

Deposit disputes. When a tenant disputes a security deposit deduction, your repair invoices and payment records are the evidence. No records means no case. Good rental property bookkeeping protects you in court, not just at tax time. For more on this, see our guide on how to handle security deposit disputes.

The 3 Bank Accounts Every Landlord Needs

Before you track a single dollar, get your accounts set up correctly. Mixing personal and rental finances is the single most common mistake small landlords make — and the one that creates the most problems at tax time.

1. Operating Checking Account

This is your rental business account. Rent comes in here. Repairs, supplies, insurance, and management costs go out from here. Nothing personal touches this account. When your CPA or the IRS asks to see your rental finances, this account tells the whole story cleanly.

2. Security Deposit Holding Account

Most states require security deposits to be held in a separate, interest-bearing account — and in some states, commingling deposit funds with your operating account is illegal. Even where it isn't required, keeping deposits separate protects you. You always know exactly what's owed back to each tenant, and you're never accidentally spending money that isn't yours.

3. Repair Reserve / Savings Account

Set aside a percentage of monthly rent — many landlords use 5–10% — into a dedicated savings account for capital repairs. When the HVAC dies or the roof needs work, you're not scrambling. This account also keeps large repair expenses from muddying your operating account when they hit.

What Rental Income to Track

All of it. The IRS expects you to report every dollar of rental income, regardless of how it was paid — check, ACH, Venmo, cash. Here's what that includes:

• Monthly rent payments — the obvious one. Track the amount, date received, and which tenant/unit it came from.
• Late fees — if your lease charges a late fee and the tenant pays it, it's income.
• Pet fees and pet deposits — non-refundable pet fees are income; refundable pet deposits are liabilities (you owe them back). Track them differently.
• Move-in fees — any non-refundable fee charged at move-in beyond security deposit.
• Laundry income — if you have coin-operated or app-based laundry machines, that revenue counts.
• Parking fees — separate parking charges beyond what's included in rent.
• Utility reimbursements — if tenants pay you back for utilities, that's income (the utility bills themselves are a deductible expense).

Record the source and date for each payment. If a tenant is consistently late and you're charging late fees, you want a clear record — both for tax purposes and in case of a dispute.

What Rental Expenses to Track

For a complete list of what's deductible — including the repairs vs. improvements distinction that trips up most landlords — see our landlord tax deductions guide. In short, the categories that matter for rental property bookkeeping are:

• Mortgage interest (from your Form 1098)
• Property taxes
• Insurance premiums
• Repairs and maintenance (not improvements — see the guide)
• Utilities you pay on behalf of tenants
• Professional services (CPA, attorney, property manager)
• Advertising and listing fees
• Mileage and travel to the property
• Supplies
• Software subscriptions used to manage the rental

For every expense, you need: the date, the amount, what it was for, which property it applies to, and a receipt or invoice. The IRS doesn't require you to submit receipts when you file — but if you're ever questioned, you need to be able to produce them.

Cash vs. Accrual Accounting: Which Should You Use?

This is simpler than it sounds. For small landlords, the answer is almost always cash basis accounting.

Cash basis means you record income when you receive it and expenses when you pay them. January's rent hits your account on the 3rd? It's January income. You pay a plumber in February? It's a February expense. Simple, and it matches your actual bank activity.

Accrual basis means recording income when it's earned (even if unpaid) and expenses when they're incurred (even if not yet paid). This is standard for larger businesses, but for small landlords it creates unnecessary complexity — tracking receivables, matching periods, adjusting entries — without any real benefit.

The IRS allows small landlords (below a certain gross receipts threshold) to use cash basis, and it's the default for landlords filing on Schedule E. Unless your accountant tells you otherwise, use cash basis. It's what your bank statements reflect, it's easy to audit, and it doesn't require accounting software to maintain correctly.

The Spreadsheet Trap: Why Excel Breaks Down at 3+ Properties

A spreadsheet works fine for one property and one tenant. Once you have three units, multiple tenants, overlapping lease periods, and receipts from five different payment methods, it starts falling apart.

Here's where spreadsheets specifically fail:

• No receipt attachment. You write down “$340 — plumber” in a cell, but the invoice is a photo on your phone. Come audit time, those two things live in completely different places — and it's easy for one to disappear.
• Manual data entry means errors. Mistyped amounts, wrong categories, rows accidentally deleted. With a spreadsheet, there's no audit trail — you can't see when something changed or who changed it.
• No per-property separation built in. If you track all three properties in one sheet, generating a Schedule E summary for each property requires manual filtering every year.
• Tax season is a manual job. Your accountant needs totals by Schedule E category, per property. With a spreadsheet, you're the one doing that summarization — usually at 11 PM on April 10th.
• Venmo and cash are easy to miss. Payments that don't flow through a bank account require manual entry, and they're the first thing that gets skipped when you're busy.

Most landlords realize the spreadsheet is failing them at their second or third property — usually after they miss a deduction on the previous year's return.

How LeasePlex Handles Rental Property Accounting Automatically

LeasePlex was built specifically for the landlord who doesn't want to learn accounting software — they just want to know their numbers are organized and ready when April comes.

• Expense tracker with auto-categorization. Enter an expense and LeasePlex maps it to the correct Schedule E category automatically. Your books stay organized without you having to remember which line item is which.
• Receipt upload from your phone. Photograph an invoice from the job site and attach it to the expense record immediately. No more shoebox of paper receipts or digging through your camera roll in March.
• Per-property tracking. Income and expenses are tied to specific units, so generating a per-property summary for Schedule E takes seconds, not hours.
• Export-ready reports. Hand your accountant a clean summary instead of a pile of bank statements to sort through. Most LeasePlex landlords spend less than an hour preparing their tax materials at year end.
• Rent collection built in. When rent comes in through LeasePlex, it's recorded automatically — no manual entry, no missed payments, no Venmo screenshots to track down.

If you're currently doing this manually, you're spending time every month that you're not getting back. The right time to switch is before tax season, not during it.

Getting Ready for Tax Season: What Your CPA Needs

Rental income and expenses are reported on Schedule E (Supplemental Income and Loss), attached to your Form 1040. You fill out one section per property.

What to have ready:

• Total rent received per property — for the full calendar year, by unit
• Expense totals by category — mortgage interest, taxes, insurance, repairs, supplies, management fees, advertising, professional fees, utilities, mileage
• Form 1098 from your lender (mortgage interest paid)
• Property tax statements for each rental
• Depreciation schedule — if you haven't set this up yet, your CPA can do it; if you have, bring the prior year's return so they can continue it
• Receipts for major expenses — anything over a few hundred dollars, plus your records for repairs vs. improvements distinctions
• Mileage log — total miles driven to each rental property for business purposes

If you use LeasePlex, most of this is one export. If you're working from a spreadsheet, plan to spend a few hours pulling everything together before your CPA appointment.

FAQ

This is not tax advice — consult a CPA or tax professional for your specific situation.

Do I need QuickBooks for rental property accounting?

No. QuickBooks is built for businesses with accounts payable, invoicing, payroll, and inventory — none of which apply to a small landlord. It's powerful but far more than you need, and the learning curve is real. Most small landlords are better served by a purpose-built tool like LeasePlex, or at minimum a well-structured spreadsheet, than by fighting with software designed for retail shops and contractors.

Can I mix personal and rental finances in the same account?

Technically yes, but it's a bad idea. When personal and rental transactions share an account, every expense requires manual separation — and you will miss some. More importantly, it makes your records harder to defend if questioned. Keeping a dedicated operating account for your rentals costs nothing extra at most banks and saves hours of work each year.

How long do I need to keep rental property records?

The IRS generally requires you to keep records for at least 3 years from the date you filed the return they relate to. However, depreciation records are an exception — because depreciation spans the life of the asset (27.5 years for residential rental property), you should keep those records for as long as you own the property and for several years after you sell it. Digital records in cloud storage or a property management app are fully acceptable.

What if a tenant pays me in cash?

Record it the same day you receive it. Write a rent receipt for your tenant (and keep a copy), log the payment in your rent ledger with the date and amount, and deposit it into your operating account as soon as possible. Cash income is fully taxable — the IRS doesn't care how it was paid. Having a clean paper trail for every cash payment also protects you if a tenant later claims they didn't pay or that you accepted less than the full amount.

This post is for informational purposes only and is not tax or legal advice. Tax laws change and your situation may differ. Consult a licensed CPA or tax professional before making financial or tax decisions.