Audit 307116

FY End
2023-06-30
Total Expended
$7.15M
Findings
2
Programs
13
Organization: Town of Franklin (MA)
Year: 2023 Accepted: 2024-05-23
Auditor: Marcum LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
398423 2023-001 Significant Deficiency - AB
974865 2023-001 Significant Deficiency - AB

Contacts

Name Title Type
GCN6XXQDJ115 Christopher Sandini Auditee
5085534864 Laurie Garland Auditor
No contacts on file

Notes to SEFA

Title: Donated Personal Protective Equipment (PPE) (Unaudited) Accounting Policies: -The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of the Town of Franklin (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 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. -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. -The amounts reported for the National School Lunch Program – Non-Cash Assistance represent the fair value of commodities received. - Expenditures awarded from the Federal Emergency Management Agency (FEMA), must be presented on the Schedule when; 1) FEMA has approved the Town’s project worksheet (PW) and 2) the Town has incurred the eligible expenditures. The $305,000 reported for Disaster Grants – Public Assistance (Presidentially Declared Disasters), AL 97.036, represents expenditures incurred in prior years that were approved by FEMA during fiscal year 2023. 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 to Town did not receive donated PPE from federal sources.
Title: Subrecipients Accounting Policies: -The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of the Town of Franklin (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 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. -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. -The amounts reported for the National School Lunch Program – Non-Cash Assistance represent the fair value of commodities received. - Expenditures awarded from the Federal Emergency Management Agency (FEMA), must be presented on the Schedule when; 1) FEMA has approved the Town’s project worksheet (PW) and 2) the Town has incurred the eligible expenditures. The $305,000 reported for Disaster Grants – Public Assistance (Presidentially Declared Disasters), AL 97.036, represents expenditures incurred in prior years that were approved by FEMA during fiscal year 2023. 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 Improve Time and Effort Documentation Federal Agency: U.S. Department of Education Cluster/Program: Special Education Cluster Award Name: Special Education Grants to States AL Number(s): 84.027/84.173 Award Year: 2023 Compliance Requirement: Allowable Costs/Cost Principles Type of Finding Compliance Internal Control over Compliance – Significant Deficiency Criteria or Specific Requirement Grantees must provide reasonable assurance that Federal awards are expended only for allowable activities and that the costs of goods and services charged to Federal awards are allowable and in accordance with the applicable cost principles. An employee whose salary is paid in part from federal grant funds and in part from other revenue sources must maintain time and effort distribution records, such as activity reports or timesheets, that document the portion of time spent working on tasks related to the federal grant program and time spent on programs supported by the other revenue sources. Management 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 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 As a result of our testing, we determined that time and effort semiannual certifications for salaried individuals paid from federal grant funds and in part from other revenue sources for the period under audit were not properly approved. There were also some employees whose time and effort documentation were not maintained. Cause Weaknesses in the design and operation of controls. Effect or Potential Effect Time and effort documentation did not meet federal requirements. There is a risk that amounts charged to federal awards may not be allowable or in accordance with applicable cost principles. Questioned Costs Due to the condition noted, we were unable to determine if payroll costs charged to the applicable grants are allowable. AL Questioned Number(s) Name of Federal Program or Cluster Costs 84.027/84.173 Special Education Cluster Unknown Recommendation The School Department should address the weaknesses in internal controls noted above in order to provide reasonable assurance that federal awards are expended only for allowable activities, and that the costs services charged to federal awards are allowable and in accordance with the applicable cost principles. Views of Responsible Official and Planned Corrective Action Management’s views and corrective action plan is included at the end of this report.
2023-001 Improve Time and Effort Documentation Federal Agency: U.S. Department of Education Cluster/Program: Special Education Cluster Award Name: Special Education Grants to States AL Number(s): 84.027/84.173 Award Year: 2023 Compliance Requirement: Allowable Costs/Cost Principles Type of Finding Compliance Internal Control over Compliance – Significant Deficiency Criteria or Specific Requirement Grantees must provide reasonable assurance that Federal awards are expended only for allowable activities and that the costs of goods and services charged to Federal awards are allowable and in accordance with the applicable cost principles. An employee whose salary is paid in part from federal grant funds and in part from other revenue sources must maintain time and effort distribution records, such as activity reports or timesheets, that document the portion of time spent working on tasks related to the federal grant program and time spent on programs supported by the other revenue sources. Management 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 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 As a result of our testing, we determined that time and effort semiannual certifications for salaried individuals paid from federal grant funds and in part from other revenue sources for the period under audit were not properly approved. There were also some employees whose time and effort documentation were not maintained. Cause Weaknesses in the design and operation of controls. Effect or Potential Effect Time and effort documentation did not meet federal requirements. There is a risk that amounts charged to federal awards may not be allowable or in accordance with applicable cost principles. Questioned Costs Due to the condition noted, we were unable to determine if payroll costs charged to the applicable grants are allowable. AL Questioned Number(s) Name of Federal Program or Cluster Costs 84.027/84.173 Special Education Cluster Unknown Recommendation The School Department should address the weaknesses in internal controls noted above in order to provide reasonable assurance that federal awards are expended only for allowable activities, and that the costs services charged to federal awards are allowable and in accordance with the applicable cost principles. Views of Responsible Official and Planned Corrective Action Management’s views and corrective action plan is included at the end of this report.