Finding 1179668 (2023-005)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2026-03-16
Audit: 392081
Organization: Lake County (IN)

AI Summary

  • Core Issue: The County failed to establish effective internal controls for quarterly Project and Expenditures (P&E) reports, leading to potential inaccuracies in submissions.
  • Impacted Requirements: Compliance with 2 CFR 200.303, which mandates effective internal controls over federal awards to ensure accurate reporting.
  • Recommended Follow-Up: Management should design and implement a robust internal control system to verify the accuracy of quarterly P&E reports before submission.

Finding Text

FINDING 2023-005 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): SLT-3157 Compliance Requirement: Reporting Audit Finding: Material Weakness INDIANA STATE BOARD OF ACCOUNTS 26 LAKE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context Recipients are required to submit quarterly Project and Expenditures (P&E) reports to the U.S. Department of the Treasury. The reporting periods, as well as the respective due dates, are based upon type of recipient and its population, as well as the recipient's allocation amount. Information to be reported includes projects funded, expenditures, and contracts for the appropriate reporting period. The County was classified as a county with a population above 250,000 residents. As such, the County was required to submit quarterly P&E reports in 2023. The County did not have internal control procedures in place over the quarterly P&E reports. The quarterly P&E reports were generated by one individual without a review or oversight process to detect and correct errors prior to submission. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) 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). . . ." Cause A proper system of internal controls was not designed or implemented by management of the County to ensure that policies and procedures were in place related to reporting to ensure the amounts reported were accurate. Effect Without the proper implementation of an effectively designed system of internal controls over reporting, the County cannot ensure that the quarterly P&E reports submitted were materially accurate and correct. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the repayment or loss of future federal funding to the County. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the management of the County design and implement a proper system of internal controls to ensure the accuracy and correctness of the quarterly P&E reports. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Corrective Action Plan

FINDING 2023-005 Contact Person Responsible for Corrective Action: Craig Zandstra Contact Phone Number: 219-945-0543 Ext 234 Contact Email: craigz@lakecountyparks.com Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan As this finding is shared between The Lake County Board of Commissioners and the Lake County Parks & Recreation Department, both departments will develop and implement a proper system of internal controls and segregation of duties. This will ensure accuracy and correctness of all quarterly P & E Reports in the future. Completion Date: June 2026

Categories

Internal Control / Segregation of Duties Allowable Costs / Cost Principles Material Weakness Reporting Matching / Level of Effort / Earmarking Special Tests & Provisions

Other Findings in this Audit

  • 1179664 2023-002
    Material Weakness Repeat
  • 1179665 2023-003
    Material Weakness Repeat
  • 1179666 2023-004
    Material Weakness Repeat
  • 1179667 2023-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $17.03M
93.563 CHILD SUPPORT SERVICES $4.51M
21.023 EMERGENCY RENTAL ASSISTANCE PROGRAM $2.58M
20.205 HIGHWAY PLANNING AND CONSTRUCTION $1.26M
97.056 PORT SECURITY GRANT PROGRAM $583,168
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $396,435
66.469 GEOGRAPHIC PROGRAMS - GREAT LAKES RESTORATION INITIATIVE $136,435
16.575 CRIME VICTIM ASSISTANCE $95,685
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $94,000
97.067 HOMELAND SECURITY GRANT PROGRAM $90,677
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $85,604
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $81,000
16.588 VIOLENCE AGAINST WOMEN FORMULA GRANTS $80,020
10.555 NATIONAL SCHOOL LUNCH PROGRAM $66,341
16.606 STATE CRIMINAL ALIEN ASSISTANCE PROGRAM $61,363
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $54,181
16.609 PROJECT SAFE NEIGHBORHOODS $44,319
16.111 JOINT LAW ENFORCEMENT OPERATIONS (JLEO) $35,460
16.922 EQUITABLE SHARING PROGRAM $34,850
10.553 SCHOOL BREAKFAST PROGRAM $32,993
11.419 COASTAL ZONE MANAGEMENT ADMINISTRATION AWARDS $26,800
21.019 CORONAVIRUS RELIEF FUND $22,257
93.940 HIV PREVENTION ACTIVITIES HEALTH DEPARTMENT BASED $15,405
93.788 OPIOID STR $14,000
97.012 BOATING SAFETY FINANCIAL ASSISTANCE $11,250
93.354 PUBLIC HEALTH EMERGENCY RESPONSE: COOPERATIVE AGREEMENT FOR EMERGENCY RESPONSE: PUBLIC HEALTH CRISIS RESPONSE $10,228