Corrective Action Plans

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.

Finding 2021‐001 Federal Agency: United States Department of Housing and Urban Development (HUD) Planned Corrective Actions: Responsible Official – Darryl Johnson, Deputy CFO Anticipated completion date – October 2025 Management will review its controls and update standard work documentation to ensure that all loans and expenditures related to the Housing Trust Fund are appropriately accumulated and reported in the schedule of expenditures of federal awards (SEFA) for the period covered by the New York State Housing Finance Agency’s financial statements in accordance with Uniform Guidance 2 CFR section 200.502. All staff working on SEFA preparation and review, will receive additional education in reporting for federal programs.

We will adopt procedures and implement to ensure accurate reporting of expenditures on the SEFA and to ensure compliance with federal requirements.

The Board of County Commissioners, with the cooperation and participation of all elected officials, rev iews, develops and implements policies and procedures to create a strong internal control environment. Addit ionally, the Board of County Commissioners conducts meetings with all elected officials and officers responsible for the receipt and/or expenditure of county funds. These meetings address fiscal matters, including but not limited to, pol icy d iscussions and implementation, financial reports, budget oversight, SEF A reporting, and legal compliance. Policies and procedures, combined with fiscal oversight meetings, are intended to: I) prevent or detect material misstatements in the financial statements; 2) prevent or detect fraud within the county; 3) increase communication between the Board of County Commiss ioners and those elected officials and officers respons ible for the receipt and/or expenditure of public funds; 4) provide oversight over the fiscal concerns of the county; 5) identify and address risks related to financial reporting; 6) ensure the accuracy of Rogers County's financial statements, Estimate of Needs, the Schedule of Federal Awards ("SEFA"); and 7) ensure compliance with all applicable federal and state laws, regulations, and/or codes. The Board of County Commissioners, with the cooperation of all elected officials and officers responsible for the receipt or expenditure of county funds, will evaluate the processes and procedures currently in place to detect and identify material misstatements in Rogers County's financial statements, detect fraud, and identify and address risks related to Rogers County's financial processes and procedures will be implemented to identify fraud, detect material misstatements in the financial statements, and address risks related to financial reporting.

Management feels that the SEFA wasprepared in accordance with guidance that was available at the time. We will continue to evaluate all federal programs’ expenditures and include on the SEFA as necessary. All federal expenditures will continue to be reconciled to College ledgers.

Through the assistance of the Oklahoma State Auditors and Inspectors Office, we have received appropriate instruction on how they wish the appearance of the SEF A to be. We believe this issue to be resolved and will be reported as instructed from this point forward.

Finding 20201-0001 Responsible Official: Richard E Rico Views of Responsible Officials: With the volume of new COVID-19 federal programs, it was more challenging to completely prepare the SEFA. Processes will be put into place to compile the SEFA, reconcile to support and perform a related review prior to audit. In addition, any funds with unusual reporting requirements will be reviewed in detail to ensure reporting is complete and accurate. This has been implemented as of January 2025.

Finding: In accordance with 2 CFR 200 200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. The Corporation’s Schedule of Expenditures of Federal Awards for the year ended June 30, 2021 was initially prepared without federal expenditures totaling $1,222,859 for the HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund, Assistance Listing number 93.461. Corrective Actions Taken or Planned: In July 2023, the Corporation has provided education and training to the staff regarding how to identify programs and costs that need to be reported on the annual SEFA. This includes a process to enhance internal controls around the timely identification of federal awards and the reconciliation of the SEFA to ensure that it is accurate and complete. Name of contact person responsible for corrective action: Rose Rosario, Director of Patient Financial Services.

Confluence Health has made significant changes to its internal controls to ensure federal funds are accounted for properly in the Schedule of Expenditures of Federal Awards. Confluence Health developed a Grants Committee that approves all Federal and State Grants. This Committee reviews all grant applications and after approval, contacts finance and executive leaders of the approved grants by the committee. In addition to the control implemented above, Confluence Health meets internally monthly with all parts of the organization that receive cash payments from grant programs and incur federal expenditures to confirm if federal grant funds have or have not been received and spent. Our Revenue Cycle department that received the funds related to this program has provided education to their team, and leadership is aware of the risk and importance of reporting federal funding of grants and monitoring compliance. The COVID-19 HRSA Uninsured Program has been reported appropriately on Confluence Health’s restated 2021 Schedule of Expenditures of Federal Awards. This process has been put in place and continues monthly during our month-end close meetings to ensure federal grant funds are being reported correctly. The Vice President of Finance, Eric Caldwell, will be the individual responsible for the corrective action plan.

Program: Transportation Infrastructure Finance & Innovation Action (TIFIA) Program (ALN 20.223) Finding: 2021-002 Contact Person: Wei Chi Director of Finance City of Long Beach Harbor Department Phone: (562) 283-7594 Email: wei.chi@polb.com Corrective Action Plan: Going forward, the Harbor Department will ensure that federal loans are reported on the SEFA. The expected completion date for implementation of these planned actions is no later than June 30, 2025.

Finding 2021-003: Reconciliation of Accounts Federal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1524963 (11/1/2015 – 9/30/2021), 1812860 (9/1/2018 – 8/31/2020) Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 10/15/2024 Responsible Official: Michael Brosnan, CFO

Finding 2021-003: Reconciliation of Accounts Federal Program: Research and Development Cluster: 47.076 Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO

Public Health’s Accounting Office will generate the FI$Cal Year End Close report (KK_12 expenditure) and collaborate with the ELC program to ensure that all expenditures captured are complete and accurate, ensuring timely reporting of the SEFA data for FY 2023-24 and beyond. Additionally, we will update the procedures to document the SEFA reporting for the ELC program.

EDD agrees with this finding. The deferred transition to FI$Cal and the difficulties experienced thereafter have continued to cause EDD to be late with submitting year-end financials and its ability to submit timely the cash basis expenditures into the Single Audit Expenditures Reporting Database (Database). In addition, the onset of the COVID-19 pandemic created additional issues which ultimately impacted the EDD’s ability to submit timely year-end financials. However, the EDD is making progress and continues to gain ground in the department’s efforts to follow the State’s deadlines for submitting year-end financials and entering the cash basis expenditures into the Database. By the end of fiscal year 2021-22 and into fiscal year 2022-23, the EDD did a restructuring within the accounting area which realigned workload amongst the units and provided additional resources in critical areas. These changes will have a lasting effect and help the department to be better positioned going forward in processing the accounting workload and ultimately be able to catch up and submit year-end financials and enter the cash basis expenditures into the Database by the State’s deadlines. In addition, the EDD took lessons learned from the fiscal year 2019-20 financial audit to update processes and procedures and applied that knowledge going forward. Also, staff have been participating in various trainings offered by Finance and the Department of FISCal and staff continue to work with the control agencies when issues arise that would impact our accounting functions. While the EDD is still behind, the department is making great progress on catching up. The EDD submitted the last of its fiscal year 2020-21 financials in July 2022 and is targeting to submit the last of its fiscal year 2021-22 financials by the end of March 2023. The EDD’s goal is to submit fiscal year 2022-23 financials by the end of December 2023. Similar to the 2019-20 financial audit, the EDD will take the knowledge learned during the 2020-21 audit season, continue to engage with the control agencies, and continue to train and develop staff in order to keep progressing towards the department’s goal of becoming timely with the submission of the year-end financials and entering of the cash basis expenditures into the Database.

Finding 2021-002 Responsible Official: Donnie Gosnell, Controller Views of Responsible Officials: With the volume of new COVID-19 federal programs, it was more challenging to completely prepare the SEFA. Processes will be put in place to compile the SEFA, reconcile to support and perform a related review prior to audit. In addition, grant agreements will be required to go through the contract approval process. This will allow all grants to be identified and tracked, ensuring completeness. This has been implemented as of March 2024

The County Clerk, Treasurer, and BOCC Executive Assistant are tracking and monitoring all Federal expenditures closely to ensure the SEFA is more accurately reported.

In collaboration with the audit team, we will correct the procedures used to develop the Schedule of Expenditures of Federal Awards to ensure that it is completed correctly and accurately .Anticipated Completion Date April 30,2024.Responsible Contact Person-Kathleen Boyce, CFAO

Management will work together to design and implement a system of internal controls to ensure an accurate reporting of revenues and expenditures on the SEFA, that the notes to the SEFA are prepared, and compliance with all applicable federal requirements.