Chart of Accounts for Real Estate

Whether you’re a landlord with a small-to-mid-sized rental portfolio, a property manager overseeing 10-50 units, or a solo brokerage operator, a purpose-built chart of accounts (COA) is one of the keys to understanding the financial health of your business.

If you’re using QuickBooks for real estate, you may have found the default COA for real estate helpful at first, but it’s really just meant as a template. As your portfolio grows or becomes more complex, the default configuration becomes less useful and soon requires customization.

The first step to creating the ideal chart of accounts for a real estate portfolio is understanding what makes real estate bookkeeping different from other industries, and then building your COA around those distinctions. 

What Makes a Real Estate Chart of Accounts Different From Other Industries?

Most small business accounting systems operate around a relatively straightforward model: revenue comes in, expenses go out, and what’s left is the profit. When you’re dealing with real estate, though, things are more complex.

One major difference is a structural one: in a chart of accounts for a real estate investor, property-level tracking is essential. That level of granularity is what lets you understand the profitability of different properties, enabling you to optimize rental income, reduce operational expenses, retain your best tenants, and accurately assess each property’s performance. In turn, this lets you maximize profits, identify and mitigate risks, and embrace data-driven decision-making.

The second difference that makes a real estate or property management chart of accounts unique is how common account types are best handled.

• Security deposits are a liability, not income. This money belongs to your tenant(s) until certain conditions are met. Recording security deposits as income is a common mistake, and it can be a costly one when it inflates revenue and causes you to pay taxes on money that’s not technically yours and must be returned.

• Mortgage payments are not a single expense. Think of each payment as having three distinct components: interest (an income statement expense), principal reduction (a balance sheet entry that reduces your loan liability), and escrow for taxes and insurance (an operating expense). Posting the full payment as a “Mortgage Expense” overstates your costs and distorts your P&L.

• Capital improvements must be capitalized, not expensed. There’s a big difference between replacing an HVAC system and fixing a leaky faucet. Rather than deducting them in a single year (like a repair), capital improvements belong on your balance sheet as assets that depreciate over time. 

What Accounts Does Your Real Estate Business Actually Need?

A well-structured real estate chart of accounts in QuickBooks is one with the appropriate number of accounts (neither too many nor too few, as each will create problems in your reporting). 

When setting QuickBooks for real estate, the primary goal is to make your reports accurate and useful; that requires you to think about common account categories through a real estate lens. 

• Income Accounts: Be sure to break out revenue sources by type, not just by property. For example, a rental property chart of accounts should distinguish between rent income, late fees, parking or storage fees, and ancillary income sources. Since these categories function differently than they do in other industries, this separation is especially important for analyzing the performance of your portfolio.

• Expense Accounts: In the context of real estate, your COA expense structure needs one critical distinction: repairs and maintenance are not the same as capital improvements. They have different impacts on a property’s value and are treated differently by the IRS as well. Key expense categories include property management fees, insurance, utilities (tracked by property where possible), professional fees, and mortgage interest (but not full mortgage payments).

• Assets: Your asset accounts should capture what your business owns, which starts with the value of each property (which gets recorded on your balance sheet, not your income statement). For each property asset, you’ll want an accumulated depreciation account to track the value written down over time, and you should also carry a security deposit trust account here to reflect the cash you’re holding on tenants’ behalf.

• Liabilities: Those same security deposits should also be recorded in a “Security Deposits Payable” account that reflects money owed back to tenants. Your mortgage principal balances also constitute liabilities, not expenses, since paying down a loan is a balance sheet transaction, not an operating cost.

Should You Create Separate Accounts for Each Property?

It’s not advisable to create separate accounts for each property, which is where many property management accounting system setups go wrong. When you create these, you quickly find yourself staring at a COA that’s bloated and difficult to maintain. 

Instead, property-level tracking is better-suited for class or location tracking features available in QuickBooks Plus (and above), rather than as separate accounts. Classes or location tags let you filter and report by property without multiplying your account structure, providing granular reporting without creating a cluttered and unwieldy chart of accounts.

What Are the Most Common Real Estate COA Mistakes, and How Do You Fix Them?

Recording Security Deposits as Income

Instead of recording them as income, security deposits should be considered liabilities until their conditions are met. If you’ve already recorded them as income, the easiest fix is to reclassify them to a “Security Deposits Payable” account, keeping them off your P&L.

Posting Full Mortgage Payments as Expenses

When you receive a mortgage payment, only the interest qualifies as an expense. The principal component reduces your loan balance, so it belongs on the balance sheet. Every time you receive a payment, be sure to split it correctly. Otherwise, your profitability numbers will be unreliable. 

Lumping Repairs and Improvements Together

The IRS treats repairs and improvements differently; lumping them together distorts financial statements, misrepresents your Net Operating Income, and risks triggering an IRS audit. Repairs (that maintain a property’s condition) should be recorded as expenses, while capital improvements (that improve its condition) belong on your balance sheet as an increase to the property’s cost basis.

Mixing Multiple Entries Into One File

If you own multiple properties under separate LLCs, each entity needs its own file (not sub-accounts within a shared file). Comingling these entries creates liability exposure and can create confusion in your reporting. The right structure is a separate QuickBooks file for each entity, so reporting stays clean at both the property and portfolio level.

Overbuilding the Chart of Accounts

There’s a happy medium between including too many and too few accounts in your COA. Just like combining multiple entries in a single file creates issues (see the previous point), including too many does not lead to improved visibility; it often has the opposite impact. The best fix is to create the accounts you need to create, and then use classes for property-level detail.

When Does Your Real Estate COA Need a Professional Review?

It’s difficult to overstate the importance of a correct chart of accounts setup for a small business, and that’s especially true with real estate. A proper real estate accounting setup is fundamentally necessary for income and expense tracking across multiple properties, as well as ensuring tax compliance and improving cash flow management. 

While some experienced investors might be comfortable building their own real estate chart of accounts, a DIY setup isn’t always feasible as you scale or diversify your portfolio. If you’re having trouble telling which properties are profitable, your books require extensive cleanup during tax season, or a lender or investor is requesting “clean” financials that you can’t easily provide, you have likely outgrown your COA configuration.

That’s where Milestone comes into the picture, offering fractional accounting services for real estate and property management as well as complete accounting system design and implementation. Milestone’s experienced team is ready to help assess your current setup, build your ideal QuickBooks configuration, and train your team on how to use it.

If your current setup can’t answer questions about your portfolio’s health and individual properties’ profitability, it’s time to build a better system. Learn more about how Milestone can help.