Corrective Action Plans

FINDING 2022-005 Finding Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Summary of Finding: Material Weakness, Modified Opinion The County did not have an effective internal control system to ensure compliance with the Reporting compliance requirement. Recipients are required to submit quarterly or annually Project and Expenditure (P&E) Reports to the Department of the Treasury (Treasury). The County submitted four quarterly P&E Reports during the audit period. The County's process for the completion and submission of the P&E Reports was that the County Auditor prepared each P&E Report based on the County's Financial Ledgers, without a proper oversight or review process in place prior to submission. All four quarterly reports that were due during the audit period were not properly supported by the County's records Contact Person Responsible for Corrective Action: Timothy Stabosz Contact Phone Number and Email Address: 219-326-6808 x2226 tstabosz@laporteco.in.gov Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: To correct this finding, we will require one person to complete the report and another to review the report prior to submission. Anticipated Completion Date: We will begin requirement a review prior to submission as of November 21, 2024.

FINDING 2022-005 Finding Subject: CDBG ‐ Entitlement Grants Cluster ‐ Period of Performance Summary of Finding: The county did not have properly designed internal controls in order to prevent or detect errors in the general ledger for activities related to adjustments to Community Development Block Grant funds during the transition and implementation of the Oracle accounting system. Contact Person Responsible for Corrective Action: Dan Ciecierski, Comptroller Contact Phone Number and Email Address: 219-755-3137 | ciecidx@lakecountyin.org Views of Responsible Officials: We concur with the finding. Explanation and Reasons for Disagreement: N/A Description of Corrective Action Plan: Lake County has begun execution of a comprehensive strategy in order to address the lack of internal controls around its financial transactions and reporting in a number of ways. The following will address control issues identified in these areas: - Financial Transactions and Reporting - Employee Benefit Accrual (EBA) Fund - Cash and Investments - Receipts - Journal Entries - Financial Statement & Reporting First, a more qualified consulting firm has been hired to assist on two important fronts related to the new accounting system: 1. The first is the reimplementation of the Oracle accounting software which is inclusive of correcting data and poor configurations from the prior consultant, and deploying additional appropriate functionality to allow the County to optimize Oracle to suit the accounting needs from a process standpoint as well as an internal control perspective. Oracle in and of itself allows the county to implement strategic preventative internal controls via role-based access features. Said differently, Oracle has a more robust and granular ability to automatically create separation of INDIANA STATE BOARD OF ACCOUNTS 41 duties among employees and departments simply by restricting the ability to perform actions which should be naturally segregated to mitigate risk of error. 2. Secondly, the managed services portion of the consulting contract will aid the County in running the business activities related to both the Oracle Human Capital Management (HCM) module and the Enterprise Resource Planning (ERP) module (Purchasing, Accounts Receivable, Accounts Payable, and General Accounting). Another initiative being executed to address the lack of internal controls is to attract, and hire qualified professionals who have years of real world, practical experience in the field for which a job relates to. During the original implementation of the Oracle system there was no one who fully understood, nor had a background in the professional field of accounting in the Auditor’s Office. The County has hired a Comptroller who passed the CPA, and has spent their entire career in the field of accounting. This individual has worked in the corporate utility and banking industries and has experience in GAAP reporting, regulatory reporting, internal controls, and overall general accounting. Additionally, the Comptroller has been involved with internal and external audit compliance as well as the installation, user acceptance testing, and transition of new accounting software. In order to mitigate the risk of error for any adjusting entries made which are recommended by consultants, the Comptroller of Finance must review and approve these entries. Anticipated Completion Date: 1. This process has already been put into place and is being executed.

