New Budget Report Filters for Fund and Reimbursements

This message is intended for individuals that utilize the Budget reports in EFS Reporting Services.

We have added two new drop down filter options to improve users ability to review their budgets and to easily provide information for quarterly adjustments. The reports listed below now include two new drop down filter options, Reimbursement Grouping and Fund.

• The Reimbursement Grouping option allows users to see Reimbursements either as negative expenditures or as positive revenues. This is particularly useful when completing the excel template for quarterly adjustments, as that form presents Gross Expenditures in one column and Revenues & Reimbursements in the other column.
• The Fund option allows users to select General Fund or Other Funds. With these drop down options, users can easily see values for the General Fund vs Other Funds at the Department and Division levels. This is also useful when completing the excel template for quarterly adjustments, as that form requires users to display General Fund and Other Fund costs. 

These new options are now available for these reports:

• BUD001: Dept Division Section*  this report allows users to see information for any Hyperion scenario, any year and at any level of detail desired by the user.
• BUD004: Quarterly Budget Adjustments*  this report shows information entered in the Quarterly Budget Adjustment forms in Hyperion and is useful for completing the Excel template for the CAO for quarterly adjustments.
• BUD006: Quarterly Budget Estimates* - this report shows information entered in the Mid-Year and 3rd Quarter forms in Hyperion. It does not have a reimbursement grouping option as reimbursements are always negative expenditures in estimates.
• BUD007: Recommended Budget Variance*  this report shows the coming year recommended budget as compared to the current year adopted budget, and the coming year recommended budget as compared to the prior year actual budget.
• BUD008: Budget and Actual*  this report is similar to the BUZ report in the mainframe system. It shows the requested, recommended and adopted budget for the selected year as well as the actuals and adopted budget for the current year and actuals for the prior year. 

Additionally, when you run any of the above reports at the section or subsection level, you will see the Fund ID in the report. If you save this report as a CSV, you will get a raw extract of the data that can be manipulated easily in Excel (with pivot tables, filtering, sorting, etc). If you save the report as an Excel file as opposed to a CSV, it will look nicer but does not allow for the same level of data manipulation. Fund ID 10005 is General Fund and all other Fund IDs are considered Other Funds. If you need more refined information on funds outside of the general fund, this feature may be helpful to you.

If you have questions regarding these new feature or you have reporting needs associated with Hyperion information, please contact Natalie Brunamonte at (707) 565-8328 or via e-mail Natalie.Brunamonte@sonoma-county.org