The Content of the Report

You may generate the ledger report for a group or for a company. The direct subsidiaries belonging to the group and a group total are shown if you only select the group. By selecting a company you can choose to see the report for a specific company. The report can be grouped per company, account or movement accounts.

If you select Analysis of Group Values, the report will display data stored on the original company.

If the Show All Group Levels option is selected, which may only be combined with analysis by account, you will get information about the selected accounts for all companies contributing to the selected group. The information is displayed by level and group and the sub-totals of the groups are shown.

If you select the Alternative Layout of Reported Values option the journal types will be displayed as reported values on subgroups, as if they were removed during consolidation.

Procedure

  1. On the Group menu, click Reports/Ledger Report. The Reports - Ledger Report window opens.
  2. Select the relevant report(s) to generate:
    • By company
    • By account
    • By movement:
    • Analysis of Group Values: Select this option if you want to generate a report by original company per account and automatic journal type for group amounts. This report is useful when eliminations that originates from different companies are booked on a group.

      This option cannot be used together with the other selection options.

    Note: The By Account check box applies if the account specified is not a movement account. If the specified account is the main part of a movement account, then a report containing movements between opening and closing balances is shown if you select by Movement Account (e.g. account 1070 shows OB, movements of the year and CB being part of 1070).
  3. Select Alternative Layout of Reported Values if you want values on subgroups with journal types to be displayed as reported values.
  4. In the text boxes, enter the actuality, period, closing version and contribution version for which you want to generate the report.
  5. In the text box, enter the consolidation type for which you want to generate the report.
  6. If you want to generate reports for all companies within a group belonging to the specified consolidation type, enter the group code in the Group text box and select the check box All Companies - Only One Level.
    Note: If you want to generate a ledger report without having access rights to a whole group, click Company, in the Report Selection area.
  7. If you want to generate reports for one or several companies, clear the check box All Companies - Only One Level and enter the company code for which you want to generate the reports. You must also state which group you want to use as the base for the generation, as you may get different eliminations towards different groups.
  8. If you want to see all details from the bottom, use the check box Show all Group Levels (this option is only available in combination with Ledger Report by Account). Companies in subgroups are summed into subgroup totals, and shows what all companies contribute to the group you have selected, level by level.
  9. Select Consolidated Automatic Journal Types as Base if you want to sum automatic journal types into contribution version Base. If you do not select this option, the automatic journal types originating from a lower level will be specified separately at the subgroup levels, with journal number 0.
  10. Select the Account option button to generate reports for specific accounts and enter the relevant account code(s) in the text box. To limit the list of available accounts, select the Form option button and enter a form within which you want to select accounts, and then select the accounts.
  11. Select the relevant report option buttons:
    • Total (no dimension levels)
    • Extended dimension levels
  12. Click the Preview button to generate the report.