✆ UAE: +971 58 5616 616, ✆ USA:+14099168409,   ✉ info@insightcubes.com

InsightCubes Consolidation Extension for SAC – Journals

Overview and Purpose of Journals

Users with journal entry rights can create and manage journals with unique IDs, allowing them to enter adjustments directly into debit and credit fields. When entering journals, users can select specific audit trail members, which determine whether the journal will undergo currency conversion, be included in consolidation, or be affected by other logic. Journals can be applied at the entity level or as top-line adjustments on consolidated balances, with entries made manually or uploaded from an Excel file. Users have full control over their journal entries, including the ability to save, post, un-post, lock, unlock, and delete them, ensuring accurate financial management across subsidiaries and their holding companies.

How to use the Journals Dashboard of the Consolidation extension for SAP Analytics cloud step-by-step

Introducing New Design and Theme Options!
Announcing a major update to all our dashboards! We’ve undergone a comprehensive design revamp, bringing a fresh, modern look and feel to enhance your user experience.

Journal Dashboard in light theme mode

Now you can easily toggle between themes based on your visual preference or ambient lighting, ensuring optimal readability and comfort.

Understanding Journal Entries in the Consolidation Extension for SAC

Users can create different types of journal entries to address various scenarios during the consolidation process. While the Consolidation Extension for SAP Analytics Cloud (SAC) automates most eliminations and adjustments, there are instances where manual one-time entries are necessary. Journals serve this purpose.

Journal entries may involve currency conversion if entered at the entity level in local currency, or they might be recorded directly in the reporting currency. Some entries are subject to consolidation rules when made at the entity level, while others function as top-line entries in group currency. The treatment of these entries during the consolidation process is determined by the selected audit trail members, which govern the rules applied to the values. Additionally, audit trail members dictate whether journals are carried forward to the next year’s opening balances or not.

Journal governance is crucial, linking roles and authorizations to ensure control over the process. The Consolidation Extension for SAC allows for the differentiation between users who can create journal entries and those who can post them, following approval. Furthermore, granular permissions can be set to determine who can edit, un-post, or unlock journals, ensuring proper oversight and security throughout the process.

Creating new Journal entries

Enter the description and select all the intersections you want to save the data records on from the dimensions dropdowns: version, currency, scope, audit, and date.

Provide a journal description and adjust the context using the dimension dropdowns.

Choose the version (actual, budget, plan, or forecast), select the currency (reporting or local), define the scope (impacting consolidation or standalone), determine the adjustment type under audit, and specify the date (year and month) for your journal.

Select Audit Trail

Enter the description and select all the intersections you want to save the data records on from the dimensions dropdowns: version, currency, scope, audit, and date.

Click the plus sign to add a row, then fill in the cells either manually, using the member ID if known, or by selecting members from the dimension popups.

Opening the member selector to select the entity of the newly created journal using the Journal Entries Dashboard of the consolidation extension for SAP Analytics Cloud
Member selector
Member selector popup to select entity member for the new journal entry using the Journal Entries interface of the consolidation extension for SAP Analytics Cloud
Member selector popup

Mass data entry

Alternatively, you can conduct a mass upload of Journal entries from Excel.

Simply click the “Import” button, paste your Excel data into the provided input field, and then click “Import” to efficiently create all the journal entries at once.

Importing data from excel into the journal entries interface of the consolidation extension for SAP Analytics Cloud
Import Button
copying data from excel to paste in the journals entries interface of the consolidation extension for SAP analytics Cloud
Copy/paste Journal Entries from Excel File into the import popup
Pasting data from excel into the journal entries dashboards popup in the Journal Entries Dashboard of the consolidation extension for SAP Analytics Cloud
Paste and import data from Excel

Saving data

After the entries have been added to the journal, you can proceed clicking the “Save button” to temporarily store your journal entries without finalizing them. This action lets you review and adjust the entries before posting. It ensures your work is preserved and can be edited or reviewed later.

saving entries in the journal entries interface
Save Journal Entries

