Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Steps: Produce Cash Forecast Reports

Steps: Produce Cash Forecast Reports

  • Configure the
    Cash Forecast Report Event
     business process and security policy in the Cash Management functional area.
  • Security:
    Process: Cash Forecast Reporting
     and
    Reports: Cash Forecast Reporting
     domains in the Cash Management functional area.
We plan to retire the cash forecasting 1.0 functionality in a future update. Workday recommends you use the new cash forecasting with Worksheets that provides advanced forecast modeling and reporting capabilities.
To produce cash forecast reports, you can define the report layout, identify system and manual inputs, generate the report, make adjustments, and publish for others to view. Your reports can utilize bank balances and transactions that are already captured in Workday. You can also define additional external inputs and record the adjustments against them, which is needed to complete the reports.
You can use this report beyond cash forecasting simply as a generic reporting tool where you can pull in specific transaction information.
  1. Lay out your cash forecast report on paper, thinking about your sources of data and what you want your columns and rows to be.
  2. (Optional) Access the
    Maintain Cash Forecast Component Categories
     task.
    Create categories in which to organize your cash forecast components for easier retrieval later on.
  3. These make up the rows of your report.
  4. Use this task as needed to limit the scope of data that you pull from Workday sources in your cash forecast components.
  5. This makes up the columns of your report.
  6. (Optional) Access the
    Maintain Cash Forecast Report Categories
     task.
    Create categories in which to organize your cash forecast report definitions for easier retrieval later on.
  8. Set up cash forecast report profiles.
    These profiles are the lenses through which you can view the cash forecast report. Use them to define the display options for a unique view of the cash forecast report.
    1. Access the
      Create/Edit Cash Forecast Report Profile
       task.
    2. Specify for the
      Cash Forecast View Type
       to override the default view from the cash forecast report definition.
    3. Select the
      Currency
       that you want to view the report in and the currency conversion
      Rate Type
      . Your selections override the currency and rate type for each of the components.
    4. Select
      Worktags
       to filter report results by a specific dimension, such as customer.
  9. Access the
    Create Cash Forecast Report
     task.
    Generate and view the report.
  11. (Optional) From the cash forecast report, select
    Refresh Data
     to update a report to include:
    • New or changed transaction data now available since the time you ran the report.
    • Adjustments made to the report.
    • Changes made in the report profile.
      Refresh Data
       doesn't reflect any modifications made to the:
      • Cash forecast component definition.
      • Condition rules you use in the cash forecast component definition.
      • Cash forecast report definition.
      If you change these definitions, create a new report.
  12. From the cash forecast report, click
    Publish
     to initiate the process that finalizes the report for publication.
    Publishing launches the
    Cash Forecast Report Event
     business process that sends the completed report for notification and approval. Because the report is in the publication process, approvers must have security access to the
    Process: Cash Forecast Reporting
     domain. If you have included a review step in the business process, reviewers can update the report during review and approval.
    Once a report is published, it cannot be modified or refreshed.
  13. View the published cash forecast report.
    Viewers must have security access to published cash forecast reports through the
    Reports: Cash Forecast Reporting
     domain.
  14. If necessary, you can
    Rescind
     the report publishing event, which reverts the report back to draft status. At this point, you can edit, refresh, and republish the report.
A typical process flow starts when the cash manager creates a report. Individuals with security permission view it, and then the cash manager revises and submits the report for publication. The
Cash Forecast Report Event
 business process routes the report for optional approval. When the business process completes, the cash forecast report is published and the controller can view it.