Finding 1223462 (2025-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2026-07-09
Audit: 406819
Organization: City of Greeley (CO)

AI Summary

  • Core Issue: The schedule of expenditures of federal awards (SEFA) for two programs was incomplete and inaccurate, affecting major program determination.
  • Impacted Requirements: Compliance with 2 CFR Section 200.510(b) was not met, as the SEFA did not accurately reflect total federal awards expended.
  • Recommended Follow-Up: Strengthen controls to ensure SEFA accuracy; the new Grants Manager and team should enhance tracking and reconciliation processes using the eCivis Euna Grants system.

Finding Text

Assistance Listing Number, Federal Agency, and Program Name - ALN 15.916, Department of the Interior, Outdoor Recreation Acquisition, Development and Planning, Outdoor Recreation Acquisition, Development and Planning Grants, and ALN 66.468, Environmental Protection Agency, Drinking Water State Revolving Fund. Federal Award Identification Number and Year - All grants under ALN Pass through Entity - ALN 15.916, Colorado Department of Natural Resources, and ALN 66.468, Colorado Water Resources and Power Development Authority Finding Type - Material weakness Repeat Finding - Yes 2024 002 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 Outdoor Recreation Acquisition, Development and Planning program and the Drinking Water State Revolving Fund program 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 Outdoor Recreation Acquisition, Development and Planning program expenditures of $1,250,000 were omitted. The Drinking Water State Revolving Fund program was overstated by $76,884. 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 was adjusted for two federal programs. This did impact major program determination for Outdoor Recreation Acquisition, Development and Planning. Recommendation - We recommend the City ensure the effectiveness of controls to ensure expenditures reported on the SEFA are complete and accurate. Views of Responsible Officials and Corrective Action Plan - The Finance Department recently hired a new Grants Manager after being without this critical position for almost a year. The Grants Manager, along with the Grant Specialist and the Financial Reporting team accountants, plan to work together to improve the tracking and reconciliation of grant activity. In addition, the City implemented eCivis Euna Grants, a grant application, tracking, and reporting system, in November of 2025. The Grants Team will be working with Departments to document the grants process formally for the City and this will ensure that all grants are accounted for and tracked in the Euna grants system. This renewed capacity and new initiatives, supported by the new administrative cost recovery framework and the City's grants management platform, reflects a broader commitment to managing external funding with the same discipline applied to locally generated revenues.

Corrective Action Plan

Condition: The Outdoor Recreation Acquisition, Development and Planning program and the Drinking Water State Revolving Fund program expenditures on the schedule of expenditures of federal awards (SEFA) initially presented for audit were not complete and accurate. Planned Corrective Action: The Finance Department recently hired a new Grants Manager after being without this critical position for almost a year. The Grants Manager, along with the Grant Specialist and the Financial Reporting team accountants, plan to work together to improve the tracking and reconciliation of grant activity. In addition, the City implemented eCivis Euna Grants, a grant application, tracking, and reporting system, in November of 2025. The Grants Team will be working with Departments to document the grants process formally for the City and this will ensure that all grants are accounted for and tracked in the Euna grants system. This renewed capacity and new initaitives, supported by the new administrative cost recovery framework and the City's grants management platform, reflects a broader commitment to managing external funding with the same discipline applied to locally generated revenues. Contact person responsible for corrective action: Julie Cunningham, Grants Manager. Anticipated Completion date: 05/01/2027

Categories

Reporting

Other Findings in this Audit

  • 1223460 2025-002
    Material Weakness Repeat
  • 1223461 2025-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
20.507 FEDERAL TRANSIT FORMULA GRANTS $3.20M
66.468 DRINKING WATER STATE REVOLVING FUND $2.06M
15.916 OUTDOOR RECREATION ACQUISITION, DEVELOPMENT AND PLANNING $1.25M
20.941 STRENGTHENING MOBILITY AND REVOLUTIONIZING TRANSPORTATION (SMART) GRANTS PROGRAM $613,018
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $317,298
66.818 BROWNFIELDS MULTIPURPOSE, ASSESSMENT, REVOLVING LOAN FUND, AND CLEANUP COOPERATIVE AGREEMENTS $224,348
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $135,576
16.039 RURAL VIOLENT CRIME INITIATIVE $130,650
10.923 EMERGENCY WATERSHED PROTECTION PROGRAM $129,409
16.922 EQUITABLE SHARING PROGRAM $126,584
97.047 BRIC: BUILDING RESILIENT INFRASTRUCTURE AND COMMUNITIES $106,304
95.001 HIGH INTENSITY DRUG TRAFFICKING AREAS PROGRAM $105,034
16.575 CRIME VICTIM ASSISTANCE $97,467
20.205 HIGHWAY PLANNING AND CONSTRUCTION $58,516
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $41,438
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $31,330
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $9,774
20.939 SAFE STREETS AND ROADS FOR ALL $8,387