Summary
The Trial Balance Report displays the change in balance of GL accounts over a selected period of time.
Step by Step
1 Open the GL Trial Balance Report window (BT> Reports> GL Trial Balance).
2 Configure the report.
- The JE Date From and JE Date To fields are used to filter the journal entries included on the report by the journal entry date.
- The journal entry date of a receipt entered in the Cash Receipts module is set during the GL Distribution step (CR> Cash Receipts> GL Distribution).
- The Report Type drop-down menu is used to select the level of detail you would like to display on the report.
- Select Brief to create a report that displays GL Account Number, Description, Beginning Balance, Debit Amount, Credit Amount and Ending Balance for the included GL Accounts.
- Select Summary to create a report that displays the same information that is in the Brief Report as well as Journal Entry Date, Business Number, Transaction Date, Transaction Type and Transaction ID for the included GL Accounts.
- Select Detail to create a report that displays the same information that is in the Summary Report as well as the Fee Code, Fee Type and Fee Code Description for the included GL Accounts.
- The GL Account field is used to limit the report to a single general ledger account. Click the GL Account field label to select a GL account from a list.
- If no GL account is specified, the report will include all GL accounts.
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).