Audit 21843

FY End
2022-06-30
Total Expended
$5.70M
Findings
4
Programs
9
Year: 2022 Accepted: 2023-09-26

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
25786 2022-002 Material Weakness Yes B
25787 2022-003 - - P
602228 2022-002 Material Weakness Yes B
602229 2022-003 - - P

Programs

ALN Program Spent Major Findings
10.555 National School Lunch Program $1.67M - 0
10.553 School Breakfast Program $555,011 - 0
84.365 English Language Acquisition State Grants $34,245 - 0
84.425 Education Stabilization Fund $33,379 Yes 0
84.027 Special Education_grants to States $11,556 Yes 0
84.010 Title I Grants to Local Educational Agencies $6,312 - 0
84.367 Improving Teacher Quality State Grants $5,197 - 0
84.424 Student Support and Academic Enrichment Program $4,611 - 0
84.173 Special Education_preschool Grants $2,886 Yes 0

Contacts

Name Title Type
J9PMGBDSCA98 David Flynn Auditee
5083987610 Grady Connor 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. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. The information included in the Schedule may not fully agree with other federal award reports the District submits to federal awarding or pass-through entities. The District has not elected to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The Dennis-Yarmouth Regional School District (the District) is a governmental agency established by the laws of the Commonwealth of Massachusetts, for the purposes of providing public education for grades kindergarten through high school grade 12. It is comprised of its member towns of Dennis and Yarmouth. All operations related to the District's federal grant programs are included in the scope of the OMB Uniform Guidance. The U.S. Department of Education has been designated as the Districts oversight agency for purposes of the audit.The accompanying schedule of expenditures of federal awards (Schedule) includes the federal award activity of the Dennis-Yarmouth Regional School District for the year ended June 30, 2022. 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 Dennis-Yarmouth Regional School District it is not intended to and does not present the financial position, or changes in the financial position of the District.
Title: Cash and Non-cash Assistance - Child Nutrition Cluster 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. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. The information included in the Schedule may not fully agree with other federal award reports the District submits to federal awarding or pass-through entities. The District has not elected to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The following define the cash and non-cash assistance provided by the U.S. Department of Agriculture's Child Nutrition cluster School Breakfast Program (Assistance Listing #10.553) and National School Lunch Program (Assistance Listing #10.555).Cash assistance - expenditures represent federal reimbursement for meals during the year. Reimbursements for meals as a result of the COV-19 pandemic have been reimbursed through the Districts summer food service program and have been identified with the prefix- COVID-19. Non-cash assistance - represent food commodities received under a state distribution formula and are valued at federally published wholesale prices for purposes of this schedule. Such commodities are not recorded in the financial records, although memorandum records are maintained.
Title: Subrecipients 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. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. The information included in the Schedule may not fully agree with other federal award reports the District submits to federal awarding or pass-through entities. The District has not elected to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The District did not have any subrecipients for the year ended June 30, 2022.
Title: COVID-19 pandemic related funding 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. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. The information included in the Schedule may not fully agree with other federal award reports the District submits to federal awarding or pass-through entities. The District has not elected to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Programs identified in the accompanying Schedule of Expenditures of Federal Awards which have been funded pursuant to federal legislation as a result of the coronavirus pandemic have been specifically indicated with the prefix- COVID-19.

Finding Details

