Finding 1081262 (2022-005)

Material Weakness
Requirement
H
Questioned Costs
-
Year
2022
Accepted
2024-11-06
Audit: 327510
Organization: Lake County (IN)

AI Summary

  • Core Issue: The County lacks effective internal controls over adjustments to Community Development Block Grants, leading to a material weakness in compliance.
  • Impacted Requirements: Non-compliance with 2 CFR 200.303 and 2 CFR 200.1 regarding internal control systems may jeopardize future federal funding.
  • Recommended Follow-Up: Management should establish a robust internal control system and maintain documentation to ensure compliance with performance requirements.

Finding Text

FINDING 2022-005 Subject: CDBG - Entitlement Grants Cluster - Period of Performance Federal Agency: Department of Housing and Urban Development Federal Program: Community Development Block Grants/Entitlement Grants Assistance Listings Number: 14.218 Federal Award Numbers and Years (or Other Identifying Numbers): B-11-UN-18-0002, B-17-UC-18-0016, B-18-UC-18-0016, B-19-UC-18-0016, B-20-UC-18-0016, B-21-UC-18-0016 Compliance Requirement: Period of Performance Audit Finding: Material Weakness Condition and Context The County did not have internal control procedures over adjustments to Community Development Block Grants/Entitlement Grants funds. During and after the transition to a new financial accounting software system for the County, various adjusting entries were entered by outside consultants without any oversight or review by County management. The lack of internal controls was a systematic issue from July 1, 2022 to December 31, 2022. 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 25 LAKE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.1 states in part: ". . . Internal controls for non-Federal entities means: (1) Processes designed and implemented by non-Federal entities to provide reasonable assurance regarding the achievement of objectives in the following categories: (i) Effectiveness and efficiency of operations; (ii) Reliability of reporting for internal and external use; . . ." Cause The conversion process due to the change in financial software in the middle of year 2022 caused abnormal activity which was not a part of the system of internal controls as designed and implemented by the County. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the County. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the County's management design and implement a proper system of internal controls, and retain documentation of its system of internal controls, to ensure compliance with period of performance requirements. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Categories

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

Other Findings in this Audit

  • 504817 2022-003
    Material Weakness
  • 504818 2022-004
    Material Weakness
  • 504819 2022-004
    Material Weakness
  • 504820 2022-005
    Material Weakness
  • 504821 2022-006
    Significant Deficiency
  • 1081259 2022-003
    Material Weakness
  • 1081260 2022-004
    Material Weakness
  • 1081261 2022-004
    Material Weakness
  • 1081263 2022-006
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.023 Emergency Rental Assistance Program $13.02M
93.563 Child Support Services $4.38M
20.205 Highway Planning and Construction $567,324
97.067 Homeland Security Grant Program $288,943
11.419 Coastal Zone Management Administration Awards $150,000
16.609 Project Safe Neighborhoods $144,235
93.069 Public Health Emergency Preparedness $142,233
16.575 Crime Victim Assistance $139,526
14.239 Home Investment Partnerships Program $101,809
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $100,000
16.738 Edward Byrne Memorial Justice Assistance Grant Program $98,508
16.588 Violence Against Women Formula Grants $91,445
93.944 Human Immunodeficiency Virus (hiv)/acquired Immunodeficiency Virus Syndrome (aids) Surveillance $80,802
97.042 Emergency Management Performance Grants $72,953
10.555 National School Lunch Program $61,397
21.019 Coronavirus Relief Fund $57,076
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $45,528
14.218 Community Development Block Grants/entitlement Grants $45,065
16.922 Equitable Sharing Program $36,333
10.553 School Breakfast Program $34,529
16.000 Domestic Cannabis Eradication and Suppression $30,000
93.747 Elder Abuse Prevention Interventions Program $22,561
15.662 Great Lakes Restoration $13,210
66.469 Geographic Programs - Great Lakes Restoration Initiative $13,161
93.788 Opioid Str $13,000
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $12,898
97.012 Boating Safety Financial Assistance $3,750
93.268 Immunization Cooperative Agreements $3,411