Finding 2024-005 -Material Weakness: Cash Management Identification of federal program: Assistance Listing No. 93-493 - Congressional Directives Criteria or specific requirement: Per the OMB Compliance Supplement, "For grants and cooperative agreements to non-federal entities that are funded on a reimbursement basis, determine that expenditures, as defined by 2 CFR 200.1, were incurred prior to date of the reimbursement request." Condition: We noted two instances of request for reimbursement prior to the expenditures being incurred. Cause: Drawdown on reimbursement requests were submitted to the grantor prior to the System incurring qualifyig expenditures. Effect or potential effect: This resulted in material non-compliance with the cash management requirement for the grant program. Questioned cost: $92,130 known. The 2024 Schedule of Expenditures of Federal Awards has been corrected for this finding. Context: The finding is considered systemic in nature. Recommendation: We recommend that the System personnel administering the grant program comply with the System's established process, whereby qualifying expenditured are incurred prior to requesting reimbursement from the grantor. Views of responsible officials: The System concur wuth this finding. See page 57 for corrective action plan.
2024-001 Research and Development Cluster – Education Innovation and Research (formerly Investing in Innovation (i3) Fund – Validation Grants) Assistance Listing No. 84.411A Criteria: 2 CFR 200.332 notes, “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; (xii) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. (2) All requirements imposed by the pass-through entity on the subrecipient so that the Federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the Federal award; …” Condition: For both subawards selected for testing, the identification of the contact information for the awarding agency was incorrect. The contact information was Education Analytics, Inc., the Organization’s grantor, but should have been Future Forward, Inc. Further, one of the two subawards selected for testing had information missing from the subaward including all requirements for the award to be used in accordance with Federal statutes, regulations and terms and conditions of the Federal award. We consider this condition to be an instance of noncompliance relating to the Subrecipient Monitoring compliance requirement. Statistical sampling was not used in making sample selections. Questioned Costs: N/A Cause and Effect: Without communication of the required information, subrecipients may overspend award amounts or incur unallowable expenses towards the grant as well as report the incorrect grantor on their schedule of expenditures of federal awards. Recommendation: We recommend the Organization evaluates policies and procedures to ensure all required information is communicated with the subrecipient. Views of Responsible Officials: Management agrees with this Single Audit Finding and response is included in the Corrective Action Plan.
2024 – 001 Period of Performance Federal Agency: U.S. Department of Health and Human Services Federal Program: Consolidated Health Centers Grant AL Number: 93.224 & 93.527 Award Period: 1/1/24 - 12/31/24 Type of Finding: Significant deficiency in Internal Control over Compliance and Compliance Criteria or Specific Requirement According to § 2 CFR 200.303, the non-Federal entity must 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. According to 2 CFR 200.1 Period of Performance is defined as the total estimated time interval between the start of an initial Federal award and the planned end date, which may include one or more funded portions, or budget periods. Condition and Context The Organization began allocating direct salaries and benefits prior to the awards period of performance start date. The Organization allocated expenditures based on the payroll paid date, rather than the date the payroll was incurred. Total direct salaries and benefits allocated to the grant prior to the period of performance start date was $21,049. Effect Potential that costs will be charged to the grant outside of the period of performance. Questioned Costs $21,049 Cause The Organization allocated payroll expenditures based on the paid date, rather than the incurred date. Recommendation We recommend the Organization update their method of allocating expenditures to federal awards based on the incurred date, rather than paid date.Views of Responsible Officials The Organization corrected the period of performance finding prior to the 2024 audit being completed and feel this was an isolated incident. The issue was caused by staff turnover in 2024, and new staff have been properly trained to review all grants to ensure compliance with all grant regulations. This grant can be used for staffing costs and upon identification of this issue we have corrected the allocations to the prior grant periods. Going forward, the Organization has implemented controls to ensure that all staff are being trained to ensure they are following grant guidelines.
2024 – 001 Period of Performance Federal Agency: U.S. Department of Health and Human Services Federal Program: Consolidated Health Centers Grant AL Number: 93.224 & 93.527 Award Period: 1/1/24 - 12/31/24 Type of Finding: Significant deficiency in Internal Control over Compliance and Compliance Criteria or Specific Requirement According to § 2 CFR 200.303, the non-Federal entity must 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. According to 2 CFR 200.1 Period of Performance is defined as the total estimated time interval between the start of an initial Federal award and the planned end date, which may include one or more funded portions, or budget periods. Condition and Context The Organization began allocating direct salaries and benefits prior to the awards period of performance start date. The Organization allocated expenditures based on the payroll paid date, rather than the date the payroll was incurred. Total direct salaries and benefits allocated to the grant prior to the period of performance start date was $21,049. Effect Potential that costs will be charged to the grant outside of the period of performance. Questioned Costs $21,049 Cause The Organization allocated payroll expenditures based on the paid date, rather than the incurred date. Recommendation We recommend the Organization update their method of allocating expenditures to federal awards based on the incurred date, rather than paid date.Views of Responsible Officials The Organization corrected the period of performance finding prior to the 2024 audit being completed and feel this was an isolated incident. The issue was caused by staff turnover in 2024, and new staff have been properly trained to review all grants to ensure compliance with all grant regulations. This grant can be used for staffing costs and upon identification of this issue we have corrected the allocations to the prior grant periods. Going forward, the Organization has implemented controls to ensure that all staff are being trained to ensure they are following grant guidelines.
2024 – 001 Period of Performance Federal Agency: U.S. Department of Health and Human Services Federal Program: Consolidated Health Centers Grant AL Number: 93.224 & 93.527 Award Period: 1/1/24 - 12/31/24 Type of Finding: Significant deficiency in Internal Control over Compliance and Compliance Criteria or Specific Requirement According to § 2 CFR 200.303, the non-Federal entity must 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. According to 2 CFR 200.1 Period of Performance is defined as the total estimated time interval between the start of an initial Federal award and the planned end date, which may include one or more funded portions, or budget periods. Condition and Context The Organization began allocating direct salaries and benefits prior to the awards period of performance start date. The Organization allocated expenditures based on the payroll paid date, rather than the date the payroll was incurred. Total direct salaries and benefits allocated to the grant prior to the period of performance start date was $21,049. Effect Potential that costs will be charged to the grant outside of the period of performance. Questioned Costs $21,049 Cause The Organization allocated payroll expenditures based on the paid date, rather than the incurred date. Recommendation We recommend the Organization update their method of allocating expenditures to federal awards based on the incurred date, rather than paid date.Views of Responsible Officials The Organization corrected the period of performance finding prior to the 2024 audit being completed and feel this was an isolated incident. The issue was caused by staff turnover in 2024, and new staff have been properly trained to review all grants to ensure compliance with all grant regulations. This grant can be used for staffing costs and upon identification of this issue we have corrected the allocations to the prior grant periods. Going forward, the Organization has implemented controls to ensure that all staff are being trained to ensure they are following grant guidelines.
FINDING 2024-002 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Procurement and 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): Contract #65851 Pass-Through Entity: Schneck Medical Center Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2023-001. Condition and Context An effective internal control system was not in place at the City to ensure compliance with requirements related to the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement 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 customarily set at $250,000. However, Indiana Code 5-22-8 has a more restrictive threshold of $150,000 or less for when small purchase procedures may be used. This informal process allows for methods other than the formal bid process. The informal process is divided between two methods based on thresholds. Micro-purchases, 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. One vendor was identified that fell within the small purchase threshold. Purchases from the vendor totaled $148,800. As such, price or rate quotations from an adequate number of qualified sources should have been obtained. However, the City did not obtain price or rate quotations for the purchases, nor was full and open competition provided for the vendor. Additionally, there was no documentation available to support the rationale to limit competition. INDIANA STATE BOARD OF ACCOUNTS 15 CITY OF SEYMOUR SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Suspension and Debarment Prior to entering into subawards and covered transactions with the COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (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 adding a clause or condition to the covered transaction with that person. The City did not have policies or procedures in place for verifying that an entity with which it planned to enter into a covered transaction was not suspended, debarred, or otherwise excluded until November 25, 2024. One of the two vendors selected for testing, with covered transactions totaling $148,800, was not verified to ensure that the vendor was not suspended, debarred, or otherwise excluded. The lack of internal controls and noncompliance were systemic issues until the City implemented new policies and procedures in November 2024. 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.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 — INDIANA STATE BOARD OF ACCOUNTS 16 CITY OF SEYMOUR SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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. . . . 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 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 The City did not have a procurement policy in place that contained the requirements of the procurement standards as outlined in the Code of Federal Regulations prior to entering into an agreement with the vendor. Due to the timing of the adoption of the City's Procurement and Suspension and Debarment Policy, which defines procedures to ensure they are properly procuring services and verifying suspension and debarment status for covered transactions, not all of the items selected for testing were in compliance. Effect Without the proper implementation of an effectively designed system of internal controls, the City cannot ensure that goods and services are appropriately procured and that contractors paid with federal funds are eligible to participate in federal programs. Any program funds the City used to pay contractors that have been suspended or debarred would be unallowable, and the funding agency could potentially recover them. Furthermore, 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 City. Questioned Costs There were no questioned costs identified. Recommendation We recommended adhering to the newly implemented procurement policies to ensure compliance with state and federal laws and regulations for procuring goods and services paid with federal funds. We also recommended that management of the City adhere to its newly approved policy of internal controls to ensure that all contractors that are expected to be paid $25,000 or more, all or in part with federal funds, are not suspended or debarred from participating in federal programs before entering into covered transactions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding #24-001 – Significant Deficiency in Internal Control over Financial Reporting: Procurement Program Names: 3rd Street Housing Project Eagle Community Pool Replacement CFDA Titles and Numbers: 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Agency: United States Treasury Pass-through Agency: Colorado Department of Local Affairs Award Year: December 31, 2024 Condition: No formal Federal procurement policy has been adopted by the Town of Eagle, Colorado, resulting in a lack of internal controls over Federal procurement. Criteria or Specific Requirement: The Town of Eagle, Colorado, must comply with procurement standards set out at 2 CFR sections 200.303 and 200.318 through 200.326 within Uniform Guidance. Per 2 CFR section 200.303(a), a non-Federal entity must: 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). UG §200.318 General Procurement Standards. (i) 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, section of contract type, contractor selection or rejection, and the basis for the contract price. UG §200.320 states that the non-Federal entity must use one of the prescribed methods of procurement: (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 or property or services at or below the SAT include: (1) Micro-purchases. Procurement by micro-purchase is the acquisition of supplies or services, the aggregate dollar amount of which does not exceed the micro-purchase threshold (see definition of micro-purchase in §200.1). To the maximum extent practicable, the non-Federal entity should distribute micro-purchases equitably among qualified suppliers. Micro-purchases may be awarded without soliciting competitive price or equitably among qualified suppliers. Micro-purchases may be awarded without soliciting competitive price or rate quotations if the non-Federal entity considers the price to be reasonable based on research, experience, purchase history or other information and documents it files accordingly. Purchase cards can be used for micro-purchases if procedures are documented and approved by the non-Federal entity. (2) Small purchase. Procurement by small purchase is the acquisition of property or services, the aggregate dollar amount of which is greater 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. (b) Formal procurement methods. When the value of the procurement for property or services under a Federal financial assistance award exceeds the SAT, or a lower threshold established by a non-Federal entity, formal procurement methods are required. Formal procurement methods require following documented procedures. Formal procurement methods also require public advertising unless a non-competitive procurement can be used in accordance with §200.319 or paragraph (c) of this section. The following formal methods of procurement are used for procurement of property or services above the simplified acquisition threshold or a value below the simplified acquisition threshold the non-Federal entity determines to be appropriate: (1) Sealed Bids. Bids are publicly solicited, and a firm fixed-price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. (2) Proposals. Either a fixed price or cost-reimbursement-type contract is awarded. Proposals are generally used when conditions are not appropriate for the use of sealed bids. (c) Noncompetitive procurement. There are specific circumstances in which noncompetitive procurement can be used. Noncompetitive procurement can only be awarded if one or more of the allowed circumstances apply. Questioned Costs: N/A Context: Although the Town of Eagle, Colorado, had not adopted a formal Federal procurement policy as outlined in 2CFR sections 200.303 and 200.318 through 200.326, during the course of our federal single audit testing of transactions and contracts, we found that the Town’s general contract purchase procedures that were followed meet the requirements of the Uniform Guidance and that no contracts were awarded without proper justification in 7 or 7 procurement transactions tested. Cause: Management was not aware of the requirement of adopting a formal Federal procurement policy under the procurement standards set out at 2CFR sections 200.303 and 200.318 through 200.626 within Uniform Guidance. Effect: The Town of Eagle, Colorado, is at risk for noncompliance with Federal grants as it relates to procurement. Recommendation: We recommend that the Town of Eagle, Colorado, adopts a formal Federal procurement policy to include all elements identified in 2CFR Sections 200.303 and 200.318 through 200.626. Views of Responsible Officials and Planned Corrective Action: Management agrees with this finding and will adopt a formal Federal procurement policy which includes all elements identified in 2CFR Sections 200.303 and 200.318 through 200.626.
Finding #24-003 – Procurement Program Names: 3rd Street Housing Project Eagle Community Pool Replacement CFDA Titles and Numbers: 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Agency: United States Treasury Pass-through Agency: Colorado Department of Local Affairs Award Year: December 31, 2024 Condition: No formal Federal procurement policy has been adopted by the Town of Eagle, Colorado, resulting in a lack of compliance with Federal procurement. Criteria or Specific Requirement: The Town of Eagle, Colorado, must comply with procurement standards set out at 2 CFR sections 200.303 and 200.318 through 200.326 within Uniform Guidance. Per 2 CFR section 200.303(a), a non-Federal entity must: 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). UG §200.318 General Procurement Standards. (i) 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, section of contract type, contractor selection or rejection, and the basis for the contract price. UG §200.320 states that the non-Federal entity must use one of the prescribed methods of procurement: (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 or property or services at or below the SAT include: (1) Micro-purchases. Procurement by micro-purchase is the acquisition of supplies or services, the aggregate dollar amount of which does not exceed the micro-purchase threshold (see definition of micro-purchase in §200.1). To the maximum extent practicable, the non-Federal entity should distribute micro-purchases equitably among qualified suppliers. Micro-purchases may be awarded without soliciting competitive price or rate quotations if the non-Federal entity considers the price to be reasonable based on research, experience, purchase history or other information and documents it files accordingly. Purchase cards can be used for micro-purchases if procedures are documented and approved by the non-Federal entity. (2) Small purchase. Procurement by small purchase is the acquisition of property or services, the aggregate dollar amount of which is greater 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. (b) Formal procurement methods. When the value of the procurement for property or services under a Federal financial assistance award exceeds the SAT, or a lower threshold established by a non-Federal entity, formal procurement methods are required. Formal procurement methods require following documented procedures. Formal procurement methods also require public advertising unless a non-competitive procurement can be used in accordance with §200.319 or paragraph (c) of this section. The following formal methods of procurement are used for procurement of property or services above the simplified acquisition threshold or a value below the simplified acquisition threshold the non-Federal entity determines to be appropriate: (1) Sealed Bids. Bids are publicly solicited, and a firm fixed-price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. (2) Proposals. Either a fixed price or cost-reimbursement-type contract is awarded. Proposals are generally used when conditions are not appropriate for the use of sealed bids. (c) Noncompetitive procurement. There are specific circumstances in which noncompetitive procurement can be used. Noncompetitive procurement can only be awarded if one or more of the allowed circumstances apply. Questioned Costs: N/A Context: Although the Town of Eagle, Colorado, had not adopted a formal Federal procurement policy as outlined in 2CFR sections 200.303 and 200.318 through 200.326, during the course of our federal single audit testing of transactions and contracts, we found that the Town’s general contract purchase procedures that were followed meet the requirements of the Uniform Guidance and that no contracts were awarded without proper justification in 7 or 7 procurement transactions tested. Cause: Management was not aware of the requirement of adopting a formal Federal procurement policy under the procurement standards set out at 2CFR sections 200.303 and 200.318 through 200.626 within Uniform Guidance. Effect: The Town of Eagle, Colorado, is at risk for noncompliance with Federal grants as it relates to procurement. Recommendation: We recommend that the Town of Eagle, Colorado, adopts a formal Federal procurement policy to include all elements identified in 2CFR Sections 200.303 and 200.318 through 200.626. Views of Responsible Officials and Planned Corrective Action: Management agrees with this finding and will adopt a formal Federal procurement policy which includes all elements identified in 2CFR Sections 200.303 and 200.318 through 200.626.
Finding #24-001 – Significant Deficiency in Internal Control over Financial Reporting: Procurement Program Names: 3rd Street Housing Project Eagle Community Pool Replacement CFDA Titles and Numbers: 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Agency: United States Treasury Pass-through Agency: Colorado Department of Local Affairs Award Year: December 31, 2024 Condition: No formal Federal procurement policy has been adopted by the Town of Eagle, Colorado, resulting in a lack of internal controls over Federal procurement. Criteria or Specific Requirement: The Town of Eagle, Colorado, must comply with procurement standards set out at 2 CFR sections 200.303 and 200.318 through 200.326 within Uniform Guidance. Per 2 CFR section 200.303(a), a non-Federal entity must: 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). UG §200.318 General Procurement Standards. (i) 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, section of contract type, contractor selection or rejection, and the basis for the contract price. UG §200.320 states that the non-Federal entity must use one of the prescribed methods of procurement: (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 or property or services at or below the SAT include: (1) Micro-purchases. Procurement by micro-purchase is the acquisition of supplies or services, the aggregate dollar amount of which does not exceed the micro-purchase threshold (see definition of micro-purchase in §200.1). To the maximum extent practicable, the non-Federal entity should distribute micro-purchases equitably among qualified suppliers. Micro-purchases may be awarded without soliciting competitive price or equitably among qualified suppliers. Micro-purchases may be awarded without soliciting competitive price or rate quotations if the non-Federal entity considers the price to be reasonable based on research, experience, purchase history or other information and documents it files accordingly. Purchase cards can be used for micro-purchases if procedures are documented and approved by the non-Federal entity. (2) Small purchase. Procurement by small purchase is the acquisition of property or services, the aggregate dollar amount of which is greater 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. (b) Formal procurement methods. When the value of the procurement for property or services under a Federal financial assistance award exceeds the SAT, or a lower threshold established by a non-Federal entity, formal procurement methods are required. Formal procurement methods require following documented procedures. Formal procurement methods also require public advertising unless a non-competitive procurement can be used in accordance with §200.319 or paragraph (c) of this section. The following formal methods of procurement are used for procurement of property or services above the simplified acquisition threshold or a value below the simplified acquisition threshold the non-Federal entity determines to be appropriate: (1) Sealed Bids. Bids are publicly solicited, and a firm fixed-price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. (2) Proposals. Either a fixed price or cost-reimbursement-type contract is awarded. Proposals are generally used when conditions are not appropriate for the use of sealed bids. (c) Noncompetitive procurement. There are specific circumstances in which noncompetitive procurement can be used. Noncompetitive procurement can only be awarded if one or more of the allowed circumstances apply. Questioned Costs: N/A Context: Although the Town of Eagle, Colorado, had not adopted a formal Federal procurement policy as outlined in 2CFR sections 200.303 and 200.318 through 200.326, during the course of our federal single audit testing of transactions and contracts, we found that the Town’s general contract purchase procedures that were followed meet the requirements of the Uniform Guidance and that no contracts were awarded without proper justification in 7 or 7 procurement transactions tested. Cause: Management was not aware of the requirement of adopting a formal Federal procurement policy under the procurement standards set out at 2CFR sections 200.303 and 200.318 through 200.626 within Uniform Guidance. Effect: The Town of Eagle, Colorado, is at risk for noncompliance with Federal grants as it relates to procurement. Recommendation: We recommend that the Town of Eagle, Colorado, adopts a formal Federal procurement policy to include all elements identified in 2CFR Sections 200.303 and 200.318 through 200.626. Views of Responsible Officials and Planned Corrective Action: Management agrees with this finding and will adopt a formal Federal procurement policy which includes all elements identified in 2CFR Sections 200.303 and 200.318 through 200.626.
Finding #24-003 – Procurement Program Names: 3rd Street Housing Project Eagle Community Pool Replacement CFDA Titles and Numbers: 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Agency: United States Treasury Pass-through Agency: Colorado Department of Local Affairs Award Year: December 31, 2024 Condition: No formal Federal procurement policy has been adopted by the Town of Eagle, Colorado, resulting in a lack of compliance with Federal procurement. Criteria or Specific Requirement: The Town of Eagle, Colorado, must comply with procurement standards set out at 2 CFR sections 200.303 and 200.318 through 200.326 within Uniform Guidance. Per 2 CFR section 200.303(a), a non-Federal entity must: 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). UG §200.318 General Procurement Standards. (i) 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, section of contract type, contractor selection or rejection, and the basis for the contract price. UG §200.320 states that the non-Federal entity must use one of the prescribed methods of procurement: (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 or property or services at or below the SAT include: (1) Micro-purchases. Procurement by micro-purchase is the acquisition of supplies or services, the aggregate dollar amount of which does not exceed the micro-purchase threshold (see definition of micro-purchase in §200.1). To the maximum extent practicable, the non-Federal entity should distribute micro-purchases equitably among qualified suppliers. Micro-purchases may be awarded without soliciting competitive price or rate quotations if the non-Federal entity considers the price to be reasonable based on research, experience, purchase history or other information and documents it files accordingly. Purchase cards can be used for micro-purchases if procedures are documented and approved by the non-Federal entity. (2) Small purchase. Procurement by small purchase is the acquisition of property or services, the aggregate dollar amount of which is greater 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. (b) Formal procurement methods. When the value of the procurement for property or services under a Federal financial assistance award exceeds the SAT, or a lower threshold established by a non-Federal entity, formal procurement methods are required. Formal procurement methods require following documented procedures. Formal procurement methods also require public advertising unless a non-competitive procurement can be used in accordance with §200.319 or paragraph (c) of this section. The following formal methods of procurement are used for procurement of property or services above the simplified acquisition threshold or a value below the simplified acquisition threshold the non-Federal entity determines to be appropriate: (1) Sealed Bids. Bids are publicly solicited, and a firm fixed-price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. (2) Proposals. Either a fixed price or cost-reimbursement-type contract is awarded. Proposals are generally used when conditions are not appropriate for the use of sealed bids. (c) Noncompetitive procurement. There are specific circumstances in which noncompetitive procurement can be used. Noncompetitive procurement can only be awarded if one or more of the allowed circumstances apply. Questioned Costs: N/A Context: Although the Town of Eagle, Colorado, had not adopted a formal Federal procurement policy as outlined in 2CFR sections 200.303 and 200.318 through 200.326, during the course of our federal single audit testing of transactions and contracts, we found that the Town’s general contract purchase procedures that were followed meet the requirements of the Uniform Guidance and that no contracts were awarded without proper justification in 7 or 7 procurement transactions tested. Cause: Management was not aware of the requirement of adopting a formal Federal procurement policy under the procurement standards set out at 2CFR sections 200.303 and 200.318 through 200.626 within Uniform Guidance. Effect: The Town of Eagle, Colorado, is at risk for noncompliance with Federal grants as it relates to procurement. Recommendation: We recommend that the Town of Eagle, Colorado, adopts a formal Federal procurement policy to include all elements identified in 2CFR Sections 200.303 and 200.318 through 200.626. Views of Responsible Officials and Planned Corrective Action: Management agrees with this finding and will adopt a formal Federal procurement policy which includes all elements identified in 2CFR Sections 200.303 and 200.318 through 200.626.
FINDING 2024-004 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): FY24 Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2023-005. Condition and Context 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 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). 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 the P&E report by April 30, 2024, as required; 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. As a result, the following errors were noted: The current period expenditures for ten projects tested were understated by $533,935. In addition, current period expenditures for one project tested was overstated by $4,529. The cumulative expenditures for six projects tested were understated by $151,208. In addition, cumulative expenditures for three projects tested were overstated by $108,106. INDIANA STATE BOARD OF ACCOUNTS 20 DECATUR COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The current period obligations for four projects tested were understated by $205,178. In addition, current period obligations for four projects tested were overstated by $1,634,629. The cumulative obligations for one project tested was understated by $100,000. In addition, cumulative obligations for six projects tested were overstated by $2,007,842. 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). . . ." Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary . . . periodic reports providing detailed accounting of the uses of funds . . ." Cause A proper system of internal controls, including policies and procedures, was not designed or implemented by management of the County to prevent and detect errors on the P&E report prior to submission. The County incorrectly reported projects that had been appropriated, but not yet obligated, and amounts reported did not always agree to the County's records. The reports submitted were not reviewed by a second person to identify these errors prior to submission. Effect Without the proper implementation of an effectively designed 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. As such, the County did not accurately report current period obligations and cumulative obligations when filing the P&E report for the period April 1, 2023 to March 31, 2024. INDIANA STATE BOARD OF ACCOUNTS 21 DECATUR COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Noncompliance with the provisions of federal regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the County. In addition, not meeting the SLFRF reporting requirements increases the likelihood that the public will not have access to transparent and accurate information regarding expenditures of federal awards. 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 of federal reports are taking place. We also recommended the development of policies and procedures to ensure the County provides the Treasury with complete and accurate information for the P&E report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-003 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): 2024 Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2023-005. Condition and Context 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). 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, the report was submitted without a review or oversight process in place to prevent, or detect and correct, errors. As a result, cumulative obligations reported were overstated by $1,160,124. 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 20 JEFFERSON COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary periodic reports providing detailed accounting of the uses of funds, . . ." Cause The County reported the total program funds received in the cumulative obligations amount, instead of only reporting the funds that had been obligated. Due to the timing of the P&E report submission and prior audit completion, corrective actions from finding 2023-005 could not be implemented in time to correct this noncompliance. Effect Without the proper implementation of an effectively designed 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. As such, the County did not report cumulative obligations properly when filing the P&E report for the period April 1, 2023 to March 31, 2024. 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. In addition, not meeting the SLFRF reporting requirements increases the likelihood that the public will not have access to transparent and accurate information regarding expenditures of federal awards. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the County strengthen its system of internal controls to provide for a segregation of duties in the preparation and review of federal reports to ensure appropriate reviews, approvals, and oversight are taking place. We also recommended the development of policies and procedures to ensure the County provides the Treasury with complete and accurate information for the P&E report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-005 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): FY2024 Compliance Requirement: Reporting 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 2023-004. Condition and Context The County had not properly 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 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 submitted one 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 and a financial consultant prepared the P&E report based on reports from the County's financial system and the County Auditor submitted the report. There was no evidence of an oversight or review process. The County submitted the P&E report by April 30, 2024, as required; however, the report was not supported by the County's records. The annual report submitted in April 2024 did not include an expenditure of $228,300 as the County Auditor used the incorrect period of March 31, 2023 to December 31, 2023, to complete the report, and this expenditure was incurred on February 5, 2024. 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 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary periodic reports providing detailed accounting of the uses of funds, . . ." INDIANA STATE BOARD OF ACCOUNTS 23 SHELBY COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." Cause A proper system of internal controls, which would include segregation of key functions, was not designed by management of the County. The lack of review or approval process by someone other than the preparers allowed the error in the P&E report to go undetected. The error was a result of expenditures from the incorrect reporting period being used to complete the report. 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, noncompliance. As such, the P&E report submitted understated expenditures. 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. In addition, not meeting the SLFRF reporting requirements increases the likelihood that the public will not have access to transparent and accurate information regarding expenditures of federal awards. 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 to ensure that the County abstracts the correct reporting period, to provide the Treasury with complete and accurate information for the P&E reports. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-001 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Procurement and 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): 2021 Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediate prior audit report. The prior audit finding number was 2023-001. 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 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 customarily set at $250,000. However, Indiana Code 5-22-8 has a more restrictive threshold of $150,000 or less for when small purchase procedures may be used. This informal process allows for methods other than the formal bid process. Micro-purchases are typically for those purchases $10,000 or under, and small purchase procedures are 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. One vendor was identified that fell within the small purchase threshold. Purchases from the vendor totaled $40,458. As such, price or rate quotations from an adequate number of qualified sources should have been obtained. However, the City did not obtain price or rate quotations for the purchases, nor was full and open competition provided for the vendor. Additionally, there was no documentation available to support the rationale to limit competition. Suspension and Debarment The City elected to receive the standard revenue loss allowance, allowing the City to claim $10,000,000 of its total COVID-19 - State and Local Fiscal Recovery Funds (SLFRF) allocation of $16,549,045 as revenue loss to use for government services. 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 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 City was only required to comply with suspension and debarment requirements related to contracts. The City's policies related to SLFRF suspension and debarment requirements include the Board of Public Works completing a review of each bid packet to ensure the bidder submitted a statement indicating if they were not suspended or debarred or an employee from the City Controller's office checking the Sam.gov website. There were 13 covered transactions identified that equaled or exceeded $25,000, and 2 covered transactions, totaling $251,334, were selected for testing. For both of the transactions tested, the City did not verify the suspension or debarment status prior to 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). . . ." 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 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." 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." 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. . . ." Cause The City did not follow the City's established policy to ensure the proper procurement of services and supplies and to verify suspension and debarment status for covered transactions. 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. The City did not use the proper method of procurement to choose a vendor. In addition, the City did not ensure the contractors paid with federal funds are eligible to participate in federal programs. Any program funds the City used to pay contractors that have been suspended or debarred would be unallowable, and the funding agency could potentially recover them. Furthermore, 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 City. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the City follow the City's established policies to ensure compliance with requirements related to procurement and suspension and debarment. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-002 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Procurement and 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): TRSW222046 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 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 customarily set at $250,000. However, Indiana Code 5-22-8 has a more restrictive threshold of $150,000 or less for when small purchase procedures may be used. This informal process allows for methods other than the formal bid process. Micro-purchases are typically for those purchases $10,000 or under, and small purchase procedures are 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 grant covered one project with one vendor that fell within the simplified acquisition threshold. Payments to the vendor for the project totaled $189,741 with $120,452 of that amount was grant funds. As such, the formal bid process should have been followed. The City did not perform bid procedures or provide the rationale for the method of procurement, the selection of vendor, or the basis for price. Additionally, the City did not obtain a written contract for the services. Suspension and Debarment Prior to entering into subawards and covered transactions with federal 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 SAM exclusions, collecting a certification from that person, or adding a clause or condition to the covered transaction with that person or entity. The City's policies related to COVID-19 - Coronavirus State and Local Fiscal Recovery Funds suspension and debarment requirements include the Board of Public Works completing a review of each bid packet to ensure the bidder submitted a statement indicating if they were not suspended or debarred or an employee from the City Controller's office checking the Sam.gov website. As noted above, the grant covered one project with one vendor utilized and the City did not verify the suspension or debarment status prior to payment for this vendor. The lack of internal controls and noncompliance was isolated to the instance noted above. 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(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." 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: . . . (b) Formal Procurement Methods. When the value of the procurement for property or services under a Federal financial assistance award exceeds the SAT, or a lower threshold established by a non-Federal entity, formal procurement methods are required. Formal procurement methods require following documented procedures. Formal procurement methods also require public advertising unless a non-competitive procurement can be used in accordance with § 200.319 or paragraph (c) of this section. The following formal methods of procurement are used for procurement of property or services above the simplified acquisition threshold or a value below the simplified acquisition threshold the non-Federal entity determines to be appropriate: (1) Sealed bids. A procurement method in which bids are publicly solicited and a firm fixed-price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. The sealed bids method is the preferred method for procuring construction, if the conditions. . . . (2) Proposals. A procurement method in which either a fixed price or cost-reimbursement type contract is awarded. Proposals are generally used when conditions are not appropriate for the use of sealed bids. . . ." 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 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 The City did not follow the City's established policy to ensure the proper procurement of services and supplies and to verify suspension and debarment status for covered transactions. 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. The City did not use the proper method of procurement to choose a vendor. In addition, the City did not ensure the contractors paid with federal funds are eligible to participate in federal programs. Any program funds the City used to pay contractors that have been suspended or debarred would be unallowable, and the funding agency could potentially recover them. Furthermore, 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 City. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the City follow its established policies to ensure compliance with requirements related to procurement and suspension and debarment. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
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): CY2021 Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2023-001. Condition and Context 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 City was classified as a metropolitan city with a population below 250,000 residents that received an allocation of more than $10 million in COVID-19 - Coronavirus 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 quarterly reports were to cover one calendar quarter and must be submitted to the Treasury by the last day of the month following the end of the period covered. The City submitted four P&E reports during the audit period; however, the internal controls in place were not effective to prevent, or detect and correct, errors. As a result, errors in reporting were identified. The current period and cumulative expenditures reported consisted of the amounts expended by the beneficiaries who were awarded funds from the City, rather than total amounts expended to the beneficiaries, resulting in current period expenditures and cumulative expenditures being incorrectly reported on three of the four reports as follows: Quarterly Report: October 1, 2023 to December 31, 2023 Current period expenditures were overstated by $666,417. Cumulative expenditures were understated by $964,879. Quarterly Report: January 1, 2024 to March 31, 2024 Current period expenditures were overstated by $860,312. Cumulative expenditures were understated by $104,567. Quarterly Report: April 1, 2024 to June 30, 2024 Current period expenditures were overstated by $104,567. The lack of effective 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). . . ." Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary or her delegate, as applicable, periodic reports providing detailed accounting of the uses of funds, . . ." 2 CFR 200.1 states in part: ". . . Expenditures means charged made by a non-Federal entity to a project or program for which a Federal award was received. . . . (2) For reports prepared on a cash basis, expenditures are the sum of: (i) Cash disbursements for direct charges for property and services; (ii) The amount of indirect expense charged; (iii) The value of third-party in-kind contribution applied; and (iv) The amount of cash advance payments and payments made to subrecipients. . . ." Cause The City's oversight process for filing the P&E reports for the period of October 1, 2023 to September 30, 2024, did not detect errors in the P&E reports. The City's understanding was that the expenditures in its report should be based on when the beneficiaries expended the funds and not when the City disbursed the funds to the beneficiaries. The City officials did not understand the requirements until the prior audit was finished, which was after multiple of these reports had already been submitted. 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 such, the City did not report cumulative expenditures and current period expenditures properly when filing the P&E reports for periods from October 1, 2023 to September 30, 2024. 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 City. In addition, not meeting the SLFRF reporting requirements increases the likelihood that the public will not have access to transparent and accurate information regarding expenditures of federal awards. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the City develop policies and procedures to ensure the City provides the Treasury with complete and accurate information as it relates to the City in its P&E reports. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Federal Program, Assistance Listing # and Year, Federal Agency, Pass-Through Entity: COVID-19 - Coronavirus State & Local Fiscal Recovery Fund, Assistance Listing #21.027, 2021, U.S. Department of Treasury. Criteria or Specific Requirement: In accordance with 2 CFR 200.1, all recipients of federal funds must complete and submit annual project and expenditure reports on all SLFRF funded projects. Also, 2 CFR 200.303 requires the entity to establish and maintain effective internal controls over compliance with respect to federal awards and Section 1111(b)(2)(A) of the ESEA for compliance accountability. Proper internal controls require supporting documentation to be retained as evidence for effectiveness of the controls in place. In accordance with 2 CFR.307, program income earned during the period of performance must be used in accordance with the terms and conditions of the federal award. Condition: During our testing, CRI identified a lack of internal controls related to reviewing and approving report submissions. During our testing, CRI identified 2024 report submissions did not agree to cumulativeto- date expenditures of the fiscal years 2021-2024. During our testing, CRI identified revenue recognized/earned during the period was improperly reported as program income and expenditures were improperly included as program income expenditures, causing inaccurate reporting. Program income was materially overstated. Effect: The City of Shreveport risks reports required to be submitted to the U.S. Department of the Treasury to be materially misstated. Cause: A lack of adequate controls over reporting requirements. Questioned Costs: Not applicable Context: The issue was identified while testing the population of reports. Recommendation: We recommend the City implements proper controls to review reports submitted, so as to identify and address any discrepancies. Views of responsible officials and corrective action plan: Accounting has reviewed all projects and Ordinances related to ARPA and has updated reports and records to fully account for ARPA funding. From the Chief Administrative Officer (CAO) and the department responsible for a specific project that has multiple funding sources, confirmation was obtained on what amounts were obligated ARPA funds. This strengthens the controls over the report submission process to ensure the reported amounts are accurate and reconciled properly.
FINDING 2024-003 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 2023 Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context 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 City was classified as a metropolitan city 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 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, April 1 through March 31, and must be submitted to the Treasury by April 30 each year. The City submitted one P&E report during the audit period. The internal controls in place were not effective and did not prevent, or detect and correct, errors in the P&E report prior to submission. As a result, the Current Period Obligation and Current Period Expenditure amounts for Project Identification Numbers 0022.0000 and 0.24 were each overstated by $298,172 and $1,490,414, respectively. 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 18 CITY OF PORTAGE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary periodic reports providing detailed accounting of the uses of funds, . . ." Cause The City's management did not have effective internal controls in place to ensure proper amounts were reported prior to submission. The City had established Project Identification Numbers based on the City's calendar year expense amounts. However, the City's calendar year, January 1 to December 31, differed from the P&E annual report calendar year, April 1 through March 31. This resulted in Project Identification Number 0022.0000 Current Period Obligation and Current Period Expenditures not to be reduced to zero and Project Identification Number 0.24 Current Period Obligation and Current Period Expenditures amounts to include $1,490,414 of January 1 through March 31, 2023, expenditures that were outside the P&E annual report that was due April 30, 2024, parameters. 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. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of federal funding to the City. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the City strengthen its system of internal controls over the preparation and review of federal reports to ensure appropriate reviews, approvals, and oversight are effective in preventing, or detecting and correcting, noncompliance. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding 2024-005 -Material Weakness: Cash Management Identification of federal program: Assistance Listing No. 93-493 - Congressional Directives Criteria or specific requirement: Per the OMB Compliance Supplement, "For grants and cooperative agreements to non-federal entities that are funded on a reimbursement basis, determine that expenditures, as defined by 2 CFR 200.1, were incurred prior to date of the reimbursement request." Condition: We noted two instances of request for reimbursement prior to the expenditures being incurred. Cause: Drawdown on reimbursement requests were submitted to the grantor prior to the System incurring qualifyig expenditures. Effect or potential effect: This resulted in material non-compliance with the cash management requirement for the grant program. Questioned cost: $92,130 known. The 2024 Schedule of Expenditures of Federal Awards has been corrected for this finding. Context: The finding is considered systemic in nature. Recommendation: We recommend that the System personnel administering the grant program comply with the System's established process, whereby qualifying expenditured are incurred prior to requesting reimbursement from the grantor. Views of responsible officials: The System concur wuth this finding. See page 57 for corrective action plan.
2024-001 Research and Development Cluster – Education Innovation and Research (formerly Investing in Innovation (i3) Fund – Validation Grants) Assistance Listing No. 84.411A Criteria: 2 CFR 200.332 notes, “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; (xii) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. (2) All requirements imposed by the pass-through entity on the subrecipient so that the Federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the Federal award; …” Condition: For both subawards selected for testing, the identification of the contact information for the awarding agency was incorrect. The contact information was Education Analytics, Inc., the Organization’s grantor, but should have been Future Forward, Inc. Further, one of the two subawards selected for testing had information missing from the subaward including all requirements for the award to be used in accordance with Federal statutes, regulations and terms and conditions of the Federal award. We consider this condition to be an instance of noncompliance relating to the Subrecipient Monitoring compliance requirement. Statistical sampling was not used in making sample selections. Questioned Costs: N/A Cause and Effect: Without communication of the required information, subrecipients may overspend award amounts or incur unallowable expenses towards the grant as well as report the incorrect grantor on their schedule of expenditures of federal awards. Recommendation: We recommend the Organization evaluates policies and procedures to ensure all required information is communicated with the subrecipient. Views of Responsible Officials: Management agrees with this Single Audit Finding and response is included in the Corrective Action Plan.
2024 – 001 Period of Performance Federal Agency: U.S. Department of Health and Human Services Federal Program: Consolidated Health Centers Grant AL Number: 93.224 & 93.527 Award Period: 1/1/24 - 12/31/24 Type of Finding: Significant deficiency in Internal Control over Compliance and Compliance Criteria or Specific Requirement According to § 2 CFR 200.303, the non-Federal entity must 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. According to 2 CFR 200.1 Period of Performance is defined as the total estimated time interval between the start of an initial Federal award and the planned end date, which may include one or more funded portions, or budget periods. Condition and Context The Organization began allocating direct salaries and benefits prior to the awards period of performance start date. The Organization allocated expenditures based on the payroll paid date, rather than the date the payroll was incurred. Total direct salaries and benefits allocated to the grant prior to the period of performance start date was $21,049. Effect Potential that costs will be charged to the grant outside of the period of performance. Questioned Costs $21,049 Cause The Organization allocated payroll expenditures based on the paid date, rather than the incurred date. Recommendation We recommend the Organization update their method of allocating expenditures to federal awards based on the incurred date, rather than paid date.Views of Responsible Officials The Organization corrected the period of performance finding prior to the 2024 audit being completed and feel this was an isolated incident. The issue was caused by staff turnover in 2024, and new staff have been properly trained to review all grants to ensure compliance with all grant regulations. This grant can be used for staffing costs and upon identification of this issue we have corrected the allocations to the prior grant periods. Going forward, the Organization has implemented controls to ensure that all staff are being trained to ensure they are following grant guidelines.
2024 – 001 Period of Performance Federal Agency: U.S. Department of Health and Human Services Federal Program: Consolidated Health Centers Grant AL Number: 93.224 & 93.527 Award Period: 1/1/24 - 12/31/24 Type of Finding: Significant deficiency in Internal Control over Compliance and Compliance Criteria or Specific Requirement According to § 2 CFR 200.303, the non-Federal entity must 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. According to 2 CFR 200.1 Period of Performance is defined as the total estimated time interval between the start of an initial Federal award and the planned end date, which may include one or more funded portions, or budget periods. Condition and Context The Organization began allocating direct salaries and benefits prior to the awards period of performance start date. The Organization allocated expenditures based on the payroll paid date, rather than the date the payroll was incurred. Total direct salaries and benefits allocated to the grant prior to the period of performance start date was $21,049. Effect Potential that costs will be charged to the grant outside of the period of performance. Questioned Costs $21,049 Cause The Organization allocated payroll expenditures based on the paid date, rather than the incurred date. Recommendation We recommend the Organization update their method of allocating expenditures to federal awards based on the incurred date, rather than paid date.Views of Responsible Officials The Organization corrected the period of performance finding prior to the 2024 audit being completed and feel this was an isolated incident. The issue was caused by staff turnover in 2024, and new staff have been properly trained to review all grants to ensure compliance with all grant regulations. This grant can be used for staffing costs and upon identification of this issue we have corrected the allocations to the prior grant periods. Going forward, the Organization has implemented controls to ensure that all staff are being trained to ensure they are following grant guidelines.
2024 – 001 Period of Performance Federal Agency: U.S. Department of Health and Human Services Federal Program: Consolidated Health Centers Grant AL Number: 93.224 & 93.527 Award Period: 1/1/24 - 12/31/24 Type of Finding: Significant deficiency in Internal Control over Compliance and Compliance Criteria or Specific Requirement According to § 2 CFR 200.303, the non-Federal entity must 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. According to 2 CFR 200.1 Period of Performance is defined as the total estimated time interval between the start of an initial Federal award and the planned end date, which may include one or more funded portions, or budget periods. Condition and Context The Organization began allocating direct salaries and benefits prior to the awards period of performance start date. The Organization allocated expenditures based on the payroll paid date, rather than the date the payroll was incurred. Total direct salaries and benefits allocated to the grant prior to the period of performance start date was $21,049. Effect Potential that costs will be charged to the grant outside of the period of performance. Questioned Costs $21,049 Cause The Organization allocated payroll expenditures based on the paid date, rather than the incurred date. Recommendation We recommend the Organization update their method of allocating expenditures to federal awards based on the incurred date, rather than paid date.Views of Responsible Officials The Organization corrected the period of performance finding prior to the 2024 audit being completed and feel this was an isolated incident. The issue was caused by staff turnover in 2024, and new staff have been properly trained to review all grants to ensure compliance with all grant regulations. This grant can be used for staffing costs and upon identification of this issue we have corrected the allocations to the prior grant periods. Going forward, the Organization has implemented controls to ensure that all staff are being trained to ensure they are following grant guidelines.
FINDING 2024-002 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Procurement and 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): Contract #65851 Pass-Through Entity: Schneck Medical Center Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2023-001. Condition and Context An effective internal control system was not in place at the City to ensure compliance with requirements related to the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement 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 customarily set at $250,000. However, Indiana Code 5-22-8 has a more restrictive threshold of $150,000 or less for when small purchase procedures may be used. This informal process allows for methods other than the formal bid process. The informal process is divided between two methods based on thresholds. Micro-purchases, 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. One vendor was identified that fell within the small purchase threshold. Purchases from the vendor totaled $148,800. As such, price or rate quotations from an adequate number of qualified sources should have been obtained. However, the City did not obtain price or rate quotations for the purchases, nor was full and open competition provided for the vendor. Additionally, there was no documentation available to support the rationale to limit competition. INDIANA STATE BOARD OF ACCOUNTS 15 CITY OF SEYMOUR SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Suspension and Debarment Prior to entering into subawards and covered transactions with the COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (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 adding a clause or condition to the covered transaction with that person. The City did not have policies or procedures in place for verifying that an entity with which it planned to enter into a covered transaction was not suspended, debarred, or otherwise excluded until November 25, 2024. One of the two vendors selected for testing, with covered transactions totaling $148,800, was not verified to ensure that the vendor was not suspended, debarred, or otherwise excluded. The lack of internal controls and noncompliance were systemic issues until the City implemented new policies and procedures in November 2024. 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.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 — INDIANA STATE BOARD OF ACCOUNTS 16 CITY OF SEYMOUR SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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. . . . 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 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 The City did not have a procurement policy in place that contained the requirements of the procurement standards as outlined in the Code of Federal Regulations prior to entering into an agreement with the vendor. Due to the timing of the adoption of the City's Procurement and Suspension and Debarment Policy, which defines procedures to ensure they are properly procuring services and verifying suspension and debarment status for covered transactions, not all of the items selected for testing were in compliance. Effect Without the proper implementation of an effectively designed system of internal controls, the City cannot ensure that goods and services are appropriately procured and that contractors paid with federal funds are eligible to participate in federal programs. Any program funds the City used to pay contractors that have been suspended or debarred would be unallowable, and the funding agency could potentially recover them. Furthermore, 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 City. Questioned Costs There were no questioned costs identified. Recommendation We recommended adhering to the newly implemented procurement policies to ensure compliance with state and federal laws and regulations for procuring goods and services paid with federal funds. We also recommended that management of the City adhere to its newly approved policy of internal controls to ensure that all contractors that are expected to be paid $25,000 or more, all or in part with federal funds, are not suspended or debarred from participating in federal programs before entering into covered transactions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding #24-001 – Significant Deficiency in Internal Control over Financial Reporting: Procurement Program Names: 3rd Street Housing Project Eagle Community Pool Replacement CFDA Titles and Numbers: 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Agency: United States Treasury Pass-through Agency: Colorado Department of Local Affairs Award Year: December 31, 2024 Condition: No formal Federal procurement policy has been adopted by the Town of Eagle, Colorado, resulting in a lack of internal controls over Federal procurement. Criteria or Specific Requirement: The Town of Eagle, Colorado, must comply with procurement standards set out at 2 CFR sections 200.303 and 200.318 through 200.326 within Uniform Guidance. Per 2 CFR section 200.303(a), a non-Federal entity must: 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). UG §200.318 General Procurement Standards. (i) 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, section of contract type, contractor selection or rejection, and the basis for the contract price. UG §200.320 states that the non-Federal entity must use one of the prescribed methods of procurement: (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 or property or services at or below the SAT include: (1) Micro-purchases. Procurement by micro-purchase is the acquisition of supplies or services, the aggregate dollar amount of which does not exceed the micro-purchase threshold (see definition of micro-purchase in §200.1). To the maximum extent practicable, the non-Federal entity should distribute micro-purchases equitably among qualified suppliers. Micro-purchases may be awarded without soliciting competitive price or equitably among qualified suppliers. Micro-purchases may be awarded without soliciting competitive price or rate quotations if the non-Federal entity considers the price to be reasonable based on research, experience, purchase history or other information and documents it files accordingly. Purchase cards can be used for micro-purchases if procedures are documented and approved by the non-Federal entity. (2) Small purchase. Procurement by small purchase is the acquisition of property or services, the aggregate dollar amount of which is greater 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. (b) Formal procurement methods. When the value of the procurement for property or services under a Federal financial assistance award exceeds the SAT, or a lower threshold established by a non-Federal entity, formal procurement methods are required. Formal procurement methods require following documented procedures. Formal procurement methods also require public advertising unless a non-competitive procurement can be used in accordance with §200.319 or paragraph (c) of this section. The following formal methods of procurement are used for procurement of property or services above the simplified acquisition threshold or a value below the simplified acquisition threshold the non-Federal entity determines to be appropriate: (1) Sealed Bids. Bids are publicly solicited, and a firm fixed-price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. (2) Proposals. Either a fixed price or cost-reimbursement-type contract is awarded. Proposals are generally used when conditions are not appropriate for the use of sealed bids. (c) Noncompetitive procurement. There are specific circumstances in which noncompetitive procurement can be used. Noncompetitive procurement can only be awarded if one or more of the allowed circumstances apply. Questioned Costs: N/A Context: Although the Town of Eagle, Colorado, had not adopted a formal Federal procurement policy as outlined in 2CFR sections 200.303 and 200.318 through 200.326, during the course of our federal single audit testing of transactions and contracts, we found that the Town’s general contract purchase procedures that were followed meet the requirements of the Uniform Guidance and that no contracts were awarded without proper justification in 7 or 7 procurement transactions tested. Cause: Management was not aware of the requirement of adopting a formal Federal procurement policy under the procurement standards set out at 2CFR sections 200.303 and 200.318 through 200.626 within Uniform Guidance. Effect: The Town of Eagle, Colorado, is at risk for noncompliance with Federal grants as it relates to procurement. Recommendation: We recommend that the Town of Eagle, Colorado, adopts a formal Federal procurement policy to include all elements identified in 2CFR Sections 200.303 and 200.318 through 200.626. Views of Responsible Officials and Planned Corrective Action: Management agrees with this finding and will adopt a formal Federal procurement policy which includes all elements identified in 2CFR Sections 200.303 and 200.318 through 200.626.
Finding #24-003 – Procurement Program Names: 3rd Street Housing Project Eagle Community Pool Replacement CFDA Titles and Numbers: 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Agency: United States Treasury Pass-through Agency: Colorado Department of Local Affairs Award Year: December 31, 2024 Condition: No formal Federal procurement policy has been adopted by the Town of Eagle, Colorado, resulting in a lack of compliance with Federal procurement. Criteria or Specific Requirement: The Town of Eagle, Colorado, must comply with procurement standards set out at 2 CFR sections 200.303 and 200.318 through 200.326 within Uniform Guidance. Per 2 CFR section 200.303(a), a non-Federal entity must: 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). UG §200.318 General Procurement Standards. (i) 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, section of contract type, contractor selection or rejection, and the basis for the contract price. UG §200.320 states that the non-Federal entity must use one of the prescribed methods of procurement: (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 or property or services at or below the SAT include: (1) Micro-purchases. Procurement by micro-purchase is the acquisition of supplies or services, the aggregate dollar amount of which does not exceed the micro-purchase threshold (see definition of micro-purchase in §200.1). To the maximum extent practicable, the non-Federal entity should distribute micro-purchases equitably among qualified suppliers. Micro-purchases may be awarded without soliciting competitive price or rate quotations if the non-Federal entity considers the price to be reasonable based on research, experience, purchase history or other information and documents it files accordingly. Purchase cards can be used for micro-purchases if procedures are documented and approved by the non-Federal entity. (2) Small purchase. Procurement by small purchase is the acquisition of property or services, the aggregate dollar amount of which is greater 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. (b) Formal procurement methods. When the value of the procurement for property or services under a Federal financial assistance award exceeds the SAT, or a lower threshold established by a non-Federal entity, formal procurement methods are required. Formal procurement methods require following documented procedures. Formal procurement methods also require public advertising unless a non-competitive procurement can be used in accordance with §200.319 or paragraph (c) of this section. The following formal methods of procurement are used for procurement of property or services above the simplified acquisition threshold or a value below the simplified acquisition threshold the non-Federal entity determines to be appropriate: (1) Sealed Bids. Bids are publicly solicited, and a firm fixed-price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. (2) Proposals. Either a fixed price or cost-reimbursement-type contract is awarded. Proposals are generally used when conditions are not appropriate for the use of sealed bids. (c) Noncompetitive procurement. There are specific circumstances in which noncompetitive procurement can be used. Noncompetitive procurement can only be awarded if one or more of the allowed circumstances apply. Questioned Costs: N/A Context: Although the Town of Eagle, Colorado, had not adopted a formal Federal procurement policy as outlined in 2CFR sections 200.303 and 200.318 through 200.326, during the course of our federal single audit testing of transactions and contracts, we found that the Town’s general contract purchase procedures that were followed meet the requirements of the Uniform Guidance and that no contracts were awarded without proper justification in 7 or 7 procurement transactions tested. Cause: Management was not aware of the requirement of adopting a formal Federal procurement policy under the procurement standards set out at 2CFR sections 200.303 and 200.318 through 200.626 within Uniform Guidance. Effect: The Town of Eagle, Colorado, is at risk for noncompliance with Federal grants as it relates to procurement. Recommendation: We recommend that the Town of Eagle, Colorado, adopts a formal Federal procurement policy to include all elements identified in 2CFR Sections 200.303 and 200.318 through 200.626. Views of Responsible Officials and Planned Corrective Action: Management agrees with this finding and will adopt a formal Federal procurement policy which includes all elements identified in 2CFR Sections 200.303 and 200.318 through 200.626.
Finding #24-001 – Significant Deficiency in Internal Control over Financial Reporting: Procurement Program Names: 3rd Street Housing Project Eagle Community Pool Replacement CFDA Titles and Numbers: 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Agency: United States Treasury Pass-through Agency: Colorado Department of Local Affairs Award Year: December 31, 2024 Condition: No formal Federal procurement policy has been adopted by the Town of Eagle, Colorado, resulting in a lack of internal controls over Federal procurement. Criteria or Specific Requirement: The Town of Eagle, Colorado, must comply with procurement standards set out at 2 CFR sections 200.303 and 200.318 through 200.326 within Uniform Guidance. Per 2 CFR section 200.303(a), a non-Federal entity must: 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). UG §200.318 General Procurement Standards. (i) 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, section of contract type, contractor selection or rejection, and the basis for the contract price. UG §200.320 states that the non-Federal entity must use one of the prescribed methods of procurement: (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 or property or services at or below the SAT include: (1) Micro-purchases. Procurement by micro-purchase is the acquisition of supplies or services, the aggregate dollar amount of which does not exceed the micro-purchase threshold (see definition of micro-purchase in §200.1). To the maximum extent practicable, the non-Federal entity should distribute micro-purchases equitably among qualified suppliers. Micro-purchases may be awarded without soliciting competitive price or equitably among qualified suppliers. Micro-purchases may be awarded without soliciting competitive price or rate quotations if the non-Federal entity considers the price to be reasonable based on research, experience, purchase history or other information and documents it files accordingly. Purchase cards can be used for micro-purchases if procedures are documented and approved by the non-Federal entity. (2) Small purchase. Procurement by small purchase is the acquisition of property or services, the aggregate dollar amount of which is greater 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. (b) Formal procurement methods. When the value of the procurement for property or services under a Federal financial assistance award exceeds the SAT, or a lower threshold established by a non-Federal entity, formal procurement methods are required. Formal procurement methods require following documented procedures. Formal procurement methods also require public advertising unless a non-competitive procurement can be used in accordance with §200.319 or paragraph (c) of this section. The following formal methods of procurement are used for procurement of property or services above the simplified acquisition threshold or a value below the simplified acquisition threshold the non-Federal entity determines to be appropriate: (1) Sealed Bids. Bids are publicly solicited, and a firm fixed-price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. (2) Proposals. Either a fixed price or cost-reimbursement-type contract is awarded. Proposals are generally used when conditions are not appropriate for the use of sealed bids. (c) Noncompetitive procurement. There are specific circumstances in which noncompetitive procurement can be used. Noncompetitive procurement can only be awarded if one or more of the allowed circumstances apply. Questioned Costs: N/A Context: Although the Town of Eagle, Colorado, had not adopted a formal Federal procurement policy as outlined in 2CFR sections 200.303 and 200.318 through 200.326, during the course of our federal single audit testing of transactions and contracts, we found that the Town’s general contract purchase procedures that were followed meet the requirements of the Uniform Guidance and that no contracts were awarded without proper justification in 7 or 7 procurement transactions tested. Cause: Management was not aware of the requirement of adopting a formal Federal procurement policy under the procurement standards set out at 2CFR sections 200.303 and 200.318 through 200.626 within Uniform Guidance. Effect: The Town of Eagle, Colorado, is at risk for noncompliance with Federal grants as it relates to procurement. Recommendation: We recommend that the Town of Eagle, Colorado, adopts a formal Federal procurement policy to include all elements identified in 2CFR Sections 200.303 and 200.318 through 200.626. Views of Responsible Officials and Planned Corrective Action: Management agrees with this finding and will adopt a formal Federal procurement policy which includes all elements identified in 2CFR Sections 200.303 and 200.318 through 200.626.
Finding #24-003 – Procurement Program Names: 3rd Street Housing Project Eagle Community Pool Replacement CFDA Titles and Numbers: 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Agency: United States Treasury Pass-through Agency: Colorado Department of Local Affairs Award Year: December 31, 2024 Condition: No formal Federal procurement policy has been adopted by the Town of Eagle, Colorado, resulting in a lack of compliance with Federal procurement. Criteria or Specific Requirement: The Town of Eagle, Colorado, must comply with procurement standards set out at 2 CFR sections 200.303 and 200.318 through 200.326 within Uniform Guidance. Per 2 CFR section 200.303(a), a non-Federal entity must: 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). UG §200.318 General Procurement Standards. (i) 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, section of contract type, contractor selection or rejection, and the basis for the contract price. UG §200.320 states that the non-Federal entity must use one of the prescribed methods of procurement: (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 or property or services at or below the SAT include: (1) Micro-purchases. Procurement by micro-purchase is the acquisition of supplies or services, the aggregate dollar amount of which does not exceed the micro-purchase threshold (see definition of micro-purchase in §200.1). To the maximum extent practicable, the non-Federal entity should distribute micro-purchases equitably among qualified suppliers. Micro-purchases may be awarded without soliciting competitive price or rate quotations if the non-Federal entity considers the price to be reasonable based on research, experience, purchase history or other information and documents it files accordingly. Purchase cards can be used for micro-purchases if procedures are documented and approved by the non-Federal entity. (2) Small purchase. Procurement by small purchase is the acquisition of property or services, the aggregate dollar amount of which is greater 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. (b) Formal procurement methods. When the value of the procurement for property or services under a Federal financial assistance award exceeds the SAT, or a lower threshold established by a non-Federal entity, formal procurement methods are required. Formal procurement methods require following documented procedures. Formal procurement methods also require public advertising unless a non-competitive procurement can be used in accordance with §200.319 or paragraph (c) of this section. The following formal methods of procurement are used for procurement of property or services above the simplified acquisition threshold or a value below the simplified acquisition threshold the non-Federal entity determines to be appropriate: (1) Sealed Bids. Bids are publicly solicited, and a firm fixed-price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. (2) Proposals. Either a fixed price or cost-reimbursement-type contract is awarded. Proposals are generally used when conditions are not appropriate for the use of sealed bids. (c) Noncompetitive procurement. There are specific circumstances in which noncompetitive procurement can be used. Noncompetitive procurement can only be awarded if one or more of the allowed circumstances apply. Questioned Costs: N/A Context: Although the Town of Eagle, Colorado, had not adopted a formal Federal procurement policy as outlined in 2CFR sections 200.303 and 200.318 through 200.326, during the course of our federal single audit testing of transactions and contracts, we found that the Town’s general contract purchase procedures that were followed meet the requirements of the Uniform Guidance and that no contracts were awarded without proper justification in 7 or 7 procurement transactions tested. Cause: Management was not aware of the requirement of adopting a formal Federal procurement policy under the procurement standards set out at 2CFR sections 200.303 and 200.318 through 200.626 within Uniform Guidance. Effect: The Town of Eagle, Colorado, is at risk for noncompliance with Federal grants as it relates to procurement. Recommendation: We recommend that the Town of Eagle, Colorado, adopts a formal Federal procurement policy to include all elements identified in 2CFR Sections 200.303 and 200.318 through 200.626. Views of Responsible Officials and Planned Corrective Action: Management agrees with this finding and will adopt a formal Federal procurement policy which includes all elements identified in 2CFR Sections 200.303 and 200.318 through 200.626.
FINDING 2024-004 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): FY24 Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2023-005. Condition and Context 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 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). 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 the P&E report by April 30, 2024, as required; 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. As a result, the following errors were noted: The current period expenditures for ten projects tested were understated by $533,935. In addition, current period expenditures for one project tested was overstated by $4,529. The cumulative expenditures for six projects tested were understated by $151,208. In addition, cumulative expenditures for three projects tested were overstated by $108,106. INDIANA STATE BOARD OF ACCOUNTS 20 DECATUR COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The current period obligations for four projects tested were understated by $205,178. In addition, current period obligations for four projects tested were overstated by $1,634,629. The cumulative obligations for one project tested was understated by $100,000. In addition, cumulative obligations for six projects tested were overstated by $2,007,842. 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). . . ." Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary . . . periodic reports providing detailed accounting of the uses of funds . . ." Cause A proper system of internal controls, including policies and procedures, was not designed or implemented by management of the County to prevent and detect errors on the P&E report prior to submission. The County incorrectly reported projects that had been appropriated, but not yet obligated, and amounts reported did not always agree to the County's records. The reports submitted were not reviewed by a second person to identify these errors prior to submission. Effect Without the proper implementation of an effectively designed 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. As such, the County did not accurately report current period obligations and cumulative obligations when filing the P&E report for the period April 1, 2023 to March 31, 2024. INDIANA STATE BOARD OF ACCOUNTS 21 DECATUR COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Noncompliance with the provisions of federal regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the County. In addition, not meeting the SLFRF reporting requirements increases the likelihood that the public will not have access to transparent and accurate information regarding expenditures of federal awards. 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 of federal reports are taking place. We also recommended the development of policies and procedures to ensure the County provides the Treasury with complete and accurate information for the P&E report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-003 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): 2024 Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2023-005. Condition and Context 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). 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, the report was submitted without a review or oversight process in place to prevent, or detect and correct, errors. As a result, cumulative obligations reported were overstated by $1,160,124. 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 20 JEFFERSON COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary periodic reports providing detailed accounting of the uses of funds, . . ." Cause The County reported the total program funds received in the cumulative obligations amount, instead of only reporting the funds that had been obligated. Due to the timing of the P&E report submission and prior audit completion, corrective actions from finding 2023-005 could not be implemented in time to correct this noncompliance. Effect Without the proper implementation of an effectively designed 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. As such, the County did not report cumulative obligations properly when filing the P&E report for the period April 1, 2023 to March 31, 2024. 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. In addition, not meeting the SLFRF reporting requirements increases the likelihood that the public will not have access to transparent and accurate information regarding expenditures of federal awards. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the County strengthen its system of internal controls to provide for a segregation of duties in the preparation and review of federal reports to ensure appropriate reviews, approvals, and oversight are taking place. We also recommended the development of policies and procedures to ensure the County provides the Treasury with complete and accurate information for the P&E report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-005 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): FY2024 Compliance Requirement: Reporting 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 2023-004. Condition and Context The County had not properly 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 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 submitted one 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 and a financial consultant prepared the P&E report based on reports from the County's financial system and the County Auditor submitted the report. There was no evidence of an oversight or review process. The County submitted the P&E report by April 30, 2024, as required; however, the report was not supported by the County's records. The annual report submitted in April 2024 did not include an expenditure of $228,300 as the County Auditor used the incorrect period of March 31, 2023 to December 31, 2023, to complete the report, and this expenditure was incurred on February 5, 2024. 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 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary periodic reports providing detailed accounting of the uses of funds, . . ." INDIANA STATE BOARD OF ACCOUNTS 23 SHELBY COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." Cause A proper system of internal controls, which would include segregation of key functions, was not designed by management of the County. The lack of review or approval process by someone other than the preparers allowed the error in the P&E report to go undetected. The error was a result of expenditures from the incorrect reporting period being used to complete the report. 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, noncompliance. As such, the P&E report submitted understated expenditures. 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. In addition, not meeting the SLFRF reporting requirements increases the likelihood that the public will not have access to transparent and accurate information regarding expenditures of federal awards. 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 to ensure that the County abstracts the correct reporting period, to provide the Treasury with complete and accurate information for the P&E reports. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-001 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Procurement and 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): 2021 Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediate prior audit report. The prior audit finding number was 2023-001. 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 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 customarily set at $250,000. However, Indiana Code 5-22-8 has a more restrictive threshold of $150,000 or less for when small purchase procedures may be used. This informal process allows for methods other than the formal bid process. Micro-purchases are typically for those purchases $10,000 or under, and small purchase procedures are 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. One vendor was identified that fell within the small purchase threshold. Purchases from the vendor totaled $40,458. As such, price or rate quotations from an adequate number of qualified sources should have been obtained. However, the City did not obtain price or rate quotations for the purchases, nor was full and open competition provided for the vendor. Additionally, there was no documentation available to support the rationale to limit competition. Suspension and Debarment The City elected to receive the standard revenue loss allowance, allowing the City to claim $10,000,000 of its total COVID-19 - State and Local Fiscal Recovery Funds (SLFRF) allocation of $16,549,045 as revenue loss to use for government services. 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 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 City was only required to comply with suspension and debarment requirements related to contracts. The City's policies related to SLFRF suspension and debarment requirements include the Board of Public Works completing a review of each bid packet to ensure the bidder submitted a statement indicating if they were not suspended or debarred or an employee from the City Controller's office checking the Sam.gov website. There were 13 covered transactions identified that equaled or exceeded $25,000, and 2 covered transactions, totaling $251,334, were selected for testing. For both of the transactions tested, the City did not verify the suspension or debarment status prior to 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). . . ." 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 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." 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." 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. . . ." Cause The City did not follow the City's established policy to ensure the proper procurement of services and supplies and to verify suspension and debarment status for covered transactions. 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. The City did not use the proper method of procurement to choose a vendor. In addition, the City did not ensure the contractors paid with federal funds are eligible to participate in federal programs. Any program funds the City used to pay contractors that have been suspended or debarred would be unallowable, and the funding agency could potentially recover them. Furthermore, 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 City. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the City follow the City's established policies to ensure compliance with requirements related to procurement and suspension and debarment. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-002 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Procurement and 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): TRSW222046 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 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 customarily set at $250,000. However, Indiana Code 5-22-8 has a more restrictive threshold of $150,000 or less for when small purchase procedures may be used. This informal process allows for methods other than the formal bid process. Micro-purchases are typically for those purchases $10,000 or under, and small purchase procedures are 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 grant covered one project with one vendor that fell within the simplified acquisition threshold. Payments to the vendor for the project totaled $189,741 with $120,452 of that amount was grant funds. As such, the formal bid process should have been followed. The City did not perform bid procedures or provide the rationale for the method of procurement, the selection of vendor, or the basis for price. Additionally, the City did not obtain a written contract for the services. Suspension and Debarment Prior to entering into subawards and covered transactions with federal 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 SAM exclusions, collecting a certification from that person, or adding a clause or condition to the covered transaction with that person or entity. The City's policies related to COVID-19 - Coronavirus State and Local Fiscal Recovery Funds suspension and debarment requirements include the Board of Public Works completing a review of each bid packet to ensure the bidder submitted a statement indicating if they were not suspended or debarred or an employee from the City Controller's office checking the Sam.gov website. As noted above, the grant covered one project with one vendor utilized and the City did not verify the suspension or debarment status prior to payment for this vendor. The lack of internal controls and noncompliance was isolated to the instance noted above. 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(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." 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: . . . (b) Formal Procurement Methods. When the value of the procurement for property or services under a Federal financial assistance award exceeds the SAT, or a lower threshold established by a non-Federal entity, formal procurement methods are required. Formal procurement methods require following documented procedures. Formal procurement methods also require public advertising unless a non-competitive procurement can be used in accordance with § 200.319 or paragraph (c) of this section. The following formal methods of procurement are used for procurement of property or services above the simplified acquisition threshold or a value below the simplified acquisition threshold the non-Federal entity determines to be appropriate: (1) Sealed bids. A procurement method in which bids are publicly solicited and a firm fixed-price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. The sealed bids method is the preferred method for procuring construction, if the conditions. . . . (2) Proposals. A procurement method in which either a fixed price or cost-reimbursement type contract is awarded. Proposals are generally used when conditions are not appropriate for the use of sealed bids. . . ." 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 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 The City did not follow the City's established policy to ensure the proper procurement of services and supplies and to verify suspension and debarment status for covered transactions. 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. The City did not use the proper method of procurement to choose a vendor. In addition, the City did not ensure the contractors paid with federal funds are eligible to participate in federal programs. Any program funds the City used to pay contractors that have been suspended or debarred would be unallowable, and the funding agency could potentially recover them. Furthermore, 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 City. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the City follow its established policies to ensure compliance with requirements related to procurement and suspension and debarment. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
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): CY2021 Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2023-001. Condition and Context 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 City was classified as a metropolitan city with a population below 250,000 residents that received an allocation of more than $10 million in COVID-19 - Coronavirus 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 quarterly reports were to cover one calendar quarter and must be submitted to the Treasury by the last day of the month following the end of the period covered. The City submitted four P&E reports during the audit period; however, the internal controls in place were not effective to prevent, or detect and correct, errors. As a result, errors in reporting were identified. The current period and cumulative expenditures reported consisted of the amounts expended by the beneficiaries who were awarded funds from the City, rather than total amounts expended to the beneficiaries, resulting in current period expenditures and cumulative expenditures being incorrectly reported on three of the four reports as follows: Quarterly Report: October 1, 2023 to December 31, 2023 Current period expenditures were overstated by $666,417. Cumulative expenditures were understated by $964,879. Quarterly Report: January 1, 2024 to March 31, 2024 Current period expenditures were overstated by $860,312. Cumulative expenditures were understated by $104,567. Quarterly Report: April 1, 2024 to June 30, 2024 Current period expenditures were overstated by $104,567. The lack of effective 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). . . ." Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary or her delegate, as applicable, periodic reports providing detailed accounting of the uses of funds, . . ." 2 CFR 200.1 states in part: ". . . Expenditures means charged made by a non-Federal entity to a project or program for which a Federal award was received. . . . (2) For reports prepared on a cash basis, expenditures are the sum of: (i) Cash disbursements for direct charges for property and services; (ii) The amount of indirect expense charged; (iii) The value of third-party in-kind contribution applied; and (iv) The amount of cash advance payments and payments made to subrecipients. . . ." Cause The City's oversight process for filing the P&E reports for the period of October 1, 2023 to September 30, 2024, did not detect errors in the P&E reports. The City's understanding was that the expenditures in its report should be based on when the beneficiaries expended the funds and not when the City disbursed the funds to the beneficiaries. The City officials did not understand the requirements until the prior audit was finished, which was after multiple of these reports had already been submitted. 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 such, the City did not report cumulative expenditures and current period expenditures properly when filing the P&E reports for periods from October 1, 2023 to September 30, 2024. 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 City. In addition, not meeting the SLFRF reporting requirements increases the likelihood that the public will not have access to transparent and accurate information regarding expenditures of federal awards. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the City develop policies and procedures to ensure the City provides the Treasury with complete and accurate information as it relates to the City in its P&E reports. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Federal Program, Assistance Listing # and Year, Federal Agency, Pass-Through Entity: COVID-19 - Coronavirus State & Local Fiscal Recovery Fund, Assistance Listing #21.027, 2021, U.S. Department of Treasury. Criteria or Specific Requirement: In accordance with 2 CFR 200.1, all recipients of federal funds must complete and submit annual project and expenditure reports on all SLFRF funded projects. Also, 2 CFR 200.303 requires the entity to establish and maintain effective internal controls over compliance with respect to federal awards and Section 1111(b)(2)(A) of the ESEA for compliance accountability. Proper internal controls require supporting documentation to be retained as evidence for effectiveness of the controls in place. In accordance with 2 CFR.307, program income earned during the period of performance must be used in accordance with the terms and conditions of the federal award. Condition: During our testing, CRI identified a lack of internal controls related to reviewing and approving report submissions. During our testing, CRI identified 2024 report submissions did not agree to cumulativeto- date expenditures of the fiscal years 2021-2024. During our testing, CRI identified revenue recognized/earned during the period was improperly reported as program income and expenditures were improperly included as program income expenditures, causing inaccurate reporting. Program income was materially overstated. Effect: The City of Shreveport risks reports required to be submitted to the U.S. Department of the Treasury to be materially misstated. Cause: A lack of adequate controls over reporting requirements. Questioned Costs: Not applicable Context: The issue was identified while testing the population of reports. Recommendation: We recommend the City implements proper controls to review reports submitted, so as to identify and address any discrepancies. Views of responsible officials and corrective action plan: Accounting has reviewed all projects and Ordinances related to ARPA and has updated reports and records to fully account for ARPA funding. From the Chief Administrative Officer (CAO) and the department responsible for a specific project that has multiple funding sources, confirmation was obtained on what amounts were obligated ARPA funds. This strengthens the controls over the report submission process to ensure the reported amounts are accurate and reconciled properly.
FINDING 2024-003 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 2023 Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context 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 City was classified as a metropolitan city 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 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, April 1 through March 31, and must be submitted to the Treasury by April 30 each year. The City submitted one P&E report during the audit period. The internal controls in place were not effective and did not prevent, or detect and correct, errors in the P&E report prior to submission. As a result, the Current Period Obligation and Current Period Expenditure amounts for Project Identification Numbers 0022.0000 and 0.24 were each overstated by $298,172 and $1,490,414, respectively. 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 18 CITY OF PORTAGE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary periodic reports providing detailed accounting of the uses of funds, . . ." Cause The City's management did not have effective internal controls in place to ensure proper amounts were reported prior to submission. The City had established Project Identification Numbers based on the City's calendar year expense amounts. However, the City's calendar year, January 1 to December 31, differed from the P&E annual report calendar year, April 1 through March 31. This resulted in Project Identification Number 0022.0000 Current Period Obligation and Current Period Expenditures not to be reduced to zero and Project Identification Number 0.24 Current Period Obligation and Current Period Expenditures amounts to include $1,490,414 of January 1 through March 31, 2023, expenditures that were outside the P&E annual report that was due April 30, 2024, parameters. 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. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of federal funding to the City. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the City strengthen its system of internal controls over the preparation and review of federal reports to ensure appropriate reviews, approvals, and oversight are effective in preventing, or detecting and correcting, noncompliance. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
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): Account ID 20-1982-0-1-806 Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion INDIANA STATE BOARD OF ACCOUNTS 13 GIBSON COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The County elected to receive the standard revenue loss allowance, allowing it to claim a total COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (SLFRF) allocation of $6,537,866 as revenue loss to use for government services. As such, all SLFRF program funds expended from January 1, 2024 to December 31, 2024, were 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 as there is no federal program or purpose to carry out in the case of the revenue loss portion of the award. Recipients are required to submit quarterly or annually Project and Expenditure (P&E) reports to the Treasury. The reporting periods, as well as the respective due dates, are based on the type of recipient and the recipient's 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 submitted the required annual P&E reports during the audit period, which were obtained from the County Auditor's office. Although one employee prepared the P&E report and another reviewed the entries, the system of internal controls was not effective in preventing, detecting and correcting, errors. The data submitted included amounts which were not supported by the County's records. Errors identified included the following: • The 2024 Annual P&E report current expenditures were overstated by $170,815. • The 2024 Annual P&E report current obligations were overstated by $170,815. • The 2024 Annual P&E report cumulative obligations were overstated by $101,490. • The 2024 Annual P&E report cumulative expenditures were overstated by $99,325. The County did not adequately track expenditures annually as required, despite the P&E report breaking down expenditures by project, which would have allowed for accurate tracking. Instead, the County's ledger did not have adjustments or corrections that were included in the P&E report, resulting in the inability to verify the accuracy of the annual report filed during the audit period. The lack of effective 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 14 GIBSON COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary periodic reports providing detailed accounting of the uses of funds, . . ." Cause The Deputy County Auditor reported that, due to persistent error messages in the submission system, the financial figures were modified to enable successful submission. 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. 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. In addition, not meeting the SLFRF reporting requirements, by reporting erroneous data, increases the likelihood that the public and the Treasury will not have access to transparent and accurate information regarding expenditures of federal awards. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the 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 take 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 2024-003 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): FY2023 Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context 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 City was classified as a city with a population below 250,000 residents that was allocated less than $10 million in COVID-19 - Coronavirus State and Local Fiscal Recovery Funds funding. As such, the P&E report, covering the period April 1, 2023 to March 31, 2024, was required to be submitted to the Treasury by April 30, 2024. The subsequent annual reports are to cover one year from April 1 to March 31 and must be submitted to the Treasury by April 30 of each year. The City submitted the P&E report by April 30, 2024, as required, and there was more than one employee involved in the process of submission; however, internal controls were not effective to prevent, or detect and correct, errors. The data submitted included amounts that were not supported by the City's records and amounts that should not have been included. Errors identified included the following: Total Cumulative Obligations were overstated by $452,808. Current Period Obligations were overstated by $1,819,927. Current Period Expenditures and Total Cumulative Expenditures were overstated by $1,400,000. The lack of internal controls and noncompliance was a systemic issue throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 18 CITY OF MARION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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). . . ." Compliance and Reporting Guidance, State and Local Fiscal Recovery Funds, page 13, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary or her delegate, as applicable, periodic reports providing detailed accounting of the uses of funds . . ." Cause The City included the total amount appropriated to each of the projects that were overstated on the report and did not only include the amounts that were obligated as of the end date of the report. Also, the City included transfers to other funds in cumulative and current expenditures, but the funds were not expended as of the end of the report date. Effect Without the proper implementation of an effectively designed 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. As such, the City did not accurately report current period obligations and cumulative obligations when filing the P&E report for the period April 1, 2023 to March 31, 2024. Noncompliance with the provisions of federal regulations and the terms and conditions of the federal award could result in the loss of future federal funding to the City. Questioned Costs There were no questioned costs identified. INDIANA STATE BOARD OF ACCOUNTS 19 CITY OF MARION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended that management of the City 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 of federal reports are taking place. We also recommended the development of policies and procedures to ensure the City provides the Treasury with complete and accurate information for the P&E report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
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 Findings: Material Weakness, Modified Opinion INDIANA STATE BOARD OF ACCOUNTS 13 WABASH COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context 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 the 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). 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 the P&E report that covered the period from April 1, 2023 to March 31, 2024, by April 30, 2024, as required; however, there was no evidence provided for audit to support there was a review or oversight process implemented to prevent, or detect and correct, errors on the prepared and submitted P&E report. As a result, the submitted P&E report included the following errors: The total cumulative expenditures of the entire program up to the report date of March 31, 2024, were reported as $2,028,663, which was underreported by $574,410; the actual total cumulative expenditures to be reported were identified as $2,603,073. The total cumulative obligations of the entire program up to the report date of March 31, 2024, were reported as $6,020,610, which was overreported by $1,604,688; the actual total cumulative obligations to be reported were identified as $4,415,922. 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). . . ." Compliance and Reporting Guidance, State and Local Fiscal Recovery Funds, page 13, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." INDIANA STATE BOARD OF ACCOUNTS 14 WABASH COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary . . . periodic reports providing detailed accounting of the uses of funds . . ." Cause A proper system of internal controls, including policies and procedures, was designed but not implemented by management of the County to prevent and detect errors on the P&E report prior to submission. The County reported amounts for total cumulative expenditures and total cumulative obligations that did not agree with the County's records. The report submitted was not reviewed by a second person to identify this error prior to submission. Effect Without the proper implementation 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. As such, the County reported amounts for total cumulative expenditures and total cumulative obligations that did not agree with the County's records when filing the P&E report for the period April 1, 2023 to March 31, 2024. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the County implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight of federal reports are taking place. We also recommended the development of policies and procedures to ensure the County provides the Treasury with complete and accurate information for the P&E report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-003 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): IN0184 Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context 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 City was classified as a metropolitan city 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). 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 City submitted one P&E report during the audit period; however, the report was submitted without a documented review or oversight process in place to prevent, or detect and correct, errors. As a result, errors in reporting were identified. For one of the projects within the report, one claim included in the current period and cumulative expenditures was paid after the period covered (April 1, 2023 to March 31, 2024) by this report. This caused the current period and the cumulative expenditures to be overstated in the amount of $18,860. 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). . . ." Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary periodic reports providing detailed accounting of the uses of funds, . . ." Cause A proper system of internal controls over the P&E report was not implemented by the management of the City to ensure that complete and accurate information related to the SLFRF awards was provided to the Treasury. Effect Without the proper implementation of an effectively designed 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. As such, errors, as identified in the Condition and Context, occurred, and inaccurate information was provided to the Treasury. 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 City. In addition, not meeting the SLFRF reporting requirements increases the likelihood that the public will not have access to transparent and accurate information regarding expenditures of federal awards. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the City design and implement a proper system of internal controls that would provide for segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Additionally, management should develop policies and procedures to ensure that the City abstracts and reports on the correct time frame for each report submitted to provide the Treasury with complete and accurate information. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-002 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): CY 2024 Compliance Requirement: Reporting 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 2023-001. Condition and Context 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 the type of recipient and its population, as well as the recipient's allocation amount. Information to be reported includes projects funded, expenditures, and contract 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 COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (SLFRF) funding. As such, the initial P&E report, covering three calendar quarters from March 3, 2021 to December 31, 2021, was required to be submitted to the Treasury by January 31, 2022. The subsequent quarterly reports are to cover one calendar quarter and must be submitted to the Treasury by the last day of the month following the end of the period covered. INDIANA STATE BOARD OF ACCOUNTS 16 HOWARD COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) One employee at the County prepared the quarterly reports, and the County Auditor reviewed the reports; however, the internal control was not effective and did not detect and allow correction of material misstatements prior to submission. Two of the four quarterly reports submitted during the audit period were selected for testing. For the two reports tested, all activity for the reporting period was not included, information submitted was not supported by the County's records, and the reports were not fairly presented. The errors identified on the quarterly reports included the following: Quarter 4 Project and Expenditure Report (October 1, 2023 to December 31, 2023) Total Cumulative Obligations were understated by $331,303 Total Cumulative Expenditures were understated by $331,303 Current Period Obligations were understated by $155 Current Period Expenditures were understated by $20,856 Quarter 3 Project and Expenditure Report (July 1, 2024 to September 30, 2024) Total Cumulative Obligations were overstated by $15,138 Total Cumulative Expenditures were understated by $15,118 Current Period Obligations were understated by $294,973 Current Period Expenditures were understated by $9,685 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 17 HOWARD COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary periodic reports providing detailed accounting of the uses of funds, . . ." Cause 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 statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. The errors were due to all expenditures not being included in the reports and report entry errors such as typos. These errors were due to not all expenditures being included in the P&E reports ran for the time frame and not having a correct understanding of what was to be included in the reports. Effect Without the proper implementation of an effectively designed system of internal controls over reporting, the County could not ensure that the reports submitted were accurate. In addition, not meeting the SLFRF reporting requirements increases the likelihood that the public will not have access to transparent and accurate information regarding expenditures of federal awards. 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 design and implement a proper system of internal controls, including policies and procedures, to ensure that the County provides the Treasury with complete and accurate information for the P&E report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-003 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): SLFRP0752 Compliance Requirement: Reporting 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 2023-002. Condition and Context Recipients are required to submit quarterly or annual 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 COVID-19 - State and Local Fiscal Recovery Funds (SLFRF). As such, the P&E report, covering the period from April 1, 2023 to March 31, 2024, was required to be submitted to the Treasury by April 30, 2024. The County submitted the P&E report by April 30, 2024, as required. Although one employee prepared the P&E report and another reviewed the entries, the system of internal controls was not effective in preventing, or detecting and correcting, errors. The County omitted expenditures that should have been reported and conversely reported expenditures that were erroneously charged to the grant fund but later moved to the correct fund. Additionally, the County reported obligations that were based on amounts budgeted for planned projects. Obligations are defined by a commitment to expend funds based on entering into contracts, subawards, or similar transactions that require payment. An allocation of funds in a budget or an intention to enter into a contract does not constitute an obligation. The errors identified included the following: Current obligations were understated by $1,723,673. Current expenditures were overstated by $29,960. Cumulative obligations were overstated by $1,385,504. Cumulative expenditures were understated by $12,000. 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 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary or her delegate, as applicable, periodic reports providing detailed accounting of the uses of funds, . . ." Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." Cause Although a system of internal controls over the P&E report which included segregation of duties was designed by management, it did not ensure that 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 statements of what should be done to effect internal controls, 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 P&E report submitted to the Treasury misstated obligations and expenditures. 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. In addition, not meeting the SLFRF reporting requirements increases the likelihood that the public will not have access to transparent and accurate information regarding expenditures of federal awards. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the 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 take 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 2024-004 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - American Rescue Plan Act - 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): FY2024 Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2023-002. Condition and Context Recipients are required to submit quarterly or annual 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. INDIANA STATE BOARD OF ACCOUNTS 21 LAWRENCE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The County was classified as a 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). As such, the P&E report covering the period from April 1, 2023 to March 31, 2024, was required to be submitted to the Treasury by April 30, 2024. The P&E report was submitted April 30, 2024, as required; however, the information submitted did not match the County's ledgers for Total Expenditures and Total Cumulative Expenditures. Total Period Expenditures was reported as $2,720,340, as was Total Cumulative Expenditures. The ledger amount was $2,631,190, resulting in expenditures being overstated by $89,150. In addition, supporting documentation was not provided to support the amounts reported as Total Period Obligations and Cumulative Period Obligations, resulting in the inability to verify the accuracy of the information reported. There were no internal controls in place to prevent, or detect and correct, noncompliance related to the P&E report. Even though a County Commissioner reviewed and approved the report submission, as indicated by his signature, this review was not effective. 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). . . ." Compliance and Reporting Guidance, State and Local Fiscal Recovery Funds, page 13, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary periodic reports providing detailed accounting of the uses of funds, . . ." Cause The County's system of internal controls was not effective in detecting the errors noted in the Condition and Context above and did not allow for the appropriate supporting documentation to be retained for review. INDIANA STATE BOARD OF ACCOUNTS 22 LAWRENCE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect Without the proper implementation of an effectively designed 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. As such, the County did not report current period obligations, current period expenditures, and cumulative expenditures properly when filing the P&E reports during the audit period. 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. In addition, not meeting the SLFRF reporting requirements increases the likelihood that the public will not have access to transparent and accurate information regarding expenditures of federal awards. 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 to ensure that effective internal controls are implemented over all grant compliance requirements for reporting and allow for the retention of all required supporting documentation. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-003 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Subrecipient Monitoring 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): SLFRP1096 Compliance Requirement: Subrecipient Monitoring Audit Finding: Material Weakness INDIANA STATE BOARD OF ACCOUNTS 19 CITY OF ANDERSON SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context Subrecipients associated with the City's Non-profit, Affordable Housing, and Homeless Initiatives activities funded by the COVID-19 - Coronavirus State and Local Fiscal Recovery Funds were required to submit reports on program activities either quarterly or monthly. The City did not have adequate internal controls in place designed to ensure that these reports were reviewed. Responsibility for reviewing these reports rested primarily with one employee. For two of three subrecipients tested, we were not able to determine that there was a second employee involved that would ensure that the reports submitted by the subrecipients were reviewed by the City. 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). . . ." 2 CFR 200.332 states: "All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and include the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward notification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; INDIANA STATE BOARD OF ACCOUNTS 20 CITY OF ANDERSON SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the passthrough entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the passthrough entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; (xii) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. (2) All requirements imposed by the pass-through entity on the subrecipient so that the Federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the Federal award; (3) Any additional requirements that the pass-through entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the Federal awarding agency including identification of any required financial and performance reports. (4) (i) An approved federally recognized indirect cost rate negotiated between the subrecipient and the Federal Government. If no approved rate exists, the passthrough entity must determine the appropriate rate in collaboration with the subrecipient, which is either: (A) The negotiated indirect cost rate between the pass-through entity and the subrecipient; which can be based on a prior negotiated rate between a different PTE and the same subrecipient. If basing the rate on a previously negotiated rate, the pass through entity is not required to collect information justifying this rate, but may elect to do so; (B) The de minimis indirect cost rate. (ii) The pass-through entity must not require use of a de minimis indirect cost rate if the subrecipient has a Federally approved rate. Subrecipients can elect to use the cost allocation method to account for indirect costs in accordance with § 200.405(d). INDIANA STATE BOARD OF ACCOUNTS 21 CITY OF ANDERSON SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (5) A requirement that the subrecipient permit the pass-through entity and auditors to have access to the subrecipient's records and financial statements as necessary for the pass-through entity to meet the requirements of this part; and (6) Appropriate terms and conditions concerning closeout of the subaward. . . . (b) Evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section, which may include consideration of such factors as: (1) The subrecipient's prior experience with the same or similar subawards; (2) The results of previous audits including whether or not the subrecipient receives a Single Audit in accordance with Subpart F of this part, and the extent to which the same or similar subaward has been audited as a major program; (3) Whether the subrecipient has new personnel or new or substantially changed systems; and (4) The extent and results of Federal awarding agency monitoring (e.g., if the subrecipient also receives Federal awards directly from a Federal awarding agency). (c) Consider imposing specific subaward conditions upon a subrecipient if appropriate as described in § 200.208. (d) Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: (1) Reviewing financial and performance reports required by the pass-through entity. (2) Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particular subaward. (3) Issuing a management decision for applicable audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by § 200.521. INDIANA STATE BOARD OF ACCOUNTS 22 CITY OF ANDERSON SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (4) The pass-through entity is responsible for resolving audit findings specifically related to the subaward and not responsible for resolving crosscutting findings. If a subrecipient has a current Single Audit report posted in the Federal Audit Clearinghouse and has not otherwise been excluded from receipt of Federal funding (e.g., has been debarred or suspended), the pass-through entity may rely on the subrecipient's cognizant audit agency or cognizant oversight agency to perform audit follow-up and make management decisions related to cross-cutting findings in accordance with section § 200.513(a)(3)(vii). Such reliance does not eliminate the responsibility of the pass-through entity to issue subawards that conform to agency and award-specific requirements, to manage risk through ongoing subaward monitoring, and to monitor the status of the findings that are specifically related to the subaward. (e) Depending upon the pass-through entity's assessment of risk posed by the subrecipient (as described in paragraph (b) of this section), the following monitoring tools may be useful for the pass-through entity to ensure proper accountability and compliance with program requirements and achievement of performance goals: (1) Providing subrecipients with training and technical assistance on program related matters; and (2) Performing on-site reviews of the subrecipient's program operations. (3) Arranging for agreed-upon-procedures engagements as described in § 200.425. (f) Verify that every subrecipient is audited as required by Subpart F of this part when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in § 200.501. (g) Consider whether the results of the subrecipient's audits, on-site reviews, or other monitoring indicate conditions that necessitate adjustments to the pass-through entity's own records. (h) Consider taking enforcement action against noncompliant subrecipients as described in § 200.339 of this part and in program regulations." Cause A system of internal controls to include oversite and review of the quarterly or monthly reports prepared by the subrecipients was not in place. One individual was primarily responsible for reviewing the subrecipient reports. Effect Not having procedures in place for oversite and review of the monitoring reports could lead to noncompliance with the requirements for subrecipient monitoring. 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 City. INDIANA STATE BOARD OF ACCOUNTS 23 CITY OF ANDERSON SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the City establish a proper system of internal controls to include oversite and review to ensure that the subrecipient report reviews are reviewed/approved by a second party. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-005 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): 2024 Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context 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, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. Recipients are required to submit an initial interim report and 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 City was classified as a city with a population below 250,000 residents that was allocated less than $10 million in COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (SLFRF). As such, an annual P&E report, covering one calendar year from April 1, 2023 to March 31, 2024, was prepared and submitted by the Clerk-Treasurer to the Treasury by April 30, 2024. The P&E report data to be submitted included, but was not limited to, current period and total cumulative obligations and current period and total cumulative expenditures. We were unable to trace the annual P&E report to the City's records. The errors identified were as follows: Total cumulative obligations were overstated by $1,732,149. Current period obligations were understated by $2,089,238. Current period expenditures and total cumulative expenditures were both overstated by $38,398. In addition, the P&E report required obligations and expenditures to be reported by project. The City completed the report utilizing total amounts for all projects. There were 11 projects appropriated using the SLFRF award. 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: INDIANA STATE BOARD OF ACCOUNTS 23 CITY OF VINCENNES SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (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. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary periodic reports providing detailed accounting of the uses of funds, . . ." Compliance and Reporting Guidance, State and Local Fiscal Recovery Funds, page 13, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." Cause The City officials appropriated the entire SLFRF award in May 2022 and reported the entire award amount as obligated in the P&E reports completed in 2023 and 2024. City officials were not aware that appropriating the funds alone does not constitute obligations of the award. Additionally, correcting adjustments made after the report was submitted partially contributed to the differences noted in expenditures. City officials were also not aware that obligations and expenditures could not be reported in total but should be reported by project. Effect Without a proper system of internal controls in place that operated effectively, the City did not file an accurate annual P&E report as required under the federal award. As such, the City did not accurately report current period obligations, cumulative obligations, current period expenditures, and cumulative expenditures when filing the P&E report for the period April 1, 2023 to March 31, 2024. As a result, material noncompliance occurred and remained undetected. 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 City. INDIANA STATE BOARD OF ACCOUNTS 24 CITY OF VINCENNES 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 and develop and implement reporting policies and procedures to ensure that all required reports are complete and accurate when submitted. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-003 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 Findings: Material Weakness, Modified Opinion INDIANA STATE BOARD OF ACCOUNTS 17 TOWN OF RIDGEVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context 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 Town was classified as a metropolitan town 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). 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 Town submitted one P&E report during the audit period; however, the internal controls in place were not effective and did not prevent, or detect and correct, errors. As a result, the following errors in reporting were identified: Expenditures for a police car were overstated by $5,868. Expenditures for a utility truck, digital sign, and fire safety equipment occurred outside of the reporting period but were reported resulting in an overstatement of $72,605. Reported expenditures for fire safety equipment were overstated by $30,000. Expenditures for a Water Tower Project were not reported on the P&E report, resulting in an understatement of $58,809. The lack of internal controls was systemic 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). . . ." Compliance and Reporting Guidance, State and Local Fiscal Recovery Funds, page 13, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." INDIANA STATE BOARD OF ACCOUNTS 18 TOWN OF RIDGEVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary periodic reports providing detailed accounting of the uses of funds, . . ." Cause Since the Clerk-Treasurer was in her first few months in office when the P&E report was prepared and submitted, she was inexperienced with reporting the Town's grant expenditure information. Internal controls established were not followed by management of the Town to ensure the Town provided the Treasury with complete and accurate information related to the SLFRF awards. Effect Without proper execution of internal controls, the P&E report that was submitted included the errors identified in the Condition and Context. The SLFRF reporting requirements were not met, which increases the likelihood that the public will not have access to transparent and accurate information regarding expenditures of federal awards. The lack of proper reporting could result in the Town not receiving future federal fundings or reduction in current federal funding. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the Town develop policies and procedures to ensure the accurate reporting of expenditures in the correct reporting period for each report submitted to provide the Treasury with complete and accurate information. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-004 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Procurement and 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): SWIF224568 Pass-Through Entity: Indiana Finance Authority Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion Condition and Context As part of sound management of the federal award, the Town was responsible for implementing a system of internal controls that would ensure compliance with the applicable requirements. The Town had not properly designed or implemented such a system, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 19 TOWN OF RIDGEVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Procurement 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 customarily set at $250,000. However, Indiana Code 5-22-8 has a more restrictive threshold of $150,000 or less for when small purchase procedures may be used. This informal process allows for methods other than the formal bid process. The informal process is divided between two methods based on thresholds: micro-purchases, 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. One vendor was identified that fell within the small purchase threshold. Purchases from the vendor totaled $38,225. As such, price or rate quotations from an adequate number of qualified sources should have been obtained. However, the Town did not obtain price or rate quotations for the purchases, nor was full and open competition provided for the vendor. Additionally, there was no documentation available to support the rationale to limit competition. Suspension and Debarment Prior to entering into subawards and covered transactions with the COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (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 adding a clause or condition to the covered transaction with that person. The Town did not have policies or procedures in place for verifying that an entity with which it planned to enter into a covered transaction was not suspended, debarred, or otherwise excluded. Two of the three vendors selected for testing, with covered transactions, were not verified to ensure that the vendor was not suspended, debarred, or otherwise excluded. 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 20 TOWN OF RIDGEVILLE 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. . . ." 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 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 The Town did not have policies or procedures in place to document the process performed to ensure each vendor related to the SLFRF program was not suspended or debarred from participation in federal awards. The Town was not aware of the requirements for specific federal procurement policies or the need to verify covered transactions for suspension and debarment. Effect Without the proper implementation of an effectively designed system of internal controls and procedures, the Town could not ensure the vendors paid with federal funds were eligible to participate in federal programs. Any program funds the Town used to pay vendors that have been suspended or debarred would be unallowable and the funding agency could potentially recover the funds. Questioned Costs No questioned costs noted. INDIANA STATE BOARD OF ACCOUNTS 21 TOWN OF RIDGEVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended the Town implement procurement policies to ensure compliance with state and federal laws and regulations for procuring goods and services paid with federal funds. We also recommended that management of the Town adopt internal controls to ensure that all contractors that are expected to be paid $25,000 or more, all or in part with federal funds, are not suspended or debarred from participating in federal programs before entering into covered transactions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-005 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 Findings: Material Weakness, Modified Opinion Condition and Context The County elected to receive the standard revenue loss allowance, allowing it to claim a total COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (SLFRF) allocation of $2,054,458 as revenue loss to use for government services. As such, all SLFRF program funds expended from January 1, 2024 to December 31, 2024, were 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 as there is no federal program or purpose to carry out in the case of the revenue loss portion of the award. Recipients are required to submit quarterly or annually Project and Expenditure (P&E) reports to the Treasury. The reporting periods, as well as the respective due dates, are based on the type of recipient and the recipient's 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 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. INDIANA STATE BOARD OF ACCOUNTS 22 CRAWFORD COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The County submitted the P&E report by April 30, 2024, as required during the audit period. Although one employee prepared the P&E report and another reviewed the entries, the system of internal controls was not effective in preventing, detecting, or correcting errors. The data submitted included amounts which were not supported by the County's records. For the 2024 annual P&E report, current and cumulative obligations and expenditures were each overstated by $311,286. The County did not accurately report the breakdown of obligations by project in its P&E report. While project-specific financial data was available in the County's internal ledger, it was not transferred or summarized in a way that met the annual reporting requirements. The lack of effective 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). . . ." Compliance and Reporting Guidance, State and Local Fiscal Recovery Funds, page 13, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary periodic reports providing detailed accounting of the uses of funds, . . ." Cause Management's actions contributed to the noncompliance. The financial figures were modified to bypass submission system error messages, a process not supported by the County's records. Additionally, management misinterpreted reporting requirements, incorrectly assuming a project-level breakdown was not necessary for revenue replacement funds. INDIANA STATE BOARD OF ACCOUNTS 23 CRAWFORD COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 such, the County did not report current and cumulative obligations and expenditures properly when filing the P&E report for the period April 1, 2023 to March 31, 2024. 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. In addition, not meeting the SLFRF reporting requirements by reporting erroneous data increases the likelihood that the public and the Treasury will not have access to transparent and accurate information regarding expenditures of federal awards. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the 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 take 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 2024-003 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): CY2022 Compliance Requirement: Reporting 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 2023-003. INDIANA STATE BOARD OF ACCOUNTS 18 CLINTON COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 on the type of recipient and the recipient's 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 COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (SLFRF). As such, the P&E report, covering the period from April 1, 2023 to March 31, 2024, was required to be submitted to the Treasury by April 30, 2024. The County submitted one P&E report during the audit period, which was obtained from the Treasury's website. Although one employee prepared the P&E report and another reviewed the entries, the system of internal controls was not effective in preventing, detecting, or correcting errors. The information submitted included amounts based on the incorrect period, amounts that should have been omitted, and amounts which were based on budgeted amounts instead of actual amounts, as such, the reports were not fairly presented. Errors identified included the following: • Total Cumulative Expenditures were overstated by $3,174,098. • Total Current Expenditures were understated by $616,514. • Total Current Obligations were overstated by $1,825,902. Additionally, the County was unable to provide documentation to substantiate the amount obligated to one vendor used for the Government Services project. 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 19 CLINTON COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary or her delegate, as applicable, periodic reports providing detailed accounting of the uses of funds, modifications to a State or Territory's tax revenue sources, and such other information as the Secretary or her delegate, as applicable, may require for the administration of this section. In addition to regular reporting requirements, the Secretary may request other additional information as may be necessary or appropriate, including as may be necessary to prevent evasions of the requirements of this subpart. False statements or claims made to the Secretary may result in criminal, civil, or administrative sanctions, including fines, imprisonment, civil damages and penalties, debarment from participating in Federal awards or contracts, and/or any other remedy available by law." Cause Although a system of internal controls over the P&E report was designed by management, which included segregation of duties, it did not ensure that 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 statements of what should be done to affect internal controls, 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. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal awards could result in the loss of future federal funding to the County. In addition, not meeting the SLFRF reporting requirements increases the likelihood that the public will not have access to transparent and accurate information regarding expenditures of federal awards. Questioned Costs There were no questioned costs identified. INDIANA STATE BOARD OF ACCOUNTS 20 CLINTON COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended that management of the County design and implement a proper system of internal controls that would ensure appropriate reviews, approvals, 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 the P&E report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. INDIANA STATE BOARD OF ACCOUNTS 21
FINDING 2024-003 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 Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): FY2024 Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context Recipients of COVID-19 - State and Local Fiscal Recovery Funds (SLFRF) grants 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 Town was classified as a Tier 5 auditee - a metropolitan city with a population below 250,000 residents which received less than $10 million in SLFRF funding. Tier 5 auditees are required to submit an annual P&E report due in April of each year. The Town was required to file an annual P&E report on April 30, 2024. The report was to cover the period of April 1, 2023 to March 31, 2024. The Town presented this report for audit; however, there were no documented internal controls in place over the Reporting compliance requirement. The report was prepared and submitted by the Director of Finance and Records without documented oversight or review. The lack of internal controls resulted in material errors made on the report, including an overstatement in Cumulative Expenditures and Cumulative Obligations. 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). . . ." Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary or her delegate, as applicable, periodic reports providing detailed accounting of the uses of funds, modifications to a State or Territory's tax revenue sources, and such other information as the Secretary or her delegate, as applicable, may require for the administration of this section. In addition to regular reporting requirements, the Secretary may request other additional information as may be necessary or appropriate, including as may be necessary to prevent evasions of the requirements of this subpart. False statements or claims made to the Secretary may result in criminal, civil, or administrative sanctions, including fines, imprisonment, civil damages and penalties, debarment from participating in Federal awards or contracts, and/or any other remedy available by law." Cause A proper system of internal controls over the P&E reports was not designed by management of the Town. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the Town's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. The Town had a systemic lack of internal controls, which resulted in the lack of internal controls over the annual P&E report. 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. 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 Town. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the Town's management design and implement a proper system of internal controls, including policies and procedures to ensure that the Town provides the Treasury with complete and accurate information for the P&E report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.