U.S. DEPARTMENT OF EDUCATION Passed through the Commonwealth of Massachusetts?Department of Elementary and Secondary Education Material Weakness 2022-002: Special Education Cluster ? SPED Grants to States, IDEA, Part B (Assistance Listing #84.027) Pass-through program number: 0240-577419-2022-0645; Fiscal year ending June 30, 2022 Criteria: Established internal controls surrounding documentation of federal award compliance requirements should ensure that all charges to Federal awards for salaries and wages are based on records that accurately reflect the work performed. Accordingly, time and effort documentation are required to be maintained which clearly documents ?after-the -fact? determinations of amounts for which individuals have worked on the federal program. These records should correspond with the internal control policies and procedures maintained by the District. Condition and Context: During our audit work associated with time and effort certifications, we noted a population of approximately (11) individuals being consistently charged to the grant program through the fiscal year. Of the four (4) individuals tested, no time & effort certifications were maintained on file for the fiscal year 2022. Salaries for the tested individuals were in accordance with expected pay schedule/contracts. Based upon our discussion with personnel, for fiscal year 2023, the District budgeting within the grant award has been changed to charge non-salary related allowable costs to the award ongoing. Cause and effect: Effective for fiscal year 2022, the District implemented a formalized grants manual. However, grants personnel incorrectly interpreted ?time & effort? requirements for personnel in accordance with the District?s established procedures. The District?s established procedures did not provide for adequate monitoring and review in accordance with the adopted policies and procedures. Perspective Information: There was a similar finding in the prior years related to allowable costs associated with the maintenance of appropriate time & effort certifications (2021-002; 2020-002). There was a finding related to enhanced formalization of grant compliance was previously reported in the previous years? audit reports as a finding.(2021-003; 2020-004). Questioned Costs: $236,230 represents the approximate charge to the program of salary of the (4) individuals for whom there were no time & effort certifications on file for the year ended June 30, 2022. As indicated, the actual amounts paid, corresponded with expected pay schedule/contracts. Total salaries and wages charged to the program for fiscal year 2022 was $637,307. Auditor?s Recommendation: The District should review currently established policies and procedures for maintenance of time and effort certifications as established within adopted grants manual. Personnel should review established policies and procedures on a routine basis to ensure the District?s compliance with all aspects of the District?s established policies and procedures as well as individual requirements pursuant to OMB. Established policies and procedures should be reviewed on an annual basis to ensure continued compliance with ever changing federal compliance and other financial reporting requirements. View of Responsible Official and Planned Corrective Action: The District expects significant improvement in the administration and monitoring of grant activity during the current fiscal year with additional review of the procedure manual and new personnel. Additionally, as indicated by the auditor, the budgeting for the 240 SPED allocation grant in fiscal year 2023 has been changed to exclude personnel costs (salaries & wages) subject to the ?time & effort? certifications. District personnel will review established grants policies and procedures manual with current federal awards.
Other Matters: 2022-003 Completion and filing of the Single Audit in accordance with OMB guidelines. Criteria: OMB guidelines generally requires the District?s Single Audit to be completed and filed by March 31 of the following year (March 31, 2023). Condition: The District was unable to meet the filing deadline in the current year. Effect: The District?s filing is considered late by OMB. Auditor?s Recommendation: We recommend the District work to meet the required filing deadline. View of Responsible Official and Planned Corrective Action: The District expects to meet filing deadlines in the future.
U.S. DEPARTMENT OF EDUCATION Passed through the Commonwealth of Massachusetts?Department of Elementary and Secondary Education Material Weakness 2022-002: Special Education Cluster ? SPED Grants to States, IDEA, Part B (Assistance Listing #84.027) Pass-through program number: 0240-577419-2022-0645; Fiscal year ending June 30, 2022 Criteria: Established internal controls surrounding documentation of federal award compliance requirements should ensure that all charges to Federal awards for salaries and wages are based on records that accurately reflect the work performed. Accordingly, time and effort documentation are required to be maintained which clearly documents ?after-the -fact? determinations of amounts for which individuals have worked on the federal program. These records should correspond with the internal control policies and procedures maintained by the District. Condition and Context: During our audit work associated with time and effort certifications, we noted a population of approximately (11) individuals being consistently charged to the grant program through the fiscal year. Of the four (4) individuals tested, no time & effort certifications were maintained on file for the fiscal year 2022. Salaries for the tested individuals were in accordance with expected pay schedule/contracts. Based upon our discussion with personnel, for fiscal year 2023, the District budgeting within the grant award has been changed to charge non-salary related allowable costs to the award ongoing. Cause and effect: Effective for fiscal year 2022, the District implemented a formalized grants manual. However, grants personnel incorrectly interpreted ?time & effort? requirements for personnel in accordance with the District?s established procedures. The District?s established procedures did not provide for adequate monitoring and review in accordance with the adopted policies and procedures. Perspective Information: There was a similar finding in the prior years related to allowable costs associated with the maintenance of appropriate time & effort certifications (2021-002; 2020-002). There was a finding related to enhanced formalization of grant compliance was previously reported in the previous years? audit reports as a finding.(2021-003; 2020-004). Questioned Costs: $236,230 represents the approximate charge to the program of salary of the (4) individuals for whom there were no time & effort certifications on file for the year ended June 30, 2022. As indicated, the actual amounts paid, corresponded with expected pay schedule/contracts. Total salaries and wages charged to the program for fiscal year 2022 was $637,307. Auditor?s Recommendation: The District should review currently established policies and procedures for maintenance of time and effort certifications as established within adopted grants manual. Personnel should review established policies and procedures on a routine basis to ensure the District?s compliance with all aspects of the District?s established policies and procedures as well as individual requirements pursuant to OMB. Established policies and procedures should be reviewed on an annual basis to ensure continued compliance with ever changing federal compliance and other financial reporting requirements. View of Responsible Official and Planned Corrective Action: The District expects significant improvement in the administration and monitoring of grant activity during the current fiscal year with additional review of the procedure manual and new personnel. Additionally, as indicated by the auditor, the budgeting for the 240 SPED allocation grant in fiscal year 2023 has been changed to exclude personnel costs (salaries & wages) subject to the ?time & effort? certifications. District personnel will review established grants policies and procedures manual with current federal awards.
Other Matters: 2022-003 Completion and filing of the Single Audit in accordance with OMB guidelines. Criteria: OMB guidelines generally requires the District?s Single Audit to be completed and filed by March 31 of the following year (March 31, 2023). Condition: The District was unable to meet the filing deadline in the current year. Effect: The District?s filing is considered late by OMB. Auditor?s Recommendation: We recommend the District work to meet the required filing deadline. View of Responsible Official and Planned Corrective Action: The District expects to meet filing deadlines in the future.