Corrective Action Plans

Condition: The schedule of expenditures of federal awards (SEFA) was not complete and accurate. Planned Corrective Action: The City will be implementing a procedure whereby the Controller’s Office receives copies of all contracts to ensure all reporting requirements are met and financial deliverables are completed according to the schedules. Contact person responsible for corrective action: Brandy Ruth Anticipated Completion Date: June 2024

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.

This was a simple mistake in reporting the SEFA revenue instead of the expenditures. Since discovering expenditures are required this will not be an issue going forward.

The Schedule of Expenditures of Federal Awards (SEFA) provided to the audit firm was incomplete due to two primary factors: (1) insufficient understanding by staff regarding the requirement to include federally funded capital expenditures, and (2) improper recording of property acquisitions. Management acknowledges this oversight, which occurred during the implementation of a new program and at a time when staff were not fully aware that such expenditures must be reflected on the SEFA. Furthermore, certain capital expenditures paid directly through escrow were not recorded in the organization's accounting records. To remediate these issues, management has taken the following corrective actions: - Delivered targeted training to staff on the proper treatment and reporting of federally funded capital expenditures; - Updated internal closing and reporting procedures to incorporate a formal review of balance sheet activity; and - Updated internal closing and reporting procedures to incorporate a reconciliation to settlement statements when recording new property acquisitions; and - Strengthened internal controls to ensure all federally funded capital items are accurately captured in future SEFA submissions. Management is committed to maintaining compliance with federal reporting requirements and ensuring the completeness and accuracy of future SEFA filings.

Finding: During the audit of the auditee's SEFA for the year ended December 31, 2022, we noted discrepancies related to incorrect identification of Assistance Listing Numbers for certain grants, as well as difficulty providing initial supporting detail for balances of expenditures for certain Federal programs. The auditee lacks sufficient internal controls over the preparation and review of the SEFA. Specifically, there is no established process to reconcile federal expenditures reported on the SEFA to the auditee's underlying accounting records. A formal review process involving an individual independent of the preparation was not conducted to ensure the SEFA was complete and accurate before submission to the auditors. Views of responsible officials and planned corrective actions: Management agrees with the recommendation to establish and document a formal, multilevel review process for the preparation of the SEFA. Baltimore Medical System recently hired a new grant accountant who will be responsible for the preparation of the SEFA. • The Controller will perform a detailed reconciliation of the SEFA’s data to the general ledger and supporting grant documents. • The Grant Accountant will develop a central repository that includes all grant contracts/awards and a summary document which contains the grant name, grantee, award amount and period, Assistance Listing Numbers, pass-through entity and subrecipient information. • Train relevant staff on the SEFA requirements governed by the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for the Federal Awards (2 CFR Part 200, 200.510(b)). Anticipated date of completion: December 31, 2025 Contact person responsible – Tammy Grinnan, Controller and Margaret Boemmel, CFO

Finding 2022 – 003: Reporting: Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Response: For the audit period and subsequent audit periods the employee responsible for the SEFA did not prepare the SEFA for the audit. For future audit periods the SEFA will be prepared by the Financial Consultant.

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