CFAM 353 - Revenue Budget Planning

This is the worksheet you will want to use when planning your district’s REVENUE budget for the new school year. Let’s assume you are budgeting for FY22. Set the Select Year parameter to 21. This tells the worksheet to calculate the expenditures for FY19 (REVENUE for 2 Years Prior to Selected Year), FY20 (REVENUE for 1 Year Prior to Selected Year) and FY21 (REVENUE for Selected Year). The budget for FY21 will be displayed in the last column (REVENUE Budget for Selected Year). Use the filters as necessary to limit the budget units to those for which you wish to enter a budget.
Once the Select Year parameter and remaining filters are set the way you want, this worksheet should be downloaded. To do this, click 'Download' (found in the upper right-hand area of the screen) and select Crosstab. Select Excel then click the 'Download' button.
The resulting Excel worksheet can be used to key in the desired budget for the new year.
copyright 2021 Arkansas Public School Resource Center