Finding 6202 (2023-001)

Material Weakness
Requirement
ABEH
Questioned Costs
-
Year
2023
Accepted
2023-12-21

AI Summary

  • Core Issue: UWMC failed to properly adjust prior year audit accruals, leading to inaccurate accounting for subrecipient agency expenditures.
  • Impacted Requirements: Internal controls over subawards were not effectively maintained, resulting in understated expenditures and payables.
  • Recommended Follow-Up: UWMC should implement cumulative reporting and conduct final reconciliations with subrecipient agencies before final payments in fiscal year 2024.

Finding Text

Criteria: United Way of Monterey County (“UWMC”) must establish and maintain effective internal controls over agencies receiving subawards of Federal funding passed through UWMC. This includes proper documentation and tracking of subrecipient agency expenditures and the resulting accruals for the amounts due to subrecipient agencies. Condition: Accounting for UWMC’s prior year audit accruals for subrecipient agency expenditures was not properly adjusted, based on the prior year audit adjustments. Accruals for the current year’s agency expenditures were not reconciled prior to the audit and required significant auditor assistance in the calculations to accurately state the accruals. Cause: During the single audit for the fiscal year ended June 30, 2022, audit adjustments were made to accrue for agency expenditures based on reconciliations with the agencies’ general ledgers. During that time UWMC had turnover in the finance department, so the details behind those adjustments and the subsequent year’s effects were not properly transitioned. During the fiscal year ended June 30, 2023, year end reconciliations and accruals were not done with the subrecipient agencies prior to the audit. Effect: Fiscal year 2023 expenditures were understated by approximately $213,000 as a result of the fiscal year 2022 accruals not being properly recorded. This resulted in amounts payable to subrecipient agencies and amounts receivable from Monterey County being understated by approximately $754,000. Additional audit adjustments were made to true up agency expenditures for the year ended June 30, 2023. These adjustments increased expenditures, agency payables and related Monterey County receivables by approximately $144,000. Recommendation: We recommend UWMC maintain cumulative reports of agency activities to agree each fiscal year’s expenditures to the finalized audit balances. This would ensure that proper documentation is in place for any transition of UWMC management. It is recommended that UWMC also perform a final reconciliation with the subrecipient agencies general ledger prior to issuing the final payment during the close of the program in fiscal year 2024. Management’s Response: We have been reconciling to subgrantee agency general ledgers each month before payment. But given prior period adjustments occasionally made on the agency side, we will make it a cumulative reconciliation going forward for monthly payment. UWMC will perform a final reconciliation with the subrecipient agencies general ledger during the close of the program in fiscal Year 2024. The finance department is keeping records of all adjustments and accruals that are reconciled monthly and during the close of the program in fiscal Year 2024.

Corrective Action Plan

The Emergency Rental Assistance Program was developed in response to the pandemic and was implemented swiftly to meet the needs of low-income tenants affected by Covid-19. The program design involves fourteen partner agencies and their varying accounting systems. In March 2021, UWMC began this emergency program with an existing system, the Smart Referral Network (SRN) software, which was adapted in order to quickly launch the program. In March of 2022, the SRN tool was replaced with a software system (Neighborly) more specifically designed to administer and report on ERAP. The new data system facilitates reconciliation to the detailed payment data. Management agrees that the expenditures for the reporting period were overstated and accepts the recommendation along with implementing the following corrective action. UWMC conducted a comprehensive reconciliation of program data to financial expenditure records of its partnering agencies through June 30, 2022. In the current fiscal year, all partnering agencies were required to submit program data through the online Neighborly software along with providing a general ledger report that supports and is reconciled to the data submitted prior to receiving reimbursement. We have been reconciling to subgrantee agency general ledgers each month before payment. But given prior period adjustments occasionally made on the agency side, we will make it a cumulative reconciliation going forward for monthly payment. UWMC will perform a final reconciliation with the subrecipient agencies’ general ledgers during the close of the program in Fiscal Year 2024. The finance department is keeping records of all adjustments and accruals that are reconciled monthly and during the close of the program in Fiscal Year 2024. The UWMC staff member overseeing these reconciliations with is: Danae Thomas VP, Finance Danae.Thomas@unitedwaymcca.org (831) 318-1991

Categories

Subrecipient Monitoring

Other Findings in this Audit

  • 582644 2023-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.023 Emergency Rental Assistance Program $8.13M
93.569 Community Services Block Grant $70,985
21.009 Volunteer Income Tax Assistance (vita) Matching Grant Program $52,624
94.006 Americorps $32,896