You can create a consolidation for multiple organisations, even if they use different currencies or integrate with different accounting software. The consolidated organisation will feature a seamless Chart of Accounts and automated inter-company eliminations.
This is ideal for managing national or regional groups, franchises, and complex business structures.
Step 1 - Create a new consolidation
When logged into Futrli, click the organisation name in the top-right corner of the window.
Click Manage Organisations.
Click the Consolidations tab.
Click Add new consolidation.
Step 2 - Add organisations to the consolidation
Within the Consolidation settings box:
Enter a Consolidation name
Select the Financial year end
Select the Presentation currency, for example, British pound
You have a list of available entities to add to your consolidation. You can see their name, year end, and currency.
Click and drag the relevant entities across to Consolidated entities.
To continue, click Next.
After you add the entity, this creates a short code automatically based on the entity name:
This code will show on consolidated forecasts and reports to help you identify the organisations.
You can edit the code straight away, or later from the consolidation settings.
Step 3 - Eliminate accounts
Select whether you need to eliminate any accounts from the consolidation.
📎NOTE: If you don't need to eliminate any accounts., click No, take me to the next step, click Next then skip to Step 4 - Select a reporting structure in this guide
Click Yes, I have account eliminations, click Next.
A list of your available accounts displays as clickable dropdowns. Click them to expand them and see the individual accounts.
Click Create new group to create a group to categorise the eliminated accounts.
Click and drag the relevant accounts across to your elimination groups.
After you eliminate the relevant accounts, click Next.
📌TIP: You can edit and eliminate accounts later from the consolidation settings.
Step 4 - Select a reporting structure
Select a reporting structure for your consolidation. Every report, budget, forecast, and scenario will mirror the structure you select.
When you're done, click Next.
Step 5 - Review FX rates
📎NOTE: This step only appears if the organisations you're consolidating have different currencies.
You see the FX rates that will apply. There are different tabs for each currency, for example, USD.
📌TIP: Click Edit daily FX rates if there's a rate on a date that you want to amend.
To finish, click Next.
A message appears stating the consolidation is being created. When complete, you're taken to the Home page of the consolidated organisation. You can now switch between the organisations and the consolidation.
Just like your organisations, the consolidated organisation appears as an option to switch to.
📌TIP: You can make changes to the consolidated organisation anytime, just click Consolidation Settings. If you no longer want the consolidated organisation, you can delete it.