Summary

The Budget Totals by Account Type Report displays the requested, proposed, approved and adopted budget amounts of a fiscal year totaled by GL account type. The report will not display period budget information.

GL account types are attached to GL accounts in order to define the ALFRE designation of the GL account. Account types will display on the report if they are attached to GL accounts that are set up as budgetable. GL accounts are set up as budgetable if the Account is Budgetable toggle is checked on the GL account (GL> Maintenance> Chart of Accounts> General tab).

If the GL chart of accounts is set up for full chart budgeting, the budget amounts on all GL accounts that are set up as budgetable will display on the report. If the GL chart of accounts is set up to only budget for revenue and expense ALFRE designated GL accounts, only revenue and expense account types will display on the report. (If the GL chart of accounts is set up to budget only revenue and expense accounts, the Account is Budgetable toggle on the GL account will not be enabled on asset, liability and fund balance account type GL accounts. The toggle can still have a check in it, but the toggle value will not apply.)

Step by Step

1     Open the Budget Total by Account window (GL> New Budget Information> Budget Totals by Account).

2     Configure the report.

• The Account Type field is used to filter the report by account type.
  • Click the Account Type field search button to select an account type from a list or leave the field blank to include all account types on the report.
  • Account types are created in GL> Maintenance> Account Types.
  • Account types are attached to GL accounts in GL> Maintenance> Chart of Accounts> General tab> Account Type field.
• The Fiscal Year field is used to select the fiscal year of the general ledger accounts you would like to include on the report.
  • The Fiscal Year field will default to the current fiscal year plus one. Enter a fiscal year or click an arrow icon to increase or decrease the fiscal year of the general ledger accounts that will display on the report.
• The Budget Total by Account Type Report will display the ALFRE designation, account type, account type description, and the requested, proposed, approved, and adopted budget amounts. The report will be sorted and totaled by ALFRE designation and the account types will display on the report in alphabetical order.

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.