Finding 599127 (2022-002)

Material Weakness
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2023-07-09
Audit: 21865
Organization: Okaw Valley Cusd 302 (IL)

AI Summary

  • Core Issue: Grant expenditures are not consistently coded in the general ledger compared to grant reports, making reconciliation difficult.
  • Impacted Requirements: Internal controls require that expenditures match in both the general ledger and grant reports, including clear identification of federal funds.
  • Recommended Follow-Up: Ensure grant expenditures are recorded in the same functions as reported and clearly identify the federal funds used.

Finding Text

SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS 1. FINDING NUMBER: 2022- 002 2. THIS FINDING IS: X New Repeat from Prior year? Year originally reported? 3. Federal Program Name and Year: COVID 19: Education Stabilization Fund (2021 & 2022) 4. Project No.: 4998-ER, E2, E3 5. CFDA No.: 84.425D-COVID 19, 84.425U-COVID 19 6. Passed Through: Illinois State Board of Education 7. Federal Agency: Department of Education 8. Criteria or specific requirement (including statutory, regulatory, or other citation) Internal controls over compliance over reporting of federal expenditures require expenditures to be coded to the same expenditure functions and object codes in the District's general ledger as they are on grant expenditure reports. Additionally, the source of funds used for federal expenditures should be identified in the underlying accounting records. 9. Condition Expenditure functions used to record grant expenditures in the general ledger are not consistent with the expenditure functions used for grant reporting and the general ledger account number did not identify which federal funds were being utilized. Numerous expenditures were coded to the grant general ledger accounts via journal entry reclassification. 10. Questioned Costs None 11. Context Numerous expenditures in the District's general ledger which were claimed on grant expenditure reports were not coded to accounts which identified the source of federal funds nor to the same function and object codes as reported on the grant expenditure reports. 12. Effect Grant expenditures claimed cannot be easily reconciled to the general ledger totals. 13. Cause Coding of grant expenditures was not reviewed to ensure expenditures are coded to functions in which they are budgeted and to general ledger accounts that clearly identify which federal funds or other funds were utilized. 14. Recommendation Grant expenditures should be recorded in the same general ledger expenditure functions as are used for grant reporting and should identify the federal funds being utilized. 15. Management's response Management will implement the auditor's recommendation in the year ended June 30, 2023.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 22683 2022-002
    Material Weakness
  • 22684 2022-003
    Material Weakness
  • 22685 2022-002
    Material Weakness
  • 22686 2022-003
    Material Weakness
  • 599125 2022-002
    Material Weakness
  • 599126 2022-003
    Material Weakness
  • 599128 2022-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $388,274
10.555 National School Lunch Program $199,159
84.027 Special Education_grants to States $155,431
84.010 Title I Grants to Local Educational Agencies $100,683
10.553 School Breakfast Program $55,173
84.358 Rural Education $39,457
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $28,163
93.778 Medical Assistance Program $12,840
84.173 Special Education_preschool Grants $6,398
84.367 Improving Teacher Quality State Grants $6,294
84.048 Career and Technical Education -- Basic Grants to States $1,100
10.649 Pandemic Ebt Administrative Costs $614