Finding 24392 (2022-001)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-05-17
Audit: 19937
Organization: City of Sierra Vista, Arizona (AZ)

AI Summary

  • Core Issue: The City failed to maintain adequate documentation for $929,000 reported in the Interim Report and used incorrect expenditure category (EC) codes in the Project and Expenditure Report.
  • Impacted Requirements: Noncompliance with federal reporting requirements under 2 CFR §200.303, including the need for accurate documentation and correct EC codes.
  • Recommended Follow-Up: The City should improve its reporting processes and ensure proper documentation is maintained to align with federal guidelines.

Finding Text

Finding Number: 2022-001 Repeat Finding: No Program Name/Assistance Listing Title: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Agency: U.S. Department of Treasury Federal Award Number: N/A Pass-Through Agency: N/A Questioned Costs: N/A Type of Finding: Noncompliance, Significant Deficiency Compliance Requirement: Reporting CRITERIA Under 2 CFR ?200.303, the City is required to establish and maintain effective internal controls over Federal awards that provide reasonable assurance that the City is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. As noted in the Interim Final Rule and the Final Rule, Coronavirus State & Local Fiscal Recovery Funds (CSLFRF) recipients with allocations less than $10.0 million and populations less than 250,000, were required to prepare and submit a one-time Interim Report through July 31, 2021, and Project and Expenditure Reports annually through March 31 of each respective year. Both the Interim Report and the Project and Expenditure Reports contain key line items that contain critical information, and the reported amounts must agree to the City?s accounting records. Additionally, the Project and Expenditure Reports also include Expenditure Category (EC) references defined by the U.S. Department of Treasury, which recipients should utilize to report the nature of the activities for which the CSLFRF monies were expended. CONDITION The City did not maintain adequate supporting documentation for the expenditure amount reported on the Interim Report. Additionally, the City?s Project and Expenditure Report for March 2022 did not include the correct EC codes based on the actual manner in which CSLFRF monies were expended. CAUSE Documentation was not maintained that agreed to the amounts on the Interim Report. Additionally, City personnel were unfamiliar with the U.S. Department of Treasury guidance regarding EC codes and their relationship to the City?s manner of use for CSLFRF funding. EFFECT The City was not in compliance with federal regulations and guidelines for reporting. CONTEXT The City did not maintain documentation to support the $929,000 of costs reported on the Interim Report; however, the amount appeared reasonable based on subsequent expenditure reports prepared by City personnel for the period of reporting. Additionally, while the City utilized the entire CSLFRF funding in a manner consistent with replacing lost public sector revenue to provide for government services (i.e. to help fund firefighter salaries and benefits), the City?s Project and Expenditure Report for March 2022 did not include the correct EC code based on this actual manner of use. The Project and Expenditure Report indicated that funds were used for `EC 1.14 Other Public Health Services?, rather than `EC 6.1 Revenue Replacement?. The sample was not intended to be, and was not, a statistically valid sample. RECOMMENDATION The City should ensure that accurate federal reports are prepared and that proper supporting documentation is maintained for all amounts indicated on such reports. VIEWS OF RESPONSIBLE OFFICIALS See Corrective Action Plan.

Corrective Action Plan

Program Name/Assistance Listing Title: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Contact Person: David Felix, Chief Financial Officer Anticipated Completion Date: May 18, 2023 Planned Corrective Action: When the City received notification of the award of CSLFRF funds, the CFO and City Attorney reviewed the law and, based on how it was written, felt that we could apply it to the Fire Department?s salary expenses as over 80% of their calls are for emergency medical services, they are the first responders to a 911 EMS call, and they usually transport the patients to the hospital. Neither in the initial law documentation, nor in the initial application, was there an option to select a $10M de minimus revenue loss option. If this was available, the City would have chosen that up front. We completed the interim report based on data created by inquiries run in our General Ledger on the date we submitted the report. We believed the data was saved on our system, but we can not find the electronic copy of it. As adjustments have been made to the data since then, we are unable to recreate a report that matches the data on the interim report. We can get within $800, but not the exact amount. Going forward, we will ensure the data is saved and put in a place that it is easier to retrieve.

Categories

Allowable Costs / Cost Principles Reporting Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 600834 2022-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
12.600 Community Investment $1.34M
20.507 Covid-19 Federal Transit_formula Grants $736,868
20.106 Airport Improvement Program $650,258
14.218 Community Development Block Grants/entitlement Grants $468,043
20.507 Federal Transit_formula Grants $344,034
12.610 Community Economic Adjustment Assistance for Compatible Use and Joint Land Use Studies $330,498
20.205 Highway Planning and Construction $216,712
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $191,994
97.067 Homeland Security Grant Program $66,891
14.218 Covid-19 Community Development Block Grants/entitlement Grants $59,838
20.106 Covid-19 Airport Improvement Program $32,000
20.600 State and Community Highway Safety $24,516
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $8,750
16.607 Bulletproof Vest Partnership Program $6,000
45.310 Covid-19 Grants to States $4,000