Finding 577114 (2022-008)

- Repeat Finding
Requirement
N
Questioned Costs
-
Year
2022
Accepted
2023-10-25
Audit: 1234
Organization: Indianapolis Housing Agency (IN)
Auditor: Somerset CPAS

AI Summary

  • Core Issue: Monthly VMS reporting is not reconciling with the trial balance, leading to an overstatement of HAP expenses by $3,530,690.
  • Impacted Requirements: Compliance with HUD-52681-B submission is compromised due to inadequate internal controls and lack of reconciliation.
  • Recommended Follow-Up: Implement regular reconciliations of VMS reporting to the trial balance to ensure accurate data submission.

Finding Text

Criteria: HUD-52681-B is required to be submitted monthly electronically via the VMS. HUD relies on the audit of these key line items below to determine the reasonableness of the data submitted for the purpose of calculating funding under the program. Condition and Context: We obtained a summary of monthly VMS reporting from management noting that the key line items were unable to be reconciled to the trial balance by management. Specifically, HAP expenses reported on the trial balance are overstated by $3,530,690 relative to the HUD reporting. Cause and Effect: As described in 2022-001, the Agency has not maintained appropriate internal controls over compliance. Lack of regular reconciliation of HAP expenses to the HUD reporting referenced above resulted in the inability to reconcile at year end. Recommendation: We recommend that monthly VMS reporting be reconciled to the trial balance to ensure accurate reporting. This is a repeat finding of 2021-010. Views of Responsible Officials and Planned Corrective Actions: The Agency agrees with the recommendation. See the Corrective Action Plan for the Agency’s response and planned completion date.

Categories

HUD Housing Programs Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 659 2022-003
    Material Weakness Repeat
  • 660 2022-004
    -
  • 661 2022-005
    Material Weakness Repeat
  • 662 2022-006
    - Repeat
  • 663 2022-007
    -
  • 664 2022-008
    - Repeat
  • 665 2022-009
    -
  • 666 2022-010
    -
  • 667 2022-003
    Material Weakness Repeat
  • 668 2022-004
    -
  • 669 2022-005
    Material Weakness Repeat
  • 670 2022-006
    - Repeat
  • 671 2022-007
    -
  • 672 2022-008
    - Repeat
  • 577101 2022-003
    Material Weakness Repeat
  • 577102 2022-004
    -
  • 577103 2022-005
    Material Weakness Repeat
  • 577104 2022-006
    - Repeat
  • 577105 2022-007
    -
  • 577106 2022-008
    - Repeat
  • 577107 2022-009
    -
  • 577108 2022-010
    -
  • 577109 2022-003
    Material Weakness Repeat
  • 577110 2022-004
    -
  • 577111 2022-005
    Material Weakness Repeat
  • 577112 2022-006
    - Repeat
  • 577113 2022-007
    -

Programs in Audit

ALN Program Name Expenditures
14.871 Section 8 Housing Choice Vouchers $60.27M
14.872 Public Housing Capital Fund $2.27M
14.850 Public and Indian Housing $1.73M
14.879 Mainstream Vouchers $529,342
14.231 Emergency Solutions Grant Program $196,547
14.896 Family Self-Sufficiency Program $133,418