Finding 624185 (2022-003)

Material Weakness Repeat Finding
Requirement
C
Questioned Costs
-
Year
2022
Accepted
2022-11-13
Audit: 53995
Organization: Three Rivers Community Schools (MI)

AI Summary

  • Core Issue: The School District lacked timely reconciliation controls for payroll charges to Title I, leading to an overcharge of approximately $99,000.
  • Impacted Requirements: Compliance with federal cost principles requires accurate tracking of employee time and costs associated with federal awards.
  • Recommended Follow-up: Implement an annual review and reconciliation process to ensure charges to Title I align with actual time spent on activities.

Finding Text

Assistance Listing Number, Federal Agency, and Program Name - 84.010A, U.S. Department of Education, Title I, Part A Federal Award Identification Number and Year - 211530, 221530 Pass-through Entity - Michigan Department of Education Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - Yes 2021-003 Criteria - Under the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200.430, allowable direct costs chargeable to federal awards include compensation of employees for the time devoted and identified specifically to the performance of those awards. When an employee spends time among specific activities or cost objectives, the School District should maintain support for the distribution of time. Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to federal awards but may be used for interim accounting, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity actually performed. (B) Significant changes in the corresponding work activity (as defined by the nonfederal entity?s written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term. (C) The nonfederal entity?s system of internal controls includes processes to review after the fact interim charges made to a federal award based on budget estimates. All necessary adjustments must be made such that the final amount charged to the federal award is accurate, allowable, and properly allocated. Under the federal payment principles contained in Title 2 U.S. Code of Federal Regulations Part 200.305, nonfederal entities are generally required to draw federal payments on a reimbursement basis. Condition - During payroll expenditure testing of salaried employees, it was identified that, for employees who spend time in multiple cost objectives, appropriate controls were not in place to perform a timely reconciliation between the time charged to Title I based on budget estimates and the actual time expended on Title I activities. Ultimately a reconciliation was performed, and approximately $99,000 was overcharged to Title I and subsequently reclassified as a non-grant expenditure. However, the School District requested and received reimbursement for this amount during the year ended June 30, 2022. Questioned Costs - None Identification of How Questioned Costs Were Computed - No questioned costs Context - Title I payroll costs include those incurred by both hourly and salary employees. During our testing, we noted that timekeeping documentation for the hourly paid employees satisfied the requirement to track their activities to the charges to Title I. However, for the total population of salary employees charged to Title I, a timely reconciliation was not completed at the end of the year to adjust charges to the grant to agree with the actual time expended on Title I activities. Due to the timely reconciliation not occurring, the School District requested and received funds in excess of actual costs incurred throughout the year. The School District receives monthly activity reports, or PARS, from the salary employees to describe the activities completed on a daily basis. The salary employees work in buildings that are schoolwide Title I programs, and the School District does not use all of the allocated funds for Title I. It is determined that the activities completed by the salary employees are reasonable and allowable based on buildings being schoolwide Title I programs; therefore, no questioned costs were identified. Cause and Effect - The School District does not have proper controls in place to ensure that the reconciliation is being performed timely to validate the budget estimate used to charge to Title I throughout the year to the actual time expended on Title I activities. This lack of control is caused by the lack of adequate grant oversight and an insufficient control environment. Once the reconciliation was ultimately performed, it was identified that approximately $99,000 was charged to the Title I grant that was in excess of actual allowable costs, this amount was reclassified as a nongrant expenditure prior to the final close of the June 30, 2022 trial balance. The School District received reimbursement of this amount prior to the reclassification of these expenditures. Recommendation - The School District should complete a review and reconciliation process on an annual basis before the end of the grant period to support that the amount charged to Title I based on budget estimates is reasonable when compared to actual time expended on Title I activities. This review and reconciliation should be maintained to support the wages charged to Title I. Views of Responsible Officials and Corrective Action Plan - Three Rivers Community Schools agrees with the above recommendation. The School District will implement procedures to complete a review and reconciliation process to support that the amount charged to Title I based on budget estimates is reasonable when compared to actual time expended on Title I activities.

Categories

Internal Control / Segregation of Duties Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking Cash Management Material Weakness Subrecipient Monitoring

Other Findings in this Audit

  • 47742 2022-003
    Material Weakness Repeat
  • 47743 2022-003
    Material Weakness Repeat
  • 47744 2022-004
    Material Weakness
  • 624184 2022-003
    Material Weakness Repeat
  • 624186 2022-004
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.010 Title I Grants to Local Educational Agencies $466,629
10.553 School Breakfast Program $384,840
32.009 Covid-19 - Emergency Connectivity Fund Program $164,500
84.367 Improving Teacher Quality State Grants $118,095
84.425 Covid-19 - Education Stabilization Fund $74,655
10.555 National School Lunch Program $50,024
10.559 Summer Food Service Program for Children $42,207
93.778 Medical Assistance Program $34,353
84.424 Student Support and Academic Enrichment Program $26,885
84.002 Adult Education - Basic Grants to States $25,300
10.649 Covid-19 - Pandemic Ebt Administrative Costs $3,063
84.365 English Language Acquisition State Grants $-1,968