Finding 503538 (2024-001)

Material Weakness
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2024-10-23
Audit: 325665
Organization: Coldwater Community Schools (MI)
Auditor: Hungerford

AI Summary

  • Core Issue: The District lacks adequate internal controls over time and effort reporting for salaries charged to the Title I, Part A grant.
  • Impacted Requirements: Compliance with 2 CFR 200.430(i) is not met, as records do not accurately reflect work performed and lack proper support.
  • Recommended Follow-Up: Implement and adhere to documented time and effort reporting procedures to ensure accurate allocation of salaries and wages.

Finding Text

Material Weakness in Internal Controls over Compliance (Allowable Costs/Cost Principles), and Noncompliance with Laws and Regulations. Program Impacted: 84.010 – Title I, Part A. Criteria: 2 CFR 200.430(i) requires that charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. Among other requirements identified in this section, these records must (i) be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated, and (v) comply with the established accounting policies and practices of the District. Condition: The District did not maintain adequate controls over time and effort reporting to substantiate salaries and wages charged to the Title I, Part A grant. Cause: The District’s oversight of salaries and wages charged to the Title I, Part A grant was insufficient. Effect: The District was unable to support the accuracy of salaries and wages charged to the Title I, Part A grant. Questioned Costs: The District adjusted unsupported charges from the grant via the final request for reimbursement for the fiscal year expenditures. No questioned costs after adjustments. Context: The District utilized Personnel Activity Reports (PARs) for split-funded personnel as the control over salaries and wages charged to the Title I, Part A grant. The PARs identify the employee and total hours spent on grant-funded activities, supporting the rate at which they are to be charged during the specified period. During our review of salaries and wages charged to the grant during the audit period, we noted instances of one individual being charged at rates in excess of those specified on the associated PAR. Recommendation: We recommend that the District adhere to documented time and effort reporting procedures and maintain effective internal controls that ensure salaries and wages are allocated based on records that accurately reflect the work performed. View of Responsible Officials: The District agrees with the finding and will adhere to documented time and effort reporting procedures to ensure that salaries and wages allocated to federal awards are accurate and adequately supported.

Corrective Action Plan

The District will work with the Assistant Superintendent of Curriculum and Instruction and the payroll supervisor to ensure that pars are matching what is being charged in the payroll system. A form will be created to ensure that they align and both parties will sign off on it quarterly.

Categories

Allowable Costs / Cost Principles Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1079980 2024-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $1.94M
10.555 National School Lunch Program $1.33M
84.010 Title I Grants to Local Educational Agencies $729,081
10.553 School Breakfast Program $495,216
10.559 Summer Food Service Program for Children $169,926
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) $114,420
84.365 English Language Acquisition State Grants $77,733
84.424 Student Support and Academic Enrichment Program $40,172
10.185 Local Food for Schools Cooperative Agreement Program $17,018
10.579 Child Nutrition Discretionary Grants Limited Availability $10,000
10.558 Child and Adult Care Food Program $7,916