FINDING 2023-003
Subject: Special Education Cluster (IDEA) - Procurement
Federal Agency: Department of Education
Federal Program: Special Education Grants to States
Assistance Listings Number: 84.027
Federal Award Number and Year (or Other Identifying Number): H027A190084
Pass-Through Entity: Indiana Department of Education
Compliance Requirement: Procurement and Suspension and Debarment
Audit Findings: Material Weakness, Modified Opinion
Condition and Context
Federal regulations allow for informal procurement methods when the value of the procurement for
property or services does not exceed the simplified acquisition threshold, which is set at $250,000 unless
a lower, more restrictive threshold is set by a non-Federal entity. As Indiana Code has set a more restrictive
threshold of $150,000, informal procurement methods are permitted when the value of the procurement
does not exceed $150,000. This informal process allows for methods other than the formal bid process.
The informal process is divided between two methods based on thresholds. Micro-purchases, typically for
those purchases $10,000 or under, and small purchase procedures for those purchases above the micropurchase
threshold, but below the simplified acquisition threshold. Micro-purchases may be awarded
without soliciting competitive price rate quotations. If small purchase procedures are used, then price or
rate quotations must be obtained from an adequate number of qualified sources.
There were 27 vendors exceeding the small purchase threshold during the audit period. Of those,
5 vendors were selected for testing. For all 5 vendors tested, totaling $299,889, the School Corporation
did not obtain price or rate quotes. Documentation detailing the history of procurement, which must include
the reason for the procurement method used, selection of the vendor, and the basis for the price, was not
available for audit.
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
24
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
2 CFR 200.318 states in part:
"(a) The non-Federal entity must have and use documented procurement procedures,
consistent with State, local, and tribal laws and regulations and the standards of this section,
for the acquisition of property or services required under a Federal award or subaward. The
non-Federal entity's documented procurement procedures must conform to the procurement
standards identified in §§ 200.317 through 200.327. . . .
(i) The non-Federal entity must maintain records sufficient to detail the history of procurement.
These records will include, but are not necessarily limited to, the following: Rationale for the
method of procurement, selection of contract type, contractor selection or rejection, and the
basis for the contract price. . . ."
2 CFR 200.320 states in part:
"The non-Federal entity must have and use documented procurement procedures, consistent
with the standards of this section and §§ 200.317, 200.318, and 200.319 for any of the following
methods of procurement used for the acquisition of property or services required under a
Federal award or sub-award.
(a) Informal procurement methods. When the value of the procurement for property or
services under a Federal award does not exceed the simplified acquisition threshold (SAT),
as defined in § 200.1, or a lower threshold established by a non-Federal entity, formal
procurement methods are not required. The non-Federal entity may use informal
procurement methods to expedite the completion of its transactions and minimize the
associated administrative burden and cost. The informal methods used for procurement
of property or services at or below the SAT include: . . .
(2) Small purchases —
(i) Small purchase procedures. The acquisition of property or services, the
aggregate dollar amount of which is higher than the micro-purchase threshold but
does not exceed the simplified acquisition threshold. If small purchase procedures
are used, price or rate quotations must be obtained from an adequate number of
qualified sources as determined appropriate by the non-Federal entity. . . ."
Cause
A proper system of internal controls was not designed by management of the School Corporation.
Embedded within a properly designed and implemented internal control system should be internal controls
consisting of policies and procedures. Policies reflect the School Corporation's management statements
of what should be done to effect internal controls, and procedures should consist of actions that would
implement these policies.
Effect
Without the proper implementation of an effectively designed system of internal controls, the
internal control system cannot be capable of effectively preventing, or detecting and correcting, material
noncompliance. As a result, procurement procedures for goods and services were not adhered to for
vendors that fell within the small purchase threshold.
INDIANA STATE BOARD OF ACCOUNTS
25
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
Noncompliance with the grant agreement and the compliance requirement could result in the loss
of future federal funds to the School Corporation.
Questioned Costs
There were no questioned costs identified.
Recommendation
We recommended that management of the School Corporation establish a proper system of
internal controls and develop policies and procedures to ensure there are adequate and appropriate
procurement procedures for goods and services.
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: Twenty-First Century Community Learning Centers - Cash
Management, Program Income and Reporting
Federal Agency: Department of Education
Federal Program: Twenty-First Century Community Learning Centers
Assistance Listings Number: 84.287
Federal Award Numbers and Years (or Other Identifying Numbers): A58-1-21DL-0153,
A58-1-21DL-5176,
A58-2-22DL-0018,
A58-3-23DL-0027
Pass-Through Entity: Indiana Department of Education
Compliance Requirements: Cash Management, Program Income, and Reporting
Audit Findings: Material Weakness, Modified Opinion
Condition and Context
The School Corporation utilized grant funds to operate an After School Care Safe Harbor Program.
As part of the programs, the students were charged monthly fees to help cover the related costs. Per the
grant guidelines, families cannot be turned away for nonpayment of fees, and any fees collected are to be
reinvested into the programs. Reimbursement requests are to deduct the program income received from
allowable costs prior to claiming reimbursement.
During the audit period, the School Corporation collected fees for the Before School Care Program
and the After School Care Safe Harbor Program in the same manner. Fees collected for both programs
were collected and receipted into the After School fund. For the years ended June 30, 2022, and June 30,
2023, the School Corporation receipted a total of $45,723 and $41,513, respectively, into the After School
fund.
Cash Management
The School Corporation submitted 18 reimbursement requests in the audit period. Costs were
paid prior to requesting reimbursement as required; however, due to the lack of adequate
program income records the reimbursements were not reduced by the program income
received.
INDIANA STATE BOARD OF ACCOUNTS
26
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
Program Income
Although the School Corporation received approval from the grantor agency to collect program
income, the School Corporation did not properly track students' attendance and payments, both
if paid and how much paid; therefore, we were unable to determine the amount of program
income related to each program. Additionally, the School Corporation did not maintain program
income in a separate fund but comingled it with other nongrant funded program revenues.
Finally, the School Corporation did not deduct program income from allowable costs prior to
claiming reimbursement.
Reporting
Reimbursement Requests
The School Corporation submitted 18 reimbursement requests in the audit period. Of
those, 3 reimbursement requests were selected for testing. Of the 3 reimbursement
requests inspected, none were reduced by program income received, and 1 was not
properly supported by School Corporation records. The reimbursement was overstated by
$14,700 when compared to the ledger. Based on additional procedures performed, the
total requested reimbursements for the audit period were understated by $32,605 when
compared to the ledger.
Year End Reports
End of Year reports are to be submitted within 60 days of the contract end date. A total of
four End of Year Reports were submitted in the audit period and two were selected for
testing. Of the two End of Year reports selected for testing, neither properly included
program income received during the year due to inadequate tracking of program income.
The lack of 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.305(b)(5) states in part: "To the extent available, the non-Federal entity must disburse
funds available from program income (including repayments to a revolving fund), rebates, refunds, contract
settlements, audit recoveries, and interest earned on such funds before requesting additional cash
payments."
INDIANA STATE BOARD OF ACCOUNTS
27
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
2 CFR 200.307 states in part:
"(a) General. Non-Federal entities are encouraged to earn income to defray program costs
where appropriate. . . .
(e) Use of program income. If the Federal awarding agency does not specify in its regulations
or the terms and conditions of the Federal award, or give prior approval for how program
income is to be used, paragraph (e)(1) of this section must apply. For Federal awards made
to IHEs and nonprofit research institutions, if the Federal awarding agency does not specify in
its regulations or the terms and conditions of the Federal award how program income is to be
used, paragraph (e)(2) of this section must apply. In specifying alternatives to paragraphs
(e)(1) and (2) of this section, the Federal awarding agency may distinguish between income
earned by the recipient and income earned by subrecipients and between the sources, kinds,
or amounts of income. When the Federal awarding agency authorizes the approaches in
paragraphs (e)(2) and (3) of this section, program income in excess of any amounts specified
must also be deducted from expenditures.
(1) Deduction. Ordinarily program income must be deducted from total allowable costs to
determine the net allowable costs. Program income must be used for current costs
unless the Federal awarding agency authorizes otherwise. Program income that the
non- Federal entity did not anticipate at the time of the Federal award must be used to
reduce the Federal award and non- Federal entity contributions rather than to increase
the funds committed to the project.
(2) Addition. With prior approval of the Federal awarding agency (except for IHEs and
nonprofit research institutions, as described in this paragraph (e)) program income may
be added to the Federal award by the Federal agency and the non-Federal entity. The
program income must be used for the purposes and under the conditions of the Federal
award.
(3) Cost sharing or matching. With prior approval of the Federal awarding agency,
program income may be used to meet the cost sharing or matching requirement of the
Federal award. The amount of the Federal award remains the same. . . ."
2 CFR 200.302(b) states in part:
"The financial management system of each non-Federal entity must provide for the following:
. . .
(2) Accurate, current, and complete disclosure of the financial results of each Federal
award or program in accordance with the reporting requirements set forth in §§ 200.328
and 200.329. . . ."
34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format
that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other
responsibilities under the program."
34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with
program requirements."
INDIANA STATE BOARD OF ACCOUNTS
28
MICHIGAN CITY AREA SCHOOLS
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 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, program income was not properly documented resulting in noncompliance
with the Cash Management, Program Income, and Reporting compliance requirements.
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 by 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 strengthen its policies and procedures to ensure proper tracking of program income
to ensure all activity and reports submitted on behalf of the Twenty-First Century Community Learning
Centers program funds are accurate.
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: Twenty-First Century Community Learning Centers - Cash
Management, Program Income and Reporting
Federal Agency: Department of Education
Federal Program: Twenty-First Century Community Learning Centers
Assistance Listings Number: 84.287
Federal Award Numbers and Years (or Other Identifying Numbers): A58-1-21DL-0153,
A58-1-21DL-5176,
A58-2-22DL-0018,
A58-3-23DL-0027
Pass-Through Entity: Indiana Department of Education
Compliance Requirements: Cash Management, Program Income, and Reporting
Audit Findings: Material Weakness, Modified Opinion
Condition and Context
The School Corporation utilized grant funds to operate an After School Care Safe Harbor Program.
As part of the programs, the students were charged monthly fees to help cover the related costs. Per the
grant guidelines, families cannot be turned away for nonpayment of fees, and any fees collected are to be
reinvested into the programs. Reimbursement requests are to deduct the program income received from
allowable costs prior to claiming reimbursement.
During the audit period, the School Corporation collected fees for the Before School Care Program
and the After School Care Safe Harbor Program in the same manner. Fees collected for both programs
were collected and receipted into the After School fund. For the years ended June 30, 2022, and June 30,
2023, the School Corporation receipted a total of $45,723 and $41,513, respectively, into the After School
fund.
Cash Management
The School Corporation submitted 18 reimbursement requests in the audit period. Costs were
paid prior to requesting reimbursement as required; however, due to the lack of adequate
program income records the reimbursements were not reduced by the program income
received.
INDIANA STATE BOARD OF ACCOUNTS
26
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
Program Income
Although the School Corporation received approval from the grantor agency to collect program
income, the School Corporation did not properly track students' attendance and payments, both
if paid and how much paid; therefore, we were unable to determine the amount of program
income related to each program. Additionally, the School Corporation did not maintain program
income in a separate fund but comingled it with other nongrant funded program revenues.
Finally, the School Corporation did not deduct program income from allowable costs prior to
claiming reimbursement.
Reporting
Reimbursement Requests
The School Corporation submitted 18 reimbursement requests in the audit period. Of
those, 3 reimbursement requests were selected for testing. Of the 3 reimbursement
requests inspected, none were reduced by program income received, and 1 was not
properly supported by School Corporation records. The reimbursement was overstated by
$14,700 when compared to the ledger. Based on additional procedures performed, the
total requested reimbursements for the audit period were understated by $32,605 when
compared to the ledger.
Year End Reports
End of Year reports are to be submitted within 60 days of the contract end date. A total of
four End of Year Reports were submitted in the audit period and two were selected for
testing. Of the two End of Year reports selected for testing, neither properly included
program income received during the year due to inadequate tracking of program income.
The lack of 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.305(b)(5) states in part: "To the extent available, the non-Federal entity must disburse
funds available from program income (including repayments to a revolving fund), rebates, refunds, contract
settlements, audit recoveries, and interest earned on such funds before requesting additional cash
payments."
INDIANA STATE BOARD OF ACCOUNTS
27
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
2 CFR 200.307 states in part:
"(a) General. Non-Federal entities are encouraged to earn income to defray program costs
where appropriate. . . .
(e) Use of program income. If the Federal awarding agency does not specify in its regulations
or the terms and conditions of the Federal award, or give prior approval for how program
income is to be used, paragraph (e)(1) of this section must apply. For Federal awards made
to IHEs and nonprofit research institutions, if the Federal awarding agency does not specify in
its regulations or the terms and conditions of the Federal award how program income is to be
used, paragraph (e)(2) of this section must apply. In specifying alternatives to paragraphs
(e)(1) and (2) of this section, the Federal awarding agency may distinguish between income
earned by the recipient and income earned by subrecipients and between the sources, kinds,
or amounts of income. When the Federal awarding agency authorizes the approaches in
paragraphs (e)(2) and (3) of this section, program income in excess of any amounts specified
must also be deducted from expenditures.
(1) Deduction. Ordinarily program income must be deducted from total allowable costs to
determine the net allowable costs. Program income must be used for current costs
unless the Federal awarding agency authorizes otherwise. Program income that the
non- Federal entity did not anticipate at the time of the Federal award must be used to
reduce the Federal award and non- Federal entity contributions rather than to increase
the funds committed to the project.
(2) Addition. With prior approval of the Federal awarding agency (except for IHEs and
nonprofit research institutions, as described in this paragraph (e)) program income may
be added to the Federal award by the Federal agency and the non-Federal entity. The
program income must be used for the purposes and under the conditions of the Federal
award.
(3) Cost sharing or matching. With prior approval of the Federal awarding agency,
program income may be used to meet the cost sharing or matching requirement of the
Federal award. The amount of the Federal award remains the same. . . ."
2 CFR 200.302(b) states in part:
"The financial management system of each non-Federal entity must provide for the following:
. . .
(2) Accurate, current, and complete disclosure of the financial results of each Federal
award or program in accordance with the reporting requirements set forth in §§ 200.328
and 200.329. . . ."
34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format
that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other
responsibilities under the program."
34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with
program requirements."
INDIANA STATE BOARD OF ACCOUNTS
28
MICHIGAN CITY AREA SCHOOLS
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 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, program income was not properly documented resulting in noncompliance
with the Cash Management, Program Income, and Reporting compliance requirements.
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 by 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 strengthen its policies and procedures to ensure proper tracking of program income
to ensure all activity and reports submitted on behalf of the Twenty-First Century Community Learning
Centers program funds are accurate.
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: COVID-19 - Education Stabilization Fund - Activities Allowed
or Unallowed, Allowable Costs/Cost Principles
Federal Agency: Department of Education
Federal Program: COVID-19 - Education Stabilization Fund
Assistance Listings Number: 84.425
Federal Award Number and Year (or Other Identifying Number): S425V200013
Pass-Through Entity: Indiana Department of Education
Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles
Audit Findings: Material Weakness, Modified Opinion
Condition and Context
On December 17, 2021, the School Corporation paid all School Corporation employees who had
been employed with the School Corporation during the 2020-2021 school year and for 120 days a School
Board approved retention bonus. The across-the-board stipends were paid without justification or
documentation that provided for additional duties or work performed on which to base the stipends. The
total amount of stipends paid, $822,750, were considered questioned costs.
INDIANA STATE BOARD OF ACCOUNTS
29
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
The lack of internal controls and noncompliance were isolated to the stipend payments noted
above.
Criteria
2 CFR 200.303 states in part:
"The non-Federal entity must:
(a) Establish and maintain effective internal control over the Federal award that provides
reasonable assurance that the non-Federal entity is managing the Federal award in
compliance with Federal statutes, regulations, and the terms and conditions of the Federal
award. These internal controls should be in compliance with guidance in 'Standards for
Internal Control in the Federal Government' issued by the Comptroller General of the
United States or the 'Internal Control Integrated Framework', issued by the Committee of
Sponsoring Organizations of the Treadway Commission (COSO). . . ."
2 CFR 200.403 states in part:
"Except where otherwise authorized by statute, costs must meet the following general criteria
in order to be allowable under Federal awards:
(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. . . ."
Indiana Department of Education's ESSER II Frequently Asked Questions (FAQs) states in part:
"12. Can ESSER II funds be used for staff stipends? . . .
While across the board stipends are not permitted (as "universal" or "across the board"
does not in and of itself demonstrate sufficient documentation), LEAs may pay staff for
COVID-related work that has been documented. Most, if not all, staff likely had extra
responsibilities as well as time and effort to respond to the pandemic. ESSER funds can be
used to pay staff for that work and LEAs are responsible for documenting (with internal controls)
that this work occurred. This is consistent with guidance on all salary and stipend
payments with all federal funds. . . ."
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.
INDIANA STATE BOARD OF ACCOUNTS
30
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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, costs were reimbursed that did not have adequate documentation to ensure
compliance with the compliance requirement.
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
Known questioned costs of $822,750 were identified as detailed in the Condition and Context.
Recommendation
We recommended that management of the School Corporation establish a proper system of
internal controls and develop policies and procedures to ensure costs are adequately documented.
Views of Responsible Officials
For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Auditor's Response
Per the Indiana Department of Education's ESSER II Frequently Asked Questions as stated above
in the listed "criteria," across the School Board stipends are not permitted and LEAs may pay staff for
COVID-related work that has been documented.
We reaffirm our finding and will review the status of the finding during our next audit.
FINDING 2023-005
Subject: COVID-19 - Education Stabilization Fund - Activities Allowed
or Unallowed, Allowable Costs/Cost Principles
Federal Agency: Department of Education
Federal Program: COVID-19 - Education Stabilization Fund
Assistance Listings Number: 84.425
Federal Award Number and Year (or Other Identifying Number): S425V200013
Pass-Through Entity: Indiana Department of Education
Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles
Audit Findings: Material Weakness, Modified Opinion
Condition and Context
On December 17, 2021, the School Corporation paid all School Corporation employees who had
been employed with the School Corporation during the 2020-2021 school year and for 120 days a School
Board approved retention bonus. The across-the-board stipends were paid without justification or
documentation that provided for additional duties or work performed on which to base the stipends. The
total amount of stipends paid, $822,750, were considered questioned costs.
INDIANA STATE BOARD OF ACCOUNTS
29
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
The lack of internal controls and noncompliance were isolated to the stipend payments noted
above.
Criteria
2 CFR 200.303 states in part:
"The non-Federal entity must:
(a) Establish and maintain effective internal control over the Federal award that provides
reasonable assurance that the non-Federal entity is managing the Federal award in
compliance with Federal statutes, regulations, and the terms and conditions of the Federal
award. These internal controls should be in compliance with guidance in 'Standards for
Internal Control in the Federal Government' issued by the Comptroller General of the
United States or the 'Internal Control Integrated Framework', issued by the Committee of
Sponsoring Organizations of the Treadway Commission (COSO). . . ."
2 CFR 200.403 states in part:
"Except where otherwise authorized by statute, costs must meet the following general criteria
in order to be allowable under Federal awards:
(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. . . ."
Indiana Department of Education's ESSER II Frequently Asked Questions (FAQs) states in part:
"12. Can ESSER II funds be used for staff stipends? . . .
While across the board stipends are not permitted (as "universal" or "across the board"
does not in and of itself demonstrate sufficient documentation), LEAs may pay staff for
COVID-related work that has been documented. Most, if not all, staff likely had extra
responsibilities as well as time and effort to respond to the pandemic. ESSER funds can be
used to pay staff for that work and LEAs are responsible for documenting (with internal controls)
that this work occurred. This is consistent with guidance on all salary and stipend
payments with all federal funds. . . ."
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.
INDIANA STATE BOARD OF ACCOUNTS
30
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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, costs were reimbursed that did not have adequate documentation to ensure
compliance with the compliance requirement.
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
Known questioned costs of $822,750 were identified as detailed in the Condition and Context.
Recommendation
We recommended that management of the School Corporation establish a proper system of
internal controls and develop policies and procedures to ensure costs are adequately documented.
Views of Responsible Officials
For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Auditor's Response
Per the Indiana Department of Education's ESSER II Frequently Asked Questions as stated above
in the listed "criteria," across the School Board stipends are not permitted and LEAs may pay staff for
COVID-related work that has been documented.
We reaffirm our finding and will review the status of the finding during our next audit.
FINDING 2023-006
Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management
Federal Agency: Department of Education
Federal Program: COVID-19 - Education Stabilization Fund
Assistance Listings Number: 84.425
Federal Award Number and Year (or Other Identifying Number): S425V200013
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 hired a consultant to compile and provide to them a fixed asset report that
contained all inventory and assets purchased that exceeded the School Corporation's capitalization
threshold through June 30, 2023. The consultant prepared the report; however, the School Corporation
did not have any policies or procedures in place to ensure the listing was complete, nor was there any
documentation that differences between the compiled asset report and the School Corporation's equipment
records were reviewed and resolved.
INDIANA STATE BOARD OF ACCOUNTS
31
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
Additionally, a property record or capital asset listing would include the following for each asset: 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.
During the audit period, the School Corporation completed an improvement project totaling
$1,738,356 with ESSER funds. This improvement project was not included on the asset listing or physical
inventory prepared by the consultant.
In addition, the School Corporation was unable to provide the capital asset deletions during the
audit period. Therefore, we could not determine if the disposition of any equipment or real property acquired
under federal awards were properly reflected in the property records.
The lack of internal controls and noncompliance were systemic issues throughout the audit period.
Criteria
2 CFR 200.303 states in part:
"The non-Federal entity must:
(a) Establish and maintain effective internal control over the Federal award that provides
reasonable assurance that the non-Federal entity is managing the Federal award in
compliance with Federal statutes, regulations, and the terms and conditions of the Federal
award. These internal controls should be in compliance with guidance in 'Standards for
Internal Control in the Federal Government' issued by the Comptroller General of the
United States or the 'Internal Control Integrated Framework', issued by the Committee of
Sponsoring Organizations of the Treadway Commission (COSO). . . ."
2 CFR 200.313(d) states in part:
". . . (1) Property records must be maintained that include a description of the property, a serial
number or other identification number, the source of funding for the property (including the
FAIN), who holds title, the acquisition date, 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."
2 CFR 200.313(e) states in part:
"When original or replacement equipment acquired under a Federal award is no longer needed
for the original project or program or for other activities currently or previously supported by a
Federal awarding agency, except as otherwise provided in Federal statutes, regulations, or
Federal awarding agency disposition instructions, the non-Federal entity must request
disposition instructions from the Federal awarding agency if required by the terms and
conditions of the Federal award. . . ."
INDIANA STATE BOARD OF ACCOUNTS
32
MICHIGAN CITY AREA SCHOOLS
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. As a result, assets purchased with federal dollars, ESSER funds, were not properly added
to the School Corporation's asset listing. In addition, assets on the listing did not denote whether federal
funds were used to acquire or dispose the asset, nor were any discrepancies in the records reconciled.
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,
new assets are properly added, and any discrepancies are reconciled.
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: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management
Federal Agency: Department of Education
Federal Program: COVID-19 - Education Stabilization Fund
Assistance Listings Number: 84.425
Federal Award Number and Year (or Other Identifying Number): S425V200013
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 hired a consultant to compile and provide to them a fixed asset report that
contained all inventory and assets purchased that exceeded the School Corporation's capitalization
threshold through June 30, 2023. The consultant prepared the report; however, the School Corporation
did not have any policies or procedures in place to ensure the listing was complete, nor was there any
documentation that differences between the compiled asset report and the School Corporation's equipment
records were reviewed and resolved.
INDIANA STATE BOARD OF ACCOUNTS
31
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
Additionally, a property record or capital asset listing would include the following for each asset: 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.
During the audit period, the School Corporation completed an improvement project totaling
$1,738,356 with ESSER funds. This improvement project was not included on the asset listing or physical
inventory prepared by the consultant.
In addition, the School Corporation was unable to provide the capital asset deletions during the
audit period. Therefore, we could not determine if the disposition of any equipment or real property acquired
under federal awards were properly reflected in the property records.
The lack of internal controls and noncompliance were systemic issues throughout the audit period.
Criteria
2 CFR 200.303 states in part:
"The non-Federal entity must:
(a) Establish and maintain effective internal control over the Federal award that provides
reasonable assurance that the non-Federal entity is managing the Federal award in
compliance with Federal statutes, regulations, and the terms and conditions of the Federal
award. These internal controls should be in compliance with guidance in 'Standards for
Internal Control in the Federal Government' issued by the Comptroller General of the
United States or the 'Internal Control Integrated Framework', issued by the Committee of
Sponsoring Organizations of the Treadway Commission (COSO). . . ."
2 CFR 200.313(d) states in part:
". . . (1) Property records must be maintained that include a description of the property, a serial
number or other identification number, the source of funding for the property (including the
FAIN), who holds title, the acquisition date, 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."
2 CFR 200.313(e) states in part:
"When original or replacement equipment acquired under a Federal award is no longer needed
for the original project or program or for other activities currently or previously supported by a
Federal awarding agency, except as otherwise provided in Federal statutes, regulations, or
Federal awarding agency disposition instructions, the non-Federal entity must request
disposition instructions from the Federal awarding agency if required by the terms and
conditions of the Federal award. . . ."
INDIANA STATE BOARD OF ACCOUNTS
32
MICHIGAN CITY AREA SCHOOLS
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. As a result, assets purchased with federal dollars, ESSER funds, were not properly added
to the School Corporation's asset listing. In addition, assets on the listing did not denote whether federal
funds were used to acquire or dispose the asset, nor were any discrepancies in the records reconciled.
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,
new assets are properly added, and any discrepancies are reconciled.
Views of Responsible Officials
For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-007
Subject: COVID-19 - Education Stabilization Fund - Reporting
Federal Agency: Department of Education
Federal Program: COVID-19 - Education Stabilization Fund
Assistance Listings Number: 84.425
Federal Award Numbers and Years (or Other Identifying Numbers): 5120S425U210013, S425U200013,
S425V200013
Pass-Through Entity: Indiana Department of Education
Compliance Requirement: Reporting
Audit Findings: Material Weakness, Other Matters
Condition and Context
The School Corporation had not properly designed or implemented a system of internal controls
that would likely be effective in preventing, or detecting and correcting, noncompliance. The School
Corporation was required to submit annual data reports 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.
INDIANA STATE BOARD OF ACCOUNTS
33
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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. Two of the six reports submitted during the
audit period were not supported by the School Corporation's records. The following errors were identified:
The ESSER II, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022,
reported $4,608,835 in total expenditures. However, the School Corporation's ledger for the
same period had total expenditures of $4,560,160.
The ESSER III, Year 2 report, which had covered the period of July 1, 2021 to June 30, 2022,
reported $118,103 in total expenditures. However, the School Corporation's ledger for the
same period had total expenditures of $317,536.
The lack of internal controls and noncompliance were isolated to these two reports.
Criteria
2 CFR 200.303 states in part:
"The non-Federal entity must:
(a) Establish and maintain effective internal control over the Federal award that provides
reasonable assurance that the non-Federal entity is managing the Federal award in
compliance with Federal statutes, regulations, and the terms and conditions of the Federal
award. These internal controls should be in compliance with guidance in 'Standards for
Internal Control in the Federal Government' issued by the Comptroller General of the
United States or the 'Internal Control Integrated Framework', issued by the Committee of
Sponsoring Organizations of the Treadway Commission (COSO). . . ."
2 CFR 200.302(b) states in part:
"The financial management system of each non-Federal entity must provide for the following
. . .
(2) Accurate, current, and complete disclosure of the financial results of each Federal
award or program in accordance with the reporting requirements set forth in §§ 200.328
and 200.329. . . ."
34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format
that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other
responsibilities under the program."
Cause
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.
INDIANA STATE BOARD OF ACCOUNTS
34
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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, ESSER reports were not supported by the School Corporation's records and
were not accurate and complete.
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 that all reports are submitted accurately.
Views of Responsible Officials
For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-007
Subject: COVID-19 - Education Stabilization Fund - Reporting
Federal Agency: Department of Education
Federal Program: COVID-19 - Education Stabilization Fund
Assistance Listings Number: 84.425
Federal Award Numbers and Years (or Other Identifying Numbers): 5120S425U210013, S425U200013,
S425V200013
Pass-Through Entity: Indiana Department of Education
Compliance Requirement: Reporting
Audit Findings: Material Weakness, Other Matters
Condition and Context
The School Corporation had not properly designed or implemented a system of internal controls
that would likely be effective in preventing, or detecting and correcting, noncompliance. The School
Corporation was required to submit annual data reports 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.
INDIANA STATE BOARD OF ACCOUNTS
33
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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. Two of the six reports submitted during the
audit period were not supported by the School Corporation's records. The following errors were identified:
The ESSER II, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022,
reported $4,608,835 in total expenditures. However, the School Corporation's ledger for the
same period had total expenditures of $4,560,160.
The ESSER III, Year 2 report, which had covered the period of July 1, 2021 to June 30, 2022,
reported $118,103 in total expenditures. However, the School Corporation's ledger for the
same period had total expenditures of $317,536.
The lack of internal controls and noncompliance were isolated to these two reports.
Criteria
2 CFR 200.303 states in part:
"The non-Federal entity must:
(a) Establish and maintain effective internal control over the Federal award that provides
reasonable assurance that the non-Federal entity is managing the Federal award in
compliance with Federal statutes, regulations, and the terms and conditions of the Federal
award. These internal controls should be in compliance with guidance in 'Standards for
Internal Control in the Federal Government' issued by the Comptroller General of the
United States or the 'Internal Control Integrated Framework', issued by the Committee of
Sponsoring Organizations of the Treadway Commission (COSO). . . ."
2 CFR 200.302(b) states in part:
"The financial management system of each non-Federal entity must provide for the following
. . .
(2) Accurate, current, and complete disclosure of the financial results of each Federal
award or program in accordance with the reporting requirements set forth in §§ 200.328
and 200.329. . . ."
34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format
that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other
responsibilities under the program."
Cause
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.
INDIANA STATE BOARD OF ACCOUNTS
34
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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, ESSER reports were not supported by the School Corporation's records and
were not accurate and complete.
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 that all reports are submitted accurately.
Views of Responsible Officials
For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-007
Subject: COVID-19 - Education Stabilization Fund - Reporting
Federal Agency: Department of Education
Federal Program: COVID-19 - Education Stabilization Fund
Assistance Listings Number: 84.425
Federal Award Numbers and Years (or Other Identifying Numbers): 5120S425U210013, S425U200013,
S425V200013
Pass-Through Entity: Indiana Department of Education
Compliance Requirement: Reporting
Audit Findings: Material Weakness, Other Matters
Condition and Context
The School Corporation had not properly designed or implemented a system of internal controls
that would likely be effective in preventing, or detecting and correcting, noncompliance. The School
Corporation was required to submit annual data reports 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.
INDIANA STATE BOARD OF ACCOUNTS
33
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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. Two of the six reports submitted during the
audit period were not supported by the School Corporation's records. The following errors were identified:
The ESSER II, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022,
reported $4,608,835 in total expenditures. However, the School Corporation's ledger for the
same period had total expenditures of $4,560,160.
The ESSER III, Year 2 report, which had covered the period of July 1, 2021 to June 30, 2022,
reported $118,103 in total expenditures. However, the School Corporation's ledger for the
same period had total expenditures of $317,536.
The lack of internal controls and noncompliance were isolated to these two reports.
Criteria
2 CFR 200.303 states in part:
"The non-Federal entity must:
(a) Establish and maintain effective internal control over the Federal award that provides
reasonable assurance that the non-Federal entity is managing the Federal award in
compliance with Federal statutes, regulations, and the terms and conditions of the Federal
award. These internal controls should be in compliance with guidance in 'Standards for
Internal Control in the Federal Government' issued by the Comptroller General of the
United States or the 'Internal Control Integrated Framework', issued by the Committee of
Sponsoring Organizations of the Treadway Commission (COSO). . . ."
2 CFR 200.302(b) states in part:
"The financial management system of each non-Federal entity must provide for the following
. . .
(2) Accurate, current, and complete disclosure of the financial results of each Federal
award or program in accordance with the reporting requirements set forth in §§ 200.328
and 200.329. . . ."
34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format
that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other
responsibilities under the program."
Cause
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.
INDIANA STATE BOARD OF ACCOUNTS
34
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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, ESSER reports were not supported by the School Corporation's records and
were not accurate and complete.
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 that all reports are submitted accurately.
Views of Responsible Officials
For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-007
Subject: COVID-19 - Education Stabilization Fund - Reporting
Federal Agency: Department of Education
Federal Program: COVID-19 - Education Stabilization Fund
Assistance Listings Number: 84.425
Federal Award Numbers and Years (or Other Identifying Numbers): 5120S425U210013, S425U200013,
S425V200013
Pass-Through Entity: Indiana Department of Education
Compliance Requirement: Reporting
Audit Findings: Material Weakness, Other Matters
Condition and Context
The School Corporation had not properly designed or implemented a system of internal controls
that would likely be effective in preventing, or detecting and correcting, noncompliance. The School
Corporation was required to submit annual data reports 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.
INDIANA STATE BOARD OF ACCOUNTS
33
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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. Two of the six reports submitted during the
audit period were not supported by the School Corporation's records. The following errors were identified:
The ESSER II, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022,
reported $4,608,835 in total expenditures. However, the School Corporation's ledger for the
same period had total expenditures of $4,560,160.
The ESSER III, Year 2 report, which had covered the period of July 1, 2021 to June 30, 2022,
reported $118,103 in total expenditures. However, the School Corporation's ledger for the
same period had total expenditures of $317,536.
The lack of internal controls and noncompliance were isolated to these two reports.
Criteria
2 CFR 200.303 states in part:
"The non-Federal entity must:
(a) Establish and maintain effective internal control over the Federal award that provides
reasonable assurance that the non-Federal entity is managing the Federal award in
compliance with Federal statutes, regulations, and the terms and conditions of the Federal
award. These internal controls should be in compliance with guidance in 'Standards for
Internal Control in the Federal Government' issued by the Comptroller General of the
United States or the 'Internal Control Integrated Framework', issued by the Committee of
Sponsoring Organizations of the Treadway Commission (COSO). . . ."
2 CFR 200.302(b) states in part:
"The financial management system of each non-Federal entity must provide for the following
. . .
(2) Accurate, current, and complete disclosure of the financial results of each Federal
award or program in accordance with the reporting requirements set forth in §§ 200.328
and 200.329. . . ."
34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format
that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other
responsibilities under the program."
Cause
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.
INDIANA STATE BOARD OF ACCOUNTS
34
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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, ESSER reports were not supported by the School Corporation's records and
were not accurate and complete.
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 that all reports are submitted accurately.
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: Special Education Cluster (IDEA) - Procurement
Federal Agency: Department of Education
Federal Program: Special Education Grants to States
Assistance Listings Number: 84.027
Federal Award Number and Year (or Other Identifying Number): H027A190084
Pass-Through Entity: Indiana Department of Education
Compliance Requirement: Procurement and Suspension and Debarment
Audit Findings: Material Weakness, Modified Opinion
Condition and Context
Federal regulations allow for informal procurement methods when the value of the procurement for
property or services does not exceed the simplified acquisition threshold, which is set at $250,000 unless
a lower, more restrictive threshold is set by a non-Federal entity. As Indiana Code has set a more restrictive
threshold of $150,000, informal procurement methods are permitted when the value of the procurement
does not exceed $150,000. This informal process allows for methods other than the formal bid process.
The informal process is divided between two methods based on thresholds. Micro-purchases, typically for
those purchases $10,000 or under, and small purchase procedures for those purchases above the micropurchase
threshold, but below the simplified acquisition threshold. Micro-purchases may be awarded
without soliciting competitive price rate quotations. If small purchase procedures are used, then price or
rate quotations must be obtained from an adequate number of qualified sources.
There were 27 vendors exceeding the small purchase threshold during the audit period. Of those,
5 vendors were selected for testing. For all 5 vendors tested, totaling $299,889, the School Corporation
did not obtain price or rate quotes. Documentation detailing the history of procurement, which must include
the reason for the procurement method used, selection of the vendor, and the basis for the price, was not
available for audit.
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
24
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
2 CFR 200.318 states in part:
"(a) The non-Federal entity must have and use documented procurement procedures,
consistent with State, local, and tribal laws and regulations and the standards of this section,
for the acquisition of property or services required under a Federal award or subaward. The
non-Federal entity's documented procurement procedures must conform to the procurement
standards identified in §§ 200.317 through 200.327. . . .
(i) The non-Federal entity must maintain records sufficient to detail the history of procurement.
These records will include, but are not necessarily limited to, the following: Rationale for the
method of procurement, selection of contract type, contractor selection or rejection, and the
basis for the contract price. . . ."
2 CFR 200.320 states in part:
"The non-Federal entity must have and use documented procurement procedures, consistent
with the standards of this section and §§ 200.317, 200.318, and 200.319 for any of the following
methods of procurement used for the acquisition of property or services required under a
Federal award or sub-award.
(a) Informal procurement methods. When the value of the procurement for property or
services under a Federal award does not exceed the simplified acquisition threshold (SAT),
as defined in § 200.1, or a lower threshold established by a non-Federal entity, formal
procurement methods are not required. The non-Federal entity may use informal
procurement methods to expedite the completion of its transactions and minimize the
associated administrative burden and cost. The informal methods used for procurement
of property or services at or below the SAT include: . . .
(2) Small purchases —
(i) Small purchase procedures. The acquisition of property or services, the
aggregate dollar amount of which is higher than the micro-purchase threshold but
does not exceed the simplified acquisition threshold. If small purchase procedures
are used, price or rate quotations must be obtained from an adequate number of
qualified sources as determined appropriate by the non-Federal entity. . . ."
Cause
A proper system of internal controls was not designed by management of the School Corporation.
Embedded within a properly designed and implemented internal control system should be internal controls
consisting of policies and procedures. Policies reflect the School Corporation's management statements
of what should be done to effect internal controls, and procedures should consist of actions that would
implement these policies.
Effect
Without the proper implementation of an effectively designed system of internal controls, the
internal control system cannot be capable of effectively preventing, or detecting and correcting, material
noncompliance. As a result, procurement procedures for goods and services were not adhered to for
vendors that fell within the small purchase threshold.
INDIANA STATE BOARD OF ACCOUNTS
25
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
Noncompliance with the grant agreement and the compliance requirement could result in the loss
of future federal funds to the School Corporation.
Questioned Costs
There were no questioned costs identified.
Recommendation
We recommended that management of the School Corporation establish a proper system of
internal controls and develop policies and procedures to ensure there are adequate and appropriate
procurement procedures for goods and services.
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: Twenty-First Century Community Learning Centers - Cash
Management, Program Income and Reporting
Federal Agency: Department of Education
Federal Program: Twenty-First Century Community Learning Centers
Assistance Listings Number: 84.287
Federal Award Numbers and Years (or Other Identifying Numbers): A58-1-21DL-0153,
A58-1-21DL-5176,
A58-2-22DL-0018,
A58-3-23DL-0027
Pass-Through Entity: Indiana Department of Education
Compliance Requirements: Cash Management, Program Income, and Reporting
Audit Findings: Material Weakness, Modified Opinion
Condition and Context
The School Corporation utilized grant funds to operate an After School Care Safe Harbor Program.
As part of the programs, the students were charged monthly fees to help cover the related costs. Per the
grant guidelines, families cannot be turned away for nonpayment of fees, and any fees collected are to be
reinvested into the programs. Reimbursement requests are to deduct the program income received from
allowable costs prior to claiming reimbursement.
During the audit period, the School Corporation collected fees for the Before School Care Program
and the After School Care Safe Harbor Program in the same manner. Fees collected for both programs
were collected and receipted into the After School fund. For the years ended June 30, 2022, and June 30,
2023, the School Corporation receipted a total of $45,723 and $41,513, respectively, into the After School
fund.
Cash Management
The School Corporation submitted 18 reimbursement requests in the audit period. Costs were
paid prior to requesting reimbursement as required; however, due to the lack of adequate
program income records the reimbursements were not reduced by the program income
received.
INDIANA STATE BOARD OF ACCOUNTS
26
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
Program Income
Although the School Corporation received approval from the grantor agency to collect program
income, the School Corporation did not properly track students' attendance and payments, both
if paid and how much paid; therefore, we were unable to determine the amount of program
income related to each program. Additionally, the School Corporation did not maintain program
income in a separate fund but comingled it with other nongrant funded program revenues.
Finally, the School Corporation did not deduct program income from allowable costs prior to
claiming reimbursement.
Reporting
Reimbursement Requests
The School Corporation submitted 18 reimbursement requests in the audit period. Of
those, 3 reimbursement requests were selected for testing. Of the 3 reimbursement
requests inspected, none were reduced by program income received, and 1 was not
properly supported by School Corporation records. The reimbursement was overstated by
$14,700 when compared to the ledger. Based on additional procedures performed, the
total requested reimbursements for the audit period were understated by $32,605 when
compared to the ledger.
Year End Reports
End of Year reports are to be submitted within 60 days of the contract end date. A total of
four End of Year Reports were submitted in the audit period and two were selected for
testing. Of the two End of Year reports selected for testing, neither properly included
program income received during the year due to inadequate tracking of program income.
The lack of 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.305(b)(5) states in part: "To the extent available, the non-Federal entity must disburse
funds available from program income (including repayments to a revolving fund), rebates, refunds, contract
settlements, audit recoveries, and interest earned on such funds before requesting additional cash
payments."
INDIANA STATE BOARD OF ACCOUNTS
27
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
2 CFR 200.307 states in part:
"(a) General. Non-Federal entities are encouraged to earn income to defray program costs
where appropriate. . . .
(e) Use of program income. If the Federal awarding agency does not specify in its regulations
or the terms and conditions of the Federal award, or give prior approval for how program
income is to be used, paragraph (e)(1) of this section must apply. For Federal awards made
to IHEs and nonprofit research institutions, if the Federal awarding agency does not specify in
its regulations or the terms and conditions of the Federal award how program income is to be
used, paragraph (e)(2) of this section must apply. In specifying alternatives to paragraphs
(e)(1) and (2) of this section, the Federal awarding agency may distinguish between income
earned by the recipient and income earned by subrecipients and between the sources, kinds,
or amounts of income. When the Federal awarding agency authorizes the approaches in
paragraphs (e)(2) and (3) of this section, program income in excess of any amounts specified
must also be deducted from expenditures.
(1) Deduction. Ordinarily program income must be deducted from total allowable costs to
determine the net allowable costs. Program income must be used for current costs
unless the Federal awarding agency authorizes otherwise. Program income that the
non- Federal entity did not anticipate at the time of the Federal award must be used to
reduce the Federal award and non- Federal entity contributions rather than to increase
the funds committed to the project.
(2) Addition. With prior approval of the Federal awarding agency (except for IHEs and
nonprofit research institutions, as described in this paragraph (e)) program income may
be added to the Federal award by the Federal agency and the non-Federal entity. The
program income must be used for the purposes and under the conditions of the Federal
award.
(3) Cost sharing or matching. With prior approval of the Federal awarding agency,
program income may be used to meet the cost sharing or matching requirement of the
Federal award. The amount of the Federal award remains the same. . . ."
2 CFR 200.302(b) states in part:
"The financial management system of each non-Federal entity must provide for the following:
. . .
(2) Accurate, current, and complete disclosure of the financial results of each Federal
award or program in accordance with the reporting requirements set forth in §§ 200.328
and 200.329. . . ."
34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format
that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other
responsibilities under the program."
34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with
program requirements."
INDIANA STATE BOARD OF ACCOUNTS
28
MICHIGAN CITY AREA SCHOOLS
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 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, program income was not properly documented resulting in noncompliance
with the Cash Management, Program Income, and Reporting compliance requirements.
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 by 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 strengthen its policies and procedures to ensure proper tracking of program income
to ensure all activity and reports submitted on behalf of the Twenty-First Century Community Learning
Centers program funds are accurate.
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: Twenty-First Century Community Learning Centers - Cash
Management, Program Income and Reporting
Federal Agency: Department of Education
Federal Program: Twenty-First Century Community Learning Centers
Assistance Listings Number: 84.287
Federal Award Numbers and Years (or Other Identifying Numbers): A58-1-21DL-0153,
A58-1-21DL-5176,
A58-2-22DL-0018,
A58-3-23DL-0027
Pass-Through Entity: Indiana Department of Education
Compliance Requirements: Cash Management, Program Income, and Reporting
Audit Findings: Material Weakness, Modified Opinion
Condition and Context
The School Corporation utilized grant funds to operate an After School Care Safe Harbor Program.
As part of the programs, the students were charged monthly fees to help cover the related costs. Per the
grant guidelines, families cannot be turned away for nonpayment of fees, and any fees collected are to be
reinvested into the programs. Reimbursement requests are to deduct the program income received from
allowable costs prior to claiming reimbursement.
During the audit period, the School Corporation collected fees for the Before School Care Program
and the After School Care Safe Harbor Program in the same manner. Fees collected for both programs
were collected and receipted into the After School fund. For the years ended June 30, 2022, and June 30,
2023, the School Corporation receipted a total of $45,723 and $41,513, respectively, into the After School
fund.
Cash Management
The School Corporation submitted 18 reimbursement requests in the audit period. Costs were
paid prior to requesting reimbursement as required; however, due to the lack of adequate
program income records the reimbursements were not reduced by the program income
received.
INDIANA STATE BOARD OF ACCOUNTS
26
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
Program Income
Although the School Corporation received approval from the grantor agency to collect program
income, the School Corporation did not properly track students' attendance and payments, both
if paid and how much paid; therefore, we were unable to determine the amount of program
income related to each program. Additionally, the School Corporation did not maintain program
income in a separate fund but comingled it with other nongrant funded program revenues.
Finally, the School Corporation did not deduct program income from allowable costs prior to
claiming reimbursement.
Reporting
Reimbursement Requests
The School Corporation submitted 18 reimbursement requests in the audit period. Of
those, 3 reimbursement requests were selected for testing. Of the 3 reimbursement
requests inspected, none were reduced by program income received, and 1 was not
properly supported by School Corporation records. The reimbursement was overstated by
$14,700 when compared to the ledger. Based on additional procedures performed, the
total requested reimbursements for the audit period were understated by $32,605 when
compared to the ledger.
Year End Reports
End of Year reports are to be submitted within 60 days of the contract end date. A total of
four End of Year Reports were submitted in the audit period and two were selected for
testing. Of the two End of Year reports selected for testing, neither properly included
program income received during the year due to inadequate tracking of program income.
The lack of 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.305(b)(5) states in part: "To the extent available, the non-Federal entity must disburse
funds available from program income (including repayments to a revolving fund), rebates, refunds, contract
settlements, audit recoveries, and interest earned on such funds before requesting additional cash
payments."
INDIANA STATE BOARD OF ACCOUNTS
27
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
2 CFR 200.307 states in part:
"(a) General. Non-Federal entities are encouraged to earn income to defray program costs
where appropriate. . . .
(e) Use of program income. If the Federal awarding agency does not specify in its regulations
or the terms and conditions of the Federal award, or give prior approval for how program
income is to be used, paragraph (e)(1) of this section must apply. For Federal awards made
to IHEs and nonprofit research institutions, if the Federal awarding agency does not specify in
its regulations or the terms and conditions of the Federal award how program income is to be
used, paragraph (e)(2) of this section must apply. In specifying alternatives to paragraphs
(e)(1) and (2) of this section, the Federal awarding agency may distinguish between income
earned by the recipient and income earned by subrecipients and between the sources, kinds,
or amounts of income. When the Federal awarding agency authorizes the approaches in
paragraphs (e)(2) and (3) of this section, program income in excess of any amounts specified
must also be deducted from expenditures.
(1) Deduction. Ordinarily program income must be deducted from total allowable costs to
determine the net allowable costs. Program income must be used for current costs
unless the Federal awarding agency authorizes otherwise. Program income that the
non- Federal entity did not anticipate at the time of the Federal award must be used to
reduce the Federal award and non- Federal entity contributions rather than to increase
the funds committed to the project.
(2) Addition. With prior approval of the Federal awarding agency (except for IHEs and
nonprofit research institutions, as described in this paragraph (e)) program income may
be added to the Federal award by the Federal agency and the non-Federal entity. The
program income must be used for the purposes and under the conditions of the Federal
award.
(3) Cost sharing or matching. With prior approval of the Federal awarding agency,
program income may be used to meet the cost sharing or matching requirement of the
Federal award. The amount of the Federal award remains the same. . . ."
2 CFR 200.302(b) states in part:
"The financial management system of each non-Federal entity must provide for the following:
. . .
(2) Accurate, current, and complete disclosure of the financial results of each Federal
award or program in accordance with the reporting requirements set forth in §§ 200.328
and 200.329. . . ."
34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format
that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other
responsibilities under the program."
34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with
program requirements."
INDIANA STATE BOARD OF ACCOUNTS
28
MICHIGAN CITY AREA SCHOOLS
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 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, program income was not properly documented resulting in noncompliance
with the Cash Management, Program Income, and Reporting compliance requirements.
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 by 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 strengthen its policies and procedures to ensure proper tracking of program income
to ensure all activity and reports submitted on behalf of the Twenty-First Century Community Learning
Centers program funds are accurate.
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: COVID-19 - Education Stabilization Fund - Activities Allowed
or Unallowed, Allowable Costs/Cost Principles
Federal Agency: Department of Education
Federal Program: COVID-19 - Education Stabilization Fund
Assistance Listings Number: 84.425
Federal Award Number and Year (or Other Identifying Number): S425V200013
Pass-Through Entity: Indiana Department of Education
Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles
Audit Findings: Material Weakness, Modified Opinion
Condition and Context
On December 17, 2021, the School Corporation paid all School Corporation employees who had
been employed with the School Corporation during the 2020-2021 school year and for 120 days a School
Board approved retention bonus. The across-the-board stipends were paid without justification or
documentation that provided for additional duties or work performed on which to base the stipends. The
total amount of stipends paid, $822,750, were considered questioned costs.
INDIANA STATE BOARD OF ACCOUNTS
29
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
The lack of internal controls and noncompliance were isolated to the stipend payments noted
above.
Criteria
2 CFR 200.303 states in part:
"The non-Federal entity must:
(a) Establish and maintain effective internal control over the Federal award that provides
reasonable assurance that the non-Federal entity is managing the Federal award in
compliance with Federal statutes, regulations, and the terms and conditions of the Federal
award. These internal controls should be in compliance with guidance in 'Standards for
Internal Control in the Federal Government' issued by the Comptroller General of the
United States or the 'Internal Control Integrated Framework', issued by the Committee of
Sponsoring Organizations of the Treadway Commission (COSO). . . ."
2 CFR 200.403 states in part:
"Except where otherwise authorized by statute, costs must meet the following general criteria
in order to be allowable under Federal awards:
(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. . . ."
Indiana Department of Education's ESSER II Frequently Asked Questions (FAQs) states in part:
"12. Can ESSER II funds be used for staff stipends? . . .
While across the board stipends are not permitted (as "universal" or "across the board"
does not in and of itself demonstrate sufficient documentation), LEAs may pay staff for
COVID-related work that has been documented. Most, if not all, staff likely had extra
responsibilities as well as time and effort to respond to the pandemic. ESSER funds can be
used to pay staff for that work and LEAs are responsible for documenting (with internal controls)
that this work occurred. This is consistent with guidance on all salary and stipend
payments with all federal funds. . . ."
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.
INDIANA STATE BOARD OF ACCOUNTS
30
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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, costs were reimbursed that did not have adequate documentation to ensure
compliance with the compliance requirement.
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
Known questioned costs of $822,750 were identified as detailed in the Condition and Context.
Recommendation
We recommended that management of the School Corporation establish a proper system of
internal controls and develop policies and procedures to ensure costs are adequately documented.
Views of Responsible Officials
For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Auditor's Response
Per the Indiana Department of Education's ESSER II Frequently Asked Questions as stated above
in the listed "criteria," across the School Board stipends are not permitted and LEAs may pay staff for
COVID-related work that has been documented.
We reaffirm our finding and will review the status of the finding during our next audit.
FINDING 2023-005
Subject: COVID-19 - Education Stabilization Fund - Activities Allowed
or Unallowed, Allowable Costs/Cost Principles
Federal Agency: Department of Education
Federal Program: COVID-19 - Education Stabilization Fund
Assistance Listings Number: 84.425
Federal Award Number and Year (or Other Identifying Number): S425V200013
Pass-Through Entity: Indiana Department of Education
Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles
Audit Findings: Material Weakness, Modified Opinion
Condition and Context
On December 17, 2021, the School Corporation paid all School Corporation employees who had
been employed with the School Corporation during the 2020-2021 school year and for 120 days a School
Board approved retention bonus. The across-the-board stipends were paid without justification or
documentation that provided for additional duties or work performed on which to base the stipends. The
total amount of stipends paid, $822,750, were considered questioned costs.
INDIANA STATE BOARD OF ACCOUNTS
29
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
The lack of internal controls and noncompliance were isolated to the stipend payments noted
above.
Criteria
2 CFR 200.303 states in part:
"The non-Federal entity must:
(a) Establish and maintain effective internal control over the Federal award that provides
reasonable assurance that the non-Federal entity is managing the Federal award in
compliance with Federal statutes, regulations, and the terms and conditions of the Federal
award. These internal controls should be in compliance with guidance in 'Standards for
Internal Control in the Federal Government' issued by the Comptroller General of the
United States or the 'Internal Control Integrated Framework', issued by the Committee of
Sponsoring Organizations of the Treadway Commission (COSO). . . ."
2 CFR 200.403 states in part:
"Except where otherwise authorized by statute, costs must meet the following general criteria
in order to be allowable under Federal awards:
(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. . . ."
Indiana Department of Education's ESSER II Frequently Asked Questions (FAQs) states in part:
"12. Can ESSER II funds be used for staff stipends? . . .
While across the board stipends are not permitted (as "universal" or "across the board"
does not in and of itself demonstrate sufficient documentation), LEAs may pay staff for
COVID-related work that has been documented. Most, if not all, staff likely had extra
responsibilities as well as time and effort to respond to the pandemic. ESSER funds can be
used to pay staff for that work and LEAs are responsible for documenting (with internal controls)
that this work occurred. This is consistent with guidance on all salary and stipend
payments with all federal funds. . . ."
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.
INDIANA STATE BOARD OF ACCOUNTS
30
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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, costs were reimbursed that did not have adequate documentation to ensure
compliance with the compliance requirement.
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
Known questioned costs of $822,750 were identified as detailed in the Condition and Context.
Recommendation
We recommended that management of the School Corporation establish a proper system of
internal controls and develop policies and procedures to ensure costs are adequately documented.
Views of Responsible Officials
For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Auditor's Response
Per the Indiana Department of Education's ESSER II Frequently Asked Questions as stated above
in the listed "criteria," across the School Board stipends are not permitted and LEAs may pay staff for
COVID-related work that has been documented.
We reaffirm our finding and will review the status of the finding during our next audit.
FINDING 2023-006
Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management
Federal Agency: Department of Education
Federal Program: COVID-19 - Education Stabilization Fund
Assistance Listings Number: 84.425
Federal Award Number and Year (or Other Identifying Number): S425V200013
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 hired a consultant to compile and provide to them a fixed asset report that
contained all inventory and assets purchased that exceeded the School Corporation's capitalization
threshold through June 30, 2023. The consultant prepared the report; however, the School Corporation
did not have any policies or procedures in place to ensure the listing was complete, nor was there any
documentation that differences between the compiled asset report and the School Corporation's equipment
records were reviewed and resolved.
INDIANA STATE BOARD OF ACCOUNTS
31
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
Additionally, a property record or capital asset listing would include the following for each asset: 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.
During the audit period, the School Corporation completed an improvement project totaling
$1,738,356 with ESSER funds. This improvement project was not included on the asset listing or physical
inventory prepared by the consultant.
In addition, the School Corporation was unable to provide the capital asset deletions during the
audit period. Therefore, we could not determine if the disposition of any equipment or real property acquired
under federal awards were properly reflected in the property records.
The lack of internal controls and noncompliance were systemic issues throughout the audit period.
Criteria
2 CFR 200.303 states in part:
"The non-Federal entity must:
(a) Establish and maintain effective internal control over the Federal award that provides
reasonable assurance that the non-Federal entity is managing the Federal award in
compliance with Federal statutes, regulations, and the terms and conditions of the Federal
award. These internal controls should be in compliance with guidance in 'Standards for
Internal Control in the Federal Government' issued by the Comptroller General of the
United States or the 'Internal Control Integrated Framework', issued by the Committee of
Sponsoring Organizations of the Treadway Commission (COSO). . . ."
2 CFR 200.313(d) states in part:
". . . (1) Property records must be maintained that include a description of the property, a serial
number or other identification number, the source of funding for the property (including the
FAIN), who holds title, the acquisition date, 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."
2 CFR 200.313(e) states in part:
"When original or replacement equipment acquired under a Federal award is no longer needed
for the original project or program or for other activities currently or previously supported by a
Federal awarding agency, except as otherwise provided in Federal statutes, regulations, or
Federal awarding agency disposition instructions, the non-Federal entity must request
disposition instructions from the Federal awarding agency if required by the terms and
conditions of the Federal award. . . ."
INDIANA STATE BOARD OF ACCOUNTS
32
MICHIGAN CITY AREA SCHOOLS
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. As a result, assets purchased with federal dollars, ESSER funds, were not properly added
to the School Corporation's asset listing. In addition, assets on the listing did not denote whether federal
funds were used to acquire or dispose the asset, nor were any discrepancies in the records reconciled.
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,
new assets are properly added, and any discrepancies are reconciled.
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: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management
Federal Agency: Department of Education
Federal Program: COVID-19 - Education Stabilization Fund
Assistance Listings Number: 84.425
Federal Award Number and Year (or Other Identifying Number): S425V200013
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 hired a consultant to compile and provide to them a fixed asset report that
contained all inventory and assets purchased that exceeded the School Corporation's capitalization
threshold through June 30, 2023. The consultant prepared the report; however, the School Corporation
did not have any policies or procedures in place to ensure the listing was complete, nor was there any
documentation that differences between the compiled asset report and the School Corporation's equipment
records were reviewed and resolved.
INDIANA STATE BOARD OF ACCOUNTS
31
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
Additionally, a property record or capital asset listing would include the following for each asset: 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.
During the audit period, the School Corporation completed an improvement project totaling
$1,738,356 with ESSER funds. This improvement project was not included on the asset listing or physical
inventory prepared by the consultant.
In addition, the School Corporation was unable to provide the capital asset deletions during the
audit period. Therefore, we could not determine if the disposition of any equipment or real property acquired
under federal awards were properly reflected in the property records.
The lack of internal controls and noncompliance were systemic issues throughout the audit period.
Criteria
2 CFR 200.303 states in part:
"The non-Federal entity must:
(a) Establish and maintain effective internal control over the Federal award that provides
reasonable assurance that the non-Federal entity is managing the Federal award in
compliance with Federal statutes, regulations, and the terms and conditions of the Federal
award. These internal controls should be in compliance with guidance in 'Standards for
Internal Control in the Federal Government' issued by the Comptroller General of the
United States or the 'Internal Control Integrated Framework', issued by the Committee of
Sponsoring Organizations of the Treadway Commission (COSO). . . ."
2 CFR 200.313(d) states in part:
". . . (1) Property records must be maintained that include a description of the property, a serial
number or other identification number, the source of funding for the property (including the
FAIN), who holds title, the acquisition date, 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."
2 CFR 200.313(e) states in part:
"When original or replacement equipment acquired under a Federal award is no longer needed
for the original project or program or for other activities currently or previously supported by a
Federal awarding agency, except as otherwise provided in Federal statutes, regulations, or
Federal awarding agency disposition instructions, the non-Federal entity must request
disposition instructions from the Federal awarding agency if required by the terms and
conditions of the Federal award. . . ."
INDIANA STATE BOARD OF ACCOUNTS
32
MICHIGAN CITY AREA SCHOOLS
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. As a result, assets purchased with federal dollars, ESSER funds, were not properly added
to the School Corporation's asset listing. In addition, assets on the listing did not denote whether federal
funds were used to acquire or dispose the asset, nor were any discrepancies in the records reconciled.
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,
new assets are properly added, and any discrepancies are reconciled.
Views of Responsible Officials
For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-007
Subject: COVID-19 - Education Stabilization Fund - Reporting
Federal Agency: Department of Education
Federal Program: COVID-19 - Education Stabilization Fund
Assistance Listings Number: 84.425
Federal Award Numbers and Years (or Other Identifying Numbers): 5120S425U210013, S425U200013,
S425V200013
Pass-Through Entity: Indiana Department of Education
Compliance Requirement: Reporting
Audit Findings: Material Weakness, Other Matters
Condition and Context
The School Corporation had not properly designed or implemented a system of internal controls
that would likely be effective in preventing, or detecting and correcting, noncompliance. The School
Corporation was required to submit annual data reports 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.
INDIANA STATE BOARD OF ACCOUNTS
33
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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. Two of the six reports submitted during the
audit period were not supported by the School Corporation's records. The following errors were identified:
The ESSER II, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022,
reported $4,608,835 in total expenditures. However, the School Corporation's ledger for the
same period had total expenditures of $4,560,160.
The ESSER III, Year 2 report, which had covered the period of July 1, 2021 to June 30, 2022,
reported $118,103 in total expenditures. However, the School Corporation's ledger for the
same period had total expenditures of $317,536.
The lack of internal controls and noncompliance were isolated to these two reports.
Criteria
2 CFR 200.303 states in part:
"The non-Federal entity must:
(a) Establish and maintain effective internal control over the Federal award that provides
reasonable assurance that the non-Federal entity is managing the Federal award in
compliance with Federal statutes, regulations, and the terms and conditions of the Federal
award. These internal controls should be in compliance with guidance in 'Standards for
Internal Control in the Federal Government' issued by the Comptroller General of the
United States or the 'Internal Control Integrated Framework', issued by the Committee of
Sponsoring Organizations of the Treadway Commission (COSO). . . ."
2 CFR 200.302(b) states in part:
"The financial management system of each non-Federal entity must provide for the following
. . .
(2) Accurate, current, and complete disclosure of the financial results of each Federal
award or program in accordance with the reporting requirements set forth in §§ 200.328
and 200.329. . . ."
34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format
that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other
responsibilities under the program."
Cause
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.
INDIANA STATE BOARD OF ACCOUNTS
34
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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, ESSER reports were not supported by the School Corporation's records and
were not accurate and complete.
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 that all reports are submitted accurately.
Views of Responsible Officials
For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-007
Subject: COVID-19 - Education Stabilization Fund - Reporting
Federal Agency: Department of Education
Federal Program: COVID-19 - Education Stabilization Fund
Assistance Listings Number: 84.425
Federal Award Numbers and Years (or Other Identifying Numbers): 5120S425U210013, S425U200013,
S425V200013
Pass-Through Entity: Indiana Department of Education
Compliance Requirement: Reporting
Audit Findings: Material Weakness, Other Matters
Condition and Context
The School Corporation had not properly designed or implemented a system of internal controls
that would likely be effective in preventing, or detecting and correcting, noncompliance. The School
Corporation was required to submit annual data reports 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.
INDIANA STATE BOARD OF ACCOUNTS
33
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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. Two of the six reports submitted during the
audit period were not supported by the School Corporation's records. The following errors were identified:
The ESSER II, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022,
reported $4,608,835 in total expenditures. However, the School Corporation's ledger for the
same period had total expenditures of $4,560,160.
The ESSER III, Year 2 report, which had covered the period of July 1, 2021 to June 30, 2022,
reported $118,103 in total expenditures. However, the School Corporation's ledger for the
same period had total expenditures of $317,536.
The lack of internal controls and noncompliance were isolated to these two reports.
Criteria
2 CFR 200.303 states in part:
"The non-Federal entity must:
(a) Establish and maintain effective internal control over the Federal award that provides
reasonable assurance that the non-Federal entity is managing the Federal award in
compliance with Federal statutes, regulations, and the terms and conditions of the Federal
award. These internal controls should be in compliance with guidance in 'Standards for
Internal Control in the Federal Government' issued by the Comptroller General of the
United States or the 'Internal Control Integrated Framework', issued by the Committee of
Sponsoring Organizations of the Treadway Commission (COSO). . . ."
2 CFR 200.302(b) states in part:
"The financial management system of each non-Federal entity must provide for the following
. . .
(2) Accurate, current, and complete disclosure of the financial results of each Federal
award or program in accordance with the reporting requirements set forth in §§ 200.328
and 200.329. . . ."
34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format
that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other
responsibilities under the program."
Cause
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.
INDIANA STATE BOARD OF ACCOUNTS
34
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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, ESSER reports were not supported by the School Corporation's records and
were not accurate and complete.
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 that all reports are submitted accurately.
Views of Responsible Officials
For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-007
Subject: COVID-19 - Education Stabilization Fund - Reporting
Federal Agency: Department of Education
Federal Program: COVID-19 - Education Stabilization Fund
Assistance Listings Number: 84.425
Federal Award Numbers and Years (or Other Identifying Numbers): 5120S425U210013, S425U200013,
S425V200013
Pass-Through Entity: Indiana Department of Education
Compliance Requirement: Reporting
Audit Findings: Material Weakness, Other Matters
Condition and Context
The School Corporation had not properly designed or implemented a system of internal controls
that would likely be effective in preventing, or detecting and correcting, noncompliance. The School
Corporation was required to submit annual data reports 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.
INDIANA STATE BOARD OF ACCOUNTS
33
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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. Two of the six reports submitted during the
audit period were not supported by the School Corporation's records. The following errors were identified:
The ESSER II, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022,
reported $4,608,835 in total expenditures. However, the School Corporation's ledger for the
same period had total expenditures of $4,560,160.
The ESSER III, Year 2 report, which had covered the period of July 1, 2021 to June 30, 2022,
reported $118,103 in total expenditures. However, the School Corporation's ledger for the
same period had total expenditures of $317,536.
The lack of internal controls and noncompliance were isolated to these two reports.
Criteria
2 CFR 200.303 states in part:
"The non-Federal entity must:
(a) Establish and maintain effective internal control over the Federal award that provides
reasonable assurance that the non-Federal entity is managing the Federal award in
compliance with Federal statutes, regulations, and the terms and conditions of the Federal
award. These internal controls should be in compliance with guidance in 'Standards for
Internal Control in the Federal Government' issued by the Comptroller General of the
United States or the 'Internal Control Integrated Framework', issued by the Committee of
Sponsoring Organizations of the Treadway Commission (COSO). . . ."
2 CFR 200.302(b) states in part:
"The financial management system of each non-Federal entity must provide for the following
. . .
(2) Accurate, current, and complete disclosure of the financial results of each Federal
award or program in accordance with the reporting requirements set forth in §§ 200.328
and 200.329. . . ."
34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format
that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other
responsibilities under the program."
Cause
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.
INDIANA STATE BOARD OF ACCOUNTS
34
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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, ESSER reports were not supported by the School Corporation's records and
were not accurate and complete.
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 that all reports are submitted accurately.
Views of Responsible Officials
For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-007
Subject: COVID-19 - Education Stabilization Fund - Reporting
Federal Agency: Department of Education
Federal Program: COVID-19 - Education Stabilization Fund
Assistance Listings Number: 84.425
Federal Award Numbers and Years (or Other Identifying Numbers): 5120S425U210013, S425U200013,
S425V200013
Pass-Through Entity: Indiana Department of Education
Compliance Requirement: Reporting
Audit Findings: Material Weakness, Other Matters
Condition and Context
The School Corporation had not properly designed or implemented a system of internal controls
that would likely be effective in preventing, or detecting and correcting, noncompliance. The School
Corporation was required to submit annual data reports 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.
INDIANA STATE BOARD OF ACCOUNTS
33
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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. Two of the six reports submitted during the
audit period were not supported by the School Corporation's records. The following errors were identified:
The ESSER II, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022,
reported $4,608,835 in total expenditures. However, the School Corporation's ledger for the
same period had total expenditures of $4,560,160.
The ESSER III, Year 2 report, which had covered the period of July 1, 2021 to June 30, 2022,
reported $118,103 in total expenditures. However, the School Corporation's ledger for the
same period had total expenditures of $317,536.
The lack of internal controls and noncompliance were isolated to these two reports.
Criteria
2 CFR 200.303 states in part:
"The non-Federal entity must:
(a) Establish and maintain effective internal control over the Federal award that provides
reasonable assurance that the non-Federal entity is managing the Federal award in
compliance with Federal statutes, regulations, and the terms and conditions of the Federal
award. These internal controls should be in compliance with guidance in 'Standards for
Internal Control in the Federal Government' issued by the Comptroller General of the
United States or the 'Internal Control Integrated Framework', issued by the Committee of
Sponsoring Organizations of the Treadway Commission (COSO). . . ."
2 CFR 200.302(b) states in part:
"The financial management system of each non-Federal entity must provide for the following
. . .
(2) Accurate, current, and complete disclosure of the financial results of each Federal
award or program in accordance with the reporting requirements set forth in §§ 200.328
and 200.329. . . ."
34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format
that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other
responsibilities under the program."
Cause
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.
INDIANA STATE BOARD OF ACCOUNTS
34
MICHIGAN CITY AREA SCHOOLS
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
(Continued)
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, ESSER reports were not supported by the School Corporation's records and
were not accurate and complete.
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 that all reports are submitted accurately.
Views of Responsible Officials
For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.