Consolidation Journals and Eliminations
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Consolidation Journals and Eliminations

  • Dark
    Light
  • PDF

Article summary

Basic Navigation Tips

  • Use the Help Resources > Training link under your user icon for additional learning.

  • Online Help (OLH) and Community are also available for more resources.

Standard Journals

Purpose
This section explains how to define and post a standard journal entry (one‑time entries to one or several periods).

How to create a Standard Journal

  1. Select the Scenario, Period, and Company to post to.

  2. Go to Processes > Standard Journals.

  3. Click Add to begin a journal.

  4. Enter a Code (required).

  5. Optionally add a Name.

  6. Select the Period for posting.

  7. Choose the Posting Type.

  8. Select the Reporting currency.

  9. Choose whether the journal will be Auto‑reversing.

  10. Click Add to insert the number of journal entry lines you need.

  11. Enter Debit and Credit amounts.

  12. Save.

  13. After saving, proceed with the appropriate Workflow Entry Actions.

Note: Standard journals must balance.

Dynamic Journals

Purpose
Dynamic Journals are for entries where debit/credit amounts vary by period. A Dynamic Journal includes both (a) the calculation of posting amounts and (b) the posting intersection (dimensions).

How to create a Dynamic Journal

  1. Select the Scenario, Period, and Company.

  2. Go to Processes > Dynamic Journal.

  3. In Properties, click Add to begin.

  4. Enter a Code.

  5. (Optional) Enter a Name.

  6. Select Period(s) for posting.

  7. Select the Posting Type.

    • Note: MTD Posting Type is available—contact Customer Support to enable.

  8. Select the Reporting currency.

  9. Choose whether the journal will be Unbalanced.

  10. Open the Journal Entry tab.

  11. Click Add to insert a journal line.

  12. Enter a Description for the line.

  13. Select the intersection of Dimensions (the “posting string”).

  14. Set Line Type to debit or credit.

  15. Click Rule to open the Rule Box and start the line calculation.

  16. In the Rule Box, build the Line Formula.

  17. Save the mapped dimensions.

  18. If needed, open Advanced Rule for advanced calculations.

  19. Complete the rule calculation.

  20. Check Syntax.

  21. Save the rule.

  22. Return to Journal Entry and complete remaining debit/credit lines.

  23. Save.

  24. After saving, proceed with appropriate Workflow Entry Actions.

Note: Dynamic Journal calculations are processed during Consolidation.

Upload Journal Entries in Bulk

Purpose
How to upload multiple journal entries at once using provided, type‑specific Excel templates.

Download the Excel sample template

  • From the Processes pane, select the desired journal tab.

  • Click the upload icon.

  • Choose Download sample Excel template in the journals upload window.

Notes:
• The template you download is specific to the journal type.
• All fields marked with an asterisk are mandatory.
Do not change any fields in the template.

Upload the file

  1. Click Choose File and select your Excel file.

  2. Click Submit.

Notes:
• Upload all similar journals together using the same template.
• Each template includes field directions—delete those directions before upload.

Elimination Entries

Purpose
How to define an elimination entry (an elimination set is composed of a Due To and Due From reference).

Create an Elimination Entry

  1. Go to Processes > Eliminations.

  2. Click Add to begin a new elimination set.

  3. In Properties, enter a Code (optional Name).

  4. Select the Out of Balance account.

  5. Choose Default values for other Segments:

    • Retain Source Segments (when applicable).

    • Select remaining Default dimensions.

  6. Open the Elimination Accounts tab.

  7. In Account (right side), select an account member (search by Code/Name or check the box).

  8. Identify the Due To and Due From selections.

  9. Set Variance Thresholds as desired.

  10. Save.

Note: Due To and Due From dropdowns are required to generate the Elimination Variance report.


Was this article helpful?