Finding 1220081 (2024-005)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2026-06-29
Audit: 405251
Organization: Lake County (IN)

AI Summary

  • Core Issue: The County failed to submit accurate quarterly Project and Expenditure reports, leading to significant discrepancies in reported amounts.
  • Impacted Requirements: Noncompliance with federal reporting standards and lack of effective internal controls as mandated by 2 CFR 200.303.
  • Recommended Follow-Up: Establish a robust internal control system to ensure accurate reporting and compliance with federal requirements.

Finding Text

FINDING 2024-005 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Federal Agency: U.S. 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 Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2023-005. Condition and Context Recipients are required to submit quarterly or annual Project and Expenditure (P&E) reports to the U.S. Department of the Treasury (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 that exceeds 250,000 residents. As such, the County was required to submit quarterly P&E reports in 2024. The amounts submitted for three of the four quarterly P&E reports were not supported by the County's records and contained the following errors:  The 2024 Quarter 1 P&E report period and cumulative expenditures were each overstated by $333,424.  The 2024 Quarter 2 P&E report period and cumulative expenditures were understated by $842,954 and $509,530, respectively.  The 2024 Quarter 3 P&E report period and cumulative expenditures were understated by $239,925 and $749,455, respectively. Additionally, the current period obligations and cumulative obligations amounts reported in all quarterly reports could not be verified as supporting documentation was not provided for audit. The lack of internal controls and noncompliance was a systemic issue throughout the audit period. 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). . . ." Compliance and Reporting Guidance, State and Local Fiscal Recovery Funds, page 13 states in part: ". . . 13. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or 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. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary or her delegate, as applicable, periodic reports providing detailed accounting of the uses of funds, . . ." Cause All quarterly P&E reports were prepared and submitted by a consultant without an oversight or review process in place to prevent, or detect and correct, errors prior to submission. Effect 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 County's management establish a proper system of internal controls that would ensure compliance with the Reporting compliance requirement. 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 2024-005 Finding Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Contact Person Responsible for Corrective Action: Burzynski Thaddeus Contact Phone Number and Email Address: 219-755-3200, burzytx@lakecountyin.org Views of Responsible Officials: We concur with the finding Description of Corrective Action Plan: The County 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. Anticipated Completion Date: December 2026

Categories

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

Other Findings in this Audit

  • 1220078 2024-003
    Material Weakness Repeat
  • 1220079 2024-004
    Material Weakness Repeat
  • 1220080 2024-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $7.83M
93.563 CHILD SUPPORT SERVICES $4.34M
20.205 HIGHWAY PLANNING AND CONSTRUCTION $1.56M
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $251,263
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $163,767
93.940 HIV PREVENTION AND SURVEILLANCE ACTIVITIES-HEALTH DEPARTMENT BASED $151,285
97.067 HOMELAND SECURITY GRANT PROGRAM $128,960
66.469 GEOGRAPHIC PROGRAMS - GREAT LAKES RESTORATION INITIATIVE $114,932
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $107,078
90.404 HAVA ELECTION SECURITY GRANTS $89,570
93.788 OPIOID STR $81,250
16.U01 Domestic Cannabis Eradication and Suppression $77,800
21.023 EMERGENCY RENTAL ASSISTANCE PROGRAM $76,911
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $75,000
16.575 CRIME VICTIM ASSISTANCE $64,585
10.555 NATIONAL SCHOOL LUNCH PROGRAM $45,474
16.922 EQUITABLE SHARING PROGRAM $34,089
16.609 PROJECT SAFE NEIGHBORHOODS $30,588
10.553 SCHOOL BREAKFAST PROGRAM $24,685
93.747 ELDER ABUSE PREVENTION INTERVENTIONS PROGRAM $16,923
15.662 GREAT LAKES RESTORATION $9,800
97.012 BOATING SAFETY FINANCIAL ASSISTANCE $7,500
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $6,034
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $5,826
93.946 COOPERATIVE AGREEMENTS TO SUPPORT STATE-BASED SAFE MOTHERHOOD AND INFANT HEALTH INITIATIVE PROGRAMS $4,852