Audit 22866

FY End
2022-05-31
Total Expended
$15.05M
Findings
6
Programs
9
Organization: Loras College (IA)
Year: 2022 Accepted: 2023-02-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
20757 2022-003 - Yes L
20758 2022-003 - Yes L
20759 2022-002 Significant Deficiency Yes N
597199 2022-003 - Yes L
597200 2022-003 - Yes L
597201 2022-002 Significant Deficiency Yes N

Contacts

Name Title Type
KHABH9BKTL93 Rennie Root Auditee
5635887775 Nicki Donlon Auditor
No contacts on file

Notes to SEFA

Title: Loan/loan guarantee outstanding balances Accounting Policies: Expenditures reported on the Schedule are reported on the accrual or modified 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: Loras College has elected not to use the 10% de minimis indirect cost rate. The Federal Perkins Loan Program (CFDA No. 84.038) is administered directly by Loras College, and balances and transactions relating to this program are included in Loras College's basic financial statements. Loans outstanding at the beginning of the year and loans made during the year are included in the federal expenditures presented in the Schedule. No Federal Perkins loans were made during the year ended May 31, 2022. Federal Perkins loans outstanding at May 31, 2022 totaled $1,812,005.
Title: Pass-Through Entity Identification Numbers Accounting Policies: Expenditures reported on the Schedule are reported on the accrual or modified 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: Loras College has elected not to use the 10% de minimis indirect cost rate. Certain of the programs, grants, and/or awards included in the Schedule are missing the pass-through entity identification numbers. The missing numbers are due to the pass-through entity not providing the pass-through entity identification number.
Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the accrual or modified 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: Loras College has elected not to use the 10% de minimis indirect cost rate. The accompanying schedule of expenditures of federal and state awards (the Schedule) includes the federal and state award activity of Loras College under programs of the federal government for the year ended May 30, 2022. The information in this 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 Requirements for Federal Awards (Uniform Guidance) and the State Single Audit Guidelines. Because the Schedule presents only a selected portion of the operations of Loras College, it is not intended to and does not present the financial position, changes in net position or cash flows of Loras College.

Finding Details

