Finding 1182041 (2025-005)

Material Weakness Repeat Finding
Requirement
EG
Questioned Costs
-
Year
2025
Accepted
2026-03-23

AI Summary

  • Core Issue: The School Corporation lacks effective internal controls over Title I grant eligibility and vendor expenditure reporting, leading to potential inaccuracies in funding and financial records.
  • Impacted Requirements: Compliance with 2 CFR 200.303 regarding internal controls, specifically in verifying enrollment and poverty counts and ensuring proper coding of expenditures.
  • Recommended Follow-Up: Implement a two-person review process for verifying enrollment data and vendor expenditures, and maintain documentation of these reviews for audit purposes.

Finding Text

FINDING 2025-005 Subject: Title I Grants to Local Educational Agencies - Internal Controls Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A220014, S010A230014, S010A240014 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility, Matching, Level of Effort, Earmarking Audit Finding: Material Weakness INDIANA STATE BOARD OF ACCOUNTS 23 WAWASEE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Repeat Finding This is a repeat finding for internal controls only from the immediately prior audit report. The prior audit finding numbers were 2023-007 and 2023-008. Condition and Context Eligibility Eligibility for Title I is determined on the Eligible School Summary of the Tile I application. Enrollment and poverty numbers are automatically pulled from the Indiana Department of Education's (IDOE) Official Pupil Enrollment count for each school into the Eligible School Summary page of the Tile I application. The counts that are prepopulated should be based on the School Corporation's records as of October of the prior fiscal year. There was no documented review by the School Corporation of the enrollment and poverty counts that were prepopulated into the School Corporation's Title I grant application. Level of Effort - Individual Transactions (Vendor) The Form 9 (financial) data was submitted by the School Corporation to the IDOE semiannually. The data reported included the School Corporation's expenditures recorded during that period. The IDOE calculated Maintenance of Effort based on the expenditure information submitted on the Form 9 for that fiscal year. To verify amounts used by the IDOE in their computation were derived from the books and records of the School Corporation, costs were reviewed to ensure they were recorded properly as to account and object code and reported correctly on the Form 9. The School Corporation did not have an oversight process in place to ensure that expenditures for vendors were posted to the correct fund, account, and object codes. During review of expenditures, it was determined that there was not a documented second review in place for all vendor payments being made. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 24 WAWASEE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause Although the School Corporation stated that one person is verifying the enrollment and poverty counts that are prepopulated by the IDOE into the School Corporation's Title I grant application each year back to School Corporation records in the student information system and program eligibility files, documentation could not be presented for audit that this verification occurred. There was also not an additional person reviewing the verification for accuracy. One person entered and posted vendor expenditures in the accounting system without a review in place to ensure the expenditures were posted to the correct fund, account, and object codes. Although additional employees were involved in the claims process either by submitting paper accounts payable vouchers, signing invoices, or approving purchase orders for some claims we reviewed, there was no review by a second person after the expenditures were entered into the accounting system. Effect Without the proper implementation of an effectively designed system of internal controls, the School Corporation cannot ensure that the enrollment and poverty counts prepopulated into the School Corporation's Title I grant applications are accurate, nor can the School Corporation ensure that expenditures entered into the accounting system are coded correctly. Incorrect enrollment and poverty counts in the Title I application can lead to an incorrect amount of Title I funding being received by the School Corporation. Incorrect coding of expenditures in the accounting system can result in incorrect Maintenance of Effort calculations. Questioned Costs There were no questioned costs identified. Recommendation We recommended the School Corporation strengthen its system of internal controls over the verification of enrollment and poverty counts prepopulated into the Title I grant application by having an additional person review the verification of the counts back to School Corporation records. We also recommended strengthening the School Corporation policies and procedures to ensure that appropriate supporting documentation of this verification and review is retained to be presented for audit. We further recommend that management of the School Corporation establish and implement an effective system of internal controls over vendor expenditures to ensure expenditures for vendors are posted to the correct fund, account, and object codes. For all vendor expenditures, we recommended they are reviewed by an individual other than the person entering them into the accounting system, along with the supporting documentation of the expenditure, and that this process is documented as to the preparer and reviewer. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Corrective Action Plan

