Auto Journal Rules

Auto Journal rules enable automated, rule-based postings directly into Consolidation Sheet metrics without relying on manual journal entries or traditional ledgers. A new Auto Journal rule editor allows users to define logic-driven entries using input metric filters, debit/credit factors, and elimination rules. This enhancement streamlines repetitive financial adjustments such as eliminations and reclassifications, improving accuracy and reducing manual effort during the financial close process.

Configurable Logic Components

Users can configure Auto Journal rules with the following logic components:

Input Metric-Level Filtering - Specify which input metrics will trigger auto journal entries. This allows users to target specific data conditions that require automatic adjustments.

Debit/Credit and Elimination Factor Logic - Define debit and credit factors to control how amounts are posted. Elimination factors determine the multiplier applied to filtered data when posting entries.

Output Account-Flow Mapping - Map journal entries to specific Account and Flow dimension members where results should be posted.

Entity and Interco Swapping - Configure relationship options including Swap Entity, Swap Entity-Interco, and Interco, as well as posting to Interco Balances.

Applicability Conditions - Set conditions based on consolidation methods to control when rules execute. Rules can be scoped to specific versions, groups, and other field members.

How Auto Journal Rules Process

The system processes auto journal rules through the following logic flow:

Step 1: Filter Input Data - Apply input metric filters and applicability conditions to identify data that requires automatic journal entries.

Step 2: Check Applicability - Verify that Applicable to and Relationship conditions are met. Automatic Journals will filter input data when these conditions are satisfied.

Step 3: Calculate Debit and Credit Values - Apply the debit/credit factors and elimination factors to determine posting amounts based on the defined logic.

Step 4: Post Results - Post results directly to the Consolidation Sheet based on the output account-flow mapping configured in the rule.

Note: Aggregated execution improves performance by reducing data volume, while logs ensure traceability and audit readiness.

Incorporating Auto Journal Rules in Consolidation

To incorporate Auto Journal rules in the Consolidation sheet action, navigate to Sheet Details > Actions > Group Consolidation. Add matrix and configure by selecting Update Method as Rule, then select from the predefined Auto Journal rules where the same reference sheet is used.

Execution Sequence

Rules defined are executed in the sequence they are defined to address dependencies. Automatic Entries is considered Calculation task and Currency Conversion, Intercompany Eliminations, Automatic Journals are considered Actions under Automatic Entries.

This sequencing ensures that currency conversion occurs first, followed by eliminations, and then automatic journals, allowing each step to build on the results of the previous steps.

Configuration Parameters

Auto Journal works based on the defined Dataset, Version and Currency type Group subtype Account, Flow and Ownership type field. These fields are based on the tagged Model used for the calculation.

Important: Method is a required property in ownership structure to have the relationship field working.

Monitoring and Audit

The execution status can be monitored in the Event Log. Logs ensure traceability and audit readiness, providing a complete record of auto journal entries posted during consolidation.