State Categorical Special Education Estimate

Create a Fund 27 aid estimate from WISEdata Finance reported expenditures

1. Log in to WISEdata Finance and select the fiscal year and agency.
2. Confirm the most recent data push
3. Navigate to Account Reviews to perform Account Search using the following parameters
4. Identify School Year
5. Enter 27 in Fund field
6. Select Expenditure from drop down in Type field
7. Indicate 011 in Project field
8. Press Search
9. Select the Export to XLSX or Export to CSV button
10. Insert two columns after the F Actual data
11. Insert the Final or Prorated Aid Rate in far-right columns
12. Create formulas multiplying determine aid estimated amount
13. The actual aid amounts paid in the STAR Aids Register may vary from this calculation due to rounding or withholding associated with other aid payments.