Finding 1096676 (2024-010)

Significant Deficiency
Requirement
AB
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 timecard approval, leading to a significant deficiency in compliance with federal requirements.
  • Impacted Requirements: Failure to meet internal control standards as outlined in §200.303 and follow-up obligations under §200.511 of 2 CFR Part 200.
  • Recommended Follow-Up: The City should finalize and implement the new timecard policy by April 2024 and consider additional software to enhance control measures.

Finding Text

2024 - 010 Allowable Activities and Costs/Cost Principles - Payroll (2023-010 and 2022-005) Federal Agency: U.S. Department of Transportation Federal Program Name: Federal Transit Cluster - Federal Transit - Formula Grants Assistance Listing Number: 20.507 Federal Award Identification Number and Year: N1vl-2023-022-00 - 2023 N1vl-2023-036-00 - 2023 Award Period: 5/31/2023 - 9/30/2024 12/18/2023 - 6/30/2025 Type of Finding: • Significant Deficiency in Internal Control over Compliance 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.511 Audit findings follow-up of 2 CFR Part 200, the auditee is responsible for follow-up and corrective action on all audit findings. At the completion of the audit, the auditee must prepare a corrective action plan to address each audit finding included in the auditor's report for the current year. According to the City's Corrective Action Plan for the year ended June 30, 2023, the Transit department has established a timeline for the completion and approval of the time card policy, and it is expected that the policy will take effect in April 2024. Condition: During our testing, we noted the City did not have adequate internal controls designed to ensure proper timecard approval. 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 thirteen out of sixteen payroll disbursements did not have approval of the employees' timecards. Cause: The City has not implemented corrective action from the audit for the year ended June 30, 2023. The Transit department is working on the policy and in the final stages of getting the policy updated. Effect: The auditor noted no instances of noncompliance with the provisions of allowable activities and costs/cost principles; however, the lack of internal controls over these compliance requirements provides an opportunity for noncompliance. Recommendation: We recommend the City work to implement full corrective action. Management Response: The City concurs with the finding. Transit Department staff is in the process of developing a policy establishing internal controls over timekeeping and is near finalizing the policy. Once finalized, the policy will be reviewed with appropriate parties. Further, the Transit Department is exploring the purchase and implementation of additional software to assist with enacting these controls. Timeline and Responsible Position: April 2025 - Transit Department Director

Categories

Procurement, Suspension & Debarment Subrecipient Monitoring Allowable Costs / Cost Principles Significant Deficiency Internal Control / Segregation of Duties Special Tests & Provisions

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
  • 520237 2024-013
    Significant Deficiency
  • 1096675 2024-009
    Significant Deficiency Repeat
  • 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