Audit 342359

FY End
2024-06-30
Total Expended
$9.82M
Findings
8
Programs
22
Organization: Rend Lake College District #521 (IL)
Year: 2024 Accepted: 2025-02-13

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
523083 2024-002 Material Weakness - N
523084 2024-002 Material Weakness - N
523085 2024-002 Material Weakness - N
523086 2024-002 Material Weakness - N
1099525 2024-002 Material Weakness - N
1099526 2024-002 Material Weakness - N
1099527 2024-002 Material Weakness - N
1099528 2024-002 Material Weakness - N

Contacts

Name Title Type
M3RZKF31LJB3 Mallory Howell Auditee
6184375321 Kimberly Walker Auditor
No contacts on file

Notes to SEFA

Title: Loans or Loan Guarantees outstanding Accounting Policies: The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Rend Lake College District #521 (the College) under programs of the federal government for the year ended June 30, 2024. The information in the Schedule 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 Reqiurements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the College, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the College. Basis of Accounting. For financial reporting purposes, the College is considered a special-purpose government engaged only in business-type activities. Accordingly, the Colleges financial statements have been presented using the economic resources and measurement focus and the accrual basis of accounting. The Colleges schedule of expenditures of federal awards is prepared in conformity with the same basis of accounting. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. There were no loan programs for the year ended June 30, 2024.
Title: Subrecipients Accounting Policies: The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Rend Lake College District #521 (the College) under programs of the federal government for the year ended June 30, 2024. The information in the Schedule 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 Reqiurements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the College, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the College. Basis of Accounting. For financial reporting purposes, the College is considered a special-purpose government engaged only in business-type activities. Accordingly, the Colleges financial statements have been presented using the economic resources and measurement focus and the accrual basis of accounting. The Colleges schedule of expenditures of federal awards is prepared in conformity with the same basis of accounting. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. No federal awards were provided to subrecipients for the year ended June 30, 2024.
Title: Non-Cash Awards Accounting Policies: The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Rend Lake College District #521 (the College) under programs of the federal government for the year ended June 30, 2024. The information in the Schedule 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 Reqiurements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the College, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the College. Basis of Accounting. For financial reporting purposes, the College is considered a special-purpose government engaged only in business-type activities. Accordingly, the Colleges financial statements have been presented using the economic resources and measurement focus and the accrual basis of accounting. The Colleges schedule of expenditures of federal awards is prepared in conformity with the same basis of accounting. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. There were no noncash awards reports on the Schedule for the year ended June 30, 2024.

Finding Details

