CORRECTIVE ACTION PLAN Oversight Agency for Audit: U.S. Department of Treasury The City of Peabody, Massachusetts respectfully submits the following corrective action plan for the year ended June 30, 2022. Name and address of independent public accounting firm: Powers & Sullivan, LLC 100 Qu...
CORRECTIVE ACTION PLAN Oversight Agency for Audit: U.S. Department of Treasury The City of Peabody, Massachusetts respectfully submits the following corrective action plan for the year ended June 30, 2022. Name and address of independent public accounting firm: Powers & Sullivan, LLC 100 Quannapowitt Parkway, Suite 101 Wakefield, MA 01880 Audit period: July 1, 2021 through June 30, 2022 The finding from the June 30, 2022, schedule of findings and questioned costs is discussed below. The finding is numbered consistently with the number assigned in the schedule. FINDINGS?FEDERAL AWARD PROGRAMS AUDITS U.S. DEPARTMENT OF EDUCATION Passed through Massachusetts Department of Elementary and Secondary Education Education Stabilization Fund Education Stabilization Fund Federal Assistance Listing No. 84.425, 84.425C, 84.425D and 84.425U 2022-003: Controls for Monitoring Payroll Charged to the Grant Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Compliance and Internal Control Over Compliance ? Other Matter Criteria or Specific Requirement: Grantees must provide reasonable assurance that Federal Awards are expended only for allowable activities and that the costs of goods and services charged to Federal awards are allowable and in accordance with applicable cost principles. Condition: Payroll expenditures charged to the Education Stabilization Fund grant are required to be supported with documentation (i.e., semi-annual certifications and personnel activity reports) substantiating that the employees are eligible to be charged to the grant and that the payroll charged relates to time spent accomplishing grant objectives. The City utilizes semi-annual time and effort certification forms to document the eligibility of the employees paid out of the grant. These forms, however, were not consistently completed for each employee charged out of the grant. Furthermore, the forms that were completed did not include all data required by federal and state guidelines. Context: The City did not maintain sufficient documentation to demonstrate compliance with federal and state time and effort reporting requirements in accordance with the provisions of Title 2 U.S. Code of Federal Regulations Part 225 Cost Principals for State, Local, and Indian Tribal Governments. Effect: The City has not complied with the federal and state time and effort reporting requirements. Cause: Management has not established written guidelines and procedures outlining the time and effort reporting and documentation requirements that department heads must adhere with to ensure compliance with federal and state time and effort reporting requirements. Such guidelines and procedures should indicate under what circumstances semi-annual certifications and personnel activity reports (PARS) are required. Management also has not adopted and implemented standardized forms that include all data as required by federal and state guidelines to demonstrate compliance with these requirements. Questioned Costs: Total payroll costs charged to the grant in 2022 totaled $2,997,132, which was paid on a bi-weekly basis throughout the year. Three of the pay periods were selected for testing, which totaled $241,339 for 73 employees paid out of the grant during those pay periods. From the pay periods selected for testing, the following known questioned costs were identified: "SEE CORRECTIVE ACTION PLAN FOR TABLE" Repeat Finding: This matter was reported as a finding in the previous year as finding 2021-004. Recommendation: The City should establish written policies and procedures outlining the time and effort reporting and documentation requirements that must be adhered with to ensure compliance with federal and state time and effort reporting requirements. Management should adopt and implement standardized forms that include all data required by federal and state guidelines and provide training to ensure that program personnel understand the time and effort reporting requirements. Views of Responsible Officials and Planned Corrective Actions: The School District immediately began redesigning the form used for time and effort reporting, and the School District will immediately begin reissuing and recollecting the forms for the education stabilization grant for 2022, as well as into future periods. If the Oversight Agency has questions regarding this plan, please call Samuel Rippin, School Business Manager, at 978-536-6520. Sincerely yours, Samuel Rippin School Business Manager City of Peabody