Solved

Group Consolidation Year end Process

  • 28 June 2021
  • 6 replies
  • 537 views

Userlevel 3
Badge +5

Hi,

 

Do anyone know whether we need to run Year end accounting like - Clear cost revenue balances, Preliminary year end and final year end for Master company for Group consolidation?

 

If yes when it should be performed?

Is there any document for standard process around this?

 

Thanks

Gaurav

icon

Best answer by Gayathrie Thiruvalluvar 28 June 2021, 18:03

View original

This topic has been closed for comments

6 replies

Userlevel 5
Badge +9

Hi Gaurav,

 

Usually the master company for group consolidation is created as a container to run the consolidation flow only. [i.e. it is somewhat like a dummy company]

And no transactions are usually entered there.

 

Does your company enter any transactions [other than adjustment entries] in the master company?

 

Since such other transactions are not entered, there is no necessity in general to do any period closures, year ends or clearing of costs/revenues in the master company.

 

The F1 help for Group Consolidation provides some info on the general process and there is an IFS Academy course as well for Group Consolidation.

 

Best Regards,

Gayathrie

IFS Global Support

Userlevel 7
Badge +16

Hi, 
it depends on the way you are performing consolidation, I think, and the scope of reports you need to perform in Parent Company. And the IFS system version, as I know that consolidation feature has been improved recently.

If you want to report consolidated trial balance from your Parent company, you should close PnL accounts there - either by consolidation of year-end periods from children (assuming no entries are booked in Parent other than consolidation) or by regular year end-process (in this case you may consolidate regular periods only).

In my current installation, out consolidation parent is fully-functional and we need to perform regular year end there, and we are consolidating periods 1-12 only. We are in IFS v. 7.5.

 

Userlevel 3
Badge +5

Hi Gaurav,

 

Usually the master company for group consolidation is created as a container to run the consolidation flow only. [i.e. it is somewhat like a dummy company]

And no transactions are usually entered there.

 

Does your company enter any transactions [other than adjustment entries] in the master company?

 

Since such other transactions are not entered, there is no necessity in general to do any period closures, year ends or clearing of costs/revenues in the master company.

 

The F1 help for Group Consolidation provides some info on the general process and there is an IFS Academy course as well for Group Consolidation.

 

Best Regards,

Gayathrie

IFS Global Support

Hi Gayathrie ,

Thanks for quick update, yes we have only adjustment entries. :-)

Another question is, how effect of such adjustment entries can be seen in next year in Master company GL analysis? what will be opening balances for Master Company?

 

Thanks & Regards,

Gaurav  

Userlevel 5
Badge +9

Hi Gaurav,

 

Adjustment entries, in general, are only applicable for the specific reporting period they are entered.

That is the period entered here…

 

If you require those to be present in the consolidated results in other periods [within same year or subsequent years], you would need to reenter them or copy them manually into future periods.

 

[Note: some specific basic data setups can give alternative behaviours as well. What I mentioned above is the general behaviour]

 

Regarding opening balances for the master company

You need to have an active consolidation structure and a balance version for the year opening period in the Consolidation Status window and consolidated balances should also exist for the last period of the previous year.

Then using the right mouse button option "Update Opening Balances" in the Consolidation Status window, opening balances can be updated.

To move the profit/loss in the process of updating opening balances, you need to setup relevant code strings in the Consolidation Opening Balance Update Rule window.

The F1 help related to "Update Opening Balances" will give more details on these. You can reach the F1 help related to this topic by clicking F1 while being in the Consolidation Opening Balance Update Rule window and then going to the Update Opening Balances option under Activities in that web page.

 

Hope this helps!

 

Best regards,

Gayathrie

IFS Global Support

Userlevel 5
Badge +9

Hi, 
it depends on the way you are performing consolidation, I think, and the scope of reports you need to perform in Parent Company. And the IFS system version, as I know that consolidation feature has been improved recently.

If you want to report consolidated trial balance from your Parent company, you should close PnL accounts there - either by consolidation of year-end periods from children (assuming no entries are booked in Parent other than consolidation) or by regular year end-process (in this case you may consolidate regular periods only).

In my current installation, out consolidation parent is fully-functional and we need to perform regular year end there, and we are consolidating periods 1-12 only. We are in IFS v. 7.5.

 

Hi Adam,

 

As you have mentioned, the Consolidation function in IFS has evolved and from the IFSApplication9 version onwards, a more comprehensive consolidation functionality has been introduced and it is now referred to as IFS Group Consolidation.

 

Best regards,

Gayathrie

IFS Global Support

Userlevel 3
Badge +5

Hi Gaurav,

 

Adjustment entries, in general, are only applicable for the specific reporting period they are entered.

That is the period entered here…

 

If you require those to be present in the consolidated results in other periods [within same year or subsequent years], you would need to reenter them or copy them manually into future periods.

 

[Note: some specific basic data setups can give alternative behaviours as well. What I mentioned above is the general behaviour]

 

Regarding opening balances for the master company

You need to have an active consolidation structure and a balance version for the year opening period in the Consolidation Status window and consolidated balances should also exist for the last period of the previous year.

Then using the right mouse button option "Update Opening Balances" in the Consolidation Status window, opening balances can be updated.

To move the profit/loss in the process of updating opening balances, you need to setup relevant code strings in the Consolidation Opening Balance Update Rule window.

The F1 help related to "Update Opening Balances" will give more details on these. You can reach the F1 help related to this topic by clicking F1 while being in the Consolidation Opening Balance Update Rule window and then going to the Update Opening Balances option under Activities in that web page.

 

Hope this helps!

 

Best regards,

Gayathrie

IFS Global Support

Thanks Gayathire for your support and help.

 

Regards,

Gaurav