Finding 371923 (2023-008)

Significant Deficiency Repeat Finding
Requirement
M
Questioned Costs
-
Year
2023
Accepted
2024-03-01
Audit: 293176
Organization: City of Albuquerque (NM)

AI Summary

  • Core Issue: The City failed to follow federal and internal subrecipient monitoring regulations, leading to significant deficiencies in compliance.
  • Impacted Requirements: Internal controls under 2 CFR Part 200 were not effectively established, particularly in risk assessment and monitoring of subrecipients.
  • Recommended Follow-up: Implement training for department staff on subrecipient requirements and ensure adherence to updated management policies by June 2024.

Finding Text

Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds (SLFRF) Emergency Rental Assistance Program Assistance Listing Number: 21.027 and 21.023 Federal Award Identification Numberand Year: ALN 21.027 -Pub. L. No. 117-2 2021 ALN 21.023 -ERA0335 2021 Award Period: ALN 21.027 - 5/10/2021 - 12/31/2026 ALN 21.023 - 1/20/2021 - 9/30/2022 Type of Finding: • Significant Deficiency in Internal Control over Compliance • Other Matters Criteria or specific requirement: According to§ 200.303 Internal controls of 2 CFR Part 200, the non-federal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. According to § 200.331 Subrecipient and contractor determinations of 2 CFR Part 200, a pass-through entity must make case-by­ case determinations whether each agreement it makes for the disbursement of federal program funds casts the party receiving the funds in the role of a subrecipient or a contractor. According to § 200.332 Requirements for pass-through entities of 2 CFR Part 200, all pass-through entities must: • Evaluate each subrecipient's risk of noncompliance with federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. • Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. • Verify that every subrecipient is audited as required by Subpart F ohhis part when it is expected that the subrecipient's federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in§ 200.501. • Consider whether the results of the subrecipient's audits, on-site reviews, or other monitoring indicate conditions that necessitate adjustments to the pass-through entity's own records. According to the City's subrecipient monitoring policies and procedures, monitoring of subrecipients shall be conducted as often as may be required at the discretion of the Community Development Division or at least once per program year. An annual Risk Assessment will be completed to determine a ranking for the activity. The Risk Assessment ranking score will determine whether a monitoring review will occur. According to the City's Sub-recipient Agreement, the Sub-recipient will provide to the Department of Family and Community Services cumulative quarterly program performance reports covering the Services provided under this Agreement. Reports are due no later than fifteen (15) days after the end of the reporting quarter, and shall be in accordance with City of Albuquerque reporting instructions. Condition: During our testing, it was noted that the City did not follow federal subrecipient monitoring and management regulation nor its subrecipient monitoring policies and procedures. Management's Progress for Repeat Findings: This is a repeated and modified.finding. While the City has improved its efforts, there are still opportunities for improvement to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements as well as compliance with City policy. Questioned costs: None Context: During our testing, we noted the following exceptions related to subrecipient monitoring. ALN 21.027 • For one of the five subrecipients, the City did not utilize the risk assessment tool specific to ARPA which does have a different risk assessment ranking score determining the monitoring of the subrecipient. The City did, however, perform a monitoring visit for the subrecipient. • For one of the five subrecipients, the City was unable to locate the subrecipient/contract determination worksheet. • For one of the five subrecipients, the City was unable to locate the quarterly program performance reports submitted by the subrecipient. ALN 21.023 • For one of the five subrecipients, the most recent annual audit report for the year ended June 30, 2022 was not reviewed by the City nor included in the risk assessment. Cause: The City does not have sufficient internal controls to ensure appropriate risk assessment and subrecipient monitoring. Effect: The auditor noted instances of noncompliance. Recommendation: The City has developed standard City-wide subrecipient management and monitoring policies and procedures effective June 2023. We recommend the City design controls to ensure departments are abiding by the subrecipient management and monitoring policies and procedures including Individual departments that develop their own department­ specific and/or grant-specific subrecipient management policies and procedures. Management Response: The City agrees with the finding. The City's Grant Administrator will provide training to each City department which currently oversees subrecipients, ensuring that all department staff understand general and ARPA-specific subrecipient requirements. Additionally, the Grant Administrator will review City departments' subrecipient management checklists to ensure all required documentation is obtained from subrecipients and reviewed as required. This will be complete by June 30, 2024. Timeline and Responsible Position: June 2024 - Grants Administrator

