Finding 402455 (2023-005)

Material Weakness
Requirement
M
Questioned Costs
-
Year
2023
Accepted
2024-06-26
Audit: 309973
Organization: City of Cambridge Massachusetts (MA)
Auditor: Kpmg

AI Summary

  • Core Issue: The City lacks effective controls and documented procedures for monitoring subrecipients, leading to potential noncompliance with federal requirements.
  • Impacted Requirements: The City failed to evaluate subrecipients' compliance risks and did not document reviews of their audit reports as required by 2 CFR 200.332 and 200.303.
  • Recommended Follow-Up: Implement a formal checklist for risk assessments and audit report reviews to ensure compliance and proper documentation moving forward.

Finding Text

Program: Housing Opportunities for Persons with AIDS (HOPWA) ALN #: 14.241 Federal Agency: Housing and Urban Development Federal Award Numbers: MAH22-F005, MAH20-F005, and MAH21-F005 Award Year: July 1, 2022–June 30, 2023 Subrecipient Monitoring Type of finding: Material weakness and noncompliance 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 nonfederal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the nonfederal 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. • 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 the four subrecipients selected for testing, but there was no documentation to evidence the nature and extent of the City’s review of the reports obtained. Additionally, a documented risk assessment was not performed by the City over the four subrecipients selected for testing prior to entering into a contract. 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. Additionally, the City requires a risk assessment be completed over each subrecipient. However, due to time constraints, a risk assessment was not completed. Effect Lack of effective controls and written policies and procedures over subrecipient monitoring 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 for both risk assessments and review of single audit report procedures. Employees can complete these checklists when obtaining subrecipient audit reports to ensure required monitoring procedures are performed and well documented. Views of Responsible Officials and Corrective Actions The City will incorporate a more formal review of financial audits of subrecipients in conjunction with new contracts moving forward. These audits, and City staff’s verification of assessment will be included in each subrecipient file. Implementation Date FY2025 Contracts Responsible Officials Robert Keller, Project Planner, Cambridge Community Development Department, and Judith Tumusiime, Federal Grants Manager, Cambridge Community Development Department

Corrective Action Plan

The City will incorporate a more formal review of financial audits of subrecipients in conjunction with new contracts moving forward. These audits, and City staff's verification of assessment will be included in each subrecipient file.

Categories

Subrecipient Monitoring

Other Findings in this Audit

  • 402448 2023-001
    Significant Deficiency Repeat
  • 402449 2023-001
    Significant Deficiency Repeat
  • 402450 2023-002
    Material Weakness Repeat
  • 402451 2023-002
    Material Weakness Repeat
  • 402452 2023-003
    Material Weakness Repeat
  • 402453 2023-003
    Material Weakness Repeat
  • 402454 2023-004
    -
  • 402456 2023-005
    Material Weakness
  • 402457 2023-006
    Material Weakness
  • 402458 2023-006
    Material Weakness
  • 402459 2023-007
    Material Weakness
  • 402460 2023-007
    Material Weakness
  • 402461 2023-008
    Material Weakness
  • 402462 2023-008
    Material Weakness
  • 402463 2023-009
    Material Weakness
  • 402464 2023-009
    Material Weakness
  • 402465 2023-010
    Material Weakness
  • 402466 2023-010
    Material Weakness
  • 402467 2023-011
    Material Weakness
  • 402468 2023-011
    Material Weakness
  • 978890 2023-001
    Significant Deficiency Repeat
  • 978891 2023-001
    Significant Deficiency Repeat
  • 978892 2023-002
    Material Weakness Repeat
  • 978893 2023-002
    Material Weakness Repeat
  • 978894 2023-003
    Material Weakness Repeat
  • 978895 2023-003
    Material Weakness Repeat
  • 978896 2023-004
    -
  • 978897 2023-005
    Material Weakness
  • 978898 2023-005
    Material Weakness
  • 978899 2023-006
    Material Weakness
  • 978900 2023-006
    Material Weakness
  • 978901 2023-007
    Material Weakness
  • 978902 2023-007
    Material Weakness
  • 978903 2023-008
    Material Weakness
  • 978904 2023-008
    Material Weakness
  • 978905 2023-009
    Material Weakness
  • 978906 2023-009
    Material Weakness
  • 978907 2023-010
    Material Weakness
  • 978908 2023-010
    Material Weakness
  • 978909 2023-011
    Material Weakness
  • 978910 2023-011
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
14.239 Home Investment Partnerships Program $11.36M
14.267 Continuum of Care Program $4.82M
84.425U American Rescue Plan Elementary and Secondary School Emergency Relief $2.88M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $2.59M
14.218 Community Development Block Grants/entitlement Grants $2.26M
84.425D Elementary and Secondary School Emergency Relief Fund (esser) $1.83M
10.555 National School Lunch Program $1.78M
93.568 Low-Income Home Energy Assistance $1.36M
84.010 Title I Grants to Local Educational Agencies $1.33M
21.027 Coronavirus State and Local Fiscal Recovery Funds $631,858
14.231 Emergency Solutions Grant Program $447,934
97.067 Homeland Security Grant Program $395,216
10.553 School Breakfast Program $350,371
84.027 Special Education_grants to States $342,165
32.004 Universal Service Fund - Schools and Libraries $238,716
10.559 Summer Food Service Program for Children $235,325
84.367 Improving Teacher Quality State Grants $178,360
84.002 Adult Education - Basic Grants to States $165,716
32.009 Emergency Connectivity Fund Program $158,827
93.590 Community-Based Child Abuse Prevention Grants $150,159
84.048 Career and Technical Education -- Basic Grants to States $99,323
84.365 English Language Acquisition State Grants $85,904
14.881 Moving to Work Demonstration Program $84,885
84.424 Student Support and Academic Enrichment Program $82,790
84.173 Special Education_preschool Grants $45,562
14.241 Housing Opportunities for Persons with Aids $45,047
97.042 Emergency Management Performance Grants $39,600
84.425 Education Stabilization Fund $30,287
84.196 Education for Homeless Children and Youth $15,549
14.401 Fair Housing Assistance Program_state and Local $12,746
20.616 National Priority Safety Programs $12,189
97.024 Emergency Food and Shelter National Board Program $11,885
20.600 State and Community Highway Safety $11,337
16.738 Edward Byrne Memorial Justice Assistance Grant Program $10,008
93.499 Low Income Household Water Assistance Program $9,554
93.788 Opioid Str $5,889
84.287 Twenty-First Century Community Learning Centers $363