Finding 1168655 (2025-005)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2025
Accepted
2026-01-09
Audit: 380616
Organization: Village of Beverly Hills (MI)

AI Summary

  • Core Issue: Federal expenses and revenues were incorrectly recorded for both fiscal years 2025 and 2026, requiring a material adjustment during the audit.
  • Impacted Requirements: The Schedule of Expenditures of Federal Awards must only include eligible expenses from the current fiscal year.
  • Recommended Follow-Up: Conduct a thorough review of federal expenses and revenues at year-end to ensure accurate period recording, aiding in compliance and audit readiness.

Finding Text

Finding 2025-005 – Material Weakness and Material Noncompliance – Allowable Costs Program Information: Congressionally Mandated Projects, U.S. Environmental Protection Agency, 00E04067, 2025, ALN #66.202 Criteria: Federal revenues and expenses reported on the Schedule of Expenditures of Federal Awards should only include eligible expenses that occurred within the current fiscal year. Condition: A material adjustment was required during the audit to record federal expenses and revenues of the program in the proper period for an invoice that included activity for both fiscal year 2025 and fiscal year 2026. The expenses and revenues were originally improperly recorded only in fiscal year 2025. Questioned Costs: None Cause and Effect: Expenses and revenues were recorded in the improper period resulting in a material audit adjustment to correct the Schedule of Expenditures of Federal Awards. Recommendation: We recommend federal expenses and revenues be reviewed closely to ensure they are recorded in the proper period, especially at year end. This will give management and the Village Council an accurate depiction of federal expenses and revenues, which will also help to ensure that single audits are performed when required. Views of Responsible Officials: Management agrees with the finding. Corrective Action Plan: See attached corrective action plan.

Corrective Action Plan

2025-005 - Material Weakness and Material Noncompliance - Allowable Costs Condition: Federal revenues and expenses reported on the Schedule of Expenditures of Federal Awards should only include eligible expenses that occurred within the current fiscal year. Corrective Action Plan: The Village experienced some staff turnover in the prior fiscal year. In addition, the Village has not historically been subject to single audits, which created some challenges with the preparation of the Schedule of Expenditures of Federal Awards. Going forward, the Village has a better understanding of the requirements for completing the Schedule.

Categories

Allowable Costs / Cost Principles Material Weakness Reporting

Other Findings in this Audit

  • 1168654 2025-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
66.202 CONGRESSIONALLY MANDATED PROJECTS $445,608
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $22,500
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $1,540