Finding 577573 (2023-003)

Material Weakness Repeat Finding
Requirement
A
Questioned Costs
-
Year
2023
Accepted
2023-11-02
Audit: 2150
Organization: Ecorse Public Schools (MI)
Auditor: Yeo & Yeo PC

AI Summary

  • Core Issue: Payroll documentation and reconciliation processes are inadequate, leading to payments not aligning with approved rates.
  • Impacted Requirements: Compliance with grant agreements and internal controls over payroll processing are not being met, risking over or under-payment of employees.
  • Recommended Follow-up: Implement annual documentation of pay rates, ensure communication with payroll, review payroll registers before processing, and closely monitor budget compliance.

Finding Text

Finding 2023-003, 2022-001: Allowable Activities - Payroll Documentation and Reconciliation Program Name: Title I Grants to Local Educational Agencies – Assistance Listing 84.010 & Education Stabilization Fund – Assistance Listing 84.425C, 84.425D, 84.425U Awarding Agency: U.S. Department of Education, passed through Michigan Department of Education Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: Unknown Context / Criteria: The School District determines salary and hourly rates based on contractual agreements and other approved rates and charges these expenses to grants in accordance with approved grant agreements. The School District’s payroll processing should maintain internal controls sufficient to pay employees at agreed amounts, ensure timely changes to agreed amounts, and that amounts are charged to the correct grants in compliance with approved budgets. Condition: During our payroll testing we noted that 13 payments to employees charged to Title I and 10 payments to employees charged to ESSER were not paid based on approved rates. It was also noted that 3 employees charged to ESSER were not charged to the correct expense accounts based on their position changes. Additionally, it was noted that a bonus charged to the Title I grant was unallowable. Cause / Effect: The School District did not maintain sufficient procedures to ensure changes in pay rates were communicated to the appropriate departments for payroll processing. Employees could have been over or under-paid as a result. Additionally, the School District did not maintain sufficient procedures to ensure all expenses charged to the grant were allowable based on the approved budget. Recommendation: We recommend the School District document annual pay rates and increases within each personnel file and those pay rates should be communicated to the payroll department to ensure the changes are made within the payroll software. The payroll register should be reviewed before payroll is processed and paid. Additionally, the School District should review all expenditures to ensure the expense is allowable and monitor budget to actual more closely. The School District should ensure the budget used for this comparison agrees to the approved grant budget. Views of Responsible Officials and Corrective Actions: Management agrees with the finding. See accompanying Corrective Action Plan.

Categories

Allowable Costs / Cost Principles Material Weakness Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1127 2023-002
    Material Weakness Repeat
  • 1128 2023-002
    Material Weakness Repeat
  • 1129 2023-002
    Material Weakness Repeat
  • 1130 2023-002
    Material Weakness Repeat
  • 1131 2023-003
    Material Weakness Repeat
  • 1132 2023-003
    Material Weakness Repeat
  • 1133 2023-003
    Material Weakness Repeat
  • 1134 2023-003
    Material Weakness Repeat
  • 1135 2023-004
    Material Weakness
  • 1136 2023-004
    Material Weakness
  • 1137 2023-004
    Material Weakness
  • 1138 2023-004
    Material Weakness
  • 577569 2023-002
    Material Weakness Repeat
  • 577570 2023-002
    Material Weakness Repeat
  • 577571 2023-002
    Material Weakness Repeat
  • 577572 2023-002
    Material Weakness Repeat
  • 577574 2023-003
    Material Weakness Repeat
  • 577575 2023-003
    Material Weakness Repeat
  • 577576 2023-003
    Material Weakness Repeat
  • 577577 2023-004
    Material Weakness
  • 577578 2023-004
    Material Weakness
  • 577579 2023-004
    Material Weakness
  • 577580 2023-004
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $5.65M
84.010 Title I Grants to Local Educational Agencies $1.05M
10.555 National School Lunch Program $505,059
84.027 Special Education_grants to States $299,988
10.553 School Breakfast Program $238,370
84.367 Improving Teacher Quality State Grants $163,420
93.778 Medical Assistance Program $89,210
84.424 Student Support and Academic Enrichment Program $60,150
10.559 Summer Food Service Program for Children $33,037
32.009 Emergency Connectivity Fund Program $21,224
84.365 English Language Acquisition State Grants $9,917
10.558 Child and Adult Care Food Program $4,536
10.649 Pandemic Ebt Administrative Costs $3,135