Finding 1170826 (2024-002)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2026-01-28
Audit: 384102
Organization: The City of Oklahoma City (OK)

AI Summary

  • Core Issue: The program manager did not approve four invoices before they were charged to the CSLFRF grant, violating internal control procedures.
  • Impacted Requirements: This finding highlights noncompliance with 2 CFR 200.303, which mandates effective internal controls over federal awards.
  • Recommended Follow-Up: The City should ensure program manager certification is completed before charging expenditures to the CSLFRF program and implement additional monitoring steps for compliance.

Finding Text

Finding 2024-002 (Significant Deficiency) AL# 21.027: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds, U.S. Department of Treasury Condition: The City’s control procedures for the Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) requires the department personnel to authorize payment and the program manager to certify the expenditures to the CSLFRF program prior to being paid. The program manager did not approve four invoices prior to the expenditure being charged to the grant. Criteria: Per 2 CFR 200.303, the Non-Federal entity must establish and maintain effective internal controls over federal awards to ensure compliance with federal statutes, regulations and the terms and conditions of the awards. Questions Costs: None Context: During testing of grant expenditures, we identified 4 out of 21 items were missing the program manager certification prior to being charged to the grant program. All four invoices were approved at the department level and one of the invoices was subsequently reviewed by the department head. The expenditures were allowable under the CSLFRF program. The sample size was determined based upon guidelines provided by the AICPA which is not a statistically valid sample. Cause: Purchase orders are created that identify projects that are part of the CSLFRF program and expenditures coding is assigned at that time prior to the purchase. Once the invoice was approved by department personnel, the expenditures were applied to the assigned purchase order coding. Effect: Failure to follow established internal controls increases the risk of noncompliance with the grant requirements and processing unallowable costs towards the grant. Recommendation: We recommend the City review the processing of payments applied to the CLSFRF program to ensure program manager certification is complete prior to charging expenditures to the program. Views of Responsible Officials (Unaudited): The City concurs with the finding. Although the expenditures tested were allowable under the CSLFRF program and approved at the department level, the required program manager certification was not consistently documented prior to charging expenditures to the grant. The City acknowledges that this represents a deviation from established internal control procedures. Upon identification of this issue, Internal Audit worked with Accounts Payable and department personnel to address issues and made recommendations to correct the control gap. Additional review steps will be implemented within Accounts Payable to help ensure required approvals are obtained prior to payment processing. In addition, Accounting Services has developed a monitoring report to review CSLFRF expenditures and provide an additional level of oversight to verify that program manager certification is completed prior to charging expenditures to the grant. This monitoring serves as a secondary control to support compliance with grant requirements.

Corrective Action Plan

Finding 2024-002: (Significant Deficiency) AL# 21.027: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds, U.S. Department of Treasury Condition: The City’s control procedures for the Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) requires the department personnel to authorize payment and the program manager to certify the expenditures to the CSLFRF program prior to being paid. The program manager did not approve four invoices prior to the expenditure being charged to the grant. Criteria or Specific Requirement: 2 CFR 200.303, the Non-Federal entity must establish and maintain effective internal controls over federal awards to ensure compliance with federal statutes, regulations and the terms and conditions of the awards. Cause: Purchase orders are created that identify projects that are part of the CSLFRF and expenditures coding is assigned at that time prior to the purchase. Once the invoice was approved by department personnel, the expenditures were applied to the assigned purchase order coding. Effect: Failure to follow established internal controls increases the risk of noncompliance with the grant requirements and processing unallowable costs towards the grant. Corrective Plan: To address the underlying issues identified in the audit finding, the City will implement the following steps: 1.Correct Approval Control GapInternal Audit worked with Accounts Payable and department personnel and made recommendations tocorrect the control gap and ensure compliance with approval procedures. It is anticipated theserecommendations will be implemented in the next two months. Additional review steps were added inaccounts payable to ensure required approvals obtained prior to payment processing. 2.Implement Monitoring ReportAccounting services developed a report to verify approvals and provide secondary oversight for CSLFRFexpenditures. These actions will be implemented and monitored to ensure compliance with grant requirements. Alex Fedak, CPA 1/7/26 Date Controller

Categories

Allowable Costs / Cost Principles Internal Control / Segregation of Duties Procurement, Suspension & Debarment Subrecipient Monitoring Significant Deficiency Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 1170825 2024-004
    Material Weakness Repeat
  • 1170827 2024-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $16.55M
14.248 COMMUNITY DEVELOPMENT BLOCK GRANTS SECTION 108 LOAN GUARANTEES $15.52M
20.507 FEDERAL TRANSIT FORMULA GRANTS $6.00M
20.933 NATIONAL INFRASTRUCTURE INVESTMENTS $3.84M
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $2.83M
66.468 DRINKING WATER STATE REVOLVING FUND $2.04M
16.922 EQUITABLE SHARING PROGRAM $1.71M
66.818 BROWNFIELDS MULTIPURPOSE, ASSESSMENT, REVOLVING LOAN FUND, AND CLEANUP COOPERATIVE AGREEMENTS $1.36M
14.241 HOUSING OPPORTUNITIES FOR PERSONS WITH AIDS $1.07M
21.023 EMERGENCY RENTAL ASSISTANCE PROGRAM $530,116
21.016 EQUITABLE SHARING $444,540
97.041 NATIONAL DAM SAFETY PROGRAM $420,902
93.044 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART B, GRANTS FOR SUPPORTIVE SERVICES AND SENIOR CENTERS $414,096
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $319,431
20.525 STATE OF GOOD REPAIR GRANTS PROGRAM $267,444
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $231,596
97.090 LAW ENFORCEMENT OFFICER REIMBURSEMENT AGREEMENT PROGRAM $229,104
16.320 SERVICES FOR TRAFFICKING VICTIMS $180,233
20.939 SAFE STREETS AND ROADS FOR ALL $152,834
16.741 DNA BACKLOG REDUCTION PROGRAM $123,944
14.267 CONTINUUM OF CARE PROGRAM $119,836
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $107,915
14.276 YOUTH HOMELESSNESS DEMONSTRATION PROGRAM $93,269
81.128 ENERGY EFFICIENCY AND CONSERVATION BLOCK GRANT PROGRAM (EECBG) $86,151
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $81,098
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $64,304
97.046 FIRE MANAGEMENT ASSISTANCE GRANT $38,932
97.067 HOMELAND SECURITY GRANT PROGRAM $29,100
16.575 CRIME VICTIM ASSISTANCE $26,070
15.904 HISTORIC PRESERVATION FUND GRANTS-IN-AID $21,619
20.205 HIGHWAY PLANNING AND CONSTRUCTION $21,151
11.431 CLIMATE AND ATMOSPHERIC RESEARCH $9,750
20.325 CONSOLIDATED RAIL INFRASTRUCTURE AND SAFETY IMPROVEMENTS $9,577
20.106 AIRPORT IMPROVEMENT PROGRAM, INFRASTRUCTURE INVESTMENT AND JOBS ACT PROGRAMS, AND COVID-19 AIRPORTS PROGRAMS $7,333
16.710 PUBLIC SAFETY PARTNERSHIP AND COMMUNITY POLICING GRANTS $7,219
45.129 PROMOTION OF THE HUMANITIES FEDERAL/STATE PARTNERSHIP $1,470
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $800
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $-3,853