Finding 504520 (2023-006)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-11-04

AI Summary

  • Core Issue: There is a significant discrepancy of $14,966,519 in grant reporting due to missing entries in the Administrative and Performance Reports for February and March 2023.
  • Impacted Requirements: This discrepancy affects the accuracy of performance monitoring by PRDOH, as the cumulative total of grants awarded is incorrect.
  • Recommended Follow-Up: The Bank should reconcile grant figures with the accounting system to ensure accurate reporting and improve monthly tracking of CDBG-DR fund activities in the general ledger.

Finding Text

• Monthly Reporting We compared the amount of grants awarded as per the Administrative and Performance Reports submitted to the Puerto Rico Deparment of Housing (PRDOH) with the amount reported in the Schedule of Expenditures and Federal Awards as of June 30, 2023. We noted a difference of $14,966,519 due to grants awarded in February 2023 and March 2023 that were not reflected in the Administrative and Performance Reports. This caused a discrepancy in the cumulative actual total amount of grants awarded for the year that impacts the results in the monitoring of performance by PRDOH. The Bank needs to reconcile the figures with the accounting system to confirm the information for the period is properly reflected in the Administrative and Performance Reports before the submission of the report to ensure the monitoring performed by PRDOH is based on correct and reliable information. • Accounting Records and Reconciliations In relation to the CDBG-DR Fund, although disbursements are recorded in a separate fund, the Bank does not present, on a monthly basis, the revenues, expenses, assets, and liabilities in the Bank’s general ledger. Instead, the Bank is recording the transactions as revenues, expenses, assets, and liabilities related to the CDBG-DR fund at year end. The CDBG-DR fund activity is monitored in another system that is maintained parallel to the Bank’s general ledger. This additional system is used for the reporting process but is not monitored and reconciled jointly with the Bank’s general ledger. Entity level controls related to monthly approvals, reconciliations, actual versus budget comparisons, and other financial reporting controls are performed in another system that does not make automatic interface with the Bank’s general ledger.

Corrective Action Plan

Management agrees with this finding. The presentation of the CDBG-DR fund was caused by the significant time and effort that requires the accounting of the new fund and the understaffing of the accounting department. Management is making arrangements to modify accounting system and procedures to ascertain all transactions related to the CDBG-DR Fund are presented in the Bank's general ledger on a monthly basis. Also, the Bank is working toward recruiting additional personnel for the accounting department.

Categories

Reporting Subrecipient Monitoring

Other Findings in this Audit

  • 504516 2023-002
    Material Weakness Repeat
  • 504517 2023-003
    Significant Deficiency Repeat
  • 504518 2023-004
    Significant Deficiency Repeat
  • 504519 2023-005
    Significant Deficiency
  • 504521 2023-007
    Significant Deficiency Repeat
  • 1080958 2023-002
    Material Weakness Repeat
  • 1080959 2023-003
    Significant Deficiency Repeat
  • 1080960 2023-004
    Significant Deficiency Repeat
  • 1080961 2023-005
    Significant Deficiency
  • 1080962 2023-006
    Material Weakness Repeat
  • 1080963 2023-007
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $82.69M