Finding 1240076 (2021-001)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2021
Accepted
2026-10-07
Audit: 414691
Organization: City of Springfield (MA)
Auditor: CBIZ CPAS PC

AI Summary

  • Core Issue: The City failed to report $6,174,406 in Coronavirus Relief expenditures on the SEFA due to inadequate internal controls.
  • Impacted Requirements: Compliance with Uniform Guidance 2 CFR 200.303, which mandates effective internal controls for federal awards.
  • Recommended Follow-Up: Improve internal controls and training for staff involved in preparing and reviewing the SEFA to ensure accurate reporting.

Finding Text

Federal Agency: Department of Treasury Pass-Through Entity: Executive Office of Administration and Finance & Massachusetts Department of Elementary and Secondary Education Award Name: Coronavirus Relief Fund Assistance Listing Number: 21.019 Compliance Requirement: Reporting Type of Finding: Compliance Internal Control over Compliance – Material Weakness Criteria: According to Uniform Guidance 2 CFR 200.303, the non-federal entity must establish and maintain effective internal controls over compliance for federal awards to provide reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition and Context: During fiscal year 2021, the City charged the Coronavirus Relief expenditures to multiple funds in the general ledger. The fiscal year 2021 SEFA omitted $6,174,406 of expenditures from one fund from the SEFA. The error only extended to the amounts reported on the SEFA, amounts reported to the pass-through entities were correct. Cause: The lack of reconciliation to the general ledger during the preparation and review process. Effect: The SEFA and major program were materially understated. Questioned Costs: None. Recommendation: We recommend the City enhance their internal controls over the preparation of the SEFA to ensure those preparing and reviewing the reports have the appropriate understanding and information needed to ensure completeness and accuracy of information being reported. Views of Responsible Officials: See corrective action plan.

Corrective Action Plan

Planned Corrective Action: Management agrees with the finding and has implemented controls to match revenue received from Emergency Federal Funds with expenditures submitted on drawdown requests. This will properly capture all expenditures of Federal Funds in the correct fiscal year. Furthermore, management will meet on a quarterly basis to review all Federal Funds and perform reconciliations on a monthly basis. In addition to quarterly financial reviews and monthly financial reconciliations, management will immediately adapt to changing guidelines on Emergencv Federal Funds in future fiscal vears. Planned Implementation Date of Corrective Action: Currently Implemented.

Categories

Reporting Subrecipient Monitoring Material Weakness Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 1240074 2021-001
    Material Weakness Repeat
  • 1240075 2021-001
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $7.43M
10.558 CHILD AND ADULT CARE FOOD PROGRAM $5.55M
14.267 CONTINUUM OF CARE PROGRAM $3.87M
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $2.97M
14.231 COVID-19 EMERGENCY SOLUTIONS GRANT PROGRAM $1.64M
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN $1.63M
93.224 HEALTH CENTER PROGRAM $1.53M
14.218 COVID-19 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $1.36M
14.272 NATIONAL DISASTER RESILIENCE COMPETITION $1.32M
21.019 COVID-19 CORONAVIRUS RELIEF FUND $935,201
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $929,884
10.555 NATIONAL SCHOOL LUNCH PROGRAM $814,063
14.241 HOUSING OPPORTUNITIES FOR PERSONS WITH AIDS $701,992
17.235 SENIOR COMMUNITY SERVICE EMPLOYMENT PROGRAM $498,350
14.900 LEAD HAZARD REDUCTION GRANT PROGRAM $488,830
15.916 OUTDOOR RECREATION ACQUISITION, DEVELOPMENT AND PLANNING $451,434
93.224 COVID-19 HEALTH CENTER PROGRAM $435,513
10.558 COVID-19 CHILD AND ADULT CARE FOOD PROGRAM $399,413
97.083 STAFFING FOR ADEQUATE FIRE AND EMERGENCY RESPONSE (SAFER) $396,385
10.582 FRESH FRUIT AND VEGETABLE PROGRAM $383,468
14.276 YOUTH HOMELESSNESS DEMONSTRATION PROGRAM $282,990
97.044 ASSISTANCE TO FIREFIGHTERS GRANT $273,960
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $269,918
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $229,242
97.044 COVID-19 ASSISTANCE TO FIREFIGHTERS GRANT $207,582
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $200,107
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES $190,046
66.818 BROWNFIELDS MULTIPURPOSE, ASSESSMENT, REVOLVING LOAN FUND, AND CLEANUP COOPERATIVE AGREEMENTS $130,749
16.835 BODY WORN CAMERA POLICY AND IMPLEMENTATION $77,613
93.042 SPECIAL PROGRAMS FOR THE AGING, TITLE VII, CHAPTER 2, LONG TERM CARE OMBUDSMAN SERVICES FOR OLDER INDIVIDUALS $71,947
14.241 COVID-19 HOUSING OPPORTUNITIES FOR PERSONS WITH AIDS $71,860
47.070 COMPUTER AND INFORMATION SCIENCE AND ENGINEERING $65,853
14.261 NATIONAL HOMELESS DATA ANALYSIS PROJECT (NHDAP) $54,574
84.938 DISASTER RECOVERY ASSISTANCE FOR EDUCATION $48,994
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS $43,258
93.779 CENTERS FOR MEDICARE AND MEDICAID SERVICES (CMS) RESEARCH, DEMONSTRATIONS AND EVALUATIONS $42,717
20.219 RECREATIONAL TRAILS PROGRAM $26,783
93.243 SUBSTANCE ABUSE AND MENTAL HEALTH SERVICES PROJECTS OF REGIONAL AND NATIONAL SIGNIFICANCE $24,422
10.664 COOPERATIVE FORESTRY ASSISTANCE $22,500
93.092 AFFORDABLE CARE ACT (ACA) PERSONAL RESPONSIBILITY EDUCATION PROGRAM $22,092
10.575 FARM TO SCHOOL GRANT PROGRAM $21,818
93.788 OPIOID STR $17,242
97.047 BRIC: BUILDING RESILIENT INFRASTRUCTURE AND COMMUNITIES $16,154
84.425 COVID-19 EDUCATION STABILIZATION FUND $15,993
84.287 TWENTY-FIRST CENTURY COMMUNITY LEARNING CENTERS $14,643
93.279 DRUG USE AND ADDICTION RESEARCH PROGRAMS $14,588
84.371 COMPREHENSIVE LITERACY DEVELOPMENT $14,232
84.027 SPECIAL EDUCATION GRANTS TO STATES $13,225
84.010 COVID-19 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $12,726
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $11,971
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $9,877
84.196 EDUCATION FOR HOMELESS CHILDREN AND YOUTH $9,781
47.076 STEM EDUCATION (FORMERLY EDUCATION AND HUMAN RESOURCES) $8,991
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $7,725
93.268 IMMUNIZATION COOPERATIVE AGREEMENTS $7,414
45.025 PROMOTION OF THE ARTS PARTNERSHIP AGREEMENTS $7,000
93.044 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART B, GRANTS FOR SUPPORTIVE SERVICES AND SENIOR CENTERS $4,805
45.310 GRANTS TO STATES $2,673
10.543 HEALTHIER US SCHOOL CHALLENGE: SMARTER LUNCHROOMS $1,397
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $1,117