GL> Reports> Budget Adjustment

Budget Adjustment Report

 

Summary

 

The Budget Adjustment Report displays the budget adjustments and transfers that occurred during a selected time period and/or in a selected range. Budget adjustments are added to GL accounts using the Budget Adjustments process in the GL module (GL> Budget Adjustments). You can view the budget adjustments attached to a GL account using the Chart of Accounts Maintenance window (GL> Maintenance> Chart of Accounts> Budget tab> Budget Adjustments section).

 

The budget Adjustment Report will not include budget adjustments created by purchase orders that were rolled-over in the Purchase Order module (PO> Roll Over POs).

 

Related Links

 

Click here for information on the Chart of Accounts Maintenance window.

Click here for information on the Jobs Viewer window.

 

Step by Step

 

1     Open the Budget Adjustments window (GL> Reports> Budget Adjustment).

 

2     Configure the report. 

 

  • The Post Date From and Post Date To fields are used to filter the budget adjustments included in the report by post date. The post date and transaction date of a budget adjustment are always the same value.
    • The post date of a budget adjustment is the date the budget adjustment was committed in Budget Adjustments batch (GL> Budget Adjustments> Commit).
    • You can view the post date of a budget adjustment on a GL account using the Chart of Accounts Maintenance window (GL> Maintenance> Chart of Accounts> Budget tab> Budget Adjustments section> Transaction Date field). The transaction date and post date of a budget adjustment are always the same value.
  • Enter the Fiscal Year of the budget adjustments you would like to include on the report.
  • Select the level of detail you would like to include on the report in the Report Type drop-down menu.
    • Select Detail if you would like to include the description and date of each budget adjustment on a general ledger account.
      • The transaction date that will display on the report is post date of the budget adjustment batch that created the budget adjustment.
      • The Description of the budget adjustment is entered in the Description field when the budget adjustment is created in GL> Budget Adjustments> Edit Adjustments>Description field.
    • Select Summary if you would like only the total budget adjustments on each general ledger account to display on the report.
  • The From Account Number and To Account Number fields are used to filter the GL accounts included in the report.
    • Click the From Account Number or To Account Number field search icon to select a general ledger account from a list.
  • Check the Include inactive accounts toggle to include inactive GL accounts on the report.
    • GL accounts are active if the Account is Active toggle is checked on the GL account maintenance window.
      • You can view the Account is Active toggle for a GL account on the Chart of Accounts Maintenance window (GL> Maintenance> Chart of Accounts> General tab).
    • Budget adjustments cannot be posted to inactive GL accounts. An error message will display if a user tries to create a budget adjustment on an inactive GL account.
  • The Budget Adjustment Summary report will display the GL Account Number, GL Account Description, Beginning Budget, adjustment Amount and Current Budget.
  • The Budget Adjustments Detail report will include everything displayed on the Summary report as well as the Adjustment Date, Transaction Description, Transfer Description and report totals.
  • Since the report does not contain budget adjustments due to purchase order roll overs, the adjusted budgets for the general ledger accounts in this report could be different from the budgets that display on the Budget tab of the Chart of Accounts Maintenance window (GL> Maintenance> Chart of Accounts> Budget tab> Budget 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 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 icon next 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 click SUBMIT.
  • 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.