Audit 368938

FY End
2023-12-31
Total Expended
$5.10M
Findings
2
Programs
4
Organization: City of Logansport (IN)
Year: 2023 Accepted: 2025-09-30

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
1156583 2023-003 Material Weakness Yes AB
1156584 2023-004 Material Weakness Yes I

Contacts

Name Title Type
T47VMLEAA4J4 Tyler Pearson Auditee
5747391416 Beth Kelley, Cpa, Cfe Auditor
No contacts on file

Finding Details

FINDING 2023-003 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Activities Allowed or Unallowed, Allowable Costs/Cost Principles 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): IN0263 Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-004. Condition and Context Prior to receipt of direct State and Local Fiscal Recovery Funds (SLFRF) award funds, all eligible entities were required to execute a Financial Assistance Agreement (Agreement), which included the award terms and conditions that recipients must comply with in carrying out the objectives of their award. Per the Agreement, the City was responsible for the effective administration of the federal award, as well as the application of sound management practices and administration of federal funds in a manner consistent with program objectives and terms and conditions of the award. Activities Allowed or Unallowed, Allowable Costs/Cost Principles As part of sound management of the federal award, the City was responsible for implementing a system of internal controls that would ensure compliance with the applicable requirements. The City had not properly designed or implemented such a system. There was no evidence of segregation of duties, such as an oversight, review, or approval process related to these expenditures that would have ensured that expenditures of award funds were made only for activities and costs that were allowable under the federal award and federal regulations. The City passed Ordinance 2022-45 approving a "commitment of up to but not to exceed $400,000 for Infrastructure at the Junction." However, the City made no formal agreements for the payment of claims in relation to the "Junction" Project. Of the ten claims paid with SLFRF funds during 2023, two claims totaling $400,000 were for the "Junction" project. Both claims were paid without itemized invoices and adequate supporting documentation to support amounts paid. INDIANA STATE BOARD OF ACCOUNTS 19 CITY OF LOGANSPORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Additionally, the City did not ensure a proper system of internal controls was in place to accurately track expenditures for the SLFRF grant. In 2022, $2.5 million of SLFRF grant funds were transferred out of the City's SLFRF fund into the City of Logansport Project Fund at a financial institution in the name of the City (bank account) and were subsequently comingled with other nonfederal funds as part of a Build Operate Transfer (BOT) Agreement. Of this $2.5 million, $1,626,043 was spent during 2022, leaving $873,957 of the original $2.5 million to be spent in 2023. During 2023, the City disbursed $4,369,454 from its BOT bank account, where SLFRF and other funding sources were comingled without tracking which expenditures were expressly for the purpose of SLFRF. It was not possible to obtain a population of federal expenditures for the BOT expenditures due to this comingling; therefore, a portion of the Activities Allowed or Unallowed and Allowable Costs/Cost Principles compliance requirements could not be tested. Costs totaling $1,273,957 were not properly documented and were considered questioned costs. The lack of internal controls and noncompliance 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). . . ." 2 CFR 200.302 states in part: "(a) Each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. . . . (b) The financial management system of each non-Federal entity must provide for the following . . . (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number and year, name of the Federal agency, and name of the pass-through entity, if any. INDIANA STATE BOARD OF ACCOUNTS 20 CITY OF LOGANSPORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. (4) Effective control over, and accountability for, all funds, property, and other assets. . . ." 2 CFR 200.400 states in part: "The application of these cost principles is based on the fundamental premises that: (a) The non-Federal entity is responsible for the efficient and effective administration of the Federal award through the application of sound management practices. (b) The non-Federal entity assumes responsibility for administering Federal funds in a manner consistent with underlying agreements, program objectives, and the terms and conditions of the Federal award. (c) The non-Federal entity, in recognition of its own unique combination of staff, facilities, and experience, has the primary responsibility for employing whatever form of sound organization and management techniques may be necessary in order to assure proper and efficient administration of the Federal award. . . ." 2 CFR 200.403(g) states in part: "Be adequately documented. . . ." 2 CFR 200.404 states in part: "A cost is reasonable if, in its nature and amount, it does not exceed that which would be incurred by a prudent person under the circumstances prevailing at the time the decision was made to incur the cost. The question of reasonableness is particularly important when the non- Federal entity is predominantly federally-funded. In determining reasonableness of a given cost, consideration must be given to: . . . (e) Whether the non-Federal entity significantly deviates from its established practices and policies regarding the incurrence of costs, which may unjustifiably increase the Federal award's cost." Cause Due to the lack of internal controls, the City was unable to differentiate expenditures made from federal and nonfederal funds once it commingled nonfederal funds and federal grant awards in a single bank account. Additionally, the City did not obtain appropriate supporting documentation for federal expenditures. INDIANA STATE BOARD OF ACCOUNTS 21 CITY OF LOGANSPORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect The City was unable to identify all the expenditures paid with federal funds and cannot ensure, nor can we determine, expenditures of the grant were not unallowable and adhered to established practices and polices. This could result in the misuse of funds and the potential loss of funding for future federal awards. Questioned Costs We identified $1,273,957 in known questioned costs as noted above in the Condition and Context. Recommendation We recommended that management of the City establish a system of internal controls to ensure that grant award funds are accounted for and tracked in a designated grant fund. All activity of the grant should be in this fund with supporting documentation for each transaction. Additionally, the City should obtain appropriate supporting documentation for all federal grant expenditures. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Drinking Water State Revolving Fund (DWSRF) Cluster - Procurement and Suspension and Debarment Federal Agency: Environmental Protection Agency Federal Program: Drinking Water State Revolving Fund Assistance Listings Number: 66.468 Federal Award Number and Year (or Other Identifying Number): DW23150901 Pass-Through Entity: Indiana Finance Authority Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion Condition and Context An effective internal control system was not designed or implemented at the City to ensure compliance with requirements related to the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement - Policy The City had not established a purchasing policy that reflected applicable state laws and regulations, including procedures to avoid the acquisition of unnecessary or duplicative items and procedures to ensure that all solicitations incorporate a clear and accurate description of the technical requirements for the material, product, or service to be procured. Additionally, the City did not maintain a policy that prohibits the use of statutorily or administratively imposed state, local, or tribal geographical preferences in evaluation of bids or proposals. INDIANA STATE BOARD OF ACCOUNTS 22 CITY OF LOGANSPORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Procurement - Small Purchases The City expended federal funds to pay 12 separate vendors to provide goods and services for the duration of the City's Lead Service Line Replacement project. A population of 5 vendors had aggregated expenditures for the audit period that were less than the simplified acquisition threshold of $150,000 but exceeded the $10,000 micro-purchase threshold. All 5 vendors were tested; for 2 of the 5 vendors, the City was unable to provide any documentation that the procurement method used was appropriate or that the procurement provided full and open competition or rationale to support the determination to limit competition. The history of the procurement, including rationale for the method of procurement, selection of the vendor, and the basis for the price, was not adequately documented. Suspension and Debarment Prior to entering into subawards and covered transactions with award funds, recipients are required to verify that vendors 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 adding a clause or condition to the covered transaction with that person. Due to the agreement with the Indiana Finance Authority (IFA), the City was not required to perform testing over suspension and debarment for a majority of the vendors used; however, several drawdowns from the State Revolving Funds (SRF) program were used to reimburse the City for payments made to specific vendors. The vendors paid directly by the City were not included in the IFA's procedures for checking suspension and debarment, therefore, the City was obligated to meet the requirement. The City did not maintain a set of procedures for checking suspension and debarment status of vendors for expenditures related to the SRF awards. A total of two vendors paid directly by the City exceeded the suspension and debarment threshold of $25,000 and were subject to testing. No documentation to show that suspension and debarment was verified prior to entering into the contract could be provided for either vendor. The lack of internal controls and noncompliance 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 23 CITY OF LOGANSPORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.320 states in part: "The non-Federal entity must have and use documented procurement procedures, consistent with the standards of this section and §§ 200.317, 200.318, and 200.319 for any of the following methods of procurement used for the acquisition of property or services required under a Federal award or sub-award. (a) Informal procurement methods. When the value of the procurement for property or services under a Federal award does not exceed the simplified acquisition threshold (SAT), as defined in § 200.1, or a lower threshold established by a non-Federal entity, formal procurement methods are not required. The non-Federal entity may use informal procurement methods to expedite the completion of its transactions and minimize the associated administrative burden and cost. The informal methods used for procurement of property or services at or below the SAT include: . . . (2) Small purchases– (i) Small purchase procedures. The acquisition of property or services, the aggregate dollar amount of which is higher than the micro-purchase threshold but does not exceed the simplified acquisition threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate by the non-Federal entity. . . ." 2 CFR 180.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 SAM.gov Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." 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." 2 CFR 200.318(a) states: "The non-Federal entity must have and use documented procurement procedures, consistent with State, local, and tribal laws and regulations and the standards of this section, for the acquisition of property or services required under a Federal award or subaward. The nonfederal entity's documented procurement procedures must conform to the procurement standards identified in §§ 200.317 through 200.327." INDIANA STATE BOARD OF ACCOUNTS 24 CITY OF LOGANSPORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.318(d) states: "The non-Federal entity's procedures must avoid acquisition of unnecessary or duplicative items. Consideration should be given to consolidating or breaking out procurements to obtain a more economical purchase. Where appropriate, an analysis will be made of lease versus purchase alternatives, and any other appropriate analysis to determine the most economical approach." 2 CFR 200.319(c) states: "The non-Federal entity must conduct procurements in a manner that prohibits the use of statutorily or administratively imposed state, local, or tribal geographical preferences in the evaluation of bids or proposals, except in those cases where applicable Federal statutes expressly mandate or encourage geographic preference. Nothing in this section preempts state licensing laws. When contracting for architectural and engineering (A/E) services, geographic location may be a selection criterion provided its application leaves an appropriate number of qualified firms, given the nature and size of the project, to compete for the contract." 2 CFR 200.319(d) states: "The non-Federal entity must have written procedures for procurement transactions. These procedures must ensure that all solicitations: (1) Incorporate a clear and accurate description of the technical requirements for the material, product, or service to be procured. Such description must not, in competitive procurements, contain features which unduly restrict competition. The description may include a statement of the qualitative nature of the material, product or service to be procured and, when necessary, must set forth those minimum essential characteristics and standards to which it must conform if it is to satisfy its intended use. Detailed product specifications should be avoided if at all possible. When it is impractical or uneconomical to make a clear and accurate description of the technical requirements, a 'brand name or equivalent' description may be used as a means to define the performance or other salient requirements of procurement. The specific features of the named brand which must be met by offers must be clearly stated; and (2) Identify all requirements which the offerors must fulfill and all other factors to be used in evaluating bids or proposals." Cause The City did not maintain a procurement policy that would demonstrate the appropriate procedures to be followed when procuring with federal funding and were not aware of the need to follow federal guidelines for procurement or suspension and debarment for expenditures associated with the SRF awards. Effect Without a proper system of internal controls in place that operated effectively, noncompliance remained undetected. As a result, proper procurement procedures were not adhered to for all vendors. Without following the required methods for procurement, the City could be overpaying for services or providing federal funds to an entity that is suspended or debarred. 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 funds to the City. INDIANA STATE BOARD OF ACCOUNTS 25 CITY OF LOGANSPORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified. Recommendation We recommended that the City's management establish a proper system of internal controls to ensure expenditures made from federal awards use the appropriate procurement method and retain the documentation to support the procurement methods used in order to ensure compliance with the terms and conditions of the federal award and ensure that vendors paid from federal funds are neither suspended nor debarred. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.