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

InsightCubes Cloud Consolidation – Journals

Using the Journals dashboard with SAP Analytics Designer

The journal interface in SAP Analytics Cloud was built using SAP Analytics Designer, allowing entry of adjustments for specific audit trail (type – manual) to impact the standalone or consolidated balances. These debit and credit balances can be manually entered or uploaded from an excel file. Each journal can be saved, posted/unposted, locked/unlocked and deleted. This provides the full set of functionalities to manage journal entries among subsidiaries and their respective holding companies.

Typically, after the Consolidation process has been executed, if specific Eliminations or reclassifications are required, journal entries are done to record such adjustment. However, journals can be used for any kind of adjustment, as long as the end user is aware of the inherit impact of the entry type, based on the selected audit trail. Journal Entries can be subject to currency conversion and/or consolidation, or top side entries without any consolidation and/or currency conversion, based on the selected audit trail.

Each journal has a unique ID, making it easily retrievable and identifiable. A Journal can have multiple debit and credit entries, for a specific combination of accounts, entities, flows and partner companies (InterCo), influenced by the journal context. These entries can be saved (parked in the journal table) and posted (written to the consolidation data foundation as adjustments to existing entries), unposted and deleted.

To create a new Journal in the SAP Journals dashboard, first click Create New Journal, the Journal ID is automatically created. 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.

Enter a Journal Description
Select Scope from dropdown of the journal context
Select Currency from dropdown of the journal context
Select allowed Audit member from the list
Enter date in the input field of the journal context

Click the plus sign to add a row and fill in the cells either manually, if you know the member ID, or through selecting the members from the dimension’s popups.

Member selector
Member selector popup

Alternatively, you can mass upload the entries from excel by clicking on the “Import” button, pasting the excel entries in the “input field” and clicking on Import.

Import Button
Copy/paste Journal Entries from Excel File into the import popup

After the entries have been added to the journal, you can proceed by saving them.

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.

Check Journal Entries on the table

By clicking on Post Entries, the values will be published to the consolidation model. Any existing amounts will be adjusted by the incoming debit/credit values based on the account types.

“Post Entries” Button

Only the users that are assigned Journal Manager role can now Lock the Journal. This will prohibit any change to the journal entries made, saved and posted.

Journal Locking

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.

Unlock Journal

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.

“Un-post Entries” Button

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.

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.

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.

Selected Journal (JRN_14) opened

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

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.

Data Interaction

Recent Posts

account configuration guide for the consolidation extension

Account Configuration Guide

Consolidation Extensions’ Account Configuration Guide The Account Configuration Guide serves as a preconfigured administrative tool designed to guide users with specific roles to effectively manage

Configuration Starter Kit

Consolidation Extensions’ Configuration Starter Kit The configuration of the Consolidation Extension for SAP Analytics Cloud can be conducted using a preconfigured toolkit. The purpose is

Audit Trail Configuration Toolkit for the consolidation extension

Audit Trail Configuration Toolkit

Audit Trail Configuration Toolkit Audit Trail Configuration Toolkit provides a comprehensive set of tools and resources to help developers easily configure the behavior of the

Scope configuration guide for the consolidation extension

Scope Configuration Toolkit

Scope Configuration Toolkit With our Scope Configuration Toolkit, you can take control of your consolidation scopes with confidence and precision. This interface makes it extremely

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.