Consolidations 2: Intercompany profits & losses and loans

11.03.25 12:15 AM By Caroline

Consolidations with Forecast 5: Eliminating intercompany profits, losses and loans

This is the 2nd in a series of articles on Group Consolidated Forecast, written by Johnny Kipps, Forecast 5 UK

One of the keys to a group consolidated forecast is the ability to eliminate intercompany profits and set off intercompany loans.

Clearly when delivering a consolidated forecast to the board it's important that intercompany profits and losses have been eliminated. These profits and losses 

are internal to the group and as such if they were included the group P&L would present a misleading picture of the group’s results and prospects.

In the same way, loans between group companies are not with external parties, and as such have no place in the group consolidated forecast and must be eliminated.


In Forecast 5 each individual line of business, be they of revenues, direct costs, overheads, assets, liabilities or equity are held in separate 'records'.

This makes it easy when preparing a group forecast as across the group companies those 'records' that hold intercompany income and expenses are separately identified and upon consolidation the user simply ticks off the relevant intercompany records in the consolidated P&L to effect the elimination.

Similarly, Forecast 5 will set off and eliminate those records on the balance sheet with identical names – ie, “Intercompany loan – Coy A - Coy B”.


And that’s it; intercompany profits and losses and intercompany loans are eliminated.

Forecast 5 makes the preparation of group consolidated forecasts simple!


If you aren't a signed customer yet, and would like to see for yourself the power of Forecast 5, please go ahead and download a  FREE 21 DAY TRIAL

If you are a current customer and would like a personalised demo of how we can enhance your experience with Forecast 5 then let's SCHEDULE A DEMO

You can read more in our series Group Consolidated Forecasts:


Coming next.....

Consolidations 4: Actual results in Group Consolidated Forecasts
Consolidations 5:  Allocation of Group admin amongst subsidiaries
Consolidations 6: Forecast 5 handling of Minority and Associate Interests and Goodwill