Madison Consolidated Schools

EIN: 356002609

UEI: N7KVE6CS6DN3

Data as of August 22, 2026

Madison Consolidated Schools5 audit years42 findings24 repeat
5
Audit Years
42
Total Findings
24
Repeat Findings

FY 2024-06-30

Management decision deadline — for entities that funded this organization

The FAC accepted this audit on March 6, 2025. Under 2 CFR 200.521(d), a pass-through entity that provided federal funds to this organization for this audit period must issue a management decision on these findings by September 6, 2025 (350 days ago).

What is a management decision? →
2024-003
Procurement & Suspension/Debarment
MATERIAL WEAKNESSREPEAT

FINDING 2024-003 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program Assistance Listings Numbers: 10.553, 10.555 Federal Award Number and Year (or Other Identifying Number): FY 2023-2024 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Material Weakness Repeat Finding This is a repeat finding pertaining to internal controls from the immediately prior audit report. The prior audit finding number was 2022-006. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement Federal regulations allow for informal procurement methods when the value of the procurement for property or services does not exceed the simplified acquisition threshold, which is customarily set at $250,000. However, Indiana Code 5-22-8 has a more restrictive threshold of $150,000 or less for when small purchase procedures may be used. This informal process allows for methods other than the formal bid process. The informal process is divided between two methods based on thresholds. Micro-purchases, typically for those purchases $10,000 or under, and small purchase procedures for those purchases above the micro-purchase threshold, but below the simplified acquisition threshold. Micro-purchases may be awarded without soliciting competitive price rate quotations. If small purchase procedures are used, then price or rate quotations must be obtained from an adequate number of qualified sources. The School Corporation did not have effective internal controls in place to ensure that an adequate number of price or rate quotations were obtained for all small purchases. Suspension and Debarment Prior to entering into subawards and covered transactions with the Child Nutrition Cluster (CNC) award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the Excluded Parties List System (EPLS), collecting a certification from that person, or adding a clause or condition to the covered transactions with that person. The School Corporation did not have effective internal controls in place to ensure that the verification was completed for all contractors prior to entering into covered transactions. The lack of internal controls was isolated to fiscal year 2023-2024. INDIANA STATE BOARD OF ACCOUNTS 20 MADISON CONSOLIDATED SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 established a system of internal controls to ensure documentation was obtained and retained to demonstrate they had properly procured all small purchases. Management had not established a system of internal controls to ensure that the School Corporation's procedures for verifying a contractor's suspension and debarment status was followed for all contractors. Effect Without the proper design or implementation of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. This could result in the School Corporation overpaying for goods or services or paying a contractor who has been suspended or debarred, which would be unallowable. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation strengthen its system of internal controls to ensure that an adequate number of price or rate quotations are obtained for all small purchases and that suspension and debarment is verified for all covered transactions of $25,000 or more. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2024-003 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program Assistance Listings Numbers: 10.553, 10.555 Federal Award Number and Year (or Other Identifying Number): FY 2023-2024 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Material Weakness Repeat Finding This is a repeat finding pertaining to internal controls from the immediately prior audit report. The prior audit finding number was 2022-006. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement Federal regulations allow for informal procurement methods when the value of the procurement for property or services does not exceed the simplified acquisition threshold, which is customarily set at $250,000. However, Indiana Code 5-22-8 has a more restrictive threshold of $150,000 or less for when small purchase procedures may be used. This informal process allows for methods other than the formal bid process. The informal process is divided between two methods based on thresholds. Micro-purchases, typically for those purchases $10,000 or under, and small purchase procedures for those purchases above the micro-purchase threshold, but below the simplified acquisition threshold. Micro-purchases may be awarded without soliciting competitive price rate quotations. If small purchase procedures are used, then price or rate quotations must be obtained from an adequate number of qualified sources. The School Corporation did not have effective internal controls in place to ensure that an adequate number of price or rate quotations were obtained for all small purchases. Suspension and Debarment Prior to entering into subawards and covered transactions with the Child Nutrition Cluster (CNC) award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the Excluded Parties List System (EPLS), collecting a certification from that person, or adding a clause or condition to the covered transactions with that person. The School Corporation did not have effective internal controls in place to ensure that the verification was completed for all contractors prior to entering into covered transactions. The lack of internal controls was isolated to fiscal year 2023-2024. INDIANA STATE BOARD OF ACCOUNTS 20 MADISON CONSOLIDATED SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 established a system of internal controls to ensure documentation was obtained and retained to demonstrate they had properly procured all small purchases. Management had not established a system of internal controls to ensure that the School Corporation's procedures for verifying a contractor's suspension and debarment status was followed for all contractors. Effect Without the proper design or implementation of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. This could result in the School Corporation overpaying for goods or services or paying a contractor who has been suspended or debarred, which would be unallowable. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation strengthen its system of internal controls to ensure that an adequate number of price or rate quotations are obtained for all small purchases and that suspension and debarment is verified for all covered transactions of $25,000 or more. 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 2024-003 Finding Subject: Child Nutrition Cluster – Procurement and Suspension and Debarment Summary of Finding: The School Corporation did not have effective controls in place to ensure that the verification was completed for prior to entering into covered transactions or that the correct procurement method was utilized for one vendor in the audit period. Contact Person Responsible for Corrective Action: Judy Brooks Contact Phone Number and Email Address: 812-274-8108 jbrooks@madison.k12.in.us Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: For federal procurements exceeding $25,000, the Food Service Coordinator will request a signed certification of compliance from the vendor. If she is unable to obtain a certification in this manner, alternate procedures such as checking the SAM.gov website will be utilized and the appropriate documentation supporting this review will be retained Anticipated Completion Date: 6/30/2025

Prior Finding References

2022-006

About Procurement and Suspension and Debarment →
2024-004
Special Tests & Provisions
MATERIAL WEAKNESS

FINDING 2024-004 Subject: Title I Grants to Local Educational Agencies - Special Tests and Provisions - Assessment System Security 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): S010A210014, S010A220014, S010A230014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Assessment System Security Audit Findings: Material Weakness, Other Matters Condition and Context State educational agencies (SEA), in consultation with local educational agencies (LEA), are required to establish and maintain an assessment security system that is valid, reliable, and consistent with relevant professional and technical standards. Within their assessment system, SEAs must have policies and procedures to maintain test security measures and ensure that LEAs implement those policies and procedures. As such, the Indiana Department of Education created and published the Indiana Assessment Policy Manual. As a part of the assessment security, any individual who administers, handles, or has access to secure test materials at the school or school corporation shall complete assessment training and sign a testing security and integrity statement that remains on file in the appropriate building-level office each year. Each individual required to sign the testing integrity agreement shall sign the form by an established date. The School Corporation had a process to provide assessment system security training and to ensure each employee that attended training signed the agreement indicating training was received. However, there was no process in place to ensure that all documentation of school employees being trained was retained for audit. Due to the lack of internal controls over maintaining the supporting documentation, some of the Indiana Testing and Security agreements were not provided for review. A sample of 40 employees was selected for testing from the School Corporation's roster. Of the 40 employees tested, 8 did not have a signed agreement on file indicating training was received as required. The lack of internal controls and noncompliance was isolated to the 2022-2023 school year for 3 of the buildings. 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 22 MADISON CONSOLIDATED SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 511 IAC 5-5-5(b) states: "Any individual who administers, handles, or has access to secure test materials at the school or school corporation shall complete assessment training and sign a testing security and integrity agreement to remain on file in the appropriate building-level office each year." Cause A proper system of internal controls was not designed by management of the School Corporation to ensure that all Indiana Testing and Security agreements were on file and could be presented for audit. Agreements for 8 employees selected for testing could not be located. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, not all required employees have the required Indiana Testing Security and Integrity agreement maintained for Assessment System Security. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure that all required employees complete assessment security training and that the signed appropriate forms are retained for audit. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2024-004 Subject: Title I Grants to Local Educational Agencies - Special Tests and Provisions - Assessment System Security 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): S010A210014, S010A220014, S010A230014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Assessment System Security Audit Findings: Material Weakness, Other Matters Condition and Context State educational agencies (SEA), in consultation with local educational agencies (LEA), are required to establish and maintain an assessment security system that is valid, reliable, and consistent with relevant professional and technical standards. Within their assessment system, SEAs must have policies and procedures to maintain test security measures and ensure that LEAs implement those policies and procedures. As such, the Indiana Department of Education created and published the Indiana Assessment Policy Manual. As a part of the assessment security, any individual who administers, handles, or has access to secure test materials at the school or school corporation shall complete assessment training and sign a testing security and integrity statement that remains on file in the appropriate building-level office each year. Each individual required to sign the testing integrity agreement shall sign the form by an established date. The School Corporation had a process to provide assessment system security training and to ensure each employee that attended training signed the agreement indicating training was received. However, there was no process in place to ensure that all documentation of school employees being trained was retained for audit. Due to the lack of internal controls over maintaining the supporting documentation, some of the Indiana Testing and Security agreements were not provided for review. A sample of 40 employees was selected for testing from the School Corporation's roster. Of the 40 employees tested, 8 did not have a signed agreement on file indicating training was received as required. The lack of internal controls and noncompliance was isolated to the 2022-2023 school year for 3 of the buildings. 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 22 MADISON CONSOLIDATED SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 511 IAC 5-5-5(b) states: "Any individual who administers, handles, or has access to secure test materials at the school or school corporation shall complete assessment training and sign a testing security and integrity agreement to remain on file in the appropriate building-level office each year." Cause A proper system of internal controls was not designed by management of the School Corporation to ensure that all Indiana Testing and Security agreements were on file and could be presented for audit. Agreements for 8 employees selected for testing could not be located. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, not all required employees have the required Indiana Testing Security and Integrity agreement maintained for Assessment System Security. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure that all required employees complete assessment security training and that the signed appropriate forms are retained for audit. 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 2024-004 Finding Subject: Title I - Special Tests and Provisions - Assessment System Security Summary of Finding: The School Corporation had a process to provide assessment system security training and to ensure each employee that attended training signed the agreement indicating training was received. However, there was no process in place to ensure that all documentation of school employees being trained was retained for audit. As a result, some of the Indiana Testing and Security agreements were not able to be provided for review. Contact Person Responsible for Corrective Action: Janet McCreary Contact Phone Number and Email Address: 812-274-8001 jmccreary@madison.k12.in.us Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: This was corrected in FY24. Our testing security coordinator now ensures that all training certifications are on file as required and monitors this via a spreadsheet. Anticipated Completion Date: Already completed.

About Special Tests and Provisions →
2024-005
Eligibility
MATERIAL WEAKNESSREPEAT

