Corrective Action Plans

Action Plan: We will work with our departments to ensure that controls for grants are documented with written procedures. These procedures will include the title of the positions responsible for each control (preparation, review, reconciliation, etc.) and will require that the performance of the controls be documented in a clear, re-performable manner with the name of the responsible individuals, the specific control(s) they performed over compliance for the grant, and the date(s) the controls were performed. Contact Names Responsible for the plan - Marcia Saulo Anticipated completion date of the plan - September 20, 2024

Action Plan: We will work with our departments to ensure that controls for grants are documented with written procedures. These procedures will include the title of the positions responsible for each control (preparation, review, reconciliation, etc.) and will require that the performance of the controls be documented in a clear, re-performable manner with the name of the responsible individuals, the specific control(s) they performed over compliance for the grant, and the date(s) the controls were performed. Contact Names Responsible for the plan - Marcia Saulo Anticipated completion date of the plan - September 20, 2024

CFDA No. and Name: 10.691 Good Neighbor Authority Responsible Persons: Siri Mullaney, Finance Director Anticipated completion date: June 30, 2023 Corrective Action: Concur. In fiscal year 2023, the Flood Control District was moved from the Public Works Department and formed into a stand-alone department, allowing for the hire of new staff dedicated to the management of federal awards. This increase in oversight will provide the capacity to accurately account for federal awards and comply with requirements such as adherence to the award start and end dates and the receipt of pre-approval by the federal agency for pre-award costs. The County will continue to provide technical assistance and resources to departments managing federal awards.

Department of the Treasury ? CDFI Fund Grant Vantage West Credit Union respectfully submits the following corrective action plan for the year ended December 31, 2022. Name and address of independent public accounting firm: Doeren Mayhew 305 West Big Beaver Rd., Ste. 200 Troy, MI 48084 Audit period: January 1, 2022 ? December 31, 2022 The finding from the December 31, 2022 schedule of findings and questioned costs are discussed below. The finding is numbered consistently with the number assigned in the schedule. FINDINGS?FEDERAL AWARD PROGRAMS AUDITS DEPARTMENT OF TREASURY CDFI Program ? CFDA No. 21.024 Significant Deficiency: See Finding 2022-001. Recommendation: Complete established procedures to identify and track eligible loans deployed during the RRP grant performance period and reconcile the totals to the underlying loan data. Action Taken: Vantage west will enhance its reporting to our third party CDFI reporting consultant to clarify and fully define borrower data points, in support of improving the accuracy of financial products reported annually on the Performance Reports to the CDFI Fund.

