Finding 516228 (2024-005)

Material Weakness Repeat Finding
Requirement
A
Questioned Costs
$1
Year
2024
Accepted
2024-12-20

AI Summary

  • Core Issue: The District submitted inaccurate expenditure reports, claiming the same expenses across multiple grants, leading to questioned costs of $43,447.
  • Impacted Requirements: The District failed to adhere to reporting requirements for allowable costs, resulting in potential repayment risks for incorrectly claimed funds.
  • Recommended Follow-Up: Conduct a thorough review of the general ledger and journal entries for duplicates or unallowable expenses before future expenditure report submissions.

Finding Text

Criteria: Allowable Costs/Activites Allowed. The District is required to report allowable costs/activities allowed based on the grant, the grant budget and for the period of the grant. Condition: The amount claimed on the 11/30/23 final expenditure report for ESSER II included an expense that had been claimed on the ESSER III 6/30/24 expenditure report. The amount claimed on the 11/30/23 final expenditure report for ESSER II included an expense that had been claimed on the Digital Equity I (2021 Grant Year) 6/30/22 expenditure report. Questioned Costs: Total questioned costs of $43,447: $3,333 in 1000-100 double-reported in ESSER II and ESSER III; $4,800 in 1000-300 double reported in ESSER II and Digital Equity I (Grant Year 2021); $35,314 in 1000-400 double-reported in ESSER II and Digital Equity I (Grant Year 2021). Context: Various journal entries were made at year-end moving items out of ESSER II accounts and into other grant accounts, where they were included in grant expenditure reports and subsequently reimbursed. 3 employees had their last pay moved out of the ESSER II 1000-100 grant accounts ($2,655.71, $552.00, and $125.00 respectfully for a total of $3,332.71) and moved into an ESSER III 1000-100 grant account, where these amounts were included in the grant reports for ESSER III from 8/31/23 through 6/30/24. A manual journal entry moved $4,800 out of an ESSER II 1000-300 account and into a Digital Equity 1000-300 account, where this amount was included in the grant reports for Digital Equity I (Grant Year 2021) through 6/30/22. A journal entry moved $35,998.50 out of an ESSER II 1000-400 account and into a Digital Equity 1000-400 account, where a portion of this amount, totaling $35,414.74, was included in the grant reports for Digital Equity I (Grant Year 2021) through 6/30/22. Effect: The District did not file an accurate expenditure report at 11/30/23 resulting in $43,447.34 of expenses claimed across different grants. There is an increased risk that these funds will be subject to repayment as they were incorrectly submitted for reimbursement. Cause: The District claimed the same expenses for Digital Equity I (2021 Grant Year) and ESSER II. The District claimed the same expenses for ESSER II and ESSER III. The District's financial specialist started at the beginning of the year, and ESSER II and ESSER III claimed items from prior years (from 2021, 2022, and 2023, when the previous financial specialist was still working at the District. Recommendation: We recommend reviewing the general ledger and journal entries made at the end of the year for duplicate or unallowable expenses before entering into the expenditure report and submitting. Management's Response: The District will review the general ledger and end-of-year journal entries for duplicate or unallowable expenses before submitting quarterly reports.

Corrective Action Plan

Condition: To determine that an accurate final expenditure report was filed with the Illinois State Board of Education. The District reported expenses on the final ESSER II November 11, 2023 expenditure report that were claimed twice in different grants. Recommendation: We recommend to review for duplicate or unallowable expenses before entering into the expenditure report and submitting. Management Response: The District will review the general ledger for duplicate or unallowable expenses before submitting quarterly reports.

Categories

Questioned Costs Allowable Costs / Cost Principles Cash Management

Other Findings in this Audit

  • 516225 2024-008
    Significant Deficiency Repeat
  • 516226 2024-009
    Significant Deficiency Repeat
  • 516227 2024-009
    Significant Deficiency Repeat
  • 516229 2024-006
    Material Weakness
  • 516230 2024-008
    Significant Deficiency Repeat
  • 516231 2024-009
    Significant Deficiency Repeat
  • 516232 2024-010
    Significant Deficiency
  • 516233 2024-007
    Significant Deficiency Repeat
  • 516234 2024-008
    Significant Deficiency Repeat
  • 516235 2024-009
    Significant Deficiency Repeat
  • 516236 2024-003
    Material Weakness
  • 516237 2024-002
    - Repeat
  • 516238 2024-002
    - Repeat
  • 516239 2024-004
    Material Weakness
  • 516240 2024-002
    - Repeat
  • 516241 2024-002
    - Repeat
  • 1092667 2024-008
    Significant Deficiency Repeat
  • 1092668 2024-009
    Significant Deficiency Repeat
  • 1092669 2024-009
    Significant Deficiency Repeat
  • 1092670 2024-005
    Material Weakness Repeat
  • 1092671 2024-006
    Material Weakness
  • 1092672 2024-008
    Significant Deficiency Repeat
  • 1092673 2024-009
    Significant Deficiency Repeat
  • 1092674 2024-010
    Significant Deficiency
  • 1092675 2024-007
    Significant Deficiency Repeat
  • 1092676 2024-008
    Significant Deficiency Repeat
  • 1092677 2024-009
    Significant Deficiency Repeat
  • 1092678 2024-003
    Material Weakness
  • 1092679 2024-002
    - Repeat
  • 1092680 2024-002
    - Repeat
  • 1092681 2024-004
    Material Weakness
  • 1092682 2024-002
    - Repeat
  • 1092683 2024-002
    - Repeat

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $454,562
84.010 Title I Grants to Local Educational Agencies $233,568
10.553 National School Lunch Program $64,248
93.778 Medical Assistance Program $30,354
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) $26,707
84.424 Student Support and Academic Enrichment Program $26,457
84.027 Special Education Grants to States $25,236
84.358 Rural Education $19,957
10.555 National School Lunch Program $14,676
84.173 Special Education Preschool Grants $2,558
10.649 Pandemic Ebt Administrative Costs $653
84.048 Career and Technical Education -- Basic Grants to States $325