Finding 520237 (2024-013)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-01-27
Audit: 339863
Organization: City of Albuquerque (NM)

AI Summary

  • Core Issue: The City lacks adequate internal controls for accurate and timely reporting of subawards under the FFATA, leading to significant deficiencies in compliance.
  • Impacted Requirements: Noncompliance with 2 CFR Part 200 and the Transparency Act, including inaccuracies in subaward descriptions and late submissions.
  • Recommended Follow-Up: Establish a reporting calendar, conduct periodic reviews for accuracy, and implement a formal review process for subawards of $30,000 or more.

Finding Text

2024- 013 Reporting- Special FFATA Federal Agency: U.S. Department of Housing and Urban Development Federal Program Name: Community Development Block Grant Program for Entitlement Communities Assistance Listing Number: 14.218 Federal Award Identification Number and Year: B-23-MC-35-0001 - 2023 Award Period: 7/1/2023 - 9/1/2030 Type of Finding • Significant Deficiency in Internal Control over Compliance • Other Matters Criteria or specific requirement: 2 CFR Part 200 Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award requires compliance with the provisions of reporting. The City should have internal controls designed to ensure compliance with those provisions. Under the requirements of the Federal Funding Accountability and Transparency Act (Pub. L. No. 109-282), as amended by Section 6202 of Pub. L. No. 110-252, hereafter referred as the "Transparency Act" that are codified in 2 CFR Part 170, recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). The key data elements are to be accurately reported and supported by the source documentation. The action is to be reported in FSRS no later than the last day of the month following the month in which the subaward/subaward amendment obligation was made or the subcontract award/subcontract modification was made. Condition: During our testing, we noted the City did not have adequate internal controls designed to ensure the accuracy of the subaward project description for two of the four subawards. Also, the report was not timely for three of the four subawards. Lastly, the subaward amount was incorrect for one of the four subawards. Questioned costs: None Context: During our testing of special reporting under the requirements of the Federal Funding Accountability and Transparency Act (FFATA), we noted the following instances of noncompliance: transactions tested - 4, subawards not reported - 0; report not timely - 3; subaward amount incorrect - 1; subaward missing key elements - 2; dollar amount of tested transactions -#2,444,598.00; Subaward not reported - $0; Report not timely - $1,444,598; subaward amount incorrect - $1,179,000; Subaward missing key elements - $2,179,000.00 Cause: :tvfanagement oversight. Specific to report not timely, the delay was due to staff turnover. Specific to subaward amount incorrect, the difference was due to the amount used from the investment summary which included the Program Income. Effect: The auditor noted instances of noncompliance with special reporting under the requirements of the FF AT A Recommendation: We recommend the City establish a reporting calendar. We recommend the City periodically reviews the completeness and accuracy of and adherence to the reporting calendar. Also, we recommend the City implement a formal review process of the reporting of first-tier subawards of $30,000 or more to the FSRS. Management Response: The City concurs with the finding. The CDBG contract check list has been updated to include the FF AT A reporting requirement. The Fiscal CDBG Policies and procedures have been modified to include a section on FFATA reporting to be completed with the time frame set forth in the FF AT A requirements. Timeline and Responsible Position: December 2024 - Department of Health, Housing and Homelessness Fiscal Manager

Corrective Action Plan

The City concurs with the finding. The CDBG contract check list has been updated to include the FFATA reporting requirement. The Fiscal CDBG Policies and procedures have been modified to include a section on FFATA reporting to be completed with the time frame set forth in the FF AT A requirements.

Categories

Reporting Internal Control / Segregation of Duties Procurement, Suspension & Debarment Subrecipient Monitoring Allowable Costs / Cost Principles Significant Deficiency Program Income

