Finding 1175150 (2025-006)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2025
Accepted
2026-02-24
Audit: 388755
Organization: City of Albuquerque (NM)

AI Summary

  • Core Issue: The City lacks adequate internal controls for properly allocating fringe benefits, leading to significant compliance deficiencies.
  • Impacted Requirements: Noncompliance with 2 CFR Part 200 regarding internal controls and cost allocation, specifically concerning fringe benefits.
  • Recommended Follow-Up: The City should implement quarterly reviews of fringe benefit allocations and ensure proper oversight by fiscal staff and management.

Finding Text

Federal Agency: U.S. Department of Housing and Urban Development Federal Program Name: HOME Investment Partnerships Program Assistance Listing Number: 14.239 Federal Award Identification Number and Year: M20-MC350209 - 2020 M21-MC350209 - 2021 Award Period: 5/29/2020 - 9/01/2028 8/03/2021 - 9/01/2029 Type of Finding: • Significant Deficiency in Internal Control over Compliance and Other Matters Criteria or specific requirement: According to §200.303 Internal controls of 2 CFR Part 200, the recipient and subrecipient must establish, document, and maintain effective internal control over the federal award that provides reasonable assurance that the recipient or subrecipient is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. According to §200.403 Factors affecting allowability of costs of 2 CFR Part 200, costs must conform to any limitations or exclusions set forth in these principles or in the federal award as to types or amount of cost items. Additionally, according to §200.431 costs of fringe benefits in the form of regular compensation paid to employees during periods of authorized absences should be equitably allocated to all related activities, including Federal awards. Condition: During our testing, we noted the City did not have adequate internal controls designed to ensure proper allocation of fringe benefits. 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: $973.77 Context: During our testing, it was noted that for one of twenty-four samples, the City applied incorrect fringe benefits to the grant, resulting in $371.11 that should have been allocated to the grant. Additionally, for one of twenty-four samples, the City did not accurately apply sick leave conversion to wages, resulting in $973.77 of wages improperly allocated to the grant. Cause: Management oversight. The city did not have adequate controls in place to ensure proper allocation of fringe benefits. Effect: The auditor noted instances of noncompliance. Noncompliance results in potential pay back of federal funds. Recommendation: We recommend the City review fringe benefits charged to the grant to equitably allocate fringe benefits between federal and city funding sources. Management Response: The City concurs with the finding. The Department of Health, Housing & Homelessness will review the allocation of fringe benefits to grant payroll charges on a quarterly basis to ensure fringe benefits are properly allocated to funding sources. The reconciliations will be prepared by fiscal staff and approved by the Fiscal Manager. Additionally, the DFAS Grant Administrator will perform a semi-annual review of excess leave payouts to ensure they are charged to the correct grant funding string. Timeline and Responsible Position: June 2026 – Department of Health, Housing and Homelessness Fiscal Manager

Corrective Action Plan

The City concurs with the finding. The Department of Health, Housing & Homelessness will review the allocation of fringe benefits to grant payroll charges on a quarterly basis to ensure fringe benefits are properly allocated to funding sources. The reconciliations will be prepared by fiscal staff and approved by the Fiscal Manager. Additionally, the DFAS Grant Administrator will perform a semi-annual review of excess leave payouts to ensure they are charged to the correct grant funding string.

Categories

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

