GeneralLedgerCS > General Ledger > Reporting menu > GL Trial Balance window
 
GL Trial Balance window
Use this window to run a trial balance to check the balances in each account and verify that debits and credits are equal.
Fund Number (Fund product only) 
Enter a fund number to show only accounts in that fund on the report.
Print All Funds (Fund product only) 
This drop-down is only active if the Fund Number field is blank. If you want to print one report that displays all the included funds, select Combined from the drop-down. If you want to print a separate report for each fund, select Separated.
Starting Period / Ending Period 
Enter the starting and ending period numbers that you want to include in the report. You can choose any periods in your fiscal calendar, from 0 to 60 (period 0 is balance forward amounts). If you want to include only one period in the report, enter the same number in both the Starting Period and Ending Period boxes. The defaults for these boxes are the Present Period as shown in your fiscal calendar.
When you enter the period number, the first date of the starting period and the last date of the ending period will appear to the right of the corresponding boxes so you can verify that these are the periods you want to include in the report.
(Fund product only) If the Allow multiple fiscal calendars check box is selected in Module Preferences and the fund calendar is different than the organization calendar, the fund’s organization calendar will be used for these dates.
Report Type (Fund product only) 
Select the type of report you want to run from the drop-down. Your choices are:
Combine Actual and Encumbrance: This shows the actual and encumbrance amounts combined for the selected account(s).
Separate Actual and Encumbrance: This shows the actual and encumbrance amounts separated for the selected account(s).
Show Actual Only: This shows only the actual amounts for the account(s).
Show Encumbrance Only: This shows only the encumbrance amounts for the account(s).
Show All Movement: This shows the starting balance, ending balance, all adjustments, and transactions for the selected period.
Use Account Filter 
Select this radio button and enter a filter to use to print a customized report which includes only those accounts that meet the filter criteria.
Account Filter 
If you selected the Use Account Filter check box, enter the filter you will use here. Only accounts that match the specified filter criteria will appear on the report. Use wildcards (* and ?) to establish the filter parameters. Substitute a (?) for any single character in the account number, or an (*) for any number of characters. For example, to include all four-digit accounts beginning with a 1, enter 1??? in the Account Filter box. To include all accounts that end in 02, enter *02.
Skip Zero Balance 
Select this check box to exclude accounts that have a zero balance for the specified time period on the report. If the accounts have a balance, but not in the time period shown on the report, they will not appear on the report.
Print Consolidated Ledgers (Accounting product only) 
Select this check box to include information from all companies that have been consolidated with the current company. Be sure to consolidate your ledgers in the Consolidate Ledgers window before you run this report with this option.
Sort by Fund (Fund product only) 
This check box is only active if you select Combined from the Print All Funds drop-down. Select this check box if you want to sort the included accounts by fund number.
Enable Drilldown 
Select this check box to print a report that allows you to drill down to view individual transactions. Choose any line on the report for which you want more information and double-click. A new report page will open showing transaction information specific to the line you selected. You can only run this report for periods 0 to 12/13 (Business product) or 1 to 12/13 (Fund product). You can only print this report to screen.
Include Inactive Accounts 
Select this check box if you want to include inactive accounts on the report. You can mark accounts inactive in the GL Accounts window. If you have a balance in your inactive accounts and you don’t include them on the report, your report might be out of balance.
 
 
Published date: 03/18/2020