Creating Consolidation Journal Templates

To create, modify and delete consolidation journal templates, you must be assigned the application role of Consolidation Journals - Create. If you also have the predefined role of User, Power User or Service Administrator, you must have write access to the members in the journal.

You can create Standard or Recurring journal templates.

• Standard templates contain accounts and entities for adjustments that you enter frequently.

• Recurring templates contain complete information for identical journal entries that occur for more than one period. If you have journals that need to be created for every period, you can create Recurring templates for those journals. Recurring journals are automatically created with a Working status when the period is opened. If you no longer need Recurring journals, you can delete the Recurring journal template.

When you create a journal, you can choose to create it using an existing template. When you select a template, a data security check is made to determine whether you have access to all of the template entries.

After you enter data, you can scan the template to verify that all entries are valid. The scan process enables you to identify errors and make any necessary changes before you save the template. The following items are examples of system validation:

• Except for Entity, all other dimension members should be base/leaf and should not be calculated members.
• Account types are Asset, Liability, Equity, Revenue, Expense, or Save Assumption.
• All of the entries should belong to the same parent. The children currency must be the same, but the parent currency can differ.
• You should have access to all of the journal entry members in the template.

  Watch the following video about creating journal templates:

  Creating Journal Templates

To create a journal template:

1. On the Home page, click Consolidation Journals.
2. Click Journal Templates.
3. From the Templates screen, click Create.

   The Template Details page is displayed.

4. For Label, enter a template label.

   The label can contain a maximum of 50 characters. Do not use spaces or these characters: . + - */ # {} ; , @, or quotation marks.

5. Optional: Enter a template description.
6. From Journal Type, select Standard or Recurring.
7. From Data Source, select a Data Source member.

   The Currency information is populated from the Source Currency type that you specified when creating the Data Source member and is read-only.

8. From Balance Type, select Balanced or Unbalanced. This option is only available if Unbalanced Journals is enabled.
9. From Template Type, select Standard or Recurring.
10. Optional: From Group, select a journal group to assign to the template.
11. To create a journal entry, click the Create button above the Debit and Credit columns.
12. To select dimension members, use one of these methods:

    • Enter the member name in the text box.

    • Select a row in the line item table and from the Actions icon, click Pick Members to open the Member Selector, select members for the dimensions on that row, and then click OK.

    • Select an existing row, click Actions, and then Copy Row, then select another row and click Paste Row.

    When you create line items, you can add a line item description of 100 characters maximum.
13. Optional: To delete one or more template entries, select the row and from Actions, click Delete.
14. Enter the adjustment amounts in the Debit or Credit columns.
15. Optional: To scan the template and verify that journal entries are valid, from Actions, click Scan.
16. Optional: To print the template details page, from Actions, click Print, and then print the page from your browser printing functionality.
17. Click Save to save the template.
18. Optional: From the main Templates page, click Refresh to refresh the template list and display the new template.