Real Estate Bookkeeping Cleanup: Separating Commingled Properties and Entities in QuickBooks Online

Real estate is one of the few businesses where the bookkeeping gets complicated faster than the business does. You buy one rental, and a single set of books handles it fine. You buy a second, maybe hold it in a separate LLC, refinance the first, lend money between the two to cover a repair — and suddenly a file that was simple is quietly tangled. Income and expenses from different properties blur together, money moving between entities looks like income or expense instead of a transfer, and the reports can no longer tell you which property or which entity is actually performing.

This is the most common condition we see in real estate files that need a cleanup, and it's rarely the result of carelessness. It's the result of a business that outgrew its bookkeeping structure without anyone stopping to rebuild it. The good news is that it's fixable — but the fix has an order to it, and doing it in the wrong order just creates a different tangle.

Why commingling is the root problem

When properties and entities are commingled in QuickBooks, every downstream report becomes unreliable. A Profit & Loss for "the portfolio" is meaningless if you can't break it out by property, because a strong performer can hide a bleeder and you'd never know. Worse, when transactions between your own entities are recorded as ordinary income and expenses, your books overstate both — inflating revenue on one side and costs on the other, distorting the tax picture, and making the numbers impossible for a CPA to rely on at year-end.

Real estate also carries its own specific traps. Money an owner puts into a property is a capital contribution, not income. Money taken out is a distribution or draw, not an expense. A loan between two of your entities to cover a shortfall is a balance-sheet item on both sides, not a P&L event. When these get miscoded — and in a commingled file they almost always do — the reports tell a story that never happened, and the errors compound every time the transaction recurs.

Step one: decide the structure before you touch a transaction

The first real decision in a real estate cleanup isn't accounting, it's structure: how should this portfolio be represented in QuickBooks in the first place? Sometimes the right answer is separate QuickBooks files for separate legal entities, so each LLC has its own clean set of books and its own balance sheet. Sometimes the right answer is a single file that uses classes to track each property or entity separately within one set of books. Which is correct depends on how the entities are actually structured legally, how they file taxes, and how much separation the owner and their CPA need to see.

Getting this decision right up front is what prevents the cleanup from having to be redone later. Rebuilding a year of history into the wrong structure is worse than not rebuilding it at all, because now you've spent the effort and still can't produce the reports you need. This is the step DIY cleanups most often skip — they start recategorizing transactions before deciding what the finished structure should look like.

Step two: separate the properties and entities cleanly

Once the structure is set, the work is to sort the history into it — assigning each transaction to the correct property and entity, so that income and expenses line up where they actually belong. In a class-based single file, that means every transaction carries the right class so a Profit & Loss by class gives you a true picture of each property. In a separate-files structure, it means untangling which transactions belonged to which entity and moving them home.

This is painstaking, but it's where the value is. When it's done, an owner can finally answer the questions that matter: which property is the top performer, which one is eating its returns in maintenance and vacancies, and how each entity actually stands on its own. Those answers are impossible to produce from a commingled file no matter how good the reporting tools are.

Step three: record the intercompany and capital activity correctly

The last piece is the one that trips up almost everyone: the money that moves between entities and between the owner and the properties. Loans between your own LLCs need to be recorded as what they are — a receivable on one side and a payable on the other, tracked with Due To and Due From accounts so the balances stay accurate and supportable. Capital contributions and distributions need to hit equity, not income and expense. And transfers between accounts you own need to be recorded as transfers, not as revenue on one end and a cost on the other.

Getting this right is what makes the books not just organized but defensible — the kind of file a CPA can build a tax strategy on instead of spending billable hours untangling, and the kind of records that hold up if anyone ever needs to see how the entities relate. It's also what makes your Schedule E preparation straightforward instead of a year-end scramble, because each property's income and expenses are already clean and separated.

The order is the strategy

A real estate cleanup done well follows this sequence deliberately: decide the structure, separate the properties and entities into it, then record the intercompany and capital activity correctly on top. Skip the structure decision and you rebuild into the wrong shape. Sort transactions before deciding the structure and you sort them twice. The sequence is what turns a tangled file into one that's clean, structured, and ready for your CPA.

At QBO Cleanups, we specialize in the accounting complexity behind growing real estate portfolios — restructuring and reconciling multi-entity files so each property and entity is accurately separated and tax-ready, and recording the loans and transfers between them so the balances are accurate and fully supported.

If your portfolio has outgrown its books, that's not a failure — it's a milestone that came with a bookkeeping bill attached. Book a free discovery call and we'll take an honest look at what it would take to separate it cleanly.

Mary E. Davis, C.P.B. holds Advanced QBO ProAdvisor certification and 20+ years of bookkeeping experience.