Overview
To consolidate actuals across multiple legal entities, begin by connecting each entity’s accounting system. This process lets you automatically pull financial data from each source and unify your general ledger accounts for consolidated reporting.Basics
Connect your accounting systems
To link Francis with your accounting system, go to Settings > Organization > Integrations. This page displays all available options, including these five native integrations:- Visma e-conomic
- Microsoft Dynamics 365 Business Central
- Intuit Quickbooks Online
- Oracle Netsuite
- Xero
If multiple entities use the same accounting system, repeat the connection steps for each one. For certain systems, having the correct entity already selected in another browser tab before you start the connection process can make set-up easier.
Non-supported systems
When an entity’s accounting system isn’t supported by Francis’ native integrations, you can still bring in actuals through one of these methods:- Google Sheets Integration: Import trial balances (or detailed transactions, if desired) using our Google Sheets integration. This method reduces manual input errors, supports larger data sets, and allows you to drill down into individual transactions, which is especially helpful for variance analysis.
- Manual entry: Copy and paste or directly input monthly aggregates into your financial model. This approach is best for very small volumes of data, as there is no ability to import individual transactions or leverage drill-down features.