FAC Explorer

Audit 27982

FY End
2022-06-30
Total Expended
$4.00M
Findings
6
Programs
9
Organization: Barr-Reeve Community Schools, Inc. (IN)
Year: 2022 Accepted: 2023-03-23
Auditor: Crowe LLP

Organization Exclusion Status:

Findings

ID Ref Severity Repeat Requirement
26362 2022-002 Significant Deficiency - L
26363 2022-002 Significant Deficiency - L
26364 2022-002 Significant Deficiency - L
602804 2022-002 Significant Deficiency - L
602805 2022-002 Significant Deficiency - L
602806 2022-002 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
84.425 Covid-19 - Education Stabilization Fund $962,516 Yes 1
84.010 Title I Grants to Local Educational Agencies $202,721 - 0
84.027 Special Education_grants to States $132,486 - 0
10.553 School Breakfast Program $85,372 Yes 0
10.555 National School Lunch Program $74,774 Yes 0
84.367 Supporting Effective Instruction State Grants $48,933 - 0
84.424 Student Support and Academic Enrichment Program $18,801 - 0
84.173 Special Education_preschool Grants $5,792 - 0
10.649 Covid-19 - Pandemic Ebt Administrative Costs $614 - 0

Contacts

Name Title Type
NDB6UDA6KB37 Tamara Swartzentruber Auditee
8124863509 Scott Nickerson Auditor
No contacts on file

Notes to SEFA

Title: NOTE 3 - 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, 2019 to June 30, 2021. 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.
Title: NOTE 4 - SPECIAL EDUCATION COOPERATIVE (ALN: 84.027, 84.173) 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, 2019 to June 30, 2021. 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 Daviess-Martin Special Education Cooperative (Cooperative), which operates the special education program for the School Corporation. As a result, some activity for the Special Education Cluster (IDEA) that is presented on 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.

Finding Details

Finding 2022-002
FINDING 2022-002 Information on the federal program: Subject: Education Stabilization Fund ? Annual Data Report Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 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 Financial reporting . . . ." 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." Condition: The School Corporation did not have a review control in place to ensure the annual data report was reviewed by someone other than the preparer. Cause: There were not sufficient internal controls in place to ensure the Annual Data Report was submitted by the Indiana Department of Education?s deadline. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Reporting compliance requirements. Questioned Costs: There were no questioned costs identified. Context: There was no documented review by someone other than the preparer of the Annual Data Report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-002
FINDING 2022-002 Information on the federal program: Subject: Education Stabilization Fund ? Annual Data Report Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 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 Financial reporting . . . ." 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." Condition: The School Corporation did not have a review control in place to ensure the annual data report was reviewed by someone other than the preparer. Cause: There were not sufficient internal controls in place to ensure the Annual Data Report was submitted by the Indiana Department of Education?s deadline. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Reporting compliance requirements. Questioned Costs: There were no questioned costs identified. Context: There was no documented review by someone other than the preparer of the Annual Data Report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-002
FINDING 2022-002 Information on the federal program: Subject: Education Stabilization Fund ? Annual Data Report Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 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 Financial reporting . . . ." 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." Condition: The School Corporation did not have a review control in place to ensure the annual data report was reviewed by someone other than the preparer. Cause: There were not sufficient internal controls in place to ensure the Annual Data Report was submitted by the Indiana Department of Education?s deadline. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Reporting compliance requirements. Questioned Costs: There were no questioned costs identified. Context: There was no documented review by someone other than the preparer of the Annual Data Report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-002
FINDING 2022-002 Information on the federal program: Subject: Education Stabilization Fund ? Annual Data Report Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 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 Financial reporting . . . ." 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." Condition: The School Corporation did not have a review control in place to ensure the annual data report was reviewed by someone other than the preparer. Cause: There were not sufficient internal controls in place to ensure the Annual Data Report was submitted by the Indiana Department of Education?s deadline. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Reporting compliance requirements. Questioned Costs: There were no questioned costs identified. Context: There was no documented review by someone other than the preparer of the Annual Data Report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-002
FINDING 2022-002 Information on the federal program: Subject: Education Stabilization Fund ? Annual Data Report Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 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 Financial reporting . . . ." 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." Condition: The School Corporation did not have a review control in place to ensure the annual data report was reviewed by someone other than the preparer. Cause: There were not sufficient internal controls in place to ensure the Annual Data Report was submitted by the Indiana Department of Education?s deadline. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Reporting compliance requirements. Questioned Costs: There were no questioned costs identified. Context: There was no documented review by someone other than the preparer of the Annual Data Report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-002
FINDING 2022-002 Information on the federal program: Subject: Education Stabilization Fund ? Annual Data Report Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 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 Financial reporting . . . ." 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." Condition: The School Corporation did not have a review control in place to ensure the annual data report was reviewed by someone other than the preparer. Cause: There were not sufficient internal controls in place to ensure the Annual Data Report was submitted by the Indiana Department of Education?s deadline. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Reporting compliance requirements. Questioned Costs: There were no questioned costs identified. Context: There was no documented review by someone other than the preparer of the Annual Data Report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.