Finding 1171996 (2025-003)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2025
Accepted
2026-02-03
Audit: 385089
Organization: Village of Milford, Michigan (MI)

AI Summary

  • Core Issue: The schedule of expenditures of federal awards (SEFA) was found to be incomplete and inaccurate, leading to an overstatement of $40,088 in federal funding.
  • Impacted Requirements: Compliance with 2 CFR 200.510(b) was not met, as necessary controls for preparing an accurate SEFA were lacking.
  • Recommended Follow-Up: The Village should establish review controls for the SEFA to ensure its completeness and accuracy, and has engaged an outside contractor for assistance.

Finding Text

Assistance Listing Number, Federal Agency, and Program Name - ALN 66.202, U.S. Environmental Protection Agency - Congressionally Mandated Projects Federal Award Identification Number and Year - CG-00E03697-0, 2024 Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria - Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 2 CFR 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use. Condition - Controls were not in place to ensure that the schedule of expenditures of federal awards (SEFA) was complete and accurate. Questioned Costs - None If Questioned Costs are Not Determinable, Description of Why Known Questioned Costs Were Undetermined or Otherwise Could Not Be Reported - N/A Identification of How Questioned Costs Were Computed - N/A Context - In fiscal year 2025, the Village expended approximately $935,000 of federal funding from various federal agencies. The Village accumulates the financial data and other required information to complete the SEFA. Expenditures under grant ALN 66.202, Congressionally Mandated Projects, were originally overstated by $40,088 due to duplication of costs. No controls were in place to identify incompleteness or inaccuracy of the SEFA. Cause and Effect - No review or other control was in place to ensure the SEFA was complete and accurate. As a result, ALN 66.202, Congressionally Mandated Projects, expenditures were overstated by $40,088. This error has been corrected on the SEFA as of June 30, 2025. Recommendation - The Village should implement controls to ensure the SEFA is reviewed for completeness and accuracy. Views of Responsible Officials and Planned Corrective Actions - The Village has hired an outside contractor to assist with review of audit documents.

Corrective Action Plan

Condition: Controls were not in place to ensure that the schedule of expenditures of federal awards (SEFA) was complete and accurate. Planned Corrective Action: The Village has hired an outside contractor to assist with review of audit documents. Contact person responsible for corrective action: Penny Ray Anticipated Completion Date: 12/31/2025

Categories

Reporting Material Weakness

Other Findings in this Audit

  • 1171995 2025-002
    Material Weakness Repeat
  • 1171997 2025-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
66.202 CONGRESSIONALLY MANDATED PROJECTS $680,415
21.027 COVID-19 - CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $125,360
16.753 CONGRESSIONALLY RECOMMENDED AWARDS $66,573
16.835 BODY WORN CAMERA POLICY AND IMPLEMENTATION $42,000
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $20,960