Synchronising the Operational Chart of Account

The actual Operational Chart of Accounts (FIN OCoA) is only updated when it is synchronised with the staging Operational Chart of Accounts. The chart of accounts can only be synchronised when the compulsory Fixed Accounts have been mapped to an account in the Management Trial Balance.

Synchronising the Chart of Account

The Operational Chart of Account can synchronise using the Sync Dimension button on the Administration > Chart of Account > Operational CoA tab. When the actual Operational Chart of Account is not the same as the staging Operational CoA the Sync Dimension button will be Orange. Synchronising the actual and staging Operational CoA will turn the Sync Dimension button green.

Click on the Sync Dimension to open the popup. It can take a few seconds while an update of the mandatory flag attributes happens in the background.

image-20240228-053511.png
Sync Dimension

Rebuild option:

  • Incremental Update: Only add new accounts. Existing rollups will not be changed. No elements will be deleted from the actual Operational CoA (FIN OCoA).

  • Uwind: This is the default option. The parent-child relationships between elements will be broken, then reconstructed based on the mapping changes you have made in the staging Operational CoA. If you have deleted accounts in the staging Operational CoA, they will persist in the actual Operational CoA as orphan element in the dimension. This allow the ability correct account mapping back into the account structure without losing any data.

  • Delete all elements: Use this option only if you intentionally want to deleted elements from the actual Operational CoA. Make sure that the content of the staging dimension is up to date. That data associated with the delete element is also deleted.

Update Hierarchies will reconstruct the technical rollups used by Apliqo FPM. This option should be set to Yes.

Override Element Type allow for the change of element type. Changing a N-type element to C-Type element could lead to loss of data. This option should be set to No, unless you know the impact of the change.

Delete Empty Consolidations will delete C-type elements that have no components. This reduces the actual Operational CoA to only include consolidations that have natural accounts. While maintaining a full Management Trial Balance in the staging Operational CoA.

Automating the Synchronisation of the Operational CoA.

The synchronisation can be automated in the Automation tab.

image-20240228-071554.png
Click for a guided walkthrough.

Â