FINDING 2024-005 Subject: Title I Grants to Local Educational Agencies - Eligibility 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): S010A210014, S010A220014, S010A230014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. INDIANA STATE BOARD OF ACCOUNTS 23 MADISON CONSOLIDATED SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context 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 (PE) count for each school into the Eligible School Summary page of the Tile I application. These counts that are prepopulated should be based on the School Corporation's records as of October of the prior fiscal year. One person compiled and uploaded enrollment data, including poverty status for Real Time (RT) reports, to the IDOE without a documented oversight or review process to ensure that the information was accurate and retained for audit. In addition, there was no review by the School Corporation of the enrollment and poverty counts that were prepopulated into the School Corporation's Title I grant application. The IDOE used the October 1 RT reports for fiscal years 2021-2022 and 2022-2023, as provided by the School Corporation, to determine Eligibility for the 2022-2023 and 2023-2024 grant programs, respectively. The October 1 RT report could not be presented for audit for 2021-2022, which would have been used to pull in enrollment and poverty information for the 2022-2023 grant. As such, we were unable to verify the amounts reported in the grant application. Additionally, the Indiana State Board of Accounts was unable to verify if the correct socioeconomic status was properly reported for any of the students. Enrollment and poverty numbers for any nonpublic schools are manually entered into the application by the School Corporation. The School Corporation had not established an effective process to review the listing of students from the nonpublic schools for enrollment and poverty counts to be entered into the Title I application and to retain this information for audit. We were unable to determine if the enrolled student count and their poverty status in the application was accurate. The lack of internal controls and lack of information submitted for audit 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). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for the Federal awards that are renewed quarterly or annual, from the date of submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." INDIANA STATE BOARD OF ACCOUNTS 24 MADISON CONSOLIDATED SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions, to ensure all records pertinent to the federal award were retained for audit. After a change in software providers, information from the previous provider could not be obtained for audit. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, RT reports and nonpublic school enrollment documentation were not maintained for audit, and, as such, the Indiana State Board of Accounts could not determine if the School Corporation complied with the Eligibility compliance requirement. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure RT reports, and nonpublic school enrollment documentation are maintained for audit. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2024-005 Subject: Title I Grants to Local Educational Agencies - Eligibility 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): S010A210014, S010A220014, S010A230014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. INDIANA STATE BOARD OF ACCOUNTS 23 MADISON CONSOLIDATED SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context 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 (PE) count for each school into the Eligible School Summary page of the Tile I application. These counts that are prepopulated should be based on the School Corporation's records as of October of the prior fiscal year. One person compiled and uploaded enrollment data, including poverty status for Real Time (RT) reports, to the IDOE without a documented oversight or review process to ensure that the information was accurate and retained for audit. In addition, there was no review by the School Corporation of the enrollment and poverty counts that were prepopulated into the School Corporation's Title I grant application. The IDOE used the October 1 RT reports for fiscal years 2021-2022 and 2022-2023, as provided by the School Corporation, to determine Eligibility for the 2022-2023 and 2023-2024 grant programs, respectively. The October 1 RT report could not be presented for audit for 2021-2022, which would have been used to pull in enrollment and poverty information for the 2022-2023 grant. As such, we were unable to verify the amounts reported in the grant application. Additionally, the Indiana State Board of Accounts was unable to verify if the correct socioeconomic status was properly reported for any of the students. Enrollment and poverty numbers for any nonpublic schools are manually entered into the application by the School Corporation. The School Corporation had not established an effective process to review the listing of students from the nonpublic schools for enrollment and poverty counts to be entered into the Title I application and to retain this information for audit. We were unable to determine if the enrolled student count and their poverty status in the application was accurate. The lack of internal controls and lack of information submitted for audit 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). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for the Federal awards that are renewed quarterly or annual, from the date of submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." INDIANA STATE BOARD OF ACCOUNTS 24 MADISON CONSOLIDATED SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions, to ensure all records pertinent to the federal award were retained for audit. After a change in software providers, information from the previous provider could not be obtained for audit. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, RT reports and nonpublic school enrollment documentation were not maintained for audit, and, as such, the Indiana State Board of Accounts could not determine if the School Corporation complied with the Eligibility compliance requirement. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure RT reports, and nonpublic school enrollment documentation are maintained for audit. 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 2024-005 Finding Subject: Title I - Eligibility Summary of Finding: The October 1 Real Time report could not be presented for audit for 2021-2022, which would have been used to pull in enrollment and poverty information for the 2022-2023 grant. As such, we were unable to verify the amounts reported in the grant application. Additionally, we were unable to verify if the correct socioeconomic status was properly reported for any of the students. Additionally, we were unable to verify nonpublic enrollment and poverty data included on the Title I application. Contact Person Responsible for Corrective Action: Janet McCreary Contact Phone Number and Email Address: 812-274-8001 jmccreary@madison.k12.in.us Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: Due to the timing of the prior audit and the nature of the Real-Time report, this portion of the finding was not able to be completed timely for FY23’s grant. Beginning in FY24, The Data Management Specialist will save all reports submitted to the DOE. This will ensure that supporting documentation is kept that will be used determine Eligibility for Title I. Additionally, for the nonpublic enrollment and poverty data, the grants specialist meets with non-public partners to review enrollment information and verify the student population that encumbers funding. The data management specialist for MCS verifies all enrollment information and poverty identification in concert with the nutrition manager of MCS, building administrators, and the central office administration to verify all data reported to the state. Anticipated Completion Date: 6/30/2025

Prior Finding References

2022-003

About Eligibility →
2024-006
Procurement & Suspension/Debarment

FINDING 2024-006 Subject: Special Education Cluster (IDEA) - Procurement and Suspension and Debarment Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants, COVID-19 - Special Education Grants to States, COVID-19 - Special Education Preschool Grants Assistance Listings Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): HO27A220084, 21611-127-PN01, 22611-127-ARP, 22611-127-PN01, 23611-127-PN01, 23619-127-ARP, 22619-127-PN01, 23619-127-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Significant Deficiency Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and suspension and debarment compliance requirements. INDIANA STATE BOARD OF ACCOUNTS 25 MADISON CONSOLIDATED SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Prior to entering into subawards and covered transactions with the Special Education Cluster (SPED) award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the Excluded Parties List System, collecting a certification from that person, or adding a clause or condition to the covered transactions with that person. There was no internal control in place, such as an oversight, review, or approval process, to ensure that contractors or subrecipients were not suspended, debarred, or otherwise excluded. 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). . . ." Cause The School Corporation did not have internal controls in pace to ensure the suspension and debarment status for covered transactions it intended to pay with federal funds of the major program were properly verified. Effect Without the proper design or implementation of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. This could result in the School Corporation paying a contractor who has been suspended or debarred, which would be unallowable. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation strengthen its system of internal controls to ensure that suspension and debarment is verified for all covered transactions of $25,000 or more. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report

Show full finding ▾
Full finding narrative

FINDING 2024-006 Subject: Special Education Cluster (IDEA) - Procurement and Suspension and Debarment Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants, COVID-19 - Special Education Grants to States, COVID-19 - Special Education Preschool Grants Assistance Listings Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): HO27A220084, 21611-127-PN01, 22611-127-ARP, 22611-127-PN01, 23611-127-PN01, 23619-127-ARP, 22619-127-PN01, 23619-127-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Significant Deficiency Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and suspension and debarment compliance requirements. INDIANA STATE BOARD OF ACCOUNTS 25 MADISON CONSOLIDATED SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Prior to entering into subawards and covered transactions with the Special Education Cluster (SPED) award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the Excluded Parties List System, collecting a certification from that person, or adding a clause or condition to the covered transactions with that person. There was no internal control in place, such as an oversight, review, or approval process, to ensure that contractors or subrecipients were not suspended, debarred, or otherwise excluded. 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). . . ." Cause The School Corporation did not have internal controls in pace to ensure the suspension and debarment status for covered transactions it intended to pay with federal funds of the major program were properly verified. Effect Without the proper design or implementation of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. This could result in the School Corporation paying a contractor who has been suspended or debarred, which would be unallowable. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation strengthen its system of internal controls to ensure that suspension and debarment is verified for all covered transactions of $25,000 or more. 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 2024-006 Finding Subject: Special Education – Procurement Summary of Finding: There was no control in place, such as an oversight, review, or approval process, to ensure that contractors or subrecipients were not suspended, debarred, or otherwise excluded from receiving federal funds for the Special Education program. Contact Person Responsible for Corrective Action: Danica Houze Contact Phone Number and Email Address: 812-274-8103 dhouze@madison.k12.in.us Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: The CFO will monitor encumbrance reports on a regular basis. When federal procurements exceeding $25,000 are encumbered, we will have vendors submit a Suspended and Debarment Certification with their contract agreement when federal dollars are being encumbered. If we are unable to obtain a certification in this manner, alternate procedures such as checking the SAM.gov website will be utilized and the appropriate documentation supporting this review will be retained Anticipated Completion Date: 6/30/2025

About Procurement and Suspension and Debarment →

FY 2022-06-30

FAC accepted this audit on March 8, 2023 — management decision was due September 8, 2023.

2022-003
Eligibility
MATERIAL WEAKNESSREPEAT

FINDING 2022-003 Subject: Title I Grants to Local Educational Agencies - Eligibility 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): S010A190014, S010A200014, S010A210014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2020-007. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Eligibility compliance requirement. Sufficient evidence was not presented for audit to verify that the information used to determine eligibility for the Title I program was accurate. The Indiana Department of Education (IDOE) used the October 1 Real Time reports for fiscal years 2019-2020 and 2020-2021, as provided by the School Corporation, to determine Title I Eligibility for the 2020-2021 and 2021-2022 grant programs, respectively. The October 1 Real Time reports presented for audit differed from the amounts reported to the IDOE. The School Corporation could not provide an explanation for the variances. The lack of internal controls and noncompliance were systemic issues 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). . . ." 2 CFR 200.333 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." Cause Management had not developed a system of internal control that would have ensured compliance with the grant agreement and the Eligibility compliance requirement. Effect The failure to provide sufficient audit evidence for the determination of eligibility prevented the determination of the School Corporation's compliance with the Eligibility compliance requirement. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal control to ensure compliance and comply with the Eligibility compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2022-003 Subject: Title I Grants to Local Educational Agencies - Eligibility 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): S010A190014, S010A200014, S010A210014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2020-007. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Eligibility compliance requirement. Sufficient evidence was not presented for audit to verify that the information used to determine eligibility for the Title I program was accurate. The Indiana Department of Education (IDOE) used the October 1 Real Time reports for fiscal years 2019-2020 and 2020-2021, as provided by the School Corporation, to determine Title I Eligibility for the 2020-2021 and 2021-2022 grant programs, respectively. The October 1 Real Time reports presented for audit differed from the amounts reported to the IDOE. The School Corporation could not provide an explanation for the variances. The lack of internal controls and noncompliance were systemic issues 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). . . ." 2 CFR 200.333 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." Cause Management had not developed a system of internal control that would have ensured compliance with the grant agreement and the Eligibility compliance requirement. Effect The failure to provide sufficient audit evidence for the determination of eligibility prevented the determination of the School Corporation's compliance with the Eligibility compliance requirement. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal control to ensure compliance and comply with the Eligibility compliance requirement. 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-003 Contact Person Responsible for Corrective Action: Janet McCreary, Director of Curriculum, Instruction, & Assessments Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Data Management Specialist will save all reports submitted to the DOE. This will ensure that supporting documentation is kept that will be used determine Eligibility for Title I. The Title I Compliance Specialist/Grants & Compliance Specialist will verify the information for accuracy and keep documentation of the review. Anticipated Completion Date: 2/13/2023