Finding 2022-003: COVID-19 Education Stabilization Fund, Higher Education Emergency Relief Funds Reporting Program: COVID-19 Education Stabilization Fund, Higher Education Emergency Relief Funds Assistance Listing Number: 84.425E & F Federal Agency: U.S. Department of Education Federal Award Identification Number: P425E200665 & P425F201753 Federal Award Year: June 30, 2022 Repeat Finding: 2021-003 Criteria: The U.S. Department of Education (the Department) has issued guidance for the Education Stabilization Funds (ESF) Higher Education Emergency Relief Funds (HEERF) for quarterly reporting for all sections (a)(1), (a)(2), (a)(3) and (a)(4) that specifies the information to be reported and also that the deadline to submit all quarterly reports, student and institutional, is within 10 days of the end of the calendar quarter. Condition/Context: For the Institutional portion June 30, 2021 report selected for testing, the auditor noted that the report did not agree to the underlying support, specifically the categories of replacing lost revenue from auxiliary sources and other uses. Additionally, the June 30, 2021 report was posted to the College's website after the deadline of 10 days after calendar quarter end. Subsequently, the College corrected the June 30, 2021 institutional quarterly report and posted it to the College?s website and the auditor reviewed. For the student portion June 30, 2021, August 31, 2021 and March 31, 2022 quarterly reports selected for testing the College did not include two required items ? 1) the number of students eligible to receive emergency financial aid grants and 2) the total number of students who received the emergency financial aid grants. Additionally, the College posted the March 31, 2022 report two days after the reporting deadline. Subsequently, the College corrected the June 30, 2021, August 31, 2021 and March 31, 2022 student quarterly reports to add the required items and posted them to the College?s website and the auditor reviewed. Questioned Costs: Not applicable. Cause: The College?s internal controls related to the preparation and review of the quarterly reports were not effective in catching the errors in the reporting or ensuring that reporting was completed timely. Effect: The quarterly reports included incorrect and missing information and were posted to the College?s website late. Recommendation: We recommend the College review its internal controls over the preparation and review of the quarterly reports. The College should have supporting documents available for the preparer and reviewer of the quarterly and annual reports to ensure that reporting is done accurately and timely. Management?s Response: Management has reviewed internal controls related to quarterly reporting for both institutional and student funds. Requirements have been reviewed by personnel responsible for the preparation of quarterly reports as well as personnel responsible for review of the reports. Management has assigned personnel separate from those responsible for preparation of the quarterly reports to review supporting documents and verify the accuracy of the reporting. Procedures have been put into place to ensure timely reporting. In addition, all reports posted have been revised to include all requirements and report accurate information.
Finding 2022-003: COVID-19 Education Stabilization Fund, Higher Education Emergency Relief Funds Reporting Program: COVID-19 Education Stabilization Fund, Higher Education Emergency Relief Funds Assistance Listing Number: 84.425E & F Federal Agency: U.S. Department of Education Federal Award Identification Number: P425E200665 & P425F201753 Federal Award Year: June 30, 2022 Repeat Finding: 2021-003 Criteria: The U.S. Department of Education (the Department) has issued guidance for the Education Stabilization Funds (ESF) Higher Education Emergency Relief Funds (HEERF) for quarterly reporting for all sections (a)(1), (a)(2), (a)(3) and (a)(4) that specifies the information to be reported and also that the deadline to submit all quarterly reports, student and institutional, is within 10 days of the end of the calendar quarter. Condition/Context: For the Institutional portion June 30, 2021 report selected for testing, the auditor noted that the report did not agree to the underlying support, specifically the categories of replacing lost revenue from auxiliary sources and other uses. Additionally, the June 30, 2021 report was posted to the College's website after the deadline of 10 days after calendar quarter end. Subsequently, the College corrected the June 30, 2021 institutional quarterly report and posted it to the College?s website and the auditor reviewed. For the student portion June 30, 2021, August 31, 2021 and March 31, 2022 quarterly reports selected for testing the College did not include two required items ? 1) the number of students eligible to receive emergency financial aid grants and 2) the total number of students who received the emergency financial aid grants. Additionally, the College posted the March 31, 2022 report two days after the reporting deadline. Subsequently, the College corrected the June 30, 2021, August 31, 2021 and March 31, 2022 student quarterly reports to add the required items and posted them to the College?s website and the auditor reviewed. Questioned Costs: Not applicable. Cause: The College?s internal controls related to the preparation and review of the quarterly reports were not effective in catching the errors in the reporting or ensuring that reporting was completed timely. Effect: The quarterly reports included incorrect and missing information and were posted to the College?s website late. Recommendation: We recommend the College review its internal controls over the preparation and review of the quarterly reports. The College should have supporting documents available for the preparer and reviewer of the quarterly and annual reports to ensure that reporting is done accurately and timely. Management?s Response: Management has reviewed internal controls related to quarterly reporting for both institutional and student funds. Requirements have been reviewed by personnel responsible for the preparation of quarterly reports as well as personnel responsible for review of the reports. Management has assigned personnel separate from those responsible for preparation of the quarterly reports to review supporting documents and verify the accuracy of the reporting. Procedures have been put into place to ensure timely reporting. In addition, all reports posted have been revised to include all requirements and report accurate information.
Finding 2022-002: Significant Deficiency - Return of Title IV Funds Program: Student Financial Assistance Cluster Assistance Listing Number: 84.063 Federal Agency: U.S. Department of Education Federal Award Identification Number: P063P211441 Federal Award Year: June 30, 2022 Repeat Finding: 2021-001 Criteria: 34 CFR 668.22 requires that when a recipient of Title IV grant or loan assistance withdraws from an institution during a payment period or period of enrollment in which the recipient began attendance, the institution must determine the amount of Title IV grant or loan assistance that the student earned as of the student's withdrawal date in accordance with Federal regulations and return the unearned portion of the grant or loan funds to the Title IV programs as soon as possible but no later than 45 days after the withdrawal date. Condition/Context: The auditors noted that refunds were calculated incorrectly for three of five students selected for testing. Testing was performed for follow-up on the prior audit finding. ? For the first student, the original R2T4 calculation was completed incorrectly and 100% of the funds were returned. The College later revised the calculation to incorrectly include FSEOG funds that could have been disbursed that were awarded to the student months after the withdrawal and then disbursed to the student only the percentage of those funds that was calculated as earned. The result was $302 too much Pell Grant funds returned. ? For the second student, the original R2T4 calculation resulted in 100% of the funds being returned since the student did not attend. The College later revised the calculation and counted some days as being attended and aid earned although the aid was not disbursed to the student. ? For the third student, the original R2T4 calculation was completed incorrectly and included Pell Grant funds although the student had dropped below 1/2 time before withdrawing. The College later revised the calculation to incorrectly use a different withdrawal date and include FSEOG funds that could have been disbursed that were awarded to the student after the withdrawal and then disbursed to the student only the percentage of those funds that was calculated as earned. The result was $349 less Pell Grant funds than should have been returned. The sample was not a statistically valid sample. Questioned Costs: A total of $47 in Pell Grant funds (84.063). Cause: The College?s controls in place to accurately review and approve R2T4 calculations did not operate as designed. Effect: The College returned incorrect amounts the US Department of Education. Recommendation: The College should review its procedures to ensure that refunds are calculated correctly and timely and any returns are made within the required timeframe. Management?s Response: Management has reviewed internal processes and procedures to ensure that all refunds are calculated correctly and sent back or provided to the student as a post withdrawal disbursement when appropriate and within the required timeframe as stated in the federal student aid handbook. Procedures are clarified to include a student withdrawal date based on formal withdrawal by the student and despite the Loras policy to refund all charges back to the student if they fully withdraw in the first week of classes, a return of Title IV funds will be calculated to be certain the student receives any federal aid that has been earned. If a student withdraws before the 60% point of the semester, the last date of attendance as reported by faculty will be used to calculate the return of funds. All refund calculations will be completed using the Common Origination and Disbursement R2T4 calculator along with the Colleague R2T4 calculation and will then receive a final review by the Director of Student Accounts to ensure the correct type and amount of aid earned by the student and the correct type and amount of all federal funds is sent back in the timeframe outlined by the regulations.
Finding 2022-003: COVID-19 Education Stabilization Fund, Higher Education Emergency Relief Funds Reporting Program: COVID-19 Education Stabilization Fund, Higher Education Emergency Relief Funds Assistance Listing Number: 84.425E & F Federal Agency: U.S. Department of Education Federal Award Identification Number: P425E200665 & P425F201753 Federal Award Year: June 30, 2022 Repeat Finding: 2021-003 Criteria: The U.S. Department of Education (the Department) has issued guidance for the Education Stabilization Funds (ESF) Higher Education Emergency Relief Funds (HEERF) for quarterly reporting for all sections (a)(1), (a)(2), (a)(3) and (a)(4) that specifies the information to be reported and also that the deadline to submit all quarterly reports, student and institutional, is within 10 days of the end of the calendar quarter. Condition/Context: For the Institutional portion June 30, 2021 report selected for testing, the auditor noted that the report did not agree to the underlying support, specifically the categories of replacing lost revenue from auxiliary sources and other uses. Additionally, the June 30, 2021 report was posted to the College's website after the deadline of 10 days after calendar quarter end. Subsequently, the College corrected the June 30, 2021 institutional quarterly report and posted it to the College?s website and the auditor reviewed. For the student portion June 30, 2021, August 31, 2021 and March 31, 2022 quarterly reports selected for testing the College did not include two required items ? 1) the number of students eligible to receive emergency financial aid grants and 2) the total number of students who received the emergency financial aid grants. Additionally, the College posted the March 31, 2022 report two days after the reporting deadline. Subsequently, the College corrected the June 30, 2021, August 31, 2021 and March 31, 2022 student quarterly reports to add the required items and posted them to the College?s website and the auditor reviewed. Questioned Costs: Not applicable. Cause: The College?s internal controls related to the preparation and review of the quarterly reports were not effective in catching the errors in the reporting or ensuring that reporting was completed timely. Effect: The quarterly reports included incorrect and missing information and were posted to the College?s website late. Recommendation: We recommend the College review its internal controls over the preparation and review of the quarterly reports. The College should have supporting documents available for the preparer and reviewer of the quarterly and annual reports to ensure that reporting is done accurately and timely. Management?s Response: Management has reviewed internal controls related to quarterly reporting for both institutional and student funds. Requirements have been reviewed by personnel responsible for the preparation of quarterly reports as well as personnel responsible for review of the reports. Management has assigned personnel separate from those responsible for preparation of the quarterly reports to review supporting documents and verify the accuracy of the reporting. Procedures have been put into place to ensure timely reporting. In addition, all reports posted have been revised to include all requirements and report accurate information.
Finding 2022-003: COVID-19 Education Stabilization Fund, Higher Education Emergency Relief Funds Reporting Program: COVID-19 Education Stabilization Fund, Higher Education Emergency Relief Funds Assistance Listing Number: 84.425E & F Federal Agency: U.S. Department of Education Federal Award Identification Number: P425E200665 & P425F201753 Federal Award Year: June 30, 2022 Repeat Finding: 2021-003 Criteria: The U.S. Department of Education (the Department) has issued guidance for the Education Stabilization Funds (ESF) Higher Education Emergency Relief Funds (HEERF) for quarterly reporting for all sections (a)(1), (a)(2), (a)(3) and (a)(4) that specifies the information to be reported and also that the deadline to submit all quarterly reports, student and institutional, is within 10 days of the end of the calendar quarter. Condition/Context: For the Institutional portion June 30, 2021 report selected for testing, the auditor noted that the report did not agree to the underlying support, specifically the categories of replacing lost revenue from auxiliary sources and other uses. Additionally, the June 30, 2021 report was posted to the College's website after the deadline of 10 days after calendar quarter end. Subsequently, the College corrected the June 30, 2021 institutional quarterly report and posted it to the College?s website and the auditor reviewed. For the student portion June 30, 2021, August 31, 2021 and March 31, 2022 quarterly reports selected for testing the College did not include two required items ? 1) the number of students eligible to receive emergency financial aid grants and 2) the total number of students who received the emergency financial aid grants. Additionally, the College posted the March 31, 2022 report two days after the reporting deadline. Subsequently, the College corrected the June 30, 2021, August 31, 2021 and March 31, 2022 student quarterly reports to add the required items and posted them to the College?s website and the auditor reviewed. Questioned Costs: Not applicable. Cause: The College?s internal controls related to the preparation and review of the quarterly reports were not effective in catching the errors in the reporting or ensuring that reporting was completed timely. Effect: The quarterly reports included incorrect and missing information and were posted to the College?s website late. Recommendation: We recommend the College review its internal controls over the preparation and review of the quarterly reports. The College should have supporting documents available for the preparer and reviewer of the quarterly and annual reports to ensure that reporting is done accurately and timely. Management?s Response: Management has reviewed internal controls related to quarterly reporting for both institutional and student funds. Requirements have been reviewed by personnel responsible for the preparation of quarterly reports as well as personnel responsible for review of the reports. Management has assigned personnel separate from those responsible for preparation of the quarterly reports to review supporting documents and verify the accuracy of the reporting. Procedures have been put into place to ensure timely reporting. In addition, all reports posted have been revised to include all requirements and report accurate information.
Finding 2022-002: Significant Deficiency - Return of Title IV Funds Program: Student Financial Assistance Cluster Assistance Listing Number: 84.063 Federal Agency: U.S. Department of Education Federal Award Identification Number: P063P211441 Federal Award Year: June 30, 2022 Repeat Finding: 2021-001 Criteria: 34 CFR 668.22 requires that when a recipient of Title IV grant or loan assistance withdraws from an institution during a payment period or period of enrollment in which the recipient began attendance, the institution must determine the amount of Title IV grant or loan assistance that the student earned as of the student's withdrawal date in accordance with Federal regulations and return the unearned portion of the grant or loan funds to the Title IV programs as soon as possible but no later than 45 days after the withdrawal date. Condition/Context: The auditors noted that refunds were calculated incorrectly for three of five students selected for testing. Testing was performed for follow-up on the prior audit finding. ? For the first student, the original R2T4 calculation was completed incorrectly and 100% of the funds were returned. The College later revised the calculation to incorrectly include FSEOG funds that could have been disbursed that were awarded to the student months after the withdrawal and then disbursed to the student only the percentage of those funds that was calculated as earned. The result was $302 too much Pell Grant funds returned. ? For the second student, the original R2T4 calculation resulted in 100% of the funds being returned since the student did not attend. The College later revised the calculation and counted some days as being attended and aid earned although the aid was not disbursed to the student. ? For the third student, the original R2T4 calculation was completed incorrectly and included Pell Grant funds although the student had dropped below 1/2 time before withdrawing. The College later revised the calculation to incorrectly use a different withdrawal date and include FSEOG funds that could have been disbursed that were awarded to the student after the withdrawal and then disbursed to the student only the percentage of those funds that was calculated as earned. The result was $349 less Pell Grant funds than should have been returned. The sample was not a statistically valid sample. Questioned Costs: A total of $47 in Pell Grant funds (84.063). Cause: The College?s controls in place to accurately review and approve R2T4 calculations did not operate as designed. Effect: The College returned incorrect amounts the US Department of Education. Recommendation: The College should review its procedures to ensure that refunds are calculated correctly and timely and any returns are made within the required timeframe. Management?s Response: Management has reviewed internal processes and procedures to ensure that all refunds are calculated correctly and sent back or provided to the student as a post withdrawal disbursement when appropriate and within the required timeframe as stated in the federal student aid handbook. Procedures are clarified to include a student withdrawal date based on formal withdrawal by the student and despite the Loras policy to refund all charges back to the student if they fully withdraw in the first week of classes, a return of Title IV funds will be calculated to be certain the student receives any federal aid that has been earned. If a student withdraws before the 60% point of the semester, the last date of attendance as reported by faculty will be used to calculate the return of funds. All refund calculations will be completed using the Common Origination and Disbursement R2T4 calculator along with the Colleague R2T4 calculation and will then receive a final review by the Director of Student Accounts to ensure the correct type and amount of aid earned by the student and the correct type and amount of all federal funds is sent back in the timeframe outlined by the regulations.