Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-09-20
Steps: Roll Forward Setup and Configuration in AP&C

Steps: Roll Forward Setup and Configuration in AP&C

You can create and configure a roll-forward type of supplemental schedule in Adaptive Planning and Consolidation (AP&C) and roll forward your ending balances to the next period beginning balances by using Supplemental Schedules.
Consider these guidelines and setup configurations when rolling forward ending balances using Supplemental Schedules. This ensures accurate calculation, translation, and roll forward of such schedules from period to period.
Use the Mass Roll Forward Supplemental Data task to roll forward multiple workbooks. See Mass Roll Forward Multiple Supplemental Data Workbooks in AP&C.
    1. Access the
      Create Supplemental Data Template
       task.
    2. Select
      Roll Forward
       in the template header.
    3. For
      Data Type
       of
      Currency
      , click
      Properties
       and enter these values:
    Option Description
    Calculated Field
    Create an arithmetic expression to derive the calculation of your ending balance column. See Concept: Calculated Fields in Supplemental Schedules in AP&C.
    When you assign a Calculated Field to a Currency Data Type, Workday will calculate the column value during data entry based on the configured arithmetic expression. This column will be Read-Only during data entry.
    You can configure more than 1 Calculated Field in a given Supplemental Data Template.
    Translated Calculated Field
    Create another Calculated Field referencing translated report fields on the
    Supplemental Data Row
     business object.
    Configuring translated Calculated Fields ensures that Workday accurately calculates translated currency values in addition to ledger currency values.
    Roll Forward Column
    Specify the column where you want to roll forward the ending balance of a roll-forward schedule for each period.
    This will likely be your beginning balance column in a roll-forward.
    Example: Roll Forward Template Column Configuration.
    Option Description
    Name and Data Type
    Properties
    Name: Beginning Balance
    Data Type: Currency
    Name: Additions
    Data Type: Currency
    Name: Ending Balance
    Data Type: Currency
    Calculated Field
    Calc_Field
    Translated Field
    Calc_Field_Translated
    Rollforward Column
    Beginning Balance
    In the example above:
    • Calc_Field is a calculated field for an arithmetic expression in the
      Ending Balance
       column. Workday references the calculated field by these report fields on the
      Supplemental Data Row
       business object:
      Column 01 Currency + Column 02 Currency
    • Calc_Field_Translated is a calculated field for an arithmetic expression representing the
      Translated Ending Balance
       column. Workday references the calculated field by these translated report fields on the
      Supplemental Data Row
       business object:
      Column 01 Currency Translated + Column 02 Currency Translated
  2. You can create Supplemental Data using a predefined Supplemental Data Template that you enable as a
    Roll Forward
     template.
    1. Access the
      Create Supplemental Data
       task.
    2. As you complete the Supplemental Data details, consider these guidelines for creating Supplemental Data from templates that you enable as
      Roll Forward
      :
    Option Description
    Time Period
    Workday only supports these reporting Time Periods:
    • Current Period (Workday Owned).
    • Current Period (Workday Owned).
    • Quarterly Time Periods (that is, reporting time periods that have a summary schedule with 4 fiscal time intervals each summarizing 3 fiscal posting intervals).
      For Quarterly Reporting Time Periods, ensure you specify a value under the
      Use Specific within the Period
       section of Reporting Time Period configuration.
    1. From the related actions menu of the
      Approved
       Supplemental Data, select
      Supplemental Data
      Maintain Translation Amounts
      .
    2. For the first period for which you want to roll forward balances, load translated beginning balance values into your beginning balance translation adjustment amount column. The default values for this column are zero until you create an adjustment.
      This is a one-time step for the first period. This ensures accurate calculation of ending translated balances that you roll over from period to period. Thereafter, accessing the task is optional and you can use it to make translation amount adjustments to activity columns.
      Once a Supplemental Data has a status of
      Approved
       for the current period:
      • You can't create any new Translated Supplemental Data for the previous period.
      • You can no longer modify any existing Translated Supplemental Data for the previous period.
  4. Roll forward Supplemental Data
    To ensure accurate data entry from period to period, Workday supports the automatic roll-forward of ending balances into beginning balances for Supplemental Data Templates that you enable as
    Roll Forward
    .
    Security:
    Process: Supplemental Data
     in the Advanced Close and Consolidation functional area.
    1. From the related actions menu off of an Approved Supplemental Data that you wish to roll forward, select
      Supplemental Data > Roll Forward
      .
      You can also access the
      Roll Forward Supplemental Data
       task and for the
      Previous Detailed Supplemental Data
       field, select the
      Approved Supplemental Data
       that you wish to roll forward.
    2. As you complete the task, consider: 
      Prompt
      Description
      Period
      Workday defaults the value to the Supplemental Data Period from where you’re rolling balances.
      Update the period to the next Period to where you want to roll forward balances.
      Time Period
      Workday defaults the value to the reporting time period of the Supplemental Data that you’re rolling forward balances from.
      Workday recommends that you don’t change this defaulted value unless you’re using a Quarterly Time Period. Example: For Quarterly Time Period, select the next Quarter that you wish to roll forward balances to.
    3. Select
      Copy Supporting Information
       to copy over non-Entry Area items (sheets, pivot tables, or other supporting details) from the Supplemental Data workbook that you’re running the Roll Forward action on.
    4. Under
      Name
       enter a unique name.
    5. Click
      OK
      .
Workday:
  • Generates a workbook that displays the name, number, and type of columns as you defined in your Supplemental Data Template.
  • Rolls forward ending balances from your previous Supplemental Data to the beginning balance column, per your template configuration.
Balances that you’ve rolled forward (that is, beginning balances) are read-only during data entry and you can't modify them.
You can’t roll forward a previous Supplemental Data under these conditions:
  • When you have already created a rolled forward Supplemental Data for the next period, in a
    Draft
     or
    Submitted
     Document Status.
  • When you have Supplemental Data for a previous period in
    Draft
     or
    Submitted
     Document Status with these same grouping dimensions of:
    • Company
    • Supplemental Data Template
    • Period
    • Time Period