Finding 575601 (2025-003)

Significant Deficiency Repeat Finding
Requirement
F
Questioned Costs
-
Year
2025
Accepted
2025-09-04
Audit: 365594
Organization: Village of Shelby (MI)

AI Summary

  • Core Issue: The Village's asset listing for federally funded equipment is incomplete and lacks required details, such as locations and funding sources.
  • Impacted Requirements: Compliance with Section 200.313(d) of the Uniform Guidance is not met, including the need for regular physical inventories and reconciliations.
  • Recommended Follow-up: The Village should implement procedures to maintain complete asset records and conduct physical inventories every two years to safeguard against loss or theft.

Finding Text

Finding 2025-003: Community Development Block Grants Equipment Procedures Type of Finding: Both Compliance and Control U.S. Department of Housing and Urban Development Pass-through Entity: Michigan Strategic Fund Assistance Listing Number: 14.228 Award Numbers: MSC 222003-PGS and MSC-221009-WRI Award Year Ends: November 30, 2024, and December 31, 2024 Specific Requirements: (F.) Equipment Criteria: Section 200.313(d) of the Cost Principles of the Title 2 U.S. Code of Federal Regulations Part 200—Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) requires a non-federal entity to (1) maintain property records that include a description of the property, a serial number or other identification number, the source of funding for the property, who holds the title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property, (2) perform a physical inventory of the property and reconcile the results with the property records at least once every two years, (3) develop a control system to ensure adequate safeguards to prevent loss, damage, or theft of the property with any suspected loss, damage or theft investigated. Questioned Costs: None. Condition: The listing maintained by the Village for assets acquired with federal funds was lacking certain required elements. In addition, a physical inventory was not performed and documented, and the results were not reconciled with the property records as required. Context: The Village maintains a listing of fixed assets that it owns. We noted that the listing properly contained descriptions of the property, identification numbers, acquisition dates, and cost of the property. However, the fixed asset listing was lacking locations, federal funding sources, percentages of federal participation in the costs of fixed assets acquired under federal awards and the conditions of the property as required. In addition, the Village did not perform and document a physical inventory of the property and reconcile the results with the property records at least once every two years as required. The sample was not a statistically valid sample, and the matter appears to be a systemic condition. Effect: A control system has not been fully implemented to safeguard the fixed assets to prevent loss, damage or theft and promptly investigate missing items. Failure to maintain adequate detailed fixed asset records with all the required elements, failure to perform a physical inventory of the property, and failure to reconcile the inventory results with the property records could lead to the loss or misappropriation of these assets. Cause: The Village became aware of this requirement during the prior single audit but was unable to fully implement this corrective action in the current year. Repeat Finding: See Finding 2024-003 for a similar finding reported during the audit for the year ended February 29, 2024. Recommendation: The Village should establish procedures to require the maintenance of detailed fixed asset records that include all specified elements. In addition, the Village should perform a physical inventory of the property and reconcile the results with fixed asset records at least once every two years to help prevent loss, damage, or theft of the property. Views of Responsible Officials: The Village agrees with this finding.

Corrective Action Plan

Finding 2025-003: Community Development Block Grants Equipment Procedures Type of Finding: Both Compliance and Control U.S. Department of Housing and Urban Development Pass-through Entity: Michigan Strategic Fund Assistance Listing Number: 14.228 Award Numbers: MSC 22003-PGS and MSC-221009-WRI Award Year Ends: November 30, 2024, and December 31, 2024 Recommendation: The Village should establish procedures to require the maintenance of detailed fixed asset records that include all specified elements. In addition, the Village should perform a physical inventory of the property and reconcile the results with fixed asset records at least once every two years to help prevent loss, damage, or theft of the property. Action Taken: The Village will establish a standard operating procedure that requires the maintenance of detailed asset records and the performance of a documented physical inventory of the assets acquired with federal funds on an annual basis. Responsible Person and Anticipated Completion Date: The Village Clerk/Treasurer will oversee the implementation of this plan by February 28, 2026.

Categories

Equipment & Real Property Management

Other Findings in this Audit

  • 575602 2025-004
    Significant Deficiency
  • 575603 2025-004
    Significant Deficiency
  • 1152043 2025-003
    Significant Deficiency Repeat
  • 1152044 2025-004
    Significant Deficiency
  • 1152045 2025-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $420,362
15.916 Outdoor Recreation Acquisition, Development and Planning $300,000
21.027 Coronavirus State and Local Fiscal Recovery Funds $206,439