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

Create a Cash Forecast Outline

Security:
Set Up: Cash Forecasting
 domain in the Cash Management functional area.
Create an outline to establish the hierarchical order of the cash inflows, outflows, and their aggregations for display on your cash forecast reports.
  1. Access the
    Create Cash Forecast Outline 2.0
     task.
  2. Specify a name and description to identify the outline.
    You select an outline when you generate a cash forecast.
  3. Click
    Maintain Sublevels
     to define the next level of your cash forecast outline.
  4. As you complete the task, consider:
    Option Description
    Name
    The name identifies the level of cash forecast hierarchy, such as opening balances, inflow, or outflow, that displays on a row of the cash forecast report.
    Outline Row Type
    Select the type of hierarchy level:
    • Accumulation
      : An aggregate of 1 or more sublevel amounts or balances into a parent amount in the report structure. Workday calculates the accumulation value when you run the cash forecast report. Example:
      Cash Inflows
       or
      Cash Outflows
      .
    • Amount
      : The basic building block of your cash forecast reports. You enter your cash inflows and outflows in the worksheet. Example:
      Customer Receipts
      ,
      Supplier Payments
      ,
      Borrowings
      , or
      Investment Income
      .
    • Balance
      : You enter your cash opening balance and carry forwards in the worksheet. Example:
      Opening Balance
       or
      Carry Forward Balance
      .
    Cash Activity Category
    You can assign 1 or more cash activity category worktags to an amount. Workday uses the worktags to group cash inflow or outflow actual amounts by bank statement type code.
    These actuals display on the
    Cash Forecast to Actuals in Reporting Currency
     report.
    Normalized Balance
    You can assign a normalized balance to a balance type. A normalized balance is a grouping of balances by bank statement type codes from multiple bank statement formats.
    The balance displays as an actual on the
    Cash Forecast to Actuals in Reporting Currency
     report.
    Flip Sign
    Select to reverse the sign for an amount. The sign reversal impacts the number that displays on the cash forecast report for this amount. It also impacts the sum of any accumulation that uses the amount, such as the ending cash position.
    Example: Select to reverse the sign for your outflows so that they display as negative numbers on the report and in accumulations.
  5. On the
    View Cash Forecast Outline 2.0
     report, select an accumulation in the outline, and click
    Maintain Sublevels
    .
    The accumulation value becomes a parent that you can link to the sublevels in the hierarchy.
  6. On the
    Maintain Sublevels for Forecast Outline Row
     task, add accumulations and inflow or outflow amounts as sublevels in the hierarchy.
    The order that you list the amounts or accumulations controls how they display on the cash forecast report. You can rearrange or add new sublevels within the hierarchy.
After you've created your outline, you can use it as the foundation for 1 or more cash forecast models and reports.
To create the outline of your cash forecast report, identify your cash inflows and outflows and add them to accumulations as shown in this example:
Name
Outline Row Type
1. Opening Balance
Accumulation

    1.1 Carry Forward Balance

Balance

    1.2 Manual Adjustments

Amount

    1.3 Projected Float

Amount
2. Cash Inflows
Accumulation

    2.1 Customer Receipts

Amount

    2.2 Fund Transfers

Amount
3. Cash Outflows
Accumulation

    3.1 Trade Payments

Amount

    3.2 Operational Payments

Amount
Use the
View Cash Forecast Outline 2.0
 report to review your cash forecast outlines and make any changes. You can modify the outline structure if you haven't generated any cash forecasts, or first cancel any cash forecasts generated from the outline. You can edit the values defined within the structure at any time.
From the related actions of a cash forecast outline, you can:
  • Copy the outline and modify its structure or values to create a new outline.
  • Generate the cash forecast based on the outline to a worksheet where you populate your cash forecast data.
  • Inactivate the outline if it's no longer in use. This prevents users from creating new cash forecasts while the outline is inactive. Inactivating an outline doesn't impact associated cash forecasts that are already created or published.