Finding 204834 (2022-007)

Material Weakness
Requirement
AB
Questioned Costs
$1
Year
2022
Accepted
2023-03-01
Audit: 174116
Organization: Kankakee School District 111 (IL)
Auditor: Skdo PC

AI Summary

  • Core Issue: Overclaimed expenditures totaling $818,716 on ESSER grants for FY 2022, with $636,025 not spent during the period and $180,691 reported incorrectly.
  • Impacted Requirements: Expenditures must be necessary and reasonable per 2 CFR Part 200, Subpart E; journal entries need accurate review to ensure compliance.
  • Recommended Follow-Up: Review journal entries for accuracy, check general ledger details before posting, and ensure all expenditures align with grant budgets before reimbursement requests.

Finding Text

Federal Program Name: Education Stabilization Fund Federal Award Number: S425D210041, S425U210041 Federal Agency: US Department of Education CFDA No: 84.425D, 84.425U Passed Through: Illinois State Board of Education Pass-through ID Number: ESSER II 2021-4998-E2, ESSER III 2022-4998-E3 Criteria or specified requirement: Allowable Costs/Cost Principles: To be allowable grant expenditures, the expenditures must be necessary and reasonable for the performance of the federal award and be allocable thereto under the principles in 2 CFR Part 200, Subpart E. Journal entries related to grant expenditures should be reviewed for accuracy and verified as allowable grant expenditures. Condition: Expenditures were overclaimed on certain ESSER grants for fiscal year 2022 in the amount of $818,716. Questioned Costs: $636,025 was requested for reimbursement for the year ending June 30, 2022 for ISBE grant 2021-4998-E2, but was not actually spent during that time period. $180,691 was requested for reimbursement for the year ending June 30, 2022 under ISBE grant 2022-4998-E3, but the amount should have been reported on ISBE grant 2021-4998-E2. Context: Certain projects approved under the 2022 project year grants are still ongoing under the 2023 project year grants. Grant expenditure reports and future reimbursements may be able to be adjusted to correct the amounts overclaimed. Effect: The granting agency could disallow the expenditures and request the District to repay the funds. Cause: Journal entries to reclassify expenditures to grant lines on the general ledger contained errors. In one instance, certain expenditures ($603,789 ESSER II) were included twice in the total amount reclassified and the error was not detected. In a second instance ($32,236 ESSER II), the journal entry was posted from the information contained on the purchase order rather than the general ledger, and a portion of the amount had already been reclassified in a separate entry. In addition, $182,691 were charged to and claimed under the wrong grant subcode (expenditures were approved in the ESSER II grant budget but claimed under ESSER III). Recommendation: Journal entries should be reviewed for accuracy, and the District should review the general ledger detail prior to posting any entries to prevent duplicate entries from being posted. Also, the District should verify that all expenditures charged to grants are approved on the grant budget detail prior to requesting reimbursement. Management?s response: A corrective action plan has been prepared and is included in this report.

Corrective Action Plan

Finding Number: 2022-007 Finding: Expenditures were overclaimed on certain ESSER grants for fiscal year 2022 in the amount of $818,716. Planned Corrective Action: All ESSER Grants should be reconciled to-date to ensure that revenues are recorded in the same fund in which the expenses occurred. Moving forward ? once an ESSER expenditure report is created, the accounting coordinator will be provided with a breakdown (by fund) of how the revenue should be recorded. Anticipated Completion Date: June 30, 2023 Contact/Responsible Person: Assistant Superintendent of Business TBD, Shemeka M. Fountain, Assistant Superintendent

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 204835 2022-007
    Material Weakness
  • 781276 2022-007
    Material Weakness
  • 781277 2022-007
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $4.39M
84.010 Title I Grants to Local Educational Agencies $3.45M
84.027 Special Education_grants to States $1.61M
10.553 School Breakfast Program $581,234
94.011 Foster Grandparent Program $320,063
93.778 Medical Assistance Program $259,872
10.555 National School Lunch Program $229,329
84.367 Improving Teacher Quality State Grants $189,201
93.600 Head Start $154,271
16.839 Stop School Violence $141,163
10.558 Child and Adult Care Food Program $124,184
93.994 Maternal and Child Health Services Block Grant to the States $115,274
10.559 Summer Food Service Program for Children $102,257
32.009 Emergency Connectivity Fund Program $90,768
84.365 English Language Acquisition State Grants $68,255
84.011 Migrant Education_state Grant Program $59,470
10.579 Child Nutrition Discretionary Grants Limited Availability $47,939
84.173 Special Education_preschool Grants $22,326
99.U01 Junior Reserve Officer Training Corps $5,970
10.649 Pandemic Ebt Administrative Costs $5,814
84.126 Rehabilitation Services_vocational Rehabilitation Grants to States $5,000