G/L Trial Balance From Summary Totals

This trial balance is based on the summarized totals as defined the last time Summarize G/L For Financial Statements was successfully run.

Note: The alternative Trial Balance report does NOT use summarized totals and the current figures are recompiled each time it is run.

Some of the features of this trial balance report include:

• The output data can be printed or exported to an Excel file for further analysis.
• All accounts or a select range of accounts can be reflected in the report.
• All divisions, a single division, or a selection of divisions can be reflected in the report.
• If multiple divisions are included the divisions can be printed separately or consolidated into totals reflected on one report.
• If the output for multiple divisions is exported to a spreadsheet and is not consolidated, a separate sheet is generated for each division.

The prompts to generate the report or spreadsheet are:

FROM ACCOUNT NUMBER

Leave this field blank for the report to begin at the first account, or select a starting primary account from the window as outlined in G/L Account Search.

This starting selection field always refers to the primary account number, and not the alternate account number.

TO ACCOUNT NUMBER

Leave this field blank for the report to end after the last account, or select an ending primary account from the window.

DIVISION, "ALL" OR "SEL"

• To print the report for a single division, leave this field blank for the Head Office Division, or enter a specific division code, or select a division from the drop-down list.
• Type ALL to include all divisions, in the report.
• Type SEL to select a range of divisions to include in the report, as outlined in Division Select By Region.

CONSOLIDATE DIVISIONS

This prompt only applies if multiple divisions are selected.

Uncheck this box to generate a separate report or Tab on the spreadsheet for each division.
Check this box to combine the account totals for the selected divisions into a single set of totals on a single report or spreadsheet.

PRINT ALTERNATE ACCOUNT#

An optional Alternate Account number can be assigned to each account in Chart Of Accounts.

Uncheck this box to generate the report for the selected list, printing only the primary account #s.
Check this box to print the report using the alternate account numbers. If an alternate account number does not exist for an account in the selected range, then the primary account number is printed.

REPORT OPTIONS

This value defaults to the operator preference as defined in Operators.
Select one of the output options to Print a report or export the data to Excel as outlined in Report Options.

Finished?

Click the ACCEPT button to begin printing the report, or CANCEL to abort.