Loading...
HomeMy WebLinkAboutFiscal Year 2011 Reports on Federal Awards Programs TOWN OF NANTUCKET, MASSACHUSETTS REPORTS ON FEDERAL AWARD PROGRAMS FISCAL YEAR ENDED JUNE 30, 2011 TOWN OF NANTUCKET, MASSACHUSETTS REPORTS ON FEDERAL AWARD PROGRAMS FISCAL YEAR ENDED JUNE 30, 2011 TABLE OF CONTENTS Page Report on internal control over financial reporting and on compliance and other matters based on an audit of financial statements performed in accordance with Government Auditing Standards.....................1 Report on compliance with requirements that could have a direct and material effect on each major program and on internal control over compliance in accordance with OMB Circular A-133.........................3 Schedule of expenditures of federal awards ......................................................................................................5 Notes to schedule of expenditures of federal awards ........................................................................................6 Schedule of findings and questioned costs........................................................................................................8 1 REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING AND ON COMPLIANCE AND OTHER MATTERS BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS Report on internal control over financial reporting and on compliance and other matters based on an audit of financial statements performed in accordance with Government Auditing Standards To the Honorable Board of Selectmen Town of Nantucket, Massachusetts We have audited the financial statements of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information of the Town of Nantucket, Massachusetts, as of and for the fiscal year ended June 30, 2011, which collectively comprise the Town of Nantucket, Massachusetts’ basic financial statements and have issued our report thereon dated February 21, 2012. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Internal Control Over Financial Reporting In planning and performing our audit, we considered the Town of Nantucket, Massachusetts' internal control over financial reporting as a basis for designing our auditing procedures for the purpose of expressing our opinions on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the Town of Nantucket, Massachusetts' internal control over financial reporting. Accordingly, we do not express an opinion on the effectiveness of the Town of Nantucket, Massachusetts' internal control over financial reporting. Our consideration of the internal control over financial reporting was for the limited purpose described in the preceding paragraph and was not designed to identify all deficiencies in internal control over financial reporting that might be significant deficiencies, or material weaknesses and therefore, there can be no assurance that all deficiencies, significant deficiencies, or material weaknesses have been identified. However, as described in the accompanying schedule of findings and questioned costs, we identified certain deficiencies in internal control over financial reporting that we consider to be material weaknesses. A deficiency in internal control exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned functions, to prevent or detect and correct misstatements on a timely basis. A material weakness is a deficiency, or combination of deficiencies, in internal control, such that there is a reasonable possibility that a material misstatement of the entity’s financial statements will not be prevented, or detected and corrected on a timely basis. We consider the significant deficiencies described in the accompanying schedule of findings and questioned costs as findings 2011-1 and 2011-2 to be material weaknesses. 2 Compliance and Other Matters As part of obtaining reasonable assurance about whether the Town of Nantucket, Massachusetts' financial statements are free of material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts, and grants, noncompliance with which could have a direct and material effect on the determination of financial statement amounts. However, providing an opinion on compliance with those provisions was not an objective of our audit and, accordingly, we do not express such an opinion. The results of our tests disclosed one instance of noncompliance that is required to be reported under Government Auditing Standards. That finding is described in the accompanying Schedule of Findings and Questioned Costs as finding 2011-2. We noted certain other matters that we reported to management of the Town of Nantucket, Massachusetts in a separate letter dated February 21, 2012. The Town of Nantucket’s responses to the findings identified in our audit are described in the accompanying schedule of findings and questioned costs. We did not audit the Town of Nantucket’s responses and accordingly, we express no opinion on them. This report is intended solely for the information and use of management, the Board of Selectmen, others within the entity, and federal awarding agencies and pass-through entities and is not intended to be and should not be used by anyone other than these specified parties. February 21, 2012, except for the Nantucket Islands Land Bank which is as of September 27, 2011 3 REPORT ON COMPLIANCE WITH REQUIREMENTS THAT COULD HAVE A DIRECT AND MATERIAL EFFECT ON EACH MAJOR PROGRAM AND ON INTERNAL CONTROL OVER COMPLIANCE IN ACCORDANCE WITH OMB CIRCULAR A-133 Report on compliance with requirements that could have a direct and material effect on each major program and on internal control over compliance in accordance with OMB Circular A-133 To the Honorable Board of Selectmen Town of Nantucket, Massachusetts Compliance We have audited the compliance of the Town of Nantucket, Massachusetts, with the types of compliance requirements described in the U.S. Office of Management and Budget (OMB) Circular A-133 Compliance Supplement that could have a direct and material effect on each of the Town of Nantucket’s major federal programs for the fiscal year ended June 30, 2011. The Town of Nantucket, Massachusetts' major federal programs are identified in the summary of auditors’ results section of the accompanying schedule of findings and questioned costs. Compliance with the requirements of laws, regulations, contracts and grants applicable to each of its major federal programs is the responsibility of the Town of Nantucket, Massachusetts' management. Our responsibility is to express an opinion on the Town of Nantucket, Massachusetts' compliance based on our audit. We conducted our audit of compliance in accordance with auditing standards generally accepted in the United States of America; the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States; and OMB Circular A-133, Audits of States, Local Governments, and Non-Profit Organizations. Those standards and OMB Circular A-133 require that we plan and perform the audit to obtain reasonable assurance about whether noncompliance with the types of compliance requirements referred to above, that could have a direct and material effect on a major federal program, occurred. An audit includes examining, on a test basis, evidence about the Town of Nantucket, Massachusetts' compliance with those requirements and performing such other procedures, as we considered necessary in the circumstances. We believe that our audit provides a reasonable basis for our opinion. Our audit does not provide a legal determination on the Town of Nantucket, Massachusetts' compliance with those requirements. As described in item 2011-2 in the accompanying Schedule of Findings and Questioned Costs, the Town of Nantucket’s Memorial Airport did not comply with requirements pertaining to procurement laws. Compliance with such requirements is necessary, in our opinion, for the Town of Nantucket to comply with the requirements applicable to that program. In our opinion, except for the item identified as finding 2011-2, the Town of Nantucket, Massachusetts, complied, in all material respects, with the requirements referred to above that could have a direct and material effect on each of its major federal programs for the fiscal year ended June 30, 2011. Additionally, the results of our auditing procedures disclosed other instances of noncompliance with those requirements, which are required to be reported in accordance with OMB Circular A-133 and which are described in the accompanying schedule of findings and questioned costs as item 2011-3 and 2011-4. Internal Control Over Compliance Management of the Town of Nantucket, Massachusetts, is responsible for establishing and maintaining effective internal control over compliance with requirements of laws, regulations, contracts and grants applicable to federal programs. In planning and performing our audit, we considered the Town of Nantucket, Massachusetts' internal control over compliance with requirements that could have a direct and material effect on a major federal program in order to determine our auditing procedures for the purpose of expressing our opinion on compliance, but not for 4 the purpose of expressing an opinion on the effectiveness of internal control over compliance. Accordingly, we do not express an opinion on the effectiveness of the Town of Nantucket, Massachusetts’ internal control over compliance. Our consideration of the internal control over compliance was for the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control over compliance that might be deficiencies, significant deficiencies, or material weaknesses and therefore, there can be no assurance that all deficiencies, significant deficiencies, or material weaknesses have been identified. However, as discussed below, we identified certain deficiencies in internal control over compliance that we consider to be material weaknesses. A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis. A material weakness in internal control over compliance is a deficiency, or combination of deficiencies, in internal control over compliance, such that there is a reasonable possibility that material noncompliance with a type of compliance requirement of a federal program will not be prevented, or detected and corrected, on a timely basis. We consider the deficiencies in internal control over compliance described in the accompanying schedule of findings and questioned costs as item 2011-2 to be material weaknesses. The Town of Nantucket’s responses to the findings identified in our audit are described in the accompanying schedule of findings and questioned costs. We did not audit the Town of Nantucket’s responses and accordingly, we express no opinion on them. This report is intended solely for the information and use of management of the Town of Nantucket and federal awarding agencies and pass-through entities and is not intended to be and should not be used by anyone other than these specified parties. REPORT ON SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS We have audited the financial statements of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information of the Town of Nantucket, Massachusetts, as of and for the fiscal year ended June 30, 2011, and have issued our report thereon dated February 21, 2012. Our audit was performed for the purpose of forming opinions on the financial statements that collectively comprise the Town of Nantucket, Massachusetts’ basic financial statements. The accompanying Schedule of Expenditures of Federal Awards is presented for purposes of additional analysis as required by OMB Circular A-133 and is not a required part of the basic financial statements. Such information has been subjected to the auditing procedures applied in the audit of the basic financial statements and, in our opinion, is fairly stated, in all material respects, in relation to the basic financial statements taken as a whole. This report is intended solely for the information and use of management, the Board of Selectmen, others within the entity, and federal awarding agencies and pass-through entities and is not intended to be and should not be used by anyone other than these specified parties. February 21, 2012, except for the Nantucket Islands Land Bank which is as of September 27, 2011 Federal CFDA Federal Grantor/Program Title Number Expenditures U.S. DEPARTMENT OF AGRICULTURE: Passed through Massachusetts Department of Elementary and Secondary Education: Non-Cash Assistance (Commodities): National School Lunch Program 10.555 $ 19,178 Cash Assistance: School Breakfast Program 10.553 4,090 National School Lunch Program 10.555 49,848 TOTAL AGRICULTURE 73,116 U.S. DEPARTMENT OF THE INTERIOR: Passed through Massachusetts Department of Fish and Game: Clean Vessel Act 15.616 13,220 U.S. DEPARTMENT OF JUSTICE: Direct: Public Safety Partnership and Community Policing Grants 16.710 102,852 Passed through Massachusetts Executive Office of Public Safety and Homeland Security: Enforcing Underage Drinking Laws Program 16.727 4,496 TOTAL CRIMINAL JUSTICE 107,348 U.S. DEPARTMENT OF TRANSPORTATION - FEDERAL AVIATION ADMINISTRATION: Direct: Airport Improvement Program 20.106 33,072 Passed through Massachusetts Department of Transportation - Aeronautics Division: Airport Improvement Program 20.106 2,231,536 U.S. DEPARTMENT OF TRANSPORTATION - FEDERAL HIGHWAY ADMINISTRATION: Passed through Massachusetts Department of Transportation - Highway Division: Highway Planning and Construction 20.205 209,178 TOTAL TRANSPORTATION 2,473,786 U.S. DEPARTMENT OF EDUCATION: Passed through Massachusetts Department of Elementary and Secondary Education: Title I Grants to Local Educational Agencies 84.010 84,740 Special Education Grants to States 84.027 253,055 Safe and Drug Free Schools 84.186 81 Improving Teacher Quality State Grants 84.367 25,141 ARRA - Special Education Grants to States, Recovery Act 84.391 153,923 ARRA - State Fiscal Stabilization Fund, Recovery Act 84.394 7,124 Education Jobs Fund 84.410 97,327 Passed through Massachusetts Department of Early Education and Care: Special Education Preschool Grants 84.173 8,529 ARRA - Special Education Preschool Grants, Recovery Act 84.392 6,225 TOTAL EDUCATION 636,145 U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES: Passed through Health Resources and Services Administration: National Bioterrorism Hospital Preparedness Program 93.889 2,500 U.S. DEPARTMENT OF HOMELAND SECURITY: Direct: Airport Law Enforcement Officer Reimbursement Agreement Program 97.090 121,352 ARRA - Port Security Grant Program 97.116 125,193 Passed through Massachusetts Federal Emergency Management Agency: Hazard Mitigation Grant 97.039 4,657 TOTAL HOMELAND SECURITY 251,202 TOTAL $ 3,557,317 See notes to schedule of expenditures of federal awards. FOR THE FISCAL YEAR ENDED JUNE 30, 2011 SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Town of Nantucket, Massachusetts 5 Reports on Federal Award Programs Notes to Schedule of Expenditures of Federal Awards Fiscal Year Ended June 30, 2011 Town of Nantucket, Massachusetts 6 Reports on Federal Awards Programs Note 1 - Definition of Reporting Entity Notes to schedule of expenditures of federal awards The accompanying Schedule of Expenditures of Federal Awards presents the activity of all federal financial assistance programs of the Town of Nantucket, Massachusetts. All federal financial assistance received directly from federal agencies as well as federal financial assistance passed through other governmental agencies is included on the schedule. Note 2 - Significant Accounting Policies The accounting and reporting policies of the Town of Nantucket, Massachusetts, are set forth below: (a) Basis of Presentation – The accompanying Schedule of Expenditures of Federal Awards is presented on the modified accrual basis of accounting. Accordingly, grant revenues are recognized when they are susceptible to accrual and expenditures are recognized when the related liability is incurred. (b) Cash Assistance – School Lunch Program - Program expenditures represent federal reimbursement for meals provided during the year. (c) Non-Cash Assistance (Commodities) – School Lunch Program – Program expenditures represent the value of donated foods received during the fiscal year. Note 3 - Program Clusters In accordance with Subpart A §_.105 of OMB Circular No. A-133, Audits of States, Local Governments and Non Profit Organizations, certain programs have been clustered in determining major programs. The following represents the clustered programs: CFDA Name of Cluster/Program Number Child Nutrition Cluster School Breakfast Program 10.553 National School Lunch Program 10.555 Special Milk Program for Children 10.556 Summer Food Service Program for Children 10.559 Highway Planning and Construction Cluster Highway Planning and Construction 20.205 Recreational Trails Program 20.219 Surface Transportation Infrastructure-Discretionary Grants for Capital Investments II 20.933 Appalachian Development Highway System 23.003 Notes to Schedule of Expenditures of Federal Awards Fiscal Year Ended June 30, 2011 Town of Nantucket, Massachusetts 7 Reports on Federal Awards Programs Title I, Part A Cluster Title I Grants to Local Educational Agencies (Title I, Part A of the ESEA) 84.010 ARRA-Title I Grants to Local Educational Agencies, Recovery Act 84.389 Special Education Cluster Special Education Grants to States 84.027 Special Education Preschool Grants 84.173 ARRA-Special Education Grants to States, Recovery Act 84.391 ARRA-Special Education Preschool Grants, Recovery Act 84.392 State Fiscal Stabilization Fund Cluster ARRA-State Fiscal Stabilization Fund (SFSF)-Education State Grants, Recovery Act 84.394 ARRA-State Fiscal Stabilization Fund (SFSF)-Government Services, Recovery Act 84.397 Schedule of Findings and Questioned Costs Fiscal Year Ended June 30, 2011 Town of Nantucket, Massachusetts 8 Report on Federal Award Programs A. Summary of Auditors’ Results Schedule of findings and questioned costs 1. The auditors’ report expresses an unqualified opinion on the basic financial statements of the Town of Nantucket, Massachusetts. 2. Material weaknesses relating to the audit of the basic financial statements are reported in the Report on Internal Control Over Financial Reporting and on Compliance and Other Matters Based on an Audit of Financial Statements Performed In Accordance with Government Auditing Standards. 3. One instance of noncompliance material to the financial statements of the Town of Nantucket, Massachusetts, was disclosed during the audit. 4. Significant deficiencies relating to the audit of the major federal award programs are reported in the Report on Compliance with Requirements that could have a direct and material effect on each Major Program and on Internal Control Over Compliance in Accordance with OMB Circular A-133. 5. The auditors’ report on compliance for the major federal award programs for the Town of Nantucket, Massachusetts, expresses a qualified opinion. 6. There were three audit findings relative to the major federal award programs for the Town of Nantucket. 7. The programs tested as major grants include: CFDA Program Title Number Airport Improvement Program 20.106 Special Education Grants to States 84.027 Special Education Preschool Grants 84.173 ARRA-Special Education Grants to States, Recovery Act 84.391 ARRA-Special Education Preschool Grants, Recovery Act 84.392 8. The threshold for distinguishing Types A and B programs was $300,000. 9. The Town of Nantucket, Massachusetts was not determined to be a low-risk auditee. Schedule of Findings and Questioned Costs Fiscal Year Ended June 30, 2011 Town of Nantucket, Massachusetts 9 Report on Federal Award Programs B. Findings-Financial Statements Audit 2011-1 Material Weaknesses Condition and Criteria: The following deficiencies existed within the Town’s system of internal control: • Inadequate Design of Internal Control Over Significant Accounts • The Town’s system of controls to verify that the cash balances in the enterprise fund bank accounts were accurate failed to detect significant variances until after the end of the fiscal year which required material adjustments. • The Town does not have a reliable system for monitoring capital borrowing and the associated capital expenditures. • The Town has not implemented formal reconciliation processes with several Town departments. Communication between the Town and Town departments is essential to the monthly reconciliation process and to provide assurance that revenues and expenditures have been properly reported. • The Nantucket Memorial Airport has constructed a number of capital projects which were authorized to be funded partially through state and federal grants and partially through long- term borrowing. Since grant revenue was not monitored on a project basis, the final Airport portion of each project was not calculated and was not borrowed. • Failure to Comply with Procurement Laws and Regulations • The Town has not enforced procurement laws to ensure that Town departments are going through the proper channels when requesting bids, obtaining quotes, and entering into contracts before projects commence. Proper internal controls require that procedures be in place to provide reasonable assurance that 1) assets are properly safeguarded; 2) that transactions are executed in accordance with management’s authorization and 3) that transactions are recorded properly in the general and subsidiary ledgers. Cause: Lack of procedures in place to obtain the objectives of a system of internal control as defined above. Effect: The Town is unable to provide reasonable assurance that capital borrowing is properly monitored, assets are properly safeguarded and transactions are executed in accordance with management’s authorization and recorded timely and properly in the general and subsidiary ledgers. Auditors’ Recommendation: We recommend that the Town implement a system to insure that all account reconciliations are performed timely and that procurement laws are followed. Auditee’s Response: • During fiscal 2012, the Town is implementing procedures to ensure that transactions are reported accurately and timely on the Town’s general ledger. • Regarding capital borrowing, during fiscal 2012 the Town’s Finance Department with assistance from an independent financial consultant re-created all Nantucket Airport capital project activity dating back to 2005 and in the 3rd Quarter of fiscal year 2012, the Town plans to adopt and distribute to all Town Departments a “Post Issuance Tax Compliance Procedure for Tax Exempt Obligations and Other Tax Benefited Obligations”. • The Chief Procurement Officer and Finance Department are working collectively to mitigate disbursements to vendors without verification that the proper procurement process has taken place. Schedule of Findings and Questioned Costs Fiscal Year Ended June 30, 2011 Town of Nantucket, Massachusetts 10 Report on Federal Award Programs C. Findings and Questioned Costs-Major Federal Award Programs Audit 2011-2 Material Weakness U.S. DEPARTMENT OF TRANSPORTATION – FEDERAL AVIATION ADMINISTRATION Questioned Costs Airport Improvement Program 20.106 Unknown Condition and Criteria: OMB Circular A-110 states, “All procurement transactions shall be conducted in a manner to provide, to the maximum extent practical, open and free competition”. The Nantucket Memorial Airport has not followed the proper procurement procedures to provide open and free competition. Various Airport projects commenced without obtaining the required bids or quotes and in some instances not entering into signed contracts. Cause: Lack of procedures in place to ensure proper procurement laws were followed. Effect: The Town is not in compliance with the requirements of OMB Circular A-110. Auditors’ Recommendation: We recommend that the Town implement procedures to comply with OMB Circular A-110 by improving controls to ensure that procurement laws are followed. Auditee’s Response: During Fiscal Year 2012, the Chief Procurement Officer and Finance Department are working collectively to mitigate, to the extent possible, disbursements to vendors without proper procurement process taking place. Additional controls have been put into place. These controls include a centralized procurement process which no longer gives departments the ability to enter invoices into the Towns’ invoice processing system without a Town issued purchase order number. In addition, in January of 2012, the Chief Procurement Officers provided a mandatory training for all departmental staff that was conducted by the Inspector General and Attorney General’s office of the State of Massachusetts. 2011-3 U.S. DEPARTMENT OF EDUCATION Questioned Costs Special Education Grants to States 84.027 None Special Education Preschool Grants 84.173 None ARRA-Special Education Grants to States, Recovery Act 84.391 None ARRA-Special Education – Preschool Grants, Recovery Act 84.392 None Condition and Criteria: OMB Circular A-87, “Cost Principles for State, Local and Indian Tribal Governments” requires grantees to maintain documentation of employee time and effort that has been charged to federal awards. If 100% of an employee’s salary is charged to a federal award, a grant recipient is required to maintain semi-annual certifications stating that 100% of the employee’s time was spent working on grant activities. If less than 100% of an employee’s salary is charged to a federal award, a grant recipient is required to maintain monthly personnel activity reports documenting 100% of the employee’s time. One employee, who was only paid partially from the grant in fiscal year 2011, Schedule of Findings and Questioned Costs Fiscal Year Ended June 30, 2011 Town of Nantucket, Massachusetts 11 Report on Federal Award Programs completed semi annual certification to document the time spent on the grant rather than monthly personnel activity reports as required by OMB Circular A-87. Cause: The District did not maintain monthly personnel activity reports for employees partially paid from the grant. Effect: The District is not in compliance with the grant requirements. Auditors’ Recommendation: We recommend that the District implement procedures to comply with OMB Circular A-87, “Cost Principles for State, Local and Indian Tribal Governments”. Auditee’s Response: The School Department has completed a corrective action plan to address this finding. 2011-4 U.S. DEPARTMENT OF EDUCATION Questioned Costs Special Education Grants to States 84.027 None Special Education Preschool Grants 84.173 None Condition and Criteria: Form FR-1 (Final Financial Report) for the Special Education Grants to States and Special Education Preschool Grants was due October 31, 2010. The final reports for each of these grants were submitted in March of 2011 after the deadline. No extensions were to permit the reports to be late. Cause: lack of procedures in place to file final reports timely. Effect: The Town is not in compliance with grants requirements. Auditors’ Recommendation: We recommend the Town implement procedures to insure compliance with all grant reporting requirements to ensure the timely filing of the final financial reports. Auditee’s Response: The School Department has completed a corrective action plan to address this finding. Schedule of Findings and Questioned Costs Fiscal Year Ended June 30, 2011 Town of Nantucket, Massachusetts 12 Report on Federal Award Programs D. Prior Year Audit Findings and Questioned Costs 2010-1 Material Weaknesses Condition and Criteria: In fiscal year 2010, the following deficiencies existed within the Town’s system of internal control: • Failure to Act on Previously Communicated Weaknesses • The Town’s audits have reported significant deficiencies in the design and operation of internal controls for several years which have not been resolved. • Inadequate Design of Internal Control Over Significant Accounts • The Town has not accurately reconciled cash between the Treasurers cash book and the bank balances throughout the year. • The Town did not accurately record all financial activity on the general ledger during the fiscal year, resulting in 37 late adjustments. • The Town Treasurer did not transfer the exact amount of the warrants from the Airport bank accounts to reimburse the Town accounts on a timely basis throughout the year. This resulted in cash being misstated between the Town and Airport bank statements throughout the year requiring significant adjustments subsequent to year end. • During fieldwork, the Town provided several supporting schedules that were inaccurate and were adjusted during the audit as errors were identified. A system of controls should be designed to detect and correct errors on a timely basis. • The Town does not have a reliable system for monitoring capital borrowing and the associated capital expenditures. Proper internal controls require that procedures be in place to provide reasonable assurance that 1) assets are properly safeguarded; 2) that transactions are executed in accordance with management’s authorization and 3) that transactions are recorded properly in the general and subsidiary ledgers. Cause: Lack of procedures in place to obtain the objectives of a system of internal control as defined above. Effect: The is unable to provide reasonable assurance that assets are properly safeguarded and transactions are executed in accordance with management’s authorization and recorded timely and properly in the general and subsidiary ledgers. Current Status: During fiscal 2011 the Town implemented procedures to reconcile the Treasurers cash book to the general ledger and to the bank balances. Also, the Treasurer began to transfer the exact warrant amount related to the Enterprise funds on a timely basis. There are significant deficiencies that continue to exist. Please refer to finding 2011-1 for additional information. 2010-2 U.S. DEPARTMENT OF TRANSPORTATION Questioned Costs Highway Planning and Construction 20.205 None Condition and Criteria: The Town has under reported federal expenditures on the Schedule of Expenditures of Federal Awards for the past several years. Schedule of Findings and Questioned Costs Fiscal Year Ended June 30, 2011 Town of Nantucket, Massachusetts 13 Report on Federal Award Programs Cause: The Town does not have procedures for reconciling grant activity recorded in the general ledger with records maintained by Town’s departments and reported to granting agencies. Effect: Indirect costs that have been reported to the granting agency have not been charged to the grant on the general ledger for several years. This has resulted in an excess balance in the general ledger grant account and an underreporting of federal expenditures on the Schedule of Expenditures and Federal Awards. In an effort to reconcile the grant balances on the general ledger to the balance maintained by the planning department as of June 30, 2010, the Town reclassified over $600,000 in expenditures from the general fund to the Highway Planning and Construction grant. Current Status: As of June 30, 2011 the Town reconciled the highway planning and construction grant with the Planning Department. 2010-3 U.S. DEPARTMENT OF EDUCATION Special Education Grants to States 84.027 None Special Education Preschool Grants 84.173 None ARRA-Special Education Grants to States, Recovery Act 84.391 None ARRA-Special Education – Preschool Grants, Recovery Act 84.392 None Condition and Criteria: OMB Circular A-87, “Cost Principles for State, Local and Indian Tribal Governments” requires grantees to maintain documentation of employee time and effort that has been charged to federal awards. If 100% of an employee’s salary is charged to a federal award, a grant recipient is required to maintain semi-annual certifications stating that 100% of the employee’s time was spent working on grant activities. If less than 100% of an employee’s salary is charged to a federal award, a grant recipient is required to maintain monthly personnel activity reports documenting 100% of the employee’s time. The District did not maintain semi-annual certifications or personnel activity reports for employee salaries charged to the SPED Grants as required by OMB Circular A-87. Cause: The District did not maintain semi-annual certifications or personnel activity reports for those employee’s whose payroll was charged to the grant Effect: The District is not in compliance with the grant requirements. Current Status: During fiscal 2011 the School Department was able to provide semi-annual certifications for SPED employees. However, it was noted that an employee completed a semi-annual certification when they should have been submitting monthly time and effort reports. Please refer to finding 2011-3 for additional information.