Finding 573710 (2023-010)

Significant Deficiency Repeat Finding
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2025-08-15
Audit: 364370
Organization: Rogers County (OK)

AI Summary

  • Core Issue: Noncompliance with reporting requirements was found in 35 projects related to the Coronavirus and Local Fiscal Recovery Funds, including incorrect coding of revenue losses and expenditures.
  • Impacted Requirements: Federal grant guidelines were not followed, leading to inaccurate financial reporting and potential violations of compliance standards.
  • Recommended Follow-Up: The County should enhance internal controls and policies to ensure accurate tracking and reporting of federal funds, collaborating with a third-party administrator for oversight.

Finding Text

Condition: During the test of 100% of projects, thirty-five (35) projects, for the Coronavirus and Local Fiscal Recovery Funds, the following noncompliance with the Reporting compliance requirement was noted: • Eighteen (18) projects were coded as revenue loss and were a subrecipient relationship. • Seventeen (17) projects were coded as revenue loss and should have been coded to an Administrative code. • Four (4) projects were coded as a subrecipient and should not have been. After the review of the quarterly reports, the following exceptions were noted: • The second quarter report was over reported by $643,303, • 911 Trust Authority reported $195,398 in cumulative expenditures on the report; however, no disbursements were made in fiscal year 2022 or fiscal year 2023. • North West Rogers County Fire Protection District reported $171,219 in cumulative expenditures; however, no disbursements were made in fiscal year 2022 and fiscal year 2023. • Emergency Management reported $333,169 in cumulative expenditures; however, there were only expenditures totaling $18,313. • School Resource Officers reported $135,778 in cumulative expenditures; however, there were only expenditures totaled $41,447. • Expenditures for the jail security electronics upgrade was not reported; however, there were expenditures totaling $132,501. Cause of Condition: Policies and procedures have not been designed and implemented to ensure federal expenditures are properly reported in accordance with federal compliance requirements. Effect of Condition: This condition resulted in noncompliance with federal grant guidelines. Recommendation: OSAI recommends the County gain an understanding of the requirements for this program and implement internal controls to ensure compliance with these requirements. Management Response: Board of County Commissioners: The Board of County Commissioners is responsible for the overall fiscal concerns of the county. See OKLA. STAT. Title 19, § 345. The Board of County Commissioners, with the cooperation and participation of all elected officials, reviews, develops and implements policies and procedures to create a strong internal control environment. The Board of County Commissioners will work with all elected officials, the third-party administrator, and federal, state and local partners to develop policies, procedures, and internal controls designed to accurately track grants, including the application process, verification, oversight, and reporting of grant requirements. These policies and procedures will be designed to identify requirements for recipients and sub-recipients of grants, ensure accurate equipment and real property management, procurement, recipient and subrecipient monitoring and reporting. Further, policies will ensure a proper understanding of all grant requirements and compliance of the same. To assist in this process, the Board of County Commissioners engaged a third-party administrator to oversee the grant process, including application, eligibility, review, requirements, contracting, recipient tracking and oversight, and documentation and reporting. The Board of County Commissioners will work with the third-party administrator to ensure proper grant administration. Criteria: Accountability and stewardship should be overall goals in management’s accounting of federal funds. Internal controls should be designed to monitor compliance with laws and regulations pertaining to grant contracts. Title 2 CFR § 200.303(a) Internal Controls, reads as follows: The non-federal entity must: Establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework, “issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Compliance and Reporting Guidance, State and Local Fiscal Recovery Funds (10. Reporting) reads as follows: All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlines in Part 2 of this guidance. Expenditures may be reported on a cash of accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. In addition, where appropriate, your organization needs to establish internal controls to ensure completion and timely submission of all mandatory performance and/or compliance reporting. Further, 2 CFR 200.329-Monitoring and reporting Program Performance (c)(1) reads as follows: (c)(1) The non-Federal entity must submit performance reports at the interval required by the Federal awarding agency or pass-through entity to best inform improvements in program outcomes and productivity. Intervals must be no less frequent than annually nor more frequent than quarterly except in unusual circumstances, for example where more frequent reporting is necessary for the effective monitoring of the Federal award or could significantly affect program outcomes. Reports submitted annually by the non-Federal entity and/or pass-through entity must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. Alternatively, the Federal awarding agency or pass-through entity may require annual reports before the anniversary dates of multiple year Federal awards. The final performance report submitted by the non-Federal entity and/or pass-through entity must be due no later than 120 calendar gays after the period of performance end date. A subrecipient must submit to the pass-through entity, no later than 90 calendar days after the period of performance end date, all final performance reports as required by the terms and conditions of the Federal award. See also §200.344. If a justified request is submitted by a non-Federal entity, the Federal agency may extend the due date for any performance report.

Corrective Action Plan

The Board of County Commissioners, with the cooperation and participation of all elected officials, reviews, develops and implements policies and procedures to create a strong internal control environment. The Board of County Commissioners will work with all elected officials, the third-party administrator, and federal, state and local partners to develop policies, procedures, and internal controls designed to accurately track grants, including the application process, verification, oversight, and reporting of grant requirements. To assist in this process, the Board of County Commissioners engaged a third-party administrator to oversee the grant process, including application, eligibility, review, requirements, contracting, recipient tracking and oversight, and documentation and reporting. The Board of County Commissioners will work with the third-party administrator to ensure proper grant administration.

Categories

Subrecipient Monitoring Internal Control / Segregation of Duties Equipment & Real Property Management

Other Findings in this Audit

  • 573707 2023-004
    Material Weakness Repeat
  • 573708 2023-005
    Material Weakness Repeat
  • 573709 2023-006
    Material Weakness Repeat
  • 573711 2023-011
    Significant Deficiency Repeat
  • 1150149 2023-004
    Material Weakness Repeat
  • 1150150 2023-005
    Material Weakness Repeat
  • 1150151 2023-006
    Material Weakness Repeat
  • 1150152 2023-010
    Significant Deficiency Repeat
  • 1150153 2023-011
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $5.75M
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $180,378
20.600 State and Community Highway Safety $155,289
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $152,067
16.710 Public Safety Partnership and Community Policing Grants $99,023
15.226 Payments in Lieu of Taxes $98,459
16.835 Body Worn Camera Policy and Implementation $59,585
11.300 Investments for Public Works and Economic Development Facilities $59,037
12.106 Flood Control Projects $42,942
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $33,201
16.554 National Criminal History Improvement Program (nchip) $17,878
16.607 Bulletproof Vest Partnership Program $16,400
97.042 Emergency Management Performance Grants $9,595