Corrective Action Plans

Views of Responsible Officials and Planned Corrective Actions: MARR will retain a CPA consultant to implement a full-range of controls relating to reporting, including federal program reporting. MARR will take such steps as necessary to ensure that reports are timely and accurately prepared, reviewed, and approved prior to filing. All controls, including review and approval will be documented in such documentation to be maintained.

Finding 2022-007: Reporting – Significant Deficiency. Response: 1. Staff are being trained to understand the significance of meeting deadlines. 2. New system that includes grant reporting requirements will be implemented in 2024. 3. Reporting tasks are being redistributed to assure tasks are completed by their due dates.

FINDING 2022-003 Finding Subject: COVID-19 - Education Stabilization Fund - Reporting Summary of Finding: An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. The annual Elementary and Secondary School Emergency Relief (ESSER) Data Collection reports were complied, prepared and submitted by three different staff members; however, this process was not properly designed or implemented to prevent, or detect and correct, errors. The School Corporation completed and submitted three annual Data Collection reports (Reports) for the ESSER grants. For two of the three reports tested, the report was not supported by the unit’s records. The financial information provided did not agree to the data submitted in the Reports, therefore we could not determine their accuracy. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Contact Person Responsible for Corrective Action: Matthew Miles, CFO Contact Phone Number and Email Address: 317-423-8380 mattmiles@msdlt.k12.in.us Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: The School District will work to ensure the ESSER report amounts tie to the accounting records and will improved record keeping of supporting documentation. If the amounts do not match, District will document support for all claims. Anticipated Completion Date: The School District will implement changes described in the Corrective Action Plan in February 2024.

Planned Corrective Action: We will review existing reporting procedures and ensure appropriate adjustments are made for any new federal awards’ specific reporting compliance requirements or when any existing federal awards’ specific reporting requirements are updated. Name of Contact Person: Rachel Watson, Business Office Director/Controller, watson.rachel@occ.edu Anticipated completion date: Immediate implementation of corrective action, only applicable when new funds are awarded or existing federal awards’ reporting requirements change.

FINDING 2022-007 Finding Subject: COVID-19 - Education Stabilization Fund - Reporting Summary of Finding: Finding: No oversight of reports and supporting documentation did not agrees to report submitted Recommendation: Provide oversight of reports submitted and retain supporting documentation that agrees to reports submitted Contact Person Responsible for Corrective Action: Kareemah Fowler, Assistant Superintendent of Business and Finance Deb Martin, Director of Student Learning & Title I Contact Phone Number and Email Address: Kareemah Fowler (574) 393-6088; kfowler@sbcsc.k12.in.us Deb Martin (574) 393-6053; dmartin@sbcsc.k12.in.us Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: All reports and supporting documentation, which supports each report submitted, will be reviewed/approved by the program director. All supporting documentation will be retained for future audits. Anticipated Completion Date: December 8, 2024

FINDING 2022-004 Finding Subject: Title I Grants to Local Educational Agencies - Reporting Summary of Finding: Finding: Detail data on the Form 9 and Reimbursement Request was not provided to knowledgeable individuals for review. Recommendation: Design control that provides sufficient data to knowledgeable individuals for review. Contact Person Responsible for Corrective Action: Kareemah Fowler, Assistant Superintendent of Business and Finance Contact Phone Number and Email Address: (574) 393-6088; kfowler@sbcsc.k12.in.us Views of Responsible Officials: We concur with the findings. Description of Corrective Action Plan: Form 9 Data The Human Resources Department has added a second review to verify all employee distribution codes are correct when recording/updating employee requisitions. Additionally, detailed expense reports and payroll distribution reports that support each reimbursement request are being provided to knowledgeable employees to review. Anticipated Completion Date: Completed December 8, 2023, and May 2023 Reimbursement Requests Summary level payroll data is no longer being used to support reimbursement requests. Detailed expense reports and payroll distribution reports that support each reimbursement request are being provided to knowledgeable employees to review. Anticipated Completion Date: Completed May 2023.

