Finding 486130 (2024-003)

Significant Deficiency
Requirement
F
Questioned Costs
-
Year
2024
Accepted
2024-09-09
Audit: 318759
Organization: Village of Shelby (MI)

AI Summary

  • Core Issue: The Village's asset records for federal funds are incomplete and lack required details.
  • Impacted Requirements: Failure to maintain proper records and conduct physical inventories violates federal regulations.
  • Recommended Follow-up: Implement procedures for detailed asset records and conduct biannual physical inventories to safeguard assets.

Finding Text

Finding 2024-003: Community Development Block Grants Type of Finding: Both Control and Compliance 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 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 was unaware of the requirements to maintain adequate detailed fixed asset records with specified elements, perform a physical inventory of the property and reconcile the results with the property records at least once every two years. As a result, the Village did not have proper policies and procedures in place to ensure that these required steps were completed. Repeat Finding: This is not a repeat finding. 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 2024-003: Community Development Block Grants Type of Finding: Both Control and Compliance 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, 2025. If the Michigan Strategic Fund has questions regarding this plan, please call Crystal Budde at 231-861-4401.

Categories

Equipment & Real Property Management

Other Findings in this Audit

  • 1062572 2024-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $762,496
21.027 Coronavirus State and Local Fiscal Recovery Funds $621,000
66.468 Capitalization Grants for Drinking Water State Revolving Funds $124,286