Finding No.: 2025-016 Identification of Federal Program: Federal Agency: U.S. Department of Housing and Urban Development (HUD) AL Program: 14.850 Public Housing Operating Fund Federal Award No.: GQ00100000125D, GQ00100000225D, GQ00100000325D, GQ00100000425D Area: Special Tests and Provisions – UEL (Utility Expense Level) Formula Criteria or specific requirement (including statutory, regulatory or other citation): GHURA is required to maintain and annually submit the Utility Expense Level (UEL) Formula Report (HUD Form 52722) for each project to HUD. 24 CFR 990.170(f)(1) states: 1. Appropriate utility records, satisfactory to HUD, shall be developed and maintained, so that consumption and rate data can be determined. 2 CFR 200.303 requires the implementation and monitoring of effective internal controls to provide reasonable assurance that data reported to HUD is accurate, complete, and compliant with Federal requirements. Condition: We examined the 4 reports required to be submitted during the fiscal year. For eight (14%) of total 56 key line reporting items required for testing within the Utility Expense Level (UEL) Formula Report (HUD Form 52722), the amounts were inconsistent from prior audited report submissions as follows: Item No. Project Line No. Utility Expense Level Formula Reported Utilities Reported Amount Per Audited Submission Variance Over (Under) Reported Variance Over (Under) Reported (%) 1 GQ001000001 03 Water and Sewer (Gal) 8,874 8,035 839 9% 2 GQ001000001 04 Water and Sewer (Gal) 5,647 6,486 (839) 15% 3 GQ001000002 03 Water and Sewer (Gal) 410,885 374,845 36,040 9% 4 GQ001000002 04 Water and Sewer (Gal) 383,707 419,747 (36,040) 9% 5 GQ001000003 03 Water and Sewer (Gal) 1,824,296 1,671,242 153,054 8% 6 GQ001000003 04 Water and Sewer (Gal) 2,719,307 2,872,361 (153,054) 6% 7 GQ001000003 03 Water and Sewer (Gal) 3,585,789 3,094,259 491,530 14% 8 GQ001000004 04 Water and Sewer (Gal) 2,663,490 3,155,020 (491,530) 18% Finding No.: 2025-016, continued Condition, continued: For items #s 1 and 2, the Asset Management Project (AMP) 1 reported in excess of amounts for key line items in Rolling base year 2 - actual consumption (12- month period 7/1/2021 to 6/30/2022) for water and sewer gallon consumption, and underreported for Rolling base year 3 - actual consumption (12-month period 7/1/2020 to 6/30/2021) for water gallon consumption than prior year amounts as reported on HUD Form 5722, respectively. For items #s 2 through 4, the Asset Management Project (AMP) 2 reported in excess of amounts for key line items in Rolling base year 2 - actual consumption (12- month period 7/1/2021 to 6/30/2022) for water and sewer gallon consumption, and underreported for Rolling base year 3 - actual consumption (12-month period 7/1/2020 to 6/30/2021) for water gallon consumption than prior year amounts as reported on HUD Form 5722, respectively. For items #s 3 through 6, the Asset Management Project (AMP) 3 reported in excess of amounts for key line items in Rolling base year 2 - actual consumption (12- month period 7/1/2021 to 6/30/2022) for water and sewer gallon consumption, and underreported for Rolling base year 3 - actual consumption (12-month period 7/1/2020 to 6/30/2021) for water gallon consumption than prior year amounts as reported on HUD Form 5722, respectively. For items #$ 7 and 8, the Asset Management Project (AMP) 4 reported in excess of amounts for key line items in Rolling base year 2 - actual consumption (12- month period 7/1/2021 to 6/30/2022) for water and sewer gallon consumption, and underreported for Rolling base year 3 - actual consumption (12-month period 7/1/2020 to 6/30/2021) for water gallon consumption than prior year amounts as reported on HUD Form 5722, respectively. Cause: Management did not implement adequate procedures to agree corrections on the Utility Expense Level (UEL) reporting submissions with underlying utility consumption and cost records prior to submission to HUD. In addition, supervisory review procedures were not sufficient to identify discrepancies, omissions, or reporting-period errors in the data accumulated for UEL reporting purposes. Effect or potential effect: GHURA is in noncompliance with applicable special tests and provisions for UEL Formula requirements. Questioned costs: $0 Finding No.: 2025-016, continued Identification as a repeat finding: Not applicable. Recommendation: Management should implement formal procedures to reconcile UEL reporting submissions to underlying utility consumption and cost records prior to submission to HUD. This should include preparing documented roll-forward reconciliations that ensure current-year reported amounts agree with prior submissions and are accurately carried forward. In addition, management should strengthen supervisory review controls by requiring an independent review of compiled UEL data to verify completeness, accuracy, and proper reporting period classification, with evidence of review retained. Views of Responsible Officials: Management did not provide a response to the finding. The finding was not included in management’s corrective action plan.