Audit 342839

FY End
2024-06-30
Total Expended
$10.44M
Findings
6
Programs
22
Organization: Middlebury Community Schools (IN)
Year: 2024 Accepted: 2025-02-18

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
523549 2024-002 Material Weakness - E
523550 2024-003 Material Weakness - G
523551 2024-002 Material Weakness - E
1099991 2024-002 Material Weakness - E
1099992 2024-003 Material Weakness - G
1099993 2024-002 Material Weakness - E

Programs

ALN Program Spent Major Findings
10.555 National School Lunch Program 2023 $1.65M Yes 0
10.555 National School Lunch Program 2024 $1.34M Yes 0
84.425 Education Stabilization Fund 2023 $1.22M - 0
84.027 Special Education Grants to States 2023 $843,269 - 0
84.010 Title I Grants to Local Educational Agencies 2024 $442,070 Yes 1
84.010 Title I Grants to Local Educational Agencies 2023 $346,837 Yes 2
10.553 School Breakfast Program 2023 $281,003 Yes 0
84.027 Special Education Grants to States 2024 $249,068 - 0
10.553 School Breakfast Program 2024 $241,520 Yes 0
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) 2024 $114,823 - 0
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) 2023 $104,227 - 0
84.048 Career and Technical Education -- Basic Grants to States 2024 $69,417 - 0
84.424 Student Support and Academic Enrichment Program 2023 $56,981 - 0
93.778 Medical Assistance Program 2024 $51,352 - 0
84.424 Student Support and Academic Enrichment Program 2024 $41,040 - 0
84.365 English Language Acquisition State Grants 2024 $38,148 - 0
84.173 Special Education Preschool Grants 2024 $37,105 - 0
84.365 English Language Acquisition State Grants 2023 $28,589 - 0
93.778 Medical Assistance Program 2023 $23,877 - 0
10.579 Child Nutrition Discretionary Grants Limited Availability 2023 $21,461 - 0
84.425 Education Stabilization Fund 2024 $17,470 - 0
10.649 Pandemic Ebt Administrative Costs 2023 $3,135 - 0

Contacts

Name Title Type
WZRLHCQJC953 Lisa Stutsman Auditee
5748259425 Beth Kelley Auditor
No contacts on file

Notes to SEFA

Title: Note 3. GEER I Expenditures Accounting Policies: Note 1. Summary of Significant Accounting Policies A. Basis of Presentation The accompanying Schedule of Expenditures of Federal Awards (SEFA) includes the federal award activity of the School Corporation under programs of the federal government for the years ended June 30, 2023 and 2024. The information in the SEFA 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 SEFA presents only a select portion of the operations of the School Corporation, it is not intended to and does not present the financial position of the School Corporation. The Uniform Guidance requires an annual audit of non-federal entities expending a total amount of federal awards equal to or in excess of $750,000 in any fiscal year unless by constitution or statute a less frequent audit is required. In accordance with Indiana Code (IC 5-11-1-25), audits of school corporations shall be conducted biennially. Such audits shall include both years within the biennial period. B. Other Significant Accounting Policies Expenditures reported on the SEFA are reported on the cash basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles in OMB Circular A-87, Cost Principles for State, Local, and Indian Tribal Governments, or the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowed or are limited as to reimbursement. When federal grants are received on a reimbursement basis, the federal awards are considered expended when the reimbursement is received. De Minimis Rate Used: N Rate Explanation: Note 2. Indirect Cost Rate The School Corporation has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. Note 3. GEER I Expenditures The School Corporation was a participant in a joint application with other Local Educational Agencies to receive GEER I funding from the Education Stabilization Fund through the Indiana Department of Education. Indiana University Indianapolis served as the fiscal agent for the award and expended award funds for equipment, supplies, and services on behalf of all participants. The School Corporation received equipment, supplies, and services as a result of the awarded grant in the amount of $188,293. As a result, the activity for the GEER I award that is presented as federal awards expended on the SEFA is not presented as receipts and disbursements on the financial statement for the School Corporation.

Finding Details