FINDING 2022-004 Subject: COVID-19 ? Education Stabilization Fund ? Reporting, Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting, Equipment and Real Property Management Audit Finding: Material Weakness Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting and Equipment and Real Property Management compliance requirements. Context: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Reporting The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. For both reports that were submitted, there was segregation of duties between the preparation of the report and the review and submission of the report by someone other than the preparer. However, the review was not sufficient to prevent the following error: ? In the second report, the amounts reported as expended did not agree to the underlying expenditure records of the School Corporation for ESSER I and ESSER II awards. Per discussion with the Treasurer, the amount in the report included expenditures through the report due date of May 13, 2022 rather than through the reporting period end date of June 30, 2021. This resulted in an overstatement of expenditures of $83,000 for ESSER I and $184,000 for ESSER II. Equipment and Real Property Management During our testing of equipment and real property management, it was noted that the School Corporation had not conducted a physical inventory during the last two years as required. Views of Responsible Officials and Planned Corrective Actions: We concur with the finding. Description of Corrective Action Plan: For the upcoming year 3 ESSER report that is due by April 7th, the corporation treasure will ensure that the data provided for the completion of this report only includes the correct time period information for July 1, 2021 through June 30, 2022. Southwestern superintendent, Josh Edwards, will verify the correct dates and amounts for the requested time period before submitting the report. Both the treasurer and the superintendent will review the form and sign a printed copy to be kept on file at the administration building. Inventory has in the past only been taken within certain departments. A more complete inventory will be scheduled. Southwestern superintendent, Josh Edwards, and treasurer Bonnie Thopy will research the required criteria to become compliant. Once these parameters have been established they will work within the guidelines to ensure an inventory will be completed before the next audit period. Responsible Party and Timeline for Completion: Treasurer, Bonnie Thopy, and Superintendent, Josh Edwards ? these changes will be implemented for FY2023.

FINDING 2022-016 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding Description of Corrective Action Plan: The approved grant budgets for all federal grants will be input into the financial management system and with all expenditures reported monthly from the Treasurer to the Director overseeing the federal grant for review and final approval. The Director shall be one of the approvers within the approval chain of federal grant funds the Director oversees. The Director shall be responsible for reviewing and utilizing actual expenditure reports to complete the annual reports, or any other reports, prior to another documented review by the Treasurer or CFO. All documentation related to the reports shall be maintained for future audit purposes. Anticipated Completion Date: April 2023.

FINDING 2022-014 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The approved grant budgets for all federal grants will be input into the financial management system and with all expenditures reported monthly from the Treasurer to the Director overseeing the federal grant for review and final approval. The monthly reports will then be used by the Director to generate a reimbursement request for actual expenditures. The reimbursement request must then be reviewed and signed by the Treasurer or the CFO prior to submission to the State by the Director. Anticipated Completion Date: April 2023

FINDING 2022-006 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding. INDIANA STATE BOARD OF ACCOUNTS 67 Description of Corrective Action Plan: Additional training related to grant budgets entered into and monitored within the financial software will occur, as will the new practice of having the program directors initiating monthly reimbursement requests informed by the accurate reports from the software (ledger), with documented review by the Treasurer or CFO. Additional training over the reporting requirements is taking place with the Treasurer, CFO and Directors overseeing federal funds provide accurate reporting. Anticipated Completion Date: June 2023

FINDING 2022-011 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Additional training related to grant budgets entered into and monitored within the financial software will occur, as will the new practice of having the program directors initiating monthly reimbursement requests informed by the accurate reports from the software (ledger), with documented review by the Treasurer or CFO. Additional training over the reporting requirements is taking place with the Treasurer, CFO and Directors overseeing federal funds provide accurate reporting. Anticipated Completion Date: June 2023

Corrective Action Plan Audit Finding Reference: 2022-001 Planned Corrective Action: In response to audit finding 2022-001, the University has established a system of controls. When the prior- year finding was identified, the responsible reporting officials for the institutional and student portions of HEERF funding combined report information into a single web posting request prior to the deadline each quarter. This single request provided another check for the posting official to confirm the quarterly report is comprehensive. Date of Remediation: September 2021 Contact Person Responsible: Christina Pikla

Criteria: The Partnership must establish and maintain effective internal control over federal awards that provides reasonable assurance that the Partnership is managing the federal awards in compliance with federal statutes, regulations and terms and conditions of the federal award. 2 CFR 200.327 and 2 CFR 200.328 require the auditee to collect financial information and monitor its activities under federal awards to assure compliance with applicable federal requirements and performance expectations are being achieved and report these items in accordance with program requirements. Terms and conditions of the federal award require the Hospital to maintain a debt service reserve fund as bookkeeping accounts or as separate bank accounts. Condition: During 2022, the certificate of deposit that represented the debt service reserve fund matured and the proceeds were commingled with an existing money market fund. Planned Corrective Action: Management agrees with the finding and will deposit the required debt service reserve funds in a separate bank account. Planned Completion Date: June 30, 2023 Person Responsible: Daris Rosencrance, CFO

