Audit 332988

FY End
2024-06-30
Total Expended
$3.72M
Findings
2
Programs
9
Organization: Town of Oro Valley, Arizona (AZ)
Year: 2024 Accepted: 2024-12-17

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
514620 2024-001 Significant Deficiency - F
1091062 2024-001 Significant Deficiency - F

Contacts

Name Title Type
M1KGM1EJMNJ4 David Gephart Auditee
5202294768 Brian Hemmerle Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the accrual or modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available. The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. De Minimis Rate Used: N Rate Explanation: The Town of Oro Valley has not elected to use the 10% de minimis indirect cost rate. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of the Town under programs of the federal government for the year ended June 30, 2024. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Town of Oro Valley, Arizona, it is not intended to and does not present the financial position, changes in net position or cash flows of the Town of Oro Valley, Arizona.

Finding Details

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.
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.