Finding 596765 (2022-003)

-
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-05-25
Audit: 28073
Organization: City of Birmingham (AL)

AI Summary

  • Core Issue: The City lacked effective internal controls for accurate financial reporting on Emergency Rental Assistance (ERA) awards, leading to incomplete and inaccurate submissions.
  • Impacted Requirements: Recipients must submit separate quarterly Federal Financial Reports (SF-425) for each ERA award, which the City failed to do correctly.
  • Recommended Follow-Up: Implement training and controls to ensure accurate preparation and approval of financial reports before submission.

Finding Text

2022-003: Compliance and Significant Deficiency in Internal Control over Compliance with Reporting (Financial Reporting) Federal agency: Department of Treasury Pass-through agency: None Title: Emergency Rental Assistance, including Covid-19 CFDA Number: 21.023 Award Year: 2022 Award Number: ERA-2101123809 & ERA2-0213 Criteria: As indicated in the April 2022, OMB Compliance Supplement, recipients of Emergency Rental Assistance (ERA) awards are required to submit the Federal Financial Report, SF-425, each quarter. Recipients of ERA1 (awarded pursuant to section 501 of the Consolidated Appropriations Act, 2021) and ERA2 (awarded pursuant to section 3201 of the Consolidated appropriations act) funds must submit separate quarterly reports for each ERA award. The requirement to upload the SF-425 form ended with the quarter ended March 31, 2022, and recipients were directed to submit financial reporting data directly into the ERA portal. Condition and perspective: We selected for testing the quarterly reports submitted for the periods ended September 30, 2021 and December 31, 2021. During our testing, it was noted that the City did not have effective internal controls in place to ensure accurate and complete reporting. Applicable backup documentation provided by management did not support the amounts included in each of the submitted reports included in our testing. Cause: The City did not ensure that the individuals preparing and approving financial reports for the ERA program were knowledgeable of how to accurately complete the required financial form. Effect: The City did not have effective internal controls in place to ensure that financial reports were accurate, complete, and sufficiently reviewed prior to submission. This lack of ineffective controls resulted in incomplete and inaccurate reporting. Questioned Cost: No questioned costs identified. Recommendation: We recommend the City design and implement controls that allow for the accurate preparation and adequate approval of financial reporting information prior to its submission. -12- CITY OF BIRMINGHAM, ALABAMA SCHEDULE OF FINDINGS AND QUESTIONED COSTS (CONTINUED) YEAR ENDED JUNE 30, 2022 Management?s response: Management in the Finance and Community Development Departments will work together to ensure that appropriate training is provided to all individuals responsible for the preparation and approval of financial reporting information.

Categories

Reporting

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $27.91M
21.023 Emergency Rental Assistance Program $9.75M
14.231 Emergency Solutions Grant Program $2.35M
14.218 Community Development Block Grants/entitlement Grants $1.56M
20.933 National Infrastructure Investments $1.42M
20.205 Highway Planning and Construction $543,239
14.239 Home Investment Partnerships Program $312,599
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $172,659
14.241 Housing Opportunities for Persons with Aids $154,229
59.075 Shuttered Venue Operators Grant Program $143,135
97.044 Assistance to Firefighters Grant $71,771
16.922 Equitable Sharing Program $63,913
94.013 Volunteers in Service to America $39,540
14.900 Lead-Based Paint Hazard Control in Privately-Owned Housing $31,443
16.034 Coronavirus Emergency Supplemental Funding Program $26,921
16.588 Violence Against Women Formula Grants $14,667
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $3,363
95.001 High Intensity Drug Trafficking Areas Program $3,081
16.738 Edward Byrne Memorial Justice Assistance Grant Program $877