To check the entered values, which have been saved, you can click on the Report View Button. This will show you the debit, credit and saved values in the journal table.

Checking newly created journal in table view after saving data
Check Journal Entries on the table

Posting entries

By clicking “Post Entries,” the values are published to the consolidation model. This action updates the financial records by adjusting any existing amounts according to the new debit and credit values, based on the account types.

Posting entries to the newly created journal using the Journal Entries interface of the consolidation extension for SAP Analytics Cloud
“Post Entries” Button

Locking Journal

Click “Lock” to secure your journal entry after it has been saved and posted, to prevent any further modifications. Only users with the Journal Manager role have the authority to lock a journal. This step is crucial for maintaining data integrity and preventing unauthorized changes.

Locking the newly created Journal in the Journal Entries interface of the consolidation extension for SAP Analytics Cloud
Journal Locking

Un-locking and un-posting Journal

The same users with Journal Manager role can unlock the Journal. This activity needs to be done if the journal should be unposted, edited and or deleted.

Entries that have been posted can now be unposted. The delta effect is recorded on the consolidation model, for each of the accounts in the journal.

Last, users can delete saved journals in full. This will remove all the entries from the journal table and delete the journal ID and all its properties from the journal table.

Deleting a journal  using the Journal Entries Dashboard of the consolidation extension for SAP Analytics Cloud
Delete Journal

Finding a Journal

To open a previously created journal, click on the Find Journal button, a popup with all the available journals will appear, chose the desired journal and click View Select Journal.

Finding a journal  using the Journal Entries interface of the consolidation extension for SAP Analytics Cloud
Select the journal

To open a previously created journal, click on the Find Journal button, a popup with all the available journals will appear, choose the desired journal and click View Select Journal.

The journal with all the saved and published records on both the InsightCubes Journals Model and InsightCubes Cloud Consolidation Model reports are open.

Selecting a journal using the Journal interface of the consolidation extension for SAP Analytics Cloud
Selected Journal (JRN73141_7) opened in table view

To edit a journal, first click the “Edit Journal” button.

Editing a journal using the Journal Entries interface of the consolidation extension for SAP Analytics Cloud
Edit Journal

Data can be changed from in edit mode table view simple through selecting the data point updating the information and clicking the save entries button.

Editing Journal entries debit and credit amounts using the Journal Entries Dashboard of the consolidation extension for SAP Analytics Cloud
Data Interaction – Edit journal entries in journal view

Recent Posts

Ownership interface of the consolidation solution for SAP analytics cloud

Managing Ownership Structure

Explore how Consolidation Extension for SAC simplifies managing ownership structures, spanning from creating and editing scopes to assigning ownership methods and percentages for accurate consolidation.

Systems Check and Referential Integrity Interface

Learn how SAP Analytics Cloud’s Consolidation Extension ensures data accuracy with system checks and referential integrity, ensuring proper configuration and identifying inconsistencies in design.

account configuration guide for the consolidation extension

Account Configuration Guide

Detailed guide with automated checks and inconsistencies identification on account configure for automated eliminations, cascading behavior, currency conversions and other rules

Configuration Starter Kit

Summary of all the features and automated system integrity rules included in identifying issues with designs covering scope, currency, account, audit, flow and other dimensions

Audit Trail Configuration Toolkit for the consolidation extension

Audit Trail Configuration Toolkit

A guided interface to help you configure the Audit Trail dimension and apply rules covering Copy opening, currency conversion, consolidation, staging, Journals, and others.

Scope configuration guide for the consolidation extension

Scope Configuration Toolkit

Effortlessly create, edit, or delete consolidation scopes, assign parent groups and reporting currencies, and activate staging—all through a user-friendly configuration interface.

Get in Touch

Learn more and ask us About Our Cloud Consolidation Solution

Share This Post

Share this Page!

Share this with your network.

Want to Know More?

Get In Touch

Something isn’t Clear?


Feel free to contact us, and we will be more than happy to answer all of your questions.