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.