Corrective Action Plans

Identification of federal program: U.S. DEPARTMENT OF AGRICULTURE passed through the Indiana Department of Education Child Nutrition Cluster 10.553 & 10.555, U.S. DEPARTMENT OF EDUCATION passed through the Indiana Department of Education Title I, Part A 84.010A, Student Support and Academic Enrichment Program (Title IV) 84.424, Charter Schools Program 84.282D, Education Stabilization Fund 84.425D& 84.425U. 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 Schedule of Expenditures of Federal Awards (SEFA) was overstated by $42,585.Cause: The School included depreciation expense within amounts reported on the SEFA which is not an allowable cost under Uniform Guidance. Effect: An audit adjustment was made to reduce the reported amount on the SEFA for the Child Nutrition Cluster (10.553, 10.555) by $5,988, the Title I, Part A grant (84.010A) by $378, the Student Support and Academic Enrichment Program - Title IV (84.424) by $581, Charter Schools Grant (84.282D) by $95, COVID-19 Elementary and Secondary School Emergency Relief (ESSER II) Fund (84.425D) by $29,896, and the COVID -19 ARP Elementary and Secondary School Emergency Relief (ARP ESSER) Fund (84.425U) by $5,647. Recommendation: We recommend that the School's accountant review and become familiar with Uniform Guidance and CFR 200 requirements to assist with including the accurate expenditure information in the Schedule. In addition, we recommend that the accountant reconcile federal award expenditures to the claims that were filed for the year. Action Taken: Dugger Union Community Schools plans to follow the recommendation given and work with our accountant to do our best to avoid further discrepancies.

Condition: The SEFA for the year ended June 30, 2023 was not accurately prepared as it originally included expenditures that were improperly excluded from the SEFA for the year ended June 30, 2022. Planned Corrective Action: Additional Supervisory Review of Expenditures Contact person responsible for corrective action: Deanna Korth Anticipated Completion Date: 09/30/2023

Condition: The schedule of expenditures of federal awards (SEFA) was not complete. Planned Corrective Action: The School District will develop a checklist, or a report downloaded from the General Ledger, of all federally funded grants, and will compare the grants listed on this report with the grants listed on the Schedule of Expenditures of Federal Awards (SEFA) to ensure that all grants are reflected on both documents. Additionally, the Assistant Superintendent will review, date and sign a copy of the SEFA document prior to its submission, and the Business Office will retain this signed paper copy in its audit file annually. Contact person responsible for corrective action: Michael Zopf Anticipated Completion Date: June 30, 2024

Contact: Reginald Gregory Title: Executive Director/Controller Phone Number: 202-772-4300 Estimated completion date: June 30, 2024 Corrective Action: Management will continue to stress the importance of following the detailed procedures for preparation and review of the SEFA. Responsibility for compiling the SEFA was assigned to a Senior Program Accounting Manager who is tasked with assuring the SEFA and all support reconciliation are complete and accurate. Both the Director of Program Accounting and the Executive Director of Finance/Controller will review the SEFA for completeness, accuracy, and compliance with CFR Section §200.510(b).

Views of Responsible Officials and Planned Corrective Action: The School agrees with this finding. Lisa Hendricks, the Director of Finance, and the 3rd party accountant will work closely to develop a grant tracking system that determines the source of the grant funds prior to expending any of the funds.

Finding: 2023-001: SEFA – Material Weakness The SEFA prepared by management included an incorrect Assistance Listing (AL) number for one grant. Federal grant AL NO. 20.513 Enhanced Mobility of Seniors and Individuals with Disabilities was incorrectly identified as AL No 20.507 Mobility Management. While both grants are from the Federal Transit Agency, they fall under different clusters in the Office of Management and Budget’s Compliance Supplement and thus have different audit requirements. Auditor Recommendation: We recommend management verify with the grantor the AL number of the grant. This can be done by obtaining the information from grant documents, or direct communication with the grantor. We further recommend the SEFA be reviewed for accuracy by an individual not included in the SEFA preparation process. Review should be notate with initials and date. Contact Person Responsible for the Corrective Action: Lisa Cappellari, Chief Financial Officer, LisaC@paratransit.org Management Response and Corrective Action Plan: After the end of Fiscal Year 23-24 on 6/30/2024, Jody Wadley, Finance and Grants Manager, will start the preparation of the FY24 SEFA and make sure all components are correct. Lisa Cappellari, Chief Financial Officer, will review the SEFA for accuracy, checking grant documents and directly contacting the granting agency if necessary. Once each component of the SEFA is thoroughly reviewed, Lisa Cappellari will initial and date.

