Audit 31821

FY End
2022-06-30
Total Expended
$1.23M
Findings
12
Programs
10
Organization: Manhattan School District 114 (IL)
Year: 2022 Accepted: 2023-03-21

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
33461 2022-002 Material Weakness - G
33462 2022-002 Material Weakness - G
33463 2022-002 Material Weakness - G
33464 2022-002 Material Weakness - G
33465 2022-003 Material Weakness - F
33466 2022-003 Material Weakness - F
609903 2022-002 Material Weakness - G
609904 2022-002 Material Weakness - G
609905 2022-002 Material Weakness - G
609906 2022-002 Material Weakness - G
609907 2022-003 Material Weakness - F
609908 2022-003 Material Weakness - F

Programs

ALN Program Spent Major Findings
84.425 Education Stabilization Fund $95,853 Yes 1
84.027 Special Education_grants to States $80,229 Yes 1
84.010 Title I Grants to Local Educational Agencies $30,240 - 0
93.778 Medical Assistance Program $23,854 - 0
10.555 National School Lunch Program $17,377 - 0
84.367 Improving Teacher Quality State Grants $13,121 - 0
10.559 Summer Food Service Program for Children $11,972 - 0
84.424 Student Support and Academic Enrichment Program $10,017 - 0
84.173 Special Education_preschool Grants $7,952 Yes 1
10.556 Special Milk Program for Children $346 - 0

Contacts

Name Title Type
PLN9BZ45RFV5 Russell A. Ragon Auditee
8154780191 Cory A Brown Auditor
No contacts on file

Notes to SEFA

Title: Subrecipients Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Manhattan School District 114 and is presented on the modified cash basis of accounting. The information in this schedule is presented in accordance with the requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the Basic financial statements. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Of the federal expenditures presented in the schedule, Manhattan School District 114 provided no federal awards to subrecipients.
Title: Non-Cash Assistance Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Manhattan School District 114 and is presented on the modified cash basis of accounting. The information in this schedule is presented in accordance with the requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the Basic financial statements. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The following amounts were expended in the form of non-cash assistance by Manhattan School District 114 and should be included in the Schedule of Expenditures of Federal Awards: NON-CASH COMMODITIES (CFDA 10.555): $17,377 OTHER NON-CASH ASSISTANCE - DEPT. OF DEFENSE FRUITS & VEGETABLES $0 Total Non-Cash $17,377
Title: Other Information Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Manhattan School District 114 and is presented on the modified cash basis of accounting. The information in this schedule is presented in accordance with the requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the Basic financial statements. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Insurance coverage in effect paid with Federal funds during the fiscal year: Property No Auto No General Liability No Workers Compensation No Loans/Loan Guarantees Outstanding at June 30: No District had Federal grants requiring matching expenditures No

Finding Details

