FA 2022-001 Improve Controls over Cash Management Compliance Requirement: Cash Management Internal Control Impact: Significant Deficiency Compliance Impact: Nonmaterial Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Numbers and Titles: COVID-19 ? 84.425D ? Elementary and Secondary School Emergency Relief Fund COVID-19 ? 84.425U ? American Rescue Plan Elementary and Secondary School Emergency Relief Fund Federal Award Numbers: S425D210012 (Year: 2021), S425U210012 (Year: 2021) Questioned Costs: $195,559 Description: The School District made cash drawdowns in excess of the immediate cash needs of the Elementary and Secondary School Emergency Relief Fund program. Background Information: The School District may request Elementary and Secondary School Emergency Relief (ESSER) Fund program funds from the Georgia Department of Education (GaDOE) once per month. GaDOE requires the School District to submit DE-0147 ? Requests for Reimbursement of Monthly Cash Disbursements through the Grants Accounting Online Reporting System to receive program funds. When a DE-0147 request is submitted and approved, the ESSER program funds are typically disbursed to the School District through an electronic payment process the next week. The School District submitted DE-0147 requests to receive a total of $4,407,030 in ESSER program funds from GaDOE for the fiscal year under review. Criteria: As a recipient of federal awards, the School District is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 ? Internal Controls. Provisions included in the Uniform Guidance Section 200.305(b) state that for ?For non-Federal entities other than states, payments methods must minimize the time elapsing between the transfer of funds from? the pass-through entity and the disbursement by the non-Federal entity.? In addition, the Uniform Guidance Section 200.302(b)(6) requires that the entity develop written cash management procedures. Condition: Upon testing ESSER program revenues and expenditures recorded on the financial statements, potential deficiencies in the cash management process were identified. Therefore, a review of all cash drawdowns and disbursements related to the ESSER program was performed to determine if any excessive drawdowns were made during the year under review. Excessive drawdown requests totaling $195,559 were identified. Cause: Drawdowns in excess of expenditures were caused by an error made by School District personnel when requesting ESSER funds. These excessive drawdowns were primarily the result of the School District requesting reimbursement for expenditures that had not been incurred by year end. Effect: The School District was not in compliance with the Uniform Guidance and GaDOE guidance. In addition, the School District could potentially accrue an interest liability that would be owed back to the federal government. Furthermore, when the School District cannot meet the requirement to minimize the time elapsing between the transfer of funds and disbursement of those funds, provisions included in the Uniform Guidance allow GaDOE to change the method by which the School District is transferred funds and delay the School District?s receipt of these funds. This may include requirement by GaDOE to submit invoices prior to being reimbursed for ESSER program expenditures. Recommendation: The School District should establish procedures to accurately forecast the cash needs of the ESSER program and minimize the time elapsing between the transfer of funds from GaDOE and the disbursement of such funds by the School District. In addition, these procedures should be documented in writing in accordance with the Uniform Guidance Section 200.302(b)(6). Furthermore, management should develop and implement a monitoring process to ensure that these procedures are followed. Views of Responsible Officials: We concur with this finding.
Compliance Requirement: Procurement and Written Policies ALN Number: 10.664 Grant Number: 18-DG-11020000-050 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 3.Managing Risks 4.Continuous Improvement Complying with laws and regulations should be a critical function 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 procedures to ensure, prior to entering into a covered transaction, that a contractor in not suspended, debarred, 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.
Compliance Requirement: Procurement and Written Policies ALN Number: 10.664 Grant Number: 18-DG-11020000-050 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 3.Managing Risks 4.Continuous Improvement Complying with laws and regulations should be a critical function 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 procedures to ensure, prior to entering into a covered transaction, that a contractor in not suspended, debarred, 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.
Reference Number: 2022-027 Prior Year Finding: No Federal Agency: U.S. Department of Education State Agency: Agency of Education (Agency) Federal Program: COVID-19 ? Governor?s Emergency Education Relief Fund COVID-19 ? Elementary and Secondary School Emergency Relief Fund (ESSER) COVID-19 ? Coronavirus Response and Relief Supplemental Appropriations Act, 2021 ? Emergency Assistance to Non-Public Schools (CRRSA EANS) COVID-19 ? American Rescue Plan ? Elementary and Secondary School Emergency Relief (ARP ESSER) Assistance Listing Number: 84.425C, 84.425D, 84.425R, 84.425U Award Number and Year: S425D200011 (4/29/2020 ? 9/30/2021) S425D210011 (1/5/2021 ? 9/30/2022) S425C200009 (5/6/2020 ? 9/30/2021) S425C210009 (1/8/2021 ? 9/30/2022) S425U210011 (3/24/2021 ? 9/30/2023) S425R210033 (2/23/2021 ? 9/30/2022) S425W210047 (4/23/2021 ? 9/30/2023) S425V210033 (1/21/2021 ? 9/30/2023) Compliance Requirement: Cash Management Type of Finding Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per 2 CFR 200.302, each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; 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. Control: Per 2 CFR section 200.303(a), a 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. These internal controls should comply 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). Condition: The Agency of Education (Agency) was not able to support that the amount it had drawn down for the program was accurate and was supported by expenditures recorded in its accounting system and reported on the Schedule of Expenditures of Federal Awards (SEFA.) The total draws by the Agency were less than the total expenditures on the SEFA. Context: The Agency of Education (Agency) was unable to provide supporting documentation for the amount it had drawn down for the program as compared to expenditures it had incurred and reported on the Schedule of Expenditures of Federal Awards (SEFA). Auditors noted that total draws were $7.4 million (approximately 10%) less than expenditures reported on the SEFA. The Agency was unable to reconcile this variance. Cause: The Agency?s procedures and internal controls were not sufficient to account for timing differences and ensure that cash draws were complete, accurate and tied to expenditures incurred in its accounting system as reported on the SEFA. Effect: Auditors were unable to verify that cash draw population provided for testing was complete, accurate and supported by documentation recorded in the Agency?s accounting system. Questioned costs: Undetermined. Recommendation: We recommend the Agency review and enhance internal controls and procedures over cash management to ensure that cash draws are complete, accurate, and that supporting documentation is maintained and agrees with expenditures recorded in its accounting system. Views of responsible officials: Management agrees with the finding.
Reference Number: 2022-027 Prior Year Finding: No Federal Agency: U.S. Department of Education State Agency: Agency of Education (Agency) Federal Program: COVID-19 ? Governor?s Emergency Education Relief Fund COVID-19 ? Elementary and Secondary School Emergency Relief Fund (ESSER) COVID-19 ? Coronavirus Response and Relief Supplemental Appropriations Act, 2021 ? Emergency Assistance to Non-Public Schools (CRRSA EANS) COVID-19 ? American Rescue Plan ? Elementary and Secondary School Emergency Relief (ARP ESSER) Assistance Listing Number: 84.425C, 84.425D, 84.425R, 84.425U Award Number and Year: S425D200011 (4/29/2020 ? 9/30/2021) S425D210011 (1/5/2021 ? 9/30/2022) S425C200009 (5/6/2020 ? 9/30/2021) S425C210009 (1/8/2021 ? 9/30/2022) S425U210011 (3/24/2021 ? 9/30/2023) S425R210033 (2/23/2021 ? 9/30/2022) S425W210047 (4/23/2021 ? 9/30/2023) S425V210033 (1/21/2021 ? 9/30/2023) Compliance Requirement: Cash Management Type of Finding Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per 2 CFR 200.302, each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; 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. Control: Per 2 CFR section 200.303(a), a 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. These internal controls should comply 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). Condition: The Agency of Education (Agency) was not able to support that the amount it had drawn down for the program was accurate and was supported by expenditures recorded in its accounting system and reported on the Schedule of Expenditures of Federal Awards (SEFA.) The total draws by the Agency were less than the total expenditures on the SEFA. Context: The Agency of Education (Agency) was unable to provide supporting documentation for the amount it had drawn down for the program as compared to expenditures it had incurred and reported on the Schedule of Expenditures of Federal Awards (SEFA). Auditors noted that total draws were $7.4 million (approximately 10%) less than expenditures reported on the SEFA. The Agency was unable to reconcile this variance. Cause: The Agency?s procedures and internal controls were not sufficient to account for timing differences and ensure that cash draws were complete, accurate and tied to expenditures incurred in its accounting system as reported on the SEFA. Effect: Auditors were unable to verify that cash draw population provided for testing was complete, accurate and supported by documentation recorded in the Agency?s accounting system. Questioned costs: Undetermined. Recommendation: We recommend the Agency review and enhance internal controls and procedures over cash management to ensure that cash draws are complete, accurate, and that supporting documentation is maintained and agrees with expenditures recorded in its accounting system. Views of responsible officials: Management agrees with the finding.
Reference Number: 2022-027 Prior Year Finding: No Federal Agency: U.S. Department of Education State Agency: Agency of Education (Agency) Federal Program: COVID-19 ? Governor?s Emergency Education Relief Fund COVID-19 ? Elementary and Secondary School Emergency Relief Fund (ESSER) COVID-19 ? Coronavirus Response and Relief Supplemental Appropriations Act, 2021 ? Emergency Assistance to Non-Public Schools (CRRSA EANS) COVID-19 ? American Rescue Plan ? Elementary and Secondary School Emergency Relief (ARP ESSER) Assistance Listing Number: 84.425C, 84.425D, 84.425R, 84.425U Award Number and Year: S425D200011 (4/29/2020 ? 9/30/2021) S425D210011 (1/5/2021 ? 9/30/2022) S425C200009 (5/6/2020 ? 9/30/2021) S425C210009 (1/8/2021 ? 9/30/2022) S425U210011 (3/24/2021 ? 9/30/2023) S425R210033 (2/23/2021 ? 9/30/2022) S425W210047 (4/23/2021 ? 9/30/2023) S425V210033 (1/21/2021 ? 9/30/2023) Compliance Requirement: Cash Management Type of Finding Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per 2 CFR 200.302, each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; 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. Control: Per 2 CFR section 200.303(a), a 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. These internal controls should comply 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). Condition: The Agency of Education (Agency) was not able to support that the amount it had drawn down for the program was accurate and was supported by expenditures recorded in its accounting system and reported on the Schedule of Expenditures of Federal Awards (SEFA.) The total draws by the Agency were less than the total expenditures on the SEFA. Context: The Agency of Education (Agency) was unable to provide supporting documentation for the amount it had drawn down for the program as compared to expenditures it had incurred and reported on the Schedule of Expenditures of Federal Awards (SEFA). Auditors noted that total draws were $7.4 million (approximately 10%) less than expenditures reported on the SEFA. The Agency was unable to reconcile this variance. Cause: The Agency?s procedures and internal controls were not sufficient to account for timing differences and ensure that cash draws were complete, accurate and tied to expenditures incurred in its accounting system as reported on the SEFA. Effect: Auditors were unable to verify that cash draw population provided for testing was complete, accurate and supported by documentation recorded in the Agency?s accounting system. Questioned costs: Undetermined. Recommendation: We recommend the Agency review and enhance internal controls and procedures over cash management to ensure that cash draws are complete, accurate, and that supporting documentation is maintained and agrees with expenditures recorded in its accounting system. Views of responsible officials: Management agrees with the finding.
Reference Number: 2022-027 Prior Year Finding: No Federal Agency: U.S. Department of Education State Agency: Agency of Education (Agency) Federal Program: COVID-19 ? Governor?s Emergency Education Relief Fund COVID-19 ? Elementary and Secondary School Emergency Relief Fund (ESSER) COVID-19 ? Coronavirus Response and Relief Supplemental Appropriations Act, 2021 ? Emergency Assistance to Non-Public Schools (CRRSA EANS) COVID-19 ? American Rescue Plan ? Elementary and Secondary School Emergency Relief (ARP ESSER) Assistance Listing Number: 84.425C, 84.425D, 84.425R, 84.425U Award Number and Year: S425D200011 (4/29/2020 ? 9/30/2021) S425D210011 (1/5/2021 ? 9/30/2022) S425C200009 (5/6/2020 ? 9/30/2021) S425C210009 (1/8/2021 ? 9/30/2022) S425U210011 (3/24/2021 ? 9/30/2023) S425R210033 (2/23/2021 ? 9/30/2022) S425W210047 (4/23/2021 ? 9/30/2023) S425V210033 (1/21/2021 ? 9/30/2023) Compliance Requirement: Cash Management Type of Finding Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per 2 CFR 200.302, each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; 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. Control: Per 2 CFR section 200.303(a), a 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. These internal controls should comply 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). Condition: The Agency of Education (Agency) was not able to support that the amount it had drawn down for the program was accurate and was supported by expenditures recorded in its accounting system and reported on the Schedule of Expenditures of Federal Awards (SEFA.) The total draws by the Agency were less than the total expenditures on the SEFA. Context: The Agency of Education (Agency) was unable to provide supporting documentation for the amount it had drawn down for the program as compared to expenditures it had incurred and reported on the Schedule of Expenditures of Federal Awards (SEFA). Auditors noted that total draws were $7.4 million (approximately 10%) less than expenditures reported on the SEFA. The Agency was unable to reconcile this variance. Cause: The Agency?s procedures and internal controls were not sufficient to account for timing differences and ensure that cash draws were complete, accurate and tied to expenditures incurred in its accounting system as reported on the SEFA. Effect: Auditors were unable to verify that cash draw population provided for testing was complete, accurate and supported by documentation recorded in the Agency?s accounting system. Questioned costs: Undetermined. Recommendation: We recommend the Agency review and enhance internal controls and procedures over cash management to ensure that cash draws are complete, accurate, and that supporting documentation is maintained and agrees with expenditures recorded in its accounting system. Views of responsible officials: Management agrees with the finding.
Finding 2022-001 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The Annual Data Reports required to be submitted could have incomplete or inaccurate data without a secondary, documented review process in place. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-001 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The Annual Data Reports required to be submitted could have incomplete or inaccurate data without a secondary, documented review process in place. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-001 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The Annual Data Reports required to be submitted could have incomplete or inaccurate data without a secondary, documented review process in place. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-001 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The Annual Data Reports required to be submitted could have incomplete or inaccurate data without a secondary, documented review process in place. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
2022-006 WATERSMART GRANT - REPORTING Federal Program Information Funding agency: U.S. Department of Interior, Bureau of Reclamation Title: Reclamation States Emergency Drought Relief ALN: 15.514 Award Year: 2021 Questioned Costs: None Type of Finding: Significant Deficiency, Other Non-Compliance Condition We noted the Village is not in compliance with requirements related to the reporting of grants. During our test work, we noted the following exceptions: ? The Village did not complete the recipient share section of the federal financial reports for 1 of 2 reports tested. ? The Village did not submit semi-annual performance progress reports (PPRs) timely for 1 of the 2 reports tested. Criteria According to ?200.302 Financial management of 2 CFR Part 200, the state?s and the other non-Federal entity?s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program specific terms and conditions. Further, the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements. According to ?200.303 Internal controls of 2 CFR Part 200, the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Effect The Village is not in compliance with federal reporting requirements. Cause The Village lacks established internal controls and procedures over financial grant management to ensure submitted reports are complete.
2022-002 Significant deficiency ? Other compliance requirements Condition: Drawdowns to Maine Department of Labor were submitted inaccurately Criteria and effect: 2 CFR 200.302 require financial reports and drawdown requests to be accurate, current and provide complete disclosure so that the State can take action to assure funds awarded are spent within specified timeframes and service providers can ensure continuity of service. Cause: Issue was caused by high staff turnover and, at times, no staffing which required board members to submit drawdown requests. Recommendation: We recommended that management develop a program to properly train and oversee staff and board members to ensure drawdowns are filed timely and accurately. Management response and corrective action plan: Management agrees and will implement the corrective action plan found on page 20 of this report. Repeat of prior finding ? reported as 2021-006 in prior audit.
2022-002 Significant deficiency ? Other compliance requirements Condition: Drawdowns to Maine Department of Labor were submitted inaccurately Criteria and effect: 2 CFR 200.302 require financial reports and drawdown requests to be accurate, current and provide complete disclosure so that the State can take action to assure funds awarded are spent within specified timeframes and service providers can ensure continuity of service. Cause: Issue was caused by high staff turnover and, at times, no staffing which required board members to submit drawdown requests. Recommendation: We recommended that management develop a program to properly train and oversee staff and board members to ensure drawdowns are filed timely and accurately. Management response and corrective action plan: Management agrees and will implement the corrective action plan found on page 20 of this report. Repeat of prior finding ? reported as 2021-006 in prior audit.
2022-002 Significant deficiency ? Other compliance requirements Condition: Drawdowns to Maine Department of Labor were submitted inaccurately Criteria and effect: 2 CFR 200.302 require financial reports and drawdown requests to be accurate, current and provide complete disclosure so that the State can take action to assure funds awarded are spent within specified timeframes and service providers can ensure continuity of service. Cause: Issue was caused by high staff turnover and, at times, no staffing which required board members to submit drawdown requests. Recommendation: We recommended that management develop a program to properly train and oversee staff and board members to ensure drawdowns are filed timely and accurately. Management response and corrective action plan: Management agrees and will implement the corrective action plan found on page 20 of this report. Repeat of prior finding ? reported as 2021-006 in prior audit.
Finding 2022-003 Assistance Listing Number: 14.231 Name of Federal Program or Cluster: Emergency Solutions Grant Program Name of Federal Agency: Department of Housing and Urban Development Name of Pass-through Entities: Wisconsin Department of Administration and City of Racine Criteria or Specific Requirement: The Code of Federal Regulations (CFR) Section 200.302 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition: Management?s grant tracking spreadsheets for federal awards were not properly updated or reviewed during the year. Cause: Due to staff turnover during the year, sufficient training for preparing grant tracking spreadsheets was not provided for new staff and no monitoring of this process was performed to ensure it was completed in a timely manner. Effect or Potential Effect: Unallowable costs could be charged to federal awards and not be detected and corrected. Repeat Finding: No Recommendation: We recommend the Organization provide additional training to staff responsible for tracking federal and state awards and utilize another member of management to review and approve the grant tracking spreadsheets routinely. Additionally, we recommend reconciliations be performed monthly between the grant spreadsheets and the financial reporting software.
Finding 2022-003 Assistance Listing Number: 14.231 Name of Federal Program or Cluster: Emergency Solutions Grant Program Name of Federal Agency: Department of Housing and Urban Development Name of Pass-through Entities: Wisconsin Department of Administration and City of Racine Criteria or Specific Requirement: The Code of Federal Regulations (CFR) Section 200.302 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition: Management?s grant tracking spreadsheets for federal awards were not properly updated or reviewed during the year. Cause: Due to staff turnover during the year, sufficient training for preparing grant tracking spreadsheets was not provided for new staff and no monitoring of this process was performed to ensure it was completed in a timely manner. Effect or Potential Effect: Unallowable costs could be charged to federal awards and not be detected and corrected. Repeat Finding: No Recommendation: We recommend the Organization provide additional training to staff responsible for tracking federal and state awards and utilize another member of management to review and approve the grant tracking spreadsheets routinely. Additionally, we recommend reconciliations be performed monthly between the grant spreadsheets and the financial reporting software.
Finding 2022-003 Assistance Listing Number: 14.231 Name of Federal Program or Cluster: Emergency Solutions Grant Program Name of Federal Agency: Department of Housing and Urban Development Name of Pass-through Entities: Wisconsin Department of Administration and City of Racine Criteria or Specific Requirement: The Code of Federal Regulations (CFR) Section 200.302 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition: Management?s grant tracking spreadsheets for federal awards were not properly updated or reviewed during the year. Cause: Due to staff turnover during the year, sufficient training for preparing grant tracking spreadsheets was not provided for new staff and no monitoring of this process was performed to ensure it was completed in a timely manner. Effect or Potential Effect: Unallowable costs could be charged to federal awards and not be detected and corrected. Repeat Finding: No Recommendation: We recommend the Organization provide additional training to staff responsible for tracking federal and state awards and utilize another member of management to review and approve the grant tracking spreadsheets routinely. Additionally, we recommend reconciliations be performed monthly between the grant spreadsheets and the financial reporting software.
Finding 2022-003 Assistance Listing Number: 14.231 Name of Federal Program or Cluster: Emergency Solutions Grant Program Name of Federal Agency: Department of Housing and Urban Development Name of Pass-through Entities: Wisconsin Department of Administration and City of Racine Criteria or Specific Requirement: The Code of Federal Regulations (CFR) Section 200.302 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition: Management?s grant tracking spreadsheets for federal awards were not properly updated or reviewed during the year. Cause: Due to staff turnover during the year, sufficient training for preparing grant tracking spreadsheets was not provided for new staff and no monitoring of this process was performed to ensure it was completed in a timely manner. Effect or Potential Effect: Unallowable costs could be charged to federal awards and not be detected and corrected. Repeat Finding: No Recommendation: We recommend the Organization provide additional training to staff responsible for tracking federal and state awards and utilize another member of management to review and approve the grant tracking spreadsheets routinely. Additionally, we recommend reconciliations be performed monthly between the grant spreadsheets and the financial reporting software.
The Lawrence County Fiscal Court Did Not Establish And Maintain Effective Internal Controls Over Compliance With Coronavirus State and Local Fiscal Recovery Fund (SLFRF) Requirements Federal Program: Assistance Listing #: 21.027 COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Award Number and Year: 2022 Name of Federal Agency: U.S. Department of the Treasury Compliance Requirements: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Reporting Type of Finding: Significant Deficiency Amount of Questioned Costs: $0 COVID Related: Yes The Lawrence County Fiscal Court transferred federal funds from the ARPA fund to the general, jail, road, LGEA, and E-911 funds without first ensuring sufficient supporting documentation of allowable expenditures during the same period as the funds were reported as expended on the Schedule of Expenditures of Federal Awards (SEFA). The county was awarded $2,975,148 in American Rescue Plan Act (ARPA) funds, receiving the first payment of $1,487,618 into the ARPA fund in May 2021, and their second payment of $1,487,530 in June 2022.The fiscal court?s transfers in total from the ARPA fund to each fund are provided below: ? General - $714,640 ? Road - $250,000 ? Jail - $40,000 ? LGEA - $25,000 ? E-911 - $10,000 ? Payroll - $217,739 These transfers from the ARPA fund were considered ?lost revenue? according to their fiscal court meeting minutes. At the time of these transfers, and until auditors inquired about the supporting documentation, the county did not maintain a list of expenditures that reconciled to the transfer total. After this inquiry, the county gathered documentation and provided auditors a reconciliation of expenditures of eligible costs that supported the amount transferred into the general fund. An effective internal control system was not in place in Lawrence County to ensure compliance with requirements related to the administration of ARPA funds and the Allowable Costs/Cost Principles compliance requirements. The lack of internal controls was a systemic issue throughout the period. Failure to establish and maintain effective internal controls over compliance with federal program requirements could subject the county to the risk of reporting ineligible expenditures on the SEFA and using grant funds for unallowable purposes. 2 CFR 200.303 states in part, ?[t]he non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award.? 2 CFR ?200.302(b) states, ?[t]he financial management system of each non-Federal entity must provide for the following ?: (2) [a]ccurate, current and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set for in ?200.328 and 200.329.? In addition, 2 CFR ?200.502(a) states, ?[t]he determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.? Therefore, the county should only include expenditures on the Schedule of Expenditures of Federal Awards (SEFA) for which there is sufficient supporting documentation. We recommend the county establish and maintain internal controls over compliance for all federal program expenditures to ensure accurate use and reporting of federal awards, including maintaining sufficient supporting documentation of expenditures that reconciles to any transfer from a federal program fund into other county funds.
FINDING 2022-009 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation completed and submitted four annual Data Collection reports (Reports) for the Elementary and Secondary School Emergency Relief (ESSER) grants and two Reports for the Governors Emergency Education Relief (GEER) grant. The reported data on three of the Reports as noted below could not be traced back to records that accumulate or summarize the data; therefore, the accuracy and completeness of the Reports could not be verified. ESSER I, Year 1 Report and GEER I, Year 1 Report The full-time equivalent (FTE) positions could not be verified. A spreadsheet that showed FTE positions was provided for audit; however, the spreadsheet had more FTE positions then what was reported due to the School Corporations software incorrectly assigning FTE positions to all items paid. ESSER III, Year 1 Report The School Corporation's ledgers indicated expenses totaling $43,084 were spent for salaries and stipends during the reporting period. However, these expenditures were not included in the report. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish effective internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-009 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation completed and submitted four annual Data Collection reports (Reports) for the Elementary and Secondary School Emergency Relief (ESSER) grants and two Reports for the Governors Emergency Education Relief (GEER) grant. The reported data on three of the Reports as noted below could not be traced back to records that accumulate or summarize the data; therefore, the accuracy and completeness of the Reports could not be verified. ESSER I, Year 1 Report and GEER I, Year 1 Report The full-time equivalent (FTE) positions could not be verified. A spreadsheet that showed FTE positions was provided for audit; however, the spreadsheet had more FTE positions then what was reported due to the School Corporations software incorrectly assigning FTE positions to all items paid. ESSER III, Year 1 Report The School Corporation's ledgers indicated expenses totaling $43,084 were spent for salaries and stipends during the reporting period. However, these expenditures were not included in the report. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish effective internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-009 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation completed and submitted four annual Data Collection reports (Reports) for the Elementary and Secondary School Emergency Relief (ESSER) grants and two Reports for the Governors Emergency Education Relief (GEER) grant. The reported data on three of the Reports as noted below could not be traced back to records that accumulate or summarize the data; therefore, the accuracy and completeness of the Reports could not be verified. ESSER I, Year 1 Report and GEER I, Year 1 Report The full-time equivalent (FTE) positions could not be verified. A spreadsheet that showed FTE positions was provided for audit; however, the spreadsheet had more FTE positions then what was reported due to the School Corporations software incorrectly assigning FTE positions to all items paid. ESSER III, Year 1 Report The School Corporation's ledgers indicated expenses totaling $43,084 were spent for salaries and stipends during the reporting period. However, these expenditures were not included in the report. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish effective internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-009 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation completed and submitted four annual Data Collection reports (Reports) for the Elementary and Secondary School Emergency Relief (ESSER) grants and two Reports for the Governors Emergency Education Relief (GEER) grant. The reported data on three of the Reports as noted below could not be traced back to records that accumulate or summarize the data; therefore, the accuracy and completeness of the Reports could not be verified. ESSER I, Year 1 Report and GEER I, Year 1 Report The full-time equivalent (FTE) positions could not be verified. A spreadsheet that showed FTE positions was provided for audit; however, the spreadsheet had more FTE positions then what was reported due to the School Corporations software incorrectly assigning FTE positions to all items paid. ESSER III, Year 1 Report The School Corporation's ledgers indicated expenses totaling $43,084 were spent for salaries and stipends during the reporting period. However, these expenditures were not included in the report. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish effective internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding # 2022-001 Type: Federal award, Significant Deficiency over Schedule of Expenditures of Federal Awards (SEFA) CFDA Number: U.S. Department of Health and Human Services 21.027 Coronavirus State and Local Fiscal Recovery Funds Requirement: The Organization should have a process in place to review the schedule of federal expenditures. The schedule of federal expenditures did not identify all federal expenditures in accordance with 2 CFR 200.302. Condition/Context: The Organization's schedule of federal expenditures did not identify all federal awards and significant adjustments were required. Effect: Total expenditures by federal funding source may not be properly reported and Uniform Guidance reporting may be inaccurate. Questioned Costs: None.
Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Financial Assistance Listing Number: 21.027 Federal Agency: U.S. Department of Treasury Award Year: 2021/22 Grant Number: N/A Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Significant Deficiency in Internal Control and Instance of Noncompliance Criteria: Title 2 CFR Section 200.302(b)(7) of the Uniform Guidance requires all non-Federal entities establish written procedures to implement the requirements for determining the allowability of costs in accordance with Subpart E ? Cost Principles and the conditions of the Federal award. Condition: The City has not established written procedures for determining allowability of costs in accordance with Subpart E ? Cost Principles or the conditions of the Federal award. Cause: The City?s procedures did not ensure the required written procedures were developed and implemented in accordance with the Uniform Guidance. Effect: The City has not complied with Title 2 CFR Section 200.302(b)(7) regarding establishing written procedures for determining the allowability of costs. Questioned Costs: None reported. Context: The condition noted above was identified during our procedures related to allowable costs. Repeat Finding from Prior Year: No Recommendation: We recommend the City establish policies and formalize written procedures related to allowable costs in accordance with Subpart E ? Cost Principles. Views of Responsible Official: Management agrees. See separately issued Corrective Action Plan.
FINDING 2022-008 Information on the federal program: Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425C200018 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a)Establish and maintain effective internal control over the Federal award that provides reasonableassurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes,regulations, and the terms and conditions of the Federal award. These internal controls should be incompliance with guidance in 'Standards for Internal Control in the Federal Government' issued by theComptroller General of the United States or the 'Internal Control Integrated Framework', issued by theCommittee of Sponsoring Organizations of the Treadway Commission (COSO)...." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2)Accurate, current, and complete disclosure of the financial results of each Federal award or program inaccordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . ." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Cause: Management had not developed an effective system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: The School Corporation did not have an effective system of internal controls to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) and the Governor?s Emergency Education Relief (GEER) annual Data Collection reports (Reports) were accurately submitted. The School Corporation had six annual data reports due during the audit period. The Full Time Equivalent (FTE) key line item on both the ESSER I, Fiscal Year 2021 and the GEER, Fiscal Year 2021 annual Data Collection reports were not accurately submitted. The lack of internal controls and noncompliance were isolated to the ESSER 1, Fiscal Year 2021 and GEER, Fiscal Year 2021 reports. Identification as a repeat finding, if applicable: No Recommendation: We recommend that the School Corporation's management establish effective internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-008 Information on the federal program: Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425C200018 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a)Establish and maintain effective internal control over the Federal award that provides reasonableassurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes,regulations, and the terms and conditions of the Federal award. These internal controls should be incompliance with guidance in 'Standards for Internal Control in the Federal Government' issued by theComptroller General of the United States or the 'Internal Control Integrated Framework', issued by theCommittee of Sponsoring Organizations of the Treadway Commission (COSO)...." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2)Accurate, current, and complete disclosure of the financial results of each Federal award or program inaccordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . ." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Cause: Management had not developed an effective system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: The School Corporation did not have an effective system of internal controls to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) and the Governor?s Emergency Education Relief (GEER) annual Data Collection reports (Reports) were accurately submitted. The School Corporation had six annual data reports due during the audit period. The Full Time Equivalent (FTE) key line item on both the ESSER I, Fiscal Year 2021 and the GEER, Fiscal Year 2021 annual Data Collection reports were not accurately submitted. The lack of internal controls and noncompliance were isolated to the ESSER 1, Fiscal Year 2021 and GEER, Fiscal Year 2021 reports. Identification as a repeat finding, if applicable: No Recommendation: We recommend that the School Corporation's management establish effective internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-008 Information on the federal program: Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425C200018 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a)Establish and maintain effective internal control over the Federal award that provides reasonableassurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes,regulations, and the terms and conditions of the Federal award. These internal controls should be incompliance with guidance in 'Standards for Internal Control in the Federal Government' issued by theComptroller General of the United States or the 'Internal Control Integrated Framework', issued by theCommittee of Sponsoring Organizations of the Treadway Commission (COSO)...." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2)Accurate, current, and complete disclosure of the financial results of each Federal award or program inaccordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . ." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Cause: Management had not developed an effective system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: The School Corporation did not have an effective system of internal controls to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) and the Governor?s Emergency Education Relief (GEER) annual Data Collection reports (Reports) were accurately submitted. The School Corporation had six annual data reports due during the audit period. The Full Time Equivalent (FTE) key line item on both the ESSER I, Fiscal Year 2021 and the GEER, Fiscal Year 2021 annual Data Collection reports were not accurately submitted. The lack of internal controls and noncompliance were isolated to the ESSER 1, Fiscal Year 2021 and GEER, Fiscal Year 2021 reports. Identification as a repeat finding, if applicable: No Recommendation: We recommend that the School Corporation's management establish effective internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-008 Information on the federal program: Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425C200018 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a)Establish and maintain effective internal control over the Federal award that provides reasonableassurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes,regulations, and the terms and conditions of the Federal award. These internal controls should be incompliance with guidance in 'Standards for Internal Control in the Federal Government' issued by theComptroller General of the United States or the 'Internal Control Integrated Framework', issued by theCommittee of Sponsoring Organizations of the Treadway Commission (COSO)...." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2)Accurate, current, and complete disclosure of the financial results of each Federal award or program inaccordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . ." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Cause: Management had not developed an effective system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect: The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: The School Corporation did not have an effective system of internal controls to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) and the Governor?s Emergency Education Relief (GEER) annual Data Collection reports (Reports) were accurately submitted. The School Corporation had six annual data reports due during the audit period. The Full Time Equivalent (FTE) key line item on both the ESSER I, Fiscal Year 2021 and the GEER, Fiscal Year 2021 annual Data Collection reports were not accurately submitted. The lack of internal controls and noncompliance were isolated to the ESSER 1, Fiscal Year 2021 and GEER, Fiscal Year 2021 reports. Identification as a repeat finding, if applicable: No Recommendation: We recommend that the School Corporation's management establish effective internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-005 Information on the federal program: Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: National School Lunch Program Assistance Listing Number: 10.555 Federal Award Numbers and Years (or Other Identifying Numbers): FY 20-21, FY 21-22 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Reporting Audit Findings: Material Weakness Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO)...." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Child Nutrition Cluster - Reporting compliance requirements. Section III ? Federal Award Findings and Questioned Costs (Continued) FINDING 2021-005 (Continued) Cause: Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Reporting compliance requirement. Questioned Costs: There were no questioned costs identified. Context: There was no documented control in place over the preparation/submission of monthly CNC reimbursement claims. The Food Service Director prepares the monthly reimbursement claims, however, there was no documentation that the reimbursement claims had been reviewed anyone other than the preparer. This was a systemic issue through the audit period. Identification as a repeat finding: No. Recommendation: We recommended that the School Corporation's management establish a documented system of internal control for review and approval related to the grant?s reporting compliance requirements Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-005 Information on the federal program: Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: National School Lunch Program Assistance Listing Number: 10.555 Federal Award Numbers and Years (or Other Identifying Numbers): FY 20-21, FY 21-22 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Reporting Audit Findings: Material Weakness Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO)...." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Child Nutrition Cluster - Reporting compliance requirements. Section III ? Federal Award Findings and Questioned Costs (Continued) FINDING 2021-005 (Continued) Cause: Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Reporting compliance requirement. Questioned Costs: There were no questioned costs identified. Context: There was no documented control in place over the preparation/submission of monthly CNC reimbursement claims. The Food Service Director prepares the monthly reimbursement claims, however, there was no documentation that the reimbursement claims had been reviewed anyone other than the preparer. This was a systemic issue through the audit period. Identification as a repeat finding: No. Recommendation: We recommended that the School Corporation's management establish a documented system of internal control for review and approval related to the grant?s reporting compliance requirements Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
2022-002 National Endowment for the Arts Promotion of the Arts Grants to Organizations and Individuals ? 45.024 Award Number - 1891454-22-C-21 Criteria or Specific Requirement ? Cash Management 2 CFR 200.302(b) of the compliance supplement requires organizations receiving federal funds to establish controls and procedures that would minimize the amount of time between drawdowns and disbursement of the funds. The NEA terms and conditions require requests for advanced payments to be limited to immediate cash needs and are not expected to exceed anticipated expenditures for a 30 day period. Condition ? M-AAA requested an advance payment in May 2022 for anticipated expenditures and did not expend all funding within the 30 day period. Questioned Costs ? None noted. Context ? During our test work, we noted that M-AAA had a refundable advance recorded at June 30, 2022. We selected four of seven invoices included in the refundable advance and noted that in three of the four selections payment was not disbursed within the 30 day period. The sample was not intended to be, and was not a statistically valid sample. Effect ? M-AAA did not comply with the 30 day period required for advanced payments. Cause ? M-AAA was waiting for additional information from subrecipients or vendors prior to disbursing funding. Identification as a Repeat Finding ? Not applicable. Recommendation ? We recommend M-AAA only request advance payments up to the amount they are able to disburse within the required time in order to minimize the time elapsing between the receipt and disbursement of federal funds. Views of Responsible Officials and Planned Corrective Actions ? M-AAA will implement procedures to minimize the time elapsing between the receipt and disbursement of federal funds.
2022-027 Oregon Housing and Community Services Ensure Monthly and Quarterly reports are accurate and adequately supported Federal Awarding Agency: U.S. Department of the Treasury Assistance Listing Number and Name: 21.023 Emergency Rental Assistance Program (COVID-19) Federal Award Numbers and Years: ERA 1, 2021 (COVID-19); ERA 2, 2021 (COVID-19) Compliance Requirement: Reporting Type of Finding: Material Weakness; Material Noncompliance Prior Year Finding: N/A Questioned Costs: N/A Criteria: 2 CFR 200.302(a) and (b)(3); 2 CFR 200.303(a), (c)-(d) Department management is responsible for establishing and maintaining effective internal control that provides reasonable assurance the department is managing, evaluating, and monitoring the federal award in compliance with the terms and conditions of the award and taking prompt action when instances of noncompliance are identified. Additionally, the department is responsible for maintaining records to allow for submission of reports that are accurate and adequately supported. We tested four randomly selected monthly reports and found one report did not accurately report the number of unique households assisted and the amount of the assistance based on the supporting documentation. The department stated the differences were likely due to a transition in subsystem reporting formats and delays in report processing. We tested four quarterly reports, two of which were randomly selected and two of which were judgmentally selected. We found one report where the cumulative obligation amount did not agree to supporting documentation and were not accurate, and one report where the cumulative obligation and cumulative expenditures amounts did not agree to supporting documentation and were not accurate. The department stated these errors were due to erroneously entered information in the federal awarding agency?s reporting portal. Information included in these reports is used by the federal awarding agency to determine whether the department qualifies for receiving reallocation payments, as well as how much of a reallocation would be awarded to the department. Errors in these reports could result in errors in the federal awarding agency?s determination of eligibility for funding, and/or the reallocation formula. We recommend department management update and correct erroneous reports and establish controls to ensure reported amounts are accurate and adequately supported.
2022-029 Oregon Housing and Community Services Ensure accessible documentation to evidence compliance with program requirements Federal Awarding Agency: U.S. Department of the Treasury Assistance Listing Number and Name: 21.023 Emergency Rental Assistance Program (COVID-19) Federal Award Numbers and Years: ERA 1, 2021 (COVID-19) Compliance Requirement: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Eligibility Type of Finding: Material Weakness Prior Year Finding: N/A Questioned Costs: N/A Criteria: 2 CFR 200.302(a); 2 CFR 200.332(a)(5) Department management is responsible for communicating to subrecipients that they are required to permit the department and auditors access to their records as necessary to ensure the department is compliant with program requirements. To ensure compliance with program requirements, subrecipient records must also be sufficiently detailed. The department passed through $140 million phase one program funds to community action agencies (subrecipients) to provide program delivery. The department performed limited fiscal monitoring during the audit period which included procedures to address compliance with activities allowed and allowable cost requirements for administrative costs. The department did not perform any program monitoring during the audit period which primarily addresses compliance with eligibility requirements. To determine whether the department complied with program requirements for the fiscal year, auditors attempted to reconcile detailed subrecipient ledgers with the intent of selecting and testing sample items at each individual subrecipient organization. We noted issues with two individual subrecipients, resulting in an inability to perform testing procedures over a total of $21,438,521 in program expenditures. For the first subrecipient we were able to reconcile their detailed ledgers to the department?s financial records, however their detailed ledger included pass-through payments to a third organization for program delivery. As a result of the combination of direct and pass-through payments, we were unable to obtain sufficiently detailed data that also reconciled to the department?s financial records to select individual transactions for testing. This subrecipient represents $19,877,962 of the unaudited expenditures. For the second subrecipient we were able to reconcile their detailed ledgers to the department?s financial records and select administrative and program transactions for testing. However, the subrecipient was unresponsive to documentation requests to substantiate expenditures. This subrecipient accounted for $1,560,559 of the unaudited expenditures. We recommend department management obtain and reconcile sufficiently detailed subrecipient ledgers and support to substantiate expenditures to allow for fiscal and program monitoring to ensure subrecipients are administering program funds in accordance with program requirements.
2022-067 Oregon Department of Education Ensure accuracy of federal reporting Federal Awarding Agency: U.S. Department of Education Assistance Listing Number and Name: 84.425C Education Stabilization Fund (COVID-19) Federal Award Numbers and Years: S425C200048; 2020 (COVID-19) Compliance Requirement: Reporting Type of Finding: Significant Deficiency; Noncompliance Prior Year Finding: N/A Questioned Costs: N/A Criteria: 2 CFR 200.302(b); 2 CFR 200.303(a) Federal regulations require that federal reports include all activity of the reporting period and be supported by applicable accounting records. Federal regulations also require that the department file a separate report for the Governor?s Emergency Education Relief (GEER) expenditures for the period ending June 30, 2021. The department reported GEER information for the local education areas (LEAs) related to the comprehensive distance learning grant program. LEAs submit reimbursement to the department and this information is tracked in an excel database. The database includes various information, including funding types, dates, and amounts. During FY 2022, the department completed the reports using the database, but incorrectly filtered the data so some expenditures were not captured. This resulted in an underreporting of GEER expenditures by $13.9 million. We recommend department management ensure that accurate expenditure data is submitted to the federal government for federal reporting.
FINDING 2022-005 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system, which would include segregation of duties, was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure reports were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, the GEER I, Year I and Year 2, and ESSER I, Year I reports were not supported by the School Corporation's records. One line item chosen for review and verification was determined to be incorrectly reported on each of these 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). . . ." 2 CFR 200.333 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.327 Financial reporting . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not designed nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-005 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system, which would include segregation of duties, was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure reports were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, the GEER I, Year I and Year 2, and ESSER I, Year I reports were not supported by the School Corporation's records. One line item chosen for review and verification was determined to be incorrectly reported on each of these 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). . . ." 2 CFR 200.333 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.327 Financial reporting . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not designed nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-005 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system, which would include segregation of duties, was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure reports were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, the GEER I, Year I and Year 2, and ESSER I, Year I reports were not supported by the School Corporation's records. One line item chosen for review and verification was determined to be incorrectly reported on each of these 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). . . ." 2 CFR 200.333 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.327 Financial reporting . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not designed nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-005 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system, which would include segregation of duties, was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure reports were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, the GEER I, Year I and Year 2, and ESSER I, Year I reports were not supported by the School Corporation's records. One line item chosen for review and verification was determined to be incorrectly reported on each of these 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). . . ." 2 CFR 200.333 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.327 Financial reporting . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not designed nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-005 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system, which would include segregation of duties, was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure reports were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, the GEER I, Year I and Year 2, and ESSER I, Year I reports were not supported by the School Corporation's records. One line item chosen for review and verification was determined to be incorrectly reported on each of these 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). . . ." 2 CFR 200.333 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.327 Financial reporting . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not designed nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-005 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system, which would include segregation of duties, was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure reports were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, the GEER I, Year I and Year 2, and ESSER I, Year I reports were not supported by the School Corporation's records. One line item chosen for review and verification was determined to be incorrectly reported on each of these 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). . . ." 2 CFR 200.333 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.327 Financial reporting . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not designed nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding 2022-005. Allowed and Unallowed Costs. (ALN 84.425U ARP ESSER III) CRITERIA: 2 CFR 200.302 requires that a non-federal entity?s financial management systems must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions. This section further requires 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, including a comparison of expenditures with budget amounts for each federal award. 2 CFR 200.303 requires that a non-federal entity must establish and maintain effective internal control over a 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: In our testing of the comparison of actual expenditures to budgeted amounts approved by the Mississippi Department of Education, we noted expenditures for the salaries and benefits for nurses exceeded approved budgeted amounts by $14,417.42. CAUSE: The school district failed to address unfavorable budgetary variances when actual expenditures exceeded approved budgeted amounts. EFFECT: The effect is both a breakdown in budgetary controls and unallowable program costs. Since these excess costs are less than $25,000.00, no costs will be questioned. QUESTIONED COSTS: None RECOMMENDATION: The district should limit expenditures to approved budgeted amounts for this grant. VIEWS OF RESPONSIBLE OFFICIALS: See the school district?s response in the auditee?s corrective action plan in this report.
2022 ? 003 Allowable Activities and Costs - Payroll Disbursements Federal Agency: U.S. Department of Treasury Centers for Disease Control and Prevention U.S. Department of Health & Human Services Federal Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Child Support Enforcement Assistance Listing Number: 21.027 93.323 93.563 Federal Award Identification Number and Year: 1505-0271 - 2021 6NU50CK000539-01-08 DHHS-CDC - 2020 Pass-Through Agency: California Department of Public Health Heluna Health California Department of Child Support Services Pass-Through Number(s): COVID-19ELC29 and COVID-19ELC87 0187.3380 21-06 Award Period: May 26, 2021 - December 31, 2026 May 18, 2020 - November 17, 2022 and January 15, 2021 - July 31, 2023 May 1, 2020 - March 31, 2022 July 1, 2021 - June 30, 2022 Type of Finding: ? Significant Deficiency in Internal Control over Compliance ? Other Matters Criteria or specific requirement: According to the Assistance Listing Description for CSLFRF and ELC, Subpart D, Post Federal; Award Requirements and Subpart E, Cost Principles apply to the assistance listing. According to the LCSA Fiscal and Administrative Policy Manual Revised 2021, costs allowable for reimbursement under the Child Support IV-D award are governed by federal regulations. Title 2, ?200.403, ?200.404, and Title 45, Part 304 provide general guidelines for determining cost allowability. According to ? 200.302 Financial management of 2 CFR Part 200, the financial management system of each nonfederal entity must provide for written procedures for determining the allowability of costs in accordance with subpart E of this part and the terms and conditions of the federal award. According to ? 200.303 Internal controls of 2 CFR Part 200, the nonfederal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the nonfederal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. According to ? 200.403 Factors affecting allowability of costs of 2 CFR Part 200, except where otherwise authorized by statute, costs must be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the nonfederal entity in order to be allowable under federal awards. According to ? 200.430 Compensation?personal services of 2 CFR Part 200, costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: 1. Is reasonable for the services rendered and conforms to the established written policy of the nonfederal entity consistently applied to both federal and nonfederal activities; 2. Follows an appointment made in accordance with a nonfederal entity's laws and/or rules or written policies and meets the requirements of federal statute, where applicable; and 3. Is determined and supported as provided in paragraph (i) of this section, when applicable. According to ? 200.431 Compensation-fringe benefits of 2 CFR Part 200, except as provided elsewhere in these principles, the costs of fringe benefits are allowable provided that the benefits are reasonable and are required by law, nonfederal entity-employee agreement, or an established policy of the nonfederal entity. Condition: The County does not have written procedures for determining the allowability of costs nor an established written policy for compensation-personal services and fringe benefits. Questioned costs: Unknown Context: During our testing, we noted the County charged various types of salaries and benefits to the grants. The County does not have written procedures for determining the allowability of costs. Specific to compensation-personal services and fringe benefits, there is not an established written policy for us to test that personnel costs charged to grants conform to, follows an appointment in accordance with, and are required by an established policy of the County. Cause: Management oversight. Effect: The auditor noted instances of noncompliance. Noncompliance results in potential unallowable costs charged to grants. Recommendation: We recommend the County establish written procedures for determining the allowability of costs to include a written policy regarding the charging of personnel costs to grants. Views of responsible officials: There is no disagreement from responsible officials.
2022 ? 005 Reporting Federal Agency: U.S. Department of Treasury Federal Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Assistance Listing Number: 21.027 Federal Award Identification Number and Year: 1505-0271 - 2021 Award Period: May 26, 2021 - December 31, 2026 Type of Finding: ? Significant Deficiency in Internal Control over Compliance ? Other Matters Criteria or specific requirement: According to ? 200.302 Financial management of 2 CFR Part 200, the nonfederal 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 nonfederal 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 nonfederal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the nonfederal 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 County did not have effective internal controls in place to ensure accurate and complete reporting. Questioned costs: None Context: During our testing, we noted the following matters related to reporting. ? For the interim report, no evidence of review and approval of the report. ? For the Project and Expenditure Report 1, total obligations reported of approximately $907,400. However, the documentation used to prepare the report has an obligated amount of approximately $3,600,000. Thus, a variance of approximately $2,700,000. ? For the Project and Expenditure Report 2, total obligations reported of approximately $3,500,000. However, the documentation used to prepare the report has an obligated amount of approximately $2,800,000. Thus, a variance of approximately $711.900. ? For the Project and Expenditure Report 1 and 2, Subaward No: SBC_01 Period of Performance Start of August 13, 2021. However, the professional services contract has a contract start date of July 13, 2021. Cause: Management oversight. Effect: The auditor noted instances of noncompliance. Noncompliance results in inaccurate reporting. Recommendation: We recommend the County design controls to ensure review and approval of reports are maintained in the County's grant files. Also, we recommend the County design controls to ensure reports agree to the documentation used to prepare them. Views of responsible officials: There is no disagreement from responsible officials.
2022 ? 003 Allowable Activities and Costs - Payroll Disbursements Federal Agency: U.S. Department of Treasury Centers for Disease Control and Prevention U.S. Department of Health & Human Services Federal Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Child Support Enforcement Assistance Listing Number: 21.027 93.323 93.563 Federal Award Identification Number and Year: 1505-0271 - 2021 6NU50CK000539-01-08 DHHS-CDC - 2020 Pass-Through Agency: California Department of Public Health Heluna Health California Department of Child Support Services Pass-Through Number(s): COVID-19ELC29 and COVID-19ELC87 0187.3380 21-06 Award Period: May 26, 2021 - December 31, 2026 May 18, 2020 - November 17, 2022 and January 15, 2021 - July 31, 2023 May 1, 2020 - March 31, 2022 July 1, 2021 - June 30, 2022 Type of Finding: ? Significant Deficiency in Internal Control over Compliance ? Other Matters Criteria or specific requirement: According to the Assistance Listing Description for CSLFRF and ELC, Subpart D, Post Federal; Award Requirements and Subpart E, Cost Principles apply to the assistance listing. According to the LCSA Fiscal and Administrative Policy Manual Revised 2021, costs allowable for reimbursement under the Child Support IV-D award are governed by federal regulations. Title 2, ?200.403, ?200.404, and Title 45, Part 304 provide general guidelines for determining cost allowability. According to ? 200.302 Financial management of 2 CFR Part 200, the financial management system of each nonfederal entity must provide for written procedures for determining the allowability of costs in accordance with subpart E of this part and the terms and conditions of the federal award. According to ? 200.303 Internal controls of 2 CFR Part 200, the nonfederal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the nonfederal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. According to ? 200.403 Factors affecting allowability of costs of 2 CFR Part 200, except where otherwise authorized by statute, costs must be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the nonfederal entity in order to be allowable under federal awards. According to ? 200.430 Compensation?personal services of 2 CFR Part 200, costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: 1. Is reasonable for the services rendered and conforms to the established written policy of the nonfederal entity consistently applied to both federal and nonfederal activities; 2. Follows an appointment made in accordance with a nonfederal entity's laws and/or rules or written policies and meets the requirements of federal statute, where applicable; and 3. Is determined and supported as provided in paragraph (i) of this section, when applicable. According to ? 200.431 Compensation-fringe benefits of 2 CFR Part 200, except as provided elsewhere in these principles, the costs of fringe benefits are allowable provided that the benefits are reasonable and are required by law, nonfederal entity-employee agreement, or an established policy of the nonfederal entity. Condition: The County does not have written procedures for determining the allowability of costs nor an established written policy for compensation-personal services and fringe benefits. Questioned costs: Unknown Context: During our testing, we noted the County charged various types of salaries and benefits to the grants. The County does not have written procedures for determining the allowability of costs. Specific to compensation-personal services and fringe benefits, there is not an established written policy for us to test that personnel costs charged to grants conform to, follows an appointment in accordance with, and are required by an established policy of the County. Cause: Management oversight. Effect: The auditor noted instances of noncompliance. Noncompliance results in potential unallowable costs charged to grants. Recommendation: We recommend the County establish written procedures for determining the allowability of costs to include a written policy regarding the charging of personnel costs to grants. Views of responsible officials: There is no disagreement from responsible officials.
2022 ? 003 Allowable Activities and Costs - Payroll Disbursements Federal Agency: U.S. Department of Treasury Centers for Disease Control and Prevention U.S. Department of Health & Human Services Federal Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Child Support Enforcement Assistance Listing Number: 21.027 93.323 93.563 Federal Award Identification Number and Year: 1505-0271 - 2021 6NU50CK000539-01-08 DHHS-CDC - 2020 Pass-Through Agency: California Department of Public Health Heluna Health California Department of Child Support Services Pass-Through Number(s): COVID-19ELC29 and COVID-19ELC87 0187.3380 21-06 Award Period: May 26, 2021 - December 31, 2026 May 18, 2020 - November 17, 2022 and January 15, 2021 - July 31, 2023 May 1, 2020 - March 31, 2022 July 1, 2021 - June 30, 2022 Type of Finding: ? Significant Deficiency in Internal Control over Compliance ? Other Matters Criteria or specific requirement: According to the Assistance Listing Description for CSLFRF and ELC, Subpart D, Post Federal; Award Requirements and Subpart E, Cost Principles apply to the assistance listing. According to the LCSA Fiscal and Administrative Policy Manual Revised 2021, costs allowable for reimbursement under the Child Support IV-D award are governed by federal regulations. Title 2, ?200.403, ?200.404, and Title 45, Part 304 provide general guidelines for determining cost allowability. According to ? 200.302 Financial management of 2 CFR Part 200, the financial management system of each nonfederal entity must provide for written procedures for determining the allowability of costs in accordance with subpart E of this part and the terms and conditions of the federal award. According to ? 200.303 Internal controls of 2 CFR Part 200, the nonfederal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the nonfederal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. According to ? 200.403 Factors affecting allowability of costs of 2 CFR Part 200, except where otherwise authorized by statute, costs must be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the nonfederal entity in order to be allowable under federal awards. According to ? 200.430 Compensation?personal services of 2 CFR Part 200, costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: 1. Is reasonable for the services rendered and conforms to the established written policy of the nonfederal entity consistently applied to both federal and nonfederal activities; 2. Follows an appointment made in accordance with a nonfederal entity's laws and/or rules or written policies and meets the requirements of federal statute, where applicable; and 3. Is determined and supported as provided in paragraph (i) of this section, when applicable. According to ? 200.431 Compensation-fringe benefits of 2 CFR Part 200, except as provided elsewhere in these principles, the costs of fringe benefits are allowable provided that the benefits are reasonable and are required by law, nonfederal entity-employee agreement, or an established policy of the nonfederal entity. Condition: The County does not have written procedures for determining the allowability of costs nor an established written policy for compensation-personal services and fringe benefits. Questioned costs: Unknown Context: During our testing, we noted the County charged various types of salaries and benefits to the grants. The County does not have written procedures for determining the allowability of costs. Specific to compensation-personal services and fringe benefits, there is not an established written policy for us to test that personnel costs charged to grants conform to, follows an appointment in accordance with, and are required by an established policy of the County. Cause: Management oversight. Effect: The auditor noted instances of noncompliance. Noncompliance results in potential unallowable costs charged to grants. Recommendation: We recommend the County establish written procedures for determining the allowability of costs to include a written policy regarding the charging of personnel costs to grants. Views of responsible officials: There is no disagreement from responsible officials.
2 CFR section 200.302(b)(3-4) states ?The financial management system of each non-Federal entity must provide for the following? (3) Records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. (4) Effective control over, and accountability for, all funds, property, and other assets. The non-Federal entity must adequately safeguard all assets and assure that they are used solely for authorized purposes.? During our audit we noted $13,612.46 of payroll expenditures were counted twice on the June 30, 2022. $13,612.46 was over claimed. This is the actual amount. We believe this was a clerical error and extrapolation wasn?t practical because of the nature of discrepancy it was difficult to quantify them against all grant expenditures as this appears to be an isolated clerical error.
2022?020 REPORTING Federal Program Information: Federal Agency and Program Name Assistance Listing # U.S. Department of Education Rehabilitation Services?Vocational Rehabilitation Grants to State 84.126 Grant Award H126A200095, H126A210095, H126A220095Criteria: 2 CFR 200.303 requires that a non-federal entity must ?(a) establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States and the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). 2 CFR 200.302(b)(2) ?Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. If a Federal awarding agency requires reporting on an accrual basis from a recipient that maintains its records on other than an accrual basis, the recipient must not be required to establish an accrual accounting system. This recipient may develop accrual data for its reports on the basis of an analysis of the documentation on hand. Similarly, a pass-through entity must not require a subrecipient to establish an accrual accounting system and must allow the subrecipient to develop accrual data for its reports on the basis of an analysis of the documentation on hand.? Condition: The West Virginia Division of Rehabilitation Services (WVDRS) is responsible for preparing the Rehabilitation Services Administration (RSA-17), Federal Financial Report, quarterly. The RSA-17 is used to track the status of financial data tied to a particular Federal Grant Award. The RSA-17 report should be complete, accurate, and prepared in accordance with the required accounting basis. There was an error in reporting where certain amounts reported did not agree to the underlying data used to prepare the reports. The Director?s review was not precise enough to detect the error. Questioned Costs: N/A Context: Total federal expenditures for the Vocational Rehabilitation Grant were $31,508,101 for the year ended June 30, 2022. Cause: WVDRS has policies and procedures in place to review the RSA-17 prior to submission; however, the review was not precise enough to identify the errors. Effect: Incorrect data could be reported to the RSA. Recommendation: We recommend that WVDRS enforce the existing policies and procedures surrounding the review and approval of the RSA-17 report prior to submission. Views of Responsible Officials: Management acknowledges the finding. See corrective action plan.
2022?032 ALLOWABILITY OF EXPENDITURES Federal Program Information: Federal Agency and Program Name Assistance Listing # U.S. Department of Health and Human Services Children?s Health Insurance Program (CHIP) 93.767 Grant Award 2005WV5021 Grant Award 2105WV5021 Grant Award 2205WV5021Criteria: 2 CFR 200.302(a) states, ?Each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state?s own funds. In addition, the state?s and the other non-Federal entity?s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; 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.? 2 CFR 200.403(g) states costs must ?Be adequately documented.? 2 CFR 200.456 states ?Participant support costs as defined in 200.1 are allowable with the prior approval of the Federal awarding agency.? Condition: During our testing of the allowability it was noted that for four out of 60 tested, the West Virginia Department of Health and Human Resources (WVDHHR) did not perform the quarterly updates to the wage index for the Outpatient Prospective Payment System (OPPS). Questioned Costs: $841.58 ? Assistance Listing #93.767 Context: The four expenditures represent $841 of the 60 expenditures selected for testing of $140,069. The federal expenditures for the CHIP program for the fiscal year ended June 30, 2022, were $75,615,993. Cause: WVDHHR did not update wage index for OPPS payments for four of the 60 expenditures. Effect: Incorrect payments may have been made for procedure codes. Recommendation: Management should develop an effective corrective action plan to address this matter in a timely manner. Views of Responsible Officials: Management concurs with the finding and has developed a plan to correct the finding.