FINDING 2022-001 ? Equipment and Real Property Management ? Significant Deficiency in Internal Controls and Instance of Non-Compliance "See Schedule of Findings and Questioned Costs for chart/table" Criteria: An institution must conduct a physical inventory of equipment and real property at least once every two years with results reconciled with the equipment records (2 CFR section 200.313(d)(2)). Condition/Context: In testing equipment and real property management, we requested from management support for their conduction of a physical inventory of equipment and real property acquired with federal funds. We noted management was unable to produce such records, as a physical inventory of federal equipment and real property had not been conducted within the required two-year period. Cause: There was a lapse in internal controls surrounding monitoring the physical inventory of equipment and real property acquired with federal funds. Effect: The College did not timely conduct their physical inventory of equipment and real property acquired with federal funds within the two-year period. Repeat Finding: This is not a repeat finding. Recommendation: We recommend the College implement a policy to monitor the physical inventory of equipment and real property acquired with federal funds at least once during each two-year period. Views of responsible officials: Management agrees there was a lapse in controls surrounding monitoring the physical inventory of equipment and real property acquired with federal funds. New and revised controls will be implemented to ensure a physical inventory of federally acquired equipment and real property is conducted within the required two-year period. These controls include performing this physical inventory at least annually to ensure the two-year requirement is met.
FINDING 2022-001 ? Equipment and Real Property Management ? Significant Deficiency in Internal Controls and Instance of Non-Compliance "See Schedule of Findings and Questioned Costs for chart/table" Criteria: An institution must conduct a physical inventory of equipment and real property at least once every two years with results reconciled with the equipment records (2 CFR section 200.313(d)(2)). Condition/Context: In testing equipment and real property management, we requested from management support for their conduction of a physical inventory of equipment and real property acquired with federal funds. We noted management was unable to produce such records, as a physical inventory of federal equipment and real property had not been conducted within the required two-year period. Cause: There was a lapse in internal controls surrounding monitoring the physical inventory of equipment and real property acquired with federal funds. Effect: The College did not timely conduct their physical inventory of equipment and real property acquired with federal funds within the two-year period. Repeat Finding: This is not a repeat finding. Recommendation: We recommend the College implement a policy to monitor the physical inventory of equipment and real property acquired with federal funds at least once during each two-year period. Views of responsible officials: Management agrees there was a lapse in controls surrounding monitoring the physical inventory of equipment and real property acquired with federal funds. New and revised controls will be implemented to ensure a physical inventory of federally acquired equipment and real property is conducted within the required two-year period. These controls include performing this physical inventory at least annually to ensure the two-year requirement is met.
2022-003: Equipment and Real Property Management - Material Weakness over Internal Controls over Compliance Federal Program Title and Year: Emergency Solutions Grant Program, 2021 ALN: 14.231 Federal Awarding Agency: HUD Pass-Through Entity: New Mexico Mortgage Finance Authority Pass-Through Identifying Number: 21-02-SES-EHA-001 Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, a non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should 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). Per 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 (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. Per 2 CFR 200.313(d)(2), a physical inventory of program property must be taken and the results reconciled with the property records at least once every 2 years. Condition: The Organization was not able to provide an equipment listing tracking items purchased with federal funding nor did the Organization conduct a physical inventory. Cause: The Organization does not have policies and procedures to ensure that equipment purchases with federal funds is maintained and tracked and that the Organization is performing a physical inventory at a minimum of every two years. Effect: The Organization could dispose of or lose federally funded equipment without following federal guidelines. Questioned Costs: None noted. Auditors? Recommendation: We recommend the Organization enhance the design of its control activities and policies and procedures should be developed to ensure physical inventories are taken at least once every two years and that they create a tool to assist in tracking and maintaining equipment purchased with federal funds.
2022-003: Equipment and Real Property Management - Material Weakness over Internal Controls over Compliance Federal Program Title and Year: Emergency Solutions Grant Program, 2021 ALN: 14.231 Federal Awarding Agency: HUD Pass-Through Entity: New Mexico Mortgage Finance Authority Pass-Through Identifying Number: 21-02-SES-EHA-001 Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, a non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should 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). Per 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 (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. Per 2 CFR 200.313(d)(2), a physical inventory of program property must be taken and the results reconciled with the property records at least once every 2 years. Condition: The Organization was not able to provide an equipment listing tracking items purchased with federal funding nor did the Organization conduct a physical inventory. Cause: The Organization does not have policies and procedures to ensure that equipment purchases with federal funds is maintained and tracked and that the Organization is performing a physical inventory at a minimum of every two years. Effect: The Organization could dispose of or lose federally funded equipment without following federal guidelines. Questioned Costs: None noted. Auditors? Recommendation: We recommend the Organization enhance the design of its control activities and policies and procedures should be developed to ensure physical inventories are taken at least once every two years and that they create a tool to assist in tracking and maintaining equipment purchased with federal funds.
SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS 1. FINDING NUMBER: 2022- 002 2. THIS FINDING IS: X New Repeat from Prior year? Year originally reported? 3. Federal Program Name and Year: COVID 19: Education Stabilization Fund (2021 & 2022) 4. Project No.: 4998-ER, E2 & E3 5. CFDA No.: 84.425D-COVID 19, 84.425U-COVID 19 6. Passed Through: Illinois State Board of Education 7. Federal Agency: Department of Education 8. Criteria or specific requirement (including statutory, regulatory, or other citation) Equipment and Real Property Management compliance requirements require that property records be maintained that include a description of the property, a serial number or other identification number, the source of funding of the property (including the federal award identification number), 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 the sales price of the property. (2 CFR section 200.313(d)(1)) 9. Condition The District's property records did not include the date purchased and serial numbers for equipment purchased with Education Stabilization Funding. 10. Questioned Costs None 11. Context The inventory of equipment is material to the program. 12. Effect The District is not in compliance with Equipment and Real Property Management compliance requirements. 13. Cause The District was not aware that the date purchased and serial numbers needed to be included in the property records. 14. Recommendation The District should assign an employee independent of the preparer, preferably with knowledge of applicable federal grant expenditures, to review the District's property records on a periodic basis to ensure the listing meets the requirements of 2 CFR section 200.313(d)(1). 15. Management's response Management will implement the auditor's recommendation for the year ended June 30, 2023.
SECTION III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS 1. FINDING NUMBER: 2022- 002 2. THIS FINDING IS: X New Repeat from Prior year? Year originally reported? 3. Federal Program Name and Year: COVID 19: Education Stabilization Fund (2021 & 2022) 4. Project No.: 4998-ER, E2 & E3 5. CFDA No.: 84.425D-COVID 19, 84.425U-COVID 19 6. Passed Through: Illinois State Board of Education 7. Federal Agency: Department of Education 8. Criteria or specific requirement (including statutory, regulatory, or other citation) Equipment and Real Property Management compliance requirements require that property records be maintained that include a description of the property, a serial number or other identification number, the source of funding of the property (including the federal award identification number), 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 the sales price of the property. (2 CFR section 200.313(d)(1)) 9. Condition The District's property records did not include the date purchased and serial numbers for equipment purchased with Education Stabilization Funding. 10. Questioned Costs None 11. Context The inventory of equipment is material to the program. 12. Effect The District is not in compliance with Equipment and Real Property Management compliance requirements. 13. Cause The District was not aware that the date purchased and serial numbers needed to be included in the property records. 14. Recommendation The District should assign an employee independent of the preparer, preferably with knowledge of applicable federal grant expenditures, to review the District's property records on a periodic basis to ensure the listing meets the requirements of 2 CFR section 200.313(d)(1). 15. Management's response Management will implement the auditor's recommendation for the year ended June 30, 2023.
2022-010 ? Equipment and Real Property Management ? Material Weakness Federal Program Information Funding Agency: Department of Defense, National Science Foundation, Department of Education, Department of Health and Human Services ? National Institute of Health Federal Award Agreement Number: Not Applicable Award Year: Fiscal year 2022 Title: Research and Development Cluster Assistance Listing Number: 12.598, 47.050, 47.076, 84.031, and 93.859 Pass-through Agency: Not Applicable, Direct Program Pass-through Identification Number: Not Applicable, Direct Program Condition - The College was not able to provide an equipment listing tracking items purchased with federal funding nor did the College conduct a physical inventory.Criteria - Per 2 CFR 200.313(d)(2), a physical inventory of program property must be taken and the results reconciled with the property records at least once every 2 years and per 2 CFR 200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations and the terms and conditions of the Federal award. Questioned Costs - Not applicable. Effect - The College could dispose of or lose federally funded equipment without following federal guidelines. Cause - The College does not have policies and procedures to ensure that equipment purchases with federal funds is maintained and tracked and that the College performing a physical inventory at a minimum of every two years.
2022-010 ? Equipment and Real Property Management ? Material Weakness Federal Program Information Funding Agency: Department of Defense, National Science Foundation, Department of Education, Department of Health and Human Services ? National Institute of Health Federal Award Agreement Number: Not Applicable Award Year: Fiscal year 2022 Title: Research and Development Cluster Assistance Listing Number: 12.598, 47.050, 47.076, 84.031, and 93.859 Pass-through Agency: Not Applicable, Direct Program Pass-through Identification Number: Not Applicable, Direct Program Condition - The College was not able to provide an equipment listing tracking items purchased with federal funding nor did the College conduct a physical inventory.Criteria - Per 2 CFR 200.313(d)(2), a physical inventory of program property must be taken and the results reconciled with the property records at least once every 2 years and per 2 CFR 200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations and the terms and conditions of the Federal award. Questioned Costs - Not applicable. Effect - The College could dispose of or lose federally funded equipment without following federal guidelines. Cause - The College does not have policies and procedures to ensure that equipment purchases with federal funds is maintained and tracked and that the College performing a physical inventory at a minimum of every two years.
2022-010 ? Equipment and Real Property Management ? Material Weakness Federal Program Information Funding Agency: Department of Defense, National Science Foundation, Department of Education, Department of Health and Human Services ? National Institute of Health Federal Award Agreement Number: Not Applicable Award Year: Fiscal year 2022 Title: Research and Development Cluster Assistance Listing Number: 12.598, 47.050, 47.076, 84.031, and 93.859 Pass-through Agency: Not Applicable, Direct Program Pass-through Identification Number: Not Applicable, Direct Program Condition - The College was not able to provide an equipment listing tracking items purchased with federal funding nor did the College conduct a physical inventory.Criteria - Per 2 CFR 200.313(d)(2), a physical inventory of program property must be taken and the results reconciled with the property records at least once every 2 years and per 2 CFR 200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations and the terms and conditions of the Federal award. Questioned Costs - Not applicable. Effect - The College could dispose of or lose federally funded equipment without following federal guidelines. Cause - The College does not have policies and procedures to ensure that equipment purchases with federal funds is maintained and tracked and that the College performing a physical inventory at a minimum of every two years.
2022-010 ? Equipment and Real Property Management ? Material Weakness Federal Program Information Funding Agency: Department of Defense, National Science Foundation, Department of Education, Department of Health and Human Services ? National Institute of Health Federal Award Agreement Number: Not Applicable Award Year: Fiscal year 2022 Title: Research and Development Cluster Assistance Listing Number: 12.598, 47.050, 47.076, 84.031, and 93.859 Pass-through Agency: Not Applicable, Direct Program Pass-through Identification Number: Not Applicable, Direct Program Condition - The College was not able to provide an equipment listing tracking items purchased with federal funding nor did the College conduct a physical inventory.Criteria - Per 2 CFR 200.313(d)(2), a physical inventory of program property must be taken and the results reconciled with the property records at least once every 2 years and per 2 CFR 200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations and the terms and conditions of the Federal award. Questioned Costs - Not applicable. Effect - The College could dispose of or lose federally funded equipment without following federal guidelines. Cause - The College does not have policies and procedures to ensure that equipment purchases with federal funds is maintained and tracked and that the College performing a physical inventory at a minimum of every two years.
FINDING 2022-010 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.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, 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 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 Equipment and Real Property Management compliance requirement. The School Corporation paid $4,173,474 for roof improvements at five locations. These capital improvements were not added to a detailed listing of capital assets that 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 the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. Assets were not properly safeguarded and maintained. 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: "(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 lease once every two years. INDIANA STATE BOARD OF ACCOUNTS 38 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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. . . ." Cause Management had not established a system of internal controls that would have ensured compliance with the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could have resulted in the loss of federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-010 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.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, 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 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 Equipment and Real Property Management compliance requirement. The School Corporation paid $4,173,474 for roof improvements at five locations. These capital improvements were not added to a detailed listing of capital assets that 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 the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. Assets were not properly safeguarded and maintained. 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: "(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 lease once every two years. INDIANA STATE BOARD OF ACCOUNTS 38 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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. . . ." Cause Management had not established a system of internal controls that would have ensured compliance with the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could have resulted in the loss of federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-010 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.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, 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 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 Equipment and Real Property Management compliance requirement. The School Corporation paid $4,173,474 for roof improvements at five locations. These capital improvements were not added to a detailed listing of capital assets that 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 the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. Assets were not properly safeguarded and maintained. 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: "(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 lease once every two years. INDIANA STATE BOARD OF ACCOUNTS 38 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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. . . ." Cause Management had not established a system of internal controls that would have ensured compliance with the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could have resulted in the loss of federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-010 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.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, 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 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 Equipment and Real Property Management compliance requirement. The School Corporation paid $4,173,474 for roof improvements at five locations. These capital improvements were not added to a detailed listing of capital assets that 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 the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. Assets were not properly safeguarded and maintained. 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: "(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 lease once every two years. INDIANA STATE BOARD OF ACCOUNTS 38 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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. . . ." Cause Management had not established a system of internal controls that would have ensured compliance with the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could have resulted in the loss of federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-010 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.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, 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 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 Equipment and Real Property Management compliance requirement. The School Corporation paid $4,173,474 for roof improvements at five locations. These capital improvements were not added to a detailed listing of capital assets that 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 the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. Assets were not properly safeguarded and maintained. 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: "(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 lease once every two years. INDIANA STATE BOARD OF ACCOUNTS 38 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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. . . ." Cause Management had not established a system of internal controls that would have ensured compliance with the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could have resulted in the loss of federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
2022-008 Federal Agency: U.S. Department of Education Pass Thru Entity: Oklahoma State Department of Education Program: COVID-19 Education Stabilization Fund Assistance Listing: COVID-19- 84.425D & 84.425U Grant Period: Year ending June 30, 2022 Condition: Property acquired with federal funds were not tracked in property records. Criteria: 2 CFR 200.313(d)(1) requires property records must be maintained that include a description of the property, serial number or other identification number, the source of funding for the property, who holds title, the acquisition date, the cost of the property, percentage of the federal project costs under which 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. Cause: Failure to identify construction in progress as capital outlay for property. Effect: The expenditures may be disallowed. Context: A sample of $2,908,079 was selected for audit from a population of $3,035,125. The test found $2,341,866 was not in compliance. Questioned Costs: $2,341,866 Repeat Finding from Prior Year: Yes; 2021-006 Recommendation We recommend that property be properly tracked. We also recommend reconciliations procedures be implemented of property paid with federal funds and federal property listing. Views of Responsible Officials And Planned Corrective Action: Lawton Public Schools failed to identify ?Construction in Progress? paid for with federal funds as federal. Procedures will be updated to ensure ?Construction in Progress? paid with federal funds is identified and recorded as federal immediately rather than at the completion of the construction. While this finding is identified as a repeat finding from FY2021 (2021-006), the prior year was in reference to fixed assets while this year?s finding is in reference to ?Construction in Progress?.
2022-008 Federal Agency: U.S. Department of Education Pass Thru Entity: Oklahoma State Department of Education Program: COVID-19 Education Stabilization Fund Assistance Listing: COVID-19- 84.425D & 84.425U Grant Period: Year ending June 30, 2022 Condition: Property acquired with federal funds were not tracked in property records. Criteria: 2 CFR 200.313(d)(1) requires property records must be maintained that include a description of the property, serial number or other identification number, the source of funding for the property, who holds title, the acquisition date, the cost of the property, percentage of the federal project costs under which 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. Cause: Failure to identify construction in progress as capital outlay for property. Effect: The expenditures may be disallowed. Context: A sample of $2,908,079 was selected for audit from a population of $3,035,125. The test found $2,341,866 was not in compliance. Questioned Costs: $2,341,866 Repeat Finding from Prior Year: Yes; 2021-006 Recommendation We recommend that property be properly tracked. We also recommend reconciliations procedures be implemented of property paid with federal funds and federal property listing. Views of Responsible Officials And Planned Corrective Action: Lawton Public Schools failed to identify ?Construction in Progress? paid for with federal funds as federal. Procedures will be updated to ensure ?Construction in Progress? paid with federal funds is identified and recorded as federal immediately rather than at the completion of the construction. While this finding is identified as a repeat finding from FY2021 (2021-006), the prior year was in reference to fixed assets while this year?s finding is in reference to ?Construction in Progress?.
2022-008 Federal Agency: U.S. Department of Education Pass Thru Entity: Oklahoma State Department of Education Program: COVID-19 Education Stabilization Fund Assistance Listing: COVID-19- 84.425D & 84.425U Grant Period: Year ending June 30, 2022 Condition: Property acquired with federal funds were not tracked in property records. Criteria: 2 CFR 200.313(d)(1) requires property records must be maintained that include a description of the property, serial number or other identification number, the source of funding for the property, who holds title, the acquisition date, the cost of the property, percentage of the federal project costs under which 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. Cause: Failure to identify construction in progress as capital outlay for property. Effect: The expenditures may be disallowed. Context: A sample of $2,908,079 was selected for audit from a population of $3,035,125. The test found $2,341,866 was not in compliance. Questioned Costs: $2,341,866 Repeat Finding from Prior Year: Yes; 2021-006 Recommendation We recommend that property be properly tracked. We also recommend reconciliations procedures be implemented of property paid with federal funds and federal property listing. Views of Responsible Officials And Planned Corrective Action: Lawton Public Schools failed to identify ?Construction in Progress? paid for with federal funds as federal. Procedures will be updated to ensure ?Construction in Progress? paid with federal funds is identified and recorded as federal immediately rather than at the completion of the construction. While this finding is identified as a repeat finding from FY2021 (2021-006), the prior year was in reference to fixed assets while this year?s finding is in reference to ?Construction in Progress?.
2022-008 Federal Agency: U.S. Department of Education Pass Thru Entity: Oklahoma State Department of Education Program: COVID-19 Education Stabilization Fund Assistance Listing: COVID-19- 84.425D & 84.425U Grant Period: Year ending June 30, 2022 Condition: Property acquired with federal funds were not tracked in property records. Criteria: 2 CFR 200.313(d)(1) requires property records must be maintained that include a description of the property, serial number or other identification number, the source of funding for the property, who holds title, the acquisition date, the cost of the property, percentage of the federal project costs under which 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. Cause: Failure to identify construction in progress as capital outlay for property. Effect: The expenditures may be disallowed. Context: A sample of $2,908,079 was selected for audit from a population of $3,035,125. The test found $2,341,866 was not in compliance. Questioned Costs: $2,341,866 Repeat Finding from Prior Year: Yes; 2021-006 Recommendation We recommend that property be properly tracked. We also recommend reconciliations procedures be implemented of property paid with federal funds and federal property listing. Views of Responsible Officials And Planned Corrective Action: Lawton Public Schools failed to identify ?Construction in Progress? paid for with federal funds as federal. Procedures will be updated to ensure ?Construction in Progress? paid with federal funds is identified and recorded as federal immediately rather than at the completion of the construction. While this finding is identified as a repeat finding from FY2021 (2021-006), the prior year was in reference to fixed assets while this year?s finding is in reference to ?Construction in Progress?.
2022-008 Federal Agency: U.S. Department of Education Pass Thru Entity: Oklahoma State Department of Education Program: COVID-19 Education Stabilization Fund Assistance Listing: COVID-19- 84.425D & 84.425U Grant Period: Year ending June 30, 2022 Condition: Property acquired with federal funds were not tracked in property records. Criteria: 2 CFR 200.313(d)(1) requires property records must be maintained that include a description of the property, serial number or other identification number, the source of funding for the property, who holds title, the acquisition date, the cost of the property, percentage of the federal project costs under which 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. Cause: Failure to identify construction in progress as capital outlay for property. Effect: The expenditures may be disallowed. Context: A sample of $2,908,079 was selected for audit from a population of $3,035,125. The test found $2,341,866 was not in compliance. Questioned Costs: $2,341,866 Repeat Finding from Prior Year: Yes; 2021-006 Recommendation We recommend that property be properly tracked. We also recommend reconciliations procedures be implemented of property paid with federal funds and federal property listing. Views of Responsible Officials And Planned Corrective Action: Lawton Public Schools failed to identify ?Construction in Progress? paid for with federal funds as federal. Procedures will be updated to ensure ?Construction in Progress? paid with federal funds is identified and recorded as federal immediately rather than at the completion of the construction. While this finding is identified as a repeat finding from FY2021 (2021-006), the prior year was in reference to fixed assets while this year?s finding is in reference to ?Construction in Progress?.
Type of Finding: Significant Deficiency Criteria: The Uniform Guidance-Section F Equipment and Real Property Management and the District's State-Federal Grants Manual (page 57, page 60) states property records must be maintained to include a description of the property, a serial number or other identification number, the source funding for the property (including a Federal Award Identification Number), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project cost 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 (2CFR section 200.313(d)(1)). Condition: The District did not maintain property records that include a description of the property, the acquisition date, cost of the property, percentage of Federal participation in the project cost for the Federal award under which the property was acquired and the location and use of the property. Cause: The District failed to monitor and comply with the requirements of the Uniform Guidance and the District's State-Federal Grants Manual with regard to equipment and real property management. Effect: Due to non-compliance the District would not be able to properly dispose capital assets in compliance with the Federal Regulations. Questioned Cost: None Recommendation: The District should review, monitor and comply with the regulations of the Uniform Guidance- Section F Equipment and Real Property Management and the District's State-Federal Grants Manual with regard to purchasing, maintaining and disposing of capital assets purchased with federal funds. Views of responsible officials and planned corrective action: This information is in the attached Corrective Action Plan.
Type of Finding: Significant Deficiency Criteria: The Uniform Guidance-Section F Equipment and Real Property Management and the District's State-Federal Grants Manual (page 57, page 60) states property records must be maintained to include a description of the property, a serial number or other identification number, the source funding for the property (including a Federal Award Identification Number), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project cost 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 (2CFR section 200.313(d)(1)). Condition: The District did not maintain property records that include a description of the property, the acquisition date, cost of the property, percentage of Federal participation in the project cost for the Federal award under which the property was acquired and the location and use of the property. Cause: The District failed to monitor and comply with the requirements of the Uniform Guidance and the District's State-Federal Grants Manual with regard to equipment and real property management. Effect: Due to non-compliance the District would not be able to properly dispose capital assets in compliance with the Federal Regulations. Questioned Cost: None Recommendation: The District should review, monitor and comply with the regulations of the Uniform Guidance- Section F Equipment and Real Property Management and the District's State-Federal Grants Manual with regard to purchasing, maintaining and disposing of capital assets purchased with federal funds. Views of responsible officials and planned corrective action: This information is in the attached Corrective Action Plan.
FINDING 2022-003 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.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, 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 An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation paid $136,819 for a new roof on multiple school buildings with COVID-19 - Education Stabilization Fund money. These assets were not added to a detailed listing of capital assets that 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 the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. Assets were not properly safeguarded and maintained as they were not added to an asset listing. The lack of internal controls and noncompliance were systemic issued 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 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.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. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. (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. . . ." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management 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 control to ensure compliance and to comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-003 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.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, 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 An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation paid $136,819 for a new roof on multiple school buildings with COVID-19 - Education Stabilization Fund money. These assets were not added to a detailed listing of capital assets that 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 the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. Assets were not properly safeguarded and maintained as they were not added to an asset listing. The lack of internal controls and noncompliance were systemic issued 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 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.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. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. (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. . . ." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management 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 control to ensure compliance and to comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-003 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.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, 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 An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation paid $136,819 for a new roof on multiple school buildings with COVID-19 - Education Stabilization Fund money. These assets were not added to a detailed listing of capital assets that 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 the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. Assets were not properly safeguarded and maintained as they were not added to an asset listing. The lack of internal controls and noncompliance were systemic issued 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 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.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. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. (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. . . ." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management 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 control to ensure compliance and to comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-003 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.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, 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 An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation paid $136,819 for a new roof on multiple school buildings with COVID-19 - Education Stabilization Fund money. These assets were not added to a detailed listing of capital assets that 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 the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. Assets were not properly safeguarded and maintained as they were not added to an asset listing. The lack of internal controls and noncompliance were systemic issued 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 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.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. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. (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. . . ." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management 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 control to ensure compliance and to comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-003 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.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, 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 An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation paid $136,819 for a new roof on multiple school buildings with COVID-19 - Education Stabilization Fund money. These assets were not added to a detailed listing of capital assets that 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 the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. Assets were not properly safeguarded and maintained as they were not added to an asset listing. The lack of internal controls and noncompliance were systemic issued 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 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.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. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. (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. . . ." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management 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 control to ensure compliance and to comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-003 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.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, 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 An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation paid $136,819 for a new roof on multiple school buildings with COVID-19 - Education Stabilization Fund money. These assets were not added to a detailed listing of capital assets that 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 the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. Assets were not properly safeguarded and maintained as they were not added to an asset listing. The lack of internal controls and noncompliance were systemic issued 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 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.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. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. (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. . . ." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management 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 control to ensure compliance and to comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-003 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.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, 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 An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation paid $136,819 for a new roof on multiple school buildings with COVID-19 - Education Stabilization Fund money. These assets were not added to a detailed listing of capital assets that 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 the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. Assets were not properly safeguarded and maintained as they were not added to an asset listing. The lack of internal controls and noncompliance were systemic issued 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 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.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. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. (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. . . ." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management 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 control to ensure compliance and to comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
U.S. DEPARTMENT OF EDUCATION PASSED THROUGH ARKANSAS DEPARTMENT OF EDUCATION COVID-19 - AMERICAN RESUCE PLAN - ELEMENTARY AND SECONDARY SCHOOL EMERGENCY RELIEF FUND - AL NUMBER 84.425U PASS-THROUGH NUMBER 4602 AUDIT PERIOD - YEAR ENDED JUNE 30, 2022 2022-001. Equipment and Real Property Management Criteria or specific requirement: Property records should be maintained for equipment acquired with federal awards as specified in OMB 2 CFR section 200.313. Condition: A test of the Education Stabilization Fund disbursements and walkthrough procedures revealed that five equipment items purchased with a cost greater than $1,000 each were not recorded in the District's equipment subsidiary ledger. The total cost of the equipment was $61,553. Cause: Lack of internal controls over the equipment subsidiary ledger. Effect or potential effect: The District's equipment subsidiary records were not accurate. Context: As a result of an examination of 10 percent of equipment purchases and performing a walkthrough procedure on internal controls, it was determined that equipment purchases greater than $1,000 were not always properly added to the equipment subsidiary ledger, as a result we identified five pieces of equipment totaling $61,553. Recommendation: The District should contact the Arkansas Division of Elementary and Secondary Education (DESE) for guidance regarding this matter and implement proper controls over program expenditures. Views of responsible officials: The Strong-Huttig School District is commited to addressing and correcting these findings. The District will contact the Arkansas Division of Elementary and Secondary Education for guidance regarding this matter and implement proper controls over program expenditures. The District will also ensure all capital asset records are updated, and maintained moving forward.
U.S. DEPARTMENT OF EDUCATION PASSED THROUGH ARKANSAS DEPARTMENT OF EDUCATION COVID-19 - AMERICAN RESUCE PLAN - ELEMENTARY AND SECONDARY SCHOOL EMERGENCY RELIEF FUND - AL NUMBER 84.425U PASS-THROUGH NUMBER 4602 AUDIT PERIOD - YEAR ENDED JUNE 30, 2022 2022-001. Equipment and Real Property Management Criteria or specific requirement: Property records should be maintained for equipment acquired with federal awards as specified in OMB 2 CFR section 200.313. Condition: A test of the Education Stabilization Fund disbursements and walkthrough procedures revealed that five equipment items purchased with a cost greater than $1,000 each were not recorded in the District's equipment subsidiary ledger. The total cost of the equipment was $61,553. Cause: Lack of internal controls over the equipment subsidiary ledger. Effect or potential effect: The District's equipment subsidiary records were not accurate. Context: As a result of an examination of 10 percent of equipment purchases and performing a walkthrough procedure on internal controls, it was determined that equipment purchases greater than $1,000 were not always properly added to the equipment subsidiary ledger, as a result we identified five pieces of equipment totaling $61,553. Recommendation: The District should contact the Arkansas Division of Elementary and Secondary Education (DESE) for guidance regarding this matter and implement proper controls over program expenditures. Views of responsible officials: The Strong-Huttig School District is commited to addressing and correcting these findings. The District will contact the Arkansas Division of Elementary and Secondary Education for guidance regarding this matter and implement proper controls over program expenditures. The District will also ensure all capital asset records are updated, and maintained moving forward.
SECTION III ? FEDERAL AWARD FINDINGS AND QUESTIONED COSTS _____________________________________________________________________________________________________________________ FINDING NUMBER 2022-007 FEDERAL PROGRAM HEAD START CLUSTER (ASSISTANCE LISTING NUMBER 93.356/ 93.600) PASS-THROUGH PUERTO RICO ADMINISTRATION FOR THE CHILDHOOD CARE AND INTEGRAL DEVELOPMENT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 241-2022-000653/ 241-2021-000444/ 241-2021-000226/ 241-2020- 000139 TYPE OF FINDING COMPLIANCE AND INTERNAL CONTROL COMPLIANCE REQUIREMENT EQUIPMENT AND REAL PROPERTY MANAGEMENT CONDITION During the equipment and real property management test, I noted the following situations: 1) The property subsidiary ledger of the Program was not available for examination. However, the Program?s personnel provided an equipment certification as of February 28, 2022. I selected a sample of six (6) purchases of equipment acquired during the fiscal year 2021-2022 and noted that five (5) of these purchases were not included in the equipment certification; 2) The Program personnel did not provide evidence that a physical inventory was performed during the fiscal year 2021-2022. CRITERIA 2 CFR 200.313, Equipment, (d) Management requirements, establishes the 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. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. (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 the property in good condition. (5) If the non-Federal entity is authorized or required to sell the property, proper sales procedures must be established to ensure the highest possible return. CAUSE The Program?s internal controls and procedures were not followed adequately in order to guarantee adequate records, registering and safeguarding of property and equipment. EFFECT Without completion of a regular physical inventory and maintenance of an adequate property subsidiary record, the Program is at increased risk of theft or loss of equipment, it cannot be assured that Federal equipment records were accurately maintained, and it may not be aware of all equipment disposals or losses. RECOMMENDATION Management should update the property subsidiary ledger and a physical inventory must be made and properly reconciled. QUESTIONED COSTS None PRIOR YEAR FINDING Not applicable. VIEWS OF RESPONSIBLE OFFICIALS AND PLANNED CORRECTIVE ACTION As part of the Head Start program termination by the grantee, the capital assets subsidiary ledger has been updated by the Municipality?s finance department staff. It is important to comment that during the fiscal year 2021-2022, the Program employee in charge of the capital assets administration was removed from his position, as requested by the grantee, and, in an interim basis, another employee was assigned with such functions, in additions to his regular functions.
SECTION III ? FEDERAL AWARD FINDINGS AND QUESTIONED COSTS _____________________________________________________________________________________________________________________ FINDING NUMBER 2022-007 FEDERAL PROGRAM HEAD START CLUSTER (ASSISTANCE LISTING NUMBER 93.356/ 93.600) PASS-THROUGH PUERTO RICO ADMINISTRATION FOR THE CHILDHOOD CARE AND INTEGRAL DEVELOPMENT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 241-2022-000653/ 241-2021-000444/ 241-2021-000226/ 241-2020- 000139 TYPE OF FINDING COMPLIANCE AND INTERNAL CONTROL COMPLIANCE REQUIREMENT EQUIPMENT AND REAL PROPERTY MANAGEMENT CONDITION During the equipment and real property management test, I noted the following situations: 1) The property subsidiary ledger of the Program was not available for examination. However, the Program?s personnel provided an equipment certification as of February 28, 2022. I selected a sample of six (6) purchases of equipment acquired during the fiscal year 2021-2022 and noted that five (5) of these purchases were not included in the equipment certification; 2) The Program personnel did not provide evidence that a physical inventory was performed during the fiscal year 2021-2022. CRITERIA 2 CFR 200.313, Equipment, (d) Management requirements, establishes the 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. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. (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 the property in good condition. (5) If the non-Federal entity is authorized or required to sell the property, proper sales procedures must be established to ensure the highest possible return. CAUSE The Program?s internal controls and procedures were not followed adequately in order to guarantee adequate records, registering and safeguarding of property and equipment. EFFECT Without completion of a regular physical inventory and maintenance of an adequate property subsidiary record, the Program is at increased risk of theft or loss of equipment, it cannot be assured that Federal equipment records were accurately maintained, and it may not be aware of all equipment disposals or losses. RECOMMENDATION Management should update the property subsidiary ledger and a physical inventory must be made and properly reconciled. QUESTIONED COSTS None PRIOR YEAR FINDING Not applicable. VIEWS OF RESPONSIBLE OFFICIALS AND PLANNED CORRECTIVE ACTION As part of the Head Start program termination by the grantee, the capital assets subsidiary ledger has been updated by the Municipality?s finance department staff. It is important to comment that during the fiscal year 2021-2022, the Program employee in charge of the capital assets administration was removed from his position, as requested by the grantee, and, in an interim basis, another employee was assigned with such functions, in additions to his regular functions.
SECTION III ? FEDERAL AWARD FINDINGS AND QUESTIONED COSTS _____________________________________________________________________________________________________________________ FINDING NUMBER 2022-007 FEDERAL PROGRAM HEAD START CLUSTER (ASSISTANCE LISTING NUMBER 93.356/ 93.600) PASS-THROUGH PUERTO RICO ADMINISTRATION FOR THE CHILDHOOD CARE AND INTEGRAL DEVELOPMENT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 241-2022-000653/ 241-2021-000444/ 241-2021-000226/ 241-2020- 000139 TYPE OF FINDING COMPLIANCE AND INTERNAL CONTROL COMPLIANCE REQUIREMENT EQUIPMENT AND REAL PROPERTY MANAGEMENT CONDITION During the equipment and real property management test, I noted the following situations: 1) The property subsidiary ledger of the Program was not available for examination. However, the Program?s personnel provided an equipment certification as of February 28, 2022. I selected a sample of six (6) purchases of equipment acquired during the fiscal year 2021-2022 and noted that five (5) of these purchases were not included in the equipment certification; 2) The Program personnel did not provide evidence that a physical inventory was performed during the fiscal year 2021-2022. CRITERIA 2 CFR 200.313, Equipment, (d) Management requirements, establishes the 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. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. (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 the property in good condition. (5) If the non-Federal entity is authorized or required to sell the property, proper sales procedures must be established to ensure the highest possible return. CAUSE The Program?s internal controls and procedures were not followed adequately in order to guarantee adequate records, registering and safeguarding of property and equipment. EFFECT Without completion of a regular physical inventory and maintenance of an adequate property subsidiary record, the Program is at increased risk of theft or loss of equipment, it cannot be assured that Federal equipment records were accurately maintained, and it may not be aware of all equipment disposals or losses. RECOMMENDATION Management should update the property subsidiary ledger and a physical inventory must be made and properly reconciled. QUESTIONED COSTS None PRIOR YEAR FINDING Not applicable. VIEWS OF RESPONSIBLE OFFICIALS AND PLANNED CORRECTIVE ACTION As part of the Head Start program termination by the grantee, the capital assets subsidiary ledger has been updated by the Municipality?s finance department staff. It is important to comment that during the fiscal year 2021-2022, the Program employee in charge of the capital assets administration was removed from his position, as requested by the grantee, and, in an interim basis, another employee was assigned with such functions, in additions to his regular functions.
FINDING 2022-001 Subject: COVID-19 - Education Stabilization Fund - Equipment Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation used federal funds for equipment purchases related to an HVAC construction project. The School Corporation appropriately listed the purchase in its property records as required but failed to include a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, and the percentage of federal participation in the project costs for the federal award under which the property was acquired. 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)(1) states: "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 sales price of the property." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-001 Subject: COVID-19 - Education Stabilization Fund - Equipment Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation used federal funds for equipment purchases related to an HVAC construction project. The School Corporation appropriately listed the purchase in its property records as required but failed to include a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, and the percentage of federal participation in the project costs for the federal award under which the property was acquired. 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)(1) states: "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 sales price of the property." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-001 Subject: COVID-19 - Education Stabilization Fund - Equipment Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation used federal funds for equipment purchases related to an HVAC construction project. The School Corporation appropriately listed the purchase in its property records as required but failed to include a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, and the percentage of federal participation in the project costs for the federal award under which the property was acquired. 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)(1) states: "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 sales price of the property." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-001 Subject: COVID-19 - Education Stabilization Fund - Equipment Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation used federal funds for equipment purchases related to an HVAC construction project. The School Corporation appropriately listed the purchase in its property records as required but failed to include a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, and the percentage of federal participation in the project costs for the federal award under which the property was acquired. 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)(1) states: "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 sales price of the property." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-001 Subject: COVID-19 - Education Stabilization Fund - Equipment Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation used federal funds for equipment purchases related to an HVAC construction project. The School Corporation appropriately listed the purchase in its property records as required but failed to include a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, and the percentage of federal participation in the project costs for the federal award under which the property was acquired. 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)(1) states: "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 sales price of the property." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-001 Subject: COVID-19 - Education Stabilization Fund - Equipment Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation used federal funds for equipment purchases related to an HVAC construction project. The School Corporation appropriately listed the purchase in its property records as required but failed to include a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, and the percentage of federal participation in the project costs for the federal award under which the property was acquired. 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)(1) states: "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 sales price of the property." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Federal Agency: U.S. Department of Education Pass Thru Entity: Oklahoma State Department of Education Federal Program: COVID-19 Education Stabilization Fund-Elementary & Secondary School Emergency Relief (ESSER I (CARES ACT)) & Elementary & Secondary School Emergency Relief (ESSER II) & American Rescue Plan (ARP)- Elementary and Secondary School Emergency Relief (ESSER III) Assistance Listing: COVID-19 84.425D & 84.425U (OCAS Projects 788; 793 & 795) Condition: Property was not tracked and maintained as property in accordance as federal regulations. Criteria: 2 CFR 200.313(d)(1) requires property records must be maintained that include a description of the property, serial number or other identification number, the source of funding for the property, who holds title, the acquisition date, the cost of the property, percentage of the federal project costs under which 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. Context: All equipment expenditures claimed were reviewed. There were A/C units purchased that should have been captured in the federal inventory listing. Cause: District was unaware those equipment items would need to be on the District property records of federal programs. Effect: Potential noncompliance with Uniform Guidance. Recommendation: We recommend that all property purchased with federal funds be properly tracked. We also recommend reconciliation procedures be implemented of property paid with federal funds and federal inventory listing. Views of Responsible Officials and Planned Corrective Action: District will review federal claims for equipment purchases items greater than $5,000 and life longer than a year and capture equipment items into the property records as they are received.
Federal Agency: U.S. Department of Education Pass Thru Entity: Oklahoma State Department of Education Federal Program: COVID-19 Education Stabilization Fund-Elementary & Secondary School Emergency Relief (ESSER I (CARES ACT)) & Elementary & Secondary School Emergency Relief (ESSER II) & American Rescue Plan (ARP)- Elementary and Secondary School Emergency Relief (ESSER III) Assistance Listing: COVID-19 84.425D & 84.425U (OCAS Projects 788; 793 & 795) Condition: Property was not tracked and maintained as property in accordance as federal regulations. Criteria: 2 CFR 200.313(d)(1) requires property records must be maintained that include a description of the property, serial number or other identification number, the source of funding for the property, who holds title, the acquisition date, the cost of the property, percentage of the federal project costs under which 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. Context: All equipment expenditures claimed were reviewed. There were A/C units purchased that should have been captured in the federal inventory listing. Cause: District was unaware those equipment items would need to be on the District property records of federal programs. Effect: Potential noncompliance with Uniform Guidance. Recommendation: We recommend that all property purchased with federal funds be properly tracked. We also recommend reconciliation procedures be implemented of property paid with federal funds and federal inventory listing. Views of Responsible Officials and Planned Corrective Action: District will review federal claims for equipment purchases items greater than $5,000 and life longer than a year and capture equipment items into the property records as they are received.
Federal Agency: U.S. Department of Education Pass Thru Entity: Oklahoma State Department of Education Federal Program: COVID-19 Education Stabilization Fund-Elementary & Secondary School Emergency Relief (ESSER I (CARES ACT)) & Elementary & Secondary School Emergency Relief (ESSER II) & American Rescue Plan (ARP)- Elementary and Secondary School Emergency Relief (ESSER III) Assistance Listing: COVID-19 84.425D & 84.425U (OCAS Projects 788; 793 & 795) Condition: Property was not tracked and maintained as property in accordance as federal regulations. Criteria: 2 CFR 200.313(d)(1) requires property records must be maintained that include a description of the property, serial number or other identification number, the source of funding for the property, who holds title, the acquisition date, the cost of the property, percentage of the federal project costs under which 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. Context: All equipment expenditures claimed were reviewed. There were A/C units purchased that should have been captured in the federal inventory listing. Cause: District was unaware those equipment items would need to be on the District property records of federal programs. Effect: Potential noncompliance with Uniform Guidance. Recommendation: We recommend that all property purchased with federal funds be properly tracked. We also recommend reconciliation procedures be implemented of property paid with federal funds and federal inventory listing. Views of Responsible Officials and Planned Corrective Action: District will review federal claims for equipment purchases items greater than $5,000 and life longer than a year and capture equipment items into the property records as they are received.
FINDING 2022-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 Number: 84.425U Federal Award Number and Year (or Other Identifying Number): S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters INDIANA STATE BOARD OF ACCOUNTS 15 RICHMOND COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context 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 Equipment and Real Property Management compliance requirement. The School Corporation had not implemented internal controls to ensure that capital assets were added to the capital asset ledger. One piece of equipment purchased for $23,346, was not added to the capital asset ledger. Additionally, the asset was not properly maintained or safeguarded. 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, 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. . . ." Cause An effective system of internal controls was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could result in the loss of future federal funds to the School Corporation. INDIANA STATE BOARD OF ACCOUNTS 16 RICHMOND COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish an effective system of internal controls to ensure compliance and comply with the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report
SECTION III - FEDERAL AWARDS FINDINGS AND QUESTIONED COSTS (CONTINUED) Finding Number: 2022-005 Repeat Finding: Same as prior year financial statement finding 2021-003 Program Name/Assistance Listing Title: Indian School Equalization Program Assistance Listing Number: 15.042 Federal Agency: U.S. Department of the Interior Federal Award Number: A19AV00866 Questioned Costs: None Type of Finding: Noncompliance, Significant Deficiency Compliance Requirement: Equipment and Real Property Management Criteria: Non-federal entities other than states must follow 2 CFR sections 200.313(c) through (e) which includes the requirement that a physical inventory of the property must be taken, and the results reconciled with the property records at least once every two years. Condition/Context: The School did not perform a full physical inventory within the two-year period ending June 30, 2022. Effect: Noncompliance with grant requirements. Cause: Lack of training, management turnover Recommendation: The School should implement policies and procedures that ensure a full physical inventory at least every two fiscal years and the results of the inventory are reconciled with the records in the financial software. Response: The School concurs with this recommendation and will implement procedures to ensure compliance with grant requirements. Contact person: Frances Stevens, Business Manager
FINDING 2022-002: EDUCATION STABILIZATION FUND DISCRETIONARY GRANTS? EQUIPMENT AND REAL PROPERTY MANAGEMENT (50000 & 30000) CFDA Number and Title: 84.425 and 84.425C - Education Stabilization Fund Discretionary Grants: Governor's Emergency Education Relief (GEER) Fund and Elementary, Secondary School Emergency Relief (ESSER) Fund Federal Grantor Name: U.S. Department of Education; Passed through California Department of Education Criteria: Consistent with 2 CFR section 200.311 (real property), section 200.313 (equipment), and section 200.439 (equipment and other capital expenditures) Education Stabilization Funds (ESF) may be used to purchase equipment. Capital expenditures for general and special purpose equipment purchases are subject to prior approval by Education Department (ED) or the pass-through entity. In addition, with prior approval by the ED or the pass-through entity, recipients and subrecipients may use ESF funds to purchase real property and perform construction for improvements to land, buildings, or equipment that meet the overall purpose of the ESF program, which is ?to prevent, prepare for, and respond to? the COVID-19 pandemic. Condition: The Charter used funding from the Elementary and Secondary School Emergency Relief II (ESSER II) Fund program for one capital expenditure. The funding terms and conditions require the Charter to obtain approval from the funding agency prior to incurring the expenditure. The Charter was unable to provide documentation that the required approval was obtained. Cause: The error is a result of the Charter not understanding the terms and conditions of the requirements of the grant agreement. Effect: The effect of not obtaining the required approval resulted in a total of $90,000 in allowable ESF expenditures. Additionally, this error could result in potential loss of funding under this grant. Context: Due to new COVID-19 Emergency Acts Funding this fiscal year, the Charter was unaware this was a requirement for ESSER and GEER. Questioned Costs: The questioned cost is $90,000. Repeat Finding: This is not a repeat finding. Recommendation: We recommend the Charter develop and implement policies and procedures whereby staff obtain an understanding of the funding terms and conditions of all grants in order to prevent future violations of compliance requirements. We recommend the Charter develop and implement policies and procedures whereby staff obtain an understanding of the funding terms and conditions of all grants in order to prevent future violations of compliance requirements. Management should obtain proper training through the appropriate regulatory and granting agencies.
FINDING 2022-002: EDUCATION STABILIZATION FUND DISCRETIONARY GRANTS? EQUIPMENT AND REAL PROPERTY MANAGEMENT (50000 & 30000) CFDA Number and Title: 84.425 and 84.425C - Education Stabilization Fund Discretionary Grants: Governor's Emergency Education Relief (GEER) Fund and Elementary, Secondary School Emergency Relief (ESSER) Fund Federal Grantor Name: U.S. Department of Education; Passed through California Department of Education Criteria: Consistent with 2 CFR section 200.311 (real property), section 200.313 (equipment), and section 200.439 (equipment and other capital expenditures) Education Stabilization Funds (ESF) may be used to purchase equipment. Capital expenditures for general and special purpose equipment purchases are subject to prior approval by Education Department (ED) or the pass-through entity. In addition, with prior approval by the ED or the pass-through entity, recipients and subrecipients may use ESF funds to purchase real property and perform construction for improvements to land, buildings, or equipment that meet the overall purpose of the ESF program, which is ?to prevent, prepare for, and respond to? the COVID-19 pandemic. Condition: The Charter used funding from the Elementary and Secondary School Emergency Relief II (ESSER II) Fund program for one capital expenditure. The funding terms and conditions require the Charter to obtain approval from the funding agency prior to incurring the expenditure. The Charter was unable to provide documentation that the required approval was obtained. Cause: The error is a result of the Charter not understanding the terms and conditions of the requirements of the grant agreement. Effect: The effect of not obtaining the required approval resulted in a total of $90,000 in allowable ESF expenditures. Additionally, this error could result in potential loss of funding under this grant. Context: Due to new COVID-19 Emergency Acts Funding this fiscal year, the Charter was unaware this was a requirement for ESSER and GEER. Questioned Costs: The questioned cost is $90,000. Repeat Finding: This is not a repeat finding. Recommendation: We recommend the Charter develop and implement policies and procedures whereby staff obtain an understanding of the funding terms and conditions of all grants in order to prevent future violations of compliance requirements. We recommend the Charter develop and implement policies and procedures whereby staff obtain an understanding of the funding terms and conditions of all grants in order to prevent future violations of compliance requirements. Management should obtain proper training through the appropriate regulatory and granting agencies.
FINDING 2022-002: EDUCATION STABILIZATION FUND DISCRETIONARY GRANTS? EQUIPMENT AND REAL PROPERTY MANAGEMENT (50000 & 30000) CFDA Number and Title: 84.425 and 84.425C - Education Stabilization Fund Discretionary Grants: Governor's Emergency Education Relief (GEER) Fund and Elementary, Secondary School Emergency Relief (ESSER) Fund Federal Grantor Name: U.S. Department of Education; Passed through California Department of Education Criteria: Consistent with 2 CFR section 200.311 (real property), section 200.313 (equipment), and section 200.439 (equipment and other capital expenditures) Education Stabilization Funds (ESF) may be used to purchase equipment. Capital expenditures for general and special purpose equipment purchases are subject to prior approval by Education Department (ED) or the pass-through entity. In addition, with prior approval by the ED or the pass-through entity, recipients and subrecipients may use ESF funds to purchase real property and perform construction for improvements to land, buildings, or equipment that meet the overall purpose of the ESF program, which is ?to prevent, prepare for, and respond to? the COVID-19 pandemic. Condition: The Charter used funding from the Elementary and Secondary School Emergency Relief II (ESSER II) Fund program for one capital expenditure. The funding terms and conditions require the Charter to obtain approval from the funding agency prior to incurring the expenditure. The Charter was unable to provide documentation that the required approval was obtained. Cause: The error is a result of the Charter not understanding the terms and conditions of the requirements of the grant agreement. Effect: The effect of not obtaining the required approval resulted in a total of $90,000 in allowable ESF expenditures. Additionally, this error could result in potential loss of funding under this grant. Context: Due to new COVID-19 Emergency Acts Funding this fiscal year, the Charter was unaware this was a requirement for ESSER and GEER. Questioned Costs: The questioned cost is $90,000. Repeat Finding: This is not a repeat finding. Recommendation: We recommend the Charter develop and implement policies and procedures whereby staff obtain an understanding of the funding terms and conditions of all grants in order to prevent future violations of compliance requirements. We recommend the Charter develop and implement policies and procedures whereby staff obtain an understanding of the funding terms and conditions of all grants in order to prevent future violations of compliance requirements. Management should obtain proper training through the appropriate regulatory and granting agencies.
FINDING 2022-007 Subject: COVID-19 - Education Stabilization Fund - Equipment 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 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 Equipment and Real Property Management compliance requirement. During fiscal year 2021-2022, the School Corporation purchased two buses totaling $182,486 with Education Stabilization funds. The two buses were included on a fleet listing; however, the listing did not include the federal award identification number (FAIN) or percentage of federal participation, who holds title, the acquisition date, the location, and the use and condition of the property. Additionally, the School Corporation did not complete a physical inventory of equipment within the last two years. 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 states in part: "The non-Federal entity must: . . . (d) 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: INDIANA STATE BOARD OF ACCOUNTS 28 BEECH GROVE CITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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. (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 Management had not developed a system of internal control that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management 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 control related to the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-007 Subject: COVID-19 - Education Stabilization Fund - Equipment 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 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 Equipment and Real Property Management compliance requirement. During fiscal year 2021-2022, the School Corporation purchased two buses totaling $182,486 with Education Stabilization funds. The two buses were included on a fleet listing; however, the listing did not include the federal award identification number (FAIN) or percentage of federal participation, who holds title, the acquisition date, the location, and the use and condition of the property. Additionally, the School Corporation did not complete a physical inventory of equipment within the last two years. 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 states in part: "The non-Federal entity must: . . . (d) 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: INDIANA STATE BOARD OF ACCOUNTS 28 BEECH GROVE CITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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. (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 Management had not developed a system of internal control that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management 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 control related to the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.