Prior Finding References

2020-007

About Eligibility →
2022-004
Special Tests & Provisions
MATERIAL WEAKNESSREPEAT

FINDING 2022-004 Subject: Title I Grants to Local Educational Agencies - Special Tests and Provisions - Report Card, High School Graduation Rate 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): S010A190014, S010A200014, S010A210014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Annual Report Card, High School Graduation Rate Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the immediately prior audit regarding Special Tests and Provisions - Annual Report Card, High School Graduation Rate. The prior audit finding number was 2020-008. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate. The School Corporation had not established a system of internal control to ensure the proper exit code for leaving was entered and the proper supporting documentation for the exit was obtained for all applicable students. 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 a system of internal control that would have ensured compliance with the grant agreement and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate compliance requirement. Effect The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate compliance requirement. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal control, including segregation of duties, related to the grant agreement and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2022-004 Subject: Title I Grants to Local Educational Agencies - Special Tests and Provisions - Report Card, High School Graduation Rate 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): S010A190014, S010A200014, S010A210014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Annual Report Card, High School Graduation Rate Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the immediately prior audit regarding Special Tests and Provisions - Annual Report Card, High School Graduation Rate. The prior audit finding number was 2020-008. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate. The School Corporation had not established a system of internal control to ensure the proper exit code for leaving was entered and the proper supporting documentation for the exit was obtained for all applicable students. 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 a system of internal control that would have ensured compliance with the grant agreement and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate compliance requirement. Effect The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate compliance requirement. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal control, including segregation of duties, related to the grant agreement and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate compliance requirement. 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-004 Contact Person Responsible for Corrective Action: Janet McCreary, Director of Curriculum, Instruction, & Assessments Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The high school will create procedures for tracking enrollments, removals, transfers, expulsion, and graduation numbers. Beginning in FY23, a cohort review is administered three times yearly (September, February, and June) by administration and school counselors. Student Services clerk reviews the withdrawal file for any student marked unknown or undetermined to obtain any necessary documentation and/or signatures. After review and confirmation of the appropriate mobility code and documentation, administration will work with the district technology team to correct errors in data exchange. Anticipated Completion Date: 2/13/2023

Prior Finding References

2020-008

About Special Tests and Provisions →
2022-005
Matching, Level of Effort, Earmarking
MATERIAL WEAKNESSREPEAT

FINDING 2022-005 Subject: Special Education Cluster (IDEA) - Earmarking Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants Assistance Listings Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 19611-127-PN01, 20611-127-PN01, 19619-127-PN01, 20619-127-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit. The prior audit finding number was 2020-010. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Matching, Level of Effort, Earmarking compliance requirement. Proportionate share is an amount of funds that must be expended on special education/related services for parentally-placed private school and homeschooled students. The amount to be spent is automatically calculated within each grant application. The School Corporation had not designed, nor implemented policies and procedures to ensure that the required level of expenditures for non-public students was met for each grant. The School Corporation failed to maintain records of actual time spent providing services to the participating nonpublic schools for Non-Public Proportionate Share expenditures for the 19611-127-PN01, 19619-127-PN01, 20611-127-PN01, and 20619-127-PN01 grant awards. The salaries reported as expended for the nonpublic school expenditures were based on an estimate of time instead of actual time spent. As such, we could not verify that the minimum amount per grant award was expended. The lack of internal controls and noncompliance were isolated to the 19611-127-PN01, 19619-127-PN01, 20611-127-PN01, and 20619-127-PN01 grant awards. 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 awards. 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). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: . . . (g) Be adequately documented. . . ." 2 CFR 200.208(b) states in part: "The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Cause Management had not developed a system of internal control that would have ensured compliance with the grant agreement and the Matching, Level of Effort, Earmarking compliance requirement. Effect The failure to establish an effective internal control system, as well as adequately document costs of federal awards, prevented the determination of the School Corporation's compliance with the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls, as well as appropriately document and identify federal award expenditures, to ensure compliance with the grant agreement and the Matching, Level of Effort, Earmarking compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2022-005 Subject: Special Education Cluster (IDEA) - Earmarking Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants Assistance Listings Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 19611-127-PN01, 20611-127-PN01, 19619-127-PN01, 20619-127-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit. The prior audit finding number was 2020-010. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Matching, Level of Effort, Earmarking compliance requirement. Proportionate share is an amount of funds that must be expended on special education/related services for parentally-placed private school and homeschooled students. The amount to be spent is automatically calculated within each grant application. The School Corporation had not designed, nor implemented policies and procedures to ensure that the required level of expenditures for non-public students was met for each grant. The School Corporation failed to maintain records of actual time spent providing services to the participating nonpublic schools for Non-Public Proportionate Share expenditures for the 19611-127-PN01, 19619-127-PN01, 20611-127-PN01, and 20619-127-PN01 grant awards. The salaries reported as expended for the nonpublic school expenditures were based on an estimate of time instead of actual time spent. As such, we could not verify that the minimum amount per grant award was expended. The lack of internal controls and noncompliance were isolated to the 19611-127-PN01, 19619-127-PN01, 20611-127-PN01, and 20619-127-PN01 grant awards. 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 awards. 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). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: . . . (g) Be adequately documented. . . ." 2 CFR 200.208(b) states in part: "The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Cause Management had not developed a system of internal control that would have ensured compliance with the grant agreement and the Matching, Level of Effort, Earmarking compliance requirement. Effect The failure to establish an effective internal control system, as well as adequately document costs of federal awards, prevented the determination of the School Corporation's compliance with the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls, as well as appropriately document and identify federal award expenditures, to ensure compliance with the grant agreement and the Matching, Level of Effort, Earmarking compliance requirement. 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-005 Contact Person Responsible for Corrective Action: Danica Houze, Chief Financial Officer Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Starting in FY 2021 Time and Effort logs were kept by employees working with non-public students. Logs are submitted to the Director of Student Services and the payroll department, then accounts are distributed to match time actually spent with the non-public time spent per the time and effort logs. Anticipated Completion Date: 2/13/2023

Prior Finding References

2020-001

About Matching, Level of Effort, Earmarking →
2022-006
Procurement & Suspension/Debarment
MATERIAL WEAKNESSREPEAT

FINDING 2022-006 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, COVID-19 - School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch Program Assistance Listings Numbers: 10.553, 10.555 Federal Award Numbers and Years (or Other Identifying Numbers): FY 20-21, FY 21-22 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2020-004. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement The School Corporation did not obtain price or rate quotes for purchases of milk or bread exceeding $10,000 from an adequate number of sources, which fell under the small purchase procedures. Two of the five small purchase procurements tested in fiscal year 2020-2021 did not comply. Suspension and Debarment The School Corporation did not verify that all vendors with contracts over $25,000 were not excluded or disqualified from participation in federal award programs. One of the five contracts tested for 2021-2022 did not comply. The lack of internal controls and noncompliance were systemic issues 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). . . ." 2 CFR 200.318 states in part: "(a) The non-Federal entity must have and use documented procurement procedures, consistent with State, local, and tribal laws and regulations and the standards of this section, for the acquisition of property or services required under a Federal award or subaward. The non-Federal entity's documented procurement procedures must conform to the procurement standards identified in ?? 200.317 through 200.327. . . . (i) The non-Federal entity must maintain records sufficient to detail the history of procurement. These records will include, but are not necessarily limited to, the following: Rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price." 2 CFR 200.320(b) (Uniform Guidance) states: "Procurement by small purchase procedures. Small purchase procedures are those relatively simple and informal procurement methods for securing services, supplies, or other property that do not cost more than the Simplified Acquisition Threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources." 2 CFR 200.320 (Revised Uniform Guidance) states in part: "The non-Federal entity must have and use document procurement procedures, consistent with the standards of this section and ?? 200.317, 200.318, and 200.319 for any of the following methods of procurement used for the acquisition of property or services required under a Federal award or sub-award. (a) Informal procurement methods. When the value of the procurement for property or services under a Federal award does not exceed the simplified acquisition threshold (SAT), as defined in ? 200.1, or a lower threshold established by a non-Federal entity, formal procurement methods are not required. The non-Federal entity may use informal procurement methods to expedite the completion of its transactions and minimize the associated administrative burden and cost. The informal methods used for procurement of property or services at or below the SAT include: . . . (2) Small purchases ? (i) Small purchase procedures. The acquisition of property or services, the aggregate dollar amount of which is higher than the micro-purchase threshold but does not exceed the simplified acquisition threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate by the non-Federal entity. . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause Management had not established a system of internal control that would have ensured compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Effect The failure to design and implement an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal control to ensure compliance and comply with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2022-006 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, COVID-19 - School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch Program Assistance Listings Numbers: 10.553, 10.555 Federal Award Numbers and Years (or Other Identifying Numbers): FY 20-21, FY 21-22 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2020-004. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement The School Corporation did not obtain price or rate quotes for purchases of milk or bread exceeding $10,000 from an adequate number of sources, which fell under the small purchase procedures. Two of the five small purchase procurements tested in fiscal year 2020-2021 did not comply. Suspension and Debarment The School Corporation did not verify that all vendors with contracts over $25,000 were not excluded or disqualified from participation in federal award programs. One of the five contracts tested for 2021-2022 did not comply. The lack of internal controls and noncompliance were systemic issues 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). . . ." 2 CFR 200.318 states in part: "(a) The non-Federal entity must have and use documented procurement procedures, consistent with State, local, and tribal laws and regulations and the standards of this section, for the acquisition of property or services required under a Federal award or subaward. The non-Federal entity's documented procurement procedures must conform to the procurement standards identified in ?? 200.317 through 200.327. . . . (i) The non-Federal entity must maintain records sufficient to detail the history of procurement. These records will include, but are not necessarily limited to, the following: Rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price." 2 CFR 200.320(b) (Uniform Guidance) states: "Procurement by small purchase procedures. Small purchase procedures are those relatively simple and informal procurement methods for securing services, supplies, or other property that do not cost more than the Simplified Acquisition Threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources." 2 CFR 200.320 (Revised Uniform Guidance) states in part: "The non-Federal entity must have and use document procurement procedures, consistent with the standards of this section and ?? 200.317, 200.318, and 200.319 for any of the following methods of procurement used for the acquisition of property or services required under a Federal award or sub-award. (a) Informal procurement methods. When the value of the procurement for property or services under a Federal award does not exceed the simplified acquisition threshold (SAT), as defined in ? 200.1, or a lower threshold established by a non-Federal entity, formal procurement methods are not required. The non-Federal entity may use informal procurement methods to expedite the completion of its transactions and minimize the associated administrative burden and cost. The informal methods used for procurement of property or services at or below the SAT include: . . . (2) Small purchases ? (i) Small purchase procedures. The acquisition of property or services, the aggregate dollar amount of which is higher than the micro-purchase threshold but does not exceed the simplified acquisition threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate by the non-Federal entity. . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause Management had not established a system of internal control that would have ensured compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Effect The failure to design and implement an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal control to ensure compliance and comply with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. 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-006 Contact Person Responsible for Corrective Action: Judy Brooks, Food Service Coordinator Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Food Service Coordinator will follow our procurement procedures for all purchases. Food Service Coordinator will document that vendors for the BID are not suspended or debarred from participation in federal programs before purchasing also vendors used through the Wilson Center. The Deputy Treasurer will verify procurement and suspension and debarment documentation is on file before payment is made. When we are checking the vendors on the sams.gov website and there are no results founds then we will also request the vendor to submit a suspended and debarred form. Anticipated Completion Date: 2/13/2023

