Finding 485909 (2023-002)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-09-06
Audit: 318652
Organization: City of East Chicago (IN)

AI Summary

  • Core Issue: The City lacks internal controls over the CDBG Cash on Hand Quarterly reports, leading to a material weakness in reporting accuracy.
  • Impacted Requirements: Compliance with 2 CFR 200.303, which mandates effective internal controls for managing federal awards.
  • Recommended Follow-Up: Management should establish a robust internal control system, including segregation of duties, to ensure accurate reporting of PR29 reports.

Finding Text

FINDING 2023-002 Subject: CDBG - Entitlement Grants Cluster - Reporting 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-18-MC-180004, B-19-MC-180004, B-20-MC-180004, B-21-MC-180004, B-22-MC-180004, B-23-MC-180004 Compliance Requirement: Reporting Audit Finding: Material Weakness Condition and Context Recipients are required to submit quarterly the CDBG Cash on Hand Quarterly report (PR29). The report is generated from information entered by the City into HUD's Integrated Disbursement Information System (IDIS). The City did not have internal control procedures in place over the PR29 Quarterly Reports. The reports were generated and submitted by one individual, without a review or oversight process to detect and correct errors. The lack of internal controls was isolated to the quarterly reports noted above. 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 by the management of the City. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the City's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls over reporting, the City cannot ensure that the reports submitted are materially accurate and correct. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the management of the City design and implement a proper system of internal controls, including a segregation of duties, to ensure the accuracy and correctness of the PR 29 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-002 Finding Subject: Community Development Block Grants/Entitlement Grants - Program Income Summary of Finding: Internal Controls regarding Separation of Duties with the PR29 Quarterly Reports Contact Person Responsible for Corrective Action: Frank Rivera Executive Director Contact Phone Number and Email Address: 219-391-8513 Ext:2092 frivera@eastchicago.com Views of Responsible Officials: The City of East Chicago Department of Redevelopment (ECDR) concurs with the finding and ECDR will ensure compliance with the establishment of an effective internal control over Federal Award provided by Federal statutes, regulation and with the terms and conditions of the award agreement by establishing 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 Organization of the Treadway Commission (COSO) by establishing an internal control guidance ensuring a separation of duties regarding the control procedures of the PR29 Quarterly Reports. Description of Corrective Action Plan: A guidance will be developed to ensure that the regulation of an internal control is enforced regarding the separation of duties for the control procedures of the PR29 Quarterly Report being implemented by the Executive Director and the Community Development Program Manager. The process of assuring the separation of duties will consist of the Executive Director by insuring proper oversight, reviews and approvals are being adhered to and this is conducted by the process in IDIS of Certifying by the use of the user login ID and name and the Cash on Hand information that the Community Development Program Manager inserts into IDIS utilizing a user login ID and name. The separation of duties is assured by the Office of Community Planning and Development by the PR29 Summary of Submission of Cash on Hand Report illustrating the users in formulating the data for the PR29. Included in this information is a spreadsheet reflecting the current process where the Community Development Program Manager has been both the Certify User and Insert user. The Department of Redevelopment will change the current process to reflect the changes mentioned and in the spreadsheet it illustrates the changes forth coming in red fonts. Anticipated Completion Date: This will be initiated as of August 31, 2024.

Categories

Internal Control / Segregation of Duties Material Weakness Reporting Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 485908 2023-001
    Material Weakness Repeat
  • 1062350 2023-001
    Material Weakness Repeat
  • 1062351 2023-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $11.26M
14.218 Community Development Block Grants/entitlement Grants $1.24M
14.195 Section 8 Housing Assistance Payments Program $621,653
20.507 Federal Transit_formula Grants $556,750
20.205 Highway Planning and Construction $61,764
16.922 Equitable Sharing Program $33,214
93.069 Public Health Emergency Preparedness $25,000
66.472 Beach Monitoring and Notification Program Implementation Grants $19,899
16.738 Edward Byrne Memorial Justice Assistance Grant Program $10,292
14.239 Home Investment Partnerships Program $4,879
93.268 Immunization Cooperative Agreements $4,646