Trial Balance Consolidated Report

Use this report to print a consolidated trial balance 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 (see below). This only applies if the accounts have the same currency and use the same calendar in each company.

For example, if Company 1 has a NZD general ledger account 01.01.1000 and Company 2 also has a NZD general ledger account 01.01.1000, this report will output the combined balance for account 01.01.1000.

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 debit value
MTD credit value
YTD debit value
YTD credit value

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

You can also print this report for a Single Company or Multiple Companies. The report displays a ledger total, and a list of companies if you selected the Multiple Company option.

If you select the Print in Summary option, only a ledger total will display, balances for individual accounts will not be displayed.

Parameters

These parameters are available when you run 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 that you want 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.

Sequence

You can select the account sequence on which to base the output. These are defined in GL Module Sequences.

Account Tree

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

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.

Period End Date

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

Ledger Currency

Select this option to generate the report in the currency used by the general ledger.