Other Findings in this Audit

  • 1175149 2025-005
    Material Weakness Repeat
  • 1175151 2025-007
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
20.106 AIRPORT IMPROVEMENT PROGRAM, INFRASTRUCTURE INVESTMENT AND JOBS ACT PROGRAMS, AND COVID-19 AIRPORTS PROGRAMS $16.14M
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $11.65M
20.205 HIGHWAY PLANNING AND CONSTRUCTION $5.66M
20.507 FEDERAL TRANSIT FORMULA GRANTS $5.31M
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $4.76M
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $4.73M
16.710 PUBLIC SAFETY PARTNERSHIP AND COMMUNITY POLICING GRANTS $4.23M
20.526 BUSES AND BUS FACILITIES FORMULA, COMPETITIVE, AND LOW OR NO EMISSIONS PROGRAMS $2.98M
14.267 CONTINUUM OF CARE PROGRAM $2.97M
21.023 EMERGENCY RENTAL ASSISTANCE PROGRAM $1.64M
93.600 HEAD START $1.51M
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $1.47M
93.045 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART C, NUTRITION SERVICES $1.46M
66.001 AIR POLLUTION CONTROL PROGRAM SUPPORT $1.30M
10.558 CHILD AND ADULT CARE FOOD PROGRAM $1.20M
93.493 CONGRESSIONAL DIRECTIVES $836,601
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN $828,383
16.833 NATIONAL SEXUAL ASSAULT KIT INITIATIVE $728,365
95.001 HIGH INTENSITY DRUG TRAFFICKING AREAS PROGRAM $638,756
16.753 CONGRESSIONALLY RECOMMENDED AWARDS $588,921
16.741 DNA BACKLOG REDUCTION PROGRAM $583,100
93.044 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART B, GRANTS FOR SUPPORTIVE SERVICES AND SENIOR CENTERS $489,728
66.046 CLIMATE POLLUTION REDUCTION GRANTS $480,309
11.805 MBDA BUSINESS CENTER $478,754
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $410,637
93.052 NATIONAL FAMILY CAREGIVER SUPPORT, TITLE III, PART E $381,028
20.608 MINIMUM PENALTIES FOR REPEAT OFFENDERS FOR DRIVING WHILE INTOXICATED $310,114
14.889 CHOICE NEIGHBORHOODS IMPLEMENTATION GRANTS $306,235
16.838 COMPREHENSIVE OPIOID, STIMULANT, AND OTHER SUBSTANCES USE PROGRAM $304,662
93.053 NUTRITION SERVICES INCENTIVE PROGRAM $244,039
81.128 ENERGY EFFICIENCY AND CONSERVATION BLOCK GRANT PROGRAM (EECBG) $226,440
93.243 SUBSTANCE ABUSE AND MENTAL HEALTH SERVICES PROJECTS OF REGIONAL AND NATIONAL SIGNIFICANCE $216,446
20.215 HIGHWAY TRAINING AND EDUCATION $210,656
97.067 HOMELAND SECURITY GRANT PROGRAM $187,075
94.011 AMERICORPS SENIORS FOSTER GRANDPARENT PROGRAM (FGP) 94.011 $180,324
97.039 HAZARD MITIGATION GRANT $159,510
97.141 SHELTER AND SERVICES PROGRAM $148,477
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $137,471
59.059 CONGRESSIONAL GRANTS $114,930
89.003 NATIONAL HISTORICAL PUBLICATIONS AND RECORDS GRANTS $114,169
93.074 HOSPITAL PREPAREDNESS PROGRAM (HPP) AND PUBLIC HEALTH EMERGENCY PREPAREDNESS (PHEP) ALIGNED COOPERATIVE AGREEMENTS $113,128
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $89,982
66.034 SURVEYS, STUDIES, RESEARCH, INVESTIGATIONS, DEMONSTRATIONS, AND SPECIAL PURPOSE ACTIVITIES RELATING TO THE CLEAN AIR ACT $83,053
94.016 AMERICORPS SENIORS SENIOR COMPANION PROGRAM (SCP) 94.016 $77,433
10.727 INFLATION REDUCTION ACT URBAN & COMMUNITY FORESTRY PROGRAM $64,679
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $59,884
93.043 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART D, DISEASE PREVENTION AND HEALTH PROMOTION SERVICES $58,179
16.588 VIOLENCE AGAINST WOMEN FORMULA GRANTS $56,207
94.002 AMERICORPS SENIORS RETIRED AND SENIOR VOLUNTEER PROGRAM (RSVP) 94.002 $54,223
94.013 AMERICORPS VOLUNTEERS IN SERVICE TO AMERICA 94.013 $50,000
16.742 PAUL COVERDELL FORENSIC SCIENCES IMPROVEMENT GRANT PROGRAM $41,603
45.024 PROMOTION OF THE ARTS GRANTS TO ORGANIZATIONS AND INDIVIDUALS $41,200
20.500 FEDERAL TRANSIT CAPITAL INVESTMENT GRANTS $35,111
16.575 CRIME VICTIM ASSISTANCE $30,146
10.935 URBAN AGRICULTURE AND INNOVATIVE PRODUCTION $26,900
93.048 SPECIAL PROGRAMS FOR THE AGING, TITLE IV, AND TITLE II, DISCRETIONARY PROJECTS $26,123
14.251 ECONOMIC DEVELOPMENT INITIATIVE, COMMUNITY PROJECT FUNDING, AND MISCELLANEOUS GRANTS $25,765
15.958 ROUTE 66 CORRIDOR PRESERVATION $23,150
15.904 HISTORIC PRESERVATION FUND GRANTS-IN-AID $21,115
81.106 TRANSPORT OF TRANSURANIC WASTES TO THE WASTE ISOLATION PILOT PLANT: STATES AND TRIBAL CONCERNS, PROPOSED SOLUTIONS $7,000
15.916 OUTDOOR RECREATION ACQUISITION, DEVELOPMENT AND PLANNING $1,465