1. Finding Number: 2022-002 2. This Finding is: New 3. Federal Program Name and Year: Special Education Cluster- 2021 & 2022 4. Project No.: 4600, 4620, & 4998- ID & PS 5. CFDA No.: 84.027, 84.027- COVID-19, 84.027X, 84.173, & 84.173- COVID-19, 84.173X 6. Passed Through: Illinois State Board of Education 7. Federal Agency: Department of Education 8. Criteria or specific requirement (including statutory, regulatory, or other citation) Strong internal controls over matching, level of effort and earmarking compliance requirements require District personnel to have the knowledge necessary to adequately review the District's Maintenance of Effort calculation for accuracy. 9. Condition The District's Fiscal Year 2022 and 2021 Maintenance of Effort calculations were prepared by personnel at the Illinois State Board of Education and subsequent to the District personnel's review contained numerous errors. The calculations were submitted including those errors. 10. Questioned Costs None 11. Context The Maintenance of Effort calculations performed in Fiscal Year 2022 and 2021 using Fiscal Year 2020 and 2019 expenditures, respectively. 12. Effect The District's Fiscal Year 2022 and 2021 Maintenance of Effort calculations were not accurate. The calculations included material transportation expenditures paid to another school district twice. 13. Cause Personnel at the Illinois State Board of Education inadvertently completed the calculation incorrectly and the District personnel assigned to review the Maintenance of Effort calculation prior to its submission were not properly trained to identify the errors. 14. Recommendation District personnel assigned to review the Maintenance of Effort calculation should be trained to properly complete the calculation. 15. Management's response Management will implement the auditor's recommendation in January 2023.
1. Finding Number: 2022-002 2. This Finding is: New 3. Federal Program Name and Year: Special Education Cluster- 2021 & 2022 4. Project No.: 4600, 4620, & 4998- ID & PS 5. CFDA No.: 84.027, 84.027- COVID-19, 84.027X, 84.173, & 84.173- COVID-19, 84.173X 6. Passed Through: Illinois State Board of Education 7. Federal Agency: Department of Education 8. Criteria or specific requirement (including statutory, regulatory, or other citation) Strong internal controls over matching, level of effort and earmarking compliance requirements require District personnel to have the knowledge necessary to adequately review the District's Maintenance of Effort calculation for accuracy. 9. Condition The District's Fiscal Year 2022 and 2021 Maintenance of Effort calculations were prepared by personnel at the Illinois State Board of Education and subsequent to the District personnel's review contained numerous errors. The calculations were submitted including those errors. 10. Questioned Costs None 11. Context The Maintenance of Effort calculations performed in Fiscal Year 2022 and 2021 using Fiscal Year 2020 and 2019 expenditures, respectively. 12. Effect The District's Fiscal Year 2022 and 2021 Maintenance of Effort calculations were not accurate. The calculations included material transportation expenditures paid to another school district twice. 13. Cause Personnel at the Illinois State Board of Education inadvertently completed the calculation incorrectly and the District personnel assigned to review the Maintenance of Effort calculation prior to its submission were not properly trained to identify the errors. 14. Recommendation District personnel assigned to review the Maintenance of Effort calculation should be trained to properly complete the calculation. 15. Management's response Management will implement the auditor's recommendation in January 2023.
1. Finding Number: 2022-002 2. This Finding is: New 3. Federal Program Name and Year: Special Education Cluster- 2021 & 2022 4. Project No.: 4600, 4620, & 4998- ID & PS 5. CFDA No.: 84.027, 84.027- COVID-19, 84.027X, 84.173, & 84.173- COVID-19, 84.173X 6. Passed Through: Illinois State Board of Education 7. Federal Agency: Department of Education 8. Criteria or specific requirement (including statutory, regulatory, or other citation) Strong internal controls over matching, level of effort and earmarking compliance requirements require District personnel to have the knowledge necessary to adequately review the District's Maintenance of Effort calculation for accuracy. 9. Condition The District's Fiscal Year 2022 and 2021 Maintenance of Effort calculations were prepared by personnel at the Illinois State Board of Education and subsequent to the District personnel's review contained numerous errors. The calculations were submitted including those errors. 10. Questioned Costs None 11. Context The Maintenance of Effort calculations performed in Fiscal Year 2022 and 2021 using Fiscal Year 2020 and 2019 expenditures, respectively. 12. Effect The District's Fiscal Year 2022 and 2021 Maintenance of Effort calculations were not accurate. The calculations included material transportation expenditures paid to another school district twice. 13. Cause Personnel at the Illinois State Board of Education inadvertently completed the calculation incorrectly and the District personnel assigned to review the Maintenance of Effort calculation prior to its submission were not properly trained to identify the errors. 14. Recommendation District personnel assigned to review the Maintenance of Effort calculation should be trained to properly complete the calculation. 15. Management's response Management will implement the auditor's recommendation in January 2023.
1. Finding Number: 2022-002 2. This Finding is: New 3. Federal Program Name and Year: Special Education Cluster- 2021 & 2022 4. Project No.: 4600, 4620, & 4998- ID & PS 5. CFDA No.: 84.027, 84.027- COVID-19, 84.027X, 84.173, & 84.173- COVID-19, 84.173X 6. Passed Through: Illinois State Board of Education 7. Federal Agency: Department of Education 8. Criteria or specific requirement (including statutory, regulatory, or other citation) Strong internal controls over matching, level of effort and earmarking compliance requirements require District personnel to have the knowledge necessary to adequately review the District's Maintenance of Effort calculation for accuracy. 9. Condition The District's Fiscal Year 2022 and 2021 Maintenance of Effort calculations were prepared by personnel at the Illinois State Board of Education and subsequent to the District personnel's review contained numerous errors. The calculations were submitted including those errors. 10. Questioned Costs None 11. Context The Maintenance of Effort calculations performed in Fiscal Year 2022 and 2021 using Fiscal Year 2020 and 2019 expenditures, respectively. 12. Effect The District's Fiscal Year 2022 and 2021 Maintenance of Effort calculations were not accurate. The calculations included material transportation expenditures paid to another school district twice. 13. Cause Personnel at the Illinois State Board of Education inadvertently completed the calculation incorrectly and the District personnel assigned to review the Maintenance of Effort calculation prior to its submission were not properly trained to identify the errors. 14. Recommendation District personnel assigned to review the Maintenance of Effort calculation should be trained to properly complete the calculation. 15. Management's response Management will implement the auditor's recommendation in January 2023.
1. Finding Number: 2022-003 2. This Finding is: New 3. Federal Program Name and Year: Education Stabilization Fund- 2022 4. Project No.: 4998- D2 & E3 5. CFDA No.: 84.425- COVID-19, 84.425D & 84.425- COVID-19, 84.425U 6. Passed Through: Illinois State Board of Education 7. Federal Agency: Department of Education 8. Criteria or specific requirement (including statutory, regulatory, or other citation) Internal control over Equipment and Real Property Management compliance requirements require the District to assign the responsibility to maintain all inclusive property records for all real property acquired with Federal Funds to a qualified employee. 9. Condition No District employee was assigned the responsibility of maintaining all inclusive federally funded property records; consequently, the District only has incomplete lists. 10. Questioned Costs None 11. Context No employee has ever been assigned the responsibility of maintaining all inclusive federally funded property records and several incomplete lists were in the possession of several different employees at June 30, 2022. 12. Effect The District's internal control over Equipment and Real Property Management compliance requirements is not as strong as possible. 13. Cause District administration was unaware that there was a federal compliance requirement for all inclusive federally funded property records; as a result, they failed to assign the related responsibility to an employee(s). 14. Recommendation District administrative personnel should maintain all inclusive federally funded property records by soliciting input from the employees previously maintaining incomplete lists. 15. Management's response Management will implement the auditor's recommendation for the year ended June 30, 2023.
1. Finding Number: 2022-003 2. This Finding is: New 3. Federal Program Name and Year: Education Stabilization Fund- 2022 4. Project No.: 4998- D2 & E3 5. CFDA No.: 84.425- COVID-19, 84.425D & 84.425- COVID-19, 84.425U 6. Passed Through: Illinois State Board of Education 7. Federal Agency: Department of Education 8. Criteria or specific requirement (including statutory, regulatory, or other citation) Internal control over Equipment and Real Property Management compliance requirements require the District to assign the responsibility to maintain all inclusive property records for all real property acquired with Federal Funds to a qualified employee. 9. Condition No District employee was assigned the responsibility of maintaining all inclusive federally funded property records; consequently, the District only has incomplete lists. 10. Questioned Costs None 11. Context No employee has ever been assigned the responsibility of maintaining all inclusive federally funded property records and several incomplete lists were in the possession of several different employees at June 30, 2022. 12. Effect The District's internal control over Equipment and Real Property Management compliance requirements is not as strong as possible. 13. Cause District administration was unaware that there was a federal compliance requirement for all inclusive federally funded property records; as a result, they failed to assign the related responsibility to an employee(s). 14. Recommendation District administrative personnel should maintain all inclusive federally funded property records by soliciting input from the employees previously maintaining incomplete lists. 15. Management's response Management will implement the auditor's recommendation for the year ended June 30, 2023.
1. Finding Number: 2022-002 2. This Finding is: New 3. Federal Program Name and Year: Special Education Cluster- 2021 & 2022 4. Project No.: 4600, 4620, & 4998- ID & PS 5. CFDA No.: 84.027, 84.027- COVID-19, 84.027X, 84.173, & 84.173- COVID-19, 84.173X 6. Passed Through: Illinois State Board of Education 7. Federal Agency: Department of Education 8. Criteria or specific requirement (including statutory, regulatory, or other citation) Strong internal controls over matching, level of effort and earmarking compliance requirements require District personnel to have the knowledge necessary to adequately review the District's Maintenance of Effort calculation for accuracy. 9. Condition The District's Fiscal Year 2022 and 2021 Maintenance of Effort calculations were prepared by personnel at the Illinois State Board of Education and subsequent to the District personnel's review contained numerous errors. The calculations were submitted including those errors. 10. Questioned Costs None 11. Context The Maintenance of Effort calculations performed in Fiscal Year 2022 and 2021 using Fiscal Year 2020 and 2019 expenditures, respectively. 12. Effect The District's Fiscal Year 2022 and 2021 Maintenance of Effort calculations were not accurate. The calculations included material transportation expenditures paid to another school district twice. 13. Cause Personnel at the Illinois State Board of Education inadvertently completed the calculation incorrectly and the District personnel assigned to review the Maintenance of Effort calculation prior to its submission were not properly trained to identify the errors. 14. Recommendation District personnel assigned to review the Maintenance of Effort calculation should be trained to properly complete the calculation. 15. Management's response Management will implement the auditor's recommendation in January 2023.
1. Finding Number: 2022-002 2. This Finding is: New 3. Federal Program Name and Year: Special Education Cluster- 2021 & 2022 4. Project No.: 4600, 4620, & 4998- ID & PS 5. CFDA No.: 84.027, 84.027- COVID-19, 84.027X, 84.173, & 84.173- COVID-19, 84.173X 6. Passed Through: Illinois State Board of Education 7. Federal Agency: Department of Education 8. Criteria or specific requirement (including statutory, regulatory, or other citation) Strong internal controls over matching, level of effort and earmarking compliance requirements require District personnel to have the knowledge necessary to adequately review the District's Maintenance of Effort calculation for accuracy. 9. Condition The District's Fiscal Year 2022 and 2021 Maintenance of Effort calculations were prepared by personnel at the Illinois State Board of Education and subsequent to the District personnel's review contained numerous errors. The calculations were submitted including those errors. 10. Questioned Costs None 11. Context The Maintenance of Effort calculations performed in Fiscal Year 2022 and 2021 using Fiscal Year 2020 and 2019 expenditures, respectively. 12. Effect The District's Fiscal Year 2022 and 2021 Maintenance of Effort calculations were not accurate. The calculations included material transportation expenditures paid to another school district twice. 13. Cause Personnel at the Illinois State Board of Education inadvertently completed the calculation incorrectly and the District personnel assigned to review the Maintenance of Effort calculation prior to its submission were not properly trained to identify the errors. 14. Recommendation District personnel assigned to review the Maintenance of Effort calculation should be trained to properly complete the calculation. 15. Management's response Management will implement the auditor's recommendation in January 2023.
1. Finding Number: 2022-002 2. This Finding is: New 3. Federal Program Name and Year: Special Education Cluster- 2021 & 2022 4. Project No.: 4600, 4620, & 4998- ID & PS 5. CFDA No.: 84.027, 84.027- COVID-19, 84.027X, 84.173, & 84.173- COVID-19, 84.173X 6. Passed Through: Illinois State Board of Education 7. Federal Agency: Department of Education 8. Criteria or specific requirement (including statutory, regulatory, or other citation) Strong internal controls over matching, level of effort and earmarking compliance requirements require District personnel to have the knowledge necessary to adequately review the District's Maintenance of Effort calculation for accuracy. 9. Condition The District's Fiscal Year 2022 and 2021 Maintenance of Effort calculations were prepared by personnel at the Illinois State Board of Education and subsequent to the District personnel's review contained numerous errors. The calculations were submitted including those errors. 10. Questioned Costs None 11. Context The Maintenance of Effort calculations performed in Fiscal Year 2022 and 2021 using Fiscal Year 2020 and 2019 expenditures, respectively. 12. Effect The District's Fiscal Year 2022 and 2021 Maintenance of Effort calculations were not accurate. The calculations included material transportation expenditures paid to another school district twice. 13. Cause Personnel at the Illinois State Board of Education inadvertently completed the calculation incorrectly and the District personnel assigned to review the Maintenance of Effort calculation prior to its submission were not properly trained to identify the errors. 14. Recommendation District personnel assigned to review the Maintenance of Effort calculation should be trained to properly complete the calculation. 15. Management's response Management will implement the auditor's recommendation in January 2023.
1. Finding Number: 2022-002 2. This Finding is: New 3. Federal Program Name and Year: Special Education Cluster- 2021 & 2022 4. Project No.: 4600, 4620, & 4998- ID & PS 5. CFDA No.: 84.027, 84.027- COVID-19, 84.027X, 84.173, & 84.173- COVID-19, 84.173X 6. Passed Through: Illinois State Board of Education 7. Federal Agency: Department of Education 8. Criteria or specific requirement (including statutory, regulatory, or other citation) Strong internal controls over matching, level of effort and earmarking compliance requirements require District personnel to have the knowledge necessary to adequately review the District's Maintenance of Effort calculation for accuracy. 9. Condition The District's Fiscal Year 2022 and 2021 Maintenance of Effort calculations were prepared by personnel at the Illinois State Board of Education and subsequent to the District personnel's review contained numerous errors. The calculations were submitted including those errors. 10. Questioned Costs None 11. Context The Maintenance of Effort calculations performed in Fiscal Year 2022 and 2021 using Fiscal Year 2020 and 2019 expenditures, respectively. 12. Effect The District's Fiscal Year 2022 and 2021 Maintenance of Effort calculations were not accurate. The calculations included material transportation expenditures paid to another school district twice. 13. Cause Personnel at the Illinois State Board of Education inadvertently completed the calculation incorrectly and the District personnel assigned to review the Maintenance of Effort calculation prior to its submission were not properly trained to identify the errors. 14. Recommendation District personnel assigned to review the Maintenance of Effort calculation should be trained to properly complete the calculation. 15. Management's response Management will implement the auditor's recommendation in January 2023.
1. Finding Number: 2022-003 2. This Finding is: New 3. Federal Program Name and Year: Education Stabilization Fund- 2022 4. Project No.: 4998- D2 & E3 5. CFDA No.: 84.425- COVID-19, 84.425D & 84.425- COVID-19, 84.425U 6. Passed Through: Illinois State Board of Education 7. Federal Agency: Department of Education 8. Criteria or specific requirement (including statutory, regulatory, or other citation) Internal control over Equipment and Real Property Management compliance requirements require the District to assign the responsibility to maintain all inclusive property records for all real property acquired with Federal Funds to a qualified employee. 9. Condition No District employee was assigned the responsibility of maintaining all inclusive federally funded property records; consequently, the District only has incomplete lists. 10. Questioned Costs None 11. Context No employee has ever been assigned the responsibility of maintaining all inclusive federally funded property records and several incomplete lists were in the possession of several different employees at June 30, 2022. 12. Effect The District's internal control over Equipment and Real Property Management compliance requirements is not as strong as possible. 13. Cause District administration was unaware that there was a federal compliance requirement for all inclusive federally funded property records; as a result, they failed to assign the related responsibility to an employee(s). 14. Recommendation District administrative personnel should maintain all inclusive federally funded property records by soliciting input from the employees previously maintaining incomplete lists. 15. Management's response Management will implement the auditor's recommendation for the year ended June 30, 2023.
1. Finding Number: 2022-003 2. This Finding is: New 3. Federal Program Name and Year: Education Stabilization Fund- 2022 4. Project No.: 4998- D2 & E3 5. CFDA No.: 84.425- COVID-19, 84.425D & 84.425- COVID-19, 84.425U 6. Passed Through: Illinois State Board of Education 7. Federal Agency: Department of Education 8. Criteria or specific requirement (including statutory, regulatory, or other citation) Internal control over Equipment and Real Property Management compliance requirements require the District to assign the responsibility to maintain all inclusive property records for all real property acquired with Federal Funds to a qualified employee. 9. Condition No District employee was assigned the responsibility of maintaining all inclusive federally funded property records; consequently, the District only has incomplete lists. 10. Questioned Costs None 11. Context No employee has ever been assigned the responsibility of maintaining all inclusive federally funded property records and several incomplete lists were in the possession of several different employees at June 30, 2022. 12. Effect The District's internal control over Equipment and Real Property Management compliance requirements is not as strong as possible. 13. Cause District administration was unaware that there was a federal compliance requirement for all inclusive federally funded property records; as a result, they failed to assign the related responsibility to an employee(s). 14. Recommendation District administrative personnel should maintain all inclusive federally funded property records by soliciting input from the employees previously maintaining incomplete lists. 15. Management's response Management will implement the auditor's recommendation for the year ended June 30, 2023.