Audit 365457

FY End
2024-06-30
Total Expended
$1.30M
Findings
4
Programs
4
Organization: Town of Wilbraham, Ma (MA)
Year: 2024 Accepted: 2025-09-03
Auditor: Cbiz CPAS PC

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
575407 2024-001 - Yes ABCEFGHIJLMNP
575408 2024-002 Material Weakness Yes L
1151849 2024-001 - Yes ABCEFGHIJLMNP
1151850 2024-002 Material Weakness Yes L

Contacts

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

Notes to SEFA

Title: NOTE 1 - BASIS OF PRESENTATION Accounting Policies: see form tab De Minimis Rate Used: N Rate Explanation: see form tab 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, 2024. 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 Requirements 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 form tab De Minimis Rate Used: N Rate Explanation: see form tab Expenditures reported on the schedule are reported on the 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 form tab De Minimis Rate Used: N Rate Explanation: see form tab The Town has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance.
Title: NOTE 4 - SUBRECIPIENTS Accounting Policies: see form tab De Minimis Rate Used: N Rate Explanation: see form tab Of the federal expenditures presented in the schedule, the Town did not provide federal awards to subrecipients.
Title: NOTE 5 - INCLUSION OF PRIOR YEAR EXPENDITURES Accounting Policies: see form tab De Minimis Rate Used: N Rate Explanation: see form tab Coronavirus State and Local Fiscal Recovery Fund federal program expenditures reported in the schedule for the year ended June 30, 2024, include $124,579 of expenditures that relate to activities or costs incurred in a prior fiscal year. These expenditures were not reported in the schedule in a prior year due to programmatic reporting requirements. Management has determined that inclusion of these prior year expenditures is necessary to accurately present federal expenditures in accordance with the Uniform Guidance.

Finding Details

2024-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.   2024-001 Document Policies and Procedures Over Federal Awards (Continued) 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. 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.
2024-002 Improve Oversight Over Reporting of Federal Awards (Material Weakness) Federal Agency: Department of the Treasury Cluster/Program: COVID-19 Coronavirus State and Local Fiscal Recovery Fund AL Number(s): 21.027 Award Year: 2024 Compliance Requirement: Reporting Type of Finding Material Noncompliance Internal Control over Compliance – Material Weakness 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.  2024-002 Improve Oversight Over Reporting of Federal Awards (Material Weakness) (Continued) Condition and Context When comparing annual amounts reported to the Treasury to the actual Town expenses, we noted several expenses were omitted from the Treasury reports. 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.
2024-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.   2024-001 Document Policies and Procedures Over Federal Awards (Continued) 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. 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.
2024-002 Improve Oversight Over Reporting of Federal Awards (Material Weakness) Federal Agency: Department of the Treasury Cluster/Program: COVID-19 Coronavirus State and Local Fiscal Recovery Fund AL Number(s): 21.027 Award Year: 2024 Compliance Requirement: Reporting Type of Finding Material Noncompliance Internal Control over Compliance – Material Weakness 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.  2024-002 Improve Oversight Over Reporting of Federal Awards (Material Weakness) (Continued) Condition and Context When comparing annual amounts reported to the Treasury to the actual Town expenses, we noted several expenses were omitted from the Treasury reports. 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.