Consolidation

Consolidate entities and filter dimensions

Multiple entities and dimensions, with their many datasets and intertwined formulas, make Excel models explode with complexity. Rely on built-in functionality to organize your model by entities and dimensions.

Avoid the cognitive load that comes with 25+ tabs in Excel

Maintaining group consolidations or dimensional planning in Excel requires multiple data imports, extensive duplication, is prone to errors and wastes valuable time each month.

How it works

Organize models by entities and dimensions

Automated consolidation

Build a fully automated consolidation system for entities and dimensions across accounting systems.

Built-in templating

Deploy instances of your desired model structure to streamline modeling across entities.

Inter-comp eliminations

Create eliminations to account for inter-company transactions and avoid double-counting.

Currency conversion

Convert multinational entities into a unified currency for modeling and reporting purposes.

"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

Automated consolidation

Create a consolidation system that aggregates entities or dimensions. For multiple entities, unify general ledgers with custom mappings, while dimensions are automatically imported through integrations.

Integrated templating

Build and deploy templates to create individual plans across entities or dimensions. Templates ensure that your consolidation is always intact, as updates are automatically deployed to all instances of the template.

Inter-company eliminations

Manage all inter-company eliminations within your consolidation system, enabling you to analyze individual companies separately while keeping your consolidated results free of inflated figures.

Currency conversion

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

FAQ

Feel free to contact us if you have other questions.

How many integrations can I connect to?

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

What if my entities have different general ledger structures?

That's no problem. With mappings, you can synchronize 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 integrations 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 I use one dimension for multiple purposes?

That's no problem. You can customize how you wish to split dimension values so you can structure them to split for one purpose and then another.