Summary

The Budget Analysis Report compares the requested, proposed, approved and adopted budget figures of a budget year with the adopted, estimated actual and actual amounts of the fiscal year prior to the budget year.  The report also displays the actual amount of the fiscal year two years prior to the budget year. Only GL accounts that are set up as budgetable will display on the report. If you would like to customize the columns that are included on the report and export the information to a Microsoft Excel spreadsheet, use the Export Budget Analysis feature (GL> New Budget Info> Export Budget Analysis).

Step by Step

1     Open the Budget Analysis window (GL> New Budget Info> Budget Analysis).

2     Configure the report.

• The Budget Year field will default to the current fiscal year plus one. Enter a new budget year or click an arrow icon to increase or decrease the budget year.
• The Account From and Account To fields are used to select GL accounts that will display on the report. All GL accounts will display on the report if you leave the fields blank.
  • Enter part of a GL account number to filter the report by GL account number section such as fund or department.
    • If you would like to filter the report by fund, enter only a fund number in the Account From or Account To fields. All GL accounts in that fund will display on the report.
  • Enter a general ledger account number to filter the account by GL account number. Click the Account From or Account To field label to select an account from a list.
• The Report Title field is used to enter a title on the report. The value entered in this field will display at the top of the report.
• Check the Include uncommitted Journal Entries toggle to include uncommitted manual journal entries on the report. This will not include uncommitted transactions created by batches in other modules such as uncommitted AP> Invoices batches.
  • Manual journal entries are created in the GL module in GL> Journal Entries.
• Check the Include inactive accounts toggle to include inactive accounts on the report.
  • GL accounts are active if the Account is Active toggle is checked on the Chart of Accounts Maintenance window (GL> Maintenance> Chart of Accounts> General tab> Account is active toggle).
  • Transactions cannot be posted to inactive GL accounts. When the GL Distribution report is run on a batch process, the report will generate an error message that lists the inactive GL accounts.
• Check the Include Beginning Balances toggle if you would like to include the beginning balances on the report. This only applies if you have set up asset, liability or fund balance accounts as budgetable since revenue and expense accounts do not have a beginning balance.
  • GL accounts are set up as budgetable using the Chart of Accounts Maintenance window (GL> Maintenance> Chart of Accounts> General tab> Account is budgetable toggle).
• Check the Round Actual toggle to round actual amounts to the nearest dollar. For example, if you are generating the report for fiscal year 2019, the activity amounts for fiscal year 2016 and 2017 will be rounded to the nearest dollar.
  • If you do not check this toggle, the report will display the dollars and cents associated with those activity amounts.
• Check the Print double spaced toggle if you would like to add an empty line after each line item on the report.
• Check the Page break on account section 1 toggle if you would like to add a page break before each fund that is included on the report.
• Check the Page break on account section 2 toggle if you would like to add a page break before each department that is included on the report.
• Check the Print requested budget toggle to include a Requested Budget column in the report.
• The Actual column of each fiscal year will display the total activity of that fiscal year (not the ending balance).
• The Adopted column will display the adopted budget of the fiscal year prior to the budget year selected in the Budget Year field on the Budget Analysis window.
• The Estimated column displays the estimated actual associated with each GL account. If you have not calculated an estimated actual amount for the budget year selected in the Budget Year field, no information will display in this column.
  • Estimated actuals are calculated using the Edit Estimated Actuals window (GL> New Budget Information> Edit Estimated Actuals).

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