FINDING 2023-004 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation paid $1,467,550 from the COVID-19 - Education Stabilization Fund program for two improvement projects which exceeded the School Corporation's capitalization threshold. The improvements were not added to the School Corporation's capital asset listing. Additionally, the School Corporation completed a capital asset inventory as required; however, because material improvements were not included in the capital asset listing, it was determined that the School Corporation did not reconcile differences in the property records as required. 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.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, improvements purchased were not properly added to the capital asset listing. In addition, a reconcilement between the inventory records and the property records were not completed. Noncompliance with the grant agreement and the compliance requirement could result in the loss of federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all assets. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject COVID-19 - Education Stabilization Fund - Special Tests and Provisions - Wage Rate Requirements Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Wage Rate Requirements Audit Findings: Material Weakness, Modified Opinion Condition and Context Construction contracts in excess of $2,000 financed by federal assistance funds must pay wages not less than those established for the locality of the project (prevailing wage rates) by the Department of Labor (DOL) to their laborers and mechanics. Nonfederal entities are to include in their construction contracts subject to the Wage Rate Requirements a provision that the contractor or subcontractor comply with these requirements and the DOL regulations. This would include a requirement to submit a copy of the payroll and statement of compliance to the entity for each week in which contract work was performed. The School Corporation had not designed, nor implemented a system of internal controls to ensure that construction contracts in excess of $2,000 paid from federal grant funds included a prevailing wage rate clause. Two construction contracts, totaling $1,543,551 were paid from the COVID-19 - Education Stabilization Fund grant funds during the audit period. Both contracts were tested; however, neither contract contained the required prevailing wage rate clause. Certified payrolls were submitted by the contractor for one of the contracts after the construction was completed for the contract which totaled $1,424,051; however, certified payrolls could not be obtained for the contract which totaled $119,500. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 29 CFR 5.5 states in part: "(a) The Agency head shall cause or require the contracting officer to insert in full in any contract in excess of $2,000 which is entered into for the actual construction, alteration and/or repair, including painting and decorating, of a public building or public work, or building or work financed in whole or in part from Federal funds or in accordance with guarantees of a Federal agency or financed from funds obtained by pledge of any contract of a Federal agency to make a loan, grant or annual contribution (except where a different meaning is expressly indicated), and which is subject to the labor standards provisions of any of the acts listed in § 5.1, the following clauses . . . (1) Minimum wages. (i) All laborers and mechanics employed or working upon the site of the work (or under the United States Housing Act of 1937 or under the Housing Act of 1949 in the construction or development of the project), will be paid unconditionally and not less often than once a week, and without subsequent deduction or rebate on any account (except such payroll deductions as are permitted by regulations issued by the Secretary of Labor under the Copeland Act (29 CFR part 3)), the full amount of wages and bona fide fringe benefits (or cash equivalents thereof) due at time of payment computed at rates not less than those contained in the wage determination of the Secretary of Labor which is attached hereto and made a part hereof, regardless of any contractual relationship which may be alleged to exist between the contractor and such laborers and mechanics. . . . (3) Payrolls and basic records. . . . (ii) (A) The contractor shall submit weekly for each week in which any contract work is performed a copy of all payrolls to the (write in name of appropriate federal agency) if the agency is a party to the contract, but if the agency is not such a party, the contractor will submit the payrolls to the applicant, sponsor, or owner, as the case may be, for transmission to the (write in name of agency). . . ." 2 CFR 200 Appendix II states in part: "In addition to other provisions required by the Federal agency or non-Federal entity; all contracts made by the non-Federal entity under the Federal award must contain provisions covering the following, as applicable. . . . (D) Davis-Bacon Act, as amended (40 U.S.C. 3141-3148). When required by Federal program legislation, all prime construction contracts in excess of $2,000 awarded by non- Federal entities must include a provision for compliance with the Davis-Bacon Act (40 U.S.C. 3141-3144, and 3146-3148) as supplemented by Department of Labor regulations (29 CFR Part 5, 'Labor Standards Provisions Applicable to Contracts Covering Federally Financed and Assisted Construction'). In accordance with the statute, contractors must be required to pay wages to laborers and mechanics at a rate not less than the prevailing wages specified in a wage determination made by the Secretary of Labor. In addition, contractors must be required to pay wages not less than once a week. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, construction contracts entered into did not contain the required wage rate requirements clauses nor were certified payrolls timely obtained by the School Corporation. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls and include the wage rate requirement clause in construction contracts. In addition, certified payrolls should be obtained as required. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation paid $1,467,550 from the COVID-19 - Education Stabilization Fund program for two improvement projects which exceeded the School Corporation's capitalization threshold. The improvements were not added to the School Corporation's capital asset listing. Additionally, the School Corporation completed a capital asset inventory as required; however, because material improvements were not included in the capital asset listing, it was determined that the School Corporation did not reconcile differences in the property records as required. 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.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, improvements purchased were not properly added to the capital asset listing. In addition, a reconcilement between the inventory records and the property records were not completed. Noncompliance with the grant agreement and the compliance requirement could result in the loss of federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all assets. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-001 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation had not designed an internal control system and procedures to ensure all assets purchased with federal awards were added to the property records or capital asset listing and were appropriately safeguarded and maintained. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. The School Corporation maintained and presented the equipment and real property records for the COVID-19 - Education Stabilization Fund grant equipment; however, the records failed to include a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, the use, and condition of the property. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 14 NINEVEH-HENSLEY-JACKSON UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. . . . (3) A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated. (4) Adequate maintenance procedures must be developed to keep property in good condition. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the property records for the assets acquired with COVID-19 - Education Stabilization Fund award dollars did not contain all the required elements. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-001 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation had not designed an internal control system and procedures to ensure all assets purchased with federal awards were added to the property records or capital asset listing and were appropriately safeguarded and maintained. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. The School Corporation maintained and presented the equipment and real property records for the COVID-19 - Education Stabilization Fund grant equipment; however, the records failed to include a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, the use, and condition of the property. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 14 NINEVEH-HENSLEY-JACKSON UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. . . . (3) A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated. (4) Adequate maintenance procedures must be developed to keep property in good condition. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the property records for the assets acquired with COVID-19 - Education Stabilization Fund award dollars did not contain all the required elements. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-001 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation had not designed an internal control system and procedures to ensure all assets purchased with federal awards were added to the property records or capital asset listing and were appropriately safeguarded and maintained. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. The School Corporation maintained and presented the equipment and real property records for the COVID-19 - Education Stabilization Fund grant equipment; however, the records failed to include a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, the use, and condition of the property. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 14 NINEVEH-HENSLEY-JACKSON UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. . . . (3) A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated. (4) Adequate maintenance procedures must be developed to keep property in good condition. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the property records for the assets acquired with COVID-19 - Education Stabilization Fund award dollars did not contain all the required elements. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-001 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation had not designed an internal control system and procedures to ensure all assets purchased with federal awards were added to the property records or capital asset listing and were appropriately safeguarded and maintained. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. The School Corporation maintained and presented the equipment and real property records for the COVID-19 - Education Stabilization Fund grant equipment; however, the records failed to include a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, the use, and condition of the property. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 14 NINEVEH-HENSLEY-JACKSON UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. . . . (3) A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated. (4) Adequate maintenance procedures must be developed to keep property in good condition. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the property records for the assets acquired with COVID-19 - Education Stabilization Fund award dollars did not contain all the required elements. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-001 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation had not designed an internal control system and procedures to ensure all assets purchased with federal awards were added to the property records or capital asset listing and were appropriately safeguarded and maintained. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. The School Corporation maintained and presented the equipment and real property records for the COVID-19 - Education Stabilization Fund grant equipment; however, the records failed to include a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, the use, and condition of the property. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 14 NINEVEH-HENSLEY-JACKSON UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. . . . (3) A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated. (4) Adequate maintenance procedures must be developed to keep property in good condition. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the property records for the assets acquired with COVID-19 - Education Stabilization Fund award dollars did not contain all the required elements. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-001 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation had not designed an internal control system and procedures to ensure all assets purchased with federal awards were added to the property records or capital asset listing and were appropriately safeguarded and maintained. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. The School Corporation maintained and presented the equipment and real property records for the COVID-19 - Education Stabilization Fund grant equipment; however, the records failed to include a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, the use, and condition of the property. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 14 NINEVEH-HENSLEY-JACKSON UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. . . . (3) A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated. (4) Adequate maintenance procedures must be developed to keep property in good condition. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the property records for the assets acquired with COVID-19 - Education Stabilization Fund award dollars did not contain all the required elements. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
2023-003 DEPARTMENT OF HOMELAND SECURITY Pass-through Commonwealth of Kentucky Division of Emergency Management; Disaster Grants - Public Assistance - Assistance Listing No. 97.036; Grant period - Year ended June 30, 2023 Criteria and Condition: 2 CFR 200.303 requires the non-federal entity to establish and maintain effective internal controls over compliance with Federal statues, regulations, and the terms and conditions of the Federal award including proper tracking of grant expenditures or compliance. WRECC's prcoesses over approving allowable costs in the proper period of performance could be enhanced as costs were chagred to the Distaster Grants - Public Assistance grant that fell outside of the proper period of performance Cause: Certain internal controls were not in place to prevent costs from outside of the proper period of performance from being charged to the grant Effect: The cost of the assistance may be disallowed Questioned Costs: N/A Context: A sample of timecards totaling $25,857 were selected for audit from the timecards that were charged to the Disaster Grants - Public Assistance grant. The test found one timecard that was not in compliance with the period of performance. Actual known error was determined to be $2,722 Recommendation: WRECC should enhance the review of costs prior to being transferred or charged to the grant to ensure it includes a review for proper period of performance. View of Responsible Officials and Planned Corrective Actions: WRECC concrus with the finding, see corrective action plan.
2023-003 DEPARTMENT OF HOMELAND SECURITY Pass-through Commonwealth of Kentucky Division of Emergency Management; Disaster Grants - Public Assistance - Assistance Listing No. 97.036; Grant period - Year ended June 30, 2023 Criteria and Condition: 2 CFR 200.303 requires the non-federal entity to establish and maintain effective internal controls over compliance with Federal statues, regulations, and the terms and conditions of the Federal award including proper tracking of grant expenditures or compliance. WRECC's prcoesses over approving allowable costs in the proper period of performance could be enhanced as costs were chagred to the Distaster Grants - Public Assistance grant that fell outside of the proper period of performance Cause: Certain internal controls were not in place to prevent costs from outside of the proper period of performance from being charged to the grant Effect: The cost of the assistance may be disallowed Questioned Costs: N/A Context: A sample of timecards totaling $25,857 were selected for audit from the timecards that were charged to the Disaster Grants - Public Assistance grant. The test found one timecard that was not in compliance with the period of performance. Actual known error was determined to be $2,722 Recommendation: WRECC should enhance the review of costs prior to being transferred or charged to the grant to ensure it includes a review for proper period of performance. View of Responsible Officials and Planned Corrective Actions: WRECC concrus with the finding, see corrective action plan.
2023-003 DEPARTMENT OF HOMELAND SECURITY Pass-through Commonwealth of Kentucky Division of Emergency Management; Disaster Grants - Public Assistance - Assistance Listing No. 97.036; Grant period - Year ended June 30, 2023 Criteria and Condition: 2 CFR 200.303 requires the non-federal entity to establish and maintain effective internal controls over compliance with Federal statues, regulations, and the terms and conditions of the Federal award including proper tracking of grant expenditures or compliance. WRECC's prcoesses over approving allowable costs in the proper period of performance could be enhanced as costs were chagred to the Distaster Grants - Public Assistance grant that fell outside of the proper period of performance Cause: Certain internal controls were not in place to prevent costs from outside of the proper period of performance from being charged to the grant Effect: The cost of the assistance may be disallowed Questioned Costs: N/A Context: A sample of timecards totaling $25,857 were selected for audit from the timecards that were charged to the Disaster Grants - Public Assistance grant. The test found one timecard that was not in compliance with the period of performance. Actual known error was determined to be $2,722 Recommendation: WRECC should enhance the review of costs prior to being transferred or charged to the grant to ensure it includes a review for proper period of performance. View of Responsible Officials and Planned Corrective Actions: WRECC concrus with the finding, see corrective action plan.
2023-003 DEPARTMENT OF HOMELAND SECURITY Pass-through Commonwealth of Kentucky Division of Emergency Management; Disaster Grants - Public Assistance - Assistance Listing No. 97.036; Grant period - Year ended June 30, 2023 Criteria and Condition: 2 CFR 200.303 requires the non-federal entity to establish and maintain effective internal controls over compliance with Federal statues, regulations, and the terms and conditions of the Federal award including proper tracking of grant expenditures or compliance. WRECC's prcoesses over approving allowable costs in the proper period of performance could be enhanced as costs were chagred to the Distaster Grants - Public Assistance grant that fell outside of the proper period of performance Cause: Certain internal controls were not in place to prevent costs from outside of the proper period of performance from being charged to the grant Effect: The cost of the assistance may be disallowed Questioned Costs: N/A Context: A sample of timecards totaling $25,857 were selected for audit from the timecards that were charged to the Disaster Grants - Public Assistance grant. The test found one timecard that was not in compliance with the period of performance. Actual known error was determined to be $2,722 Recommendation: WRECC should enhance the review of costs prior to being transferred or charged to the grant to ensure it includes a review for proper period of performance. View of Responsible Officials and Planned Corrective Actions: WRECC concrus with the finding, see corrective action plan.
2023-003 DEPARTMENT OF HOMELAND SECURITY Pass-through Commonwealth of Kentucky Division of Emergency Management; Disaster Grants - Public Assistance - Assistance Listing No. 97.036; Grant period - Year ended June 30, 2023 Criteria and Condition: 2 CFR 200.303 requires the non-federal entity to establish and maintain effective internal controls over compliance with Federal statues, regulations, and the terms and conditions of the Federal award including proper tracking of grant expenditures or compliance. WRECC's prcoesses over approving allowable costs in the proper period of performance could be enhanced as costs were chagred to the Distaster Grants - Public Assistance grant that fell outside of the proper period of performance Cause: Certain internal controls were not in place to prevent costs from outside of the proper period of performance from being charged to the grant Effect: The cost of the assistance may be disallowed Questioned Costs: N/A Context: A sample of timecards totaling $25,857 were selected for audit from the timecards that were charged to the Disaster Grants - Public Assistance grant. The test found one timecard that was not in compliance with the period of performance. Actual known error was determined to be $2,722 Recommendation: WRECC should enhance the review of costs prior to being transferred or charged to the grant to ensure it includes a review for proper period of performance. View of Responsible Officials and Planned Corrective Actions: WRECC concrus with the finding, see corrective action plan.
FINDING 2023-002 Subject: Child Nutrition Cluster - Eligibility Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program Assistance Listings Numbers: 10.553, 10.555 Federal Award Number and Year (or Other Identifying Number): 21-1620, 21-1620 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-003. Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance related to the eligibility determination of a child receiving meals. INDIANA STATE BOARD OF ACCOUNTS 18 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Any child enrolled in a participating school who meets the applicable program's definition of "child," may receive meals under the applicable program. In the case of the National School Lunch Program and the School Breakfast Program, children belonging to households meeting nationwide income eligibility requirements may receive meals at no charge or at reduced price. Children who have been determined ineligible for free or reduced-price school meals pay the full price, set by the School Food Authority, for their meals. Children attending SFSP meal service sites receive their meals at no charge. As a general rule, a child's eligibility for free or reduced-price meals under a Child Nutrition Cluster program may be established by the submission of an annual application or statement which furnishes such information as family income and family size. Local educational agencies, institutions, and sponsors then determine eligibility by comparing the data reported by the child's household to published income eligibility guidelines. Additionally, a child may be direct certified. For a direct certification, annual eligibility determinations are based on the child's household receiving benefits under SNAP, FDPIR, the Head Start Program (ALN 93.600), or, under most circumstances, the TANF program (ALN 93.558). A household may furnish documentation of its participation in one of these programs; or the school, institution, or sponsor may obtain the information directly from the state or local agency that administers these programs. Certain foster, runaway, homeless, and migrant children are categorically eligible for free school lunches and breakfasts. Direct Certified households do not need to complete an application. Free and reduced price applications were completed online. The information entered in the application was then automatically uploaded into the School Corporation's child nutrition software system. The software system calculated a student's eligibility for free and reduced price meals based on the parameters within the system. The system parameters were entered by the Food Service Director, without a documented review or oversight process to ensure the parameters entered were accurate. Additionally, there was not a review process in place to ensure that the eligibility determinations made by the software system were in compliance with the requirements of the programs. The lack of internal controls was isolated to fiscal year 2022-2023. 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). . . ." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. INDIANA STATE BOARD OF ACCOUNTS 19 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: Child Nutrition Cluster - Eligibility Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program Assistance Listings Numbers: 10.553, 10.555 Federal Award Number and Year (or Other Identifying Number): 21-1620, 21-1620 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-003. Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance related to the eligibility determination of a child receiving meals. INDIANA STATE BOARD OF ACCOUNTS 18 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Any child enrolled in a participating school who meets the applicable program's definition of "child," may receive meals under the applicable program. In the case of the National School Lunch Program and the School Breakfast Program, children belonging to households meeting nationwide income eligibility requirements may receive meals at no charge or at reduced price. Children who have been determined ineligible for free or reduced-price school meals pay the full price, set by the School Food Authority, for their meals. Children attending SFSP meal service sites receive their meals at no charge. As a general rule, a child's eligibility for free or reduced-price meals under a Child Nutrition Cluster program may be established by the submission of an annual application or statement which furnishes such information as family income and family size. Local educational agencies, institutions, and sponsors then determine eligibility by comparing the data reported by the child's household to published income eligibility guidelines. Additionally, a child may be direct certified. For a direct certification, annual eligibility determinations are based on the child's household receiving benefits under SNAP, FDPIR, the Head Start Program (ALN 93.600), or, under most circumstances, the TANF program (ALN 93.558). A household may furnish documentation of its participation in one of these programs; or the school, institution, or sponsor may obtain the information directly from the state or local agency that administers these programs. Certain foster, runaway, homeless, and migrant children are categorically eligible for free school lunches and breakfasts. Direct Certified households do not need to complete an application. Free and reduced price applications were completed online. The information entered in the application was then automatically uploaded into the School Corporation's child nutrition software system. The software system calculated a student's eligibility for free and reduced price meals based on the parameters within the system. The system parameters were entered by the Food Service Director, without a documented review or oversight process to ensure the parameters entered were accurate. Additionally, there was not a review process in place to ensure that the eligibility determinations made by the software system were in compliance with the requirements of the programs. The lack of internal controls was isolated to fiscal year 2022-2023. 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). . . ." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. INDIANA STATE BOARD OF ACCOUNTS 19 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Emergency Connectivity Fund Program - Suspension and Debarment Federal Agency: Federal Communications Commission Federal Program: COVID-19 - Emergency Connectivity Fund Program Assistance Listings Number: 32.009 Federal Award Number and Year (or Other Identifying Number): 50335 Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion Condition and Context Prior to entering into subawards and covered transactions with program funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusion, collecting a certification from that person, or adding a clause or condition to the covered transaction with that person. Upon inquiry of the School Corporation in order to review the procedures in place for verifying that a person with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the School Corporation disclosed there were not any policies or procedures in place. Two covered transactions that equaled or exceeded $25,000 were identified. Both transactions, totaling $837,454, were selected for testing. For the two transactions, the School Corporation did not verify the vendor's suspension and debarment status prior to payment. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 20 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, vendors to whom payments are equal to or in excess of $25,000 were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions or the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure that contractors are not suspended, debarred, or otherwise excluded prior to entering into any covered transactions. INDIANA STATE BOARD OF ACCOUNTS 21 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Emergency Connectivity Fund Program - Suspension and Debarment Federal Agency: Federal Communications Commission Federal Program: COVID-19 - Emergency Connectivity Fund Program Assistance Listings Number: 32.009 Federal Award Number and Year (or Other Identifying Number): 50335 Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion Condition and Context Prior to entering into subawards and covered transactions with program funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusion, collecting a certification from that person, or adding a clause or condition to the covered transaction with that person. Upon inquiry of the School Corporation in order to review the procedures in place for verifying that a person with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the School Corporation disclosed there were not any policies or procedures in place. Two covered transactions that equaled or exceeded $25,000 were identified. Both transactions, totaling $837,454, were selected for testing. For the two transactions, the School Corporation did not verify the vendor's suspension and debarment status prior to payment. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 20 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, vendors to whom payments are equal to or in excess of $25,000 were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions or the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure that contractors are not suspended, debarred, or otherwise excluded prior to entering into any covered transactions. INDIANA STATE BOARD OF ACCOUNTS 21 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: COVID-19 - Emergency Connectivity Fund Program - Equipment, Special Tests and Provisions - Restricted Purpose Federal Agency: Federal Communications Commission Federal Program: COVID-19 - Emergency Connectivity Fund Program Assistance Listings Number: 32.009 Federal Award Number and Year (or Other Identifying Number): 50335 Compliance Requirements: Equipment and Real Property Management, Special Tests and Provisions - Restricted Purpose Audit Finding: Material Weakness Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance related to asset inventory and per-user limitations of the devices purchased with Emergency Connectivity Fund (ECF) Program support. Equipment Management For each connected device provided to an individual student, the asset inventory must identify: 1. The device or equipment type (i.e., laptop, tablet, mobile hotspot, modem, router); 2. The device or equipment make/model; 3. The device or equipment serial number; 4. The full name of the person to whom the device was provided; and 5. The dates the device was loaned out and returned to the school or the date the school was notified that the device was missing, lost, or damaged. The School Corporation maintained a listing of equipment purchased with program funds; however, there was no documented oversight or review process to ensure the listing was accurate and complete. Special Tests and Provisions - Restricted Purpose To maximize the use of limited funds per-location and per-user limitation will be imposed. As such, an eligible school will be reimbursed for no more than one connected device per student, per school. School Corporation officials stated that the Asset Management system would not have allowed the same student to register multiple devices; however, there was no documented oversight or review to ensure that the user limitations in the system were in place during the audit period, and operating effectively to ensure a student only had one connected device as required by the grant award. INDIANA STATE BOARD OF ACCOUNTS 22 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: COVID-19 - Emergency Connectivity Fund Program - Equipment, Special Tests and Provisions - Restricted Purpose Federal Agency: Federal Communications Commission Federal Program: COVID-19 - Emergency Connectivity Fund Program Assistance Listings Number: 32.009 Federal Award Number and Year (or Other Identifying Number): 50335 Compliance Requirements: Equipment and Real Property Management, Special Tests and Provisions - Restricted Purpose Audit Finding: Material Weakness Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance related to asset inventory and per-user limitations of the devices purchased with Emergency Connectivity Fund (ECF) Program support. Equipment Management For each connected device provided to an individual student, the asset inventory must identify: 1. The device or equipment type (i.e., laptop, tablet, mobile hotspot, modem, router); 2. The device or equipment make/model; 3. The device or equipment serial number; 4. The full name of the person to whom the device was provided; and 5. The dates the device was loaned out and returned to the school or the date the school was notified that the device was missing, lost, or damaged. The School Corporation maintained a listing of equipment purchased with program funds; however, there was no documented oversight or review process to ensure the listing was accurate and complete. Special Tests and Provisions - Restricted Purpose To maximize the use of limited funds per-location and per-user limitation will be imposed. As such, an eligible school will be reimbursed for no more than one connected device per student, per school. School Corporation officials stated that the Asset Management system would not have allowed the same student to register multiple devices; however, there was no documented oversight or review to ensure that the user limitations in the system were in place during the audit period, and operating effectively to ensure a student only had one connected device as required by the grant award. INDIANA STATE BOARD OF ACCOUNTS 22 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: Special Education Cluster (IDEA) - Procurement and Suspension and Debarment Federal Agency: Department of Education Federal Programs: Special Education Grants to States, COVID-19 - Special Education Grants to States Assistance Listings Numbers: 84.027, 84.027X Federal Award Numbers and Years (or Other Identifying Numbers): 23611-048-PN01, 22611-048-ARP Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion INDIANA STATE BOARD OF ACCOUNTS 23 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation is a member of the Ripley-Ohio-Dearborn Special Education Cooperative (Cooperative). As the grant agreements were between the Indiana Department of Education and each member school, the School Corporation was responsible for ensuring and providing oversight of the Cooperative. However, there was inadequate oversight performed by the School Corporation in order to ensure compliance with the Procurement and Suspension and Debarment compliance requirement. The School Corporation did not have internal controls in place to ensure that the Cooperative complied with the procurement and suspension and debarment requirements. The Cooperative did not have adequate procedures in place to ensure that the requirements for small purchases were met for each applicable procured good or service or to ensure that vendors were not suspended or debarred prior to entering into a covered transaction. Procurement Federal regulations allow for informal procurement methods when the value of the procurement for goods or services does not exceed the simplified acquisition threshold, which is customarily set at $250,000. However, Indiana Code 5-22-8 has a more restrictive threshold of $150,000 or less for when small purchase procedures may be used. This informal process allows for methods other than the formal bid process. The informal process is divided between two methods based on thresholds. Micro-purchases, typically for those purchases $10,000 or under, and small purchase procedures for those purchases above the micro-purchase threshold but below the simplified acquisition threshold. Micro-purchases may be awarded without soliciting competitive price rate quotations. If small purchase procedures are used, then price or rate quotations must be obtained from an adequate number of qualified sources. If it is determined a single source provider can be used for a small purchase, documentation must be retained supporting the determination. Two vendors exceeded the small purchase threshold during the audit period. Both vendors were selected for testing. In both cases, the Cooperative had determined the curriculum and materials that were purchased, totaling $109,322, were to be provided by a single source provider; however, they did not have a documented rationale or support for the decision. Documentation detailing the history of procurement, which must include the reason for the procurement method used, selection of the vendor, and the basis for the price, was not available for audit for either purchase. Suspension and Debarment Prior to entering into subawards and covered transactions with Special Education Cluster (IDEA) award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusions, collecting a certification from that person, or adding a clause or condition to the covered transaction with that person. Two covered transactions were identified that equaled or exceeded $25,000. Both transactions, totaling $109,322, were selected for testing. For the noted transactions, the Cooperative did not verify the vendor's suspension and debarment status prior to payment due to the Cooperative not having any policies or procedures in place to verify that contractors were neither suspended nor debarred, or otherwise excluded or disqualified, from participating in federal assistance programs or activities. INDIANA STATE BOARD OF ACCOUNTS 24 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls and noncompliance were isolated to fiscal year 2022-2023 and the 23611-048-PN01 and 22611-048-ARP grants. 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.318(i) states: "The non-Federal entity must maintain records sufficient to detail the history of procurement. These records will include, but are not necessarily limited to the following: Rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price." 2 CFR 200.320 states in part: "The non-Federal entity must have and use documented procurement procedures, consistent with the standards of this section and §§ 200.317, 200.318, and 200.319 for any of the following methods of procurement used for the acquisition of property or services required under a Federal award or sub-award. (a) Informal procurement methods. When the value of the procurement for property or services under a Federal award does not exceed the simplified acquisition threshold (SAT), as defined in § 200.1, or a lower threshold established by a non-Federal entity, formal procurement methods are not required. The non-Federal entity may use informal procurement methods to expedite the completion of its transactions and minimize the associated administrative burden and cost. The informal methods used for procurement of property or services at or below the SAT include: . . . (2) Small purchases – (i) Small purchase procedures. The acquisition of property or services, the aggregate dollar amount of which is higher than the micro-purchase threshold but does not exceed the simplified acquisition threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate by the non-Federal entity. . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: INDIANA STATE BOARD OF ACCOUNTS 25 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, adequate documentation was not retained for procurements that fell within the small purchase threshold and vendors to whom payments equal to or in excess of $25,000 were made, were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all required documentation is retained and provided for small purchases and to ensure contractors and subrecipients, as appropriate, are not suspended, debarred, or otherwise excluded prior to entering into any contracts or subawards. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: Special Education Cluster (IDEA) - Procurement and Suspension and Debarment Federal Agency: Department of Education Federal Programs: Special Education Grants to States, COVID-19 - Special Education Grants to States Assistance Listings Numbers: 84.027, 84.027X Federal Award Numbers and Years (or Other Identifying Numbers): 23611-048-PN01, 22611-048-ARP Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion INDIANA STATE BOARD OF ACCOUNTS 23 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation is a member of the Ripley-Ohio-Dearborn Special Education Cooperative (Cooperative). As the grant agreements were between the Indiana Department of Education and each member school, the School Corporation was responsible for ensuring and providing oversight of the Cooperative. However, there was inadequate oversight performed by the School Corporation in order to ensure compliance with the Procurement and Suspension and Debarment compliance requirement. The School Corporation did not have internal controls in place to ensure that the Cooperative complied with the procurement and suspension and debarment requirements. The Cooperative did not have adequate procedures in place to ensure that the requirements for small purchases were met for each applicable procured good or service or to ensure that vendors were not suspended or debarred prior to entering into a covered transaction. Procurement Federal regulations allow for informal procurement methods when the value of the procurement for goods or services does not exceed the simplified acquisition threshold, which is customarily set at $250,000. However, Indiana Code 5-22-8 has a more restrictive threshold of $150,000 or less for when small purchase procedures may be used. This informal process allows for methods other than the formal bid process. The informal process is divided between two methods based on thresholds. Micro-purchases, typically for those purchases $10,000 or under, and small purchase procedures for those purchases above the micro-purchase threshold but below the simplified acquisition threshold. Micro-purchases may be awarded without soliciting competitive price rate quotations. If small purchase procedures are used, then price or rate quotations must be obtained from an adequate number of qualified sources. If it is determined a single source provider can be used for a small purchase, documentation must be retained supporting the determination. Two vendors exceeded the small purchase threshold during the audit period. Both vendors were selected for testing. In both cases, the Cooperative had determined the curriculum and materials that were purchased, totaling $109,322, were to be provided by a single source provider; however, they did not have a documented rationale or support for the decision. Documentation detailing the history of procurement, which must include the reason for the procurement method used, selection of the vendor, and the basis for the price, was not available for audit for either purchase. Suspension and Debarment Prior to entering into subawards and covered transactions with Special Education Cluster (IDEA) award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusions, collecting a certification from that person, or adding a clause or condition to the covered transaction with that person. Two covered transactions were identified that equaled or exceeded $25,000. Both transactions, totaling $109,322, were selected for testing. For the noted transactions, the Cooperative did not verify the vendor's suspension and debarment status prior to payment due to the Cooperative not having any policies or procedures in place to verify that contractors were neither suspended nor debarred, or otherwise excluded or disqualified, from participating in federal assistance programs or activities. INDIANA STATE BOARD OF ACCOUNTS 24 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls and noncompliance were isolated to fiscal year 2022-2023 and the 23611-048-PN01 and 22611-048-ARP grants. 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.318(i) states: "The non-Federal entity must maintain records sufficient to detail the history of procurement. These records will include, but are not necessarily limited to the following: Rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price." 2 CFR 200.320 states in part: "The non-Federal entity must have and use documented procurement procedures, consistent with the standards of this section and §§ 200.317, 200.318, and 200.319 for any of the following methods of procurement used for the acquisition of property or services required under a Federal award or sub-award. (a) Informal procurement methods. When the value of the procurement for property or services under a Federal award does not exceed the simplified acquisition threshold (SAT), as defined in § 200.1, or a lower threshold established by a non-Federal entity, formal procurement methods are not required. The non-Federal entity may use informal procurement methods to expedite the completion of its transactions and minimize the associated administrative burden and cost. The informal methods used for procurement of property or services at or below the SAT include: . . . (2) Small purchases – (i) Small purchase procedures. The acquisition of property or services, the aggregate dollar amount of which is higher than the micro-purchase threshold but does not exceed the simplified acquisition threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate by the non-Federal entity. . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: INDIANA STATE BOARD OF ACCOUNTS 25 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, adequate documentation was not retained for procurements that fell within the small purchase threshold and vendors to whom payments equal to or in excess of $25,000 were made, were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all required documentation is retained and provided for small purchases and to ensure contractors and subrecipients, as appropriate, are not suspended, debarred, or otherwise excluded prior to entering into any contracts or subawards. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: Special Education Cluster (IDEA) - Procurement and Suspension and Debarment Federal Agency: Department of Education Federal Programs: Special Education Grants to States, COVID-19 - Special Education Grants to States Assistance Listings Numbers: 84.027, 84.027X Federal Award Numbers and Years (or Other Identifying Numbers): 23611-048-PN01, 22611-048-ARP Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion INDIANA STATE BOARD OF ACCOUNTS 23 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation is a member of the Ripley-Ohio-Dearborn Special Education Cooperative (Cooperative). As the grant agreements were between the Indiana Department of Education and each member school, the School Corporation was responsible for ensuring and providing oversight of the Cooperative. However, there was inadequate oversight performed by the School Corporation in order to ensure compliance with the Procurement and Suspension and Debarment compliance requirement. The School Corporation did not have internal controls in place to ensure that the Cooperative complied with the procurement and suspension and debarment requirements. The Cooperative did not have adequate procedures in place to ensure that the requirements for small purchases were met for each applicable procured good or service or to ensure that vendors were not suspended or debarred prior to entering into a covered transaction. Procurement Federal regulations allow for informal procurement methods when the value of the procurement for goods or services does not exceed the simplified acquisition threshold, which is customarily set at $250,000. However, Indiana Code 5-22-8 has a more restrictive threshold of $150,000 or less for when small purchase procedures may be used. This informal process allows for methods other than the formal bid process. The informal process is divided between two methods based on thresholds. Micro-purchases, typically for those purchases $10,000 or under, and small purchase procedures for those purchases above the micro-purchase threshold but below the simplified acquisition threshold. Micro-purchases may be awarded without soliciting competitive price rate quotations. If small purchase procedures are used, then price or rate quotations must be obtained from an adequate number of qualified sources. If it is determined a single source provider can be used for a small purchase, documentation must be retained supporting the determination. Two vendors exceeded the small purchase threshold during the audit period. Both vendors were selected for testing. In both cases, the Cooperative had determined the curriculum and materials that were purchased, totaling $109,322, were to be provided by a single source provider; however, they did not have a documented rationale or support for the decision. Documentation detailing the history of procurement, which must include the reason for the procurement method used, selection of the vendor, and the basis for the price, was not available for audit for either purchase. Suspension and Debarment Prior to entering into subawards and covered transactions with Special Education Cluster (IDEA) award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusions, collecting a certification from that person, or adding a clause or condition to the covered transaction with that person. Two covered transactions were identified that equaled or exceeded $25,000. Both transactions, totaling $109,322, were selected for testing. For the noted transactions, the Cooperative did not verify the vendor's suspension and debarment status prior to payment due to the Cooperative not having any policies or procedures in place to verify that contractors were neither suspended nor debarred, or otherwise excluded or disqualified, from participating in federal assistance programs or activities. INDIANA STATE BOARD OF ACCOUNTS 24 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The lack of internal controls and noncompliance were isolated to fiscal year 2022-2023 and the 23611-048-PN01 and 22611-048-ARP grants. 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.318(i) states: "The non-Federal entity must maintain records sufficient to detail the history of procurement. These records will include, but are not necessarily limited to the following: Rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price." 2 CFR 200.320 states in part: "The non-Federal entity must have and use documented procurement procedures, consistent with the standards of this section and §§ 200.317, 200.318, and 200.319 for any of the following methods of procurement used for the acquisition of property or services required under a Federal award or sub-award. (a) Informal procurement methods. When the value of the procurement for property or services under a Federal award does not exceed the simplified acquisition threshold (SAT), as defined in § 200.1, or a lower threshold established by a non-Federal entity, formal procurement methods are not required. The non-Federal entity may use informal procurement methods to expedite the completion of its transactions and minimize the associated administrative burden and cost. The informal methods used for procurement of property or services at or below the SAT include: . . . (2) Small purchases – (i) Small purchase procedures. The acquisition of property or services, the aggregate dollar amount of which is higher than the micro-purchase threshold but does not exceed the simplified acquisition threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate by the non-Federal entity. . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: INDIANA STATE BOARD OF ACCOUNTS 25 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not implemented by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, adequate documentation was not retained for procurements that fell within the small purchase threshold and vendors to whom payments equal to or in excess of $25,000 were made, were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure all required documentation is retained and provided for small purchases and to ensure contractors and subrecipients, as appropriate, are not suspended, debarred, or otherwise excluded prior to entering into any contracts or subawards. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: Special Education Cluster (IDEA) - Earmarking Federal Agency: Department of Education Federal Program: Special Education Grants to States Assistance Listings Number: 84.027 Federal Award Numbers and Years (or Other Identifying Numbers): 21611-048-PN01, 22611-048-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Findings: Material Weakness, Modified Opinion INDIANA STATE BOARD OF ACCOUNTS 26 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-006. Condition and Context The School Corporation is a member of the Ripley-Ohio-Dearborn Special Education Cooperative (Cooperative). During fiscal years 2021-2022 and 2022-2023, the Cooperative operated the special education programs and spent the federal money for earmarked expenditures on behalf of three of the six member schools. As the grant agreement was between the Indiana Department of Education (IDOE) and the member school, the School Corporation was responsible for ensuring and providing oversight of the Cooperative. However, there was inadequate oversight performed by the School Corporation in order to ensure compliance with the Matching, Level of Effort, Earmarking compliance requirement. The School Corporation did not have internal controls in place to ensure that the Cooperative complied with the earmarking requirements. The Cooperative did not have adequate procedures in place to ensure that the required level of expenditures for nonpublic school students with disabilities was met for each member school. The Cooperative did not have effective internal controls to ensure nonpublic school expenditures were appropriately identified and reported. The Non-Public Proportionate Share expenditures for the 21611-048-PN01 and 22611-048-PN01 grant awards could not be verified for the individual member schools. The nonpublic school share funds for the participating member schools were allocated based on the yearly budget for certified staff instead of time charged to the nonpublic schools. These allocations were the amounts reported to the IDOE. As such, we were unable to identify which expenditures were for each school in order to verify the minimum amount per the grant award was expended and properly reported to the IDOE as required. The lack of internal controls and noncompliance was isolated to the 21611-048-PN01 and 22611-048-9N01 grant awards. 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.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: . . . (g) Be adequately documented. . . ." INDIANA STATE BOARD OF ACCOUNTS 27 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.208(b) states in part: "The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed, . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure Non-Public Proportionate Share funds are appropriately allocated to the member school based on expenses charged directly on behalf of the member school. Supporting documentation for these expenses should be retained for audit. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: Special Education Cluster (IDEA) - Earmarking Federal Agency: Department of Education Federal Program: Special Education Grants to States Assistance Listings Number: 84.027 Federal Award Numbers and Years (or Other Identifying Numbers): 21611-048-PN01, 22611-048-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Findings: Material Weakness, Modified Opinion INDIANA STATE BOARD OF ACCOUNTS 26 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-006. Condition and Context The School Corporation is a member of the Ripley-Ohio-Dearborn Special Education Cooperative (Cooperative). During fiscal years 2021-2022 and 2022-2023, the Cooperative operated the special education programs and spent the federal money for earmarked expenditures on behalf of three of the six member schools. As the grant agreement was between the Indiana Department of Education (IDOE) and the member school, the School Corporation was responsible for ensuring and providing oversight of the Cooperative. However, there was inadequate oversight performed by the School Corporation in order to ensure compliance with the Matching, Level of Effort, Earmarking compliance requirement. The School Corporation did not have internal controls in place to ensure that the Cooperative complied with the earmarking requirements. The Cooperative did not have adequate procedures in place to ensure that the required level of expenditures for nonpublic school students with disabilities was met for each member school. The Cooperative did not have effective internal controls to ensure nonpublic school expenditures were appropriately identified and reported. The Non-Public Proportionate Share expenditures for the 21611-048-PN01 and 22611-048-PN01 grant awards could not be verified for the individual member schools. The nonpublic school share funds for the participating member schools were allocated based on the yearly budget for certified staff instead of time charged to the nonpublic schools. These allocations were the amounts reported to the IDOE. As such, we were unable to identify which expenditures were for each school in order to verify the minimum amount per the grant award was expended and properly reported to the IDOE as required. The lack of internal controls and noncompliance was isolated to the 21611-048-PN01 and 22611-048-9N01 grant awards. 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.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: . . . (g) Be adequately documented. . . ." INDIANA STATE BOARD OF ACCOUNTS 27 LAWRENCEBURG COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.208(b) states in part: "The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed, . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure Non-Public Proportionate Share funds are appropriately allocated to the member school based on expenses charged directly on behalf of the member school. Supporting documentation for these expenses should be retained for audit. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding 2023-001: Special Tests and Provisions: Enrollment Reporting Program Name: Student Financial Assistance Cluster: Federal Direct Student Loans. Assistance Listing No. 84.268 Federal Pell Grant Program, Assistance Listing No. 84.063 Awarding Agency: U.S. Department of Education Finding Type: Significant Deficiency on Internal Controls over Compliance Questioned Costs: None Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, 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 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). In addition, the Department of Education relies on institution’s enrollments reports to determine a student’s enrollment status based on reductions or increases in attendance levels, withdrawals, graduations or approved leaves-of-absence. According to 34 CFR 690.83(b)(2) and 685.309, the University is required to submit changes in student attendance to the National Student Loan Data System (NSLDS) at a minimum of every 60 days. Context/Condition: Of the 37 students selected for enrollment reporting testing, five students within the sample were reported to NSLDS outside the maximum 60-day window. This was not a statistically valid sample. Cause: The College did not have effective controls in place to ensure timely reporting of all status changes. Effect: Without timely notification of withdrawals or graduation, the NSLDS is unable to accurately determine when a student enters repayment status. Recommendation: We recommend that the College review and update internal controls to ensure student enrollment status in the NSLDS is updated in a timely manner to ensure compliance with Federal requirements. Views of Responsible Officials: Management agrees with the finding. See accompanying Corrective Action Plan.
Finding 2023-001: Special Tests and Provisions: Enrollment Reporting Program Name: Student Financial Assistance Cluster: Federal Direct Student Loans. Assistance Listing No. 84.268 Federal Pell Grant Program, Assistance Listing No. 84.063 Awarding Agency: U.S. Department of Education Finding Type: Significant Deficiency on Internal Controls over Compliance Questioned Costs: None Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, 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 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). In addition, the Department of Education relies on institution’s enrollments reports to determine a student’s enrollment status based on reductions or increases in attendance levels, withdrawals, graduations or approved leaves-of-absence. According to 34 CFR 690.83(b)(2) and 685.309, the University is required to submit changes in student attendance to the National Student Loan Data System (NSLDS) at a minimum of every 60 days. Context/Condition: Of the 37 students selected for enrollment reporting testing, five students within the sample were reported to NSLDS outside the maximum 60-day window. This was not a statistically valid sample. Cause: The College did not have effective controls in place to ensure timely reporting of all status changes. Effect: Without timely notification of withdrawals or graduation, the NSLDS is unable to accurately determine when a student enters repayment status. Recommendation: We recommend that the College review and update internal controls to ensure student enrollment status in the NSLDS is updated in a timely manner to ensure compliance with Federal requirements. Views of Responsible Officials: Management agrees with the finding. See accompanying Corrective Action Plan.
Finding 2023-001: Special Tests and Provisions: Enrollment Reporting Program Name: Student Financial Assistance Cluster: Federal Direct Student Loans. Assistance Listing No. 84.268 Federal Pell Grant Program, Assistance Listing No. 84.063 Awarding Agency: U.S. Department of Education Finding Type: Significant Deficiency on Internal Controls over Compliance Questioned Costs: None Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, 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 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). In addition, the Department of Education relies on institution’s enrollments reports to determine a student’s enrollment status based on reductions or increases in attendance levels, withdrawals, graduations or approved leaves-of-absence. According to 34 CFR 690.83(b)(2) and 685.309, the University is required to submit changes in student attendance to the National Student Loan Data System (NSLDS) at a minimum of every 60 days. Context/Condition: Of the 37 students selected for enrollment reporting testing, five students within the sample were reported to NSLDS outside the maximum 60-day window. This was not a statistically valid sample. Cause: The College did not have effective controls in place to ensure timely reporting of all status changes. Effect: Without timely notification of withdrawals or graduation, the NSLDS is unable to accurately determine when a student enters repayment status. Recommendation: We recommend that the College review and update internal controls to ensure student enrollment status in the NSLDS is updated in a timely manner to ensure compliance with Federal requirements. Views of Responsible Officials: Management agrees with the finding. See accompanying Corrective Action Plan.
Finding 2023-001: Special Tests and Provisions: Enrollment Reporting Program Name: Student Financial Assistance Cluster: Federal Direct Student Loans. Assistance Listing No. 84.268 Federal Pell Grant Program, Assistance Listing No. 84.063 Awarding Agency: U.S. Department of Education Finding Type: Significant Deficiency on Internal Controls over Compliance Questioned Costs: None Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, 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 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). In addition, the Department of Education relies on institution’s enrollments reports to determine a student’s enrollment status based on reductions or increases in attendance levels, withdrawals, graduations or approved leaves-of-absence. According to 34 CFR 690.83(b)(2) and 685.309, the University is required to submit changes in student attendance to the National Student Loan Data System (NSLDS) at a minimum of every 60 days. Context/Condition: Of the 37 students selected for enrollment reporting testing, five students within the sample were reported to NSLDS outside the maximum 60-day window. This was not a statistically valid sample. Cause: The College did not have effective controls in place to ensure timely reporting of all status changes. Effect: Without timely notification of withdrawals or graduation, the NSLDS is unable to accurately determine when a student enters repayment status. Recommendation: We recommend that the College review and update internal controls to ensure student enrollment status in the NSLDS is updated in a timely manner to ensure compliance with Federal requirements. Views of Responsible Officials: Management agrees with the finding. See accompanying Corrective Action Plan.
FINDING 2023-002 Information on the federal program: Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program, Summer Food Program Assistance Listing Number: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY2022, FY2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles 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). . . ." Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the activities allowed or unallowed and allowable costs/cost principle compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: We noted that there was no primary, documented review for two of the sixteen sample vendor child nutrition cluster accounts payable vouchers. Identification as a repeat finding, if applicable: No. Recommendation: We recommend that the School Corporation establish a documented, primary review of all Child Nutrition Cluster account payable claims before they are paid. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2023-002 Information on the federal program: Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program, Summer Food Program Assistance Listing Number: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY2022, FY2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles 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). . . ." Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the activities allowed or unallowed and allowable costs/cost principle compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: We noted that there was no primary, documented review for two of the sixteen sample vendor child nutrition cluster accounts payable vouchers. Identification as a repeat finding, if applicable: No. Recommendation: We recommend that the School Corporation establish a documented, primary review of all Child Nutrition Cluster account payable claims before they are paid. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2023-002 Information on the federal program: Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program, Summer Food Program Assistance Listing Number: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY2022, FY2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles 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). . . ." Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the activities allowed or unallowed and allowable costs/cost principle compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: We noted that there was no primary, documented review for two of the sixteen sample vendor child nutrition cluster accounts payable vouchers. Identification as a repeat finding, if applicable: No. Recommendation: We recommend that the School Corporation establish a documented, primary review of all Child Nutrition Cluster account payable claims before they are paid. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2023-002 Information on the federal program: Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program, Summer Food Program Assistance Listing Number: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY2022, FY2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles 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). . . ." Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the activities allowed or unallowed and allowable costs/cost principle compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: We noted that there was no primary, documented review for two of the sixteen sample vendor child nutrition cluster accounts payable vouchers. Identification as a repeat finding, if applicable: No. Recommendation: We recommend that the School Corporation establish a documented, primary review of all Child Nutrition Cluster account payable claims before they are paid. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2023-003 Information on the federal program: Subject: Child Nutrition Cluster – Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program, Summer Food Services Assistance Listing Number: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY2022, FY2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment 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.318(a) states: "The non-Federal entity must use its own documented procurement procedures which reflect applicable State, local, and tribal laws and regulations, provided that the procurements conform to applicable Federal law and the standards identified in this part." 2 CFR 200.320 states in part: "The non-Federal Entity must use one of the following methods of procurement. . . . (b) Procurement by small purchase procedures. Small purchase procedures are those relatively simple and informal procurement methods for securing services, supplies, or other property that do not cost more than the Simplified Acquisition Threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources. . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking the SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." 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 Suspension and Debarment compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system enabled noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: For one selection in a sample of two, the school corporation did not perform the required suspension and debarment check on the vendor for FY22. For FY23, the school updated their procedures and properly performed the suspension/debarment check. Identification as a repeat finding, if applicable: This is a repeat finding from the immediately prior audit. The prior finding number was 2021-002. Recommendation: We recommended that the School Corporation's management establish a system of internal controls related to ensure that quotes are obtained as required for procurements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2023-003 Information on the federal program: Subject: Child Nutrition Cluster – Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program, Summer Food Services Assistance Listing Number: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY2022, FY2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment 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.318(a) states: "The non-Federal entity must use its own documented procurement procedures which reflect applicable State, local, and tribal laws and regulations, provided that the procurements conform to applicable Federal law and the standards identified in this part." 2 CFR 200.320 states in part: "The non-Federal Entity must use one of the following methods of procurement. . . . (b) Procurement by small purchase procedures. Small purchase procedures are those relatively simple and informal procurement methods for securing services, supplies, or other property that do not cost more than the Simplified Acquisition Threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources. . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking the SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." 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 Suspension and Debarment compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system enabled noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: For one selection in a sample of two, the school corporation did not perform the required suspension and debarment check on the vendor for FY22. For FY23, the school updated their procedures and properly performed the suspension/debarment check. Identification as a repeat finding, if applicable: This is a repeat finding from the immediately prior audit. The prior finding number was 2021-002. Recommendation: We recommended that the School Corporation's management establish a system of internal controls related to ensure that quotes are obtained as required for procurements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2023-003 Information on the federal program: Subject: Child Nutrition Cluster – Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program, Summer Food Services Assistance Listing Number: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY2022, FY2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment 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.318(a) states: "The non-Federal entity must use its own documented procurement procedures which reflect applicable State, local, and tribal laws and regulations, provided that the procurements conform to applicable Federal law and the standards identified in this part." 2 CFR 200.320 states in part: "The non-Federal Entity must use one of the following methods of procurement. . . . (b) Procurement by small purchase procedures. Small purchase procedures are those relatively simple and informal procurement methods for securing services, supplies, or other property that do not cost more than the Simplified Acquisition Threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources. . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking the SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." 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 Suspension and Debarment compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system enabled noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: For one selection in a sample of two, the school corporation did not perform the required suspension and debarment check on the vendor for FY22. For FY23, the school updated their procedures and properly performed the suspension/debarment check. Identification as a repeat finding, if applicable: This is a repeat finding from the immediately prior audit. The prior finding number was 2021-002. Recommendation: We recommended that the School Corporation's management establish a system of internal controls related to ensure that quotes are obtained as required for procurements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2023-003 Information on the federal program: Subject: Child Nutrition Cluster – Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program, Summer Food Services Assistance Listing Number: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY2022, FY2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment 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.318(a) states: "The non-Federal entity must use its own documented procurement procedures which reflect applicable State, local, and tribal laws and regulations, provided that the procurements conform to applicable Federal law and the standards identified in this part." 2 CFR 200.320 states in part: "The non-Federal Entity must use one of the following methods of procurement. . . . (b) Procurement by small purchase procedures. Small purchase procedures are those relatively simple and informal procurement methods for securing services, supplies, or other property that do not cost more than the Simplified Acquisition Threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources. . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking the SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." 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 Suspension and Debarment compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system enabled noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: For one selection in a sample of two, the school corporation did not perform the required suspension and debarment check on the vendor for FY22. For FY23, the school updated their procedures and properly performed the suspension/debarment check. Identification as a repeat finding, if applicable: This is a repeat finding from the immediately prior audit. The prior finding number was 2021-002. Recommendation: We recommended that the School Corporation's management establish a system of internal controls related to ensure that quotes are obtained as required for procurements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2023-004 Information on the federal program: Subject: Education Stabilization Fund – Special Tests and Provisions - Wage Rate Requirements Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S365A220014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Wage Rate Requirements Audit Findings: Material Weakness, Material Noncompliance, Modified Opinion 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). . . ." 29 CFR 5.5 states in part: a.The Agency head shall cause or require the contracting officer to insert in full in any contract in excess of $2,000 which is entered into for the actual construction, alteration and/or repair, including painting and decorating, of a public building or public work, or building or work financed in whole or in part from Federal funds or in accordance with guarantees of a Federal agency or financed from funds obtained by pledge of any contract of a Federal agency to make a loan, grant or annual contribution (except where a different meaning is expressly indicated), and which is subject to the labor standards provisions of any of the acts listed in §5.1, the following clauses… (1) Minimum wages. (i) All laborers and mechanics employed or working upon the site of the work (or under the United States Housing Act of 1937 or under the Housing Act of 1949 in the construction or development of the project), will be paid unconditionally and not less often than once a week, and without subsequent deduction or rebate on any account (except such payroll deductions as are permitted by regulations issued by the Secretary of Labor under the Copeland Act (29 CFR part 3)), the full amount of wages and bona fide fringe benefits (or cash equivalents thereof) due at time of payment computed at rates not less than those contained in the wage determination of the Secretary of Labor which is attached hereto and made a part hereof, regardless of any contractual relationship which may be alleged to exist between the contractor and such laborers and mechanics… (3)(ii)(A) The contractor shall submit weekly for each week in which any contract work is performed a copy of all payrolls to the (write in name of appropriate federal agency) if the agency is a party to the contract, but if the agency is not such a party, the contractor will submit the payrolls to the applicant, sponsor, or owner, as the case may be, for transmission to the (write in name of agency). 2 CFR 200 Appendix II states in part: In addition to other provisions required by the Federal agency or non-Federal entity; all contracts made by the non-Federal entity under the Federal award must contain provisions covering the following, as applicable. . . . (D) Davis-Bacon Act, as amended (40 U.S.C. 3141-3148). When required by Federal program legislation, all prime construction contracts in excess of $2,000 awarded by non-Federal entities must include a provision for compliance with the Davis-Bacon Act (40 U.S.C. 3141-3144, and 3146-3148) as supplemented by Department of Labor regulations (29 CFR Part 5, “Labor Standards Provisions Applicable to Contracts Covering Federally Financed and Assisted Construction”). In accordance with the statute, contractors must be required to pay wages to laborers and mechanics at a rate not less than the prevailing wages specified in a wage determination made by the Secretary of Labor. In addition, contractors must be required to pay wages not less than once a week.. . .” 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 Special Tests and Provisions – Wage Rate Requirements compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to design and implement an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Special Tests and Provisions – Wage Rate Requirements 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 obtain the weekly payroll reports certifications from a construction company that was improving the building. Therefore, no review was performed to ensure that pay rates complied with the federal wage rate requirements. Additionally, the School Corporation did not have a contract with the company that included clauses for the federal wage rate requirements. The sample item cost $433,318 to install a HVAC system. Identification as a repeat finding: No. Recommendation: We recommend the School Corporation implement a formal process to ensure the required weekly payroll reports certifications are collected and reviewed to ensure compliance with the wage rate requirements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2023-004 Information on the federal program: Subject: Education Stabilization Fund – Special Tests and Provisions - Wage Rate Requirements Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S365A220014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Wage Rate Requirements Audit Findings: Material Weakness, Material Noncompliance, Modified Opinion 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). . . ." 29 CFR 5.5 states in part: a.The Agency head shall cause or require the contracting officer to insert in full in any contract in excess of $2,000 which is entered into for the actual construction, alteration and/or repair, including painting and decorating, of a public building or public work, or building or work financed in whole or in part from Federal funds or in accordance with guarantees of a Federal agency or financed from funds obtained by pledge of any contract of a Federal agency to make a loan, grant or annual contribution (except where a different meaning is expressly indicated), and which is subject to the labor standards provisions of any of the acts listed in §5.1, the following clauses… (1) Minimum wages. (i) All laborers and mechanics employed or working upon the site of the work (or under the United States Housing Act of 1937 or under the Housing Act of 1949 in the construction or development of the project), will be paid unconditionally and not less often than once a week, and without subsequent deduction or rebate on any account (except such payroll deductions as are permitted by regulations issued by the Secretary of Labor under the Copeland Act (29 CFR part 3)), the full amount of wages and bona fide fringe benefits (or cash equivalents thereof) due at time of payment computed at rates not less than those contained in the wage determination of the Secretary of Labor which is attached hereto and made a part hereof, regardless of any contractual relationship which may be alleged to exist between the contractor and such laborers and mechanics… (3)(ii)(A) The contractor shall submit weekly for each week in which any contract work is performed a copy of all payrolls to the (write in name of appropriate federal agency) if the agency is a party to the contract, but if the agency is not such a party, the contractor will submit the payrolls to the applicant, sponsor, or owner, as the case may be, for transmission to the (write in name of agency). 2 CFR 200 Appendix II states in part: In addition to other provisions required by the Federal agency or non-Federal entity; all contracts made by the non-Federal entity under the Federal award must contain provisions covering the following, as applicable. . . . (D) Davis-Bacon Act, as amended (40 U.S.C. 3141-3148). When required by Federal program legislation, all prime construction contracts in excess of $2,000 awarded by non-Federal entities must include a provision for compliance with the Davis-Bacon Act (40 U.S.C. 3141-3144, and 3146-3148) as supplemented by Department of Labor regulations (29 CFR Part 5, “Labor Standards Provisions Applicable to Contracts Covering Federally Financed and Assisted Construction”). In accordance with the statute, contractors must be required to pay wages to laborers and mechanics at a rate not less than the prevailing wages specified in a wage determination made by the Secretary of Labor. In addition, contractors must be required to pay wages not less than once a week.. . .” 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 Special Tests and Provisions – Wage Rate Requirements compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to design and implement an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Special Tests and Provisions – Wage Rate Requirements 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 obtain the weekly payroll reports certifications from a construction company that was improving the building. Therefore, no review was performed to ensure that pay rates complied with the federal wage rate requirements. Additionally, the School Corporation did not have a contract with the company that included clauses for the federal wage rate requirements. The sample item cost $433,318 to install a HVAC system. Identification as a repeat finding: No. Recommendation: We recommend the School Corporation implement a formal process to ensure the required weekly payroll reports certifications are collected and reviewed to ensure compliance with the wage rate requirements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2023-004 Information on the federal program: Subject: Education Stabilization Fund – Special Tests and Provisions - Wage Rate Requirements Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S365A220014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Special Tests and Provisions - Wage Rate Requirements Audit Findings: Material Weakness, Material Noncompliance, Modified Opinion 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). . . ." 29 CFR 5.5 states in part: a.The Agency head shall cause or require the contracting officer to insert in full in any contract in excess of $2,000 which is entered into for the actual construction, alteration and/or repair, including painting and decorating, of a public building or public work, or building or work financed in whole or in part from Federal funds or in accordance with guarantees of a Federal agency or financed from funds obtained by pledge of any contract of a Federal agency to make a loan, grant or annual contribution (except where a different meaning is expressly indicated), and which is subject to the labor standards provisions of any of the acts listed in §5.1, the following clauses… (1) Minimum wages. (i) All laborers and mechanics employed or working upon the site of the work (or under the United States Housing Act of 1937 or under the Housing Act of 1949 in the construction or development of the project), will be paid unconditionally and not less often than once a week, and without subsequent deduction or rebate on any account (except such payroll deductions as are permitted by regulations issued by the Secretary of Labor under the Copeland Act (29 CFR part 3)), the full amount of wages and bona fide fringe benefits (or cash equivalents thereof) due at time of payment computed at rates not less than those contained in the wage determination of the Secretary of Labor which is attached hereto and made a part hereof, regardless of any contractual relationship which may be alleged to exist between the contractor and such laborers and mechanics… (3)(ii)(A) The contractor shall submit weekly for each week in which any contract work is performed a copy of all payrolls to the (write in name of appropriate federal agency) if the agency is a party to the contract, but if the agency is not such a party, the contractor will submit the payrolls to the applicant, sponsor, or owner, as the case may be, for transmission to the (write in name of agency). 2 CFR 200 Appendix II states in part: In addition to other provisions required by the Federal agency or non-Federal entity; all contracts made by the non-Federal entity under the Federal award must contain provisions covering the following, as applicable. . . . (D) Davis-Bacon Act, as amended (40 U.S.C. 3141-3148). When required by Federal program legislation, all prime construction contracts in excess of $2,000 awarded by non-Federal entities must include a provision for compliance with the Davis-Bacon Act (40 U.S.C. 3141-3144, and 3146-3148) as supplemented by Department of Labor regulations (29 CFR Part 5, “Labor Standards Provisions Applicable to Contracts Covering Federally Financed and Assisted Construction”). In accordance with the statute, contractors must be required to pay wages to laborers and mechanics at a rate not less than the prevailing wages specified in a wage determination made by the Secretary of Labor. In addition, contractors must be required to pay wages not less than once a week.. . .” 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 Special Tests and Provisions – Wage Rate Requirements compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to design and implement an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Special Tests and Provisions – Wage Rate Requirements 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 obtain the weekly payroll reports certifications from a construction company that was improving the building. Therefore, no review was performed to ensure that pay rates complied with the federal wage rate requirements. Additionally, the School Corporation did not have a contract with the company that included clauses for the federal wage rate requirements. The sample item cost $433,318 to install a HVAC system. Identification as a repeat finding: No. Recommendation: We recommend the School Corporation implement a formal process to ensure the required weekly payroll reports certifications are collected and reviewed to ensure compliance with the wage rate requirements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Program: AL 21.027 – COVID-19 – Coronavirus State and Local Fiscal Recovery Funds – Suspension & Debarment Grant Number & Year: SLFRP2375, March 3, 2021, through December 31, 2024 Federal Grantor Agency: U.S. Department of the Treasury Criteria: Title 2 of the U.S. Code of Federal Regulations (CFR) § 200.303 (January 1, 2023) states the following, in relevant part: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). 2 CFR § 200.214 (January 1, 2023) states the following: Non-Federal entities are subject to the non-procurement debarment and suspension regulations implementing Executive Orders 12549 and 12689, 2 CFR part 180. The regulations in 2 CFR part 180 restrict awards, subawards, and contracts with certain parties that are debarred, suspended, or otherwise excluded from or ineligible for participation in Federal assistance programs or activities. The U.S. Department of the Treasury adopted the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards in 2 CFR § 1000.10 (January 1, 2023), which states the following: Except for the deviations set forth elsewhere in this Part, the Department of the Treasury adopts the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, set forth at 2 CFR part 200. 2 CFR § 180.300 (January 1, 2023) requires non-Federal entities to verify that 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 the County to have proper procedures in place to verify that contractors paid with Federal funds are not suspended, debarred, or otherwise excluded from or ineligible for participation in Federal programs or activities. Condition: Colfax County could not provide documentation to support that the County implemented effective internal controls to ensure that suspension and debarment requirements were followed and adequately documented. We noted the County used Coronavirus State and Local Fiscal Recovery Funds to pay three entities over $25,000 each, totaling $1,054,577, during the fiscal year ended June 30, 2023. The County failed to ensure that these entities were not excluded or disqualified prior to entering into these covered transactions. We reviewed SAM.gov, and noted that none of these entities were suspended, debarred, or otherwise excluded from participation in Federal programs or activities as of the date testing was performed. Repeat Finding: No Questioned Costs: None Statistical Sample: No Context: The following table provides details of the covered transactions noted: Cause: Lack of procedures to ensure the County’s review of SAM.gov was documented and maintained on file for subsequent review 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, leading to possible Federal sanctions. Recommendation: We recommend the County implement procedures to ensure, prior to entering into a covered transaction, that a contractor is not suspended, debarred, or otherwise excluded from or ineligible for participation in Federal programs or activities, and those procedures are adequately documented. View of Officials: Procedures implemented to print the page of Sam.gov website
FINDING 2023-003 Information on the federal program: Subject: Education Stabilization Fund (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D & 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs- Cost Principles Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 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 Activities Allowed or Unallowed, Allowable Costs- Cost Principles compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: We noted that there was no secondary, documented review for all five sample vendor accounts payable vouchers. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation's management establish a documented, primary review of all accounts payable claims before they are paid. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2023-003 Information on the federal program: Subject: Education Stabilization Fund (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D & 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs- Cost Principles Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 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 Activities Allowed or Unallowed, Allowable Costs- Cost Principles compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: We noted that there was no secondary, documented review for all five sample vendor accounts payable vouchers. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation's management establish a documented, primary review of all accounts payable claims before they are paid. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2023-003 Information on the federal program: Subject: Education Stabilization Fund (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D & 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs- Cost Principles Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 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 Activities Allowed or Unallowed, Allowable Costs- Cost Principles compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: We noted that there was no secondary, documented review for all five sample vendor accounts payable vouchers. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation's management establish a documented, primary review of all accounts payable claims before they are paid. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Program - AL 21.027 – COVID-19 – Coronavirus State and Local Fiscal Recovery Funds – Suspension & Debarment Grant Number & Year - SLFRP3004, March 3, 2021, through December 31, 2024 Federal Grantor Agency - U.S. Department of the Treasury Criteria - Title 2 of the U.S. Code of Federal Regulations (CFR) § 200.303 (January 1, 2023) states the following, in relevant part: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) . . . . The U.S. Department of the Treasury adopted the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards in 2 CFR § 1000.10 (January 1, 2023), which states the following: Except for the deviations set forth elsewhere in this Part, the Department of the Treasury adopts the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, set forth at 2 CFR part 200. 2 CFR § 200.214 (January 1, 2023) states the following: Non-Federal entities are subject to the non-procurement debarment and suspension regulations implementing Executive Orders 12549 and 12689, 2 CFR part 180. The regulations in 2 CFR part 180 restrict awards, subawards, and contracts with certain parties that are debarred, suspended, or otherwise excluded from or ineligible for participation in Federal assistance programs or activities. 2 CFR § 180.300 (January 1, 2023) requires non-Federal entities to verify that 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 the County to have proper procedures in place to verify that contractors paid with Federal funds are not suspended, debarred, or otherwise excluded from or ineligible for participation in Federal programs or activities. Condition - Saunders County could not provide documentation to support the County implemented effective internal controls to ensure that suspension and debarment requirements were followed and adequately documented. We noted the County used Coronavirus State and Local Fiscal Recovery Funds to pay two vendors over $25,000, totaling $1,750,730, during the fiscal year ended June 30, 2023. The County failed to ensure that these vendors were not excluded or disqualified prior to entering into these covered transactions. We reviewed SAM.gov, and noted these vendors were not suspended, debarred, or otherwise excluded from participation in Federal programs or activities as of the date tested was performed. Repeat Finding - No Questioned Costs - None Statistical Sample - No Context - The following table provides details of the covered transactions noted: Cause - Lack of procedures and knowledge regarding suspension and debarment requirements. 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, leading to possible Federal sanctions. Recommendation - We recommend the County implement procedures to ensure, prior to entering into a covered transaction, that a contractor is not suspended, debarred, or otherwise excluded from or ineligible for participation in Federal programs or activities, and those procedures are adequately documented. View of Officials - The County Attorney is writing up a policy.
Program - AL 21.027 – COVID-19 – Coronavirus State and Local Fiscal Recovery Funds – Reporting Grant Number & Year - SLFRP3004, March 3, 2021, through December 31, 2024 Federal Grantor Agency - U.S. Department of the Treasury Criteria - Title 2 of the U.S. Code of Federal Regulations (CFR) § 200.303 (January 1, 2023) states the following, in relevant part: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). The U.S. Department of the Treasury adopted the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards in 2 CFR § 1000.10 (January 1, 2023), which states the following: Except for the deviations set forth elsewhere in this Part, the Department of the Treasury adopts the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, set forth at 2 CFR part 200. The U.S. Department of the Treasury issued “Compliance and Reporting Guidance” and frequently asked questions, which specify the reporting requirements related to Coronavirus State and Local Fiscal Recovery Funds. A good internal control plan includes establishing effective internal controls through written policies and procedures to ensure Federal reporting requirements are completed accurately. Such plan should include, among other things, appropriate training on Federal reporting requirements and require a documented, detailed review of each report to be completed by a knowledgeable individual, who did not prepare the report, prior to submission. Condition - Saunders County did not implement effective internal controls to ensure that the reporting requirements of the Coronavirus State and Local Fiscal Recovery Funds (SLFRF) were completed accurately. The Project and Expenditure report submitted on April 28, 2023, did not contain accurate information. The table below in the “Context” section summarizes the variances noted. Repeat Finding - No Questioned Costs - None Statistical Sample - No Context - The following table summarizes the variances between the 2023 report and the underlying accounting system and County records. Additionally, Saunders County incorrectly listed Motorola Solutions Inc., a communications vendor, as a subrecipient. Cause - Lack of procedures and knowledge regarding the reporting requirements. Effect - Inaccurate information was reported to the U.S. Department of the Treasury on the 2023 Project and Expenditure report. Additionally, there is an increased risk of the County not being in compliance with the reporting requirements set by the U.S Department of the Treasury. Recommendation - We recommend the County implement procedures to ensure Federal reporting requirements are completed accurately. Such procedures could include, among other things, appropriate training on Federal reporting requirements and a documented review by a knowledgeable individual who was not involved in the preparation of the report. View of Officials - The County Attorney is writing up a policy.
Program Information: Federal Program: Research and Development Cluster Assistance Listing Numbers: Various Federal Agencies: Various Award Year: Various Criteria or requirement: According to 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property, who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Per Title 2, U.S. Code of Federal Regulations Part 200 (2 CRF 200), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award, (Subpart D, Section 200.303), the nonfederal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Condition found, including facts that support the deficiency identified in the finding and information to provide proper perspective for judging the prevalence and consequences of the finding: During our procedures over management’s process of observing physical inventory of equipment, 2 of our 40 sample sections were found to have been disposed of without being removed from the inventory listing. Both of these pieces of equipment were indicated as counted during the inventory count despite being disposed of prior to the count date. These two pieces of equipment were significantly aged, had no estimated remaining fair market value, and related to grants that had ended several years ago. Therefore, there are no questioned costs related to the missing equipment. Cause and possible asserted effect: The inventory count control was not operating effectively to detect and properly track the missing equipment. Failure to accurately count equipment and to maintain accurate property records may result in the University not properly safeguarding and maintaining equipment in accordance with Federal requirements. Identification of questioned costs and how they were computed: None Sample Statistically Valid: The sample was not intended to be, and was not, a statistically valid sample. Repeat finding from prior year: No Recommendation: We recommend management enhance their internal control processes and training of people performing inventory counts to ensure the data obtained during the inventory count is appropriately reviewed to ensure that count errors are detected and corrected. Views of Responsible Officials: Management agrees with the finding noted in this report. Management has developed a corrective action plan and is in the process of improving processes and internal control systems to ensure that effective controls are in place over federally purchased equipment.
Program Information: Federal Program: Research and Development Cluster Assistance Listing Numbers: Various Federal Agencies: Various Award Year: Various Criteria or requirement: According to 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property, who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Per Title 2, U.S. Code of Federal Regulations Part 200 (2 CRF 200), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award, (Subpart D, Section 200.303), the nonfederal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Condition found, including facts that support the deficiency identified in the finding and information to provide proper perspective for judging the prevalence and consequences of the finding: During our procedures over management’s process of observing physical inventory of equipment, 2 of our 40 sample sections were found to have been disposed of without being removed from the inventory listing. Both of these pieces of equipment were indicated as counted during the inventory count despite being disposed of prior to the count date. These two pieces of equipment were significantly aged, had no estimated remaining fair market value, and related to grants that had ended several years ago. Therefore, there are no questioned costs related to the missing equipment. Cause and possible asserted effect: The inventory count control was not operating effectively to detect and properly track the missing equipment. Failure to accurately count equipment and to maintain accurate property records may result in the University not properly safeguarding and maintaining equipment in accordance with Federal requirements. Identification of questioned costs and how they were computed: None Sample Statistically Valid: The sample was not intended to be, and was not, a statistically valid sample. Repeat finding from prior year: No Recommendation: We recommend management enhance their internal control processes and training of people performing inventory counts to ensure the data obtained during the inventory count is appropriately reviewed to ensure that count errors are detected and corrected. Views of Responsible Officials: Management agrees with the finding noted in this report. Management has developed a corrective action plan and is in the process of improving processes and internal control systems to ensure that effective controls are in place over federally purchased equipment.
Program Information: Federal Program: Research and Development Cluster Assistance Listing Numbers: Various Federal Agencies: Various Award Year: Various Criteria or requirement: According to 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property, who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Per Title 2, U.S. Code of Federal Regulations Part 200 (2 CRF 200), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award, (Subpart D, Section 200.303), the nonfederal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Condition found, including facts that support the deficiency identified in the finding and information to provide proper perspective for judging the prevalence and consequences of the finding: During our procedures over management’s process of observing physical inventory of equipment, 2 of our 40 sample sections were found to have been disposed of without being removed from the inventory listing. Both of these pieces of equipment were indicated as counted during the inventory count despite being disposed of prior to the count date. These two pieces of equipment were significantly aged, had no estimated remaining fair market value, and related to grants that had ended several years ago. Therefore, there are no questioned costs related to the missing equipment. Cause and possible asserted effect: The inventory count control was not operating effectively to detect and properly track the missing equipment. Failure to accurately count equipment and to maintain accurate property records may result in the University not properly safeguarding and maintaining equipment in accordance with Federal requirements. Identification of questioned costs and how they were computed: None Sample Statistically Valid: The sample was not intended to be, and was not, a statistically valid sample. Repeat finding from prior year: No Recommendation: We recommend management enhance their internal control processes and training of people performing inventory counts to ensure the data obtained during the inventory count is appropriately reviewed to ensure that count errors are detected and corrected. Views of Responsible Officials: Management agrees with the finding noted in this report. Management has developed a corrective action plan and is in the process of improving processes and internal control systems to ensure that effective controls are in place over federally purchased equipment.
Program Information: Federal Program: Research and Development Cluster Assistance Listing Numbers: Various Federal Agencies: Various Award Year: Various Criteria or requirement: According to 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property, who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Per Title 2, U.S. Code of Federal Regulations Part 200 (2 CRF 200), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award, (Subpart D, Section 200.303), the nonfederal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Condition found, including facts that support the deficiency identified in the finding and information to provide proper perspective for judging the prevalence and consequences of the finding: During our procedures over management’s process of observing physical inventory of equipment, 2 of our 40 sample sections were found to have been disposed of without being removed from the inventory listing. Both of these pieces of equipment were indicated as counted during the inventory count despite being disposed of prior to the count date. These two pieces of equipment were significantly aged, had no estimated remaining fair market value, and related to grants that had ended several years ago. Therefore, there are no questioned costs related to the missing equipment. Cause and possible asserted effect: The inventory count control was not operating effectively to detect and properly track the missing equipment. Failure to accurately count equipment and to maintain accurate property records may result in the University not properly safeguarding and maintaining equipment in accordance with Federal requirements. Identification of questioned costs and how they were computed: None Sample Statistically Valid: The sample was not intended to be, and was not, a statistically valid sample. Repeat finding from prior year: No Recommendation: We recommend management enhance their internal control processes and training of people performing inventory counts to ensure the data obtained during the inventory count is appropriately reviewed to ensure that count errors are detected and corrected. Views of Responsible Officials: Management agrees with the finding noted in this report. Management has developed a corrective action plan and is in the process of improving processes and internal control systems to ensure that effective controls are in place over federally purchased equipment.