Finding 2023-002: Reporting - Significant Deficiency Name of Federal Agency: U.S. Department of Health and Human Services Federal Program Name and Assistance Listing Number: CCDF Cluster, 93.575 Federal Award Identification Number and Year: 2101HICSC6, 2021 Name of Pass-through Entity: State of Hawaii Department of Human Services Criteria: According to 2 CFR 200.329, management is responsible for ensuring that all reports are submitted timely, in accordance with organizational policies and federal award compliance requirements. Condition: During the audit we noted that the Organization had not retained documentation showing that the required reports were submitted timely. Cause: The Organization's financial management did not retain documentation indicating that the reports were submitted timely. Effect or Potential Effect: This condition may lead to non-compliance with reporting requirements. Questioned Costs: N/A Context: This issue was noted across multiple reporting instances. While management submitted complete and accurate reports, documentation confirming timely submission was not retained. Identification as a Repeat Finding: This is a repeat finding. See 2022-003. Recommendation: We recommend that the Organization implement policies, procedures, and controls to ensure that there are documented and retrievable records to indicate that reports were submitted timely. Views of Responsible Officials: Management concurs with the finding and will ensure that records are maintained to indicate timely submission of reports.
Finding Reference: 2023-003 – Reporting Federal Agency: U.S Department of Agriculture Federal Program: Water and Waste Disposal System for Rural Communities - ALN# 10.760 Compliance Requirement: Reporting Criteria: The Uniform Guidance requires that non-federal entities may be required to submit performance reports at least annually but not more frequently than quarterly, except in unusual circumstances, using a form or format authorized by OMB (2 CFR section 200.329). They also may be required to submit special reports as required by the terms and conditions of the federal award. The U.S Department of Agriculture requires the Authority to submit Quarterly Income and Expense Statements. The reports are to be signed by the appropriate borrower official and submitted within 30 days of each quarter’s end. Condition: The Authority has not submitted Quarterly Income and Expense Statements within 30 days of the fiscal quarter end. However, the Authority has submitted audited annual financial reports within 9 months of fiscal year end. Cause and Effect: The Authority was unacquainted with quarterly filing requirements as set forth by the U.S. Department of Agriculture per the loan agreement. Without filing quarterly Income and Expense Statements, USDA is unaware of how funding is spent throughout the year. Questioned Cost: None Identification of Repeat Finding: No Recommendation: The Authority should begin to submit quarterly reports in accordance with loan agreement. Views of Responsible Officials: This was first brought to the Authority’s attention in the current year. The Authority is working towards submitting appropriate reports.
Finding 2023-002: Reporting - Significant Deficiency Name of Federal Agency: U.S. Department of Health and Human Services Federal Program Name and Assistance Listing Number: CCDF Cluster, 93.575 Federal Award Identification Number and Year: 2101HICSC6, 2021 Name of Pass-through Entity: State of Hawaii Department of Human Services Criteria: According to 2 CFR 200.329, management is responsible for ensuring that all reports are submitted timely, in accordance with organizational policies and federal award compliance requirements. Condition: During the audit we noted that the Organization had not retained documentation showing that the required reports were submitted timely. Cause: The Organization's financial management did not retain documentation indicating that the reports were submitted timely. Effect or Potential Effect: This condition may lead to non-compliance with reporting requirements. Questioned Costs: N/A Context: This issue was noted across multiple reporting instances. While management submitted complete and accurate reports, documentation confirming timely submission was not retained. Identification as a Repeat Finding: This is a repeat finding. See 2022-003. Recommendation: We recommend that the Organization implement policies, procedures, and controls to ensure that there are documented and retrievable records to indicate that reports were submitted timely. Views of Responsible Officials: Management concurs with the finding and will ensure that records are maintained to indicate timely submission of reports.
Federal Program Information: COVID 19 Strengthening Institutions Program (SIP) ALN 84.425M Criteria: 2 CFR 200.329 and the terms and conditions of the federal award requires the entity to submit reports quarterly. Condition: The total expenditures on quarterly reports was not reported. Questioned Costs: None Context: The testing of the reports showed that no amounts were reported for expenditures on quarterly reports. Cause/Effect: The College failed to report expenditures for SIP. Repeat Finding from Prior Audit?: Yes Recommendation: We recommend review of current practices and implement policies establishing monitoring procedures related to reports. Management Response: The College agrees with the finding and is implementing appropriate procedures.
Finding: 2023-002 Program Affected: COVID-19 Higher Education Emergency Relief Fund (HEERF) (AL Number 84.425E) Finding Type: Significant deficiency on internal 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 reported on quarterly and the annual reports. Condition: Per review of the University’s annual report, we noted three instances where the amounts and information reported did not agree to the internal records. Issues noted included incorrect amounts and information posted for the Emergency Financial Aid grants, monitoring and suppressing coronavirus, and total of institutional annual expenditures. 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 Department of Education to ensure the annual report was posted accurately. Effect: The effect or possible effect is that the University may be determined ineligible to receive future HEERF program funding. Additionally, the program does not have accurate information regarding how HEERF program funds were expended by the University. 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 Department of Education and other regulators. Auditee's Response: The reports will be monitored more closely going forward. See attached corrective action plan.
Department of Education COVID-19 Higher Education Emergency Relief Fund (HEERF) – Assistance Listing #84.425E, #84.425F #2023-003 – Major Federal Award Finding – Reporting Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-003. Conditions: We noted during testing of two quarterly reports and one annual report required under the HEERF program that the two quarterly reports selected for testing were not filed timely. There were also no review procedures in place surrounding these quarterly reports. In addition, some inaccuracies were noted within the annual reporting. Criteria: Federal regulations 2 CFR Section 200.328 - 200.329 provide that required reporting under the federal program must be completed timely and accurately. The quarterly reports for institutional and student aid are required to be updated and posted to the website within 10 days of the end of the quarter. Segregation of duties is also a key element of internal controls, including controls over compliance, and involves processes whereby the activities of one employee are reviewed or checked by the activities of another individual, and avoids one employee having the ability to perform a transaction or process from beginning to end. Cause/Context: The University did not meet the reporting deadline requirements set forth by the Department of Education for the HEERF program. Only one individual was involved in the reporting process for the quarterly reports. There is a higher likelihood of errors going undetected in the absence of monitoring and review. Inaccuracies were noted in the amounts reported in the 2022 calendar annual report for HEERF student disbursements and institutional expenditures. Recommendation: Management should review the University’s practices related to reporting under the HEERF program to ensure that reports are submitted timely and that more than one individual is involved in the reporting process. Management should also submit a revision of the HEERF calendar 2022 annual report once the reporting portal is reopened by the Department of Education. Views of Responsible Officials and Planned Corrective Actions: The University agrees with the recommendations put forth by the auditors. The University will submit a revised report for the 2022 calendar year and will put a procedure in place to ensure that all reports are reviewed prior to submission. See also attached Corrective Action Plan.
Department of Education COVID-19 Higher Education Emergency Relief Fund (HEERF) – Assistance Listing #84.425E, #84.425F #2023-003 – Major Federal Award Finding – Reporting Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-003. Conditions: We noted during testing of two quarterly reports and one annual report required under the HEERF program that the two quarterly reports selected for testing were not filed timely. There were also no review procedures in place surrounding these quarterly reports. In addition, some inaccuracies were noted within the annual reporting. Criteria: Federal regulations 2 CFR Section 200.328 - 200.329 provide that required reporting under the federal program must be completed timely and accurately. The quarterly reports for institutional and student aid are required to be updated and posted to the website within 10 days of the end of the quarter. Segregation of duties is also a key element of internal controls, including controls over compliance, and involves processes whereby the activities of one employee are reviewed or checked by the activities of another individual, and avoids one employee having the ability to perform a transaction or process from beginning to end. Cause/Context: The University did not meet the reporting deadline requirements set forth by the Department of Education for the HEERF program. Only one individual was involved in the reporting process for the quarterly reports. There is a higher likelihood of errors going undetected in the absence of monitoring and review. Inaccuracies were noted in the amounts reported in the 2022 calendar annual report for HEERF student disbursements and institutional expenditures. Recommendation: Management should review the University’s practices related to reporting under the HEERF program to ensure that reports are submitted timely and that more than one individual is involved in the reporting process. Management should also submit a revision of the HEERF calendar 2022 annual report once the reporting portal is reopened by the Department of Education. Views of Responsible Officials and Planned Corrective Actions: The University agrees with the recommendations put forth by the auditors. The University will submit a revised report for the 2022 calendar year and will put a procedure in place to ensure that all reports are reviewed prior to submission. See also attached Corrective Action Plan.
2023-002 Program: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Federal Financial Assistance Listing: 21.027 Federal Agency: U.S. Department of the Treasury Passed-through: N/A Award Year: 2022-2023 Compliance Requirement: Reporting Grant Award Number: Applies to all awards with findings and no specific grant award. Type of Finding: Material Instance of Noncompliance, Material Weakness in Internal Controls over Compliance. Criteria: Per 2 CFR 200.303, the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. This includes internal controls over maintaining records of the preparer and approver of required reports. 2 CFR 200.329(b) requires that reports submitted to the federal awarding agency include all activity of the reporting period, are supported by applicable accounting or performance records, and are fairly presented in accordance with program requirements. The County must submit an annual Project and Expenditure Report that contains costs incurred during the covered period. Critical information pertaining to the annual Project and Expenditure Report specifically includes: • Subawards • Detailed information on any loans issued; contracts and grants awarded; transfers made to other government entities; and direct payments made by the recipient that are greater than $50,000. For amounts less than $50,000, the recipient must report in the aggregate for these same categories of loans issued; contracts and grants awarded; transfers made by the recipient. Condition found: As a result of audit procedures, we identified that the annual Project and Expenditure Report had 3 instances where the project expenditure category and subcategory was not correctly classified. The project category of, (6-Revenue Replacement) and the subcategory of, (6.1- Provision of Government Services) were reported for projects that were either related to capital projects or other COVID-19 related projects that would result in this being classified incorrectly within the annual report. A different classification should have been used to report these project expenditures in the annual report. Context: The County filed the annual Project and Expenditure Report under project expenditure category, (6-Revenue Replacement) and subcategory, (6.1-Provision of Government Services). We identified expenditures for subrecipient awards in the amount of $629,387 and $7,939, respectively, and COVID-19 economic assistance expenditures in the amount of $60,000. All 3 instances should have been reported under a different category and subcategory in the report and not (6.1-Provision of Government Services). While the expenditures were deemed to be allowable under the terms and conditions of the award, the expenditures were not for general government services; therefore, they were not classified correctly. Cause: The County’s procedures did not ensure that the classification of expenditures was reported correctly in the annual Project and Expenditure Report. Effect: The County did not comply with the requirements of 2 CFR 200.303 and inaccurate information was reported to the federal awarding agency. Repeat Finding from Prior Year(s): This is not a repeat finding. Recommendation: We recommend the County enhance internal controls to ensure that the annual Project and Expenditure Reports are prepared in accordance with program requirements. Views of Responsible Officials and Corrective Action: Management agrees. See the County's separately issued Corrective Action Plan.
2023-002 Program: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Federal Financial Assistance Listing: 21.027 Federal Agency: U.S. Department of the Treasury Passed-through: N/A Award Year: 2022-2023 Compliance Requirement: Reporting Grant Award Number: Applies to all awards with findings and no specific grant award. Type of Finding: Material Instance of Noncompliance, Material Weakness in Internal Controls over Compliance. Criteria: Per 2 CFR 200.303, the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. This includes internal controls over maintaining records of the preparer and approver of required reports. 2 CFR 200.329(b) requires that reports submitted to the federal awarding agency include all activity of the reporting period, are supported by applicable accounting or performance records, and are fairly presented in accordance with program requirements. The County must submit an annual Project and Expenditure Report that contains costs incurred during the covered period. Critical information pertaining to the annual Project and Expenditure Report specifically includes: • Subawards • Detailed information on any loans issued; contracts and grants awarded; transfers made to other government entities; and direct payments made by the recipient that are greater than $50,000. For amounts less than $50,000, the recipient must report in the aggregate for these same categories of loans issued; contracts and grants awarded; transfers made by the recipient. Condition found: As a result of audit procedures, we identified that the annual Project and Expenditure Report had 3 instances where the project expenditure category and subcategory was not correctly classified. The project category of, (6-Revenue Replacement) and the subcategory of, (6.1- Provision of Government Services) were reported for projects that were either related to capital projects or other COVID-19 related projects that would result in this being classified incorrectly within the annual report. A different classification should have been used to report these project expenditures in the annual report. Context: The County filed the annual Project and Expenditure Report under project expenditure category, (6-Revenue Replacement) and subcategory, (6.1-Provision of Government Services). We identified expenditures for subrecipient awards in the amount of $629,387 and $7,939, respectively, and COVID-19 economic assistance expenditures in the amount of $60,000. All 3 instances should have been reported under a different category and subcategory in the report and not (6.1-Provision of Government Services). While the expenditures were deemed to be allowable under the terms and conditions of the award, the expenditures were not for general government services; therefore, they were not classified correctly. Cause: The County’s procedures did not ensure that the classification of expenditures was reported correctly in the annual Project and Expenditure Report. Effect: The County did not comply with the requirements of 2 CFR 200.303 and inaccurate information was reported to the federal awarding agency. Repeat Finding from Prior Year(s): This is not a repeat finding. Recommendation: We recommend the County enhance internal controls to ensure that the annual Project and Expenditure Reports are prepared in accordance with program requirements. Views of Responsible Officials and Corrective Action: Management agrees. See the County's separately issued Corrective Action Plan.
Failure to properly track grant expenditures. Federal programs impacted: 93.958 Block grants for community mental health services, 93.558 TANF DYS Questioned Costs: None Condition: The Clinic expended more than $750,000 in federal awards, triggering a single audit requirement, however when asked to prepare a SEFA/SESA multiple attempts were made and numbers changed numerous times throughout the audit. Client is unable to distinguish co-mingled federal and state funding and expenditures for DYS grants, one of the major programs tested. Client is able to maintain overall expenditures, but not on a segregated level. Appears tracking was done in the same manner as other program expenses. Client failed to maintain proper records to segregate federal and state funding as required by the Uniform Guidance. Criteria: 2 CFR section 200.329 states that one responsibility of the auditee is to monitor its activities under Federal awards. See also 200.332. Cause: Funding for the TANF DYS grant is received on a state and federal level. DHS is able to segregate in their tracking software but the Clinic belives they did not have the ability to separate these payements as they come from the same source and are often received in tandem, they did not have proper internal controls in place to segregate the funding received and related expenditures as required by the Uniform Guidance. Effect: Difficulty in establishing the SEFA/SESA, causing a delay in single audit testing. Co-mingling of federal and state funding used could present the possibility that expenses tested in single audit were paid for with the state portion of the grant. Recommendation: We recommend that the Clinic maintains an effort to track federal and state funding and expenditures separate from regular program expenditures, inquiring of granting agencies if needed by developing and implementing internal control policies related to grant funding and expenditure tracking. Management Response: Management believes it will be very difficult to segregate the fundings for the reasons listed above, but they mentioned they would request clarification from awarding agencies on which portion is federal and which is state in order to properly track.
Failure to properly track grant expenditures. Federal programs impacted: 93.958 Block grants for community mental health services, 93.558 TANF DYS Questioned Costs: None Condition: The Clinic expended more than $750,000 in federal awards, triggering a single audit requirement, however when asked to prepare a SEFA/SESA multiple attempts were made and numbers changed numerous times throughout the audit. Client is unable to distinguish co-mingled federal and state funding and expenditures for DYS grants, one of the major programs tested. Client is able to maintain overall expenditures, but not on a segregated level. Appears tracking was done in the same manner as other program expenses. Client failed to maintain proper records to segregate federal and state funding as required by the Uniform Guidance. Criteria: 2 CFR section 200.329 states that one responsibility of the auditee is to monitor its activities under Federal awards. See also 200.332. Cause: Funding for the TANF DYS grant is received on a state and federal level. DHS is able to segregate in their tracking software but the Clinic belives they did not have the ability to separate these payements as they come from the same source and are often received in tandem, they did not have proper internal controls in place to segregate the funding received and related expenditures as required by the Uniform Guidance. Effect: Difficulty in establishing the SEFA/SESA, causing a delay in single audit testing. Co-mingling of federal and state funding used could present the possibility that expenses tested in single audit were paid for with the state portion of the grant. Recommendation: We recommend that the Clinic maintains an effort to track federal and state funding and expenditures separate from regular program expenditures, inquiring of granting agencies if needed by developing and implementing internal control policies related to grant funding and expenditure tracking. Management Response: Management believes it will be very difficult to segregate the fundings for the reasons listed above, but they mentioned they would request clarification from awarding agencies on which portion is federal and which is state in order to properly track.
2023-001 REPORTING SIGNIFICANT DEFICIENCY Federal Program: Education Stabilization Fund Assistance Listing Number: 84.425D Condition: The United States Department of Education required the submission of a report covering the period of July 1, 2021 to June 30, 2022 outlining the various uses of Elementary and Secondary School Emergency Relief Funds. The School was unable to provide support for how the amounts submitted in this report were calculated. Totals reported for expenses were not in line with totals expended during the period. Criteria: 2 CFR part 200, Appendix XI, Compliance Supplement, Section 3-L-1, states “Non-federal entities may be required to submit performance reports at least annually but not more frequently than quarterly, except in unusual circumstances, using a form or format authorized by OMB (2 CFR section 200.329). They also may be required to submit special reports as required by the terms and conditions of the federal award.” Cause: The School did not report activity related to the use of Elementary and Secondary School Emergency Relief Funds in line with actual activity. The School did not have controls in place to ensure accurate reporting. Effect: Information on the use of funds from the Education Stabilization Fund were not accurately presented. Recommendation: We recommend the School develop internal controls to ensure accurate reporting in line with guidelines. Views of Responsible Officials and Planned Corrective Actions: The School’s Corrective Action Plan is included on page 24.
Temporary Assistance for Needy Families, U.S. Department of Health and Human Services Federal Assistance Listing #93.558; Contract No. 337-2022 Condition: Two of the twelve monthly HSP 14 reports submitted to the granting agency did not agree with the underlying documentation used to prepare the reports. Criteria: In compliance with 2 CFR Part 200 subpart D Performance and Financial Monitoring and Reporting § 200.329 “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.” Cause: The error stems from the lack of internal controls over reporting including file retention, independent review and approval, and the organization and accuracy of supporting documentation. Effect: The auditor was unable to verify information within the monthly HSP 14 reports. Failure to report program relevant information properly may result in a reduction, loss or repayment of funding. Recommendation: Management should implement controls and procedures for maintaining supporting documentation for all reports submitted to granting agencies, which should include the implementation of controls over reporting that would prevent report submissions until all supporting documentation has been verified by an individual independent of the preparation and filing of the report(s). Management’s Response/Planned Corrective Action: We agree with the auditor’s comments, and the following action will be taken to improve the condition. Director Will Triplett and Manager Clarissa Lostaunau will implement a written policy included in the HSP Policy and Procedure Manual outlining accurate process and completion of the HSP 14 monthly reporting. The manual will include written steps on obtaining, verifying and storing all backup documentation for all data on the HSP 14. The team will also include a verification process before the submission of the report where two employees approve the monthly report as an internal control, one being from management. This will be completed by December 31, 2023 and led by Director of Transformational Services, Will Triplett.
2023-004 – Reporting – Material Weakness in Internal Controls over Compliance and Material Noncompliance Department of Education Federal Assistance Listing Number: 84.425E, 84.425F, 84.425L Federal Program Name: Higher Education Emergency Relief Funds (HEERF) Student Aid Portion, Higher Education Emergency Relief Funds (HEERF) Institutional Portion, Higher Education Emergency Relief Funds (HEERF) Minority Serving Institutions (MSIs) Federal Award Number: P425E200777, P425F201298, P425L200234 Award Year: 2022-23, 2021-22, 2020-21 Criteria – Under the Coronavirus Aid, Relief, and Economic Security Act 18004(e) and the Coronavirus Response and Relief Supplemental Appropriations Act 314(e) institutions that received funds under HEERF I and HEERF II are required to submit a report to the secretary on how the school used its HEERF funds. While the American Rescue Plan did 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. Condition/context – A sample of 5 special reports from the population of 5 special reports was selected. Two of the quarterly reports were not posted timely. In addition, the University could not provide consistent institutional records for the data included in the reports nor could they provide support that the reports were reviewed prior to posting. Three of the four quarterly reports were corrected based on the audit procedures performed, the University did not properly identify these as “corrected” upon posting to the University website. Our sample was not, and was not intended to be, statistically valid. Questioned costs – None. Cause/effect – Due to the turnover in the business office, the University did not post its quarterly reports timely and was unable to provide consistent institutional records for the data included in the reports or documented review of the reports prior to posting. The lack of support for data reported and documented review results in a material noncompliance with the reporting compliance requirement. Repeat finding – Yes, 2022-005 Recommendation – We recommend the University update previously posted reports to accurately reflect the actual expenditures during the time period covered by the report. We recommend each report be posted to the University’s website on separate documents by quarter and should not be cumulative. We also recommend the University implement a process to ensure the submission dates and publication dates are maintained to ensure compliance with the reporting due dates and that the data submitted in the reports is properly supported by institutional records. Lastly, we recommend each report be properly reviewed by someone other than the preparer and that the review be documented with a signature and date. Views of responsible officials and planned corrective actions – Heritage University will update the previously posted reports to accurately reflect the actual expenditures during FY21, FY22 & FY23 on the University’s website by quarter. Going further, it will be the Grant accountant’s practice that the submission dates and publication dates are maintained and documented with reporting due dates. All documents will be reviewed and approved by the VP of Administration/CFO with dated signatures.
2023-004 – Reporting – Material Weakness in Internal Controls over Compliance and Material Noncompliance Department of Education Federal Assistance Listing Number: 84.425E, 84.425F, 84.425L Federal Program Name: Higher Education Emergency Relief Funds (HEERF) Student Aid Portion, Higher Education Emergency Relief Funds (HEERF) Institutional Portion, Higher Education Emergency Relief Funds (HEERF) Minority Serving Institutions (MSIs) Federal Award Number: P425E200777, P425F201298, P425L200234 Award Year: 2022-23, 2021-22, 2020-21 Criteria – Under the Coronavirus Aid, Relief, and Economic Security Act 18004(e) and the Coronavirus Response and Relief Supplemental Appropriations Act 314(e) institutions that received funds under HEERF I and HEERF II are required to submit a report to the secretary on how the school used its HEERF funds. While the American Rescue Plan did 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. Condition/context – A sample of 5 special reports from the population of 5 special reports was selected. Two of the quarterly reports were not posted timely. In addition, the University could not provide consistent institutional records for the data included in the reports nor could they provide support that the reports were reviewed prior to posting. Three of the four quarterly reports were corrected based on the audit procedures performed, the University did not properly identify these as “corrected” upon posting to the University website. Our sample was not, and was not intended to be, statistically valid. Questioned costs – None. Cause/effect – Due to the turnover in the business office, the University did not post its quarterly reports timely and was unable to provide consistent institutional records for the data included in the reports or documented review of the reports prior to posting. The lack of support for data reported and documented review results in a material noncompliance with the reporting compliance requirement. Repeat finding – Yes, 2022-005 Recommendation – We recommend the University update previously posted reports to accurately reflect the actual expenditures during the time period covered by the report. We recommend each report be posted to the University’s website on separate documents by quarter and should not be cumulative. We also recommend the University implement a process to ensure the submission dates and publication dates are maintained to ensure compliance with the reporting due dates and that the data submitted in the reports is properly supported by institutional records. Lastly, we recommend each report be properly reviewed by someone other than the preparer and that the review be documented with a signature and date. Views of responsible officials and planned corrective actions – Heritage University will update the previously posted reports to accurately reflect the actual expenditures during FY21, FY22 & FY23 on the University’s website by quarter. Going further, it will be the Grant accountant’s practice that the submission dates and publication dates are maintained and documented with reporting due dates. All documents will be reviewed and approved by the VP of Administration/CFO with dated signatures.
2023-004 – Reporting – Material Weakness in Internal Controls over Compliance and Material Noncompliance Department of Education Federal Assistance Listing Number: 84.425E, 84.425F, 84.425L Federal Program Name: Higher Education Emergency Relief Funds (HEERF) Student Aid Portion, Higher Education Emergency Relief Funds (HEERF) Institutional Portion, Higher Education Emergency Relief Funds (HEERF) Minority Serving Institutions (MSIs) Federal Award Number: P425E200777, P425F201298, P425L200234 Award Year: 2022-23, 2021-22, 2020-21 Criteria – Under the Coronavirus Aid, Relief, and Economic Security Act 18004(e) and the Coronavirus Response and Relief Supplemental Appropriations Act 314(e) institutions that received funds under HEERF I and HEERF II are required to submit a report to the secretary on how the school used its HEERF funds. While the American Rescue Plan did 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. Condition/context – A sample of 5 special reports from the population of 5 special reports was selected. Two of the quarterly reports were not posted timely. In addition, the University could not provide consistent institutional records for the data included in the reports nor could they provide support that the reports were reviewed prior to posting. Three of the four quarterly reports were corrected based on the audit procedures performed, the University did not properly identify these as “corrected” upon posting to the University website. Our sample was not, and was not intended to be, statistically valid. Questioned costs – None. Cause/effect – Due to the turnover in the business office, the University did not post its quarterly reports timely and was unable to provide consistent institutional records for the data included in the reports or documented review of the reports prior to posting. The lack of support for data reported and documented review results in a material noncompliance with the reporting compliance requirement. Repeat finding – Yes, 2022-005 Recommendation – We recommend the University update previously posted reports to accurately reflect the actual expenditures during the time period covered by the report. We recommend each report be posted to the University’s website on separate documents by quarter and should not be cumulative. We also recommend the University implement a process to ensure the submission dates and publication dates are maintained to ensure compliance with the reporting due dates and that the data submitted in the reports is properly supported by institutional records. Lastly, we recommend each report be properly reviewed by someone other than the preparer and that the review be documented with a signature and date. Views of responsible officials and planned corrective actions – Heritage University will update the previously posted reports to accurately reflect the actual expenditures during FY21, FY22 & FY23 on the University’s website by quarter. Going further, it will be the Grant accountant’s practice that the submission dates and publication dates are maintained and documented with reporting due dates. All documents will be reviewed and approved by the VP of Administration/CFO with dated signatures.
2023-006 – Reporting – Material Weakness in Internal Controls over Compliance and Material Noncompliance Department of Education Federal Assistance Listing Number: 84.031 Federal Program Name: Higher Education Institutional Aid Federal Award Number: P031S210057, P031S170020, P031C210038 Award Year: 2022-23, 2021-22 Criteria – Under 2 CFR section 200.329 non-Federal entities are required to submit performance reports at the interval required by the Federal awarding agency. Condition/context – The University was unable to provide documentation supporting the reporting requirements for the award. The reporting requirements would include the type of report to be submitted, time period covered by the report and due date of the report. Our sample was not, and was not intended to be, statistically valid. Questioned costs – None. Cause/Effect – The University does not have a centralized process for tracking report due dates. The lack of support for required due dates results in a material noncompliance with the reporting compliance requirement. Repeat finding – Yes, 2022-007 Recommendation – We recommend the University create an internal control to obtain reporting requirements for each award received by the University. We recommend a standard process be implemented for each award to track the due dates to ensure they are completed timely. Views of responsible officials and planned corrective actions – The University will create an internal control policy to ensure that it has the necessary paperwork for each award it receives. This will be the routine procedure followed for every award in order to keep track of the deadlines and finish on time.
2023-006 – Reporting – Material Weakness in Internal Controls over Compliance and Material Noncompliance Department of Education Federal Assistance Listing Number: 84.031 Federal Program Name: Higher Education Institutional Aid Federal Award Number: P031S210057, P031S170020, P031C210038 Award Year: 2022-23, 2021-22 Criteria – Under 2 CFR section 200.329 non-Federal entities are required to submit performance reports at the interval required by the Federal awarding agency. Condition/context – The University was unable to provide documentation supporting the reporting requirements for the award. The reporting requirements would include the type of report to be submitted, time period covered by the report and due date of the report. Our sample was not, and was not intended to be, statistically valid. Questioned costs – None. Cause/Effect – The University does not have a centralized process for tracking report due dates. The lack of support for required due dates results in a material noncompliance with the reporting compliance requirement. Repeat finding – Yes, 2022-007 Recommendation – We recommend the University create an internal control to obtain reporting requirements for each award received by the University. We recommend a standard process be implemented for each award to track the due dates to ensure they are completed timely. Views of responsible officials and planned corrective actions – The University will create an internal control policy to ensure that it has the necessary paperwork for each award it receives. This will be the routine procedure followed for every award in order to keep track of the deadlines and finish on time.
2023-006 – Reporting – Material Weakness in Internal Controls over Compliance and Material Noncompliance Department of Education Federal Assistance Listing Number: 84.031 Federal Program Name: Higher Education Institutional Aid Federal Award Number: P031S210057, P031S170020, P031C210038 Award Year: 2022-23, 2021-22 Criteria – Under 2 CFR section 200.329 non-Federal entities are required to submit performance reports at the interval required by the Federal awarding agency. Condition/context – The University was unable to provide documentation supporting the reporting requirements for the award. The reporting requirements would include the type of report to be submitted, time period covered by the report and due date of the report. Our sample was not, and was not intended to be, statistically valid. Questioned costs – None. Cause/Effect – The University does not have a centralized process for tracking report due dates. The lack of support for required due dates results in a material noncompliance with the reporting compliance requirement. Repeat finding – Yes, 2022-007 Recommendation – We recommend the University create an internal control to obtain reporting requirements for each award received by the University. We recommend a standard process be implemented for each award to track the due dates to ensure they are completed timely. Views of responsible officials and planned corrective actions – The University will create an internal control policy to ensure that it has the necessary paperwork for each award it receives. This will be the routine procedure followed for every award in order to keep track of the deadlines and finish on time.
Finding: 2023-002 Program Affected: COVID-19 Higher Education Emergency Relief Fund (HEERF) (AL Number 84.425E) Finding Type: Significant deficiency on internal 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 reported on quarterly and the annual reports. Condition: Per review of the University’s annual report, we noted three instances where the amounts and information reported did not agree to the internal records. Issues noted included incorrect amounts and information posted for the Emergency Financial Aid grants, monitoring and suppressing coronavirus, and total of institutional annual expenditures. 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 Department of Education to ensure the annual report was posted accurately. Effect: The effect or possible effect is that the University may be determined ineligible to receive future HEERF program funding. Additionally, the program does not have accurate information regarding how HEERF program funds were expended by the University. 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 Department of Education and other regulators. Auditee's Response: The reports will be monitored more closely going forward. See attached corrective action plan.
FINDING 2023-002 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 properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. The annual data reports were complied, prepared, and submitted by the Assistant Superintendent of Schools without an oversight or review process in place to prevent, or detect and correct, errors. Furthermore, the reported data on two 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 3 Report The key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Salaries," was not able to be verified to the School Corporation's records. Additionally, the key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Benefits," was understated by $16. ESSER II, Year 2 Report The key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Salaries," was understated by $288,199. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 17 MILL CREEK COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 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." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, some data could not be traced back to the underlying records. INDIANA STATE BOARD OF ACCOUNTS 18 MILL CREEK COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all reports submitted on behalf of the COVID-19 - Education Stabilization Fund program funds are accurate and complete. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 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 properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. The annual data reports were complied, prepared, and submitted by the Assistant Superintendent of Schools without an oversight or review process in place to prevent, or detect and correct, errors. Furthermore, the reported data on two 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 3 Report The key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Salaries," was not able to be verified to the School Corporation's records. Additionally, the key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Benefits," was understated by $16. ESSER II, Year 2 Report The key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Salaries," was understated by $288,199. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 17 MILL CREEK COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 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." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, some data could not be traced back to the underlying records. INDIANA STATE BOARD OF ACCOUNTS 18 MILL CREEK COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all reports submitted on behalf of the COVID-19 - Education Stabilization Fund program funds are accurate and complete. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 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 properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. The annual data reports were complied, prepared, and submitted by the Assistant Superintendent of Schools without an oversight or review process in place to prevent, or detect and correct, errors. Furthermore, the reported data on two 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 3 Report The key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Salaries," was not able to be verified to the School Corporation's records. Additionally, the key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Benefits," was understated by $16. ESSER II, Year 2 Report The key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Salaries," was understated by $288,199. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 17 MILL CREEK COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 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." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, some data could not be traced back to the underlying records. INDIANA STATE BOARD OF ACCOUNTS 18 MILL CREEK COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all reports submitted on behalf of the COVID-19 - Education Stabilization Fund program funds are accurate and complete. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 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 properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. The annual data reports were complied, prepared, and submitted by the Assistant Superintendent of Schools without an oversight or review process in place to prevent, or detect and correct, errors. Furthermore, the reported data on two 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 3 Report The key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Salaries," was not able to be verified to the School Corporation's records. Additionally, the key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Benefits," was understated by $16. ESSER II, Year 2 Report The key line item, "Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) Uses - Personnel Services - Salaries," was understated by $288,199. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 17 MILL CREEK COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 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." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, some data could not be traced back to the underlying records. INDIANA STATE BOARD OF ACCOUNTS 18 MILL CREEK COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all reports submitted on behalf of the COVID-19 - Education Stabilization Fund program funds are accurate and complete. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 18 GREENCASTLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. The reports were prepared by one employee without an oversight, review, or approval process in place to prevent, or detect and correct, errors. Data for four of the six reports tested during the audit period could not be traced to the records that accumulated and summarized the data. The following errors were identified when tracing key line items to supporting documentation: ESSER I - Year II Report 'Addressing Physical Health and Safety - Supplies' was understated by $12,522, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was overstated $19. ESSER II - Year I Report 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Personnel Services - Salaries' was understated by $20,536, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was understated by $1,321. ESSER II - Year II Report 'Addressing Physical Health and Safety Uses - Supplies' was understated by $5,764, and 'Meeting Students' Academic, Social, Emotional, and Other Needs Uses (Excluding Mental Health Supports) - Personnel Services - Salaries' was overstated $264. ESSER III - Year II Report 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Personnel Services - Salaries' was overstated $141, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was understated by $75,303. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to four of the six reports filed. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 19 GREENCASTLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not supported by the School Corporation's underlying accounting records and key line items were misstated. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are supported by the records and key line items are accurate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 18 GREENCASTLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. The reports were prepared by one employee without an oversight, review, or approval process in place to prevent, or detect and correct, errors. Data for four of the six reports tested during the audit period could not be traced to the records that accumulated and summarized the data. The following errors were identified when tracing key line items to supporting documentation: ESSER I - Year II Report 'Addressing Physical Health and Safety - Supplies' was understated by $12,522, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was overstated $19. ESSER II - Year I Report 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Personnel Services - Salaries' was understated by $20,536, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was understated by $1,321. ESSER II - Year II Report 'Addressing Physical Health and Safety Uses - Supplies' was understated by $5,764, and 'Meeting Students' Academic, Social, Emotional, and Other Needs Uses (Excluding Mental Health Supports) - Personnel Services - Salaries' was overstated $264. ESSER III - Year II Report 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Personnel Services - Salaries' was overstated $141, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was understated by $75,303. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to four of the six reports filed. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 19 GREENCASTLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not supported by the School Corporation's underlying accounting records and key line items were misstated. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are supported by the records and key line items are accurate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 18 GREENCASTLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. The reports were prepared by one employee without an oversight, review, or approval process in place to prevent, or detect and correct, errors. Data for four of the six reports tested during the audit period could not be traced to the records that accumulated and summarized the data. The following errors were identified when tracing key line items to supporting documentation: ESSER I - Year II Report 'Addressing Physical Health and Safety - Supplies' was understated by $12,522, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was overstated $19. ESSER II - Year I Report 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Personnel Services - Salaries' was understated by $20,536, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was understated by $1,321. ESSER II - Year II Report 'Addressing Physical Health and Safety Uses - Supplies' was understated by $5,764, and 'Meeting Students' Academic, Social, Emotional, and Other Needs Uses (Excluding Mental Health Supports) - Personnel Services - Salaries' was overstated $264. ESSER III - Year II Report 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Personnel Services - Salaries' was overstated $141, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was understated by $75,303. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to four of the six reports filed. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 19 GREENCASTLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not supported by the School Corporation's underlying accounting records and key line items were misstated. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are supported by the records and key line items are accurate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 18 GREENCASTLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. The reports were prepared by one employee without an oversight, review, or approval process in place to prevent, or detect and correct, errors. Data for four of the six reports tested during the audit period could not be traced to the records that accumulated and summarized the data. The following errors were identified when tracing key line items to supporting documentation: ESSER I - Year II Report 'Addressing Physical Health and Safety - Supplies' was understated by $12,522, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was overstated $19. ESSER II - Year I Report 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Personnel Services - Salaries' was understated by $20,536, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was understated by $1,321. ESSER II - Year II Report 'Addressing Physical Health and Safety Uses - Supplies' was understated by $5,764, and 'Meeting Students' Academic, Social, Emotional, and Other Needs Uses (Excluding Mental Health Supports) - Personnel Services - Salaries' was overstated $264. ESSER III - Year II Report 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Personnel Services - Salaries' was overstated $141, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was understated by $75,303. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to four of the six reports filed. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 19 GREENCASTLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not supported by the School Corporation's underlying accounting records and key line items were misstated. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are supported by the records and key line items are accurate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 18 GREENCASTLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. The reports were prepared by one employee without an oversight, review, or approval process in place to prevent, or detect and correct, errors. Data for four of the six reports tested during the audit period could not be traced to the records that accumulated and summarized the data. The following errors were identified when tracing key line items to supporting documentation: ESSER I - Year II Report 'Addressing Physical Health and Safety - Supplies' was understated by $12,522, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was overstated $19. ESSER II - Year I Report 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Personnel Services - Salaries' was understated by $20,536, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was understated by $1,321. ESSER II - Year II Report 'Addressing Physical Health and Safety Uses - Supplies' was understated by $5,764, and 'Meeting Students' Academic, Social, Emotional, and Other Needs Uses (Excluding Mental Health Supports) - Personnel Services - Salaries' was overstated $264. ESSER III - Year II Report 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Personnel Services - Salaries' was overstated $141, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was understated by $75,303. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to four of the six reports filed. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 19 GREENCASTLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not supported by the School Corporation's underlying accounting records and key line items were misstated. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are supported by the records and key line items are accurate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 18 GREENCASTLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. The reports were prepared by one employee without an oversight, review, or approval process in place to prevent, or detect and correct, errors. Data for four of the six reports tested during the audit period could not be traced to the records that accumulated and summarized the data. The following errors were identified when tracing key line items to supporting documentation: ESSER I - Year II Report 'Addressing Physical Health and Safety - Supplies' was understated by $12,522, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was overstated $19. ESSER II - Year I Report 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Personnel Services - Salaries' was understated by $20,536, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was understated by $1,321. ESSER II - Year II Report 'Addressing Physical Health and Safety Uses - Supplies' was understated by $5,764, and 'Meeting Students' Academic, Social, Emotional, and Other Needs Uses (Excluding Mental Health Supports) - Personnel Services - Salaries' was overstated $264. ESSER III - Year II Report 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Personnel Services - Salaries' was overstated $141, and 'Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies' was understated by $75,303. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to four of the six reports filed. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 19 GREENCASTLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not supported by the School Corporation's underlying accounting records and key line items were misstated. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are supported by the records and key line items are accurate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding related to Annual Data Reports from the immediately prior audit report. The prior audit finding number was 2021-004. Condition and Context Annual Data Report The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. The annual data reports were prepared by the Treasurer and reviewed by a second knowledgeable individual; however, this process did not allow for the prevention, or detection and correction of errors. The School Corporation was required to submit six Annual Data Reports during the audit period. The three Annual Data Reports for the period of July 1, 2020 to June 30, 2021, were not submitted in a timely manner. The reports were to be submitted to the IDOE by May 13, 2022, but the School Corporation did not submit the reports until March 16, 2023. Reimbursement Requests The School Corporation completes reimbursement requests on a periodic basis. The reimbursement requests are prepared by the Treasurer utilizing various ledger reports and are reviewed by a second knowledgeable employee; however, this process did not allow for the prevention, or detection and correction, of errors. INDIANA STATE BOARD OF ACCOUNTS 26 CULVER COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) While gaining an understanding of how the School Corporation spent its COVID-19 - Education Stabilization Fund award, various issues with reimbursement requests were noted. The issues identified at that time revealed that the School Corporation submitted reimbursement requests for and received reimbursements for four invoices, twice which resulted an extra $50,000 in grant funds being claimed. Additionally, three reimbursement requests tested did not agree with supporting documentation which resulted in $6,071 being reimbursed that was not supported by the School Corporation's records. The $56,071 is considered a questioned cost. As a result of these errors, we determined that reimbursement requests should be tested. Therefore, a sample of 8 reimbursement requests were selected from the population of 49 for testing. No additional errors were noted in the 8 reimbursement requests tested. The lack of internal controls was a systemic issue that occurred throughout the audit period; the noncompliance was limited to the reports noted above. 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." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. INDIANA STATE BOARD OF ACCOUNTS 27 CULVER COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not timely submitted to the IDOE, and reimbursement requests were not supported by the School Corporation's underlying accounting records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs Known questioned of $56,071 were identified as noted in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are submitted timely and supporting documentation is used and retained for reimbursement requests. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding related to Annual Data Reports from the immediately prior audit report. The prior audit finding number was 2021-004. Condition and Context Annual Data Report The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. The annual data reports were prepared by the Treasurer and reviewed by a second knowledgeable individual; however, this process did not allow for the prevention, or detection and correction of errors. The School Corporation was required to submit six Annual Data Reports during the audit period. The three Annual Data Reports for the period of July 1, 2020 to June 30, 2021, were not submitted in a timely manner. The reports were to be submitted to the IDOE by May 13, 2022, but the School Corporation did not submit the reports until March 16, 2023. Reimbursement Requests The School Corporation completes reimbursement requests on a periodic basis. The reimbursement requests are prepared by the Treasurer utilizing various ledger reports and are reviewed by a second knowledgeable employee; however, this process did not allow for the prevention, or detection and correction, of errors. INDIANA STATE BOARD OF ACCOUNTS 26 CULVER COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) While gaining an understanding of how the School Corporation spent its COVID-19 - Education Stabilization Fund award, various issues with reimbursement requests were noted. The issues identified at that time revealed that the School Corporation submitted reimbursement requests for and received reimbursements for four invoices, twice which resulted an extra $50,000 in grant funds being claimed. Additionally, three reimbursement requests tested did not agree with supporting documentation which resulted in $6,071 being reimbursed that was not supported by the School Corporation's records. The $56,071 is considered a questioned cost. As a result of these errors, we determined that reimbursement requests should be tested. Therefore, a sample of 8 reimbursement requests were selected from the population of 49 for testing. No additional errors were noted in the 8 reimbursement requests tested. The lack of internal controls was a systemic issue that occurred throughout the audit period; the noncompliance was limited to the reports noted above. 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." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. INDIANA STATE BOARD OF ACCOUNTS 27 CULVER COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not timely submitted to the IDOE, and reimbursement requests were not supported by the School Corporation's underlying accounting records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs Known questioned of $56,071 were identified as noted in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are submitted timely and supporting documentation is used and retained for reimbursement requests. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding related to Annual Data Reports from the immediately prior audit report. The prior audit finding number was 2021-004. Condition and Context Annual Data Report The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. The annual data reports were prepared by the Treasurer and reviewed by a second knowledgeable individual; however, this process did not allow for the prevention, or detection and correction of errors. The School Corporation was required to submit six Annual Data Reports during the audit period. The three Annual Data Reports for the period of July 1, 2020 to June 30, 2021, were not submitted in a timely manner. The reports were to be submitted to the IDOE by May 13, 2022, but the School Corporation did not submit the reports until March 16, 2023. Reimbursement Requests The School Corporation completes reimbursement requests on a periodic basis. The reimbursement requests are prepared by the Treasurer utilizing various ledger reports and are reviewed by a second knowledgeable employee; however, this process did not allow for the prevention, or detection and correction, of errors. INDIANA STATE BOARD OF ACCOUNTS 26 CULVER COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) While gaining an understanding of how the School Corporation spent its COVID-19 - Education Stabilization Fund award, various issues with reimbursement requests were noted. The issues identified at that time revealed that the School Corporation submitted reimbursement requests for and received reimbursements for four invoices, twice which resulted an extra $50,000 in grant funds being claimed. Additionally, three reimbursement requests tested did not agree with supporting documentation which resulted in $6,071 being reimbursed that was not supported by the School Corporation's records. The $56,071 is considered a questioned cost. As a result of these errors, we determined that reimbursement requests should be tested. Therefore, a sample of 8 reimbursement requests were selected from the population of 49 for testing. No additional errors were noted in the 8 reimbursement requests tested. The lack of internal controls was a systemic issue that occurred throughout the audit period; the noncompliance was limited to the reports noted above. 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." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. INDIANA STATE BOARD OF ACCOUNTS 27 CULVER COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not timely submitted to the IDOE, and reimbursement requests were not supported by the School Corporation's underlying accounting records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs Known questioned of $56,071 were identified as noted in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are submitted timely and supporting documentation is used and retained for reimbursement requests. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding related to Annual Data Reports from the immediately prior audit report. The prior audit finding number was 2021-004. Condition and Context Annual Data Report The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. The annual data reports were prepared by the Treasurer and reviewed by a second knowledgeable individual; however, this process did not allow for the prevention, or detection and correction of errors. The School Corporation was required to submit six Annual Data Reports during the audit period. The three Annual Data Reports for the period of July 1, 2020 to June 30, 2021, were not submitted in a timely manner. The reports were to be submitted to the IDOE by May 13, 2022, but the School Corporation did not submit the reports until March 16, 2023. Reimbursement Requests The School Corporation completes reimbursement requests on a periodic basis. The reimbursement requests are prepared by the Treasurer utilizing various ledger reports and are reviewed by a second knowledgeable employee; however, this process did not allow for the prevention, or detection and correction, of errors. INDIANA STATE BOARD OF ACCOUNTS 26 CULVER COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) While gaining an understanding of how the School Corporation spent its COVID-19 - Education Stabilization Fund award, various issues with reimbursement requests were noted. The issues identified at that time revealed that the School Corporation submitted reimbursement requests for and received reimbursements for four invoices, twice which resulted an extra $50,000 in grant funds being claimed. Additionally, three reimbursement requests tested did not agree with supporting documentation which resulted in $6,071 being reimbursed that was not supported by the School Corporation's records. The $56,071 is considered a questioned cost. As a result of these errors, we determined that reimbursement requests should be tested. Therefore, a sample of 8 reimbursement requests were selected from the population of 49 for testing. No additional errors were noted in the 8 reimbursement requests tested. The lack of internal controls was a systemic issue that occurred throughout the audit period; the noncompliance was limited to the reports noted above. 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." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. INDIANA STATE BOARD OF ACCOUNTS 27 CULVER COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not timely submitted to the IDOE, and reimbursement requests were not supported by the School Corporation's underlying accounting records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs Known questioned of $56,071 were identified as noted in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are submitted timely and supporting documentation is used and retained for reimbursement requests. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding related to Annual Data Reports from the immediately prior audit report. The prior audit finding number was 2021-004. Condition and Context Annual Data Report The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. The annual data reports were prepared by the Treasurer and reviewed by a second knowledgeable individual; however, this process did not allow for the prevention, or detection and correction of errors. The School Corporation was required to submit six Annual Data Reports during the audit period. The three Annual Data Reports for the period of July 1, 2020 to June 30, 2021, were not submitted in a timely manner. The reports were to be submitted to the IDOE by May 13, 2022, but the School Corporation did not submit the reports until March 16, 2023. Reimbursement Requests The School Corporation completes reimbursement requests on a periodic basis. The reimbursement requests are prepared by the Treasurer utilizing various ledger reports and are reviewed by a second knowledgeable employee; however, this process did not allow for the prevention, or detection and correction, of errors. INDIANA STATE BOARD OF ACCOUNTS 26 CULVER COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) While gaining an understanding of how the School Corporation spent its COVID-19 - Education Stabilization Fund award, various issues with reimbursement requests were noted. The issues identified at that time revealed that the School Corporation submitted reimbursement requests for and received reimbursements for four invoices, twice which resulted an extra $50,000 in grant funds being claimed. Additionally, three reimbursement requests tested did not agree with supporting documentation which resulted in $6,071 being reimbursed that was not supported by the School Corporation's records. The $56,071 is considered a questioned cost. As a result of these errors, we determined that reimbursement requests should be tested. Therefore, a sample of 8 reimbursement requests were selected from the population of 49 for testing. No additional errors were noted in the 8 reimbursement requests tested. The lack of internal controls was a systemic issue that occurred throughout the audit period; the noncompliance was limited to the reports noted above. 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." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. INDIANA STATE BOARD OF ACCOUNTS 27 CULVER COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not timely submitted to the IDOE, and reimbursement requests were not supported by the School Corporation's underlying accounting records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs Known questioned of $56,071 were identified as noted in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are submitted timely and supporting documentation is used and retained for reimbursement requests. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding related to Annual Data Reports from the immediately prior audit report. The prior audit finding number was 2021-004. Condition and Context Annual Data Report The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. The annual data reports were prepared by the Treasurer and reviewed by a second knowledgeable individual; however, this process did not allow for the prevention, or detection and correction of errors. The School Corporation was required to submit six Annual Data Reports during the audit period. The three Annual Data Reports for the period of July 1, 2020 to June 30, 2021, were not submitted in a timely manner. The reports were to be submitted to the IDOE by May 13, 2022, but the School Corporation did not submit the reports until March 16, 2023. Reimbursement Requests The School Corporation completes reimbursement requests on a periodic basis. The reimbursement requests are prepared by the Treasurer utilizing various ledger reports and are reviewed by a second knowledgeable employee; however, this process did not allow for the prevention, or detection and correction, of errors. INDIANA STATE BOARD OF ACCOUNTS 26 CULVER COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) While gaining an understanding of how the School Corporation spent its COVID-19 - Education Stabilization Fund award, various issues with reimbursement requests were noted. The issues identified at that time revealed that the School Corporation submitted reimbursement requests for and received reimbursements for four invoices, twice which resulted an extra $50,000 in grant funds being claimed. Additionally, three reimbursement requests tested did not agree with supporting documentation which resulted in $6,071 being reimbursed that was not supported by the School Corporation's records. The $56,071 is considered a questioned cost. As a result of these errors, we determined that reimbursement requests should be tested. Therefore, a sample of 8 reimbursement requests were selected from the population of 49 for testing. No additional errors were noted in the 8 reimbursement requests tested. The lack of internal controls was a systemic issue that occurred throughout the audit period; the noncompliance was limited to the reports noted above. 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." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. INDIANA STATE BOARD OF ACCOUNTS 27 CULVER COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not timely submitted to the IDOE, and reimbursement requests were not supported by the School Corporation's underlying accounting records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs Known questioned of $56,071 were identified as noted in the Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are submitted timely and supporting documentation is used and retained for reimbursement requests. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
2023–010 REPORTING Federal Program Information: Federal Agency and Program Name Assistance Listing # U.S. Department of the Interior Abandoned Mine Land Reclamation (AMLR) 15.252, Grant Award S16AF20058, Grant Award S18AF20000, Grant Award S19AF20000, Grant Award S19AF20020, Grant Award S20AF20008, Grant Award S20AF20038, Grant Award S20AF20094, Grant Award S21AF10040, Grant Award S22AF00013, Grant Award S22AF00039, Grant Award S23AF00013, Grant Award S23AF00059, Grant Award S23AF00107 Criteria or specific requirement (including statutory, regulatory or other citation): 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.” Condition: The West Virginia Department of Environmental Protection (the Department) is responsible for preparing the SF-425 and SF-425A. There were errors in reporting on the SF-425 reports where receipts and disbursements reported did not agree to the underlying data used to prepare the reports. In addition, the Department did not file the SF-425A reports as required. There were no internal controls in place surrounding review and approval of the financial reports. Cause: The Department does not have adequate internal controls and policies and procedures in place to ensure that reports contain accurate financial information and are submitted as required. Effect or Potential Effect: The Department is not reporting accurate information for the SF-425 reports and is not submitting the SF-425A reports causing them not to be in compliance with federal reporting requirements over financial reports. Questioned Costs: Unknown Context: We selected five SF-425 reports for testing and noted errors in all the reports. We selected five SF-425A reports for testing and noted the reports were not filed. Total federal expenditures for the AMLR Grants program were $29,631,143 for the year ended June 30, 2023. Identification as a Repeat Finding: This is not a repeat finding from the prior year. Recommendation: We recommend that the Department strengthen internal controls and policies and procedures over financial reporting to ensure they are in compliance with federal reporting requirements. Views of Responsible Officials: Management concurs with the finding and has developed a plan to correct the finding.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Maters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period, the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports; however, a single employee prepared and submitted the reports without evidence of a review, or oversight process in place to prevent, or detect and correct, errors. INDIANA STATE BOARD OF ACCOUNTS 17 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Additionally, for the ESSER I, Year 2 report, the "Total Mandatory Subgrant Amount Expended in Current Reporting Period" was not supported by the School Corporation's records. Actual expenditures from a report provided by the School Corporation did not tie to the amount submitted for the Annual Performance Reporting. The key line item was determined to be overstated by $80,342. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, Year 2 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.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." INDIANA STATE BOARD OF ACCOUNTS 18 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the amounts reported were not supported by the School Corporation's records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure supporting documentation is used and retained for all required reports submitted on behalf of the COVID-19 - Education Stabilization Fund program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Maters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period, the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports; however, a single employee prepared and submitted the reports without evidence of a review, or oversight process in place to prevent, or detect and correct, errors. INDIANA STATE BOARD OF ACCOUNTS 17 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Additionally, for the ESSER I, Year 2 report, the "Total Mandatory Subgrant Amount Expended in Current Reporting Period" was not supported by the School Corporation's records. Actual expenditures from a report provided by the School Corporation did not tie to the amount submitted for the Annual Performance Reporting. The key line item was determined to be overstated by $80,342. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, Year 2 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.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." INDIANA STATE BOARD OF ACCOUNTS 18 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the amounts reported were not supported by the School Corporation's records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure supporting documentation is used and retained for all required reports submitted on behalf of the COVID-19 - Education Stabilization Fund program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Maters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period, the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports; however, a single employee prepared and submitted the reports without evidence of a review, or oversight process in place to prevent, or detect and correct, errors. INDIANA STATE BOARD OF ACCOUNTS 17 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Additionally, for the ESSER I, Year 2 report, the "Total Mandatory Subgrant Amount Expended in Current Reporting Period" was not supported by the School Corporation's records. Actual expenditures from a report provided by the School Corporation did not tie to the amount submitted for the Annual Performance Reporting. The key line item was determined to be overstated by $80,342. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, Year 2 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.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." INDIANA STATE BOARD OF ACCOUNTS 18 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the amounts reported were not supported by the School Corporation's records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure supporting documentation is used and retained for all required reports submitted on behalf of the COVID-19 - Education Stabilization Fund program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Maters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period, the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports; however, a single employee prepared and submitted the reports without evidence of a review, or oversight process in place to prevent, or detect and correct, errors. INDIANA STATE BOARD OF ACCOUNTS 17 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Additionally, for the ESSER I, Year 2 report, the "Total Mandatory Subgrant Amount Expended in Current Reporting Period" was not supported by the School Corporation's records. Actual expenditures from a report provided by the School Corporation did not tie to the amount submitted for the Annual Performance Reporting. The key line item was determined to be overstated by $80,342. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, Year 2 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.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." INDIANA STATE BOARD OF ACCOUNTS 18 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the amounts reported were not supported by the School Corporation's records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure supporting documentation is used and retained for all required reports submitted on behalf of the COVID-19 - Education Stabilization Fund program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Maters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period, the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports; however, a single employee prepared and submitted the reports without evidence of a review, or oversight process in place to prevent, or detect and correct, errors. INDIANA STATE BOARD OF ACCOUNTS 17 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Additionally, for the ESSER I, Year 2 report, the "Total Mandatory Subgrant Amount Expended in Current Reporting Period" was not supported by the School Corporation's records. Actual expenditures from a report provided by the School Corporation did not tie to the amount submitted for the Annual Performance Reporting. The key line item was determined to be overstated by $80,342. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, Year 2 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.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." INDIANA STATE BOARD OF ACCOUNTS 18 METROPOLITAN SCHOOL DISTRICT OF MARTINSVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the amounts reported were not supported by the School Corporation's records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure supporting documentation is used and retained for all required reports submitted on behalf of the COVID-19 - Education Stabilization Fund program. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistant Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. The annual data reports were complied, prepared and submitted by one employee without an oversight or review process in place to prevent, or detect and correct, errors. In addition, three of the six reports submitted during the audit period contained errors. The errors were as follows: The ESSER II, Year 1 report was not supported by the School Corporation's records, was not accurate and complete, and was not mathematically accurate. The ESSER II, Year 2 report was not supported by the School Corporation's records, was not accurate and complete, and was not mathematically accurate. Also, expenditures for the key line item of "Supplies" as reported did not agree to the School Corporation's ledger. The ESSER III, Year 2 key line of "Supplies" expenditures did not agree to the School Corporation's ledger. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the three reports noted above. 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." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, ESSER reports were not supported by the School Corporation's records, were not accurate and complete, and were not mathematically accurate. Additionally, key line items were not supported by the records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure supporting documentation is used and retained for all required reports submitted on behalf of the Education Stabilization Fund program funds. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistant Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. The annual data reports were complied, prepared and submitted by one employee without an oversight or review process in place to prevent, or detect and correct, errors. In addition, three of the six reports submitted during the audit period contained errors. The errors were as follows: The ESSER II, Year 1 report was not supported by the School Corporation's records, was not accurate and complete, and was not mathematically accurate. The ESSER II, Year 2 report was not supported by the School Corporation's records, was not accurate and complete, and was not mathematically accurate. Also, expenditures for the key line item of "Supplies" as reported did not agree to the School Corporation's ledger. The ESSER III, Year 2 key line of "Supplies" expenditures did not agree to the School Corporation's ledger. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the three reports noted above. 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." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, ESSER reports were not supported by the School Corporation's records, were not accurate and complete, and were not mathematically accurate. Additionally, key line items were not supported by the records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure supporting documentation is used and retained for all required reports submitted on behalf of the Education Stabilization Fund program funds. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistant Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. The annual data reports were complied, prepared and submitted by one employee without an oversight or review process in place to prevent, or detect and correct, errors. In addition, three of the six reports submitted during the audit period contained errors. The errors were as follows: The ESSER II, Year 1 report was not supported by the School Corporation's records, was not accurate and complete, and was not mathematically accurate. The ESSER II, Year 2 report was not supported by the School Corporation's records, was not accurate and complete, and was not mathematically accurate. Also, expenditures for the key line item of "Supplies" as reported did not agree to the School Corporation's ledger. The ESSER III, Year 2 key line of "Supplies" expenditures did not agree to the School Corporation's ledger. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the three reports noted above. 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." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, ESSER reports were not supported by the School Corporation's records, were not accurate and complete, and were not mathematically accurate. Additionally, key line items were not supported by the records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure supporting documentation is used and retained for all required reports submitted on behalf of the Education Stabilization Fund program funds. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Condition The United States Department of Education required the submission of a report covering the period of July 1, 2021 to June 30, 2022 outlining the various uses of Elementary and Secondary School Emergency Relief Funds. The School was unable to provide support for how the amounts submitted in this report were calculated. Totals reported for expenses were not in line with totals expended during the period. Criteria 2 CFR part 200, Appendix XI, Compliance Supplement, Section 3-L-1, states “Non-federal entities may be required to submit performance reports at least annually but not more frequently than quarterly, except in unusual circumstances, using a form or format authorized by OMB (2 CFR section 200.329). They also may be required to submit special reports as required by the terms and conditions of the federal award.” Cause The School did not report activity related to the use of Elementary and Secondary School Emergency Relief Funds in line with actual activity. The School did not have controls in place to ensure accurate reporting. Effect Information on the use of funds from the Education Stabilization Fund were not accurately presented. Recommendation We recommend the School develop internal controls to ensure accurate reporting in line with guidelines. Views of Responsible Officials and Planned Corrective Actions The School’s Corrective Action Plan is included on pages 23.
Condition The United States Department of Education required the submission of a report covering the period of July 1, 2021 to June 30, 2022 outlining the various uses of Elementary and Secondary School Emergency Relief Funds. The School was unable to provide support for how the amounts submitted in this report were calculated. Totals reported for expenses were not in line with totals expended during the period. Criteria 2 CFR part 200, Appendix XI, Compliance Supplement, Section 3-L-1, states “Non-federal entities may be required to submit performance reports at least annually but not more frequently than quarterly, except in unusual circumstances, using a form or format authorized by OMB (2 CFR section 200.329). They also may be required to submit special reports as required by the terms and conditions of the federal award.” Cause The School did not report activity related to the use of Elementary and Secondary School Emergency Relief Funds in line with actual activity. The School did not have controls in place to ensure accurate reporting. Effect Information on the use of funds from the Education Stabilization Fund were not accurately presented. Recommendation We recommend the School develop internal controls to ensure accurate reporting in line with guidelines. Views of Responsible Officials and Planned Corrective Actions The School’s Corrective Action Plan is included on pages 23.
FINDING 2023-005 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. The annual data reports were compiled, prepared, and submitted by the Assistant Superintendent of Schools and reviewed by the Treasurer prior to submission. However, this review process was not effective and did not detect and allow correction of errors prior to submission. All six of the submitted reports were selected for testing. Four of the reports, ESSER I, Year 2; ESSER II, Year 1; ESSER II, Year 2; and ESSER III, Year 2, were not supported by the School Corporation's records. The financial information provided did not agree to the data submitted in the reports; therefore, we could not determine the accuracy of the reports. 22 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the four reports identified above. 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." 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 A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. 23 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports submitted to the IDOE were not supported by the School Corporation's underlying accounting records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are supported by the ledgers or reports used to complete the report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. The annual data reports were compiled, prepared, and submitted by the Assistant Superintendent of Schools and reviewed by the Treasurer prior to submission. However, this review process was not effective and did not detect and allow correction of errors prior to submission. All six of the submitted reports were selected for testing. Four of the reports, ESSER I, Year 2; ESSER II, Year 1; ESSER II, Year 2; and ESSER III, Year 2, were not supported by the School Corporation's records. The financial information provided did not agree to the data submitted in the reports; therefore, we could not determine the accuracy of the reports. 22 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the four reports identified above. 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." 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 A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. 23 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports submitted to the IDOE were not supported by the School Corporation's underlying accounting records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are supported by the ledgers or reports used to complete the report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. The annual data reports were compiled, prepared, and submitted by the Assistant Superintendent of Schools and reviewed by the Treasurer prior to submission. However, this review process was not effective and did not detect and allow correction of errors prior to submission. All six of the submitted reports were selected for testing. Four of the reports, ESSER I, Year 2; ESSER II, Year 1; ESSER II, Year 2; and ESSER III, Year 2, were not supported by the School Corporation's records. The financial information provided did not agree to the data submitted in the reports; therefore, we could not determine the accuracy of the reports. 22 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the four reports identified above. 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." 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 A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. 23 INDIANA STATE BOARD OF ACCOUNTS RANDOLPH CENTRAL SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports submitted to the IDOE were not supported by the School Corporation's underlying accounting records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are supported by the ledgers or reports used to complete the report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.