Finding 42403 (2022-001)

Significant Deficiency Repeat Finding
Requirement
E
Questioned Costs
-
Year
2022
Accepted
2022-11-15
Audit: 38813
Organization: Rend Lake College District #521 (IL)

AI Summary

  • Core Issue: Errors in student financial assistance calculations, including incorrect charges and late fund returns.
  • Impacted Requirements: Compliance with federal regulations for R2T4 calculations and verification documentation.
  • Recommended Follow-up: Implement stronger internal controls to ensure accurate fund returns and verification processes.

Finding Text

Finding No. 2022-001 ? 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 one (1) student calculation used the incorrect institutional charges in the calculation and one (1) students funds were not sent back to the Department of Education within the required 45 day time frame. ? During the audit of the Federal Student Assistance Cluster we noted one (1) instance where the income tax reported on the Institutional Information Record (ISIR) did not match the information on the student?s income tax transcript. Questioned Costs: None. Context: In the Return of Funds calculations, two (2) of the twenty-five (25) returns were calculated incorrectly. Exceptions were noted in one (1) of the ten (10) students selected for verification. Effect: Inaccurate information may be included in the Submittal File or Enrollment Update to the NSLDS. Cause: Lack of oversight in the Enrollment Reporting to NSLDS. 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.

Corrective Action Plan

Finding No. 2022-001 - Internal Controls over Student Financial Assistance Special Tests and Provisions Condition: During the compliance testing, we noted the following exceptions: ? During the compliance testing of ?Special Tests and Provisions ? Return of Funds? we noted that one (1) student calculation used the incorrect institutional charges in the calculation and one (1) students funds were not sent back to the Department of Education within the required 45 day time frame. ? During the audit of the Federal Student Assistance Cluster we noted one (1) instance where the income tax reported on the Institutional Information Record (ISIR) did not match the information on the student?s income tax transcript. Plan: The Financial Aid Office has revised the worksheet used for Return of Funds calculation to include separate lines for tuition, fees, and books instead of only the aggregate total. The Financial Aid Specialist is training to perform the Return of Funds calculations. Going forward, when the Specialist performs the calculations, the files subsequently will be reviewed by the Director of Institutional Compliance and Research. When the Director of Institutional Compliance and Research reviews the R2T4 files for accuracy, she will also pull up the student?s file in COD to verify the amount has been transmitted. The Director will print the page for the R2T4 binder. This way the Director will quickly be able to see if a file has not been transmitted to COD. The Financial Aid Office staff has been retrained on separating tax information when a student (or parent) filed jointly and is now divorced, which was the case in the noted error. The staff will now leave the percentage to all decimal places in the calculator before multiplying it by the taxes paid. This will remove the chance for error due to rounding. Anticipated Date of Completion: Immediately upon learning of the deficiency. Contact Person Responsible for Corrective Action: Amy Epplin, Director of Institutional Compliance & Research

Categories

Student Financial Aid Special Tests & Provisions Reporting Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 42404 2022-001
    Significant Deficiency Repeat
  • 42405 2022-001
    Significant Deficiency Repeat
  • 618845 2022-001
    Significant Deficiency Repeat
  • 618846 2022-001
    Significant Deficiency Repeat
  • 618847 2022-001
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
84.063 Federal Pell Grant Program $2.67M
93.575 Child Care and Development Block Grant $611,564
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $341,024
94.006 Americorps $337,429
84.047 Trio_upward Bound $322,719
84.042 Trio_student Support Services $319,738
81.041 State Energy Program $170,000
17.285 Apprenticeship USA Grants $144,990
17.260 Wia Dislocated Workers $137,113
84.425 Education Stabilization Fund $119,383
84.002 Adult Education - Basic Grants to States $104,321
17.268 H-1b Job Training Grants $89,189
84.033 Federal Work-Study Program $54,216
10.311 Beginning Farmer and Rancher Development Program $53,951
84.007 Federal Supplemental Educational Opportunity Grants $49,400
64.117 Survivors and Dependents Educational Assistance $41,522
21.019 Coronavirus Relief Fund $34,616
84.048 Career and Technical Education -- Basic Grants to States $24,385
10.558 Child and Adult Care Food Program $16,981
84.335 Child Care Access Means Parents in School $11,802
93.434 Every Student Succeeds Act/preschool Development Grants $4,057