Finding 978909 (2023-011)

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

AI Summary

  • Core Issue: Expenditures for the IDEA program were charged 52 days before the grant's official start date due to incorrect purchase order assignments.
  • Impacted Requirements: Compliance with federal regulations on fund obligation periods and internal control standards was not maintained.
  • Recommended Follow-Up: Implement stricter controls for invoice review and approval to ensure expenses align with grant timelines, effective by July 1, 2024.

Finding Text

Program: Special Education Cluster (IDEA) ALN #: 84.027 Federal Agency: Department of Education Federal Award Number: NA Award Year: July 1, 2022–June 30, 2023 Period of Performance Type of finding: Material weakness and noncompliance Prior-year finding: No Statistically valid sample: No Criteria Per Part 4 of the Compliance Supplement, LEAs and SEAs must obligate funds during the 27 months, extending from July 1 of the fiscal year for which the funds were appropriated through September 30 of the second following fiscal year. This maximum period includes a 15-month period of initial availability plus a 12-month period for carryover. For example, funds from the fiscal year 2019 appropriation initially became available on July 1, 2019 and may be obligated by the grantee and subgrantee through September 30, 2021 (Section 421(b) of GEPA (20 USC 1225(b)); 34 CFR sections 76.703 through 76.710). 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 During testing over period of performance for the IDEA program, 14 samples were selected for testwork. For four selections (all related to the same vendor), we noted that expenditures were charged to the SC23605 grant 52 days prior to the grant’s start date. The expenditures were invoiced on August 1, 2022, and the grant’s period of performance began on September 22, 2022 (the date the Massachusetts Department of Education notified the City of this grant’s effective date). Cause The cause of the noncompliance relates to an error assigning POs for a certain vendor. POs created for this vendor for July 2022 tuition were mistakenly charged to the incorrect grant. A lack of review over charges to individual grants and programs has caused the City to charge expenses to the IDEA grant outside of its period of performance. Questioned Costs Not determinable Recommendation We recommend the City establish more precise controls over the review and approval of invoices, specifically relating to the review and approval over the direct grant that the expense will be charged to. Views of Responsible Officials and Corrective Actions Cambridge Public Schools' CFO or Grants Coordinator will review and sign-off on all tuition requisitions that will be charged to grants to confirm the grant approval date and compliance with the period of performance. Implementation Date The new approval process will be in place by July 1, 2024. Responsible Officials Dr. Karyn Grace, Assistant Superintendent of Student Services, Cambridge Public Schools, Ivy Washington, Chief Financial Officer, Cambridge School Department, and Lindsay Smythe, Grant Coordinator, Cambridge School Department

Categories

Period of Performance Internal Control / Segregation of Duties Material Weakness Matching / Level of Effort / Earmarking

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
    -
  • 402455 2023-005
    Material Weakness
  • 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
  • 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