FAC Explorer

Audit 309695

FY End
2023-06-30
Total Expended
$3.92M
Findings
10
Programs
10
Organization: Ayer Shirley Regional School District (MA)
Year: 2023 Accepted: 2024-06-24
Auditor: Roselli Clark and Associates

Organization Exclusion Status:

Findings

ID Ref Severity Repeat Requirement
401787 2023-003 Material Weakness - L
401788 2023-003 Material Weakness - L
401789 2023-003 Material Weakness - L
401790 2023-003 Material Weakness - L
401791 2023-003 Material Weakness - L
978229 2023-003 Material Weakness - L
978230 2023-003 Material Weakness - L
978231 2023-003 Material Weakness - L
978232 2023-003 Material Weakness - L
978233 2023-003 Material Weakness - L

Programs

ALN Program Spent Major Findings
10.553 School Breakfast Program $77,787 - 0
10.555 National School Lunch Program $76,753 - 0
84.027 Special Education_grants to States $65,685 - 0
84.010 Title I Grants to Local Educational Agencies $19,475 - 0
84.365 English Language Acquisition State Grants $14,934 - 0
84.425 Education Stabilization Fund $7,688 Yes 1
84.367 Improving Teacher Quality State Grants $7,428 - 0
32.004 Universal Service Fund - Schools and Libraries $6,654 - 0
84.424 Student Support and Academic Enrichment Program $6,018 - 0
84.173 Special Education_preschool Grants $5,442 - 0

Contacts

Name Title Type
EGCMNDKKL9N4 William Plunkett Auditee
9787728600 Paul Gargano Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Accounting policies and financial reporting practices permitted for municipalities in Massachusetts are prescribed by the Uniform Municipal Accounting System (UMAS) promulgated by the Commonwealth of Massachusetts Department of Revenue. The accompanying Schedule includes the federal grant transactions of the District. Although some of these programs may be supplemented with state and other revenue, only federal activity is shown. 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. De Minimis Rate Used: N Rate Explanation: The District has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of the Ayer Shirley Regional School District (the District) under programs of the federal government for the year ended June 30, 2023. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations 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 District, it is not intended to and does not present the financial position, changes in net position, or cash flows of the District.
Title: U.S. Department of Agriculture Programs Accounting Policies: Accounting policies and financial reporting practices permitted for municipalities in Massachusetts are prescribed by the Uniform Municipal Accounting System (UMAS) promulgated by the Commonwealth of Massachusetts Department of Revenue. The accompanying Schedule includes the federal grant transactions of the District. Although some of these programs may be supplemented with state and other revenue, only federal activity is shown. 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. De Minimis Rate Used: N Rate Explanation: The District has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. The District receives non-cash commodities from the U.S. Department of Agriculture as a part of the National School Lunch program. The amounts reported as non-cash assistance represent the fair market value of these commodities received during the year. The amounts reported as cash assistance represent federal reimbursements for meals provided.

Finding Details

Finding 2023-003
2023-003 U.S. Department of Education Passed-through the Commonwealth of Massachusetts’ Department of Elementary and Secondary Education COVID-19 – Education Stabilization Fund – ALN 84.425, 84.425D, 84.425U, 84.425W Material Weakness in Internal Controls Over Compliance Criteria: Per 2 CFR section 200.1, proper internal controls should be implemented to ensure transactions are properly recorded and accounted for in order to permit the preparation of reliable financial statements and federal reports. Condition: The District recorded a duplicate deposit of $133,868 in federal funds to the general ledger. Cause: There is a lack of reconciling the general ledger activity to the final financial reporting before submission to the Department of Elementary and Secondary Education. Effect: Material audit adjustments were required to the District’s general ledger for financial reporting purposes. The client did not duplicate the deposit on the final financial report submitted to the Department of Elementary and Secondary Education. Repeat Finding from Prior Year: No. Recommendation: The District should implement a process to reconcile final financial reports to the general ledger before submission. Views of Responsible Official: Management agrees with the finding.
Finding 2023-003
2023-003 U.S. Department of Education Passed-through the Commonwealth of Massachusetts’ Department of Elementary and Secondary Education COVID-19 – Education Stabilization Fund – ALN 84.425, 84.425D, 84.425U, 84.425W Material Weakness in Internal Controls Over Compliance Criteria: Per 2 CFR section 200.1, proper internal controls should be implemented to ensure transactions are properly recorded and accounted for in order to permit the preparation of reliable financial statements and federal reports. Condition: The District recorded a duplicate deposit of $133,868 in federal funds to the general ledger. Cause: There is a lack of reconciling the general ledger activity to the final financial reporting before submission to the Department of Elementary and Secondary Education. Effect: Material audit adjustments were required to the District’s general ledger for financial reporting purposes. The client did not duplicate the deposit on the final financial report submitted to the Department of Elementary and Secondary Education. Repeat Finding from Prior Year: No. Recommendation: The District should implement a process to reconcile final financial reports to the general ledger before submission. Views of Responsible Official: Management agrees with the finding.
Finding 2023-003
2023-003 U.S. Department of Education Passed-through the Commonwealth of Massachusetts’ Department of Elementary and Secondary Education COVID-19 – Education Stabilization Fund – ALN 84.425, 84.425D, 84.425U, 84.425W Material Weakness in Internal Controls Over Compliance Criteria: Per 2 CFR section 200.1, proper internal controls should be implemented to ensure transactions are properly recorded and accounted for in order to permit the preparation of reliable financial statements and federal reports. Condition: The District recorded a duplicate deposit of $133,868 in federal funds to the general ledger. Cause: There is a lack of reconciling the general ledger activity to the final financial reporting before submission to the Department of Elementary and Secondary Education. Effect: Material audit adjustments were required to the District’s general ledger for financial reporting purposes. The client did not duplicate the deposit on the final financial report submitted to the Department of Elementary and Secondary Education. Repeat Finding from Prior Year: No. Recommendation: The District should implement a process to reconcile final financial reports to the general ledger before submission. Views of Responsible Official: Management agrees with the finding.
Finding 2023-003
2023-003 U.S. Department of Education Passed-through the Commonwealth of Massachusetts’ Department of Elementary and Secondary Education COVID-19 – Education Stabilization Fund – ALN 84.425, 84.425D, 84.425U, 84.425W Material Weakness in Internal Controls Over Compliance Criteria: Per 2 CFR section 200.1, proper internal controls should be implemented to ensure transactions are properly recorded and accounted for in order to permit the preparation of reliable financial statements and federal reports. Condition: The District recorded a duplicate deposit of $133,868 in federal funds to the general ledger. Cause: There is a lack of reconciling the general ledger activity to the final financial reporting before submission to the Department of Elementary and Secondary Education. Effect: Material audit adjustments were required to the District’s general ledger for financial reporting purposes. The client did not duplicate the deposit on the final financial report submitted to the Department of Elementary and Secondary Education. Repeat Finding from Prior Year: No. Recommendation: The District should implement a process to reconcile final financial reports to the general ledger before submission. Views of Responsible Official: Management agrees with the finding.
Finding 2023-003
2023-003 U.S. Department of Education Passed-through the Commonwealth of Massachusetts’ Department of Elementary and Secondary Education COVID-19 – Education Stabilization Fund – ALN 84.425, 84.425D, 84.425U, 84.425W Material Weakness in Internal Controls Over Compliance Criteria: Per 2 CFR section 200.1, proper internal controls should be implemented to ensure transactions are properly recorded and accounted for in order to permit the preparation of reliable financial statements and federal reports. Condition: The District recorded a duplicate deposit of $133,868 in federal funds to the general ledger. Cause: There is a lack of reconciling the general ledger activity to the final financial reporting before submission to the Department of Elementary and Secondary Education. Effect: Material audit adjustments were required to the District’s general ledger for financial reporting purposes. The client did not duplicate the deposit on the final financial report submitted to the Department of Elementary and Secondary Education. Repeat Finding from Prior Year: No. Recommendation: The District should implement a process to reconcile final financial reports to the general ledger before submission. Views of Responsible Official: Management agrees with the finding.
Finding 2023-003
2023-003 U.S. Department of Education Passed-through the Commonwealth of Massachusetts’ Department of Elementary and Secondary Education COVID-19 – Education Stabilization Fund – ALN 84.425, 84.425D, 84.425U, 84.425W Material Weakness in Internal Controls Over Compliance Criteria: Per 2 CFR section 200.1, proper internal controls should be implemented to ensure transactions are properly recorded and accounted for in order to permit the preparation of reliable financial statements and federal reports. Condition: The District recorded a duplicate deposit of $133,868 in federal funds to the general ledger. Cause: There is a lack of reconciling the general ledger activity to the final financial reporting before submission to the Department of Elementary and Secondary Education. Effect: Material audit adjustments were required to the District’s general ledger for financial reporting purposes. The client did not duplicate the deposit on the final financial report submitted to the Department of Elementary and Secondary Education. Repeat Finding from Prior Year: No. Recommendation: The District should implement a process to reconcile final financial reports to the general ledger before submission. Views of Responsible Official: Management agrees with the finding.
Finding 2023-003
2023-003 U.S. Department of Education Passed-through the Commonwealth of Massachusetts’ Department of Elementary and Secondary Education COVID-19 – Education Stabilization Fund – ALN 84.425, 84.425D, 84.425U, 84.425W Material Weakness in Internal Controls Over Compliance Criteria: Per 2 CFR section 200.1, proper internal controls should be implemented to ensure transactions are properly recorded and accounted for in order to permit the preparation of reliable financial statements and federal reports. Condition: The District recorded a duplicate deposit of $133,868 in federal funds to the general ledger. Cause: There is a lack of reconciling the general ledger activity to the final financial reporting before submission to the Department of Elementary and Secondary Education. Effect: Material audit adjustments were required to the District’s general ledger for financial reporting purposes. The client did not duplicate the deposit on the final financial report submitted to the Department of Elementary and Secondary Education. Repeat Finding from Prior Year: No. Recommendation: The District should implement a process to reconcile final financial reports to the general ledger before submission. Views of Responsible Official: Management agrees with the finding.
Finding 2023-003
2023-003 U.S. Department of Education Passed-through the Commonwealth of Massachusetts’ Department of Elementary and Secondary Education COVID-19 – Education Stabilization Fund – ALN 84.425, 84.425D, 84.425U, 84.425W Material Weakness in Internal Controls Over Compliance Criteria: Per 2 CFR section 200.1, proper internal controls should be implemented to ensure transactions are properly recorded and accounted for in order to permit the preparation of reliable financial statements and federal reports. Condition: The District recorded a duplicate deposit of $133,868 in federal funds to the general ledger. Cause: There is a lack of reconciling the general ledger activity to the final financial reporting before submission to the Department of Elementary and Secondary Education. Effect: Material audit adjustments were required to the District’s general ledger for financial reporting purposes. The client did not duplicate the deposit on the final financial report submitted to the Department of Elementary and Secondary Education. Repeat Finding from Prior Year: No. Recommendation: The District should implement a process to reconcile final financial reports to the general ledger before submission. Views of Responsible Official: Management agrees with the finding.
Finding 2023-003
2023-003 U.S. Department of Education Passed-through the Commonwealth of Massachusetts’ Department of Elementary and Secondary Education COVID-19 – Education Stabilization Fund – ALN 84.425, 84.425D, 84.425U, 84.425W Material Weakness in Internal Controls Over Compliance Criteria: Per 2 CFR section 200.1, proper internal controls should be implemented to ensure transactions are properly recorded and accounted for in order to permit the preparation of reliable financial statements and federal reports. Condition: The District recorded a duplicate deposit of $133,868 in federal funds to the general ledger. Cause: There is a lack of reconciling the general ledger activity to the final financial reporting before submission to the Department of Elementary and Secondary Education. Effect: Material audit adjustments were required to the District’s general ledger for financial reporting purposes. The client did not duplicate the deposit on the final financial report submitted to the Department of Elementary and Secondary Education. Repeat Finding from Prior Year: No. Recommendation: The District should implement a process to reconcile final financial reports to the general ledger before submission. Views of Responsible Official: Management agrees with the finding.
Finding 2023-003
2023-003 U.S. Department of Education Passed-through the Commonwealth of Massachusetts’ Department of Elementary and Secondary Education COVID-19 – Education Stabilization Fund – ALN 84.425, 84.425D, 84.425U, 84.425W Material Weakness in Internal Controls Over Compliance Criteria: Per 2 CFR section 200.1, proper internal controls should be implemented to ensure transactions are properly recorded and accounted for in order to permit the preparation of reliable financial statements and federal reports. Condition: The District recorded a duplicate deposit of $133,868 in federal funds to the general ledger. Cause: There is a lack of reconciling the general ledger activity to the final financial reporting before submission to the Department of Elementary and Secondary Education. Effect: Material audit adjustments were required to the District’s general ledger for financial reporting purposes. The client did not duplicate the deposit on the final financial report submitted to the Department of Elementary and Secondary Education. Repeat Finding from Prior Year: No. Recommendation: The District should implement a process to reconcile final financial reports to the general ledger before submission. Views of Responsible Official: Management agrees with the finding.