Guides · cleanup method

Rental books, untangled property by property.

Most landlord files fail the same way: every property's money in one pool, security deposits sitting in rent income, mortgage payments booked as one big expense, and a P&L that can't say which door earns and which one bleeds. This is the cleanup that unblurs it — the test that finds every tangle, the two signature repairs, and the re-tag sequence that proves each month as it goes.

Books method only — capitalization calls, entity structure, and deposit law are your CPA's and attorney's territory, and this guide keeps saying so.

Per-property P&L as the finish line Operator-built · 40 years

In brief

The rental cleanup, in four answers.

Where do I start?

With the test, not the software: can every transaction answer "which property?" The ones that can't are the scope. Then structure first, history second — never the reverse.

What are the signature repairs?

Two: deposits re-homed from income to a tenant-by-tenant liability, and mortgage payments split into principal, interest, and escrow. Most landlord files carry both errors.

Classes or separate files?

One file per legal entity, a class per property inside it. Whether the portfolio should be one entity or several is your attorney's and CPA's question — the books mirror the answer.

What does done look like?

Per-property P&Ls that sum to the portfolio, a deposit liability equal to deposits held, loan balances matching lender statements, and repairs vs improvements in separate lanes for your CPA.

A Westgate framework · the finding question

The Which-Property Test.

The Which-Property Test: every transaction in a rental file must answer one question — which property, or the business itself? It's the rental sibling of the classifying questions that keep other books honest, and it earns its place because one question finds every failure mode at once: the deposit that can't name its tenant, the repair that can't name its address, the mortgage lump that answers "all of them, somehow," the personal purchase that answers nothing. You don't need an audit to scope a rental cleanup — you need three recent months and this question, and the transactions that fail it are the job.

The test also explains why blurred rental books hurt more than blurred books elsewhere. A portfolio P&L is only the sum of property stories: with the test failing, a bleeding unit hides inside a healthy total, the one number every buy-sell-refinance decision needs — what does this door actually earn — doesn't exist, and the two balances that must be provable to the dollar, deposits held and loans owed, are neither. Passing the test isn't bookkeeping perfectionism; it's the difference between owning a portfolio and owning a pile.

The Which-Property Test as a gate: transactions that answer flow into per-property lanes (plus one business lane with a written allocation rule); the ones that can't answer form the blur pile — and counting that pile is how a rental cleanup gets scoped honestly.

The method

The cleanup, in seven steps.

Test first, structure second, the two signature repairs, then the oldest-first re-tag that proves each month as it goes.

1 · Run the Which-Property Test on the file as-is

Open the last three months and ask every transaction one question: which property — or the business itself? Count what can't answer: the deposits with no tenant, the repairs with no address, the mortgage payment booked as one expense, the personal spending hiding in supplies. That count is the honest scope of the cleanup, and it's better to know it before the weekend starts than during it.

2 · Stop the blur going forward before fixing the past

The same pin-the-present logic as any rebuild: from today, rental money moves through the rental account only, every new transaction gets its property tag at entry, and new deposits land in the liability account. A cleanup of a file that's still blurring is a treadmill — the behind-on-books triage covers why in depth.

3 · Build the property dimension before re-tagging anything

One entity per file — whether your properties should sit in one entity or several is a question for your CPA and attorney, and the books mirror that answer — then a class or location per property inside it, plus a lean rental chart of accounts: rent income, repairs, improvements, insurance, taxes paid, utilities, management fees, interest. Lanes your CPA can map cleanly at filing time beat lanes that guess at the mapping.

4 · Repair the security-deposit liability

Deposits you hold are the tenant's money until they're rightfully applied — a liability by tenant, never income on arrival. The classic landlord error is deposits sitting in rent income, overstating every year they arrived in; the repair is re-homing each one to the liability account until the account equals exactly what's currently held, tenant by tenant. What your state requires around deposits — interest, timelines, separate holding — is your attorney's and CPA's territory; the books' job is that the number is right and provable.

5 · Split the loan payments three ways

A mortgage payment is not an expense — it's three transactions in one draft: principal reducing the loan liability, interest as the actual expense, and escrow accumulating as an asset until the insurer or tax office is paid from it. The amortization schedule and loan statements are the source; booked as one lump, the P&L overstates costs while the balance sheet's loan balances quietly stop being real.

6 · Re-tag the history oldest-first, reconciling as you go

Now the actual cleanup: work from the oldest blurred month forward, assigning every transaction its property, re-homing the deposits and loan splits from steps four and five, and reconciling each month to its bank statement before moving on — the same oldest-first, prove-every-month sequence as the full cleanup checklist. Shared costs that genuinely serve the whole portfolio get allocated by one written rule — per unit, per square foot, per revenue share — picked once and applied consistently; whether an allocation basis works for tax purposes is your CPA's call.

7 · Prove the per-property P&L and lock the rhythm

Done looks specific: each property's P&L stands on its own and the portfolio view is just their sum, the deposit liability equals the deposits actually held, loan balances match the lender statements, and repairs and improvements sit in separate lanes so your CPA can make the capitalization calls from clean numbers. Then the monthly close keeps it that way — tagged at entry, reconciled monthly, never re-blurred.

