Consolidation adjustments report

The Consolidation Adjustments report offers a comprehensive breakdown of the adjustments made during the consolidation process of the group's accounts. This report provides detailed information about the specific adjustments applied to ensure accurate and consistent financial reporting across the group.

To access the Consolidation Adjustments report page, click Reports > Standard Reports > Consolidation Adjustments.

Types of reports

The reports available on this page are:

• Summary (as an ‘index’) report - this report contains only the P&L impact of the adjustments per account and per company. There will be no Debit or Credit figures.
• Detailed report - includes the details of Debit and Credit amounts of the adjustments.
• Detailed with flows report - all the Debit/Credit details of the adjustments, as well as the flows, are included in the report.
• Detailed with dimensions report- all the Debit/Credit details of the adjustments, as well as the dimensions, are included in the report.

Create a consolidation adjustment report

You can create this report for the default consolidation period only.

1. From the Report options, select a report type.

     Note:  If you select either Detailed with flows or Detailed with dimension report, you can opt to display various Journal Types on separate sheets in the Excel output file, or have them separated by a page-break in the PDF output file. To achieve this, select

2. In the Currency type field, select a type of currency — Local Currency or Group Currency.

3. In the Company field, select the company whose adjustments report you want to generate.

4. For Journal Summation select the of journal view(s) on which you want to base your report.

   A journal view is a summation or grouping of several journals. It is used in the reports to get information at different stages or levels in the consolidation process.

5. Select a Journal type. Options include:
   • B - journals from the Bundle Adjustments
   • E - journals from the Events Adjustments
   • M - journals from the Manual Adjustments
   • T- journals from the Automatic Adjustments
   • L- journals from the Local Adjustments

6. In the Journal category field, select the journal category or code you want to use to generate your report.

7. Optionally, in the ModifiedDate field, specify a date to include only adjustments that were modified on that date on the report.

8. In the Minority Flag field, select one of these options:
   • After 3rd Parties (Post-minority Adjustments)- Adjustments are posted after the calculation of the minority interests.
   • Before 3rd Parties- Adjustments are posted before the calculation of the minority interests.
   • Both - Includes both before and after 3rd parties adjustments. Adjustments after 3rd parties have an indicator in the printout.
9. Optionally, in the Accounts field, enter an account code or click to search for one if you want only adjustments that impact the selected account to be included in the generated report.
10. Optionally, in the Partner Company field, select a partner company if you want only adjustments that impact the selected partner in the intercompany transactions to be included in the generated report.
11. Optionally, in the Flow field, enter a flow code or click to search for one if you want only adjustments that impact the selected flow to be included in the generated report.
12. You also have the options to specify the following:
    • Minimum amount - if specified, only adjustments containing amounts up to and not lower than the specified amount will be included.

    • Maximum amount - if specified, only adjustments containing amounts up to and not higher than the specified amount will be included.

13. In the Sorting field, specify how the adjustments on the report should be displayed. Available options are by:

    • Company / Journal ID / Journal Number (based on the Company).

    • Journal ID / Journal Number (based on the Journal Category).

    • Modified Date / Journal Number (based on the Modification date).

14. In the Has attachment field, you have these options:

    • Show All - adjustments with and without attachments are included on the report.

    • Yes - only adjustments with attachments are included on the report.

    • No - only adjustments that do not have attachments are included on the report.

15. In the File type field, select the output file type. Options include PDF, XLS, and XLSX.

16. Click to generate the report. After the report is generated, a download link appears below for you to click and view it in the file type selected.