Finding 520236 (2024-012)

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

AI Summary

  • Core Issue: One of the three required performance reports was submitted late, indicating a significant deficiency in internal controls over compliance.
  • Impacted Requirements: The City failed to meet the reporting deadline of March 1, 2024, for the performance report due to management oversight.
  • Recommended Follow-Up: Establish a reporting calendar and regularly review adherence to it to ensure timely submissions of all programmatic reports.

Finding Text

2024 - 012 Reporting Federal Agency: U.S. Department of Justice Federal Program Name: Public Safety Partnership and Community Policing Grants Assistance Listing Number: 16. 710 Federal Award Identification Number and Year: l SJCOPS-23-GG-01715-TECP - 2023 Award Period: 12/29/2022 - 12/31 /2024 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 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 Part 3 of the Compliance Supplement 2024, compliance testing of performance and special reports is only required for data, identified by agencies in parts 4 and 5 as key line items, that are quantifiable and are capable of evaluation against objective criteria stated in the statutes, regulations, contract or grant agreements pertaining to the program. Performance and special reports in parts 4 and 5 are assumed to meet the above criteria. However, if an agency does not identify key line items for a performance or special report, auditors are only required to test that the report was submitted in a timely manner and no other procedures are required. According to the terms and conditions of the award, the City is responsible for submitting semi-annual programmatic performance reports that describe project activities during the reporting period. Performance reports are due August 30 and March 1. Condition: During our testing, we noted one of the three performance reports was not submitted timely. Questioned costs: None Context: During our testing, it was noted that one of the three performance reports was not submitted timely. The performance report for the reporting period end date January 31 , 2024 and due March 1, 2024 was submitted on March 11 , 2024. 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. We recommend the City periodically reviews the completeness and accuracy of and adherence to the reporting calendar. Management Response: The City concurs with the finding. The APD Grant Administrator will establish a process to ensure that all programmatic reports are submitted on time by creating a spreadsheet to track the due dates for each programmatic report. Once the reports are submitted, it will be the responsibility of the Grant Coordinator to record the submission date. If a report is submitted late, the Grant Coordinator must contact the grantor by the end of the day to explain the reason for the delay. Timeline and Responsible Position: December 2024 -APD Grant Administrator

Corrective Action Plan

The City concurs with the finding. The APD Grant Administrator will establish a process to ensure that all programmatic reports are submitted on time by creating a spreadsheet to track the due dates for each programmatic report. Once the reports are submitted, it will be the responsibility of the Grant Coordinator to record the submission date. If a report is submitted late, the Grant Coordinator must contact the grantor by the end of the day to explain the reason for the delay.

Categories

Reporting Internal Control / Segregation of Duties Subrecipient Monitoring Significant Deficiency

Other Findings in this Audit

  • 520233 2024-009
    Significant Deficiency Repeat
  • 520234 2024-010
    Significant Deficiency
  • 520235 2024-011
    Significant Deficiency
  • 520237 2024-013
    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