Finding 1238734 (2024-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2026-09-30
Audit: 413657
Organization: Schertz Housing Authority (TX)

AI Summary

  • Core Issue: The Schertz Housing Authority failed to reconcile its Voucher Management System (VMS) submissions with the general ledger, leading to significant discrepancies in financial reporting.
  • Impacted Requirements: This finding violates HUD's requirement for accurate reporting and reconciliation, as well as the Uniform Guidance on internal controls over federal awards.
  • Recommended Follow-Up: The Authority should collaborate with their fee accountant to ensure financial records align with VMS submissions and address discrepancies promptly.

Finding Text

ALN Number: 14.871 Name of Federal Agency: U.S. Department of Housing & Urban Development Type of Finding – Single Audit Material Weakness in Internal Control Over Financial Reporting Criteria: HUD requires that public housing authorities accurately report program activity in the Voucher Management System (VMS) and reconcile these submissions to the general ledger (GL) on a monthly basis. The Uniform Guidance (2 CFR 200.303) requires non-federal entities to establish and maintain effective internal control over federal awards, including accurate financial reporting and reconciliation processes. Condition The Schertz Housing Authority did not properly track and reconcile its monthly VMS submissions to the general ledger. As a result, there were material discrepancies between the VMS-reported data and the HCV program’s financial statements, specifically related to income and restricted equity. Cause and Effect: The Authority did not follow their formal procedures to ensure that VMS submissions were reconciled to the general ledger each month. Material discrepancies existed in the HCV program’s financial statements, affecting reported income and restricted equity. Additionally, these discrepancies contributed to the Authority experiencing a funding shortfall in the HCV program by year-end, increasing the risk of questioned costs and noncompliance with HUD requirements. Recommendation: We recommend that the Schertz Housing Authority should work with their fee accountant to ensure that the financial records agree to the VMS submissions to the general ledger. View of Responsible Officials and Planned Corrective Action: We are working with our HUD field office to correct our VMS reporting. Responsible Official: Cristi LaJeunesse, Executive Director

Corrective Action Plan

We are working with our HUD field office to correct our VMS reporting.

Categories

HUD Housing Programs Material Weakness Reporting Matching / Level of Effort / Earmarking

Programs in Audit

ALN Program Name Expenditures
14.871 SECTION 8 HOUSING CHOICE VOUCHERS $1.52M
14.850 PUBLIC AND INDIAN HOUSING $221,407
14.872 PUBLIC HOUSING CAPITAL FUND $167,572