Finding 20540 (2022-004)

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 documented procedures for monitoring subrecipients, leading to noncompliance with federal regulations.
  • Impacted Requirements: Failure to evaluate subrecipient risk, conduct timely monitoring activities, and verify necessary audits as per 2 CFR 200.303.
  • Recommended Follow-Up: Establish formal policies and a checklist for subrecipient monitoring to ensure compliance and documentation of procedures.

Finding Text

Finding Number: 2022 004 Program: Coronavirus State and Local Fiscal Recovery Funds ALN #: 21.027 Federal Agency: U.S. Department of Treasury Federal Award Number: SLFRP1982 Award Year: 7/1/2021 ? 6/30/2022 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 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 the City does not have formally documented policies and procedures related to subrecipient monitoring and risk assessment prior to entering into contracts with subrecipients. For 1 of our 2 subrecipients selected for testing, there was no evidence of risk assessment prior to entering into contract. We noted that audited financial statements were obtained for 2 of the 2 subrecipients selected for testing, but there was no documentation to evidence monitoring procedures performed over the reports obtained. Cause The City requires that audited financial statements are obtained for subrecipients, but there is no checklist or formally documented policies and procedures for subrecipient monitoring and risk assessment to ensure compliance with subrecipient monitoring requirements. Effect Lack of effective controls resulted in the City not complying with 2 CFR 200.303. Questioned Costs None Recommendation We recommend the City establish well documented policies and procedures over subrecipient monitoring including a checklist or formal documentation requirements that employees can complete when obtaining subrecipient audit reports and making determinations on subrecipients contracts 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 the review of subrecipient agencies? audit reports. Implementation Date The checklist is completed, and the City will start using the form immediately as new subrecipients are awarded ARPA funds. Responsible Officials Betty Lyons, Federal Grants Manager

Corrective Action Plan

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

Categories

Subrecipient Monitoring

Other Findings in this Audit

  • 20531 2022-001
    Material Weakness
  • 20532 2022-002
    Material Weakness
  • 20533 2022-003
    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
  • 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