Corrective Action Plans

2022 – 005: Reporting (Compliance; Internal Controls Over Compliance) Material Weakness – 93.U01 Title V Condition: The Organization was unable to provide any of the required reports for the Title V program, including the financial report, activity narrative, third-party income report, GPRA/GPRAMA, urban data standards, and property inventory. Without these reports, we were unable to perform the necessary audit procedures to assess compliance with federal requirements. 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 reconciled monthly so this should take care of this issue. Management has worked on procedures and training to assure financial report, activity narrative, third-party income report, GPRA/GPRAMA, urban data standards, and property inventory are completed.

2022 – 004: Procurement and Suspension and Debarment (Compliance; Internal Controls Over Compliance) Material Weakness – 93.U01 Title V Condition: The Organization was unable to provide sufficient documentation to support compliance with federal procurement and suspension and debarment requirements for purchases made under the Title V program. The general ledger did not allow for sufficient identification of transactions related to the Title V program as all expenditures were recorded through journal entries without supporting transaction-level detail. Due to this limitation, we were unable to select procurement transactions for testing or verify whether vendors had been screened for suspension and debarment before contracts were awarded. Corrective Action Plan: As of October 1, 2024, the start of FY25 QuickBooks has been the only software uused,and Revenue and Disbursements are being classed by Fund. General ledgers are reconciled monthly. The following are updated procedures that are now in place. All purchases must come with a purchase order request and be signed by the supervisor prior to purchase. All purchases over $1000 must be CEO approved too. All purchases over $5000 must have 3 bids and be Board approved. All purchase orders must be completed completely in all fields to know what grant/funding source is covering the cost for draw downs. Anyone who uses the SDUIH credit cards must sign a credit card statement