Finding No. 2024-002 – Internal Controls over Student Financial Assistance Special Tests and Provisions Federal Program Name: Federal Student Assistance Cluster; Federal Pell Grant Program, Federal Supplemental Educational Opportunity, Federal Work Study Program CFDA Number: 84.063, 84.007, and 84.033 Federal Agency: U.S. Department of Education Criteria/Specific Requirement: • The Student Financial Aid Handbook states that if a recipient of Title IV grant or loan funds withdraws from a school after beginning attendance, the school must perform an R2T4 calculation to determine the amount of the Title IV assistance earned by the student. • U.S. Code of Federal Regulations Title 34 CFR 668.56 requires that for each applicant whose FAFSA information is selected for verification by the Secretary, the College must obtain specified documentation to verify the information as applicable under Title 34 CRF 668.57(a), 34 CRF 668.57(b), 34 CRF 668.57(c) and 34 CRF 668.57(d). Condition: • During the compliance testing of “Special Tests and Provisions – Return of Funds” we noted that fourteen (14) return of funds calculations for the spring semester did not use the correct dates. • During the audit of the Federal Student Assistance Cluster, we noted one (1) instance the income tax reported on the Institutional Information Record (ISIR) did not match the information on the student’s income tax transcript. We also noted one (1) instance of the student’s household size not agreeing to the ISIR. Questioned Costs: None. Context: • In the Return of Funds calculations, fourteen (14) of the twenty-five (25) returns were calculated incorrectly. • Exceptions were noted in two (2) of the twenty-five (25) students selected for verification. Effect: The College could send incorrect funds back to the Department or award inaccurate funds to students. Cause: Lack of oversight over Return of Funds calculations and Verification. Recommendation: We recommend that the College develops internal controls to ensure the return of funds and student verification is preformed accurately. Management’s Response: Management agrees with the audit finding and recommendation.
Finding No. 2024-002 – Internal Controls over Student Financial Assistance Special Tests and Provisions Federal Program Name: Federal Student Assistance Cluster; Federal Pell Grant Program, Federal Supplemental Educational Opportunity, Federal Work Study Program CFDA Number: 84.063, 84.007, and 84.033 Federal Agency: U.S. Department of Education Criteria/Specific Requirement: • The Student Financial Aid Handbook states that if a recipient of Title IV grant or loan funds withdraws from a school after beginning attendance, the school must perform an R2T4 calculation to determine the amount of the Title IV assistance earned by the student. • U.S. Code of Federal Regulations Title 34 CFR 668.56 requires that for each applicant whose FAFSA information is selected for verification by the Secretary, the College must obtain specified documentation to verify the information as applicable under Title 34 CRF 668.57(a), 34 CRF 668.57(b), 34 CRF 668.57(c) and 34 CRF 668.57(d). Condition: • During the compliance testing of “Special Tests and Provisions – Return of Funds” we noted that fourteen (14) return of funds calculations for the spring semester did not use the correct dates. • During the audit of the Federal Student Assistance Cluster, we noted one (1) instance the income tax reported on the Institutional Information Record (ISIR) did not match the information on the student’s income tax transcript. We also noted one (1) instance of the student’s household size not agreeing to the ISIR. Questioned Costs: None. Context: • In the Return of Funds calculations, fourteen (14) of the twenty-five (25) returns were calculated incorrectly. • Exceptions were noted in two (2) of the twenty-five (25) students selected for verification. Effect: The College could send incorrect funds back to the Department or award inaccurate funds to students. Cause: Lack of oversight over Return of Funds calculations and Verification. Recommendation: We recommend that the College develops internal controls to ensure the return of funds and student verification is preformed accurately. Management’s Response: Management agrees with the audit finding and recommendation.
Finding No. 2024-002 – Internal Controls over Student Financial Assistance Special Tests and Provisions Federal Program Name: Federal Student Assistance Cluster; Federal Pell Grant Program, Federal Supplemental Educational Opportunity, Federal Work Study Program CFDA Number: 84.063, 84.007, and 84.033 Federal Agency: U.S. Department of Education Criteria/Specific Requirement: • The Student Financial Aid Handbook states that if a recipient of Title IV grant or loan funds withdraws from a school after beginning attendance, the school must perform an R2T4 calculation to determine the amount of the Title IV assistance earned by the student. • U.S. Code of Federal Regulations Title 34 CFR 668.56 requires that for each applicant whose FAFSA information is selected for verification by the Secretary, the College must obtain specified documentation to verify the information as applicable under Title 34 CRF 668.57(a), 34 CRF 668.57(b), 34 CRF 668.57(c) and 34 CRF 668.57(d). Condition: • During the compliance testing of “Special Tests and Provisions – Return of Funds” we noted that fourteen (14) return of funds calculations for the spring semester did not use the correct dates. • During the audit of the Federal Student Assistance Cluster, we noted one (1) instance the income tax reported on the Institutional Information Record (ISIR) did not match the information on the student’s income tax transcript. We also noted one (1) instance of the student’s household size not agreeing to the ISIR. Questioned Costs: None. Context: • In the Return of Funds calculations, fourteen (14) of the twenty-five (25) returns were calculated incorrectly. • Exceptions were noted in two (2) of the twenty-five (25) students selected for verification. Effect: The College could send incorrect funds back to the Department or award inaccurate funds to students. Cause: Lack of oversight over Return of Funds calculations and Verification. Recommendation: We recommend that the College develops internal controls to ensure the return of funds and student verification is preformed accurately. Management’s Response: Management agrees with the audit finding and recommendation.
Finding No. 2024-002 – Internal Controls over Student Financial Assistance Special Tests and Provisions Federal Program Name: Federal Student Assistance Cluster; Federal Pell Grant Program, Federal Supplemental Educational Opportunity, Federal Work Study Program CFDA Number: 84.063, 84.007, and 84.033 Federal Agency: U.S. Department of Education Criteria/Specific Requirement: • The Student Financial Aid Handbook states that if a recipient of Title IV grant or loan funds withdraws from a school after beginning attendance, the school must perform an R2T4 calculation to determine the amount of the Title IV assistance earned by the student. • U.S. Code of Federal Regulations Title 34 CFR 668.56 requires that for each applicant whose FAFSA information is selected for verification by the Secretary, the College must obtain specified documentation to verify the information as applicable under Title 34 CRF 668.57(a), 34 CRF 668.57(b), 34 CRF 668.57(c) and 34 CRF 668.57(d). Condition: • During the compliance testing of “Special Tests and Provisions – Return of Funds” we noted that fourteen (14) return of funds calculations for the spring semester did not use the correct dates. • During the audit of the Federal Student Assistance Cluster, we noted one (1) instance the income tax reported on the Institutional Information Record (ISIR) did not match the information on the student’s income tax transcript. We also noted one (1) instance of the student’s household size not agreeing to the ISIR. Questioned Costs: None. Context: • In the Return of Funds calculations, fourteen (14) of the twenty-five (25) returns were calculated incorrectly. • Exceptions were noted in two (2) of the twenty-five (25) students selected for verification. Effect: The College could send incorrect funds back to the Department or award inaccurate funds to students. Cause: Lack of oversight over Return of Funds calculations and Verification. Recommendation: We recommend that the College develops internal controls to ensure the return of funds and student verification is preformed accurately. Management’s Response: Management agrees with the audit finding and recommendation.
Finding No. 2024-002 – Internal Controls over Student Financial Assistance Special Tests and Provisions Federal Program Name: Federal Student Assistance Cluster; Federal Pell Grant Program, Federal Supplemental Educational Opportunity, Federal Work Study Program CFDA Number: 84.063, 84.007, and 84.033 Federal Agency: U.S. Department of Education Criteria/Specific Requirement: • The Student Financial Aid Handbook states that if a recipient of Title IV grant or loan funds withdraws from a school after beginning attendance, the school must perform an R2T4 calculation to determine the amount of the Title IV assistance earned by the student. • U.S. Code of Federal Regulations Title 34 CFR 668.56 requires that for each applicant whose FAFSA information is selected for verification by the Secretary, the College must obtain specified documentation to verify the information as applicable under Title 34 CRF 668.57(a), 34 CRF 668.57(b), 34 CRF 668.57(c) and 34 CRF 668.57(d). Condition: • During the compliance testing of “Special Tests and Provisions – Return of Funds” we noted that fourteen (14) return of funds calculations for the spring semester did not use the correct dates. • During the audit of the Federal Student Assistance Cluster, we noted one (1) instance the income tax reported on the Institutional Information Record (ISIR) did not match the information on the student’s income tax transcript. We also noted one (1) instance of the student’s household size not agreeing to the ISIR. Questioned Costs: None. Context: • In the Return of Funds calculations, fourteen (14) of the twenty-five (25) returns were calculated incorrectly. • Exceptions were noted in two (2) of the twenty-five (25) students selected for verification. Effect: The College could send incorrect funds back to the Department or award inaccurate funds to students. Cause: Lack of oversight over Return of Funds calculations and Verification. Recommendation: We recommend that the College develops internal controls to ensure the return of funds and student verification is preformed accurately. Management’s Response: Management agrees with the audit finding and recommendation.
Finding No. 2024-002 – Internal Controls over Student Financial Assistance Special Tests and Provisions Federal Program Name: Federal Student Assistance Cluster; Federal Pell Grant Program, Federal Supplemental Educational Opportunity, Federal Work Study Program CFDA Number: 84.063, 84.007, and 84.033 Federal Agency: U.S. Department of Education Criteria/Specific Requirement: • The Student Financial Aid Handbook states that if a recipient of Title IV grant or loan funds withdraws from a school after beginning attendance, the school must perform an R2T4 calculation to determine the amount of the Title IV assistance earned by the student. • U.S. Code of Federal Regulations Title 34 CFR 668.56 requires that for each applicant whose FAFSA information is selected for verification by the Secretary, the College must obtain specified documentation to verify the information as applicable under Title 34 CRF 668.57(a), 34 CRF 668.57(b), 34 CRF 668.57(c) and 34 CRF 668.57(d). Condition: • During the compliance testing of “Special Tests and Provisions – Return of Funds” we noted that fourteen (14) return of funds calculations for the spring semester did not use the correct dates. • During the audit of the Federal Student Assistance Cluster, we noted one (1) instance the income tax reported on the Institutional Information Record (ISIR) did not match the information on the student’s income tax transcript. We also noted one (1) instance of the student’s household size not agreeing to the ISIR. Questioned Costs: None. Context: • In the Return of Funds calculations, fourteen (14) of the twenty-five (25) returns were calculated incorrectly. • Exceptions were noted in two (2) of the twenty-five (25) students selected for verification. Effect: The College could send incorrect funds back to the Department or award inaccurate funds to students. Cause: Lack of oversight over Return of Funds calculations and Verification. Recommendation: We recommend that the College develops internal controls to ensure the return of funds and student verification is preformed accurately. Management’s Response: Management agrees with the audit finding and recommendation.
Finding No. 2024-002 – Internal Controls over Student Financial Assistance Special Tests and Provisions Federal Program Name: Federal Student Assistance Cluster; Federal Pell Grant Program, Federal Supplemental Educational Opportunity, Federal Work Study Program CFDA Number: 84.063, 84.007, and 84.033 Federal Agency: U.S. Department of Education Criteria/Specific Requirement: • The Student Financial Aid Handbook states that if a recipient of Title IV grant or loan funds withdraws from a school after beginning attendance, the school must perform an R2T4 calculation to determine the amount of the Title IV assistance earned by the student. • U.S. Code of Federal Regulations Title 34 CFR 668.56 requires that for each applicant whose FAFSA information is selected for verification by the Secretary, the College must obtain specified documentation to verify the information as applicable under Title 34 CRF 668.57(a), 34 CRF 668.57(b), 34 CRF 668.57(c) and 34 CRF 668.57(d). Condition: • During the compliance testing of “Special Tests and Provisions – Return of Funds” we noted that fourteen (14) return of funds calculations for the spring semester did not use the correct dates. • During the audit of the Federal Student Assistance Cluster, we noted one (1) instance the income tax reported on the Institutional Information Record (ISIR) did not match the information on the student’s income tax transcript. We also noted one (1) instance of the student’s household size not agreeing to the ISIR. Questioned Costs: None. Context: • In the Return of Funds calculations, fourteen (14) of the twenty-five (25) returns were calculated incorrectly. • Exceptions were noted in two (2) of the twenty-five (25) students selected for verification. Effect: The College could send incorrect funds back to the Department or award inaccurate funds to students. Cause: Lack of oversight over Return of Funds calculations and Verification. Recommendation: We recommend that the College develops internal controls to ensure the return of funds and student verification is preformed accurately. Management’s Response: Management agrees with the audit finding and recommendation.
Finding No. 2024-002 – Internal Controls over Student Financial Assistance Special Tests and Provisions Federal Program Name: Federal Student Assistance Cluster; Federal Pell Grant Program, Federal Supplemental Educational Opportunity, Federal Work Study Program CFDA Number: 84.063, 84.007, and 84.033 Federal Agency: U.S. Department of Education Criteria/Specific Requirement: • The Student Financial Aid Handbook states that if a recipient of Title IV grant or loan funds withdraws from a school after beginning attendance, the school must perform an R2T4 calculation to determine the amount of the Title IV assistance earned by the student. • U.S. Code of Federal Regulations Title 34 CFR 668.56 requires that for each applicant whose FAFSA information is selected for verification by the Secretary, the College must obtain specified documentation to verify the information as applicable under Title 34 CRF 668.57(a), 34 CRF 668.57(b), 34 CRF 668.57(c) and 34 CRF 668.57(d). Condition: • During the compliance testing of “Special Tests and Provisions – Return of Funds” we noted that fourteen (14) return of funds calculations for the spring semester did not use the correct dates. • During the audit of the Federal Student Assistance Cluster, we noted one (1) instance the income tax reported on the Institutional Information Record (ISIR) did not match the information on the student’s income tax transcript. We also noted one (1) instance of the student’s household size not agreeing to the ISIR. Questioned Costs: None. Context: • In the Return of Funds calculations, fourteen (14) of the twenty-five (25) returns were calculated incorrectly. • Exceptions were noted in two (2) of the twenty-five (25) students selected for verification. Effect: The College could send incorrect funds back to the Department or award inaccurate funds to students. Cause: Lack of oversight over Return of Funds calculations and Verification. Recommendation: We recommend that the College develops internal controls to ensure the return of funds and student verification is preformed accurately. Management’s Response: Management agrees with the audit finding and recommendation.