FINDING 2022-004 Finding Subject: CDBG – Entitlement Grants Cluster—Reporting Summary of Finding: Condition and Context: The County did not have internal control procedures over the Quarterly Reports (PR29), IDIS Section 3 Performance Report, and NSP Quarterly Reports. One individual prepared or generated the report without a review or oversight process. Additionally, the County’s internal controls were not consistently documented over the draw down requests for the CDBG grant during the audit period. The draw down requests were entered into IDIS, which then becomes the basis for several of the reports. The control presented by the County was that one individual prepared and entered the request, which would then be printed, and another individual would review and sign the printed request to document the review. Of the thirteen reimbursement requests tested, control documentation for eight of the requests were printed and signed during current period, after the documentation was requested. The creation of documentation of the control procedure did not support that internal controls were effective during the audit period. Recommendation: We recommended that the County's management design and implement a proper system of internal controls, and retain documentation of its system of internal controls, to ensure compliance with reporting requirements. Contact Person Responsible for Corrective Action: Timothy A. Brown Contact Phone Number and Email Address: 219-755-3225 and brownta@lakecountyin.org Views of Responsible Officials: LCCEDD concurs with the audit finding. Concurrence: The Fiscal Officer from the Audit Period was new to the position and her training was focused on the changes to the financial systems at the county over the DRGR quarterly reporting of NSP actions. Further, Finding 2022-003 also caused some of the reporting issues with CDBG of having two CDBG funds and posting errors to these funds. The current LCCEDD Fiscal Officer found the problems during the audit and corrective actions were done retroactively to address this part of the finding with the drawdown requests. The CDBG drawdowns were submitted into IDIS by the Fiscal Officer who printed out the drawdown request. These printouts were then given to the Executive Director or the Deputy Director who then went into IDIS and approved the drawdown request, then print out the IDIS drawdown approval and return the request and the signed approval back to the Fiscal Officer. LAKE COUNTY COMMUNITY ECONOMIC DEVELOPMENT DEPARTMENT 2293 N. Main Street - Crown Point, In 46307 Tel. (219) 755-3225 www.lakecountyin.org INDIANA STATE BOARD OF ACCOUNTS 38 Description of Corrective Action Plan: LCCEDD staff have already adopted changes in internal controls to correct the CDBG reporting deficiencies as described in Finding 2022-003. Further, management will oversee compliance with current policies and the new quarterly reconciliations. LCCEDD policies will be updated to make the following changes: General Management and Oversight: On an on-going basis, the Director will meet with Department staff to determine if training or technical assistance is needed to complete HUD reporting requirements in a timely and accurate manner. NSP Quarterly Reports: To be followed until the HUD field office indicates QPR reports are no longer needed due to grant closeout: 1. Before the close of each month, the Fiscal Officer will create receipts and draws as needed in HUD’s DRGR system to reflect funds receipted or expended by the County. 2. At the close of each quarter, the Fiscal Officer will prepare and submit the quarterly report in DRGR for the NSP1 and NSP3 grant allocation. To prepare the report, the Fiscal Officer will reconcile all expenses and receipts posted in the County’s general ledger system for the NSP programs with the receipts and drawdown requests recorded in in HUD’s DRGR reporting system. 3. Before submitting the NSP QPR Report in the DRGR system, the Deputy Director will review and approve the prepared reconciliation and QPR Report. Any discrepancies between the two systems will be reported to the Auditor and the Department Director to determine corrective actions. 4. Within 30 days of the close of each calendar quarter, the Fiscal Officer will submit the NSP QPR Report via DRGR. The Fiscal Officer will maintain a copy of the NSP QPR and the corresponding reconciliation in their program files. Cash on Hand Reports: 1. At the close of each quarter, the Fiscal Officer will prepare and submit the Cash on Hand Report within thirty days of the close of the quarter. The Fiscal Officer will reconcile all expenses and receipts posted in the County’s general ledger system with the receipts (report PR09) and drawdown requests (report PR07) in HUD’s IDIS Online reporting system. 2. Before submitting the Cash on Hand Report in the IDIS Online system, the Deputy Director will review and approve the prepared reconciliation and Cash on Hand Report. Any discrepancies between the two systems will be reported to the Auditor and the Department Director to determine corrective actions. 3. Within 30 days of the close of each calendar quarter, the Fiscal Officer will submit the Cash on Hand Report via IDIS Online. The Fiscal Officer will maintain a copy of the Cash on Hand report and the corresponding reconciliation in their program files. INDIANA STATE BOARD OF ACCOUNTS 39 Section 3 Reporting: 1. As part of the application review, the Deputy Director will determine the applicability of the Section 3 requirements for each proposed project. 2. For projects where Section 3 is applicable, the Deputy Director will ensure that staff administering the project are familiar with the Section 3 requirements and understand the forms and reporting required to properly report Section 3, including the determination of total labor hours worked, labors hours worked by Section 3 and Targeted Section 3 workers, and corresponding certifications. 3. The County will collect Section 3 reports from subrecipients administering projects throughout the period of performance. If the project meets Section 3 benchmarks, the County will consider the activity to be in full compliance with Section 3. If the project does not meet one of the Section 3 benchmarks, the County will require reporting on the qualitative efforts that the subrecipient made to try to reach the benchmarks. 4. Section 3 information collected for each project will be reported in IDIS Online. The Section 3 information must be reported annually before the submission of the annual report (CAPER) to HUD. Anticipated Completion Date: Part of the corrections have already been put into place and the Policy and Procedure Manual will be amended in April of 2025 after the Lake County Redevelopment Commission adopts appropriate changes.

