Finding 88179 (2022-003)

Significant Deficiency Repeat Finding
Requirement
N
Questioned Costs
-
Year
2022
Accepted
2023-03-27
Audit: 79889
Organization: Presentation College (SD)
Auditor: Eide Bailly LLP

AI Summary

  • Core Issue: There were significant errors in calculating the percentage of federal aid earned for students who withdrew, leading to incorrect amounts of Title IV funds being returned.
  • Impacted Requirements: Compliance with 34 CFR section 668.22 regarding the calculation of calendar days in a payment period was not met, affecting timely returns of funds.
  • Recommended Follow-Up: Review the calculation formula at the start of each semester to prevent future errors and ensure compliance.

Finding Text

2022-003 Department of Education Student Financial Aid Cluster CFDA # 84.268 ? Federal Direct Student Loans CFDA # 84.007 ? Federal Supplemental Educational Opportunity Grants (FSEOG) CFDA # 84.063 ? Federal Pell Grant Program 2021-2022 Award Year Special Tests and Provisions ? Return of Title IV Funds ? Calculation of the Amount of Title IV Assistance to be Returned, Timely Return of Funds Significant Deficiency in Internal Controls over Compliance Criteria: 34 CFR section 668.22 provides the criteria and guidance on the total number of calendar days in a payment period or period of enrollment for purposes of calculating the percentage of federal aid earned. Condition: During testing over return of Title IV funds, the following deficiencies were noted: ?5 of 8 students? percentage completion rate were calculated incorrectly which resulted in 3 of the 8students not having the correct amount of Title IV funds to be returned. ?1 of 8 students did not return Title IV funds in the required time frame. Cause: The errors all related to students who withdrew in the fall semester as the financial aid staff excluded days from institutionally scheduled breaks of at least 5 days that should not have been excluded; and, therefore, the total number of calendar days in the payment period or enrollment period was understated for purposes of the calculation of percentage of completion. The late reporting was a result of a student being missed in a batch reporting in the system. Effect: The effect of these errors resulted in aid not being returned in the proper timeframe and incorrect amounts of aid returned. Questioned Costs: None reported. Context/Sampling: A nonstatistical sample of 8 students out of 28 were selected for testing the return of Title IV funds. Repeat Finding from Prior Year(s): Yes. Recommendation: We recommend that the formula used to complete the calculation be reviewed at the start of each semester to ensure that the calculation is completed correctly. Views of Responsible Officials: Management agrees with the finding.

Corrective Action Plan

Finding 2022-003 Special Tests and Provisions ? Return of Title IV Funds ? Calculation of the Amount of Title IV Assistance to be Returned, Timely Return of Funds Federal Agency Name: Department of Education Program Name: Student Financial Aid Cluster CFDA # 84.268 ? Federal Direct Student Loans CFDA # 84.007 ? Federal Supplemental Educational Opportunity Grants (FSEOG) CFDA # 84.063 ? Federal Pell Grant Program Finding Summary: During testing over return of Title IV funds, the following deficiencies were noted: ? 5 of 8 students? percentage completion rate were calculated incorrectly which resulted in 3 of the 8 students not having the correct amount of Title IV funds to be returned. ? 1 of 8 students did not return Title IV funds in the required time frame. Responsible Individuals: James (Rocky) Query, Interim CFO and Jessica Papa, Director of Financial Aid Corrective Action Plan: The Business Office and Financial Aid Office have examined the internal control processes to address shortcomings that have contributed to deficiencies in the calculation and return of Title IV funds. External review of internal controls during the Spring term may contribute to further corrective actions. All required corrections in student accounts noted in the findings have been made. Anticipated Completion Date: Review and corrective action ongoing.

Categories

Student Financial Aid Reporting Special Tests & Provisions Significant Deficiency Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 88180 2022-006
    Significant Deficiency Repeat
  • 88181 2022-007
    Significant Deficiency
  • 90879 2022-002
    Material Weakness Repeat
  • 90880 2022-003
    Significant Deficiency Repeat
  • 90881 2022-004
    Significant Deficiency Repeat
  • 90882 2022-005
    Significant Deficiency
  • 90883 2022-006
    Significant Deficiency Repeat
  • 90884 2022-007
    Significant Deficiency
  • 90885 2022-006
    Significant Deficiency Repeat
  • 90886 2022-007
    Significant Deficiency
  • 90887 2022-002
    Material Weakness Repeat
  • 90888 2022-003
    Significant Deficiency Repeat
  • 90889 2022-005
    Significant Deficiency
  • 90890 2022-006
    Significant Deficiency Repeat
  • 90891 2022-007
    Significant Deficiency
  • 90892 2022-008
    Significant Deficiency
  • 90893 2022-010
    Significant Deficiency
  • 90894 2022-009
    Significant Deficiency
  • 90895 2022-010
    Significant Deficiency
  • 90896 2022-002
    Material Weakness Repeat
  • 664621 2022-003
    Significant Deficiency Repeat
  • 664622 2022-006
    Significant Deficiency Repeat
  • 664623 2022-007
    Significant Deficiency
  • 667321 2022-002
    Material Weakness Repeat
  • 667322 2022-003
    Significant Deficiency Repeat
  • 667323 2022-004
    Significant Deficiency Repeat
  • 667324 2022-005
    Significant Deficiency
  • 667325 2022-006
    Significant Deficiency Repeat
  • 667326 2022-007
    Significant Deficiency
  • 667327 2022-006
    Significant Deficiency Repeat
  • 667328 2022-007
    Significant Deficiency
  • 667329 2022-002
    Material Weakness Repeat
  • 667330 2022-003
    Significant Deficiency Repeat
  • 667331 2022-005
    Significant Deficiency
  • 667332 2022-006
    Significant Deficiency Repeat
  • 667333 2022-007
    Significant Deficiency
  • 667334 2022-008
    Significant Deficiency
  • 667335 2022-010
    Significant Deficiency
  • 667336 2022-009
    Significant Deficiency
  • 667337 2022-010
    Significant Deficiency
  • 667338 2022-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans $3.85M
84.063 Federal Pell Grant Program $1.04M
84.425 Covid - 19, Education Stabilization Fund $579,418
84.038 Federal Perkins Loan Program $380,225
84.425 Covid -19 - Education Stabilization Fund $85,050
84.007 Federal Supplemental Educational Opportunity Grants $63,316
84.033 Federal Work-Study Program $45,246
21.019 Covid - 19 Coronavirus Relief Fund $32,978