Creating Standard Journal Templates

You can create a journal template when you need to post journals that have common adjustment information. For example, you can create a template that contains information such as common entities or accounts, and use the template as the basis for journals that contain similar adjustment information.

When you create a template, you select whether the journal is balanced, balanced by entity, or unbalanced. In a balanced journal, the total debits and credits must balance per journal entry before you can post the journal. In a balanced by entity journal, the debits and credits must balance for each entity included in the journal entry. In an unbalanced journal, the debits and credits do not need to balance before you can post the journal.

Web Procedure

  To create standard journal templates:

  1. In the Browser View, expand Tasks, and select Journal Tasks.

  2. Select Manage Journal Templates.

  3. Select Standard and click New.

  4. 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. Optional: From Group, select a group to assign to the journal.

    Note:

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

  6. From Balance Type, select a balance type: Balanced, Unbalanced, or Balanced by Entity.

  7. Optional: From Security, select a security class.

  8. Optional: Enter a template description.

  9. For each dimension, enter a member or click Pick Members to select members.

    Tip:

    You can also double-click the dimension to display the Pick Members dialog box, or you can right-click and select Pick Members. When you select an account, only the valid ICP or Custom members for that account are displayed.

  10. Enter an adjustment in the Debit or Credit column.

  11. Take one of these actions:

    • To add rows to the template, click Add Rows. Rows are added to the bottom of the grid.

    • To save the template, click Save.

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

    • To preview and print the template, click Print.