Finding 1205794 (2024-019)

Material Weakness Repeat Finding
Requirement
F
Questioned Costs
-
Year
2024
Accepted
2026-04-02
Audit: 397522
Organization: City of Mission (TX)

AI Summary

  • Core Issue: The City failed to maintain complete and accurate inventory records for assets funded by the Equitable Sharing Program, leading to multiple errors and omissions.
  • Impacted Requirements: The City did not comply with the Equitable Sharing Guide, which mandates detailed item-level tracking and regular reviews of all program-related assets.
  • Recommended Follow-Up: Implement a detailed inventory system for all assets, including regular management reviews to ensure records are accurate and complete.

Finding Text

Equipment Management (Significant Deficiency/Compliance) ALN No. 16.922 – Equitable Sharing Program Criteria: The Equitable Sharing Guide requires participating agencies to maintain complete and accurate inventory records for all assets purchased with Equitable Sharing Program funds. The Guide specifies that all assets, not only high-dollar items, must be inventoried, and that records must include item-level detail sufficient to track each piece of equipment individually. Effective internal controls further require that inventory listings be accurate, complete, and periodically reviewed to ensure proper stewardship of program-funded assets. Condition: During our review of the City’s inventory records for the Equitable Sharing Program, we noted multiple errors and omissions within the equipment tracking spreadsheet maintained by the City. Specifically: - Costs for multiple assets purchased together were combined into a single total preventing the City from tracking each asset on an item by item basis. - The listing did not reflect all program related equipment, resulting in incomplete inventory records. - The listing contained data entry errors, including incorrectly placed decimals that overstated the value of certain assets. - The City inventoried only larger items rather than all assets required to be tracked under the Equitable Sharing Guide. These issues were brought to the attention of City personnel and were subsequently corrected during the audit. Effect: Incomplete or inaccurate inventory records increase the risk that program-funded assets may be misstated, lost, misused, or not properly safeguarded. Inaccurate data may also impair the City’s ability to demonstrate compliance with federal asset management requirements and may result in questioned costs. Cause: Internal controls over equipment tracking and inventory management were not adequately designed or implemented. The City did not maintain item-level detail for all assets purchased with Equitable Sharing funds and lacked a formal review process to ensure the accuracy and completeness of its inventory records. Recommendation: We recommend the City maintain a detailed, item by item inventory records for all assets purchased with Equitable Sharing Program funds, including descriptions, quantities, unit costs serial numbers (if applicable), and acquisition dates. We also recommend a periodic management review to verify that inventory records are accurate, complete, and properly valued. Repeat Finding from Prior Year(s): N/A Views of Responsible Officials: See management’s corrective action plan.

Corrective Action Plan

The City will incorporate verification of grant-funded assets into year-end closing process; require asset reconciliation between Finance Department, Grants Department, and Funding Agency asset records (if provided); and maintain item-level tracking of grant-funded assets. Responsible Officials: Michael Elizalde, Grants & Strategic Initiatives Director / Vidal Roman Finance Director Timeline to Complete: Estimated December 2026

Categories

Equipment & Real Property Management Procurement, Suspension & Debarment Significant Deficiency

Other Findings in this Audit

  • 1205792 2024-016
    Material Weakness Repeat
  • 1205793 2024-018
    Material Weakness Repeat
  • 1205795 2024-016
    Material Weakness Repeat
  • 1205796 2024-016
    Material Weakness Repeat
  • 1205797 2024-017
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $3.99M
20.205 HIGHWAY PLANNING AND CONSTRUCTION $2.65M
15.916 OUTDOOR RECREATION ACQUISITION, DEVELOPMENT AND PLANNING $1.16M
16.922 EQUITABLE SHARING PROGRAM $586,338
97.067 HOMELAND SECURITY GRANT PROGRAM $285,526
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $88,596
14.228 COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII $46,191
16.575 CRIME VICTIM ASSISTANCE $38,964
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $36,998
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $7,691
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $3,542