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 in the current company, and also in the companies selected in the parameters. 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 New Zealand dollar general ledger account 01.01.1000 and Company 2 also has a New Zealand dollar general ledger account 01.01.1000, this report outputs 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.

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.

Sequence

You can select the account sequence on which to base the output. These are defined on the Sequences tab of the Module Control form.

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 to generate the report.

Ledger Currency

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