Finding 1170644 (2024-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2026-01-26

AI Summary

  • Core Issue: 75% of quarterly expenditure reports were submitted late, violating the Illinois State Board of Education's 20-day deadline.
  • Impacted Requirements: Inaccurate coding of expenditures to grant accounts led to delays and potential errors in reporting.
  • Recommended Follow-Up: Establish a control structure for consistent coding of expenditures to align with approved grant budgets, and provide training for grant personnel.

Finding Text

Criteria or specific requirement (including statutory, regulatory, or other citation) - L. Reporting - The Illinois State Board of Education requires that grant expediture reports be submitted by the 20th day after the through date of the expenditure report. In order to prepare accurate and timely expenditure reports, postings to the general ledger should be accurate and any necessary adjustments should be kept at a minimum, if possible. Condition - Out of 8 quarterly expenditure reports reviewed, 6 of them (75%) were filed beyond the 20th day after the through date. Additionally, GWA noted several adjustments to the general ledger where costs related to payroll, furnishings, etc. were reclassed to ESSER expenditure accounts as of year-end. Questioned Costs - N/A. Context - Although items reclassified to ESSER expenditure accounts appear to be compliant, it does not appear that the District was consistently coding expenditures to proper grant accounts when they were paid. An example is a reclassification of capital type expenditures from Function 2540, Object 310 to Function 2540, Object 550. Both accounts were in the Education Fund. The expenditures were related to the 2023 ESSER II grant. The time period of payments charged to Object 310 ranged from October 16, 2023 to December 18, 2023. The reclassification to Object 550 did not take place until March 31, 2024 and the reporting of this activity to ISBE did not take place until May 31, 2024. Effect - Failure to properly code expenditures to appropriate accounts that align with grant budgets creates delays in the reporting process and increases the potential for errors in reporting such as duplicate requests for reimbursement or further mispostings. Cause - The inability to implement a control structure where grant expenditures are consistenly coded to budgeted line items for approved grants creates an environment that becomes overly reliant on detective controls to identify misposted activity to be corrected with adjusting journal entires and can cause delays in the reporting of such activity to funding agencies. Recommendation - The District should look to create a control structure that better codes expenditures when paid to align with approved grant budget line items. This will allow for better accuracy and timeliness in grant reporting so that reporting deadlines can be met consistenly. Management's Response - The District will be training the grant personnel about proper coding and grant expenditure timelines to ensure timely and accurate submission of expenditure reports.

Corrective Action Plan

The District will be training the grant personnel about proper coding and grant expenditure timelines to ensure timely and accurate submissions of expenditure reports. Anticipated Date of Completion: Immediately. Contact Person: Alicia Evans, Ed.D., Assistant Superintendent of Business Affairs.

Categories

Cash Management Reporting

Other Findings in this Audit

  • 1170638 2024-002
    Material Weakness Repeat
  • 1170639 2024-002
    Material Weakness Repeat
  • 1170640 2024-002
    Material Weakness Repeat
  • 1170641 2024-002
    Material Weakness Repeat
  • 1170642 2024-002
    Material Weakness Repeat
  • 1170643 2024-002
    Material Weakness Repeat
  • 1170645 2024-003
    Material Weakness Repeat
  • 1170646 2024-003
    Material Weakness Repeat
  • 1170647 2024-003
    Material Weakness Repeat
  • 1170648 2024-003
    Material Weakness Repeat
  • 1170649 2024-003
    Material Weakness Repeat
  • 1170650 2024-003
    Material Weakness Repeat
  • 1170651 2024-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $1.24M
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $314,616
84.287 TWENTY-FIRST CENTURY COMMUNITY LEARNING CENTERS $276,801
93.778 MEDICAL ASSISTANCE PROGRAM $192,025
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES $190,594
10.553 SCHOOL BREAKFAST PROGRAM $176,985
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $93,618
84.027 SPECIAL EDUCATION GRANTS TO STATES $80,081
84.425 EDUCATION STABILIZATION FUND $47,235
10.555 NATIONAL SCHOOL LUNCH PROGRAM $34,591
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS $25,933
10.649 PANDEMIC EBT ADMINISTRATIVE COSTS $3,256