1. Working with Financial Consolidation and Close
  2. Working with Consolidation Journals
  3. Managing Consolidation Journal Templates

Managing Consolidation Journal Templates

You can create a Consolidation journal template to post adjustments that have common information, such as entities or accounts. Then you can use the template to create journals with similar information. Journal templates simplify the journal creation process and are useful for journals that need to be created for every period.

You can create two types of Consolidation journal templates:

  • Standard templates, which contain accounts and entities for adjustments that you enter frequently.
  • Recurring templates, which contain complete information for identical journal entries that occur for more than one period. When you open a journal period for a recurring template, journals are automatically created with a Working status.

From the Templates page, you can view a list of all of the journal templates that you have in the system. The Template list displays the label, description, template type, journal type, balance type (if Unbalanced Journals is enabled), Data Source member, currency, and group. You can select which columns to display, sort the list by column, or sort it by alphabetical ascending or descending order. The Entity, Created By, and Created Date columns are hidden by default. If you select to view the Entity column, the templates display multiple times for multiple-entity templates.

You can filter the template list to find templates based on selected criteria. You can filter the list by Label, Description, Entity, Template Type, Journal Type, Balance Type (if Unbalanced Journals is enabled), Data Source member, Currency, or Group. You can enter text filters, including the percent sign (%) as a wildcard, or leave a text block blank to avoid filtering on the text.

To view the list of journal templates:

  1. On the Home page, click Consolidation Journals.
  2. Click Journal Templates.
  3. To view template details, click a template label.
  4. Optional: To filter the list of templates, click the Filter icon, select filter options, and then click Apply.
  5. Optional: To select columns to display, click View, then Columns, and select the columns to display, or select Show All.
  6. Optional: To change the column sort order, click the header icons and select Sort Ascending or Sort Descending.
  7. To refresh the list of templates, click Refresh. Any new templates that you created will be displayed after the refresh.