Audit 57985

FY End
2022-06-30
Total Expended
$1.27M
Findings
4
Programs
9
Organization: Hamilton Community Schools (IN)
Year: 2022 Accepted: 2023-03-09
Auditor: Crowe LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
21222 2022-003 Significant Deficiency - G
21440 2022-003 Significant Deficiency - G
597664 2022-003 Significant Deficiency - G
597882 2022-003 Significant Deficiency - G

Programs

ALN Program Spent Major Findings
84.027 Special Education_grants to States $234,054 Yes 1
84.425 Covid-19 - Education Stabilization Fund $188,985 Yes 0
84.010 Title I Grants to Local Educational Agencies $77,598 - 0
10.555 National School Lunch Program $36,825 - 0
10.553 School Breakfast Program $23,681 - 0
84.424 Student Support and Academic Enrichment Program $20,000 - 0
84.367 Supporting Effective Instruction State Grants $11,799 - 0
84.358 Rural Education $8,685 - 0
84.173 Special Education_preschool Grants $3,461 Yes 1

Contacts

Name Title Type
LNB3AJULE2Q1 Brittany Taylor Auditee
2604882513 Scott Nickerson Auditor
No contacts on file

Notes to SEFA

Title: NOTE 3 - SPECIAL EDUCATION COOPERATIVE Accounting Policies: NOTE 1 - BASIS OF PRESENTATION A. Basis of Presentation The accompanying Schedule of Expenditures of Federal Awards (SEFA) includes the federal grant activity of the School Corporation under programs of the federal government for the period of July 1, 2020 to June 30, 2022. The information in the SEFA is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the SEFA presents only a select portion of the operations of the School Corporation, it is not intended to and does not present the financial position of the School Corporation. The Uniform Guidance requires an annual audit of nonfederal entities expending a total amount of federal awards equal to or in excess of $750,000 in any fiscal year unless by constitution or statute a less frequent audit is required. In accordance with Indiana Code (IC 5-11-1-25), audits of school corporations shall be conducted biennially. Such audits shall include both years within the biennial period. B. Other Significant Accounting Policies Expenditures reported on the SEFA are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance, wherein certain types of expenditures are not allowed or are limited as to reimbursement. When federal grants are received on a reimbursement basis, the federal awards are considered expended when the reimbursement is received. De Minimis Rate Used: N Rate Explanation: NOTE 2 - INDIRECT COST RATE The School Corporation has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The School Corporation is a member of the NorthEast Indiana Special Education Cooperative (Cooperative). As a result, some activity for the Special Education Cluster (IDEA) that is presented as federal awards expended in the SEFA is not presented as receipts and disbursements in the financial statement for the School Corporation. This activity is reported on the financial statement of the Cooperative.
Title: NOTE 4 - OTHER INFORMATION Accounting Policies: NOTE 1 - BASIS OF PRESENTATION A. Basis of Presentation The accompanying Schedule of Expenditures of Federal Awards (SEFA) includes the federal grant activity of the School Corporation under programs of the federal government for the period of July 1, 2020 to June 30, 2022. The information in the SEFA is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the SEFA presents only a select portion of the operations of the School Corporation, it is not intended to and does not present the financial position of the School Corporation. The Uniform Guidance requires an annual audit of nonfederal entities expending a total amount of federal awards equal to or in excess of $750,000 in any fiscal year unless by constitution or statute a less frequent audit is required. In accordance with Indiana Code (IC 5-11-1-25), audits of school corporations shall be conducted biennially. Such audits shall include both years within the biennial period. B. Other Significant Accounting Policies Expenditures reported on the SEFA are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance, wherein certain types of expenditures are not allowed or are limited as to reimbursement. When federal grants are received on a reimbursement basis, the federal awards are considered expended when the reimbursement is received. De Minimis Rate Used: N Rate Explanation: NOTE 2 - INDIRECT COST RATE The School Corporation has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The School Corporation did not have any subrecipient activity for the period July 1, 2020 to June 30, 2022.

