Finding 1207143 (2024-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2026-04-17
Audit: 398998
Organization: Town of Billerica (MA)
Auditor: CBIZ CPAS PC

AI Summary

  • Core Issue: The Town Accountant handles all aspects of grant report preparation, approval, and submission, lacking necessary checks and balances.
  • Impacted Requirements: This situation violates Uniform Guidance (2 CFR 200.303), which mandates effective internal controls and segregation of duties for federal award reporting.
  • Recommended Follow-Up: Implement a secondary review process for grant reports before submission, or conduct periodic retrospective reviews if staffing is limited.

Finding Text

2024-002 – Lack of Segregation of Duties—Grant Report Approval and Submission Federal Agency: Department of the Treasury Award Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Award Year: 2024 Compliance Requirement: Reporting Type of Finding - Compliance Internal Control over Compliance – Significant Deficiency Condition: During our audit of the Town’s federal grant programs, we noted that the Town Accountant is solely responsible for both completing, approving, and submitting certain reports, required under the State and Local Fiscal Recovery Fund grant, to the United States Treasury. A secondary independent review or approval process is not in place prior to submission. Criteria: Uniform Guidance (2 CFR 200.303) requires non-federal entities to establish and maintain effective internal controls over federal award reporting that provide reasonable assurance that records are accurate, complete, and in compliance with federal statutes, regulations, and the terms and conditions of the award. Effective internal control includes appropriate segregation of duties. Cause: This situation results primarily from the Town’s limited administrative staffing, which restricts the ability to segregate the reporting and approval functions among different individuals. Effect: The lack of segregation of duties increases the risk that errors or noncompliance with federal award requirements in grant reporting could occur and not be prevented or detected in a timely manner. Recommendation: We recommend the Town implement a secondary review of grant reports, for any type of grant that requires external reporting to the grantor entity, prior to submission. This review could be performed by another member of management, or another designated official, and should be documented as evidence of oversight. If staffing limitations make this impractical, consider periodic and documented retrospective reviews of submitted reports. Views of Responsible Officials: The Town acknowledges the finding and recognizes the importance of maintaining adequate internal controls over federal grant reporting, including appropriate segregation of duties. We will be implementing additional procedures to ensure adequate preparation and review procedures to ensure accurate reporting to oversight agencies.

Corrective Action Plan

CORRECTIVE ACTION PLAN The Town of Billerica, Massachusetts respectfully submits the following corrective action plan for the year ended June 30, 2024. Name and address of the independent public accounting firm: CBIZ CPAs P.C. 53 State Street, 17th Floor Boston, MA 02109 Audit Period: July 1, 2023 through June 30, 2024 The finding from the June 30, 2024, schedule of findings and questioned costs is discussed below. The finding is numbered consistently with the number assigned in the schedule. Finding 2024-002: Lack of Segregation of Duties – Grant Reporting Approval and Submission Views of Responsible Officials: The Town acknowledges the finding and recognizes the importance of maintaining adequate internal controls over federal grant reporting, including appropriate segregation of duties. We will be implementing additional procedures to ensure adequate preparation and review procedures to ensure accurate reporting to oversight agencies. Official Responsible for Implementing Corrective Action: Amit Chhayani Town Accountant

Categories

Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1207144 2024-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 COVID-19 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $3.25M
10.555 NATIONAL SCHOOL LUNCH PROGRAM $980,267
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $354,929
10.553 SCHOOL BREAKFAST PROGRAM $192,045
66.468 DRINKING WATER STATE REVOLVING FUND $155,676
10.555 COVID-19 NATIONAL SCHOOL LUNCH PROGRAM $115,928
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $82,720
93.354 PUBLIC HEALTH EMERGENCY RESPONSE: COOPERATIVE AGREEMENT FOR EMERGENCY RESPONSE: PUBLIC HEALTH CRISIS RESPONSE $38,298
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $30,953
10.182 COVID-19 PANDEMIC RELIEF ACTIVITIES: LOCAL FOOD PURCHASE AGREEMENTS WITH STATES, TRIBES, AND LOCAL GOVERNMENTS $24,467
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $23,580
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $19,062
84.425 COVID-19 EDUCATION STABILIZATION FUND $16,000
97.067 HOMELAND SECURITY GRANT PROGRAM $5,000
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $4,371
84.027 SPECIAL EDUCATION GRANTS TO STATES $1,291
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $615
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS $95