Finding 554300 (2024-002)

Significant Deficiency Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2024
Accepted
2025-04-07
Audit: 352902
Organization: City of San Bruno (CA)

AI Summary

  • Core Issue: The City miscalculated customer account credits for unpaid bills, leading to credits for future bills that are not allowed under grant requirements.
  • Impacted Requirements: Grant expenditures must comply with allowable costs, and internal controls should ensure accurate calculations of unpaid amounts as of the grant fund receipt date.
  • Recommended Follow-Up: The City should summarize grant requirements and implement controls to prevent future errors, with a plan to adjust customer account balances by October 2025.

Finding Text

2024-02 – Allowable Costs (Significant Deficiency) Program: Coronavirus State and Local Fiscal Recovery Funds, Assistance Listing Number 21.027, U.S. Department of Treasury, Passed through the State Water Resources Control Board Criteria: Grant expenditures should be for costs that are allowable per the grant requirements. Internal controls over grant expenditures should ensure compliance over the grant requirements. The State Water Resources Control Board (State) grant allows credits to customer water and wastewater accounts for unpaid bills from the period July 1, 2021 through December 31, 2022. Additionally, customer accounts should be credited only for bills for services that remain unpaid as of the date the account credit is applied. Condition: The City calculated the unpaid bills as of December 2023 when applying for the grant but did not re-calculate those unpaid amounts as of the date the accounts were received from the State and credited with the grant funds in April 2024. Effect: Customers who paid down their liabilities to the City between the date the City applied for the grant and the date the grant funds were received from the State ended with accounts that had credit balances, thus pre-paying for future bills. Credits for future bills is not allowable per the grant. Questioned Costs: 10 of the 25 credited accounts we tested were over-credited by a total of $10,467. Some of the other credited accounts tested could have been credited more, resulting in a net over-credit of $6,921 for the selections as known questioned costs. Likely questioned costs for the program totaled $116,900, which includes the corresponding allowable administrative overhead charge of 3%. Repeat Finding: This is not a repeat finding. Recommendation: We recommend the City read and summarize grant requirements for all grants that the City participates in, as well as implementing controls over those grant requirements to prevent errors from occurring. Management’s Response: The City agrees that the absence of a structured data review and analysis process sufficient to fulfill reporting requirements creates a risk of noncompliance with federal statutes, regulations, and terms and conditions of the grant awards. The City will develop, document, and implement formal grant summary requirements review process and audit preparedness policy and procedures. The responsibilities, deliverables, and deadlines will be clearly outlined and communicated to all staff members. The City will remedy the customer account credit balances by October 2025. Management intends to review and adjust the customer account balances.

Corrective Action Plan

The City will develop, document, and implement formal grant summary requirements review process and audit preparedness policy and procedures. The responsibilities, deliverables, and deadlines will be clearly outlined and communicated to all staff members. The City will remedy the customer account credit balances by October 2025. Management intends to review and adjust the customer account balances.

Categories

Questioned Costs Allowable Costs / Cost Principles Reporting Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 554299 2024-001
    Significant Deficiency
  • 1130741 2024-001
    Significant Deficiency
  • 1130742 2024-002
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $4.74M
97.039 Hazard Mitigation Grant $802,910
16.922 Equitable Sharing Program $247,805
97.044 Assistance to Firefighters Grant $95,455
93.045 Special Programs for the Aging, Title Iii, Part C, Nutrition Services $91,683
20.600 State and Community Highway Safety $38,061
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $32,410
20.205 Highway Planning and Construction $22,378
93.053 Nutrition Services Incentive Program $22,334
93.044 Special Programs for the Aging, Title Iii, Part B, Grants for Supportive Services and Senior Centers $8,182
21.019 Coronavirus Relief Fund $6,917
45.310 Grants to States $2,938
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $262