Audit 345900

FY End
2024-06-30
Total Expended
$19.05M
Findings
4
Programs
8
Organization: Columbia College (MO)
Year: 2024 Accepted: 2025-03-13
Auditor: Brown Edwards

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
526813 2024-001 Significant Deficiency Yes N
526814 2024-002 Significant Deficiency Yes N
1103255 2024-001 Significant Deficiency Yes N
1103256 2024-002 Significant Deficiency Yes N

Contacts

Name Title Type
E4VXHQEYATL4 Ruby Fielding Auditee
8037863966 John Hash Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying schedule of expenditures of federal awards (Schedule) includes the federal grant activity of Columbia 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 of the U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements 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. Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

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.
2024-002 – Reporting Student Withdrawal Date in the National Student Loan Data System (NSLDS) (Significant Deficiency) Department of Education, SFA Cluster; Special Tests and Provisions Criteria: The College is responsible for submitting timely, accurate and complete responses to Enrollment Reporting roster files and for maintaining proper documentation in accordance with 34 CFR Section 685.309(a)(2). Condition: From a population of 208 students that withdrew officially or unofficially during the fiscal year, we tested 22 and noted that withdrawal dates were submitted untimely for all 22 students and the incorrect date was reported for six students. Cause: NSLDS Enrollment Reporting was submitted more than 60 days after the date of determination for all 22 students and the incorrect withdrawal date was reported for six students. Effect: The Department of Education was unaware of the student withdrawals; thus, the Department could not properly service the student’s loans. The accuracy of Title IV student loan records depends heavily on the accuracy of the enrollment information reported by institutions. Repeat Finding from Prior Year: Repeat of 2023-005. Recommendation: We recommend that a review process be put in place to ensure complete and accurate NSLDS reporting of student withdrawal dates. Management Response: We concur with this finding. The Office of the Registrar reports the withdrawal date via Clearing House. However, the withdrawal date is overridden by any subsequent enrollment updates. Moving forward, the Office of Financial Aid will ensure that withdrawal dates for R2T4 calculations are accurately reported. The updated enrollment information will be saved in the student’s electronic file to maintain proper documentation and compliance.
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.
2024-002 – Reporting Student Withdrawal Date in the National Student Loan Data System (NSLDS) (Significant Deficiency) Department of Education, SFA Cluster; Special Tests and Provisions Criteria: The College is responsible for submitting timely, accurate and complete responses to Enrollment Reporting roster files and for maintaining proper documentation in accordance with 34 CFR Section 685.309(a)(2). Condition: From a population of 208 students that withdrew officially or unofficially during the fiscal year, we tested 22 and noted that withdrawal dates were submitted untimely for all 22 students and the incorrect date was reported for six students. Cause: NSLDS Enrollment Reporting was submitted more than 60 days after the date of determination for all 22 students and the incorrect withdrawal date was reported for six students. Effect: The Department of Education was unaware of the student withdrawals; thus, the Department could not properly service the student’s loans. The accuracy of Title IV student loan records depends heavily on the accuracy of the enrollment information reported by institutions. Repeat Finding from Prior Year: Repeat of 2023-005. Recommendation: We recommend that a review process be put in place to ensure complete and accurate NSLDS reporting of student withdrawal dates. Management Response: We concur with this finding. The Office of the Registrar reports the withdrawal date via Clearing House. However, the withdrawal date is overridden by any subsequent enrollment updates. Moving forward, the Office of Financial Aid will ensure that withdrawal dates for R2T4 calculations are accurately reported. The updated enrollment information will be saved in the student’s electronic file to maintain proper documentation and compliance.