Finding 498294 (2023-006)

Significant Deficiency
Requirement
M
Questioned Costs
-
Year
2023
Accepted
2024-09-25

AI Summary

  • Core Issue: The City lacks adequate internal controls for monitoring subrecipients of federal funds, specifically regarding compliance with single audit requirements.
  • Impacted Requirements: Federal regulations mandate that the City evaluate subrecipients' risk of noncompliance and ensure they receive necessary audits and address any findings.
  • Recommended Follow-Up: The City should implement controls to verify subrecipients' audit status and establish procedures for addressing any deficiencies identified in audits.

Finding Text

2023-006 The City had inadequate internal controls for ensuring compliance with federal requirements for subrecipient monitoring. Assistance Listing Number and Title: 21.023 - COVID 19 Emergency Rental Assistance Program Federal Grantor Name: U.S. Department of the Treasury Federal Award/Contract Number: COVID-19 1505-0270 Pass-through Entity Name: N/A Pass-through Award/Contract Number: N/A Known Questioned Cost Amount: $0 Prior Year Audit Finding: N/A Description of Condition During fiscal year 2023, the City spent $5,187,384 in federal funding for the Emergency Rental Assistance (ERA) program, which included $2,907,074 that it passed through to nine subrecipients. The purpose of the ERA is to provide direct payments to eligible entities to assist eligible households with financial assistance and to provide housing stability services and, in the case of ERA 2 as applicable, to fund other affordable rental housing and eviction prevention activities. Federal regulations require recipients to establish and maintain internal controls that ensure compliance with program requirements. These controls include understanding grant requirements and monitoring the effectiveness of established controls. Federal regulations require the City to evaluate every subrecipient’s risk of noncompliance with federal requirements to determine the appropriate level of subrecipient monitoring. Subrecipient monitoring requirements include ensuring compliance with program requirements, ensuring the subrecipient receives a federal single audit when required, following up and ensuring the subrecipient promptly and appropriately addresses all audit findings, and issuing a management decision as required. The City did not have adequate controls for monitoring its subrecipients. Specifically, adequate controls for ensuring a subrecipient received a federal single audit when required and then reviewing subrecipients’ audits when applicable. We consider this internal control deficiency to be a significant deficiency. Cause of Condition Employees responsible for ensuring compliance with subrecipient monitoring were unaware of the annual requirement to verify that subrecipients receive a single audit if they have total federal expenditures more than the single audit threshold of $750,000. Effect of Condition The City could not provide supporting documentation showing that it performed the following monitoring procedures to prevent or detect subrecipient noncompliance for all nine subrecipients: • Verifying if subrecipients received a federal single audit, if required • Ensuring subrecipients took corrective actions on any deficiencies • Issuing management decisions within six months of audit reports’ publication Recommendation We recommend the City establishes internal controls over subrecipient monitoring to ensure it verifies that subrecipients receives a federal single audit and develops follow-up procedures if detects deficiencies. City’s Response City staff will contact all Community Based Organizations (CBOs) that received Emergency Rental Assistance 2 funding to determine if they were required to complete a Single Audit per the Single Audit Act. This communication will include, if applicable, a request that they submit the organizations most recent audit for review by staff. Should a Single Audit identify any findings or other deficiencies, staff will ask the CBO to provide an update as to the status of the deficiency and if it has been appropriately addressed. Staff will document this communication in the electronic file of the CBO who was required to complete a Single Audit. Auditor’s Remarks We thank the City for its response and consideration in this matter and the steps it is taking to address this issue. We will review the status of the City’s corrective action during our next audit. Applicable Laws and Regulations Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), section 516, Audit findings, establishes reporting requirements for audit findings. Title 2 CFR Part 200, Uniform Guidance, section 303, Internal controls, describes the requirements for auditees to maintain internal controls over federal programs and comply with federal program requirements. The American Institute of Certified Public Accountants defines significant deficiencies and material weaknesses in its Codification of Statements on Auditing Standards, section 935, Compliance Audits, paragraph 11. Title 2 CFR Part 200, Uniform Guidance, section 332, Requirements for passthrough entities, establishes subrecipient monitoring and management requirements for pass-through entities.