FINDING 2022-003 Finding Subject: CDBG – Entitlement Grants Cluster—Program Income Summary of Finding: Condition and Context: The County received program income through various loan programs it offered to qualifying individuals. Once the County received a loan payment, the receipt was posted into the financial accounting system of the County and recorded in a grant fund. The amount received was also to be recorded in the Department of Housing and Urban Development’s (HUD) Integrated Disbursement & Information System (IDIS) website. The recorded program income in IDIS would then appear on the Drawdown Report by Voucher Number report (PR07). No internal control process had been established over the program income compliance requirement. One individual was responsible for notifying the Auditor's office when program income money was received, in order for it to be receipted in the County’s financial accounting system. The same individual was also responsible for reporting the same on IDIS site. No controls were established to ensure the program income that was recorded in the financial accounting system was also reported on IDIS site and the PR07 report. Additionally, four receipts totaling $38,960 were selected for testing from the County’s receipt ledger. These four receipts were unable to be located on the PR07 report provided for audit. One of the four receipts was recorded in the IDIS system after information regarding the receipt was requested. The receipt was not in the PR07 report that had been provided for audit when we were provided information documenting it being recorded in IDIS. Furthermore, we were unable to verify the total amount recorded in receipt ledger to the total reported on PR07 report. The County’s ledger was greater than the PR07 report by $30,324 and is primarily attributed to under reporting of program income in IDIS as identified above. Recommendation: We recommended that the management of the County establish a system of internal controls to ensure that all program income received is properly reported in the IDIS system and expended prior to drawing down federal awards. Contact Person Responsible for Corrective Action: Timothy A. Brown Contact Phone Number and Email Address: 219-755-3225 and brownta@lakecountyin.org Views of Responsible Officials: LCCEDD concurs with the audit finding. LAKE COUNTY COMMUNITY ECONOMIC DEVELOPMENT DEPARTMENT 2293 N. Main Street - Crown Point, In 46307 Tel. (219) 755-3225 www.lakecountyin.org INDIANA STATE BOARD OF ACCOUNTS 36 Description of Corrective Action Plan: LCCEDD staff have already adopted changes in internal controls to correct the Program Income reporting deficiencies. The process is as follows: 1. All incoming checks into the department are first reviewed by the Deputy Director. The Deputy Director determines the source of income (i.e. CDBG, HOME, NSP) and the correct receipt type (program income, repayment, homebuyer). The Deputy Director records the IDIS number of the project on the check before giving it to the Fiscal Officer. 2. The Fiscal Officer records the receipt on an internal schedule of receipts and submits the check to the County Auditor with the check deposit form with the IDIS number and correct fund and account number for deposit. 3. Once the County Auditor posts the receipt to the County’s general ledger, the Fiscal Officer records the Auditor’s receipt into HUD’s IDIS Online reporting system. 4. At the close of each quarter, the Fiscal Officer will prepare and submit the Cash on Hand Report within thirty days of the close of the quarter. The Fiscal Officer will reconcile all expenses and receipts posted in the County’s general ledger system with the receipts (report PR09) and drawdown requests (report PR07) in HUD’s IDIS Online reporting system. Before submitting the Cash on Hand Report in the IDIS Online system, the Deputy Director will review and approve the prepared reconciliation and Cash on Hand Report. Any discrepancies between the two systems will be reported to the Auditor and the Department Director to determine corrective actions. 5. Within 30 days of the close of each calendar quarter, the Fiscal Officer will submit the Cash on Hand Report via IDIS Online. The Fiscal Officer will maintain a copy of the Cash on Hand report and the corresponding reconciliation in their program files. 6. On an on-going basis, the Director will meet with Department staff to determine if training or technical assistance is needed to complete HUD reporting requirements in a timely and accurate manner. Anticipated Completion Date: A policy and procedure amendment will be written by the end of this year and presented to the Lake County Redevelopment Commission for their March 2025 meeting for adoption.

