Template Setup - New Experience

With enhanced mapping in the template setup, you can view and select the rollup members along with the leaf members of a hierarchy while doing history and reference account mapping in the template setup, making the account mapping process easy and quick.

Existing Template Experience vs New Template Experience

Mappings

Mapping involves assigning templates to specific scenarios, entities, and roles. This ensures that the right users have access to the appropriate data input and reporting capabilities. Entities are mapped to templates to determine where data will be applied, and approval roles are mapped to control user permissions for actions like input, viewing, and marking templates complete. Accurate mapping is essential for efficient planning and execution. This has the following categories:

• Mass Load / Bulk Add

  • Mass Load: This option mass loads multiple account members at once and inserts rows for each. On the Mass Load page, select the checkbox to select or deselect all accounts to load.

    Note:

    Mass Load is applicable for Allocation Template, Block Template, and GTEC templates.

  • Bulk Add: Using this option, you can select all the applicable dimensions at the Rollup and the Leaf level, and add the multiple template line items in one go.

    Note:

    Bulk Add is applicable only for GTSC Templates.

  • To learn more about Bulk Add, click here.

• Template Mappings: This category provides a one-stop where you can map the template to budget entities, configure the approval role access for the template, and also perform global field mapping to the template. The options include:

  • Entity Mapping: Open the Entity Mapping page to map the template to budget entities. Click here to learn more about entity mapping.

  • Approval Role: Open the Approval Role page to set approval actions. Click here to learn more about adding a new approval role.

  • Global Field Mapping: Open the Map Global Fields page to map global fields to the template. Click here to learn more about global field mapping.

Methods

The Method Selection is an option within Planful templates that allows adjustments like applying monthly or yearly dollar/percentage increases, distributing values using spread methods (e.g., evenly or 4-4-5), and utilizing global fields. Users can also round values and modify attributes if unlocked. These methods offer flexibility for precise financial planning and forecasting adjustments. The Method Selection section has the following options:

• Monthly Increase $: Select this option to apply a dollar amount increase over the history for each monthly period.

• Monthly Increase %: Select this option to apply a percentage increase based on the history amounts for each period.

• Full Year Growth: Select this option to apply a total percentage increase based on history, and use a spread method to distribute the amounts to the monthly periods. This option is applicable for a year.

• Annual Value: Select this option to apply a total dollar amount based on history, and use a spread method to distribute the amounts to the monthly periods. This option is applicable for a year.

• Spreads: Allows users to distribute annual value to period columns based on a selected spread method. Select an option (i.e. evenly, 4-4-5, etc.) to apply the spread to the template row that can be modified by the user. You may opt to spread based on historical data (History Scenario).

  Note:

  The attribute cell must be unlocked to allow users to make modifications.

• Global Fields: Apply a global field to a template row, which displays the lookup formula in the template setup. Global Fields that populate this list box are defined on the Global Fields page.

• Round: Select the Round checkbox to round off numbers to the nearest whole number. For example; 67.7 will appear as 68.

Hide

Administrators can manage the visibility of rows in the Input/View mode of the Planning Control Panel using the Hide feature available in Template Setup. This functionality allows rows with no data or only zeros to be hidden, streamline the user view for more efficient planning.

Note:

The hide option is applicable only to GTSC and Allocation Templates.

The following Hide options are available:

• No History Data

• No Compare Scenarios Data

• No Current Scenario Data

When one or more of these checkboxes are selected, rows that contain no data or only zeros in the corresponding columns will be hidden in Input/View mode.

Each Hide option functions independently. Administrators can select one or multiple options simultaneously. When multiple options are selected, rows will only be hidden if all selected columns have no data or contain only zeros. If at least one selected column contains data, the row remains visible.

For example:

• If you select only one option (e.g., No History Data), rows without History Data will be hidden.

• If you select multiple options (e.g., No History Data and No Compare Scenarios Data), a row will be visible if it contains data in at least one of the selected columns

Impact on Input/View mode in Planning Control Panel

When the checkbox is selected, the corresponding rows in Input and View Modes within the Planning Control Panel will be hidden.

• Users can still select or unselect the checkbox to show or hide data as needed in Input/View mode.

• If there is a change in the Template Setup, it will override any selections made in Input Mode.

Notes:

• This Hide feature operates independently from the existing Hidden functionality.