Criteria: The Partnership must establish and maintain effective internal control over federal awards that provides reasonable assurance that the Partnership is managing the federal awards in compliance with federal statutes, regulations and terms and conditions of the federal award. 2 CFR 200.327 and 2 CFR 200.328 require the auditee to collect financial information and monitor its activities under federal awards to assure compliance with applicable federal requirements and performance expectations are being achieved and report these items in accordance with program requirements. Terms and conditions of the federal award require the audited financial statements to be provided to the federal agency annually within 150 days of fiscal year-end, as well as quarterly internal financial statements. Condition: The Partnership did not submit the audited financial statements within the prescribed period or request an extension and did not submit any quarterly reports to the federal agency. The Partnership was not asked for the information after they failed to submit it. The audited financial statements are readily available to the federal agency through the federal clearinghouse website. Planned Corrective Action: Management agrees with the finding and are implementing procedures to ensure that the required financial reports are submitted in a timely manner in accordance with the terms and conditions of the federal award. Planned Completion Date: June 30, 2023 Person Responsible: Daris Rosencrance, CFO

FINDING 2022-001 Material Weakness - Reporting Contact Person Responsible for Corrective Action: Julie Flores Contact Phone Number: 765-382-3779 Views of Responsible Official: Agree with finding Description of Corrective Action Plan: The Controller?s Office will send the monthly appropriation reports for transportation to the Administrative Assistant (AA) and to the Transportation Manager to review and reconcile. After the monthly report has been reconciled by the transportation Administrative Assistant, it will be initial and dated by the AA, the work will be forwarded to the grant administrator, transportation manager and controller?s office. The Controller?s Office will review to ensure accurate information was forwarded to the grant administrator. These changes will be reflected in the City of Marion?s Internal Control Policy. Anticipation Completion Date: 09/01/23

Contact Person Responsible for Corrective Action: Jessica Espinoza Contact Phone Number: (219) 836-9111 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: There has been turnover in the finance department and the past employees who would have been responsible for this are no longer here. There are already internal controls in place to ensure that the monthly sponsor claims submitted match the school?s meal count reports. The Treasurer will continue to ensure that everything is correctly entered before submission. Anticipated Completion Date: March 2023

The College will update the September 30, 2021 quarterly report currently posted on the website to include the estimated number of students eligible for HEERF funds. The College will post an additional report for the quarter ending June 30, 2021, indicating the receipt of funds and that no funds were distributed during the quarter.

Material Weakness: Criteria: RWHS must establish and maintain effective internal control over federal awards that provides reasonable assurance that RWHS is managing the federal awards in compliance with federal statutes, regulations and terms and conditions of the federal award. 2 CFR 200.327 and 2 CFR 200.328 require the auditee to collect financial information and monitor its activities under federal awards to assure compliance with applicable federal requirements and performance expectations are being achieved and report these items in accordance with program requirements. Terms and conditions of the federal award require the quarterly revenue on an actual and budgeted basis to be reported to the federal agency by March 31, 2023. Condition: RWHS submitted instances of inaccurate actual revenue for quarters 3 and 4 of 2021 and 2022 and inaccurate budgeted revenue for quarters 2 and 3 of 2021. Planned Corrective Action: Management will implement procedures to ensure that the required revenue totals are reported accurately in accordance with the terms and conditions of the federal award. Contact Person: Alan Townsend, CFO Anticipated Completion Date: December 31, 2023

FINDING 2022-003 Contact Person Responsible for Corrective Action: Gerri Ford Contact Phone Number: 812-937-2400 Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: The Corporation Treasurer will prepare the annual reports and ensure the amounts agree to the accounting records. The annual reports prepared by the Corporation Treasurer will be provided to the Director of Learning who oversees the Elementary and Secondary School Emergency Relief (ESSER) grant to review and approve the amounts reported are accurate. After review and approval from the Director of Learning, the annual reports will be submitted by the Corporation Treasurer. Anticipated Completion Date: May 2023