Prior Finding References

2020-004

About Procurement and Suspension and Debarment →
2022-007
Equipment & Real Property
MATERIAL WEAKNESS

FINDING 2022-007 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425U Federal Award Number and Year (or Other Identifying Number): S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation had not designed, nor implemented a system of internal control over the addition of assets to the capital asset ledger. One employee was responsible for the preparation of the capital asset ledger, and the maintenance of the property records and required information, without a documented review or oversight process in place to detect and allow correction of errors. Three construction projects initiated in the audit period were paid with ESSER grant funds. These projects were all partially completed during the audit period and pay applications were paid on all three projects. However, two of the three projects were not included in Construction in Progress on the School Corporation's capital asset ledger. Additionally, the School Corporation did not have a control process in place to ensure that a physical inventory was performed at least biannually. The School Corporation's last physical asset inventory was taken in 2018. The lack of internal controls and noncompliance were systemic issues 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). . . ." 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. (3) A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated. . . ." Cause Management had not developed, nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could result in the loss of future federal funds to the School Corporation. 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 Equipment and Real Property Management compliance. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2022-007 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425U Federal Award Number and Year (or Other Identifying Number): S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation had not designed, nor implemented a system of internal control over the addition of assets to the capital asset ledger. One employee was responsible for the preparation of the capital asset ledger, and the maintenance of the property records and required information, without a documented review or oversight process in place to detect and allow correction of errors. Three construction projects initiated in the audit period were paid with ESSER grant funds. These projects were all partially completed during the audit period and pay applications were paid on all three projects. However, two of the three projects were not included in Construction in Progress on the School Corporation's capital asset ledger. Additionally, the School Corporation did not have a control process in place to ensure that a physical inventory was performed at least biannually. The School Corporation's last physical asset inventory was taken in 2018. The lack of internal controls and noncompliance were systemic issues 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). . . ." 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. (3) A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated. . . ." Cause Management had not developed, nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could result in the loss of future federal funds to the School Corporation. 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 Equipment and Real Property Management compliance. 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-007 Contact Person Responsible for Corrective Action: Danica Houze, Chief Financial Officer Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: We are in the process of contracting with a fixed asset company to perform a physical fixed asset review for MCS. The Assistant to the CFO and the CFO will monitor this process and perform a documented review of the asset ledger. Anticipated Completion Date: 2/13/2023

About Equipment and Real Property Management →
2022-008
Reporting
MATERIAL WEAKNESS

FINDING 2022-008 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U210013, S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) and the Governor's Emergency Education Relief (GEER) annual Data Collection reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, two of eight key line items examined were not able to be traced to the School Corporation's records. The School Corporation was unable to provide supporting documentation for Full Time Equivalent (FTE) figures that matched what was reported to the Indiana Department of Education. Variances ranged from 5.7 to 55.27. The lack of internal controls was systemic throughout the audit period. Noncompliance was isolated to ESSER I and GEER I, year 1 annual reports. 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). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not developed, nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2022-008 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U210013, S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) and the Governor's Emergency Education Relief (GEER) annual Data Collection reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, two of eight key line items examined were not able to be traced to the School Corporation's records. The School Corporation was unable to provide supporting documentation for Full Time Equivalent (FTE) figures that matched what was reported to the Indiana Department of Education. Variances ranged from 5.7 to 55.27. The lack of internal controls was systemic throughout the audit period. Noncompliance was isolated to ESSER I and GEER I, year 1 annual reports. 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). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not developed, nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. 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-008 Contact Person Responsible for Corrective Action: Danica Houze, Chief Financial Officer Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Documentation will be kept to ensure evidence of preparation, review, and approval of the Grant Reporting. Two individuals will sign off on all future reports and documentation will be kept on file. Anticipated Completion Date: 2/13/2023

About Reporting →
2022-009
Special Tests & Provisions
MATERIAL WEAKNESS

FINDING 2022-009 Subject: COVID-19 - Education Stabilization Fund - Special Tests and Provisions - Wage Rate Requirements Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425U Federal Award Number and Year (or Other Identifying Number): S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Wage Rate Requirements Audit Findings: Material Weakness, Modified Opinion Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Special Tests and Provisions - Wage Rate Requirements compliance requirement. Construction contracts in excess of $2,000 financed by federal assistance funds must pay wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL) to its laborers and mechanics. Nonfederal entities are to include in its construction contracts subject to the Wage Rate Requirements a provision that the contractor or subcontractor comply with these requirements and the DOL regulations. This would include a requirement to submit a copy of the payroll and statement of compliance to the entity for each week in which contract work was performed. The School Corporation entered into three construction projects during the year. Each contract contained a provision that the contract comply with applicable wage rate requirements, and that weekly payrolls be submitted to the School Corporation. However, the School Corporation did not have adequate policies or procedures to ensure that the certified payrolls were submitted for each week in which contract work was performed. No certified weekly payrolls were presented for audit for the three construction projects the School Corporation funded with Education Stabilization funds. The lack of internal controls and noncompliance were systemic issues 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). . . ." 48 CFR 22.406 6(a) states: "Submission. In accordance with the clause at 52.222-8, Payrolls and Basic Records, the contractor must submit or cause to be submitted, within 7 calendar days after the regular payment date of the payroll week covered, for the contractor and each subcontractor, (1) copies of weekly payrolls applicable to the contract, and (2) weekly payroll statements of compliance. The contractor may use the Department of Labor Form WH-347, Payroll (For Contractor's Optional Use), or a similar form that provides the same data and identical representation." Cause Management had not designed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Special Tests and Provisions - Wage Rate Requirements compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Special Tests and Provisions - Wage Rate Requirements compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal control to ensure compliance and comply with the grant agreement and the Special Tests and Provisions - Wage Rate Requirements compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2022-009 Subject: COVID-19 - Education Stabilization Fund - Special Tests and Provisions - Wage Rate Requirements Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425U Federal Award Number and Year (or Other Identifying Number): S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Wage Rate Requirements Audit Findings: Material Weakness, Modified Opinion Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Special Tests and Provisions - Wage Rate Requirements compliance requirement. Construction contracts in excess of $2,000 financed by federal assistance funds must pay wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL) to its laborers and mechanics. Nonfederal entities are to include in its construction contracts subject to the Wage Rate Requirements a provision that the contractor or subcontractor comply with these requirements and the DOL regulations. This would include a requirement to submit a copy of the payroll and statement of compliance to the entity for each week in which contract work was performed. The School Corporation entered into three construction projects during the year. Each contract contained a provision that the contract comply with applicable wage rate requirements, and that weekly payrolls be submitted to the School Corporation. However, the School Corporation did not have adequate policies or procedures to ensure that the certified payrolls were submitted for each week in which contract work was performed. No certified weekly payrolls were presented for audit for the three construction projects the School Corporation funded with Education Stabilization funds. The lack of internal controls and noncompliance were systemic issues 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). . . ." 48 CFR 22.406 6(a) states: "Submission. In accordance with the clause at 52.222-8, Payrolls and Basic Records, the contractor must submit or cause to be submitted, within 7 calendar days after the regular payment date of the payroll week covered, for the contractor and each subcontractor, (1) copies of weekly payrolls applicable to the contract, and (2) weekly payroll statements of compliance. The contractor may use the Department of Labor Form WH-347, Payroll (For Contractor's Optional Use), or a similar form that provides the same data and identical representation." Cause Management had not designed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Special Tests and Provisions - Wage Rate Requirements compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Special Tests and Provisions - Wage Rate Requirements compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal control to ensure compliance and comply with the grant agreement and the Special Tests and Provisions - Wage Rate Requirements compliance requirement. 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-009 Contact Person Responsible for Corrective Action: Danica Houze, Chief Financial Officer Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: In the future when we have construction projects being paid from federal funds we will request the contractor to submit payroll logs weekly to the Director of Facilities. We will also require them to include weekly payroll reports in the pay applications. Anticipated Completion Date: 2/13/23

About Special Tests and Provisions →

FY 2020-06-30

FAC accepted this audit on June 7, 2021 — management decision was due December 7, 2021.

2020-002
Cost Allowability / Program Income / Special Tests & Provisions
MATERIAL WEAKNESSREPEAT

FINDING 2020-002 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles, Program Income, Special Tests and Provisions - School Food Accounts Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, COVID-19 - School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch Program CFDA Numbers: 10.553, 10.555 Federal Award Numbers and Years (or Other Identifying Numbers): FY 2018-19, FY 2019-20 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Allowable Costs/Cost Principles, Program Income, Special Tests and Provisions - School Food Accounts Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit. The prior audit finding numbers were 2018-002 and 2018-003. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Allowable Costs/Cost Principles, Program Income, and Special Tests and Provisions - School Food Accounts compliance requirements. Adequate internal controls were not in place to ensure meal prices charged were the prices approved by the School Board. Additionally, internal controls were not implemented to verify all program income from meal sales was accurately calculated and recorded in the ledger. Finally, internal controls were not in place to review the financial activity of the program to ensure all monies associated with the program were accurately recorded and expenditures were allowable. Total costs charged to the program that did not comply were $375,410. The costs were comprised of salaries and benefits and utilities as described below. The School Corporation did not maintain adequate time and effort documentation for some employees paid from the School Lunch fund. Payroll records were not maintained for two employees whose job responsibilities were shown as solely related to the Child Nutrition program. Salaries and benefits for these two employees totaled $267,248. Additionally, 15 percent of an administrator's salary and benefits were charged to the program during fiscal year 2018-2019 without supporting documentation of the actual time spent on the program. Total salaries and benefits charged for the administrator during 2018-2019 totaled $17,576. Utility charges derived from costs associated with solid waste management; natural gas; internet; telecommunications, water, wastewater, and electricity were charged as direct costs to the program using an allocation based upon square footage of the kitchen space at the various school facilities in relationship to total building square footage. Utility costs charged to the program as direct costs totaled $90,586 for the audit period. The lack of internal controls and noncompliance were systemic issues 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). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." Indiana Department of Education's Frequently Asked Questions Related to Indirect Cost Rates states: "The Indirect Cost Rate calculated by the Office of School Finance sets the maximum rate a Local Education Agency can use. A Local Education Agency, however, is allowed to use any amount below the rate calculated by the Office of School Finance to the extent the funds are available." The United States Department of Agriculture's Indirect Costs Guidance for State Agencies & School Food Authorities, Appendix D: Typical Costs and their Classifications and Direct or Indirect states in part: . . . "utilities based upon one meter for the entire school should be charged as indirect costs." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities (for IHE, this per the IHE's definition of IBS); . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." 7 CFR 220.7(e) states in part: "Each school food authority approved to participate in the program shall enter into a written agreement with the State agency or the Department through the FNSRO, as applicable, that may be amended as necessary. . . . Such agreements shall provide that the School Food Authority shall, with respect to participating schools under its jurisdiction: . . ." 7 CFR 210.14(a) states: "Nonprofit school food service. School food authorities shall maintain a nonprofit school food service. Revenues received by the nonprofit school food service are to be used only for the operation or improvement of such food service, except that, such revenues shall not be used to purchase land or buildings, unless otherwise approved by FNS, or to construct buildings. Expenditures of nonprofit school food service revenues shall be in accordance with the financial management system established by the State agency under ? 210.19(a) of this part. School food authorities may use facilities, equipment, and personnel supported with nonprofit school food revenues to support a nonprofit nutrition program for the elderly, including a program funded under the Older Americans Act of 1965 (42 U.S.C. 3001 et seq.)." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Allowable Costs/Cost Principles, Program Income, and Special Tests and Provisions - School Food Accounts compliance requirements. Effect The failure to establish an effective system of internal controls enabled noncompliance to go undetected. Noncompliance with the grant agreement and the compliance requirements could have resulted in the loss of funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance with the grant agreement and the Allowable Costs/Cost Principles, Program Income, and Special Tests and Provisions - School Food Accounts compliance requirements. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2020-002 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles, Program Income, Special Tests and Provisions - School Food Accounts Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, COVID-19 - School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch Program CFDA Numbers: 10.553, 10.555 Federal Award Numbers and Years (or Other Identifying Numbers): FY 2018-19, FY 2019-20 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Allowable Costs/Cost Principles, Program Income, Special Tests and Provisions - School Food Accounts Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit. The prior audit finding numbers were 2018-002 and 2018-003. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Allowable Costs/Cost Principles, Program Income, and Special Tests and Provisions - School Food Accounts compliance requirements. Adequate internal controls were not in place to ensure meal prices charged were the prices approved by the School Board. Additionally, internal controls were not implemented to verify all program income from meal sales was accurately calculated and recorded in the ledger. Finally, internal controls were not in place to review the financial activity of the program to ensure all monies associated with the program were accurately recorded and expenditures were allowable. Total costs charged to the program that did not comply were $375,410. The costs were comprised of salaries and benefits and utilities as described below. The School Corporation did not maintain adequate time and effort documentation for some employees paid from the School Lunch fund. Payroll records were not maintained for two employees whose job responsibilities were shown as solely related to the Child Nutrition program. Salaries and benefits for these two employees totaled $267,248. Additionally, 15 percent of an administrator's salary and benefits were charged to the program during fiscal year 2018-2019 without supporting documentation of the actual time spent on the program. Total salaries and benefits charged for the administrator during 2018-2019 totaled $17,576. Utility charges derived from costs associated with solid waste management; natural gas; internet; telecommunications, water, wastewater, and electricity were charged as direct costs to the program using an allocation based upon square footage of the kitchen space at the various school facilities in relationship to total building square footage. Utility costs charged to the program as direct costs totaled $90,586 for the audit period. The lack of internal controls and noncompliance were systemic issues 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). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." Indiana Department of Education's Frequently Asked Questions Related to Indirect Cost Rates states: "The Indirect Cost Rate calculated by the Office of School Finance sets the maximum rate a Local Education Agency can use. A Local Education Agency, however, is allowed to use any amount below the rate calculated by the Office of School Finance to the extent the funds are available." The United States Department of Agriculture's Indirect Costs Guidance for State Agencies & School Food Authorities, Appendix D: Typical Costs and their Classifications and Direct or Indirect states in part: . . . "utilities based upon one meter for the entire school should be charged as indirect costs." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities (for IHE, this per the IHE's definition of IBS); . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." 7 CFR 220.7(e) states in part: "Each school food authority approved to participate in the program shall enter into a written agreement with the State agency or the Department through the FNSRO, as applicable, that may be amended as necessary. . . . Such agreements shall provide that the School Food Authority shall, with respect to participating schools under its jurisdiction: . . ." 7 CFR 210.14(a) states: "Nonprofit school food service. School food authorities shall maintain a nonprofit school food service. Revenues received by the nonprofit school food service are to be used only for the operation or improvement of such food service, except that, such revenues shall not be used to purchase land or buildings, unless otherwise approved by FNS, or to construct buildings. Expenditures of nonprofit school food service revenues shall be in accordance with the financial management system established by the State agency under ? 210.19(a) of this part. School food authorities may use facilities, equipment, and personnel supported with nonprofit school food revenues to support a nonprofit nutrition program for the elderly, including a program funded under the Older Americans Act of 1965 (42 U.S.C. 3001 et seq.)." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Allowable Costs/Cost Principles, Program Income, and Special Tests and Provisions - School Food Accounts compliance requirements. Effect The failure to establish an effective system of internal controls enabled noncompliance to go undetected. Noncompliance with the grant agreement and the compliance requirements could have resulted in the loss of funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance with the grant agreement and the Allowable Costs/Cost Principles, Program Income, and Special Tests and Provisions - School Food Accounts 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 2020-002 Contact Person Responsible for Corrective Action: Judy Brooks, Food Service Coordinator Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: We are no longer paying an administrator partially from the federal grant, this stopped at end of 2018- 2019 school year. All hourly employees paid out of the program will complete a time card indicating the hours worked. Payroll will ensure accounts are distributed per time cards. Semiannual certifications will be filled out by salaried employees fully paid out of Child Nutrition Federal Grant. The Food Service Coordinator and the payroll and compliance clerk will work together to maintain an effective internal control system in compliance with the grant agreement and the program income compliance requirement. The monthly program income spreadsheet that is created by the food service Coordinator will be reviewed and signed off by the payroll and compliance clerk prior to submission to the Treasurer. Utilities charged to the program will be based on the indirect cost rate, and will be reported on the annual report as indirect costs. Anticipated Completion Date: 8/1/2021

Prior Finding References

2018-002, 2018-003

About Allowable Costs / Cost Principles, Program Income, Special Tests and Provisions →
2020-003
Eligibility
MATERIAL WEAKNESS

FINDING 2020-003 Subject: Child Nutrition Cluster - Eligibility Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, COVID-19 - School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch Program CFDA Numbers: 10.553, 10.555 Federal Award Numbers and Years (or Other Identifying Numbers): FY 2018-19, FY 2019-20 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility Audit Finding: Material Weakness Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Eligibility compliance requirement. Internal controls were not in place for direct certifications. There was no evidence of oversight or review process to ensure all students were correctly identified as qualifying for direct certification. 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). . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Eligibility compliance requirement. Effect The failure to establish an effective system of internal controls placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirement. A lack of segregation of duties within an internal control system could also have allowed noncompliance with the compliance requirement and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls, including segregation of duties, related to the grant agreement and the Eligibility compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2020-003 Subject: Child Nutrition Cluster - Eligibility Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, COVID-19 - School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch Program CFDA Numbers: 10.553, 10.555 Federal Award Numbers and Years (or Other Identifying Numbers): FY 2018-19, FY 2019-20 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility Audit Finding: Material Weakness Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Eligibility compliance requirement. Internal controls were not in place for direct certifications. There was no evidence of oversight or review process to ensure all students were correctly identified as qualifying for direct certification. 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). . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Eligibility compliance requirement. Effect The failure to establish an effective system of internal controls placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirement. A lack of segregation of duties within an internal control system could also have allowed noncompliance with the compliance requirement and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls, including segregation of duties, related to the grant agreement and the Eligibility compliance requirement. 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 2020-003 Contact Person Responsible for Corrective Action: Judy Brooks, Food Service Coordinator Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Internal control procedures for grant eligibility will be created to ensure compliance is met. Two employees will verify direct certification. Anticipated Completion Date: 8/1/2021

About Eligibility →
2020-004
Procurement & Suspension/Debarment
MATERIAL WEAKNESSREPEAT

