Assistance Listing Number(s): 10.553 and 10.555 Name of Federal Program or Cluster: Child Nutrition Cluster Name of Federal Agency: Department of Agriculture Name of Pass-through Entity: Wisconsin Department of Public Instruction Pass-through Entity Identifying Number(s): 2023-138142-DPI-SB-546, 2023-138005-DPI-SB-546, 2023-138005-DPI-NSL-547, and 2023-138005-DPI-SK_NSLAE-566 Award Period: July 1, 2022 through June 30, 2023 Criteria: According to 2 CFR, Part 200.334 of the Uniform Guidance, supporting documentation pertinent to a federal award must be retained for a period of three years from the date of submission of the expenditure. According to 2 CFR, Part 200.302(3) of the Uniform Guidance, records must be supported by source documentation. Condition: Supporting documentation for claims were not retained. Cause: Internal controls for funding claims have not been designed appropriately. Currently, there are no internal controls to ensure support for claims are retained in accordance with federal requirements. Questioned Costs: $344,674 Effect or Potential Effect: Incomplete or inaccurate information could be reported on funding claims. Context: A sample of 8 claims reports were selected from a population of 39. The testing found that supporting documentation for claims was not retained for any of the claims in the sample. Repeat Finding: No Recommendation: One City Schools, Inc. should design and implement appropriate internal controls for retaining support for claims in accordance with federal requirements. Views of Responsible Officials: One City Schools, Inc. agrees with the finding and are working on implementing internal controls for maintaining supporting documentation.
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.
Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds (SLFRF) Emergency Rental Assistance Program Assistance Listing Number: 21.027 and 21.023 Federal Award Identification Number and Year: ALN 21.027 -Pub. L. No. 117-2 2021 ALN 21.023 -ERA0335 2021 ALN 21.023 - ERAOl 14 2021 Award Period: ALN 21.027 - 5/10/2021 - 12/31/2026 ALN 21.023 - 1/20/2021 - 9/30/2022 ALN 21.023 - 5/17/2021 - 9/30/2025 Type of Finding: • Material Weakness in Internal Control over Compliance • Other Matters Criteria or specific requirement: According to§ 200.302 Financial management of 2 CFR Part 200, the non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program -specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. Further, the financial management system of each non-federal entity must provide accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements. According to § 200.303 Internal controls of 2 CFR Part 200, the non-federal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition: During our testing, it was noted that the City did not have effective internal controls in place to ensure accurate reporting. Management's Progress for Repeat Findings: This is a repeated and modified finding. While the City has improved its efforts, there are still opportunities for improvement to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements as well as compliance with City policy. Questioned costs: None Context: During our testing, we noted the following exceptions related to reporting. ALN 21.027 • For the Project and Expenditure Report 5 and 6, it was noted that the City reported a total estimated revenue loss of $76,951,947.00 with 2022 accounting for $10,042,104.00 of the total. However, the City did not have any revenue loss for 2022. According to the City, its gross receipts tax grew 20.7% over the previous year in fiscal year 2022. • During the fiscal year 2023, the City incorrectly reported total cumulative expenditures of $29,700,000.00 for the Revenue Replacement First Responder Payroll project -Project Identifier Number 120. The amount reported should have been $27,130,906.00 resulting in a variance of $2,569,094.00. ALN 21.023 • For three of the four quarterly financial reports, the City was unable to reconcile the expenditure reports used as supporting documentation to the current quarter expenditures reported to the Treasury nor the schedule of expenditures of federal awards. Total variance of approximately $404,951 with ERAl Q3 2022 of $173,499, ERA2 Q4 2022 of $61,196, andERA2 Ql 2023 of$170,256. • For one of the five performance reports, the City was unable to provide documentation supporting the Total Dollar Amount of ERA funds Paid (Expended) and (Obligated) for Administrative Expenses of$312,822 related to key line item one -Administrative Costs Ratio. This is ERA Compliance Report for ERAl Q3 2022. • For one of the five performance reports, the City was unable to provide documentation supporting the number of unique households that received ERAl assistance over the award period of performance by income categories of 4,426 nor the number of unique recipient households whose income eligibility was determined based on their eligibility for other federal benefit programs of 9,489 related to key line item three -System for Prioritizing Assistance. This is ERA Compliance Report for ERAl Final Report. • For two of the five performance reports, it was noted that the total households receiving assistance was greater than the sum of Area Median Income (AMI) banded eligible households with a 5 to 10% margin of error to avoid false positives for medium to large recipients by 513 and 5,355 for ERAl Q3 2022 and ERAl Final Report, respectively. This is key line item four -Participant Households at Certain Income Levels Eligibility. • For one of the five performance reports, we were unable to trace the reported data to records that accumulate and summarize data for key line items one through four as the Demographics and Award Activity Amounts Approved (Obligated) and Amounts Paid (Expended) During the Quarter are blank in the Treasury report provided to us. This is ERA Compliance Report for ERA2 Ql 2023. Cause: Specific to the Project and Expenditure Report 5 and 6, the 2022 estimated revenue loss of $10,042,104.00 is a duplicate of the 2020 estimated revenue loss of $10,042,104.00. The City failed to identify this error prior to submission of the reports to the Treasury. Specific to the Revenue Replacement First Responder Payroll project, the City did not perform a comparison of actual expenditures to the total estimated revenue loss to ensure the limit for the amount of SLFRF funds that can be used to "provide government services" was not exceeded by the City. During the audit, the City posted an entry moving the expenditures of $2,569,094 to the General Fund. Specific to the remaining, the City lacks effective internal controls over financial grant management to ensure submitted reports are accurate and agree to supporting documentation. Effect: The auditor noted instances of noncompliance. Recommendation: We recommend the City implement a secondary review process of reports and supporting documentation prior to certification and submission of reports to federal funding agencies. Management Response: The City agrees with the finding. The Treasury Portal automatically fills in the amounts for revenue loss for 2022 with amounts reported in 2020. The Treasury portal has many flaws that would cause errors in reporting. In addition, the portal has changed every quarter, which makes it challenging to report accurately. The City will implement controls to ensure that a second review is completed prior to certification of the report. Additionally, the Grant Administrator will work with department staff responsible for reporting and ensure that each report's supporting documentation is complete and ties to underlying subrecipient reports, the general ledger and grantor reports. All supporting documentation, along with a copy of the submitted report, will be stored in a central location to ensure that they are available for subsequent reviews and audits. This will be completed by June 30, 2024. Timeline and Responsible Position: June 2024 - City Controller and Grants Administrator
Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds (SLFRF) Emergency Rental Assistance Program Assistance Listing Number: 21.027 and 21.023 Federal Award Identification Number and Year: ALN 21.027 -Pub. L. No. 117-2 2021 ALN 21.023 -ERA0335 2021 ALN 21.023 - ERAOl 14 2021 Award Period: ALN 21.027 - 5/10/2021 - 12/31/2026 ALN 21.023 - 1/20/2021 - 9/30/2022 ALN 21.023 - 5/17/2021 - 9/30/2025 Type of Finding: • Material Weakness in Internal Control over Compliance • Other Matters Criteria or specific requirement: According to§ 200.302 Financial management of 2 CFR Part 200, the non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program -specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. Further, the financial management system of each non-federal entity must provide accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements. According to § 200.303 Internal controls of 2 CFR Part 200, the non-federal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition: During our testing, it was noted that the City did not have effective internal controls in place to ensure accurate reporting. Management's Progress for Repeat Findings: This is a repeated and modified finding. While the City has improved its efforts, there are still opportunities for improvement to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements as well as compliance with City policy. Questioned costs: None Context: During our testing, we noted the following exceptions related to reporting. ALN 21.027 • For the Project and Expenditure Report 5 and 6, it was noted that the City reported a total estimated revenue loss of $76,951,947.00 with 2022 accounting for $10,042,104.00 of the total. However, the City did not have any revenue loss for 2022. According to the City, its gross receipts tax grew 20.7% over the previous year in fiscal year 2022. • During the fiscal year 2023, the City incorrectly reported total cumulative expenditures of $29,700,000.00 for the Revenue Replacement First Responder Payroll project -Project Identifier Number 120. The amount reported should have been $27,130,906.00 resulting in a variance of $2,569,094.00. ALN 21.023 • For three of the four quarterly financial reports, the City was unable to reconcile the expenditure reports used as supporting documentation to the current quarter expenditures reported to the Treasury nor the schedule of expenditures of federal awards. Total variance of approximately $404,951 with ERAl Q3 2022 of $173,499, ERA2 Q4 2022 of $61,196, andERA2 Ql 2023 of$170,256. • For one of the five performance reports, the City was unable to provide documentation supporting the Total Dollar Amount of ERA funds Paid (Expended) and (Obligated) for Administrative Expenses of$312,822 related to key line item one -Administrative Costs Ratio. This is ERA Compliance Report for ERAl Q3 2022. • For one of the five performance reports, the City was unable to provide documentation supporting the number of unique households that received ERAl assistance over the award period of performance by income categories of 4,426 nor the number of unique recipient households whose income eligibility was determined based on their eligibility for other federal benefit programs of 9,489 related to key line item three -System for Prioritizing Assistance. This is ERA Compliance Report for ERAl Final Report. • For two of the five performance reports, it was noted that the total households receiving assistance was greater than the sum of Area Median Income (AMI) banded eligible households with a 5 to 10% margin of error to avoid false positives for medium to large recipients by 513 and 5,355 for ERAl Q3 2022 and ERAl Final Report, respectively. This is key line item four -Participant Households at Certain Income Levels Eligibility. • For one of the five performance reports, we were unable to trace the reported data to records that accumulate and summarize data for key line items one through four as the Demographics and Award Activity Amounts Approved (Obligated) and Amounts Paid (Expended) During the Quarter are blank in the Treasury report provided to us. This is ERA Compliance Report for ERA2 Ql 2023. Cause: Specific to the Project and Expenditure Report 5 and 6, the 2022 estimated revenue loss of $10,042,104.00 is a duplicate of the 2020 estimated revenue loss of $10,042,104.00. The City failed to identify this error prior to submission of the reports to the Treasury. Specific to the Revenue Replacement First Responder Payroll project, the City did not perform a comparison of actual expenditures to the total estimated revenue loss to ensure the limit for the amount of SLFRF funds that can be used to "provide government services" was not exceeded by the City. During the audit, the City posted an entry moving the expenditures of $2,569,094 to the General Fund. Specific to the remaining, the City lacks effective internal controls over financial grant management to ensure submitted reports are accurate and agree to supporting documentation. Effect: The auditor noted instances of noncompliance. Recommendation: We recommend the City implement a secondary review process of reports and supporting documentation prior to certification and submission of reports to federal funding agencies. Management Response: The City agrees with the finding. The Treasury Portal automatically fills in the amounts for revenue loss for 2022 with amounts reported in 2020. The Treasury portal has many flaws that would cause errors in reporting. In addition, the portal has changed every quarter, which makes it challenging to report accurately. The City will implement controls to ensure that a second review is completed prior to certification of the report. Additionally, the Grant Administrator will work with department staff responsible for reporting and ensure that each report's supporting documentation is complete and ties to underlying subrecipient reports, the general ledger and grantor reports. All supporting documentation, along with a copy of the submitted report, will be stored in a central location to ensure that they are available for subsequent reviews and audits. This will be completed by June 30, 2024. Timeline and Responsible Position: June 2024 - City Controller and Grants Administrator
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.
Federal program: Water and Waste Disposal Systems for Rural Communities Assistance listing number: 10.760 Federal agency: U.S. Department of Agriculture Pass-through entity: n/a – direct award Pass-through entity identification number: n/a Type of Finding: Significant deficiency in internal control over compliance. Criteria: Per 2 CFR Section 200.302(b)(6), and 200.302(b)(7), a non-federal agency must establish written procedures related to the following: receipt of payment of federal funds and determination of allowability of costs in accordance with Subpart E – Cost Principles, respectively. Condition: The Town has not formally adopted certain required written financial management policies as outlined in the Code of Federal Regulations. Cause: Town personnel were unaware of this requirement. Effect: Transactions could occur that did not comply with federal regulations. Questioned costs: None Repeat finding: The Town of Bridgewater, Vermont was not required to have a Single Audit for its prior fiscal year. Accordingly, this is not a repeat finding. Perspective information: The finding was based on requesting the Town’s written financial policies related to federal compliance and therefore was not the result of a statistical sample. Recommendation: The auditor recommends that the Town obtain an understanding of the required written policies in the Code of Federal Regulations as applicable to its federal programs, create and formally adopt those required policies.
Federal program: Water and Waste Disposal Systems for Rural Communities Assistance listing number: 10.760 Federal agency: U.S. Department of Agriculture Pass-through entity: n/a – direct award Pass-through entity identification number: n/a Type of Finding: Significant deficiency in internal control over compliance. Criteria: 2 CFR 200.302 “Financial Management” requires the Town’s accounting system to identify all Federal awards received and expended and the Federal program under which they were received. Condition: The Town’s accounting system did not separate Federal expenditures from non-federal expenditures. Cause: Due to change in personnel, different individuals were involved in the Treasury function of the Town during the fiscal year and therefore employees did not have sufficient time, attention, and knowledge to effectively record federal expenditures in the Town’s accounting system. Effect: Federal expenditures are combined with non-federal expenditures in the general ledger. Questioned costs: None Repeat finding: The Town of Bridgewater, Vermont was not required to have a Single Audit for its prior fiscal year. Accordingly, this is not a repeat finding. Perspective information: The Town normally spends less than $750,000 in federal expenditures and therefore usually is not required to have a Single Audit. For 2023, a Single Audit was required due to an emergency wastewater improvement project. Recommendation: The structure of Town’s accounting system should be modified to separate Federal and non-federal expenditures.
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.
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.
FINDING 2023-005 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. 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 to be prepared and submitted by the School Principal and reviewed by the Executive Business Director; however, no evidence of this review or oversight process could be provided. As such, the annual data reports were prepared and submitted to the IDOE without an oversight or review process to prevent, or detect and correct, errors. In addition, five of six reports submitted during the audit period were not supported by the School Corporation's records. The following errors were identified: The ESSER I, Year 2 report, which had an applicable reporting period of October 1, 2020 through June 30, 2021, reported $534,761 in expenditures; however, actual expenditures for the applicable reporting period totaled $478,883. The ESSER I, Year 3 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $0 in expenditures; however, actual expenditures for the applicable reporting period totaled $243,814.67. The ESSER II, Year 1 report, which had an applicable reporting period of July 1, 2020 to June 30, 2021, reported $733 in expenditures; however, actual expenditures for the applicable reporting period totaled $322,539. The ESSER II, Year 2 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $0 in expenditures; however, actual expenditures for the applicable reporting period totaled $276,642. The ESSER III, Year 2 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $0 in expenditures; however, actual expenditures for the applicable reporting period totaled $1,315,208. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 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 accurately submitted to the IDOE. 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 submitted accurately. 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 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. 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 to be prepared and submitted by the School Principal and reviewed by the Executive Business Director; however, no evidence of this review or oversight process could be provided. As such, the annual data reports were prepared and submitted to the IDOE without an oversight or review process to prevent, or detect and correct, errors. In addition, five of six reports submitted during the audit period were not supported by the School Corporation's records. The following errors were identified: The ESSER I, Year 2 report, which had an applicable reporting period of October 1, 2020 through June 30, 2021, reported $534,761 in expenditures; however, actual expenditures for the applicable reporting period totaled $478,883. The ESSER I, Year 3 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $0 in expenditures; however, actual expenditures for the applicable reporting period totaled $243,814.67. The ESSER II, Year 1 report, which had an applicable reporting period of July 1, 2020 to June 30, 2021, reported $733 in expenditures; however, actual expenditures for the applicable reporting period totaled $322,539. The ESSER II, Year 2 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $0 in expenditures; however, actual expenditures for the applicable reporting period totaled $276,642. The ESSER III, Year 2 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $0 in expenditures; however, actual expenditures for the applicable reporting period totaled $1,315,208. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 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 accurately submitted to the IDOE. 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 submitted accurately. 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 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. 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 to be prepared and submitted by the School Principal and reviewed by the Executive Business Director; however, no evidence of this review or oversight process could be provided. As such, the annual data reports were prepared and submitted to the IDOE without an oversight or review process to prevent, or detect and correct, errors. In addition, five of six reports submitted during the audit period were not supported by the School Corporation's records. The following errors were identified: The ESSER I, Year 2 report, which had an applicable reporting period of October 1, 2020 through June 30, 2021, reported $534,761 in expenditures; however, actual expenditures for the applicable reporting period totaled $478,883. The ESSER I, Year 3 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $0 in expenditures; however, actual expenditures for the applicable reporting period totaled $243,814.67. The ESSER II, Year 1 report, which had an applicable reporting period of July 1, 2020 to June 30, 2021, reported $733 in expenditures; however, actual expenditures for the applicable reporting period totaled $322,539. The ESSER II, Year 2 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $0 in expenditures; however, actual expenditures for the applicable reporting period totaled $276,642. The ESSER III, Year 2 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $0 in expenditures; however, actual expenditures for the applicable reporting period totaled $1,315,208. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 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 accurately submitted to the IDOE. 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 submitted accurately. 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 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. 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 to be prepared and submitted by the School Principal and reviewed by the Executive Business Director; however, no evidence of this review or oversight process could be provided. As such, the annual data reports were prepared and submitted to the IDOE without an oversight or review process to prevent, or detect and correct, errors. In addition, five of six reports submitted during the audit period were not supported by the School Corporation's records. The following errors were identified: The ESSER I, Year 2 report, which had an applicable reporting period of October 1, 2020 through June 30, 2021, reported $534,761 in expenditures; however, actual expenditures for the applicable reporting period totaled $478,883. The ESSER I, Year 3 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $0 in expenditures; however, actual expenditures for the applicable reporting period totaled $243,814.67. The ESSER II, Year 1 report, which had an applicable reporting period of July 1, 2020 to June 30, 2021, reported $733 in expenditures; however, actual expenditures for the applicable reporting period totaled $322,539. The ESSER II, Year 2 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $0 in expenditures; however, actual expenditures for the applicable reporting period totaled $276,642. The ESSER III, Year 2 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $0 in expenditures; however, actual expenditures for the applicable reporting period totaled $1,315,208. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 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 accurately submitted to the IDOE. 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 submitted accurately. 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 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. 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 to be prepared and submitted by the School Principal and reviewed by the Executive Business Director; however, no evidence of this review or oversight process could be provided. As such, the annual data reports were prepared and submitted to the IDOE without an oversight or review process to prevent, or detect and correct, errors. In addition, five of six reports submitted during the audit period were not supported by the School Corporation's records. The following errors were identified: The ESSER I, Year 2 report, which had an applicable reporting period of October 1, 2020 through June 30, 2021, reported $534,761 in expenditures; however, actual expenditures for the applicable reporting period totaled $478,883. The ESSER I, Year 3 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $0 in expenditures; however, actual expenditures for the applicable reporting period totaled $243,814.67. The ESSER II, Year 1 report, which had an applicable reporting period of July 1, 2020 to June 30, 2021, reported $733 in expenditures; however, actual expenditures for the applicable reporting period totaled $322,539. The ESSER II, Year 2 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $0 in expenditures; however, actual expenditures for the applicable reporting period totaled $276,642. The ESSER III, Year 2 report, which had an applicable reporting period of July 1, 2021 to June 30, 2022, reported $0 in expenditures; however, actual expenditures for the applicable reporting period totaled $1,315,208. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. . . ." 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 accurately submitted to the IDOE. 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 submitted accurately. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Indiana 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include 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 ESSERI II reports, and two ESSER III reports for a total of six reports. The reports were prepared and submitted by the Finance Manager without a documented oversight or review process. In addition, four of the six annual data reports were not supported by the School Corporation's records. The financial information provided did not agree to the data submitted; therefore, we could not determine the accuracy of the annual data reports. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 17 NORTHWESTERN 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. . . ." 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, reports 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 that the records of the School Corporation support the expenditures reported on the reports submitted on behalf of the COVID-19 - Education Stabilization Fund. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Indiana 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include 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 ESSERI II reports, and two ESSER III reports for a total of six reports. The reports were prepared and submitted by the Finance Manager without a documented oversight or review process. In addition, four of the six annual data reports were not supported by the School Corporation's records. The financial information provided did not agree to the data submitted; therefore, we could not determine the accuracy of the annual data reports. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 17 NORTHWESTERN 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. . . ." 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, reports 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 that the records of the School Corporation support the expenditures reported on the reports submitted on behalf of the COVID-19 - Education Stabilization Fund. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Indiana 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include 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 ESSERI II reports, and two ESSER III reports for a total of six reports. The reports were prepared and submitted by the Finance Manager without a documented oversight or review process. In addition, four of the six annual data reports were not supported by the School Corporation's records. The financial information provided did not agree to the data submitted; therefore, we could not determine the accuracy of the annual data reports. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 17 NORTHWESTERN 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. . . ." 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, reports 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 that the records of the School Corporation support the expenditures reported on the reports submitted on behalf of the COVID-19 - Education Stabilization Fund. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Indiana 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include 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 ESSERI II reports, and two ESSER III reports for a total of six reports. The reports were prepared and submitted by the Finance Manager without a documented oversight or review process. In addition, four of the six annual data reports were not supported by the School Corporation's records. The financial information provided did not agree to the data submitted; therefore, we could not determine the accuracy of the annual data reports. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 17 NORTHWESTERN 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. . . ." 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, reports 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 that the records of the School Corporation support the expenditures reported on the reports submitted on behalf of the COVID-19 - Education Stabilization Fund. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Indiana 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include 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 ESSERI II reports, and two ESSER III reports for a total of six reports. The reports were prepared and submitted by the Finance Manager without a documented oversight or review process. In addition, four of the six annual data reports were not supported by the School Corporation's records. The financial information provided did not agree to the data submitted; therefore, we could not determine the accuracy of the annual data reports. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 17 NORTHWESTERN 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. . . ." 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, reports 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 that the records of the School Corporation support the expenditures reported on the reports submitted on behalf of the COVID-19 - Education Stabilization Fund. 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 Program: Various, including AL 20.509 – Formula Grants for Rural Areas and Tribal Transit Program – Reporting Grant Number & Year: Various Federal Grantor Agency: Various, including U.S. Department of Transportation Pass-Through Entity: Various, including Nebraska Department of Transportation Criteria: Title 2 of the U.S. Code of Federal Regulations (CFR) § 200.510(b) (January 1, 2023) states, in part, the following: The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with § 200.502. . . . (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. . . . Title 2 CFR § 200.302(b) (January 1, 2023) states, in relevant part, the following: The financial management system of each non-Federal entity must provide for the following . . . (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number and year, name of the Federal agency, and name of the pass-through entity, if any. Title 2 CFR § 200.303 (January 1, 2023) states the following, in relevant 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). Title 2 CFR § 200.511(a) (January 1, 2023) requires the auditee to prepare a summary schedule of prior audit findings. Per subsection (b)(2) of that same regulation, “When audit findings were not corrected or were only partially corrected, the summary schedule must describe the reasons for the finding’s recurrence and planned corrective action, and any partial corrective action taken.” The U.S. Department of Transportation adopted the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards in Title 2 CFR § 1201.10 (January 1, 2023). A good internal control plan requires adequate procedures to ensure the Schedule of Expenditures Federal Awards (SEFA) is properly presented and includes all Federal expenditures made by the County during the fiscal year. Condition: Kimball County does not have adequate procedures in place to ensure the SEFA is prepared accurately and includes all Federal expenditures of the County. Consequently, there were numerous errors in the SEFA that were identified by the auditors. A similar finding was noted during the fiscal year 2022 audit. The Summary Schedule of Prior Audit Findings lists the status of this finding as complete. Repeat Finding: Finding # 2022-002 Questioned Costs: None Statistical Sample: No Context: Specifically, we noted the following errors during our audit: • Fiscal year 2023 Federal expenditures of $276,566 were improperly omitted from the SEFA for Assistance Listing 20.509. • Fiscal year 2022 Federal expenditures of $92,389 were improperly included as fiscal year 2023 expenditures for Assistance Listing 20.509. • Non-Federal expenditures of $253,869 were improperly included as Federal Expenditures for Assistance Listing 20.509. These expenditures were paid with State funds and, therefore, should not have been included on the SEFA. • The SEFA provided by Kimball County did not include the assistance listing number to which the expenditures were related, nor did it identify the name of the pass-through entity or the identifying number assigned by the pass-through entity. Corrections were made for these errors after they were identified by the auditors to ensure the SEFA was properly presented. Cause: Kimball County continues to lack personnel with adequate knowledge of Federal reporting and compliance requirements to prepare an accurate SEFA. Effect: Increased risk for the SEFA to be inaccurate, which could lead to Federal sanctions or failure to audit programs that should be audited. Recommendation: We recommend the County work with their pass-through entities to obtain training necessary to understand fully Federal reporting and compliance requirements, including how to prepare the SEFA accurately. View of Officials: The information provided to the auditors regarding the SEFA did contain additional information such as the Federal and State reimbursements for the months before and after the fiscal year. While it is our responsibility to provide just the information required, the information was trackable and accurate per month.
FINDING 2023-009 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 Number and Year (or Other Identifying Number): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context 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. The annual data reports were prepared by the Chief Financial Officer and reviewed by a second knowledgeable individual; however, this process did not allow for the prevention, or detection and correction, of errors prior to submission. INDIANA STATE BOARD OF ACCOUNTS 30 MADISON-GRANT UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Due to the lack of effective internal controls, one of the six annual data reports was not supported by the School Corporation's records. For the ESSER 1, Year 2 report, which covered the period of October 1, 2020 to June 30, 2021, the School Corporation's records did not support the data reported. The total expenditures were not correct and the key line item did not match to the records of the unit. The lack of internal controls and noncompliance were 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.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, the ESSER I, Year 2 report was 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. INDIANA STATE BOARD OF ACCOUNTS 31 MADISON-GRANT UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure that all expenditures are reported on the reports submitted on behalf of the COVID-19 - 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. INDIANA STATE BOARD OF ACCOUNTS 32
2023-002 - Significant Deficiency - Coronavirus State & Local Fiscal Recovery Funds - Lack of Written Policies and Procedures including Suspension & Debarment and Conflict of Interest Federal Expenditures Compliance Requirement: Procurement and Written Policies ALN Number: 21.027 Criteria: Title 2 of the U.S. Code of Federal Regulations (CFR) 180.300 (January 1, 2021) requires non-federal entities to verify an entity is not excluded or disqualified prior to entering into a covered transaction by, "(a) Checking SAM Exclusions; or (b) Collecting a certification from that [entity]; or (c) Adding a clause or condition to the covered transaction with that [entity]." A good internal control plan requires adequate procedures to ensure the County has proper procedures in place to verify that contractors paid with grant funds are not suspended, debarred, or otherwise excluded from or ineligible for participation in Federal programs or activities. The Uniform Guidance requires nonfederal entities that receive federal awards to establish written policies, procedures, and or/standards of conduct, except if excluded in compliance supplement. There are four basic reasons for creating an internal control system through defining and documenting processes with well-written policies and procedures: 1. Compliance 2. Operational Needs 2. Managing Risks 4. Continuous Improvement Complying with laws and regulations should be a critical funciton of the County. Well-defined and documented processes (i.e. procedures, training manuals) along with records that demonstrate process capability can make evident an effective internal control system and compliance to Federal guidelines. Another important role of documentation of procedures is to ensure processes fundamental to the County are properly guided by County's officials, and are consistent way that meets the County's needs, and that are important related information and data are captured and communicated. Documentation of procedures are important for controlling process, documenting the standard work that was performed and training new employees. Condition: The County lacks certain written policies and procedures required by Uniform Guidance. Although the County has an outdated Accounting Policy, certain policies for Federal Expenditures need to be updated and added. These include: 1. Financial management (200.302) 2. Payment (200.305) 3. General procurement standards (200.318) 4. Competition (200.319) 5. Methods of procurement to be followed (200.320) 6. Compensation - personal services (200.430) 7. Compensation - fringe benefits (200.431) 8. Relocation costs of employees (200.464) 9. Travel costs (200.474) Cause: Appears to be the result of a lack of training coupled with limited staffing and resources. Questioned Costs: None Context for Calculation of Questioned Costs: None Effect: Without adequate procedures to ensure contractors are not suspended, debarred or otherwise excluded from or ineligible for participation in Federal programs or activities, there is an increased risk for the misuse of Federal funds and noncompliance with Federal regulations. Recommendation: We recommend the County implement proceduresto ensure, prior to entering into a covered transaction, that a contractor in not syspended, bebarred, or otherwise excluded from or ineligible for participation in Federal programs or activities, and that procedures is adequately documented. Furthermore, the County should familiarize themselves with the Uniform Guidance and implement the following: 1. Develop and document all of its significant processes over federal awards. 2. Make the written policies and procedures available to all personnel and departments within the County. 3. Ensure the written policies and procedures are accurate, complete, and current at all times (The Board of County Commissioners should update the policy on an annual basis.) 4. Revise policies and procedures for changes in business processes and policies over federal awards. 5. Communicate significant changes to all affected personnel immediately to ensure they are aware of any revisions to their responsibilities to the federal award. 6. Document policies and procedures to facilitate training and provide guidelines relative to federal awards for changes in personnel.
2023-008 – Internal Controls Over Compliance Federal Program: Refugee and Entrant Assistance Program Federal Agency: U.S. Department of Health and Human Services Assistance Listing Number: 93.566 Repeat of Prior Finding: No Type of Finding: Significant Deficiency in Internal Controls Over Compliance Criteria In accordance with 2 CFR § 200.302, the Organizations’ financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statues, regulations, and the terms and conditions of the federal award. Additionally, as required by 2 CFR 200.302(b)(4), the non-federal entity must exercise effective control over, and accountability for, all federal funds. Per 2 CFR. 200.303(a), the non-federal entity should use the Internal Control Integrated Framework issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) as a guideline. The COSO guideline indicates that proper segregation of duties between initiating, recording, and authorizing is a best practice as well as retaining documentation of performance and authorization controls. Condition and Context During our audit it was noted that the Organization had inadequate segregation of duties over cash disbursements. Further, written policies concerning cash management practices were not followed and there are no written policies in place regarding written approval of expenses prior to submitting requests for reimbursement. Cause Lack of segregation of incompatible tasks and written policies were not consistently followed. Effect or Potential Effect Lack of internal controls around supervising and authorizing cash management and financial management systems could result in mismanagement of federal funds. Questioned Costs None noted. Recommendations Initiating, authorizing, and recording transaction should not be performed by the same individual. Segregation of incompatible tasks should be implemented so that authorization and review of cash draws of federal or state funds is done by someone other than the individual who initiates and records the transaction. Additionally, there should be written policies in place surrounding cash management. Views of Responsible Officials and Planned Corrective Actions Management agrees with the finding and recommendations. See the attached corrective action plan.