2022-005 (2019-013) REPORTING ? Repeated and Modified Federal Agency: U.S. Department of Homeland Security/FEMA Federal Program Title & Assistance Listing Number: Disaster Grants ? Public Assistance (Presidentially Declared Disasters) - 97.036 Emergency Management Performance Grants ? 97.042 Fire Management Assistance Grants ? 97.046 Pre-Disaster Mitigation ? 97.047 Homeland Security Grant Program ? 97.067 Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance Material Noncompliance (Modified Opinion) Questioned Costs: Unknown Condition: We noted the Department was not in compliance with requirements related to the reporting of grants. ? Assistance Listing 97.036 o The Department did not complete the recipient share section of the federal financial reports for 2 out of 10 reports tested. ? Assistance Listing 97.042 o The Department did not complete the recipient share section of the federal financial reports for 4 out of 9 reports tested. o 2 out of 9 federal financial reports tested were not submitted timely. ? Assistance Listing 97.046 o 2 out of 6 federal financial reports tested were not provided to us. ? Assistance Listing 97.047 o The Department did not complete the recipient share section of the federal financial reports for 3 out of 6 reports tested. ? Assistance Listing 97.067 o All but one Performance Progress Report was not submitted for FY22. Management?s Progress for Repeated Findings: Management failed to implement adequate controls to resolve the finding from the prior years. Criteria: According to ?200.302 Financial management of 2 CFR Part 200, the State?s, and the other non-Federal entity?s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions. Further, the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements. According to ?200.303 Internal controls of 2 CFR Part 200, the non-Federal entity must 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. Effect: The auditor noted instances of noncompliance. Noncompliance results in delayed reimbursement of eligible federal expenditures. Potential loss of federal funding. Cause: The Department lacks established internal controls and procedures over financial grant management to ensure submitted reports are complete, agree to supporting spreadsheets, submitted timely, and properly maintained in the files of the Department.
2022-005 (2019-013) REPORTING ? Repeated and Modified Federal Agency: U.S. Department of Homeland Security/FEMA Federal Program Title & Assistance Listing Number: Disaster Grants ? Public Assistance (Presidentially Declared Disasters) - 97.036 Emergency Management Performance Grants ? 97.042 Fire Management Assistance Grants ? 97.046 Pre-Disaster Mitigation ? 97.047 Homeland Security Grant Program ? 97.067 Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance Material Noncompliance (Modified Opinion) Questioned Costs: Unknown Condition: We noted the Department was not in compliance with requirements related to the reporting of grants. ? Assistance Listing 97.036 o The Department did not complete the recipient share section of the federal financial reports for 2 out of 10 reports tested. ? Assistance Listing 97.042 o The Department did not complete the recipient share section of the federal financial reports for 4 out of 9 reports tested. o 2 out of 9 federal financial reports tested were not submitted timely. ? Assistance Listing 97.046 o 2 out of 6 federal financial reports tested were not provided to us. ? Assistance Listing 97.047 o The Department did not complete the recipient share section of the federal financial reports for 3 out of 6 reports tested. ? Assistance Listing 97.067 o All but one Performance Progress Report was not submitted for FY22. Management?s Progress for Repeated Findings: Management failed to implement adequate controls to resolve the finding from the prior years. Criteria: According to ?200.302 Financial management of 2 CFR Part 200, the State?s, and the other non-Federal entity?s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions. Further, the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements. According to ?200.303 Internal controls of 2 CFR Part 200, the non-Federal entity must 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. Effect: The auditor noted instances of noncompliance. Noncompliance results in delayed reimbursement of eligible federal expenditures. Potential loss of federal funding. Cause: The Department lacks established internal controls and procedures over financial grant management to ensure submitted reports are complete, agree to supporting spreadsheets, submitted timely, and properly maintained in the files of the Department.
2022-005 (2019-013) REPORTING ? Repeated and Modified Federal Agency: U.S. Department of Homeland Security/FEMA Federal Program Title & Assistance Listing Number: Disaster Grants ? Public Assistance (Presidentially Declared Disasters) - 97.036 Emergency Management Performance Grants ? 97.042 Fire Management Assistance Grants ? 97.046 Pre-Disaster Mitigation ? 97.047 Homeland Security Grant Program ? 97.067 Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance Material Noncompliance (Modified Opinion) Questioned Costs: Unknown Condition: We noted the Department was not in compliance with requirements related to the reporting of grants. ? Assistance Listing 97.036 o The Department did not complete the recipient share section of the federal financial reports for 2 out of 10 reports tested. ? Assistance Listing 97.042 o The Department did not complete the recipient share section of the federal financial reports for 4 out of 9 reports tested. o 2 out of 9 federal financial reports tested were not submitted timely. ? Assistance Listing 97.046 o 2 out of 6 federal financial reports tested were not provided to us. ? Assistance Listing 97.047 o The Department did not complete the recipient share section of the federal financial reports for 3 out of 6 reports tested. ? Assistance Listing 97.067 o All but one Performance Progress Report was not submitted for FY22. Management?s Progress for Repeated Findings: Management failed to implement adequate controls to resolve the finding from the prior years. Criteria: According to ?200.302 Financial management of 2 CFR Part 200, the State?s, and the other non-Federal entity?s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions. Further, the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements. According to ?200.303 Internal controls of 2 CFR Part 200, the non-Federal entity must 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. Effect: The auditor noted instances of noncompliance. Noncompliance results in delayed reimbursement of eligible federal expenditures. Potential loss of federal funding. Cause: The Department lacks established internal controls and procedures over financial grant management to ensure submitted reports are complete, agree to supporting spreadsheets, submitted timely, and properly maintained in the files of the Department.
2022-005 (2019-013) REPORTING ? Repeated and Modified Federal Agency: U.S. Department of Homeland Security/FEMA Federal Program Title & Assistance Listing Number: Disaster Grants ? Public Assistance (Presidentially Declared Disasters) - 97.036 Emergency Management Performance Grants ? 97.042 Fire Management Assistance Grants ? 97.046 Pre-Disaster Mitigation ? 97.047 Homeland Security Grant Program ? 97.067 Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance Material Noncompliance (Modified Opinion) Questioned Costs: Unknown Condition: We noted the Department was not in compliance with requirements related to the reporting of grants. ? Assistance Listing 97.036 o The Department did not complete the recipient share section of the federal financial reports for 2 out of 10 reports tested. ? Assistance Listing 97.042 o The Department did not complete the recipient share section of the federal financial reports for 4 out of 9 reports tested. o 2 out of 9 federal financial reports tested were not submitted timely. ? Assistance Listing 97.046 o 2 out of 6 federal financial reports tested were not provided to us. ? Assistance Listing 97.047 o The Department did not complete the recipient share section of the federal financial reports for 3 out of 6 reports tested. ? Assistance Listing 97.067 o All but one Performance Progress Report was not submitted for FY22. Management?s Progress for Repeated Findings: Management failed to implement adequate controls to resolve the finding from the prior years. Criteria: According to ?200.302 Financial management of 2 CFR Part 200, the State?s, and the other non-Federal entity?s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions. Further, the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements. According to ?200.303 Internal controls of 2 CFR Part 200, the non-Federal entity must 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. Effect: The auditor noted instances of noncompliance. Noncompliance results in delayed reimbursement of eligible federal expenditures. Potential loss of federal funding. Cause: The Department lacks established internal controls and procedures over financial grant management to ensure submitted reports are complete, agree to supporting spreadsheets, submitted timely, and properly maintained in the files of the Department.
2022-005 (2019-013) REPORTING ? Repeated and Modified Federal Agency: U.S. Department of Homeland Security/FEMA Federal Program Title & Assistance Listing Number: Disaster Grants ? Public Assistance (Presidentially Declared Disasters) - 97.036 Emergency Management Performance Grants ? 97.042 Fire Management Assistance Grants ? 97.046 Pre-Disaster Mitigation ? 97.047 Homeland Security Grant Program ? 97.067 Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance Material Noncompliance (Modified Opinion) Questioned Costs: Unknown Condition: We noted the Department was not in compliance with requirements related to the reporting of grants. ? Assistance Listing 97.036 o The Department did not complete the recipient share section of the federal financial reports for 2 out of 10 reports tested. ? Assistance Listing 97.042 o The Department did not complete the recipient share section of the federal financial reports for 4 out of 9 reports tested. o 2 out of 9 federal financial reports tested were not submitted timely. ? Assistance Listing 97.046 o 2 out of 6 federal financial reports tested were not provided to us. ? Assistance Listing 97.047 o The Department did not complete the recipient share section of the federal financial reports for 3 out of 6 reports tested. ? Assistance Listing 97.067 o All but one Performance Progress Report was not submitted for FY22. Management?s Progress for Repeated Findings: Management failed to implement adequate controls to resolve the finding from the prior years. Criteria: According to ?200.302 Financial management of 2 CFR Part 200, the State?s, and the other non-Federal entity?s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions. Further, the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements. According to ?200.303 Internal controls of 2 CFR Part 200, the non-Federal entity must 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. Effect: The auditor noted instances of noncompliance. Noncompliance results in delayed reimbursement of eligible federal expenditures. Potential loss of federal funding. Cause: The Department lacks established internal controls and procedures over financial grant management to ensure submitted reports are complete, agree to supporting spreadsheets, submitted timely, and properly maintained in the files of the Department.
2022-005 (2019-013) REPORTING ? Repeated and Modified Federal Agency: U.S. Department of Homeland Security/FEMA Federal Program Title & Assistance Listing Number: Disaster Grants ? Public Assistance (Presidentially Declared Disasters) - 97.036 Emergency Management Performance Grants ? 97.042 Fire Management Assistance Grants ? 97.046 Pre-Disaster Mitigation ? 97.047 Homeland Security Grant Program ? 97.067 Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance Material Noncompliance (Modified Opinion) Questioned Costs: Unknown Condition: We noted the Department was not in compliance with requirements related to the reporting of grants. ? Assistance Listing 97.036 o The Department did not complete the recipient share section of the federal financial reports for 2 out of 10 reports tested. ? Assistance Listing 97.042 o The Department did not complete the recipient share section of the federal financial reports for 4 out of 9 reports tested. o 2 out of 9 federal financial reports tested were not submitted timely. ? Assistance Listing 97.046 o 2 out of 6 federal financial reports tested were not provided to us. ? Assistance Listing 97.047 o The Department did not complete the recipient share section of the federal financial reports for 3 out of 6 reports tested. ? Assistance Listing 97.067 o All but one Performance Progress Report was not submitted for FY22. Management?s Progress for Repeated Findings: Management failed to implement adequate controls to resolve the finding from the prior years. Criteria: According to ?200.302 Financial management of 2 CFR Part 200, the State?s, and the other non-Federal entity?s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions. Further, the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements. According to ?200.303 Internal controls of 2 CFR Part 200, the non-Federal entity must 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. Effect: The auditor noted instances of noncompliance. Noncompliance results in delayed reimbursement of eligible federal expenditures. Potential loss of federal funding. Cause: The Department lacks established internal controls and procedures over financial grant management to ensure submitted reports are complete, agree to supporting spreadsheets, submitted timely, and properly maintained in the files of the Department.
2022-005 (2019-013) REPORTING ? Repeated and Modified Federal Agency: U.S. Department of Homeland Security/FEMA Federal Program Title & Assistance Listing Number: Disaster Grants ? Public Assistance (Presidentially Declared Disasters) - 97.036 Emergency Management Performance Grants ? 97.042 Fire Management Assistance Grants ? 97.046 Pre-Disaster Mitigation ? 97.047 Homeland Security Grant Program ? 97.067 Award Period: Various Type of Finding: Material Weakness in Internal Control over Compliance Material Noncompliance (Modified Opinion) Questioned Costs: Unknown Condition: We noted the Department was not in compliance with requirements related to the reporting of grants. ? Assistance Listing 97.036 o The Department did not complete the recipient share section of the federal financial reports for 2 out of 10 reports tested. ? Assistance Listing 97.042 o The Department did not complete the recipient share section of the federal financial reports for 4 out of 9 reports tested. o 2 out of 9 federal financial reports tested were not submitted timely. ? Assistance Listing 97.046 o 2 out of 6 federal financial reports tested were not provided to us. ? Assistance Listing 97.047 o The Department did not complete the recipient share section of the federal financial reports for 3 out of 6 reports tested. ? Assistance Listing 97.067 o All but one Performance Progress Report was not submitted for FY22. Management?s Progress for Repeated Findings: Management failed to implement adequate controls to resolve the finding from the prior years. Criteria: According to ?200.302 Financial management of 2 CFR Part 200, the State?s, and the other non-Federal entity?s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions. Further, the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements. According to ?200.303 Internal controls of 2 CFR Part 200, the non-Federal entity must 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. Effect: The auditor noted instances of noncompliance. Noncompliance results in delayed reimbursement of eligible federal expenditures. Potential loss of federal funding. Cause: The Department lacks established internal controls and procedures over financial grant management to ensure submitted reports are complete, agree to supporting spreadsheets, submitted timely, and properly maintained in the files of the Department.
FINDING 2022-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Number or Year (or Other Identifying Number): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, or implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual data reports were complete and accurately submitted. The reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, for one of seven key line items tested, the School Corporation could not provide supporting documentation. The lack of supporting documentation for the Full Time Equivalent (FTE) key line item on the ESSER I, Year 1, annual report prevented us from verifying the accuracy of the line item. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, Year 1 report. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Number or Year (or Other Identifying Number): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, or implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual data reports were complete and accurately submitted. The reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, for one of seven key line items tested, the School Corporation could not provide supporting documentation. The lack of supporting documentation for the Full Time Equivalent (FTE) key line item on the ESSER I, Year 1, annual report prevented us from verifying the accuracy of the line item. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, Year 1 report. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding 2022-002 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 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." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-002 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 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." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-002 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 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." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 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." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The Annual Data Reports required to be submitted could have incomplete or inaccurate data without a secondary, documented review in place. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted the amounts reported as expended for ESSER awards on the second report did not agree to the amounts expended per the underlying expenditure records of the School Corporation. Additionally, we noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 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." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The Annual Data Reports required to be submitted could have incomplete or inaccurate data without a secondary, documented review in place. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted the amounts reported as expended for ESSER awards on the second report did not agree to the amounts expended per the underlying expenditure records of the School Corporation. Additionally, we noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 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." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The Annual Data Reports required to be submitted could have incomplete or inaccurate data without a secondary, documented review in place. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted the amounts reported as expended for ESSER awards on the second report did not agree to the amounts expended per the underlying expenditure records of the School Corporation. Additionally, we noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 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." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The Annual Data Reports required to be submitted could have incomplete or inaccurate data without a secondary, documented review in place. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted the amounts reported as expended for ESSER awards on the second report did not agree to the amounts expended per the underlying expenditure records of the School Corporation. Additionally, we noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-014 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, S010A200014, S010A190014SIG Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context The system of internal controls over the applicable reports as established by the School Corporation was not properly implemented, nor was it operating effectively to ensure that sufficient audit evidence was maintained to support the requests for reimbursement, as well as the Final Expenditure Reports as submitted by the School. The fiscal years 2020-2021 and 2021-2022 Final Expenditure Reports and three reimbursement requests were selected for testing. The School was unable to provide for audit, documentation to support the underlying data accumulated and summarized in each of the Final Expenditure Reports, or for the three reimbursement requests. The reported data could not be traced to records that accumulate or summarize the data; therefore, the accuracy and completeness of the reports could not be verified. The Title I Director approved the requests for reimbursement and the Final Expenditure Reports prior to submission; however, this review was not effective. 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.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not established an effective system of internal controls that would have ensured compliance, or that supporting documentation would have been maintained and made available for audit, related to the Reporting compliance requirement. Effect The failure to establish an effective system of internal controls and to retain and provide appropriate supporting documentation prevented the determination of the School Corporation's compliance with compliance requirements listed above. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish an effective system of internal controls to ensure documentation be maintained and made available for audit related to the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-014 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, S010A200014, S010A190014SIG Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context The system of internal controls over the applicable reports as established by the School Corporation was not properly implemented, nor was it operating effectively to ensure that sufficient audit evidence was maintained to support the requests for reimbursement, as well as the Final Expenditure Reports as submitted by the School. The fiscal years 2020-2021 and 2021-2022 Final Expenditure Reports and three reimbursement requests were selected for testing. The School was unable to provide for audit, documentation to support the underlying data accumulated and summarized in each of the Final Expenditure Reports, or for the three reimbursement requests. The reported data could not be traced to records that accumulate or summarize the data; therefore, the accuracy and completeness of the reports could not be verified. The Title I Director approved the requests for reimbursement and the Final Expenditure Reports prior to submission; however, this review was not effective. 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.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not established an effective system of internal controls that would have ensured compliance, or that supporting documentation would have been maintained and made available for audit, related to the Reporting compliance requirement. Effect The failure to establish an effective system of internal controls and to retain and provide appropriate supporting documentation prevented the determination of the School Corporation's compliance with compliance requirements listed above. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish an effective system of internal controls to ensure documentation be maintained and made available for audit related to the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-017 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, Other Matters Condition and Context The School Corporation had not designed nor implemented a system of internal controls to ensure that the four Elementary and Secondary School Emergency Relief (ESSER) annual data reports required to be filed during the audit period were complete and accurate prior to submission. Each of the reports was prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Furthermore, the reported data on three of the reports as noted below could not be traced back to records that accumulate or summarize the data; therefore, the accuracy and completeness of the reports could not be verified. ESSER I, Year 1 Report The Full-Time Employee (FTE) Positions as of March 13, 2020, and FTE Positions as of September 30, 2020, were not able to be verified to the School's records. ESSER I, Year 2 Report The Key Line Item, Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Personnel Services - Salary was overstated by $950. An additional Key Line Item, Operational Continuity and Other Allowed Uses - purchased professional services was understated by $138,739. ESSER II, Year 1 Report The Key Line Item, Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Purchased Professional and Technical Services was understated by $111,290. An additional Key Line Item, Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies was understated by $6,500. 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.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, 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 Management had not designed nor implemented a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-017 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, Other Matters Condition and Context The School Corporation had not designed nor implemented a system of internal controls to ensure that the four Elementary and Secondary School Emergency Relief (ESSER) annual data reports required to be filed during the audit period were complete and accurate prior to submission. Each of the reports was prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Furthermore, the reported data on three of the reports as noted below could not be traced back to records that accumulate or summarize the data; therefore, the accuracy and completeness of the reports could not be verified. ESSER I, Year 1 Report The Full-Time Employee (FTE) Positions as of March 13, 2020, and FTE Positions as of September 30, 2020, were not able to be verified to the School's records. ESSER I, Year 2 Report The Key Line Item, Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Personnel Services - Salary was overstated by $950. An additional Key Line Item, Operational Continuity and Other Allowed Uses - purchased professional services was understated by $138,739. ESSER II, Year 1 Report The Key Line Item, Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Purchased Professional and Technical Services was understated by $111,290. An additional Key Line Item, Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies was understated by $6,500. 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.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, 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 Management had not designed nor implemented a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
2022-001 U.S. Department of Housing and Urban Development CDBG ? Entitlement Grants Cluster ? CFDA 14.218 Criteria: Per 2 CFR section 200.302(b)(2), the City?s financial management system must provide for the accurate, current and complete disclosure of the financial results of each Federal award or program. Condition: The subsidiary ledger for community development rehabilitation loans maintained by the Department did not agree to the City?s general ledger. Cause: The subsidiary loans receivable ledger has not been reconciled to the City?s general ledger. Effect: The subsidiary ledger used to monitor community development rehabilitation loans was not properly stated. Questioned Costs: None Repeat Finding from Prior Year: Prior year finding 2021-002 Recommendation: The City should reconcile its loan management software program to the City?s general ledger. Views of Responsible Official: Management agrees with the finding.
2022-001 U.S. Department of Housing and Urban Development CDBG ? Entitlement Grants Cluster ? CFDA 14.218 Criteria: Per 2 CFR section 200.302(b)(2), the City?s financial management system must provide for the accurate, current and complete disclosure of the financial results of each Federal award or program. Condition: The subsidiary ledger for community development rehabilitation loans maintained by the Department did not agree to the City?s general ledger. Cause: The subsidiary loans receivable ledger has not been reconciled to the City?s general ledger. Effect: The subsidiary ledger used to monitor community development rehabilitation loans was not properly stated. Questioned Costs: None Repeat Finding from Prior Year: Prior year finding 2021-002 Recommendation: The City should reconcile its loan management software program to the City?s general ledger. Views of Responsible Official: Management agrees with the finding.
2022-001 U.S. Department of Housing and Urban Development CDBG ? Entitlement Grants Cluster ? CFDA 14.218 Criteria: Per 2 CFR section 200.302(b)(2), the City?s financial management system must provide for the accurate, current and complete disclosure of the financial results of each Federal award or program. Condition: The subsidiary ledger for community development rehabilitation loans maintained by the Department did not agree to the City?s general ledger. Cause: The subsidiary loans receivable ledger has not been reconciled to the City?s general ledger. Effect: The subsidiary ledger used to monitor community development rehabilitation loans was not properly stated. Questioned Costs: None Repeat Finding from Prior Year: Prior year finding 2021-002 Recommendation: The City should reconcile its loan management software program to the City?s general ledger. Views of Responsible Official: Management agrees with the finding.
2022-051 Oregon Health Authority Correct expenditures charged to the incorrect program Federal Awarding Agency: U.S. Department of Health and Human Services Assistance Listing Number and Name: 93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (COVID-19) Federal Award Numbers and Years: 6 NU50CK000541 (COVID-19) Compliance Requirements: Activities Allowed or Unallowed Type of Finding: Significant Deficiency, Noncompliance Prior Year Finding: N/A Questioned Costs: $356,050 (COVID-19) Criteria: 2 CFR 200.302 To address the COVID-19 pandemic, the Center for Disease Control (CDC) awarded the Oregon Health Authority (department) over $495 million in additional funding beyond the normal funding levels for the Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) program. The funding was awarded for specific purposes such as enhancing detection, reopening schools, and enhancing detection expansion. The purposes of these awards generally do not allow for expenditures directly related to operating the COVID-19 vaccine clinics. In our testing, we identified two payments totaling $356,050 relating to emergency medical technicians attending vaccine clinics to assist if those receiving the vaccine had adverse reactions and required medical attention. Per department management, the transactions should have been charged to a different grant provided by the Federal Emergency Management Agency (FEMA). The error was caused by incorrect account coding when the invoice was processed. Other transactions under this contract were properly charged to the FEMA grant. We recommend management correct the accounting error and ensure the expenditures are charged to the correct programs. We also recommend the department determine if there are additional questioned costs relating to the advanced cash draw as the federal programs have different timing for federal reimbursements.
FINDING 2022-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Number: 84.425D Federal Award Number or Year (or Other Identifying Number): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters INDIANA STATE BOARD OF ACCOUNTS 18 FAIRFIELD COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Two of four annual data reports due and submitted during the audit period contained errors. The Elementary and Secondary School Emergency Relief (ESSER) I, Year 1 annual data report overstated total expenditures by $72,046. The ESSER I, Year 2 annual data report overstated total expenditures by $2,303. 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 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 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." INDIANA STATE BOARD OF ACCOUNTS 19 FAIRFIELD COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause Management had not established a system of internal controls that would have ensured compliance with the Reporting compliance requirement. The ESSER1, Year 1 report included expenditures past the reporting period. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Number: 84.425D Federal Award Number or Year (or Other Identifying Number): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters INDIANA STATE BOARD OF ACCOUNTS 18 FAIRFIELD COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Two of four annual data reports due and submitted during the audit period contained errors. The Elementary and Secondary School Emergency Relief (ESSER) I, Year 1 annual data report overstated total expenditures by $72,046. The ESSER I, Year 2 annual data report overstated total expenditures by $2,303. 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 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 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." INDIANA STATE BOARD OF ACCOUNTS 19 FAIRFIELD COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause Management had not established a system of internal controls that would have ensured compliance with the Reporting compliance requirement. The ESSER1, Year 1 report included expenditures past the reporting period. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Number: 84.425D Federal Award Number or Year (or Other Identifying Number): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters INDIANA STATE BOARD OF ACCOUNTS 18 FAIRFIELD COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Two of four annual data reports due and submitted during the audit period contained errors. The Elementary and Secondary School Emergency Relief (ESSER) I, Year 1 annual data report overstated total expenditures by $72,046. The ESSER I, Year 2 annual data report overstated total expenditures by $2,303. 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 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 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." INDIANA STATE BOARD OF ACCOUNTS 19 FAIRFIELD COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause Management had not established a system of internal controls that would have ensured compliance with the Reporting compliance requirement. The ESSER1, Year 1 report included expenditures past the reporting period. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-001 Subject: COVID-19 - Education Stabilization Fund - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425U Federal Award Number and Year (or Other Identifying Number): S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation was a participating member in the Central Nine Career Center (Center). As a member, the School Corporation was responsible for providing financial contributions to support the Center's operations. In 2019, the Center's Executive Director commissioned a facilities study for purposes of addressing the increase in enrollment at the Center. Based on the results of the study, the Center's Governing Board approved an expansion project in May of 2021, with the construction costs to be split between the member schools based upon each member school's student enrollment at the Center. As a result of that calculation, the School Corporation's contribution to the Center for the construction costs was $472,963. The School Corporation elected to use the American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSER) funds awarded under the COVID-19 - Education Stabilization Fund to pay this obligation to the Center in December 2021. Although the School Corporation incurred the financial obligation within the grant's period of performance, the origins of the project predated the COVID-19 pandemic. The project's stated purpose did not provide any evidence that it was to prevent, prepare for, or respond to COVID-19. Additionally, the payment was made without proper supporting documentation. The claim for payment was prepared based upon an invoice submitted to the School Corporation from the Center that listed the amount due on a single line item without a breakdown or itemized detail to support the expense from the federal award. We consider the total payment of $472,963 to be questioned costs. The lack of internal controls and noncompliance was isolated to this single payment. 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). . . ." American Rescue Plan Act section 2001(e) states in part: "Uses of Funds. - A local education agency that receives funds under this section - . . . (2) shall use the remaining funds for any of the following: . . . (E) Coordination of preparedness and response efforts of local education agencies with State, local, Tribal, and territorial public health departments, and other relevant agencies, to improve coordinated responses among such entities to prevent, prepare for, and respond to coronavirus. . . . (G) Developing and implementing procedures and systems to improve the preparedness and response efforts of local educational agencies. . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (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. . . ." 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. . . . (g) be adequately documented. . . ." Cause The system of internal controls over the review of federal award expenditures developed by management of the School Corporation was not properly implemented, nor was it operating effectively to ensure expenditures were in compliance with the terms and conditions of the federal award, as well as the Activities Allowed or Unallowed and the Allowable Costs/Cost Principles compliance requirements. Effect Without a proper system of internal controls in place that operated effectively, material noncompliance remained undetected. 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 funds to the School Corporation. Questioned Costs Questioned costs in the amount of $472,963, were identified as noted in the Condition and Context. Recommendation We recommended that the School Corporation's management establish a proper system of internal controls to ensure expenditures made from federal awards are in compliance with the terms and conditions of the federal award, as well as the Activities Allowed or Unallowed and the Allowable Costs/Cost Principles compliance requirements. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
2022 ? 008 Reporting (Significant Deficiency and Noncompliance) Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Emergency Rental Assistance Program Assistance Listing Number: 21.027, 21.023 Federal Award Identification Number and Year: ALN 21.027 ? Pub. L. No. 117-2 2021 ALN 21.023 ? ERA0335 - 2021 Award Period: ALN 21.027 ? 5/10/2021 - 12/31/2026 ALN 21.023 ? 1/20/2021 - 9/30/2022 Type of Finding: ? Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: According to ? 200.302 Financial management of 2 CFR Part 200, the non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Further, the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements. According to ? 200.303 Internal controls of 2 CFR Part 200, the non-Federal entity must 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. According to the Compliance Supplement 2022 Part 3, program income does not include interest earned on advances of federal funds. Condition: During our testing, it was noted that the City did not have effective internal controls in place to ensure accurate and complete reporting. Questioned costs: None Context: During our testing, we noted the following exceptions, which are detailed by ALN Number. ALN 21.027 ? For the interim report, support was not provided for Category 1.7 Capital Investments or Physical Plant Changes to Public Facilities that respond to the COVID-19 public health emergency Cumulative Obligations of approximately $280.2K. The City did, however, cancel this project after the initial reporting. 2022 ? 008 Reporting (Significant Deficiency and Noncompliance) (Continued) ALN 21.027 (continued) ? For the Project and Expenditure Report 1, we noted the following exceptions. o Project Name: Police Vehicles Total Cumulative Obligations of approximately $2,654,705. The City identified requisitions and purchase orders of approximately $2,655,183. Thus, a variance of $478. o Project Name: Police Vehicles Total Cumulative Obligations and Total Cumulative Expenditures of approximately $2,654,705 and $1,095,985, respectively, are listed twice in the project overview. Thus, the project is duplicated in the Total Obligations and Total Expenditures in the overview section. The City states this to be a glitch of the portal. However, there is no communication between the City and Treasury to evidence the Treasury's acknowledgment of this glitch in the portal. o Project Name: Eviction Prevention: New Mexico Legal Aid Total Cumulative Obligations of approximately $216K. The total should be approximately $26K. Thus, a variance of $190K. ? Subaward No: SUB-0034501 Period of Performance Start and End of 9/1/2021 to 12/31/2022. However, the subrecipient agreement signed by all parties early September 2021 has a Subaward Period of Performance Start and End Date 9/14/2021 to 3/31/2022. ? Subaward No: SUB-0034394 Period of Performance Start and End of 10/25/2021 to 12/31/2022. However, the contract control form approved by all parties late October 2021 has a contract term 10/20/2021 to 10/19/2022. ? Subaward No: SUB-0034455 Subaward Date of 3/11/2021. This date is the Federal Award Date of Award to the Recipient by the Federal Agency not the subaward start date of 9/1/2021. The subrecipient agreement signed by all parties 9/29/2021 and 10/1/2021. ? Subaward No: SUB-0034462 Subaward Date of 3/11/2021. This date is the Federal Award Date of Award to the Recipient by the Federal Agency not the subaward start date of 9/1/2021. The subrecipient agreement signed by all parties late December 2021. ? Expenditures for Awards more than $50,000 ? All projects have a Subaward Amount of 54405428.50. The City states this to be an error with the portal exporting. However, there is no communication between the City and Treasury to evidence the Treasury's acknowledgment of this error with portal exporting. ? Subaward Crossroads for Women amount of $750K with Subaward Period of Performance Start and End Date of 12/1/2021 to 12/31/2024 not included in the report. Agreement signed by all parties end December 2021. ? Contractual 2021 expenditures of approximately $122K not included in the report. o For the Project and Expenditure Report 2, we noted the following exceptions. ? Subaward No: SLFRP0013-RIVENROCK Subaward Obligation of $50K. However, total purchase order amount of approximately $74.5K. Thus, a variance of approximately $24.5K. ? Subaward No: 33-202200796 Subaward Date of 9/1/2021 and Period of Performance Start and End of 9/1/2021 to 12/31/2023. However, the subrecipient agreement signed by all parties end December 2021 has a Subaward Date of 12/1/2021 and Subaward Period of Performance Start and End Date 12/1/2021 to 12/31/2024. ? Payments To Individuals Expenditure: EN-00044853 Total Period Expenditure Amount of approximately $6.9 million. Amount includes approximately $128.1K of contractor payments not business grants. 2022 ? 008 Reporting (Significant Deficiency and Noncompliance) (Continued) ALN 21.023 ? For 3 of 5 financial reports, the City reported interest earned on advances of federal funds totaling approximately $380.8K as program income. However, interest earned on advances of federal funds is not program income. ? For 1 of 5 special quarterly reports, we noted the following exceptions. o The City did not provide support for any changes from the last report we had which was ERA 1 Quarter 3 2021 (July-September). o The City incorrectly reported cumulative expenditures to date of approximately $13.1 million The amount reported should have been approximately $17.1 million based on a reconciliation provided to us by the City. Thus, a variance of approximately $4 million. o The City incorrectly reported cumulative obligations to date of approximately $23.7 million. The amount reported should have been approximately $23.6 million based on a reconciliation provided to us by the City. Thus, a variance of approximately $151K. Cause: The City lacks effective internal controls and procedures over financial grant management to ensure submitted reports are complete and agree to supporting documentation. Effect: The auditor noted instances of noncompliance. Noncompliance results in inaccurate reporting. Recommendation: We recommend the City design controls to ensure compliance with federal financial management regulation. Management Response: The City agrees with the finding. The City will implement controls to ensure compliance with federal financial management regulations. The City recognizes that it needs to improve its procedures for preparing quarterly report for Treasury funds. Going forward, the Family and Community Services Department will work with the Grants Section to develop and implement standardized procedures for identifying and documenting expenditures, and for reviewing quarterly reports prior to submission. Timeline and Responsible Position: June 2023 ? City Controller/DFAS Deputy Director and Director of Family & Community Services
2022 ? 008 Reporting (Significant Deficiency and Noncompliance) Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Emergency Rental Assistance Program Assistance Listing Number: 21.027, 21.023 Federal Award Identification Number and Year: ALN 21.027 ? Pub. L. No. 117-2 2021 ALN 21.023 ? ERA0335 - 2021 Award Period: ALN 21.027 ? 5/10/2021 - 12/31/2026 ALN 21.023 ? 1/20/2021 - 9/30/2022 Type of Finding: ? Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: According to ? 200.302 Financial management of 2 CFR Part 200, the non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Further, the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements. According to ? 200.303 Internal controls of 2 CFR Part 200, the non-Federal entity must 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. According to the Compliance Supplement 2022 Part 3, program income does not include interest earned on advances of federal funds. Condition: During our testing, it was noted that the City did not have effective internal controls in place to ensure accurate and complete reporting. Questioned costs: None Context: During our testing, we noted the following exceptions, which are detailed by ALN Number. ALN 21.027 ? For the interim report, support was not provided for Category 1.7 Capital Investments or Physical Plant Changes to Public Facilities that respond to the COVID-19 public health emergency Cumulative Obligations of approximately $280.2K. The City did, however, cancel this project after the initial reporting. 2022 ? 008 Reporting (Significant Deficiency and Noncompliance) (Continued) ALN 21.027 (continued) ? For the Project and Expenditure Report 1, we noted the following exceptions. o Project Name: Police Vehicles Total Cumulative Obligations of approximately $2,654,705. The City identified requisitions and purchase orders of approximately $2,655,183. Thus, a variance of $478. o Project Name: Police Vehicles Total Cumulative Obligations and Total Cumulative Expenditures of approximately $2,654,705 and $1,095,985, respectively, are listed twice in the project overview. Thus, the project is duplicated in the Total Obligations and Total Expenditures in the overview section. The City states this to be a glitch of the portal. However, there is no communication between the City and Treasury to evidence the Treasury's acknowledgment of this glitch in the portal. o Project Name: Eviction Prevention: New Mexico Legal Aid Total Cumulative Obligations of approximately $216K. The total should be approximately $26K. Thus, a variance of $190K. ? Subaward No: SUB-0034501 Period of Performance Start and End of 9/1/2021 to 12/31/2022. However, the subrecipient agreement signed by all parties early September 2021 has a Subaward Period of Performance Start and End Date 9/14/2021 to 3/31/2022. ? Subaward No: SUB-0034394 Period of Performance Start and End of 10/25/2021 to 12/31/2022. However, the contract control form approved by all parties late October 2021 has a contract term 10/20/2021 to 10/19/2022. ? Subaward No: SUB-0034455 Subaward Date of 3/11/2021. This date is the Federal Award Date of Award to the Recipient by the Federal Agency not the subaward start date of 9/1/2021. The subrecipient agreement signed by all parties 9/29/2021 and 10/1/2021. ? Subaward No: SUB-0034462 Subaward Date of 3/11/2021. This date is the Federal Award Date of Award to the Recipient by the Federal Agency not the subaward start date of 9/1/2021. The subrecipient agreement signed by all parties late December 2021. ? Expenditures for Awards more than $50,000 ? All projects have a Subaward Amount of 54405428.50. The City states this to be an error with the portal exporting. However, there is no communication between the City and Treasury to evidence the Treasury's acknowledgment of this error with portal exporting. ? Subaward Crossroads for Women amount of $750K with Subaward Period of Performance Start and End Date of 12/1/2021 to 12/31/2024 not included in the report. Agreement signed by all parties end December 2021. ? Contractual 2021 expenditures of approximately $122K not included in the report. o For the Project and Expenditure Report 2, we noted the following exceptions. ? Subaward No: SLFRP0013-RIVENROCK Subaward Obligation of $50K. However, total purchase order amount of approximately $74.5K. Thus, a variance of approximately $24.5K. ? Subaward No: 33-202200796 Subaward Date of 9/1/2021 and Period of Performance Start and End of 9/1/2021 to 12/31/2023. However, the subrecipient agreement signed by all parties end December 2021 has a Subaward Date of 12/1/2021 and Subaward Period of Performance Start and End Date 12/1/2021 to 12/31/2024. ? Payments To Individuals Expenditure: EN-00044853 Total Period Expenditure Amount of approximately $6.9 million. Amount includes approximately $128.1K of contractor payments not business grants. 2022 ? 008 Reporting (Significant Deficiency and Noncompliance) (Continued) ALN 21.023 ? For 3 of 5 financial reports, the City reported interest earned on advances of federal funds totaling approximately $380.8K as program income. However, interest earned on advances of federal funds is not program income. ? For 1 of 5 special quarterly reports, we noted the following exceptions. o The City did not provide support for any changes from the last report we had which was ERA 1 Quarter 3 2021 (July-September). o The City incorrectly reported cumulative expenditures to date of approximately $13.1 million The amount reported should have been approximately $17.1 million based on a reconciliation provided to us by the City. Thus, a variance of approximately $4 million. o The City incorrectly reported cumulative obligations to date of approximately $23.7 million. The amount reported should have been approximately $23.6 million based on a reconciliation provided to us by the City. Thus, a variance of approximately $151K. Cause: The City lacks effective internal controls and procedures over financial grant management to ensure submitted reports are complete and agree to supporting documentation. Effect: The auditor noted instances of noncompliance. Noncompliance results in inaccurate reporting. Recommendation: We recommend the City design controls to ensure compliance with federal financial management regulation. Management Response: The City agrees with the finding. The City will implement controls to ensure compliance with federal financial management regulations. The City recognizes that it needs to improve its procedures for preparing quarterly report for Treasury funds. Going forward, the Family and Community Services Department will work with the Grants Section to develop and implement standardized procedures for identifying and documenting expenditures, and for reviewing quarterly reports prior to submission. Timeline and Responsible Position: June 2023 ? City Controller/DFAS Deputy Director and Director of Family & Community Services
FINDING 2022-008 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U210013, S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) and the Governor's Emergency Education Relief (GEER) annual Data Collection reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, two of eight key line items examined were not able to be traced to the School Corporation's records. The School Corporation was unable to provide supporting documentation for Full Time Equivalent (FTE) figures that matched what was reported to the Indiana Department of Education. Variances ranged from 5.7 to 55.27. The lack of internal controls was systemic throughout the audit period. Noncompliance was isolated to ESSER I and GEER I, year 1 annual reports. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not developed, nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-008 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U210013, S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) and the Governor's Emergency Education Relief (GEER) annual Data Collection reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, two of eight key line items examined were not able to be traced to the School Corporation's records. The School Corporation was unable to provide supporting documentation for Full Time Equivalent (FTE) figures that matched what was reported to the Indiana Department of Education. Variances ranged from 5.7 to 55.27. The lack of internal controls was systemic throughout the audit period. Noncompliance was isolated to ESSER I and GEER I, year 1 annual reports. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not developed, nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-008 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U210013, S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) and the Governor's Emergency Education Relief (GEER) annual Data Collection reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, two of eight key line items examined were not able to be traced to the School Corporation's records. The School Corporation was unable to provide supporting documentation for Full Time Equivalent (FTE) figures that matched what was reported to the Indiana Department of Education. Variances ranged from 5.7 to 55.27. The lack of internal controls was systemic throughout the audit period. Noncompliance was isolated to ESSER I and GEER I, year 1 annual reports. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not developed, nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-008 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U210013, S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) and the Governor's Emergency Education Relief (GEER) annual Data Collection reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, two of eight key line items examined were not able to be traced to the School Corporation's records. The School Corporation was unable to provide supporting documentation for Full Time Equivalent (FTE) figures that matched what was reported to the Indiana Department of Education. Variances ranged from 5.7 to 55.27. The lack of internal controls was systemic throughout the audit period. Noncompliance was isolated to ESSER I and GEER I, year 1 annual reports. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not developed, nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-008 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U210013, S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) and the Governor's Emergency Education Relief (GEER) annual Data Collection reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, two of eight key line items examined were not able to be traced to the School Corporation's records. The School Corporation was unable to provide supporting documentation for Full Time Equivalent (FTE) figures that matched what was reported to the Indiana Department of Education. Variances ranged from 5.7 to 55.27. The lack of internal controls was systemic throughout the audit period. Noncompliance was isolated to ESSER I and GEER I, year 1 annual reports. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not developed, nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-003 Information on the federal program: Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Numbers: 84.425D, 84.425U Federal Award Numbers (or Other Identifying Numbers): S425D200013, S425D210013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion 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 awards 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 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.? Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Three of four annual data reports due and submitted during the audit period were materially misstated. ? The Elementary and Secondary School Emergency Relief (ESSER I), Year 2 annual data report understated total expenditures by $145,422. ? The Elementary and Secondary School Emergency Relief (ESSER II), Year 1 annual data report overstated total expenditures by $412,355. ? The American Rescue Plan?Elementary and Secondary School Emergency Relief (ARP ESSER), Year 1 annual data report overstated total expenditures by $550,973. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Cause: Management had not established a system of internal controls that would have ensured compliance with the Reporting compliance requirement. The two overstated reports included expenditures past the reporting period. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-003 Information on the federal program: Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Numbers: 84.425D, 84.425U Federal Award Numbers (or Other Identifying Numbers): S425D200013, S425D210013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion 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 awards 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 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.? Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Three of four annual data reports due and submitted during the audit period were materially misstated. ? The Elementary and Secondary School Emergency Relief (ESSER I), Year 2 annual data report understated total expenditures by $145,422. ? The Elementary and Secondary School Emergency Relief (ESSER II), Year 1 annual data report overstated total expenditures by $412,355. ? The American Rescue Plan?Elementary and Secondary School Emergency Relief (ARP ESSER), Year 1 annual data report overstated total expenditures by $550,973. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Cause: Management had not established a system of internal controls that would have ensured compliance with the Reporting compliance requirement. The two overstated reports included expenditures past the reporting period. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-002 Subject: COVID-19 Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness 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 awards 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 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." Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Cause: Management had not established an effective system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Context: Although, the School Treasurer and the Superintendent worked independently to compile the information for the Elementary and Secondary School Emergency Relief (ESSER) annual data reports (Reports) reports and then reviewed each other?s notes and prepared the annual date reports, the control was not effective and did not detect and allow correction of errors prior to submission. Due to the lack of effective internal controls, the Reports contained the following errors: -ESSER I, Annual Year 1 Report The School Corporation did not file this report. According to the detailed disbursements, no ESSER funds were expended for the applicable date range. However, the full-time employee numbers should have been reported. These numbers were 117.5 at 3/13/20 and 113.5 at 9/30/20. - ESSER I, Annual Year 2 Report The School Corporation did not enter the correct amounts for the following categories: - Addressing Physical Health & Safety - Personal Services - Salaries. The appropriated amount of $44,000 was reported instead of the actual disbursement of $36,377. - Meeting Student's Academic, Social, Emotional, and Other Needs - Supplies. The appropriated amount of $73,390 was reported instead of the actual disbursement of $796. - ESSER II, Annual Year 2 Report The School Corporation did not enter the correct amount for the Meeting Student?s Academic, Social, Emotional, and Other Needs ? Supplies category. The appropriated amount of $408,715 was report instead of the actual disbursement of $400,439. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Identification as a repeat finding, if applicable: No Recommendation: We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-002 Subject: COVID-19 Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness 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 awards 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 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." Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Cause: Management had not established an effective system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Context: Although, the School Treasurer and the Superintendent worked independently to compile the information for the Elementary and Secondary School Emergency Relief (ESSER) annual data reports (Reports) reports and then reviewed each other?s notes and prepared the annual date reports, the control was not effective and did not detect and allow correction of errors prior to submission. Due to the lack of effective internal controls, the Reports contained the following errors: -ESSER I, Annual Year 1 Report The School Corporation did not file this report. According to the detailed disbursements, no ESSER funds were expended for the applicable date range. However, the full-time employee numbers should have been reported. These numbers were 117.5 at 3/13/20 and 113.5 at 9/30/20. - ESSER I, Annual Year 2 Report The School Corporation did not enter the correct amounts for the following categories: - Addressing Physical Health & Safety - Personal Services - Salaries. The appropriated amount of $44,000 was reported instead of the actual disbursement of $36,377. - Meeting Student's Academic, Social, Emotional, and Other Needs - Supplies. The appropriated amount of $73,390 was reported instead of the actual disbursement of $796. - ESSER II, Annual Year 2 Report The School Corporation did not enter the correct amount for the Meeting Student?s Academic, Social, Emotional, and Other Needs ? Supplies category. The appropriated amount of $408,715 was report instead of the actual disbursement of $400,439. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Identification as a repeat finding, if applicable: No Recommendation: We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-002 Subject: COVID-19 Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness 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 awards 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 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." Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Cause: Management had not established an effective system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Context: Although, the School Treasurer and the Superintendent worked independently to compile the information for the Elementary and Secondary School Emergency Relief (ESSER) annual data reports (Reports) reports and then reviewed each other?s notes and prepared the annual date reports, the control was not effective and did not detect and allow correction of errors prior to submission. Due to the lack of effective internal controls, the Reports contained the following errors: -ESSER I, Annual Year 1 Report The School Corporation did not file this report. According to the detailed disbursements, no ESSER funds were expended for the applicable date range. However, the full-time employee numbers should have been reported. These numbers were 117.5 at 3/13/20 and 113.5 at 9/30/20. - ESSER I, Annual Year 2 Report The School Corporation did not enter the correct amounts for the following categories: - Addressing Physical Health & Safety - Personal Services - Salaries. The appropriated amount of $44,000 was reported instead of the actual disbursement of $36,377. - Meeting Student's Academic, Social, Emotional, and Other Needs - Supplies. The appropriated amount of $73,390 was reported instead of the actual disbursement of $796. - ESSER II, Annual Year 2 Report The School Corporation did not enter the correct amount for the Meeting Student?s Academic, Social, Emotional, and Other Needs ? Supplies category. The appropriated amount of $408,715 was report instead of the actual disbursement of $400,439. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Identification as a repeat finding, if applicable: No Recommendation: We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-003 Information on the federal program: Subject: Education Stabilization Fund ? Annual Data Report Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 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 Financial reporting . . . ." 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." Condition: The School Corporation did not have a documented review control in place to ensure the annual data report was reviewed by someone other than the preparer. Cause: There were not sufficient internal controls in place to ensure the Annual Data Report was submitted by the Indiana Department of Education?s deadline. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Reporting compliance requirements. Questioned Costs: There were no questioned costs identified. Context: There was no documented review by someone other than the preparer of the Annual Data Report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-003 Information on the federal program: Subject: Education Stabilization Fund ? Annual Data Report Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 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 Financial reporting . . . ." 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." Condition: The School Corporation did not have a documented review control in place to ensure the annual data report was reviewed by someone other than the preparer. Cause: There were not sufficient internal controls in place to ensure the Annual Data Report was submitted by the Indiana Department of Education?s deadline. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Reporting compliance requirements. Questioned Costs: There were no questioned costs identified. Context: There was no documented review by someone other than the preparer of the Annual Data Report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-003 Information on the federal program: Subject: Education Stabilization Fund ? Annual Data Report Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 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 Financial reporting . . . ." 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." Condition: The School Corporation did not have a documented review control in place to ensure the annual data report was reviewed by someone other than the preparer. Cause: There were not sufficient internal controls in place to ensure the Annual Data Report was submitted by the Indiana Department of Education?s deadline. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Reporting compliance requirements. Questioned Costs: There were no questioned costs identified. Context: There was no documented review by someone other than the preparer of the Annual Data Report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-003 Information on the federal program: Subject: Education Stabilization Fund ? Annual Data Report Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 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 Financial reporting . . . ." 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." Condition: The School Corporation did not have a documented review control in place to ensure the annual data report was reviewed by someone other than the preparer. Cause: There were not sufficient internal controls in place to ensure the Annual Data Report was submitted by the Indiana Department of Education?s deadline. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Reporting compliance requirements. Questioned Costs: There were no questioned costs identified. Context: There was no documented review by someone other than the preparer of the Annual Data Report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-007 Subject: COVID-19 ? Education Stabilization Fund ? Reporting Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 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." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. The amounts reported as expended on the second report did not agree to the underlying expenditure records of the School Corporation. Per discussion with the Treasurer, the amounts reported on the second report were the appropriated amounts, not the actual amounts expended during the period. Therefore, the amounts on the report were overstated by approximately 25% for ESSER I and 280% for ESSER II compared to the correct amounts on the School Corporation?s records. Additionally, for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommended someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-007 Subject: COVID-19 ? Education Stabilization Fund ? Reporting Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 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." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. The amounts reported as expended on the second report did not agree to the underlying expenditure records of the School Corporation. Per discussion with the Treasurer, the amounts reported on the second report were the appropriated amounts, not the actual amounts expended during the period. Therefore, the amounts on the report were overstated by approximately 25% for ESSER I and 280% for ESSER II compared to the correct amounts on the School Corporation?s records. Additionally, for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommended someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Assistance Listing Number, Federal Agency, and Program Name - 84.425, U.S. Department of Education, Education Stabalization Fund Federal Award Identification Number and Year - P425E203325 - Various Pass-through Entity - N/A Finding Type: Significant Deficiency Repeat Finding - No Criteria - 2 CFR 200.302(a) indicates that a non-federal entity's financial management system includes records documenting compliance with Federal statutes, regulations must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions. 2 CFR 200.303(a) requires non-federal entities to 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. And 2 CFR 200.334 requires that 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. Condition - The College did not retain underlying support related to the student emergency grants information reported by the College on the annual and quarterly reporting. Questioned Costs - There were no questioned costs identified. Identification of How Questioned Costs Were Computed - N/A Context: The quarterly student reports were posted to the College's website for each quarter in fiscal year 2022 and the annual report covering the period from January 1, 2021 through December 31, 2021 was submitted to the Department of Education. However, the College did not maintain the supporting documents for the information reported. Cause and Effect - The College's processes and controls were not designed effectively in order to ensure appropriate record retention related to reporting completed throughout the year. The failure to establish an effective internal control led to the inabiltiy to provide supporting documentation for key information reported during the year. Recommendation - We recommend the College retains underlying supporting records used to substantiate reporting for the timeframe required by the regulations, as stated above. Views of Responsible Officials and Corrective Action Plan - Support used for reporting will be retained for all future reports moving forward including the fourth quarter 2022 report and the 2022 annual report.
Assistance Listing Number, Federal Agency, and Program Name - 84.425, U.S. Department of Education, Education Stabalization Fund Federal Award Identification Number and Year - P425E203325 - Various Pass-through Entity - N/A Finding Type: Significant Deficiency Repeat Finding - No Criteria - 2 CFR 200.302(a) indicates that a non-federal entity's financial management system includes records documenting compliance with Federal statutes, regulations must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions. 2 CFR 200.303(a) requires non-federal entities to 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. And 2 CFR 200.334 requires that 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. Condition - The College did not retain underlying support related to the student emergency grants information reported by the College on the annual and quarterly reporting. Questioned Costs - There were no questioned costs identified. Identification of How Questioned Costs Were Computed - N/A Context: The quarterly student reports were posted to the College's website for each quarter in fiscal year 2022 and the annual report covering the period from January 1, 2021 through December 31, 2021 was submitted to the Department of Education. However, the College did not maintain the supporting documents for the information reported. Cause and Effect - The College's processes and controls were not designed effectively in order to ensure appropriate record retention related to reporting completed throughout the year. The failure to establish an effective internal control led to the inabiltiy to provide supporting documentation for key information reported during the year. Recommendation - We recommend the College retains underlying supporting records used to substantiate reporting for the timeframe required by the regulations, as stated above. Views of Responsible Officials and Corrective Action Plan - Support used for reporting will be retained for all future reports moving forward including the fourth quarter 2022 report and the 2022 annual report.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund (ESSER) ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 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." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER and GEER grant awards. The first report was for the period of March 13, 2020, to September 30, 2020, and was due by January 21, 2021. The second report was for the period of October 1, 2020, to June 30, 2021, and was due by May 13, 2022. We noted the amount reported on the first Annual Data Report did not agree to underlying detail. The amount reported on the annual data report for the ESSER I fund of $70,616 did not agree to the underlying detail of $21,593. The amounts reported on the second Annual Data Report agreed to the underlying detail. Additionally, we noted for the first report submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. The second report was properly reviewed before submission. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund (ESSER) ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 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." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER and GEER grant awards. The first report was for the period of March 13, 2020, to September 30, 2020, and was due by January 21, 2021. The second report was for the period of October 1, 2020, to June 30, 2021, and was due by May 13, 2022. We noted the amount reported on the first Annual Data Report did not agree to underlying detail. The amount reported on the annual data report for the ESSER I fund of $70,616 did not agree to the underlying detail of $21,593. The amounts reported on the second Annual Data Report agreed to the underlying detail. Additionally, we noted for the first report submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. The second report was properly reviewed before submission. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.