Finding 2022-005 Federal Agency Name: Department of Education Program Name: Education Stabilization Fund ALN 84.425 Finding Summary: During our testing, we noted the following issues over reporting: ? The financial data reported in the some of the quarterly reports posted for the institutional portion were not supported by the underlying trial balance activity. Responsible Individuals: Courtney Judah, Director of Institutional Effectiveness Corrective Action Plan: During internal audit of disbursements, the College identified several student disbursements that should have been recorded as emergency funds granted under the intuitional portion and not student portion. Journal entries were made to correct and change the award to the institutional portion, but failed to update the prior term report. To prevent future communication errors the team revisited the process and added a reviewing and updating of reports from prior periods. Management meet with the Grant Administrator and attended 2 webinars throughout the year to improve reporting process. Anticipated Completion Date: December 30, 2022

Finding 2022-002: Grant Program/ALN #: Grants to Provide Outpatient Early Intervention Services with Respect to HIV Disease/ALN # 93.918 Federal Agency/Pass-Through Entity: U.S. Department of Health and Human Services Federal Award ID#: 5H76HA00151-31-00; 6H76HA00151-31-01; 2H76HA00151-32-00; 6H76HA00151-32-01 Name of Contract Person: Lito Landas, Controller Management Response: The Ryan White Part C program project period ended December 31, 2021 and a new project period started January 1, 2022 with the first federal financial report due in April 2023. Starting with the new program year, Valleywise Health management will develop and implement internal controls to ensure that program income is accurately calculated and reported in the federal financial report. Proposed Completion Date: March 31, 2023

FINDING 2022-007 Contact Person Responsible for Corrective Action: Mary K. Kaczka, Assistant Director, Community Development Contact Phone Number: 574-322-4472 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Financial Reporting: Management has developed the following process to correct for the lack of evidence for review or approval for reports that are submitted: Staff responsible for preparing the report in IDIS and management responsible for review for accuracy and completeness will both sign appropriate documentation detail (PR 5 and PR 7, draw spread sheets, draw vouchers) supporting the Cash on Hand Report and the IDIS report. CDBG staff has consulted with HUD CPD staff for additional training on how to complete the PR 26 report. The training assisted staff in filing two (2) past due reports and resulted in changes to the reporting process utilized by staff. Performance Reporting: Management will address the performance reporting weaknesses by taking the following steps: The assistant director of community development will document the segregation of duties for the completion and submittal of the CAPER before submission to HUD. Documentation will consist of a clear and understandable workflow on City workpapers, and final submissions, evidenced by signature (ink or digital stamp), email string other generally acceptable audit trail. Additionally, as part of continuing education, CDBG staff participated in a workshop organized by our CDBG consultant this past June, 2023 to better understand the Section 3 reporting requirements. Special Reporting for Federal Funding Accountability and Transparency Act (FFATA): Management will address the weaknesses identified in Special Reporting for Federal Funding Accountability and Transparency (FFATA) by taking the following actions: Management will review and strengthen the current process in place for identification and timely submission of projects that qualify for FFATA reporting. Completed reports will show evidence of segregation of duty for completion, and review and approval. Anticipated Completion Date: August 31, 2023

FINDING 2022-005 Subject: COVID-19 ? Education Stabilization Fund ? Reporting Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. For the first report, the amounts reported as expended did not agree to underlying expenditure records of the School Corporation. Per discussion with the Treasurer, the amount in the report included expenditures from outside of the reporting period, resulting in an overstatement of expenditures of approximately $28,000. Additionally, for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Description of Corrective Action Plan: The treasurer will prepare the grant reporting and have the deputy treasurer review and make any corrections to the information online prior to submission. Responsible Party and Timeline for Completion: Jennifer Blakely, Treasurer, and Debbie Blevins, Deputy Treasurer ? this corrective action will be implemented for all reporting requirements immediately following the audit in March 2023.

FINDING 2022-002 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding. The School Treasurer will complete the Annual ESSER data report. The Grant Director will verify the report(s) for accuracy and completion. The Grant director will sign off on each report and then confirm via email the report(s) is correct and ready for submission to the IDOE. Responsible party and timeline for completion: Contact person responsible for Corrective Action: Patti Kappes, Treasurer Contact phone number: (812)427-4215 Anticipated completion date: April 30, 2023

Finding 2022-003 ? Education Stabilization Fund - Reporting Contact Person Responsible for Corrective Action: Mr. Patrick Culp, Superintendent Contact Phone Number: 219-279-2418 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Tri-County School Corporation will ensure someone other that the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Anticipated Completion Date: March 29, 2023