Categories

Subrecipient Monitoring

Other Findings in this Audit

  • 371917 2023-004
    Material Weakness
  • 371918 2023-005
    Material Weakness Repeat
  • 371919 2023-005
    Material Weakness Repeat
  • 371920 2023-006
    Significant Deficiency Repeat
  • 371921 2023-007
    Significant Deficiency Repeat
  • 371922 2023-008
    Significant Deficiency Repeat
  • 371924 2023-009
    Significant Deficiency Repeat
  • 948359 2023-004
    Material Weakness
  • 948360 2023-005
    Material Weakness Repeat
  • 948361 2023-005
    Material Weakness Repeat
  • 948362 2023-006
    Significant Deficiency Repeat
  • 948363 2023-007
    Significant Deficiency Repeat
  • 948364 2023-008
    Significant Deficiency Repeat
  • 948365 2023-008
    Significant Deficiency Repeat
  • 948366 2023-009
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $33.80M
20.106 Airport Improvement Program $27.30M
21.023 Emergency Rental Assistance Program $9.13M
14.218 Community Development Block Grants/entitlement Grants $8.17M
20.205 Highway Planning and Construction $7.08M
14.239 Home Investment Partnerships Program $5.50M
20.507 Federal Transit_formula Grants $3.47M
14.267 Continuum of Care Program $2.80M
93.600 Head Start $2.32M
16.710 Public Safety Partnership and Community Policing Grants $2.25M
20.500 Federal Transit_capital Investment Grants $2.23M
93.137 Community Programs to Improve Minority Health Grant Program $2.13M
93.575 Child Care and Development Block Grant $1.68M
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $1.59M
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $1.23M
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $1.17M
16.034 Coronavirus Emergency Supplemental Funding Program $994,013
10.559 Summer Food Service Program for Children $808,112
10.558 Child and Adult Care Food Program $773,503
11.805 Mbda Business Center $693,794
66.001 Air Pollution Control Program Support $628,271
95.001 High Intensity Drug Trafficking Areas Program $611,914
16.741 Dna Backlog Reduction Program $537,637
14.231 Emergency Solutions Grant Program $380,036
93.052 National Family Caregiver Support, Title Iii, Part E $286,455
16.838 Comprehensive Opioid Abuse Site-Based Program $245,373
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $203,284
97.072 National Explosives Detection Canine Team Program $202,000
93.053 Nutrition Services Incentive Program $180,647
45.310 Grants to States $169,365
97.U02 Tsa Law Enforcement Officer Reimbursement Program $153,300
94.011 Foster Grandparent Program $153,040
97.024 Emergency Food and Shelter National Board Program $142,012
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $128,794
16.738 Edward Byrne Memorial Justice Assistance Grant Program $128,500
97.042 Emergency Management Performance Grants $122,719
93.997 Assisted Outpatient Treatment $116,743
97.067 Homeland Security Grant Program $112,637
16.588 Violence Against Women Formula Grants $87,609
21.000 National Priority Safety Programs $83,124
20.215 Highway Training and Education $81,450
16.001 Law Enforcement Assistance_narcotics and Dangerous Drugs_laboratory Analysis $80,193
16.575 Crime Victim Assistance $77,617
20.600 State and Community Highway Safety $69,744
94.016 Senior Companion Program $68,047
97.083 Staffing for Adequate Fire and Emergency Response (safer) $53,034
94.002 Retired and Senior Volunteer Program $51,723
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $37,189
16.607 Bulletproof Vest Partnership Program $32,587
15.904 Historic Preservation Fund Grants-in-Aid $29,935
16.833 National Sexual Assault Kit Initiative $26,566
93.213 Research and Training in Complementary and Integrative Health $19,259
94.013 Volunteers in Service to America $15,000
97.141 National Explosives Detection Canine Team Program $13,427
97.039 Hazard Mitigation Grant $10,223
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $3,952
66.034 Surveys, Studies, Research, Investigations, Demonstrations, and Special Purpose Activities Relating to the Clean Air Act $2,764
16.301 Law Enforcement Assistance_fbi Crime Laboratory Support $2,017