Audit 317055

FY End
2023-06-30
Total Expended
$2.53M
Findings
4
Programs
3
Organization: Town of Wilbraham, Ma (MA)
Year: 2023 Accepted: 2024-08-12
Auditor: Marcum LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
480945 2023-001 - - ABCEFGHIJLMNP
480946 2023-002 Significant Deficiency - L
1057387 2023-001 - - ABCEFGHIJLMNP
1057388 2023-002 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $2.34M Yes 2
97.044 Assistance to Firefighters Grant $110,131 - 0
97.083 Staffing for Adequate Fire and Emergency Response (safer) $86,096 - 0

Contacts

Name Title Type
U5WJK7PWJFE5 Derek Geser Auditee
4135962800 Tanya Campbell Auditor
No contacts on file

Notes to SEFA

Title: Note 1 - Basis of Presentation Accounting Policies: See note 2 De Minimis Rate Used: N Rate Explanation: The Town has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of the Town of Wilbraham, Massachusetts (the Town) under programs of the federal government for the year ended June 30, 2023. The information in the Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Require­ments for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Town, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Town.
Title: Note 2 - Summary of Significant Accounting Policies Accounting Policies: See note 2 De Minimis Rate Used: N Rate Explanation: The Town has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. 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, wherein certain types of expenditures are not allowable or are limited to reimbursement.
Title: Note 3 - De Minimis Cost Rate Accounting Policies: See note 2 De Minimis Rate Used: N Rate Explanation: The Town has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The Town has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance.
Title: Note 4 - Donated Personal Protective Equipment (PPE) (Unaudited) Accounting Policies: See note 2 De Minimis Rate Used: N Rate Explanation: The Town has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. During fiscal year 2023, the Town did not receive donated PPE from federal sources.
Title: Note 5 - Subrecipients Accounting Policies: See note 2 De Minimis Rate Used: N Rate Explanation: The Town has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. Of the federal expenditures presented in the Schedule, the Town did not provide federal awards to subrecipients.

Finding Details

