Real Estate Accounting Entries

Why Most People Mess Up Property Bookkeeping

Most real estate bookkeeping comes down to a handful of recurring entries, but people keep tripping over the same stuff. I spent about eight years running the books for a small portfolio before handing it off, and the errors always came from the same sources. Not understanding how depreciation interacts with depreciation recapture. Messing up the security deposit handling. Forgetting that operating expenses and capital improvements are completely different animals.

The simplest way to think about real estate accounting entries is to separate everything into buckets: the acquisition bucket, the income bucket, the operating expense bucket, the depreciation bucket, and the disposition bucket. Every transaction falls into one of those. If it doesn't fit neatly, you probably need to figure out why before you book it. Let me walk through what these actually look like in practice, not just the textbook version. When you buy a property, you're not just debiting one account. You need to allocate the purchase price across land, building, and any improvements. Land doesn't depreciate. The building does. Mixing those up is the most common error I see, and it costs people real money at tax time.

The entry looks like this: Debit Land for the allocated amount
Debit Building for the allocated amount
Debit Improvements for any separate line items
Credit Cash or Mortgage Payable for the total purchase price I once worked with an investor who just booked the entire purchase price into the building account. Saved maybe ten minutes on data entry and created a nightmare when he sold the property three years later. The depreciation schedule was wrong, the gain calculation was wrong, and the CPA spent two days fixing it. Just split it properly the first time.

Rental Income Entries

Recording rent received is straightforward until it isn't. Security deposits are liabilities, not income. If you book them as revenue, you're overreporting income and underreporting a liability. It sounds obvious but people do it constantly, especially when they're first setting up their chart of accounts. When rent comes in: Debit Cash for the amount received
Credit Rental Income for the actual rent
Credit Security Deposits Payable if you collected a deposit

If you prepaid rent, that's unearned revenue until the period hits. Debit Cash, credit Unearned Rent Revenue, then each month move from the liability to the income account. Same logic applies to advance payments for services like cleaning or repairs that might be owed back.

Operating Expense Entries

This is where things get messy. Property taxes, insurance, maintenance, utilities, management fees - they all come in at different times with different billing cycles. I used to spend about two hours every month reconciling expense accounts because vendors sent invoices on weird schedules and checks didn't clear when they should have. The fix was setting up a recurring expense schedule for the predictable ones and keeping a standing folder for everything else. Property tax and insurance go in automatically each month. Maintenance and repairs get logged when they happen. By the time reconciliation came around, I was usually looking at maybe five or six unclear entries instead of thirty.

Depreciation Entries

Residential rental property is depreciated over 27.5 years using the straight-line method. Commercial is 39 years. This is non-negotiable and it's one of the few things that's pretty uniform across the board. The tricky part is knowing what gets depreciated and what doesn't. When you book depreciation, you're not touching cash. It's a non-cash expense that reduces taxable income. The entry is straightforward: Debit Depreciation Expense
Credit Accumulated Depreciation

The accumulated depreciation account is a contra-asset. It sits on the balance sheet and grows every year. When you sell the property, the total accumulated depreciation gets credited against the building's original cost to figure your gain or loss. This is also where depreciation recapture comes from. The IRS treats that portion of the gain as ordinary income, not capital gains, which means it gets taxed at a higher rate.

The Common Pitfall Nobody Warns About

Here's something most guides skip: the interaction between partial year depreciation and mid-month conventions. If you buy a property in March, you don't get depreciation for March. You start counting from April, and the first year's depreciation is prorated based on the IRS mid-month convention. Buy it on the 15th of May and you get half a month of depreciation for the first year. Buy it on the 3rd and you get a full month. It's a small detail but it adds up over twenty-seven years. I ran into this when a client bought a property on January 20th and assumed he'd get a full year's depreciation starting that same month. He didn't. The IRS convention meant his first year was only about eleven months worth. He'd taken slightly too much on his return and had to amend. Nothing dramatic, just a quiet adjustment. But it happened because nobody had explicitly walked him through the mid-month rule.

Closing and Sale Entries

When you sell, you're reversing everything. You credit the building for its original cost, credit accumulated depreciation for the total taken, debit any gain or credit any loss, and debit cash for what you received. The difference between your adjusted basis and the sale price is your gain or loss. The adjusted basis is original cost minus accumulated depreciation. That's the number that matters, not what you originally paid. If you've been depreciating correctly for years, your adjusted basis will be significantly lower than your purchase price, which means your gain will be larger than it looks at first glance. This is also where many people hit the depreciation recapture wall.

What This System Doesn't Handle Well

Simple entries miss some edge cases. If you have a short-term rental component in a mixed-use property, you need to prorate income and expenses between personal and rental use. If you do significant improvements during the year, those get added to the basis and depreciated separately, sometimes with a different recovery period. If you convert a personal residence to rental property, the basis for depreciation purposes is the lesser of the adjusted basis or fair market value at the conversion date. Those scenarios require more nuanced handling than standard entries cover. For a small portfolio of long-term rentals, the standard entries are enough. For anything more complex, you probably need accounting software with real estate templates or a professional who understands the specifics. I tried managing a portfolio of six properties with a spreadsheet and it worked fine for about a year. After that, the errors started accumulating faster than I could catch them.

What to Do Instead of Spreadsheets

Software like QuickBooks with the real estate package handles a lot of this automatically. Recurring journal entries for rent, automatic depreciation schedules, expense categorization that sticks. It cuts the monthly close from a couple of hours down to maybe fifteen minutes for a small portfolio. The tradeoff is the monthly cost and the initial setup time, which is where most people get stuck. If you're doing this manually, at minimum keep a fixed asset register separate from your general ledger. Track each property's original cost allocation, the depreciation taken each year, and the accumulated total. Without that, you're just hoping the numbers add up when you need to sell or file taxes. That's not a strategy, it's a gamble. Get the acquisition entries right from day one. Keep the depreciation schedule updated. Separate security deposits from income. Prorate properly at year end. Do those four things consistently and the rest of the entries mostly sort themselves out.