Corrective Action Plans

FINDING 2022-003: Significant Deficiency in Internal Control Over Financial Documentation Recommendation: Implement enhanced procedures for the systematic maintenance and retrieval of all financial records related to expenditures, including staff training on these protocols. Action Taken: Management agrees with the auditor’s finding and recommendation. The newly appointed Deputy Director of Finance will oversee the implementation of these enhanced procedures.

Management agrees with the findings and has already initiated corrective actions. Moving forward, budget-to-actual comparisons will be prepared monthly, and any discrepancies will be addressed promptly. The organization will work closely with the cognizant agency to arrange for the return of any unobligated funds or, if applicable, seek authorization to retain the funds for use in other similar programs. This process will ensure proper financial management and compliance.

The organization has already taken steps and will continue to take immediate action to establish a formal risk management framework. This will include conducting a comprehensive fraud risk assessment and integrating fraud detection and prevention processes into the organization’s internal controls. A formal risk management policy will be developed and adopted within three months, with regular reviews scheduled thereafter to ensure its continued effectiveness and alignment with industry best practices.

FA 2022-001 Strengthen Controls over Expenditures Compliance Requirement: Activities Allowed or Unallowed Allowable Costs/Cost Principle Procurement and Suspension and Debarment Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education Assistance Listing Number and Title: COVID-19 - 84.425D - Elementary and Secondary School Emergency Relief Fund Federal Award Number: S425D210012 (Year: 2021) Questioned Costs: $189,893 Description: The policies and procedures of the School District were insufficient to provide adequate internal controls over expenditures as it relates to the Elementary and Secondary School Emergency Relief Fund program. Corrective Action Plans: Management has implemented internal controls procedures to ensure transactions are properly processed and reported. Additional procedures have been established to review transaction to make they align with the approved budget. Estimated Completion Date: June 30, 2024 Contact Person: Georgette Evans Telephone: 478-374-3783 Email: gevans@dodge.k12.ga.us

FINDING 2022-006 Finding Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Suspension and Debarment Summary of Finding: Material Weakness, Modified Opinion An effective internal control system, which would include segregation of duties, was not in place at the County in order to ensure compliance with requirements related to the grant agreement and the procurement and suspension and debarment compliance requirement. Prior to entering into subawards and covered transactions with Coronavirus State and Local Fiscal Recovery Funds (CSLFRF), SLFRF funds, recipients are required to verify that contractors and subrecipients are not suspended, debarred, or otherwise excluded. Upon inquiring of the County to determine its policies and procedures related to suspension and debarment requirements for the Coronavirus State and Local Fiscal Recovery Funds (CSLFRF), SLFRF funds, the County stated procedures were not in place to ensure vendors were not suspended or debarred prior to entering into covered transactions. The County had not performed procedures to ensure the vendors were not suspended or debarred or otherwise excluded or disqualified from participation in federal assistance programs or activities during the audit period on all of the four vendors tested, that were paid with SLFRF Funds. Contact Person Responsible for Corrective Action: Timothy Stabosz Contact Phone Number and Email Address: 219-326-6808 x2226 tstabosz@laporteco.in.gov Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: To correct this finding, we will begin doing a search on sam.gov to find out if a vendor has been suspended or disbarred. We will also add language to bid and/or contracts to require vendors to supply proof of being in good standing with the federal government. Anticipated Completion Date: The above plan of action will begin on November 21, 2024.

FINDING 2022-005 Finding Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Summary of Finding: Material Weakness, Modified Opinion The County did not have an effective internal control system to ensure compliance with the Reporting compliance requirement. Recipients are required to submit quarterly or annually Project and Expenditure (P&E) Reports to the Department of the Treasury (Treasury). The County submitted four quarterly P&E Reports during the audit period. The County's process for the completion and submission of the P&E Reports was that the County Auditor prepared each P&E Report based on the County's Financial Ledgers, without a proper oversight or review process in place prior to submission. All four quarterly reports that were due during the audit period were not properly supported by the County's records Contact Person Responsible for Corrective Action: Timothy Stabosz Contact Phone Number and Email Address: 219-326-6808 x2226 tstabosz@laporteco.in.gov Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: To correct this finding, we will require one person to complete the report and another to review the report prior to submission. Anticipated Completion Date: We will begin requirement a review prior to submission as of November 21, 2024.

