Finding 613009 (2022-001)

Significant Deficiency
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2023-07-25

AI Summary

  • Core Issue: Bank reconciliations as of September 30, 2022, were not aligned with the general ledger, leading to an understatement of cash balances by $54,588.
  • Impacted Requirements: Monthly bank reconciliations must be completed for each account and matched to the general ledger to ensure accuracy.
  • Recommended Follow-Up: Revise procedures to include proper documentation of intercompany accounts and ensure all reconciling items are recorded monthly to mitigate risks.

Finding Text

Bank Reconciliation Condition: The bank reconciliations performed as of September 30, 2022 were not reconciled to the general ledger. Criteria: Bank reconciliations should be prepared at the end of each month, for each bank account and agreed to the general ledger. Cause: Transfers of cash between bank accounts were not properly reconciled at the end of the fiscal year. Effect: The combined bank reconciliations balances exceeded the general ledger cash balance by $54,588 as of September 30, 2022. As a result, the overall cash balance is understated. Recommendation: I recommend that bank reconciliations should be reconciled to the general ledger on a monthly basis and proper due to and due from accounts be established to account for the transfers. Performing these procedures will reduce the risk of an overdrawn or overstated bank balance, during the fiscal year. Views of Responsible Officials and Planned Corrective Actions: Springfield MHA will revise standard operating procedures so that bank reconciliations for the month of September of each fiscal year-ended September 30 will reflect balances in intercompany accounts receivables and intercompany accounts payables reported in accordance with HUD Accounting Brief 14 on the Financial Data Schedule as reconciling items on the bank reconciliations. For this fiscal year-end September 30, 2022, the reporting of such balances in accordance with HUD Accounting Brief 14 was only documented on trial balance worksheets that document mapping between trial balance numbers and the Financial Data Schedule. In addition, the Authority will implement controls to ensure all reconciling items are clearly documented on bank reconciliations performed monthly.

Categories

HUD Housing Programs Reporting

Other Findings in this Audit

  • 36567 2022-001
    Significant Deficiency
  • 36568 2022-002
    Significant Deficiency
  • 36569 2022-003
    Significant Deficiency
  • 36570 2022-004
    Significant Deficiency
  • 613010 2022-002
    Significant Deficiency
  • 613011 2022-003
    Significant Deficiency
  • 613012 2022-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
14.871 Section 8 Housing Choice Vouchers $4.34M
14.850 Public and Indian Housing $3.04M
14.872 Public Housing Capital Fund $662,750
14.879 Mainstream Vouchers $154,203
14.238 Shelter Plus Care $113,555
14.870 Resident Opportunity and Supportive Services - Service Coordinators $59,864
14.896 Family Self-Sufficiency Program $19,230