The Planning Chart of Accounts (CoA) is distinct from the Operational Chart of Accounts. While the Operational CoA serves management reporting and analysis purposes, the Planning CoA is specifically designed for financial planning.
Building the Planning Chart of Accounts
The Planning CoA is derived from the Operational CoA. Any level in the chart of account can be set as the leaf element in the Planning CoA. The hierarchy above the leaf elements in the Planning CoA is the same as the Operational CoA.
In this walkthrough the Planning CoA will be built from the Operational CoA.
...
Fixed Account for Planning Chart of Accounts
Planning Chart of accounts has Fixed Accounts and KPI accounts. When you first initialise the Planning CoA is easiest to copy the Operation CoA Fixed Account mapping to the Planning CoA Fixed Account mapping then adjust depending on level of detail in the Planning CoA.
...
See Draft: Mapping Fixed Accounts for a review on how Fixed Accounts are mapped.
...
C3_CTA - Cumulative translation adjustments - CTA
C3_TOTOPEX - Total Operating Expenses
C3_NPAT - Profit After Taxes
C3_EBIT - Earning Before Income Tax
C3_EBITDA - Earning Before Income Tax, Depreciation and Amortization
C3_AP - Accounts Payable
C3_AR - Accounts Receivable
C3_INV - Inventories
C3_COGS - Cost of Goods Sold
C3_CASH - Cash and cash equivalents
C3_GP - Gross Profit
C3_NCHGCASH - Net increase / decrease in cash and cash equivalents net of FX effect
Populate Plan Type
The core planning is broken up into Balance Sheet Planning, Revenue Planning and Expense Planning. Based on the Fixed Account mapping, populating the plan type determines which account is planned in which core planning module.
...
Plan Type: Set the plan type for the account.
Synchronising the Planning Chart of Accounts
The actual Planning Chart of Accounts (FIN PCoA) is only updated when it is synchronised with the staged Planning CoA. The Planning CoA can synchronise using the Sync Dimension button on the Administration > Chart of Account > Planning CoA tab. When the actual Planning CoA is not the same as the staged Planning CoA the Sync Dimension button will be Orange. Synchronising the actual and staged Planning CoA will turn the Sync Dimension button green.
...
Delete Empty Consolidations will delete C-type elements that have no components. This reduces the actual Planning CoA to only include consolidations that have natural accounts. While maintaining a full Management Trial Balance in the staging Planning CoA.
Automating the Planning Chart of Accounts maintenance
Three automation steps need to be added to automate the maintenance of the Planning CoA.
...