FINDING 2020-004 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, COVID-19 - School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch Program CFDA Numbers: 10.553, 10.555 Federal Award Numbers and Years (or Other Identifying Numbers): FY 2018-19, FY 2019-20 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit. The prior audit finding number is 2018-006. Condition and Context The School Corporation was a member of the Wilson Education Center (Service Center). During the audit period, the Service Center solicited, evaluated, and awarded bids for bread, milk, and other products on behalf of its members. An effective internal control system was not in place at the Service Center and the School Corporation to ensure compliance with requirements related to the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement The Service Center bids for bread and milk were originally awarded for fiscal year 2016-2017. Each contract included a clause stating that the contract could be extended for three additional 12-month periods by mutual written agreements. The Service Center could not provide written contracts of the mutually agreed-upon extensions for the bread and dairy bids for either 2018-2019 or 2019-2020. For 2019-2020, the Service Center had emails with the contractor that noted the agreement to extend the contract. The School Corporation did not follow proper procurement requirements for small purchases. There was an instance in which no quotes were obtained for the items purchased. In another instance, bids were obtained for items purchased, but documentation was not retained to document how the bids were evaluated to determine the responsive bidder and criteria used. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Suspension and Debarment The Service Center bids for bread and milk were originally awarded for 2016-2017. Each contract included a clause stating that the contract could be extended for three additional 12-month periods by mutual written agreement, along with a clause noting that the vendor was not suspended or debarred. The Service Center could not provide documentation of the mutually agreed-upon contracts for the extensions of the bread and dairy bids for either 2018-2019 or 2019-2020. The Service Center obtained certifications for 2019-2020 from the vendors that stated they were not suspended or debarred. The Service Center did not provide documentation that procedures were performed to verify the vendors were not suspended or debarred for 2018-2019. The School Corporation did not provided documentation that procedures were performed to verify the vendors were not suspended or debarred for 2018-2019 for all three of the vendors tested. The lack of internal controls and noncompliance were systemic issues isolated to 2018-2019. 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). . . ." 2 CFR 200.318(a) states: "The non-Federal entity must use its own documented procurement procedures which reflect applicable State, local, and tribal laws and regulations, provided that the procurements conform to applicable Federal law and the standards identified in this part." 2 CFR 200.318(i) states: "The non-Federal entity must maintain records sufficient to detail the history of procurement. These records will include, but are not necessarily limited to the following: rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price." 2 CFR 200.320 states in part: "The non-Federal entity must use one of the following methods of procurement. . . . (b) Procurement by small purchase procedures. Small purchase procedures are those relatively simple and informal procurement methods for securing services, supplies, or other property that do not cost more than the Simplified Acquisition Threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources. . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking the SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause Management of the School Corporation had not developed a system of internal controls that would have ensured compliance with the Procurement and Suspension and Debarment compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the compliance requirement could have resulted in the loss of federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2020-004 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, COVID-19 - School Breakfast Program, National School Lunch Program, COVID-19 - National School Lunch Program CFDA Numbers: 10.553, 10.555 Federal Award Numbers and Years (or Other Identifying Numbers): FY 2018-19, FY 2019-20 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit. The prior audit finding number is 2018-006. Condition and Context The School Corporation was a member of the Wilson Education Center (Service Center). During the audit period, the Service Center solicited, evaluated, and awarded bids for bread, milk, and other products on behalf of its members. An effective internal control system was not in place at the Service Center and the School Corporation to ensure compliance with requirements related to the grant agreement and the Procurement and Suspension and Debarment compliance requirement. Procurement The Service Center bids for bread and milk were originally awarded for fiscal year 2016-2017. Each contract included a clause stating that the contract could be extended for three additional 12-month periods by mutual written agreements. The Service Center could not provide written contracts of the mutually agreed-upon extensions for the bread and dairy bids for either 2018-2019 or 2019-2020. For 2019-2020, the Service Center had emails with the contractor that noted the agreement to extend the contract. The School Corporation did not follow proper procurement requirements for small purchases. There was an instance in which no quotes were obtained for the items purchased. In another instance, bids were obtained for items purchased, but documentation was not retained to document how the bids were evaluated to determine the responsive bidder and criteria used. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Suspension and Debarment The Service Center bids for bread and milk were originally awarded for 2016-2017. Each contract included a clause stating that the contract could be extended for three additional 12-month periods by mutual written agreement, along with a clause noting that the vendor was not suspended or debarred. The Service Center could not provide documentation of the mutually agreed-upon contracts for the extensions of the bread and dairy bids for either 2018-2019 or 2019-2020. The Service Center obtained certifications for 2019-2020 from the vendors that stated they were not suspended or debarred. The Service Center did not provide documentation that procedures were performed to verify the vendors were not suspended or debarred for 2018-2019. The School Corporation did not provided documentation that procedures were performed to verify the vendors were not suspended or debarred for 2018-2019 for all three of the vendors tested. The lack of internal controls and noncompliance were systemic issues isolated to 2018-2019. 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). . . ." 2 CFR 200.318(a) states: "The non-Federal entity must use its own documented procurement procedures which reflect applicable State, local, and tribal laws and regulations, provided that the procurements conform to applicable Federal law and the standards identified in this part." 2 CFR 200.318(i) states: "The non-Federal entity must maintain records sufficient to detail the history of procurement. These records will include, but are not necessarily limited to the following: rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price." 2 CFR 200.320 states in part: "The non-Federal entity must use one of the following methods of procurement. . . . (b) Procurement by small purchase procedures. Small purchase procedures are those relatively simple and informal procurement methods for securing services, supplies, or other property that do not cost more than the Simplified Acquisition Threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources. . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking the SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause Management of the School Corporation had not developed a system of internal controls that would have ensured compliance with the Procurement and Suspension and Debarment compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the compliance requirement could have resulted in the loss of federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. 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 2020-004 Contact Person Responsible for Corrective Action: Judy Brooks, Food Service Coordinator Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Food Service Coordinator will follow our procurement procedures for all purchases. Food Service Coordinator will document that vendors for the BID are not suspended or debarred from participation in federal programs before purchasing also vendors used through the Wilson Center. The Deputy Treasurer will verify procurement and suspension and debarment documentation is on file before payment is made. Anticipated Completion Date: 8/1/2021

Prior Finding References

2018-006

About Procurement and Suspension and Debarment →
2020-005
Special Tests & Provisions
MATERIAL WEAKNESS

FINDING 2020-005 Subject: Child Nutrition Cluster - Special Tests and Provisions - Paid Lunch Equity Federal Agency: Department of Agriculture Federal Program: National School Lunch Program CFDA Number: 10.555 Federal Award Number and Year (or Other Identifying Number): FY 2018-19 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Paid Lunch Equity Audit Finding: Material Weakness, Other Matters Condition and Context An effective internal control system, which would include segregation of duties, was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Special Tests and Provisions - Paid Lunch Equity compliance requirement. Internal controls over the paid lunch equity calculation were ineffective. Meal prices for the junior/senior high used in the paid lunch equity calculations for fiscal year 2018-2019 were incorrectly reported as $2.20 when the actual amount charged was $2.30 resulting in an error in the calculation. The lack of effective internal controls and noncompliance was isolated to 2018-2019. 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). . . ." 7 CFR 210.14(e) states in part: "Pricing paid lunches. For each school year beginning July 1, 2011, school food authorities shall establish prices for paid lunches in accordance with this paragraph. (1) Calculation procedures. Each school food authority shall: (i) Determine the average price of paid lunches. The average shall be determined based on the total number of paid lunches claimed for the month of October in the previous school year, at each different price charged by the school food authority. (ii) Calculate the difference between the per meal Federal reimbursement for paid and free lunches received by the school food authority in the previous school year (i.e., the reimbursement difference); (iii) Compare the average price of a paid lunch under paragraph (e)(1)(i) of this section to the difference between reimbursement rates under paragraph (e)(1)(ii) of this section. (2) Average paid lunch price is equal to/greater than the reimbursement difference. When the average paid lunch price from the prior school year is equal to or greater than the difference in reimbursement rates as determined in paragraph (e)(1)(iii) of this section, the school food authority shall establish an average paid lunch price for the current school year that is not less than the difference identified in (e)(1)(iii) of this section; except that, the school food authority may use the procedure in paragraph (e)(4)(ii) of this section when establishing prices of paid lunches. (3) Average lunch price is lower than the reimbursement difference. When the average price from the prior school year is lower than the difference in reimbursement rates as determined in paragraph (e)(1)(iii) of this section, the school food authority shall establish an average price for the current school year that is not less than the average price charged in the previous school year as adjusted by a percentage equal to the sum obtained by adding: (i) 2 percent; and (ii) The percentage change in the Consumers Price Index for All Urban Consumers used to increase the Federal reimbursement rate under section 11 of the Act for the most recent school year for which data are available. The percentage to be used is found in the annual notice published in the FEDERAL REGISTER announcing the national average payment rates, from the prior year. (4) Price adjustments. (i) Maximum required price increase. The maximum annual average price increase required under this paragraph shall not exceed ten cents. (ii) Rounding of paid lunch prices. Any school food authority may round the adjusted price of the paid lunches down to the nearest five cents. (iii) Optional price increases. A school food authority may increase the average price by more than ten cents. . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the Special Tests and Provisions - Paid Lunch Equity compliance requirement. Effect The failure to establish an effective internal control system enabled noncompliance to go undetected. Noncompliance with the grant agreement and the compliance requirement could have resulted in the loss of funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance with the grant agreement and the Special Test and Provisions - Paid Lunch Equity compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2020-005 Subject: Child Nutrition Cluster - Special Tests and Provisions - Paid Lunch Equity Federal Agency: Department of Agriculture Federal Program: National School Lunch Program CFDA Number: 10.555 Federal Award Number and Year (or Other Identifying Number): FY 2018-19 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Paid Lunch Equity Audit Finding: Material Weakness, Other Matters Condition and Context An effective internal control system, which would include segregation of duties, was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Special Tests and Provisions - Paid Lunch Equity compliance requirement. Internal controls over the paid lunch equity calculation were ineffective. Meal prices for the junior/senior high used in the paid lunch equity calculations for fiscal year 2018-2019 were incorrectly reported as $2.20 when the actual amount charged was $2.30 resulting in an error in the calculation. The lack of effective internal controls and noncompliance was isolated to 2018-2019. 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). . . ." 7 CFR 210.14(e) states in part: "Pricing paid lunches. For each school year beginning July 1, 2011, school food authorities shall establish prices for paid lunches in accordance with this paragraph. (1) Calculation procedures. Each school food authority shall: (i) Determine the average price of paid lunches. The average shall be determined based on the total number of paid lunches claimed for the month of October in the previous school year, at each different price charged by the school food authority. (ii) Calculate the difference between the per meal Federal reimbursement for paid and free lunches received by the school food authority in the previous school year (i.e., the reimbursement difference); (iii) Compare the average price of a paid lunch under paragraph (e)(1)(i) of this section to the difference between reimbursement rates under paragraph (e)(1)(ii) of this section. (2) Average paid lunch price is equal to/greater than the reimbursement difference. When the average paid lunch price from the prior school year is equal to or greater than the difference in reimbursement rates as determined in paragraph (e)(1)(iii) of this section, the school food authority shall establish an average paid lunch price for the current school year that is not less than the difference identified in (e)(1)(iii) of this section; except that, the school food authority may use the procedure in paragraph (e)(4)(ii) of this section when establishing prices of paid lunches. (3) Average lunch price is lower than the reimbursement difference. When the average price from the prior school year is lower than the difference in reimbursement rates as determined in paragraph (e)(1)(iii) of this section, the school food authority shall establish an average price for the current school year that is not less than the average price charged in the previous school year as adjusted by a percentage equal to the sum obtained by adding: (i) 2 percent; and (ii) The percentage change in the Consumers Price Index for All Urban Consumers used to increase the Federal reimbursement rate under section 11 of the Act for the most recent school year for which data are available. The percentage to be used is found in the annual notice published in the FEDERAL REGISTER announcing the national average payment rates, from the prior year. (4) Price adjustments. (i) Maximum required price increase. The maximum annual average price increase required under this paragraph shall not exceed ten cents. (ii) Rounding of paid lunch prices. Any school food authority may round the adjusted price of the paid lunches down to the nearest five cents. (iii) Optional price increases. A school food authority may increase the average price by more than ten cents. . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the Special Tests and Provisions - Paid Lunch Equity compliance requirement. Effect The failure to establish an effective internal control system enabled noncompliance to go undetected. Noncompliance with the grant agreement and the compliance requirement could have resulted in the loss of funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance with the grant agreement and the Special Test and Provisions - Paid Lunch Equity compliance requirement. 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 2020-005 Contact Person Responsible for Corrective Action: Judy Brooks, Food Service Coordinator Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Food Service Coordinator will calculate the meal price using the correct information. The payroll and compliance clerk will review the worksheet for accuracy and approve. They will work together to allow proper segregation of duties and internal controls to ensure paid lunch equity is compliant to the requirements. Anticipated Completion Date: 8/1/2021