2022-001 – Internal Controls over Allowable Costs Individuals Responsible for Corrective Action Plan: J. Neal Bolton, Director of Revenue Management & Budget Shemaine Rose, Controller Anticipated Completion Date: December 2024 In order to ensure expenses are only counted once, a check will be added to future reporting to ensure the total of all expenses equals the total amount of expenses allocated by category. This check will be confirmed by two individuals independently before submission.

Condition and Context: The System did not complete the PRF Periods 2 and 3 reporting in accordance with the U.S. Department of Health and Human Services guidance. The System did not enter the correct amounts from its data supporting lost revenues for all quarters. We note that many of these amounts carried forward in the PRF reports from errors made in the PRF Period 1 reporting. The adjustments needed within the PRF reports to correct the errors noted for PRF Periods 2 and 3 are as follows: (1) lost revenues for the period of availability should decrease from $13,866,058 to $2,405,798 and (2) unused lost revenues should decrease from $12,493,140 to $1,032,880. Furthermore, errors in reporting total revenues by quarter led to errors in the allocation among payers by quarter. Corrective Action Plan: System management agrees with the finding and has updated its lost revenue calculation, with cumulative amounts through Period 6 reporting. While management did attempt to update its lost revenue amounts with filing of its Period 4 reports, additional data entry errors were made. As such, the lost revenue schedules maintained by the System (which are available upon request) provide the final source of information related to the calculation of lost revenue by quarter, by entity, and by payor.

2022-002 Material Weakness in internal controls over compliance with period of performance. Name of Contact Person: Chris Conley, Chief Accountant. Corrective action: To ensure this does not occur again, the City Accountant and Chief Accountant will review all journal entries to make sure that expenses are charges with the appropriate project period and with the definitions of the grant. We will train and have training documents for the City Accountant when the come into this position. Proposed Completion Date: Immediately. Implementation date: Immediately.

Management Response and Corrective Action Plan City's Response: The City concurs with the recommendation. Corrective Action Plan: The recommendations are included in the new grants policy. The City Manager shall review and approve it for implementation by March 2025. Planned Implementation Date: March 2025 Responsible Person(s): City Manager

The County will implement procedures to ensure the review and approval of the monthly report is documented.

The County will implement procedures to ensure the approval process is documented.

The County will implement a new policy to ensure all subrecipients that are given federal funds of $25,000 or more are properly monitored.

The County will implement a new policy to verify vendors are not suspended or debarred.

Management accepts the finding and notes that the prior year finding was not reported until near the end of the current audit period, contributing to the repeat finding. Effective in June 2022, payroll authorizations were directed through the PeopleSoft system to the Payroll Manager who prepared and documented the necessary allocation calculation. This calculation, along with a copy of the original payroll authorization for the employee and the superseding payroll authorization were sent to the Associate Controller for review and verification. This secondary review was marked approved and returned to the Payroll Manager for final entry in the payroll system and records archiving. Further, a campus committee with representatives from the offices of; Controller, Information Technology, Sponsored Research Services, Payroll and Academic Affairs Operations was formed to further review and address this prior year finding. The Committee has developed a form within PeopleSoft that will allow for entering payroll authorization data, system calculation of applicable fringe adjustments, and a system driven workflow review and approval process from initial entry by the Principal Investigator to approval by Sponsored Research Services to the approval by either the Research Accountant or the Associate Controller for posting of all prior period reallocations. Any adjustments affecting future periods will be processed through the existing payroll authorization process and system entered by the Payroll Office. This cost transfer process was implemented on April 1, 2023. A further enhancement of automating a portion of the related journal entry posting upon final approval by the Research Accountant or Associate Controller was implemented in June 2023. In light of the repeat finding, the University engaged an outside firm, Bowers and Company CPAs PLLC in May 2023, to conduct an internal review evaluation of the Payroll Department with a focus on reviewing assessing current internal controls and processes from employees set up through issuance of compensation and filing of state and federal forms relating to payroll procedures and transactions. The outcome of this review was to identify areas of potential weakness, process improvement, and current utilization of existing financial systems and tools. The results of this review evaluation were received in August 2023. In the limited scope review they identified no reportable findings and provided several recommendations to improve University-wide payroll processes. The implementation of these recommendations improved University-wide payroll processes. Additionally, we carried out an internal audit encompassing all federally funded research payroll transactions involving students, staff, and research faculty for the fiscal year 2022. We compared payroll authorizations against the actual payroll amounts for a total of 231 faculty, staff and students. We identified 6 findings, in addition to the findings from KPMG during the initial audit, between payroll authorizations or graduate appointments and the actual amounts charged to federal accounts, which is an overall error rate of 5.6%. Clarkson’s Payroll Department is conducting monthly review of allocations in payroll to proactively identify errors, aiming to facilitate prompt corrections. In addition to the monthly review, Sponsored Research Services will continue in processing cost transfers whenever errors are identified, necessitating adjustments to the allocation of payroll to federal awards.

Management accepts this finding. A detailed set of procedures was documented immediately after the discovery of this error in preparing the Schedule. Included in these procedures, a query is run of research projects. This query is sent to Sponsored Research Services (SRS) to review to verify the reporting status and AL numbers, and other items are correct and complete. Once SRS has verified the data in the query is complete and accurate, then the Controller’s office will proceed with preparing the Schedule as well as reconciling it to the Statement of Activities (SOA) In the procedures, we have added that SRS and the Controller, and/or Chief Financial Officer review the Schedule prior to initiation of the audit review process.

We agree that CAC did not summarize agency wide or program specific internal controls and reporting requirements as required by 2CFR 200.303 and the CAC Management Services Manual. In order to ensure that the reporting requirements and specific internal controls of all awards made to CAC are summarized in adherence to 2 CFR 200.303 and the CAC Management Services Manual, the following corrective action will be implemented: Beginning in the FY2025 fiscal year, CAC will add a senior level staff position designated as Director of Compliance. The Director of Compliance will review and update current policies and procedures regarding specific internal controls, compliance reporting and eligibility for all awards received by CAC. The Director of Compliance will work with the Chief Program Officer and the Chief Financial Officer to ensure the development and application of program specific procedures and internal controls for reporting and determining eligibility for federal award programs. The projected date for full implementation of the corrective action plan for this finding is June 30, 2025. The contact persons for this corrective action are: Barbara Kelly, Executive Director, Windie Wilson, CAC Human Resources Director, Misty Goodwin, CAC Chief Program Officer, David Mincey, CAC Fiscal Services Manager/Internal Auditor, CAC Director of Compliance, to be selected.

Condition and Context: The System did not complete the PRF Period 1 reporting in accordance with the U.S. Department of Health and Human Services guidance. The System did not enter the correct amounts from its data supporting lost revenues for all quarters; it also did not enter the correct amounts from its data supporting eligible expenditures. The adjustments needed within the PRF reports to correct the errors decreased year over year lost revenues from $21,664,944 to $11,771,346 and decreased eligible expenditures from $7,527,194 to $4,334,813, on total distributions of PRF funding of $14,972,846. In summary, the data supporting amounts for lost revenues and eligible expenses totals $16,104,159 on total distributions of PRF funding of $14,972,846 in this reporting period. Corrective Action Plan: System management agrees with the finding and has updated its lost revenue calculation. Management attempted to update lost revenue amounts with filing of its Period 4 reports; however, additional data entry errors were made. Management has worked extensively over the past two years to monitor the changing guidelines surrounding the various programs designed to respond to the COVID-19 pandemic. Management has furthered this effort by attending continuing professional education on this topic and reading available guidance to ensure that the final recordkeeping maintained by the System follows the guidance as established by HRSA.

FINDING 2022-006 Finding Subject: Emergency Rental Assistance Program -- Reporting Summary of Finding: Condition and Context: Recipients are required to submit FFATA (Federal Funding Accountability and Transparency Act) reporting through the FSRS (FFATA Subaward Reporting System) website to the U.S. General Services Administration. This reporting is required to be completed for each action based on subawards of $30,000 or more that are made from the federal program. Information to be reported included the information contained within the subaward. The County did not have any policies or procedures in place related to the FFATA reporting requirements. During the audit period, the County was required to submit the FFATA reporting for one subaward that was over $30,000. The County, however, did not submit the required report on the FSRS website. Recommendation: We recommended that management of the County design and implement a proper system of internal controls, to ensure that all subrecipients awarded $30,000 or more are properly reported in accordance with FFATA reporting requirements. Contact Person Responsible for Corrective Action: Timothy A. Brown Contact Phone Number and Email Address: 219-755-3225 and brownta@lakecountyin.org Views of Responsible Officials: LCCEDD concurs with the audit finding. Description of Corrective Action Plan: LCCEDD staff will be preparing an amendment to the policy and procedures manual to follow the FFATA regulations for all of the department sub-recipients (social service agencies) including the CDBG partner communities. The process will include review of all sub-recipient agreements by the Deputy Director who will provide to the Fiscal Officer a copy of the approved and signed agreement. The Fiscal Officer will work with the Bookkeeper to record the agreements into the FFATA Subaward Reporting System (FSRS). LAKE COUNTY COMMUNITY ECONOMIC DEVELOPMENT DEPARTMENT 2293 N. Main Street - Crown Point, In 46307 Tel. (219) 755-3225 www.lakecountyin.org INDIANA STATE BOARD OF ACCOUNTS 43 Anticipated Completion Date: A policy and procedure amendment will be written by the end of this year and presented to the Lake County Redevelopment Commission for their January 2025 meeting for adoption. LCCEDD staff will start reporting into FSRS all sub-recipient for FY2023 and FY2024 once the policy and procedure amendments are approved.

FINDING 2022-005 Finding Subject: CDBG ‐ Entitlement Grants Cluster ‐ Period of Performance Summary of Finding: The county did not have properly designed internal controls in order to prevent or detect errors in the general ledger for activities related to adjustments to Community Development Block Grant funds during the transition and implementation of the Oracle accounting system. Contact Person Responsible for Corrective Action: Dan Ciecierski, Comptroller Contact Phone Number and Email Address: 219-755-3137 | ciecidx@lakecountyin.org Views of Responsible Officials: We concur with the finding. Explanation and Reasons for Disagreement: N/A Description of Corrective Action Plan: Lake County has begun execution of a comprehensive strategy in order to address the lack of internal controls around its financial transactions and reporting in a number of ways. The following will address control issues identified in these areas: - Financial Transactions and Reporting - Employee Benefit Accrual (EBA) Fund - Cash and Investments - Receipts - Journal Entries - Financial Statement & Reporting First, a more qualified consulting firm has been hired to assist on two important fronts related to the new accounting system: 1. The first is the reimplementation of the Oracle accounting software which is inclusive of correcting data and poor configurations from the prior consultant, and deploying additional appropriate functionality to allow the County to optimize Oracle to suit the accounting needs from a process standpoint as well as an internal control perspective. Oracle in and of itself allows the county to implement strategic preventative internal controls via role-based access features. Said differently, Oracle has a more robust and granular ability to automatically create separation of INDIANA STATE BOARD OF ACCOUNTS 41 duties among employees and departments simply by restricting the ability to perform actions which should be naturally segregated to mitigate risk of error. 2. Secondly, the managed services portion of the consulting contract will aid the County in running the business activities related to both the Oracle Human Capital Management (HCM) module and the Enterprise Resource Planning (ERP) module (Purchasing, Accounts Receivable, Accounts Payable, and General Accounting). Another initiative being executed to address the lack of internal controls is to attract, and hire qualified professionals who have years of real world, practical experience in the field for which a job relates to. During the original implementation of the Oracle system there was no one who fully understood, nor had a background in the professional field of accounting in the Auditor’s Office. The County has hired a Comptroller who passed the CPA, and has spent their entire career in the field of accounting. This individual has worked in the corporate utility and banking industries and has experience in GAAP reporting, regulatory reporting, internal controls, and overall general accounting. Additionally, the Comptroller has been involved with internal and external audit compliance as well as the installation, user acceptance testing, and transition of new accounting software. In order to mitigate the risk of error for any adjusting entries made which are recommended by consultants, the Comptroller of Finance must review and approve these entries. Anticipated Completion Date: 1. This process has already been put into place and is being executed.

FINDING 2022-004 Finding Subject: CDBG – Entitlement Grants Cluster—Reporting Summary of Finding: Condition and Context: The County did not have internal control procedures over the Quarterly Reports (PR29), IDIS Section 3 Performance Report, and NSP Quarterly Reports. One individual prepared or generated the report without a review or oversight process. Additionally, the County’s internal controls were not consistently documented over the draw down requests for the CDBG grant during the audit period. The draw down requests were entered into IDIS, which then becomes the basis for several of the reports. The 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 thirteen reimbursement requests tested, control documentation for eight of the requests were printed and signed during current period, after the documentation was requested. The creation of documentation of the control procedure did not support that internal controls were effective during the audit period. 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. Contact Person Responsible for Corrective Action: Timothy A. Brown Contact Phone Number and Email Address: 219-755-3225 and brownta@lakecountyin.org Views of Responsible Officials: LCCEDD concurs with the audit finding. Concurrence: The Fiscal Officer from the Audit Period was new to the position and her training was focused on the changes to the financial systems at the county over the DRGR quarterly reporting of NSP actions. Further, Finding 2022-003 also caused some of the reporting issues with CDBG of having two CDBG funds and posting errors to these funds. The current LCCEDD Fiscal Officer found the problems during the audit and corrective actions were done retroactively to address this part of the finding with the drawdown requests. The CDBG drawdowns were submitted into IDIS by the Fiscal Officer who printed out the drawdown request. These printouts were then given to the Executive Director or the Deputy Director who then went into IDIS and approved the drawdown request, then print out the IDIS drawdown approval and return the request and the signed approval back to the Fiscal Officer. LAKE COUNTY COMMUNITY ECONOMIC DEVELOPMENT DEPARTMENT 2293 N. Main Street - Crown Point, In 46307 Tel. (219) 755-3225 www.lakecountyin.org INDIANA STATE BOARD OF ACCOUNTS 38 Description of Corrective Action Plan: LCCEDD staff have already adopted changes in internal controls to correct the CDBG reporting deficiencies as described in Finding 2022-003. Further, management will oversee compliance with current policies and the new quarterly reconciliations. LCCEDD policies will be updated to make the following changes: General Management and Oversight: On an on-going basis, the Director will meet with Department staff to determine if training or technical assistance is needed to complete HUD reporting requirements in a timely and accurate manner. NSP Quarterly Reports: To be followed until the HUD field office indicates QPR reports are no longer needed due to grant closeout: 1. Before the close of each month, the Fiscal Officer will create receipts and draws as needed in HUD’s DRGR system to reflect funds receipted or expended by the County. 2. At the close of each quarter, the Fiscal Officer will prepare and submit the quarterly report in DRGR for the NSP1 and NSP3 grant allocation. To prepare the report, the Fiscal Officer will reconcile all expenses and receipts posted in the County’s general ledger system for the NSP programs with the receipts and drawdown requests recorded in in HUD’s DRGR reporting system. 3. Before submitting the NSP QPR Report in the DRGR system, the Deputy Director will review and approve the prepared reconciliation and QPR Report. Any discrepancies between the two systems will be reported to the Auditor and the Department Director to determine corrective actions. 4. Within 30 days of the close of each calendar quarter, the Fiscal Officer will submit the NSP QPR Report via DRGR. The Fiscal Officer will maintain a copy of the NSP QPR and the corresponding reconciliation in their program files. Cash on Hand Reports: 1. At the close of each quarter, the Fiscal Officer will prepare and submit the Cash on Hand Report within thirty days of the close of the quarter. The Fiscal Officer will reconcile all expenses and receipts posted in the County’s general ledger system with the receipts (report PR09) and drawdown requests (report PR07) in HUD’s IDIS Online reporting system. 2. Before submitting the Cash on Hand Report in the IDIS Online system, the Deputy Director will review and approve the prepared reconciliation and Cash on Hand Report. Any discrepancies between the two systems will be reported to the Auditor and the Department Director to determine corrective actions. 3. Within 30 days of the close of each calendar quarter, the Fiscal Officer will submit the Cash on Hand Report via IDIS Online. The Fiscal Officer will maintain a copy of the Cash on Hand report and the corresponding reconciliation in their program files. INDIANA STATE BOARD OF ACCOUNTS 39 Section 3 Reporting: 1. As part of the application review, the Deputy Director will determine the applicability of the Section 3 requirements for each proposed project. 2. For projects where Section 3 is applicable, the Deputy Director will ensure that staff administering the project are familiar with the Section 3 requirements and understand the forms and reporting required to properly report Section 3, including the determination of total labor hours worked, labors hours worked by Section 3 and Targeted Section 3 workers, and corresponding certifications. 3. The County will collect Section 3 reports from subrecipients administering projects throughout the period of performance. If the project meets Section 3 benchmarks, the County will consider the activity to be in full compliance with Section 3. If the project does not meet one of the Section 3 benchmarks, the County will require reporting on the qualitative efforts that the subrecipient made to try to reach the benchmarks. 4. Section 3 information collected for each project will be reported in IDIS Online. The Section 3 information must be reported annually before the submission of the annual report (CAPER) to HUD. Anticipated Completion Date: Part of the corrections have already been put into place and the Policy and Procedure Manual will be amended in April of 2025 after the Lake County Redevelopment Commission adopts appropriate changes.

FINDING 2022-003 Finding Subject: CDBG – Entitlement Grants Cluster—Program Income Summary of Finding: Condition and Context: The County received program income through various loan programs it offered to qualifying individuals. Once the County received a loan payment, the receipt was posted into the financial accounting system of the County and recorded in a grant fund. The amount received was also to be recorded in the Department of Housing and Urban Development’s (HUD) Integrated Disbursement & Information System (IDIS) website. The recorded program income in IDIS would then appear on the Drawdown Report by Voucher Number report (PR07). No internal control process had been established over the program income compliance requirement. One individual was responsible for notifying the Auditor's office when program income money was received, in order for it to be receipted in the County’s financial accounting system. The same individual was also responsible for reporting the same on IDIS site. No controls were established to ensure the program income that was recorded in the financial accounting system was also reported on IDIS site and the PR07 report. Additionally, four receipts totaling $38,960 were selected for testing from the County’s receipt ledger. These four receipts were unable to be located on the PR07 report provided for audit. One of the four receipts was recorded in the IDIS system after information regarding the receipt was requested. The receipt was not in the PR07 report that had been provided for audit when we were provided information documenting it being recorded in IDIS. Furthermore, we were unable to verify the total amount recorded in receipt ledger to the total reported on PR07 report. The County’s ledger was greater than the PR07 report by $30,324 and is primarily attributed to under reporting of program income in IDIS as identified above. Recommendation: We recommended that the management of the County establish a system of internal controls to ensure that all program income received is properly reported in the IDIS system and expended prior to drawing down federal awards. Contact Person Responsible for Corrective Action: Timothy A. Brown Contact Phone Number and Email Address: 219-755-3225 and brownta@lakecountyin.org Views of Responsible Officials: LCCEDD concurs with the audit finding. LAKE COUNTY COMMUNITY ECONOMIC DEVELOPMENT DEPARTMENT 2293 N. Main Street - Crown Point, In 46307 Tel. (219) 755-3225 www.lakecountyin.org INDIANA STATE BOARD OF ACCOUNTS 36 Description of Corrective Action Plan: LCCEDD staff have already adopted changes in internal controls to correct the Program Income reporting deficiencies. The process is as follows: 1. All incoming checks into the department are first reviewed by the Deputy Director. The Deputy Director determines the source of income (i.e. CDBG, HOME, NSP) and the correct receipt type (program income, repayment, homebuyer). The Deputy Director records the IDIS number of the project on the check before giving it to the Fiscal Officer. 2. The Fiscal Officer records the receipt on an internal schedule of receipts and submits the check to the County Auditor with the check deposit form with the IDIS number and correct fund and account number for deposit. 3. Once the County Auditor posts the receipt to the County’s general ledger, the Fiscal Officer records the Auditor’s receipt into HUD’s IDIS Online reporting system. 4. At the close of each quarter, the Fiscal Officer will prepare and submit the Cash on Hand Report within thirty days of the close of the quarter. The Fiscal Officer will reconcile all expenses and receipts posted in the County’s general ledger system with the receipts (report PR09) and drawdown requests (report PR07) in HUD’s IDIS Online reporting system. Before submitting the Cash on Hand Report in the IDIS Online system, the Deputy Director will review and approve the prepared reconciliation and Cash on Hand Report. Any discrepancies between the two systems will be reported to the Auditor and the Department Director to determine corrective actions. 5. Within 30 days of the close of each calendar quarter, the Fiscal Officer will submit the Cash on Hand Report via IDIS Online. The Fiscal Officer will maintain a copy of the Cash on Hand report and the corresponding reconciliation in their program files. 6. On an on-going basis, the Director will meet with Department staff to determine if training or technical assistance is needed to complete HUD reporting requirements in a timely and accurate manner. Anticipated Completion Date: A policy and procedure amendment will be written by the end of this year and presented to the Lake County Redevelopment Commission for their March 2025 meeting for adoption.

Federal Award Finding and Questioned Costs Finding Reference: 2022-004 – Other finding – SEFA Preparation Federal Program Information Federal Agencies: United States Department of Homeland Security Awards: Assistance Listing Number 97.036 – COVID-19 – Disaster Grants - Public Assistance (Presidentially Declared Disasters) Award Periods: January 20, 2020 – May 11, 2023 Description: Preparation of Schedule of Expenditures of Federal Awards Type of Finding: Material Weakness in Internal Control Over Compliance Recommendation The System should update its policies and procedures and internal controls, specifically the process to accumulate and report FEMA expenditures of federal awards to be in accordance with the FEMA Schedule requirements outlined above. View of responsible officials The System agrees with the comment and has developed a plan to correct the finding. Corrective Action Planned The System has trained all applicable staff on the appropriate interpretation of FEMA Public Assistance Grant Program guidance for reporting Assistance Listing 97.036 expenditures in the SEFA. Name(s) of the Contact Person(s) Responsible for Corrective Action: Christopher T. Smith, Vice President of Finance and Corporate Controller, 571-472-8122. Planned completion Date for Corrective Action Planned: Ongoing with completion date of December 31, 2024

2022-019 U.S. Department of Health and Human Services, passed through Kansas Department of Aging Aging Cluster - ALN 93.045 - Special Programs for the Aging _Title III, Part C_Nutrition Services - 2201KSOAHD Management’s Response: Management will work with Aging to make sure they are tracking and reporting time correctly in accordance with the award parameters. Views of Responsible Officials and Corrective Action: Department personnel will need training on how to report time correctly in the payroll system to adhere to award parameters. Management will ensure this is addressed by December 31, 2024. Responsible Official: Dr. Shelley Kneuvean Chief Financial Officer Unified Government of Wyandotte County & Kansas City KS

Finding 2022-018 U.S Department of Housing and Urban Development Emergency Solutions Grant Program - 14.231, Award number E-22-MC-0001 COVID-19 Emergency Solutions Grant Program - 14.231, Award number E-20-MW-20-0001 Management’s Response: Management will work with Procurement & departments to make sure debarment checks are completed. Views of Responsible Officials and Corrective Action: Departmental stakeholders should work with central accounting to be sure payments are made in time and develop solutions where there could potentially be a shortfall. Management will ensure this is addressed by December 31, 2024. Responsible Official: Dr. Shelley Kneuvean Chief Financial Officer Unified Government of Wyandotte County & Kansas City KS