Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Create Cash Forecast Data Source Sets

Create Cash Forecast Data Source Sets

  • Create a cash forecast outline.
  • Security: These domains in the Cash Management functional area:
    • Set Up: Cash Forecasting
    • Process: Cash Forecast Data Automation
Workday provides data sources to automate the data accumulation for your cash forecasts. You can leverage existing operational data in Workday to create projected cash inflows, outflows, and opening cash balances for your cash forecasts.
You can select a data source to use for each cash forecast outline row, such as supplier payments or customer payments. When you generate a cash forecast, Workday uses the data source sets to automatically populate the summarized forecasted amounts in the cash forecast entry area.
  1. Access the
    Create Cash Forecast Outline Data Source Set
     task.
  2. As you complete the task, consider:
    Option Description
    Data Source
    Select a predefined source to extract and accumulate Workday operational data on an outline row, which can include:
    • Customer invoices.
    • Expense reports.
    • Bank statement line amounts from prior day or intraday bank statements.
    • Opening bank account balances from prior day or intraday bank statements.
    • Supplier invoices.
    You can also run data sources as standard reports on an ad hoc basis to:
    • Analyze detailed operational data.
    • Copy as custom reports to link to your model workbook.
    Source Date
    Select a date field from the data source to use as a cash forecast date. Examples of source dates include the supplier invoice date and supplier invoice due date.
    Example: The supplier invoice for 100.00 has an invoice date of January 1 and an invoice due date of January 15. You use the invoice due date as the source date. The generated cash forecast of 100.00 displays on January 15.
    Source Date Modifier
    Adjusts the source date by the specified number of days for the cash forecast. Enter:
    • A positive number to indicate a number of days in the future.
    • A negative number to indicate a number of days in the past.
    • A zero to use the source date on the cash forecast. You can also leave the field blank.
    Example: If you enter a date modifier as
    7
    , Workday adjusts the cash forecast date for the 100.00 supplier invoice from January 15 to January 22.
    Source Amount
    Select an amount field from the data source to use as the cash forecast amount. Examples of source amounts include the supplier invoice gross amount and supplier invoice net due amount.
    Example: You prepay 15.00 on the 100.00 supplier invoice, and select the supplier invoice net due amount as the source amount. Workday will now use the net value as the forecasted amount. The generated cash forecast displays 85.00 on January 22.
  3. (Optional) Select the data source field values to include in the forecasted calculation for the outline row.
    To split the field values onto separate rows in your cash forecast, you can create a new cash forecast outline row for each field value. Then, assign the data source and specific field values to each new outline row.
    Example: You edit your outline to create 2 separate outline rows for partially paid and unpaid supplier payments. In your cash forecast data source set, you select the
    Supplier Invoices for Cash Forecasting
     data source for each row. You also assign one of these
    Cash Forecast Payment Status
     data source field values to each row:
    • Partially Paid
    • Unpaid
    The partially paid and unpaid invoice amounts display on separate lines in the cash forecast.
    If you don't specify any data source field values, Workday consolidates all available values into the forecasted amount.
You can create a different data source set for each cash forecast outline. When you generate a cash forecast, the data sources prepopulate the summarized outline rows in the cash forecast workbook.
  • Generate the cash forecast with the data source set.
  • Merge your model workbook with the cash forecast workbook to populate the values for other sources.
  • Override the prepopulated values by adding any amounts you might have recently paid or other adjustments.
  • Copy a data source set to create multiple sets to use for a cash forecast outline structure. From the related action on a cash forecast data source set, select
    Copy
     and modify the values in the fields.