SB Enterprise Help Center

GL Account List Report

Updated on

Summary

The Account List Report displays a list of general ledger accounts filtered by fund, status and fiscal year. The information that displays on the report depends on the selections in the Account List window.

Step by Step

1     Open the Account List window (GL> Reports> Account List).

 

2     Configure the report. 

  • Enter a Fund or leave the field blank to print a list of accounts in all the funds in the chart of accounts.
  • The Fiscal Year field will default to the current fiscal year. Enter a fiscal year or click the arrow button to increase or decrease it.
  • Select to status of the GL accounts you would like to include in the report in the Account Status drop-down menu.
    • Select All to include both active and inactive GL accounts on the report.
    • You can view the status of a GL account in GL> Maintenance> Chart of Accounts> General tab> Account is Active toggle.
  • Select the Print Format for the report. The selection will affect what information displays on the report.
    • The portrait format will display the GL account number, GL account description, account type and budget amount.
      • The budget amount that displays on the report in the Budget column is the current budget amount. After the Fiscal Year End Reset process (GL> Utilities> Fiscal Year End Reset) has been run, the adopted budget will be copied to the current budget. Budget amounts that have not been copied to the current budget amount will not display on the report.
      • The budget amount will only display on the report if the Account is Budgetable toggle is checked on the GL account (GL> Maintenance> Chart of Accounts> General tab).
    • The landscape format will display all the information that displays on the portrait format plus the ALFRE designation of the GL accounts. Selecting the landscape format will also enable the Include Goto Accounts toggle on the window.
      • If the Include Goto Accounts toggle is checked, the Account List Report will include the goto accounts and goto account distribution percentage.
      • The ALFRE designation is added to the Account Type, which is added to a GL account in GL> Maintenance> Chart of Accounts> General tab> Account Type field.
  • The Include Goto Accounts toggle will only be enabled if you print the report in landscape format.
    • Check the Include Goto Accounts toggle if you would like include to the goto accounts and goto distribution percentage on the report.
    • You can view the goto accounts on a GL account in GL> Maintenance> Chart of Accounts> General tab> Goto Accounts section.
  • The Chart of Accounts List report in portrait format will display the GL Account number, account description, account type, budget, Sub Ledger 1, Sub Ledger 2 and Reference field.
    • The amount in the budget column is pulled from the Budget field in GL> Maintenance> Chart of Accounts> Budget tab. The Budget field is used instead of the Adopted budget field because it contains any 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 and budgets adjusted in GL> Budget Adjustments> Edit Budget Adjustments.
  • The Chart of Accounts List report in landscape format will display all of the information in the portrait format plus the ALFRE designation.
    • If you check the Include Goto Accounts toggle, the landscape format report will display the Goto accounts and the Goto % of each goto account.
      • The reference column on the report is the Reference field that displays in the GL> Maintenance> Chart of Accounts> General Tab> Reference Number field. This field can be used as an account alias field.

 

3     Print the report.

  • Once the required report settings have been specified, click the Print button   to print your report.
  • Click the options arrow on the right side of the Print button to see other print options.
    • Select Send PDF to Job Viewer to print the report in the default Springbrook format.
    • Select Send Excel to Job Viewer to export the report data to an Excel spreadsheet as unformatted data.
    • Select Send Excel (Formatted) to Job Viewer to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
  • Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
    • Scheduled printing has not yet been enabled for reports generated from process batches. This functionality will be released in an upcoming service pack.
  • Users can also regenerate a report with the same configuration as a prior report via the report history section. This can help improve efficiency when an identical report is frequently generated.
    • Once a report has been generated, the date and time it was generated will display in the report history accessed via the Expand Arrow button on the right side of the window.
    • Expand the report history and click on a previous report record to automatically populate the report criteria with the criteria specified on the previously generated report. This section will display the last three times the report was generated.
Previous Article GL Account Analysis Report
Next Article GL Account Type Report
Still Need Help? Contact Us