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:
> 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.
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.
When
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 |