Skip to main content
Administrator Guide
Last Updated: 2023-06-23
Define Cash Forecast Components

Define Cash Forecast Components

Define the individual components that make up each row on your cash forecast report. You can share components across reports. It is best to layout the report on paper first, and then start building the components.
When defining components, the opening cash balance in the starting position and the ending cash balance in final position must reference each other. Because of this circular reference, Workday recommends that you define your components in this sequence:
  • Define your starting position using a
    Balance/Carry Over
    component but leave the
    Carry Forward From
    field blank.
  • Define
    Amount
    components for your inflows and outflows.
  • Define your
    Accumulation
    components, the final accumulator being your ending balance.
  • Update your starting position component to reference the ending balance component in the
    Carry Forward From
    field.
  1. Access the
    Create/Edit Cash Forecast Component
    task.
  2. Select the component to edit, or create a new component:
    Option Description
    Amount
    The basic building blocks of your cash forecast reports. You can have them pull data from Workday sources and cash forecast adjustment entries.
    Accumulation
    Aggregate of one or more amount components and other accumulation components into a new component.
    Balance/Carry Over
    This is the beginning balance for the first column of your cash forecast report. You can specify amount details just like an amount component.
    For subsequent columns, this is the carry over balance from one of the accumulator components, typically your ending balance component. You can specify amount details, a carry over accumulation component, or both.
  3. As you complete the task, consider:
    Option Description
    Name
    The name that displays in prompts when retrieving the component for inclusion in the report.
    Report Row Label
    The label that displays for the row on the actual report.
    Category
    To organize your components for easier retrieval, select a category. To create categories, use the
    Maintain Cash Forecast Component Definition Categories
    task.
    Inactive
    Not available for future use. Existing use of the component in report definitions and other component definitions remains functional.
    In Report Definition
    In Component Definition
    If in use, Workday displays these fields to indicate where.
    Days Prior to Report Date
    (
    Amount
    components only) Specify when you want to begin pulling source data into the amount component. Enter
    0
    to have Workday pull source data beginning on the
    Report Date
    specified when you create a cash forecast report. Or specify the number of days before this report date for which you want to pull additional data into the first column of the report. You can go back as many as 180 days before the report date. Example: A weekly report that pulls data 7 days prior and is run on March 8 will include data in the first column back to March 1.
    Carry Forward From
    (
    Balance/Carry Over
    components only) Specify the accumulation component that carries over from the previous column of the report. This is typically the ending balance accumulation component.
    Currency
    Assign a specific currency and
    Currency Rate Type
    to use for this component in the cash forecasting report. If the currency of any data that Workday pulls into the report differs when you run the report, Workday converts these amounts to this currency. You can display individual components in their own currencies on the same report.
    Reverse Sign for Accumulation
    (
    Amount
    and
    Balance/Carry Over
    components) Select to reverse the sign for this component amount. The sign reversal impacts the number that displays on the cash forecast report for this component. It also impacts the sum of any accumulation component that uses this component, such as the ending cash position. Example: Select to reverse the sign for your outflows so that they display on the report and in accumulation components as negative numbers.
  4. For amount and balance/carry over components, specify the
    Amount Details
    :
    Option Description
    Source Definition
    From the Workday delivered source definitions, select the data that you want to pull into the report through the component. Unless you assign a condition rule to filter source transaction data, Workday pulls in the data for all statuses (approved, in progress, draft, canceled and so on).
    Amount and Date
    Sometime sources have multiple amount values. Select the one that you want to use.
    Condition Rule
    To limit the scope of data, apply a condition rule as defined using the
    Maintain Cash Forecast Rules
    task. Workday does not provide filters for any of the source transaction data. To filter, create a condition rule. Example: You can create a rule to pull in approved supplier invoices only.
    Multiplier
    Add a multiplier greater or less than one to the results.
    Add New Rule
    When editing, click to add a new cash forecast rule for the selected
    Source Definition
    . You can then select this new rule as a
    Condition Rule
    for the source.
    For components that only pull data from external sources, you can define an amount component without details. Then you can record adjustments against the component when you run the report.
  5. For accumulation components, specify
    Accumulation Details
    :
    Option Description
    Order
    The order that you list the included components controls the structure and order of how amounts appear in the cash forecast report.
    Cash Forecast Component
    From the existing cash forecast components, select the ones that you want to accumulate and pull into the report through the component.
  6. To launch the
    Create/Edit Cash Forecast Component
    task in a new window, click
    Add Component
    or
    Edit Component
    .
The cash forecast component is available for use in cash forecast reports definitions, and in other components.
You can use the
View Cash Forecast Component Definition
report to review details of a specific cash forecast component. Workday provides buttons that enable you to edit or add a component. You can also add a cash forecast rule to use as condition when pulling data from a source definition.
If you change the component definition or condition rules, create a new report.
Refresh Data
doesn't reflect these modifications.
  • Define another cash forecast component.
  • Set up cash forecast report definitions.