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.

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

Connect your data

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

Convert actuals

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

Consolidate entities

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

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

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.

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.

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.

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.

FAQ

Feel free to contact us if you have other questions.

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.