Finding 28841 (2022-002)

Material Weakness
Requirement
EGLN
Questioned Costs
-
Year
2022
Accepted
2023-02-26

AI Summary

  • Core Issue: The School Corporation lacks an effective internal control system to ensure compliance with Title I grant requirements.
  • Impacted Requirements: Key areas affected include Eligibility, Reporting, Matching, Level of Effort, Earmarking, and Special Tests related to Annual Report Card and High School Graduation Rate.
  • Recommended Follow-Up: Management should implement a robust internal control system to ensure compliance with all grant agreement requirements.

Finding Text

FINDING 2022-002 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): 19611-001-PN01, 20611-001-PN01, 21611-001-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility; Reporting; Matching, Level of Effort, Earmarking; Special Tests and Provisions - Annual Report Card, High School Graduation Rate Audit Finding: Material Weakness Condition and Context An effective internal control system was not designed nor implemented at the School Corporation to ensure compliance with the grant agreement and the Eligibility; the Reporting; the Matching, Level of Effort, Earmarking; and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate compliance requirements. Eligibility The October 1st Real Time Report of Public Enrollment (PE) was used by the Indiana Department of Education to populate the enrollment and poverty status data in the Title I applications. These numbers were then used to calculate Percent Poverty, which was used to rank schools for Title I eligibility. One person was primarily responsible for compiling and uploading student data, including poverty status, for Real Time reports. There were no documented controls in place, such as an oversight, review, or approval process to ensure eligibility was properly determined. Reporting The Indiana Department of Education used the Form 9 financial reports submitted by the School Corporation in the state's submission of the average State Per Pupil Expenditure data submitted to the National Center for Education Statistics. The Treasurer was responsible for preparing and submitting the Form 9. There were no documented controls in place such as an oversight, review, or approval process to ensure expenditures were correctly reported. Matching, Level of Effort, Earmarking The Indiana Department of Education calculates the Maintenance of Effort - Level of Effort based on expenditure information submitted on the Form 9 for that fiscal year. The Treasurer was responsible for the preparation and submission of the Form 9. There were no documented internal controls in place such as an oversight, review, or approval process to ensure expenditures were correctly reported. Special Tests and Provisions - Annual Report Card, High School Graduation Rate One person was primarily responsible for removing students from a cohort and receiving required documentation to support their removal. There were no documented controls in place to ensure the proper exit code was entered and that the required documentation was obtained. The lack of internal controls was a systemic issue throughout the entire 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). . . ." Cause Management had not designed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Eligibility; the Reporting; the Matching, Level of Effort, Earmarking; and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate compliance requirements. Effect The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Eligibility; the Reporting; the Matching, Level of Effort, Earmarking; and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate compliance requirements. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal control related to the grant agreement and the Eligibility; the Reporting; the Matching, Level of Effort, Earmarking; and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate compliance requirements. 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 2022-002 Contact Person Responsible for Corrective Action: Andrea Phillips Contact Phone Number: (812) 663-4774 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Eligibility ? The Food Service Director is responsible for communicating/uploading information in regard to families who are eligible for Free/Reduced Benefits. This work is reviewed by the Cafeteria Bookkeeper and filed in her office. The students who are ?Directly Certified? by the state of Indiana are added to the electronic student data system. The Corporation Data Manager files all necessary documents for the October 1 count day, which is then signed off by the Superintendent and Treasurer. Once the state of Indiana approves this data, a copy will be provided to the Grant Administrator. The Treasurer and Grant Administrator will be able to verify the data matches with the Eligible School Summary page of Title I basic application by comparing the October 1 count data with the Title 1 application data and signing off to this. Reporting ? The Form 9 Financial Reports will be prepared by the Treasurer and then reviewed by the Accounts Payable Clerk. During the secondary review, the Accounts Payable Clerk will compare the Form 9 Financial Report to Komputrol Reports and/or calculations prepared by Treasurer, check mark or highlight numbers verified, and signoff on the reports to ensure expenditures are correctly reported. Matching, Level of Effort, Earmarking ? The Form 9 Financial Reports will be prepared by the Treasurer and then reviewed by the Accounts Payable Clerk. During the secondary review, the Accounts Payable Clerk will compare the Form 9 Financial Report to Komputrol Reports and/or calculations prepared by Treasurer, check mark or highlight numbers verified, and signoff on the reports to ensure expenditures are correctly reported. Special Tests and Provisions ? Annual Report Card, High School Graduation Rate ? The Guidance Department and School Administration will communicate with the Registrar to prepare all documentation needed prior to a student?s removal from a cohort. Once those documents are prepared, they will be given to the Corporation Data Manager. The Building Administrator will sign off that the proper exit code was entered and documentation is available. Anticipated Completion Date: June 2023

Categories

Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 28842 2022-002
    Material Weakness
  • 28843 2022-001
    Material Weakness
  • 28844 2022-001
    Material Weakness
  • 28845 2022-001
    Material Weakness
  • 28846 2022-001
    Material Weakness
  • 28847 2022-001
    Material Weakness
  • 605283 2022-002
    Material Weakness
  • 605284 2022-002
    Material Weakness
  • 605285 2022-001
    Material Weakness
  • 605286 2022-001
    Material Weakness
  • 605287 2022-001
    Material Weakness
  • 605288 2022-001
    Material Weakness
  • 605289 2022-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.555 National School Lunch Program 22 $1.18M
84.425 Education Stabilization Fund 22 $948,554
84.027 Special Education_grants to States 21 $562,834
84.010 Title I Grants to Local Educational Agencies 22 $434,046
84.010 Title I Grants to Local Educational Agencies 21 $404,505
10.553 School Breakfast Program 22 $202,139
10.555 National School Lunch Program 21 $146,052
84.367 Improving Teacher Quality State Grants 22 $145,695
84.367 Improving Teacher Quality State Grants 21 $51,706
84.411 Investing in Innovation (i3) Fund 22 $44,138
84.424 Student Support and Academic Enrichment Program 21 $37,424
84.411 Investing in Innovation (i3) Fund 21 $31,687
10.553 School Breakfast Program 21 $29,154
93.778 Medical Assistance Program 22 $23,937
84.173 Special Education_preschool Grants 22 $17,924
84.173 Special Education_preschool Grants 21 $13,882
84.424 Student Support and Academic Enrichment Program 22 $8,606
84.048 Career and Technical Education -- Basic Grants to States 21 $4,545
84.425 Education Stabilization Fund 21 $3,443
84.027 Special Education_grants to States 22 $1,938
10.558 Child and Adult Care Food Program 22 $907