LaGrange CountyLocal Government

FINDING 2024-001 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): FY 2024 Compliance Requirement: Reporting Audit Finding: Significant Deficiency INDIANA STATE BOARD OF ACCOUNTS 13 LAGRANGE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context An effective internal control system, which would include segregation of duties, was not in place at the County in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Recipients are required to quarterly or annually submit Project and Expenditure (P&E) reports to the U.S. 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 less than $10 million in COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (SLFRF) funding. As such, the initial P&E report, covering April 1, 2023 to March 31, 2024, was required to be submitted to the Treasury by April 30, 2024. The County submitted the annual P&E report during the audit period. The County's process for the completion and submission of the P&E reports was that the County Auditor prepared the P&E report based on the County's financial ledgers without a proper oversight or review process in place prior to submission. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." Cause A proper system of internal controls was not designed or implemented by management of the County to ensure that P&E reports were prepared by one individual and reviewed by another individual before submission to the Treasury. Effect Without the proper implementation of an effectively designed system of internal controls, errors could occur and remain undetected. As such, the County cannot ensure that the reports submitted are materially accurate and correct. INDIANA STATE BOARD OF ACCOUNTS 14 LAGRANGE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the County establish a system of internal controls and develop policies and procedures over the preparation and review of federal reports to ensure appropriate reviews, approval, and oversight are taking place. Additionally, management should develop policies and procedures to ensure that the County provides the Treasury with complete and accurate information for all reports. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

FINDING 2023-001 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Suspension and Debarment Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): 2023 Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion INDIANA STATE BOARD OF ACCOUNTS 13 LAGRANGE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-002. Condition and Context The County elected to receive the standard revenue loss allowance, allowing the County to claim its total State and Local Fiscal Recovery Funds (SLFRF) allocation of $7,694,555 as revenue loss to use for government services. As such, all SLFRF program funds were expended under the revenue loss eligible use category. The U.S. Department of the Treasury (Treasury) determined that there are no subawards under this eligible use category and that recipients' use of revenue loss funds would not give rise to subrecipient relationships given that there is no federal program or purpose to carry out in the case of the revenue loss portion of the award. Prior to entering into subawards and covered transactions with SLFRF award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the Excluded Parties List System (EPLS), collecting a certification from that person or entity, or adding a clause or condition to the covered transaction with that person or entity. Due to the Treasury's determination that the revenue loss eligible use category does not give rise to subawards, the County was only required to comply with suspension and debarment requirements related to covered transactions. Upon inquiry of the County's policies and procedures related to suspension and debarment requirements, the County disclosed its process for the County Auditor to ensure that the agreements or contracts include language related to suspension and debarment. Four covered transactions for goods or services that equaled or exceeded $25,000 that were paid from SLFRF funds during the audit period were selected for testing. Each transaction was examined to determine whether the County verified the suspension and debarment status of the vendor prior to payment. The first covered transaction, in the amount of $304,263, was made to a contractor for the purchase of three building generators. While the contract was reviewed and approved by a County official, no suspension or debarment clause was present in the contract. As such, the County did not verify the vendor was neither suspended nor debarred, or otherwise excluded or disqualified, from participating in federal assistance programs or activities prior to payment. The second covered transaction, in the amount of $56,338, was made for the purchase of the commissioner's room audio video upgrades. While the contract was reviewed and approved by a County official, no suspension or debarment clause was present in the contract. As such, the County did not verify the vendor was neither suspended nor debarred, or otherwise excluded or disqualified, from participating in federal assistance programs or activities prior to payment. The third covered transaction, in the amount of $126,737, was made for the construction of a 4-H fairgrounds home. The contract was reviewed and approved by a County official and included a suspension or debarment clause. The fourth covered transaction, in the amount of $27,661, was made for the construction of a new park pavilion. While the contract was reviewed and approved by a County official, no suspension or debarment clause was present in the contract. As such, the County did not verify the vendor was neither suspended nor debarred, or otherwise excluded or disqualified, from participating in federal assistance programs or activities prior to payment. INDIANA STATE BOARD OF ACCOUNTS 14 LAGRANGE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 31 CFR 19.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking the EPLS; or (b) Collecting a certification from that person if allowed by this rule; or (c) Adding a clause or condition to the covered transaction with that person." Cause After the last audit, the County established procedures to include a suspension and debarment clause in agreements or contracts. However, the County did not amend agreements or contracts entered into prior to the implementation of this policy. Effect Without the proper implementation of an effectively designed system of internal controls, the County cannot ensure the contractors paid with federal funds are eligible to participate in federal programs. Any program funds the County used to pay contractors that have been suspended or debarred would be unallowable, and the funding agency could potentially recover them. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the County strengthen its system of internal controls to ensure that all contractors that are paid $25,000 or more, all or in part with federal funds, are not suspended, debarred, or otherwise excluded from participating in federal programs prior to entering into any contracts. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

FINDING 2022-001 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): FY 2022 Compliance Requirement: Reporting Audit Finding: Material Weakness Condition and Context The County had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties that would likely be effective in preventing, or detecting and correcting, noncompliance. Recipients are required to submit quarterly or annually Project and Expenditure (P&E) reports to the U. S. 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 county with a population below 250,000 residents that received an allocation of less than $10 million in State and Local Fiscal Recovery Funds (SLFRF). As such, the initial P&E report, covering the period from March 3, 2021 to March 31, 2022, was required to be submitted to the Treasury by April 30, 2022. The subsequent annual reports are to cover one calendar year and must be submitted to the Treasury by April 30 each year. The County submitted one P&E report during the audit period; however, a single employee prepared and submitted the P&E report without a review or oversight process in place to prevent, or detect and correct, errors. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." Cause A proper system of internal control over the P&E report was not designed by management of the County, which would include segregation of key functions, to ensure the County provided the Treasury with complete and accurate information related to the SLFRF awards. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the County's management view of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the County design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties, to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