2022-006 Program: WIOA Cluster Federal Financial Assistance Listing Number: 17.258, 17.259, 17.277, 17.278 Federal Grantor: U.S. Department of Labor Pass-Through: California Department of Employment Development Award No. and Year: AA011008 and 2019 Compliance Requirements: Subrecipient Monitoring Type of Finding: Material Weakness Management’s or Department’s Response: Imperial County Workforce Development Office (ICWDO) agrees with the finding. Views of Responsible Officials and Corrective Action Plan: The questions from finding 2021-008 relate to a formalization of the fiscal processes and protocols. ICWDO operates under WIOA guidelines and follows Imperial County’s fiscal policies. Internal policy will be formally updated to reflect compliance with WIOA regulations, as well as Imperial County policies. These policies will include formal controls and procedures to evaluate each subrecipient’s risk of noncompliance. Once the formal procedure is drafted, it will go through the ICWDO Policy Committee for comment and direction, and then finally reviewed and approved for implementation by the full Workforce Development Board. Additionally, for any future Memorandums of Understanding (MOUs) between this Imperial County department and any outside agency, there will be an additional step to include review by Imperial County Counsel to reflect that recital around the funding source will specify the following required information: • Federal Award Identification Number • Federal award date of award to recipient by the Federal agency • Name of Federal awarding agency • CFDA Number • Specific identification of whether the award is research and development ICWDO will develop internal policies for formalizing all subrecipient monitoring process. ICWDO operates under WIOA guidelines for monitoring; therefore a formal internal policy for future contracts will be developed and implemented using the usual review and approval procedures followed by the department. ICWDO will develop a formal internal documentation system, with appropriate checks and signatures, for the evaluation and assessment of each subrecipient’s risk of noncompliance. ICWDO will utilize this formal process to properly document the risk assessment of all subrecipients. ICWDO anticipates to implement the corrective action by December 31, 2023. Name of Responsible Person: Priscilla A Lopez, ICWDB Director Implementation Date: December 31, 2023

Responsible: Denice Hairston, Chief Quality, Compliance and Accountability Officer Corrective Actions: Update subrecipient award agreements to ensure the final approved scope of work or project description is specified. Completion Date: March 29, 2023 Explanation: Policies and procedures were updated in 2023 in response to an OJJDP/OCFO recommendation to ensure subaward files contain the requisite components for the award agreement. In addition to these updates, which include a master file checklist, National CASA/GAL has updated the subrecipient Terms & Conditions agreement to include CFR requirements as recommended.

Invoices that are received will be scanned to “invoices”. This will direct them to our electronic software, Docuware. The item will then be forwarded to the appropriate Program Director for approval, and they will indicate the appropriate cost centers / allocations. Bookers will then review the approved coding and entered fiscal software. If there is a question or concern about approved coding by the bookkeeper they will speak with Director of Finance, Ethan Terrio. Once invoices are entered into fiscal software, checks will be printed. The check stub and invoice will be attached to each other and filed in the fiscal department. Paper documents will continue to be maintained in fiscal until we go 100% paperless, then all documents will be stored in Docuware.

FINDING # 2022-010No finding in prior yearAs recommended, the DCA will review current procedures to ensure that all subaward information required by the federal Uniform Guidance is included in all subaward contracts and grant agreements. The DCA has also reviewed its current subrecipient monitoring procedures for standard subawards made by the agency and has determined that no internal control enhancements are required. The HAF award was a unique grant relationship for DCA in that the entire award was passed through to another New Jersey State government agency that is a direct affiliate of the Department. Monitoring procedures were determined based on the close working relationship with our affiliate organization and the fact that less than 1 percent of the grant award was expended through June 30, 2022. Current procedures included a risk assessment of the subrecipient and performance of the single audit desk review of the independent audit report. In addition, the Director of Audit, and the Executive Director of the subgrantee affiliate participate in weekly meetings where updates on the program status can be determined. DCA?s subrecipient monitoring plan also includes the hiring of an Integrity Monitor to oversee and monitor the use of the HAF funds as well as compliance with all HAF program reporting requirements. As program disbursement activity is continuing to increase with the HAF program(s) created more fully up and running, DCA is currently targeting the Integrity Monitor hire to take place sometime within the next three to six months.COMPLETION DATE/CONTACT PERSON Fiscal Years 2023 and 2024John Alexy(609) 913.4385John.Alexy@dca.nj.gov

