How to Clean Up Messy Books for a Real Estate Portfolio

Every acquisition adds a new entity. Every entity adds a new set of books. For owners running a real estate portfolio of five, ten, or 50 properties, cleaning up messy books becomes urgent once the balance sheet outgrows the accounting function behind it.

Intercompany loans pile up between entities, reconciliations fall behind, and by the time an audit, a sale, or a lender request arrives, nobody is fully certain what the numbers actually show.

This isn’t a sign of poor management; it’s a natural result of growth. But it does mean the general ledger deserves a health check before it becomes a liability.

Key Takeaways

• Owners of multi-entity real estate portfolios should confirm the last period is fully reconciled across every entity before assuming their books are accurate.
• Intercompany loans between related entities often diverge over time because interest accrues or payments are posted inconsistently on only one side.
• Fixed asset registers and depreciation schedules need to reflect actual placed-in-service dates to hold up under audit or lender due diligence.
• A books cleanup should be scoped by the number of entities, accounts, and prior years involved before any remediation work begins.
• The objective behind a cleanup, whether audit readiness, a pending sale, or ongoing stabilization, determines which deliverables and timeline are appropriate.
• Assigning clear ownership of monthly reconciliations and intercompany agreements after a cleanup prevents the same issues from resurfacing.

What Are the Warning Signs Your Books Need a Cleanup?

A few questions reveal how much attention the books need:

• What is the last period that was fully reconciled across every entity?
• Are all entities using the same chart of accounts and accounting policies, or has each property developed its own?
• Is data moving between the property management system and the general ledger through a clean integration, or through manual uploads and offline spreadsheets?
• Do beginning balances tie to prior-year ending balances, entity by entity?

If any of these are hard to answer with confidence, the portfolio likely has legacy issues sitting quietly on the balance sheet.

Where Real Estate Portfolios Go Wrong

Certain accounts create disproportionate risk for owners with multiple properties and related entities.

Intercompany and Related-Party Balances

When one entity lends to another, both parties to the loan must agree, a fact that is drawing increasing IRS scrutiny of intercompany loan terms in real estate structures. In practice, the note payable on one entity’s books and the note receivable on the other often diverge over time as interest accrues differently, payments post inconsistently, or one side falls behind. Interest charged on these loans should also be calculated using the IRS’s Applicable Federal Rates to withstand scrutiny. Left uncorrected, this becomes one of the most time-consuming issues to unwind.

Fixed Assets

Depreciation schedules and asset registers should reflect what the organization actually owns and when it was placed in service. Missing or outdated registers make it difficult to support depreciation expense or respond to due diligence requests.

Cash

Long-outstanding reconciling items, whether unrecorded transfers or stale checks, quietly distort cash balances across all entities that share a bank relationship and could trigger unclaimed property due diligence and reporting requirements.

Revenue and Leasing

Rent rolls, tenant billings, and lease-related adjustments need to tie back to the general ledger. Gaps here affect both reported income and lender or investor confidence.

Equity

Capital contributions and distributions across multiple partners or investors must be tracked accurately at the entity level, particularly when ownership structures vary by property.

How Do You Scope a Books Cleanup for a Real Estate Portfolio?

A cleanup that starts without a clear scope tends to run long and cost more than expected. Before any remediation begins, it helps to size the effort:

• How many entities, accounts, and prior years actually need attention?
• What documentation exists, consistent with IRS recordkeeping requirements, including bank statements, loan agreements, intercompany schedules, and prior audits, and what is missing?
• What is the actual objective? Audit readiness, a pending sale, or simply stabilizing the books for ongoing operations each call for different deliverables and timelines.

Owners who answer these questions upfront avoid the common trap of an open-ended engagement with no defined endpoint.

Build for the Long Term

A cleanup that is not paired with process improvement tends to repeat itself. Once the books are current, define who owns monthly reconciliations, how intercompany activity gets recorded and agreed between entities, and what documentation new team members will need to keep things on track.

For owners managing multiple properties, entities, and intercompany relationships, clean books are not a one-time project. They are the foundation for every audit, financing decision, and eventual sale. Taking stock of where things stand today is the first step toward keeping it that way.

Not sure where your books stand today? A quick general ledger assessment can show you exactly which entities, accounts, and years need attention before an audit, sale, or lender request forces the question. Connect with our team using the form below to get started.