Assigning cash flow accounts
Use the Assignment of Cash Flow Accounts page to:
- Assign accounts from the profit and loss statement and the balance sheet to the cash flow.
- Open the Cash Flow Transfer Configuration page where you can copy a cash flow configuration.
- Transfer balance sheet and profit and loss data to the cash flow statement.
These tasks are usually completed by the administrator or the Business Modeler role.
When assigning a financial account to a cash flow account, these rules apply:
- Profit & loss. Closing Balance or Change Previous Year can be selected; both options give the same result since profit and loss values are stored as period movements. Profit & Loss accounts do not have an opening balance.
- Balance sheet. The data entry requirements drive the cash flow configuration.
- If data is collected by Schedule Detail, the cash flow configuration must use the Schedule Detail account.
- If data is collected at the account level, Closing Balance or Change Previous Year can be selected. Both options give the same results since Budgeting & Planning collects and stores balance sheet values as period movements.
When configuring a cash flow account, all accounts that contribute to it must be configured in the same manner.
If Trade receivables (fair value) and Trade receivables (provision for bad debt) accounts are collected using Schedule detail, this configuration is correct:
Cash flow account | Cash flow account type | Assigned financial account |
---|---|---|
Change in accounts receivable due to trading | Schedule detail | Trade receivables
(fair value) |
Schedule detail | Trade receivables (provision for bad debt) |
This configuration is incorrect:
Cash flow account | Cash flow account type | Assigned financial account |
---|---|---|
Change in accounts receivable due to trading | Schedule detail | Trade receivables
(Fair value) |
Change previous year | Trade receivables (provision for bad debt) |
Even though the cash flow account type must be the same for each configured account, the contribution sign signifying an increase or decrease of the cash flow, can differ by account or account – Schedule Detail member.
After you have completed assigning accounts to the cash flow, you must transfer the cash flow data by clicking
.