FINDING 2022-005Subject: Child Nutrition Cluster - Procurement and Suspension and DebarmentFederal Agency: Department of AgricultureFederal Programs: School Breakfast Program, COVID-19 ? School Breakfast Program, National SchoolLunch Program, COVID-19 ? National School Lunch Program, Summer Food Service Program, COVID-19 ?Summer Food Service ProgramALN Numbers: 10.553, 10.555, 10.559Federal Award Numbers and Years (or Other Identifying Numbers): FY21, FY22Pass-Through Entity: Indiana Department of EducationCompliance Requirements: Procurement and Suspension and DebarmentAudit Findings: Material Weakness, Other MattersContact Person Responsible for Corrective Action: Chad Yencer - SuperintendentContact Phone Number: 765-348-7550Views of Responsible Official: We concur with this findingDescription of Corrective Action Plan:BCS has established the following internal controls to ensure compliance:1. Internal Control: When a purchase is made at $10,000 or more using Federal Funds, thesuperintendent will require that any vendors selected are in compliance with theProcurement and Suspension and Debarment compliance requirement by completing one ofthe following quality checks with each vendor prior to purchase:a. Checking the federal System for Award Management (SAM) database athttps://sam.gov/content/exclusions and maintain a screenshot of the search results.b. Collect a certification from the vendor directlyc. Add a clause or condition to the covered transaction with the vendorAnticipated Completion Date:This corrective action will be implemented and completed immediately with any purchase made that meets theabove threshold.

FINDING 2022-002Contact Person Responsible for Corrective Action: Janetta C HardyContact Phone Number: 812-752-4343 X222Views of Responsible Official:I concur with the finding.Description of Corrective Action Plan:In April of 2022 the City of Scottsburg?s annual reporting of COVID 19 ? State and Local Fiscal RecoveryFunds for 2021 provided the Common Council?s allocated expenditures for the reporting period instead ofactual expenditures for the reporting period. This error was corrected in the 2023 reporting for April 1,2022 ? Mar 31, 2023 expenditures. However the cumulative obligations and the current periodobligations were again reported as the total grant award. This will be corrected in the April 2024reporting.In regards to this finding, as clerk treasurer I reviewed the report created by Tish Richey and submittedwith inaccurate numbers. I qualify this under human error, commonly known as a mistake. In the future, Iwill do my best to not make a mistake in reporting and retain the initialed documentation for what issubmitted. Lastly, this was the first year for federal reporting of these funds and the instructions wereambiguous at best.Anticipated Completion Date: April 2024

FINDING 2022-001Contact Person Responsible for Corrective Action: Mayor Terry AmickContact Phone Number: 812-752-3169Views of Responsible Official: I concur with the findings.Description of Corrective Action Plan: The City plans to review existing policies and procedures andmake any needed changes to endure that they are in compliance with the federal compliancerequirements for procurement as well as suspension and debarment. Furthermore, controls will beestablished to ensure that the City?s policies related to compliance with the federal compliancerequirements for procurement as well as suspension and debarment are followed.Anticipated Completion Date: December 31, 2023

FINDING 2022-003􀯗 Finding Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting􀯗 Summary of Finding:􀯗􀯗 Recipients are required to submit quarterly or annually Project and Expenditure (P&E) reports to the Department of the Treasury (Treasury). The reporting periods, as well as the respective due dates, are based upon type of recipient and its population, as well as the recipient's allocation amount. Information to be reported includes projects funded, expenditures, and contracts for the appropriate reporting period. The County was classified as a metropolitan county with a population below 250,000 residents that received an allocation of more than $10 million in Coronavirus State and Local Fiscal Recovery Funds (CSLFRF). Therefore, quarterly P&E Reports were due by January 31, 2022, and the last day of the month after the end of each quarter thereafter. The County submitted four quarterly P&E Reports during the audit period. The County’s process for the completion and submission of the P&E Reports was the Grant Administrator prepared the P&E Reports and the County Auditor reviewed them prior to submission; however, the control was not effective in detecting and preventing noncompliance. Two of the four quarterly reports submitted during the audit period were selected for testing. The County utilized the current period obligations field to document total obligations less current period expenditures. For the reports tested, the current period obligations, per the County’s interpretation of the field, were not supported by the County’s records. The following errors were noted: Quarter 2 P&E Report (April 1, 2022 - June 30, 2022) 􀄁 The Current Period Obligations for the Revenue Replacement project were overstated by $399,097. Quarter 3 P&E Report (July 1, 2022 - September 30, 2022) 􀄁 The Current Period Obligations for the Prairie Creek Water Run Water Line project were overstated by $67,773. 􀄁 The Current Period Obligations for the Parks Department - Latrine project were overstated by $25,758. 􀄁 The Current Period Obligations for the Foraker/Southwest project were overstated by $230,338. The lack of effective internal controls and noncompliance was a systemic issue during the audit period. Contact Person Responsible for Corrective Action: Patricia Pickens Contact Phone Number and Email Address: 574.535.6719 ppickens@elkhartcounty.com􀯗 􀯗 􀯗 INDIANA STATE BOARD OF ACCOUNTS 36 117 N. 2ND St Rm 203 Goshen, IN 46526 - 574-535-6719 􀀃 Views of Responsible Officials:􀯗􀯗 We disagree with the finding.􀯗􀯗 􀯗 Explanation and Reasons for Disagreement:􀯗􀯗 The finding does not accurately reflect the administration of the SLFRF program and fails to correctly identify key challenges that impacted the difference in data. There is a rigorous system of diligent records keeping, auditing expenditures, and internal controls including multiple points of review and approval for reporting ARPA funds. All expenditures are accounted for and maintained with supporting documentation. The auditing team can clearly demonstrate attention to detail in the tracking and reporting of all expenditures. They also have extensive record of on-going issues with the reporting portal including tickets and communications with Treasury support. They have identified issues with the portal that prevented the submission of reports or caused erroneous calculations/data.

