Finding 1224818 (2025-016)

Material Weakness Repeat Finding
Requirement
F
Questioned Costs
-
Year
2025
Accepted
2026-07-28
Audit: 408033
Organization: City of Mission (TX)

AI Summary

  • Core Issue: The City has significant deficiencies in maintaining accurate inventory records for assets funded by the Equitable Sharing Program.
  • Impacted Requirements: The City failed to comply with the Equitable Sharing Guide, which mandates complete item-level tracking of all assets, not just high-value items.
  • Recommended Follow-Up: Implement a detailed inventory system with item descriptions and conduct regular management reviews to ensure accuracy and completeness of records.

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. Questioned Costs: $0 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): 2024-019 Views of Responsible Officials: See management's corrective action plan.

Corrective Action Plan

Corrective Action: The City will implement standardized inventory management procedures for federally funded assets; maintain detailed item-by-item inventory records; conduct periodic management reviews of inventory listings; and ensure all required equipment is properly tracked and reported. Responsible Individual(s): Michael Elizalde, Grants & Strategic Initiatives Director; Vidal Roman, Finance Director. Timeline: In Progress. Estimated September 2026.

Categories

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

Other Findings in this Audit

  • 1224806 2025-017
    Material Weakness Repeat
  • 1224807 2025-018
    Material Weakness Repeat
  • 1224808 2025-019
    Material Weakness Repeat
  • 1224809 2025-020
    Material Weakness Repeat
  • 1224810 2025-021
    Material Weakness Repeat
  • 1224811 2025-017
    Material Weakness Repeat
  • 1224812 2025-018
    Material Weakness Repeat
  • 1224813 2025-019
    Material Weakness Repeat
  • 1224814 2025-020
    Material Weakness Repeat
  • 1224815 2025-021
    Material Weakness Repeat
  • 1224816 2025-013
    Material Weakness Repeat
  • 1224817 2025-015
    Material Weakness Repeat
  • 1224819 2025-013
    Material Weakness Repeat
  • 1224820 2025-013
    Material Weakness Repeat
  • 1224821 2025-013
    Material Weakness Repeat
  • 1224822 2025-013
    Material Weakness Repeat
  • 1224823 2025-014
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
20.205 HIGHWAY PLANNING AND CONSTRUCTION $399,522
15.916 OUTDOOR RECREATION ACQUISITION, DEVELOPMENT AND PLANNING $282,591
16.922 EQUITABLE SHARING PROGRAM $231,969
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $137,787
81.128 ENERGY EFFICIENCY AND CONSERVATION BLOCK GRANT PROGRAM (EECBG) $137,278
16.745 CRIMINAL AND JUVENILE JUSTICE AND MENTAL HEALTH COLLABORATION PROGRAM $110,207
97.067 HOMELAND SECURITY GRANT PROGRAM $104,934
97.029 FLOOD MITIGATION ASSISTANCE $68,013
16.609 PROJECT SAFE NEIGHBORHOODS $49,640
16.710 PUBLIC SAFETY PARTNERSHIP AND COMMUNITY POLICING GRANTS $48,611
14.228 COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII $37,792
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $34,407
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $12,134
16.575 CRIME VICTIM ASSISTANCE $11,036
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $3,966
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $2,251