Finding 32302 (2022-001)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-03-30

AI Summary

  • Core Issue: The City of Chicopee's quarterly reports on Coronavirus Relief Fund expenditures were not reconciled with the general ledger, leading to discrepancies of $1,450,148.36.
  • Impacted Requirements: Compliance with U.S. Department of Treasury and Massachusetts Executive Office regulations for accurate reporting of fund usage.
  • Recommended Follow-Up: Implement procedures to reconcile reports with the general ledger and ensure proper journal entries and documentation for any reclassified expenses.

Finding Text

Finding 2022-001 Significant Deficiency in Internal Control Over Compliance ? U.S. Department of Treasury ? Coronavirus Relief Fund City Municipal Assistance ? (CFDA No. 21.019) ? Reporting Passed Through Commonwealth of Massachusetts Executive Office of Administration and Finance Criteria: The U. S. Department of Treasury Office of Inspector General requires recipients of the CARES Act Coronavirus Relief Fund dollars to file periodic reports that describe the uses of these funds. The Massachusetts Executive Office of Administration and Finance requires that sub-recipient municipal governments (cities, towns, and regional school districts) submit quarterly reports on expenditures of the Coronavirus Relief Fund to the State administering agency. The reports should reflect the amounts expended on the municipal general ledger accounting records. Condition: The City of Chicopee, Massachusetts, filed the required quarterly reports. However, the reports were not reconciled to the City?s general ledger. The Final Submission Report showed $1,450,148.36 more reported on the report than was posted to the general ledger CARES account. Cause: The City does not have procedures in place to reconcile reporting filed with the State administering agency to the activity in the City?s general ledger. The costs reported that were not charged to the CARES Act account are likely expenses that were charged to City departmental budgets and later determined to be eligible under the program but were not reclassified to the CARES Act account on the City?s general ledger. Effect: The City could misstate or include unallowed costs in its financial reporting of grant funds. Questioned Costs: None reported. Recommendation: The City personnel should reconcile the reports to the City?s general ledger. When expenses are reclassified from other accounts to the Coronavirus Relief Funds, a journal entry adjustment should be made to the general ledger and proper supporting documentation should be retained to have a proper audit trail. Views of Responsible Officials and Planned Corrective Action: See corrective action plan following on page 17.

Corrective Action Plan

Finding 2022-001 Significant Deficiency in Internal Control Over Compliance ? U.S. Department of Treasury ? Coronavirus Relief Fund City Municipal Assistance ? (CFDA No. 21.019) ? Reporting (continued) Passed Through Commonwealth of Massachusetts Executive Office of Administration and Finance Name of Person Responsible: Marie T. Laflamme, Treasurer Sharyn Riley, Auditor John Miarecki, School Director of Budget & Finance Corrective Action Planned: The City will immediately review all expenses related to the Coronavirus Relief Funds. The City will take steps to reconcile the Coronavirus Report to our General Ledger. Anticipated Completion Date: May 30, 2023

Categories

Subrecipient Monitoring Reporting Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 608744 2022-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $11.23M
84.425 Education Stabilization Fund $8.70M
84.010 Title I Grants to Local Educational Agencies $2.84M
10.553 School Breakfast Program $1.39M
66.458 Capitalization Grants for Clean Water State Revolving Funds $1.30M
14.218 Community Development Block Grants/entitlement Grants $452,434
97.083 Staffing for Adequate Fire and Emergency Response (safer) $377,059
84.367 Improving Teacher Quality State Grants $355,845
10.559 Summer Food Service Program for Children $290,182
10.555 National School Lunch Program $285,720
84.027 Special Education_grants to States $266,167
84.424 Student Support and Academic Enrichment Program $205,050
16.738 Edward Byrne Memorial Justice Assistance Grant Program $175,406
84.048 Career and Technical Education -- Basic Grants to States $143,172
14.239 Home Investment Partnerships Program $80,000
84.365 English Language Acquisition State Grants $67,245
97.042 Emergency Management Performance Grants $55,988
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $48,089
21.019 Coronavirus Relief Fund $44,504
84.173 Special Education_preschool Grants $23,274
16.922 Equitable Sharing Program $23,191
10.558 Child and Adult Care Food Program $15,816
20.600 State and Community Highway Safety $13,761
84.371 Striving Readers $13,438
10.649 Pandemic Ebt Administrative Costs $11,659
84.196 Education for Homeless Children and Youth $11,025
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $9,331
16.544 Youth Gang Prevention $9,153
16.004 Law Enforcement Assistance_narcotics and Dangerous Drugs Training $5,140
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $3,450
45.310 Grants to States $2,050
97.044 Assistance to Firefighters Grant $865