/
Training: Planning Chart of Accounts

Training: Planning Chart of Accounts

To initialise the Planning CoA, complete the follow steps.

  1. Map the Operational CoA to the Planning CoA.

  2. Set the Fixed Accounts.

  3. Set the Plan Type ID.

  4. 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

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

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.

Next

Training: Planning CoA Automation