Real Estate Accounting

1. Per-property tracking. Schedule E reports each property in its own column, so your books need to answer "what did the duplex on Maple make?" without a spreadsheet archaeology project. Every transaction gets tagged to a property the day it is entered. Portfolio-level totals are easy to roll up; property-level detail is impossible to reconstruct in April.

2. Capital vs expense. A repair is deducted this year. An improvement is capitalized and depreciated over years. The dollar difference in any single year is large, and the classification decision happens at bookkeeping time, not at tax time. A bookkeeper who dumps every Home Depot run into "Repairs" is making tax decisions without knowing it.

3. Basis records. Your basis, what you paid plus capitalized closing costs plus improvements, minus depreciation taken, determines your depreciation deduction every year you own the property and your gain the day you sell. It lives on the balance sheet, which is exactly the part of the books most landlords ignore. A profit-and-loss-only view of a rental portfolio is half a set of books.

The single best trick in rental bookkeeping costs nothing: name your expense accounts after the Schedule E lines. When the categories in your software match the lines on the form, year-end tax prep is a report export instead of a translation exercise. Here is a working template.

Two accounts in that table do the most protective work, and both live on the balance sheet: security deposits held (a liability) and accumulated depreciation (the running record of deductions that will be recaptured at sale). If your current system has neither, that is the first fix. For a line-by-line walkthrough of the form these accounts feed, see our Schedule E explained guide.

Any mainstream bookkeeping tool can hold this structure; the structure matters more than the software. If you are choosing a tool, we compare the options in our real estate accounting software roundup.

Most individual landlords are cash-method taxpayers: rent is income in the year you actually or constructively receive it, and expenses are deducted in the year paid. "Constructively" matters: rent is income when it is available to you, so a December rent check sitting uncashed in a drawer is still December income. So is January rent a tenant prepays in December.

Accrual accounting, recording rent when it is earned and expenses when incurred, gives a truer month-to-month picture for large operations with receivables and property managers. For a personally held portfolio of a few doors, it adds work without adding a tax benefit, and it creates a books-to- return translation step every year. Unless your CPA has told you otherwise, keep the books on the same cash basis your return uses.

Every month, in order:

1. Reconcile the bank account. Match every transaction in the books to the bank statement. This is the step that catches missed rent, duplicate entries, and the subscription you forgot you were paying. Non-negotiable, and it takes ten minutes when done monthly.
2. Categorize and tag. Every transaction gets an account and a property. Anything ambiguous, especially potential capital items, gets the invoice attached and a note.
3. Review the per-property P&L. One page per property. You are looking for rent that did not arrive, expenses that look wrong, and margins drifting quarter over quarter. This is also where a bad tenant or a money-pit property shows up in the numbers before it shows up in your stress level.

The year-end package your CPA actually needs:

• Per-property profit and loss for the full year, plus a balance sheet if you keep one.
• Form 1098 from every lender, and December mortgage statements showing year-end balances.
• Closing statements for anything bought, sold, or refinanced during the year. These drive basis, new depreciation schedules, and loan cost amortization.
• Invoices for every capital improvement and every item you want covered by the de minimis election, so cost and date placed in service are documented.
• Your existing depreciation schedule from the prior return, if you changed preparers.
• A mileage log if you claim auto and travel for property visits.

Take a hypothetical duplex, two units at $1,450, with a $1,780 mortgage payment. Here is one ordinary month, booked correctly.

Missing from the month, on purpose: depreciation. The building itself is being written off over 27.5 years on the return, computed on Form 4562 from your basis records, whether or not you book it monthly. It is usually the largest single deduction a rental produces, and for owners who want it front-loaded, a cost segregation study can accelerate a meaningful share of it into the early years of ownership.

Up to about three doors, a disciplined owner with a dedicated bank account, the chart of accounts above, and a monthly reconciliation habit does not need to pay anyone for bookkeeping. That is the honest answer, and if it describes you, this page plus decent software is genuinely enough.

Where DIY reliably breaks:

• Multiple entities. Two LLCs and a partnership mean inter-entity transfers, separate books per entity, and equity accounting that spreadsheets mangle quietly.
• Midyear acquisitions and refinances. Every closing statement is a basis allocation, a new depreciation schedule, and loan costs to amortize. This is where the expensive, permanent errors happen.
• Short-term rentals with material participation goals. STR owners pursuing non-passive treatment need contemporaneous time logs and clean cost records that can survive scrutiny, a documentation standard casual books do not meet.
• Falling more than a quarter behind. Catch-up bookkeeping costs more than maintenance bookkeeping, every time.

If you are past the line, two paths: our real estate bookkeeping service takes the monthly work off your plate entirely, and our CPA services for landlords cover the tax strategy and filings that sit on top of clean books.