Corrective Action Plans

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

Finding 2022-002 Department of Transportation Airport Improvement Program, CFDA #20.106 AIP3-46-0050-57, AIP3-46-0050-61 Finding Summary: Federal share of expenditures reported within SF-425 annual report for grants #57 and #61 did not reconcile to supporting client records. Responsible Individuals: Dan Letellier, Executive Director Corrective Action Plan: Management will ensure correct support documentation is provided to 3rd party account for correct submission of FAA Forms 5100-126 and 127. Director will also verify that annual report form SF-425 is completed either by the Airport or the State of South Dakota DOT as it has been in the past. Anticipated Completion Date: Ongoing

INTERNAL CONTROLS OVER FINANCIAL STATEMENT PREPARATION, GRANT CLOSE OUT AND COMPLIANCE WITH RELATED PROVISIONS OF GRANTS AND CONTRACTS SHOULD BE IMPROVED HEAD START AND EARLY HEAD START PROGRAMS LOW-INCOME HOME ENERGY and WATER ASSISTANCE PROGRAM CFDA # 93.600, 93.568 and 93.499 (Questioned Costs - Undetermined) Management is in the process of assessing the organizational structure and capacity to provide adequate financial reporting. With Board review and approval of the agency?s financial funding sources, the agency will hire additional fiscal clerk to further support financial requirements and segregation of duties to ensure adequate internal controls are fully implemented. The CFO will have the overall responsibility of properly reconciling and closing out the accounting system and grant activity each month in an efficient and timely manner to eliminate the risk of significant errors occurring. Budget-to-actual schedules will be an integral part of the grant accountant analyst?s basic responsibilities. The fiscal policies and procedures will be updated with the enhancements implemented within the fiscal department. Staff will be trained on revised policies and procedures and uniform guidance regulations. The new automated financial system, will support financial reporting to meet GAAP requirements and to provide informative reports for Board and Management. All enhancements will be implemented by December 31, 2023.

FINDING 2022-003 Contact Person: Jo Ann Treon Phone Number (765)948-4632 Views of Responsible Official: We concur with the findings. Description of Corrective Action Plan: Forms RD 442-2 & RD Form 442-3 will be completed in August 2023. Anticipated Completion Date: Immediately

FINDING 2022-007 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, S425U200013 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. The amounts reported as expended on the second report did not agree to the underlying expenditure records of the School Corporation. Per discussion with the Treasurer, the amounts reported on the second report were the appropriated amounts, not the actual amounts expended during the period. Therefore, the amounts on the report were overstated by approximately 25% for ESSER I and 280% for ESSER II compared to the correct amounts on the School Corporation?s records. 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. Views of Responsible Officials and Planned Corrective Actions: We concur with the finding. Description of Corrective Action Plan: The NJ-SP School Corporation will implement effective internal controls to oversee that the federal grant information prepared and submitted is accurate and reviewed. This will be done in order to detect and correct errors that may be entered prior to submission. This will be done by having an employee prepare the Annual Data Report information while another employee reviews and approves the information before submitting. These controls will be implemented by July 1, 2023. Responsible Party and Timeline for Completion: Dalton C. Tunis ? Corporation Business Manager/Treasurer Anticipated Completion Date: July 1, 2023

FINDING 2022-003 Information on the federal program: Subject: Education Stabilization Fund - Annual Data Report 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: Material Weakness Condition: The School Corporation did not have a documented review control in place to ensure the annual data report was reviewed by someone other than the preparer and that the report was submitted timely. Context: The Annual Data Report for the period of October 1, 2020 to June 30, 2021 was due to the Indiana Department of Education (IDOE) by May 13, 2022. The School Corporation submitted the report on May 16, 2022. In addition, 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 and will take the following corrective action. Dr. Barry Stone, Director of Curriculum will prepare the Annual Data Report in a timely matter and the reports will be reviewed by Mrs. Berry, Superintendent and then signed off before submitting the report. Responsible party and timeline for completion: Federal regulation requires name and title of person overseeing corrective action plan and anticipated completion date. Dr. Barry Stone, Director of Curriculum will compile the report and Mrs. Berry, Superintendent will approve and sign off when the report is due.

