Finding 571503 (2024-006)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-07-17
Audit: 362454
Organization: City of Loveland (CO)

AI Summary

  • Core Issue: The schedule of expenditures of federal awards (SEFA) was inaccurate, with significant overstatements and understatements in reported federal funding.
  • Impacted Requirements: Compliance with the Single Audit Act and Uniform Guidance, which mandate accurate financial reporting for federal awards exceeding $750,000.
  • Recommended Follow-Up: Implement a robust process to ensure SEFA accuracy, including enhancing tracking systems and collaboration across city departments.

Finding Text

Assistance Listing, Federal Agency, and Program Name - 20.205, U.S. Department of Transportation, Highway Planning and Construction; 15.916, U.S. Department of the Interior, Outdoor Recreation, Acquisition, Development and Planning Federal Award Identification Number and Year - FAINs not available Pass through Entity - ALN 20.205 Colorado Department of Transportiation; ALN 15.916 Colorado Parks and Wildlife/Land and Water Conservation Fund Finding Type - Material weakness Repeat Finding - No Criteria - The Single Audit Act and Uniform Guidance require a nonfederal entity that expends $750,000 or more of federal awards in a fiscal year to have a single or program specific audit. 2 CFR §200.508 (b) indicates that the auditee must prepare financial statements, including the schedule of expenditures of federal awards, in accordance with 2 CFR §200.510. Additionally, 2 CFR §200.502 describes the basis for determining the timing of when federal awards are deemed expended and, therefore, reportable on the schedule. Condition - The schedule of expenditures of federal awards (the "SEFA") was not accurate. Questioned Costs - None If questioned costs are not determinable, description of why known questioned costs were undetermined or otherwise could not be reported - Not applicable Identification of How Questioned Costs Were Computed - Not applicable Context - During the fiscal year ended December 31, 2024, the City expended approximately $22,617,000 of federal funding. The initial draft of the SEFA included the following inaccuracies: ALN 20.205 The expenditures reported on the SEFA were overstated by $19,522 for one award and understated by $145,869 for another award. ALN 15.916 The expenditures reported on the SEFA were overstated by $45,915 The errors noted above have been corrected on the SEFA as of December 31, 2024. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for the fiscal period under audit. The errors resulted in the understatement of federal expenditures. Recommendation - We recommend the City implement a process to ensure that the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - The City accepts this finding. As part of the revision to the City’s grant process and procedures, we will enhance our master grant tracking spreadsheet to ensure grant expenditures are reported correctly. We will collaborate with city departments to ensure costs are recorded correctly. See the corrective action plan.

Corrective Action Plan

Condition: The schedule of expenditures of federal awards (the "SEFA") was not accurate. Planned Corrective Action: To improve accuracy and completeness of the SEFA, the City will enhance its master grant tracking spreadsheet to ensure all grant expenses are calculated correctly and consistently. In addition, quarterly reviews will be conducted in partnership with departments to confirm that all federal awards are current and accurately captured. These improvements, along with the updated required quarterly report and request for reimbursement procedures, will allow the City to compile a complete and accurate SEFA. Contact person responsible for corrective action: Grant Accountant and Accounting Manager Anticipated Completion Date: 7/31/2025

Categories

Reporting Material Weakness Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 571498 2024-001
    Material Weakness
  • 571499 2024-002
    Material Weakness
  • 571500 2024-003
    Material Weakness
  • 571501 2024-004
    Material Weakness
  • 571502 2024-005
    Material Weakness
  • 571504 2024-006
    Material Weakness
  • 1147940 2024-001
    Material Weakness
  • 1147941 2024-002
    Material Weakness
  • 1147942 2024-003
    Material Weakness
  • 1147943 2024-004
    Material Weakness
  • 1147944 2024-005
    Material Weakness
  • 1147945 2024-006
    Material Weakness
  • 1147946 2024-006
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
20.106 Airport Improvement Program, Infrastructure Investment and Jobs Act Programs, and Covid-19 Airports Programs $9.27M
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $3.25M
97.039 Hazard Mitigation Grant $1.14M
15.916 Outdoor Recreation Acquisition, Development and Planning $1.01M
20.507 Federal Transit Formula Grants $892,699
14.251 Economic Development Initiative, Community Project Funding, and Miscellaneous Grants $810,000
20.106 Covid-19 - Airport Improvement Program, Infrastructure Investment and Jobs Act Programs, and Covid-19 Airports Programs $669,458
20.507 Covid-19 - Federal Transit Formula Grants $495,732
94.021 Americorps Volunteer Generation Fund 94.021 $327,801
14.218 Community Development Block Grants/entitlement Grants $298,173
20.205 Highway Planning and Construction $256,489
66.818 Brownfields Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements $70,237
11.307 Covid-19 - Economic Adjustment Assistance $68,786
16.575 Crime Victim Assistance $50,612
15.605 Sport Fish Restoration $37,598
17.285 Registered Apprenticeship $35,607
20.600 State and Community Highway Safety $29,423
93.575 Child Care and Development Block Grant $23,545
32.009 Emergency Connectivity Fund Program $17,972
14.218 Covid-19 - Community Development Block Grants/entitlement Grants $8,865
45.025 Promotion of the Arts Partnership Agreements $3,250