Finding 517211 (2024-003)

Significant Deficiency Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2024-12-30
Audit: 335174
Organization: Springfield Housing Authority (MA)

AI Summary

  • Core Issue: The Authority failed to report $735,922 in federal awards and had a $689,366 discrepancy in another program, leading to an understatement of total federal expenditures by $1,425,288.
  • Impacted Requirements: The Authority did not comply with the requirement to prepare a complete SEFA as per §200.502, resulting in a repeat finding from the previous year.
  • Recommended Follow-Up: Verify grant expenditures against general ledger balances before submitting the Financial Data Schedule, and continue using external accounting services to ensure accuracy.

Finding Text

Criteria - The Authority must prepare a SEFA for the period covered by the Authority’s financial statements which must include the total Federal awards expended by individual Assistance Listing number as determined in accordance with §200.502 Basis for determining Federal awards expended. Condition - The Authority did not include $735,922 related to the Project-Based Rental Assistance (Assistance Listing No. 14.195) grant in its SEFA for the year ended March 31, 2024. The Authority also had a variance of $689,366 in its Public Housing Capital Fund Program (Assistance Listing No. 14.872) between the SEFA and the amount reported for audit. Cause - The Authority’s year-end closing and financial reporting procedures were not sufficient to ensure accurate financial reporting. Effect - The total expenditures of federal awards were understated by $1,425,288. Statistical Sampling - The sample was not intended to be, and was not, a statistically valid sample. Questioned Costs - None identified. Repeat Finding - This is a repeat of finding 2023-004 as reported in the prior year. Recommendation - We recommend verifying the total amount of expenditures on an individual grant basis per review of the general ledger account balances prior to submitting the unaudited Financial Data Schedule (FDS). Management’s Response - (3) Finding 2024-003 (a) Comments on the finding and recommendation - The Authority agrees with the finding. The Authority also agrees with the recommendations, please see below for action taken. (b) Action taken - The Authority will continue to utilize Marcum LLP to provide ongoing fee accounting services to incorporate the recommendations listed above on a monthly basis. A comprehensive year-end checklist will continue to be utilized to ensure all general ledger activity is accurate to the underlying support. (c) Planned implementation date of corrective action - Completed by March 31, 2025.

Corrective Action Plan

Name of Auditee: Springfield Housing Authority Name of Audit Firm: EFPR Group, CPAs, PLLC Period Covered by the Audit: March 31, 2024 CAP Prepared by: Denise Jordan, Executive Director Phone: (413) 785-4500 (A) Current Findings on the Schedule of Findings and Questioned Costs (3) Finding 2024-003 (a) Comments on the finding and recommendation - The Authority agrees with the finding. The Authority also agrees with the recommendations, please see below for action taken. (b) Action taken - The Authority will continue to utilize Marcum LLP to provide ongoing fee accounting services to incorporate the recommendations listed above on a monthly basis. A comprehensive year-end checklist will continue to be utilized to ensure all general ledger activity is accurate to the underlying support. (c) Planned implementation date of corrective action - Completed by March 31, 2025.

Categories

Reporting HUD Housing Programs

Other Findings in this Audit

  • 517212 2024-002
    Significant Deficiency Repeat
  • 517213 2024-002
    Significant Deficiency Repeat
  • 517214 2024-003
    Significant Deficiency Repeat
  • 517215 2024-004
    Significant Deficiency
  • 517216 2024-002
    Significant Deficiency Repeat
  • 517217 2024-002
    Significant Deficiency Repeat
  • 517218 2024-002
    Significant Deficiency Repeat
  • 1093653 2024-003
    Significant Deficiency Repeat
  • 1093654 2024-002
    Significant Deficiency Repeat
  • 1093655 2024-002
    Significant Deficiency Repeat
  • 1093656 2024-003
    Significant Deficiency Repeat
  • 1093657 2024-004
    Significant Deficiency
  • 1093658 2024-002
    Significant Deficiency Repeat
  • 1093659 2024-002
    Significant Deficiency Repeat
  • 1093660 2024-002
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
14.850 Public Housing Operating Fund $12.95M
14.872 Public Housing Capital Fund $6.23M
14.195 Project-Based Rental Assistance (pbra) $735,922
14.879 Mainstream Vouchers $269,058
14.871 Section 8 Housing Choice Vouchers $101,646
14.870 Resident Opportunity and Supportive Services - Service Coordinators $89,169
14.249 Section 8 Moderate Rehabilitation Single Room Occupancy $40,515