FINDING 2024-002 Subject: Title I Grants to Local Educational Agencies - Eligibility Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A210014, S010A230014, S010A220014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility Audit Finding: Material Weakness Condition and Context The School Corporation submits the October Real Time Data (RT) report each year to the Indiana Department of Education. This data is used to report the School Corporation's enrollment and poverty (socioeconomic) status of the students enrolled in each school. The annual Pupil Enrollment count is a compilation of data from all RT and Enrollment and Mobility reports, for public and non-public schools respectively, which then becomes the official enrollment count for each school. This compiled data populates the socioeconomic status counts on the Eligible School Summary of the Title I applications for the School Corporation, which determines group eligibility for the program. The School Corporation had not designed or implemented a system of internal controls that included an oversight or review process to prevent or detect student socioeconomic status count errors on the Eligible School Summary of the Title I applications for the School Corporation. The lack of internal controls was a systemic issue that occurred throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." Cause The socioeconomic status counts on the Eligible School Summary of the Title I application were prepopulated and, as such, the grant specialist believed the data was correct and did not perform a review to ensure its accuracy. Effect Without a proper review of the data, the socioeconomic counts in the Title I application could be incorrect. Incorrect data in the Title I application could lead to an incorrect determination of Title I eligibility. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls, including segregation of duties, related to the grant agreement and the eligibility compliance requirements. An internal control system, including segregation of duties, should be designed and operate effectively to provide reasonable assurance that material noncompliance with the grant agreement or a compliance requirement of a federal program will be prevented, or detected and corrected, on a timely basis. In order to have an effective internal control system, it is important to have proper segregation of duties. This is accomplished by making sure proper oversight, reviews, and approvals take place and to have a separation of functions over certain activities related to the program. The fundamental premise of segregation of duties is that an individual or small group of individuals should not be in a position to initiate, approve, undertake, and review the same activity. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-003 Subject: Title I Grants to Local Educational Agencies - Earmarking Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Number and Year (or Other Identifying Number): S010A210014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Findings: Material Weakness, Other Matters Condition and Context Homeless children and youth are automatically eligible for services under Title I, Part A, whether or not they live in a Title I school attendance area or meet the academic standards required of other children for eligibility. The School Corporation is required to reserve (set-aside) the funds necessary to provide homeless children services comparable to services provided in Title I, Part A schools. The set-aside is to be a reasonable amount of funds to meet the needs of the homeless population in the school community. At the end of each grant period, if the School Corporation's obligation to provide services to students experiencing homelessness has been met, but the amount needed to meet that obligation was less than the amount the school had reserved, the school may carry over those unused funds to support any allowable Title I, Part A activities in the next school year. However, if at the end of each grant period the School Corporation's obligation to provide services has not been met, the funds must be carried over to the next school year to provide services to those students experiencing homelessness, in addition to reserving funds from that next school year's grant award for that purpose. The 2021-2022 grant award homeless reservation was $8,600. The School Corporation did not spend any of the funds, but was determined to have met its obligation based on documentation provided. However, through inspection of the final grant report, it was determined that $276 of the $8,600 was used inappropriately in the current school year for other Title I, Part A activities and not for the needs of the homeless student population. The lack of internal controls and noncompliance were isolated to the 2022-2023 school year. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.400 states in part: "The application of these cost principles is based on the fundamental premises that: (a) The recipient and subrecipient are responsible for the efficient and effective administration of the Federal award through sound management practices. (b) The recipient and subrecipient are responsible for administering Federal funds in a manner consistent with Federal statutes, regulations, and the terms and conditions of the Federal award. . . ." 20 USC 6313(c)(3)(A) states: "A local educational agency shall reserve such funds as are necessary under this part, determined in accordance with subparagraphs (B) and (C), to provide services comparable to those provided to children in schools funded under this part to serve - (i) homeless children and youths, including providing educationally related support services to children in shelters and other locations where children may live; (ii) children in local institutions for neglected children; and (iii) if appropriate, children in local institutions for delinquent children, and neglected or delinquent children in community day programs." Cause Total expenditures for the grant were not adequately monitored to ensure funds from the homeless reservation were not spent on other activities. Effect A portion of the homeless reservation was spent on activities not related to the homeless population. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls, including segregation of duties, related to the grant agreement and the earmarking compliance requirements. An internal control system, including segregation of duties, should be designed and operate effectively to provide reasonable assurance that material noncompliance with the grant agreement or a compliance requirement of a federal program will be prevented, or detected and corrected, on a timely basis. In order to have an effective internal control system, it is important to have proper segregation of duties. This is accomplished by making sure proper oversight, reviews, and approvals take place and to have a separation of functions over certain activities related to the program. The fundamental premise of segregation of duties is that an individual or small group of individuals should not be in a position to initiate, approve, undertake, and review the same activity. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-002 Subject: Title I Grants to Local Educational Agencies - Eligibility Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A210014, S010A230014, S010A220014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility Audit Finding: Material Weakness Condition and Context The School Corporation submits the October Real Time Data (RT) report each year to the Indiana Department of Education. This data is used to report the School Corporation's enrollment and poverty (socioeconomic) status of the students enrolled in each school. The annual Pupil Enrollment count is a compilation of data from all RT and Enrollment and Mobility reports, for public and non-public schools respectively, which then becomes the official enrollment count for each school. This compiled data populates the socioeconomic status counts on the Eligible School Summary of the Title I applications for the School Corporation, which determines group eligibility for the program. The School Corporation had not designed or implemented a system of internal controls that included an oversight or review process to prevent or detect student socioeconomic status count errors on the Eligible School Summary of the Title I applications for the School Corporation. The lack of internal controls was a systemic issue that occurred throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." Cause The socioeconomic status counts on the Eligible School Summary of the Title I application were prepopulated and, as such, the grant specialist believed the data was correct and did not perform a review to ensure its accuracy. Effect Without a proper review of the data, the socioeconomic counts in the Title I application could be incorrect. Incorrect data in the Title I application could lead to an incorrect determination of Title I eligibility. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls, including segregation of duties, related to the grant agreement and the eligibility compliance requirements. An internal control system, including segregation of duties, should be designed and operate effectively to provide reasonable assurance that material noncompliance with the grant agreement or a compliance requirement of a federal program will be prevented, or detected and corrected, on a timely basis. In order to have an effective internal control system, it is important to have proper segregation of duties. This is accomplished by making sure proper oversight, reviews, and approvals take place and to have a separation of functions over certain activities related to the program. The fundamental premise of segregation of duties is that an individual or small group of individuals should not be in a position to initiate, approve, undertake, and review the same activity. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-002 Subject: Title I Grants to Local Educational Agencies - Eligibility Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A210014, S010A230014, S010A220014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility Audit Finding: Material Weakness Condition and Context The School Corporation submits the October Real Time Data (RT) report each year to the Indiana Department of Education. This data is used to report the School Corporation's enrollment and poverty (socioeconomic) status of the students enrolled in each school. The annual Pupil Enrollment count is a compilation of data from all RT and Enrollment and Mobility reports, for public and non-public schools respectively, which then becomes the official enrollment count for each school. This compiled data populates the socioeconomic status counts on the Eligible School Summary of the Title I applications for the School Corporation, which determines group eligibility for the program. The School Corporation had not designed or implemented a system of internal controls that included an oversight or review process to prevent or detect student socioeconomic status count errors on the Eligible School Summary of the Title I applications for the School Corporation. The lack of internal controls was a systemic issue that occurred throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." Cause The socioeconomic status counts on the Eligible School Summary of the Title I application were prepopulated and, as such, the grant specialist believed the data was correct and did not perform a review to ensure its accuracy. Effect Without a proper review of the data, the socioeconomic counts in the Title I application could be incorrect. Incorrect data in the Title I application could lead to an incorrect determination of Title I eligibility. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls, including segregation of duties, related to the grant agreement and the eligibility compliance requirements. An internal control system, including segregation of duties, should be designed and operate effectively to provide reasonable assurance that material noncompliance with the grant agreement or a compliance requirement of a federal program will be prevented, or detected and corrected, on a timely basis. In order to have an effective internal control system, it is important to have proper segregation of duties. This is accomplished by making sure proper oversight, reviews, and approvals take place and to have a separation of functions over certain activities related to the program. The fundamental premise of segregation of duties is that an individual or small group of individuals should not be in a position to initiate, approve, undertake, and review the same activity. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-003 Subject: Title I Grants to Local Educational Agencies - Earmarking Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Number and Year (or Other Identifying Number): S010A210014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Findings: Material Weakness, Other Matters Condition and Context Homeless children and youth are automatically eligible for services under Title I, Part A, whether or not they live in a Title I school attendance area or meet the academic standards required of other children for eligibility. The School Corporation is required to reserve (set-aside) the funds necessary to provide homeless children services comparable to services provided in Title I, Part A schools. The set-aside is to be a reasonable amount of funds to meet the needs of the homeless population in the school community. At the end of each grant period, if the School Corporation's obligation to provide services to students experiencing homelessness has been met, but the amount needed to meet that obligation was less than the amount the school had reserved, the school may carry over those unused funds to support any allowable Title I, Part A activities in the next school year. However, if at the end of each grant period the School Corporation's obligation to provide services has not been met, the funds must be carried over to the next school year to provide services to those students experiencing homelessness, in addition to reserving funds from that next school year's grant award for that purpose. The 2021-2022 grant award homeless reservation was $8,600. The School Corporation did not spend any of the funds, but was determined to have met its obligation based on documentation provided. However, through inspection of the final grant report, it was determined that $276 of the $8,600 was used inappropriately in the current school year for other Title I, Part A activities and not for the needs of the homeless student population. The lack of internal controls and noncompliance were isolated to the 2022-2023 school year. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.400 states in part: "The application of these cost principles is based on the fundamental premises that: (a) The recipient and subrecipient are responsible for the efficient and effective administration of the Federal award through sound management practices. (b) The recipient and subrecipient are responsible for administering Federal funds in a manner consistent with Federal statutes, regulations, and the terms and conditions of the Federal award. . . ." 20 USC 6313(c)(3)(A) states: "A local educational agency shall reserve such funds as are necessary under this part, determined in accordance with subparagraphs (B) and (C), to provide services comparable to those provided to children in schools funded under this part to serve - (i) homeless children and youths, including providing educationally related support services to children in shelters and other locations where children may live; (ii) children in local institutions for neglected children; and (iii) if appropriate, children in local institutions for delinquent children, and neglected or delinquent children in community day programs." Cause Total expenditures for the grant were not adequately monitored to ensure funds from the homeless reservation were not spent on other activities. Effect A portion of the homeless reservation was spent on activities not related to the homeless population. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls, including segregation of duties, related to the grant agreement and the earmarking compliance requirements. An internal control system, including segregation of duties, should be designed and operate effectively to provide reasonable assurance that material noncompliance with the grant agreement or a compliance requirement of a federal program will be prevented, or detected and corrected, on a timely basis. In order to have an effective internal control system, it is important to have proper segregation of duties. This is accomplished by making sure proper oversight, reviews, and approvals take place and to have a separation of functions over certain activities related to the program. The fundamental premise of segregation of duties is that an individual or small group of individuals should not be in a position to initiate, approve, undertake, and review the same activity. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-002 Subject: Title I Grants to Local Educational Agencies - Eligibility Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A210014, S010A230014, S010A220014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility Audit Finding: Material Weakness Condition and Context The School Corporation submits the October Real Time Data (RT) report each year to the Indiana Department of Education. This data is used to report the School Corporation's enrollment and poverty (socioeconomic) status of the students enrolled in each school. The annual Pupil Enrollment count is a compilation of data from all RT and Enrollment and Mobility reports, for public and non-public schools respectively, which then becomes the official enrollment count for each school. This compiled data populates the socioeconomic status counts on the Eligible School Summary of the Title I applications for the School Corporation, which determines group eligibility for the program. The School Corporation had not designed or implemented a system of internal controls that included an oversight or review process to prevent or detect student socioeconomic status count errors on the Eligible School Summary of the Title I applications for the School Corporation. The lack of internal controls was a systemic issue that occurred throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." Cause The socioeconomic status counts on the Eligible School Summary of the Title I application were prepopulated and, as such, the grant specialist believed the data was correct and did not perform a review to ensure its accuracy. Effect Without a proper review of the data, the socioeconomic counts in the Title I application could be incorrect. Incorrect data in the Title I application could lead to an incorrect determination of Title I eligibility. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls, including segregation of duties, related to the grant agreement and the eligibility compliance requirements. An internal control system, including segregation of duties, should be designed and operate effectively to provide reasonable assurance that material noncompliance with the grant agreement or a compliance requirement of a federal program will be prevented, or detected and corrected, on a timely basis. In order to have an effective internal control system, it is important to have proper segregation of duties. This is accomplished by making sure proper oversight, reviews, and approvals take place and to have a separation of functions over certain activities related to the program. The fundamental premise of segregation of duties is that an individual or small group of individuals should not be in a position to initiate, approve, undertake, and review the same activity. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.