Finding 1056776 (2022-006)

Material Weakness
Requirement
B
Questioned Costs
$1
Year
2022
Accepted
2024-08-04
Audit: 316559
Organization: City of Manteca (CA)

AI Summary

  • Core Issue: The City failed to document customer credit calculations and notifications, leading to non-compliance with grant requirements.
  • Impacted Requirements: Notifications to customers about credits and options for payment plans were not properly documented or retained.
  • Recommended Follow-Up: Generate reports from the billing system for accurate credit documentation and establish procedures to ensure compliance and proper record retention.

Finding Text

Finding #SA2022-006 Compliance with Grant Documentation Requirements Assistance Listing Number: 21.027 Assistance Listing Title: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Name of Federal Agency: Department of Treasury Pass Through Entity: California State Water Resources Control Board Federal Award Identification Number: 68-0281986 Criteria: The California Water and Wastewater Arrearage Payment Program Guidelines include the following requirements: • Section F.2.1, Notification of Customer Bill Credits, and Appendix A, Section 6.2.1, Notification of Customer Bill Credits require that the City notify water and wastewater customers, respectively, in writing of the amount credited. The acknowledgement must state that the credited amount is being provided through the California Water and Wastewater Arrearage Payment Program through funding from the State Water Resources Control Board using federal ARPA funds. • Section F.2.2, Payment Plans, requires that the City offer any residential and commercial water customers with remaining balances after the credits have been applied the option to enroll in a payment plan. The notice offering the payment plan must provide the customer with 30 days to enroll in the plan from the date of the notice. Condition: We selected forty-one customer credits (water and wastewater) for testing of the documentation of the date the credit was calculated and whether the notification included the required elements noted in the Guidelines. Although we understand the City calculated the customer arrearages and credits to be applied based on the total amount due from March 4, 2020 to June 15, 2021, City staff was unable to locate documentation to show the actual dates the credits were calculated for each customer and how the credits applied were calculated. We did note that the customers we tested had amounts due during the eligible period in excess of the credits applied. As for the notifications to the customers, City staff could not provide the notifications sent to the customers selected for testing. City staff did provide an example notification for a different water customer credit dated April 28, 2022 that included the required Notification and Payment Plan elements noted above. Cause: We understand that the documentation of how the customer credits were calculated, including the period covered by the credit, could not be located due to staff turnover and due to the approach of the adjustments being entered manually into the system by one staff member. In addition, we understand the notification letters to the individual customers were not retained – only the one example letter was retained in the City’s files. Questioned Costs: We question costs of $735,218, which consists of the amounts charged to the Arrearage Program, because we were unable to verify the dates the credits were calculated. Effect: The City is not in compliance with the terms and conditions of the California Arrearage Payment Programs related to Notification of Customer Credits and Payment Plans. Recommendation: The City should determine if reports can be generated from the utility billing system to show the amounts due from the customers during the eligible period of March 4, 2020 to June 15, 2021 and how the customer credits were calculated. In addition, the City must develop procedures to ensure compliance with all grant award terms and conditions and retain documentation to demonstrate such compliance until the grantor has closed-out the grant award program. View of Responsible Officials and Planned Corrective Actions: Please see Corrective Action Plan separately prepared by the City.

Categories

Questioned Costs

Other Findings in this Audit

  • 480327 2022-007
    Material Weakness Repeat
  • 480328 2022-008
    Material Weakness
  • 480329 2022-007
    Material Weakness Repeat
  • 480330 2022-008
    Material Weakness
  • 480331 2022-003
    Material Weakness
  • 480332 2022-004
    Significant Deficiency
  • 480333 2022-005
    Material Weakness
  • 480334 2022-006
    Material Weakness
  • 480335 2022-003
    Material Weakness
  • 480336 2022-004
    Significant Deficiency
  • 480337 2022-005
    Material Weakness
  • 480338 2022-006
    Material Weakness
  • 480339 2022-002
    Significant Deficiency
  • 1056769 2022-007
    Material Weakness Repeat
  • 1056770 2022-008
    Material Weakness
  • 1056771 2022-007
    Material Weakness Repeat
  • 1056772 2022-008
    Material Weakness
  • 1056773 2022-003
    Material Weakness
  • 1056774 2022-004
    Significant Deficiency
  • 1056775 2022-005
    Material Weakness
  • 1056777 2022-003
    Material Weakness
  • 1056778 2022-004
    Significant Deficiency
  • 1056779 2022-005
    Material Weakness
  • 1056780 2022-006
    Material Weakness
  • 1056781 2022-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
20.507 Federal Transit_formula Grants $1.66M
21.027 Coronavirus State and Local Fiscal Recovery Funds $735,218
14.218 Community Development Block Grants/entitlement Grants $359,800
97.083 Staffing for Adequate Fire and Emergency Response (safer) $146,104
20.205 Highway Planning and Construction $64,802
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $56,218
16.034 Coronavirus Emergency Supplemental Funding Program $53,798
20.616 National Priority Safety Programs $40,192
20.600 State and Community Highway Safety $37,825
16.738 Edward Byrne Memorial Justice Assistance Grant Program $29,993
97.044 Assistance to Firefighters Grant $3,091