Audit 3965

FY End
2022-06-30
Total Expended
$27.26M
Findings
4
Programs
32
Organization: City of Chelsea (MA)
Year: 2022 Accepted: 2023-11-21

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
2314 2022-001 - Yes B
2315 2022-001 - - B
578756 2022-001 - Yes B
578757 2022-001 - - B

Programs

ALN Program Spent Major Findings
21.019 Coronavirus Relief Fund $1.82M Yes 1
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.49M Yes 0
11.300 Investments for Public Works and Economic Development Facilities $1.30M - 0
10.553 School Breakfast Program $992,044 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $919,477 Yes 1
16.817 Byrne Criminal Justice Innovation Program $578,485 - 0
10.555 National School Lunch Program $366,561 - 0
84.027 Special Education_grants to States $328,084 - 0
10.559 Summer Food Service Program for Children $309,243 - 0
10.582 Fresh Fruit and Vegetable Program $109,320 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $99,796 Yes 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $92,023 - 0
84.010 Title I Grants to Local Educational Agencies $85,976 - 0
84.365 English Language Acquisition State Grants $73,677 - 0
16.922 Equitable Sharing Program $69,196 - 0
84.367 Improving Teacher Quality State Grants $58,752 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $45,055 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $40,022 - 0
84.425 Education Stabilization Fund $28,994 Yes 0
16.607 Bulletproof Vest Partnership Program $23,820 - 0
97.056 Port Security Grant Program $19,520 - 0
84.002 Adult Education - Basic Grants to States $19,459 - 0
84.173 Special Education_preschool Grants $18,882 - 0
84.424 Student Support and Academic Enrichment Program $18,386 Yes 0
10.558 Child and Adult Care Food Program $17,138 - 0
97.042 Emergency Management Performance Grants $15,476 - 0
84.287 Twenty-First Century Community Learning Centers $14,726 - 0
10.649 Pandemic Ebt Administrative Costs $8,589 - 0
20.600 State and Community Highway Safety $8,108 - 0
97.067 Homeland Security Grant Program $7,794 - 0
45.310 Grants to States $2,407 - 0
84.371 Striving Readers $136 - 0

Contacts

Name Title Type
T39VNB2VPJV5 Edward Dunn Auditee
6174664035 Paul Gargano Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Accounting policies and financial reporting practices permitted for municipalities in Massachusetts are prescribed by the Uniform Municipal Accounting System (UMAS) promulgated by the Commonwealth of Massachusetts Department of Revenue. The accompanying Schedule includes the federal grant transactions of the City. Although some of these programs may be supplemented with state and other revenue, only federal activity is shown. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of the City of Chelsea, Massachusetts (the City) under programs of the federal government for the year ended June 30, 2022. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position, or cash flows of the City.
Title: U.S. Department of Agriculture Programs Accounting Policies: Accounting policies and financial reporting practices permitted for municipalities in Massachusetts are prescribed by the Uniform Municipal Accounting System (UMAS) promulgated by the Commonwealth of Massachusetts Department of Revenue. The accompanying Schedule includes the federal grant transactions of the City. Although some of these programs may be supplemented with state and other revenue, only federal activity is shown. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. The City receives non-cash commodities from the U.S. Department of Agriculture as a part of the National School Lunch program. The amounts reported as non-cash assistance represent the fair market value of these commodities received during the year. The amounts reported as cash assistance represent federal reimbursements for meals provided.
Title: U.S. Department of Homeland Security Programs Accounting Policies: Accounting policies and financial reporting practices permitted for municipalities in Massachusetts are prescribed by the Uniform Municipal Accounting System (UMAS) promulgated by the Commonwealth of Massachusetts Department of Revenue. The accompanying Schedule includes the federal grant transactions of the City. Although some of these programs may be supplemented with state and other revenue, only federal activity is shown. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. U.S. Department of Homeland Security’s Disaster Grants – Public Assistance (Presidentially Declared Disaster) expenditures are recognized when the Federal Emergency Management Administration (FEMA) approves the City’s project worksheet (PW) and the City has incurred the eligible expenditures. The amounts reported in the Schedule include $919,477 of expenditures incurred in prior fiscal years but awarded by FEMA in the current fiscal year.

Finding Details

2022-001 U.S. Department of the Treasury Passed-through the Commonwealth of Massachusetts Executive Office for Administration and Finance COVID-19 – Coronavirus Relief Fund – 21.019 U.S. Department of the Homeland Security Passed-through the Massachusetts Emergency Management Agency Disaster Grants: Public Assistance (Presidentially Declared) – 97.036 Criteria: Per Part 4 of the OMB Compliance Supplement (21.019-4), recipients may not use payments from the Fund to cover expenditures for which they will receive reimbursement from other sources. Condition: The City charged the same invoice to two separate federal awards. Cause: Numerous invoices were added and removed from each grant as the eligibility criteria for grant charges evolved over time which led to the duplication. Effect: The City was reimbursed twice for the same invoice from separate federal awards. Questioned Costs: $15,579.58 Repeat Finding from Prior Year: Yes, finding 2021-002. Recommendation: The City should implement procedures to review grant general ledger activity more timely to ensure that duplicate costs are not included. Views of Responsible Official: Management agrees with the finding.
2022-001 U.S. Department of the Treasury Passed-through the Commonwealth of Massachusetts Executive Office for Administration and Finance COVID-19 – Coronavirus Relief Fund – 21.019 U.S. Department of the Homeland Security Passed-through the Massachusetts Emergency Management Agency Disaster Grants: Public Assistance (Presidentially Declared) – 97.036 Criteria: Per Part 4 of the OMB Compliance Supplement (21.019-4), recipients may not use payments from the Fund to cover expenditures for which they will receive reimbursement from other sources. Condition: The City charged the same invoice to two separate federal awards. Cause: Numerous invoices were added and removed from each grant as the eligibility criteria for grant charges evolved over time which led to the duplication. Effect: The City was reimbursed twice for the same invoice from separate federal awards. Questioned Costs: $15,579.58 Repeat Finding from Prior Year: Yes, finding 2021-002. Recommendation: The City should implement procedures to review grant general ledger activity more timely to ensure that duplicate costs are not included. Views of Responsible Official: Management agrees with the finding.
2022-001 U.S. Department of the Treasury Passed-through the Commonwealth of Massachusetts Executive Office for Administration and Finance COVID-19 – Coronavirus Relief Fund – 21.019 U.S. Department of the Homeland Security Passed-through the Massachusetts Emergency Management Agency Disaster Grants: Public Assistance (Presidentially Declared) – 97.036 Criteria: Per Part 4 of the OMB Compliance Supplement (21.019-4), recipients may not use payments from the Fund to cover expenditures for which they will receive reimbursement from other sources. Condition: The City charged the same invoice to two separate federal awards. Cause: Numerous invoices were added and removed from each grant as the eligibility criteria for grant charges evolved over time which led to the duplication. Effect: The City was reimbursed twice for the same invoice from separate federal awards. Questioned Costs: $15,579.58 Repeat Finding from Prior Year: Yes, finding 2021-002. Recommendation: The City should implement procedures to review grant general ledger activity more timely to ensure that duplicate costs are not included. Views of Responsible Official: Management agrees with the finding.
2022-001 U.S. Department of the Treasury Passed-through the Commonwealth of Massachusetts Executive Office for Administration and Finance COVID-19 – Coronavirus Relief Fund – 21.019 U.S. Department of the Homeland Security Passed-through the Massachusetts Emergency Management Agency Disaster Grants: Public Assistance (Presidentially Declared) – 97.036 Criteria: Per Part 4 of the OMB Compliance Supplement (21.019-4), recipients may not use payments from the Fund to cover expenditures for which they will receive reimbursement from other sources. Condition: The City charged the same invoice to two separate federal awards. Cause: Numerous invoices were added and removed from each grant as the eligibility criteria for grant charges evolved over time which led to the duplication. Effect: The City was reimbursed twice for the same invoice from separate federal awards. Questioned Costs: $15,579.58 Repeat Finding from Prior Year: Yes, finding 2021-002. Recommendation: The City should implement procedures to review grant general ledger activity more timely to ensure that duplicate costs are not included. Views of Responsible Official: Management agrees with the finding.