Finding 20533 (2022-003)

Material Weakness
Requirement
M
Questioned Costs
-
Year
2022
Accepted
2023-03-29
Audit: 19296
Organization: City of Cambridge Massachusetts (MA)
Auditor: Kpmg LLP

AI Summary

  • Core Issue: The City lacks proper controls and documentation for monitoring subrecipients, risking noncompliance with federal requirements.
  • Impacted Requirements: Compliance with 2 CFR sections 200.332 and 200.303, including timely evaluations and audits of subrecipients.
  • Recommended Follow-Up: Implement a checklist or formal documentation process for reviewing subrecipient audit reports, effective by July 1, 2023.

Finding Text

Finding Number: 2022 003 Program: Emergency Solutions Grant Program (ESG) ALN #: 14.231 Federal Agency: Housing and Urban Development Federal Award Number: E 20 MC 25 005; E 20 MW 25 0005 Award Year: 7/1/2021 ? 6/30/2022 E 21 MC 25 0005 Subrecipient Monitoring Type of finding: Material Weakness Prior year finding: No Statistically valid sample: No Criteria The 2 CFR sections 200.332(d) through (f) provide the principles to be applied to monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, complies with the terms and conditions of the subaward, and achieves performance goals. According to 2 CFR 200.303, the non Federal entity must Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition The City does not have properly designed controls and documented procedures in place to ensure compliance with the following requirements: ? Each subrecipients risk of noncompliance is appropriately evaluated ? Monitoring activities over subrecipients are performed on a timely basis ? Verification that subrecipients are audited as required when they are expected to exceed the threshold for having a single audit. During our audit, we noted that audited financial statements were obtained for 5 of the 5 subrecipients selected for testing, but there was no documentation to evidence consideration of the compliance requirements indicated above. Cause The City requires that audited financial statements are obtained for subrecipients, but there is no checklist or formal documentation required to indicate what should be reviewed when reviewing the audit reports to ensure compliance with subrecipient monitoring requirements. Effect Lack of effective controls could result in the City?s noncompliance with program requirements. Questioned Costs None Recommendation We recommend the City establish a checklist or formal documentation requirements that employees can complete when obtaining subrecipient audit reports to ensure required monitoring procedures are performed and well documented. Views of Responsible Officials and Corrective Actions The City has established an Audit Review Certification form that will be completed by employees to formally document review of subrecipient agencies? audit reports. Implementation Date The City will implement use of the Audit Review Certification form as part of the ESG subrecipient application process for the FY24 program year beginning July 1, 2023. Responsible Officials Anthony Woods, Planner and Contract Manager; Liz Mengers Magargee, Planning and Development Manager

Corrective Action Plan

The City has established an Audit Review Certification form that will be completed by employees to formally document review of subrecipient agencies? audit reports.

Categories

Subrecipient Monitoring

Other Findings in this Audit

  • 20531 2022-001
    Material Weakness
  • 20532 2022-002
    Material Weakness
  • 20534 2022-001
    Material Weakness
  • 20535 2022-002
    Material Weakness
  • 20536 2022-003
    Material Weakness
  • 20537 2022-001
    Material Weakness
  • 20538 2022-002
    Material Weakness
  • 20539 2022-003
    Material Weakness
  • 20540 2022-004
    Material Weakness
  • 596973 2022-001
    Material Weakness
  • 596974 2022-002
    Material Weakness
  • 596975 2022-003
    Material Weakness
  • 596976 2022-001
    Material Weakness
  • 596977 2022-002
    Material Weakness
  • 596978 2022-003
    Material Weakness
  • 596979 2022-001
    Material Weakness
  • 596980 2022-002
    Material Weakness
  • 596981 2022-003
    Material Weakness
  • 596982 2022-004
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
14.239 Home Investment Partnerships Program $12.65M
21.027 Coronavirus State and Local Fiscal Recovery Funds $10.27M
14.267 Continuum of Care Program $5.50M
10.555 National School Lunch Program $3.04M
14.218 Community Development Block Grants/entitlement Grants $3.02M
14.241 Housing Opportunities for Persons with Aids $1.49M
84.010 Title I Grants to Local Educational Agencies $1.08M
10.553 School Breakfast Program $782,939
93.568 Low-Income Home Energy Assistance $606,534
97.067 Homeland Security Grant Program $400,827
84.002 Adult Education - Basic Grants to States $333,339
10.559 Summer Food Service Program for Children $252,567
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $222,120
84.367 Improving Teacher Quality State Grants $198,485
32.004 Universal Service Fund - Schools and Libraries $173,887
93.590 Community-Based Child Abuse Prevention Grants $126,947
84.425 Education Stabilization Fund $124,113
21.019 Coronavirus Relief Fund $122,324
84.365 English Language Acquisition State Grants $102,500
14.231 Emergency Solutions Grant Program $91,847
14.881 Moving to Work Demonstration Program $91,504
84.424 Student Support and Academic Enrichment Program $76,040
14.401 Fair Housing Assistance Program_state and Local $39,953
16.588 Violence Against Women Formula Grants $35,996
97.042 Emergency Management Performance Grants $31,470
84.048 Career and Technical Education -- Basic Grants to States $26,639
84.173 Special Education_preschool Grants $26,422
97.024 Emergency Food and Shelter National Board Program $19,892
84.027 Special Education_grants to States $12,151
84.196 Education for Homeless Children and Youth $10,961
10.649 Pandemic Ebt Administrative Costs $10,438
16.034 Coronavirus Emergency Supplemental Funding Program $9,765
16.922 Equitable Sharing Program $7,530
93.499 Low Income Household Water Assistance Program $4,541
84.371 Striving Readers $2,110