School Finance: Accounting and Auditing
Spreadsheet Issues, 2011-2012 End of Year Financial Report
School officials completing the FY12 End of Year Financial Report (EOYFR) are encouraged to contact ESE about any technical difficulties they encounter (downloading and uploading, macros, printing, cell references, etc). If such problems are confirmed, this document will identify them and explain how to correct them if necessary.
Amendment smart form
Amendments to FY11 can still be made using the automated amendment smart form on the secure portal. The FY12 application should be available in October.
Do not use Firefox or Mozilla as a browser for the amendment smart form application.
Once the FY12 smart form is ready, amendments from the previous week will be processed by the end of the day each Monday.
Obtaining amended ESE copies of FY12 End of Year Financial reports.
We will post the final version of every district's FY12 report to the dropbox in July, 2013. In the meantime if you need a copy reflecting all amendments to date
Circuit Breaker Supplemental Payments
The amounts listed in the state aid section under Circuit Breaker do not include the two supplementary payments districts received. While those payments were not made from the Circuit Breaker appropriation, all reimbursement revenue is deposited in your local Special Education Reimbursement fund. You can find the amount of the supplemental payments at the FY12 CB Supplemental Payments posting (the amount is in red) on the FY12 End of Year Report page. We would ask that you please amend Cell F38 (ESE Administered Grants) to include these receipts.
We suggest you also verify the amounts we have included in the Grants Revenue section of your EOYR with the amounts posted on the Federal and State Grants posting on the above referenced website.
The CFDA# for these reimbursements was 84.027A.
Edit 3 labels
Edit 3 appears if a city or town is a member of a regional district, but has not entered a regional assessment. The label for line 2270 should be "Schedule 1 - FY12 assessment" and the label for line 7860 should be "Schedule 19 - FY13 assessment."
If you get a macro error on schedule 3, it may be that you are using a version of the file that has been saved with a name other than the standard "12eoy***.xls" (where the *** represents your three-digit lea code). Save the file under the original name and the problem usually disappears.
Enabling macros: macros must be enabled for the schedule 3 update or print macros to work. Some spreadsheets have security set at the highest level in the "tools\macros\security" menu. A lower level usually works, although in some cases it is a local network problem. The Windows 7 command sequence is Developer\macro security\enable all macros\ok\file save. Save the file and then reopen.
Remember that there is a print menu: hit "control p".
If numbers appear on the screen as asterisks, use a higher zoom level (View\Zoom).