FINDING 2020-002 Contact Person Responsible for Corrective Action: Shelly Harrison, Corporation Treasurer Contact Phone Number: 765-492-5102 Views of Responsible Official: We concur to the findings; however, while completing the ESSER Reports, some formatting errors of the provided spreadsheet created some questions by the North Vermillion officials prompting a clarification email to the DOE. Since the formatting errors were not addressed and all completed boxes on the North Vermillion ESSER Report spreadsheet turned green (indicating the correct amounts on the spreadsheet), the North Vermillion officials felt the ESSER report submitted was correct. Description of Corrective Action Plan: To correct the internal control issue, the Superintendent and Corporation Treasurer will work independently as well as collaboratively on the ESSER Reports. Prior to submitting any future report, the corporation officials will document their work by signing off and dating the report prior to submission to the DOE. To rectify the incorrect dollar amount on the Yearly ESSER Report Spreadsheet, the corporation treasurer and superintendent will work collaboratively to correct the amounts on either the ESSER I Year End Report and the ESSER II Year 2 and/or Year End Report. Anticipated Completion Date: Both the Internal Control and ESSER I corrective actions have been corrected, with the ESSER I Final Expenditure Report being completed and signed off on. The ESSER II corrective actions will be completed on the upcoming ESSER III Year End Report when that report is due.

FINDING 2022-003 Contact Person Responsible for Corrective Action: Jeff Gambill, Superintendent; Jennifer Barcus, Corporation Treasurer. Contact Phone Number: 812-665-3550 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Corporation Treasurer will begin reviewing all annual data reports completed by the Superintendent, prior to submission of the reports, to verify that all expenditures are reported in the correct reporting period. Anticipated Completion Date: Immediate review will begin of all annual data reports.

2022-001 ? COVID-19 ? Education Stabilization Fund - Significant Deficiency in Reporting Recommendation: The School should assign an individual to monitor reporting requirements of HEERF awards to ensure the School is in compliance. Planned Action The School plans to review enhance processes related to HEERF reporting to ensure compliance with the requirement of Section 18004(e) of the Coronavirus Aid, Relief, and Economic Security Act (CARES Act), Section314(e) of the Coronavirus Response and Relief Supplemental Appropriations Act (CRRSAA) and 2 CFR sections 200.328 and 200.329. Proposed Completion Date: The School will review processes to ensure we are in compliance by March 15, 2023.

Finding Number: 2022-004 Condition: The University did not file accurate and timely reports throughout the fiscal year. Planned Corrective Action: 1. The 9/30/21 HEERF institutional report was posted on the University?s website 10 days late. This was due to the staff member responsible going out on medical leave and miscommunication within the area on required filings. There were no additional quarterly reports to be filed so no further controls were put in place for this reporting. The annual report was filed timely. 2. The 9/30/21 institutional report has been removed from the University website as it indicated a duplicate expense that was reported on the 6/30/21 quarterly report. The 06/30/21 report has been marked as the final institutional report. 3. The Student Financial Aid (SFA) office agrees that the March 31, 2022, student website report did not include language regarding eligible students, and the reported student count was incorrect. SFA will amend the March 31, 2022, quarterly student report to reflect the correct number, add language regarding eligible students, and send the correction to the appointed HEERF email address by June 1, 2023. The Associate Director of Compliance and Training will perform a secondary review of any future reports to ensure the completeness and accuracy of the information. 4. The Student Financial Aid (SFA) office agrees that the 2021 annual report included the incorrect number of part-time graduate students who received an award, impacting the total number of students reported. The error was due to incorrectly inputting the information from the supporting data onto the annual report. SFA will amend the 2021 annual report by correcting the number of part-time graduate students by March 24, 2023. The Associate Director of Compliance and Training will perform a secondary review of the data on the annual report and compare it with the supporting documentation. 5. As indicated in the report, the University did comply with earmarking requirements. However, the categories used to report the expenditures on the 12/31/21 annual report were not the specific earmarked categories. The 12/31/21 annual report filed through the Department of Education website has just recently been made active again and the University will make necessary category reporting corrections. As the 12/31/21 annual report was the final report for institutional expenses no additional actions are required. Contact person responsible for corrective action: Colleen Scarff, Assoc VP for Business and Finance and Lana Greaves, Senior Associate Director, Student Financial Services Anticipated Completion Date: 3/24/23