Multi-Entity Financial Consolidation Without Enterprise Pricing

The Consolidation Gap Nobody Talks About

There’s a moment in every growing company’s life when the CEO asks: “How much money do we actually have — across all our entities?”

If you have one company in one country, the answer is in your accounting software. If you have two entities — say a US LLC and a UK Ltd — the answer is in two separate accounting systems, two different charts of accounts, two currencies, and probably a spreadsheet that someone updates monthly. If you have three or more entities, the answer is “we’ll get back to you in two weeks.”

This is the consolidation gap. On one side, you have QuickBooks and Xero, which handle single-entity bookkeeping well but cannot consolidate multiple entities. On the other side, you have NetSuite and SAP, which handle consolidation perfectly but cost $25,000-$100,000 per year and take months to implement.

In between? Almost nothing. Until now.

What Financial Consolidation Actually Requires

Let’s be precise about what “consolidation” means, because it’s not just adding numbers together.

Combined financial statements

At the simplest level, you need to see the financial position of your entire group — total revenue, total expenses, total assets, total liabilities — as if all your entities were one company. This requires:

• A unified chart of accounts: Each entity may use a different local chart (PGC in Spain, PCG in France, SKR04 in Germany, US GAAP in the US, FRS 102 in the UK). Consolidation requires mapping each local account to a group-level structure
• Common currency: If your Spanish entity reports in EUR, your US entity in USD, and your UK entity in GBP, you need currency translation rules
• Common accounting period: All entities must be reporting for the same period. If your US entity has a January fiscal year-end and your UK entity has a March year-end, you need alignment

Intercompany eliminations

This is where things get interesting — and where spreadsheets break down.

When Entity A sells services to Entity B, Entity A records revenue and Entity B records an expense. From each entity’s perspective, these are real transactions. From the group’s perspective, money just moved from one pocket to another. If you don’t eliminate these intercompany transactions, you double-count revenue and expenses.

Common intercompany transactions that need elimination:

• Sales between entities: Parent sells goods to subsidiary, or subsidiary provides services to parent
• Management fees: Headquarters charges subsidiaries for shared services
• Intercompany loans: One entity lends to another — the loan receivable and loan payable must net to zero at group level
• Dividends: Subsidiary pays dividend to parent — this is income for the parent but not for the group
• Intellectual property royalties: Subsidiary pays parent for use of IP

Each of these requires a specific elimination journal entry in the consolidated accounts. Miss one, and your consolidated P&L or balance sheet is wrong.

Currency translation (IAS 21)

If your entities operate in different currencies, you need to translate their financials into the group reporting currency. IAS 21 (The Effects of Changes in Foreign Exchange Rates) prescribes the method:

• Balance sheet items (assets, liabilities): translated at the closing rate (exchange rate on the reporting date)
• Income statement items (revenue, expenses): translated at the average rate for the period (or the rate on the transaction date, if practical)
• Equity items: translated at historical rates (the rate when the equity was originally recorded)
• Translation differences: The difference between translating the balance sheet at closing rates and the income statement at average rates creates a foreign currency translation reserve in equity

Getting this wrong doesn’t just produce inaccurate numbers — it can create phantom gains or losses that mislead stakeholders and complicate tax planning.

Minority interests

If you own less than 100% of a subsidiary, you need to calculate and present the non-controlling interest (NCI) — the portion of equity and profit that belongs to outside shareholders. This appears as a separate line in both the consolidated balance sheet and the income statement.

Why Spreadsheets Break

Most mid-market companies start their consolidation journey in Excel. It works for a while — until it doesn’t. Here’s where it fails:

Version control: Three people working on the consolidation spreadsheet simultaneously. Which version is current? Who changed cell G47?

Intercompany matching: Entity A says it owes Entity B $50,000. Entity B says it’s owed $48,500. The difference is an FX timing issue, a disputed invoice, or a data entry error. Finding it in a spreadsheet takes hours.

Currency translation errors: Manually applying exchange rates to hundreds of line items, maintaining historical rates for equity, calculating the translation reserve — one wrong rate and the entire balance sheet is off.

Audit trail: An auditor asks “where did this number come from?” In a spreadsheet, the answer is a trail of cell references that may or may not trace back to source data. In an ERP, the answer is a click.

Time: Companies with 3-5 entities typically spend 5-10 days on monthly consolidation in spreadsheets. That’s 5-10 days of stale numbers before anyone can make a decision.

What Enterprise ERPs Charge for Consolidation

The enterprise solutions work. They’ve been doing consolidation for decades. But the economics are brutal for mid-market companies:

Estimates based on mid-market implementations (3-10 entities). Prices vary significantly by configuration.

A 50-person company with three entities doesn’t have $75,000 for year one of an ERP. But it absolutely needs consolidated financials. This is the gap.

How Odiverse Solves Consolidation at SME Pricing

Odiverse was designed with multi-entity in mind from day one — not as an add-on module, but as a core architectural principle.

Multi-entity by design

