SB Enterprise Help Center

GL Budget Adjustment Report

Updated on

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

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> Create icon> 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 label 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.

  • 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).
Previous Article GL Balance Sheet Report
Next Article GL Budget Status Report
Still Need Help? Contact Us