Consolidation is a monthly workbook
Twenty entities exported, pasted into tabs, intercompany eliminated from memory, and a portfolio P&L produced by one person under time pressure at the end of the close.
ERP by industry
Real estate is the industry where entity count breaks the accounting system. One legal entity per property is normal, twenty entities is unremarkable, and consolidating them by hand every month is where most property companies spend their close.
Tell us your entity count and how you consolidate today. We will show you what continuous consolidation changes.
The problems
Almost all of these trace back to a structure where each property is its own entity and the accounting system was designed for one.
Twenty entities exported, pasted into tabs, intercompany eliminated from memory, and a portfolio P&L produced by one person under time pressure at the end of the close.
Net operating income by asset requires revenue, operating expense, and a consistent view of what counts as operating. Most portfolios compute it in Excel with a mapping that lives nowhere.
Common area maintenance recovery is reconciled once a year against estimates billed monthly, and tenants dispute it because the underlying detail is difficult to produce.
Each investor group wants a different pack on a different schedule, assembled by hand from the same data, with capital account balances maintained separately.
Management fees, shared services, and cash sweeps between related entities are recorded on both sides by hand and rarely agree exactly.
Whether a roof replacement is capitalised or expensed changes NOI, distributions, and covenant compliance, and the decision is made inconsistently across properties.
Where the money goes
A representative shape for a commercial portfolio. NOI sits above debt service, which is why it is the number lenders and buyers both anchor on.
Whether a major repair is capitalised or expensed changes NOI, which changes valuation, covenant headroom, and what can be distributed. Applied inconsistently across properties — which it usually is, because the decision is made property by property — it makes portfolio comparison unreliable in exactly the analysis it is most used for.
Your stack
Your property management system keeps handling leases, tenants, and maintenance. What changes is that the financial layer above it stops being manual.
Benchmarks
Drawn from our own engagements with property companies between $10M and $80M in revenue. The bar is a typical erp.io customer after two quarters; the marker is the segment median.
Most accounting systems handle one entity well, two acceptably, and nine badly. Real estate routinely runs twenty or more because lenders and investors require single-purpose entities, and that requirement is not negotiable.
The result is a portfolio whose financial picture only exists inside a spreadsheet, produced once a month, by one person, with intercompany eliminated from memory. It is correct and it is unauditable, and it is the single most common thing we replace in this industry.
When consolidation is a monthly exercise, the portfolio view is a month-end artefact and nobody asks about portfolio performance in week two because the answer would take two days to produce.
When it is continuous, the question becomes ordinary. That changes what gets asked — trailing twelve-month NOI by asset, expense variance across comparable properties, which assets are trending against underwriting — and those questions are where portfolio management actually happens.
Common area maintenance reconciliation is contested because tenants receive a summary and ask for the detail, and the detail requires reconstructing a year of expense allocation across a pro-rata share calculation that lives in a lease abstract.
Where operating expenses are coded to property and category as incurred, and pro-rata shares are held as data rather than in a lease document, the reconciliation computes itself and the supporting detail is available on request rather than on reconstruction. That alone substantially reduces the annual argument.
Capital accounts, preferred returns, waterfall distributions, and per-investor reporting are maintained in a spreadsheet in most property companies of this size, and the spreadsheet is the definitive record of what investors are owed.
Holding capital accounts and distribution waterfalls as data — with the agreement terms encoded rather than remembered — makes investor reporting a query and removes the single most consequential workbook in the business.
We are not a property management system. Lease administration, tenant portals, maintenance requests, and rent collection workflow belong in Yardi, AppFolio, MRI, or Buildium, and we integrate rather than compete. Companies whose primary requirement is property operations rather than portfolio finance should invest there first. We are also not a fund administration platform for complex multi-fund structures with institutional LPs.
Questions
Send your entity structure and how you consolidate today. We will show you what it is quietly plugging.