Finding 396402 (2023-006)

Material Weakness
Requirement
C
Questioned Costs
-
Year
2023
Accepted
2024-05-10
Audit: 305967
Organization: Hamtramck Public Schools (MI)
Auditor: Yeo & Yeo PC

AI Summary

  • Core Issue: The district improperly managed grant funds by moving expenses between grants after receiving reimbursements, leading to unearned revenue.
  • Impacted Requirements: All expenses charged to grants must be supported by allowable costs, and funds should only be requested based on these expenses.
  • Recommended Follow-Up: The district should reconcile grant revenues and expenses before year-end to ensure accurate classification and full utilization of funds.

Finding Text

2023-006 – Material Weakness and Material Noncompliance – Cash Management Program information: COVID-19 Governor’s Emergency Education Relief (GEER), U.S. Department of Education, passed through Michigan Department of Education, AL #84.425C; COVID-19 Elementary and Secondary School Emergency Relief (ESSER) Formula, U.S. Department of Education, passed through Michigan Department of Education, AL #84.425D; COVID-19 ESSER Education Equity, U.S. Department of Education, passed through Michigan Department of Education, AL #84.425D. Criteria: The School District should support all expenses that are charged to a grant and should only request funds in amounts that are supported by allowable expenses. Condition: As of June 30, 2023, the district had unearned revenue recorded related to the ESSER III Grant AL# 84.425U Project 213713. This resulted due to the District requesting expense reimbursements through a cash request, and then subsequently moving the expenses from the ESSER III grant to the ESSER II grant after the funds had already been received in order to spend down their remaining ESSER II grants before they expired. Questioned costs: None Cause and effect: Management did not properly reconcile grant revenue and expense accounts at year end. Recommendation: We recommend that the district reconciles all grant revenues and expenses before the end of the year to ensure that all projects are being fully spent and properly classified within the trial balance. Views of responsible officials: Management agrees with the finding. Corrective action plan: See attached corrective action plan.

Categories

Cash Management Material Weakness

Other Findings in this Audit

  • 396391 2023-004
    Material Weakness
  • 396392 2023-005
    Material Weakness
  • 396393 2023-004
    Material Weakness
  • 396394 2023-005
    Material Weakness
  • 396395 2023-003
    Material Weakness
  • 396396 2023-003
    Material Weakness
  • 396397 2023-003
    Material Weakness
  • 396398 2023-003
    Material Weakness
  • 396399 2023-006
    Material Weakness
  • 396400 2023-006
    Material Weakness
  • 396401 2023-006
    Material Weakness
  • 972833 2023-004
    Material Weakness
  • 972834 2023-005
    Material Weakness
  • 972835 2023-004
    Material Weakness
  • 972836 2023-005
    Material Weakness
  • 972837 2023-003
    Material Weakness
  • 972838 2023-003
    Material Weakness
  • 972839 2023-003
    Material Weakness
  • 972840 2023-003
    Material Weakness
  • 972841 2023-006
    Material Weakness
  • 972842 2023-006
    Material Weakness
  • 972843 2023-006
    Material Weakness
  • 972844 2023-006
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $2.99M
84.010 Title I Grants to Local Educational Agencies $931,049
10.559 Summer Food Service Program for Children $310,579
84.002 Adult Education - Basic Grants to States $246,994
10.555 National School Lunch Program $172,934
10.582 Fresh Fruit and Vegetable Program $98,850
84.365 English Language Acquisition State Grants $82,061
10.553 School Breakfast Program $69,938
84.424 Student Support and Academic Enrichment Program $63,871
84.367 Improving Teacher Quality State Grants $55,428
84.048 Career and Technical Education -- Basic Grants to States $44,682
93.778 Medical Assistance Program $12,248
10.579 Child Nutrition Discretionary Grants Limited Availability $10,000
10.649 Pandemic Ebt Administrative Costs $3,135
84.027 Special Education_grants to States $2,707
10.558 Child and Adult Care Food Program $1,331