One rental property can be run from a spreadsheet. By the third, most owners have lost track of which roof repair belonged to which house, and tax season becomes an archaeology project. This guide sets out how to keep rental books so that each property stands on its own and the tax return falls out of them.
Why track each rental property separately?
Because the IRS requires it and because you need it. Schedule E reports income and expenses property by property, and you cannot tell which properties earn their keep from a single blended total. In QuickBooks Online use classes or locations, one per property; in Xero use tracking categories. Every rent payment, repair, insurance premium and tax bill gets a property attached when it is entered, not in April.
How to track rental property expenses
Use the categories Schedule E uses, and every line of the return comes straight from your books: advertising, auto and travel, cleaning and maintenance, commissions, insurance, legal and other professional fees, management fees, mortgage interest, other interest, repairs, supplies, taxes, utilities, depreciation, and other. Then keep three habits:
- Record each expense when it is paid, with the property attached.
- Keep the receipt or invoice. A photo in your accounting software is fine.
- Write one line on what each job was. “Replaced water heater, unit 2” settles the repair-or-improvement question months later.
Trips to the properties count too, so keep a mileage log with the date, the property and the reason.
How do you record a mortgage payment?
A mortgage payment is not one expense. It is interest, which is deductible; principal, which reduces the loan balance and is not an expense at all; and usually escrow for property tax and insurance, which becomes an expense when the lender pays it out. Booking the whole payment as an expense overstates your costs and leaves the loan balance on your books wrong. Use the lender’s annual statement or amortization schedule to split it.
Are security deposits income?
No. A refundable security deposit is money you are holding for the tenant, so it is a liability. It becomes income only if and when you keep some of it, for unpaid rent or damage. Many states also require deposits to be held in a separate bank account. Last month’s rent paid in advance is different: that is taxable when you receive it.
Repair vs improvement
A repair keeps the property in ordinary working condition and is deducted in the year it is paid: fixing a leak, repainting, replacing a broken window. An improvement makes the property better, restores it, or adapts it to a new use, and has to be capitalized and depreciated: a new roof, an addition, a full kitchen remodel. There are safe harbors, including a de minimis election that lets many owners expense items costing $2,500 or less per invoice or item. The distinction is the most common area of error on rental returns, so note what each job actually was when you record it.
| Question | Repair | Improvement |
|---|---|---|
| In the books | Deducted in the year it is paid | Capitalized and depreciated |
| For example | Fixing a leak, repainting, replacing a broken window | A new roof, an addition, a full kitchen remodel |
How does depreciation work on a rental property?
Residential rental buildings are depreciated over 27.5 years, and commercial buildings over 39. Land is never depreciated, so the purchase price has to be split between land and building, usually using the property tax assessment ratio. Appliances, carpets and furniture used in the rental have a shorter, five-year recovery period. Depreciation is a deduction you do not pay cash for, and skipping it does not help: when you sell, the IRS taxes the depreciation you were allowed to take whether you took it or not.
What records should a landlord keep?
- Closing statements for every purchase, sale and refinance
- Leases and a rent roll showing what was due and what was paid
- Receipts and invoices for every expense, tagged by property
- Mortgage statements and the year-end Form 1098
- Property tax and insurance bills
- Mileage logs for trips to the properties
- W-9s for contractors, and 1099-NECs if your rentals are run as a business and you paid a contractor $2,000 or more in 2026 (the threshold was $600 through 2025; see the 1099 threshold for 2026)
Keep most records for at least three years after you file. Keep the records for the property itself (purchase, improvements and depreciation) until three years after the year you sell it, because they set your gain on the sale.
Should rental income go through a separate bank account?
Yes. At minimum, keep one account that is used only for the rentals, and if the properties sit in LLCs, give each LLC its own account. Mixing personal and rental spending is the fastest way to lose deductions, and in an LLC it can weaken the liability protection you set the company up for. Our guide to bookkeeping for LLCs covers the rest of that setup.
What about passive loss limits?
Rental losses are generally passive and can only offset passive income. Owners who actively participate can usually deduct up to $25,000 of rental losses against other income, phasing out between $100,000 and $150,000 of modified adjusted gross income. Real estate professionals are treated differently. Accurate per-property books are what let your tax preparer apply these rules correctly and carry unused losses forward.
A rental property chart of accounts (Example)
A chart of accounts for rental property should do two jobs: match Schedule E line for line, and keep the balance sheet honest about loans, deposits and depreciation. The accounts stay the same for every property; a class or tracking category per property does the splitting.
- Assets
- Rental operating account; Security deposit account (where your state requires one); Escrow held by lender; Land; Buildings; Improvements; Accumulated depreciation
- Liabilities
- Mortgage, one account per loan; Security deposits held
- Equity
- Owner contributions; Owner draws
- Income
- Rents received; Late fees; Other rental income (pet fees, laundry, deposits kept)
- Expenses
- Advertising; Auto and travel; Cleaning and maintenance; Commissions; Insurance; Legal and other professional fees; Management fees; Mortgage interest; Other interest; Repairs; Supplies; Taxes; Utilities; Depreciation; Other
- The test
- One property tag on every transaction. If a line cannot be tagged to one property, split it across them before you save it.
Example only: a starting point for a made-up business, not a recommendation for yours.
A simple per-property template
A rental property bookkeeping template does not need to be clever. One column per property, income at the top, the Schedule E categories below, a total, and twelve of them add up to the year’s return. Here is one month for two properties.
| Line | Maple St | Oak Ave | Total |
|---|---|---|---|
| Rents received | $1,650 | $2,100 | $3,750 |
| Late fees | $50 | $0 | $50 |
| Total income | $1,700 | $2,100 | $3,800 |
| Mortgage interest | ($610) | ($840) | ($1,450) |
| Repairs | ($180) | $0 | ($180) |
| Management fees | $0 | ($168) | ($168) |
| Utilities | ($45) | $0 | ($45) |
| Total expenses | ($835) | ($1,008) | ($1,843) |
| Net before depreciation | $865 | $1,092 | $1,957 |
Example only: a made-up business. The figures add up but belong to no real client.
Frequently asked questions
What is the best accounting method for rental property?
Most individual landlords use the cash method: rent counts when it is received and expenses when they are paid. It matches how most owners report on Schedule E and is simple to keep. Whichever method you use, apply it every year and keep each property separate.
Is a security deposit income?
Not while it is refundable. It is money you hold for the tenant, so it is a liability. It becomes income only when and if you keep some of it, for damage or unpaid rent. A deposit that will be used as the final month’s rent is advance rent, so it is income when you receive it (IRS Publication 527).
Is last month’s rent income when I receive it?
Yes. Advance rent is income in the year you receive it, whatever period it covers. That is different from a refundable security deposit, which stays a liability unless you end up keeping some of it.
Can I use a spreadsheet for my rental books?
For one or two properties with few transactions, yes, as long as it uses the Schedule E categories and you check it against the bank every month. Past that, accounting software with one class or tracking category per property saves time and catches mistakes a spreadsheet will not.
How long should a landlord keep rental records?
Generally at least three years after you file the return. Records for the property itself, such as the closing statement, improvements and depreciation, should be kept until three years after the year you sell it, since they decide your gain.
Remote Bookkeepers keeps books for landlords and rental property investors across the US: per-property reporting, mortgage splits, deposits and Schedule E-ready records. Not sure your rental books would survive a close look? Add us as your accountant for a free books review, and you get a written list of what we find in about 48 hours.