Setting Up Your Chart of Accounts: A Guide for Real Estate Professionals
Updated: Jun 1
By Joyce Orr | On The Books Bookkeeping Services
When new clients approach me, I often see a chart of accounts that was set up incorrectly. This usually happens because it was copied from a generic QuickBooks template or created by a bookkeeper unfamiliar with real estate. They might handle restaurants and retail alongside rental properties, but that doesn’t mean it works well for you.
"Well enough" can cost you money. It leads to confusion at tax time, makes lender-ready reporting a scramble, and obscures the performance of each property.
Setting up your chart of accounts correctly from the start—or cleaning it up if it’s already a mess—is the most crucial structural decision you’ll make for your books. Here’s how I assist my clients in this process.
What Is a Chart of Accounts, and Why Does It Matter?
Your chart of accounts (COA) is the backbone of your bookkeeping system. It’s the master list of every category used to record financial transactions. Every dollar coming in and going out gets assigned to an account on this list.
When set up correctly, your books tell a clear story: how much each property earns, what it costs to operate, where your money is going, and how your portfolio performs as a whole. If set up incorrectly, you end up with a tangled mess that no CPA, lender, or investor wants to sort through.
For real estate, a generic chart of accounts simply doesn’t cut it. You need categories that reflect how rental properties actually work.
The Five Account Types You Need
Every chart of accounts, regardless of industry, is organized around five core account types. Here’s what each one looks like for a rental portfolio:
1. Assets
Assets are what your business owns or is owed. For rental properties, your asset accounts typically include:
Checking account — your operating account where rent is deposited and expenses are paid.
Security deposit account — this must be a separate account, held in trust.
Accounts receivable — tenant balances that are owed but not yet collected.
Property — the value of the real estate you own (if tracking on an accrual basis).
2. Liabilities
Liabilities are what your business owes. Key liability accounts for landlords and property managers include:
Security deposits held — this offsets your security deposit asset account. Security deposits are not income; they belong to your tenants until properly applied or returned.
Mortgage payable — if you carry financing on your properties.
Accounts payable — vendor invoices and expenses owed but not yet paid.
3. Equity
Equity represents the owner's stake in the business. For most clients operating as LLCs, this includes:
Owner's equity or capital contributions.
Owner's draws.
Retained earnings.
4. Income
This is where most of the real estate-specific structure lives. I recommend breaking income down by type rather than lumping it all into one "rental income" bucket:
Rental income — base rent collected from tenants.
Late fees — charged when tenants pay past the grace period.
Parking or storage income — if applicable.
Pet fees — recurring monthly pet rent (not to be confused with pet deposits, which are liabilities).
Laundry or vending income — for properties with on-site amenities.
Other income — a catch-all for anything that doesn't fit above.
The reason for this separation is simple: at year-end, your CPA needs to see income by type. If you ever seek financing, a lender will want to understand your revenue streams clearly.
5. Expenses
This is where most portfolios get sloppy. A well-structured expense section for rental properties should include, at minimum:
Repairs and maintenance — routine upkeep and minor repairs.
Capital improvements — larger projects that add value or extend the life of the property.
Property management fees — if you use a third-party manager.
Insurance — property and liability coverage.
Property taxes.
Mortgage interest — separate from principal payments.
Utilities — broken down by type if the owner pays (electric, water, gas, trash).
Landscaping and grounds.
Advertising and leasing — listing fees, photography, tenant screening costs.
Professional fees — CPA, legal, bookkeeping.
Bank fees and charges.
Depreciation — if tracking on an accrual basis.
Structure at Two Levels: Entity and Property
Getting your chart of accounts right isn’t just about the accounts themselves; it’s also about how your overall bookkeeping structure is organized. There are two distinct levels to consider, and confusing them is a common mistake.
Level 1: One entity, one file. If you own multiple properties through separate LLCs—which I recommend—each entity needs its own QuickBooks file and its own chart of accounts. Do not combine them.
I frequently see clients with three LLCs all running through one QuickBooks file because it seemed easier at the time. It isn’t easier. It creates legal exposure, makes entity-level reporting impossible, and is a nightmare to unwind. One LLC, one file. Every time.
Level 2: Track by property within each entity. Once your entities are properly separated, the next question is how to track performance across multiple properties within a single entity. If one LLC owns five properties, you still need to know how each one is performing individually. This is where QuickBooks' class or location tracking feature comes in.
By coding every transaction to a specific property, you can run a Profit & Loss report for each one. This tells you exactly which properties are performing, which ones are bleeding money, and where to focus your attention. Without it, you’re looking at a blended picture that hides as much as it reveals.
Think of it this way: entity separation is a legal necessity. Property-level tracking is a business intelligence tool. You need both.
A Note on Security Deposits
I want to highlight this because it’s the most common mistake I see, even among experienced landlords.
Security deposits are not income. The moment you record a security deposit as income, your books are incorrect.
A security deposit is a liability—money you’re holding on behalf of your tenant that must be returned (in full or in part) at the end of the lease. It should be held in a dedicated, separate bank account, recorded as an asset on one side and a liability on the other. Only when a deposit is applied—for unpaid rent or documented damage—does any portion of it become income.
Get this wrong, and you’ll overpay taxes, misstate your income, and potentially face legal trouble. While many states require security deposits to be held in a dedicated escrow or trust account, Texas is not one of them. However, I strongly recommend doing so anyway. Texas has strict rules about how security deposits must be handled at the end of a tenancy: landlords have 30 days to return the deposit or provide an itemized written statement of deductions. Misclassifying a deposit as income creates an accounting problem and complicates tracking what you owe tenants when it’s time to settle up.
Where to Start
If you're starting from scratch, open QuickBooks Online and begin with the default real estate chart of accounts template. Then customize it using the structure above. Delete what doesn’t apply, add what’s missing, and ensure your income and expense categories reflect how your portfolio operates.
If you’ve been using a generic or messy chart of accounts for a while, a cleanup is worth doing properly. This usually means exporting your transaction history, remapping categories, and reconciling from scratch. This is exactly the kind of setup work we do for new clients at On The Books Bookkeeping Services.
Regardless of your starting point, getting your chart of accounts right is the foundation everything else is built on. Clean categories lead to clean reports. Clean reports mean better decisions—and fewer surprises at tax time.
Have questions about setting up your chart of accounts or cleaning up an existing one? Schedule a free 20-minute discovery call, and I’ll take a look at what you’re working with.
Comments