Finding 526813 (2024-001)

Significant Deficiency Repeat Finding
Requirement
N
Questioned Costs
-
Year
2024
Accepted
2025-03-13
Audit: 345900
Organization: Columbia College (MO)
Auditor: Brown Edwards

AI Summary

  • Core Issue: Incorrect calculations of Title IV funds refunds due to improper deduction of break days for students who withdrew.
  • Impacted Requirements: Compliance with Department of Education criteria for calculating total calendar days in a payment period.
  • Recommended Follow-Up: Implement procedures for accurate Title IV refund calculations and ensure timely reviews by financial aid staff.

Finding Text

2024-001 – Incorrect Calculation of Title IV Funds Refunds (Significant Deficiency) Department of Education, SFA Cluster; Special Tests and Provisions Criteria: The total number of calendar days in a payment period or period of enrollment includes all days within the period that a student was scheduled to complete, except that scheduled breaks of at least five consecutive days are excluded from the total number of calendar days in a payment period or period of enrollment and the number of calendar days completed in that period. Condition: From a population of 208 students that officially or unofficially withdrew from a payment period, we tested 22 and noted that ten students required refund calculations. From these calculations we noted the following: 1) Thanksgiving break of five days was deducted incorrectly from total days in three calculations. 2) Spring break of nine days was deducted incorrectly as five days in one calculation. Cause: The College’s spring break was scheduled for the period February 26, 2024 through March 1, 2024, a total break of nine days for traditional students with no online classes. One traditional student with no online classes was tested and the break was incorrectly deducted as five days instead of nine. Three on-line students were tested, and a break of five days was deducted from total days, however, online classes were in progress during spring break and no break days should have been deducted. Effect: The refund was incorrect for four students that had refund calculations prepared. Repeat Finding from a Prior Year: Repeat of 2023-004. Recommendation: We recommend the College put procedures in place for accurate preparation and calculation of Title IV refunds. Management Response: We concur with this finding. The Office of Financial Aid conducted an internal review of all Return of Title IV (R2T4) calculations for the 2023-2024 academic year. Two students within the audit sample had been corrected prior to the audit; however, their disbursements were not updated in the Common Origination and Disbursement (COD) system at the time of the request. To prevent future discrepancies, we have collaborated with PowerFAIDS to ensure that the appropriate number of days associated with Thanksgiving and Spring Break are accurately assigned to students. Additionally, each financial aid counselor will complete the R2T4 calculation within three days of receiving a withdrawal notification email. Upon completion, the calculation will undergo a review by the Associate and/or Senior Director of Financial Aid to verify accuracy.

Corrective Action Plan

2024‐001 – Incorrect Calculation of Title IV Funds Refunds (Significant Deficiency) Criteria: The total number of calendar days in a payment period or period of enrollment includes all days within the period that a student was scheduled to complete, except that scheduled breaks of at least five consecutive days are excluded from the total number of calendar days in a payment period or period of enrollment and the number of calendar days completed in that period. Condition: From a population of 208 students that officially or unofficially withdrew from a payment period, we tested 22 and noted that ten students required refund calculations. From these calculations we noted the following: 1. Thanksgiving break of five days was deducted incorrectly from total days in three calculations. 2. Spring break of nine days was deducted incorrectly as five days in one calculation. Action Taken: We concur with this finding. The Office of Financial Aid conducted an internal review of all Return of Title IV (R2T4) calculations for the 2023‐2024 academic year. Two students within the audit sample had been corrected prior to the audit; however, their disbursements were not updated in the Common Origination and Disbursement (COD) system at the time of the request. To prevent future discrepancies, we have collaborated with PowerFAIDS to ensure that the appropriate number of days associated with Thanksgiving and Spring Break are accurately assigned to students. Additionally, each financial aid counselor will complete the R2T4 calculation within three days of receiving a withdrawal notification email. Upon completion, the calculation will undergo a review by the Associate and/or Senior Director of Financial Aid to verify accuracy. Responsible Party: Lola Kennedy, Senior Director of Financial Aid Point of Contact: Lola Kennedy, Senior Director of Financial Aid (lkennedy@columbiasc.edu) Expected date of correction: January 2025

Categories

Special Tests & Provisions Student Financial Aid Significant Deficiency

Other Findings in this Audit

  • 526814 2024-002
    Significant Deficiency Repeat
  • 1103255 2024-001
    Significant Deficiency Repeat
  • 1103256 2024-002
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans $12.17M
84.063 Federal Pell Grant Program $4.33M
84.027 Special Education Grants to States $1.55M
84.336 Teacher Quality Partnership Grants $533,181
84.007 Federal Supplemental Educational Opportunity Grants $165,792
84.033 Federal Work-Study Program $126,136
84.379 Teacher Education Assistance for College and Higher Education Grants (teach Grants) $39,606
93.859 Biomedical Research and Research Training $6,062