Audit 289747

FY End
2022-06-30
Total Expended
$48.77M
Findings
16
Programs
26
Year: 2022 Accepted: 2024-02-09

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
366751 2022-002 Material Weakness - EG
366752 2022-003 Material Weakness - B
366753 2022-004 Material Weakness - L
366754 2022-005 Material Weakness - N
366755 2022-006 Material Weakness - B
366756 2022-007 Material Weakness - L
366757 2022-006 Material Weakness - B
366758 2022-007 Material Weakness - L
943193 2022-002 Material Weakness - EG
943194 2022-003 Material Weakness - B
943195 2022-004 Material Weakness - L
943196 2022-005 Material Weakness - N
943197 2022-006 Material Weakness - B
943198 2022-007 Material Weakness - L
943199 2022-006 Material Weakness - B
943200 2022-007 Material Weakness - L

Programs

ALN Program Spent Major Findings
84.374 Teacher Incentive Fund $6.11M - 0
84.010 Title I Grants to Local Educational Agencies $4.13M Yes 4
10.559 Summer Food Service Program for Children $2.27M - 0
10.553 School Breakfast Program $2.00M - 0
84.027 Special Education_grants to States $1.50M - 0
84.336 Teacher Quality Partnership Grants $1.26M - 0
84.011 Migrant Education_state Grant Program $1.14M - 0
84.184 Safe and Drug-Free Schools and Communities_national Programs $712,692 - 0
93.778 Medical Assistance Program $543,084 - 0
84.367 Improving Teacher Quality State Grants $466,510 - 0
84.425 Education Stabilization Fund $404,291 Yes 0
84.334 Gaining Early Awareness and Readiness for Undergraduate Programs $397,667 - 0
84.048 Career and Technical Education -- Basic Grants to States $336,025 - 0
84.424 Student Support and Academic Enrichment Program $316,382 - 0
10.555 National School Lunch Program $294,289 - 0
84.002 Adult Education - Basic Grants to States $247,225 - 0
84.173 Special Education_preschool Grants $205,310 - 0
10.582 Fresh Fruit and Vegetable Program $166,413 - 0
84.365 English Language Acquisition State Grants $124,736 - 0
84.377 School Improvement Grants $107,067 - 0
16.839 Stop School Violence $67,553 - 0
84.215 Fund for the Improvement of Education $45,750 - 0
21.019 Coronavirus Relief Fund $22,380 - 0
10.558 Child and Adult Care Food Program $6,253 - 0
10.649 Pandemic Ebt Administrative Costs $5,814 - 0
93.575 Child Care and Development Block Grant $1,252 - 0

Contacts

Name Title Type
W6K1EV9X3ZK9 Marlaina Jones Auditee
5743936000 Beth Kelley, Cpa, Cfe Auditor
No contacts on file

Notes to SEFA

Title: Note 3. Federal Loans Accounting Policies: Note 1. Summary of Significant Accounting Policies A. Basis of Presentation The accompanying Schedule of Expenditures of Federal Awards (SEFA) includes the federal grant activity of the School Corporation under programs of the federal government for the year ended June 30, 2022. The information in the SEFA is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the SEFA presents only a select portion of the operations of the School Corporation, it is not intended to and does not present the financial position of the School Corporation. B. Other Significant Accounting Policies Expenditures reported on the SEFA are reported on the cash basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles in OMB Circular A-87, Cost Principles for State, Local, and Indian Tribal Governments, or the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowed or are limited as to reimbursement. When federal reimbursement grants passed through the State of Indiana are received on a reimbursement basis, in accordance with Uniform Guidance, the federal awards are considered expended when the reimbursement is received. For direct awards, in accordance with Uniform Guidance, the award is deemed to be expended when the cash is disbursed. De Minimis Rate Used: N Rate Explanation: Note 2. Indirect Cost Rate The School Corporation has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance South Bend Community School Corporation had no federal loans that they were administering as of June 30, 2022.

Finding Details

FINDING 2022-002 Subject: Title I Grants to Local Educational Agencies - Internal Controls Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A190014 FY2021, S010A200014 FY2021 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility; Matching, Level of Effort, Earmarking Audit Finding: Material Weakness Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, material noncompliance related to the grant agreement and the Eligibility and Matching, Level of Effort, Earmarking compliance requirements. Eligibility Data from the School Corporation's student software system is uploaded to the Indiana Department of Education's (IDOE) Data Exchange System. Enrollment and poverty information for the School Corporation is then abstracted by the IDOE from the Data Exchange System. The School Corporation's Research and Evaluation team compared the lunch status eligibility used to determine student poverty in the student software system to the information in Data Exchange System at regular intervals. However, this process was not documented and, therefore, could not be verified. INDIANA STATE BOARD OF ACCOUNTS 22 Level of Effort Form 9 data is submitted to the IDOE semi-annually. The data reported includes the School Corporation's expenditures recorded during that period. The IDOE calculates Maintenance of Effort based on the expenditure information submitted on the Form 9 for that fiscal year. To verify amounts used by the IDOE in their computation were derived from the books and records of the School Corporation, costs were reviewed to ensure they are recorded properly as to account and object code and reported correctly on the Form 9. SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) For payroll amounts, summary level payroll reports were provided to a knowledgeable employee for review; however, the reports lacked sufficient detail to effectively review and verify the proper employees were paid from the correct fund, account, and object codes. Earmarking A portion of the School Corporation's Title I allocation is required to be set aside for parental involvement and homeless reservation. The required amount to be set aside is indicated in the Title I grant application. The School Corporation is responsible for monitoring each required set aside throughout the life of the grant to ensure the obligation is met. Monitoring of each set aside was completed on the reimbursement requests; however, reimbursement requests, although reviewed by a knowledgeable employee, were supported by summary level payroll data. The summary level payroll did not provide sufficient detail to effectively review and verify the proper employees were paid from or should have been paid from earmarked Title I funds. 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 A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. INDIANA STATE BOARD OF ACCOUNTS 23 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place.
FINDING 2022-003 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 Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A190014 FY2021, S010A200014 FY2021 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Condition and Context Costs charged to grant funds must be adequately documented. To adequately document payroll expenses charged to the grant fund, contracts or other documentation supporting the employees' approved rates of pay are necessary. The School Corporation utilized a financial software system that has two different sides, an employee portal side and an administrator side. Employee contracts are approved by the employee, the Superintendent of Schools, and the President of the School Board within the system on the employee portal side. Once approved, the data in the employee portal side is fed into a process in the administrator side. The School Corporation could not provide contracts for 10 of 15 employees tested, as the contracts were not properly archived in the financial software used to electronically approve and archive employment contracts. As such, we could not verify the employees were paid their contracted rate for hours spent working on grant-related activities. This resulted in known questioned costs of $203,488. 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 24 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 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. . . ." 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; (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. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. INDIANA STATE BOARD OF ACCOUNTS 25 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 employment contracts could be presented for audit nor could documentation be provided to support time charged to the grant. 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 known questioned costs of $203,488 as identified in Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure contracts and certifications, as appropriate, are retained to support the amounts paid from Title I program funds. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response The alternative documentation provided was a snapshot from the administrator side of the financial software system; however, the original source document, which was the contract that was approved by the employee, the Superintendent of Schools, and the President of the School Board, was not provided to substantiate the amounts in the administrator side of the financial software system. We reaffirm our finding and will review the status of the finding during our next audit.
FINDING 2022-004 Subject: Title I Grants to Local Educational Agencies - Reporting 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 FY2021; S010A200014 FY2021 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context Form 9 Data The State uses the Form 9 data for their required submission of the average state per pupil expenditure data which is submitted to the National Center for Education Statistics. INDIANA STATE BOARD OF ACCOUNTS 26 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The Form 9 reports are comprised of the School Corporation's transactions recorded during the audit period. Payroll reports, which included summary level payroll data, were provided to a knowledgeable employee for review; however, the reports did not include sufficient detail to effectively review and verify the proper employees were paid from the correct fund, account, and object codes. Reimbursement Requests Requests for reimbursement are utilized by the School Corporation to request reimbursement for allowable expenses paid from Title I funds. Requests for reimbursement should be based on and supported by transactions recorded in the Title I funds of the School Corporation. Summary level reports were run from the School Corporation's financial system by the Director of Federal Grants for the period in which reimbursement was requested. The reports were then attached to the reimbursement request. The Title I Director then approved the reimbursement request prior to submission. Of the three reimbursement requests selected for testing, two could not be verified to the summary level detail attached to the reimbursement request nor to a detailed list of transactions. As the amount requested for reimbursement could not be traced to detailed records nor reports which accumulated or summarized the data, the accuracy and completeness of the reimbursement requests could not be verified. 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.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 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. . . ." 27 INDIANA STATE BOARD OF ACCOUNTS SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. 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, the amounts requested for reimbursement could not be reconciled to the School Corporation's underlying accounting records. 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 management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure detailed supporting documentation is used and retained when reviewing Form 9 data and for all requests for reimbursements submitted on behalf of the Title I program funds. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-005 Subject: Title I Grants to Local Educational Agencies - Special Tests and Provisions - Annual 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 FY2021, S010A200014 FY2021 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Annual Report Card/High School Graduation Rate Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation reports graduation rate data for all public high schools within the School Corporation using the four-year adjusted cohort rate. To remove a student from the cohort, the School Corporation must confirm the reason for removal in writing. Additionally, required documentation for each removal type must be retained by the School Corporation. The Indiana Department of Education has outlined the acceptable documentation required when a student exists in a cohort. The School Corporation has a total of five high schools plus the juvenile detention center for which graduation rate data is submitted. A withdrawal form is utilized by each high school and the juvenile detention center to document the reason for a withdrawal. The withdrawal form and supporting documentation is then approved by an official at that student's high school prior to the student being removed from the cohort. Of the 15 students selected for testing, the following errors were noted:  One student's mobility was not properly coded.  One student's documentation did not clearly state the city and country the student was moving to.  One student's documentation was lacking a court order or other documentation from the juvenile detention center to evidence that the student was detained more than 20 days.  One student's documentation did not include the required transcript request or enrollment verification.  Two students did not have any documentation to support the student's withdrawal. 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). . . ." 29 INDIANA STATE BOARD OF ACCOUNTS SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 20 USC 7801(23)(B) states: "To remove a student from a cohort, a school or local educational agency shall require documentation, or obtain documentation from the State educational agency, to confirm that the student has transferred out, emigrated to another country, or transferred to a prison or juvenile facility, or is deceased." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. 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, adequate documentation to support the reason for a student's removal from the high school graduation cohort for mobility reasons was not retained. 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 management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure appropriate documentation is retained to support the removal of students from the graduation cohort. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-006 Subject: COVID-19 - Education Stabilization Fund - Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters 30 INDIANA STATE BOARD OF ACCOUNTS SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The Education Stabilization Fund established by the Coronavirus Aid, Relief, and Economic Security (CARES) Act, and further funded by the Coronavirus Response and Relief Supplemental Appropriations Act (CRSSA) and the American Rescue Plan (ARP) Act, was for the purpose of preventing, preparing for, or responding to the novel coronavirus. Costs charged to grant funds must be adequately documented. To adequately document payroll expenses charged to the grant fund, contracts or other documentation supporting the employees' approved rates of pay are necessary. The School Corporation utilized a financial software system that has two different sides, an employee portal side and an administrator side. Employee contracts are approved by the employee, the Superintendent of Schools, and the President of the School Board within the system on the employee portal side. Once approved, the data in the employee portal side is fed into a process in the administrator side. The School Corporation could not provide contracts for 3 of 13 employees tested, as the contracts were not properly archived in the financial software used to electronically approve and archive employment contracts. As such, we could not verify the employees were paid their contracted rate for hours spent working on grant-related activities. This resulted in known questioned costs of $26,207. 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.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 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. . . ." 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. INDIANA STATE BOARD OF ACCOUNTS 31 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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; (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. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal control, and procedures should consist of actions that would implement these policies. 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 employment contracts could be presented for audit nor could documentation be provided to support time charged to the grant. 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 known questioned costs of $26,207 as identified in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure contracts and certifications, as appropriate, are retained to support the amounts paid from Education Stabilization Fund program funds. INDIANA STATE BOARD OF ACCOUNTS 32 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response The alternative documentation provided was a snapshot from the administrator side of the financial software system; however, the original source document, which was the contract that was approved by the employee, the Superintendent of Schools, and the President of the School Board, was not provided to substantiate the amounts in the administrator side of the financial software system. We reaffirm our finding and will review the status of the finding during our next audit.
FINDING 2022-007 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. The School Corporation submitted three reports during the audit period; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent or detect and correct errors. Additionally, two of the three reports tested, ESSER I Year 2 and ESSER II Year 1, were not supported by the School Corporation's records. The financial information provided was based on estimates and actual expenditures, and did not agree with the data submitted in the reports, nor to the School Corporation's records; therefore, the reports were determined to be inaccurate and incomplete. The key line item "Overall Expenditures" was tested on both reports. The ESSER I Year 2 report overall expenditures key line item was determined to be understated by $140,160. The ESSER II Year 1 overall expenditures key line item was determined to be overstated by $2,745,818. The lack of internal controls and noncompliance were systemic issues throughout the audit period. 33 INDIANA STATE BOARD OF ACCOUNTS SOUTH BEND COMMUNITY SCHOOL CORPORATION 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). . . ." 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 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. . . ." 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 federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial 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 A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. INDIANA STATE BOARD OF ACCOUNTS 34 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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, the amounts requested for reimbursement could not be reconciled to the School Corporation's underlying accounting records. 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 management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure supporting documentation is used and retained for all required reports submitted on behalf of the Education Stabilization Fund program funds. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-006 Subject: COVID-19 - Education Stabilization Fund - Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters 30 INDIANA STATE BOARD OF ACCOUNTS SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The Education Stabilization Fund established by the Coronavirus Aid, Relief, and Economic Security (CARES) Act, and further funded by the Coronavirus Response and Relief Supplemental Appropriations Act (CRSSA) and the American Rescue Plan (ARP) Act, was for the purpose of preventing, preparing for, or responding to the novel coronavirus. Costs charged to grant funds must be adequately documented. To adequately document payroll expenses charged to the grant fund, contracts or other documentation supporting the employees' approved rates of pay are necessary. The School Corporation utilized a financial software system that has two different sides, an employee portal side and an administrator side. Employee contracts are approved by the employee, the Superintendent of Schools, and the President of the School Board within the system on the employee portal side. Once approved, the data in the employee portal side is fed into a process in the administrator side. The School Corporation could not provide contracts for 3 of 13 employees tested, as the contracts were not properly archived in the financial software used to electronically approve and archive employment contracts. As such, we could not verify the employees were paid their contracted rate for hours spent working on grant-related activities. This resulted in known questioned costs of $26,207. 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.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 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. . . ." 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. INDIANA STATE BOARD OF ACCOUNTS 31 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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; (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. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal control, and procedures should consist of actions that would implement these policies. 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 employment contracts could be presented for audit nor could documentation be provided to support time charged to the grant. 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 known questioned costs of $26,207 as identified in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure contracts and certifications, as appropriate, are retained to support the amounts paid from Education Stabilization Fund program funds. INDIANA STATE BOARD OF ACCOUNTS 32 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response The alternative documentation provided was a snapshot from the administrator side of the financial software system; however, the original source document, which was the contract that was approved by the employee, the Superintendent of Schools, and the President of the School Board, was not provided to substantiate the amounts in the administrator side of the financial software system. We reaffirm our finding and will review the status of the finding during our next audit.
FINDING 2022-007 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. The School Corporation submitted three reports during the audit period; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent or detect and correct errors. Additionally, two of the three reports tested, ESSER I Year 2 and ESSER II Year 1, were not supported by the School Corporation's records. The financial information provided was based on estimates and actual expenditures, and did not agree with the data submitted in the reports, nor to the School Corporation's records; therefore, the reports were determined to be inaccurate and incomplete. The key line item "Overall Expenditures" was tested on both reports. The ESSER I Year 2 report overall expenditures key line item was determined to be understated by $140,160. The ESSER II Year 1 overall expenditures key line item was determined to be overstated by $2,745,818. The lack of internal controls and noncompliance were systemic issues throughout the audit period. 33 INDIANA STATE BOARD OF ACCOUNTS SOUTH BEND COMMUNITY SCHOOL CORPORATION 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). . . ." 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 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. . . ." 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 federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial 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 A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. INDIANA STATE BOARD OF ACCOUNTS 34 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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, the amounts requested for reimbursement could not be reconciled to the School Corporation's underlying accounting records. 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 management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure supporting documentation is used and retained for all required reports submitted on behalf of the Education Stabilization Fund program funds. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-002 Subject: Title I Grants to Local Educational Agencies - Internal Controls Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A190014 FY2021, S010A200014 FY2021 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility; Matching, Level of Effort, Earmarking Audit Finding: Material Weakness Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, material noncompliance related to the grant agreement and the Eligibility and Matching, Level of Effort, Earmarking compliance requirements. Eligibility Data from the School Corporation's student software system is uploaded to the Indiana Department of Education's (IDOE) Data Exchange System. Enrollment and poverty information for the School Corporation is then abstracted by the IDOE from the Data Exchange System. The School Corporation's Research and Evaluation team compared the lunch status eligibility used to determine student poverty in the student software system to the information in Data Exchange System at regular intervals. However, this process was not documented and, therefore, could not be verified. INDIANA STATE BOARD OF ACCOUNTS 22 Level of Effort Form 9 data is submitted to the IDOE semi-annually. The data reported includes the School Corporation's expenditures recorded during that period. The IDOE calculates Maintenance of Effort based on the expenditure information submitted on the Form 9 for that fiscal year. To verify amounts used by the IDOE in their computation were derived from the books and records of the School Corporation, costs were reviewed to ensure they are recorded properly as to account and object code and reported correctly on the Form 9. SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) For payroll amounts, summary level payroll reports were provided to a knowledgeable employee for review; however, the reports lacked sufficient detail to effectively review and verify the proper employees were paid from the correct fund, account, and object codes. Earmarking A portion of the School Corporation's Title I allocation is required to be set aside for parental involvement and homeless reservation. The required amount to be set aside is indicated in the Title I grant application. The School Corporation is responsible for monitoring each required set aside throughout the life of the grant to ensure the obligation is met. Monitoring of each set aside was completed on the reimbursement requests; however, reimbursement requests, although reviewed by a knowledgeable employee, were supported by summary level payroll data. The summary level payroll did not provide sufficient detail to effectively review and verify the proper employees were paid from or should have been paid from earmarked Title I funds. 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 A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. INDIANA STATE BOARD OF ACCOUNTS 23 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place.
FINDING 2022-003 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 Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A190014 FY2021, S010A200014 FY2021 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Condition and Context Costs charged to grant funds must be adequately documented. To adequately document payroll expenses charged to the grant fund, contracts or other documentation supporting the employees' approved rates of pay are necessary. The School Corporation utilized a financial software system that has two different sides, an employee portal side and an administrator side. Employee contracts are approved by the employee, the Superintendent of Schools, and the President of the School Board within the system on the employee portal side. Once approved, the data in the employee portal side is fed into a process in the administrator side. The School Corporation could not provide contracts for 10 of 15 employees tested, as the contracts were not properly archived in the financial software used to electronically approve and archive employment contracts. As such, we could not verify the employees were paid their contracted rate for hours spent working on grant-related activities. This resulted in known questioned costs of $203,488. 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 24 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 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. . . ." 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; (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. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. INDIANA STATE BOARD OF ACCOUNTS 25 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 employment contracts could be presented for audit nor could documentation be provided to support time charged to the grant. 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 known questioned costs of $203,488 as identified in Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure contracts and certifications, as appropriate, are retained to support the amounts paid from Title I program funds. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response The alternative documentation provided was a snapshot from the administrator side of the financial software system; however, the original source document, which was the contract that was approved by the employee, the Superintendent of Schools, and the President of the School Board, was not provided to substantiate the amounts in the administrator side of the financial software system. We reaffirm our finding and will review the status of the finding during our next audit.
FINDING 2022-004 Subject: Title I Grants to Local Educational Agencies - Reporting 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 FY2021; S010A200014 FY2021 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context Form 9 Data The State uses the Form 9 data for their required submission of the average state per pupil expenditure data which is submitted to the National Center for Education Statistics. INDIANA STATE BOARD OF ACCOUNTS 26 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The Form 9 reports are comprised of the School Corporation's transactions recorded during the audit period. Payroll reports, which included summary level payroll data, were provided to a knowledgeable employee for review; however, the reports did not include sufficient detail to effectively review and verify the proper employees were paid from the correct fund, account, and object codes. Reimbursement Requests Requests for reimbursement are utilized by the School Corporation to request reimbursement for allowable expenses paid from Title I funds. Requests for reimbursement should be based on and supported by transactions recorded in the Title I funds of the School Corporation. Summary level reports were run from the School Corporation's financial system by the Director of Federal Grants for the period in which reimbursement was requested. The reports were then attached to the reimbursement request. The Title I Director then approved the reimbursement request prior to submission. Of the three reimbursement requests selected for testing, two could not be verified to the summary level detail attached to the reimbursement request nor to a detailed list of transactions. As the amount requested for reimbursement could not be traced to detailed records nor reports which accumulated or summarized the data, the accuracy and completeness of the reimbursement requests could not be verified. 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.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 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. . . ." 27 INDIANA STATE BOARD OF ACCOUNTS SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. 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, the amounts requested for reimbursement could not be reconciled to the School Corporation's underlying accounting records. 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 management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure detailed supporting documentation is used and retained when reviewing Form 9 data and for all requests for reimbursements submitted on behalf of the Title I program funds. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-005 Subject: Title I Grants to Local Educational Agencies - Special Tests and Provisions - Annual 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 FY2021, S010A200014 FY2021 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Annual Report Card/High School Graduation Rate Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation reports graduation rate data for all public high schools within the School Corporation using the four-year adjusted cohort rate. To remove a student from the cohort, the School Corporation must confirm the reason for removal in writing. Additionally, required documentation for each removal type must be retained by the School Corporation. The Indiana Department of Education has outlined the acceptable documentation required when a student exists in a cohort. The School Corporation has a total of five high schools plus the juvenile detention center for which graduation rate data is submitted. A withdrawal form is utilized by each high school and the juvenile detention center to document the reason for a withdrawal. The withdrawal form and supporting documentation is then approved by an official at that student's high school prior to the student being removed from the cohort. Of the 15 students selected for testing, the following errors were noted:  One student's mobility was not properly coded.  One student's documentation did not clearly state the city and country the student was moving to.  One student's documentation was lacking a court order or other documentation from the juvenile detention center to evidence that the student was detained more than 20 days.  One student's documentation did not include the required transcript request or enrollment verification.  Two students did not have any documentation to support the student's withdrawal. 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). . . ." 29 INDIANA STATE BOARD OF ACCOUNTS SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 20 USC 7801(23)(B) states: "To remove a student from a cohort, a school or local educational agency shall require documentation, or obtain documentation from the State educational agency, to confirm that the student has transferred out, emigrated to another country, or transferred to a prison or juvenile facility, or is deceased." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. 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, adequate documentation to support the reason for a student's removal from the high school graduation cohort for mobility reasons was not retained. 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 management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure appropriate documentation is retained to support the removal of students from the graduation cohort. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-006 Subject: COVID-19 - Education Stabilization Fund - Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters 30 INDIANA STATE BOARD OF ACCOUNTS SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The Education Stabilization Fund established by the Coronavirus Aid, Relief, and Economic Security (CARES) Act, and further funded by the Coronavirus Response and Relief Supplemental Appropriations Act (CRSSA) and the American Rescue Plan (ARP) Act, was for the purpose of preventing, preparing for, or responding to the novel coronavirus. Costs charged to grant funds must be adequately documented. To adequately document payroll expenses charged to the grant fund, contracts or other documentation supporting the employees' approved rates of pay are necessary. The School Corporation utilized a financial software system that has two different sides, an employee portal side and an administrator side. Employee contracts are approved by the employee, the Superintendent of Schools, and the President of the School Board within the system on the employee portal side. Once approved, the data in the employee portal side is fed into a process in the administrator side. The School Corporation could not provide contracts for 3 of 13 employees tested, as the contracts were not properly archived in the financial software used to electronically approve and archive employment contracts. As such, we could not verify the employees were paid their contracted rate for hours spent working on grant-related activities. This resulted in known questioned costs of $26,207. 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.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 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. . . ." 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. INDIANA STATE BOARD OF ACCOUNTS 31 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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; (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. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal control, and procedures should consist of actions that would implement these policies. 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 employment contracts could be presented for audit nor could documentation be provided to support time charged to the grant. 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 known questioned costs of $26,207 as identified in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure contracts and certifications, as appropriate, are retained to support the amounts paid from Education Stabilization Fund program funds. INDIANA STATE BOARD OF ACCOUNTS 32 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response The alternative documentation provided was a snapshot from the administrator side of the financial software system; however, the original source document, which was the contract that was approved by the employee, the Superintendent of Schools, and the President of the School Board, was not provided to substantiate the amounts in the administrator side of the financial software system. We reaffirm our finding and will review the status of the finding during our next audit.
FINDING 2022-007 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. The School Corporation submitted three reports during the audit period; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent or detect and correct errors. Additionally, two of the three reports tested, ESSER I Year 2 and ESSER II Year 1, were not supported by the School Corporation's records. The financial information provided was based on estimates and actual expenditures, and did not agree with the data submitted in the reports, nor to the School Corporation's records; therefore, the reports were determined to be inaccurate and incomplete. The key line item "Overall Expenditures" was tested on both reports. The ESSER I Year 2 report overall expenditures key line item was determined to be understated by $140,160. The ESSER II Year 1 overall expenditures key line item was determined to be overstated by $2,745,818. The lack of internal controls and noncompliance were systemic issues throughout the audit period. 33 INDIANA STATE BOARD OF ACCOUNTS SOUTH BEND COMMUNITY SCHOOL CORPORATION 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). . . ." 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 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. . . ." 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 federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial 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 A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. INDIANA STATE BOARD OF ACCOUNTS 34 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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, the amounts requested for reimbursement could not be reconciled to the School Corporation's underlying accounting records. 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 management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure supporting documentation is used and retained for all required reports submitted on behalf of the Education Stabilization Fund program funds. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-006 Subject: COVID-19 - Education Stabilization Fund - Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters 30 INDIANA STATE BOARD OF ACCOUNTS SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The Education Stabilization Fund established by the Coronavirus Aid, Relief, and Economic Security (CARES) Act, and further funded by the Coronavirus Response and Relief Supplemental Appropriations Act (CRSSA) and the American Rescue Plan (ARP) Act, was for the purpose of preventing, preparing for, or responding to the novel coronavirus. Costs charged to grant funds must be adequately documented. To adequately document payroll expenses charged to the grant fund, contracts or other documentation supporting the employees' approved rates of pay are necessary. The School Corporation utilized a financial software system that has two different sides, an employee portal side and an administrator side. Employee contracts are approved by the employee, the Superintendent of Schools, and the President of the School Board within the system on the employee portal side. Once approved, the data in the employee portal side is fed into a process in the administrator side. The School Corporation could not provide contracts for 3 of 13 employees tested, as the contracts were not properly archived in the financial software used to electronically approve and archive employment contracts. As such, we could not verify the employees were paid their contracted rate for hours spent working on grant-related activities. This resulted in known questioned costs of $26,207. 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.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 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. . . ." 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. INDIANA STATE BOARD OF ACCOUNTS 31 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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; (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. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal control, and procedures should consist of actions that would implement these policies. 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 employment contracts could be presented for audit nor could documentation be provided to support time charged to the grant. 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 known questioned costs of $26,207 as identified in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure contracts and certifications, as appropriate, are retained to support the amounts paid from Education Stabilization Fund program funds. INDIANA STATE BOARD OF ACCOUNTS 32 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response The alternative documentation provided was a snapshot from the administrator side of the financial software system; however, the original source document, which was the contract that was approved by the employee, the Superintendent of Schools, and the President of the School Board, was not provided to substantiate the amounts in the administrator side of the financial software system. We reaffirm our finding and will review the status of the finding during our next audit.
FINDING 2022-007 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. The School Corporation submitted three reports during the audit period; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent or detect and correct errors. Additionally, two of the three reports tested, ESSER I Year 2 and ESSER II Year 1, were not supported by the School Corporation's records. The financial information provided was based on estimates and actual expenditures, and did not agree with the data submitted in the reports, nor to the School Corporation's records; therefore, the reports were determined to be inaccurate and incomplete. The key line item "Overall Expenditures" was tested on both reports. The ESSER I Year 2 report overall expenditures key line item was determined to be understated by $140,160. The ESSER II Year 1 overall expenditures key line item was determined to be overstated by $2,745,818. The lack of internal controls and noncompliance were systemic issues throughout the audit period. 33 INDIANA STATE BOARD OF ACCOUNTS SOUTH BEND COMMUNITY SCHOOL CORPORATION 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). . . ." 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 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. . . ." 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 federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial 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 A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. INDIANA STATE BOARD OF ACCOUNTS 34 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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, the amounts requested for reimbursement could not be reconciled to the School Corporation's underlying accounting records. 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 management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure supporting documentation is used and retained for all required reports submitted on behalf of the Education Stabilization Fund program funds. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.