Training: Planning Chart of Accounts
- Adam Davis
- Cristian Blana
To initialise the Planning CoA, complete the follow steps.
Map the Operational CoA to the Planning CoA.
Set the Fixed Accounts.
Set the Plan Type ID.
Synchronise the Operational and Planning Chart of Accounts.
Mapping the Operational CoA
The first step to establishing the Planning CoA is to set the mapping of the Operational CoA to the Planning CoA. You can map the Operational CoA at any level to form the Planning CoA. In this training, level 1 of the Operational CoA balance sheet will be used to define the Planning CoA. This means the balance sheet in the Planning will start at the top node of the Balance Sheet, “9999 - All Accounts Total” and finish 1 level above the natural accounts. All of the statistical accounts in the Operational CoA will be included in the Planning CoA.
To manage the Planning CoA go to: Administration > Chart of Account.
Mapping the Fixed Accounts for Planning
To enable driver-based planning the follow Fixed Accounts must be mapped. As many Planning CoA Fixed Account mappings are the same as the Operational CoA Fixed Account, the Planning CoA Fixed Accounts mapping can be copied/cloned. Some Planning CoA Fixed Accounts mappings will be different to the Operational CoA Fixed Account mapping and will have to be manually updated.
Clone the Fixed Accounts
Once the Fixed Accounts have been mapped in the Operational CoA they can be copied to Planning CoA.
Exercise
Confirm that these Planning CoA Fixed Accounts mappings have been applied to your training environment. Manually adjust any Planning CoA Fixed Account mapping that do not match to the mappings below. If you need a refresher on mapping Fixed Accounts, see Training: Management Trial Balance for the FIN OCoA Target.
Fixed Account | Natural Account |
|---|---|
C3_REV | 3990 |
C3_TOTOPEX - Total Operating Expenses | 5299 |
C3_NPAT - Profit After Taxes | 8999 |
C3_EBIT - EBIT | 8699 |
C3_EBITDA - Earning Before Income Tax, Depreciation and Amortization | 8599 |
C3_AP - Accounts Payable | 2120 |
C3_AR - Accounts Receivable | 1120 |
C3_INV - Inventories | 1160 |
C3_COGS - Cost of Goods Sold | 4999 |
C3_CASH - Cash and cash equivalents | 1110 |
C3_GP - Gross Profit | 8499 |
C3_NCHGCASH - Net increase / decrease in cash and cash equivalents net of FX effect | CF8999 |
Set the Plan Type ID
To properly move the year-to-date actual between the General Ledger cube and the Revenue Planning, Expense Planning and Balance Sheet Planning cubes the FIN Plan Type ID needs to be mapped for every planning account. The planning module for each Plan Type ID is as follows:
Planning Type | Planning Module |
|---|---|
Balance Sheet | Balance Sheet Planning |
CapEx | Balance Sheet Planning |
Debt | Balance Sheet Planning |
Expenses | Expense Planning |
Marketing | Expense Planning |
Revenue | Revenue Planning |
Travel and Entertainment | Expense Planning |
Workforce | Expense Planning |
The Plan Type ID are update using the Update Flags process. Based on the Fixed Account Mapping (C3_GP: Revenue, C3_TOTOPEX: Expenses, C3_SALARIES: Workforce, C3_TandE: Travel and Entertainment, C3_Marketing: Marketing, C3_MGMTTB: Balance Sheet, C3_FAGROSS: CapEx, C3_LTDEBT: Debt) the plan type will be set for each account. Any gaps in the Plan Type IDs will be automatically filled with the value of the nearest parent element.
The Update Flag process also set the FIN OCoA ID. This is the account code that will be used when the plan is submitted from the planning module to the General Ledger.
Exercise
After setting the Planning CoA Fixed Accounts run the Update Flag process to set the Plan Type ID and the FIN CoA ID. Review and change any Plan Types that are missing.
Set the Plan Type ID for the Statistical accounts.
Synchronising the Operational CoA and Planning CoA
When setting up the Planning CoA we have made changes to both Planning CoA and the Operational CoA that need to be synchronised to their proper dimension. The Dimension in Sync button will be orange if the Chart of Account needs to be synchronised.