The general fix sequence underneath steps six and seven — scope, structure, rebuild oldest-first, prove, lock — is the bookkeeping cleanup checklist; this guide adds the property dimension and the two rental-specific repairs. The pin-the-present discipline in step two is the behind-on-books triage, and the account-lane hygiene in step three is the chart of accounts template.

The honest section

DIY the untangle, or hand it off?

A single-owner portfolio of a few doors, records intact, blur mostly cosmetic — genuinely DIY. The test scopes it in an evening, the structure goes up in another, and the re-tag is a few disciplined weekends of unglamorous work this guide fully equips you for. If that's your file, run it yourself and put the fee toward the next roof.

Four things move it across the line. Deposits or loans that won't prove out — when the re-homed liability doesn't match what you actually hold, or loan balances won't tie to lender statements, the blur runs deeper than tags. A transaction volume that outruns your weekends — property management flows, short-term rental platforms, dozens of doors. Filed years on blurred numbers — the fix changes historical figures, your CPA needs to weigh in, and the books they'd weigh in on should be rebuilt professionally. Or trust-accounting stakes — if you hold other owners' funds as a manager, the standard isn't "tidy," it's fiduciary. That's cleanup work scoped as one fixed fee, and the per-property discipline afterward is exactly what real estate bookkeeping runs monthly.

Want the blur pile counted for you — and an honest read on which side of the line your file sits? The free assessment runs the test on your actual books.

Free books assessment

Rental cleanup FAQ · Updated July 2026

The questions landlords ask mid-untangle.

How do I clean up rental property books where everything is lumped together?

Structure first, history second. Build the property dimension — a class or location per property and a lean rental chart of accounts — and stop the blur going forward from today. Then work the history oldest-first: assign every transaction its property, re-home security deposits to a liability account, split mortgage payments into principal, interest, and escrow, and reconcile each month to its statement before touching the next. The order matters because re-tagging into a structure you haven't built yet is work you'll redo, and cleaning a file that's still blurring is a treadmill. Most single-owner portfolios can run this themselves over a few disciplined weekends; the honest handoff lines are below.

My security deposits were recorded as rent income — how do I fix that?

Re-home them, tenant by tenant, and prove the ending balance. Each deposit gets moved from income to a security-deposit liability account, dated when it was received, until the liability equals exactly what you currently hold across all tenants — a number you can verify against leases and move-in records. Expect the fix to change past-year income figures; if returns were filed on the overstated numbers, what to do about that is squarely your CPA's territory, and handing them a corrected, tenant-by-tenant schedule is what makes their answer fast. State rules on holding deposits — interest, separate accounts, return deadlines — belong with your attorney; the books' job is that the balance is right.

How do I split one bank account's history across multiple properties?

Retroactively, with tags rather than surgery: the transactions stay where they are, and each gets a class or location assigning it to its property as you work oldest-first through the history. Most transactions self-identify — the plumber's invoice has an address, the insurance policy names the property. The genuinely shared costs — software, a portfolio-wide policy, your mileage — get allocated by one written rule applied consistently, or held in a business-level lane rather than force-fitted. Going forward, the discipline is tagging at entry; whether you also want separate bank accounts per property is a control decision worth discussing with your CPA, not a bookkeeping requirement.

Mortgage payments were all booked as one expense — what's the fix?

Rebuild the split from the amortization schedule. Each payment divides three ways: principal, which reduces the loan liability and was never an expense; interest, which is the real cost; and escrow, which accumulates as an asset until the tax office or insurer is actually paid from it. Booked as one lump, your P&L has been overstating expenses while the balance sheet's loan balance drifted from reality. The lender's amortization schedule and monthly statements give you the exact three-way split for every payment, and the year-end loan statements anchor the totals — your CPA will be glad of both when the interest figure has to be defended.

Do I need separate QuickBooks files for each property, or classes in one file?

One file per legal entity, classes or locations per property inside it — that's the working rule. A file is an entity's books, so if all your properties sit in one LLC or in your own name, one file with a class per property gives you per-property P&Ls and a portfolio view without triple bookkeeping. Separate files become necessary when the properties genuinely sit in separate entities, because mixing entities in one file is a mess with legal consequences. Whether your portfolio should be one entity or several is an asset-protection and tax question for your attorney and CPA — decide it there, then make the books mirror it.

What should rental property books look like when the cleanup is done?

Four checks, all verifiable: every property's P&L stands on its own and the portfolio total is just their sum; the security-deposit liability equals, to the dollar, what you actually hold across tenants; every loan balance on the balance sheet matches the lender's statement; and repairs and improvements sit in separate lanes with the judgment calls documented, so capitalization decisions are your CPA's to make from clean numbers rather than reconstructed ones. If all four hold and every month is reconciled, the cleanup is genuinely done — and a monthly close keeps you from ever running it again.

Rather have the whole untangle run for a fixed fee — deposits proven, loans tied, every door's P&L real? That's bookkeeping cleanup, kept clean after by real estate bookkeeping. More guides: the guides hub →

Keep reading

The guides that pair with this one.

Bookkeeping cleanup checklist

The general fix sequence this guide builds on — scope, structure, rebuild oldest-first, prove every month, lock.

Keep reading

Signs your books need cleanup

The six mechanisms read early — before the blur pile is a year deep and the deposit liability is a mystery.

Keep reading