Finding 1164933 (2025-001)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2025
Accepted
2025-12-16
Audit: 374865
Organization: Ypsilanti Community Schools (MI)
Auditor: YEO & YEO PC

AI Summary

  • Core Issue: The School District overspent its budget by $15,920,067, indicating a significant lack of budget monitoring and control.
  • Impacted Requirements: Compliance with the Michigan School Accounting Manual and Board of Education budget approvals was not maintained, leading to material noncompliance.
  • Recommended Follow-Up: Establish clear policies for ongoing budget monitoring and adopt amended budgets as necessary to manage spending effectively.

Finding Text

Program Name and Awarding Agency: Education Stabilization Fund –84.425V, 84.425W, 84.425U, U.S. Department of Education, passed through Michigan Department of Education Literacy Excellence Accelerates Performance – 84.215G, U.S. Department of Education Supporting Educator Excellence and Knowledge – 84.374A, U.S. Department of Education Magnet Schools Assistance ARC (Academically Rigorous Choices) – 84.165A, U.S. Department of Education Head Start Cluster – 93.600, U.S. Department of Health and Human Services, passed through Washtenaw Intermediate School District Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: The Michigan School Accounting Manual (Bulletin 1022) serves as a mandatory guide to the uniform classification and recording of accounting transactions for Michigan public school districts. Furthermore, the School District shall not incur an expenditure against an appropriation account in excess of the amount authorized by the Board of Education. The School District is also responsible for comparing budget to actual expenses by function for programs. The School District should also import its original and final budgets into the accounting system to monitor spending and reduce errors in posting expenditures to the chart of accounts. Condition: The School District incurred material budget overages in multiple budgeted functions as adopted by the Board of Education and disclosed in the June 30, 2025 financial statements. Additionally, total actual expenditures of $91,760,599 exceed total budgeted expenditures of $75,840,532 by $15,920,067 in the General Fund. No adopted budget was provided for the Student and School Activities Fund. The final budget also was not imported into the School District’s accounting software. Cause / Effect: The budget was not properly monitored allowing the budget overages to exist. The School District has not established appropriate controls to ensure that the budget is monitored during the year and has overspent the Board-approved budget by a material amount. Additionally, the lack of budgets imported in the accounting software combined with the numerous federal and restricted state grants the School District receives increases the risk of the wrong account codes being used for expenditures which could have a material effect on reporting of Federal and restricted state grants. Recommendation: We recommend that the School District establish policies and procedures to ensure the budget is properly maintained and monitored throughout the year. An amended budget should be adopted throughout the year, as needed, to reflect changes in spending needs. Views of Responsible Officials and Corrective Actions: Management is in agreement with the finding. See accompanying corrective action plan.

Corrective Action Plan

Corrective Action: The Finance Director and Business Office will undergo additional training with Tyler Technologies, Michigan School Business Officials, and others to optimize financial processes and transaction processing. The team will adhere to the state business calendar for timely reconciliations, budget amendments, and internal control reviews. Responsible Person: Director of Finance

Categories

Material Weakness Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1164919 2025-001
    Material Weakness Repeat
  • 1164920 2025-001
    Material Weakness Repeat
  • 1164921 2025-002
    Material Weakness Repeat
  • 1164922 2025-003
    Material Weakness Repeat
  • 1164923 2025-001
    Material Weakness Repeat
  • 1164924 2025-002
    Material Weakness Repeat
  • 1164925 2025-003
    Material Weakness Repeat
  • 1164926 2025-001
    Material Weakness Repeat
  • 1164927 2025-002
    Material Weakness Repeat
  • 1164928 2025-003
    Material Weakness Repeat
  • 1164929 2025-001
    Material Weakness Repeat
  • 1164930 2025-001
    Material Weakness Repeat
  • 1164931 2025-001
    Material Weakness Repeat
  • 1164932 2025-001
    Material Weakness Repeat
  • 1164934 2025-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $3.28M
84.165 MAGNET SCHOOLS ASSISTANCE $2.43M
93.600 HEAD START $2.18M
10.555 NATIONAL SCHOOL LUNCH PROGRAM $1.80M
84.215 INNOVATIVE APPROACHES TO LITERACY; PROMISE NEIGHBORHOODS; FULL-SERVICE COMMUNITY SCHOOLS; AND CONGRESSIONALLY DIRECTED SPENDING FOR ELEMENTARY AND SECONDARY EDUCATION COMMUNITY PROJECTS $1.17M
84.027 SPECIAL EDUCATION GRANTS TO STATES $1.06M
84.374 TEACHER AND SCHOOL LEADER INCENTIVE GRANTS (FORMERLY THE TEACHER INCENTIVE FUND) $1.02M
84.425 EDUCATION STABILIZATION FUND $803,043
10.553 SCHOOL BREAKFAST PROGRAM $752,372
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $271,950
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $214,554
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $185,000
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES $57,332
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN $41,530
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $40,305
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS $30,616
21.019 CORONAVIRUS RELIEF FUND $29,696
10.558 CHILD AND ADULT CARE FOOD PROGRAM $6,009
10.582 FRESH FRUIT AND VEGETABLE PROGRAM $-14,689