Bookkeeping for Real Estate Investors and Property Managers: What QuickBooks Can (and Can't) Do for You

Imagine having three small buildings and all three of them made $100,000 in rent income for the past year. How do you differentiate which building, even which unit made the most income? Let's dive deeper into some of the rules and I will explain what real estate and property managers need to see and how that needs to be broken down.

A property manager came to us last year with what he called “a rent roll problem.” He was managing 14 units across three small buildings, and every month he spent the better part of a weekend trying to match the deposits hitting his bank account to the tenants who were supposed to have paid. Some rents came in early, some late, one tenant always paid in two installments, others have deposits sitting in undeposited funds, and two owners expected separate reports for their properties. A lot to take in? His QuickBooks file treated all of it as one undifferentiated pile of “rental income.”

This is the most common real estate bookkeeping setup problem we see — and it’s entirely fixable in QuickBooks. The software can absolutely handle property-level tracking, owner reporting, and clean reconciliations. The catch is that QuickBooks won’t organize any of it for you. Set up correctly, it becomes the financial backbone of a real estate operation. Set up like a generic small-business file, it becomes the weekend headache above.

Here’s what QuickBooks can do for real estate and property managers, where its limits actually are, and how to build a setup that gives you numbers you can trust.

Why real estate bookkeeping is different

Real estate bookkeeping is different because a real estate business isn’t one business — it’s a portfolio of small businesses that happen to share an owner. Each property has its own income, its own expenses, and often its own owner or investor who expects to see how their asset is performing.

A restaurant has one profit-and-loss statement. A landlord with six units may need seven: one per property, plus a consolidated view. That single structural fact drives almost every setup decision that follows.

Layer on the tax dimension and the complexity compounds. The IRS reports that roughly 9.72 million taxpayers owned rental property in 2024, and most of them report income and expenses on Schedule E (form 1040) — the IRS form used to report income or loss from rental real estate and royalties. Now, where is the sales tax? That's a different story, but will be discussed in the future of the blog. Schedule E asks you to break out results per property across roughly fifteen expense categories, from cleaning and maintenance to management fees to mortgage interest. If your books don’t already track expenses that way, tax season becomes a reconstruction project instead of an export for CPAs.

Property managers carry an additional burden most owners don’t: they handle money that isn’t theirs. Rent collected on behalf of an owner, security deposits, and management fees earned all have to stay clearly separated. Commingling those funds isn’t just messy — in many states it’s a compliance violation.

Setting up QuickBooks for property management

The good news: QuickBooks Online has the tools to handle all of this. You just have to configure them deliberately before the transactions start piling up. Here is the setup sequence we use when onboarding a real estate client.

1. Choose the right QuickBooks plan. Property-level tracking depends on the Class and Location features, which are available in QuickBooks Online Plus and Advanced. Simple Start and Essentials won’t do the job. Start on the right tier so you don’t have to migrate later.

2. Turn on Class and Location tracking. Under Account and Settings, enable both. You’ll use one dimension for properties and the other for units or owners — more on that below.

3. Set up each property as a Class (or Location). Create a Class for every building or property. Now every transaction can be tagged to a specific property, and QuickBooks can produce a P&L filtered to just that asset.

4. Track units or owners with the second dimension. Use Location (or sub-classes) for individual units, or to group properties by the owner they belong to. This is what lets you generate a clean, per-owner report in seconds instead of a weekend.

5. Build a real estate chart of accounts. Replace the generic default accounts with categories that mirror how real estate actually earns and spends. This is the single highest-leverage step, so it gets its own section below.

6. Set up your bank and trust accounts separately. Operating funds, and any security-deposit or trust funds you hold, belong in distinct accounts in QuickBooks that mirror distinct accounts at the bank. Never run deposits through your operating account. You actually can, but it becomes a nightmare with all the deposits and tracking in Excel who, for what unit, and when the deposit is paid and needs to be returned.

   
   

A quick note of realism: this setup takes a few focused hours to do well, and the Class/Location structure is hard to change once a year of transactions is built on top of it. It pays to get it right the first time — or to have someone who’s done it before build it with you. A clean structure here is closely related to the chart of accounts setup we’ve written about for small businesses generally, applied to the specific realities of property.

The accounts every property manager needs

At minimum, a real estate chart of accounts should let you see income and expenses the way both you and the IRS think about them. The default QuickBooks chart doesn’t — so this is where most files go wrong.

On the income side, separate your revenue streams rather than lumping them into one “Rental Income” line:

• Rental income (the base rent)

• Late fees and other tenant charges

• Application and administrative fees

• Management fees earned (for property managers)

• Reimbursed expenses (utilities or repairs billed back to owners or tenants)

  
  

On the expense side, structure your accounts to map cleanly onto Schedule E’s categories so year-end reporting is an export, not an ordeal (this is just a base of expenses, but you can adjust it as you wish and as it makes sense to you):

• Repairs and maintenance

• Cleaning and turnover

• Property management fees paid

• Insurance

• Property taxes

• Mortgage interest (tracked separately from principal — only the interest is deductible)

• Utilities

• Depreciation

Remember that when categorizing these, they need to be categorized to correct class and/or location. They will show as one item in your P&L in consolidated statement, but when you run the report to show you P&L based on the class/location, it will show how much money was earned and spent for each unit.

Two balance-sheet items deserve special attention. Security deposits are a liability, not income — you’re holding the tenant’s money, and it belongs in a liability account until it’s returned or applied. And mortgage payments must be split: principal reduces a loan liability, while only the interest portion is a deductible expense. Booking the whole payment as an expense is one of the most common — and most expensive — errors we find in real estate files.

What QuickBooks can’t do alone — and what QQS adds

QuickBooks is a powerful ledger, but it is not a property management system, and it won’t catch its own mistakes. This is where the honest limits sit.

QuickBooks won’t chase a late rent payment, won’t flag that a tenant underpaid, and won’t tell you a repair was accidentally coded to the wrong property. It doesn’t reconcile itself, it doesn’t know that a “deposit” was actually a security deposit rather than rent, and it won’t produce an owner statement unless someone has built the structure to make one possible. It also doesn’t integrate rent collection, lease tracking, or maintenance requests — for those, investors often pair QuickBooks with a dedicated property management app and sync the financial data across.

What a bookkeeper adds is judgment and consistency: the monthly reconciliation that confirms every dollar of rent actually landed where the books say it did, the correct classification of deposits and mortgage splits, and the per-property and per-owner reports delivered on a predictable schedule. The IRS is explicit that good records are what let you monitor the property, prepare financial statements, and support what you report at tax time — and “good records” means maintained every month, not reconstructed every April.

This is exactly the work we handle in our bookkeeping services and, for owners and managers who want the full financial operation run for them, our account management services — reconciliations, owner reporting, and 1099 handling for the contractors nearly every property relies on.

Conclusion

Real estate is one of the industries QuickBooks serves best — but only when it’s configured for the way property actually works. The takeaways worth keeping:

• Structure before transactions. Enable Class and Location tracking and set up each property before the first month of activity, not after.

• Build the chart of accounts around Schedule E. Separate income streams, split mortgage payments, and treat security deposits as a liability.

• QuickBooks is the ledger, not the manager. It records beautifully but reconciles nothing on its own — that consistency is what turns data into decision-ready financials.

  
  

If your rental income all lands in one bucket and every month-end feels like detective work, your setup is the problem, not you — and it’s fixable. Book a free 15-minute call and we’ll review your current QuickBooks file and show you what a clean real estate chart of accounts looks like for a portfolio like yours. No contracts, no pressure — just a clearer set of books.

About the author

Marko Radulovic is the founder of QuantumQuota Solutions, a fully remote bookkeeping firm serving U.S. small businesses. He holds an MBA and is a NACPB-certified bookkeeper and certified QuickBooks ProAdvisor with six years of experience structuring and cleaning up QuickBooks files for businesses across real estate, healthcare, financial, legal, professional, non-profit, and agency sectors. Connect with Marko on LinkedIn.