Other Findings in this Audit

  • 520233 2024-009
    Significant Deficiency Repeat
  • 520234 2024-010
    Significant Deficiency
  • 520235 2024-011
    Significant Deficiency
  • 520236 2024-012
    Significant Deficiency
  • 1096675 2024-009
    Significant Deficiency Repeat
  • 1096676 2024-010
    Significant Deficiency
  • 1096677 2024-011
    Significant Deficiency
  • 1096678 2024-012
    Significant Deficiency
  • 1096679 2024-013
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
20.507 Federal Transit Formula Grants $41.50M
20.106 Airport Improvement Program, Covid-19 Airports Programs, and Infrastructure Investment and Jobs Act Programs $15.54M
21.027 Coronavirus State and Local Fiscal Recovery Funds $9.66M
14.218 Community Development Block Grants/entitlement Grants $7.40M
16.710 Public Safety Partnership and Community Policing Grants $6.03M
14.239 Home Investment Partnerships Program $3.95M
20.205 Highway Planning and Construction $3.66M
14.267 Continuum of Care Program $2.85M
93.045 Special Programs for the Aging, Title Iii, Part C, Nutrition Services $1.95M
93.600 Head Start $1.83M
10.558 Child and Adult Care Food Program $1.09M
66.001 Air Pollution Control Program Support $770,662
93.044 Special Programs for the Aging, Title Iii, Part B, Grants for Supportive Services and Senior Centers $766,412
20.256 Federal Transit--Formula Grants $699,384
10.559 Summer Food Service Program for Children $686,552
97.039 Hazard Mitigation Grant $666,084
93.052 National Family Caregiver Support, Title Iii, Part E $630,849
16.741 Dna Backlog Reduction Program $627,969
95.001 High Intensity Drug Trafficking Areas Program $580,890
14.231 Emergency Solutions Grant Program $556,083
16.738 Edward Byrne Memorial Justice Assistance Grant Program $467,616
20.500 Federal Transit Capital Investment Grants $363,179
16.753 Congressionally Recommended Awards $334,079
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $296,018
66.034 Surveys, Studies, Research, Investigations, Demonstrations, and Special Purpose Activities Relating to the Clean Air Act $282,178
11.805 Mbda Business Center $261,730
93.053 Nutrition Services Incentive Program $197,728
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $176,555
97.141 Shelter and Services Program $175,539
94.011 Americorps Seniors Foster Grandparent Program (fgp) 94.011 $171,051
59.059 Congressional Grants $166,308
16.034 Coronavirus Emergency Supplemental Funding Program $133,717
97.U02 Tsa Law Enforcement Officer Reimbursement Program $133,644
97.042 Emergency Management Performance Grants $130,998
93.043 Special Programs for the Aging, Title Iii, Part D, Disease Prevention and Health Promotion Services $130,960
20.215 Highway Training and Education $126,621
21.023 Emergency Rental Assistance Program $113,280
94.016 Americorps Seniors Senior Companion Program (scp) 94.016 $83,137
16.838 Comprehensive Opioid, Stimulant, and Other Substances Use Program $69,257
97.072 National Explosives Detection Canine Team Program $67,333
16.588 Violence Against Women Formula Grants $64,152
66.046 Climate Pollution Reduction Grants $61,204
45.024 Promotion of the Arts Grants to Organizations and Individuals $51,000
94.013 Americorps Volunteers in Service to America 94.013 $50,000
93.048 Special Programs for the Aging, Title Iv, and Title Ii, Discretionary Projects $49,526
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $41,241
94.002 Americorps Seniors Retired and Senior Volunteer Program (rsvp) 94.002 $38,792
16.575 Crime Victim Assistance $34,381
93.074 Hospital Preparedness Program (hpp) and Public Health Emergency Preparedness (phep) Aligned Cooperative Agreements $33,298
20.600 State and Community Highway Safety $25,703
15.904 Historic Preservation Fund Grants-in-Aid $24,422
16.833 National Sexual Assault Kit Initiative $20,846
81.106 Transport of Transuranic Wastes to the Waste Isolation Pilot Plant: States and Tribal Concerns, Proposed Solutions $6,993
15.958 Route 66 Corridor Preservation $6,850
97.024 Emergency Food and Shelter National Board Program $1,187
93.137 Community Programs to Improve Minority Health Grant Program $-2,430