Print a Trial Balance

Use the GL Trial Balance (GTB) program to print trial balances in detail, summary, or worksheet format for an accounting period. See Background and Road Map for more information.

Set your options:
1. Click the Runtime tab to set runtime options. See Set Options for Reports and Inquiries for more information.
2. Click the Selection tab to select specific records.
3. Click the Program tab to set these program specific options:

Field Name

Type / Max Length

Action / Description

Enter a date within the period

Optional

Enter or select the date in the period you want to report, enter a date shortcut or leave blank for the current period. The program uses this date to determine the period on which to report. For example, if your fiscal calendar corresponds to a calendar year and you enter March 23, 2020, the report is produced for 03/2020.

Although normally used for open periods, you can run the GL Trial Balance for a closed accounting period. If the period is closed, the report prints the word CLOSED in the header after the period.

Print summary, detail, or worksheet

Required
1 alphanumeric

Select	To print
S	A summary trial balance with totals for each category.
D	A detail trial balance with balances for each account.
W	An accountant's worksheet with ending balances for each account and blank columns for debits and credits to be used for adjusting entries and financial statement preparation.

Print consolidated trial balance?

Optional

Select if you want to print a consolidated trial balance or leave blank if you do not.

If you select this option and enter a consolidated organization for the Org or Org group Selection option, all organizations in that consolidation are combined into one trial balance.

If you select this option and enter an organization group for the Org or Org group Selection option, all organizations in that group are consolidated into one trial balance.

If you select this option but do not select a consolidated organization or organization group, the trial balance is for one organization.

Include zero balance accounts?

Optional

Select to include accounts that have a balance of zero or leave blank to omit them.

Convert currency?

Conditional/Optional

If the multi-currency feature is active, select to convert different currencies to one currency or leave blank not to do this.

If you do not select this option, you should evaluate only individual account values because totals (of multiple, unlike currencies) may be meaningless.

Convert to which currency

Conditional

If you selected the Convert currency? option, select the currency to convert to.

The default is the company's base currency code, but you can print the report in any other currency for which you have established appropriate exchange rates.

Select currency exchange date

Conditional
10 date

If you selected the Convert currency? option, select the date to use for the exchange rate or enter a date shortcut.

The report uses the exchange rate in effect on this date.

Suppress account type subtotals?

Optional

If selected, subtotals for each account type (i.e., assets, liabilities, capital, revenue & expense) are not included on the report.

Choose the appropriate options:

To	Do This
Review the report on the screen before printing	Click View. See Background for a list of what displays.
Print the report	Click Print. See Background for a list of what prints. Note The report prints immediately if the option Allow device override? in the Date-Output Device Maintenance (ZE) program is not selected. If this option is selected, the program prompts Output device. Accept the default device that displays, which is specified in the Date-Output Device Maintenance program, or enter the name of a different device.
Save these options for future use	Click Save.
Redisplay selected options	Click Refresh. The selected organization/org group description and the calendar date that corresponds to entered date shortcuts are displayed.
Exit the program	Click Exit.