Consolidated Report

Use this report to print a consolidated report for selected or all companies. The report outputs the combined balance for each general ledger account that exists in the current company (that the report runs from), and also in the companies selected in the parameters. This only applies if the accounts have the same currency, calendar, and budget code (specified as a report parameter).

Header Details

Report process date & time
Page number
Period end date specified in the parameters

Line Details

These details display for each general ledger account, using the parameters selected and the period end date specified. This is based on selecting the Detail option in the parameters:

Account number
Account description
MTD actual value
MTD budget value
MTD variance
YTD actual value
YTD budget value
YTD variance

You can filter the output of this report by tree. Select a tree to specify which branches to include. If you do not want to filter the output by tree, select the option None in the Tree field.

The report displays a ledger total, and a list of companies if you select the Multiple Company option.

Parameters

You can set these parameters for the report:

Report On

Select either Single Company or Multiple Company.

Account Order

Select either By Number or By Description.

Print In

Select either Summary or Detail.

Select Companies

Click the Selection checkbox to include one or more companies in the report.

Select Branches

Select the branches to include in the report.

View Mode

Select one of these options:

All - All records are available, no limitation based on the owner of the record.
Mine - Only the records that are assigned to you are available.
Team - Only the records that are assigned to your team(s) are available.

Budget

Select the budget to base the report on from this list.

Sequence

Select the account sequence on which to base the output. These are defined on the Sequences tab of the General Ledger Module Control form.

Period End Date

Enter the last day of the period for which to generate the report.

Variance

Select > (greater than) or < (less than) from this list. A field displays, where you can enter a value you can compare against MTD/QTD or YTD.

Account From

Enter the first account number in the range of account numbers you want to report on.

Account To

Enter the last account number in the range of account numbers you want to report on.

Tree

Select the account tree to use with the report from this list.