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 accountCash flow account typeAssigned financial account
Change in accounts receivable due to tradingSchedule detailTrade receivables

(fair value)

Schedule detailTrade receivables (provision for bad debt)

This configuration is incorrect:

Cash flow accountCash flow account typeAssigned financial account
Change in accounts receivable due to tradingSchedule detailTrade receivables

(Fair value)

Change previous yearTrade 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.

  1. Click the Home icon.
  2. Select Applications > Financial Applications > Cash Flow > Configuration > Accounts Assignment.
  3. Select a version from which to select the cash flow accounts types.
    Optionally, search for a particular account by specifying a text string in the Search By Name box.
  4. Click Not Set for an account type and select a cash flow account type. These cash flow account types are automatically calculated:
    Option Description
    Schedule Detail A balance sheet account is selected and then the appropriate schedule detail members are selected. The period movements for the account and schedule detail members are transferred to the cash flow account.

    The value that is written back to the database for this cash flow account type is 1.

    Closing Balance One or more balance sheet and profit and loss accounts are selected. The period movements for the selected accounts are transferred to the cash flow account.

    The value that is written back to the database for this cash flow account type is 2.

    Change Previous Year One or more balance sheet and profit and loss accounts are selected. The period movements for the selected accounts are transferred to the cash flow account. Opening balance values for balance sheet accounts are not transferred.

    The value that is written back to the database for this cash flow account type is 3.

    Manual The data is specified manually.

    The value that is written back to the database for this cash flow account type is 4.

  5. Click Edit to select the accounts.
  6. Click OK.

After you have completed assigning accounts to the cash flow, you must transfer the cash flow data by clicking Transfer of Cash Flow Data.