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.

• 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).