Finding 514620 (2024-001)

Significant Deficiency
Requirement
F
Questioned Costs
-
Year
2024
Accepted
2024-12-17
Audit: 332988
Organization: Town of Oro Valley, Arizona (AZ)

AI Summary

  • Core Issue: The Town failed to properly track and segregate capital assets purchased with federal funds, leading to inadequate records.
  • Impacted Requirements: This violates 2 CFR § 200.313, which mandates detailed record-keeping and regular physical inventories for federally funded assets.
  • Recommended Follow-Up: Update the capital asset tracking system to include federally purchased assets and schedule inventory counts every two years.

Finding Text

Criteria: Per 2 CFR § 200.313 (Uniform Guidance) for managing federally funded property, recipients must: maintain records of capital assets purchased with federal funds including detailed descriptions, serial numbers, acquisition dates, and funding sources. The recipients must also perform physical inventories at least every two years to ensure assets are accounted for, and establish internal controls to safeguard assets from loss, damage, or unauthorized use. Condition: During the audit, we noted that the Town did not segregate capital assets acquired utilizing federal funds in its capital asset software, including records of asset locations and condition. Since federally funded capital assets were not separately tracked in the capital asset system, we were unable to determine which disposals during the current year, if any were federally purchased assets. Lastly, the Town did not maintain records of any federally purchased asset inventory counts completed during the last two years. Cause: The Town lacked sufficient internal controls and formalized procedures to track federally funded assets. Effect or Potential Effect: Inadequate records increase the risk of asset misappropriation, misuse or loss. Failure to account for disposals could lead to questioned costs during federal audits. Sale of federally purchased assets could result in a gain and the requirement for the Town to perform program income procedures with the pass-through entity or the related federal agency. Recommendation: We recommend the Town update their capital asset tracking schedule to include information on which assets are purchased using federal funds. Furthermore, we suggest the Town begin to keep records of any inventory count taken and begin scheduling inventory counts to be completed at least once every two years. Management's Response: Management concurs with the finding and has already begun taking steps to address the issue. They plan on updating their capital asset tracking module to include documentation of federally purchased assets. Additionally, the Town is in the process of scheduling inventory counts to be completed at least once every two years, and to maintain documentation of any inventory count completed.

Corrective Action Plan

Town management concurs with the finding, and while audit staff were still onsite for field work, Town staff implemented and added tracking and documentation information for all federally funded capital assets, to include unique descriptors, Catalog of Federal Domestic Assistance grant number, funding source and amount. In addition, inventory counts for federally funded assets will be conducted and recorded at least once every two years.

Categories

Equipment & Real Property Management Procurement, Suspension & Debarment Subrecipient Monitoring Program Income

Other Findings in this Audit

  • 1091062 2024-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.57M
15.916 Outdoor Recreation Acquisition, Development and Planning $1.00M
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $537,235
20.507 Federal Transit Formula Grants $318,996
95.001 High Intensity Drug Trafficking Areas Program $97,611
97.067 Homeland Security Grant Program $88,385
20.616 National Priority Safety Programs $82,609
16.607 Bulletproof Vest Partnership Program $22,313
97.U01 United States Secret Service $5,500