Finding 2022-001 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: 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 Annual Data Reports required to be submitted could have incomplete or inaccurate data without a secondary, documented review process 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 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-001 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: 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 Annual Data Reports required to be submitted could have incomplete or inaccurate data without a secondary, documented review process 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 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-001 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: 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 Annual Data Reports required to be submitted could have incomplete or inaccurate data without a secondary, documented review process 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 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-001 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: 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 Annual Data Reports required to be submitted could have incomplete or inaccurate data without a secondary, documented review process 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 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.
Criteria or specific requirement (including statutory, regulatory, or other citation): The grant agreement requires quarterly cumulative expenditure reports and a final completion report, consistent with the financial reporting provisions of the Uniform Guidance (2 CFR section 200.328). Condition: Quarterly cumulative expenditure reports and the final completion report, which are typically due within 30 days of the period end, were materially accurate but were filed late, or not at all, as noted below: 1.The quarterly expenditure report for 7/1/21-9/30/21, for $557,513, was submitted on 6/21/22. 2. The quarterly expenditure report for 10/1/21-12/31/21, for $137,492, was submitted on 6/25/22. 3. The quarterly expenditure report for 1/1/22-3/31/22, for $70,291, was submitted on 6/30/22. 4. The quarterly expenditure report for 4/1/22-6/30/22 was not submitted. Questioned Costs: None noted. Context: Late quarterly expenditure report submissions were also noted on several other federal grant programs, including Title I grants, in which reports were filed up to 9 months past the respective due dates. The quarterly expenditure report for 4/1/22-6/30/22 was later submitted under the ESSER II project year 2023 grant. Effect As this grant operates on a reimbursement basis, except for an overpayment in fiscal year 2021 resulting in advance funding of $286,522 at June 30, 2021, the District taxpayers had to carry the costs of the program expenditures for far longer than necessary. The District was unable to reconcile grant expenditures recorded in the general ledger with those that were to be claimed under the ESSER II grant during the year, putting the District at risk of submitting claims for duplicated expenditures or of not claiming eligible expenditures. As a result of late filing, the quarterly expenditure report for 4/1/22-6/30/22 was unable to be submitted for reimbursement under the project year 2021 grant, as the project year had been closed by ISBE in September 2022 in preparation for the rollover to project year 2023. Cause: The District did not have internal controls in place or allocate adequate resources to ensure timely grant reporting could be achieved. Recommendation: The District should implement internal controls over grant expenditure reporting and allocate adequate resources to ensure that all eligible grant expenditures are appropriately submitted for reimbursement in a timely manner. Management's response: See Corrective Action Plan.
"COVID-19 Higher Education Emergency Relief Fund Program Assistance Lising Number 84.425E COVID-19 Relief Fund for Student Aid U.S. Department of Education Program Year 2021-2022" Criteria or specific requirement ? Quarterly Public Reporting for (a)(1) Student Aid Portion 2 CFR Sections 200.328 and 200.329. Condition ? University did not disclose on their website the estimated total number of students at the institution that are eligible to receive Emergency Financial Aid Grants to Students under the ARP (a)(1) subprogram. Questioned costs ? None Context ? Out of the population of nine special reporting requirements for the fiscal year, a sample of three reports were selected for testing. For the Q2 public reporting for Student Aid Portion, the estimated total number of students at the institution that were eligible to receive Emergency Financial Aid Grants to Students under the ARP (a)(1) subprogram was not publicly posted to the institution's website. This sample was not a statistically valid sample. Effect ? The public was not notified of of the estimated total number of students at the institution that were eligible to receive Emergency Financial Aid Grants to Students under the ARP (a)(1) subprogram in a timely or accurate manner. Cause ? Personnel responsible for reporting overlooked the public posting requirement of grant information for HEERF grantees as noted in 86 FR 26213. Indication as a repeat finding ? N/A Recommendation ? The University should review its procedures for publicly reporting the Student Aid Portion in accordance with 86 FR 26213.
Program Information: AL #: 93.243 U.S. Department of Health and Human Services SAMHSA Youth Programs ? Youth Tree, Youth Suicide Prevention, Youth Connections Project Award Numbers: 6H79TI081193-01, 1H79SM082124-01, 1H79SM081540-01 Award Periods: 9/30/18-9/29/23, 6/30/19-6/29/24, 9/30/18-9/29/23 Criteria: Internal control is a process, effected by an entity?s?[governing body], management and other personnel, designed to provide reasonable assurance regarding the achievement of objectives related to operations, reporting, and compliance. (Internal Control ? Integrated Framework, Committee of Sponsoring Organizations of the Treadway Commission, May 2013, p. 1) Monitoring and reporting program performance, 2 CFR section 200.328. The following reports are required to be submitted for this program: ? Annual Programmatic Progress Report for each award ? Annual SF-425 Report for each award Condition/Context: During testing of internal controls over the Annual Progress reports, 2 of 3 reports did not have documentation of review and approval. [ ] Compliance Finding [ ] Significant Deficiency [ X ] Material Weakness Cause: There were ineffective controls in place during the period to ensure reports were documented as being approved prior to submission, along with lack of management oversight. Effect: Without effective internal controls over reporting, information reported to federal agencies may be inaccurate. Questioned Costs: Not applicable. Repeat Finding: No. Recommendation: We recommend that the Clinic improve controls over the reporting function, which includes the documentation, review and approval of all required reports. Views of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
The Lawrence County Fiscal Court Did Not Establish And Maintain Effective Internal Controls Over Compliance With Coronavirus State and Local Fiscal Recovery Fund (SLFRF) Requirements Federal Program: Assistance Listing #: 21.027 COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Award Number and Year: 2022 Name of Federal Agency: U.S. Department of the Treasury Compliance Requirements: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Reporting Type of Finding: Significant Deficiency Amount of Questioned Costs: $0 COVID Related: Yes The Lawrence County Fiscal Court transferred federal funds from the ARPA fund to the general, jail, road, LGEA, and E-911 funds without first ensuring sufficient supporting documentation of allowable expenditures during the same period as the funds were reported as expended on the Schedule of Expenditures of Federal Awards (SEFA). The county was awarded $2,975,148 in American Rescue Plan Act (ARPA) funds, receiving the first payment of $1,487,618 into the ARPA fund in May 2021, and their second payment of $1,487,530 in June 2022.The fiscal court?s transfers in total from the ARPA fund to each fund are provided below: ? General - $714,640 ? Road - $250,000 ? Jail - $40,000 ? LGEA - $25,000 ? E-911 - $10,000 ? Payroll - $217,739 These transfers from the ARPA fund were considered ?lost revenue? according to their fiscal court meeting minutes. At the time of these transfers, and until auditors inquired about the supporting documentation, the county did not maintain a list of expenditures that reconciled to the transfer total. After this inquiry, the county gathered documentation and provided auditors a reconciliation of expenditures of eligible costs that supported the amount transferred into the general fund. An effective internal control system was not in place in Lawrence County to ensure compliance with requirements related to the administration of ARPA funds and the Allowable Costs/Cost Principles compliance requirements. The lack of internal controls was a systemic issue throughout the period. Failure to establish and maintain effective internal controls over compliance with federal program requirements could subject the county to the risk of reporting ineligible expenditures on the SEFA and using grant funds for unallowable purposes. 2 CFR 200.303 states in part, ?[t]he 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.? 2 CFR ?200.302(b) states, ?[t]he financial management system of each non-Federal entity must provide for the following ?: (2) [a]ccurate, current and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set for in ?200.328 and 200.329.? In addition, 2 CFR ?200.502(a) states, ?[t]he determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.? Therefore, the county should only include expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for which there is sufficient supporting documentation. We recommend the county establish and maintain internal controls over compliance for all federal program expenditures to ensure accurate use and reporting of federal awards, including maintaining sufficient supporting documentation of expenditures that reconciles to any transfer from a federal program fund into other county funds.
2022-004 Department of Education Federal Financial Assistance Listing 84.425E, 84.425F, 84.425K Federal Award Numbers P425E201501, P425E201757, P425E200021, award year 2021 COVID-19 Education Stabilization Fund - Higher Education Emergency Relief Fund (HEERF) Reporting Material Weakness in Internal Control over Compliance and Material Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. 2 CFR 200.327 and 2 CFR 200.328 require the auditee to collect financial information and monitor its activities under federal awards to assure compliance with applicable federal requirements and performance expectations are being achieved and report these items in accordance with the program requirements. Condition: In our sample of reports selected for testing, we noted the following items; a) No support could be provided to substantiate a secondary level of review was completed for student and institutional portion quarterly reports for the quarters ended 12/31/2021 and 3/31/2022 and the year two annual report. b) Student portion quarterly reports ending 12/31/2021 and 3/31/2022 reported cumulative expenditures incurred from the inception of the federal program rather than expenditures incurred within the quarter, resulting in an error of $105,202 in the first report and $165,154 in the second report. Cause: There was a lapse in oversight of the internal control process ensuring expenditures reported were accurate and reconciled to supporting documentation. The College failed to identify the change in reporting requirements between HEERF awards. Effect: The College?s controls did not detect or correct the errors identified, which resulted in inaccurate expenditures reported within HEERF quarterly reports. Additionally, not having a formal oversight process over reporting results in a reasonable possibility that reports that are inaccurate or incomplete could be submitted. Questioned Costs: None reported. Context/Sampling: Four out of eight quarterly reports were reviewed along with one annual report. Repeat Finding from Prior Year: Yes, prior year finding 2021-003. Recommendation: We recommend that management implement procedures and control processes to comply with the federal requirements noted above and ensure documentation is retained supporting a secondary level of review is completed prior to submission of required reports. Views of Responsible Officials: Management is in agreement with the finding.
2022-004 Department of Education Federal Financial Assistance Listing 84.425E, 84.425F, 84.425K Federal Award Numbers P425E201501, P425E201757, P425E200021, award year 2021 COVID-19 Education Stabilization Fund - Higher Education Emergency Relief Fund (HEERF) Reporting Material Weakness in Internal Control over Compliance and Material Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. 2 CFR 200.327 and 2 CFR 200.328 require the auditee to collect financial information and monitor its activities under federal awards to assure compliance with applicable federal requirements and performance expectations are being achieved and report these items in accordance with the program requirements. Condition: In our sample of reports selected for testing, we noted the following items; a) No support could be provided to substantiate a secondary level of review was completed for student and institutional portion quarterly reports for the quarters ended 12/31/2021 and 3/31/2022 and the year two annual report. b) Student portion quarterly reports ending 12/31/2021 and 3/31/2022 reported cumulative expenditures incurred from the inception of the federal program rather than expenditures incurred within the quarter, resulting in an error of $105,202 in the first report and $165,154 in the second report. Cause: There was a lapse in oversight of the internal control process ensuring expenditures reported were accurate and reconciled to supporting documentation. The College failed to identify the change in reporting requirements between HEERF awards. Effect: The College?s controls did not detect or correct the errors identified, which resulted in inaccurate expenditures reported within HEERF quarterly reports. Additionally, not having a formal oversight process over reporting results in a reasonable possibility that reports that are inaccurate or incomplete could be submitted. Questioned Costs: None reported. Context/Sampling: Four out of eight quarterly reports were reviewed along with one annual report. Repeat Finding from Prior Year: Yes, prior year finding 2021-003. Recommendation: We recommend that management implement procedures and control processes to comply with the federal requirements noted above and ensure documentation is retained supporting a secondary level of review is completed prior to submission of required reports. Views of Responsible Officials: Management is in agreement with the finding.
2022-004 Department of Education Federal Financial Assistance Listing 84.425E, 84.425F, 84.425K Federal Award Numbers P425E201501, P425E201757, P425E200021, award year 2021 COVID-19 Education Stabilization Fund - Higher Education Emergency Relief Fund (HEERF) Reporting Material Weakness in Internal Control over Compliance and Material Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. 2 CFR 200.327 and 2 CFR 200.328 require the auditee to collect financial information and monitor its activities under federal awards to assure compliance with applicable federal requirements and performance expectations are being achieved and report these items in accordance with the program requirements. Condition: In our sample of reports selected for testing, we noted the following items; a) No support could be provided to substantiate a secondary level of review was completed for student and institutional portion quarterly reports for the quarters ended 12/31/2021 and 3/31/2022 and the year two annual report. b) Student portion quarterly reports ending 12/31/2021 and 3/31/2022 reported cumulative expenditures incurred from the inception of the federal program rather than expenditures incurred within the quarter, resulting in an error of $105,202 in the first report and $165,154 in the second report. Cause: There was a lapse in oversight of the internal control process ensuring expenditures reported were accurate and reconciled to supporting documentation. The College failed to identify the change in reporting requirements between HEERF awards. Effect: The College?s controls did not detect or correct the errors identified, which resulted in inaccurate expenditures reported within HEERF quarterly reports. Additionally, not having a formal oversight process over reporting results in a reasonable possibility that reports that are inaccurate or incomplete could be submitted. Questioned Costs: None reported. Context/Sampling: Four out of eight quarterly reports were reviewed along with one annual report. Repeat Finding from Prior Year: Yes, prior year finding 2021-003. Recommendation: We recommend that management implement procedures and control processes to comply with the federal requirements noted above and ensure documentation is retained supporting a secondary level of review is completed prior to submission of required reports. Views of Responsible Officials: Management is in agreement with the finding.
Finding 2022-003 ? Significant Deficiency, Compliance and Control Federal Assistance Listing No. 84.425E U.S. Department Of Education ESF Section 2 ? Higher Education (Higher Education Emergency Relief Fund (HEERF)) - Reporting Criteria: 2 CFR section 200.328 and 2 CFR section 200.329 requires grantees to submit quarterly reports for both student and institutional portions along with an annual report to the Department of Education. Condition: In our nonstatistical testing of 2 quarterly reports and 1 annual report, it was noted that for the one student report selected, the University excluded a subset of non-Title IV eligible students from the estimated total number of students at the institution that are eligible to receive Emergency Financial Aid Grants to Students under the CARES (a)(1) subprogram and the CRRSAA and ARP (a)(1) subprograms. Cause: Management based the reporting requirement on the HEERF 1 guidance, which had more stringent eligibility requirements, in reporting the estimated total number of students at the institution that are eligible to receive Emergency Financial Aid Grants to Students under the CARES (a)(1) subprogram and the CRRSAA and ARP (a)(1) subprograms. Effect: The estimated total number of students at the institution eligible to receive emergency financial aid grants to students reported was less than the actual by approximately 400 students. Questioned Costs: Not applicable Context: One item on the selected student report was not reported in conformity with the guidance. Identification As A Repeat Finding: Not a repeat finding. Recommendation: We recommend that management develop a system with appropriate controls that allows for implementing the most recent guidance on HEERF reporting. Views Of Responsible Officials/Corrective Action Plan (Unaudited): The Controller and Compliance Officers are working together to correct the previously filed reports to update the estimated total number of students at the institution that are eligible to receive Emergency Financial Aid Grants to Students under the CARES (a)(1) subprogram and the CRRSAA and ARP (a)(1) subprograms. Completion Date: April 2023 Contact Person: Tom Corley, Controller and Director of Fiscal Operations and Carrie Stevens, Associate Vice President of Compliance
Finding 2022-003 ? Significant Deficiency, Compliance and Control Federal Assistance Listing No. 84.425E U.S. Department Of Education ESF Section 2 ? Higher Education (Higher Education Emergency Relief Fund (HEERF)) - Reporting Criteria: 2 CFR section 200.328 and 2 CFR section 200.329 requires grantees to submit quarterly reports for both student and institutional portions along with an annual report to the Department of Education. Condition: In our nonstatistical testing of 2 quarterly reports and 1 annual report, it was noted that for the one student report selected, the University excluded a subset of non-Title IV eligible students from the estimated total number of students at the institution that are eligible to receive Emergency Financial Aid Grants to Students under the CARES (a)(1) subprogram and the CRRSAA and ARP (a)(1) subprograms. Cause: Management based the reporting requirement on the HEERF 1 guidance, which had more stringent eligibility requirements, in reporting the estimated total number of students at the institution that are eligible to receive Emergency Financial Aid Grants to Students under the CARES (a)(1) subprogram and the CRRSAA and ARP (a)(1) subprograms. Effect: The estimated total number of students at the institution eligible to receive emergency financial aid grants to students reported was less than the actual by approximately 400 students. Questioned Costs: Not applicable Context: One item on the selected student report was not reported in conformity with the guidance. Identification As A Repeat Finding: Not a repeat finding. Recommendation: We recommend that management develop a system with appropriate controls that allows for implementing the most recent guidance on HEERF reporting. Views Of Responsible Officials/Corrective Action Plan (Unaudited): The Controller and Compliance Officers are working together to correct the previously filed reports to update the estimated total number of students at the institution that are eligible to receive Emergency Financial Aid Grants to Students under the CARES (a)(1) subprogram and the CRRSAA and ARP (a)(1) subprograms. Completion Date: April 2023 Contact Person: Tom Corley, Controller and Director of Fiscal Operations and Carrie Stevens, Associate Vice President of Compliance
Finding 2022-003 ? Significant Deficiency, Compliance and Control Federal Assistance Listing No. 84.425E U.S. Department Of Education ESF Section 2 ? Higher Education (Higher Education Emergency Relief Fund (HEERF)) - Reporting Criteria: 2 CFR section 200.328 and 2 CFR section 200.329 requires grantees to submit quarterly reports for both student and institutional portions along with an annual report to the Department of Education. Condition: In our nonstatistical testing of 2 quarterly reports and 1 annual report, it was noted that for the one student report selected, the University excluded a subset of non-Title IV eligible students from the estimated total number of students at the institution that are eligible to receive Emergency Financial Aid Grants to Students under the CARES (a)(1) subprogram and the CRRSAA and ARP (a)(1) subprograms. Cause: Management based the reporting requirement on the HEERF 1 guidance, which had more stringent eligibility requirements, in reporting the estimated total number of students at the institution that are eligible to receive Emergency Financial Aid Grants to Students under the CARES (a)(1) subprogram and the CRRSAA and ARP (a)(1) subprograms. Effect: The estimated total number of students at the institution eligible to receive emergency financial aid grants to students reported was less than the actual by approximately 400 students. Questioned Costs: Not applicable Context: One item on the selected student report was not reported in conformity with the guidance. Identification As A Repeat Finding: Not a repeat finding. Recommendation: We recommend that management develop a system with appropriate controls that allows for implementing the most recent guidance on HEERF reporting. Views Of Responsible Officials/Corrective Action Plan (Unaudited): The Controller and Compliance Officers are working together to correct the previously filed reports to update the estimated total number of students at the institution that are eligible to receive Emergency Financial Aid Grants to Students under the CARES (a)(1) subprogram and the CRRSAA and ARP (a)(1) subprograms. Completion Date: April 2023 Contact Person: Tom Corley, Controller and Director of Fiscal Operations and Carrie Stevens, Associate Vice President of Compliance
FINDING 2022-009 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U200013 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 nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation completed and submitted four annual Data Collection reports (Reports) for the Elementary and Secondary School Emergency Relief (ESSER) grants and two Reports for the Governors Emergency Education Relief (GEER) grant. 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 and GEER I, Year 1 Report The full-time equivalent (FTE) positions could not be verified. A spreadsheet that showed FTE positions was provided for audit; however, the spreadsheet had more FTE positions then what was reported due to the School Corporations software incorrectly assigning FTE positions to all items paid. ESSER III, Year 1 Report The School Corporation's ledgers indicated expenses totaling $43,084 were spent for salaries and stipends during the reporting period. However, these expenditures were not included in the report. 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.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." 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. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and 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 effective 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-009 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U200013 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 nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation completed and submitted four annual Data Collection reports (Reports) for the Elementary and Secondary School Emergency Relief (ESSER) grants and two Reports for the Governors Emergency Education Relief (GEER) grant. 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 and GEER I, Year 1 Report The full-time equivalent (FTE) positions could not be verified. A spreadsheet that showed FTE positions was provided for audit; however, the spreadsheet had more FTE positions then what was reported due to the School Corporations software incorrectly assigning FTE positions to all items paid. ESSER III, Year 1 Report The School Corporation's ledgers indicated expenses totaling $43,084 were spent for salaries and stipends during the reporting period. However, these expenditures were not included in the report. 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.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." 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. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and 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 effective 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-009 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U200013 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 nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation completed and submitted four annual Data Collection reports (Reports) for the Elementary and Secondary School Emergency Relief (ESSER) grants and two Reports for the Governors Emergency Education Relief (GEER) grant. 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 and GEER I, Year 1 Report The full-time equivalent (FTE) positions could not be verified. A spreadsheet that showed FTE positions was provided for audit; however, the spreadsheet had more FTE positions then what was reported due to the School Corporations software incorrectly assigning FTE positions to all items paid. ESSER III, Year 1 Report The School Corporation's ledgers indicated expenses totaling $43,084 were spent for salaries and stipends during the reporting period. However, these expenditures were not included in the report. 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.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." 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. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and 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 effective 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-009 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U200013 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 nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation completed and submitted four annual Data Collection reports (Reports) for the Elementary and Secondary School Emergency Relief (ESSER) grants and two Reports for the Governors Emergency Education Relief (GEER) grant. 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 and GEER I, Year 1 Report The full-time equivalent (FTE) positions could not be verified. A spreadsheet that showed FTE positions was provided for audit; however, the spreadsheet had more FTE positions then what was reported due to the School Corporations software incorrectly assigning FTE positions to all items paid. ESSER III, Year 1 Report The School Corporation's ledgers indicated expenses totaling $43,084 were spent for salaries and stipends during the reporting period. However, these expenditures were not included in the report. 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.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." 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. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and 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 effective 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.
Program Information: AL #: 93.243 U.S. Department of Health and Human Services SAMHSA Youth Programs ? Youth Tree, Youth Suicide Prevention, Youth Connections Project Award Numbers: 6H79TI081193-01, 1H79SM082124-01, 1H79SM081540-01 Award Periods: 9/30/18-9/29/23, 6/30/19-6/29/24, 9/30/18-9/29/23 Criteria: Internal control is a process, effected by an entity?s?[governing body], management and other personnel, designed to provide reasonable assurance regarding the achievement of objectives related to operations, reporting, and compliance. (Internal Control ? Integrated Framework, Committee of Sponsoring Organizations of the Treadway Commission, May 2013, p. 1) Monitoring and reporting program performance, 2 CFR section 200.328. The following reports are required to be submitted for this program: ? Annual Programmatic Progress Report for each award ? Annual SF-425 Report for each award Condition/Context: During testing of internal controls over the Annual Progress reports, 2 of 3 reports did not have documentation of review and approval. [ ] Compliance Finding [ ] Significant Deficiency [ X ] Material Weakness Cause: There were ineffective controls in place during the period to ensure reports were documented as being approved prior to submission, along with lack of management oversight. Effect: Without effective internal controls over reporting, information reported to federal agencies may be inaccurate. Questioned Costs: Not applicable. Repeat Finding: No. Recommendation: We recommend that the Clinic improve controls over the reporting function, which includes the documentation, review and approval of all required reports. Views of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: AL #: 93.243 U.S. Department of Health and Human Services SAMHSA Youth Programs ? Youth Tree, Youth Suicide Prevention, Youth Connections Project Award Numbers: 6H79TI081193-01, 1H79SM082124-01, 1H79SM081540-01 Award Periods: 9/30/18-9/29/23, 6/30/19-6/29/24, 9/30/18-9/29/23 Criteria: Internal control is a process, effected by an entity?s?[governing body], management and other personnel, designed to provide reasonable assurance regarding the achievement of objectives related to operations, reporting, and compliance. (Internal Control ? Integrated Framework, Committee of Sponsoring Organizations of the Treadway Commission, May 2013, p. 1) Monitoring and reporting program performance, 2 CFR section 200.328. The following reports are required to be submitted for this program: ? Annual Programmatic Progress Report for each award ? Annual SF-425 Report for each award Condition/Context: During testing of internal controls over the Annual Progress reports, 2 of 3 reports did not have documentation of review and approval. [ ] Compliance Finding [ ] Significant Deficiency [ X ] Material Weakness Cause: There were ineffective controls in place during the period to ensure reports were documented as being approved prior to submission, along with lack of management oversight. Effect: Without effective internal controls over reporting, information reported to federal agencies may be inaccurate. Questioned Costs: Not applicable. Repeat Finding: No. Recommendation: We recommend that the Clinic improve controls over the reporting function, which includes the documentation, review and approval of all required reports. Views of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
2022-001 U.S. Department of the Treasury COVID-19 ? Coronavirus State and Local Fiscal Recovery Funds ? CFDA 21.027 Criteria: Per 2 CFR section 200.328 of the Uniform Guidance, each recipient must report program outlays and program income on a cash or accrual basis, as prescribed by the federal awarding agency. The compliance supplement identifies four Key Line Items required to be reported to the federal awarding agency which include (1) current period obligation, (2) cumulative obligation, (3) current period expenditure and (4) cumulative expenditure. Condition: As of the March 31, 2022 reporting date, the Town expended $137,500 related to first responder bonuses. However, no obligations or expenditures were reported in the Project and Expenditure report. Cause: The Town did not reconcile the Project and Expenditure report with the Town?s general ledger before submitting. Effect: The Town did not properly report grant expenditures in the Project and Expenditure report. Questioned Costs: None Repeat Finding from Prior Year: No Recommendation: The Town should implement procedures to reconcile the financial information in the Project and Expenditure reports to the Town?s general ledger before submission. Views of Responsible Official: Management agrees with the finding.
FINDING 2022-008 Information on the federal program: Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425C200018 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Significant Deficiency 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 reasonableassurance 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 incompliance with guidance in 'Standards for Internal Control in the Federal Government' issued by theComptroller General of the United States or the 'Internal Control Integrated Framework', issued by theCommittee 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 inaccordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . ." 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 requirement. Cause: Management had not developed an effective 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 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: The School Corporation did not have an effective system of internal controls 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 accurately submitted. The School Corporation had six annual data reports due during the audit period. The Full Time Equivalent (FTE) key line item on both the ESSER I, Fiscal Year 2021 and the GEER, Fiscal Year 2021 annual Data Collection reports were not accurately submitted. The lack of internal controls and noncompliance were isolated to the ESSER 1, Fiscal Year 2021 and GEER, Fiscal Year 2021 reports. Identification as a repeat finding, if applicable: No Recommendation: We recommend that the School Corporation's management establish effective 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-008 Information on the federal program: Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425C200018 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Significant Deficiency 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 reasonableassurance 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 incompliance with guidance in 'Standards for Internal Control in the Federal Government' issued by theComptroller General of the United States or the 'Internal Control Integrated Framework', issued by theCommittee 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 inaccordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . ." 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 requirement. Cause: Management had not developed an effective 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 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: The School Corporation did not have an effective system of internal controls 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 accurately submitted. The School Corporation had six annual data reports due during the audit period. The Full Time Equivalent (FTE) key line item on both the ESSER I, Fiscal Year 2021 and the GEER, Fiscal Year 2021 annual Data Collection reports were not accurately submitted. The lack of internal controls and noncompliance were isolated to the ESSER 1, Fiscal Year 2021 and GEER, Fiscal Year 2021 reports. Identification as a repeat finding, if applicable: No Recommendation: We recommend that the School Corporation's management establish effective 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-008 Information on the federal program: Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425C200018 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Significant Deficiency 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 reasonableassurance 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 incompliance with guidance in 'Standards for Internal Control in the Federal Government' issued by theComptroller General of the United States or the 'Internal Control Integrated Framework', issued by theCommittee 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 inaccordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . ." 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 requirement. Cause: Management had not developed an effective 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 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: The School Corporation did not have an effective system of internal controls 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 accurately submitted. The School Corporation had six annual data reports due during the audit period. The Full Time Equivalent (FTE) key line item on both the ESSER I, Fiscal Year 2021 and the GEER, Fiscal Year 2021 annual Data Collection reports were not accurately submitted. The lack of internal controls and noncompliance were isolated to the ESSER 1, Fiscal Year 2021 and GEER, Fiscal Year 2021 reports. Identification as a repeat finding, if applicable: No Recommendation: We recommend that the School Corporation's management establish effective 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-008 Information on the federal program: Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425C200018 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Significant Deficiency 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 reasonableassurance 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 incompliance with guidance in 'Standards for Internal Control in the Federal Government' issued by theComptroller General of the United States or the 'Internal Control Integrated Framework', issued by theCommittee 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 inaccordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . ." 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 requirement. Cause: Management had not developed an effective 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 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: The School Corporation did not have an effective system of internal controls 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 accurately submitted. The School Corporation had six annual data reports due during the audit period. The Full Time Equivalent (FTE) key line item on both the ESSER I, Fiscal Year 2021 and the GEER, Fiscal Year 2021 annual Data Collection reports were not accurately submitted. The lack of internal controls and noncompliance were isolated to the ESSER 1, Fiscal Year 2021 and GEER, Fiscal Year 2021 reports. Identification as a repeat finding, if applicable: No Recommendation: We recommend that the School Corporation's management establish effective 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-005 Information on the federal program: Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: National School Lunch Program Assistance Listing Number: 10.555 Federal Award Numbers and Years (or Other Identifying Numbers): FY 20-21, FY 21-22 Pass-Through Entity: Indiana Department of Education Compliance Requirements: 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 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 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." 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 Child Nutrition Cluster - Reporting compliance requirements. Section III ? Federal Award Findings and Questioned Costs (Continued) FINDING 2021-005 (Continued) Cause: Management had not developed 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 internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Reporting compliance requirement. Questioned Costs: There were no questioned costs identified. Context: There was no documented control in place over the preparation/submission of monthly CNC reimbursement claims. The Food Service Director prepares the monthly reimbursement claims, however, there was no documentation that the reimbursement claims had been reviewed anyone other than the preparer. This was a systemic issue through the audit period. Identification as a repeat finding: No. Recommendation: We recommended that the School Corporation's management establish a documented system of internal control for review and approval related to the grant?s reporting compliance requirements Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-005 Information on the federal program: Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: National School Lunch Program Assistance Listing Number: 10.555 Federal Award Numbers and Years (or Other Identifying Numbers): FY 20-21, FY 21-22 Pass-Through Entity: Indiana Department of Education Compliance Requirements: 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 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 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." 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 Child Nutrition Cluster - Reporting compliance requirements. Section III ? Federal Award Findings and Questioned Costs (Continued) FINDING 2021-005 (Continued) Cause: Management had not developed 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 internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Reporting compliance requirement. Questioned Costs: There were no questioned costs identified. Context: There was no documented control in place over the preparation/submission of monthly CNC reimbursement claims. The Food Service Director prepares the monthly reimbursement claims, however, there was no documentation that the reimbursement claims had been reviewed anyone other than the preparer. This was a systemic issue through the audit period. Identification as a repeat finding: No. Recommendation: We recommended that the School Corporation's management establish a documented system of internal control for review and approval related to the grant?s reporting compliance requirements Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
2022-001 Untimely and Inaccurate Reporting - Significant Deficiency Department of Education ALN #: 84.425E and 84.425F Criteria: Per 2 CFR section 200.328 and 2 CFR section 200.329, the College must accurately complete quarterly reports and post the completed forms to a publicly accessible location on the College?s website within 10 days of a quarter end. Condition: The College did not accurately complete and/or post three of the four quarterly reports to a publicly accessible location on the College?s website for the period July 1, 2021 through June 30, 2022. Cause: Turnover in the Vice President of Finance position responsible for report preparation combined with inadequate controls in place to review the quarterly reports for accuracy prior to posting to the College?s website. Questioned Costs: N/A Effect: The College was not in compliance with reporting requirements applicable to the HEERF program. Recommendation: Management should revise the quarterly reports, as applicable, noting the changes and post the revised reports to the College?s website. Management should submit copies of the revised report to HEERF reporting through the Department of Education. Management Response: Management agrees with this finding. Refer to the accompanying corrective action plan for additional information.
2022-001 Untimely and Inaccurate Reporting - Significant Deficiency Department of Education ALN #: 84.425E and 84.425F Criteria: Per 2 CFR section 200.328 and 2 CFR section 200.329, the College must accurately complete quarterly reports and post the completed forms to a publicly accessible location on the College?s website within 10 days of a quarter end. Condition: The College did not accurately complete and/or post three of the four quarterly reports to a publicly accessible location on the College?s website for the period July 1, 2021 through June 30, 2022. Cause: Turnover in the Vice President of Finance position responsible for report preparation combined with inadequate controls in place to review the quarterly reports for accuracy prior to posting to the College?s website. Questioned Costs: N/A Effect: The College was not in compliance with reporting requirements applicable to the HEERF program. Recommendation: Management should revise the quarterly reports, as applicable, noting the changes and post the revised reports to the College?s website. Management should submit copies of the revised report to HEERF reporting through the Department of Education. Management Response: Management agrees with this finding. Refer to the accompanying corrective action plan for additional information.
Criteria or Specific Requirement: The Code of Federal Regulations, 2 CFR 200.303, non-Federal entities receiving Federal awards are required to establish and maintain internal controls designed to reasonably ensure compliance with federal laws, regulations and program compliance requirements. There are three components to reporting for Higher Education Emergency Relief Funds (HEERF): 1) public reporting on the (a)(1) Student Aid Portion; 2) public reporting on the (a)(1) Institutional Portion (a)(2) and (a)(3) subprograms (Quarterly Reporting Form), as applicable; and 3) the annual report. The CARES Act 18004(e) and the CRRSAA 314(e) requires an institution receiving funds under HEERF I and HEERF II to submit a report to the secretary, at such time in such a manner as the secretary may require. While ARP does not explicitly identify procedures by which institutions must report on their uses of HEERF grant funds, the Department of Education exercises this reporting authority under 2 CFR section 200.328 and 2 CFR section 200.329. Specific to the quarterly reports, institutions are required to post two separate reports (institutional and student) for each quarter, including the quarterly reports from previous quarters. Quarterly reports should appear on the institution?s website as separate documents by quarter and should not be cumulative. Condition: The University is not in compliance with Student Aid quarterly reporting requirements for HEERF. Questioned Costs: None Context: We tested two of the four required Student Aid Quarterly Reports. While management was able to provide ?look back? reports for our testing, and we concluded the reports tested were completed accurately and timely, we noted that the Student Aid Quarterly Reports were not being maintained on the University?s website as required. We did note that the Institutional Quarterly Reports were being maintained on the Institution?s website as required. Cause: The University was not aware that the Student Aid Quarterly Reports were required to be maintained on the University?s website. Effect: The University was not in compliance with requirement to maintain Student Aid Quarterly Reports on the University?s website. Repeat Finding: No Recommendation: We recommend that the University post and maintain the Student Aid Quarterly reports on the University?s website, as required. In addition, in order to prevent similar instances in the future, we recommend the University ensure interpretation of guidance is accurate through the use of trainings, consultations, and direct correspondence with the regulatory agency, when necessary, to ensure full understanding of reporting requirements. View of Responsible Official: The University agrees with the finding.
2022-004 Department of Health and Human Services FFLA #93.087, 90CU0095, 9/30/2018 ? 9/29/2023 Enhance Safety of Children Affected by Substance Abuse Reporting Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. 2 CFR 200.328 and 2 CFR 200.329 require the auditee to collect financial information and monitor its activities under federal awards to assure compliance with applicable federal requirements and performance expectations are being achieved and report these items in accordance with the program requirements. Condition: Through testing of one programmatic report, we noted amounts reported did not agree to supporting documentation. Programmatic information included within the report were included in the wrong category for services provided to adults and children and amounts were included in two categories for services in which no adults or children were provided services. Cause: The preparer of the report improperly inputted the case sizes within the incorrect column within the report and entered incorrect information in two instances. Effect: The report included programmatic information in the wrong categories for services provided and services not provided to adults and children. Questioned Costs: None reported. Context: Included under the award letter of the federal program, one combined quarterly federal cash transaction report was reviewed in the Center?s fiscal year. In addition, one semi-annual federal financial report and one semi-annual programmatic report was reviewed in the Center?s fiscal year. There was a total of 5 reports filed. Repeat Finding from Prior Year: Yes, prior year finding 2021-004 Recommendation: We recommend management review the procedures and control processes surrounding preparation and review of reports to ensure reports are completed based upon supporting documentation. View of Responsible Officials: Management is in agreement.
2022-006 Department of Health and Human Services FFLA #93.829, H79SM083331-02, 5/1/2021 ? 12/31/2022 Section 223 Demonstration Programs to Improve Community Mental Health Services Reporting Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. 2 CFR 200.328 and 2 CFR 200.329 require the auditee to collect financial information and monitor its activities under federal awards to assure compliance with applicable federal requirements and performance expectations are being achieved and report these items in accordance with the program requirements. Condition: Through testing of one programmatic report, we noted the number of adults and children served during the reporting period included six individuals twice. Cause: As a result of a software change during the grant year, management combined the listing of adults and children served from two electronic health record systems and did not identify these six individuals were duplicates in the listings. Effect: The programmatic report included a total of six adults and children serviced during the reporting period twice. Questioned Costs: None reported. Context: Included under the award letter of the federal program, one annual federal financial report and one annual programmatic progress report was reviewed in the Center?s fiscal year. There was a total of 5 reports filed. Repeat Finding from Prior Year: Yes, prior year finding 2021-006 Recommendation: We recommend management review the procedures and control processes surrounding preparation and review of reports to ensure reports are completed based upon supporting documentation. View of Responsible Officials: Management is in agreement.
2022?020 REPORTING Federal Program Information: Federal Agency and Program Name Assistance Listing # U.S. Department of Education Rehabilitation Services?Vocational Rehabilitation Grants to State 84.126 Grant Award H126A200095, H126A210095, H126A220095Criteria: 2 CFR 200.303 requires that a 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 and the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). 2 CFR 200.302(b)(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. If a Federal awarding agency requires reporting on an accrual basis from a recipient that maintains its records on other than an accrual basis, the recipient must not be required to establish an accrual accounting system. This recipient may develop accrual data for its reports on the basis of an analysis of the documentation on hand. Similarly, a pass-through entity must not require a subrecipient to establish an accrual accounting system and must allow the subrecipient to develop accrual data for its reports on the basis of an analysis of the documentation on hand.? Condition: The West Virginia Division of Rehabilitation Services (WVDRS) is responsible for preparing the Rehabilitation Services Administration (RSA-17), Federal Financial Report, quarterly. The RSA-17 is used to track the status of financial data tied to a particular Federal Grant Award. The RSA-17 report should be complete, accurate, and prepared in accordance with the required accounting basis. There was an error in reporting where certain amounts reported did not agree to the underlying data used to prepare the reports. The Director?s review was not precise enough to detect the error. Questioned Costs: N/A Context: Total federal expenditures for the Vocational Rehabilitation Grant were $31,508,101 for the year ended June 30, 2022. Cause: WVDRS has policies and procedures in place to review the RSA-17 prior to submission; however, the review was not precise enough to identify the errors. Effect: Incorrect data could be reported to the RSA. Recommendation: We recommend that WVDRS enforce the existing policies and procedures surrounding the review and approval of the RSA-17 report prior to submission. Views of Responsible Officials: Management acknowledges the finding. See corrective action plan.
Finding Number: 2022-002 Program: COVID-19 Higher Education Emergency Relief Fund (HEERF) Federal Agency Name: U.S. Department of Education Federal Award Year: July 1, 2021 ? June 30, 2022 Federal Assistance Listing Number: 84.425F Criteria There are three components to reporting for HEERF: 1) public reporting on the (a)(1) Student Aid Portion; 2) public reporting on the (a)(1) Institutional Portion (a)(2) and (a)(3) subprograms (Quarterly Reporting Form), as applicable; and 3) the annual report. The CARES Act 18004(e) and the CRRSAA 314(e) require an institution receiving funds under HEERF I and HEERF II to submit a report to the secretary, at such time in such a manner as the secretary may require. While ARP does not explicitly identify procedures by which institutions must report on their uses of HEERF grant funds, ED exercises this reporting authority under 2 CFR section 200.328 and 2 CFR section 200.329. Annual Reporting (all HEERF grantees) ED required an annual report from HEERF grantees in April 2022 that included reporting uses of HEERF I CARES Act funds, HEERF II CRRSAA funds, and HEERF III ARP funds for the 2021 calendar year. Quarterly Public Reporting for (a)(1) Institutional Portion, (a)(2), and (a)(3) funds The CARES, CRRSAA, and ARP institutional quarterly portion reporting requirements involve publicly posting completed forms on the institution?s website. The forms must be conspicuously posted on the institution?s primary website on the same page the reports of the IHE?s activities as to the emergency financial aid grants to students (Student Aid Portion) are posted. IHEs must post this quarterly report form no later than 10 days after the end of each calendar quarter apart from the first report, which was due October 30, 2020, and the report covering the first quarter of 2021, which was due by July 10, 2021. Quarterly Public Reporting for (a)(1) Student Aid Portion ED requires institutions that received Student Aid Portion awards under CARES Act, CRRSAA and ARP to publicly post certain information on their website. Under the requirements to post student aid public reporting for CRRSAA and ARP, there is a requirement to include certain information on their website. Institutions must publicly post their report as soon as possible, but no later than 30 days after the publication of the notice or 30 days after the date ED first obligated funds under HEERF I, II, or III to the institution for Emergency Financial Aid Grants to Students, whichever comes later. The report must be updated not later than 10 days after the end of each calendar quarter. Further, in accordance with 2 CFR 200.303(a), non-federal entities 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. Condition During the year ended June 30, 2022, although all required reporting was found to be accurate and provided on a timely basis, in compliance with the reporting requirements, the College had not implemented a control that specifically addresses the accuracy and timeliness of the required reporting under HEERF. Cause The College?s HEERF reporting process did not include a control designed to monitor the timeliness and accuracy of the required reporting. Although identified as a finding in the prior year, the timing of the identification of this issue did not allow for the management of the College to implement a control that was responsive to the finding. Effect If appropriate controls are not designed and operating effectively over the HEERF reporting process, HEERF expenditures reported on the College?s website and to ED may be incomplete, inaccurate, or not posted within the timeframe required. Questioned Costs None noted. Prior Year Finding Yes ? 2021-001 Recommendation We recommend that the College implement a more thorough and detailed process and related internal controls to ensure timely and accurate reporting required under its Federal programs. Management?s Views Subsequent to June 30, 2022, management has reviewed its reporting requirements under its Federal programs and implemented controls to ensure accuracy and timeliness of required reporting. These include reconciliation of reporting to the College?s accounting records and a review of requirements to ensure timeliness. Anticipated Completion Date Completed ? October 31, 2022 Responsible Persons Gillian King, Chief of Staff
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.
2022-001 U.S. Department of the Treasury COVID-19 ? Coronavirus State and Local Fiscal Recovery Funds - CFDA 21.027 Criteria: Per 2 CFR section 200.328 of the Uniform Guidance, each recipient must report program outlays and program income on a cash or accrual basis, as prescribed by the federal awarding agency. The compliance supplement identifies four Key Line Items required to be reported to the federal awarding agency which include (1) current period obligation, (2) cumulative obligation, (3) current period expenditure and (4) cumulative expenditure. Condition: As of the March 31, 2022, reporting date, the Town reported obligations of $5,044,950 while actual obligations were only $1,134,400. Cause: The Town reported its entire award allotment as obligated due to a misunderstanding of the grant reporting requirements. Effect: The Town?s reporting is overstated. Questioned Costs: None Repeat Finding from Prior Year: No Recommendation: The Town should only report obligations for amounts that represent orders placed for property and services, contracts and subawards made that require payment in the same or future period. Views of Responsible Official: Management agrees with the finding.
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.
Finding: 2022-002 Program Affected: 84.425E, 84.425F Finding Type: Significant deficiency on compliance and control Criteria: The HEERF I, II, and III funding came with various requirements instituted by the CARES Act, CRRSAA, and ARP and then further defined by the US Department of Education (ED). The ED exercised its reporting authority under 2 CFR section 200.328 and 2 CFR section 200.329 to define three reporting requirements for the HEERF program funds, which include 1) public reporting on the (a)(1) Student Aid Portion; 2) public reporting on the (a)(1) Institutional Portion (a)(2) and (a)(3) subprograms (Quarterly Reporting Form), as applicable; and 3) the annual report. These reporting requirements stipulate specific guidelines regarding when, how, and what information is to be publicly posted on the University?s website. Condition: Per review of the University's quarterly public reporting for the Student Aid Portion, we noted one instance where the amounts and information reported did not adhere to the program requirements. Issues noted included amounts not properly separated between student and institutional fund portions and incorrect amounts and information posted for one period. Cause: Reporting requirements posted by the Department of Education for HEERF program funds have continuously changed with the intent to be made clearer with each subsequent revision. However, it is difficult to draw conclusions on some of the reporting guidance. There were not adequate controls nor review processes in place to monitor the reporting requirements issued by the DoE to ensure quarterly reports for the Student Aid Portion were posted accurately. Effect: The effect or possible effect is that the University may be determined ineligible to receive future HEERF program funding. Additionally, the public does not have accurate information regarding how HEERF program funds were expended by the University from the student aid portion. Questioned Costs: None Recommendation: Controls should be established to allow for a second detailed review of all reporting of HEERF program funds by an official extensively familiar with the reporting requirements published by the DoE and other regulators. Auditee?s Response: The reports will be monitored more closely going forward. See attached corrective action plan. Repeat Finding: Yes, 2021-002
2022-053 Oregon Health Authority Improve financial reporting accuracy 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, 2020 (COVID-19); 6 NU50CK000541, 2021 (COVID-19) Compliance Requirements: Reporting Type of Finding: Significant Deficiency, Noncompliance Prior Year Finding: 2021-022 Questioned Costs: N/A Criteria: 2 CFR 200.328 In response to the COVID-19 pandemic, the Centers for Disease Control (CDC) awarded states substantial funds for the purpose of addressing the pandemic at the state level. Among other requirements, states are required to submit monthly financial reports to the CDC providing totals spent on travel, payroll, equipment, and other categories. During the fiscal year 2021 audit, we reported a material weakness relating to the accuracy of the amounts reported to the CDC. The same issue persisted throughout fiscal year 2022. As of June 30, 2022, the department had not taken the necessary actions to implement the prior recommendations and had not fully corrected the reports submitted in fiscal years 2021 and 2022. However, as of March 2023, the department had implemented the appropriate corrective actions and the previously inaccurate reports have been updated, including the reports for fiscal year 2022. Audit standards require that we report on the status as of June 30, 2022. We recommend department management maintain the necessary internal controls to ensure the monthly financial reports are accurate and agree to the accounting records.