POF’s initial exposure to Single Audit compliance requirements has sharpened its focus on the need to purposefully identify and maintain corroborating evidence regarding its timely submission and acceptance by each of the respective funding sources. While POF believes that all these reporting requirements were timely met and accepted by all funding sources, it did not consistently maintain either the report itself, or the related documentation such as copies of the emails sent or the associated read-receipts as evidence of these reports. Effective July 1, POF will routinely and consistently accumulate and organize these documents as well as ancillary evidence of their transmission to, receipt by, and acknowledgement of acceptance by the federal agency. As it deems necessary, POF will seek professional education and advice in implementing policies, practices, and procedures in addition to those already described herein.

FINDING 2022-002 Finding Subject: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds - Reporting Summary of Finding: Material Weakness, other matters. 2022 Q4 P&E report failed to include a $1,500,000 expenditure. Recommendation is that management of County design and implement a proper system of internal control including policies and procedures to ensure that the County provides Treasury with complete and accurate information for the P&E report. Contact Person Responsible for Corrective Action: Adam Gadberry Contact Phone Number and Email Address: 317.346.4392 agadberry@co.johnson.in.us Views of Responsible Officials: “We concur with the finding.” Description of Corrective Action Plan: The $1,500,000 expenditure for road repairs was one of two tranches for road repairs. The first tranche was in the proper location of -122 while the second tranche was placed in location -201 and as a result the expenditure was inadvertently missed. The County became aware of the issue and included this expenditure on the subsequent P&E Report for Q2. Moving forward as programs are added, the location of those funds should be in location -122. When they must be in a different location, access will be given to the Board of Commissioners Executive/Administrative Assistant to track expenditures. Anticipated Completion Date: June 30, 2024

FINDING 2022-001 Contact Person Responsible for Corrective Action: Terri Gadd, Clerk-Treasurer Contact Phone Number: (765) 364-5150 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Starting with the 2023 reporting of State and Local Fiscal Recovery Funds (SLFRF) Compliance Reporting to U.S. Treasury: The City of Crawfordsville management will follow the following process. 1. Before processing request from designated organizations the Clerk Treasurer and Mayor or a designated person, will review documentation and approve for payment/claim processing. 2. After approval a claim will be submitted to the Clerk Treasurer office for payment. 3. Clerk Treasurer will prepare and submit monthly expenditure report to the Mayor or designated person. 4. Annually before the Clerk Treasurer, reports to the U.S. Treasury expenditures the Clerk Treasurer and Mayor, or designated person, will review and confirm expenditures. 5. Clerk Treasurer will submit report to U.S. Treasury following prompts. 6. Clerk Treasurer will notify Mayor of the annual report submission. Anticipated Completion Date: January 2024

The Board of County Commissioners will take measures to ensure future compliance with all requirements of federal grants

The Board of County Commissioners will take measures to ensure future compliance with all requirements of federal grants.

