Finding 371110 (2023-002)

Significant Deficiency
Requirement
J
Questioned Costs
-
Year
2023
Accepted
2024-02-28
Audit: 292753
Organization: City of Redmond, Oregon (OR)

AI Summary

  • Core Issue: The City drew additional funds without using available program income first, violating CDBG guidelines.
  • Impacted Requirements: Program income, including interest, must be used before requesting additional treasury funds, especially when under $25,000.
  • Recommended Follow-Up: The City should assess year-end program income, calculate any applicable interest, and return excess funds to its line of credit.

Finding Text

Condition and criteria: The CDBG manual states that program income must be disbursed prior to the drawdown of additional funds of the treasury and there were some drawdowns of additional funds even though there is program income on hand. Program income also includes interest on cash on hand, but the City has not been allocating interest to the CDBG program. Cause: The City sets up activities for each project and program income is allocated as the funding source and when draws are done, they either go against program income or as a request for funds based on the particular project. If a project was set up later and does not have program income allocated as a funding source to spent out first, there will be a request for additional funds, even if there is program income on hand. Context and effect: The City has under $25,000 of program income remaining at fiscal year end, thus it is not considered material non-compliance. There is also an exception for allocating interest to program income when the total from all sources for the program is less than $25,000 but would be required if excess income exceeds that amount. Auditor's recommendation: We recommend that the City perform procedures at year end to determine whether it has excess program income on hand, calculate interest on cash on hand if applicable, and return any excess funds to its line of credit. Management response: Management agrees with the auditor's recommendation. The City has currently exhausted all program income on-hand and will perform year-end testing/monitoring around program income going forward.

Corrective Action Plan

Specific Steps to Correct: Management has already corrected how it records interest earned on CDBG cash on-hand. Management will review program income on-hand throughout the year to assess its responsibility to return funds to the line of credit. Anticipated Completion Date: Will incorporate the auditor's recommendation into year end processing for fiscal year 2024, which will occur around June 30, 2024. Name(s) and Title(s) of Responsible Person(s): James Wood, Finance Director

Categories

Subrecipient Monitoring Cash Management Program Income

Other Findings in this Audit

  • 371109 2023-001
    Significant Deficiency
  • 947551 2023-001
    Significant Deficiency
  • 947552 2023-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
20.106 Airport Improvement Program $2.03M
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $227,648
16.922 Equitable Sharing Program $53,455
14.218 Community Development Block Grants/entitlement Grants $40,707
20.616 National Priority Safety Programs $5,703
15.904 Historic Preservation Fund Grants-in-Aid $5,059
16.607 Bulletproof Vest Partnership Program $4,400
21.027 Coronavirus State and Local Fiscal Recovery Funds $2,750
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $2,630
20.600 State and Community Highway Safety $2,453