Audit 351403

FY End
2024-06-30
Total Expended
$10.61M
Findings
2
Programs
22
Organization: City of Beverly (MA)
Year: 2024 Accepted: 2025-03-31
Auditor: Cbiz CPAS PC

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
547016 2024-001 Significant Deficiency - L
1123458 2024-001 Significant Deficiency - L

Contacts

Name Title Type
GQUZWMGJNDP4 Bryant Ayles Auditee
9786052315 Renee Davis Auditor
No contacts on file

Notes to SEFA

Accounting Policies: (a) Basis of Accounting – The accompanying Schedule of Expenditures of Federal Awards is presented on the modified accrual basis of accounting. Accordingly, expenditures are recognized when the liability is incurred. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. (b) Cash Assistance – School Breakfast and Lunch Program – Program expenditures represent federal reimbursement for meals provided during the year. (c) Non-Cash Assistance (Commodities) – School Lunch Program – Program expenditures represent the value of donated foods received during the year. (d) Disaster grants have been recorded the year the grant was approved. De Minimis Rate Used: N Rate Explanation: The City of Beverly, Massachusetts has not elected to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance.

Finding Details

2024-001 Improve Internal Controls Over Reporting Federal Agency: U.S. Department of the Treasury Award Name: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds AL Number(s): 21.027 Award Year: 2024 Compliance Requirement: Reporting Type of Finding Compliance Internal Control over Compliance - Significant Deficiency Criteria or Specific Requirement OMB’s Uniform Administrative Requirement, Cost Principles, and Audit Requirements for Federal Awards (UG) requires that grant recipients design internal controls to ensure that reports submitted to the State/Federal government are complete and accurate. Management is also responsible for establishing and maintaining effective internal controls over compliance with federal requirements that have a direct and material effect on a federal program. A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis. Condition and Context Key line items, specifically current period expenditures and total cumulative expenditures, included on the project and expenditure report submitted for quarter 1 2024 (January – March) did not agree to the general ledger. Cause Weaknesses in the design and implementation of internal controls. Effect or Potential Effect Due to the weaknesses in internal control noted above, key line items on reports submitted may not be complete or accurate. No questioned costs are reported as it is not quantifiable. Recommendation The City should design and implement improved internal controls to ensure that reports are reviewed in detail and agreed back to the general ledger prior to submission to ensure completeness and accuracy. Views of Responsible Official Management agrees with the finding.
2024-001 Improve Internal Controls Over Reporting Federal Agency: U.S. Department of the Treasury Award Name: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds AL Number(s): 21.027 Award Year: 2024 Compliance Requirement: Reporting Type of Finding Compliance Internal Control over Compliance - Significant Deficiency Criteria or Specific Requirement OMB’s Uniform Administrative Requirement, Cost Principles, and Audit Requirements for Federal Awards (UG) requires that grant recipients design internal controls to ensure that reports submitted to the State/Federal government are complete and accurate. Management is also responsible for establishing and maintaining effective internal controls over compliance with federal requirements that have a direct and material effect on a federal program. A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis. Condition and Context Key line items, specifically current period expenditures and total cumulative expenditures, included on the project and expenditure report submitted for quarter 1 2024 (January – March) did not agree to the general ledger. Cause Weaknesses in the design and implementation of internal controls. Effect or Potential Effect Due to the weaknesses in internal control noted above, key line items on reports submitted may not be complete or accurate. No questioned costs are reported as it is not quantifiable. Recommendation The City should design and implement improved internal controls to ensure that reports are reviewed in detail and agreed back to the general ledger prior to submission to ensure completeness and accuracy. Views of Responsible Official Management agrees with the finding.