Finding 1081261 (2022-004)

Material Weakness
Requirement
L
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 reporting for CDBG grants, leading to a material weakness.
  • Impacted Requirements: Compliance with 2 CFR 200.303 and 2 CFR 200.1 regarding internal controls and reporting reliability.
  • Recommended Follow-Up: Management should establish and document a robust internal control system to ensure compliance with reporting requirements.

Finding Text

FINDING 2022-004 Subject: CDBG - Entitlement Grants Cluster - Reporting Federal Agency: Department of Housing and Urban Development Federal Programs: Community Development Block Grants/Entitlement Grants; COVID-19 - 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, B-20-UW-18-0016 Compliance Requirement: Reporting Audit Finding: Material Weakness Condition and Context The County did not have internal control procedures over the Quarterly Reports (PR29), the IDIS Section 3 Performance Report, and the NSP Quarterly Reports. One individual prepared or generated the report without a review or oversight process. INDIANA STATE BOARD OF ACCOUNTS 23 LAKE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Additionally, the County's internal controls were not consistently documented over the drawdown requests for the CDBG grant during the audit period. The drawdown requests were entered into the IDIS, which then became the basis for several of the reports. The internal control presented by the County was that one individual prepared and entered the request, which would then be printed, and another individual would review and sign the printed request to document the review. Of the 13 reimbursement requests tested, internal control documentation for 8 of the requests was printed and signed during the current period, after the documentation was requested. The creation of documentation of the internal control procedure did not support that internal controls were properly implemented and effective during the audit period. The lack of internal controls were systemic issues 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). . . ." 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 A turnover of staff in the County's Community Development office, and management not ensuring that a system of internal controls that segregated key functions was designed, implemented, and operating effectively, contributed to the program income issue identified above. 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. INDIANA STATE BOARD OF ACCOUNTS 24 LAKE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 reporting requirements. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Categories

Cash Management Internal Control / Segregation of Duties Material Weakness Reporting Matching / Level of Effort / Earmarking Program Income

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
  • 1081262 2022-005
    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