Finding 28868 (2022-003)

Significant Deficiency
Requirement
LP
Questioned Costs
-
Year
2022
Accepted
2023-03-30
Audit: 25588
Organization: City of Concord (CA)

AI Summary

  • Core Issue: The City reported inflated program expenditures in the PR26 report, which could lead to non-compliance with financial reporting requirements.
  • Impacted Requirements: The City failed to reconcile reported amounts with the SEFA and could not locate essential Funding/Approval Agreements.
  • Recommended Follow-Up: Implement procedures for accurate financial reporting, ensure retention of grant documentation, and obtain necessary agreements to comply with program terms.

Finding Text

Finding Reference Number: SA2022-003 - Financial Reporting and Retention of Grant Documentation Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grant ? Entitlement Grant COVID-19 - Community Development Block Grants/ Entitlement Grants-CV Name of Federal Agency: Department of Housing and Urban Development Federal Award Identification Number: B-21-MC-06-0009 COVID-19 ? BC-20-MW-06-0009 Criteria: Grantees may include reports generated by Integrated Disbursement and Information System (IDIS) as part of their annual performance and evaluation report that must be submitted for the CDBG Entitlement program 90 days after the end of a grantee?s program year. The reports to be included in the annual performance and evaluation report include the PR26 ? CDBG Financial Summary Report and the PR26 ? CDBG-CV Financial Summary Report. The reports should include accurate information and reconcile to the amounts reported on the SEFA. In addition, one component of the PR26 ? CDBG Financial Summary Report (line 02) and the PR26 ? CDBG-CV Financial Summary Report (line 01) is the grant award amount. That information is directly from the City?s annual Funding Approval/Agreement. Condition: We obtained the City?s PR26 ? CDBG Financial Summary Report for program year 2021 (fiscal year ended June 30, 2022), which reported program expenditures of $1,927,639. We requested a reconciliation of that amount on the PR26 to the program expenditures reported on the SEFA of $963,820, but City staff could not reconcile the amounts reported. It appears that the program expenditures in the PR26 ? CDBG Financial Summary Report were doubled, as the amount on the SEFA is exactly half of that amount. We were not able to test the components of the PR26 ? CDBG-CV Financial Summary Report for fiscal year 2022, because City staff did not retain a copy of the report and was not able to extract a copy from the Integrated Disbursement and Information System (IDIS). Finally, City staff was not able to locate copies of the Funding/Approval Agreements for CDBG and CDBG-CV for the periods starting July 1, 2021 and June 30, 2020, respectively. Those Agreements not only contain the grant award amount, they include special award terms and conditions. Cause: We understand that City staff had worked with the grantor to make corrections to the PR26 ? CDBG Financial Summary Report, but could not provide us with documentation to show that the corrections made were related to the program expenditures. For the PR26 ? CDBG-CV Financial Summary Report, we understand City staff did not retain a copy of the report and were unable to generate a copy of the report from the IDIS system. For the Funding/Approval Agreements, due to staff turnover, City staff could not locate copies of the award agreements. Effect: The City is not in compliance with the financial reporting requirements of the CDBG Program and may not be in compliance with special award terms and conditions of the program. Recommendation: The City should develop procedures to ensure that financial reports filed in the IDIS system reconcile with general ledger activity and amounts reported on the SEFA. The City should also ensure that grant reports and grant award information is retained in the City?s files. Finally, the City should obtain copies of the Funding/Approval Agreements for the program to ensure that it is aware of all special award terms and conditions. View of Responsible Officials and Planned Corrective Actions: Please see Corrective Action Plan separately prepared by the City.

Corrective Action Plan

Finding Reference Number: SA2022-003 - Financial Reporting and Retention of Grant Documentation Assistance Listing Number: 14.218 Assistance Listing Title: Community Development Block Grant ? Entitlement Grant COVID-19 - Community Development Block Grants/ Entitlement Grants-CV Name of Federal Agency: Department of Housing and Urban Development Federal Award Identification Number: B-21-MC-06-0009 COVID-19 ? BC-20-MW-06-0009 ? Fiscal Year of Initial Finding: 2022 ? Name(s) of the contact person: Leng Powers ? Corrective Action Plan: The City will develop procedures to ensure that the PR26 ties to the general ledger before submission and the City will retain all future PR 26 reports in a centralized location in the City?s files. In addition, the City will retain all future CDBG agreements in a centralized location in the City?s files. ? Anticipated Completion Date: April 30, 2023

Categories

Reporting

Other Findings in this Audit

  • 28866 2022-001
    Significant Deficiency
  • 28867 2022-002
    Significant Deficiency
  • 28869 2022-002
    Significant Deficiency
  • 28870 2022-003
    Significant Deficiency
  • 605308 2022-001
    Significant Deficiency
  • 605309 2022-002
    Significant Deficiency
  • 605310 2022-003
    Significant Deficiency
  • 605311 2022-002
    Significant Deficiency
  • 605312 2022-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $5.67M
14.218 Community Development Block Grants/entitlement Grants $1.39M
20.205 Highway Planning and Construction $1.06M
14.218 Covid-19 - Community Block Developement $138,083
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $54,142
20.600 State and Community Highway Safety $20,522
16.922 Equitable Sharing Program $4,879
16.738 Edward Byrne Memorial Justice Assistance Grant Program $3,316