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.
To enable driver-based planning the follow Fixed Accounts must be mapped in the Planning Chart of Accounts.
...
Fixed Account
...
Please map these Fixed Accounts.
C3_
...
CTA - Cumulative translation adjustments - CTA
C3_TOTOPEX - Total Operating Expenses
...
5299
C3_NPAT
...
- Profit After Taxes
C3_EBIT
...
- Earning Before Income Tax
C3_EBITDA
...
- Earning Before Income Tax, Depreciation and Amortization
C3_AP - Accounts Payable
...
2120
C3_AR
...
- Accounts Receivable
C3_INV
...
- Inventories
C3_COGS - Cost of Goods Sold
...
4999
C3_CASH
...
- Cash and cash equivalents
C3_GP - Gross Profit
...
8499
C3_NCHGCASH
...
CF8999
...
- 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.
The Populate Plan Type process can be found on Structure tab of the Planning CoA tab.
...
Reset Planning Flags: Override the existing Planning Flag with the calculated mapping. This should be set to Yes unless you are manually maintaining the planning module mappings (FIN Plan Type ID).
OCoA Mapping: Calculate the mapping from the Planning CoA to the Operational CoA.
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.
...