Failure to Inform Auditors of the Need for A Single Audit Recommendation: We recommend that Counseling Clinic updates and maintains a SEFA or other tracking protocol of total expenditures on a federal level throughout the year. Action Taken: Management is now properly tracking grant expenditures and can accurately state quantities of grant expenditures.

Recommendation: We recommend that Minnesota Land Trust review its internal controls to ensure the SEFA captures all federal awards expended at the correct amounts in accordance with 2 CFR 200.510(b) Schedule of expenditures of Federal awards and CFR 200.502, Basis for determining Federal awards expended. Actions to be Taken: The Minnesota Land Trust will add additional internal controls to ensure a complete listing of federal expenditures is easy to provide and that the listing is reviewed by the Finance Department prior to audit fieldwork. Timeline for Completion: A complete listing of federal expenditures to be available from our accounting software (i.e., automatically) by October 31, 2023. Contact person responsible for corrective action: Claire Colliander

Response to Finding 2023-003 - Schedule of Expenditures of Federal Awards (SEFA) Preparation The district will strive for monthly requests for reimbursement for all applicable federal funds, thus creating awareness of the funds and potential issues before they arise. The District Director of Finance will be responsible for overseeing the implementation of these responses and anticipates corrective dates to be immediate. Person(s) responsible for action: Lanell Farmer/Director of Finance

Description of Finding: The school did not adequately track its expenditures of federal awards and did not prepare a complete SEFA as of the year end. Statement of Concurrence or Nonconcurrence: The school agrees with the audit finding as presented. Corrective Action: While the school’s chart of accounts includes specific accounts for grants and Title I funds, the chart of accounts did not explicitly list all federal revenue (Title I, ESSER Grant, USDA, and Federal Facility Grant). The school has already updated the chart of accounts to account for all federal funds with appropriate identification of revenue sources. This will allow the school to accurately account for monthly revenue and expenditures relating to federal funding sources, along with accurate monthly financial reporting of federal fund usage and expenses. Name of Contact Person: Chaz Patterson-Ellis, Chief Financial Officer, 678-466-7300, chaz.patterson@chatthillscharter.org. Projected Completion Date: Sept 30, 2023. Chaz Patterson-Ellis, Chief Financial Officer.

During the grant agreement review and signature process, the source of funding is identified and confirmed with the funder. As a result, when the Schedule of Expenditures of Federal Awards (SEFA) is developed, the source of funds has already been correctly identified.

UCCAC has retained services of an outside service provider who will ensure schedule of expenditures of federal awards is reconciled to general ledger and includes all federal and pass-through federal grants awarded. The schedule will also be reviewed by program director for accuracy and completeness. Responsible Person: Controller and program directors Timeline: 30-60 days

2022 – 006: Reporting - Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Condition: During fiscal year 2022, the Organization did not have adequate controls in place to ensure the SEFA accurately reflected each award's federal agency and assistance listing number. There were differences between the SEFA and the grant agreements/compliance supplements, requiring adjustments to the SEFA. Corrective Action Plan: As of October 1, 2024, the start of FY25 QuickBooks has been the only software used, and Revenue and Disbursements are being classed by Fund. General ledgers are now reconciled monthly. Each grant will have its own folder and required information to assure an accurate SEFA can be completed will be included.

The Board of County Commissioners, with the cooperation of all elected officials and officers responsible for the receipt or expenditure of federal funds, will evaluate the processes and procedures currently in place to ensure the accuracy of SEFA reporting and detect potential inaccuracies and/or misstatements.

Management concurs with the finding and will implement a proper expenditure reporting process, reconciled monthly, to avoid recurrence during future audits.

The City will review the process for identifying federal awards to minimize the likelihood of errors in preparing the schedule of expenditures of federal awards to minimize the likelihood of errors in preparing the schedule of expenditures of federal awards. This will include inquiries of the Engineer’s Office.

Management’s Planned Corrective Action: Disagree: We have established a cost center or “Department” for each federal program that clearly identifies federal expenditures. Our funders request monthly copies of receipts and payment issued to verify expenses. Responsible Party: Beaulieu Accountancy Corporation, Accountant Completion Date: 9/25/2024

