Corrective Action Plans

Management?s Views and Corrective Action Plan 2022-001: Schedule of Expenditures of Federal Awards All Federal programs Federal Award year: 2021 Management?s Response Management agrees with the finding as it relates to the inclusive of expenditures of State awards. As part of the preparation and review of the schedule of expenditures of federal awards (the ?Schedule?), processes were in place to reconcile total expenditures under the program to the general ledger as well as the consolidated financial statements. In addition, analytical review was performed of variances in expenditures year-over-year, by program, to assess reasonableness of reported expenditures. During review of the 2021 CHIP program expenditures, management reconciled total expenditures to the general ledger and consolidated financial statements without exception, as both the general ledger and consolidated financial statements include total program expenditures (i.e., both federal and state are included). In addition, upon review of variances in total program expenditures in comparison to the previous award year, variances appeared reasonable as they remained relatively consistent year-over-year and with historical data. In fiscal year 2022, management has implemented additional steps into its reconciliation process to bifurcate the total expenditures between Federal and State expenditures prior to agreement to the general ledger and consolidated financial statements to ensure exclusion of State amounts when preparing the Schedule. In addition, within the analytical review process management utilizes the bifurcated totals to assess for reasonableness at the more detailed level regarding year-over-year variances. Anticipated Completion Date Additional reconciliation steps and bifurcation of amounts were implemented during the preparation and review of the 2022 Schedule. Responsible Parties ? Matthew Bazzani, Chief Accounting Officer, Highmark Health

Finding 2022-002 Material Weakness, Inaccurate Schedule of Expenditures of Federal Awards (SEFA) Personnel Responsible for Corrective Action: John Moore, Director of Finance and Leon Hanhardt, Superintendent Anticipated Completion Date: September 30, 2023 Corrective Action Plan: District personnel will agree amounts reported on the SEFA to the corresponding expenditures recorded in the general ledger and an individual independent of preparation of the SEFA will review the report.

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

Grady’s corrective action plan: 1. Going forward, Grady will have a formal agenda to discuss and approve the SEFA prior to submission. 2. The SEFA will be reviewed, approved and attested by the Grady’s VP Of Fiscal Services and the Executive Director of Internal Audit. 3. Differences above established thresholds will be reviewed and addressed

Action Taken/to be Taken: Accounting staff will be responsible for the preparation of the SEFA in the future, this had been done by operations staff in the past. Appropriate training will be sought as necessary. An outside accountant will be consulted for guidance and recommendations on the 2023 SEFA prior to submission.

The IDOC plans to correct and record appropriate expenses in the FY23 SEFA. When preparing documentation for future SEFA reporting, the IDOC will endeavor to use the appropriate dates that fall within the proper guidelines for reporting.

The IDHS will design and implement a reconciliation of Federal grant receipts and expenditures by assistance listing number included in the financial reporting forms submitted to the IOC to the IDHS’ financial reporting system.

During 2023, the newly elected County Auditor took on an active role in tracking the Coronavirus State and Local Fiscal Recovery Funds by preparing and maintaining spreadsheets so that the Commissioners have the most current information for making decisions. The County Auditor attends or watches/listens to the Commissioners’ meetings to make sure that she is updating the spreadsheets with all action taken by the Commissioners. Before submitting the Schedule of Expenditures of Federal Awards for the 2023 audit, we will consult with the Commissioners’ Office and the County Auditor to make sure that we are reporting the transactions correctly based on the spreadsheets prepared and maintained for such purposes.

Views of Responsible Officials and Planned Corrective Actions: USTTI will prepare its SEFA on a quarterly basis and we will reconcile the expenses reported on the SEFA with general ledger amounts. We will also review the chart of accounts coding to be sure all eligible expenses are clearly identified.

Criteria: According to 2 CFR Subpart F Section 200.510b, the auditee must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period that includes all amounts spent on federal programs during the reporting period. Condition: The SEFA under-reported the expenditures for Charter Schools Program (CSP) by $24,206. Cause: The School prepared the SEFA based on the federal revenue recorded, rather than the actual federal expenditures incurred. Effect: An audit adjustment of $24,206 was made to increase the federal expenditures reported on the SEFA for the CSP program. Recommendation: We recommend that the School implement procedures whereby the SEFA is prepared based on federal expenditures incurred on a GAAP basis. Action Plan: The School has hired an accountant who will follow the accounting rules and standards for financial reporting using GAAP (generally accepted accounting principles).Persons Responsible: Tammy Chaney, Accountant

