Finding 1175149 (2025-005)

Material Weakness Repeat Finding
Requirement
L
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, leading to late submissions of required financial reports for the Airport Improvement Program.
  • Impacted Requirements: Noncompliance with federal regulations regarding timely report submissions, specifically Forms 5100-126 and 5100-127, which were submitted 61 and 63 days late.
  • Recommended Follow-Up: Establish a reporting calendar and conduct regular reviews to ensure timely and accurate submissions of all required reports.

Finding Text

Federal Agency: U.S. Department of Transportation Federal Program Name: Airport Improvement Program Assistance Listing Number: 20.106 Federal Award Identification Number and Year: Multiple Award Period: 8/23/2020 –1/28/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 the Federal Aviation Administration's Advisory Circular 150-1500-19D, Guide for Airport Financial Reports Filed by Airport Sponsors, Financial Reports 5100-126 & 5100-127 "are due within 120 days of the end of the airport's fiscal year. A sponsor may request an automatic 60-day extension on the website. An airport that cannot file within the 60-day expensive should send a written explanation to Airport Compliance and Management Analysis" of the FAA. Condition: During our testing, we noted the City did not have adequate internal controls designed to ensure timely report submission. 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, it was noted that two of the six financial reports were not submitted timely. Form 5100-126 and Form 5100-127 were submitted on 02/26/2025 and 02/28/2025, respectively. These submissions occurred 61 and 63 days beyond the prescribed filing deadline of 180-days following the fiscal year end. Cause: Management oversight. The City did not submit the performance report by the due date. Effect: The auditor noted an instance of noncompliance. Noncompliance results in untimely submission of information to the federal agency. Recommendation: We recommend the City establish a reporting calendar and perform periodic reviews of the completeness, accuracy and adherence to the reporting calendar. Management Response: The City concurs with the finding. Beginning in December 2025, the Aviation Revenue and Finance Officer has implemented an internal control to strengthen compliance with federal reporting requirements. A centralized spreadsheet has been created to track all required financial report deadlines, including FAA Forms 5100-126 and 5100-127. This spreadsheet identifies the due dates, responsible personnel, and submission status to help ensure reports are prepared, reviewed, and submitted timely in accordance with applicable federal regulations. The Aviation Revenue and Finance Officer will also perform periodic reviews of the reporting calendar to monitor completeness, accuracy, and compliance to required deadlines. Timeline and Responsible Position: June 2026 – Aviation Department Revenue and Finance Officer

Corrective Action Plan

The City concurs with the finding. Beginning in December 2025, the Aviation Revenue and Finance Officer has implemented an internal control to strengthen compliance with federal reporting requirements. A centralized spreadsheet has been created to track all required financial report deadlines, including FAA Forms 5100-126 and 5100-127. This spreadsheet identifies the due dates, responsible personnel, and submission status to help ensure reports are prepared, reviewed, and submitted timely in accordance with applicable federal regulations. The Aviation Revenue and Finance Officer will also perform periodic reviews of the reporting calendar to monitor completeness, accuracy, and compliance to required deadlines.

Categories

Reporting Internal Control / Segregation of Duties Subrecipient Monitoring Significant Deficiency

Other Findings in this Audit

  • 1175150 2025-006
    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