Finding no.: 2022-003 Contact person(s) responsible: Kymberly Horner, Executive Director Corrective action planned: The SEFA was assigned to be prepared internally, but unfortunately was not submitted due to staff turnover during the course of the audit. This oversight will be corrected by improving procedures around internal task assign-ments when employee turnover is experienced in the Fiscal department during the course of the audit. Anticipated completion date: December 2023

PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS - SIGNIFICANT DEFICIENCY Federal Program Community Development Block Grant/Entitlement Grant ALN 14.218; passed through the County of Berks HOME Investment Partnership Program ALN 14.239; passed through the County of Berks Emergency Rental Assistance ALN 21.023; passed through the County of Berks Condition/Cause The Authority provided information relating to the federal programs including grant agreements and other supporting documentation. However, the information prepared by the auditee required material adjustments as a result of audit procedures. Certain account reconciliations were not performed prior to the audit, which impacted amounts reported on the SEFA. Recommendation In order to meet Uniform Guidance requirements, the Authority should prepare the SEFA from the grant award documentation and any other relevant information including the assistance listing numbers, grant award amounts, grant amounts received, grant amounts expended, and grant revenue recorded. The amounts reported in the SEFA should reconcile to the general ledger. Management Response The Authority researched the method to prepare a SEFA and will be preparing the SEFA starting with the 2023 audit.

Consortium’s Fiscal Agent will ensure that supporting documentation will be maintained for all expenditures to ensure that each expenditure charged to the program is for an allowable activity/cost. In addition, Fiscal Agent will complete corrective action for 2022-005 & 2022-006

Condition: The schedule of expenditures of federal awards (SEFA) was not accurate. Planned Corrective Action: The City will review its process for identifying and communicating Federal Grant expenditures to its auditors. Contact person responsible for corrective action: Robert McMahon, City Administrator Anticipated Completion Date: 09/30/2025

2022 - 008: Reporting: Preparation of the Schedule of Expenditures and Federal Awards (SEFA) (Repeat Finding:2019-007 and 2020-007 and 2021-006) Condition: During fiscal year 2022, the Governmental Department did not have sufficient controls to ensure the SEFA accurately reflected each award’s federal expenditures. There were differences noted in reconciling expenditures from the original SEFA to the trial balance, and it was discovered that certain adjustments for grants receivable, unearned revenues and grant revenue had not been made in order to properly report total federal expenditures. These errors were corrected through adjustments proposed as part of the audit, and the final version of the SEFA reconciles to the Governmental Department’s general ledger. Corrective Action Plan: Management of the Tribe realizes the importance of the SEFA and will be sure that the SEFA matches the general ledger and accurately reflect each awards federal expenses. The internal task list to be developed will include reconciliations from the trial balance to the SEFA on a least a quarterly basis

Responsible Parties: Chief Executive Officer (Rose Turner), Interim Chief Financial Officer (Dan Miles), Finance Director (Kelly Glover) Gateway’s Management will utilize the implemented Matrix duties and responsibilities Grid to help monitor the documentation of required procedures and Standard Operating Procedures approved by the Board of Directors. The health center will use the approved Financial Policies and Procedures Manual as its Standard Operating Procedures. The Health Center’s Management employs key management staff that reflects the size and composition of a health center. Ongoing evaluations will be used to monitor the qualifications of the staff. This Audit is a late submission, however with the submission a qualified Chief Financial Officer is in place and has the qualifications needed to assess and train staff accordingly and provide recommended changes to the department. This new Chief Financial Officer will serve as a technical resource to assist with the implementation of all the resolutions to the findings of the 2022 and 2023 audits

Finding Number: 2022-003 Condition: Controls in place were not adequate to ensure the schedule of federal expenditures was complete and accurate. Planned Corrective Action: The federal funding was not received until fiscal year 2023 while some expenditures were incurred in fiscal year 2022. The timing of events contributed to the oversight on the 2022 SEFA. WakeMed has reeducated staff on the preparation of the SEFA in order to prevent this error from reoccurring.Contact person responsible for corrective action: Lynn Bailey Anticipated Completion Date: 12/5/2024

Action Taken: Management is in the process of instituting additional procedures to ensure all awards are assessed not only to identify whether sources of funds are Federal, requiring inclusion on the SEFA, but also to identify continuing compliance period when applicable. Management has also conducted internal training relative to applicable 2 CFR 200 regulations and requirements and will continue to provide periodic staff training to ensure continued compliance. Anticipated Completion Date: Management estimates that additional processes will be in place by December 31, 2024.