Finding 1175443 (2025-003)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2026-02-26
Audit: 389227
Organization: City of Sand Springs (OK)

AI Summary

  • Core Issue: The City of Sand Springs misreported $2,392,701.84 in SLFRF expenditures, including $1,283,496.43 from a federal pass-through grant that should have been reported by OWRB.
  • Impacted Requirements: This misreporting violates Uniform Guidance (2 CFR 200.331 and 2 CFR 200.510) and could lead to questioned costs and noncompliance.
  • Recommended Follow-Up: Implement procedures to track and report only direct federal expenditures, provide training for staff on reporting requirements, and coordinate with OWRB for accurate pass-through fund reporting.

Finding Text

Finding 2025-003 – Misreporting of Pass-Through Grant Expenditures in SLFRF Compliance Report Criteria: Per Uniform Guidance (2 CFR 200.331 and 2 CFR 200.510), pass-through entities must clearly identify federal awards to subrecipients, including the source of funding, applicable federal requirements, and the Assistance Listing number (21.027 for SLFRF). Subrecipients are required to report only those federal expenditures they directly administer on their Schedule of Expenditures of Federal Awards (SEFA), and not those administered by the pass-through entity. Expenditures of federal pass-through funds should be reported by the pass-through entity (e.g., OWRB) and not by the subrecipient (the City of Sand Springs). Condition: During review of the ARPA Funds Project Spending for March 2025, it was identified that the City of Sand Springs reported $2,392,701.84 in current period expenditures for project #479952 in the SLFRF Compliance report. However, only $1,109,205.41 should have been reported. The discrepancy resulted from the mistaken inclusion of expenditures from the OWRB Grant (a federal pass-through grant from ARPA) in the City of Sand Springs's SLFRF report. Cause and Effect: The Finance Director was unaware that the City of Sand Springs was utilizing OWRB funds (ARPA pass-through) first, followed by direct ARPA funds. As a result, expenditures from the OWRB Grant were incorrectly included in the City of Sand Springs's SLFRF Compliance report, rather than being reported by OWRB as the pass-through entity. The City of Sand Springs's SLFRF Compliance report overstated federal expenditures by $1,283,496.43 for the period. This misreporting could result in inaccurate federal reporting, potential questioned costs, and noncompliance with Uniform Guidance and SLFRF requirements. It also constitutes a significant deficiency in internal controls over federal award reporting. Recommendation: We recommend that the City of Sand Springs implement procedures to ensure that only expenditures of direct federal awards are reported in the SLFRF Compliance report. Expenditures from federal pass-through grants should be tracked separately and reported by the appropriate pass-through entity. Staff responsible for federal reporting should receive training on the distinction between direct and pass-through federal funds and related reporting requirements. Management Response: Management concurs with the finding. The Finance Department will update its procedures to ensure that only direct ARPA funds are reported in the SLFRF Compliance report. Expenditures from OWRB pass-through grants will be tracked separately and excluded from the City of Sand Springs's SLFRF reporting. Staff will receive additional training on federal grant reporting requirements. The City of Sand Springs will coordinate with OWRB to ensure proper reporting of pass-through funds.

Corrective Action Plan

RE: Finding 2025-003 Misreporting of Pass-Through Grant Expenditures in Compliance Report In conjunction with our FY25 annual audit, please see the City's corrective action plan below: The City of Sand Springs will strengthen internal controls over federal grant reporting to ensure proper distinction between direct federal awards and federal pass-through grants, in accordance with Uniform Guidance and SLFRF requirements. Specifically, the City will implement the following corrective actions: Separate Tracking of Direct vs. Pass-Through Funds o The Finance Department will revise grant accounting procedures to clearly segregate expenditures related to: Direct SLFRF (ARPA) awards administered by the City, and Federal pass-through grants administered by external entities, including OWRB. o Separate project codes and/or accounting identifiers will be maintained to prevent commingling of expenditures. Revision of SLFRF Reporting Procedures o Written procedures for preparation and review of the SLFRF Compliance Report will be updated to explicitly state that: Only expenditures related to direct federal awards are to be reported by the City, and Expenditures related to pass-through grants are excluded and reported by the pass-through entity. o A documented review step will be added to verify that reported expenditures align with the funding source prior to submission. Staff Training and Awareness o Finance staff involved in grant accounting and reporting will receive targeted training on: Uniform Guidance requirements (2 CFR 200), The distinction between direct federal awards and pass-through grants, and Proper SEFA and SLFRF reporting responsibilities. o Training will be documented and incorporated into onboarding materials for future staff. Coordination with Pass-Through Entity (OWRB) o The City will coordinate with OWRB to confirm: The sequence of fund utilization (pass-through vs. direct ARPA funds), and Roles and responsibilities for federal expenditure reporting. Expected completion date: Procedures will be implemented for the fiscal year ending June 30, 2026, and applied during interim processing and year-end close. Party Responsible: Finance Director and Finance Staff, in coordination with applicable Department Heads and Project Managers. Contact Information: Arlena Barnes 918-246-2646 arlena.barnes@sandspringsok.gov

Categories

Reporting Subrecipient Monitoring

Other Findings in this Audit

  • 1175441 2025-001
    Material Weakness Repeat
  • 1175442 2025-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $2.00M
20.513 ENHANCED MOBILITY OF SENIORS AND INDIVIDUALS WITH DISABILITIES $105,958
16.710 PUBLIC SAFETY PARTNERSHIP AND COMMUNITY POLICING GRANTS $53,612
20.106 AIRPORT IMPROVEMENT PROGRAM, INFRASTRUCTURE INVESTMENT AND JOBS ACT PROGRAMS, AND COVID-19 AIRPORTS PROGRAMS $10,882
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $5,670
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $1,644