Accounting

Rental property accounting: a complete guide for small landlords

The five-habit bookkeeping system for a 1-10 unit portfolio, carried through one example duplex and single-family from first transaction to filed Schedule E.

8 min read

Rental property accounting breaks the same way for almost every small landlord. Rent lands in the same checking account as a paycheck, the hardware store receipt rides home in a coat pocket, and the mortgage payment gets booked, when it gets booked at all, as one expense instead of three. Nothing hurts for months. Then a tenant questions a late fee from August, or your CPA asks what the $2,840 of “miscellaneous” was, and a year of bank statements becomes your weekend.

The fix is not an accounting degree, and it is not property-manager software with trust accounting you will never touch. A portfolio of 1-10 units needs five habits: one dedicated account, categories shaped like the tax form they land on, a rent roll, mortgage payments split into their parts, and a short monthly close. To keep it concrete, this guide follows one hypothetical portfolio the whole way through: say you own a duplex bought for $340,000 with two units renting at $1,450 a month each, plus a single-family bought for $250,000 renting at $1,800. Three units, $4,700 a month of scheduled rent, and every number below comes from them.

One account and one category list

Open a checking account that exists only for the rentals and run everything through it: every rent deposit in, every repair, premium, and mortgage payment out. Commingling rental and personal money is not, by itself, illegal for a sole owner, but it slows every later step and it is the first fact a lawyer reaches for when arguing an LLC's liability shield should not hold. The full reasoning is in the separate bank account guide. Security deposits carry their own holding rules in some states, covered in the deposit account rules guide; when in doubt, keep deposit money apart from operating cash and read your state's statute.

Then fix your category list before the first transaction, and make it match Schedule E rather than your bank's idea of budgeting. The form has specific lines: insurance on line 9, repairs on line 14, taxes on line 16, utilities on line 17. Categories that mirror those lines all year make year-end a sort, not a translation; a free list mapped line by line is in the rental chart of accounts. A category list invented in April gets invented again next April.

Pick the ledger before the first transaction

At one to three units a spreadsheet genuinely works: one tab per property, one row per transaction, columns for date, payee, category, amount. A free one with Schedule E categories built in is at the rental property spreadsheet template. QuickBooks also works, though it was built for invoices and inventory, so expect setup time bending its chart of accounts into Schedule E shape and its reports into per-property columns. The breaking point is volume, and it arrives as dropped transactions rather than as a bill; spreadsheet vs landlord software works out where that line sits.

Income: rent, late fees, and the deposit that is not income

Track income as a rent roll, not as a bank balance: for each month and each unit, what was charged, what arrived, and when. Take March on the example portfolio. $4,700 is charged across three units; the single-family pays $1,800 on the 1st, duplex unit A pays $1,450 on the 3rd, and unit B pays $1,000 on the 10th, leaving $450 open. The bank statement shows $4,250 of deposits and nothing else. Only a rent roll shows who owes the $450, and that unit B has now paid short two months running. The free rent roll template and the printable rent ledger both do this on one page.

Two edges trip people. Late fees are rental income in the month received, so give them their own category instead of netting them into rent. And a security deposit is not income on the day it arrives: the $1,800 deposit on the single-family is money you are holding, a liability, and it becomes income only in the year you keep part of it for damage or unpaid rent. When a kept deposit hits Schedule E covers the timing.

Expenses: the classification that moves real money

Most expense entries take five seconds. The one worth thought is repair versus improvement, because it decides whether a cost is deducted this year or recovered over decades. The $310 spent fixing the duplex's leaking toilet and patching the drywall under it is a repair, deductible now on line 14. The $7,800 membrane roof on the same duplex is an improvement: it joins the depreciation schedule instead of the expense column. Repairs vs improvements classifies twenty common expenses along that line, and CapEx vs OpEx shows what the split does to your NOI.

Three deductions live outside the checkbook. The de minimis safe harbor lets you elect to expense items up to $2,500 per invoice that would otherwise be depreciated, which is how a $1,150 dishwasher for the single-family stays a current-year deduction; IRS Publication 527 covers the election. Driving to the properties is deductible at the 2026 IRS rate of 72.5 cents per mile, so 640 logged miles of rental trips is a $464 deduction that exists only if the log does; the mileage guide lists what counts. And if a corner of your home is used exclusively and regularly for managing the rentals, the home office guide walks through the test that decides whether you can claim it.

The monthly close

Books stay accurate through rhythm, not effort. Once a month, on a fixed day, do four things: mark every rent charge paid, partial, or open; categorize every expense while you still remember what the $87 at the hardware store was; split the mortgage payments; and file the receipts where February-you can find them. On the example portfolio that is a 10-to-15 minute job, and the timed checklist is in the 10-minute monthly close. I self-manage my own small portfolio from two time zones away and close my books on the 5th of each month, after grace periods have run out, because a close with a fixed date is a close that happens.