Corrective Action Plan

City staff will contact all Community Based Organizations (CBOs) that received Emergency Rental Assistance 2 funding to determine if they were required to complete a Single Audit per the Single Audit Act. This communication will include, if applicable, a request that they submit the organizations most recent audit for review by staff. Should a Single Audit identify any findings or other deficiencies, staff will ask the CBO to provide an update as to the status of the deficiency and if it has been appropriately addressed. Staff will document this communication in the electronic file of the CBO who was required to complete a Single Audit.

Categories

Subrecipient Monitoring Internal Control / Segregation of Duties Allowable Costs / Cost Principles Material Weakness Reporting Significant Deficiency

Other Findings in this Audit

  • 498263 2023-001
    Material Weakness
  • 498264 2023-001
    Material Weakness
  • 498265 2023-001
    Material Weakness
  • 498266 2023-001
    Material Weakness
  • 498267 2023-002
    Material Weakness
  • 498268 2023-002
    Material Weakness
  • 498269 2023-002
    Material Weakness
  • 498270 2023-002
    Material Weakness
  • 498271 2023-003
    Significant Deficiency
  • 498272 2023-003
    Significant Deficiency
  • 498273 2023-003
    Significant Deficiency
  • 498274 2023-003
    Significant Deficiency
  • 498275 2023-003
    Significant Deficiency
  • 498276 2023-004
    - Repeat
  • 498277 2023-004
    - Repeat
  • 498278 2023-004
    - Repeat
  • 498279 2023-004
    - Repeat
  • 498280 2023-004
    - Repeat
  • 498281 2023-004
    - Repeat
  • 498282 2023-004
    - Repeat
  • 498283 2023-004
    - Repeat
  • 498284 2023-004
    - Repeat
  • 498285 2023-005
    Material Weakness Repeat
  • 498286 2023-005
    Material Weakness Repeat
  • 498287 2023-005
    Material Weakness Repeat
  • 498288 2023-005
    Material Weakness Repeat
  • 498289 2023-005
    Material Weakness Repeat
  • 498290 2023-005
    Material Weakness Repeat
  • 498291 2023-005
    Material Weakness Repeat
  • 498292 2023-005
    Material Weakness Repeat
  • 498293 2023-005
    Material Weakness Repeat
  • 1074705 2023-001
    Material Weakness
  • 1074706 2023-001
    Material Weakness
  • 1074707 2023-001
    Material Weakness
  • 1074708 2023-001
    Material Weakness
  • 1074709 2023-002
    Material Weakness
  • 1074710 2023-002
    Material Weakness
  • 1074711 2023-002
    Material Weakness
  • 1074712 2023-002
    Material Weakness
  • 1074713 2023-003
    Significant Deficiency
  • 1074714 2023-003
    Significant Deficiency
  • 1074715 2023-003
    Significant Deficiency
  • 1074716 2023-003
    Significant Deficiency
  • 1074717 2023-003
    Significant Deficiency
  • 1074718 2023-004
    - Repeat
  • 1074719 2023-004
    - Repeat
  • 1074720 2023-004
    - Repeat
  • 1074721 2023-004
    - Repeat
  • 1074722 2023-004
    - Repeat
  • 1074723 2023-004
    - Repeat
  • 1074724 2023-004
    - Repeat
  • 1074725 2023-004
    - Repeat
  • 1074726 2023-004
    - Repeat
  • 1074727 2023-005
    Material Weakness Repeat
  • 1074728 2023-005
    Material Weakness Repeat
  • 1074729 2023-005
    Material Weakness Repeat
  • 1074730 2023-005
    Material Weakness Repeat
  • 1074731 2023-005
    Material Weakness Repeat
  • 1074732 2023-005
    Material Weakness Repeat
  • 1074733 2023-005
    Material Weakness Repeat
  • 1074734 2023-005
    Material Weakness Repeat
  • 1074735 2023-005
    Material Weakness Repeat
  • 1074736 2023-006
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $36.45M
66.958 Water Infrastructure Finance and Innovation (wifia) (e) $34.24M
93.778 Medical Assistance Program $10.54M
66.458 Capitalization Grants for Clean Water State Revolving Funds $9.00M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $8.69M
21.023 Emergency Rental Assistance Program $5.19M
21.016 Equitable Sharing $3.94M
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $2.48M
93.045 Special Programs for the Aging, Title Iii, Part C, Nutrition Services $2.42M
97.091 Homeland Security Biowatch Program $1.66M
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $1.39M
14.239 Home Investment Partnerships Program $1.31M
16.922 Equitable Sharing Program $1.14M
93.052 National Family Caregiver Support, Title Iii, Part E $738,424
97.108 Homeland Security, Research, Testing, Evaluation, and Demonstration of Technologies $721,140
97.047 Bric: Building Resilient Infrastructure and Communities $716,410
10.558 Child and Adult Care Food Program $666,904
14.241 Housing Opportunities for Persons with Aids $637,090
14.881 Moving to Work Demonstration Program $630,550
16.543 Missing Children's Assistance $592,392
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $510,428
93.564 Child Support Enforcement Research $485,553
93.053 Nutrition Services Incentive Program $480,821
97.042 Emergency Management Performance Grants $451,101
20.500 Federal Transit_capital Investment Grants $447,835
16.738 Edward Byrne Memorial Justice Assistance Grant Program $415,453
45.024 Promotion of the Arts_grants to Organizations and Individuals $410,500
97.044 Assistance to Firefighters Grant $409,141
20.525 State of Good Repair Grants Program $367,832
10.559 Summer Food Service Program for Children $247,016
14.218 Community Development Block Grants/entitlement Grants $226,417
16.320 Services for Trafficking Victims $208,391
93.569 Community Services Block Grant $180,466
84.047 Trio_upward Bound $166,434
93.568 Low-Income Home Energy Assistance $149,721
15.916 Outdoor Recreation_acquisition, Development and Planning $132,765
16.835 Body Worn Camera Policy and Implementation $128,368
16.582 Crime Victim Assistance/discretionary Grants $127,953
97.111 Regional Catastrophic Preparedness Grant Program (rcpgp) $126,276
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $123,832
93.969 Pphf Geriatric Education Centers $118,077
97.067 Homeland Security Grant Program $85,998
20.941 Strengthening Mobility and Revolutionizing Transportation (smart) Grants Program $80,794
16.710 Public Safety Partnership and Community Policing Grants $78,414
16.575 Crime Victim Assistance $70,143
20.616 National Priority Safety Programs $50,203
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $45,852
93.493 Congressional Directives $40,521
14.231 Emergency Solutions Grant Program $38,052
16.838 Comprehensive Opioid Abuse Site-Based Program $29,516
20.600 State and Community Highway Safety $27,030
81.042 Weatherization Assistance for Low-Income Persons $26,498
14.251 Economic Development Initiative, Community Project Funding, and Miscellaneous Grants $24,000
11.438 Pacific Coast Salmon Recovery_pacific Salmon Treaty Program $22,518
20.205 Highway Planning and Construction $21,301
97.039 Hazard Mitigation Grant $21,062
93.041 Special Programs for the Aging_title Vii, Chapter 3_programs for Prevention of Elder Abuse, Neglect, and Exploitation $16,994
10.576 Senior Farmers Market Nutrition Program $7,025
16.034 Coronavirus Emergency Supplemental Funding Program $5,232
45.310 Grants to States $4,451
20.507 Federal Transit_formula Grants $3,634
97.056 Port Security Grant Program $1,777
32.011 Affordability Connectivity Outreach Grant Program $1,707