How to Add a Capital Template Type

There are 2 parts to complete the creation of a template:

1. Template Add - From the Template List page (accessed by navigating to Maintenance > Templates > Template Setup) click the Add button to define the template type, enables spreads and global fields, and set other parameters.

2. Capital - Navigate to Maintenance > Capital > Asset Setup. Set up Asset Categories, Assets, and Finance Modes. Then, perform template set up for Finance Modes. Assets are loaded to the Capital template via the Budget Control Panel template Input page.

For detailed information on setting up Capital Planning, see the Capital Planning Admin Guide.

Complete the following steps to add a Capital template (this is part 1 or 2 as part 2 is discussed in the Capital Planning Admin Guide).

1. Navigate to Maintenance > Planning Templates > Template Setup.
   

2. Select Scenario as Default Scenario. All templates must be created on the Default scenario and then mapped to your scenarios of choice.

3. Click the Add button.
   

4. For Template Type, select Capital Template.
   

5. Enter Template Code (enter any code that correlates with your company's current identification practices).

6. Enter Template Name (enter a descriptive and identifiable name).

7. Select the Entity Type for the template. This information is populated from the Entity Types set up in Hierarchy Management. Entity types are associated with the lowest level members of the budget hierarchy.

8. For Data Transfer select Apply Sign Reversal or No Sign Reversal. This selection works with the Debit/Credit field in the Natural Account segment. Debit accounts typically display data in the same sign as stored in the database. Credit type accounts typically store data in the opposite sign of that stored in the database. Therefore, a credit becomes a debit (or negative) in the database, but is displayed as a positive in reports and during input.
   

   • Apply Sign Reversal - Select this option so that credit type accounts are displayed and entered opposite the sign they are stored.

   • No Sign Reversal - Select this option to display and enter balances as they should be stored in the database.

9. For Display Line Code, select the checkbox to display a separate column in the template for the line codes.

10. Click the Template Columns tab. This is where you will configure template column structures such as Time Set and Template Attribute Columns. See Template Line Types and Column Types.
    

    Default Time Set/Custom Time Set - Time Sets allow budget input at a selected time period frequency in a budget template for each budget input year. This flexibility allows you to create templates with accurate operational plans and provide a means for long-term strategic planning. By default, the Planful system assumes a one fiscal year (12 periods) configuration, which is equal to months. This option is selected by default. Deselect this option and select Custom Time Set to allow additional time set fields to create time sets with varying frequencies. Once created, they are mapped to templates.

    Fields available when Custom Time Set is selected:

    • Time Set - Select the time set you want associated with the template. The Time Set options available are those you defined on the Define Time Sets page.

    • Year Total Columns - This selection determines the position of the Year Total(s) columns on the template with respect to the Budget Periods.

      • Before Budget Periods – Places the Year Total(s) column before all budget periods.

      • After Budget Periods - Places the Year Total(s) column after all budget periods.

      • By Budget Periods (Before) – Places the Year Total(s) column before the budget periods per time set structure (year, quarter, month).

      • By Budget Periods (After) - Places the Year Total(s) column after the budget periods per time set structure (year, quarter, month).

    • Year Totals For - Determines the way the Year Total column is produced on the template.

      • All Periods - Creates the Year Total column which contains data for all years.

      • Required Budget Periods - Creates the Year Total column, which contains data for periods with non-year level budget input.

11. Template Columns - Attribute Columns - attribute selections are not available and are pre-populated based on your configuration on the Define Capital Budgeting Criteria page shown below.

12. Click the Segment Members tab.

    • All Members - Indicates that the mapping for the respective definition is performed from the Template Input page along with the segment identified as a ‘Load’ segment. Note, a Load type segment is also a template segment.

    • Allow Destination Account Setup - Allows administrators to override the control panel setting.
      

13. Click Save and click the Back button to return to the Template List page. There is NO Template Setup to set up for Capital templates. Capital setup (assets, finance modes, and asset categories must be completed).

For detailed information on setting up Capital Planning, see the Capital Planning Admin Guide