Finding 11231 (2023-002)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-02-01
Audit: 15023
Organization: Salt Lake City Corporation (UT)
Auditor: Eide Bailly LLP

AI Summary

  • Core Issue: The City failed to include all expenditures in the quarterly Project and Expenditure Reports.
  • Impacted Requirements: Reports submitted to the Department of Treasury must accurately reflect all expenditures for the reporting period.
  • Recommended Follow-Up: Enhance internal controls to ensure complete and accurate reporting of all program expenditures.

Finding Text

Department of Treasury Federal Financial Assistance Listing 21.027 Award number SLT-4512 COVID-19 Coronavirus State and Local Fiscal Recovery Fund Reporting Significant Deficiency in Internal Control and Immaterial Instance of Noncompliance Criteria: The quarterly Project and Expenditure Report should include all expenditures made in the reporting period. Condition: The original project and expenditure reports provided to the auditors did not include all expenditures made during the reporting periods selected for testing. Cause: The City’s internal controls related to preparation of the reports did not identify all expenditures made in the reporting periods selected for testing. Effect: The original reports submitted to the Department of Treasury were not complete. Questioned Costs: None reported Context/Sampling: We examined all four quarterly Project and Expenditure Reports for the audit period. We noted errors in one report. Repeat Finding from Prior Year(s): No Recommendation: We recommend that the City enhance internal controls to ensure all program expenditures are appropriately reported. Views of Responsible Officials: Management agrees with the finding.

Corrective Action Plan

Finding 2023-002 Federal Agency Name: Department of the Treasury Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery Fund CFDA #21.027 Finding Summary: The original project and expenditure reports provided to the auditors did not include all expenditures made during the reporting periods they selected for testing. Responsible Individuals: Aaron Price Corrective Action Plan: This is the result of an end of year timing issue wherein the reporting deadline to the Federal Government occurred prior to year-end close, resulting in a reconciling item being accurately reported within the City’s fiscal year despite being reported to the Federal Government in a subsequent quarter, but still accurately within the Federal Government’s fiscal year. Moving forward, greater efforts will be used to reconcile year end grant transactions prior to federal reporting, however, this is considered to be a non-recurring issue given the nature of the grant. Anticipated Completion Date: December 2023

Categories

Reporting Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 587673 2023-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
20.106 Airport Improvement Program $62.99M
21.027 Coronavirus State and Local Fiscal Recovery Funds $18.61M
66.958 Water Infrastructure Finance and Innovation (wifia) (e) $13.11M
21.023 Emergency Rental Assistance Program $3.23M
14.218 Community Development Block Grants/entitlement Grants $1.05M
14.231 Emergency Solutions Grant Program $925,203
14.241 Housing Opportunities for Persons with Aids $905,903
14.239 Home Investment Partnerships Program $779,436
95.001 High Intensity Drug Trafficking Areas Program $584,204
97.047 Pre-Disaster Mitigation $566,365
16.922 Equitable Sharing Program $375,508
97.090 Law Enforcement Personnel Reinmursement Agreement $328,880
16.738 Edward Byrne Memorial Justice Assistance Grant Program $254,484
97.072 National Explosives Detection Canine Team Program $252,500
93.575 Child Care and Development Block Grant $231,643
93.558 Temporary Assistance for Needy Families $201,787
16.575 Crime Victim Assistance $145,030
97.044 Assistance to Firefighters Grant $100,914
93.566 Refugee and Entrant Assistance_state Administered Programs $51,670
97.042 Emergency Management Performance Grants $38,000
16.710 Public Safety Partnership and Community Policing Grants $35,023
10.558 Child and Adult Care Food Program $24,410
93.889 National Bioterrorism Hospital Preparedness Program $18,302
16.034 Coronavirus Emergency Supplemental Funding Program $17,939
45.310 Grants to States $11,917
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $9,280
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $8,209
20.600 State and Community Highway Safety $8,159
16.582 Crime Victim Assistance/discretionary Grants $3,676
45.313 Laura Bush 21st Century Librarian Program $2,452