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.
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.
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.
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.
That's no problem. With mappings, you can synchronize multiple general ledgers to your financial model, unifying all general ledgers.
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.
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.
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.
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.
Still reading? Start building.
Connect your business data in less than 5 minutes.