About Special Tests and Provisions →
2020-006
Cost Allowability
MATERIAL WEAKNESSREPEATQUESTIONED COSTS

FINDING 2020-006 Subject: Title I Grants to Local Educational Agencies - Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies CFDA Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A150014, S010A180014, S010A190014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit. The prior audit finding number was 2018-012. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Allowable Costs/Cost Principles compliance requirement. Internal controls were not in place to ensure salary and benefits charged to the program were supported and accurate. Time and effort reports were not in agreement with amounts charged to the program for salaries and benefits in fifteen of the forty instances tested. A projection of the errors identified resulted in likely questioned costs of $56,412. The lack of internal controls and noncompliance were systemic issues 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). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; . . . (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities (for IHE, this per the IHE's definition of IBS); . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Allowable Costs/Cost Principles compliance requirement. Effect The failure to establish an effective internal control system enabled noncompliance to go undetected. Noncompliance with the grant agreement and the compliance requirement could have resulted in loss of funds to the School Corporation. Questioned Costs There were likely questioned costs in the amount of $56,412. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance with the grant agreement and the Allowable Costs/Cost Principles compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2020-006 Subject: Title I Grants to Local Educational Agencies - Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies CFDA Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A150014, S010A180014, S010A190014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit. The prior audit finding number was 2018-012. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Allowable Costs/Cost Principles compliance requirement. Internal controls were not in place to ensure salary and benefits charged to the program were supported and accurate. Time and effort reports were not in agreement with amounts charged to the program for salaries and benefits in fifteen of the forty instances tested. A projection of the errors identified resulted in likely questioned costs of $56,412. The lack of internal controls and noncompliance were systemic issues 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). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; . . . (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities (for IHE, this per the IHE's definition of IBS); . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Allowable Costs/Cost Principles compliance requirement. Effect The failure to establish an effective internal control system enabled noncompliance to go undetected. Noncompliance with the grant agreement and the compliance requirement could have resulted in loss of funds to the School Corporation. Questioned Costs There were likely questioned costs in the amount of $56,412. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance with the grant agreement and the Allowable Costs/Cost Principles compliance requirement. 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 2020-006 Contact Person Responsible for Corrective Action: Darla Mahoney, Title I Specialist Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Proper time and effort logs will be maintained by all employees paid partially from Title I. All time and effort logs will be reviewed by the Title I Specialist. The payroll department will distribute the payroll accounts according to the logs kept by employees. All employees paid 100% by Title I will complete a semiannual certification and approved by the supervisor or the Title I Compliance Specialist to be maintained by the Treasurer. All future payroll adjustments will be reviewed and approved by a second person to ensure accuracy and approval. This documentation will also be maintained. Anticipated Completion Date: 8/1/2021

Prior Finding References

2018-012

About Allowable Costs / Cost Principles →
2020-007
Eligibility
MATERIAL WEAKNESSREPEAT

FINDING 2020-007 Subject: Title I Grants to Local Educational Agencies - Eligibility Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies CFDA Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A150014, S010A180014, S010A190014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2018-010. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Eligibility compliance requirement. Sufficient audit evidence was not presented for audit to verify the information used to determine eligibility for the Title I program was accurate. The Indiana Department of Education (IDOE) used the October 1 Real Time reports for fiscal years 2017-2018 and 2018-2019, as provided by the School Corporation, to determine Title I Eligibility for the 2018-2019 and 2019-2020 grant programs. The October 1 Real Time reports presented for audit to verify the eligibility accuracy differ from the amounts reported to IDOE. The School Corporation could not provide an explanation for the variances. The lack of internal controls and noncompliance were systemic issues 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). . . ." 2 CFR 200.333 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Eligibility compliance requirement. Effect The failure to provide sufficient audit evidence for the determination of eligibility prevented the determination of the School Corporation's compliance with the Eligibility compliance requirement. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the Eligibility compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2020-007 Subject: Title I Grants to Local Educational Agencies - Eligibility Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies CFDA Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A150014, S010A180014, S010A190014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2018-010. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Eligibility compliance requirement. Sufficient audit evidence was not presented for audit to verify the information used to determine eligibility for the Title I program was accurate. The Indiana Department of Education (IDOE) used the October 1 Real Time reports for fiscal years 2017-2018 and 2018-2019, as provided by the School Corporation, to determine Title I Eligibility for the 2018-2019 and 2019-2020 grant programs. The October 1 Real Time reports presented for audit to verify the eligibility accuracy differ from the amounts reported to IDOE. The School Corporation could not provide an explanation for the variances. The lack of internal controls and noncompliance were systemic issues 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). . . ." 2 CFR 200.333 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Eligibility compliance requirement. Effect The failure to provide sufficient audit evidence for the determination of eligibility prevented the determination of the School Corporation's compliance with the Eligibility compliance requirement. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the Eligibility compliance requirement. 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 2020-007 Contact Person Responsible for Corrective Action: Darla Mahoney, Title I Specialist Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Supporting documentation will be kept that is used to determine Eligibility for Title I. The Title I Compliance Specialist will verify the information for accuracy and keep documentation of the review. Anticipated Completion Date: 8/1/2021

Prior Finding References

2018-010

About Eligibility →
2020-008
Special Tests & Provisions
MATERIAL WEAKNESSREPEAT

FINDING 2020-008 Subject: Title I Grants to Local Educational Agencies - Special Tests and Provisions - Report Card - High School Graduation Rate; Special Tests and Provisions - Assessment System Security Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies CFDA Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A150014, S010A180014, S010A190014 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Special Tests and Provisions - Annual Report Card, High School Graduation Rate, Special Tests and Provisions - Assessment System Security Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the immediately prior audit regarding Special Tests and Provisions - Assessment Security System. The prior audit finding number was 2018-013. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate and Special Tests and Provisions - Assessment System Security compliance requirements. Special Tests and Provisions - Annual Report Card, High School Graduation Rate The School Corporation had not established a system of internal controls where all students reported exiting the cohort are reviewed to ensure the proper exit code for leaving was entered and proper supporting documentation for the exit was obtained. Special Tests and Provisions - Assessment System Security The School Corporation had not established a system of internal controls to ensure monitoring of Assessment System Security occurred and was adequate. There were no documented internal controls in place to ensure all individuals that should have received training did receive training. The lack of internal controls was a systemic issue, which occurred 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). . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the Special Tests and Provisions - Annual Report Card, High School Graduation Rate and Special Tests and Provisions - Assessment System Security 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 compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirement and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls, including segregation of duties, related to the grant agreement and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate and Special Tests and Provisions - Assessment System Security compliance requirements. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2020-008 Subject: Title I Grants to Local Educational Agencies - Special Tests and Provisions - Report Card - High School Graduation Rate; Special Tests and Provisions - Assessment System Security Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies CFDA Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A150014, S010A180014, S010A190014 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Special Tests and Provisions - Annual Report Card, High School Graduation Rate, Special Tests and Provisions - Assessment System Security Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the immediately prior audit regarding Special Tests and Provisions - Assessment Security System. The prior audit finding number was 2018-013. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate and Special Tests and Provisions - Assessment System Security compliance requirements. Special Tests and Provisions - Annual Report Card, High School Graduation Rate The School Corporation had not established a system of internal controls where all students reported exiting the cohort are reviewed to ensure the proper exit code for leaving was entered and proper supporting documentation for the exit was obtained. Special Tests and Provisions - Assessment System Security The School Corporation had not established a system of internal controls to ensure monitoring of Assessment System Security occurred and was adequate. There were no documented internal controls in place to ensure all individuals that should have received training did receive training. The lack of internal controls was a systemic issue, which occurred 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). . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the Special Tests and Provisions - Annual Report Card, High School Graduation Rate and Special Tests and Provisions - Assessment System Security 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 compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirement and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls, including segregation of duties, related to the grant agreement and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate and Special Tests and Provisions - Assessment System Security 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 2020-008 Contact Person Responsible for Corrective Action: Darla Mahoney, Title I Specialist Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The high school will create procedures for tracking enrollments, removals, transfers, expulsion, and graduation numbers. The High School principal will review and approve at least twice a year. The Testing Coordinator will create procedures to ensure all assessment security is in place and monitored with proper documentation kept. Anticipated Completion Date: 8/1/2021

Prior Finding References

2018-013

About Special Tests and Provisions →
2020-009
Cost Allowability
MATERIAL WEAKNESSREPEAT

FINDING 2020-009 Subject: Special Education Cluster (IDEA) - Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants CFDA Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 18611-127-PN01, 19611-127-PN01, 45717-127-PN01, 45715-158-PN01, 19619-127-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit. The prior audit finding number was 2018-008. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Allowable Costs/Cost Principles compliance requirement. The School Corporation did not maintain records that adequately documented the work performed related to the Special Education Cluster (IDEA) grants. Records documenting time and effort for employees charging their salaries, wages, and related benefits to the grants were presented for some, but not all employees during the audit. There were seven employees without time record documentation. A review of the time and effort documentation that was completed showed it was not being completed timely. Time and effort documentation completed was not signed and dated until four to six months after the fact, resulting in some documentation not being completed until the subsequent fiscal school year. The lack of internal controls and noncompliance were systemic issues, which occurred 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). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (ii) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; . . . (iv) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities (for IHE, this per the IHE's definition of IBS); . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Allowable Costs/Cost Principles compliance requirement. Effect The failure to establish an effective system of internal controls enabled noncompliance to go undetected. Noncompliance with the grant agreement and the compliance requirements could have resulted in the loss of funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance with the grant agreement and the Allowable Costs/Cost Principles compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2020-009 Subject: Special Education Cluster (IDEA) - Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants CFDA Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 18611-127-PN01, 19611-127-PN01, 45717-127-PN01, 45715-158-PN01, 19619-127-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit. The prior audit finding number was 2018-008. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Allowable Costs/Cost Principles compliance requirement. The School Corporation did not maintain records that adequately documented the work performed related to the Special Education Cluster (IDEA) grants. Records documenting time and effort for employees charging their salaries, wages, and related benefits to the grants were presented for some, but not all employees during the audit. There were seven employees without time record documentation. A review of the time and effort documentation that was completed showed it was not being completed timely. Time and effort documentation completed was not signed and dated until four to six months after the fact, resulting in some documentation not being completed until the subsequent fiscal school year. The lack of internal controls and noncompliance were systemic issues, which occurred 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). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (ii) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; . . . (iv) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities (for IHE, this per the IHE's definition of IBS); . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Allowable Costs/Cost Principles compliance requirement. Effect The failure to establish an effective system of internal controls enabled noncompliance to go undetected. Noncompliance with the grant agreement and the compliance requirements could have resulted in the loss of funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance with the grant agreement and the Allowable Costs/Cost Principles compliance requirement. 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 2020-009 Contact Person Responsible for Corrective Action: Bonnie Hensler, Director of Finance and Human Resources Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Proper time and effort logs will be maintained by all employees paid partially from the Federal Special Education Grants. All time and effort logs will be reviewed by the Director of Special Education. Payroll department will distribute funds each payroll per the time and effort logs. All employees paid 100% by the Federal Special Education Grants will have a semiannual certification completed and signed by their supervisors to be kept on file by the Treasurer. Anticipated Completion Date: 8/1/2021