• Header rows always remain visible, regardless of Hide selections.

• Row hide settings are applied when copying or seeding scenarios.

• Row hide settings are not applied during exports or when sending via email.

Grid Actions

Select from the following actions:

• Show/Hide Formula Bar: Display or hide the Excel formula bar.

• Hide/Show Format Bar: Display or hide the format area, which is where you insert lines, borders, format numbers, and more.

• Show/Hide Row Header: Hide or display the template row numbers.

• Show/Hide Column Header: Hide or display the template column letters.

• Show/Hide Tabs: Hide the tabs for Global Fields and Spreads that appear at the bottom of the Template Input and View screens.

• Show/Hide Scenario Header: Display or hide column header information. Column scenario headers display scenario name. Admin users can choose to set the display globally (to hide or show) for column headers. If an Admin user hides the display of column headers globally, other users will not be able to see this information.

• Show/Hide Column: Hide or show selected columns (within any template except Initiative templates) to improve visibility.

• Show/Hide Data Filter: Filter Spreadsheet Data similar to Excel as shown below.
  Data filter functionality is available for the following template types: Allocation, Block, Sales, Global Template - Single Copy, Global Template - Entity Copy, Line Item, and HR.

  Note:

  Data filters will be lost during Scenario Seeding when using a Reference Scenario and Change by Periods.

• Show/Hide All: Display or hide the top action ribbon and info bar.

• Hide/Show Info Bar: Hide or display the info bar.

• Show/Hide Column: Select a column and click Show/Hide Column to display or hide a column.

Export Options

These options allow you to export the template. The available options are:

• Export to Excel: Use this option to download the template in an Excel sheet.

• Print: This has two options: Print and Print Setup. Use Print Setup to customize your print settings and use print to the template.

• Send Email: This option allows you to send the template as an attachment allowing you to search for the recipients using the First Name, Last Name, or Email. You can also compose an email to the recipient.

More

The More option has the following categories:

• Account Reports: This category has the following options:

  • Destination Account Report: Open the Report page to view each line that is identified as a destination account and print or download the report in Excel format.

  • Reference Account Report: Open the Report page to view each line that is identified as a reference account. Print or download the report in Excel format.

  • Show Rule: Open the Rule page to view associated multidimensional expressions.

• Header: This category has the following options:

  • Notes: View all notes for the related template.

  • Snapshot: Take a snapshot of the template. Snapshots may be stored in the File Cabinet.

  • Template History: View information on when the template was modified and by whom.

Format Bar

When setting up a template ensure you select the row type (e.g., LINE, CALC, HEADER) before clicking Add Line Item. The row type will then appear in the first column of the template for easy reference. Click here to learn more about template line types and column types.

• Move Row Down/Up: Select a cell and click on Move Row Down/Up to move the row Down or Up.

• LINE (L): Allow data entry or calculations to be performed for the row. Reference and destination accounts may be applied to a line.

• HEADER (H): Format sections or provide additional spacing within a template or add instructions for end users. This cannot be edited/input by the user.

• CALC (C): Allow calculations to be defined for a row within the template design, preventing users from modifying the formula. Destination accounts may be applied to a calc line. This cannot be edited/input by the user.

• Apply bold, italic, text color, background color, and borders.

• Format: This has the following options:

  • Text: Select to allow the entry of text.

  • Number: By default, the Number is selected in the Format field. It allows numerical entries.

  • Currency: Select to allow the system to enter a currency symbol ($) for all numerical data entered.

  • Percent: Select to allow the system to place a percent symbol (%) behind all numerical data entered.

• Hidden: Select to show or hide the column from users.

• Show All: Select to show the hidden rows in the template.

• Copy Format: Select to copy the format of a cell and paste it to another row.

Select Mapping (Account Mapping)

Column J on the Template Setup screen allows you to directly map each row's destination account, reference account, or reference cube. You can view and select the rollup members along with the leaf members of a hierarchy while doing history and reference account mapping in the template setup, making the account mapping process easy and quick.

When you click the Edit icon in this column, the following options are available:

• Destination Account

• Reference Account

• Reference Cube

To learn more about the Mapping options, click here.

Limitations

• This update does not apply to greater than 12-period templates or templates in Shared Mode.

• AirliftXL will not be supported.

• Wildcard characters are not supported. Existing wildcard mappings will be expanded to the matching segment leaf members.