How to use the Consolidation Journal

With this model you can enter journals for consolidation, eliminations and further adjustments to include in your consolidated financial data. It also shows a Trial Balance and Intercompany Schedule for additional information. Your journals are immediately visible in the Trial Balance.

Below is a step-by-step guide on how to use the Consolidation Journal.

1. How to Start

You will find the Consolidation Journal in Essentials -> Update.

Click on the field behind the Run button, and select the desired financial period from the dropdown menu.

Click on the Run button to retrieve the latest version of your Consolidation Journal.

2. Enter your journals

Enter each line of your journal, by selecting the reporting code and entering a description and amount. All amounts need to be entered in your consoliation currency. Whilst you are entering your journal lines, they are immediately visible in the Trial Balance. Once you completed your journal, click Save.

Your journals are automatically included in all consolidated reports.

3. Inserting and deleting rows

You can add a new revenue line via the hamburger icon in the left column. Using that dropdown menu you can also copy, move and delete rows.

4. Save your changes

Once you completed your journal, click Save (or Ctrl+S).

4. Choose from Actions

When working in this journal, you can click the Actions button in the right-top of the screen to open a dropdown menu with further options:

4. Export to Excel or PDF

To export the current layout to Excel, or to a PDF file, or to print it, click the Actions button in the top right corner of the screen, and then select Export data or print.

You can export the report to a large variety of file formats, Excel and PDF being the most often used.

screenshot export excel

By following these steps, you'll be able to enter consolidation journals that are included in your consolidated financial statements.

If you like to read more detailed instructions, click here.

Recommended reading:
Back to top | Overview | Settings

We value your privacy

We use cookies to enhance your browsing experience and analyze our traffic.
By accepting, you consent to our use of cookies.

Accept Reject Cookie Policy