Consolidation Movements

Use the Insert New member function to create new Movement.

 

Movement Attributes

Choose an existing Movement (or while defining a new one), edit it and select from the available drop-down lists the proper attribute:

 

image103.jpg

 

 

> Calculated (Y/N)

If checked this Movement is calculated; it means you can't have data entry on it (e.g. Error)

Predefined Calculated Movement are locked on Movement Group and Translation Rate attribute.

 

> Movement Group

This property is mainly used for batch process to identify a subset of Movements. It is referred to the Movement property of being a

- Closure Mov : only CLO has this property

- Opening Mov : movements which is calculated at the re-opening of the period (only OPE and PAL have this property)

- Movement Mov : "Default" choice for Movements

- Conversion Difference Mov : Movements which are calculated during to translation process (only EDM and EDO have this property)

 

Basically any New Movement should be linked to the  "Movements" item, unless specific needs are required.

Each attribute must be chosen, differently the member can't be saved.

 

> Movement Translation Rates

This setting influences the Translation Step of the Consolidation Procedure. For additional details please refer to Consolidation Preliminary Calculation.

The Following choices are available :

 

> Closing Rate : it is the closing rate of the period

> Average Rate : it is the average rate of the period

> Spot Rate : it's a custom rate applicable to Movs that ordinary are being translated at average rate but occasionally (for some accounts only) must be differently treated. If you have no Movs with such property you can skip this.

> Previous Fiscal Year Average (on re-Opening)

> Previous Fiscal Closure (on re-Opening)

 

Movement Group Account Attributes

For each movement check the corresponding Account Group you want the Movement to be related with.

Sample : opening the Intangible Fixed Asset screen,  data entry is allowed on a subset of movements. The available movements are automatically pre-selected thanks to the relationship you define checking the column block Intangible Fixed Asset Flows.

 

image104.jpg

 

Check then all the Column blocks (representing different subsets of accounts) for which a given movement should be available for data entry of reporting purposes.

 

The Application provides standard movements on standard account groups, but both groups and movement can be added.

 

 

 

image39.jpgWhen completed click on the Confirm Button. A process is executed to spread the attributes from Movement Account Group Level at Account Level.

 

Template pre-defined Movements

The Following Movements are provided and linked to the related Movement Group Accounts :

 

Movement

Calc Y/N

Short Description

OPE Opening Balance

Y

It reports the Opening Balance (Closing Balances of the PFY). It is calculated in FY-reopening Process

PAL Profit Brought Forward

Y

It reports the retained earning calculation effect . It is calculated in FY-reopening Process

ADE Adjustement re-Opening and Edit

Y

It reports the automatic balances to close/reverse an Adjustment in the next FY

EDP PFY Exchange Rate Difference

Y

(not used yet) : its contribution is in EDM

EDM Exchange Rate Difference on Movements

Y

It reports the effect of the exchange rate difference between closing balance and movements balance. It si calculated in the L06 (Translation)

EDO Exchange Rate Difference on Opening

Y

It reports the effect of the exchange rate difference between closing balance and the opening balance. It si calculated in the L06 (Translation)

STM Short Term Movement

Y

It reports the variation for all balance sheet accounts where is not mandatory explain variation by movements (i.e. Payable, Receivable) .It is calculated in the preliminary calculation of the Consolidation Procedure.

DEC Decrease (-)

N

Available for Edit : suggested to be used for Elimination in Investment (L10-02) and Cash Flow Calculation

INC Increase (+)

N

Available for Edit : suggested to be used for Elimination in Investment (L10-02) and Cash Flow Calculation

OTH Other Changes (+/-)

N

Available for Edit : suggested to be used for Elimination in Investment (L10-02) and Cash Flow Calculation

EXI Exit from Conso Scope

Y

It reports the Closing balance of the Reporting Unit at EXIT method.It is calculated in the preliminary calculation of the Consolidation Procedure

DIV Dividends Paid

Y

It reports the dividend paid from subsidiaries to holding company.It is calculated in the L10-05

CCA Change in Consolidation Scope (Movements)

Y

It reports the change of ownership %s effect : it is calculated in the L09 Proportionalization

OCV Change in Consolidation Scope (Opening)

Y

It reports the change of ownership %s effect from PFY: it is calculated in the L09 Proportionalization

PRO Profit for the Period

Y

It  reports the result of the year as variation on Result account, it is calculated as difference between Revenue and Expense on Input and Adjustment Layers

ERR Error

Y

It bridges the gap between Closing Balance and Open+Movement Balances if any.It is calculated in the preliminary calculation of the Consolidation Procedure

CLO Closing Balance

Y/N

It reports the Closing Balances : it is regularly calculated or it can be manually edit

CTM 01 Custom 01

N

Available for Edit

CTM 02 Custom 02

N

Available for Edit