Mass.gov
Massachusetts Department of Elementary and Secondary Education
Go to Selected Program Area
Massachusetts State Seal
News School/District Profiles School/District Administration Educator Services Assessment/Accountability Family & Community  
> Administration Finance/Grants PK-16 Program Support Information Services  
>
>
>
 
 
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

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.

  1. 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.

  2. 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

  3. 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.

  4. 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."

Helpful Hints

  • 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).



Last Updated: November 26, 2012
E-mail this page| Print View| Print Pdf  
Massachusetts Department of Elementary and Secondary Education Search · Site Index · Policies · Site Info · Contact ESE