2022 – 003: Activities Allowed and Unallowed, Allowable Costs, Period of Performance (Compliance; Internal Controls Over Compliance Material Weakness – 93.U01 Title V Condition: The Organization’s general ledger did not allow for sufficient identification of transactions related to the major program, Title V. Title V expenditures were recorded through journal entries without supporting transaction-level detail. Because of this, the population of expenditures could not be tied to individual transactions, and pulling samples from this population would not provide a reasonable basis for drawing conclusions about the population tested. As a result, we were unable to select transactions for testing or perform the necessary audit procedures to assess compliance with federal requirements. 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 reconciled monthly.

Views of Responsible Officials and Planned Corrective Actions: Management agrees that improvement is necessary with respect to reconciliation and documentation of credit card expenses. Management is in the process of updated their process surrounding credit cards.

Epidemiology and Laboratory Capacity for Infectious Diseases Cash Management Significant Deficiency in Internal Control over Compliance For the audited period and until August 2023, the procedure of the program and the Department of Health was "advanced" and was as follows: 1. The Epidemiology program worked with the validation of the voucher and recovered the director's signature for the punch of the "certificate". Once the validation and signature were in place, the cash request was processed. Once the cash request was remitted or the credit notice was registered, the receipt was delivered to the Tax Intervention area. 2. The Fiscal Intervention area works on the approval of the payment on the vouchers. Vouchers were worked on a first-come, first-served basis. This intervention process can take a week or more. The program had no control over the timing of payment approvals. This created a weakness when it came to cash management compliance. The program did confirm that the money was available at the time the payment was approved but had no control over the date the payment was approved. However, due to the nature of our funds and the volume of invoices, the Treasury Department asked us to change the modality for terms of cash requests from "advanced" to reimbursement. This began to be implemented as of September 2023. This method of reimbursement makes it easier for the program to have better control over cash management. With this method, the program requests the funds on the days that the Treasury Department makes the payment rolls. Once the petition is created on the same day of the print run and approved by the Program Director, it is submitted to the Office of Federal Affairs to prepare the request for funds to the federal government. The Office of Federal Affairs has the flexibility and agility to process such a request within two days. This helps us to meet the requirements of cash management.

2022-005 Significant Deficiency in Controls over Compliance: Administrative Requirements of Uniform Guidance-Administrative Policies The schools have documented their administrative policies effective 3/1/2023.

FINDING 2022-007 Contact Person Responsible for Corrective Action: Kristin Nass Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: In addition to on-going training and support of the Director of Grants/Programs who oversees Title I, a comprehensive checklist which includes required documentation and actions (including the verified data from non-pub school) is being developed and will be implemented in the spring of 2023. Checklist completion and reviewed data will be signed off by the CFO. Anticipated Completion Date: May 2023

FINDING 2022-006 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding. INDIANA STATE BOARD OF ACCOUNTS 67 Description of Corrective Action Plan: Additional training related to grant budgets entered into and monitored within the financial software will occur, as will the new practice of having the program directors initiating monthly reimbursement requests informed by the accurate reports from the software (ledger), with documented review by the Treasurer or CFO. Additional training over the reporting requirements is taking place with the Treasurer, CFO and Directors overseeing federal funds provide accurate reporting. Anticipated Completion Date: June 2023

FINDING 2022-005 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Instead of utilizing journal entries for corrections or adjustments in generic form, corrections to large or for multiple disbursements or receipts should be completed by reversing the action within the financial software and then correctly processing the disbursements or receipts. The on-going training and the related corrective actions which ensure more frequent and more in-depth reviews of reports on a monthly basis will also reduce the need for corrections in general. However, in the event there must be journal entries for corrections, documentation supporting and related to any journal entry will be input into the financial management software, as will any related notes, and any journal entry will have documented approval contained in that software, all completed by separate people ? the Treasurer and CFO. Additional, related training will also be sought to ensure related processes and controls are understood and followed. Anticipated Completion Date: May 2023

FINDING 2022-011 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Additional training related to grant budgets entered into and monitored within the financial software will occur, as will the new practice of having the program directors initiating monthly reimbursement requests informed by the accurate reports from the software (ledger), with documented review by the Treasurer or CFO. Additional training over the reporting requirements is taking place with the Treasurer, CFO and Directors overseeing federal funds provide accurate reporting. Anticipated Completion Date: June 2023

FINDING 2022-010 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Instead of utilizing journal entries for corrections or adjustments in generic form, corrections to large or for multiple disbursements or receipts should be completed by reversing the action within the financial software and then correctly processing the disbursements or receipts. The on-going training and the related corrective actions which ensure more frequent and more in-depth reviews of reports on a monthly basis will also reduce the need for corrections in general. However, in the event there must be journal entries for corrections, documentation supporting and related to any journal entry will be input into the financial management software, as will any related notes, and any journal entry will have documented approval contained in that software, all completed by separate people ? the Treasurer and CFO. Additional, related training will also be sought to ensure related processes and controls are understood and followed. Anticipated Completion Date: June 2023

Program: AL 21.026 ? COVID-19 Homeowner Assistance Fund ? Subrecipient Monitoring Corrective Action Plan: N/A Contact: Major General Daryl Bohac Anticipated Completion Date: N/A

FINDING 2022-003 Contact Person Responsible for Corrective Action: Teresa Stuckey, Director of Elementary Education and Title I Contact Phone Number: 812-462-4228 Views of Responsible Official: The School Corporation will implement effective processes to ensure that the Special Tests and Provisions ? Annual Report Card, High School Graduation Rate data is solicited and maintained for audit purposes. Description of Corrective Action Plan: The School Corporation will work to develop a more defined process that ensures compliance with procedures that were established, but have not always followed, to ensure that the Special Tests and Provisions ? Annual Report Card, High School Graduation Rate compliance requirement is met. Specific employees will be placed in charge of obtaining documentation from students leaving the district and others will be asked to review and approve the documentation. If documentation is not successfully garnered from parents, schools will maintain records indicating the school?s efforts to solicit the correct documentation from parents. Anticipated Completion Date: Immediately.

FINDING 2022-002 Contact Person Responsible for Corrective Action: Teresa Stuckey, Director of Elementary Education and Title I Contact Phone Number: 812-462-4228 Views of Responsible Official: The School Corporation will work with non-public schools to make sure that their enrollment is properly reported. Description of Corrective Action Plan: School Corporation personnel will work with non-public school representatives to secure accurate enrollment information and maintain the proper documentation for audit purposes. Additionally, enrollment data entered on the Title I application portal will be reviewed prior to submission to ensure that data entered agrees with supporting documentation. Anticipated Completion Date: During submission of the 23-24 Title I application.

FINDING 2022-003 Contact Person Responsible for Corrective Action: Janet McCreary, Director of Curriculum, Instruction, & Assessments Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Data Management Specialist will save all reports submitted to the DOE. This will ensure that supporting documentation is kept that will be used determine Eligibility for Title I. The Title I Compliance Specialist/Grants & Compliance Specialist will verify the information for accuracy and keep documentation of the review. Anticipated Completion Date: 2/13/2023

FINDING 2022-012 Contact Person Responsible for Corrective Action: Tricia Malone Hudson, District Curriculum Specialist Contact Phone Number: 812-279-3521 Views of Responsible Official: We concur with the audit finding. Description of Corrective Action Plan: The district will scan and save all testing security agreements for all staff. The test coordinator will be responsible for ensuring that all relative staff complete training and sign testing agreements. Anticipated Completion Date: North Lawrence Community Schools implemented this procedure beginning in September 2022.

FINDING 2022-006 Contact Person Responsible for Corrective Action: Melissa Hinds, Director of Special Education Contact Phone Number: 812-279-3521 Views of Responsible Official: We concur with the audit finding. Description of Corrective Action Plan: As it relates to retaining proper documentation for an audit for Activities allowed or un-allowed, and allowable cost/costs, a policy and procedure will be implemented regarding the documentation and retention of records. Review and approval of activities reimbursed by the Special Education Grants to States and Special Education Preschool Grants will have the appropriate backup documentation (e.g. invoices, purchase orders, contracts, receipts) to ensure alignment to the IDOE grant, as well as documentation that funds were encumbered within the financial system by the respective period of performance end date. As of July 2022, these activities began being reviewed and approved by two separate individuals. Anticipated Completion Date: July 2022

FINDING 2022-005 Contact Person Responsible for Corrective Action: Jami Parks and Stacey Teipen Contact Phone Number: 812-794-8750 Views of Responsible Official: We concur with the finding Description of Corrective Action Plan: The school corporation will implement internal controls to prepare, review and retain reports. The stated reporting was completed by both the Corporation Treasurer and Federal Programs Director, but the records were not initialed to show completion and review. Supporting documents will be kept as evidence of the data. Anticipated Completion Date: August 1, 2023

FINDING 2022-008 Contact Person Responsible for Corrective Action: Whitney Dixon, Treasurer Contact Phone Number: 574-533-8631 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Vendor claims with supporting documentation will be retained by the business office. Requests for reimbursements including supporting documentation, including financial and programmatic records, will be retained to verify allowable activities or costs. Anticipated Completion Date: May 2023

FINDING 2022-003 Contact Person Responsible for Corrective Action: Christopher Dixon, Director of Nutrition Contact Phone Number: 574-533-8631 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The School Corporation will document the review/oversight of disbursements from program funds prior to payment. Claims will be prepared and reviewed by Christopher Dixon, Director of Nutrition, or designee, and submitted to the Accounts Payable Specialist for payment. Claims will be initialed or signed demonstrating approval of disbursements. Accounts Payable Specialist enters claims into the financial software and pays claims after approval by the Chief Financial Officer and School Board. Documentation for claims will be kept in the business office. GCS will obtain prior written approval from IDOE and approval documents will be maintained by the Director of Nutrition. Assistant Superintendent, Dr. Barry Younhans, retired from GCS in July 2022. This corrected the finding. To ensure compliance, the payroll distribution report is reviewed and signed by the Treasurer and applicable program administrators prior to the completion of payroll by the payroll specialist. The report is reviewed to verify that employees are paid out of the correct accounting line. This process was implemented in December 2022. Anticipated Completion Date: April 2023 INDIANA STATE

Finding: 2022-003 Material Weakness in Internal Control over Compliance and Material Noncompliance U.S. Department of Labor Federal Financial Assistance Listing 17.258/17.259/17.278 WIOA Cluster Subrecipient Monitoring Finding Summary: The County did not formally communicate the required information to the subrecipient. No subrecipient agreement was executed. In addition, no monitoring activities were documented. Responsible Individuals: Dana Aschenbrenner, Finance Director Corrective Action Plan: Johnson County disagrees with the underlying premises of this finding. This finding is due in part to the fiscal agent agreement with Iowa Workforce Development (?IWD?) which does not state that subrecipient monitoring has to be done. Recently, IWD received a finding from the Department of Labor stating that the template fiscal agent agreements imposed upon fiscal agents by IWD improperly placed liability of disallowed costs onto the fiscal agents. According to DOL, IWD?s form of fiscal agent contract was incorrect, i.e., the liability was to stay with the local CEOs. In the wake of the finding, IWD is reissuing the contracts out to the regions to create compliant subrecipient entities within each, and then new fiscal agent agreements will be issued. Additionally, Johnson County will be ending it fiscal agent agreement, and no longer continue to be the fiscal agent as of June 30, 2023. Anticipated Completion Date: Ongoing

FINDING 2022-006 CONTACT PERSON RESPONSIBLE FOR CORRECTIVE ACTION: Ralph Shrader/Jim Beyer CONTACT PHONE NUMBER: 765-762-3364 VIEWS OF RESPONSIBLE OFFICIAL: We concur with the finding. DESCRIPTION OF CORRECTIVE ACTION PLAN: Information reported via Jotform will be produced by the Superintendent and verified by the Assistant Superintendent with documentation maintained. ANTICIPATED COMPLETION DATE: March 2023

Finding 2022-004 Subrecipient Monitoring and Special Tests and Provisions Material Weakness in Internal Control Over Compliance and Material Noncompliance Federal Agency Name: Department of Health and Human Services Program Name: Immunization Cooperative Agreements CFDA Number: 93.268 Finding Summary: The County did not formally communicate the required information to the subrecipient. No subrecipient agreement was executed. In addition, no monitoring activities were documented, including monitoring of the program?s special tests and provisions. Responsible Individuals: Allie White, County Health Department Executive Director Corrective Action Planned: Dubuque County is working with the Dubuque Visiting Nurse Association on implementing a subrecipient agreement and will put a control process in place to monitor. Anticipated Completion Date: June 30, 2023

Single Audit Corrective Action Plan FY 2022 / Finding: / AFG acknowledges that an internal control deficiency existed within the credit card process and procedures, during Fiscal Year 2022. The process required staff to forward credit card documentation to the finance department, via email, in person, or using an accounts payable mailbox. The finance staff would then collect and maintain all receipts and other supporting documents pending the monthly credit card review and reconciliation. After receiving the approved credit card statements from cardholders, the finance staff would undertake the task of matching the receipts and other support documentation to the appropriate staff person?s credit card. / In the current period, Fiscal Year 2023, the finance team has developed and implemented controls to ensure program expenditures on agency credit cards and supporting documents are: / 1. Reviewed and approved by a supervisor, to ensure that expenditures are allowable costs within the program and grant guidelines. / 2. Supported by the appropriate and required documentation. / 3. Submitted timely both internally to the finance department, as well as externally to funding sources. / 4. Stored and maintained for future refence, by the finance department and the program staff responsible for credit card purchase. / 5. Reviewed for financial recording accuracy by the finance department's grants manager and controller. / In January 2023, AFG management, including the finance team, revised and streamlined the credit card process by eliminating multiple modes of submission for credit card required documentation, reducing the occurrence of misplaced documents. The new process also includes the development and implementation of an electronic shared filing system. The credit card expenditures and supporting documents are maintained in the electronic files by the cardholders' names and are also uploaded to the accounting software. / Additionally, effective March 31, 2023, AFG revised the agency's Credit Card Policy and Procedures to include fixed deadlines for the submission of credit card required documentation. The revision also outlined more specifically the required process for submitting credit card documents. As stated, in the revised procedures, monthly credit card packages must be submitted to the finance department on or before the established deadline, via email. The Credit Card Packages include the approved Staff Credit Card Statement, legible copies of credit card receipts, and any other required documentation that supports the purchase. / Additional enhancements to the credit card process include reviews for accuracy by the grant manager and controller of credit card reconciliations and financial postings. The credit card packages are uploaded and maintained on AFG's accounting software, and the finance department's shared files. Credit Card Packages are only submitted to and accepted by the finance department via email. The AFG staff member who is responsible for the credit card purchase must maintain the hard copy of the purchase receipt and any other support documents received directly. / AFG's management appreciates the efforts of the George Johnson & Company auditing staff, as well as this opportunity to strengthen the internal control structure and procedures. We are confident that the revised credit card procedures will significantly reduce the occurrences of misclassifications of program expenditures and misplacement of required support documentation.

FINDING 2022-009 Contact Person Responsible for Corrective Action: Kasey Clark Contact Phone Number: 574-772-1604 Views of Responsible Official: We concur with the findings Description of Corrective Action Plan: Internal controls will be in place for ESSER funds so that Treasurer and Superintendent or Title I specialist will sign off on annual reports to ensure accuracy of ESSER dollars spent. Anticipated Completion Date: March 2023