There are two versions of this problem. The first owner has one QuickBooks file with everything in it and no way to tell the properties apart. The second has six files, one per property, and no way to see the portfolio without a spreadsheet. Both are trying to solve the same structural question and have picked opposite wrong answers.
The right structure depends on your legal entities, not on your property count. Here is how to decide, and how to set it up.
The question that determines everything: how many entities?
The structural rule is simple and it is about entities, not properties. One legal entity, one set of books.
If you hold six rentals inside one LLC, that is one entity and it should be one QuickBooks Online file, with the six properties as reporting segments inside it. If you hold six rentals in six separate LLCs, that is six entities, and the books need to be genuinely separate, because each entity files its own return and has its own balance sheet.
Mixing entities into one file to save on subscriptions creates a real problem: the balance sheet becomes meaningless, because it shows assets and liabilities of several legal persons combined. Splitting one entity across several files creates the opposite problem: no entity-level balance sheet exists anywhere, so nobody can see the whole thing.
Where an entity structure is complex, with holding companies, partnerships, or properties owned across multiple entities, the accounting structure should follow the legal structure as your attorney and CPA have set it up. Meridian Ledger Group LLC does not provide legal or tax advice, and entity structure decisions belong with them. What Meridian can do is make the books match whatever structure exists.
Getting property-level reporting inside one file
Within a single entity, QuickBooks Online gives you two mechanisms for property-level reporting, and the choice between them matters more than it looks.
Classes
Class tracking adds a property dimension to every transaction. Every income and expense line gets tagged with the property it belongs to, and a Profit and Loss by class then produces a column per property plus a total.
This is the right default for most rental owners. It is simple, it does not interfere with anything else, and the report you get is exactly the one you wanted: income and expenses per property, side by side, with the entity total.
Customers or sub-customers
The alternative is treating each property as a customer, with tenants as sub-customers. This gives you per-property income tracking through the invoicing side and works well if you invoice tenants through QuickBooks.
It is more awkward for expenses, and it consumes the customer field, which you may want for tenants. Most owners get a cleaner result using classes for properties and customers for tenants.
What both require
Consistency at the point of entry. A property tag applied to 80 percent of transactions produces a report with an unexplained residual column, and the residual grows until people stop reading the report.
Set the class field as required in QuickBooks Online settings, apply it to every income and expense transaction, and use bank rules to tag the predictable recurring items automatically. Mortgage payments, utilities on a specific meter, and property tax payments can all be tagged by rule without anyone thinking about it.
What genuinely belongs at the entity level
Not everything is a property cost, and forcing everything onto a property is as distorting as tagging nothing.
- Entity administration. Registered agent fees, annual report filings, bank fees on the operating account, accounting and bookkeeping fees.
- Owner distributions and contributions. These are equity movements, not property expenses.
- Portfolio level financing. A line of credit secured across several properties, or a blanket loan, unless you allocate deliberately by a documented method.
- Costs incurred looking at properties you did not buy. Inspections and appraisals on deals that did not close.
Keep an entity-level or unallocated class for these, rather than spreading them arbitrarily. Then a property Profit and Loss shows what that property earned and cost, and the entity Profit and Loss shows the additional cost of holding the structure. Both are true and useful, and they answer different questions.
The one that changes decisions is usually the property view. An owner who can see that one building generated a positive result while another consumed cash every month for two years has a decision available that a portfolio total never surfaces.
Recording a closing statement properly
The purchase closing statement, sometimes called the settlement statement or ALTA statement, is the single most commonly mis-recorded document in a real estate file. It is also the one with the longest tail of consequences, because errors sit on the balance sheet indefinitely.
The frequent mistake is recording the purchase as one entry: the wire amount posted to a fixed asset account. That produces a property basis equal to the cash you brought to closing, which is wrong in both directions, and it loses everything else on the statement.
A closing statement contains several categories that need to land in different places.
- Purchase price, split between land and building, because the two are treated differently for depreciation purposes.
- Closing costs that are typically capitalized, such as title fees, recording fees, and transfer taxes, added to the property basis.
- Loan costs, such as origination fees and points, which are typically treated separately from the property basis and amortized rather than depreciated.
- Prepaid items, such as prepaid insurance and property tax escrow deposits, which are assets rather than immediate expenses.
- Prorated items, such as property taxes and rent credited or debited at closing, which are income or expense of the period.
- The mortgage, recorded as a liability at its full principal amount, not netted against anything.
- The cash you actually wired, which is the balancing figure rather than the starting point.
The land and building split deserves particular attention, because it is not optional and it cannot be derived from the closing statement alone. It usually comes from the county assessor allocation or an appraisal, and your CPA or tax professional will have a view on the basis used. Getting it wrong affects depreciation for as long as you hold the property.
Meridian Ledger Group LLC does not provide tax advice and does not prepare or file tax returns. The bookkeeping goal is a complete and accurate record of the transaction, with the capitalization and allocation treatments agreed with your tax professional so the file supports the return rather than contradicting it.
Loans: the other balance sheet problem
The second most common structural error is expensing the whole mortgage payment.
A mortgage payment is at minimum two things, principal and interest, and often four, adding escrowed property tax and escrowed insurance. Only the interest is an expense. The principal reduces the loan liability. The escrow portion is a transfer into an asset, and becomes an expense when the escrow account pays the tax or the premium.
When the entire payment is expensed, three things go wrong simultaneously. Expenses are overstated, so property performance looks worse than it is. The loan balance on the balance sheet never decreases, so it eventually bears no relationship to what you owe. And equity is understated by the accumulated principal, which compounds year over year.
The fix is mechanical. Get the amortization schedule from the lender, split each payment according to it, and reconcile the loan balance to the schedule every month. This is a five minute check that catches drift immediately.
For properties with escrow, treat the escrow account as an asset and record the disbursements when the escrow pays. An escrow account that has never been reconciled is a common source of a mysterious balance sheet item, and it is usually straightforward to unpick once someone looks.
The reports worth having each month
Once the structure holds, four reports do most of the work.
- Profit and Loss by property, with comparison. Current period against prior period and prior year, so a change reads as a change.
- Entity balance sheet. Reconciled cash, loan balances tied to schedules, escrow and prepaid balances, security deposits held as liabilities, and equity.
- Cash view. What came in, what went out, and what is committed. For owners with debt service, this is often the report that actually drives decisions.
- Property performance summary. Net operating result per property, with financing shown separately, so you can see the difference between a property that performs poorly and a property that is simply heavily leveraged.
That last distinction is worth dwelling on. A property with strong operating performance and thin cash flow after debt service is a financing situation. A property with weak operating performance is an asset situation. They look identical on a single bottom line and call for completely different responses.
If your file is already mixed together
This is the normal starting point, and the work is more contained than most owners expect.
The sequence that works: establish the entity structure as it legally exists, decide the property segmentation method, then rebuild forward from a clean start date rather than attempting to retag years of history.
Some history is worth reconstructing. Balance sheet items almost always are, because an incorrect property basis or an unreconciled loan balance stays wrong until someone fixes it, and it affects every future period. Income and expense detail from three years ago usually is not, because the decision it might have informed has passed.
So the practical priority order is: correct the balance sheet, get the current year segmented properly, and treat older income statement detail as approximate. That gives you a trustworthy position and a trustworthy current year, which is enough to run the portfolio on.
Meridian handles this as cleanup and catch-up, and the property structure gets designed as part of it rather than bolted on afterwards. More on the ongoing side is on real estate bookkeeping.
The short version
Structure the books around legal entities, one entity per file, and use classes to report properties as segments within an entity. Keep entity level costs out of property results, record closing statements as the multi part transactions they are with a proper land and building split, and split every loan payment between principal, interest, and escrow. Correct the balance sheet first if the file is behind.