FINDING 2022-002 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Suspension and Debarment Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): FY 2022 Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion Condition and Context The County elected to receive the standard revenue loss allowance, allowing the County to claim its total State and Local Fiscal Recovery Funds (SLFRF) allocation of $7,694,555 as revenue loss to use for government services. As such, all SLFRF program funds were expended under the revenue loss eligible use category. The U. S. Department of the Treasury (Treasury) determined that there are no subawards under this eligible use category, and that recipients' use of revenue loss funds would not give rise to subrecipient relationships given that there is no federal program or purpose to carry out in the case of the revenue loss portion of the award. Prior to entering into subawards and covered transactions with SLFRF award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for good and services awarded under a non-procurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the Excluded Parties List System (EPLS), collecting a certification from that person or entity, or adding a clause or condition to the covered transaction with that person or entity. Due to the Treasury's determination that the revenue loss eligible use category does not give rise to subawards, the County was only required to comply with suspension and debarment requirements related to covered transactions. Upon inquiry of the County's policies and procedures related to suspension and debarment requirements, the County divulged that they did not have policies or procedures in place for verifying that an entity with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded or disqualified from participating in federal assistance programs or activities. Two covered transactions for goods or services that equaled or exceeded $25,000 that were paid from SLFRF funds during the audit period were identified. Each transaction was examined to determine whether the County verified the suspension and debarment status of either vendor prior to payment. The first covered transaction in the amount of $100,000 was made to a contractor for the construction of a new park pavilion. The contract, as provided by the contractor, included a clause stating they were neither excluded nor disqualified. Although the contract was signed by a County official, the contract was not appropriately reviewed by the County to ensure the suspension and debarment clause was included prior to signing. The second covered transaction in the amount of $144,359 was made for the purchase of new elevators for the annex building and the courthouse. The County was unable to provide documentation to support whether the County verified the vendor's suspension and debarment status prior to issuing payment. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.318(i) states: "The non-Federal entity must maintain records sufficient to detail the history of procurement. These records will include, but are not necessarily limited to, the following: Rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price." 2 CFR 200.214 states: "Non-federal entities are subject to the non-procurement debarment and suspension regulations implementing Executive Orders 12549 and 12689, 2 CFR part 180. The regulations in 2 CFR part 180 restrict awards, subawards, and contracts with certain parties that are debarred, suspended, or otherwise excluded from or ineligible for participation in Federal assistance programs or activities." 31 CFR 19.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking the EPLS; or (b) Collecting a certification from that person if allowed by this rule; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not designed by management of the County. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the County's management view of what should be done to effect internal control, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, vendors to whom payments equal to or in excess of $25,000 were made, were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the County. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the County establish a proper system of internal controls and develop policies and procedures to ensure contractors and subrecipients, as appropriate, are not suspended, debarred, or otherwise excluded prior to entering into any contracts or subawards. We also recommended that supporting documentation be retained in order to be presented for audit.

FINDING 2021-001 Subject: COVID-19 - Community Development Block Grants/State's program and Non-Entitlement Grants in Hawaii - Reporting Federal Agency: Department of Housing and Urban Development Federal Program: COVID-19 - Community Development Block Grants/State's program and Non-Entitlement Grants in Hawaii Assistance Listings Number: 14.228 Federal Award Numbers and Years (or Other Identifying Numbers): CV-CV1-208, CV-CV2-314 Pass-Through Entity: Indiana Office of Community and Rural Affairs Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system, which would include segregation of duties, was not in place at the County to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. While the Grant Administrator prepared and submitted the required Job Retention Business Report, information provided did not support the items presented on the report. The lack of internal controls and noncompliance were isolated to the Job Retention Business Report. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.329(c)(1) states: "The non-Federal entity must submit performance reports at the interval required by the Federal awarding agency or pass-through entity to best inform improvements in program outcomes and productivity. Intervals must be no less frequent than annually nor more frequent than quarterly except in unusual circumstances, for example where more frequent reporting is necessary for the effective monitoring of the Federal award or could significantly affect program outcomes. Reports submitted annually by the non-Federal entity and/or pass-through entity must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. Alternatively, the Federal awarding agency or pass-through entity may require annual reports before the anniversary dates of multiple year Federal awards. The final performance report submitted by the non-Federal entity and/or pass-through entity must be due no later than 120 calendar days after the period of performance end date. A subrecipient must submit to the pass-through entity, no later than 90 calendar days after the period of performance end date, all final performance reports as required by the terms and conditions of the Federal award. See also ? 200.344. If a justified request is submitted by a non-Federal entity, the Federal agency may extend the due date for any performance report." 2 CFR 200.329(c)(2) states in part: "As appropriate in accordance with above mentioned performance reporting, these reports will contain, for each Federal award, brief information on the following unless other data elements are approved by OMB in the agency information collection request: (i) A comparison of actual accomplishments to the objectives of the Federal award established for the period. Where the accomplishments of the Federal award can be quantified, a computation of the cost (for example, related to units of accomplishment) may be required if that information will be useful. Where performance trend data and analysis would be informative to the Federal awarding agency program, the Federal awarding agency should include this as a performance reporting requirement. (ii) The reasons why established goals were not met, if appropriate. (iii) Additional pertinent information . . ." Cause Management had not established a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could have resulted in the loss of federal funds to the County. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the County's management establish a system of internal control to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.