Automatic Journal

Automatic journals are used to post necessary adjustments for the previously declared or posted data. In consolidation, in addition to converting entity data into a common group currency and combined data, additional consolidation entries have to be posted.

Prerequisites

Automatic Journal works based on the defined dataset, version, and currency type, group subtype, account, flow, and ownership type fields. These fields are based on the tagged Model used for the calculation. There are no required property dataset, account, and flow fields; however, the method is a required property in the ownership structure to have the relationship field working. Please check the Fields article in the Modelling section for more information.

Actions required to generate Automatic Entries for Consolidation can be summarised below:

1. Currency conversion to group currency based on ownership structure.

2. Intercompany eliminations

3. Automatic journals

   • Auto adjustments

   • Reclassifications

   • Manual journals

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

Automatic Journals will filter input data when Applicable to and Relationship conditions are met. This is like creating a joint between the consolidation and ownership model to apply filter criteria.

1. Apply Formula.

2. Post Debit and Credit Entries to:

   • Consolidation Model (Existing data is updated).

   • Journal table (Existing data is updated).

   • Audit table (Only delta records are posted).

Features

Creating the Automatic Journal group calculation details:

1. Output Dataset: The user should be able to select from the dataset field the dataset to be used to record and save the result of the calculation. It can also be set the same as the source or the same as the input account and flow fields.

2. Applicable to: The user should be able to set the version and groups field member.

3. Active: An option for the user if the set automatic adjustment rule will be parked (inactive) or activated as ticked.

Automatic Journal calculation details:

1. Description: Rule details description.

2. Input Dataset: Dataset field member to be used in the calculation.

3. Input: Account and flow field member to be used as an input reference for the calculation.

4. Formula

5. Debit: The user should be able to set the debit account and flow to be used.

6. Credit: The user should be able to set the credit account and flow to be used.

7. Relationship: Entity and intercompany relationship to be used in the calculation. For the relationship option, the user should have an option to swap entity, Swap Entity-Interco, and intercompany as well as the posting to intercompany balances, Post to Interco Balances.

8. Insert Posting of Automatic journal calculation: The user should be able to create a new automatic journal line item rule with the group of calculations.