FINDING 2022-002 Finding Subject: Special Education Cluster (IDEA) - Procurement and Suspension and Debarment Summary of Finding: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Procurement and Suspension and Debarment compliance requirement. The School Corporation had not designed or implemented adequate policies or procedures to ensure that proper procurement procedures for small purchases were followed. There was no oversight, review, or approval process in place and documented at the School Corporation to ensure proper procedures were followed and price or rate quotations were obtained, or documentation to support limited procurement procedures conducted. Federal regulations allow for informal procurement methods when the value of the procurement for property or services does not exceed the simplified acquisition threshold, which is set at $150,000 per Indiana Code. This informal process allows for methods other than the formal bid process. The informal process is divided between two methods based on thresholds. Micropurchases, typically for those purchases $10,000 or under, and small purchase procedures for those purchases above the micro-purchase threshold, but below the simplified acquisition threshold. Micro-purchases may be awarded without soliciting competitive price rate quotations. If small purchase procedures are used, then price or rate quotations must be obtained from an adequate number of qualified sources. The School Corporation did not obtain price or rate quotes for the five vendors tested that was less than the simplified acquisition threshold of $150,000 but exceeded the $10,000 micropurchase threshold. Documentation detailing the history of procurement, which must include the reason for the procurement method used, was not available for audit. The School Corporation also did not follow procurement requirements for contracted services which exceeded the simplified acquisition threshold of $150,000. The School Corporation did not correctly procure a contract for the one vendor that exceeded the simplified acquisition threshold. Additionally, the School Corporation did not adequately maintain documentation of the procurement history or rationale. Finally, the School Corporation did not verify that this vendor was not excluded or disqualified from participation in federal assistance programs or activities. Contact Person Responsible for Corrective Action: Matthew Miles, CFO Contact Phone Number and Email Address: 317-423-8380 mattmiles@msdlt.k12.in.us Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: The School District will obtain 3 quotes or do a bid process in the future. If there is limited availability, we will document the reason 3 quotes are not possible. Additionally, the District INDIANA STATE BOARD OF ACCOUNTS 34 will check for suspension and debarment, create a write-up of our findings, and obtain Board approval for the contract. Anticipated Completion Date: The School District will implement changes described in the Corrective Action Plan February in 2024.

(A) CDHS agrees that it needs to it needs to correct the automated reporting process from the eClearance system used to gather data needed for our FFATA reporting. The department thought that the reports obtained from eClearance were complete and relied on them as the basis of our reporting. Upon investigation we found that an internal process change enacted during the implementation of another system at the start of the pandemic was the cause of the data discrepancy. This occurred because the new system made the routing in eClearance after a certain point unnecessary for internal processing so this stopped. It was unknown that this further routing to archive files in eClearance was the trigger for eClearance to push out FFATA report data. Since the department has been able to identify the cause we are able to immediately remedy the problem and ensure that all processes are in sync to ensure accurate and complete FFATA data is contained in automated reporting processes. The department will catch up on FFATA reporting that was missed during this time frame. (B) The department agrees that it needs to implement procedures to validate that data derived from automated processes used as a basis for FFATA reporting should be periodically validated against another data source. To do this the department will create and implement procedures to use CORE reports of encumbrance data referencing subrecipient object codes and tie this to information received from the automated eClearance report. Doing this will validate that the data provided from eClearance is a complete listing of all FFATA reportable subrecipient awards, and thus is a valid source to base FFATA reporting on. This will also help us monitor the process in case any future inadvertent changes are made to processes that could cause data validity issues. (C) CDHS agrees that a supervisory review is needed over the FFATA reporting process in order to ensure more consistency, accuracy and timeliness in reporting processes and standards. The department is currently developing procedures that will allow for more oversight of the FFATA reporting through supervisory reviews and cross training staff on FFATA reporting duties. Supervisory reviews will help ensure that reporting is completed in line with reporting procedures and timeframes and can be a second set of eyes to ensure that information appears accurate and adds analytical judgement value (example - a supervisor might see that July typically has high volume, but this July volume is low, why). In addition, the department is taking this opportunity to cross train other staff on the process so that more individuals can be involved which leads to more transparency over processes allowing various individuals to notice if something isn't working as designed. These new procedures are being developed and implemented as the department catches up on reporting subrecipient awards that were missed since the automated process stopped working.

(A) CDHS agrees to enhance internal controls over monthly P-EBT reporting to better ensure accuracy. P-EBT is a new program derived from pandemic funding. Being a new program with a lack of federal guidance at implementation, and urgency to get the funds disbursed program staff had to learn about the nuances of the program and the reporting requirements as it was being implemented. During implementation we recognized that there are some inherent differences with P-EBT from other benefit programs which caused processes to have to be adjusted slightly. Additionally, timing of federal report filing for the P-EBT program is not in synch with our other processes and associated federal reporting requirements and deadlines. This makes it impossible to ensure reconciliation procedures are performed before filing occurs, which is one of our typical internal controls. As a compensating internal control CDHS will ensure that supervisory review processes are performed over P-EBT reporting, and that P-EBT reporting is reconciled to other sources (CBMS and CFMS) as soon as possible after reporting is available. If changes are discovered CDHS will make adjustments to filed P-EBT reports as needed based on reconciliation findings, and communicate changes to necessary parties. (B) CDHS will work to ensure better coordination between program activities and the accounting section relating to federal reporting changes. Accounting will iterate the importance of timely informing the accounting staff when changes are made to program filed federal reports. This message will be delivered in periodic fiscal meetings and identified on the closing calendar. The P-EBT program will ensure that corrections are communicated to accounting on any updates completed on the FNS-292-B report upon discovery, and no later than 30 days after the reporting period. (C) CDHS will ensure that review and approval processes are occurring as designed at various points in the process leading up to entry into CORE. As part of the Requisition (RQS) approval process program and accounting staff independently approve that the correct direct or subrecipient object code is used. These approved RQS transactions are then transitioned into encumbrance documents that drive which object code future expenditures will be booked to. For CCDF transactions related to this finding, both the OEC and Accounting teams inadvertently approved an incorrect object code in 4 RQS's. Staffing shortages coupled with a large increase in workload related to pandemic funding contributed to this oversight. To correct OEC and Accounting will train new staff, periodically familiarize themselves with the appropriate object codes, and perform quality assurance review over object codes before applying approval in CORE. The K1 is compiled from balances derived from expenditure data recorded in CORE. The compilation of the K1 relies on the fact that expenditure balances are accurate, and that prior reviews and approvals of individual transactions have occurred as designed. The K1 currently goes through various levels of review focusing on balance level validation coupled with analytical procedures. To enhance the review process, CDHS will ensure analytical procedures include line level expenditure comparison at the direct and subrecipient levels.

(A) We agree with this recommendation. In recent years, the Federal Government had multiple continuing resolutions in their budget process, resulting in CDE?s Title I allocations coming in multiple iterations. For the last several years, CDE has received revised allocations from the US Department of Education for the fiscal year as late as early summer; in one example, we received six revisions. With staffing shortages and the administrative burden to continuously revise, research issues and update FFATA for each allocation change, CDE took the step to report only the final allocation to FFATA, which was reported as of the month the awardee was awarded. However, the report was submitted later in the fiscal year. CDE will take a two-fold approach to rectify the issue related to the required FFATA reporting for Title I. First, we will report to FSRS the initial awards within 30 days following the date the awardee was provided final approval on their award. This is consistent with CDE?s approach to all other federal awards. Second, we will monitor the continuing resolutions and changes in allocations, and report only the net changes to each awardee, in the month those changes occur from the US Department of Education. Thereby, FSRS will represent the total revised award. In addition to this approach, all Title I awards will continue to be a part of our regular FFATA reconciliation process. (B) We agree with this recommendation. CDE identified its own failure to report two ESSER subawards to FFATA within 30 days as part of the successful development and implementation of a FFATA-specific reconciliation process in Summer 2022. CDE will continue to refine and improve its FFATA reconciliation process.

By the implementation date, the Department of Labor and Employment (CDLE) will complete a review of grant agreements for reporting requirements, including the Federal Funding Accountability and Transparency Act of 2006. By the implementation date, the CDLE will develop and implement appropriate controls and processes to come into compliance with the reporting requirements and submit FFATA reports for the 10 entities identified in the audit.

Management agrees with the recommendation. Due to hiring of new staff and an internal audit with similar findings, these actions were in process and implemented as of November 2022. These actions are part of the Sub Team?s standard operating processes and will continue. The proposed corrective action plan is as follows: - The hiring of new team members in 2022; all team members trained on subcontracting processes and documentation requirements with an emphasis on following standard baseline procedures. - New Subcontract Administrator (SCA) position tasked with compiling final packets for each sub, which includes a quality check to ensure all documents and signatures required are included. - Use of subcontract checklist and risk assessments required and consistently done by the team.

Federal Program Name: ? Block Grants for Community Mental Health Services ? ALN 93.243 ? Section 223 Demonstration Programs to Improve Community Mental Health Services ? ALN 93.958 Recommendation: Our auditors recommended the Organization update their method of allocating expenditures to federal awards based on the incurred date, rather than paid date. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Management?s response: Management concurs with the audit finding. As the previous process for grant salary, fringe, and indirect billings was based on salary paid date this resulted in expenses on certain grants being allocated prior to the period of performance. While this was at least in part offset by eligible grant expenses not being billed at the end of the grant period, it was not in compliance with 2 CFR 200.1 for period of performance. The CFO, supported by the Controller and Grants Manager, will immediately update the controls and grants billing processes to be based on incurred date rather than paid date. Name(s) of the contact person(s) responsible for corrective action: CFO, Controller, and Grants Manager Planned completion date for corrective action plan: Will implement in fiscal year 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