2023-001 Document Policies and Procedures Over Federal Awards Federal Program(s) Information Cluster/Program: All federal programs Type of Finding Compliance – Other Matters Criteria or Specific Requirement OMB’s Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (UG) established significant requirements related to federal awards. The requirements stipulate that federal award recipients must document their policies and procedures over certain aspects of financial program management. Specifically, written policies are required for the following compliance requirements: • Cash management • Determination of allowable costs • Program income • Eligibility determination • Equipment and real property management • Period of performance • Procurement • Subrecipient monitoring and management Condition and Context The Town does not have written policies and procedures related to federal awards, as required under the Uniform Guidance. Specifically, there are no formalized written policies for cash management, allowable costs, program income/requesting reimbursement, eligibility determina¬tion, equipment and real property management, period of performance, procurement, or subrecipient monitoring. Cause Weakness in the design of internal controls. Effect or Potential Effect The Town is not in compliance with the Uniform Guidance requirements for written policies and procedures. 2023-001 Document Policies and Procedures Over Federal Awards (Continued) Questioned Costs There are no questioned costs as a result of this finding, as there are no costs directly associated with this compliance requirement and this is a procedural requirement under the Uniform Guidance. Recommendation The Town should develop and implement written procedures that are in compliance with the requirements of the Uniform Guidance. Views of Responsible Official Management agrees with the finding. Planned Corrective Action Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.
2023-002 Improve Oversight Over Reporting of Federal Awards (Significant Deficiency) Federal Agency: Department of the Treasury Cluster/Program: COVID-19 Coronavirus State and Local Fiscal Recovery Fund AL Number(s): 21.027 Award Year: 2023 Compliance Requirement: Reporting Type of Finding Compliance Internal Control over Compliance – Significant Deficiency Criteria or Specific Requirement A non-federal entity is required to submit a performance report annually using a form or format authorized by OMB (2 CFR section 200.329) based on expenditures reported in the Town’s general ledger. Management of the Town is also responsible for establishing and maintaining effective internal control over compliance with federal requirements that have a direct and material effect on a federal pro¬gram. 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 per¬forming 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 In the March 2023 annual performance report, the Town reported expenditures of $239,098 for the MRHS switches project. These expenditures did not occur until fiscal year 2024 and should not have been reported.   2023-002 Improve Oversight Over Reporting of Federal Awards (Significant Deficiency) (Continued) Cause The Town has not established adequate procedures to ensure expenditures reported on the annual report agree with the Town’s general ledger. Effect or Potential Effect The Town is not in compliance with the Uniform Guidance requirements for reporting. Questioned Costs There are no questioned costs as a result of this finding, as these costs were allowable and did occur, but they were reported in the incorrect reporting period. Recommendation The Town should implement controls to ensure that reports are reconciled to the general ledger prior to submission. Views of Responsible Official Management agrees with the finding. Planned Corrective Action Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.
2023-001 Document Policies and Procedures Over Federal Awards Federal Program(s) Information Cluster/Program: All federal programs Type of Finding Compliance – Other Matters Criteria or Specific Requirement OMB’s Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (UG) established significant requirements related to federal awards. The requirements stipulate that federal award recipients must document their policies and procedures over certain aspects of financial program management. Specifically, written policies are required for the following compliance requirements: • Cash management • Determination of allowable costs • Program income • Eligibility determination • Equipment and real property management • Period of performance • Procurement • Subrecipient monitoring and management Condition and Context The Town does not have written policies and procedures related to federal awards, as required under the Uniform Guidance. Specifically, there are no formalized written policies for cash management, allowable costs, program income/requesting reimbursement, eligibility determina¬tion, equipment and real property management, period of performance, procurement, or subrecipient monitoring. Cause Weakness in the design of internal controls. Effect or Potential Effect The Town is not in compliance with the Uniform Guidance requirements for written policies and procedures. 2023-001 Document Policies and Procedures Over Federal Awards (Continued) Questioned Costs There are no questioned costs as a result of this finding, as there are no costs directly associated with this compliance requirement and this is a procedural requirement under the Uniform Guidance. Recommendation The Town should develop and implement written procedures that are in compliance with the requirements of the Uniform Guidance. Views of Responsible Official Management agrees with the finding. Planned Corrective Action Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.
2023-002 Improve Oversight Over Reporting of Federal Awards (Significant Deficiency) Federal Agency: Department of the Treasury Cluster/Program: COVID-19 Coronavirus State and Local Fiscal Recovery Fund AL Number(s): 21.027 Award Year: 2023 Compliance Requirement: Reporting Type of Finding Compliance Internal Control over Compliance – Significant Deficiency Criteria or Specific Requirement A non-federal entity is required to submit a performance report annually using a form or format authorized by OMB (2 CFR section 200.329) based on expenditures reported in the Town’s general ledger. Management of the Town is also responsible for establishing and maintaining effective internal control over compliance with federal requirements that have a direct and material effect on a federal pro¬gram. 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 per¬forming 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 In the March 2023 annual performance report, the Town reported expenditures of $239,098 for the MRHS switches project. These expenditures did not occur until fiscal year 2024 and should not have been reported.   2023-002 Improve Oversight Over Reporting of Federal Awards (Significant Deficiency) (Continued) Cause The Town has not established adequate procedures to ensure expenditures reported on the annual report agree with the Town’s general ledger. Effect or Potential Effect The Town is not in compliance with the Uniform Guidance requirements for reporting. Questioned Costs There are no questioned costs as a result of this finding, as these costs were allowable and did occur, but they were reported in the incorrect reporting period. Recommendation The Town should implement controls to ensure that reports are reconciled to the general ledger prior to submission. Views of Responsible Official Management agrees with the finding. Planned Corrective Action Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.