Summary

The Trial Balance Report will display the change in balance of general ledger accounts over a selected period of time. The Trial Balance Report will not display activity across more than one fiscal year.

Step by Step

1     Open the Trial Balance window (GL> Reports> Trial Balance).

2     Configure the report.

• The Account From and Account To fields are used to filter the GL accounts that display on the report.
  • The function of the Account From and Account To fields will change depending on the GL account numbers entered into the window.
    • If the value in a GL account section is the same in the Account From and Account To fields, then only GL accounts that have that value in that section will be included on the report. For example, if you enter 01-20- and 05-20 in the Account From and Account To fields, all GL accounts between fund 01 and 05 with department 20 will be included on the report (01-20-001, 02-20-545, 03-20-111, 04-20-999, 05-20-555, etc.).
    • If the value in a GL account section is not the same, then that section of the GL account will be treated as a range. For example, if you enter 1-1-0001 and 1-1-0050, the fund and department sections are the same, so only GL accounts that are 1-1- will be included on the report. Since the account number portion of the GL account is different ( - -0001 and - -0050), that section will be treated as a range. The report in this example will include all GL accounts between 1-1-0001 and 1-1-0050.
  • Click the Account From or Account To field label to select the account number from a list. Make sure you select the correct fiscal year when selecting a GL account number. If the GL account does not exist in the fiscal year selected in the Fiscal Year field, then no information will display on the report.
• Enter a range of fiscal periods to filter the report in the Period From and Period To fields. The period range will default to the current fiscal period.
  • Enter the same fiscal period in the Period From and Period To fields to include a single fiscal period.
• The Fiscal Year field will default to the current fiscal year. Enter a fiscal year or click an Arrow icon to increase or decrease the fiscal year.
• The Include drop-down menu is used to filter the GL accounts included in the report by ALFRE designation.
  • Select Balance Sheet Accounts if you would like to exclude revenue and expense GL accounts from the report.
• The Report Type drop-down menu is used to select the information that will display on the report.
  • The Summary version of the report will display the GL account number, GL account description, budget amount, beginning balance, debits and credits of the selected fiscal periods, and ending balance of all accounts included in the report.
    • The Summary report will only display the total credits and debits of the journal entries posted to the GL accounts. The report will not display the journal entry line items that created the debit and credit amounts.
  • The Detail version of the report includes all of the information on the Summary version as well as the detailed journal entry history and the batch number where applicable.
• Check the Include uncommitted journal entries toggle to include uncommitted manual journal entries on the report.
  • Checking this toggle will not include uncommitted AP invoice batches or other transactions in the report, it will only include uncommitted manual journal entries created in GL> Journal Entries> Edit Journal Entries.
• Check the Include inactive accounts toggle to include inactive GL accounts on the report.
  • GL accounts are active if the Account is Active toggle is checked on the GL account maintenance window.
    • You can view the Account is Active toggle for a GL account in GL> Maintenance> Chart of Accounts> General tab.
  • Transactions cannot be posted to inactive GL accounts. When the GL Distribution report is run on a batch process, the report will generate an error message that lists the inactive GL accounts.
• Check the Include expense liability detail toggle to include the description of the AP invoice line items on the report.
  • The AP Invoice line item description is entered in the Description field when an Invoice is created in AP> Invoice> Enter Invoices.
• Check the Print Inactive accounts only toggle if you only want inactive GL accounts to display on the report.
  • If you want to print a list of all inactive GL accounts, leave the Account field blank and select All in the Include drop-down menu.
  • GL accounts are inactive if the Account is Active toggle is not checked on the GL account maintenance window.
    • You can view the Account is Active toggle for a GL account in GL> Maintenance> Chart of Accounts> General tab.
• Check the Page break by fund or Page break by department toggles to configure how the report will be displayed.
• The budgeted amount displayed in this report is the Budget field in Chart of Accounts Maintenance window (GL> Maintenance> Chart of Accounts> Budget tab). The Budget field is used instead of the Adopted budget field because it contains any budget adjustments (GL> Budget Adjustments) to the budget made after the budget has been adopted. This includes adjustments made to the general ledger account budget due to rolling over purchase orders.
  • The Budgeted Amount column is the total fiscal year budget. If you are dispersing the fiscal budget to specific fiscal periods that information will not be reflected in this report.
• The Debits and Credits fields are filtered by period should be the same as the amounts in GL> Maintenance> Chart of Accounts> Balance tab.

3     Print the report.

• Click the Print icon to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time. You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).
  • Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
  • Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
  • Click the Print icon drop-down menu and select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
  • Once the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report).