External data in cash flow forecasts

External data can be entered or imported into cash flow forecasts. This article describes the setup steps that are specific to the use of external data and that enable the external data to be included in a cash flow forecast.

External data setup

Use the External source tab on the Cash flow forecast setup page (Cash and bank management > Cash flow forecasting > Cash flow forecast setup) to enter settings that support the use of external data in cash flow forecasts.

External data can be entered or imported into cash flow forecasts. Before external data is entered or imported, external sources must be set up. On the External source tab, set up external cash flow categories. A category can be either Outgoing or Incoming. Liquidity should be selected as the posting type. In the Legal entity settings grid, select the legal entities and the corresponding main accounts that the external cash flow categories apply to.

For more information about how to set up cash flow forecasts, see Cash flow forecasting.

Enter external data

To enter and modify external data for cash flow forecasts, you can use the Open in Excel experience. Select the External data button on the Cash flow forecast workspace page, and then select either Add External Data or Edit existing external data. When the Microsoft Excel file is opened, you can enter information in the following fields:

• Entry ID (unique)
• Description (optional)
• External Source name – Select one of the values in the list that you defined when you set up Finance insights.
• Legal Entity
• Date
• Amount in transaction currency
• Currency Code
• Default Dimension (optional)
• Document number (optional)
• Account number (optional)
• Account name (optional)

Importing external data by using the Data Management framework

You can import external data for cash flow forecasts by using the Data Management workspace and the entity that is named Cash flow forecast external source entry.

Additionally, if you must move setup data from one environment to another, the following entities area available for the setup tables that are required:

• Cash flow forecast external source setup
• Cash flow forecast external source legal entity setup