Prior Finding References

2018-008

About Allowable Costs / Cost Principles →
2020-010
Matching, Level of Effort, Earmarking
MATERIAL WEAKNESSREPEAT

FINDING 2020-010 Subject: Special Education Cluster (IDEA) - Earmarking Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants CFDA Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 18611-127-PN01, 19611-127-PN01, 45717-127-PN01, 45715-158-PN01, 19619-127-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit as it relates to internal controls. The prior audit finding number was 2018-007. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. The School Corporation failed to maintain records and monitor actual time spent providing services to the participating nonpublic schools within their district. The salaries reported as expended for non-public schools were based upon an estimate instead of actual time spent. A minimum amount of program funds that is to be expended at the participating nonpublic schools is identified in the grant budgets prior to the start of each grant. The School Corporation expended $3,815 less, in total, for the four grants that were finalized during the audit period. The lack of internal controls and noncompliance were systemic issues, which occurred 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). . . ." 2 CFR 200.207(a) states in part: "The Federal awarding agency or pass-through entity may impose additional specific award conditions as needed. . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Cause Management had not developed a system of internal controls that would have ensured compliance the grant agreement and the earmarking requirements. Effect The failure to establish an effective system of internal controls enabled noncompliance to go undetected. Noncompliance with the grant agreement and the compliance requirements could have resulted in the loss of funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance with the grant agreement and the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2020-010 Subject: Special Education Cluster (IDEA) - Earmarking Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants CFDA Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 18611-127-PN01, 19611-127-PN01, 45717-127-PN01, 45715-158-PN01, 19619-127-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit as it relates to internal controls. The prior audit finding number was 2018-007. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. The School Corporation failed to maintain records and monitor actual time spent providing services to the participating nonpublic schools within their district. The salaries reported as expended for non-public schools were based upon an estimate instead of actual time spent. A minimum amount of program funds that is to be expended at the participating nonpublic schools is identified in the grant budgets prior to the start of each grant. The School Corporation expended $3,815 less, in total, for the four grants that were finalized during the audit period. The lack of internal controls and noncompliance were systemic issues, which occurred 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). . . ." 2 CFR 200.207(a) states in part: "The Federal awarding agency or pass-through entity may impose additional specific award conditions as needed. . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Cause Management had not developed a system of internal controls that would have ensured compliance the grant agreement and the earmarking requirements. Effect The failure to establish an effective system of internal controls enabled noncompliance to go undetected. Noncompliance with the grant agreement and the compliance requirements could have resulted in the loss of funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance with the grant agreement and the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. 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 2020-010 Contact Person Responsible for Corrective Action: Bonnie Hensler, Director of Finance and Human Resources Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Going forward all non-public expenditures will have account numbers with a project # of 600 to identify that they are non-public expenses. Time and Effort logs will be kept by employees working with nonpublic students. Logs will be submitted to the payroll department, then accounts will be distributed to match time actually spent with the non-public time spent per the time and effort logs. Expenditures reports will be given to the Assistant Director of Student Services to ensure the non-public funds are being spent. Anticipated Completion Date: 8/1/2021

Prior Finding References

2018-007

About Matching, Level of Effort, Earmarking →
2020-011
Period of Performance
MATERIAL WEAKNESSREPEAT

FINDING 2020-011 Subject: Special Education Cluster (IDEA) - Period of Performance Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants CFDA Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 18611-127-PN01, 19611-127-PN01, 45717-127-PN01, 45715-158-PN01, 19619-127-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Period of Performance Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the immediately prior audit. The prior audit finding number was 2018-007. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Period of Performance compliance requirement. Expenditures charged to the grant program recorded as accounting adjustments were not properly reviewed by management. Supporting documentation of the initial expenditure entries should have been reviewed to determine if those expenditures related to accounting adjustments fell within the period of performance for each grant. The lack of internal controls was a systemic issue, which occurred 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). . . ." Cause Management had not developed an effective system of internal controls that would have ensured compliance with the grant agreement and the Period of Performance compliance requirement. Effect The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirement. A lack of segregation of duties within an internal control system could also have allowed noncompliance with the compliance requirement and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of effective internal controls, including segregation of duties, related to the grant agreement and the Period of Performance compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Show full finding ▾
Full finding narrative

FINDING 2020-011 Subject: Special Education Cluster (IDEA) - Period of Performance Federal Agency: Department of Education Federal Programs: Special Education Grants to States, Special Education Preschool Grants CFDA Numbers: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 18611-127-PN01, 19611-127-PN01, 45717-127-PN01, 45715-158-PN01, 19619-127-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Period of Performance Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the immediately prior audit. The prior audit finding number was 2018-007. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Period of Performance compliance requirement. Expenditures charged to the grant program recorded as accounting adjustments were not properly reviewed by management. Supporting documentation of the initial expenditure entries should have been reviewed to determine if those expenditures related to accounting adjustments fell within the period of performance for each grant. The lack of internal controls was a systemic issue, which occurred 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). . . ." Cause Management had not developed an effective system of internal controls that would have ensured compliance with the grant agreement and the Period of Performance compliance requirement. Effect The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirement. A lack of segregation of duties within an internal control system could also have allowed noncompliance with the compliance requirement and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of effective internal controls, including segregation of duties, related to the grant agreement and the Period of Performance compliance requirement. 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 2020-011 Contact Person Responsible for Corrective Action: Bonnie Hensler, Director of Finance and Human Resources Contact Phone Number: 812-274-8001 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Internal controls will be implemented to ensure period of performance is checked on payroll adjustments. Payroll adjustments will be printed with explanation and the Part B Grant Administrator will review and sign off on adjustments. Anticipated Completion Date: 8/1/2021

Prior Finding References

2018-007

About Period of Performance →

FY 2018-06-30

FAC accepted this audit on July 9, 2019 — management decision was due January 9, 2020.

2018-002
Cost Allowability
MATERIAL WEAKNESS

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

About Allowable Costs / Cost Principles →
2018-003
Program Income
MATERIAL WEAKNESSREPEAT

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

Prior Finding References

2016-002

About Program Income →
2018-004
Reporting
MATERIAL WEAKNESSREPEAT

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

Prior Finding References

2016-002

About Reporting →
2018-005
Special Tests & Provisions
MATERIAL WEAKNESS

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

About Special Tests and Provisions →
2018-006
Procurement & Suspension/Debarment
MATERIAL WEAKNESSREPEAT

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

Prior Finding References

2016-003

About Procurement and Suspension and Debarment →
2018-007
Activities Allowed or Unallowed / Cash Management / Matching, Level of Effort, Earmarking / Period of Performance
MATERIAL WEAKNESSREPEAT

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

Prior Finding References

2016-005

About Activities Allowed or Unallowed, Cash Management, Matching, Level of Effort, Earmarking, Period of Performance →
2018-008
Cost Allowability
MATERIAL WEAKNESSREPEAT

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

Prior Finding References

2016-005

About Allowable Costs / Cost Principles →
2018-009
Reporting
MATERIAL WEAKNESSREPEAT

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

Prior Finding References

2016-005

About Reporting →
2018-010
Eligibility
MATERIAL WEAKNESSREPEAT

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

Prior Finding References

2016-006

About Eligibility →
2018-011
Procurement & Suspension/Debarment
MATERIAL WEAKNESSREPEAT

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

Prior Finding References

2016-008

About Procurement and Suspension and Debarment →
2018-012
Cost Allowability
MATERIAL WEAKNESSREPEAT

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

Prior Finding References

2016-007

About Allowable Costs / Cost Principles →
2018-013
Period of Performance / Special Tests & Provisions
MATERIAL WEAKNESSREPEAT

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

Prior Finding References

2016-006

About Period of Performance, Special Tests and Provisions →

FY 2016-06-30

FAC accepted this audit on August 3, 2018 — management decision was due February 3, 2019.

2016-002
Cash Management / Eligibility / Program Income / Reporting / Special Tests & Provisions
MATERIAL WEAKNESS

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

About Cash Management, Eligibility, Program Income, Reporting, Special Tests and Provisions →
2016-003
Procurement & Suspension/Debarment
MATERIAL WEAKNESS

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

About Procurement and Suspension and Debarment →
2016-004
Procurement & Suspension/Debarment
MATERIAL WEAKNESS

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

About Procurement and Suspension and Debarment →
2016-005
Activities Allowed or Unallowed / Cost Allowability / Cash Management / Matching, Level of Effort, Earmarking / Period of Performance / Reporting
MATERIAL WEAKNESS

GSA_MIGRATION

Show full finding ▾
2016-006
Activities Allowed or Unallowed / Cash Management / Eligibility / Period of Performance / Reporting / Special Tests & Provisions
MATERIAL WEAKNESS

GSA_MIGRATION

Show full finding ▾
2016-007
Cost Allowability
MATERIAL WEAKNESS

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

About Allowable Costs / Cost Principles →
2016-008
Procurement & Suspension/Debarment
MATERIAL WEAKNESS

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

About Procurement and Suspension and Debarment →
2016-009
Special Tests & Provisions
MATERIAL WEAKNESS

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

About Special Tests and Provisions →
2016-010
Special Tests & Provisions
MATERIAL WEAKNESS

GSA_MIGRATION

Show full finding ▾
Full finding narrative

GSA_MIGRATION

Corrective Action Plan

GSA_MIGRATION

About Special Tests and Provisions →

Data source: This information comes from the Federal Audit Clearinghouse, the official repository of Single Audit data. All data is public domain. Verify this organization's audit history at fac.gov.

Are you this organization?

Track your findings and corrective action plans across audit cycles.

Start tracking findings →

Do you fund this organization?

Monitor subrecipient audit findings and compliance status.

Start monitoring →

Product

Resources

Legal

Single Audit Intelligence is an independent tool powered by Federal Audit Clearinghouse data. Not affiliated with GSA, OMB, or any federal agency.

© 2026 Single Audit Intelligence. All data is public domain.