Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Generate a Cash Forecast

Generate a Cash Forecast

  • Create a cash forecast outline and a time span profile.
  • Configure these business processes and security policies in the Banking and Settlement functional area:
    • Cash Forecast Event 2.0
    • Cash Forecast Intercompany Event 2.0
  • Security:
    Process: Cash Forecast Reporting
     domain in the Cash Management functional area.
You can generate your cash forecast based on a cash forecast outline and time span profile. Workday creates a worksheet based on the cash forecast outline and time span with a zero-dollar cash forecast. You use the spreadsheet functions provided in the worksheet to populate the monetary values for your cash forecast.
  1. Access the
    Generate Cash Forecast 2.0
     task.
  2. As you complete the task, consider:
    Option Description
    Cash Forecast Type
    Select a cash forecast type that identifies the version of your cash forecast, such as
    Week 1
     or
    Version 1
    . This is useful if you're creating iterations of cash forecasts such as weekly reports.
    Cash Forecast Outline
    Select an outline to use as the structure of your cash forecast. The outline organizes your opening balances, cash inflows and outflows, and their subaccounts in a hierarchical format.
    Workday generates the cash forecast rows based on this outline in the workbook. The lowest-level children of the outline are available for cash forecast entry in the worksheet.
    Time Span Profile
    Defines the time period for the cash forecast. The time period, such as days, weeks, months, or quarters, displays across the columns in the report. If the time span profile contains a combination, it displays all time types in the sequential order defined in the profile.
    Companies
    Select the companies to include in your cash forecast. You can select to use either the company currency or specify a default currency for all companies.
  3. Generate your cash forecast.
    Workday creates your cash forecast in a single sheet in the workbook.
  4. Click the
    Refresh
     button.
  5. When the generate process completes, select the
    Cash Forecast Workbook
     link on the
    View Cash Forecast Criteria
     report.
    You can also open the generated cash forecast from the
    Find Cash Forecasts 2.0
     report.
Once generated into Worksheets, you can prepare your cash forecast data. You can collaborate with other users, apply mathematical calculations on historical data to project cash flows, and manually enter values or link custom reports to source forecasted data.
The cash forecast entry area is contained within a green dashed outline in the worksheet. This area also represents the cash forecast data available for standard reports and Cash Management dashboard worklets.
From the related actions of a cash forecast, select:
  • Copy Data
     to create multiple versions of a generated cash forecast. If you change attributes such as the outline structure or time span, Workday regenerates the cash forecast using the original forecast data in the new format.
  • Publish
     to finalize the draft for review and approval. If you've also configured the
    Cash Forecast Intercompany Event 2.0
     business process for intercompanies, reviewers from each company must approve the cash forecast for the publishing process to complete. Once a cash forecast is approved and published, you can distribute the forecast as a read-only report.