Federal Agency: U.S. Department of Agriculture, U.S. Department of Justice, U.S. Department of the Treasury and U.S. Department of Homeland Security Program Name: Emergency Watershed Protection Program; Drug Court Discretionary Grant Program; COVID-19 Coronavirus State and Local Fiscal Recovery Funds; Emergency Management Performance grants Assistance Listing Number: 10.923, 16.738, 21.027 and 97.042 Responsible Official: Courtney Campbell, County Clerk Views of Responsible Individuals: The SEFA monies had been reported wrong in the past. With this being my first year as County Clerk and my first experience with the budget I also went by what was reported in the past. I am working toward correcting this mistake and tracking the money better so it can be reported correctly.

YMCA of San Juan Response The Organization agrees with the finding. YMCA maintains a detailed accounting system subject to periodical reviews by the grantee in each individual grant. The system includes separate bank accounts, job ledgers, individual transactions are registered and in the CDBG-DR program a live platform exists with written procedures adopted by the subgrantee to be eligible to have access to the reimbursement expenses. In order to improve the supervision and reporting the organization is in the active recruitment process and review of individual requirements of the grants such as the CFDA among others. Corrective action plan The Organization is currently implementing a procedure to review the information presented in the SEFA, to segregate from schedule the nonfederal funding expenditures. Name (s) of person (s) responsible for corrective action Ms. Mabel Román, YMCA Executive Director YMCA Finance Director Anticipated completion date December 2023

CONDITION: The ROE did not have sufficient internal controls over the preparation of the Schedule of Expenditures of Federal Awards (SEFA) to ensure all federal expenditures during the fiscal year were reported and information in the SEFA was accurately reported. PLAN: The ROE will work with their contracted accounting firm to review financial statements, including the schedule of expenditures of federal awards, to ensure program titles, assistance listing numbers and other pertinent information is accurate for financial statement presentation. ANTICIPATED DATE OF COMPLETION: The anticipated date of completion is December 2023. CONTACT PERSON: Ms. Jill Reedy, Regional Superintendent

Assistance listing number and program name: N/A Agency: Department of Education Name of contact person and title: Mark Belanger, Budget Director Anticipated completion date: October 31, 2023 Agency’s Response: Concur The Department agrees with this finding and will implement the following: • Train designated staff responsible for preparing the Schedule of Expenditures of Federal Awards (SEFA) on State of Arizona Accounting Manual (SAAM) requirements. • Establish a reconciliation process to validate expenditures prior to submitting report • Staff will review federal resources for Assistance Listing Numbers (formerly CFDAs) to ensure proper title reporting • Designated staff will stay current on all federal regulations and SAAM requirements for reporting

Views of Responsible Officials and Corrective Action Plan: Management agrees with this finding and identifies federal funding based on contract language. The contracts do not include a percentage of funding that is not federal. To ensure proper spending of federal funds, Rainbow Health Minnesota treats all funds as federal funds.

Response. Agreed. Where feasible, the Housing Trust will aim to improve management of all federal grants. A process of documentation verification prior to any requests made for financial draws will include employee, supervisor, business operations manager, and executive director level approvals to ensure compliance and availability of funds. A monthly federal request for reimbursements with all grantee information will be used and reconciled monthly with QuickBooks. This report will mirror the SEFA form so auditors will receive the information in a timely manner. For any quarterly reports, the three months of reporting will again be reconciled prior to submission. All new processes and compliance will be updated in the policies and procedure manual. As the Executive Director prepares the 2024 budget, a reorganization of the business operations department will be sought. A new position to prepare and work on all federal grant tasks will be hired and report to the Business Operations Manager. In the meantime, the Business Operations Manager has started to develop checks and balances. Corrective Action Plan Timeline: Immediately Designation Of Employee Position Responsible For Meeting Deadline: Business Operations Manager

The finance department of NorthPoint Wellness Center Inc. is incorporating as part of the annual financial closing process a reconciliation directly with the grantors to confirm the financial expenditures, contract agreements and to determine the correct Assistance Listing Numbers (ALN). The reconciliation must be completed by January 20th following the close of the fiscal year, as well as at the end of the contract period. A Government Contract Reconciliation template has been created as part of the verification process and supporting documentation for the grantee organization.

