Finding 1176377 (2025-007)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2026-03-04

AI Summary

  • Core Issue: There was a mismatch between the accounts used for quarterly expenditure reports and the general ledger, affecting accurate financial reporting.
  • Impacted Requirements: Consistency in reporting is crucial for monitoring budget versus actual expenses by grant line item.
  • Recommended Follow-Up: Implement a verification process with oversight and a detailed reconciliation spreadsheet to ensure accurate reporting before submission.

Finding Text

Criteria: Reporting. The accounts used to record expenditures on the quarterly expenditure reports should match the general ledger accounts where the expenditures are recorded. Condition: It was noted that there was an inconsistency when comparing the general ledger to what was reported on the expenditure reports. Questioned Costs: There are no questioned costs. Context: The accounts used to record expenditures on the quarterly expenditure reports did not match the general ledeger accounts. In total, approximately $141,593 of costs were posted to an account in the general ledger that did not match the final ISBE classification of expenditure reported for the year. No expenses were duplicated across another grant, and all expenses were allowable in the grant. Effect: The expenditures were not recorded/reported consistently between the District's financial records and the reports to ISBE. This makes the monitoring of budget to actual expense by grant line item difficult. Cause: Expenses claimed in the grant were incorrectly coded on the general ledger. Recommendation: We recommend that steps are taken, including oversight by a second employee, to reconcile the general ledger to the expenditure reports in detail before submission. We also recommend implementing a detailed reconciliation spreadsheet that lists claimed expenses by account. Management's Response: The District will add a verification process to reconcile the general ledger to the budget and expenditure reports before submitting.

Corrective Action Plan

Condition: It was noted that there was an inconsistency when comparing the general ledger to what was reported on the expenditure reports. Recommendation: We recommend that steps are taken, including oversight by a second employee, to reconcile the general ledger to the expenditure reports, and the expenditure reports against the budget items before submitting. Management Response: The District will add a verification process to reconcile the general ledger to the budget and expenditure reports before submitting. The District will consider implementing a detailed grant tracking sheet to ensure the general ledger expenditures agree to the expenses reported to ISBE by grant. Anticipated Date of Completion: June 30, 2026

Categories

Subrecipient Monitoring Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1176374 2025-005
    Material Weakness Repeat
  • 1176375 2025-005
    Material Weakness Repeat
  • 1176376 2025-006
    Material Weakness Repeat
  • 1176378 2025-008
    Material Weakness Repeat
  • 1176379 2025-008
    Material Weakness Repeat
  • 1176380 2025-008
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.027 SPECIAL EDUCATION GRANTS TO STATES $161,036
10.553 SCHOOL BREAKFAST PROGRAM $99,940
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $49,591
93.778 MEDICAL ASSISTANCE PROGRAM $49,068
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $44,372
84.425 EDUCATION STABILIZATION FUND $40,000
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $23,842
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN $11,279
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $5,512
84.287 TWENTY-FIRST CENTURY COMMUNITY LEARNING CENTERS $2,187
10.555 NATIONAL SCHOOL LUNCH PROGRAM $1,125