Finding 573705 (2024-010)

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

AI Summary

  • Core Issue: Sixteen projects failed to comply with reporting requirements, including late submissions and incorrect coding of expenditures.
  • Impacted Requirements: Noncompliance with federal grant guidelines due to inadequate internal controls and reporting processes.
  • Recommended Follow-Up: Implement robust internal controls and training to ensure accurate tracking and reporting of federal funds.

Finding Text

Condition: During the test of 100 % of projects, sixteen (16) projects, for the Coronavirus State and Local Fiscal Recovery Funds, the following noncompliance with the Reporting compliance requirement was noted: • The third quarter report was not submitted. • The fourth quarter report was not timely submitted. • Four (4) projects were coded as revenue loss and should have been coded to an administrative expense code. • Four (4) projects were coded as revenue loss and should have been coded as a subrecipient. • Two (2) projects were coded as a subrecipient and were not a subrecipient relationship. After the review of the quarterly reports, the following exceptions were noted: • The second quarter report was understated by $257,160. • Health Department reported cumulative total of $1,090,483 in expenditures; however, disbursements totaled $1,089,725. • Emergency Management reported cumulative total of $276,279 in expenditures; however, disbursements totaled $333,169. • Rogers County Sheriff reported cumulative total of $300,000 in expenditures; however, disbursements totaled $233,344. • The consultant hired by the county to administer the grant reported cumulative total of $251,427 in expenditures; however, disbursements totaled was $287,346. Jail Remodel had expenditures of $231,765; however, it was no expenditures were listed on the report. 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 Reporting Equipment & Real Property Management

Other Findings in this Audit

  • 573703 2024-005
    Material Weakness Repeat
  • 573704 2024-006
    Material Weakness Repeat
  • 573706 2024-011
    Significant Deficiency Repeat
  • 1150145 2024-005
    Material Weakness Repeat
  • 1150146 2024-006
    Material Weakness Repeat
  • 1150147 2024-010
    Significant Deficiency Repeat
  • 1150148 2024-011
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $3.13M
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $419,458
20.600 State and Community Highway Safety $194,380
15.226 Payments in Lieu of Taxes $104,715
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $79,081
12.106 Flood Control Projects $33,338
97.067 Homeland Security Grant Program $16,755
16.710 Public Safety Partnership and Community Policing Grants $11,098
16.738 Edward Byrne Memorial Justice Assistance Grant Program $10,950
97.042 Emergency Management Performance Grants $800