2025-001 U.S. Department of the Treasury Direct Award and Passed through Bristol County, Massachusetts COVID-19 – Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 Significant Deficiency in Internal Controls over Compliance and Compliance Finding Criteria: The compliance supplement identifies four Key Line Items required to be reported to the federal awarding agency which include (1) current period obligation, (2) cumulative obligation, (3) current period expenditure and (4) cumulative expenditure. Per 2 CFR 200.1, an obligation is an order placed for property and services, contracts and subawards made, and similar transactions that require payment. Condition: Expenditures were not reconciled to the general ledger for reporting submitted to the U.S. Department of the Treasury and Bristol County, Massachusetts. Cause: The Town did not have procedures in place to perform reconciliations of required grant reporting. Effect: The Town potentially overstated expenditures by approximately $528,000 and $127,000 in reporting submitted to the U.S. Department of the Treasury and Bristol County, Massachusetts, respectively. Questioned Costs: None Repeat Finding from Prior Year: No Recommendation: The Town should implement procedures to reconcile all federal reporting to the general ledger. Views of Responsible Official: Management agrees with the finding.
2025-001 U.S. Department of the Treasury Direct Award and Passed through Bristol County, Massachusetts COVID-19 – Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 Significant Deficiency in Internal Controls over Compliance and Compliance Finding Criteria: The compliance supplement identifies four Key Line Items required to be reported to the federal awarding agency which include (1) current period obligation, (2) cumulative obligation, (3) current period expenditure and (4) cumulative expenditure. Per 2 CFR 200.1, an obligation is an order placed for property and services, contracts and subawards made, and similar transactions that require payment. Condition: Expenditures were not reconciled to the general ledger for reporting submitted to the U.S. Department of the Treasury. Cause: The Town did not have procedures in place to perform reconciliations of required grant reporting. Effect: The Town potentially overstated expenditures by approximately $336,000 in reporting submitted to the U.S. Department of the Treasury. Questioned Costs: None Repeat Finding from Prior Year: No Recommendation: The Town should implement procedures to reconcile all federal reporting to the general ledger. Views of Responsible Official: Management agrees with the finding.
Equipment means tangible personal property, including information technology systems, having a useful life of more than one year and a per-unit acquisition cost which equals or exceeds the lesser of the capitalization level established by the non-Federal entity for financial statement purposes or $5,000 (2 CFR 200.1_Equipment). Title to equipment acquired by a non-Federal entity under grants and cooperative agreements vests in the non-Federal entity subject to certain obligations and conditions (2 CFR 200.313(a)). Non-Federal Entities Other than States Non-Federal entities other than States must follow 2 CFR 200.313(c) through (e) which require that: 1. Equipment, including replacement equipment, be used in the program or project for which it was acquired as long as needed, whether or not the project or program continues to be supported by the Federal award or, when appropriate, under other Federal awards; however, the non-Federal entity must not encumber the equipment without prior approval of the Federal awarding agency (2 CFR 200.313(c) and (e)). 2. Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the Federal award identification number), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property (2 CFR 200.313(d)(1)). 3. A physical inventory of the property must be taken and the results reconciled with the property records at least once every 2 years (2 CFR 200.313(d)(2)). 4. A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated (2 CFR 200.313(d)(3)). 5. Adequate maintenance procedures must be developed to keep the property in good condition (2 CFR 200.313(d)(4)). 6. If the non-Federal entity is authorized or required to sell the property, proper sales procedures must be established to ensure the highest possible return (2 CFR 200.313(d)(5)). 7. When original or replacement equipment acquired under a Federal award is no longer needed for a Federal program (whether the original project or program or other activities currently or previously supported by the Federal government), the non-Federal entity must request disposition instructions from the Federal awarding agency if required by the terms and conditions of the award. Items of equipment with a current per-unit fair market value of $5,000 or less may be retained, sold, or otherwise disposed of with no further obligation to the Federal awarding agency. If the Federal awarding agency fails to provide requested disposition instructions within 120 days, items of equipment with a current per-unit fair market value in excess of $5,000 may be retained or sold. The Federal awarding agency is entitled to the Federal interest in the equipment, which is the amount calculated by multiplying the current market value or sale proceeds by the Federal agency’s participation in total project costs (2 CFR 200.313(e)). While testing equipment acquisitions acquired using ESSER funds, one instance was noted in which equipment purchased was not fully added to the District records. Without proper controls over equipment requirements, there is an increased risk that the District is not in compliance with applicable federal regulations. Additionally, noncompliance could result in federal funding being reduced or taken away, or other sanctions imposed by the federal grantor agency. The District should establish (or perform existing) controls to include the required clauses of 2 CFR 200.313 to ensure equipment is being properly safeguarded and tracked.
Finding Number: 2025-001 Program: Community Development Block Grant (CDBG) ALN #: 14.218 Pass-through Entity: N/A- Direct Award Federal Agency: Department of Housing and Urban Development Federal Award Year: July 1, 2024–June 30, 2025 Compliance Requirement: Performance Reporting Type of finding: Material weakness and noncompliance Criteria Special Reporting for Federal Funding Accountability and Transparency Act Under the requirements of the Federal Funding Accountability and Transparency Act (FFATA) (Pub. L. No.109-282), as amended by Section 6202 of Public Law 110-252, herein referred to as the “Transparency Act” that are codified in 2 CFR Part 170, recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). Aspects of the Transparency Act that relate to subaward reporting (1) under grants and cooperative agreements were implemented in OMB in 2 CFR Part 170 and (2) under contracts, by the regulatory agencies responsible for the Federal Acquisition Regulation (FAR at 5 FR 39414 et seq., July 8, 2010). The requirements pertain to recipients (i.e., direct recipients) of grants or cooperative agreements who make first-tier subawards and contractors (i.e., prime contractors) that award first-tier subcontracts. Title 2 US Code of Federal Regulations Part 200 (2 CFR 200), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, section 200.1 defines subaward as an award provided by a pass-through entity to a subrecipient for the subrecipient to carry out part of a federal award received by the pass-through entity. It does not include payments to a contractor or payments to an individual that is a beneficiary of a federal program. A subaward may be provided through any form of legal agreement, including an agreement that the pass-through entity considers a contract. Further, 2 CFR 200.1 defines subrecipient as a nonfederal entity that receives a subaward from a passthrough entity to carry out part of a federal program but does not include an individual that is a beneficiary of such program. A subrecipient may also be a recipient of other federal awards directly from a federal awarding agency. Lastly, 2 CFR 200.303(a) states, the nonfederal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the nonfederal 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). Condition The City’s Community Development Department (CDBG) did not report awards granted to subrecipients for the CDBG program by the end of the month following the month in which the City awarded the subrecipient award. FFATA requires the City to report certain identifying information related to awards made to subrecipients in amounts greater than or equal to $30,000. Of the information to be reported, the following key data elements are required to be audited: 1. Subawardee name 2. Subawardee DUNS/UEI number 3. Amount of subaward 4. Subaward obligation/action date 5. Date of report submission 6. Subaward number 7. Subaward project description 8. Subawardee names and compensation of highly compensated officers During our testing, we noted that the City did not establish control procedures to submit FFATA reports for all subawards as required by federal regulations. Cause The condition found was due to the City not reporting amounts passed through to subrecipients for the period from July 2024 to June 2025 within the required time after the award is granted to the subrecipient. Proper perspective During our testing of the three selected subawards, we noted reporting exceptions as subawards were not reported within the one month following the month that the City awarded the subrecipient contract. Additionally, there was a control exception to ensure that the data submitted is complete and accurate.Possible asserted effect Failure to submit subaward amounts passed through to subrecipients and subcontractors under subawards as defined by 2 CFR 200.1 in the City’s FFATA reporting could result in the City reporting inaccurate and incomplete amounts to the federal government. Questioned costs None noted Statistical sampling The sample was not intended to be, and was not, a statistically valid sample. Repeat finding Yes, 2024-002 Recommendation We recommend that the City continue to review and enhance their policies, procedures, and internal controls to ensure that all amounts passed through to subrecipients under subawards, as defined in 2 CFR 200.1 are reported in accordance with the FFATA federal regulations. In addition, we recommend that the City use obligation date for FFATA reporting. Views of responsible officials and corrective actions The City will continue strengthening its policies, procedures, and internal controls to ensure all subawards are reported in full compliance with FFATA. The City reported subawards using the subaward obligation date, which is the date the agreement is fully executed, rather than the July 1 performance start date. As a result, obligation dates varied depending on when each agreement is signed.
Finding Number: 2025-003 Program: Housing Opportunities for Persons with AIDS (HOPWA) ALN #: 14.241 Pass-through Entity: N/A- Direct Award Federal Agency: Department of Housing and Urban Development Federal Award Year: July 1, 2024–June 30, 2025 Compliance Requirement: Reporting Type of finding: Material weakness and noncompliance Criteria Special Reporting for Federal Funding Accountability and Transparency Act Under the requirements of the Federal Funding Accountability and Transparency Act (FFATA) (Pub. L. No.109-282), as amended by Section 6202 of Public Law 110-252, herein referred to as the “Transparency Act” that are codified in 2 CFR Part 170, recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). Aspects of the Transparency Act that relate to subaward reporting (1) under grants and cooperative agreements were implemented in OMB in 2 CFR Part 170 and (2) under contracts, by the regulatory agencies responsible for the Federal Acquisition Regulation (FAR at 5 FR 39414 et seq., July 8, 2010). The requirements pertain to recipients (i.e., direct recipients) of grants or cooperative agreements who make first-tier subawards and contractors (i.e., prime contractors) that award first-tier subcontracts. Title 2 US Code of Federal Regulations Part 200 (2 CFR 200), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, section 200.1 defines subaward as an award provided by a pass-through entity to a subrecipient for the subrecipient to carry out part of a federal award received by the pass-through entity. It does not include payments to a contractor or payments to an individual that is a beneficiary of a federal program. A subaward may be provided through any form of legal agreement, including an agreement that the pass-through entity considers a contract. Further, 2 CFR 200.1 defines subrecipient as a nonfederal entity that receives a subaward from a passthrough entity to carry out part of a federal program but does not include an individual that is a beneficiary of such program. A subrecipient may also be a recipient of other federal awards directly from a federal awarding agency. Lastly, 2 CFR 200.303(a) states, the nonfederal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the nonfederal 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). Condition The City’s Community Development Department did not report awards granted to subrecipients for the HOPWA program by the end of the month following the month in which the City awarded the subrecipient award. FFATA requires the City to report certain identifying information related to awards made to subrecipients in amounts greater than or equal to $30,000. Of the information to be reported, the following key data elements are required to be audited: 1. Subawardee name 2. Subawardee DUNS/UEI number 3. Amount of subaward 4. Subaward obligation/action date 5. Date of report submission 6. Subaward number 7. Subaward project description 8. Subawardee names and compensation of highly compensated officers During our testing, we noted that the City did not establish control procedures to submit FFATA reports for all subawards as required by federal regulations. Cause The condition found was due to the City not reporting amounts passed through to subrecipients for the period from July 2024 to June 2025 within the required time after the award is granted to the subrecipient. Proper perspective During our testing of four selected subawards, we noted reporting exceptions as subawards were not reported within the one month following the month that the City awarded the subrecipient contract. Additionally, there was a control exception to ensure that the data submitted is complete and accurate. Possible asserted effect Failure to submit subaward amounts passed through to subrecipients and subcontractors under subawards as defined by 2 CFR 200.1 in the City’s FFATA reporting could result in the City reporting inaccurate and incomplete amounts to the federal government. Questioned costs None Statistical sampling The sample was not intended to be, and was not, a statistically valid sample. Repeat finding Yes, 2024-004 Recommendation We recommend that the City continue to review and enhance their policies, procedures, and internal controls to ensure that all amounts passed through to subrecipients under subawards, as defined in 2 CFR 200.1 are reported in accordance with the FFATA federal regulations. In addition, we recommend that the City use obligation date for FFATA reporting. Views of responsible officials and corrective actions The City will continue strengthening its policies, procedures, and internal controls to ensure all subawards are reported in full compliance with FFATA. The City reported subawards using the subaward obligation date, which is the date the agreement is fully executed, rather than the July 1 performance start date. As a result, obligation dates var depending on when each agreement is signed.
Finding No. 2025-047 Prior Year Finding: 2024-053 Federal Awarding Agency: U.S. Department of Agriculture (USDA) Impact: Material Weakness, Material Noncompliance AL Number and Title: 10.551, 10.561 Supplemental Nutrition Assistance Program (SNAP) Cluster Federal Award Number: 25AK35050292301, 24AK35050292301 Applicable Compliance Requirement: Allowable Costs/Cost Principles, Special Tests and Provisions Condition: The amount of FY 25 SNAP benefits reported to USDA as issued by the State’s Electronic Benefits Transfer (EBT) contractor, Fidelity National Information Services (FIS), was $1,235,577 more than the amount of authorized benefits reported in data from the Division of Public Assistance’s (DPA) Eligibility Information System (EIS). Furthermore, FIS could not provide a reliable audit trail of issuances. Context: DPA relies on its legacy eligibility system, EIS, to determine eligibility for SNAP and calculate monthly benefit amounts. Benefit amounts are calculated based on household size, income, and other financial resources of all qualifying members of a household, less specific allowable deductions. Each day EIS transmits an issuance batch file, including authorized beneficiaries and benefit amounts, to the State’s EBT contractor, FIS, which maintains accounts for each beneficiary. When an EBT card is utilized by a beneficiary, FIS functions as the intermediary between the State’s U.S. Treasury benefit account and the retailers by settling SNAP benefit transactions with retailers before drawing down federal reimbursement. The State is required to ensure its automated data processing systems accurately and completely process and store all case file information for eligibility determinations and benefit calculations, and provide the data necessary to meet federal issuance and reconciliation reporting requirements. A reconciliation of FIS issuance records with EIS authorized beneficiaries and benefit amounts demonstrates the completeness and accuracy of the EBT process. In FY 25, the EIS benefit data provided by DPA could not be reconciled to the amount of SNAP benefits issued per FIS data or the issuance amounts reported by DPA to USDA. Furthermore, FIS could not provide a detailed list of issuances to support the monthly amounts reconciled by DPA staff and reported to USDA. Cause: DPA management and FIS staff could not identify the cause of the variances. DPA’s outdated legacy eligibility system and the lack of daily reconciliations (see Finding No. 2025-049) contributed to the deficiencies. Criteria: Title 7 CFR 274.1(h) requires that the State agency create and maintain a master issuance file that consolidates records of all certified SNAP households, record participation activity for each household, and supply all information necessary to fulfill the reporting requirements outlined in Title 7 CFR 274.4. Title 7 CFR 274.4(a) requires the State to reconcile benefits posted to household accounts on the central computer against benefits on the issuance authorization file. Title 2 CFR 200.303(a) requires the State to establish and maintain effective internal controls over federal awards that provide reasonable assurance that the State is managing federal awards in compliance with federal statutes, regulations, and the terms and conditions of the grant awards. Effect: Significant discrepancies between EIS benefit data and the EBT contractor’s issuance records undermine confidence in the eligibility system and may be indicative of significant unidentified processing errors. Inadequate system controls increase the risk of incorrect or ineligible benefits. Questioned Costs: AL 10.551: $1,235,577 Recommendation: DPA’s director should identify the cause of the discrepancies between EBT contractor issuance data and the State’s eligibility system and take action necessary to ensure SNAP benefit payments are supported by eligibility and benefit data. Views of Responsible Officials: The department agrees with the finding but does not concur with the questioned costs. The Division of Public Assistance completes reconciliations between FIS daily transaction records and EBT Account Management Agent (AMA) data to ensure issuance accuracy. Auditor’s Concluding Remarks: Management concurs with the finding, but not the questioned costs. Questioned costs are defined by Title 2 CFR 200.1, which states: Questioned cost means a cost that is questioned by the auditor because of an audit finding: Which resulted from a violation or possible violation of a statute, regulation, or the terms and conditions of a federal award, including for funds used to match federal funds; Where the costs, at the time of the audit, are not supported by adequate documentation; or Where the costs incurred appear unreasonable and do not reflect the actions a prudent person would take in the circumstances. Based on Uniform Guidance, the SNAP benefits issued that were not supported by eligibility determinations were reported as questioned costs.
Finding No. 2025-032 Prior Audit Finding: 2024-038 Federal Awarding Agency: USDHS Impact: Material Weakness, Material Noncompliance AL Number and Title: 97.036 Disaster Grants Federal Award Number: 4413DRAKP00000001 Applicable Compliance Requirement: Subrecipient Monitoring Condition: DMVA management did not issue a management decision for a finding relating to one Disaster Grants subrecipient’s single audit. Context: Under federal regulations, pass-through entities are responsible for issuing a management decision for audit findings relating to federal awards provided to subrecipients. The management decisions must clearly state whether or not the audit finding is substantiated, the reason for the decision, and the adequacy of the recipient’s proposed corrective actions to address the findings. If the subrecipient has not completed corrective action, a timetable for follow-up should be given. One Disaster Grants subrecipients single audit contained a finding and DMVA management did not issue a management decision. The finding related to a subrecipient lacking evidence that a secondary review was conducted by an individual other than the preparer for required reports. Cause: DMVA had controls to ensure a management decision was issued on a subrecipient's single audit finding. However, DMVA’s procedures were insufficient to identify subrecipient’s findings requiring follow-up. DMVA staff stated that information reported on the Summary of Items for Follow-up document, provided by the Department of Administration, Division of Finance, did not specify that DMVA should follow up on the finding; therefore, no management decision was issued. However, the audit determined DMVA misinterpreted the information provided by the Division of Finance. Criteria: Title 2 CFR 200.521 requires the State to issue a management decision for audit findings that affect subawards it issues to subrecipients under a federal award. Title 2 CFR 200.1 defines a management decision as a pass-through entity’s written determination, provided to the auditee, of the adequacy of the auditee’s proposed corrective actions to address the findings, based on its evaluation of the audit findings and proposed corrective actions. Title 2 CFR 200.303(a) requires the State to establish and maintain effective internal control over the federal award that provides reasonable assurance that the State is managing the federal awards in compliance with federal statutes, regulations, and terms and conditions of the grant awards. Effect: The lack of a management decision may result in a subrecipient not taking appropriate corrective action on findings. Noncompliance with federal regulations may result in the federal awarding agency imposing additional conditions or taking corrective action, including additional reporting requirements or withholding/terminating funding. Questioned Costs: None Recommendation: DMVA’s DAS director should strengthen procedures to ensure findings requiring follow-up are identified and management decisions are issued within six months of a subrecipient audit report’s acceptance by the federal audit clearinghouse. Views of Responsible Officials: Management agrees with this finding.
Condition: During our test of the annual expenditure report filed by the County for compliance with grant reporting requirements, it was noted that the report listed inaccurate information regarding the actual expenditures. The annual report listed the expenditures totaling $2,680,335; however, the confirmed amount on the financial statement and SEFA indicated the actual expenditures were $2,813,954 resulting in an understatement of $133,619. Cause of Condition: Policies and procedures have not been designed and implemented to ensure compliance with federal grant requirements. Effect of Condition: This condition resulted in noncompliance with federal grant requirements for this program and could result in loss of federal funds to the County. Recommendation: OSAI recommends the County gain an understanding of the compliance requirements for federal programs to ensure compliance with the grant requirements and filing accurate quarterly reports. Management Response: Chairman of the Board of County Commissioners and County Clerk: The Creek County Clerk's Office will work with the SEFA preparer to ensure that the correct paid dates are being used when reporting. This should eliminate the actual expenditures differences. We will work to educate all offices involved in the reporting process on financial statement and SEFA. Criteria: Title 2 CFR § 200.303(a) Internal Controls reads (a) reads as follows: 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. 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 Controls Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Compliance and Reporting Guidance, State and Local Fiscal Recovery Funds (10. Reporting.) reads as follows: 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. In addition, where appropriate, your organization needs to establish controls to ensure completion and timely submission of all mandatory performance and/or compliance reporting.
Finding 2025-013 – Noncompliance with Reporting Over Major Federal Program - Coronavirus State and Local Fiscal Recovery Funds (Repeat Finding – 2023-013, 2024-013) PASS-THROUGH GRANTOR: Direct Grant FEDERAL AGENCY: U.S. Department of Treasury ASSISTANCE LISTING: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds FEDERAL AWARD YEAR: 2021 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $-0- Condition: During the test of 100% of expenditures for the Coronavirus State and Local Fiscal Recovery Funds, totaling $5,176,520, thirty (32) expenditures totaling $2,780,668, were not accurately reported in the proper period on the quarterly reports, and two expenditures to subrecipients totaling $121,362, were improperly classified as “Revenue Replacement” expense instead of using the “Infrastructure” expense category as required by the Reporting compliance requirement. Cause of Condition: Policies and procedures have not been designed and implemented to ensure federal expenditures are made in accordance with federal compliance requirements. Effect of Condition: This condition resulted in noncompliance with grant requirements. Recommendation: OSAI recommends the County design and implement a system of internal controls to ensure the accuracy and completeness of reports and to ensure compliance with federal requirements. Management Response: Chairman of the Board of County Commissioners: The Board of County Commissioners will take measures to ensure future compliance with all requirements of federal grants. Criteria: Accountability and stewardship should be overall goals in management’s accounting of federal funds. Internal controls should be designed to monitor compliance with laws and regulations pertaining to grant contracts. Title 2 CFR § 200.303(a) Internal Controls reads (a) reads as follows: 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. 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 Controls Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Compliance and Reporting Guidance, State and Local Fiscal Recovery Funds (10. Reporting.) reads as follows: 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. In addition, where appropriate, your organization needs to establish controls to ensure completion and timely submission of all mandatory performance and/or compliance reporting. Further, 2 CFR § 200.329 Monitoring and Reporting Program Performance (c)(1) reads as follows The non-Federal entity must submit performance reports at the interval required by the Federal awarding agency or pass-through entity to best inform improvements in program outcomes and productivity. Intervals must be no less frequent than annually nor more frequent than quarterly except in unusual circumstances, for example where more frequent reporting is necessary for the effective monitoring of the Federal award or could significantly affect program outcomes. Reports submitted annually by the non-Federal entity and/or pass-through entity must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. Alternatively, the Federal awarding agency or pass-through entity may require annual reports before the anniversary dates of multiple year Federal awards. The final performance report submitted by the non-Federal entity and/or pass-through entity must be due no later than 120 calendar days after the period of performance end date. A subrecipient must submit to the pass-through entity, no later than 90 calendar days after the period of performance end date, all final performance reports as required by the terms and conditions of the Federal award. See also § 200.344. If a justified request is submitted by a non-Federal entity, the Federal agency may extend the due date for any performance report.
Finding 2025-014 – Noncompliance with Reporting Over Major Federal Program – Coronavirus State and Local Fiscal Recovery Funds (Repeat Finding – 2022-014, 2023-014, 2024-014) PASS-THROUGH GRANTOR: Direct Grant FEDERAL AGENCY: U.S. Department of Treasury ASSISTANCE LISTING: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds FEDERAL AWARD YEAR: 2021 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $0 Condition: During the test of sixty-five (65) expenditures for the Coronavirus State and Local Fiscal Recovery Funds, totaling $4,254,839, seventeen (17) expenditures, totaling $1,280,024, were not accurately reported in the proper period on the quarterly reports as required by the program. Cause of Condition: Policies and procedures have not been designed and implemented to ensure federal expenditures are properly reported in accordance with federal compliance requirements. Effect of Condition: This condition resulted in noncompliance with grant requirements. Recommendation: OSAI recommends the County design and implement a system of internal controls to ensure the accuracy and completeness of reports and to ensure compliance with federal requirements. Management Response: Chairman of the Board of County Commissioners: The Board of County Commissioners have hired a grant administrator to assist with the reporting process. We will ensure that the reports are accurate and reported in the proper period. Criteria: GAO Standards – Section 2 – Establishing an Effective Internal Control System – OV2.23 states in part: Objectives of an Entity – Compliance Objectives Management conducts activities in accordance with applicable laws and regulations. As part of specifying compliance objectives, the entity determines which laws and regulations apply to the entity. Management is expected to set objectives that incorporate these requirements. Title 2 CFR § 200.303(a) Internal Controls reads (a) reads as follows: 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. 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). Additionally, Compliance and Reporting Guidance, State and Local Fiscal Recovery Funds (10. Reporting.) reads as follows: 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. In addition, where appropriate, your organization needs to establish controls to ensure completion and timely submission of all mandatory performance and/or compliance reporting. See Part 2 of this guidance for a full overview of recipient reporting responsibilities. Further, 2 CFR § 200.329 Monitoring and Reporting Program Performance (c)(1) reads as follows: The non-Federal entity must submit performance reports at the interval required by the Federal awarding agency or pass-through entity to best inform improvements in program outcomes and productivity. Intervals must be no less frequent than annually nor more frequent than quarterly except in unusual circumstances, for example where more frequent reporting is necessary for the effective monitoring of the Federal award or could significantly affect program outcomes. Reports submitted annually by the non-Federal entity and/or pass-through entity must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. Alternatively, the Federal awarding agency or pass-through entity may require annual reports before the anniversary dates of multiple year Federal awards. The final performance report submitted by the non-Federal entity and/or pass-through entity must be due no later than 120 calendar days after the period of performance end date. A subrecipient must submit to the pass-through entity, no later than 90 calendar days after the period of performance end date, all final performance reports as required by the terms and conditions of the Federal award. See also § 200.344. If a justified request is submitted by a non-Federal entity, the Federal agency may extend the due date for any performance report.
FINDING 2025-003 Subject: Special Education Cluster (IDEA) - Procurement and Suspension and Debarment Federal Agency: Department of Education Federal Program: Special Education Grants to States Assistance Listings Number: 84.027 Federal Award Numbers and Years (or Other identifying Numbers): 22611-133-PN01, 23611-133-PN01, 24611-133-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion INDIANA STATE BOARD OF ACCOUNTS 19 LEWIS CASS SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The internal control system in place at the School Corporation was not effective in ensuring compliance with requirements related to the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement - Small Purchases Federal regulations allow for informal procurement methods when the value of the procurement for property or services does not exceed the simplified acquisition threshold, which is set at $250,000 unless a lower, more restrictive threshold is set by a nonfederal entity. As Indiana Code has set a more restrictive threshold of $150,000, the informal procurement method is permitted when the value of the procurement does not exceed $150,000. 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. A total of two vendors were determined to require small purchase procedures, totaling $123,078. For the two vendors tested, the School Corporation did not obtain price or rate quotations. Additionally, documentation detailing the history of procurement, which must include the reason for the procurement method used, was absent for those two vendors. 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 System for Award Management (SAM) Excluded Parties List System (EPLS), collecting a certification from that person or entity, or adding a clause or condition to the covered transaction with that person or entity. A population of two covered transactions for goods or services totaling $123,078, both of which equaled or exceeded the $25,000 threshold paid from the special education funds during the audit period, were identified and selected for testing. For both transactions, the School Corporation did not verify that the vendor was not suspended, debarred, or otherwise excluded from or eligible for participation in federal assistance programs or activities prior to issuing payment. 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: INDIANA STATE BOARD OF ACCOUNTS 20 LEWIS CASS SCHOOLS 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 awards 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.214 states: "Non-Federal entities are subject to the non-procurement debarment and suspension regulations implementing Executive Orders 12549 and 12689, 2 CFR part 180. The regulations in 2 CFR part 180 restrict awards, subawards, and contracts with certain parties that are debarred, suspended, or otherwise excluded from or ineligible for participation in Federal assistance programs or activities." 2 CFR 200.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 School Corporation did not have adequate internal controls to ensure compliance with procurement and suspension and debarment requirements. Effect The lack of an effective internal control system enabled material noncompliance to occur and remain undetected. Noncompliance with the Procurement and Suspension and Debarment compliance requirement could enable small purchases made by the School Corporation to be uncompetitive and could lead to contracting with vendors who are suspended or debarred from receiving federal grant funding. INDIANA STATE BOARD OF ACCOUNTS 21 LEWIS CASS SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the management of the School Corporation develop policies and procedures to ensure there are appropriate procurement procedures for goods and services and contractors and subrecipients, as appropriate, are verified to not be suspended, debarred, or otherwise excluded prior to entering into any contracts or subawards. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING REFERENCE NUMBER 2025-004 FEDERAL PROGRAMS (ALN – 10.553) SCHOOL BREAKFAST PROGRAM (SBP) – CHILD NUTRITION CLUSTER (ALN – 10.555) NATIONAL SCHOOL LUNCH PROGRAM (NSLP) – CHILD NUTRITION CLUSTER (ALN – 10.559) SUMMER FOOD SERVICE PROGRAM FOR CHILDREN (SFSP) – CHILD NUTRITION CLUSTER (ALN – 10.582) FRESH FRUIT AND VEGETABLE PROGRAM (FFVP) – CHILD NUTRITION CLUSTER U.S. DEPARTMENT OF AGRICULTURE (ALN – 84.010A) TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES (TITLE I, PART A OF THE ESSEA) (ALN – 84.027) SPECIAL EDUCATION – GRANTS TO STATES (IDEA, PART B) (ALN – 84.425D) COVID-19 EDUCATION STABILIZATION FUND: ELEMENTARY AND SECONDARY SCHOOL EMERGENCY RELIEF FUND (ALN – 84.425U) COVID-19 EDUCATION STABILIZATION FUND: AMERICAN RESCUE PLAN – ELEMENTARY AND SECONDARY SCHOOL EMERGENCY RELIEF (ARP ESSER) U.S. DEPARTMENT OF EDUCATION AWARD NUMBERS 1PRAEA18SCESUBA (10/01/2017 – 09/30/2018); 1PRAEA19SCESUBA (10/01/2018 – 09/30/2019); 1PRAEA20SCESUBA (10/01/2019 – 09/30/2020); 1PRAEA21SCESUBA (10/01/2020 – 09/30/2021); 1PRAEA22SCESUBA (10/01/2021 – 09/30/2022); 1PRAEA23SCESUBA (10/01/2022 – 09/30/2023); 1PRAEA24SCESUBA (10/01/2023 – 09/30/2024); 1PRAEA25SCESUBA (10/01/2024 – 09/30/2025); H027A1200003 (07/01/2020 – 09/30/2021); H027A2200003 (07/01/2022 – 09/30/2023); H027A2300003 (07/01/2023 – 09/30/2024); H027A2400003 (07/01/2024 – 09/30/2025); V048A180052 (07/01/2018 – 09/30/2019); S425D200029 (06/16/2020 – 09/30/2021); S425D210029 (01/05/2021 – 09/30/2022); S425U210029 (03/24/2021 – 09/30/2023) COMPLIANCE REQUIREMENT ACTIVITIES ALLOWED OR UNALLOWED // ALLOWABLE COSTS/COSTS PRINCIPLES TYPE OF FINDING INTERNAL CONTROL AND COMPLIANCE – MATERIAL WEAKNESS AND MATERIAL NONCOMPLIANCE CRITERIA 2 CFR Section 200.403 (g) establishes that except where otherwise authorized by statute, costs must be adequately documented in order to be allowable under Federal awards. In addition 2 CFR Section 200.1, defines improper payments as a payment that should not have been made or that was made in an incorrect amount under statutory, contractual, administrative, or other legally applicable requirements. The term improper payment includes any payment to an ineligible recipient, any payment for ineligible goods or service, any duplicate payment, any payment for a good or service not received (except for those payments where authorized by law), any payment that is not authorized by law, and any payment that does not account for credit for applicable discounts. STATEMENT OF CONDITION As part of our audit procedures and interviews over financial reporting, we obtained a detail of accounts receivable related to duplicate or incorrect payments made for payroll transactions in the amount of $3,756,580. Invoices issued during the fiscal year ended June 30, 2025, balance, were distributed as federal and state, as follows: Assistance Listing Number Program Description Transaction Balance 10.553/ 10.555/ 10.559/ 10.582 Child Nutrition Program Cluster $ 94,915 84.010A Title I Grants to Local Educational Agencies (Title I, Part A of the ESEA) 13,665 84.027 Special Education – Grants to States (IDEA, Part B) 33,798 84.425D COVID-19 Education Stabilization Fund: Elementary and Secondary School Emergency Relief Fund 43,252 84.425U COVID-19 Education Stabilization Fund: American Rescue Plan – Elementary and Secondary School Emergency Relief (ARP ESSER) 55,837 Subtotal 241,467 Not Determined Schoolwide Program (State and Federal Funds) 2,106,827 Not Determined Consolidated Funds (State and Federal Funds) 32,730 Not Applicable State Funds 1,375,556 Total Invoices Issued Balance at 06/30/2025 $ 3,756,580 QUESTIONED COSTS Identified questioned costs are $241,467, which were identified as employees that didn't work for the Federal program. Other amount may be unallowed, if the PRDE can identify the portion of Federal funding incurred in Schoolwide and Consolidated activities. PERSPECTIVE INFORMATION This is a systemic deficiency. The amount of $3,756,580, corresponds to incorrect payroll payments made from current and prior years, for which during fiscal year 2024-2025, the PRDE determined that an invoice for excess payroll payments proceeds. The PRDE was unable to indicate which amount of Schoolwide or Consolidated funds corresponds to Federal funding, because these funds close at year end. STATEMENT OF CAUSE The PRDE sends the Treasury Department of Puerto Rico a balance of the payroll, before the end of the fortnight, to speed up the payment process. By sending this information without balancing the hours worked, it causes errors in the payroll computations. POSSIBLE ASSERTED EFFECT The PRDE incurred payments to employees for hours not worked, and for which specific grants were received. IDENTIFICATION OF REPEAT FINDING This is a repeat finding (Finding Reference Number 2024-005). RECOMMENDATIONS We recommend PRDE design and implement adequate internal controls and payroll processes that will identify in real – time or sooner any incorrect payroll payment made.
Finding 2025-015 – Noncompliance with Reporting Over Major Federal Program – Coronavirus State and Local Fiscal Recovery Funds PASS-THROUGH GRANTOR: Direct Grant FEDERAL AGENCY: U.S. Department of Treasury ASSISTANCE LISTING: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds FEDERAL AWARD YEAR: 2021 CONTROL CATEGORY: Reporting QUESTIONED COSTS: $-0- Condition: During the test of 100% of expenditures for the Coronavirus State and Local Fiscal Recovery Funds totaling $10,706,312, reflected five (5) expenditures totaling $10,182,497, were not accurately reported in the proper period on the quarterly reports as required by the Reporting compliance requirement. Cause of Condition: Policies and procedures have not been designed and implemented to ensure federal expenditures are properly reported in accordance with federal compliance requirements. Effect of Condition: This condition resulted in noncompliance with grant requirements. Recommendation: OSAI recommends the County design and implement a system of internal controls to ensure the accuracy and completeness of reports and to ensure compliance with federal requirements. Management Response: Chairman of the Board of County Commissioners: The BOCC will ensure that the reports are accurate and reported in the proper period. Criteria: GAO Standards – Section 2 – Establishing an Effective Internal Control System – OV2.23 states in part: Objectives of an Entity – Compliance Objectives Management conducts activities in accordance with applicable laws and regulations. As part of specifying compliance objectives, the entity determines which laws and regulations apply to the entity. Management is expected to set objectives that incorporate these requirements. 2 CFR § 200.303 Internal Controls (a) reads as follows: 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. 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). Additionally, Compliance and Reporting Guidance, State and Local Fiscal Recovery Funds (10. Reporting.) reads as follows: 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. In addition, where appropriate, your organization needs to establish controls to ensure completion and timely submission of all mandatory performance and/or compliance reporting. Further, 2 CFR § 200.329 Monitoring and Reporting Program Performance (c)(1) reads as follows: The non-Federal entity must submit performance reports at the interval required by the Federal awarding agency or pass-through entity to best inform improvements in program outcomes and productivity. Intervals must be no less frequent than annually nor more frequent than quarterly except in unusual circumstances, for example where more frequent reporting is necessary for the effective monitoring of the Federal award or could significantly affect program outcomes. Reports submitted annually by the non-Federal entity and/or pass-through entity must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. Alternatively, the Federal awarding agency or pass-through entity may require annual reports before the anniversary dates of multiple year Federal awards. The final performance report submitted by the non-Federal entity and/or pass-through entity must be due no later than 120 calendar days after the period of performance end date. A subrecipient must submit to the pass-through entity, no later than 90 calendar days after the period of performance end date, all final performance reports as required by the terms and conditions of the Federal award. See also § 200.344. If a justified request is submitted by a non-Federal entity, the Federal agency may extend the due date for any performance report.
Finding No. SA 2025-004 – Inaccurate and Unreconciled Reporting of Project and Expenditure Reports Federal Assistance Listing Number: 21.027 Federal Program Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: U.S. Department of Treasury Award Period: Fiscal year 2025 Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria: Pursuant to 2 CFR §200.1, internal controls for non Federal entities are defined as processes designed and implemented to provide reasonable assurance regarding the achievement of objectives in the following categories: (1) effectiveness and efficiency of operations, (2) reliability of reporting for internal and external use, and (3) compliance with applicable laws and regulations. The Accounting Manager is responsible for reviewing the completeness and accuracy of the quarterly Project and Expenditure Reports (PERs) submitted to the U.S. Department of the Treasury and ensuring that reported amounts agree with the City’s financial records, including the Schedule of Expenditures of Federal Awards (SEFA). Condition: During our review of the quarterly reports, we identified unreconciled differences totaling $1,865 between amounts reported on the Schedule of Expenditures of Federal Awards (SEFA) and the quarterly Project and Expenditure Reports submitted to the U.S. Department of the Treasury. Cause: Incorrect adjustments were recorded during the preparation of the quarterly reports, and reconciliation procedures were not sufficient to identify and resolve these differences prior to submission. Effect: The Project and Expenditure Reports submitted to the U.S. Department of the Treasury were not fully accurate or complete. Inaccurate reporting may result in noncompliance with federal requirements and could lead to fines, penalties, or the suspension or termination of federal awards. Questioned Costs: $1,865 Repeat finding: No Recommendation: We recommend that the City enhance review and reconciliation procedures over the preparation of Project and Expenditure Reports to ensure amounts reported are accurate, complete, and fully reconciled to the City’s financial records, including the SEFA, prior to submission. Views of responsible officials and planned corrective actions: The Finance Staff will perform quarterly reconciliations of expenditures to ensure accurate reporting of amounts. Personnel responsible for implementation: Carmen Tsui, Grant Accountant Completion Date: June 30, 2026
Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Child Care and Development Block Grant/Child Care Mandatory and Matching Funds of the Child Care and Development Fund State Administering Department: California Department of Social Services (CDSS) ALN: 93.575, 93.596 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2101CACDC6; October 1, 2020 – September 30, 2024 2334CACCDD; October 1, 2022 – September 30, 2025 2334CACCDF; October 1, 2022 – September 30, 2025 2334CACCDM; October 1, 2022 – September 30, 2025 2434CACCDD; October 1, 2023 – September 30, 2026 2434CACCDF; October 1, 2023 – September 30, 2026 2434CACCDM; October 1, 2023 – September 30, 2025 2534CACCDD; October 1, 2024 – September 30, 2027 2534CACCDF; October 1, 2024 – September 30, 2027 2534CACCDM; October 1, 2024 – September 30, 2026 2534CACCDY; December 21, 2024 – September 30, 2028 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Material Weakness in Internal Control over Complianceand Material Noncompliance Criteria or specific requirement: Title 2 – Federal Financial Assistance Subtitle A – Office of Management and Budget Guidance for Grants and Agreements. Chapter II – Office of Management and Budget Guidance. Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart D – Post Federal Award Requirements. § 200.303 - Internal controls (2 CFR 200.303): The recipient and subrecipient 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). § 200.302 – Financial management (b) The recipient's and subrecipient's financial management system 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 in §§ 200.328 and 200.329. (3) Maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. §200.328 Financial reporting (c) The recipient or subrecipient must submit financial reports as required by the Federal award. Reports submitted annually by the recipient or subrecipient must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. (d) The final financial report submitted by the recipient must be due no later than 120 calendar days after the conclusion of the period of performance. A subrecipient must submit a final financial report to a pass-through entity no later than 90 calendar days after the conclusion of the period of performance. § 200.329 Monitoring and reporting program performance (a) Monitoring by the recipient and subrecipient The recipient and subrecipient are responsible for the oversight of the Federal award. The recipient and subrecipient must monitor their activities under Federal awards to ensure they are compliant with all requirements and meeting performance expectations. Monitoring by the recipient and subrecipient must cover each program, function, or activity. See also § 200.332. Title 45 – Public Welfare Subtitle A – Department of Health and Human Services Subchapter A – General Administration Part 98 – Child Care and Development Fund Subpart G – Financial Management § 98.60 – Availability of funds (d) The following obligation and liquidation provisions apply to States and Territories: (1) Discretionary Fund allotments shall be obligated in the fiscal year in which funds are awarded or in the succeeding fiscal year. Unliquidated obligations as of the end of the succeeding fiscal year shall be liquidated within one year. (2)(i) Mandatory Funds for States requesting Matching Funds per § 98.55 shall be obligated in the fiscal year in which the funds are granted and are available until expended. (4) Both the Federal and non-Federal share of the Matching Fund shall be obligated in the fiscal year in which the funds are granted and liquidated no later than the end of the succeeding fiscal year. (5) Determination of whether funds have been obligated and liquidated will be based on State or local law or, if there is no applicable State or local law, the regulation at 2 CFR 200.1, Expenditures and Obligations. § 98.65 Audits and financial reporting (a) Each Lead Agency shall have an audit conducted after the close of each program period in accordance with 2 CFR part 200, subpart F, and the Single Audit Act Amendments of 1996. (b) Lead Agencies are responsible for ensuring that subgrantees are audited in accordance with appropriate audit requirements. (c) Not later than 30 days after the completion of the audit, Lead Agencies shall submit a copy of their audit report to the legislature of the State or, if applicable, to the Tribal Council(s). Lead Agencies shall also submit a copy of their audit report to the HHS Inspector General for Audit Services, as well as to their cognizant agency, if applicable. (d) Any amounts determined through an audit not to have been expended in accordance with these statutory or regulatory provisions, or with the Plan, and that are subsequently disallowed by the Department shall be repaid to the Federal government, or the Secretary will offset such amounts against any other CCDF funds to which the Lead Agency is or may be entitled. (e) Lead Agencies shall provide access to appropriate books, documents, papers and records to allow the Secretary to verify that CCDF funds have been expended in accordance with the statutory and regulatory requirements of the program, and with the Plan. (f) The audit required in paragraph (a) of this section shall be conducted by an agency that is independent of the State, Territory or Tribe as defined by generally accepted government auditing standards issued by the Comptroller General, or a public accountant who meets such independent standards. (g) Lead Agencies shall submit financial reports, in a manner specified by ACF, quarterly for each fiscal year until funds are expended. (h) At a minimum, a State or territorial Lead Agency's quarterly report shall include the following information on expenditures under CCDF grant funds, including Discretionary (which includes realloted funding and any funds transferred from the TANF block grant), Mandatory, and Matching Funds (which includes redistributed funding); and State Matching and Maintenance-of- Effort (MOE) Funds: (1) Child care administration; (2) Quality activities, including any sub-categories of quality activities as required by ACF; (3) Direct services for both grant or contracted slots and certificates; (4) Non-direct services, including: (i) Establishment and maintenance of computerized child care information systems; (ii) Certificate program cost/eligibility determination; (iii) All other non-direct services; and (5) Such other information as specified by the Secretary. § 98.67 – Fiscal requirements (c) Fiscal control and accounting procedures shall be sufficient to permit: (1) Preparation of reports required by the Secretary under this subpart and under subpart H; and (2) The tracing of funds to a level of expenditure adequate to establish that such funds have not been used in violation of the provisions of this part. Condition: Audit procedures included a review of the entire population of ACF-696 financial reports submitted for the CCDF Cluster. Our testing identified that certain reported amounts did not agree or reconcile to the underlying general ledger, resulting in a total variance of $491,119,535. Additionally, audit procedures identified that internal controls over reporting were not operating effectively to ensure the accurate submission of reports. Specifically, certain reports contained inaccuracies at the time of submission, and controls were not performed with sufficient precision to verify that reported information was complete and accurate in accordance with federal reporting requirements. Questioned costs: None Context: See “Condition.” Cause: The controls over the preparation and review of ACF-696 reports were not performed with sufficient precision to identify and resolve discrepancies between reported amounts and the underlying general ledger. Specifically, controls were not designed or operating at a level precise enough to ensure that reported data was accurate, reconciled, and submitted in a timely manner in accordance with federal requirements. As a result, variances and reporting errors were not detected or corrected prior to submission. Effect: Without a documented reconciliation between the ACF-696 reports and the general ledger, the Department cannot demonstrate that reported expenditures were accurate, complete, and supported by accounting records. This increases the risk that expenditures, obligations, liquidations, unobligated balances, or expenditure categories reported to ACF may be misstated. Inaccurate ACF-696 reporting may affect ACF’s ability to monitor compliance with CCDF spending, obligation, liquidation, and availability requirements. Repeat finding: Yes – 2024-015 Recommendation: Management should establish a formal reconciliation process to ensure that ACF-696 expense reports align with the general ledger. This process should include assigning responsibility to a designated finance team member for performing and documenting reconciliations, implementing a monthly reconciliation schedule, and promptly investigating and resolving any variances with documented approvals. Additionally, financial reporting policies should be updated to incorporate reconciliation requirements, and staff should receive training on compliance and reconciliation procedures to strengthen internal controls and reduce the risk of reporting inaccuracies. Views of responsible officials: Management’s response is reported in “Management’s Response and Corrective Action Plan” included in a separate section at the end of this report. Response to views of responsible officials: We acknowledge management's explanation that variances between the ACF-696 reports and the general ledger resulted from timing differences associated with subsequent cost allocations, accruals, and other adjustments. However, the issue identified during the audit was not the existence of timing differences, but that the reconciliation process did not adequately identify, explain, and support significant variances. Audit testing identified unreconciled variances totaling $491,119,535 between the ACF-696 reports and the general ledger. Although management indicated that adjustments were reported in subsequent quarters, documentation supporting a complete and accurate reconciliation was not available at the time of report preparation and submission. As a result, controls did not operate with sufficient precision to ensure reported amounts were accurate, complete, and supported by the Department's accounting records. Accordingly, we continue to conclude that the finding is valid as presented. We appreciate management's planned corrective actions to formalize the reconciliation process and strengthen oversight of ACF-696 reporting.
Finding 2025-005 Late Reporting and Noncompliance with Reporting Requirements Federal Agency: U.S. Department of Commerce Federal Program: Economic Development Cluster ALN: 11.307 Award Numbers: ED23SEA0G0012 Award Year: 2025 Type of Finding: Significant deficiency and noncompliance. Criteria: 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. The nonfederal entity must submit performance reports at the interval required by the federal awarding agency or pass-through entity to best inform improvements in program outcomes and productivity as outlined in 2 CFR 200.329. Condition and context: The City did not adhere to the program requirement of submitting the financial and performance report by the deadlines set forth in the grant award. Cause: The City was not able to provide the necessary reporting documents in the required time frames set forth in the grant award. Effect: The City is not in compliance with reporting requirements. Questioned Costs: None noted. Repeat finding: This is not a repeat finding. Recommendation: The City needs to improve processes for preparing and submitting financial information timely. Management’s Response: Management concurs with the finding. See Corrective Action Plan.
Federal Program: ALN 93.600 Head Start Category: Compliance/internal control significant deficiency Compliance Requirement: Equipment and real property management Criteria: 2 CFR §200.313 (d) establishes that in the management requirements of equipment that regardless of whether equipment is acquired in part or its entirety under the Federal award, the recipient or subrecipient must manage equipment (including replacement equipment) utilizing procedures that meet the following requirements: (1) Property records must include a description of the property, a serial number or another identification number, the source of funding for the property (including the Federal Award Identification Number), the title holder, the acquisition date, the cost of the property, the percentage of the Federal agency contribution towards the original purchase, the location, use and condition of the property, and any disposition data including the date of disposal and sale price of the property. The recipient and subrecipient are responsible for maintaining and updating property records when there is a change in the status of the property. As established by BGCPR's capitalization policy, all items with a unit cost exceeding $5,000 must be capitalized. As per 2 CFR §200.1 equipment means tangible personal property (including information technology systems) having a useful life of more than one year and a per-unit acquisition cost that equals or exceeds the lesser of the capitalization level established by the recipient or subrecipient for financial statement purposes, or $5,000 on June 30, 2025. Condition: BGCPR real and personal property records are not complete and did not follow the program requirements. BGCPR’s fixed asset records include assets acquired using multiple funding sources (federal, state, and private). However, the BGCPR has not implemented a mechanism to clearly identify and distinguish equipment acquired with federal funds within the fixed asset system. As a result, property records for federally funded equipment are incomplete and do not include all data elements required under 2 CFR §200.313(d)(1), including Federal Award Identification Number (FAIN), percentage of federal participation, and information related to location, use, condition, and disposition. In addition, certain equipment acquisitions that exceeded BGCPR’s capitalization threshold were not capitalized in the fixed asset records. Cause: BGCPR did not maintain essential details, such as acquisition costs, funding sources, or the federal award identification numbers. In addition, management did not consistently apply its capitalization policy. Effect or potential effect: As a result of this condition, BGCPR: • Is not in compliance with 2 CFR §200.313(d)(1); • May incur questioned or disallowed costs related to federally funded equipment • Cannot readily identify federally funded equipment for monitoring, reporting, or physical inventory purposes • Is exposed to an increased risk of loss, misuse, or inaccurate reporting of federally funded equipment, which may affect current and future federal funding. Questioned costs: Amount is below the threshold to be considered a questioned cost. Context: Upon testing a sample of twenty one (21) assets, we noted that two (2) equipment acquisitions exceeding the capitalization threshold were not capitalized, four assets lacked an Asset ID identification or tag number, and one asset lacked a serial number. Identification as a repeat finding: As of June 30, 2024, finding 2024-007 was identified under this condition. This finding is still valid for the year ended June 30, 2025. Recommendation: BGCPR must identify all properties acquired with Federal funds and maintain adequate accounting records in accordance with Federal regulations. The program must maintain an automated accounting and record keeping system adequate for effective oversight. Management should strengthen its fixed asset tracking system to ensure compliance with 2 CFR §200.313(d)(1) by: • Implementing a method to clearly identify and track equipment acquired with federal funds within the fixed asset register; • Updating property records to include all required data elements (e.g., FAIN, percentage of federal participation, location, condition, and disposition data) for federally funded equipment; • Establishing formal policies and procedures for recording, monitoring, and disposing of equipment acquired with federal funds; • Performing periodic reviews and physical inventories to ensure completeness and accuracy of federally funded equipment records. Views of officials responsible: BGCPR recognizes that it must keep and improve the asset capitalization processes and policies, particularly within the accounting system of record. It acknowledges the need to strengthen these processes to ensure accurate and compliant management of equipment acquisitions. To address this, during fiscal year 2025-26, BGCPR implemented a system capable of recording, classifying, and monitoring all capital assets in alignment with the criteria established under federal regulation 2 CFR §200. This improvement is essential to ensure that all asset capitalization activities meet regulatory standards and support greater financial transparency and accountability. As a corrective measure, BGCPR will take the following actions: a. A property and inventory coordinator was hired and is responsible for overseeing all aspects of property control and asset management. b. Full Implementation Property software to accurately all property of by BGCPR. The system includes information such as asset identification number, acquisition date, funding source, cost, useful life, depreciation, location, and other relevant details, serving as a support tool for the property records maintained in the accounting system. c. Prepare an updated Property Control Manual, which is pending final approval by senior management. Implement procedures for timely recording of acquisitions, transfers, disposals, and impairments to ensure that asset records remain current and accurate. d. Perfom and complete physical inventory for all Units and Central Office. e. All inventory counts have been entered into the system. f. All property acquired have been recorded in the property software. g. Currently we are in the process of valuation of the physical inventory to reconcile with the accounting records by December 31, 2026. h. Training was provided to personnel involved in asset management and inventory activities to ensure consistent application of established procedures. i. Perform periodic monitoring reviews by finance, compliance, or internal audits to validate adherence to property control policies and inventory requirements. Anticipated Completion Date: December 31, 2026
2025-002 U.S. Department of Treasury COVID-19 – Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 Material Weakness in Internal Controls over Compliance and Compliance Finding Criteria: The compliance supplement identifies four Key Line Items required to be reported to the federal awarding agency which include (1) current period obligation, (2) cumulative obligation, (3) current period expenditure and (4) cumulative expenditure. Per 2 CFR 200.1, an obligation is an order placed for property and services, contracts and subawards made, and similar transactions that require payment. Condition: Expenditures were not reconciled to the general ledger for reporting submitted to the U.S. Department of the Treasury. Cause: The Town did not have procedures in place to perform reconciliations of required grant reporting. Effect: It was determined that the Town recorded overstated expenditures by $427,507 in reporting submitted to the U.S. Department of the Treasury. Questioned Costs: None Repeat Finding from Prior Year: No Recommendation: The Town should implement procedures to reconcile all federal reporting to the general ledger. Views of Responsible Official: Management agrees with the finding.
Federal Agency: United States Department of Education Federal Program: Rehabilitation Services – Vocational Rehabilitation Grants to States (84.126) Federal Award Numbers: H126A220047 (SED), H126A230047(SED), H126A240047 (SED), H126A250047 (SED) Federal Award Years: 2022, 2023, 2024, 2025 State Agency: State Education Department Reference: 2025-003 Criteria Period of Performance Under section 111(a)(1) of the Rehabilitation Act, the Department pays to each state each federal fiscal year an amount equal to the federal share of the cost of providing VR services and administering the VR program. Consistent with the definition of “period of performance” at 2 CFR section 200.1 and the requirements governing information that must be contained in a Grant Award Notification (GAN) at 2 CFR section 200.211, the VR GAN specifies the beginning and end dates for each VR grant award. Therefore, state VR agencies may incur obligations or make expenditures under a grant award if they are incurred during the period of performance for that award. Any obligations or expenditures incurred outside of that period of performance would need to be paid with funds available from a different VR grant award. Internal Controls 2 CFR 200.303(a) states 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. 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). Condition The State Education Department (SED) did not maintain complete data along with the supporting documentation for the period of performance. A sample of 60 transactions was selected from SED records. For each case, an invoice, pay period, and/or manual journal entries were tested to verify the data reported in the NYGR0302 report. It was also checked to ensure that the disbursement was properly reviewed, approved, and that the selected amount met the requirement of an allowable activity incurred during the period of performance and liquidated within the required time period. During our review of fiscal year 2025 transactions, we identified that 4 out of the 60 sampled transactions occurred outside the designated period of performance. The grant award period ended on September 30, 2024, with a liquidation period extending 120 days beyond that date, until January 28, 2025. Specifically, for grant number H126A230047, these four services were incurred in either October or November 2024, which is after the designated period of performance. This indicates a significant lapse in the controls governing the timing of obligations and expenditures related to VR grant funds. Cause The condition related to a deficiency in the operation of the review process not occurring at a precision necessary to identify missing information during the review that is required to be in compliance with the grant’s period of performance. Possible Asserted Effect The identified issue of a transaction occurring outside the period of performance and being liquidated beyond the required liquidation period could have significant implications for SED. This non compliance with federal regulations may result in financial penalties, reduced future funding, and potential repayment of misused funds. Questioned Costs $23,190 (representing the 4 transactions found to have occurred outside the specified period of performance. The population amounted to $117,470,987, of which sixty, totaling $2,948,245, were selected for test work.) Statistical Sampling The sample was not intended to be, and was not, a statistically valid sample. Repeat Finding A similar finding was identified in the 2024 Single Audit Report as finding number 2024-003 at pages 23-24. Recommendation We recommend SED implement a new control mechanism for reviewing funds before distribution. This control should include a pre distribution review process with a dedicated team or staff verifying the period of performance for each VR grant award, ensuring all obligations and expenditures fall within the specified dates. Additionally, an automated system or manual control is recommended to be developed or enhanced to flag any transactions outside the period of performance or liquidation period. View of Responsible Officials Recommendation accepted. Please refer to corrective action plan.
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.