Breadcrumbs

Creating consolidated reports

Accountants Enterprise only

Reporter provides the ability to retrieve financial data from multiple ledgers and display the combined results in any of the reports. The financial figures from all the specified ledgers are combined and reported. This method is also known as simple consolidation.

To generate a report combining values from multiple ledgers:

1. Specify the required ledgers

  1. Open the primary ledger and click Reports > Reporter > Generate Reports. The Reporter window opens.

  2. From the Tools menu, select Current Ledger Configuration. The Current Ledger Configuration window appears with the primary ledger selected.

  3. Click the drop-down arrow on the Ledger field and select the subsequent ledger(s) from the list. The ledger(s) are added to the list of current ledgers.

  4. Click OK. The additional ledgers are added to the values retrieved for the reports.

    The setting applied in the above steps remain in effect for the primary ledger until changed. To remove this setting, repeat the above steps 1 and 2 to access the Current Ledger Configuration, select the subsequent ledger(s) to remove and click the Remove Ledger icon.

2. Preview the consolidated report

  1. Click Reports. The reports list appears in the right-hand pane.

  2. Select the required report and click Preview. The preview is generated and displayed.

  3. In the report preview, click on a common financial figure that reports a consolidated amount (for example, Cash at Bank). The drill down window appears showing the components from the different ledgers. The total of the components equals the consolidated figure.