The mortgage split is the step most spreadsheets skip and the one that corrupts everything downstream. The duplex's $2,121 payment this month is really three transactions: $1,434 of interest, which is deductible; $220 of principal paydown, which is a transfer to your own equity and not an expense; and $467 into escrow, which becomes a deduction only when the escrow account pays the tax bill or the premium. Book the whole $2,121 as “mortgage expense” and you overstate expenses, understate NOI, and double-count property taxes the day escrow disburses. Tracking mortgage interest correctly shows the clean method.

Reading the books: NOI, cash flow, and your return

NOI = rent collected − operating expenses

Tidy books earn their keep when you ask whether the portfolio performs. Say the example portfolio finishes the year with $54,600 collected ($56,400 scheduled, less one vacant month on the single-family) and $14,800 of operating expenses: property taxes $6,100, insurance $2,700, repairs and maintenance $3,400, utilities $1,650, lawn and snow $950. Net operating income is $39,800, which against the $590,000 of combined purchase price is a 6.7% cap rate; run your own numbers through the cap rate calculator.

NOI deliberately ignores the mortgage, so it is not the money you keep. Subtract the year's debt service to get cash flow, then measure that against the cash you put into the deals to get cash-on-cash return. NOI vs cash flow runs one duplex through three competing answers to “is it making money,” and the cash-on-cash guide works the return math with a calculator beside it. Books that cannot produce these numbers in five minutes are storage, not accounting.

Year end: from your ledger to Schedule E

Each property gets its own column on Schedule E (Form 1040): rents received on line 3, expenses on lines 5 through 19, depreciation on line 18. If your categories matched the form all year this is a sort and a sum, and the line-by-line Schedule E walkthrough handles the edge cases. Depreciation is the one figure the ledger does not produce on its own: the duplex's building basis is $272,000 ($340,000 less $68,000 of land value from the assessor's ratio), recovered straight-line over 27.5 years, about $9,891 in a full year. The depreciation guide works the math, including the first-year mid-month convention, and the depreciation calculator runs your numbers. What your CPA wants in February is one packet: per-property totals in Schedule E categories, the 1098s, closing statements, the improvements list, the mileage log. The year-end tax prep checklist is that packet as a printable list.

This system runs fine on paper and a spreadsheet. I built rents.ai because my own spreadsheets kept dropping pieces of it, a rent charge unmarked here, a mortgage payment unsplit there, and it keeps the rent roll, the Schedule E-categorized ledger, and the mortgage splits from this guide as one set of books; its read-only demo portfolio, a single-family, a duplex, and a fourplex with a year of payment history, looks a lot like the example you have been reading. The limit is real: there is no bank feed, so you record payments and expenses yourself or import a CSV, and its tax view produces estimates that organize your year for your CPA, not a filing.

Whatever tool you choose, the five habits do the work: one account, Schedule E categories, a rent roll, split mortgage payments, a close on a fixed day. Books kept monthly cost an hour a year. Books kept in April cost a weekend, every April.

The duplex and single-family above are hypothetical and the figures are rounded illustrations. Everything here, including the depreciation and safe harbor examples, is meant to organize your year for your CPA, not tax advice, and deposit and late fee rules vary by state, so read your state's statute before relying on a number.

Questions landlords actually ask

Do I need a separate bank account for my rental property?
No federal law requires one for rent income, but it is the highest-value move in this guide: clean books, a shorter audit, and the integrity of an LLC liability shield all start there. Security deposits are a different question, since some states require them to be held in a separate or escrow account, so check your state statute on deposits specifically.
Can I use Excel or QuickBooks for rental property bookkeeping?
Yes. A spreadsheet handles one to three units well if every transaction gets a row and a Schedule E category, and QuickBooks works once you rebuild its chart of accounts around Schedule E lines and tag every transaction by property. The common failure is not the tool but the habit: books that are not closed monthly fall behind no matter what software holds them.
What records do I need to keep for my rental property and for how long?
Keep leases, rent records, receipts, bank statements, and mileage logs for at least three years after you file the return they support, which covers the normal IRS audit window. Keep anything that proves basis, including purchase closing statements and improvement invoices, for as long as you own the property plus at least three years after the sale is reported.
What does my accountant need from me at the end of the year?
A per-property income and expense summary in Schedule E categories, mortgage interest statements (Form 1098), closing statements for any purchase or sale, a list of improvements with dates and costs, and your mileage log. If your categories matched Schedule E all year, assembling that packet takes an evening, not a weekend.
Is mixing personal and rental money actually illegal?
For a sole owner it is generally not illegal, but it is expensive in quieter ways: deductions get missed, audits take longer, and if the property sits in an LLC, commingled funds are a classic argument for piercing the liability shield. Security deposits are the exception, since a number of states regulate how those are held, so treat deposit money separately from operating cash.