Finding 517200 (2023-004)

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

AI Summary

  • Core Issue: The Authority failed to include $833,469 in federal awards in the SEFA for the fiscal year ended March 31, 2023.
  • Impacted Requirements: This omission violates the requirement to report total federal awards expended by individual Assistance Listing numbers.
  • Recommended Follow-Up: Verify expenditures on a grant-by-grant basis before submitting the Financial Data Schedule, and implement a year-end checklist for 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 $114,639 related to the Emergency Housing Vouchers (Assistance Listing No. 14.871) grant and $718,830 related to the Project-Based Rental Assistance (Assistance Listing No. 14.195) grant in its SEFA for the fiscal year ended March 31, 2023. 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 $888,252. Statistical Sampling - The sample was not intended to be, and was not, a statistically valid sample. Questioned Costs - None identified. Repeat Finding - This is not a repeat finding. 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 - (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, 2023 CAP Prepared by: Denise Jordan, Executive Director Phone: (413) 785-4500 (A) Current Findings on the Schedule of Findings and Questioned Costs (4) Finding 2023-004 (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

Other Findings in this Audit

  • 517199 2023-003
    Significant Deficiency
  • 517201 2023-003
    Significant Deficiency
  • 517202 2023-003
    Significant Deficiency
  • 517203 2023-002
    Significant Deficiency
  • 517204 2023-003
    Significant Deficiency
  • 517205 2023-004
    Significant Deficiency
  • 517206 2023-002
    Significant Deficiency
  • 517207 2023-003
    Significant Deficiency
  • 517208 2023-004
    Significant Deficiency
  • 517209 2023-002
    Significant Deficiency
  • 517210 2023-003
    Significant Deficiency
  • 1093641 2023-003
    Significant Deficiency
  • 1093642 2023-004
    Significant Deficiency
  • 1093643 2023-003
    Significant Deficiency
  • 1093644 2023-003
    Significant Deficiency
  • 1093645 2023-002
    Significant Deficiency
  • 1093646 2023-003
    Significant Deficiency
  • 1093647 2023-004
    Significant Deficiency
  • 1093648 2023-002
    Significant Deficiency
  • 1093649 2023-003
    Significant Deficiency
  • 1093650 2023-004
    Significant Deficiency
  • 1093651 2023-002
    Significant Deficiency
  • 1093652 2023-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
14.850 Public Housing Operating Fund $11.28M
14.872 Public Housing Capital Fund $2.90M
14.195 Project-Based Rental Assistance (pbra) $773,613
14.879 Mainstream Vouchers $258,572
14.871 Section 8 Housing Choice Vouchers $114,639
14.870 Resident Opportunity and Supportive Services - Service Coordinators $81,816
14.249 Section 8 Moderate Rehabilitation Single Room Occupancy $38,675