Finding 1072620 (2022-001)

Significant Deficiency
Requirement
AB
Questioned Costs
$1
Year
2022
Accepted
2023-03-23
Audit: 319093
Organization: City of Beverly Hills (CA)
Auditor: Crowe LLP

AI Summary

  • Core Issue: The City incorrectly applied the pandemic relief cutoff date, leading to ineligible payments for water and wastewater bills.
  • Impacted Requirements: Costs must meet federal criteria for allowability, including being necessary, reasonable, and documented, as per 2 CFR Part 200.
  • Recommended Follow-Up: Implement stronger internal controls to verify eligibility periods for funding before disbursement and establish a multi-layered approval process.

Finding Text

Finding 2022-001- Activities Allowed or Unallowed, Allowable Costs- Significant Deficiency Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listing No.: 21.027 Federal Agency: Department of the Treasury ? Pass-through from the State of California Award No.: WWID 4SSO10370 & CA 1910156 Award Year: Fiscal year 2021-2022 Category of Finding: Activities Allowed or Unallowed, Allowable Costs Criteria or Specific Requirement: Allowable Costs - 2 CFR Part 200.403 Factors affecting allowability of costs except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. (c) Be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the non-Federal entity. (d) Be accorded consistent treatment. A cost may not be assigned to a Federal award as a direct cost if any other cost incurred for the same purpose in like circumstances has been allocated to the Federal award as an indirect cost. (e) Be determined in accordance with generally accepted accounting principles (GAAP), except, for state and local governments and Indian tribes only, as otherwise provided for in this part. (f) Not be included as a cost or used to meet cost sharing or matching requirements of any other federally-financed program in either the current or a prior period. See also ? 200.306(b). (g) Be adequately documented. See also ?? 200.300 through 200.309 of this part. (h) Cost must be incurred during the approved budget period. The Federal awarding agency is authorized, at its discretion, to waive prior written approvals to carry forward unobligated balances to subsequent budget periods pursuant to ? 200.308(e)(3). Per California Water and Wastewater Arrearage Payment Program Guidelines amended on January 19, 2022, providers that accrued residential and commercial customer arrearages during the COVID-19 pandemic bill relief period (March 4, 2020 through June 15, 2021) are eligible for the water and wastewater arrearages funding. In addition, 2 CFR 200.303 requires nonfederal entities to, among other things, establish and maintain effective internal control over the federal award that provides reasonable assurance that the nonfederal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition: The City did not have an effective system of internal control in place to ensure the correct COVID-19 pandemic relief period was applied to identify eligible customers to have their bills paid with federal grant funds. Context: Crowe selected a total of 60 payment transactions, consisting of 30 water bills and 30 wastewater bills that were included in the arrearage program. We noted that one of the water bills selected for testing had a service date from June 28, 2021 in the amount $77.88. Upon further discussion with City management we noted the City applied the incorrect pandemic relief period to the program. Instead of a date of June 15, 2021, the City was using June 30, 2021 as the cutoff date. Management subsequently reviewed the entire population of the bills and quantified that there were 93 water bills with aggregate amount of $20,199 and 81 wastewater bills with aggregate amount of $15,331 ineligible for the funding. Cause: The City applied the incorrect pandemic relief period to the program. Instead of a date of June 15, 2021, the City was using June 30, 2021 as the cutoff date. Effect or Potential Effect: There were 93 water bills with totaled amount of $20,199 and 81 wastewater bills with totaled amount of $15,331 ineligible for the funding. Questioned Costs: $35,530 Identification of a repeat finding: Not a repeat finding. Recommendation: We recommend that the City implement internal controls to review the eligibility period for water and wastewater arrearages funding to identify the correct eligible applicants prior to disbursement. Views of Responsible Officials: Payments applied to the 93 water bills and 81 wastewater bills will be reversed on the customer?s accounts. A notice will be issued to customers via mail and email (where possible) of the discrepancy. The funds will be returned to the State pursuant to their outlined procedures. Moving forward, the City will ensure that there is a multi-layered approval process to review the eligibility period of any State funding to identify the correct eligible applicants prior to disbursement. For future funding related to water and/or waster bills, the list of eligible applicants will be compiled by an analyst within the department and will be reviewed by the Revenue Services Manager and Assistant Finance Director prior to disbursement.

Categories

Questioned Costs Matching / Level of Effort / Earmarking Allowable Costs / Cost Principles Eligibility

Other Findings in this Audit

  • 496178 2022-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.04M