Finding 403065 (2023-007)

Significant Deficiency
Requirement
F
Questioned Costs
-
Year
2023
Accepted
2024-06-26

AI Summary

  • Core Issue: The Organization's asset records are missing key details and have not been physically inventoried as required.
  • Impacted Requirements: Failure to comply with Section 200.313(d) of the Uniform Guidance regarding asset management and inventory reconciliation.
  • Recommended Follow-Up: Implement procedures for maintaining complete asset records and conduct physical inventories every two years to safeguard against loss or theft.

Finding Text

U.S. Department of Justice Pass-through Entity: Michigan Department of Health and Human Services Assistance Listing Number: 16.575 Award Numbers: E20232575-00, E20233017-00, E20233431-00 Award Year End: September 30, 2023 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 Organization 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 Organization maintains a listing of fixed assets that it owns. We noted that the listing properly contained descriptions of the property, identification numbers, locations, federal funding sources, acquisition dates, and cost of the property. However, the fixed asset listing was lacking 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 Organization 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 Organization 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 Organization 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 Organization should establish procedures to require the maintenance of detailed fixed asset records that include all specified elements. In addition, the Organization 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 Organization agrees with this finding.

Corrective Action Plan

Finding 2023-007: Crime Victim Assistance Equipment Procedures U.S. Department of Justice Pass-through Entity: Michigan Department of Health and Human Services Assistance Listing Number: 16.575 Award Numbers: E20232575-00, E20233017-00, E20233431-00 Award Year End: September 30, 2023 Recommendation: The Organization should establish procedures to require the maintenance of detailed fixed asset records that include all specified elements. In addition, the Organization 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 Organization 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 Executive Director will oversee the implementation of this plan by September 30, 2024. If the U.S. Department of Justice has questions regarding this plan, please call Megan Hennessey at (616) 494-1724.

Categories

Equipment & Real Property Management

Other Findings in this Audit

  • 403063 2023-005
    Material Weakness
  • 403064 2023-006
    Significant Deficiency
  • 979505 2023-005
    Material Weakness
  • 979506 2023-006
    Significant Deficiency
  • 979507 2023-007
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
16.575 Crime Victim Assistance $745,855
93.558 Temporary Assistance for Needy Families $302,466
14.267 Continuum of Care Program $234,893
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $170,757
16.017 Sexual Assault Services Formula Program $68,840
97.024 Emergency Food and Shelter National Board Program $18,703
93.497 Family Violence Prevention and Services/ Sexual Assault/rape Crisis Services and Supports $15,468
14.231 Emergency Solutions Grant Program $15,419