to select the Department assigned to accounts to be included on the report. One or more Departments may be selected. If the field is empty, all active Departments will be considered for inclusion on the report.GL Trial Balance displays the closing balances of the general ledger accounts. The balances of the ledgers are added to the debit and credit columns. The total of these two columns should match.
Internal Company – The company from which the data is being reported.
From Period – Select the oldest period to include data from.
Thru Period – Select the most current period to include data from.
Summary or Detail – Select Summary to have the transactions summarized based on the additional filter selections. Select Detail to display individual transactions. Select Subledger to display individual transactions for the activity in the module specified in Module, as well as summary lines for all accounts that had no activity in that module. The Subledger option allows you to look at the entire trial balance, with a detailed view of transactions from the activity in the specified module. This option defaults to Detail.
Module – If you selected Subledger in Summary or Detail, select a module from the dropdown list to report individual transactions for only what was entered in that module. Options include Payables, Receivables, Billing, Cash, General Ledger, Inventory, Projects and Purchasing.
Note: While it is possible to specify a module when you have selected Summary or Detail in the Summary or Detail field, the Module field is intended to be used, and gives predictable results, only when you have selected Subledger.
Sort By – Select the option from the dropdown list to use to sort the report. Options include Account Code, Account Type, and Account Type and Category.
Include Year End Closing Entries – Select the option from the dropdown list that represents which closing entries, if any, to include on the report. Options include Exclude Year End Closing Entries, Include Year End Closing Entries and Year End Closing Entries Only.
Print Zero Balances – Select this check box to include accounts with a balance of 0.00 for the time period selected. This check box defaults to unchecked.
Exclude Voided Items – Select this check box to exclude voided transactions. The check box defaults to unchecked.
Show Account Totals – Select this check box to show totals for each account. The check box defaults to checked.
Show Category Totals – Select this check box to have totals summarized by account category. This check box is unchecked by default.
Show Type Totals – Select this check box to have totals summarized by account type. This check box defaults to unchecked.
Show Period Totals – Select this check box to have totals summarized by fiscal periods. This check box defaults to unchecked.
Account – Select the account(s) to be included on the report. Selecting a single account allows the activity for a given account and a given period (or range of periods) to be analyzed. This is helpful when tracking down historical activity or tracing a transaction through the system.
Department – Click Lookup to select the Department assigned to accounts to be included on the report. One or more Departments may be selected. If the field is empty, all active Departments will be considered for inclusion on the report.
Territory – Click Lookup to select the Territory assigned to accounts to be included on the report. One or more territories may be selected. If the field is empty, all active Territories will be considered for inclusion on the report.
Product – Click Lookup to select the Product assigned to projects to be included on the report. One or more products may be selected. If the field is empty, all active Products will be considered for inclusion on the report.
Dimension 4 – Click Lookup to select the Dimension 4 values assigned to accounts to be included on the report. One or more values may be selected. If the field is empty, all active Dimension 4 values will be considered for inclusion on the report.
Dimension 5 – Click Lookup to select the Dimension 5 values assigned to accounts to be included on the report. One or more values may be selected. If the field is empty, all active Dimension 5 values will be considered for inclusion on the report.
Dimension 6 – Click Lookup to select the Dimension 6 values assigned to accounts to be included on the report. One or more values may be selected. If the field is empty, all active Dimension 6 values will be considered for inclusion on the report.
Dimension 7 – Click Lookup to select the Dimension 7 values assigned to accounts to be included on the report. One or more values may be selected. If the field is empty, all active Dimension 7 values will be considered for inclusion on the report.
Dimension 8 – Click Lookup to select the Dimension 8 values assigned to accounts to be included on the report. One or more values may be selected. If the field is empty, all active Dimension8 values will be considered for inclusion on the report.
Starting Account – Enter an account number to use as the starting account to filter the data that is included on the report to a specific account or range of accounts.
Ending Account – Enter an account number to use as the last account number to filter the data that is included on the report to a specific account or range of accounts.
For information about using this report in the financial reconciliation process, see Reconciling Account Balances.