Bringing 20+ Real Estate Entities Under One Roof — QuickBooks Online to NetSuite

Client Snapshot

Industry: Real Estate Development & Construction Structure: 20+ subsidiaries organized into multiple project clusters (3–5 entities per project) Previous System: QuickBooks Online (separate files per entity) Solution Delivered: Oracle NetSuite implementation with multi-entity consolidation, project-level reporting, and intercompany automation

---

The Challenge: Growth That Outpaced the Accounting System

Our client, a fast-growing real estate construction group, had built its business the way most successful developers do — one project at a time. Each new development was structured as its own cluster of legal entities: a holding company, a land-owning entity, a construction entity, and in some cases financing and property management subsidiaries. Over time, this disciplined legal structuring produced more than twenty active companies spread across multiple concurrent projects.

The legal structure was sound. The accounting infrastructure was not.

Every entity lived in its own QuickBooks Online file. What worked well for a single project became a serious operational burden at scale. Month-end close meant logging in and out of more than twenty separate QBO instances. Consolidated financials were assembled manually in spreadsheets, with finance staff exporting trial balances, mapping charts of accounts that had drifted apart over the years, and reconciling intercompany balances by hand. A group-level P&L that should have taken hours took weeks — and by the time it was finished, the numbers were already stale.

The pain points compounded across every layer of the organization. Leadership had no real-time view of performance across the portfolio, and answering a simple question like “how profitable is Project X across all of its entities?” required a manual consolidation exercise. Intercompany transactions — loans between the holding company and project entities, shared payroll and overhead allocations, cross-entity construction billing — were recorded inconsistently and frequently failed to eliminate cleanly at consolidation. Each QBO file had its own chart of accounts, so nothing rolled up without extensive remapping. And as the group prepared for larger financing rounds, lenders and investors began asking for consolidated statements the business simply couldn’t produce quickly or confidently.

The group wasn’t suffering from bad bookkeeping. It was suffering from a system architecture that was never designed for a multi-entity, multi-project business.

Our Approach: Structure First, Software Second

We’ve learned that ERP migrations fail when they simply replicate the old mess in a new system. So before a single record was migrated, we worked with the client’s leadership and finance team to design the right organizational architecture inside NetSuite.

Entity and hierarchy design. We mapped all 20+ subsidiaries into NetSuite’s native multi-subsidiary structure, mirroring the legal ownership tree while grouping entities under their project clusters. For the first time, the system reflected how the business actually operates — projects as the unit of management, entities as the unit of legal ownership — instead of forcing the team to mentally reconstruct that picture from disconnected files.

A unified chart of accounts. We rationalized more than twenty divergent charts of accounts into a single, standardized group chart. Combined with NetSuite’s segmentation — subsidiary, class, department, and location dimensions — the client could now slice results by legal entity, by project cluster, by cost category, or by the entire group, all from one dataset.

Project-level visibility built in. Using custom segments and project records, we configured reporting so every transaction carries its project identity. Construction costs, land carrying costs, financing charges, and revenue now roll up to the project level automatically — no exports, no spreadsheets, no remapping.

Intercompany automation. We implemented NetSuite’s intercompany framework so that loans, management fees, shared services allocations, and cross-entity billings post to both entities simultaneously with matching elimination entries. What was previously the single largest source of consolidation errors became a controlled, automated process.

Clean, validated migration. We migrated historical balances and open transactions from all QBO files, reconciling each entity’s trial balance before and after cutover. The client went live with clean opening balances, verified intercompany positions, and full comparability to prior-period figures.

Enablement, not just implementation. We trained the finance team on the new close process, built role-based dashboards for executives, project managers, and accountants, and supported the first several month-end closes hands-on until the team was fully self-sufficient.

The Results: From Spreadsheet Chaos to Real-Time Clarity

The transformation was visible from the very first consolidated close in NetSuite.

Consolidation went from weeks to the push of a button. Group financial statements — with automated intercompany eliminations and multi-level roll-ups by project cluster — are now generated in real time. The month-end close cycle shrank from several weeks of manual assembly to a matter of days, with the consolidation step itself reduced to minutes.

Leadership finally sees the whole business. Executive dashboards show group performance, project-cluster profitability, cash positions across all entities, and budget-versus-actual on every active development — live, in one login, instead of twenty.

Every project has a true P&L. Because every transaction is tagged to its project, management can evaluate the full economics of each development across all of its subsidiaries — land, construction, financing, and operations combined. Underperforming projects surface early; capital allocation decisions are made on current data rather than month-old spreadsheets.

Intercompany balances reconcile by design. Automated intercompany journals and eliminations removed the recurring reconciliation headaches that had plagued every close, dramatically reducing audit adjustments and restatement risk.

The group is now finance-ready. With auditable, consolidated statements available on demand, conversations with lenders, investors, and auditors changed completely. What used to be a scramble is now a standard report.

Scalability is built in. When the client launches a new project, its entities are added to the existing structure in hours — inheriting the group chart of accounts, reporting dimensions, and intercompany rules from day one. The accounting system now grows with the business instead of holding it back.

Why It Worked

Multi-entity real estate and construction groups have a specific set of problems: layered legal structures, project-centric economics, heavy intercompany activity, and stakeholders who demand consolidated numbers. Solving them takes more than installing new software — it takes a partner who understands how to translate a complex legal and operational structure into a system architecture that makes the business easier to run, not just easier to record.

That’s the expertise we brought to this engagement: deep NetSuite implementation experience combined with real-world understanding of how real estate developers structure, finance, and manage their projects.