Creating Standard Journal Templates

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

When you create a template, you select whether the journals created from the template are balanced, balanced by entity, or unbalanced.

• Balanced - In a balanced journal, the total debits and credits for the journal must balance before you can post the journal.

• Balanced by Entity - In a balanced by entity journal, the total debits and credits must balance for each entity included in the journal entry.

• Unbalanced - In an unbalanced journal, the total debits and credits do not need to balance before you can post the journal.

To create standard journal templates:

1. Select Consolidation, then Journals, and then Templates.
2. Select New, and then Standard Template.
3. To set the Point of View, click a dimension name and from Member Selection, select dimension members.
4. For Label, enter a template label.

   Note:

   The label can contain a maximum of 20 characters. Do not include spaces in the label and do not use these characters . + - */ # {} ; , @ ”

5. From Balance Type, select an option: Balanced, Unbalanced, or Balanced by Entity.
6. Optional: From Group, select a group to assign to the journal.

   Note:

   The journal group that you assign must exist in the application.

7. From Security Class, select a security class. or use the Default security class.
8. Optional: Enter a template description.
9. For Account, double-click in the row and from Member Selection, select an account and click OK.
10. Optional: To move the dimensions from the POV to the table rows, click Move dimensions to Table.

    Tip:

    To move the dimensions selected for rows to the POV, click in the row and click Move dimensions to POV.

11. Enter an adjustment in the Debit or Credit column.
12. Optional: To add rows, select Actions, and then Add Rows. Rows are added to the bottom of the template.

    Tip:

    To delete entries, select the rows and click Delete Row, or select Actions, and then Delete Row.

13. Optional: To scan the template and verify that journal entries are valid, click Scan.
14. To save the template, click Save.

    Tip:

    To restore the last saved version of the template, click Reset.

15. Optional: To preview and print the template, click Print.