Audit 296610

FY End
2023-06-30
Total Expended
$14.83M
Findings
60
Programs
26
Organization: Community Schools of Frankfort (IN)
Year: 2023 Accepted: 2024-03-22

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
383527 2023-002 Material Weakness - F
383528 2023-002 Material Weakness - F
383529 2023-002 Material Weakness - F
383530 2023-002 Material Weakness - F
383531 2023-002 Material Weakness - F
383532 2023-002 Material Weakness - F
383533 2023-003 Material Weakness Yes L
383534 2023-003 Material Weakness Yes L
383535 2023-003 Material Weakness Yes L
383536 2023-003 Material Weakness Yes L
383537 2023-003 Material Weakness Yes L
383538 2023-003 Material Weakness Yes L
383539 2023-004 Material Weakness - B
383540 2023-004 Material Weakness - B
383541 2023-004 Material Weakness - B
383542 2023-004 Material Weakness - B
383543 2023-004 Material Weakness - B
383544 2023-004 Material Weakness - B
383545 2023-005 Material Weakness - ELN
383546 2023-005 Material Weakness - ELN
383547 2023-005 Material Weakness - ELN
383548 2023-005 Material Weakness - ELN
383549 2023-005 Material Weakness - ELN
383550 2023-005 Material Weakness - ELN
383551 2023-006 Material Weakness - I
383552 2023-006 Material Weakness - I
383553 2023-006 Material Weakness - I
383554 2023-006 Material Weakness - I
383555 2023-006 Material Weakness - I
383556 2023-006 Material Weakness - I
959969 2023-002 Material Weakness - F
959970 2023-002 Material Weakness - F
959971 2023-002 Material Weakness - F
959972 2023-002 Material Weakness - F
959973 2023-002 Material Weakness - F
959974 2023-002 Material Weakness - F
959975 2023-003 Material Weakness Yes L
959976 2023-003 Material Weakness Yes L
959977 2023-003 Material Weakness Yes L
959978 2023-003 Material Weakness Yes L
959979 2023-003 Material Weakness Yes L
959980 2023-003 Material Weakness Yes L
959981 2023-004 Material Weakness - B
959982 2023-004 Material Weakness - B
959983 2023-004 Material Weakness - B
959984 2023-004 Material Weakness - B
959985 2023-004 Material Weakness - B
959986 2023-004 Material Weakness - B
959987 2023-005 Material Weakness - ELN
959988 2023-005 Material Weakness - ELN
959989 2023-005 Material Weakness - ELN
959990 2023-005 Material Weakness - ELN
959991 2023-005 Material Weakness - ELN
959992 2023-005 Material Weakness - ELN
959993 2023-006 Material Weakness - I
959994 2023-006 Material Weakness - I
959995 2023-006 Material Weakness - I
959996 2023-006 Material Weakness - I
959997 2023-006 Material Weakness - I
959998 2023-006 Material Weakness - I

Programs

ALN Program Spent Major Findings
10.555 National School Lunch Program 2022 $2.19M Yes 3
10.555 National School Lunch Program 2023 $2.07M Yes 3
84.425 Education Stabilization Fund 2023 $1.75M Yes 2
84.425 Education Stabilization Fund 2022 $1.40M Yes 2
84.010 Title I Grants to Local Educational Agencies 2023 $769,665 Yes 0
84.027 Special Education_grants to States 2022 $667,028 - 0
84.010 Title I Grants to Local Educational Agencies 2022 $643,422 Yes 0
10.553 School Breakfast Program 2023 $528,679 Yes 3
10.553 School Breakfast Program 2022 $520,601 Yes 3
84.048 Career and Technical Education -- Basic Grants to States 2023 $226,461 - 0
93.575 Child Care and Development Block Grant 2023 $181,784 - 0
93.778 Medical Assistance Program 2022 $161,879 - 0
84.048 Career and Technical Education -- Basic Grants to States 2022 $135,903 - 0
84.367 Improving Teacher Quality State Grants 2023 $129,080 - 0
84.367 Improving Teacher Quality State Grants 2022 $118,173 - 0
93.778 Medical Assistance Program 2023 $114,302 - 0
84.365 English Language Acquisition State Grants 2023 $82,785 - 0
84.027 Special Education_grants to States 2023 $74,774 - 0
84.358 Rural Education 2022 $70,740 - 0
84.424 Student Support and Academic Enrichment Program 2023 $68,059 - 0
84.424 Student Support and Academic Enrichment Program 2022 $67,603 - 0
84.365 English Language Acquisition State Grants 2022 $51,627 - 0
10.559 Summer Food Service Program for Children 2023 $36,851 Yes 3
10.559 Summer Food Service Program for Children 2022 $31,121 Yes 3
84.173 Special Education_preschool Grants 2023 $29,951 - 0
84.173 Special Education_preschool Grants 2022 $28,346 - 0

Contacts

Name Title Type
Z1NKTMX7C193 Scott Weltz Auditee
7656545585 Beth Kelley, Cpa, Cfe Auditor
No contacts on file

Notes to SEFA

Accounting Policies: Note 1. Summary of Significant Accounting Policies A. Basis of Presentation The accompanying Schedule of Expenditures of Federal Awards (SEFA) includes the federal grant activity of the School Corporation under programs of the federal government for the years ended June 30, 2022 and 2023. The information in the SEFA is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the SEFA presents only a select portion of the operations of the School Corporation, it is not intended to and does not present the financial position of the School Corporation. The Uniform Guidance requires an annual audit of nonfederal entities expending a total amount of federal awards equal to or in excess of $750,000 in any fiscal year unless by constitution or statute a less frequent audit is required. In accordance with Indiana Code (IC 5-11-1-25), audits of school corporations shall be conducted biennially. Such audits shall include both years within the biennial period. B. Other Significant Accounting Policies Expenditures reported on the SEFA are reported on the cash basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles in OMB Circular A-87, Cost Principles for State, Local, and Indian Tribal Governments, or the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowed or are limited as to reimbursement. When federal grants are received on a reimbursement basis, the federal awards are considered expended when the reimbursement is received. De Minimis Rate Used: N Rate Explanation: The School Corporation has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance.

Finding Details

FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.42U 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. INDIANA STATE BOARD OF ACCOUNTS 18 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation paid for equipment totaling $842,161 with its COVID-19 - Education Stabilization Fund grant award; however, only equipment with a cost of $215,720 could be identified in the asset listing provided. In addition, the School Corporation capital asset records were incomplete and did not include all the required information. The asset listing did not always include the 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. Finally, the School Corporation did not complete a capital asset inventory every two years as required. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, 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. . . ." INDIANA STATE BOARD OF ACCOUNTS 19 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, asset records were incomplete, and a physical inventory was not taken. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and an inventory is taken every two years. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.42U 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. INDIANA STATE BOARD OF ACCOUNTS 18 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation paid for equipment totaling $842,161 with its COVID-19 - Education Stabilization Fund grant award; however, only equipment with a cost of $215,720 could be identified in the asset listing provided. In addition, the School Corporation capital asset records were incomplete and did not include all the required information. The asset listing did not always include the 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. Finally, the School Corporation did not complete a capital asset inventory every two years as required. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, 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. . . ." INDIANA STATE BOARD OF ACCOUNTS 19 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, asset records were incomplete, and a physical inventory was not taken. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and an inventory is taken every two years. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.42U 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. INDIANA STATE BOARD OF ACCOUNTS 18 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation paid for equipment totaling $842,161 with its COVID-19 - Education Stabilization Fund grant award; however, only equipment with a cost of $215,720 could be identified in the asset listing provided. In addition, the School Corporation capital asset records were incomplete and did not include all the required information. The asset listing did not always include the 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. Finally, the School Corporation did not complete a capital asset inventory every two years as required. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, 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. . . ." INDIANA STATE BOARD OF ACCOUNTS 19 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, asset records were incomplete, and a physical inventory was not taken. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and an inventory is taken every two years. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.42U 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. INDIANA STATE BOARD OF ACCOUNTS 18 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation paid for equipment totaling $842,161 with its COVID-19 - Education Stabilization Fund grant award; however, only equipment with a cost of $215,720 could be identified in the asset listing provided. In addition, the School Corporation capital asset records were incomplete and did not include all the required information. The asset listing did not always include the 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. Finally, the School Corporation did not complete a capital asset inventory every two years as required. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, 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. . . ." INDIANA STATE BOARD OF ACCOUNTS 19 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, asset records were incomplete, and a physical inventory was not taken. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and an inventory is taken every two years. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.42U 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. INDIANA STATE BOARD OF ACCOUNTS 18 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation paid for equipment totaling $842,161 with its COVID-19 - Education Stabilization Fund grant award; however, only equipment with a cost of $215,720 could be identified in the asset listing provided. In addition, the School Corporation capital asset records were incomplete and did not include all the required information. The asset listing did not always include the 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. Finally, the School Corporation did not complete a capital asset inventory every two years as required. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, 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. . . ." INDIANA STATE BOARD OF ACCOUNTS 19 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, asset records were incomplete, and a physical inventory was not taken. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and an inventory is taken every two years. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.42U 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. INDIANA STATE BOARD OF ACCOUNTS 18 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation paid for equipment totaling $842,161 with its COVID-19 - Education Stabilization Fund grant award; however, only equipment with a cost of $215,720 could be identified in the asset listing provided. In addition, the School Corporation capital asset records were incomplete and did not include all the required information. The asset listing did not always include the 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. Finally, the School Corporation did not complete a capital asset inventory every two years as required. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, 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. . . ." INDIANA STATE BOARD OF ACCOUNTS 19 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, asset records were incomplete, and a physical inventory was not taken. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and an inventory is taken every two years. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-004. INDIANA STATE BOARD OF ACCOUNTS 20 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period, the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent, or detect and correct, errors. The lack of internal controls was a systemic issue 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). . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include appropriate segregation of duties. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. INDIANA STATE BOARD OF ACCOUNTS 21 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-004. INDIANA STATE BOARD OF ACCOUNTS 20 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period, the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent, or detect and correct, errors. The lack of internal controls was a systemic issue 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). . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include appropriate segregation of duties. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. INDIANA STATE BOARD OF ACCOUNTS 21 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-004. INDIANA STATE BOARD OF ACCOUNTS 20 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period, the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent, or detect and correct, errors. The lack of internal controls was a systemic issue 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). . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include appropriate segregation of duties. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. INDIANA STATE BOARD OF ACCOUNTS 21 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-004. INDIANA STATE BOARD OF ACCOUNTS 20 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period, the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent, or detect and correct, errors. The lack of internal controls was a systemic issue 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). . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include appropriate segregation of duties. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. INDIANA STATE BOARD OF ACCOUNTS 21 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-004. INDIANA STATE BOARD OF ACCOUNTS 20 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period, the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent, or detect and correct, errors. The lack of internal controls was a systemic issue 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). . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include appropriate segregation of duties. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. INDIANA STATE BOARD OF ACCOUNTS 21 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-004. INDIANA STATE BOARD OF ACCOUNTS 20 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period, the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent, or detect and correct, errors. The lack of internal controls was a systemic issue 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). . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include appropriate segregation of duties. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. INDIANA STATE BOARD OF ACCOUNTS 21 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context A cash reimbursement is provided to the School Corporation based on meals served under the School Breakfast Program, National School Lunch Program, and Summer Food Service Program for Children. The cash reimbursement is to be used for the benefit of the food service program. The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. There was no documented internal control in place over payroll claims to ensure that payroll charged to the grant was reviewed and approved by an individual knowledgeable about the cost principles. In addition, pay rates could not be tied directly to the salary ordinance for 4 of the 40 payroll payments tested. Timecards were provided which substantiated the hours worked; however, the hourly rate at which the employees were paid could not be tied to the salary ordinance or other internal records provided. The hourly rates paid to these four employees did not differ significantly from the rates documented in the salary ordinances. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 22 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 7 CFR 220.7(e) states in part: ". . . the School Food Authority shall, with respect to participating schools under its jurisdiction: . . . (1) (i) Maintain a nonprofit school food service; (ii) . . . use all revenues received by such food service only for the operation or improvement of that food service . . ." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 23 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, payroll disbursements identified above could not be tied to an approved salary. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would ensure that employees charged to the grant are paid the approved rate of pay. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context A cash reimbursement is provided to the School Corporation based on meals served under the School Breakfast Program, National School Lunch Program, and Summer Food Service Program for Children. The cash reimbursement is to be used for the benefit of the food service program. The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. There was no documented internal control in place over payroll claims to ensure that payroll charged to the grant was reviewed and approved by an individual knowledgeable about the cost principles. In addition, pay rates could not be tied directly to the salary ordinance for 4 of the 40 payroll payments tested. Timecards were provided which substantiated the hours worked; however, the hourly rate at which the employees were paid could not be tied to the salary ordinance or other internal records provided. The hourly rates paid to these four employees did not differ significantly from the rates documented in the salary ordinances. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 22 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 7 CFR 220.7(e) states in part: ". . . the School Food Authority shall, with respect to participating schools under its jurisdiction: . . . (1) (i) Maintain a nonprofit school food service; (ii) . . . use all revenues received by such food service only for the operation or improvement of that food service . . ." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 23 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, payroll disbursements identified above could not be tied to an approved salary. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would ensure that employees charged to the grant are paid the approved rate of pay. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context A cash reimbursement is provided to the School Corporation based on meals served under the School Breakfast Program, National School Lunch Program, and Summer Food Service Program for Children. The cash reimbursement is to be used for the benefit of the food service program. The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. There was no documented internal control in place over payroll claims to ensure that payroll charged to the grant was reviewed and approved by an individual knowledgeable about the cost principles. In addition, pay rates could not be tied directly to the salary ordinance for 4 of the 40 payroll payments tested. Timecards were provided which substantiated the hours worked; however, the hourly rate at which the employees were paid could not be tied to the salary ordinance or other internal records provided. The hourly rates paid to these four employees did not differ significantly from the rates documented in the salary ordinances. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 22 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 7 CFR 220.7(e) states in part: ". . . the School Food Authority shall, with respect to participating schools under its jurisdiction: . . . (1) (i) Maintain a nonprofit school food service; (ii) . . . use all revenues received by such food service only for the operation or improvement of that food service . . ." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 23 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, payroll disbursements identified above could not be tied to an approved salary. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would ensure that employees charged to the grant are paid the approved rate of pay. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context A cash reimbursement is provided to the School Corporation based on meals served under the School Breakfast Program, National School Lunch Program, and Summer Food Service Program for Children. The cash reimbursement is to be used for the benefit of the food service program. The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. There was no documented internal control in place over payroll claims to ensure that payroll charged to the grant was reviewed and approved by an individual knowledgeable about the cost principles. In addition, pay rates could not be tied directly to the salary ordinance for 4 of the 40 payroll payments tested. Timecards were provided which substantiated the hours worked; however, the hourly rate at which the employees were paid could not be tied to the salary ordinance or other internal records provided. The hourly rates paid to these four employees did not differ significantly from the rates documented in the salary ordinances. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 22 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 7 CFR 220.7(e) states in part: ". . . the School Food Authority shall, with respect to participating schools under its jurisdiction: . . . (1) (i) Maintain a nonprofit school food service; (ii) . . . use all revenues received by such food service only for the operation or improvement of that food service . . ." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 23 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, payroll disbursements identified above could not be tied to an approved salary. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would ensure that employees charged to the grant are paid the approved rate of pay. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context A cash reimbursement is provided to the School Corporation based on meals served under the School Breakfast Program, National School Lunch Program, and Summer Food Service Program for Children. The cash reimbursement is to be used for the benefit of the food service program. The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. There was no documented internal control in place over payroll claims to ensure that payroll charged to the grant was reviewed and approved by an individual knowledgeable about the cost principles. In addition, pay rates could not be tied directly to the salary ordinance for 4 of the 40 payroll payments tested. Timecards were provided which substantiated the hours worked; however, the hourly rate at which the employees were paid could not be tied to the salary ordinance or other internal records provided. The hourly rates paid to these four employees did not differ significantly from the rates documented in the salary ordinances. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 22 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 7 CFR 220.7(e) states in part: ". . . the School Food Authority shall, with respect to participating schools under its jurisdiction: . . . (1) (i) Maintain a nonprofit school food service; (ii) . . . use all revenues received by such food service only for the operation or improvement of that food service . . ." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 23 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, payroll disbursements identified above could not be tied to an approved salary. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would ensure that employees charged to the grant are paid the approved rate of pay. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context A cash reimbursement is provided to the School Corporation based on meals served under the School Breakfast Program, National School Lunch Program, and Summer Food Service Program for Children. The cash reimbursement is to be used for the benefit of the food service program. The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. There was no documented internal control in place over payroll claims to ensure that payroll charged to the grant was reviewed and approved by an individual knowledgeable about the cost principles. In addition, pay rates could not be tied directly to the salary ordinance for 4 of the 40 payroll payments tested. Timecards were provided which substantiated the hours worked; however, the hourly rate at which the employees were paid could not be tied to the salary ordinance or other internal records provided. The hourly rates paid to these four employees did not differ significantly from the rates documented in the salary ordinances. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 22 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 7 CFR 220.7(e) states in part: ". . . the School Food Authority shall, with respect to participating schools under its jurisdiction: . . . (1) (i) Maintain a nonprofit school food service; (ii) . . . use all revenues received by such food service only for the operation or improvement of that food service . . ." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 23 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, payroll disbursements identified above could not be tied to an approved salary. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would ensure that employees charged to the grant are paid the approved rate of pay. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility, Reporting, Special Tests and Provisions - Non-Profit School Food Service Accounts Audit Finding: Material Weakness Condition and Context The School Corporation had not established effective internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 24 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Eligibility The Data Collection Specialist entered direct certifications into the School Corporation's software system. A student that was direct certified was coded in the software system as an import. The Food Service Director then viewed the direct certification listing monthly. However, there was no evidence that the Food Service Director's review took place, nor was there a review or oversight process in place to ensure that direct certifications were properly uploaded into the system or that that the software system accurately recording the direct certification students. Reporting During the 2021-2022 school year, the School Corporation operated under the Seamless Summer Option (SSO), which allowed all students to receive free meals. Therefore, the cafeteria cashiers at each school manually recorded meals served on the meal count forms provided and prescribed by the Indiana Department of Education. The Food Service Director used the meal count forms to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. During the 2022-2023 school year, the School Corporation did not operate under SSO and thus resumed the use of their software, Café Enterprise. Café Enterprise, generated meal count reports by type (i.e., free, reduced, paid, etc.) at each school. The Food Service Director used the meal count reports to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. Special Tests and Provisions - Non-Profit School Food Service Accounts A receipt was prepared and recorded in the school food service account when reimbursement was received for meals served. On a monthly basis, the Deputy Treasurer generated a Fund Report and Revenue History Report and provided it to the Food Service Director. The Food Service Director prepared and utilized a monthly spreadsheet to reconcile the Food Service accounts to the corporation account. While appropriate financial records were prepared and exchanged, there was no documented oversight, review, or approval process in place to ensure the separate accounting took place, that reimbursements were correctly credited to the school food sever account and that transfers out of the food service account were for allowable costs of the food service. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 25 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility, Reporting, Special Tests and Provisions - Non-Profit School Food Service Accounts Audit Finding: Material Weakness Condition and Context The School Corporation had not established effective internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 24 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Eligibility The Data Collection Specialist entered direct certifications into the School Corporation's software system. A student that was direct certified was coded in the software system as an import. The Food Service Director then viewed the direct certification listing monthly. However, there was no evidence that the Food Service Director's review took place, nor was there a review or oversight process in place to ensure that direct certifications were properly uploaded into the system or that that the software system accurately recording the direct certification students. Reporting During the 2021-2022 school year, the School Corporation operated under the Seamless Summer Option (SSO), which allowed all students to receive free meals. Therefore, the cafeteria cashiers at each school manually recorded meals served on the meal count forms provided and prescribed by the Indiana Department of Education. The Food Service Director used the meal count forms to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. During the 2022-2023 school year, the School Corporation did not operate under SSO and thus resumed the use of their software, Café Enterprise. Café Enterprise, generated meal count reports by type (i.e., free, reduced, paid, etc.) at each school. The Food Service Director used the meal count reports to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. Special Tests and Provisions - Non-Profit School Food Service Accounts A receipt was prepared and recorded in the school food service account when reimbursement was received for meals served. On a monthly basis, the Deputy Treasurer generated a Fund Report and Revenue History Report and provided it to the Food Service Director. The Food Service Director prepared and utilized a monthly spreadsheet to reconcile the Food Service accounts to the corporation account. While appropriate financial records were prepared and exchanged, there was no documented oversight, review, or approval process in place to ensure the separate accounting took place, that reimbursements were correctly credited to the school food sever account and that transfers out of the food service account were for allowable costs of the food service. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 25 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility, Reporting, Special Tests and Provisions - Non-Profit School Food Service Accounts Audit Finding: Material Weakness Condition and Context The School Corporation had not established effective internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 24 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Eligibility The Data Collection Specialist entered direct certifications into the School Corporation's software system. A student that was direct certified was coded in the software system as an import. The Food Service Director then viewed the direct certification listing monthly. However, there was no evidence that the Food Service Director's review took place, nor was there a review or oversight process in place to ensure that direct certifications were properly uploaded into the system or that that the software system accurately recording the direct certification students. Reporting During the 2021-2022 school year, the School Corporation operated under the Seamless Summer Option (SSO), which allowed all students to receive free meals. Therefore, the cafeteria cashiers at each school manually recorded meals served on the meal count forms provided and prescribed by the Indiana Department of Education. The Food Service Director used the meal count forms to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. During the 2022-2023 school year, the School Corporation did not operate under SSO and thus resumed the use of their software, Café Enterprise. Café Enterprise, generated meal count reports by type (i.e., free, reduced, paid, etc.) at each school. The Food Service Director used the meal count reports to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. Special Tests and Provisions - Non-Profit School Food Service Accounts A receipt was prepared and recorded in the school food service account when reimbursement was received for meals served. On a monthly basis, the Deputy Treasurer generated a Fund Report and Revenue History Report and provided it to the Food Service Director. The Food Service Director prepared and utilized a monthly spreadsheet to reconcile the Food Service accounts to the corporation account. While appropriate financial records were prepared and exchanged, there was no documented oversight, review, or approval process in place to ensure the separate accounting took place, that reimbursements were correctly credited to the school food sever account and that transfers out of the food service account were for allowable costs of the food service. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 25 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility, Reporting, Special Tests and Provisions - Non-Profit School Food Service Accounts Audit Finding: Material Weakness Condition and Context The School Corporation had not established effective internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 24 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Eligibility The Data Collection Specialist entered direct certifications into the School Corporation's software system. A student that was direct certified was coded in the software system as an import. The Food Service Director then viewed the direct certification listing monthly. However, there was no evidence that the Food Service Director's review took place, nor was there a review or oversight process in place to ensure that direct certifications were properly uploaded into the system or that that the software system accurately recording the direct certification students. Reporting During the 2021-2022 school year, the School Corporation operated under the Seamless Summer Option (SSO), which allowed all students to receive free meals. Therefore, the cafeteria cashiers at each school manually recorded meals served on the meal count forms provided and prescribed by the Indiana Department of Education. The Food Service Director used the meal count forms to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. During the 2022-2023 school year, the School Corporation did not operate under SSO and thus resumed the use of their software, Café Enterprise. Café Enterprise, generated meal count reports by type (i.e., free, reduced, paid, etc.) at each school. The Food Service Director used the meal count reports to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. Special Tests and Provisions - Non-Profit School Food Service Accounts A receipt was prepared and recorded in the school food service account when reimbursement was received for meals served. On a monthly basis, the Deputy Treasurer generated a Fund Report and Revenue History Report and provided it to the Food Service Director. The Food Service Director prepared and utilized a monthly spreadsheet to reconcile the Food Service accounts to the corporation account. While appropriate financial records were prepared and exchanged, there was no documented oversight, review, or approval process in place to ensure the separate accounting took place, that reimbursements were correctly credited to the school food sever account and that transfers out of the food service account were for allowable costs of the food service. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 25 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility, Reporting, Special Tests and Provisions - Non-Profit School Food Service Accounts Audit Finding: Material Weakness Condition and Context The School Corporation had not established effective internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 24 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Eligibility The Data Collection Specialist entered direct certifications into the School Corporation's software system. A student that was direct certified was coded in the software system as an import. The Food Service Director then viewed the direct certification listing monthly. However, there was no evidence that the Food Service Director's review took place, nor was there a review or oversight process in place to ensure that direct certifications were properly uploaded into the system or that that the software system accurately recording the direct certification students. Reporting During the 2021-2022 school year, the School Corporation operated under the Seamless Summer Option (SSO), which allowed all students to receive free meals. Therefore, the cafeteria cashiers at each school manually recorded meals served on the meal count forms provided and prescribed by the Indiana Department of Education. The Food Service Director used the meal count forms to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. During the 2022-2023 school year, the School Corporation did not operate under SSO and thus resumed the use of their software, Café Enterprise. Café Enterprise, generated meal count reports by type (i.e., free, reduced, paid, etc.) at each school. The Food Service Director used the meal count reports to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. Special Tests and Provisions - Non-Profit School Food Service Accounts A receipt was prepared and recorded in the school food service account when reimbursement was received for meals served. On a monthly basis, the Deputy Treasurer generated a Fund Report and Revenue History Report and provided it to the Food Service Director. The Food Service Director prepared and utilized a monthly spreadsheet to reconcile the Food Service accounts to the corporation account. While appropriate financial records were prepared and exchanged, there was no documented oversight, review, or approval process in place to ensure the separate accounting took place, that reimbursements were correctly credited to the school food sever account and that transfers out of the food service account were for allowable costs of the food service. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 25 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility, Reporting, Special Tests and Provisions - Non-Profit School Food Service Accounts Audit Finding: Material Weakness Condition and Context The School Corporation had not established effective internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 24 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Eligibility The Data Collection Specialist entered direct certifications into the School Corporation's software system. A student that was direct certified was coded in the software system as an import. The Food Service Director then viewed the direct certification listing monthly. However, there was no evidence that the Food Service Director's review took place, nor was there a review or oversight process in place to ensure that direct certifications were properly uploaded into the system or that that the software system accurately recording the direct certification students. Reporting During the 2021-2022 school year, the School Corporation operated under the Seamless Summer Option (SSO), which allowed all students to receive free meals. Therefore, the cafeteria cashiers at each school manually recorded meals served on the meal count forms provided and prescribed by the Indiana Department of Education. The Food Service Director used the meal count forms to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. During the 2022-2023 school year, the School Corporation did not operate under SSO and thus resumed the use of their software, Café Enterprise. Café Enterprise, generated meal count reports by type (i.e., free, reduced, paid, etc.) at each school. The Food Service Director used the meal count reports to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. Special Tests and Provisions - Non-Profit School Food Service Accounts A receipt was prepared and recorded in the school food service account when reimbursement was received for meals served. On a monthly basis, the Deputy Treasurer generated a Fund Report and Revenue History Report and provided it to the Food Service Director. The Food Service Director prepared and utilized a monthly spreadsheet to reconcile the Food Service accounts to the corporation account. While appropriate financial records were prepared and exchanged, there was no documented oversight, review, or approval process in place to ensure the separate accounting took place, that reimbursements were correctly credited to the school food sever account and that transfers out of the food service account were for allowable costs of the food service. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 25 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure expenditures charged to the food service program fund (fund 800) are in adherence with the federal and state procurement regulations and requirements. In addition, an effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure covered transactions paid with child nutrition award funds are neither suspended or debarred or otherwise excluded from participating in federal awards. INDIANA STATE BOARD OF ACCOUNTS 26 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Procurement - Internal Control over Small Purchases The School Corporation had not designed or implemented adequate policies or procedures to ensure that proper procurement procedures for small purchases were adhered to. There was no documented oversight, review, or approval process in place at the School Corporation to ensure proper procedures were followed and price or rate quotations were obtained, or documentation to support limited procurement procedures were conducted and maintained for small purchases. Suspension and Debarment Prior to entering into subawards and covered transactions with federal award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusions, collecting a certification from that vendor, or adding a clause or condition to the covered transaction with that vendor. Upon inquiry of the School Corporation in order to review the procedures in place for verifying that a vendor with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the School Corporation disclosed procedures had not been performed to ensure vendors were not suspended or debarred prior to entering into covered transaction. One covered transaction that equaled or exceeded $25,000 was identified. The one transaction, totaling $40,325, was selected for testing. For the one covered transaction, the School Corporation had not performed procedures to ensure the vendor was not suspended or debarred, or otherwise excluded or disqualified from participating in federal assistance programs or activities for suspension or debarment. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to fiscal year 2021-2022. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: INDIANA STATE BOARD OF ACCOUNTS 27 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, vendors to whom payments equal to or in excess of $25,000 were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions or the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place and that contractors are not suspended, debarred, or otherwise excluded prior to entering into any covered transactions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure expenditures charged to the food service program fund (fund 800) are in adherence with the federal and state procurement regulations and requirements. In addition, an effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure covered transactions paid with child nutrition award funds are neither suspended or debarred or otherwise excluded from participating in federal awards. INDIANA STATE BOARD OF ACCOUNTS 26 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Procurement - Internal Control over Small Purchases The School Corporation had not designed or implemented adequate policies or procedures to ensure that proper procurement procedures for small purchases were adhered to. There was no documented oversight, review, or approval process in place at the School Corporation to ensure proper procedures were followed and price or rate quotations were obtained, or documentation to support limited procurement procedures were conducted and maintained for small purchases. Suspension and Debarment Prior to entering into subawards and covered transactions with federal award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusions, collecting a certification from that vendor, or adding a clause or condition to the covered transaction with that vendor. Upon inquiry of the School Corporation in order to review the procedures in place for verifying that a vendor with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the School Corporation disclosed procedures had not been performed to ensure vendors were not suspended or debarred prior to entering into covered transaction. One covered transaction that equaled or exceeded $25,000 was identified. The one transaction, totaling $40,325, was selected for testing. For the one covered transaction, the School Corporation had not performed procedures to ensure the vendor was not suspended or debarred, or otherwise excluded or disqualified from participating in federal assistance programs or activities for suspension or debarment. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to fiscal year 2021-2022. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: INDIANA STATE BOARD OF ACCOUNTS 27 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, vendors to whom payments equal to or in excess of $25,000 were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions or the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place and that contractors are not suspended, debarred, or otherwise excluded prior to entering into any covered transactions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure expenditures charged to the food service program fund (fund 800) are in adherence with the federal and state procurement regulations and requirements. In addition, an effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure covered transactions paid with child nutrition award funds are neither suspended or debarred or otherwise excluded from participating in federal awards. INDIANA STATE BOARD OF ACCOUNTS 26 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Procurement - Internal Control over Small Purchases The School Corporation had not designed or implemented adequate policies or procedures to ensure that proper procurement procedures for small purchases were adhered to. There was no documented oversight, review, or approval process in place at the School Corporation to ensure proper procedures were followed and price or rate quotations were obtained, or documentation to support limited procurement procedures were conducted and maintained for small purchases. Suspension and Debarment Prior to entering into subawards and covered transactions with federal award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusions, collecting a certification from that vendor, or adding a clause or condition to the covered transaction with that vendor. Upon inquiry of the School Corporation in order to review the procedures in place for verifying that a vendor with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the School Corporation disclosed procedures had not been performed to ensure vendors were not suspended or debarred prior to entering into covered transaction. One covered transaction that equaled or exceeded $25,000 was identified. The one transaction, totaling $40,325, was selected for testing. For the one covered transaction, the School Corporation had not performed procedures to ensure the vendor was not suspended or debarred, or otherwise excluded or disqualified from participating in federal assistance programs or activities for suspension or debarment. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to fiscal year 2021-2022. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: INDIANA STATE BOARD OF ACCOUNTS 27 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, vendors to whom payments equal to or in excess of $25,000 were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions or the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place and that contractors are not suspended, debarred, or otherwise excluded prior to entering into any covered transactions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure expenditures charged to the food service program fund (fund 800) are in adherence with the federal and state procurement regulations and requirements. In addition, an effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure covered transactions paid with child nutrition award funds are neither suspended or debarred or otherwise excluded from participating in federal awards. INDIANA STATE BOARD OF ACCOUNTS 26 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Procurement - Internal Control over Small Purchases The School Corporation had not designed or implemented adequate policies or procedures to ensure that proper procurement procedures for small purchases were adhered to. There was no documented oversight, review, or approval process in place at the School Corporation to ensure proper procedures were followed and price or rate quotations were obtained, or documentation to support limited procurement procedures were conducted and maintained for small purchases. Suspension and Debarment Prior to entering into subawards and covered transactions with federal award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusions, collecting a certification from that vendor, or adding a clause or condition to the covered transaction with that vendor. Upon inquiry of the School Corporation in order to review the procedures in place for verifying that a vendor with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the School Corporation disclosed procedures had not been performed to ensure vendors were not suspended or debarred prior to entering into covered transaction. One covered transaction that equaled or exceeded $25,000 was identified. The one transaction, totaling $40,325, was selected for testing. For the one covered transaction, the School Corporation had not performed procedures to ensure the vendor was not suspended or debarred, or otherwise excluded or disqualified from participating in federal assistance programs or activities for suspension or debarment. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to fiscal year 2021-2022. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: INDIANA STATE BOARD OF ACCOUNTS 27 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, vendors to whom payments equal to or in excess of $25,000 were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions or the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place and that contractors are not suspended, debarred, or otherwise excluded prior to entering into any covered transactions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure expenditures charged to the food service program fund (fund 800) are in adherence with the federal and state procurement regulations and requirements. In addition, an effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure covered transactions paid with child nutrition award funds are neither suspended or debarred or otherwise excluded from participating in federal awards. INDIANA STATE BOARD OF ACCOUNTS 26 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Procurement - Internal Control over Small Purchases The School Corporation had not designed or implemented adequate policies or procedures to ensure that proper procurement procedures for small purchases were adhered to. There was no documented oversight, review, or approval process in place at the School Corporation to ensure proper procedures were followed and price or rate quotations were obtained, or documentation to support limited procurement procedures were conducted and maintained for small purchases. Suspension and Debarment Prior to entering into subawards and covered transactions with federal award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusions, collecting a certification from that vendor, or adding a clause or condition to the covered transaction with that vendor. Upon inquiry of the School Corporation in order to review the procedures in place for verifying that a vendor with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the School Corporation disclosed procedures had not been performed to ensure vendors were not suspended or debarred prior to entering into covered transaction. One covered transaction that equaled or exceeded $25,000 was identified. The one transaction, totaling $40,325, was selected for testing. For the one covered transaction, the School Corporation had not performed procedures to ensure the vendor was not suspended or debarred, or otherwise excluded or disqualified from participating in federal assistance programs or activities for suspension or debarment. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to fiscal year 2021-2022. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: INDIANA STATE BOARD OF ACCOUNTS 27 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, vendors to whom payments equal to or in excess of $25,000 were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions or the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place and that contractors are not suspended, debarred, or otherwise excluded prior to entering into any covered transactions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure expenditures charged to the food service program fund (fund 800) are in adherence with the federal and state procurement regulations and requirements. In addition, an effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure covered transactions paid with child nutrition award funds are neither suspended or debarred or otherwise excluded from participating in federal awards. INDIANA STATE BOARD OF ACCOUNTS 26 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Procurement - Internal Control over Small Purchases The School Corporation had not designed or implemented adequate policies or procedures to ensure that proper procurement procedures for small purchases were adhered to. There was no documented oversight, review, or approval process in place at the School Corporation to ensure proper procedures were followed and price or rate quotations were obtained, or documentation to support limited procurement procedures were conducted and maintained for small purchases. Suspension and Debarment Prior to entering into subawards and covered transactions with federal award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusions, collecting a certification from that vendor, or adding a clause or condition to the covered transaction with that vendor. Upon inquiry of the School Corporation in order to review the procedures in place for verifying that a vendor with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the School Corporation disclosed procedures had not been performed to ensure vendors were not suspended or debarred prior to entering into covered transaction. One covered transaction that equaled or exceeded $25,000 was identified. The one transaction, totaling $40,325, was selected for testing. For the one covered transaction, the School Corporation had not performed procedures to ensure the vendor was not suspended or debarred, or otherwise excluded or disqualified from participating in federal assistance programs or activities for suspension or debarment. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to fiscal year 2021-2022. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: INDIANA STATE BOARD OF ACCOUNTS 27 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, vendors to whom payments equal to or in excess of $25,000 were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions or the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place and that contractors are not suspended, debarred, or otherwise excluded prior to entering into any covered transactions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.42U 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. INDIANA STATE BOARD OF ACCOUNTS 18 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation paid for equipment totaling $842,161 with its COVID-19 - Education Stabilization Fund grant award; however, only equipment with a cost of $215,720 could be identified in the asset listing provided. In addition, the School Corporation capital asset records were incomplete and did not include all the required information. The asset listing did not always include the 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. Finally, the School Corporation did not complete a capital asset inventory every two years as required. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, 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. . . ." INDIANA STATE BOARD OF ACCOUNTS 19 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, asset records were incomplete, and a physical inventory was not taken. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and an inventory is taken every two years. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.42U 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. INDIANA STATE BOARD OF ACCOUNTS 18 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation paid for equipment totaling $842,161 with its COVID-19 - Education Stabilization Fund grant award; however, only equipment with a cost of $215,720 could be identified in the asset listing provided. In addition, the School Corporation capital asset records were incomplete and did not include all the required information. The asset listing did not always include the 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. Finally, the School Corporation did not complete a capital asset inventory every two years as required. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, 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. . . ." INDIANA STATE BOARD OF ACCOUNTS 19 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, asset records were incomplete, and a physical inventory was not taken. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and an inventory is taken every two years. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.42U 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. INDIANA STATE BOARD OF ACCOUNTS 18 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation paid for equipment totaling $842,161 with its COVID-19 - Education Stabilization Fund grant award; however, only equipment with a cost of $215,720 could be identified in the asset listing provided. In addition, the School Corporation capital asset records were incomplete and did not include all the required information. The asset listing did not always include the 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. Finally, the School Corporation did not complete a capital asset inventory every two years as required. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, 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. . . ." INDIANA STATE BOARD OF ACCOUNTS 19 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, asset records were incomplete, and a physical inventory was not taken. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and an inventory is taken every two years. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.42U 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. INDIANA STATE BOARD OF ACCOUNTS 18 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation paid for equipment totaling $842,161 with its COVID-19 - Education Stabilization Fund grant award; however, only equipment with a cost of $215,720 could be identified in the asset listing provided. In addition, the School Corporation capital asset records were incomplete and did not include all the required information. The asset listing did not always include the 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. Finally, the School Corporation did not complete a capital asset inventory every two years as required. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, 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. . . ." INDIANA STATE BOARD OF ACCOUNTS 19 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, asset records were incomplete, and a physical inventory was not taken. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and an inventory is taken every two years. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.42U 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. INDIANA STATE BOARD OF ACCOUNTS 18 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation paid for equipment totaling $842,161 with its COVID-19 - Education Stabilization Fund grant award; however, only equipment with a cost of $215,720 could be identified in the asset listing provided. In addition, the School Corporation capital asset records were incomplete and did not include all the required information. The asset listing did not always include the 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. Finally, the School Corporation did not complete a capital asset inventory every two years as required. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, 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. . . ." INDIANA STATE BOARD OF ACCOUNTS 19 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, asset records were incomplete, and a physical inventory was not taken. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and an inventory is taken every two years. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.42U 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, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. INDIANA STATE BOARD OF ACCOUNTS 18 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation paid for equipment totaling $842,161 with its COVID-19 - Education Stabilization Fund grant award; however, only equipment with a cost of $215,720 could be identified in the asset listing provided. In addition, the School Corporation capital asset records were incomplete and did not include all the required information. The asset listing did not always include the 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. Finally, the School Corporation did not complete a capital asset inventory every two years as required. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, 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. . . ." INDIANA STATE BOARD OF ACCOUNTS 19 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, asset records were incomplete, and a physical inventory was not taken. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and an inventory is taken every two years. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-004. INDIANA STATE BOARD OF ACCOUNTS 20 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period, the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent, or detect and correct, errors. The lack of internal controls was a systemic issue 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). . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include appropriate segregation of duties. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. INDIANA STATE BOARD OF ACCOUNTS 21 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-004. INDIANA STATE BOARD OF ACCOUNTS 20 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period, the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent, or detect and correct, errors. The lack of internal controls was a systemic issue 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). . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include appropriate segregation of duties. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. INDIANA STATE BOARD OF ACCOUNTS 21 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-004. INDIANA STATE BOARD OF ACCOUNTS 20 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period, the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent, or detect and correct, errors. The lack of internal controls was a systemic issue 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). . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include appropriate segregation of duties. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. INDIANA STATE BOARD OF ACCOUNTS 21 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-004. INDIANA STATE BOARD OF ACCOUNTS 20 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period, the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent, or detect and correct, errors. The lack of internal controls was a systemic issue 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). . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include appropriate segregation of duties. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. INDIANA STATE BOARD OF ACCOUNTS 21 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-004. INDIANA STATE BOARD OF ACCOUNTS 20 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period, the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent, or detect and correct, errors. The lack of internal controls was a systemic issue 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). . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include appropriate segregation of duties. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. INDIANA STATE BOARD OF ACCOUNTS 21 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Repeat Finding This is a repeat finding from the prior audit report. The prior audit finding number was 2021-004. INDIANA STATE BOARD OF ACCOUNTS 20 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period, the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports; however, a single employee prepared and submitted the reports without a review or oversight process in place to prevent, or detect and correct, errors. The lack of internal controls was a systemic issue 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). . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include appropriate segregation of duties. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. INDIANA STATE BOARD OF ACCOUNTS 21 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context A cash reimbursement is provided to the School Corporation based on meals served under the School Breakfast Program, National School Lunch Program, and Summer Food Service Program for Children. The cash reimbursement is to be used for the benefit of the food service program. The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. There was no documented internal control in place over payroll claims to ensure that payroll charged to the grant was reviewed and approved by an individual knowledgeable about the cost principles. In addition, pay rates could not be tied directly to the salary ordinance for 4 of the 40 payroll payments tested. Timecards were provided which substantiated the hours worked; however, the hourly rate at which the employees were paid could not be tied to the salary ordinance or other internal records provided. The hourly rates paid to these four employees did not differ significantly from the rates documented in the salary ordinances. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 22 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 7 CFR 220.7(e) states in part: ". . . the School Food Authority shall, with respect to participating schools under its jurisdiction: . . . (1) (i) Maintain a nonprofit school food service; (ii) . . . use all revenues received by such food service only for the operation or improvement of that food service . . ." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 23 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, payroll disbursements identified above could not be tied to an approved salary. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would ensure that employees charged to the grant are paid the approved rate of pay. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context A cash reimbursement is provided to the School Corporation based on meals served under the School Breakfast Program, National School Lunch Program, and Summer Food Service Program for Children. The cash reimbursement is to be used for the benefit of the food service program. The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. There was no documented internal control in place over payroll claims to ensure that payroll charged to the grant was reviewed and approved by an individual knowledgeable about the cost principles. In addition, pay rates could not be tied directly to the salary ordinance for 4 of the 40 payroll payments tested. Timecards were provided which substantiated the hours worked; however, the hourly rate at which the employees were paid could not be tied to the salary ordinance or other internal records provided. The hourly rates paid to these four employees did not differ significantly from the rates documented in the salary ordinances. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 22 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 7 CFR 220.7(e) states in part: ". . . the School Food Authority shall, with respect to participating schools under its jurisdiction: . . . (1) (i) Maintain a nonprofit school food service; (ii) . . . use all revenues received by such food service only for the operation or improvement of that food service . . ." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 23 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, payroll disbursements identified above could not be tied to an approved salary. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would ensure that employees charged to the grant are paid the approved rate of pay. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context A cash reimbursement is provided to the School Corporation based on meals served under the School Breakfast Program, National School Lunch Program, and Summer Food Service Program for Children. The cash reimbursement is to be used for the benefit of the food service program. The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. There was no documented internal control in place over payroll claims to ensure that payroll charged to the grant was reviewed and approved by an individual knowledgeable about the cost principles. In addition, pay rates could not be tied directly to the salary ordinance for 4 of the 40 payroll payments tested. Timecards were provided which substantiated the hours worked; however, the hourly rate at which the employees were paid could not be tied to the salary ordinance or other internal records provided. The hourly rates paid to these four employees did not differ significantly from the rates documented in the salary ordinances. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 22 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 7 CFR 220.7(e) states in part: ". . . the School Food Authority shall, with respect to participating schools under its jurisdiction: . . . (1) (i) Maintain a nonprofit school food service; (ii) . . . use all revenues received by such food service only for the operation or improvement of that food service . . ." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 23 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, payroll disbursements identified above could not be tied to an approved salary. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would ensure that employees charged to the grant are paid the approved rate of pay. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context A cash reimbursement is provided to the School Corporation based on meals served under the School Breakfast Program, National School Lunch Program, and Summer Food Service Program for Children. The cash reimbursement is to be used for the benefit of the food service program. The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. There was no documented internal control in place over payroll claims to ensure that payroll charged to the grant was reviewed and approved by an individual knowledgeable about the cost principles. In addition, pay rates could not be tied directly to the salary ordinance for 4 of the 40 payroll payments tested. Timecards were provided which substantiated the hours worked; however, the hourly rate at which the employees were paid could not be tied to the salary ordinance or other internal records provided. The hourly rates paid to these four employees did not differ significantly from the rates documented in the salary ordinances. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 22 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 7 CFR 220.7(e) states in part: ". . . the School Food Authority shall, with respect to participating schools under its jurisdiction: . . . (1) (i) Maintain a nonprofit school food service; (ii) . . . use all revenues received by such food service only for the operation or improvement of that food service . . ." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 23 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, payroll disbursements identified above could not be tied to an approved salary. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would ensure that employees charged to the grant are paid the approved rate of pay. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context A cash reimbursement is provided to the School Corporation based on meals served under the School Breakfast Program, National School Lunch Program, and Summer Food Service Program for Children. The cash reimbursement is to be used for the benefit of the food service program. The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. There was no documented internal control in place over payroll claims to ensure that payroll charged to the grant was reviewed and approved by an individual knowledgeable about the cost principles. In addition, pay rates could not be tied directly to the salary ordinance for 4 of the 40 payroll payments tested. Timecards were provided which substantiated the hours worked; however, the hourly rate at which the employees were paid could not be tied to the salary ordinance or other internal records provided. The hourly rates paid to these four employees did not differ significantly from the rates documented in the salary ordinances. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 22 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 7 CFR 220.7(e) states in part: ". . . the School Food Authority shall, with respect to participating schools under its jurisdiction: . . . (1) (i) Maintain a nonprofit school food service; (ii) . . . use all revenues received by such food service only for the operation or improvement of that food service . . ." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 23 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, payroll disbursements identified above could not be tied to an approved salary. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would ensure that employees charged to the grant are paid the approved rate of pay. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Condition and Context A cash reimbursement is provided to the School Corporation based on meals served under the School Breakfast Program, National School Lunch Program, and Summer Food Service Program for Children. The cash reimbursement is to be used for the benefit of the food service program. The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. There was no documented internal control in place over payroll claims to ensure that payroll charged to the grant was reviewed and approved by an individual knowledgeable about the cost principles. In addition, pay rates could not be tied directly to the salary ordinance for 4 of the 40 payroll payments tested. Timecards were provided which substantiated the hours worked; however, the hourly rate at which the employees were paid could not be tied to the salary ordinance or other internal records provided. The hourly rates paid to these four employees did not differ significantly from the rates documented in the salary ordinances. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 22 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 7 CFR 220.7(e) states in part: ". . . the School Food Authority shall, with respect to participating schools under its jurisdiction: . . . (1) (i) Maintain a nonprofit school food service; (ii) . . . use all revenues received by such food service only for the operation or improvement of that food service . . ." 7 CFR 225.15(a)(1) states: "Sponsors shall operate the food service in accordance with: the provisions of this part; any instructions and handbooks issued by FNS under this part; and any instructions and handbooks issued by the State agency which are not inconsistent with the provisions of this part." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 23 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, payroll disbursements identified above could not be tied to an approved salary. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would ensure that employees charged to the grant are paid the approved rate of pay. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility, Reporting, Special Tests and Provisions - Non-Profit School Food Service Accounts Audit Finding: Material Weakness Condition and Context The School Corporation had not established effective internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 24 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Eligibility The Data Collection Specialist entered direct certifications into the School Corporation's software system. A student that was direct certified was coded in the software system as an import. The Food Service Director then viewed the direct certification listing monthly. However, there was no evidence that the Food Service Director's review took place, nor was there a review or oversight process in place to ensure that direct certifications were properly uploaded into the system or that that the software system accurately recording the direct certification students. Reporting During the 2021-2022 school year, the School Corporation operated under the Seamless Summer Option (SSO), which allowed all students to receive free meals. Therefore, the cafeteria cashiers at each school manually recorded meals served on the meal count forms provided and prescribed by the Indiana Department of Education. The Food Service Director used the meal count forms to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. During the 2022-2023 school year, the School Corporation did not operate under SSO and thus resumed the use of their software, Café Enterprise. Café Enterprise, generated meal count reports by type (i.e., free, reduced, paid, etc.) at each school. The Food Service Director used the meal count reports to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. Special Tests and Provisions - Non-Profit School Food Service Accounts A receipt was prepared and recorded in the school food service account when reimbursement was received for meals served. On a monthly basis, the Deputy Treasurer generated a Fund Report and Revenue History Report and provided it to the Food Service Director. The Food Service Director prepared and utilized a monthly spreadsheet to reconcile the Food Service accounts to the corporation account. While appropriate financial records were prepared and exchanged, there was no documented oversight, review, or approval process in place to ensure the separate accounting took place, that reimbursements were correctly credited to the school food sever account and that transfers out of the food service account were for allowable costs of the food service. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 25 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility, Reporting, Special Tests and Provisions - Non-Profit School Food Service Accounts Audit Finding: Material Weakness Condition and Context The School Corporation had not established effective internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 24 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Eligibility The Data Collection Specialist entered direct certifications into the School Corporation's software system. A student that was direct certified was coded in the software system as an import. The Food Service Director then viewed the direct certification listing monthly. However, there was no evidence that the Food Service Director's review took place, nor was there a review or oversight process in place to ensure that direct certifications were properly uploaded into the system or that that the software system accurately recording the direct certification students. Reporting During the 2021-2022 school year, the School Corporation operated under the Seamless Summer Option (SSO), which allowed all students to receive free meals. Therefore, the cafeteria cashiers at each school manually recorded meals served on the meal count forms provided and prescribed by the Indiana Department of Education. The Food Service Director used the meal count forms to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. During the 2022-2023 school year, the School Corporation did not operate under SSO and thus resumed the use of their software, Café Enterprise. Café Enterprise, generated meal count reports by type (i.e., free, reduced, paid, etc.) at each school. The Food Service Director used the meal count reports to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. Special Tests and Provisions - Non-Profit School Food Service Accounts A receipt was prepared and recorded in the school food service account when reimbursement was received for meals served. On a monthly basis, the Deputy Treasurer generated a Fund Report and Revenue History Report and provided it to the Food Service Director. The Food Service Director prepared and utilized a monthly spreadsheet to reconcile the Food Service accounts to the corporation account. While appropriate financial records were prepared and exchanged, there was no documented oversight, review, or approval process in place to ensure the separate accounting took place, that reimbursements were correctly credited to the school food sever account and that transfers out of the food service account were for allowable costs of the food service. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 25 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility, Reporting, Special Tests and Provisions - Non-Profit School Food Service Accounts Audit Finding: Material Weakness Condition and Context The School Corporation had not established effective internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 24 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Eligibility The Data Collection Specialist entered direct certifications into the School Corporation's software system. A student that was direct certified was coded in the software system as an import. The Food Service Director then viewed the direct certification listing monthly. However, there was no evidence that the Food Service Director's review took place, nor was there a review or oversight process in place to ensure that direct certifications were properly uploaded into the system or that that the software system accurately recording the direct certification students. Reporting During the 2021-2022 school year, the School Corporation operated under the Seamless Summer Option (SSO), which allowed all students to receive free meals. Therefore, the cafeteria cashiers at each school manually recorded meals served on the meal count forms provided and prescribed by the Indiana Department of Education. The Food Service Director used the meal count forms to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. During the 2022-2023 school year, the School Corporation did not operate under SSO and thus resumed the use of their software, Café Enterprise. Café Enterprise, generated meal count reports by type (i.e., free, reduced, paid, etc.) at each school. The Food Service Director used the meal count reports to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. Special Tests and Provisions - Non-Profit School Food Service Accounts A receipt was prepared and recorded in the school food service account when reimbursement was received for meals served. On a monthly basis, the Deputy Treasurer generated a Fund Report and Revenue History Report and provided it to the Food Service Director. The Food Service Director prepared and utilized a monthly spreadsheet to reconcile the Food Service accounts to the corporation account. While appropriate financial records were prepared and exchanged, there was no documented oversight, review, or approval process in place to ensure the separate accounting took place, that reimbursements were correctly credited to the school food sever account and that transfers out of the food service account were for allowable costs of the food service. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 25 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility, Reporting, Special Tests and Provisions - Non-Profit School Food Service Accounts Audit Finding: Material Weakness Condition and Context The School Corporation had not established effective internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 24 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Eligibility The Data Collection Specialist entered direct certifications into the School Corporation's software system. A student that was direct certified was coded in the software system as an import. The Food Service Director then viewed the direct certification listing monthly. However, there was no evidence that the Food Service Director's review took place, nor was there a review or oversight process in place to ensure that direct certifications were properly uploaded into the system or that that the software system accurately recording the direct certification students. Reporting During the 2021-2022 school year, the School Corporation operated under the Seamless Summer Option (SSO), which allowed all students to receive free meals. Therefore, the cafeteria cashiers at each school manually recorded meals served on the meal count forms provided and prescribed by the Indiana Department of Education. The Food Service Director used the meal count forms to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. During the 2022-2023 school year, the School Corporation did not operate under SSO and thus resumed the use of their software, Café Enterprise. Café Enterprise, generated meal count reports by type (i.e., free, reduced, paid, etc.) at each school. The Food Service Director used the meal count reports to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. Special Tests and Provisions - Non-Profit School Food Service Accounts A receipt was prepared and recorded in the school food service account when reimbursement was received for meals served. On a monthly basis, the Deputy Treasurer generated a Fund Report and Revenue History Report and provided it to the Food Service Director. The Food Service Director prepared and utilized a monthly spreadsheet to reconcile the Food Service accounts to the corporation account. While appropriate financial records were prepared and exchanged, there was no documented oversight, review, or approval process in place to ensure the separate accounting took place, that reimbursements were correctly credited to the school food sever account and that transfers out of the food service account were for allowable costs of the food service. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 25 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility, Reporting, Special Tests and Provisions - Non-Profit School Food Service Accounts Audit Finding: Material Weakness Condition and Context The School Corporation had not established effective internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 24 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Eligibility The Data Collection Specialist entered direct certifications into the School Corporation's software system. A student that was direct certified was coded in the software system as an import. The Food Service Director then viewed the direct certification listing monthly. However, there was no evidence that the Food Service Director's review took place, nor was there a review or oversight process in place to ensure that direct certifications were properly uploaded into the system or that that the software system accurately recording the direct certification students. Reporting During the 2021-2022 school year, the School Corporation operated under the Seamless Summer Option (SSO), which allowed all students to receive free meals. Therefore, the cafeteria cashiers at each school manually recorded meals served on the meal count forms provided and prescribed by the Indiana Department of Education. The Food Service Director used the meal count forms to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. During the 2022-2023 school year, the School Corporation did not operate under SSO and thus resumed the use of their software, Café Enterprise. Café Enterprise, generated meal count reports by type (i.e., free, reduced, paid, etc.) at each school. The Food Service Director used the meal count reports to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. Special Tests and Provisions - Non-Profit School Food Service Accounts A receipt was prepared and recorded in the school food service account when reimbursement was received for meals served. On a monthly basis, the Deputy Treasurer generated a Fund Report and Revenue History Report and provided it to the Food Service Director. The Food Service Director prepared and utilized a monthly spreadsheet to reconcile the Food Service accounts to the corporation account. While appropriate financial records were prepared and exchanged, there was no documented oversight, review, or approval process in place to ensure the separate accounting took place, that reimbursements were correctly credited to the school food sever account and that transfers out of the food service account were for allowable costs of the food service. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 25 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-005 Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility, Reporting, Special Tests and Provisions - Non-Profit School Food Service Accounts Audit Finding: Material Weakness Condition and Context The School Corporation had not established effective internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. INDIANA STATE BOARD OF ACCOUNTS 24 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Eligibility The Data Collection Specialist entered direct certifications into the School Corporation's software system. A student that was direct certified was coded in the software system as an import. The Food Service Director then viewed the direct certification listing monthly. However, there was no evidence that the Food Service Director's review took place, nor was there a review or oversight process in place to ensure that direct certifications were properly uploaded into the system or that that the software system accurately recording the direct certification students. Reporting During the 2021-2022 school year, the School Corporation operated under the Seamless Summer Option (SSO), which allowed all students to receive free meals. Therefore, the cafeteria cashiers at each school manually recorded meals served on the meal count forms provided and prescribed by the Indiana Department of Education. The Food Service Director used the meal count forms to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. During the 2022-2023 school year, the School Corporation did not operate under SSO and thus resumed the use of their software, Café Enterprise. Café Enterprise, generated meal count reports by type (i.e., free, reduced, paid, etc.) at each school. The Food Service Director used the meal count reports to compile and submit the monthly claim for reimbursement without an oversight or review process in place to detect and correct errors. Special Tests and Provisions - Non-Profit School Food Service Accounts A receipt was prepared and recorded in the school food service account when reimbursement was received for meals served. On a monthly basis, the Deputy Treasurer generated a Fund Report and Revenue History Report and provided it to the Food Service Director. The Food Service Director prepared and utilized a monthly spreadsheet to reconcile the Food Service accounts to the corporation account. While appropriate financial records were prepared and exchanged, there was no documented oversight, review, or approval process in place to ensure the separate accounting took place, that reimbursements were correctly credited to the school food sever account and that transfers out of the food service account were for allowable costs of the food service. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 25 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure expenditures charged to the food service program fund (fund 800) are in adherence with the federal and state procurement regulations and requirements. In addition, an effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure covered transactions paid with child nutrition award funds are neither suspended or debarred or otherwise excluded from participating in federal awards. INDIANA STATE BOARD OF ACCOUNTS 26 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Procurement - Internal Control over Small Purchases The School Corporation had not designed or implemented adequate policies or procedures to ensure that proper procurement procedures for small purchases were adhered to. There was no documented oversight, review, or approval process in place at the School Corporation to ensure proper procedures were followed and price or rate quotations were obtained, or documentation to support limited procurement procedures were conducted and maintained for small purchases. Suspension and Debarment Prior to entering into subawards and covered transactions with federal award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusions, collecting a certification from that vendor, or adding a clause or condition to the covered transaction with that vendor. Upon inquiry of the School Corporation in order to review the procedures in place for verifying that a vendor with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the School Corporation disclosed procedures had not been performed to ensure vendors were not suspended or debarred prior to entering into covered transaction. One covered transaction that equaled or exceeded $25,000 was identified. The one transaction, totaling $40,325, was selected for testing. For the one covered transaction, the School Corporation had not performed procedures to ensure the vendor was not suspended or debarred, or otherwise excluded or disqualified from participating in federal assistance programs or activities for suspension or debarment. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to fiscal year 2021-2022. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: INDIANA STATE BOARD OF ACCOUNTS 27 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, vendors to whom payments equal to or in excess of $25,000 were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions or the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place and that contractors are not suspended, debarred, or otherwise excluded prior to entering into any covered transactions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure expenditures charged to the food service program fund (fund 800) are in adherence with the federal and state procurement regulations and requirements. In addition, an effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure covered transactions paid with child nutrition award funds are neither suspended or debarred or otherwise excluded from participating in federal awards. INDIANA STATE BOARD OF ACCOUNTS 26 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Procurement - Internal Control over Small Purchases The School Corporation had not designed or implemented adequate policies or procedures to ensure that proper procurement procedures for small purchases were adhered to. There was no documented oversight, review, or approval process in place at the School Corporation to ensure proper procedures were followed and price or rate quotations were obtained, or documentation to support limited procurement procedures were conducted and maintained for small purchases. Suspension and Debarment Prior to entering into subawards and covered transactions with federal award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusions, collecting a certification from that vendor, or adding a clause or condition to the covered transaction with that vendor. Upon inquiry of the School Corporation in order to review the procedures in place for verifying that a vendor with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the School Corporation disclosed procedures had not been performed to ensure vendors were not suspended or debarred prior to entering into covered transaction. One covered transaction that equaled or exceeded $25,000 was identified. The one transaction, totaling $40,325, was selected for testing. For the one covered transaction, the School Corporation had not performed procedures to ensure the vendor was not suspended or debarred, or otherwise excluded or disqualified from participating in federal assistance programs or activities for suspension or debarment. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to fiscal year 2021-2022. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: INDIANA STATE BOARD OF ACCOUNTS 27 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, vendors to whom payments equal to or in excess of $25,000 were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions or the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place and that contractors are not suspended, debarred, or otherwise excluded prior to entering into any covered transactions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure expenditures charged to the food service program fund (fund 800) are in adherence with the federal and state procurement regulations and requirements. In addition, an effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure covered transactions paid with child nutrition award funds are neither suspended or debarred or otherwise excluded from participating in federal awards. INDIANA STATE BOARD OF ACCOUNTS 26 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Procurement - Internal Control over Small Purchases The School Corporation had not designed or implemented adequate policies or procedures to ensure that proper procurement procedures for small purchases were adhered to. There was no documented oversight, review, or approval process in place at the School Corporation to ensure proper procedures were followed and price or rate quotations were obtained, or documentation to support limited procurement procedures were conducted and maintained for small purchases. Suspension and Debarment Prior to entering into subawards and covered transactions with federal award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusions, collecting a certification from that vendor, or adding a clause or condition to the covered transaction with that vendor. Upon inquiry of the School Corporation in order to review the procedures in place for verifying that a vendor with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the School Corporation disclosed procedures had not been performed to ensure vendors were not suspended or debarred prior to entering into covered transaction. One covered transaction that equaled or exceeded $25,000 was identified. The one transaction, totaling $40,325, was selected for testing. For the one covered transaction, the School Corporation had not performed procedures to ensure the vendor was not suspended or debarred, or otherwise excluded or disqualified from participating in federal assistance programs or activities for suspension or debarment. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to fiscal year 2021-2022. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: INDIANA STATE BOARD OF ACCOUNTS 27 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, vendors to whom payments equal to or in excess of $25,000 were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions or the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place and that contractors are not suspended, debarred, or otherwise excluded prior to entering into any covered transactions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure expenditures charged to the food service program fund (fund 800) are in adherence with the federal and state procurement regulations and requirements. In addition, an effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure covered transactions paid with child nutrition award funds are neither suspended or debarred or otherwise excluded from participating in federal awards. INDIANA STATE BOARD OF ACCOUNTS 26 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Procurement - Internal Control over Small Purchases The School Corporation had not designed or implemented adequate policies or procedures to ensure that proper procurement procedures for small purchases were adhered to. There was no documented oversight, review, or approval process in place at the School Corporation to ensure proper procedures were followed and price or rate quotations were obtained, or documentation to support limited procurement procedures were conducted and maintained for small purchases. Suspension and Debarment Prior to entering into subawards and covered transactions with federal award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusions, collecting a certification from that vendor, or adding a clause or condition to the covered transaction with that vendor. Upon inquiry of the School Corporation in order to review the procedures in place for verifying that a vendor with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the School Corporation disclosed procedures had not been performed to ensure vendors were not suspended or debarred prior to entering into covered transaction. One covered transaction that equaled or exceeded $25,000 was identified. The one transaction, totaling $40,325, was selected for testing. For the one covered transaction, the School Corporation had not performed procedures to ensure the vendor was not suspended or debarred, or otherwise excluded or disqualified from participating in federal assistance programs or activities for suspension or debarment. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to fiscal year 2021-2022. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: INDIANA STATE BOARD OF ACCOUNTS 27 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, vendors to whom payments equal to or in excess of $25,000 were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions or the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place and that contractors are not suspended, debarred, or otherwise excluded prior to entering into any covered transactions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure expenditures charged to the food service program fund (fund 800) are in adherence with the federal and state procurement regulations and requirements. In addition, an effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure covered transactions paid with child nutrition award funds are neither suspended or debarred or otherwise excluded from participating in federal awards. INDIANA STATE BOARD OF ACCOUNTS 26 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Procurement - Internal Control over Small Purchases The School Corporation had not designed or implemented adequate policies or procedures to ensure that proper procurement procedures for small purchases were adhered to. There was no documented oversight, review, or approval process in place at the School Corporation to ensure proper procedures were followed and price or rate quotations were obtained, or documentation to support limited procurement procedures were conducted and maintained for small purchases. Suspension and Debarment Prior to entering into subawards and covered transactions with federal award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusions, collecting a certification from that vendor, or adding a clause or condition to the covered transaction with that vendor. Upon inquiry of the School Corporation in order to review the procedures in place for verifying that a vendor with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the School Corporation disclosed procedures had not been performed to ensure vendors were not suspended or debarred prior to entering into covered transaction. One covered transaction that equaled or exceeded $25,000 was identified. The one transaction, totaling $40,325, was selected for testing. For the one covered transaction, the School Corporation had not performed procedures to ensure the vendor was not suspended or debarred, or otherwise excluded or disqualified from participating in federal assistance programs or activities for suspension or debarment. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to fiscal year 2021-2022. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: INDIANA STATE BOARD OF ACCOUNTS 27 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, vendors to whom payments equal to or in excess of $25,000 were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions or the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place and that contractors are not suspended, debarred, or otherwise excluded prior to entering into any covered transactions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-006 Subject: Child Nutrition Cluster - Procurement and Suspension and Debarment Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2021-2022, 2022-2023 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure expenditures charged to the food service program fund (fund 800) are in adherence with the federal and state procurement regulations and requirements. In addition, an effective system of internal controls, which would include segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance should be designed and implemented to ensure covered transactions paid with child nutrition award funds are neither suspended or debarred or otherwise excluded from participating in federal awards. INDIANA STATE BOARD OF ACCOUNTS 26 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Procurement - Internal Control over Small Purchases The School Corporation had not designed or implemented adequate policies or procedures to ensure that proper procurement procedures for small purchases were adhered to. There was no documented oversight, review, or approval process in place at the School Corporation to ensure proper procedures were followed and price or rate quotations were obtained, or documentation to support limited procurement procedures were conducted and maintained for small purchases. Suspension and Debarment Prior to entering into subawards and covered transactions with federal award funds, recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the SAMs exclusions, collecting a certification from that vendor, or adding a clause or condition to the covered transaction with that vendor. Upon inquiry of the School Corporation in order to review the procedures in place for verifying that a vendor with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the School Corporation disclosed procedures had not been performed to ensure vendors were not suspended or debarred prior to entering into covered transaction. One covered transaction that equaled or exceeded $25,000 was identified. The one transaction, totaling $40,325, was selected for testing. For the one covered transaction, the School Corporation had not performed procedures to ensure the vendor was not suspended or debarred, or otherwise excluded or disqualified from participating in federal assistance programs or activities for suspension or debarment. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to fiscal year 2021-2022. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: INDIANA STATE BOARD OF ACCOUNTS 27 COMMUNITY SCHOOLS OF FRANKFORT SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, vendors to whom payments equal to or in excess of $25,000 were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions or the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place and that contractors are not suspended, debarred, or otherwise excluded prior to entering into any covered transactions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.