Finding Details

FINDING 2022-003 Subject: Special Education Cluster - Earmarking Federal Agency: Department of Education Federal Program: Special Education Grants to States, Special Education Preschool Grants Assistance Listings Numbers: 84.027, 84.173 Federal Award Number and Year (or Other Identifying Numbers): 19611-042-PN01, 20611-042-PN01, 21611-042-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Finding: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a)Establish and maintain effective internal control over Federal award that provides reasonable assurancethat the non-Federal entity is managing the Federal awards in compliance with Federal statutes,regulations, and the terms and conditions of the Federal award. These internal controls should be incompliance with guidance in 'Standards for Internal Control in the Federal Government' issued by theComptroller General of the United States or the 'Internal Control Integrated Framework', issued by theCommittee of Sponsoring Organizations of the Treadway Commission (COSO)...." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: ? (g) Be adequately documented.... " 2 CFR 200.208(b) states in part: "The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Condition: The School Corporation is a member of the Northeast Indiana Special Education Cooperative (Cooperative). The School Corporation did not have adequate internal controls in place to ensure that the Cooperative complied with the earmarking requirements. Cause: The School Corporation's management had not developed an effective system of internal controls that would have ensured compliance with the grant agreement and the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Effect: The failure to establish an effective internal control system, as well as adequately document costs of federal awards, prevented the determination of the School Corporation's compliance with the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Questioned Costs: There were no questioned costs identified. Context: The School Corporation is a member of the Northeast Indiana Special Education Cooperative (Cooperative). During fiscal year 2021-2022, the Cooperative operated the special education programs and spent the federal money on behalf of all its members. As the grant agreements were between the Indiana Department of Education (IDOE) and each member school, the School Corporation was responsible for ensuring and providing oversight of the Cooperative. However, there was inadequate oversight performed by the School Corporation in order to ensure compliance with the Matching, Level of Effort, Earmarking compliance requirement. The School Corporation did not have internal controls in place to ensure that the Cooperative complied with the earmarking requirements. The Cooperative did not have adequate procedures in place to ensure that the required level of expenditures for non-public students with disabilities was met for each member school. The Cooperative did not have effective internal controls to ensure non-public school expenditures were appropriately identified and reported. The Non-Public Proportionate Share expenditures for 19611-042-PN01 and 20611-042-PN01 grant awards could not be verified for the individual schools to verify the minimum amount per the grant awards was expended and properly reported to IDOE as required. The School Corporation?s minimum earmarking requirements for the 19611-042-PN01 and 20611-042-PN01 grant awards were $1,095 and $1,791, respectively. The lack of internal controls and noncompliance were isolated to the 19611-042-PN01 and 20611-042- Identification of repeat finding: No Recommendation: We recommended that the School Corporation's management establish a system of internal controls, as well as appropriately document and identify federal award expenditures to ensure compliance with the Matching, Level of Effort, Earmarking compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan
FINDING 2022-003 Subject: Special Education Cluster - Earmarking Federal Agency: Department of Education Federal Program: Special Education Grants to States, Special Education Preschool Grants Assistance Listings Numbers: 84.027, 84.173 Federal Award Number and Year (or Other Identifying Numbers): 19611-042-PN01, 20611-042-PN01, 21611-042-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Finding: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a)Establish and maintain effective internal control over Federal award that provides reasonable assurancethat the non-Federal entity is managing the Federal awards in compliance with Federal statutes,regulations, and the terms and conditions of the Federal award. These internal controls should be incompliance with guidance in 'Standards for Internal Control in the Federal Government' issued by theComptroller General of the United States or the 'Internal Control Integrated Framework', issued by theCommittee of Sponsoring Organizations of the Treadway Commission (COSO)...." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: ? (g) Be adequately documented.... " 2 CFR 200.208(b) states in part: "The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Condition: The School Corporation is a member of the Northeast Indiana Special Education Cooperative (Cooperative). The School Corporation did not have adequate internal controls in place to ensure that the Cooperative complied with the earmarking requirements. Cause: The School Corporation's management had not developed an effective system of internal controls that would have ensured compliance with the grant agreement and the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Effect: The failure to establish an effective internal control system, as well as adequately document costs of federal awards, prevented the determination of the School Corporation's compliance with the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Questioned Costs: There were no questioned costs identified. Context: The School Corporation is a member of the Northeast Indiana Special Education Cooperative (Cooperative). During fiscal year 2021-2022, the Cooperative operated the special education programs and spent the federal money on behalf of all its members. As the grant agreements were between the Indiana Department of Education (IDOE) and each member school, the School Corporation was responsible for ensuring and providing oversight of the Cooperative. However, there was inadequate oversight performed by the School Corporation in order to ensure compliance with the Matching, Level of Effort, Earmarking compliance requirement. The School Corporation did not have internal controls in place to ensure that the Cooperative complied with the earmarking requirements. The Cooperative did not have adequate procedures in place to ensure that the required level of expenditures for non-public students with disabilities was met for each member school. The Cooperative did not have effective internal controls to ensure non-public school expenditures were appropriately identified and reported. The Non-Public Proportionate Share expenditures for 19611-042-PN01 and 20611-042-PN01 grant awards could not be verified for the individual schools to verify the minimum amount per the grant awards was expended and properly reported to IDOE as required. The School Corporation?s minimum earmarking requirements for the 19611-042-PN01 and 20611-042-PN01 grant awards were $1,095 and $1,791, respectively. The lack of internal controls and noncompliance were isolated to the 19611-042-PN01 and 20611-042- Identification of repeat finding: No Recommendation: We recommended that the School Corporation's management establish a system of internal controls, as well as appropriately document and identify federal award expenditures to ensure compliance with the Matching, Level of Effort, Earmarking compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan
FINDING 2022-003 Subject: Special Education Cluster - Earmarking Federal Agency: Department of Education Federal Program: Special Education Grants to States, Special Education Preschool Grants Assistance Listings Numbers: 84.027, 84.173 Federal Award Number and Year (or Other Identifying Numbers): 19611-042-PN01, 20611-042-PN01, 21611-042-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Finding: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a)Establish and maintain effective internal control over Federal award that provides reasonable assurancethat the non-Federal entity is managing the Federal awards in compliance with Federal statutes,regulations, and the terms and conditions of the Federal award. These internal controls should be incompliance with guidance in 'Standards for Internal Control in the Federal Government' issued by theComptroller General of the United States or the 'Internal Control Integrated Framework', issued by theCommittee of Sponsoring Organizations of the Treadway Commission (COSO)...." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: ? (g) Be adequately documented.... " 2 CFR 200.208(b) states in part: "The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Condition: The School Corporation is a member of the Northeast Indiana Special Education Cooperative (Cooperative). The School Corporation did not have adequate internal controls in place to ensure that the Cooperative complied with the earmarking requirements. Cause: The School Corporation's management had not developed an effective system of internal controls that would have ensured compliance with the grant agreement and the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Effect: The failure to establish an effective internal control system, as well as adequately document costs of federal awards, prevented the determination of the School Corporation's compliance with the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Questioned Costs: There were no questioned costs identified. Context: The School Corporation is a member of the Northeast Indiana Special Education Cooperative (Cooperative). During fiscal year 2021-2022, the Cooperative operated the special education programs and spent the federal money on behalf of all its members. As the grant agreements were between the Indiana Department of Education (IDOE) and each member school, the School Corporation was responsible for ensuring and providing oversight of the Cooperative. However, there was inadequate oversight performed by the School Corporation in order to ensure compliance with the Matching, Level of Effort, Earmarking compliance requirement. The School Corporation did not have internal controls in place to ensure that the Cooperative complied with the earmarking requirements. The Cooperative did not have adequate procedures in place to ensure that the required level of expenditures for non-public students with disabilities was met for each member school. The Cooperative did not have effective internal controls to ensure non-public school expenditures were appropriately identified and reported. The Non-Public Proportionate Share expenditures for 19611-042-PN01 and 20611-042-PN01 grant awards could not be verified for the individual schools to verify the minimum amount per the grant awards was expended and properly reported to IDOE as required. The School Corporation?s minimum earmarking requirements for the 19611-042-PN01 and 20611-042-PN01 grant awards were $1,095 and $1,791, respectively. The lack of internal controls and noncompliance were isolated to the 19611-042-PN01 and 20611-042- Identification of repeat finding: No Recommendation: We recommended that the School Corporation's management establish a system of internal controls, as well as appropriately document and identify federal award expenditures to ensure compliance with the Matching, Level of Effort, Earmarking compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan
FINDING 2022-003 Subject: Special Education Cluster - Earmarking Federal Agency: Department of Education Federal Program: Special Education Grants to States, Special Education Preschool Grants Assistance Listings Numbers: 84.027, 84.173 Federal Award Number and Year (or Other Identifying Numbers): 19611-042-PN01, 20611-042-PN01, 21611-042-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Finding: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a)Establish and maintain effective internal control over Federal award that provides reasonable assurancethat the non-Federal entity is managing the Federal awards in compliance with Federal statutes,regulations, and the terms and conditions of the Federal award. These internal controls should be incompliance with guidance in 'Standards for Internal Control in the Federal Government' issued by theComptroller General of the United States or the 'Internal Control Integrated Framework', issued by theCommittee of Sponsoring Organizations of the Treadway Commission (COSO)...." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: ? (g) Be adequately documented.... " 2 CFR 200.208(b) states in part: "The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Condition: The School Corporation is a member of the Northeast Indiana Special Education Cooperative (Cooperative). The School Corporation did not have adequate internal controls in place to ensure that the Cooperative complied with the earmarking requirements. Cause: The School Corporation's management had not developed an effective system of internal controls that would have ensured compliance with the grant agreement and the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Effect: The failure to establish an effective internal control system, as well as adequately document costs of federal awards, prevented the determination of the School Corporation's compliance with the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Questioned Costs: There were no questioned costs identified. Context: The School Corporation is a member of the Northeast Indiana Special Education Cooperative (Cooperative). During fiscal year 2021-2022, the Cooperative operated the special education programs and spent the federal money on behalf of all its members. As the grant agreements were between the Indiana Department of Education (IDOE) and each member school, the School Corporation was responsible for ensuring and providing oversight of the Cooperative. However, there was inadequate oversight performed by the School Corporation in order to ensure compliance with the Matching, Level of Effort, Earmarking compliance requirement. The School Corporation did not have internal controls in place to ensure that the Cooperative complied with the earmarking requirements. The Cooperative did not have adequate procedures in place to ensure that the required level of expenditures for non-public students with disabilities was met for each member school. The Cooperative did not have effective internal controls to ensure non-public school expenditures were appropriately identified and reported. The Non-Public Proportionate Share expenditures for 19611-042-PN01 and 20611-042-PN01 grant awards could not be verified for the individual schools to verify the minimum amount per the grant awards was expended and properly reported to IDOE as required. The School Corporation?s minimum earmarking requirements for the 19611-042-PN01 and 20611-042-PN01 grant awards were $1,095 and $1,791, respectively. The lack of internal controls and noncompliance were isolated to the 19611-042-PN01 and 20611-042- Identification of repeat finding: No Recommendation: We recommended that the School Corporation's management establish a system of internal controls, as well as appropriately document and identify federal award expenditures to ensure compliance with the Matching, Level of Effort, Earmarking compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan