Corrective Action Plans

FINDING 2022-004 (Auditor Assigned Reference Number) Contact Person Responsible for Corrective Action: Greg Hunt Contact Phone Number: (219) 362-7056 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: LaPorte Community School Corporation will review the Education Stabilization Fund schedule of disbursements more closely prior to submission. Anticipated Completion Date: May 15, 2023

Finding 2022-019 U.S. Department of Health and Human Services AL No. 93.778 Medical Assistance Program (Medicaid; Title XIX) Significant Deficiency and Internal Control Deficiency over Reporting Repeat Finding: Yes Auditee?s Corrective Action Plan: BCHD will implement controls to maintain compliance with reporting requirements. BCHD will continue to work with the Department of Finance to ensure parameters for generating reports are the same and there is an agreed upon reconciliation when the parameters for reporting are not the same. Policies and procedures will be updated to ensure what is reported on Federal Financial Reports are reconciled to general ledger details in addition to ensuring all submitted reports have proper approvals documented. Accounting staff will be trained appropriately. Contact Person: Chief Financial Officer ? Unyime Ekpa Completion Date: December 2023

Finding 2022-017 U.S. Department of Health and Human Services AL No. 93.767 Children?s Health Insurance Program (CHIP) Significant Deficiency Over Reporting Repeat Finding: No Auditee?s Corrective Action Plan: BCHD will continue to work with the City's Finance department to ensure what is recorded on the general ledger reconciles to what is reported in the Form 440. The implementation of Workday Finance module should alleviate these findings. Contact Person: Chief Financial Officer ? Unyime Ekpa Completion Date: December 2023

Finding 2022-023 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Significant Deficiency in Compliance and Internal Control Over Reporting Repeat Finding: No Auditee?s Corrective Action Plan: BCHD will implement controls to maintain compliance with reporting requirements. BCHD will continue to work with the Department of Finance to ensure parameters for generating reports are the same and there is an agreed upon reconciliation when the parameters for reporting are not the same. Policies and procedures will be updated to ensure what is reported on 440 Reports are reconciled to general ledger details in addition to ensuring all submitted reports have proper approvals documented. Accounting staff will be trained appropriately. Contact Person: Chief Financial Officer ? Unyime Ekpa Completion Date: December 2023

COLEGIO LA MILAGROSA, INC. (A nonprofit organization) CORRECTIVE ACTION PLAN JUNE 30, 2022 FINDING NO. CORRECTIVE ACTION COMPLETION DATE CONTACT PERSON 2022-001: FINANCIAL STATEMENTS ? The Organization, Colegio La Milagrosa, hired a new employee. This employee is being trained to comply with the recommendations and apply them to the school year of 2021-2022. ? The Food Service area hired a new accounting company, LRR Services as of July 1, 2018 and implemented the recommendation provided by the company RRC CPA Group, PSC, and to comply with the financial processes required in the 2 CRF 200. ? Also, subsequent to June 30, 2022, an internal accountant was hired, who among other responsibilities, is coordinating and supervising the record keeping and compilation of interim and year end closing and reporting process. ? As part of our internal controls, the Food Service area has created an implemented an internal guide with procedures related for accounting processes (attached in this report). June 30th 2022 Liz M. Santiago/ Odette Y. Pacheco Torres / Lizzette Ruiz / Hector Rodriguez

Finding Reference Number: 2022-001 Federal Agency: U.S. Department of Health and Senior Services Program Name: Temporary Assistance for Needy Families Assistance Listing Number: 93.558 Responsible Official: Megan Bania, Executive Director Views of Responsible Individuals: The Board of Directors had difficulty filling the position of Finance Director in May of 2022. They hired a firm at the end of May, but the firm received very little support in making the transition to handling the SkillUp program billing from the outgoing Finance Director. Other resignations in the Finance Department left MCAN with no institutional knowledge of the billing process. The existing SkillUp program manager was not responsible and not trained in the financial reporting and billing for the program. The Board has resolved the issue by hiring a new SkillUp program manager and a new executive director.

Lack of Purchase Order Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles We will make sure that we follow our SOP and that proper controls are in place to ensure the policies and procedures are being followed. We also have a new E.D. who checks and approves every purchase order. The proper controls are now in place.

ALN Number 17.225 ? Unemployment Insurance 2022-022 ? Strengthen Controls to Ensure Compliance with Reporting Requirements for Unemployment Insurance. Cat ? L, Finding Type, A, C2 (MW, IMNC) MDES Response: During the pandemic emergency, MDES relied upon the procedures encoded in ReEmployMS to generate the non-emergency tasks. Currently, the Policy and Compliance staff conduct random reviews and tests of both files and reports for accuracy validation using samples identified by the US DOL. The ReEmployMS system generates and stores flat files containing the specific individual records to create the ETA reports. When an error occurs in the generated reports, the staff receive alerts to review the data and reconcile the report. If the system does not generate an error, the information passes as accurate and verification occurs later upon the generation of test samples. Corrective Action Plan: After the relative subsidence of the COVID-19 crisis and review of our activities, MDES better appreciates the value of ensuring that appropriate staff review reports and of maintaining documentation for each examination. Moreover, MDES currently has procedures in place to ensure the review of all reports and to document such activities.

Corrective Action Purchased orders will be prepared with the correct accounting code to reflect expenditures in the right budget line items. Person(s) Responsible Shontell McQueen, Finance Coordinator; Leslie Baynes,Chief Finance Office; Bima Baje, School Business Administrator Planned Completion Date As of July 2022, corrective action has been implemented.

2022-003 Compliance and Internal Controls over Allowable Costs and Earmarking (Significant Deficiency) Assistance Listing Number 64.033 VA Supportive Services for Veteran Families, A Supportive Services for Veteran Families ? Shallow Subsidy, and COVID ? 19 VA Supportive Services for Veteran Families 2020-2021 and 2021-2022 Funding U.S. Department of Veteran Affairs Recommendation: The Agency should establish and follow an allowable indirect allocation policy based on identifiable measures. The indirect costs charged to the grant can be substantiated by actual costs incurred. Corrective Action: Management will ensure the indirect allocation policy is correct, and actual and allowable costs will substantiate the indirect charge to grants. Responsible Party: Controller and Chief Operating Officer Date Expected to be Corrected: Immediately

FINDING NUMBER: 2022-002 Condition: The Organization is either lacking or has non-conforming written policies and procedures for the following administrative functions, required by the Uniform Guidance: 1. Financial Management - 2 CFR 200.302(b)(6) 2. Allowable Costs - 2 CFR 200.302(b)(7) 3. Federal payment - 2 CFR 200.305(b)(1) 4. Procurement - 2 CFR 200.318(a) and 2 CFR 200.318(c)(1) 5. Competition - 2 CFR 200.319(d) 5. Competition ? 2 CFR 200.319(d) 6. Methods of procurement to be followed - 2 CFR 200.320 7. Compensation (Personal Services) - 2 CFR 200.430(a)(1) 8. Compensation (Fringe Benefits - Leave) - 2 CFR 200.431(b)(1) 9. Relocation costs of employees - 2 CFR 200.464(a)(2) 10. Travel costs - 2 CFR 200.474 Planned Corrective Action: Management agrees with the finding and plans to review Uniform Guidance, modify and create policies and procedures where necessary to meet administrative Uniform Guidance requirements. The adopted policies and procedures will be reviewed and approved by the School Board of Directors at the organization?s next scheduled Board meeting. School Representative Responsible for Corrective Action: Carlos Perez, Executive Director Anticipated Completion Date: June 14, 2023

Identifying Number: 2022-002 Finding: The following discrepancies and inconsistencies were identified: administrative procedures and requirements of the grantor were not followed; there were no proper review or approval of required reporting prior to submission. Contact person responsible for corrective action: Kevyn Harmon, Senior Director of Finance & Administration Corrective Action: All personnel involved with the Title programs undergo training on the all the processes and requirements to administer the programs, and management will perform proper review of all claims for reimbursement. In additional, an annual update on the procedures and the requirements to ensure propriety and accuracy. Proposed Completion Date: EPIC Academy will complete implementation of the above procedures by November 30, 2022.

The Municipality will proceed to train the Section 8 program personnel so that they can record all the transactions through the system in order to maintain complete and accurate accounting record.

FINDING 2022-002 Finding Subject: Child Support Enforcement - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Summary of Finding: An effective internal control system was not in place at the County to ensure compliance with the requirements related to the grant agreement and the Activities Allowed or Unallowed and Allowable Costs/Cost Principles compliance requirements. The payment of the Deputy Court Clerk?s wages and benefits out of the Clerk?s Incentive Fund supplanted not supplemented the employee?s salary which is unallowable. Contractual payment did not match the amount stated in the contract. The County did not have an allowable cost policy. Contact Person Responsible for Corrective Action: James W. Bramble Contact Phone Number and Email Address: 812-462-3361 james.bramble@vigocounty.in.gov Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: Internal control procedures will be evaluated to determine needed changes to correct the above noted compliance requirements over Child Support. Changes will be made to the 2024 budget to correct the payroll related issue so the Clerk?s Incentive Fund. Contracts will be reviewed to ensure the contract amounts are current. The County will develop an allowable cost policy. Anticipated Completion Date: January 1, 2024

All federal Project and Expenditure reports were filed timely and all actual expenditures were also reported correctly according to the report overview page. This finding deals with the body of the report which incorrectly listed the Justice Center Project twice, with the obligation amount of $880,00 listed for the project. This duplicated project has been removed from future reports. The finding noted for $175,741, once again has all the correct totals in project overview report, which should be the summation of the report. We have been rehiring staff with American Rescue Plan funds since 2021, and this has been an ongoing project. Once again, the report overview page lists the correct expenditures, however the body of the report has the project listed twice. This duplicated project has been removed from future reports. The reporting software gives a total of expenditures before you hit submit on each report, this total has always displayed the correct cumulative expenditure total. If projects were entered twice, the total expenditures should of been over by these dollar amounts, and they were not.

#2022-002: Material Weakness in Controls over Compliance: Administrative Requirements of Uniform Guidance -Administrative Policies Recommendations: Grand Rapids Christian Schools should consider the following written policy additions or updates: ? Financial Management (2 CFR 200.302) The financial management policy should include records documenting compliance, and the tracking of funds to determine that expenditures are in accordance with the terms and conditions of the federal awards. The financial management and reporting system must provide the following : ? Identification - Title of the award, CFDA number ? Complete disclosure of accurate and current financial results of each federal award ? Source and application of funds for federal award activity ? Record retention and access - define the time period for which records must be kept (can vary by grant agreement), and who has the ability access the records (?200.333 - ?200.337) ? Written procedure to implement cash management requirements (see below) ? Written procedures for determining the allowability of costs (see below) ? Cash Management (2 CFR 200.305) A written policy is required by Uniform Guidance detailing the Organization's procedures to minimize the time that elapses between draw and expenditure of federal dollars. ? Allowable Costs (2 CFR 200.302(b)(7)) The Organization must have written procedures for determining the allowability of costs in accordance with Subpart E - Cost Principles of Uniform Guidance and the terms and conditions of the Federal award. This includes the determination of allowable costs and the review of this determination. The standard assumes policies and procedures are in place for disbursements, and the allowable cost policy will demonstrate how the Organization ensures compliance. The criteria for costs to be considered allowable are documented within 2 CFR 200.403. ? Procurement Standards (2 CFR 200.317 - 200.326) The Organization must have a written policy that promotes full and open vendor competition, conflict of interest policies should cover employees as well as the organization, and general purchase requirements with specific thresholds as set forth by the Uniform Guidance. There are five allowable procurement methods as described in ?200.320, depending upon the dollar value of the purchase or contract. Views of Responsible Officials and Planned Corrective Actions: ? Grand Rapids Christian Schools follows procurement and record retention standards provided by the USDA. ? GRCS does not have actual written policies and procedures for Financial Management, Cash Management, Allowable Costs, and Procurement Standards, but do have practices in place to follow USDA guidelines. In the case of cash management, the only location that takes cash is GRCHS. In that instance, along with Meal Magic, cash registers are zeroed out and balanced to Meal Magic and cash deposits are made daily. ? GRCS Business Office will work with the Food Service Director to begin formulating written policies and procedures specific to Grand Rapids Christian Schools. GRCS will utilize the resources from Uniform Guidance and Code of Federal Regulations (CFR) to develop policies that are compliant with those requirements prior to June 30, 2023.

FINDING 2022-001: THE CITY OF CULLMAN, ALABAMA WILL DEVELOP A GRANTS MANUAL OR WRITTEN POLICIES TO INCORPORATE ALL REQUIREMENTS OF 2 CFR 200 AND ENSURE COMPLIANCE WITH GRANT REQUIREMENTS.

2022-016 Finding: Program Income - ALN 14.239 ? Home Investment Partnerships Program / Department of Housing and Urban Development / Award Number: M22-MC080204 / Award Year: 2022 Status: Corrective action in progress Corrective Action: The City agrees with the finding as this was a simple oversight for the finance team due to the extreme staff shortages we?ve encountered over the last year. HOST has a process of reviewing and approving program income in Workday and associated grantor entries. We are filling vacancies to support the general ledger transactions and currently onboarding a new staff accountant to support this effort. Del Norte Loan # 34-36-01 had cash flow in 2021, and a subsequent payment due in 2022. An interest payment of $48,500 was completed credited correctly. The interest was booked in the General Ledger (GL) under HOME/GR2437 instead of NSP2/GR98, causing the NR to be inaccurately overstated in HOME/GR2437 and understated NSP2/GR98. This has been remediated going forward by practicing a process of reconciling each fund with each revenue category. Person(s) Responsible for Implementing: HOST ? Ami Webb Implementation Date: August 2023

Audit Finding 2022-002 Finding Lack of Written Policies and Procedures over Federal Awards ALN Number 21.027 ALN Name Coronavirus State & Local Fiscal Recovery Funds Questioned Costs $0 County Response Concur Status Corrective action plan in progress Corrective Action Plan In response to the finding, the County is in the process of developing written policies and procedures relative to internal controls over federal awards, to help achieve: - County wide consistency over compliance regulations and standards - Decrease the risk of grant agreement noncompliance - Reduce the risk of undetected errors in processing of financial transactions relative to federal awards. Steps taken include: - Familiarization of requirements in 2 CFR 200.303 - Obtain draft examples of policies and procedures adopted by other Counties - Discussion with governance and county attorney regarding development and adoption of policies and procedures In addition, the County is continuing to suggest departments implement effective internal control structures to - Protect assets against theft and waste - Ensure accurate and reliable operating and accounting data The conditions noted in this finding were previously reported in finding 2021-002 Completion Date Estimated June 2023 - policy written, approved by Commissioners, and disseminated ot departments Training - ongoing County Contact Becky Kersten, County Clerk

The transit will implement a standard operating procedure and do training on how to properly calculate the SEFA amounts for future audits.

Contact Person Jolene Palme, Finance Manager Corrective Action Plan We are in the process of updating the Center?s written policies and procedures to include the requirements of the Uniform Guidance. Completion Date Fiscal year end 2023

The City has identified federal grants subject to the Uniform Guidance and will develop written procedures for determining the allowability of costs in accordance with 2 CFR 200, Subpart E—Cost Principles and the terms and conditions of the Federal award.

The City has identified federal grants subject to the Uniform Guidance and will develop written procedures to implement the requirements of 2 CFR § 200.305 Payment.

Following the Auditor's recommendations and as a corrective action, the staff or department in charge locate and document all required reports that were filed according to the requirements of the grant agreement, including the reconciliation thereof with the official Municipality’s accounting subsidiaries. In addition, the Municipality will design, document, establish and provide the necessary and required training, including guidelines and procedures, to all personnel who work directly or indirectly with the management of these federal funds.

Following the Auditor's recommendations and as a corrective action, the staff or department in charge locate and document all required reports that were filed according to the requirements of the grant agreement, including the reconciliation thereof with the official Municipality’s accounting subsidiaries. In addition, the Municipality will design, document, establish and provide the necessary and required training, including guidelines and procedures, to all personnel who work directly or indirectly with the management of these federal funds.