Finding Reference Number: 2022-004 Description of Finding: Per the Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance (as approved and documented under OMB PRA number ? OMB #1505-0271), quarterly Project and Expenditure Reports are due to the Treasury by the last day of the month following the end of the period covered, and the funds may be used to cover eligible costs incurred between March 3, 2021 and December 31, 2024. Statement of Concurrence of Non-compliance: The City works in good faith to report in a timely manner on all grants as required. There was an issue with the login information and password that was not responded to until after the reporting date. The City was under the impression using the interim final rule that costs associated as of the beginning of the pandemic were applicable costs. As such, we agree with this finding. Corrective Action: The City has since reported on time, testing login information prior to the due date to ensure that there are no issues with login or password. We will be reviewing all costs associated during the applicable time frame and utilizing other related costs left off reporting and resubmitting to the US Treasury.

Finding Reference Number: 2022-001 Description of Finding: Per the Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance (as approved and documented under OMB PRA number ? OMB #1505-0271), quarterly Project and Expenditure Reports are due to the Treasury by the last day of the month following the end of the period covered, and the funds may be used to cover eligible costs incurred between March 3, 2021 and December 31, 2024. Statement of Concurrence of Non-compliance: The City works in good faith to report in a timely manner on all grants as required. There was an issue with the login information and password that was not responded to until after the reporting date. The City was under the impression using the interim final rule that costs associated as of the beginning of the pandemic were applicable costs. As such, we agree with this finding. Corrective Action: The City has since reported on time, testing login information prior to the due date to ensure that there are no issues with login or password. We will be reviewing all costs associated during the applicable time frame and utilizing other related costs left off reporting and resubmitting to the US Treasury.

2022-002 Crime Victim Services- Assistance Listing No. 16.575 Recommendation: The Organization should implement internal controls to ensure that there is review and approval of monthly payroll accruals by someone who does not prepare the accrual calculation. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: Payroll accruals are currently reviewed and approved by a contracted accountant. This task will transition to financial staff by the end of the fiscal year 2023. Name(s) of the contact person(s) responsible for corrective action: Yulanda Williams

Finding 2022-004 Contact Person: Peter Gray Contact Phone: 765-775-5150 Views of Responsible Official: 1. There were no material cost issues in the overall report. There was a categorization error. This was discussed in Finding 2022-003. 2. The Revenue Loss expenditures were all valid personnel costs. Over 80% of the costs are police & fire. Other various city departments comprise the balance of the expenditure. We concur with the finding. Corrective Action: A. An additional layer of review has been initiated. The Director of Development is familiar with the requirements of the SLFRF guidance and will review and sign off on future reports. Anticipated Completion Date: 30 June 2022

Finding 2022 ? 001 Fiscal year in which the finding occurred: 2022 Pass-Through Entity, if pass-through or Federal Grantor Agency, if direct: Chicago Bar Foundation Contact Person(s) Responsible for Corrective Action: Whitney Trumble and Cassandra Lively Contact Phone Number: 312-922-6464 Status of Audit Finding: At the time of the audit, CCR had not received funds for three months of work as a subgrantee on the large federal grant that is the subject of this plan. The grantor was awaiting the federal contract extension and funds, and so did not have the funds to release. CCR received communication from the grantor that the extension and funds would be available soon, so we prepared a check for a vendor. Then, there was an extensive additional delay in receiving the funds, and CCR did not send the check because the contract had not yet been signed and funds could not be dispersed. The expense had been approved by the grantor and the work was underway during the delay in mailing the check. Corrective Action: As of June 2022, stricter internal controls have been implemented to ensure that any reimbursements listed on a grant invoice have been sent out to the vendor before submitting the report. A more formal review process has been implemented: CCR?s Executive Director will review and approve monthly grant reports via email. She will also review and approve supporting documentation for reach grant report. Approval (sent via email) will be kept with in a digital file with the reporting documentation. An additional internal control has been implemented to ensure that expenditures submitted for reimbursement are within the period of performance for the grant agreement. The Executive Director will monitor the grant expenses against the grant agreement, paying specific attention to the invoices at the end of the grant period, in order to ensure that the invoice is dated prior to the end of the grant agreement or most current amendment.

Finding 2022-002 Federal Agency Name: Department of Housing and Urban Development, Passed through Hearth Connections Program Name: Continuum of Care CFDA # 14.267 Finding Summary: Identified three months in which the reimbursement amount received from the pass-through entity was more than the Organization?s documentation. In addition, there was no indication that a review was performed of the information submitted for one of the four months tested, which resulted in the reimbursement amount from the pass-through entity being more than the support maintained by the Organization for three of the 12 months and no documentation of the review for one of the months. Responsible Individuals: Paul Bloomer, VP of Finance Corrective Action Plan: Schedule meetings with 3rd party vendor to identify the significant rounding errors occurring. Develop an agreement on rounding procedures to be used by both parties ensuring reconciliation. Anticipated Completion Date: 12/31/23 ? Note- this system of reimbursement terminated on 3/31/23

Finding 2022-015 U.S. Department of Health and Human Services AL No. 93.568 Total Low-Income Home Energy Assistance Significant Deficiency over Period of Performance Repeat Finding: No Auditee?s Corrective Action Plan: The Office of Home and Energy Programs (OHEP) bureau of The Mayors Office of Children and Family Success (MOCFS) agency has implemented a plan to locate needed files from previous and current fiscal years. The agency has implemented a scanning and uploading Standard Operating Procedure (SOP) that requires each case file to be digitally attached to its application and supporting documents. This will remedy this finding in its totality. Contact Person: OHEP Director ? Rigel Moore Completion Date: March 10, 2023

Finding 2022-018 U.S. Department of Health and Human Services AL No. 93.778 Medical Assistance Program (Medicaid; Title XIX) Material Weakness over Period of Performance Repeat Finding: No Auditee?s Corrective Action Plan: BCHD will implement controls to allow only costs within the period of performance to be charged to the correct grant period within the general ledger. BCHD will ensure that if there are any exceptions that allow for costs to be charged outside the period of performance, the proper supporting documents will be kept. Baltimore City's new financial system, Workday, allows for all supporting documentation to be kept electronically in one system. Policies and procedures for internal controls will be updated to incorporate processes in Workday, and accounting staff will be trained appropriately. Contact Person: Chief Financial Officer ? Unyime Ekpa Completion Date: December 2023

Finding 2022-016 U.S. Department of Health and Human Services AL No. 93.767 Children?s Health Insurance Program (CHIP) Material Weakness Over Compliance and Internal Control over Period of Performance Repeat Finding: Yes Auditee?s Corrective Action Plan: BCHD will implement controls to allow only costs within the period of performance to be charged to a grant. BCHD will ensure that if there are any exceptions that allow for costs to be charged outside the period of performance, the proper supporting documents will be kept. Baltimore City's new financial system, Workday, allows for all supporting documentation to be kept electronically in one system. Policies and procedures for internal controls will be updated to incorporate processes in Workday and the accounting staff will be trained appropriately. Contact Person: Chief Financial Officer ? Unyime Ekpa Completion Date: December 2023

Finding 2022-024 U.S. Department of Health and Human Services AL No. 93.977 Totally Sexually Transmitted Diseases (STD) Prevention and Control Grants Significant Deficiency in Compliance and Internal Control over Period of Performance Repeat Finding: No Auditee?s Corrective Action Plan: BCHD will implement controls to allow only costs within the period of performance to be charged to the correct grant period within the general ledger. BCHD will ensure that if there are any exceptions that allow for costs to be charged outside the period of performance, the proper supporting documents will be kept. Baltimore City's new financial system, Workday, allows for all supporting documentation to be kept electronically in one system. Policies and procedures for internal controls will be updated to incorporate processes in Workday and the accounting staff will be trained appropriately. 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

Finding 2022-022 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness over Period of Performance Repeat Finding: Yes Auditee?s Corrective Action Plan: BCHD will implement controls to allow only costs within the period of performance to be charged to a grant. BCHD will ensure that if there are any exceptions that allow for costs to be charged outside the period of performance, the proper supporting documents will be kept. Baltimore City's new financial system, Workday, allows for all supporting documentation to be kept electronically in one system. Policies and procedures for internal controls will be updated to incorporate processes in Workday and the accounting staff will be trained appropriately. Contact Person: Chief Financial Officer ? Unyime Ekpa Completion Date: December 2023

Finance and the Office of Highway Safety will work together to create policies and procedures to ensure compliance with Period of Performance. Anticipated Completion Date: September 30, 2023 Contact Person: Loren Doyle, Acting Chief Operating Officer / Chief Financial Officer Department of Transportation loren.doyle@dot.ri.gov

FINDING 2022-004 Contact Person Responsible for Corrective Action: Cheryl Alcorn, County Auditor Contact Phone Number: 574-753-7700 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Auditor and Commissioner will work together to ensure Project and Expenditure Amounts are properly reported to the Department of Treasury. The corrective plan of action will include the guidance of financial advisors to ensure reporting to be complete and accurate. Anticipated Completion Date: Corrective action plan will start immediately.

CHRISTUS Health Corrective Action Plan Year Ended June 30, 2022 Finding 2022-001 Federal Program Information Federal Agency: U.S. Department of Health and Human Services, Health Resources and Services Administration (HRSA) Assistance Listing No.: 93.498 COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Award Period of Performance: July 1, 2020 to June 30, 2022 Corrective Action Planned: Management agrees that certain expenses to the COVID department were not reviewed and approved at the order entry level in specific cases. Although evidence of review was not retained for every charge to the COVID department, we believe the appropriateness of the charge was reasonable. Additionally, based on monthly review of departmental expenses and full-time equivalent (FTE) analysis at the facility level, we believe that these expenditures are subject to the appropriate level of review to identify unexpected variances. We plan to review our processes related to the retention of expense documentation to improve audit evidence. Responsible party: Lee Sonne, Vice President of Finance and Controller Implementation Date: September 2023 with the filing of the 5th portal filing.

Views of responsible officials and planned corrective actions: The College has taken steps to charge the cost to the appropriate grant award number. The College will ensure that future costs are properly charged to the correct grant award number and that costs are within the appropriate period of performance. In addition, finance and program staff will be trained on period of performance requirements, as well as other aspects of grant management. Contact Person: Rodalyn Gerardo, Vice President for Finance & Administration Expected Completion Date: September 30, 2023

2022-003 Small Business Administration Financial Assistance Listing #59.075 COVID-19 Shuttered Venue Operators Grant Program Activities Allowed or Unallowed, Allowable Costs/Cost Principles, Period of Performance Material Weakness in Internal Control over Compliance Condition: While the Organization had policies and procedures in place over the review and approval of expenditures, during the testing of expenditures there were certain items that lacked the documentation of such review and approval. The Organization did not retain the required documentation to support the review of expenditures. Cause: The Organization had turnover and limited staffing available. The review and approval process was a collaborative process that took place in face to face meetings without documentation retained. Management?s Response and Corrective Action Plan: The Museum Deputy Directory/COO reviewed all grant expenditures in detail for accuracy and approved them before submission to the SBA, and written documentation of the review and approval of the submitted expenditures was maintained. However, written documentation of the approval of certain expenditures at the time they were actually incurred was not maintained, even though there were consistent, contemporaneous oral communications between the Deputy Director/COO, the Controller and the Payroll Administrator regarding those expenditures. As of January 2023, the CFO has implemented procedures whereby written documentation of approval of those expenditures is maintained. Responsible Individual: Robin Klung, CFO Anticipated Completion Date: January 2023

Responsible Official: Matt Zook, Finance Director Views of responsible officials: Management understands the requirement for secondary review and approval both at the source level (transactions generated by departments) and the and approval and submission of grant reports) and will actively implement and execute these steps into the internal control policy. Management will meet with the public works department to evaluate the software used to track force account equipment and ensure that Supervisor review and sign off will be conducted either through the software program or physically on paper. Management will also meet with the parks department to review their process for tracking force equipment charges. They use a paper tracking system, so we will ensure that they include a supervisor review and sign off process on staff tracking sheets. Management will also create a review process within the finance department specifically for the calculation and submission of grant reporting. Management agrees to comply with this within 90 days of the filing date of the financial statements no later than March 19, 2023.

2022-005 Internal Control over Compliance and Compliance with Activities Allowed or Unallowed and Allowable Costs and Cost Principles Contact: Sam Kimball Title: Corporate Controller Phone Number: 202-296-9165 Estimated Completion Date: December 2023 Corrective Action: During 2023, the Foundation is implementing a new ERP system with an anticipated go-live date of October 1, 2023. This new system will allow for better structure around the period-end accrual process and allow the Foundation to more clearly and effectively accrue for costs in the period of performance. Additionally, the Foundation will hold informal training sessions to remind staff of the importance of recording expenditures in the appropriate period and the policies around year-end accruals for costs that have not yet been invoiced.

Corrective Action Plan Finding 2022-001 ? Reporting Federal Grantor: United States Department of Health and Human Services (HHS), Health Resources and Services Administration (HRSA) Assistance Listing No.: Assistance Listing 93.498, Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution (PRF) Federal Award Numbers: N/A Federal Award Period of Performance: July 1, 2020 ? December 31, 2020 A material weakness was issued related to reporting for the Provider Relief Funds (PRF) that represented the major program subject to the Uniform Guidance (UG) audit. This included a compliance finding with no questioned costs. Community Foundation of Northwest Indiana, Inc. and Subsidiaries (CFNI) did not maintain written documentation of the detailed review and approval process of the underlying lost revenue calculations or the approval and sign-off process for the portal submission. CFNI Finance has developed a policy and checklist to maintain written documentation of the review and approval process required under current audit standards to improve internal controls going forward. Due to the timing of the prior year UG audit, the implementation of the new policy could not impact the current UG audit, resulting in the same finding. This has been corrected for future audits with the policy being effective October 2022. In the compliance finding, management failed to catch a change in formula to a large excel file returned from an external resource. This resulted in underreporting lost revenues for one entity. The finding affirms the need for an official policy identified in the reporting deficiency, which CFNI has fully corrected, and management will improve the review process and communication over changes to files sent and received from both internal and external resources. CFNI will correct the reporting error in the next reporting submission for period 4. Responsible Official: Pamela Pokropinski, Director Accounting & Financial Systems Status of finding: Fully corrected.

Finding 2022-003 Federal Agency Name: National Endowment for the Arts Program Name: Promotion of the Arts Partnership Agreement CFDA # 45.025 Finding Summary: The Organization has a process for allocating employee wages based on hours worked, however, retroactive pay adjustments, bonus allocation for one employee, and one pay period for one employee did not follow this process. The controls in place did not operate as designed and failed to detect errors in the allocation of employee pay to the grants. Responsible Individuals: Anne Romens, Vice President and Emily Anderson, Chief Administrative Officer Corrective Action Plan: Arts Midwest uses Paylocity, a third-party payroll provider, for employee time tracking and payroll processing. Salary and benefit allocations to departments and grants are based on labor distribution reports generated by Paylocity. The Finance Team will review and verify report parameters and details to ensure they are accurate before the payroll costs are imported into the accounting system. In addition, the finance and operations teams will verify any one-time pay adjustments are correctly calculated and allocated based on related period of hours worked. With the start of a new Chief Financial Officer, this will be a priority for the first quarter of 2023. Estimated Completion Date: March 31, 2023