FINDING 2025-005 Finding Subject: Title I Grants to Local Educational Agencies – Internal Controls Federal Agency: Department of Education Federal Programs: Title I Grants to Local Educational Agencies CFDA Numbers: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A220014, S010A230014, S010A240014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility, Matching, Level of Effort, Earmarking Audit Findings: Material Weakness Summary of Finding: This is a repeat finding for controls only from the immediately prior audit report. The prior audit finding numbers were 2023-007 and 2023-008. Eligibility Eligibility for Title I is determined on the Eligible School Summary of the Title I application. Enrollment and Poverty numbers are automatically pulled from the Indiana Department of Education’s (IDOE) Official Pupil Enrollment (PE) count for each school into the Eligible School Summary page of the Title I application. The counts that are pre-populated should be based on the School Corporation’s records as of October of the prior fiscal year. There was no documented review by the School Corporation of the enrollment and poverty counts that were pre-populated into the School Corporation’s Title I grant application. Level of Effort – Individual Transactions (Vendor) The Form 9 (financial) data was submitted by the School Corporation to the Indiana Department of Education (IDOE) semi-annually. The data reported included the School Corporation’s expenditures recorded during that period. The IDOE calculated Maintenance of Effort based on the expenditure information submitted on the Form 9 for that fiscal year. To verify amounts used by the IDOE in their computation were derived from the books and records of the School Corporation, costs were reviewed to ensure they were recorded properly as to account and object code and reported correctly on the Form 9. The School Corporation did not have an oversight process in place to ensure that expenditures for vendors were posted to the correct fund, account, and object codes. During review of expenditures, 48 INDIANA STATE BOARD OF ACCOUNTS 48 801 S. Sycamore Street, Syracuse IN 46567 (574) 457-3188 Wawasee Community School Corporation it was determined that there was not a documented second review in place for all vendor payments being made. Contact Person Responsible for Corrective Action: Rachel Moore, Treasurer Contact Phone Number and Email Address: 574-457-3188 x 1369, rmoore@wawasee.k12.in.us Views of Responsible Officials: Management concurs with the finding. Description of Corrective Action Plan: Eligibility The Enrollment and Poverty numbers on the Indiana Department of Education’s (IDOE) Official Pupil Enrollment (PE) count for each school will be reviewed by the Assistant Superintendent and/or the Grant Coordinator for accuracy. Depending on who performs the initial review, either the Assistant Superintendent, Grant Coordinator and/or Treasurer will perform a secondary review of the enrollment and poverty numbers on the PE count for accuracy. The reviews will be documented using the internal sign-off form created by the School Corporation. This will ensure accuracy of the data prior to it being pre-populated into the Title I application. Level of Effort – Individual Transactions (Vendor) The Treasurer will prepare the Form 9 data and review for accuracy. The Assistant Superintendent and/or Grant Coordinator will review the data for accuracy. The Treasurer will not submit the Form 9 until the secondary review of the data has been completed. The review of the data will be documented via the internal sign-off form created by the School Corporation. The Treasurer will continue to prepare vendor claims; however a second School Corporation employee will review the vendor claims prior to posting to ensure accuracy of the fund, account and object code used for each disbursement as well as the amount of each claim. The reviewer will indicate review has been completed by their signature/initials on the claim form. The vendor claims will not be posted until the secondary review has been completed. Anticipated Completion Date: The planned corrective action for the vendor claims will be implemented in March of 2026. The planned corrective action for the Form 9 data will be implemented in July of 2026. The planned corrective action for the Pupil Enrollment Report data will be implemented in September of 2026.

Categories

Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 1182028 2025-003
    Material Weakness Repeat
  • 1182029 2025-003
    Material Weakness Repeat
  • 1182030 2025-003
    Material Weakness Repeat
  • 1182031 2025-003
    Material Weakness Repeat
  • 1182032 2025-003
    Material Weakness Repeat
  • 1182033 2025-003
    Material Weakness Repeat
  • 1182034 2025-004
    Material Weakness Repeat
  • 1182035 2025-004
    Material Weakness Repeat
  • 1182036 2025-004
    Material Weakness Repeat
  • 1182037 2025-004
    Material Weakness Repeat
  • 1182038 2025-004
    Material Weakness Repeat
  • 1182039 2025-004
    Material Weakness Repeat
  • 1182040 2025-005
    Material Weakness Repeat
  • 1182042 2025-006
    Material Weakness Repeat
  • 1182043 2025-006
    Material Weakness Repeat
  • 1182044 2025-007
    Material Weakness Repeat
  • 1182045 2025-007
    Material Weakness Repeat
  • 1182046 2025-008
    Material Weakness Repeat
  • 1182047 2025-008
    Material Weakness Repeat
  • 1182048 2025-008
    Material Weakness Repeat
  • 1182049 2025-008
    Material Weakness Repeat
  • 1182050 2025-008
    Material Weakness Repeat
  • 1182051 2025-008
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.425 EDUCATION STABILIZATION FUND 2024 $1.51M
10.555 NATIONAL SCHOOL LUNCH PROGRAM 2024 $1.07M
10.555 NATIONAL SCHOOL LUNCH PROGRAM 2025 $1.01M
84.425 EDUCATION STABILIZATION FUND 2025 $769,986
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES 2024 $404,416
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES 2025 $347,420
10.553 SCHOOL BREAKFAST PROGRAM 2024 $223,783
10.553 SCHOOL BREAKFAST PROGRAM 2025 $220,540
84.027 SPECIAL EDUCATION GRANTS TO STATES 2025 $217,859
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES 2024 $150,959
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES 2025 $114,477
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) 2025 $88,267
84.027 SPECIAL EDUCATION GRANTS TO STATES 2024 $80,103
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) 2024 $68,743
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN 2025 $64,839
93.778 MEDICAL ASSISTANCE PROGRAM 2025 $30,636
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM 2025 $28,985
93.778 MEDICAL ASSISTANCE PROGRAM 2024 $26,052
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM 2024 $25,128
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN 2024 $21,165
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS 2025 $16,521
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS 2024 $11,159
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS 2024 $6,037
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS 2025 $1,532