Available for download is the 2020-21 State Aid Reconciliation Worksheet which can be used by school districts to determine how much state aid they will be receiving for the school year and to track state aid payments throughout the year.
The worksheet is located on our website here: https://old.questar.org/services/financial/state-aid-financial-planning/topics/ under the ‘State Aid’ category drop-down.
This worksheet is useful for tracking your state aid revenue for the school year and determining the amounts you will accrue as receivables at the end of the school year. Districts will need to enter three pieces of information when using the worksheet:
- On the tab labeled “State Aid Reconciliation”, in column E, amounts from the respective lines of your GEN Report;
- On the tab labeled “Payment Schedule”, month/date/year in column A for each payment recorded;
- On the tab labeled “Payment Schedule”, the amount of each payment recorded in the correct column (columns D-H)
*NEW on the tab labeled “State Aid Reconciliation”, Line 26A has been added to account for the Deduct for the Pandemic Adjustment.
Caution: Please note that the Transportation output reports may be revised to accommodate for those expenditures deemed non-aidable during the spring of 2020.
Once aid amounts are entered on the “State Aid Reconciliation” tab, the total by category will automatically populate in Row 7 of the “Payment Schedule” tab.
Please pass this information along to the individual responsible for monitoring state aid for your district.
If you have any questions regarding this information, please do not hesitate to call our office.