Every Odiverse instance supports multiple companies through a UserCompany junction table — users can belong to multiple entities with different roles in each. A parent company has a parent_company_id FK linking subsidiaries. Switching between entities is one click in the sidebar.

This means:

• One login, multiple companies: A CFO sees all entities in one interface
• Per-entity permissions: An accountant in the Spanish entity doesn’t need access to the US entity’s data
• Per-entity compliance: Each entity uses its local chart of accounts, tax rules, and e-invoicing format
• Group-level reporting: Consolidation pulls from all entities automatically

Consolidated reports

Odiverse generates three consolidated reports:

• Consolidated Trial Balance: All accounts from all entities, mapped to a group chart of accounts, with intercompany eliminations applied
• Consolidated Profit & Loss: Group revenue and expenses, with intercompany sales eliminated and currency translation applied
• Consolidated Balance Sheet: Group assets, liabilities, and equity, with intercompany loans eliminated and translation reserves calculated

These aren’t exported-to-spreadsheet reports. They’re live, queryable, and drill-down-capable. Click a consolidated revenue line and see the breakdown by entity, by currency, by original local account.

Currency translation per IAS 21

Odiverse maintains an ExchangeRate model with daily rates. Consolidation applies:

• Closing rate for balance sheet items
• Average rate for income statement items
• Historical rate for equity
• Automatic translation reserve calculation

You don’t manage exchange rate tables manually. Rates are fetched, stored, and applied. The CFO sees consolidated numbers in the group currency; the local accountant sees numbers in the local currency. Both are correct.

Intercompany transaction detection

Odiverse automatically identifies transactions between group entities based on counterparty matching. When Entity A invoices Entity B, the system flags it as intercompany. At consolidation, these transactions are eliminated — revenue and cost of sales, receivables and payables, loans and borrowings.

The elimination entries are generated automatically and visible in the consolidated audit trail. No manual journal entries. No spreadsheet formulas.

Country-specific compliance per entity

This is where Odiverse differs from every spreadsheet and most enterprise ERPs. Each entity in the group gets:

• Local chart of accounts: PGC (Spain), PCG (France), SKR04 (Germany), SNC (Portugal), FRS 102 (UK/Ireland), US GAAP (US)
• Local tax engine: VAT/IVA rates, corporate tax rules, payroll calculations — all country-specific
• Local e-invoicing: VeriFactu (Spain), Factur-X (France), XRechnung/ZUGFeRD (Germany), SDI (Italy) — each entity complies with its own country’s mandate
• Local language: The Spanish entity’s accountant works in Spanish, the German entity’s in German, the US entity’s in English — all in the same system

What this costs

Starting at €79/month per entity (Growth plan). No implementation fee. No consultants. No 6-month project.

Compare that to NetSuite at $25,000+/year plus $50,000+ implementation.

Who This Is For

Odiverse’s consolidation isn’t for a 50,000-person multinational with 200 subsidiaries. It’s for:

• The Spanish company that opened a US subsidiary: 2 entities, 2 currencies, 2 tax regimes. Needs consolidated group reporting without deploying SAP
• The UK startup expanding into Ireland and Germany: 3 entities, mixed currencies. The CEO needs to see total cash and total burn across all three
• The Mexican group with a Brazilian subsidiary: Needs consolidated financials in MXN while each entity reports locally
• The French company with a Portuguese branch: Needs group P&L in EUR with proper FX translation for the Portuguese entity
• The Canadian company with US operations: 2 entities, CAD/USD, different GAAP. Board wants consolidated reporting

If you have 2-20 entities across 1-11 countries and need consolidated financials without spending six figures, this is built for you.

Migration Path: From Spreadsheet to Consolidated ERP

Week 1: Set up the group structure

• Create each entity in Odiverse with its country, currency, and chart of accounts
• Link subsidiaries to the parent company
• Set up user access with per-entity roles

Week 2: Import data per entity

• Import chart of accounts (or use the country-specific default)
• Import contacts, open invoices, and bank balances
• Connect bank accounts via Open Banking

Week 3: Run parallel

• Process one month of transactions in both your current system and Odiverse
• Generate consolidated reports and compare to your current spreadsheet
• Verify intercompany eliminations and currency translation

Week 4: Go live

• Switch to Odiverse as the primary system for all entities
• Decommission the spreadsheet

Total time: one month. Total cost: the monthly subscription. No consultants, no implementation project, no PowerPoint decks about “change management.”

The Bottom Line

Financial consolidation is not an enterprise-only need. Any company with two or more entities needs it. The question has always been cost — and until recently, the answer was “spend enterprise money or use spreadsheets.”

Odiverse changes that equation. Enterprise-grade consolidation — IAS 21 translation, intercompany eliminations, multi-country compliance, real-time reporting — at a price that makes sense for a 30-person company with offices in two countries.

Your group is more than the sum of its entities. Your reporting should reflect that.

See how Odiverse consolidation works or join the waitlist to start consolidating across your entities. For background on multi-country e-invoicing compliance, read our E-Invoicing in Europe 2026-2030 guide.