Finding 526021 (2023-003)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2025-03-07
Audit: 345166
Organization: City of Fort Collins, Colorado (CO)

AI Summary

  • Core Issue: The fiscal year 2023 SEFA was initially incorrect, including expenditures from fiscal year 2022 and those incurred without an executed grant agreement.
  • Impacted Requirements: Compliance with 2 CFR 200.502 and GASB Implementation Guide 2019 1, which dictate when federal awards can be recognized.
  • Recommended Follow-Up: Implement controls to ensure SEFA preparation aligns with regulations, reporting only expenditures from grants with executed agreements.

Finding Text

Assistance Listing Number, Federal Agency, and Program Name ALN 20.205, Department of Transportation, Highway Planning and Construction Federal Transit Cluster, ALNs 20.500 (Federal Transit Capital Investment Grants), 20.507 (Federal Transit Formula Grants), 20.507 (COVID 19, Federal Transit Formula Grants), and 20.526 (Bus and Bus Facilities Formula Program & Discretionary Programs), Department of Transportation Federal Award Identification Number and Year ALN 20.205: STU M455 125, SHO M455 124, and STU CO60 086 ALN 20.500: 1138 2022 1 ALN 20.507: CO 2023 015 00, CO 2021 031, CO 2023 015 00, and CO 2023 014 (COVID 19) ALN 20.526: CO 2023 013 00, 1138 2023 4, 1138 2023 7, 1138 2023 3, CO 2022 003 00, and CO 2023 001 Pass through Entity ALN 20.205 Colorado Department of Transportation ALNs 20.500, 20.507, and 20.526 N/A Finding Type Material weakness Repeat Finding No Criteria According to 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Per GASB Implementation Guide 2019 1 Question 4.7, in the absence of an executed grant agreement before the end of the reporting period, a government cannot establish that it has incurred allowable costs. Additionally, the applicable FTA section of the federal register for the grants in question indicates that "pre award authority is not a legal or implied commitment that the subject project will be approved for FTA assistance or that FTA will obligate federal funds." Condition The fiscal year 2023 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal year 2022, as well as expenditures that were incurred before an executed grant agreement was in place. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The expenditures on the City's SEFA were misreported as follows: ALN 20.205, Highway Planning and Construction The expenditures reported on the initial SEFA included $641,174 that related to expenditures incurred in fiscal year 2022. ALNs 20.500, 20.507, and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA included $5,250,990 that related to expenditures incurred in prior fiscal years, or for which an executed grant agreement had not yet been received as of December 31, 2023. ALNs 20.507, 20.507 (COVID 19), and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA excluded $9,103,948 that related to expenditures incurred in fiscal year 2022, during which an executed grant agreement had not yet been received, but was received during the year ended December 31, 2023. Cause and Effect Related to the instance where fiscal year 2022 expenditures were reported on the fiscal year 2023 SEFA, the City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Related to the Federal Transit Cluster, the City has historically interpreted pre award authority granted by the FTA as the trigger to recognized federal expenditures, even without an executed grant agreement. As a result, the SEFA in fiscal year 2023 was initially misstated requiring a restatement of the 2022 SEFA. These errors did impact major program determination, wherein ALN 20.205, Highway Planning and Construction, which was originally required to be tested in fiscal year 2023, did not need to be assessed as a major program based on the reissued 2022 SEFA. The final SEFA for fiscal year 2023 has been corrected for these errors. Recommendation The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan Expenditures will be reported on the SEFA only for grant programs with an executed award regardless of the year incurred. SEFA preparation procedures have been updated to ensure analysis of grant execution date.

Categories

Reporting

Other Findings in this Audit

  • 526014 2023-003
    Material Weakness
  • 526015 2023-003
    Material Weakness
  • 526016 2023-003
    Material Weakness
  • 526017 2023-003
    Material Weakness
  • 526018 2023-003
    Material Weakness
  • 526019 2023-003
    Material Weakness
  • 526020 2023-003
    Material Weakness
  • 1102456 2023-003
    Material Weakness
  • 1102457 2023-003
    Material Weakness
  • 1102458 2023-003
    Material Weakness
  • 1102459 2023-003
    Material Weakness
  • 1102460 2023-003
    Material Weakness
  • 1102461 2023-003
    Material Weakness
  • 1102462 2023-003
    Material Weakness
  • 1102463 2023-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
81.041 State Energy Program $800,000
20.507 Covid-19 - Federal Transit Formula Grants $589,305
20.507 Federal Transit Formula Grants $184,545
14.218 Covid-19 - Community Development Block Grants/entitlement Grants $178,166
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $159,843
66.312 Environmental Justice Government-to-Government (ejg2g) Program $147,329
21.027 Coronavirus State and Local Fiscal Recovery Funds $110,860
66.034 Surveys, Studies, Research, Investigations, Demonstrations, and Special Purpose Activities Relating to the Clean Air Act $108,200
14.218 Community Development Block Grants/entitlement Grants $71,985
14.239 Covid-19 - Home Investment Partnerships Program $63,824
20.205 Highway Planning and Construction $41,983
14.239 Home Investment Partnerships Program $36,194
16.738 Edward Byrne Memorial Justice Assistance Grant Program $29,517
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $28,084
16.575 Crime Victim Assistance $22,792
16.800 Recovery Act - Internet Crimes Against Children Task Force Program (icac) $11,195
20.616 National Priority Safety Programs $10,947
66.605 Performance Partnership Grants $9,000
93.575 Child Care and Development Block Grant $6,726
45.312 National Leadership Grants $5,160
15.507 Watersmart (sustain and Manage America’s Resources for Tomorrow) $1,023