140 likes | 298 Views
Budget Planning and Analysis System. FY 2016-17 Budget System Training. Phase I Improvements. Performance Tuning completed Software upgrade for IE9 completed Change : rebuilt the application to enhance usability and reporting capabilities. Completed
E N D
Budget Planning and Analysis System FY 2016-17 Budget System Training
Phase I Improvements • Performance Tuning completed • Software upgrade for IE9 completed • Change : rebuilt the application to enhance usability and reporting capabilities. Completed • Reporting: Reorganized reports and simplified report options to limit user selection and increase confidence in data selected. Completed • Transfers: rebuilt the application to eliminate double counting of transfers in fiscal pages and simplify reporting. Completed
BBIS Application • Combined Forms into composite forms for easier navigation • Made the Balance Forward In account a calculated field from the previous year’s Balance Forward Out • Segmented general fund and other funds due to fiscal years open for reconciliation.
System structure (Dimensions) Dimensions Fund Entity Account Year Period Version Scenario • BPAS is organized by dimensions, which represent the categories of financial data for the State: . • Each dimension contains groups of related members. Every time a user interacts with data a selection is made from each dimension.
Account Dimension Changes Account Net • Available Resources • Balance Forward In • Revenue • Revenue Account Codes from SWIFT • Appropriation • Net Transfers • Balance Forward Out • Cancellations • Uses • Expenditure account codes from SWIFT
Version & Scenario Dimensions Scenario Actual Governor’s Rec • Nov Base • Change Governor’s Revised Rec • Feb Base • Change Revised Enacted • May Base • Enacted Change Version Working Biennial Final Supplemental Final Agency What-If MMB What-If
Timingis everything • Data is entered at the lowest level of a dimension. Running reports at this level, the data is correct immediately. • Running reports at a higher level (BACT, Program, Agency) the data needs to be aggregated so the totals are correct. • Transfer Data and Aggregations occur at the top of every hour. The first ten minutes of an hour data is being updated. From 10 after thru the top of the hour reports will reflect data entered prior to the top of the hour.
2016-17 Biennial Budget Tasks • Update programmatic structure in SWIFT and budget for FY15 by accounting close (Friday August 15th) • Reconcile FY2013 and FY2014 • Adjust FY2015 budget to represent agency budget • Develop FY2016-17 base budgets and FY2018-19 planning estimates
Where Does Data Come From • Program Structure Loaded From SWIFT • Appropriations, BACT, Program, Type, and LLBC codes • MMB will need to make changes to dimension members once the system is loaded. Plan ahead. Contact your EBO regarding possible changes. • FY12 and FY13 data will be loaded from BPAS • FY14 close and FY15 budget is loaded from SWIFT as of close (Aug 15). FY15 appropriations , revenue and expenditure budgets are pushed into FY16-FY19. Agencies should ensure accurate data prior to the loading of the budget system.
Budget Development Exercises • Verify SWIFT Load Data • Reconcile FY13 – FY15 • Base Adjust FY16 – FY19 • Budget Known Transfers • Compensation & FTE Budgeting • Update Revenue Estimates • IT Spending • Run Fiscal Pages