U.S. Department of Education Finding 2022-001: Education Stabilization Fund??Governor?s Emergency Education Relief (GEER) and Elementary and Secondary School Emergency Relief (ESSER) Fund Semi-Annual Certification Procedures Pass-through entity: Michigan Department of Education (MDE) Assistance Listing Number(s): 84.425C and 84.425D Award Numbers: COVID-19 211202-2122, COVID-19 213712-2021, COVID-19 213722-2122 and COVID-19 213742-2122 Award Year End: September 30, 2023 Specific Requirement: Allowable Costs/Cost Principles Criteria: Section 200.430 of the Cost Principles of the Title 2 U.S. Code of Federal Regulations (CFR) Part 200?Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) requires charges to federal award for salaries and wages to be based on records that accurately reflect the work performed. These records must (1) be supported by a system of internal controls which provide reasonable assurance that charges are accurate, allowable and properly allocated, (2) reasonably reflect total activity for which the employee is compensated, (3) encompass both federally assisted and all other activities compensated by the entity, (4) support the distribution of the employee?s wages among specific cost objectives if the employee works on more than one federal award, (5) be reconciled with payroll budget estimates with necessary adjustments made to accounting records to ensure that excess costs are not charged to federal programs. Appendix B to 2 CFR, Part 225?Selected Items of Cost indicates that where employees are expected to work solely on a single Federal award or cost objective, charges for their salaries and wages will be supported by periodic certifications that the employees worked solely on that program for the period covered by the certification. These certifications will be prepared at least semi-annually and will be signed by the employee or supervisory official having first-hand knowledge of the work performed by the employee. Questioned Costs: None. Condition: During our detailed testing of time-and-effort reporting for the Education Stabilization Fund??GEER/ESSER programs, we noted that semi-annual certifications were prepared to comply with federal time and effort requirements. However, the reports were not timely prepared or timely reviewed by the program supervisor with documented approval. Context: Ninety-five employees working in the federal program were eligible for semi-annual certifications because their payroll costs were fully allocated to a single federal program or cost objective. One certification was prepared by each building supervisor for each six-month period during the fiscal year. In total, the certifications properly listed all eligible 95 employees that worked in the federal program during the respective semesters. While the certifications contained the proper components, including documented supervisor approval, they were not prepared timely as they were completed and certified during the audit process. The sample was not a statistically valid sample. Effect: Failure to timely and properly prepare and review time-and-effort reporting could allow improper payroll expenses to be charged to the School District?s federal programs. As a result, payroll compensation and fringe benefits charged for these employees could be disallowed, or there could be missed opportunities for reimbursement. Cause: The School District program personnel overlooked the federal requirements for time-and-effort reporting and the semi-annual certifications were not timely prepared. Repeat Finding: This is not a repeat finding. Recommendation: The School District should provide training to educate all employees working in federal programs of the requirements for documenting personnel expenses under Uniform Grant Guidance, and the School District should require proper time-and-effort documentation to be timely prepared and certified by the appropriate program supervisor. Views of Responsible Officials: The School District agrees with this finding.
U.S. Department of Education Finding 2022-001: Education Stabilization Fund??Governor?s Emergency Education Relief (GEER) and Elementary and Secondary School Emergency Relief (ESSER) Fund Semi-Annual Certification Procedures Pass-through entity: Michigan Department of Education (MDE) Assistance Listing Number(s): 84.425C and 84.425D Award Numbers: COVID-19 211202-2122, COVID-19 213712-2021, COVID-19 213722-2122 and COVID-19 213742-2122 Award Year End: September 30, 2023 Specific Requirement: Allowable Costs/Cost Principles Criteria: Section 200.430 of the Cost Principles of the Title 2 U.S. Code of Federal Regulations (CFR) Part 200?Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) requires charges to federal award for salaries and wages to be based on records that accurately reflect the work performed. These records must (1) be supported by a system of internal controls which provide reasonable assurance that charges are accurate, allowable and properly allocated, (2) reasonably reflect total activity for which the employee is compensated, (3) encompass both federally assisted and all other activities compensated by the entity, (4) support the distribution of the employee?s wages among specific cost objectives if the employee works on more than one federal award, (5) be reconciled with payroll budget estimates with necessary adjustments made to accounting records to ensure that excess costs are not charged to federal programs. Appendix B to 2 CFR, Part 225?Selected Items of Cost indicates that where employees are expected to work solely on a single Federal award or cost objective, charges for their salaries and wages will be supported by periodic certifications that the employees worked solely on that program for the period covered by the certification. These certifications will be prepared at least semi-annually and will be signed by the employee or supervisory official having first-hand knowledge of the work performed by the employee. Questioned Costs: None. Condition: During our detailed testing of time-and-effort reporting for the Education Stabilization Fund??GEER/ESSER programs, we noted that semi-annual certifications were prepared to comply with federal time and effort requirements. However, the reports were not timely prepared or timely reviewed by the program supervisor with documented approval. Context: Ninety-five employees working in the federal program were eligible for semi-annual certifications because their payroll costs were fully allocated to a single federal program or cost objective. One certification was prepared by each building supervisor for each six-month period during the fiscal year. In total, the certifications properly listed all eligible 95 employees that worked in the federal program during the respective semesters. While the certifications contained the proper components, including documented supervisor approval, they were not prepared timely as they were completed and certified during the audit process. The sample was not a statistically valid sample. Effect: Failure to timely and properly prepare and review time-and-effort reporting could allow improper payroll expenses to be charged to the School District?s federal programs. As a result, payroll compensation and fringe benefits charged for these employees could be disallowed, or there could be missed opportunities for reimbursement. Cause: The School District program personnel overlooked the federal requirements for time-and-effort reporting and the semi-annual certifications were not timely prepared. Repeat Finding: This is not a repeat finding. Recommendation: The School District should provide training to educate all employees working in federal programs of the requirements for documenting personnel expenses under Uniform Grant Guidance, and the School District should require proper time-and-effort documentation to be timely prepared and certified by the appropriate program supervisor. Views of Responsible Officials: The School District agrees with this finding.
U.S. Department of Education Finding 2022-001: Education Stabilization Fund??Governor?s Emergency Education Relief (GEER) and Elementary and Secondary School Emergency Relief (ESSER) Fund Semi-Annual Certification Procedures Pass-through entity: Michigan Department of Education (MDE) Assistance Listing Number(s): 84.425C and 84.425D Award Numbers: COVID-19 211202-2122, COVID-19 213712-2021, COVID-19 213722-2122 and COVID-19 213742-2122 Award Year End: September 30, 2023 Specific Requirement: Allowable Costs/Cost Principles Criteria: Section 200.430 of the Cost Principles of the Title 2 U.S. Code of Federal Regulations (CFR) Part 200?Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) requires charges to federal award for salaries and wages to be based on records that accurately reflect the work performed. These records must (1) be supported by a system of internal controls which provide reasonable assurance that charges are accurate, allowable and properly allocated, (2) reasonably reflect total activity for which the employee is compensated, (3) encompass both federally assisted and all other activities compensated by the entity, (4) support the distribution of the employee?s wages among specific cost objectives if the employee works on more than one federal award, (5) be reconciled with payroll budget estimates with necessary adjustments made to accounting records to ensure that excess costs are not charged to federal programs. Appendix B to 2 CFR, Part 225?Selected Items of Cost indicates that where employees are expected to work solely on a single Federal award or cost objective, charges for their salaries and wages will be supported by periodic certifications that the employees worked solely on that program for the period covered by the certification. These certifications will be prepared at least semi-annually and will be signed by the employee or supervisory official having first-hand knowledge of the work performed by the employee. Questioned Costs: None. Condition: During our detailed testing of time-and-effort reporting for the Education Stabilization Fund??GEER/ESSER programs, we noted that semi-annual certifications were prepared to comply with federal time and effort requirements. However, the reports were not timely prepared or timely reviewed by the program supervisor with documented approval. Context: Ninety-five employees working in the federal program were eligible for semi-annual certifications because their payroll costs were fully allocated to a single federal program or cost objective. One certification was prepared by each building supervisor for each six-month period during the fiscal year. In total, the certifications properly listed all eligible 95 employees that worked in the federal program during the respective semesters. While the certifications contained the proper components, including documented supervisor approval, they were not prepared timely as they were completed and certified during the audit process. The sample was not a statistically valid sample. Effect: Failure to timely and properly prepare and review time-and-effort reporting could allow improper payroll expenses to be charged to the School District?s federal programs. As a result, payroll compensation and fringe benefits charged for these employees could be disallowed, or there could be missed opportunities for reimbursement. Cause: The School District program personnel overlooked the federal requirements for time-and-effort reporting and the semi-annual certifications were not timely prepared. Repeat Finding: This is not a repeat finding. Recommendation: The School District should provide training to educate all employees working in federal programs of the requirements for documenting personnel expenses under Uniform Grant Guidance, and the School District should require proper time-and-effort documentation to be timely prepared and certified by the appropriate program supervisor. Views of Responsible Officials: The School District agrees with this finding.
U.S. Department of Education Finding 2022-001: Education Stabilization Fund??Governor?s Emergency Education Relief (GEER) and Elementary and Secondary School Emergency Relief (ESSER) Fund Semi-Annual Certification Procedures Pass-through entity: Michigan Department of Education (MDE) Assistance Listing Number(s): 84.425C and 84.425D Award Numbers: COVID-19 211202-2122, COVID-19 213712-2021, COVID-19 213722-2122 and COVID-19 213742-2122 Award Year End: September 30, 2023 Specific Requirement: Allowable Costs/Cost Principles Criteria: Section 200.430 of the Cost Principles of the Title 2 U.S. Code of Federal Regulations (CFR) Part 200?Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) requires charges to federal award for salaries and wages to be based on records that accurately reflect the work performed. These records must (1) be supported by a system of internal controls which provide reasonable assurance that charges are accurate, allowable and properly allocated, (2) reasonably reflect total activity for which the employee is compensated, (3) encompass both federally assisted and all other activities compensated by the entity, (4) support the distribution of the employee?s wages among specific cost objectives if the employee works on more than one federal award, (5) be reconciled with payroll budget estimates with necessary adjustments made to accounting records to ensure that excess costs are not charged to federal programs. Appendix B to 2 CFR, Part 225?Selected Items of Cost indicates that where employees are expected to work solely on a single Federal award or cost objective, charges for their salaries and wages will be supported by periodic certifications that the employees worked solely on that program for the period covered by the certification. These certifications will be prepared at least semi-annually and will be signed by the employee or supervisory official having first-hand knowledge of the work performed by the employee. Questioned Costs: None. Condition: During our detailed testing of time-and-effort reporting for the Education Stabilization Fund??GEER/ESSER programs, we noted that semi-annual certifications were prepared to comply with federal time and effort requirements. However, the reports were not timely prepared or timely reviewed by the program supervisor with documented approval. Context: Ninety-five employees working in the federal program were eligible for semi-annual certifications because their payroll costs were fully allocated to a single federal program or cost objective. One certification was prepared by each building supervisor for each six-month period during the fiscal year. In total, the certifications properly listed all eligible 95 employees that worked in the federal program during the respective semesters. While the certifications contained the proper components, including documented supervisor approval, they were not prepared timely as they were completed and certified during the audit process. The sample was not a statistically valid sample. Effect: Failure to timely and properly prepare and review time-and-effort reporting could allow improper payroll expenses to be charged to the School District?s federal programs. As a result, payroll compensation and fringe benefits charged for these employees could be disallowed, or there could be missed opportunities for reimbursement. Cause: The School District program personnel overlooked the federal requirements for time-and-effort reporting and the semi-annual certifications were not timely prepared. Repeat Finding: This is not a repeat finding. Recommendation: The School District should provide training to educate all employees working in federal programs of the requirements for documenting personnel expenses under Uniform Grant Guidance, and the School District should require proper time-and-effort documentation to be timely prepared and certified by the appropriate program supervisor. Views of Responsible Officials: The School District agrees with this finding.
U.S. Department of Education Finding 2022-001: Education Stabilization Fund??Governor?s Emergency Education Relief (GEER) and Elementary and Secondary School Emergency Relief (ESSER) Fund Semi-Annual Certification Procedures Pass-through entity: Michigan Department of Education (MDE) Assistance Listing Number(s): 84.425C and 84.425D Award Numbers: COVID-19 211202-2122, COVID-19 213712-2021, COVID-19 213722-2122 and COVID-19 213742-2122 Award Year End: September 30, 2023 Specific Requirement: Allowable Costs/Cost Principles Criteria: Section 200.430 of the Cost Principles of the Title 2 U.S. Code of Federal Regulations (CFR) Part 200?Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) requires charges to federal award for salaries and wages to be based on records that accurately reflect the work performed. These records must (1) be supported by a system of internal controls which provide reasonable assurance that charges are accurate, allowable and properly allocated, (2) reasonably reflect total activity for which the employee is compensated, (3) encompass both federally assisted and all other activities compensated by the entity, (4) support the distribution of the employee?s wages among specific cost objectives if the employee works on more than one federal award, (5) be reconciled with payroll budget estimates with necessary adjustments made to accounting records to ensure that excess costs are not charged to federal programs. Appendix B to 2 CFR, Part 225?Selected Items of Cost indicates that where employees are expected to work solely on a single Federal award or cost objective, charges for their salaries and wages will be supported by periodic certifications that the employees worked solely on that program for the period covered by the certification. These certifications will be prepared at least semi-annually and will be signed by the employee or supervisory official having first-hand knowledge of the work performed by the employee. Questioned Costs: None. Condition: During our detailed testing of time-and-effort reporting for the Education Stabilization Fund??GEER/ESSER programs, we noted that semi-annual certifications were prepared to comply with federal time and effort requirements. However, the reports were not timely prepared or timely reviewed by the program supervisor with documented approval. Context: Ninety-five employees working in the federal program were eligible for semi-annual certifications because their payroll costs were fully allocated to a single federal program or cost objective. One certification was prepared by each building supervisor for each six-month period during the fiscal year. In total, the certifications properly listed all eligible 95 employees that worked in the federal program during the respective semesters. While the certifications contained the proper components, including documented supervisor approval, they were not prepared timely as they were completed and certified during the audit process. The sample was not a statistically valid sample. Effect: Failure to timely and properly prepare and review time-and-effort reporting could allow improper payroll expenses to be charged to the School District?s federal programs. As a result, payroll compensation and fringe benefits charged for these employees could be disallowed, or there could be missed opportunities for reimbursement. Cause: The School District program personnel overlooked the federal requirements for time-and-effort reporting and the semi-annual certifications were not timely prepared. Repeat Finding: This is not a repeat finding. Recommendation: The School District should provide training to educate all employees working in federal programs of the requirements for documenting personnel expenses under Uniform Grant Guidance, and the School District should require proper time-and-effort documentation to be timely prepared and certified by the appropriate program supervisor. Views of Responsible Officials: The School District agrees with this finding.
U.S. Department of Education Finding 2022-001: Education Stabilization Fund??Governor?s Emergency Education Relief (GEER) and Elementary and Secondary School Emergency Relief (ESSER) Fund Semi-Annual Certification Procedures Pass-through entity: Michigan Department of Education (MDE) Assistance Listing Number(s): 84.425C and 84.425D Award Numbers: COVID-19 211202-2122, COVID-19 213712-2021, COVID-19 213722-2122 and COVID-19 213742-2122 Award Year End: September 30, 2023 Specific Requirement: Allowable Costs/Cost Principles Criteria: Section 200.430 of the Cost Principles of the Title 2 U.S. Code of Federal Regulations (CFR) Part 200?Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) requires charges to federal award for salaries and wages to be based on records that accurately reflect the work performed. These records must (1) be supported by a system of internal controls which provide reasonable assurance that charges are accurate, allowable and properly allocated, (2) reasonably reflect total activity for which the employee is compensated, (3) encompass both federally assisted and all other activities compensated by the entity, (4) support the distribution of the employee?s wages among specific cost objectives if the employee works on more than one federal award, (5) be reconciled with payroll budget estimates with necessary adjustments made to accounting records to ensure that excess costs are not charged to federal programs. Appendix B to 2 CFR, Part 225?Selected Items of Cost indicates that where employees are expected to work solely on a single Federal award or cost objective, charges for their salaries and wages will be supported by periodic certifications that the employees worked solely on that program for the period covered by the certification. These certifications will be prepared at least semi-annually and will be signed by the employee or supervisory official having first-hand knowledge of the work performed by the employee. Questioned Costs: None. Condition: During our detailed testing of time-and-effort reporting for the Education Stabilization Fund??GEER/ESSER programs, we noted that semi-annual certifications were prepared to comply with federal time and effort requirements. However, the reports were not timely prepared or timely reviewed by the program supervisor with documented approval. Context: Ninety-five employees working in the federal program were eligible for semi-annual certifications because their payroll costs were fully allocated to a single federal program or cost objective. One certification was prepared by each building supervisor for each six-month period during the fiscal year. In total, the certifications properly listed all eligible 95 employees that worked in the federal program during the respective semesters. While the certifications contained the proper components, including documented supervisor approval, they were not prepared timely as they were completed and certified during the audit process. The sample was not a statistically valid sample. Effect: Failure to timely and properly prepare and review time-and-effort reporting could allow improper payroll expenses to be charged to the School District?s federal programs. As a result, payroll compensation and fringe benefits charged for these employees could be disallowed, or there could be missed opportunities for reimbursement. Cause: The School District program personnel overlooked the federal requirements for time-and-effort reporting and the semi-annual certifications were not timely prepared. Repeat Finding: This is not a repeat finding. Recommendation: The School District should provide training to educate all employees working in federal programs of the requirements for documenting personnel expenses under Uniform Grant Guidance, and the School District should require proper time-and-effort documentation to be timely prepared and certified by the appropriate program supervisor. Views of Responsible Officials: The School District agrees with this finding.