Audit 326978

FY End
2024-06-30
Total Expended
$1.23M
Findings
14
Programs
12
Year: 2024 Accepted: 2024-11-01
Auditor: Scheffel Boyle

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
504410 2024-004 Significant Deficiency - L
504411 2024-005 Significant Deficiency Yes L
504412 2024-005 Significant Deficiency Yes L
504413 2024-005 Significant Deficiency Yes L
504414 2024-006 Significant Deficiency - B
504415 2024-007 Significant Deficiency - L
504416 2024-008 Significant Deficiency - B
1080852 2024-004 Significant Deficiency - L
1080853 2024-005 Significant Deficiency Yes L
1080854 2024-005 Significant Deficiency Yes L
1080855 2024-005 Significant Deficiency Yes L
1080856 2024-006 Significant Deficiency - B
1080857 2024-007 Significant Deficiency - L
1080858 2024-008 Significant Deficiency - B

Contacts

Name Title Type
ELG4J3LTNZB4 Dale Sauer Auditee
6186327434 Brian Otten 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 Shiloh Village SD #85 and is presented on the modified cash basis (regulatory basis). 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 claim any indirect costs. No federal awards were provided to subrecipients for the year ended June 30, 2024.
Title: NON-CASH ASSISTANCE Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Shiloh Village SD #85 and is presented on the modified cash basis (regulatory basis). 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 claim any indirect costs. During the year ended June 30, 2024, the District received $22,915 in non-cash funding through the Illinois State Board of Education's Child Nutrition program.
Title: OTHER INFORMATION Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Shiloh Village SD #85 and is presented on the modified cash basis (regulatory basis). 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 claim any indirect costs. The District had no insurance as it relates to federal programs in effect for the year ended June 30, 2024. The District had no outstanding loans or loan guarantees from federal sources as of June 30, 2024. The District did not receive any donated personal protective equipment from federal sources as of June 30, 2024.

Finding Details

Compliance Finding - Eligibility of Expenditures. The District submitted expenditures for reimbursement that were not within the appropriate quarterly expenditure report. No Questioned Costs. The District submitted expenditures for reimbursement on the wrong quarterly expenditure report for Title II. These expenditures were for training costs paid in the 4th quarter that were included on the 3rd quarter expenditure report. The expenses were allowable under the grant, but the District claimed them too early. Overall, the expenditures are reported correctly for the year. However, there was one period in which expenditures were reported incorrectly. This was an oversight by management personnel in the District when submitting expenditure reports to the Illinois State Board of Education.
Compliance Finding - Reporting. The District did not timely file quarterly expenditure reports for all federal awards with approved budgets within 20 days of the end of each quarter. There are no questioned costs. Specifically, the following federal awards did not have timely filed expenditure reports: Title I, Tile II, and Title IV all for expenditures through 1/31/24 that were filed in April 2024. Non-timely filed expenditure reports could result in the District not receiving the full allotment of funding requested or not receiving the funding timely. The District did not timely file all quarterly expenditure reports.
Compliance Finding - Reporting. The District did not timely file quarterly expenditure reports for all federal awards with approved budgets within 20 days of the end of each quarter. There are no questioned costs. Specifically, the following federal awards did not have timely filed expenditure reports: Title I, Tile II, and Title IV all for expenditures through 1/31/24 that were filed in April 2024. Non-timely filed expenditure reports could result in the District not receiving the full allotment of funding requested or not receiving the funding timely. The District did not timely file all quarterly expenditure reports.
Compliance Finding - Reporting. The District did not timely file quarterly expenditure reports for all federal awards with approved budgets within 20 days of the end of each quarter. There are no questioned costs. Specifically, the following federal awards did not have timely filed expenditure reports: Title I, Tile II, and Title IV all for expenditures through 1/31/24 that were filed in April 2024. Non-timely filed expenditure reports could result in the District not receiving the full allotment of funding requested or not receiving the funding timely. The District did not timely file all quarterly expenditure reports.
Compliance Finding - Eligibility of Expenditures. The District submitted budgeted expenditures for reimbursement instead of actual expenditures for Title IVA. The questioned cost is $2,994. The District budgeted for the purchase of 9 Google EDLA Certified OPS Android Computers. The District only purchased 1 of the 9 items during the year yet submitted the cost of all 9 items for reimbursement. As a result, $249 of eligible expenditures were submitted which leaves the remaining $2,994 as questioned costs. There is an increased risk that these funds will be subject to repayment as they were incorrectly submitted for reimbursement. This was an oversight by management personnel in the District when submitting expenditure reports to the Illinois State Board of Education.
Compliance Finding - Reporting. The District's general ledger expense account functions and objects do not agree to the account functions and objects that were reported to the Illinois State Board of Education on the quarterly expenditure reports and budgets approved by the Illinois State Board of Education. No questioned costs. The June 30, 2024 expenditure report for ESSER III filed with the Illinois State Board of Education had discrepancies between the expense account functions and objects claimed on the expenditure reports compared to the general ledger expense account functions and objects. Items reported on the expenditure report as object three, purchased services, were recorded in the general ledger as object four, supplies and materials. All expenses incurred were in the proper period and there were no questioned costs. The District's general ledger accounts did not support the June 30, 2024 expenditure report filed with the Illinois State Board of Education. This was an oversight by management personnel in the District as there were no ESSER accounts created for object 3, purchased services, so they recorded it in their ESSER object 4, supplies and materials, account.
Compliance Finding - Allowable Cost. The District submitted budgeted expenditures to the Illinois State Board of Education for reimbursement that exceeded actual expenditures for the budgeted period. The questioned cost is $4,209. The District budgeted a social worker salary for FY22 and FY23 for a total of $99,221. The 6/30/24 expenditure report submitted to the Illinois State Board of Education reflected this as well. When reviewing actual expenditures for FY22 and FY23 for that social worker's salary, there is a discrepancy between the actual and reported costs. The salaries in the budget were higher than the actual salary paid to that employee for FY22 and FY23. As the salary was lower than expected and then reported, this results in a questioned costs total of $4,209 when comparing actual FY22 and FY23 expenditures for that employee against budgeted FY22 and FY23 expenditures. There is increased risk that these funds will be subject to repayment. This was an oversight by management personnel in the District when creating the budget and submitting the final expenditure report to the Illinois State Board of Education.
Compliance Finding - Eligibility of Expenditures. The District submitted expenditures for reimbursement that were not within the appropriate quarterly expenditure report. No Questioned Costs. The District submitted expenditures for reimbursement on the wrong quarterly expenditure report for Title II. These expenditures were for training costs paid in the 4th quarter that were included on the 3rd quarter expenditure report. The expenses were allowable under the grant, but the District claimed them too early. Overall, the expenditures are reported correctly for the year. However, there was one period in which expenditures were reported incorrectly. This was an oversight by management personnel in the District when submitting expenditure reports to the Illinois State Board of Education.
Compliance Finding - Reporting. The District did not timely file quarterly expenditure reports for all federal awards with approved budgets within 20 days of the end of each quarter. There are no questioned costs. Specifically, the following federal awards did not have timely filed expenditure reports: Title I, Tile II, and Title IV all for expenditures through 1/31/24 that were filed in April 2024. Non-timely filed expenditure reports could result in the District not receiving the full allotment of funding requested or not receiving the funding timely. The District did not timely file all quarterly expenditure reports.
Compliance Finding - Reporting. The District did not timely file quarterly expenditure reports for all federal awards with approved budgets within 20 days of the end of each quarter. There are no questioned costs. Specifically, the following federal awards did not have timely filed expenditure reports: Title I, Tile II, and Title IV all for expenditures through 1/31/24 that were filed in April 2024. Non-timely filed expenditure reports could result in the District not receiving the full allotment of funding requested or not receiving the funding timely. The District did not timely file all quarterly expenditure reports.
Compliance Finding - Reporting. The District did not timely file quarterly expenditure reports for all federal awards with approved budgets within 20 days of the end of each quarter. There are no questioned costs. Specifically, the following federal awards did not have timely filed expenditure reports: Title I, Tile II, and Title IV all for expenditures through 1/31/24 that were filed in April 2024. Non-timely filed expenditure reports could result in the District not receiving the full allotment of funding requested or not receiving the funding timely. The District did not timely file all quarterly expenditure reports.
Compliance Finding - Eligibility of Expenditures. The District submitted budgeted expenditures for reimbursement instead of actual expenditures for Title IVA. The questioned cost is $2,994. The District budgeted for the purchase of 9 Google EDLA Certified OPS Android Computers. The District only purchased 1 of the 9 items during the year yet submitted the cost of all 9 items for reimbursement. As a result, $249 of eligible expenditures were submitted which leaves the remaining $2,994 as questioned costs. There is an increased risk that these funds will be subject to repayment as they were incorrectly submitted for reimbursement. This was an oversight by management personnel in the District when submitting expenditure reports to the Illinois State Board of Education.
Compliance Finding - Reporting. The District's general ledger expense account functions and objects do not agree to the account functions and objects that were reported to the Illinois State Board of Education on the quarterly expenditure reports and budgets approved by the Illinois State Board of Education. No questioned costs. The June 30, 2024 expenditure report for ESSER III filed with the Illinois State Board of Education had discrepancies between the expense account functions and objects claimed on the expenditure reports compared to the general ledger expense account functions and objects. Items reported on the expenditure report as object three, purchased services, were recorded in the general ledger as object four, supplies and materials. All expenses incurred were in the proper period and there were no questioned costs. The District's general ledger accounts did not support the June 30, 2024 expenditure report filed with the Illinois State Board of Education. This was an oversight by management personnel in the District as there were no ESSER accounts created for object 3, purchased services, so they recorded it in their ESSER object 4, supplies and materials, account.
Compliance Finding - Allowable Cost. The District submitted budgeted expenditures to the Illinois State Board of Education for reimbursement that exceeded actual expenditures for the budgeted period. The questioned cost is $4,209. The District budgeted a social worker salary for FY22 and FY23 for a total of $99,221. The 6/30/24 expenditure report submitted to the Illinois State Board of Education reflected this as well. When reviewing actual expenditures for FY22 and FY23 for that social worker's salary, there is a discrepancy between the actual and reported costs. The salaries in the budget were higher than the actual salary paid to that employee for FY22 and FY23. As the salary was lower than expected and then reported, this results in a questioned costs total of $4,209 when comparing actual FY22 and FY23 expenditures for that employee against budgeted FY22 and FY23 expenditures. There is increased risk that these funds will be subject to repayment. This was an oversight by management personnel in the District when creating the budget and submitting the final expenditure report to the Illinois State Board of Education.