Finding 1136251 (2022-008)

Significant Deficiency
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2025-05-07

AI Summary

  • Core Issue: The Authority did not prepare an accurate Schedule of Expenditures of Federal Awards (SEFA) due to unperformed account reconciliations.
  • Impacted Requirements: This finding violates Uniform Guidance 2 CFR 200.510, which mandates accurate SEFA preparation.
  • Recommended Follow-Up: Ensure future SEFAs are prepared using grant documentation and reconcile amounts with the general ledger to meet compliance.

Finding Text

PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS - SIGNIFICANT DEFICIENCY Federal Program Community Development Block Grant/Entitlement Grant ALN 14.218; passed through the County of Berks HOME Investment Partnership Program ALN 14.239; passed through the County of Berks Emergency Rental Assistance ALN 21.023; passed through the County of Berks Criteria Per the Uniform Guidance 2 CFR 200.510, the auditee is required to prepare a schedule of expenditures of federal awards (SEFA). Condition The Authority provided information relating to the federal programs including grant agreements and other supporting documentation. However, the information prepared by the auditee required material adjustments as a result of audit procedures Cause Certain account reconciliations were not performed prior to the audit, which impacted amounts reported on the SEFA. Effect Amounts reported on the general ledger used to develop the SEFA were not accurate. The SEFA was subsequently updated through audit procedures, including inquiry and review of grant documentation of awards received and amounts expended. Questioned Costs None. Context Several adjustments were required in order for the schedule to accurately reflect the current year activity. Repeat Finding No. Recommendation In order to meet Uniform Guidance requirements, the Authority should prepare the SEFA from the grant award documentation and any other relevant information including the assistance listing numbers, grant award amounts, grant amounts received, grant amounts expended, and grant revenue recorded. The amounts reported in the SEFA should reconcile to the general ledger. Management Response See corrective action plan included in this report package.

Categories

Reporting Significant Deficiency

Other Findings in this Audit

  • 559792 2022-003
    Significant Deficiency Repeat
  • 559793 2022-003
    Significant Deficiency Repeat
  • 559794 2022-003
    Significant Deficiency Repeat
  • 559795 2022-003
    Significant Deficiency Repeat
  • 559796 2022-003
    Significant Deficiency Repeat
  • 559797 2022-005
    Significant Deficiency Repeat
  • 559798 2022-006
    Significant Deficiency
  • 559799 2022-006
    Significant Deficiency
  • 559800 2022-006
    Significant Deficiency Repeat
  • 559801 2022-007
    Material Weakness
  • 559802 2022-007
    Material Weakness
  • 559803 2022-007
    Material Weakness
  • 559804 2022-007
    Material Weakness
  • 559805 2022-008
    Significant Deficiency
  • 559806 2022-008
    Significant Deficiency
  • 559807 2022-008
    Significant Deficiency
  • 559808 2022-008
    Significant Deficiency
  • 559809 2022-008
    Significant Deficiency
  • 1136234 2022-003
    Significant Deficiency Repeat
  • 1136235 2022-003
    Significant Deficiency Repeat
  • 1136236 2022-003
    Significant Deficiency Repeat
  • 1136237 2022-003
    Significant Deficiency Repeat
  • 1136238 2022-003
    Significant Deficiency Repeat
  • 1136239 2022-005
    Significant Deficiency Repeat
  • 1136240 2022-006
    Significant Deficiency
  • 1136241 2022-006
    Significant Deficiency
  • 1136242 2022-006
    Significant Deficiency Repeat
  • 1136243 2022-007
    Material Weakness
  • 1136244 2022-007
    Material Weakness
  • 1136245 2022-007
    Material Weakness
  • 1136246 2022-007
    Material Weakness
  • 1136247 2022-008
    Significant Deficiency
  • 1136248 2022-008
    Significant Deficiency
  • 1136249 2022-008
    Significant Deficiency
  • 1136250 2022-008
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.023 Emergency Rental Assistance Program $24.21M
14.231 Emergency Solutions Grant Program $387,284
14.239 Home Investment Partnerships Program $302,081
14.218 Community Development Block Grants/entitlement Grants $269,207