Finding 1167569 (2024-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2026-01-02
Audit: 378666
Organization: City of Greeley (CO)

AI Summary

  • Core Issue: The schedule of expenditures of federal awards (SEFA) for the CDBG and Federal Transit Clusters was found to be incomplete and inaccurate, with significant overstatements of $792,426 and $365,634, respectively.
  • Impacted Requirements: This finding violates 2 CFR Section 200.510(b), which mandates accurate reporting of federal award expenditures.
  • Recommended Follow-Up: The City should implement a robust process to ensure SEFA accuracy, including updated Standard Operating Procedures and a dedicated grants team to oversee compliance.

Finding Text

Assistance Listing, Federal Agency, and Program Name ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants and ALN 20.507, U.S. Department of Transportation, Federal Transit Cluster, Federal Transit Formula Grants Federal Award Identification Number and Year All grants under ALN Pass through Entity N/A Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR Section 200.510(b), the auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended determined in accordance with Section 200.502. Condition The CDBG Cluster and Federal Transit Cluster expenditures on the schedule of expenditures of federal awards (SEFA) initially presented for audit were not complete and 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 The CDBG Cluster expenditures were overstated by $792,426 and the Federal Transit Cluster expenditures were overstated by $365,634. The final SEFA has been corrected. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate and as a result, the SEFA needed to be adjusted for two federal clusters. This did not impact major program determination. Recommendation The City should implement a process to ensure the expenditures reported on the SEFA are complete and accurate. Views of Responsible Officials and Corrective Action Plan Due to turnover and the loss of a long term employee new processes were implemented to prepare reporting and documentation processes for the Federal Transit Cluster. Written Standard Operating Procedures have been generated and will be updated as necessary. Reporting and draw processes have been updated to include written signatures of approval for the documentation. The staff in transit and finance work closely together to ensure the completeness of records. City of Greeley will also be organizing a formalized grants team that will be dedicated to all grant activities including the SEFA and correcting the prior staffing insufficiencies.

Corrective Action Plan

Condition: The CDBG Cluster and Federal Transit Cluster expenditures on the schedule of expenditures of federal awards (SEFA) initially presented for audit were not complete and accurate. Planned Corrective Action: Due to turn-over and the loss of a long-term employee new processes were implemented to prepare reporting and documentation processes for the Federal Transit Cluster. Written Standard Operating Procedures have been generated and will be updated as necessary. Reporting and draw processes have been updated to include written signatures of approval for the documentation. The staff in transit and finance work closely together to ensure the completeness of records. City of Greeley will also be organizing a formalized grants team that will be dedicated to all grant activities including the SEFA and correcting the prior staffing insufficiencies. Contact person responsible for corrective action: Rebecca Romero, Grant Accountant Anticipated Completion Date: 03/01/2026

Categories

Reporting

Other Findings in this Audit

  • 1167561 2024-002
    Material Weakness Repeat
  • 1167562 2024-002
    Material Weakness Repeat
  • 1167563 2024-002
    Material Weakness Repeat
  • 1167564 2024-002
    Material Weakness Repeat
  • 1167565 2024-002
    Material Weakness Repeat
  • 1167566 2024-002
    Material Weakness Repeat
  • 1167567 2024-002
    Material Weakness Repeat
  • 1167568 2024-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
20.507 FEDERAL TRANSIT FORMULA GRANTS $2.58M
20.205 HIGHWAY PLANNING AND CONSTRUCTION $1.48M
15.507 WATERSMART (SUSTAIN AND MANAGE AMERICA’S RESOURCES FOR TOMORROW) $757,087
97.047 BRIC: BUILDING RESILIENT INFRASTRUCTURE AND COMMUNITIES $252,024
15.916 OUTDOOR RECREATION ACQUISITION, DEVELOPMENT AND PLANNING $195,182
20.939 SAFE STREETS AND ROADS FOR ALL $183,088
10.727 INFLATION REDUCTION ACT URBAN & COMMUNITY FORESTRY PROGRAM $175,124
16.922 EQUITABLE SHARING PROGRAM $173,588
10.923 EMERGENCY WATERSHED PROTECTION PROGRAM $170,038
20.941 STRENGTHENING MOBILITY AND REVOLUTIONIZING TRANSPORTATION (SMART) GRANTS PROGRAM $161,700
16.575 CRIME VICTIM ASSISTANCE $148,826
16.039 RURAL VIOLENT CRIME INITIATIVE $130,650
95.001 HIGH INTENSITY DRUG TRAFFICKING AREAS PROGRAM $104,147
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $82,917
21.027 COVID-19 - CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $58,033
14.218 COVID-19 - COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $55,112
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $29,041
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $25,500
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $10,000
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $8,503
16.543 MISSING CHILDREN'S ASSISTANCE $5,028
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $230