Consolidations 1: Forecasts Made Easy With All the Bells

09.10.24 10:34 PM By Caroline

Consolidations: Forecasts Made Easy - With all the Bells!

Written by Johnny Kipps, Forecast 5 UK

With Forecast 5, consolidating forecasts for your group is easy; the software does it all for you!


  • Currency conversion?  Forecast 5 handles this and produces the group consolidated forecast in your chosen base currency
  • Eliminate – or set off - intergroup loans?  Forecast 5 handles it. 
  • Complicated group structure with minority interests or associate interests in multiple companies?  Forecast 5 handles it all.

  • Eliminate intercompany profits and losses?  Forecast 5 handles it.

  • Parent company allocates overheads to be carried by subsidiaries?  Forecast 5 handles this.

Cashflow in scrabble letters on a bed of American Dollar Bills


We often wonder how we used to cope previously with all of these tricky situations when we tried to do this in a spreadsheet using multiple tabs and formulae that grew exponentially as we added more divisions, departments or subsidiaries. 


Consolidations of spreadsheets was accompanied by constant reworking of the formulae that may – or more often, did not - balance and all the other errors inherent in software not built for the job. Or just getting one’s mind around minority interests and goodwill was always an issue – at least for this scribe – but with Forecast 5 its amazingly easy.

Forecast 5 focusses exclusively on budgeting, forecasting and actuals. Sure, there are various add-ons to make the users’ life easier - like integrations with your favourite accounting or ERP to bring in opening balances and actual results automatically.

It does it well, all the way up from simple company forecasts to very complex group forecasts with multiple companies or even multiple levels of consolidations. 

And with each forecast, the software produces a balanced suite of forecast reports of 

Profit and Loss,

Balance Sheets,

Cashflows, and 

Funds Flows.

(and for the last, think “Statement of Cashflows” in IFRS or UK GAAP terms) for up to 15 years, and, after actuals, rolling forecasts and variance analyses for each of these reports!

Business Man measuring the weight of  coins on a  wooden scale for balance





These four reports are all in balance, proving the integrity of the financial model. And they prove the integrity of each subsidiary forecast, each consolidation and if there are multiple layers of consolidation, it proves the integrity of each layer through to the group consolidated forecast. 

Over the next few weeks, please look out for articles that cover how Forecast 5 deals with: 

  • Eliminating intercompany profits and losses and intercompany loans;
  • Multiple currencies in a group forecast
  • A parent or head office company allocating overheads to subsidiaries (this is not strictly a consolidation issue, but an issue in a group context, nevertheless);
  • Consolidations of companies with actual results (ie not simply budgets but the production of group variance analyses and group rolling forecasts);
  • Subsidiaries, branches and departments;
  • Minority & associate interests and treatment of impairment of goodwill.



If you’d like to see  the power of Forecast 5 for yourself, 
please download a free 21 day trial
Already using Forecast 5? Why not book a free demo with us
to make sure you're getting the most out of all the features!

Keep an eye out for the upcoming articles on Group Consolidations - being added shortly!

Consolidations 2: Group consolidated forecasts with multiple currencies & Eliminating intercompany profits, losses and loans.
Consolidations3Allocation-of-group-admin-amongst-subsidiaries
Consolidations 4:   Forecast 5 Handling of Minority and Associate Interests and Goodwill


Images by: Photo by Words as Pictures on StockSnap & Canva