Finding 1164928 (2025-003)

Material Weakness Repeat Finding
Requirement
A
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 has a material weakness in internal controls, leading to questioned costs of $103,970 due to improper documentation and coding of expenditures.
  • Impacted Requirements: Internal controls must ensure that disbursements and payroll are accurately documented and comply with Uniform Guidance standards.
  • Recommended Follow-Up: Management should implement procedures to ensure correct allocation of expenditures and regularly compare actual spending to the budget to identify errors.

Finding Text

Program Name: Literacy Excellence Accelerates Performance – 84.215G Awarding Agency: U.S. Department of Education Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: Our testing identified known questioned costs of $103,970. We extrapolated the error rate to the total population, based on our sample, which calculates extrapolated questioned costs of $103,970. Context / Criteria: The School District should maintain internal controls to document disbursements and salaries and wages that accurately reflect the expenditures incurred and work performed based on Uniform Guidance. The internal controls should provide reasonable assurance that the charges are accurate, allowable, and properly allocated as to account and period. Condition: The School District’s documentation for disbursements indicated the use of incorrect account and object codes, as well as a lack of supporting documentation for certain transactions. Specifically, 4 out of the 40 disbursements tested were charged to the general ledger as disbursements instead of payroll transactions, and support could not be provided for 4 out of the 40 disbursements tested. Cause / Effect: The School District is not appropriately labeling expenditures for posting and/or not appropriately reviewing expenditures compared to budget to prevent and identify errors. Additionally, the School District is not reviewing expenditures to supporting documentation to prevent and identify errors. The lack of review for charges being posted to these accounts could result in the School District over or under-charging certain function or object codes compare to approved budgets. Recommendation: We recommend management implement procedures to ensure all expenditures are being allocated to the correct program, account and object code. A comparison of actual expenditures to budget may help identify and prevent misstatements to account for function, program and object codes. 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 Business Office will implement enhanced internal control procedures to ensure that all expenditures are accurately allocated to the appropriate program account, function, and object code. As part of this process, the Director of Finance will perform regular comparisons of actual expenditures to budgeted amounts. This review will help identify potential misstatements, detect coding errors, and ensure that financial transactions are correctly recorded in accordance with state and district accounting requirements. Responsible Person: Director of Finance and Grant Managers

Categories

Internal Control / Segregation of Duties Material Weakness

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
  • 1164929 2025-001
    Material Weakness Repeat
  • 1164930 2025-001
    Material Weakness Repeat
  • 1164931 2025-001
    Material Weakness Repeat
  • 1164932 2025-001
    Material Weakness Repeat
  • 1164933 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