Multi-entity consolidation

Consolidate all your entities

Connect data and manage plans for all your entities in one model. Automatically consolidate and account for inter-company transactions.

Financial consolidation dashboard showing sheets for UK, US, and DK regions, with department breakdowns like Marketing, Sales, Operations, Admin, and Customer Success, and a consolidated profit and loss (P&L) statement for January 2024.

Entity consolidations make Excel models explode with complexity

Managing multiple general ledger imports, currency conversions, and consolidations can quickly become unmanageable. Automate it to focus on more valuable activities.

How it works

Everything you need to consolidate

Icon of a database with a lightning bolt, symbolizing fast or high-performance data storage or processing.

Connect your data

Connect data from all your subsidiaries, even if they're using different accounting systems.

Euro currency symbol icon representing financial data or transactions related to the Euro.

Convert actuals

Streamline actuals from all entities into one unified currency for modeling and reporting purposes.

Icon representing a structured layout with a top section and two smaller sections below, symbolizing consolidation.

Consolidate entities

Build a financial model and unify your general ledgers across entities to automate your consolidation.

Icon featuring a plus sign above a horizontal line, symbolizing balance, adjustment, or margin of error.

Inter-comp eliminations

Account for internal purchases within a structured system to ensure accurate group consolidation.

"It's next level. We're consolidating nine entities, including inter-company transactions, which would not have been feasible in Excel."

Mia Lysemose, Finance Manager at ÅBEN Brewery

Read story
Icon of a database with a lightning bolt, symbolizing fast or high-performance data storage or processing.

Connect your data

Connect your accounting systems to automatically import actuals. Francis allows you to connect different accounting systems while still being able to consolidate actuals across entities.

Integrations
QuickBooks Online integration settings dashboard showing options to connect multiple QuickBooks accounts. The interface displays three connected accounts: Acme Inc., Acme Corp., and Acme UK Corp., with sync statuses ranging from 3 hours ago to 31 days ago. The settings menu includes sections for General, Plans, Members, and Data sources.
Euro currency symbol icon representing financial data or transactions related to the Euro.

Convert actuals

Define custom exchange rates and convert actuals from your systems into a unified group currency for modeling and reporting purposes, allowing you to continue bookkeeping in local currencies.

Diagram showing a financial model for 'Acme Group' with three entities: Acme ApS (EUR), Acme Ltd. (GBP), and Acme Inc. (YEN), displaying custom exchange rates for multiple currencies, including USD, EUR, GBP, and YEN. The image represents multi-entity financial consolidation with currency conversions for international operations.
Icon representing a structured layout with a top section and two smaller sections below, symbolizing consolidation.

Consolidate entities

Once you've connected your systems, general ledgers for each entity will be available, allowing you to define custom mappings between your connected systems and your financial model.

Consolidation
Dashboard showing consolidation structure for multiple regions (UK, US, DK) and departments like Marketing, Sales, and Operations. The right side displays balance sheet and cash flow sections. A notification indicates that all accounting systems were synced two minutes ago, with a green integration status shown at the bottom.
Icon featuring a plus sign above a horizontal line, symbolizing balance, adjustment, or margin of error.

Inter-company eliminations

Manage all inter-company eliminations as an integrated part of your consolidation system, allowing you to analyze individual companies, while keeping your group consolidation free of inflated numbers.

Modeling
Financial consolidation dashboard for Francis Inc., showing sheets for various business units, including UK, US, and internal departments such as Marketing, Sales, Operations, and Admin. The P&L section highlights revenue and direct costs, including internal sales and purchases, with eliminations applied to avoid double counting.

FAQ

Feel free to contact us if you have other questions.

Contact
How many integrations can I connect to?

You can connect to as many data sources as you like. Your number of active connections may impact your pricing; please see our plans for more information.

What if my entities/subsidiaries have different general ledger structures?

That's no problem. With mappings, you can map multiple general ledgers to your financial model, unifying all general ledgers.

What if one of my accounting systems is not supported?

If one of your accounting systems is unsupported, we recommend importing the data via a Google Sheets connection or manually copy-pasting the data into the Francis sheet. That way, you can automate part of your data imports and import the rest manually but in a structured way. Please also let us know at support@francis.app. We appreciate input on what connections to build next.

What are the benefits of consolidating in Francis rather than Excel?

In Excel, consolidations are created using formulas, which are highly susceptible to breaking. In Francis, built-in features ensure that the consolidation and data imports are always intact.

What if my entities have different currencies?

If your entities have different base currencies, you can convert all entities to the same currency at the time of import. You specify the exchange rates yourself.

What if some of my entities are holding companies with limited activity?

In that case, we might be able to help with pricing. Please reach out to us at support@francis.app to discuss this.

Still reading? Start building.

Connect your business data in less than 5 minutes.

Get started
Schedule demo ->