Summary

The Budget Status Report displays the current budget amount compared to the activity during a certain period of time. This report will also display the amount encumbered on purchase orders.

Step by Step

1Open theBudget Statuswindow (GL Reports Budget Status).

2Configure the report.

• TheAccount FromandAccount Tofields are used to filter the report by a specific range of GL accounts.
• Enter part of a GL account number to filter the report to include the accounts in specific GL account sections.
  • The function of theAccount FromandAccount Tofields will change depending on the GL account numbers entered into the window.
  • Each GL account section will be evaluated separately using the following criteria:
    • If the value in a GL account section is the same in theAccount FromandAccount Tofields, 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 theAccount FromandAccount Tofields, 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 theAccount FromorAccount Tofield search icons 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 theFiscal Yearfield, then no information will display on the report.
• ThePeriod FromandPeriod Tofields are used to filter the transactions that are included in the report. The transactions are filtered by fiscal period.
  • The transactions included in the report will display in the Period Amount column.
  • You can view the fiscal period of the transactions on a GL account using the History tab of the Chart of Accounts Maintenance window (GL Maintenance Chart of Accounts History tab Period column).
• TheIncludedrop-down menu is used to generate the report with only Revenue accounts, only Expense accounts, or both Revenue and Expense accounts.
• Check theInclude inactive accountstoggle if you would like to include inactive GL accounts on the report. If you do not check this toggle, any GL account that is set up as inactive will not be included.
  • GL accounts are inactive if theAccount is activetoggle is not checked on the Chart of Accounts Maintenance window (GL Maintenance Chart of Accounts General tab).
• Check theInclude uncommitted JEstoggle if you would like to include uncommitted manual journal entries transactions (GL Journal Entries) on the report.
  • Checking this toggle will only include journal entry line items in an open GL Journal Entries batch. If a GL account is attached to an AP module invoice (AP Invoices) and the Invoices batch has been reached the GL Distribution step, the journal entry created by that invoice will not be included on the report.
• Check theShow Overbudget Accounts Onlytoggle to limit the report to accounts with a negative YTD variance.
• Check theSuppress Accounts Without Balance, Budget, or Activitytoggle to remove accounts with no beginning balance, a zero budget, or no activity from the report.
• Check theBreak by fundtoggle if you would like to insert a page break after each fund included on the report.
• Check theBreak by Departmenttoggle if you would like to insert a page break after each department included on the report.
• Check theShow PO  Invoice Detailtoggle to include detail of the POs that make up the encumbrance and the invoices paid against the PO below the account lines on the report.
• TheBudget Amountcolumn displays the current budget amount on the GL account. The budget amount includes budget adjustments that have been created and committed in the Budget Adjustments process (GL Budget Adjustments).
  • You can view the current budget on a GL account using the Chart of Accounts Maintenance window (GL Maintenance Chart of Accounts Budget tab).
• ThePeriod Amountcolumn displays the transactions that have been included in the report based on the fiscal periods selected in thePeriod FromandPeriod Tofields.
  • This column will include transactions in uncommitted GL Journal Entries batches if theInclude uncommitted JEstoggle was checked when the report was generated.
• TheYTD Amountcolumn displays the year to date amount of the selected GL accounts.
  • This column will include transactions in uncommitted GL Journal Entries batches if theInclude uncommitted JEstoggle was checked when the report was generated.
• TheYTD Variancecolumn displays the budget amount less the YTD amount.
• TheEncumbered Amountcolumn displays the amount that has been encumbered on purchase orders.
  • An encumbrance is created when a GL account is attached to a purchase order line item and the purchase order is then committed.
• TheAvailablecolumn displays the YTD Variance less the Encumbered Amount.
• ThePercentage Availablecolumn displays the Available amount divided by the budget amount. This will displays as a 0 if the budget amount is less than the available amount.

3Print the report.

• Once the required report settings have been specified, click the Print buttonto print your report.
• Click the options arrow on the right side of the Print button to see other print options.
  • Select PDF to print the report in the default Springbrook PDF format.
  • Select Excel to export the report data to an Excel spreadsheet as unformatted data.
  • 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 a print option is selected, that option will automatically be selected the next time you access the report. For example, if you select Excel from the drop-down menu, the next time you access the report the Excel button will be displayed by default.
• Click the Schedule iconnext to the Print button in order to schedule the report to generate at a later date and time.
  • Enter a Date and Time to generate the report and clickSUBMIT.
• 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. Hover over the Info icon to view the parameters on the previous report.
  • This section will display the last three times the report was generated.