Finding 2022-004: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Finding: The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Corrective Action: Compare all contract or award letters for accurate information reported on the SEFA prior to submission. Contact: Carmen Stevens, Finance Director Expected Completion Date: 11/30/2023 If you have any questions, please contact Carmen Stevens at 713-472-0753 or by email at cstevens@tbotw.org.

2022-002 Criteria – According to 2 CFR Subpart F Section 200.510b, the auditee must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period that includes all amounts spent on federal programs during the reporting period. Condition – The SEFA excluded the Emergency Connectivity Fund Program and was materially understated by $81,750. Cause – PPHS had significant turnover in finance personnel during and after the 21-22 school year. Effect – An audit adjustment was made to add the Emergency Connectivity Fund Program expenditures of $81,750 to the SEFA. The increase in expenditures resulted in the selection of an additional major program to achieve the audit coverage required by the Uniform Guidance. Corrective Action Plan – PPHS had significant turnover in finance personnel during the 22-23 school year. PPHS hired a full-time Financial Controller on July 31st, 2023 and has been working with accounting consultants to improve processes and procedures throughout FY23. We will implement a review process for the SEFA whereby key members of management review the SEFA for completeness. Responsible for CAP – Todd Burleson, Financial Controller. Anticipated completion date – Processes were improved in FY23 through assistance from accounting consultants. Policies and procedures updates will be implemented in FY24.

Beginning in 2023, the Holt County Clerk has implemented a process to obtain award letters from grant writers and documenting the funding details. The Holt County Clerk is looking into software which is able to track projects year over year to make reporting more manageable.

Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes. Corrective Action Planned: The NEWDB Fiscal Team will undergo supplementary training on MIP reporting procedures.

A record of each invoice or reimbursement request will be keep with the program director and a copy sent the county clerk by end of the year. This will be used to complete the SEFA. Cross checking with other documents will be done.

RE: Single Audit Corrective Action Plan The City of Hartwell, Georgia respectfully submits the following corrective action plan for the year ended December 31, 2022. Name and address of independent public accounting firm: Williamson and Company, CPAs 611 N Tennessee Street Cartersville, GA 30120 Audit Period: Year ended December 31, 2022 The findings from the December 31, 2022 schedule of findings and questioned costs are discussed below. The findings are numbered consistently with the numbers assigned in the schedule of findings and questioned costs. Findings – Financial Statement Audit MATERIAL WEAKNESS None Reported SIGNIFICANT DEFICIENCY None Reported Findings – Federal Award Programs Audit MATERIAL WEAKNESS None Reported SIGNIFICANT DEFICIENCY None Reported 2022-001 Clean Water State Revolving Fund – ALN: 66.458 Finding: Schedule of Expenditures of Federal Awards Preparation Recommendation: Procedures should be implemented to ensure completion of an entry to the Schedule of Federal Expenditures of Federal Awards to achieve a reliable reporting of total expenditures for an audit period. Action Taken: We acknowledge our responsibility to present the Schedule of Expenditures of Federal Awards and related notes in accordance with Uniform Guidance requirements. To ensure future implementation of this requirement, the City of Hartwell will record all expenditures on the schedule of federal expenditures going forward on for all federally funded projects. Please call or write if there are any questions/suggestions that you may have to help us further enhance the City’s operations. Sincerely, Audrey Segars Finance Director City of Hartwell, Georgia

City staff are aware of this responsibility and will plan to prepare the SEFA annually in future years.

Corrective Action Plan: PREMA will improve its audit reporting process to ensure timely submission of the Single Audit reporting package by strengthening internal controls over report preparation, establishing a reporting calendar that includes milestones for completing reconciliations and required documentation, and coordinating with fiscal, program, and grants staff to ensure financial data, the SEFA, and supporting information are complete and ready within the Uniform Guidance deadline; PREMA will also assess staffing needs, implement procedures to track reporting progress, and provide training to personnel involved in the audit submission process. Lead Person: Maritza Torres, Fiscal Area Director, and Contractors (Robles & Assoc.). Anticipated Completion Date: December 2025.