Corrective Action Plans

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

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

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.

Finding 2021-002 Program: Various, including AL 97.036 – Disaster Grants – Public Assistance (Presidentially Declared Disasters) – Reporting Corrective Action Planned: To make sure and have proper education and obtain training to ensure County personnel are aware of the Federal reporting requirements and understanding of the schedule of expenditures of Federal awards. Anticipated Completion Date: Fiscal Year End 2023-2024 Responsible Party: Garfield County Board Scott Krause Garfield County Board Chairman

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 track federal awards and to ensure all income and expenditures relating to federal awards are properly overseen, tracked, and reported. These policies and procedures will be designed to identify requirements for recipients and sub-recipients of grants, ensure accurate equipment and real property management, procurement, recipient and subrecipient monitoring and reporting. Further, policies will ensure a proper understanding of all grant requirements and compliance of the same.

Finding 2020-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: 1812860 (9/1/2018 – 8/31/2020), 1940925 (1/15/2020 – 12/31/2023) 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: October 15, 2024 Responsible Official: Michael Brosnan, CFO

Finding 2020-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

Federal Agency: U.S. Department of Housing and Urban Development Federal Program: 14.218 Entitlement Grants Cluster: Community Development Block Grants/Entitlement Grants Identification Number: B-15-MC-42-0018; B-16-MC-42-0018; B-17-MC-42-0018; B-18-MC-42-0018; B-19- MC-42-0018 Requirement: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Period of Performance; Reporting; Special Tests and Provisions Type of Finding: Material weakness in internal control over major program; Noncompliance Description of Finding: Supporting documentation related to the major program was not provided to the auditor due to various factors, all subsequent to year end, including turnover of all key personnel, the destruction of the City’s servers and the conversion to a new accounting system leaving the old accounting system widely unused and unsupported, the completeness and availability of all records, management has been unable to produce records to support the following: material balances stated in the accompanying financial statements, compliance with laws and regulations; the identification and disclosure of all laws, regulations, and provisions of contracts and grant agreements directly and materially affecting the determination of financial statement amounts and; the presence or absence of fraud involving management or employees with significant roles in internal control; compliance with laws, regulations, and provisions of contracts and grant agreements, including budget laws, compliance with any debt covenants, identification of subsequent events, commitments and contingencies, the identification of all Federal assistance programs and compliance with Federal grant requirements. Additionally, the amount of time which has passed since the year end under audit has further exacerbated these issues. We were unable to satisfy ourselves by other audit procedures concerning these balances and disclosures. Auditee responsibilities as outlined in section 2 CFR 200.508 include providing the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit. Recommendation: We recommend the City implement procedures to ensure consistent and accurate accounting for federal grant expenditures in accordance with section 2 CFR 200.302 of the Uniform Guidance. Statement of Concurrence: The City of York, Pennsylvania agrees with audit finding 2019-013. Corrective Action: The City of York has implemented written procedures for consistent and accurate accounting of federal grant expenditures by utilizing a new financial management system, OpenGov. The new financial management system was implemented in January 2022. Name of Contact Person Responsible for the Corrective Action: Contact Full Name: Kimberly Robertson Contact title: Business Administrator for Finance Address: 101 South George Street City: York State: Pennsylvania Zip Code: 17401 Phone: (717) 849-2883 E-mail: KRobertson@yorkcity.org Timetable for Correction: The anticipated date for resolving the audit finding is December 31, 2024.