Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Steps: Set Up Cash Forecasting with Worksheets

Steps: Set Up Cash Forecasting with Worksheets

Security: These domains in the System functional area:
  • Drive
  • Worksheets
You can set up cash forecasting with Worksheets to create cash forecasts using operational transactions, bank statement transactions, and external cash activities. Workday enables you to define the structure of your cash forecasts, providing you with flexibility and control over the reporting content, layout, and design.
  1. This is used to define the structure of the rows in your cash forecast.
  2. This is used to define the columns and forecasts across the time periods in your cash forecast.
  3. Access the
    Map Standard Aliases
     task.
    Map standard delivered aliases to the associated rows in your outline structure to view the generated cash forecast data in cash forecast standard reports.
    Select
    Cash Forecast Outline Row
     from the
    Business Object
     prompt. Then, map standard aliases to the associated rows in your outline structure as shown in this example:
    Standard Alias
    Mapped Tenanted Value
    _FC_Outline_Top_Level
    Daily Cash Forecast
    _FC_Opening Balance
    Opening Balance
    _FC_Inflows
    Cash Inflows
    _FC_Outflows
    Cash Outflows
    Security:
    Aliases
     domain in the System functional area.
  4. (Optional) Access the
    Maintain Cash Forecast Type
     task.
    Define types such as
    Conservative
     or
    Optimistic
     to identify the versions of your cash forecast reports.
    You can review your cash forecast types using the
    View Cash Forecast Types 2.0
     report.
    Security:
    Set Up: Cash Forecasting
     domain in the Cash Management functional area.
You can generate your cash forecast into Worksheets where you populate your cash forecast data automatically, manually, or by importing live data from Workday custom reports. You can output the modeled cash forecast data into Workday cash forecast standard reports.