Real Estate Bookkeeping for Investors and Landlords

Quick Answer: Real estate bookkeeping means tracking income and expenses per property, not just per owner. Keep rental money in accounts separate from personal money, tag each bank and card transaction with the property it belongs to, hold security deposits as a liability rather than income, and split mortgage payments into principal, interest and escrow. At year end, each property needs its own totals, plus records of purchase costs and improvements.

Landlords and real estate investors keep books for the same reasons as any business, with one twist: each property is its own small business. You need to know what each one earns and costs, because that's how you decide whether to keep it, and because many records, such as improvements and depreciation, follow the property for as long as you own it.

How should you set up accounts for rental properties?

Start with the bank side, since nearly every transaction will come from a statement.

Whichever you choose, never pay rental expenses from a personal account if you can avoid it. Every mixed transaction is one more to explain later.

How do you tag rent and expenses by property?

Add a Property column to your ledger with a short code for each property, such as ELM12 for 12 Elm Street, and a GEN code for costs that cover the whole portfolio (accounting software, an LLC filing fee). Then each row carries:

• Date and description from the statement.
• Amount, signed.
• Property code.
• Category: rent, late fees, repairs, cleaning and maintenance, utilities, insurance, property tax, mortgage interest, management fees, advertising, legal and professional, travel to the property, supplies.
• Unit or tenant, for multi-unit buildings.

Statement descriptions rarely say which property a payment was for, so the tag is your judgment. Make it easy: ask tenants to include the unit in the payment memo, keep a list of which contractor works on which property, and set up utility accounts so the property address appears on the bill.

Getting statements into rows is the time-consuming part. Bank CSV exports work for recent months; when you only have PDF statements, QuickBankConvert converts them into spreadsheet rows with date, description and signed amount, ready for a Property column. Our guide to rental property expenses from bank statements covers categorizing those rows.

How do you handle security deposits, advance rent and tenant-paid costs?

These three trip up do-it-yourself books most often. IRS Publication 527 addresses each:

• Security deposits. Don't include a deposit in income when you receive it if you plan to return it at the end of the lease. If you keep part or all of it because the tenant didn't meet the lease terms, include the amount you keep in income for that year. In the books, record deposits in a liability account such as "Tenant deposits held", one line per tenant.
• Advance rent. Rent received before the period it covers is included in rental income in the year you receive it, regardless of the period covered or your accounting method. A tenant who pays January rent in December creates December income.
• Expenses paid by the tenant. If a tenant pays one of your expenses, such as a plumber's bill, and deducts it from rent, that payment is rental income, and you can deduct the expense if it is a deductible rental expense. Record both sides, so the books show full rent and the repair.

Repairs or improvements?

Publication 527 tells landlords to separate the costs of repairs and improvements and keep accurate records. A repair keeps the property in its current condition: fixing a leak, repainting, replacing a broken window. An improvement adds value, extends the property's life or adapts it to a new use: a new roof, a kitchen remodel, an addition. The tax treatment differs, and improvements are recovered over years through depreciation.

In the books, give improvements their own category per property, with the date placed in service and the total cost, and keep the invoices and proof of payment. These records stay relevant until you sell the property, long after the usual three-year period for most tax records.

How do you book the mortgage payment?

A single mortgage payment on your bank statement usually covers principal, interest and escrow for taxes and insurance. Split it using the servicer's monthly statement:

1. Interest goes to a mortgage interest category for that property.
2. Principal reduces the loan balance (a liability), so it is not an expense.
3. Escrow can be recorded as a transfer into an escrow asset, and then as property tax and insurance expense when the servicer pays them, using the annual escrow statement.

At year end, the servicer's Form 1098 reports mortgage interest received, outstanding principal and, in box 10, can show other items such as real estate taxes; the IRS Form 1098 instructions describe each box. Compare it with your books. Our guide to the mortgage interest statement covers matching the two.

What about property manager statements?

When a manager collects rent, your bank sees only the net payout. Book the manager's monthly owner statement instead: gross rent as income, management and leasing fees, repairs, and any reserve the manager holds. The net should equal the deposit on your statement. If it doesn't, ask the manager before the next month's statement arrives.

How often should a landlord update the books?

Monthly, timed to when the statements and the manager's owner statement arrive. Rent cycles are monthly, so a monthly close lets you spot a missing payment while it is still a conversation with the tenant rather than a collections problem.

A workable monthly routine for a small portfolio:

1. Import the month's bank and card rows and tag each with a property.
2. Check that each unit's rent arrived in full, and record late fees separately.
3. Book the manager's statement, if you use one, and tie it to the deposit.
4. Split each mortgage payment using the servicer's statement.
5. Reconcile each account to its statement balance.
6. File receipts and invoices in a folder per property.

What should you have at year end?

For each property:

• Total rent and other income, and total expenses by category.
• The deposit liability, by tenant.
• Form 1098 and the escrow statement from each servicer.
• A list of improvements made during the year, with invoices.
• The closing statement for any property bought or sold; the IRS's list of records to keep names real estate closing statements among the supporting documents for assets.
• Mileage or travel records for trips to the property.

Rental income and expenses are usually reported per property, so per-property totals are what your preparer will ask for. For collecting the year's statements in one place, see organize bank statements for tax season.

Related guides

• Rental property expenses from bank statements
• Bookkeeping for small business
• Real estate agent expense tracking

This page covers recordkeeping; ask a tax professional how these records apply to your return.