Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Pell Grant Program ALN 84.063, Federal Direct Student Loan Program ALN 84.268, Federal Supplemental Educational Opportunity Grant (SEOG) Program ALN 84.007, Federal Work Study (FWS) Program ALN 84.033, and Federal Perkins Loan Program ALN 84.038; TRIO Student Support Service (SSS) Grant Program ALN 84.042; and Corporation for National and Community Service AmeriCorps Vista Grant Program ALN 94.006
Federal Award Identification Number and Year - 2022-2023
Finding Type - Significant deficiency
Repeat Finding - No
Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of federal expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502.
Condition - The schedule of expenditures of federal awards (SEFA) was not complete and accurate.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - The SEFA provided did not include all expenditures of the FWS and TRIO SSS programs and no expenditures of the AmeriCorps Vista program. In addition, the SEFA did not include the correct outstanding Federal Perkins Loan Balance as of the beginning of the fiscal year. As a result, the SEFA was overstated by $1,220,928. In addition, we noted the SEFA was not fully reconciled to the related federal expenditures and grant revenue as of June 30, 2023 resulting in an overstatement of federal revenue of $209,446.
Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The above errors have been corrected on the SEFA as of June 30, 2023.
Recommendation - The College should implement a process to ensure that the SEFA is prepared timely and that it is complete, accurate, and reconciled to the related federal revenue and expenditures. The College should also ensure all federal grants are appropriately classified as federal within the general ledger.
Views of Responsible Officials and Corrective Action Plan - The Albion College Business Office has established revised procedures for SEFA funds, in tandem with the Financial Aid Office, in which all Federal Awards and Grants will be reconciled on a quarterly basis, to be completed no later than the end of the first proceeding month of the quarter. The procedures create a dual- control process for the drawdown, recordation, and reporting of SEFA funds. Additionally, in FY24, the Perkins portfolio was divested. The Perkins Close- out will be part of the FY24 Single Audit.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Pell Grant Program ALN 84.063, Federal Direct Student Loan Program ALN 84.268, Federal Supplemental Educational Opportunity Grant (SEOG) Program ALN 84.007, Federal Work Study (FWS) Program ALN 84.033, and Federal Perkins Loan Program ALN 84.038; TRIO Student Support Service (SSS) Grant Program ALN 84.042; and Corporation for National and Community Service AmeriCorps Vista Grant Program ALN 94.006
Federal Award Identification Number and Year - 2022-2023
Finding Type - Significant deficiency
Repeat Finding - No
Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of federal expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502.
Condition - The schedule of expenditures of federal awards (SEFA) was not complete and accurate.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - The SEFA provided did not include all expenditures of the FWS and TRIO SSS programs and no expenditures of the AmeriCorps Vista program. In addition, the SEFA did not include the correct outstanding Federal Perkins Loan Balance as of the beginning of the fiscal year. As a result, the SEFA was overstated by $1,220,928. In addition, we noted the SEFA was not fully reconciled to the related federal expenditures and grant revenue as of June 30, 2023 resulting in an overstatement of federal revenue of $209,446.
Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The above errors have been corrected on the SEFA as of June 30, 2023.
Recommendation - The College should implement a process to ensure that the SEFA is prepared timely and that it is complete, accurate, and reconciled to the related federal revenue and expenditures. The College should also ensure all federal grants are appropriately classified as federal within the general ledger.
Views of Responsible Officials and Corrective Action Plan - The Albion College Business Office has established revised procedures for SEFA funds, in tandem with the Financial Aid Office, in which all Federal Awards and Grants will be reconciled on a quarterly basis, to be completed no later than the end of the first proceeding month of the quarter. The procedures create a dual- control process for the drawdown, recordation, and reporting of SEFA funds. Additionally, in FY24, the Perkins portfolio was divested. The Perkins Close- out will be part of the FY24 Single Audit.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Pell Grant Program ALN 84.063, Federal Direct Student Loan Program ALN 84.268, Federal Supplemental Educational Opportunity Grant (SEOG) Program ALN 84.007, Federal Work Study (FWS) Program ALN 84.033, and Federal Perkins Loan Program ALN 84.038; TRIO Student Support Service (SSS) Grant Program ALN 84.042; and Corporation for National and Community Service AmeriCorps Vista Grant Program ALN 94.006
Federal Award Identification Number and Year - 2022-2023
Finding Type - Significant deficiency
Repeat Finding - No
Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of federal expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502.
Condition - The schedule of expenditures of federal awards (SEFA) was not complete and accurate.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - The SEFA provided did not include all expenditures of the FWS and TRIO SSS programs and no expenditures of the AmeriCorps Vista program. In addition, the SEFA did not include the correct outstanding Federal Perkins Loan Balance as of the beginning of the fiscal year. As a result, the SEFA was overstated by $1,220,928. In addition, we noted the SEFA was not fully reconciled to the related federal expenditures and grant revenue as of June 30, 2023 resulting in an overstatement of federal revenue of $209,446.
Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The above errors have been corrected on the SEFA as of June 30, 2023.
Recommendation - The College should implement a process to ensure that the SEFA is prepared timely and that it is complete, accurate, and reconciled to the related federal revenue and expenditures. The College should also ensure all federal grants are appropriately classified as federal within the general ledger.
Views of Responsible Officials and Corrective Action Plan - The Albion College Business Office has established revised procedures for SEFA funds, in tandem with the Financial Aid Office, in which all Federal Awards and Grants will be reconciled on a quarterly basis, to be completed no later than the end of the first proceeding month of the quarter. The procedures create a dual- control process for the drawdown, recordation, and reporting of SEFA funds. Additionally, in FY24, the Perkins portfolio was divested. The Perkins Close- out will be part of the FY24 Single Audit.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Pell Grant Program ALN 84.063, Federal Direct Student Loan Program ALN 84.268, Federal Supplemental Educational Opportunity Grant (SEOG) Program ALN 84.007, Federal Work Study (FWS) Program ALN 84.033, and Federal Perkins Loan Program ALN 84.038; TRIO Student Support Service (SSS) Grant Program ALN 84.042; and Corporation for National and Community Service AmeriCorps Vista Grant Program ALN 94.006
Federal Award Identification Number and Year - 2022-2023
Finding Type - Significant deficiency
Repeat Finding - No
Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of federal expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502.
Condition - The schedule of expenditures of federal awards (SEFA) was not complete and accurate.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - The SEFA provided did not include all expenditures of the FWS and TRIO SSS programs and no expenditures of the AmeriCorps Vista program. In addition, the SEFA did not include the correct outstanding Federal Perkins Loan Balance as of the beginning of the fiscal year. As a result, the SEFA was overstated by $1,220,928. In addition, we noted the SEFA was not fully reconciled to the related federal expenditures and grant revenue as of June 30, 2023 resulting in an overstatement of federal revenue of $209,446.
Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The above errors have been corrected on the SEFA as of June 30, 2023.
Recommendation - The College should implement a process to ensure that the SEFA is prepared timely and that it is complete, accurate, and reconciled to the related federal revenue and expenditures. The College should also ensure all federal grants are appropriately classified as federal within the general ledger.
Views of Responsible Officials and Corrective Action Plan - The Albion College Business Office has established revised procedures for SEFA funds, in tandem with the Financial Aid Office, in which all Federal Awards and Grants will be reconciled on a quarterly basis, to be completed no later than the end of the first proceeding month of the quarter. The procedures create a dual- control process for the drawdown, recordation, and reporting of SEFA funds. Additionally, in FY24, the Perkins portfolio was divested. The Perkins Close- out will be part of the FY24 Single Audit.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Direct Student Loan Program ALN 84.268 and Federal Pell Grants ALN 84.063
Federal Award Identification Number and Year - Various
Finding Type - Significant deficiency and material noncompliance with laws and regulations
Repeat Finding - No
Criteria - Changes in a student’s status are required to be reported to the National Student Loan Data System (NSLDS) within 30 days of the change or included in a student status confirmation report sent to the NSLDS within 60 days of the status change (Pell, 34 CFR Section 690.83(b); Direct Loan, 34 CFR Section 685.309(b)).
Condition - The College did not properly update student enrollment information for campus record and program record in a timely manner due to not correcting errors in the enrollment roster uploads identified and returned by NSLDS.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - There were three errors identified that were attributed to this finding:
1. Of the 40 students tested, there were 4 students who attended the College during fiscal year 2023 that transferred out but were never reported as attending the College on the campus and program record.
2. Of the 40 students tested, there were 2 students that started attending the College in the Fall of 2021 and Fall of 2022 that were not reported as attending the College in the correct year. Both students were reported as not enrolling until the Fall of 2023 on the campus and program record.
3. Of the 40 students tested, there was 1 student that started attending the College in the Fall of 2022 that was not reported as enrolled on the campus and program record until April 2024.
All seven students showed on the error reports from NSLDS enrollment roster uploads as "NO SSN".
Cause and Effect - The College did not have a control in place to ensure that errors reports returned from NSLDS were corrected. As a result, certain student status changes including first time enrollment and transfers were not reported to NSLDS in a timely and accurate manner.
Recommendation - The College should implement a process between the Financial Aid Department and Registrar's Office to ensure enrollment information, including error reports from enrollment roster uploads to NSLDS, are updated timely and accurately.
Views of Responsible Officials and Planned Corrective Actions - The Registrar’s office in conjunction with the Financial Aid office will implement controls to ensure accurate and timely reporting to NSLDS for student enrollment status. The current cause of the untimely reporting is due to students missing social security numbers with our database which does not allow them to match to existing student in NSLDS. A report is being created through Argos (reporting software) that will be run on a monthly basis to be sure all students have the proper information needed for enrollment reporting. This report is being created through the registrar’s office and will work in conjunction with financial aid to get these records updated according with the accurate SS# for the students. Enrollment reporting is done through National Student Clearinghouse which returns error reports for a multitude of different reason one being SS#. The Assistant Registrar handles all enrollment reporting on a monthly basis. After each monthly submission the Registrar will be cross referencing the error reports to be sure that all necessary errors have been corrected and cleared. The Assistant Registrar will also be doing an analysis on the Argos report that pulls all data for the enrollment reporting submission to be sure that all data fields are still correct due to system changes on a consistent basis.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Pell Grant Program ALN 84.063, Federal Direct Student Loan Program ALN 84.268, Federal Supplemental Educational Opportunity Grant (SEOG) Program ALN 84.007, Federal Work Study (FWS) Program ALN 84.033, and Federal Perkins Loan Program ALN 84.038; TRIO Student Support Service (SSS) Grant Program ALN 84.042; and Corporation for National and Community Service AmeriCorps Vista Grant Program ALN 94.006
Federal Award Identification Number and Year - 2022-2023
Finding Type - Significant deficiency
Repeat Finding - No
Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of federal expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502.
Condition - The schedule of expenditures of federal awards (SEFA) was not complete and accurate.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - The SEFA provided did not include all expenditures of the FWS and TRIO SSS programs and no expenditures of the AmeriCorps Vista program. In addition, the SEFA did not include the correct outstanding Federal Perkins Loan Balance as of the beginning of the fiscal year. As a result, the SEFA was overstated by $1,220,928. In addition, we noted the SEFA was not fully reconciled to the related federal expenditures and grant revenue as of June 30, 2023 resulting in an overstatement of federal revenue of $209,446.
Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The above errors have been corrected on the SEFA as of June 30, 2023.
Recommendation - The College should implement a process to ensure that the SEFA is prepared timely and that it is complete, accurate, and reconciled to the related federal revenue and expenditures. The College should also ensure all federal grants are appropriately classified as federal within the general ledger.
Views of Responsible Officials and Corrective Action Plan - The Albion College Business Office has established revised procedures for SEFA funds, in tandem with the Financial Aid Office, in which all Federal Awards and Grants will be reconciled on a quarterly basis, to be completed no later than the end of the first proceeding month of the quarter. The procedures create a dual- control process for the drawdown, recordation, and reporting of SEFA funds. Additionally, in FY24, the Perkins portfolio was divested. The Perkins Close- out will be part of the FY24 Single Audit.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Direct Student Loan Program ALN 84.268 and Federal Pell Grants ALN 84.063
Federal Award Identification Number and Year - Various
Finding Type - Significant deficiency and material noncompliance with laws and regulations
Repeat Finding - No
Criteria - Changes in a student’s status are required to be reported to the National Student Loan Data System (NSLDS) within 30 days of the change or included in a student status confirmation report sent to the NSLDS within 60 days of the status change (Pell, 34 CFR Section 690.83(b); Direct Loan, 34 CFR Section 685.309(b)).
Condition - The College did not properly update student enrollment information for campus record and program record in a timely manner due to not correcting errors in the enrollment roster uploads identified and returned by NSLDS.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - There were three errors identified that were attributed to this finding:
1. Of the 40 students tested, there were 4 students who attended the College during fiscal year 2023 that transferred out but were never reported as attending the College on the campus and program record.
2. Of the 40 students tested, there were 2 students that started attending the College in the Fall of 2021 and Fall of 2022 that were not reported as attending the College in the correct year. Both students were reported as not enrolling until the Fall of 2023 on the campus and program record.
3. Of the 40 students tested, there was 1 student that started attending the College in the Fall of 2022 that was not reported as enrolled on the campus and program record until April 2024.
All seven students showed on the error reports from NSLDS enrollment roster uploads as "NO SSN".
Cause and Effect - The College did not have a control in place to ensure that errors reports returned from NSLDS were corrected. As a result, certain student status changes including first time enrollment and transfers were not reported to NSLDS in a timely and accurate manner.
Recommendation - The College should implement a process between the Financial Aid Department and Registrar's Office to ensure enrollment information, including error reports from enrollment roster uploads to NSLDS, are updated timely and accurately.
Views of Responsible Officials and Planned Corrective Actions - The Registrar’s office in conjunction with the Financial Aid office will implement controls to ensure accurate and timely reporting to NSLDS for student enrollment status. The current cause of the untimely reporting is due to students missing social security numbers with our database which does not allow them to match to existing student in NSLDS. A report is being created through Argos (reporting software) that will be run on a monthly basis to be sure all students have the proper information needed for enrollment reporting. This report is being created through the registrar’s office and will work in conjunction with financial aid to get these records updated according with the accurate SS# for the students. Enrollment reporting is done through National Student Clearinghouse which returns error reports for a multitude of different reason one being SS#. The Assistant Registrar handles all enrollment reporting on a monthly basis. After each monthly submission the Registrar will be cross referencing the error reports to be sure that all necessary errors have been corrected and cleared. The Assistant Registrar will also be doing an analysis on the Argos report that pulls all data for the enrollment reporting submission to be sure that all data fields are still correct due to system changes on a consistent basis.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Pell Grant Program ALN 84.063, Federal Direct Student Loan Program ALN 84.268, Federal Supplemental Educational Opportunity Grant (SEOG) Program ALN 84.007, Federal Work Study (FWS) Program ALN 84.033, and Federal Perkins Loan Program ALN 84.038; TRIO Student Support Service (SSS) Grant Program ALN 84.042; and Corporation for National and Community Service AmeriCorps Vista Grant Program ALN 94.006
Federal Award Identification Number and Year - 2022-2023
Finding Type - Significant deficiency
Repeat Finding - No
Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of federal expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502.
Condition - The schedule of expenditures of federal awards (SEFA) was not complete and accurate.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - The SEFA provided did not include all expenditures of the FWS and TRIO SSS programs and no expenditures of the AmeriCorps Vista program. In addition, the SEFA did not include the correct outstanding Federal Perkins Loan Balance as of the beginning of the fiscal year. As a result, the SEFA was overstated by $1,220,928. In addition, we noted the SEFA was not fully reconciled to the related federal expenditures and grant revenue as of June 30, 2023 resulting in an overstatement of federal revenue of $209,446.
Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The above errors have been corrected on the SEFA as of June 30, 2023.
Recommendation - The College should implement a process to ensure that the SEFA is prepared timely and that it is complete, accurate, and reconciled to the related federal revenue and expenditures. The College should also ensure all federal grants are appropriately classified as federal within the general ledger.
Views of Responsible Officials and Corrective Action Plan - The Albion College Business Office has established revised procedures for SEFA funds, in tandem with the Financial Aid Office, in which all Federal Awards and Grants will be reconciled on a quarterly basis, to be completed no later than the end of the first proceeding month of the quarter. The procedures create a dual- control process for the drawdown, recordation, and reporting of SEFA funds. Additionally, in FY24, the Perkins portfolio was divested. The Perkins Close- out will be part of the FY24 Single Audit.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Pell Grant Program ALN 84.063, Federal Direct Student Loan Program ALN 84.268, Federal Supplemental Educational Opportunity Grant (SEOG) Program ALN 84.007, Federal Work Study (FWS) Program ALN 84.033, and Federal Perkins Loan Program ALN 84.038; TRIO Student Support Service (SSS) Grant Program ALN 84.042; and Corporation for National and Community Service AmeriCorps Vista Grant Program ALN 94.006
Federal Award Identification Number and Year - 2022-2023
Finding Type - Significant deficiency
Repeat Finding - No
Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of federal expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502.
Condition - The schedule of expenditures of federal awards (SEFA) was not complete and accurate.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - The SEFA provided did not include all expenditures of the FWS and TRIO SSS programs and no expenditures of the AmeriCorps Vista program. In addition, the SEFA did not include the correct outstanding Federal Perkins Loan Balance as of the beginning of the fiscal year. As a result, the SEFA was overstated by $1,220,928. In addition, we noted the SEFA was not fully reconciled to the related federal expenditures and grant revenue as of June 30, 2023 resulting in an overstatement of federal revenue of $209,446.
Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The above errors have been corrected on the SEFA as of June 30, 2023.
Recommendation - The College should implement a process to ensure that the SEFA is prepared timely and that it is complete, accurate, and reconciled to the related federal revenue and expenditures. The College should also ensure all federal grants are appropriately classified as federal within the general ledger.
Views of Responsible Officials and Corrective Action Plan - The Albion College Business Office has established revised procedures for SEFA funds, in tandem with the Financial Aid Office, in which all Federal Awards and Grants will be reconciled on a quarterly basis, to be completed no later than the end of the first proceeding month of the quarter. The procedures create a dual- control process for the drawdown, recordation, and reporting of SEFA funds. Additionally, in FY24, the Perkins portfolio was divested. The Perkins Close- out will be part of the FY24 Single Audit.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Pell Grant Program ALN 84.063, Federal Direct Student Loan Program ALN 84.268, Federal Supplemental Educational Opportunity Grant (SEOG) Program ALN 84.007, Federal Work Study (FWS) Program ALN 84.033, and Federal Perkins Loan Program ALN 84.038; TRIO Student Support Service (SSS) Grant Program ALN 84.042; and Corporation for National and Community Service AmeriCorps Vista Grant Program ALN 94.006
Federal Award Identification Number and Year - 2022-2023
Finding Type - Significant deficiency
Repeat Finding - No
Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of federal expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502.
Condition - The schedule of expenditures of federal awards (SEFA) was not complete and accurate.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - The SEFA provided did not include all expenditures of the FWS and TRIO SSS programs and no expenditures of the AmeriCorps Vista program. In addition, the SEFA did not include the correct outstanding Federal Perkins Loan Balance as of the beginning of the fiscal year. As a result, the SEFA was overstated by $1,220,928. In addition, we noted the SEFA was not fully reconciled to the related federal expenditures and grant revenue as of June 30, 2023 resulting in an overstatement of federal revenue of $209,446.
Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The above errors have been corrected on the SEFA as of June 30, 2023.
Recommendation - The College should implement a process to ensure that the SEFA is prepared timely and that it is complete, accurate, and reconciled to the related federal revenue and expenditures. The College should also ensure all federal grants are appropriately classified as federal within the general ledger.
Views of Responsible Officials and Corrective Action Plan - The Albion College Business Office has established revised procedures for SEFA funds, in tandem with the Financial Aid Office, in which all Federal Awards and Grants will be reconciled on a quarterly basis, to be completed no later than the end of the first proceeding month of the quarter. The procedures create a dual- control process for the drawdown, recordation, and reporting of SEFA funds. Additionally, in FY24, the Perkins portfolio was divested. The Perkins Close- out will be part of the FY24 Single Audit.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Pell Grant Program ALN 84.063, Federal Direct Student Loan Program ALN 84.268, Federal Supplemental Educational Opportunity Grant (SEOG) Program ALN 84.007, Federal Work Study (FWS) Program ALN 84.033, and Federal Perkins Loan Program ALN 84.038; TRIO Student Support Service (SSS) Grant Program ALN 84.042; and Corporation for National and Community Service AmeriCorps Vista Grant Program ALN 94.006
Federal Award Identification Number and Year - 2022-2023
Finding Type - Significant deficiency
Repeat Finding - No
Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of federal expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502.
Condition - The schedule of expenditures of federal awards (SEFA) was not complete and accurate.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - The SEFA provided did not include all expenditures of the FWS and TRIO SSS programs and no expenditures of the AmeriCorps Vista program. In addition, the SEFA did not include the correct outstanding Federal Perkins Loan Balance as of the beginning of the fiscal year. As a result, the SEFA was overstated by $1,220,928. In addition, we noted the SEFA was not fully reconciled to the related federal expenditures and grant revenue as of June 30, 2023 resulting in an overstatement of federal revenue of $209,446.
Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The above errors have been corrected on the SEFA as of June 30, 2023.
Recommendation - The College should implement a process to ensure that the SEFA is prepared timely and that it is complete, accurate, and reconciled to the related federal revenue and expenditures. The College should also ensure all federal grants are appropriately classified as federal within the general ledger.
Views of Responsible Officials and Corrective Action Plan - The Albion College Business Office has established revised procedures for SEFA funds, in tandem with the Financial Aid Office, in which all Federal Awards and Grants will be reconciled on a quarterly basis, to be completed no later than the end of the first proceeding month of the quarter. The procedures create a dual- control process for the drawdown, recordation, and reporting of SEFA funds. Additionally, in FY24, the Perkins portfolio was divested. The Perkins Close- out will be part of the FY24 Single Audit.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Pell Grant Program ALN 84.063, Federal Direct Student Loan Program ALN 84.268, Federal Supplemental Educational Opportunity Grant (SEOG) Program ALN 84.007, Federal Work Study (FWS) Program ALN 84.033, and Federal Perkins Loan Program ALN 84.038; TRIO Student Support Service (SSS) Grant Program ALN 84.042; and Corporation for National and Community Service AmeriCorps Vista Grant Program ALN 94.006
Federal Award Identification Number and Year - 2022-2023
Finding Type - Significant deficiency
Repeat Finding - No
Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of federal expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502.
Condition - The schedule of expenditures of federal awards (SEFA) was not complete and accurate.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - The SEFA provided did not include all expenditures of the FWS and TRIO SSS programs and no expenditures of the AmeriCorps Vista program. In addition, the SEFA did not include the correct outstanding Federal Perkins Loan Balance as of the beginning of the fiscal year. As a result, the SEFA was overstated by $1,220,928. In addition, we noted the SEFA was not fully reconciled to the related federal expenditures and grant revenue as of June 30, 2023 resulting in an overstatement of federal revenue of $209,446.
Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The above errors have been corrected on the SEFA as of June 30, 2023.
Recommendation - The College should implement a process to ensure that the SEFA is prepared timely and that it is complete, accurate, and reconciled to the related federal revenue and expenditures. The College should also ensure all federal grants are appropriately classified as federal within the general ledger.
Views of Responsible Officials and Corrective Action Plan - The Albion College Business Office has established revised procedures for SEFA funds, in tandem with the Financial Aid Office, in which all Federal Awards and Grants will be reconciled on a quarterly basis, to be completed no later than the end of the first proceeding month of the quarter. The procedures create a dual- control process for the drawdown, recordation, and reporting of SEFA funds. Additionally, in FY24, the Perkins portfolio was divested. The Perkins Close- out will be part of the FY24 Single Audit.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Pell Grant Program ALN 84.063, Federal Direct Student Loan Program ALN 84.268, Federal Supplemental Educational Opportunity Grant (SEOG) Program ALN 84.007, Federal Work Study (FWS) Program ALN 84.033, and Federal Perkins Loan Program ALN 84.038; TRIO Student Support Service (SSS) Grant Program ALN 84.042; and Corporation for National and Community Service AmeriCorps Vista Grant Program ALN 94.006
Federal Award Identification Number and Year - 2022-2023
Finding Type - Significant deficiency
Repeat Finding - No
Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of federal expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502.
Condition - The schedule of expenditures of federal awards (SEFA) was not complete and accurate.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - The SEFA provided did not include all expenditures of the FWS and TRIO SSS programs and no expenditures of the AmeriCorps Vista program. In addition, the SEFA did not include the correct outstanding Federal Perkins Loan Balance as of the beginning of the fiscal year. As a result, the SEFA was overstated by $1,220,928. In addition, we noted the SEFA was not fully reconciled to the related federal expenditures and grant revenue as of June 30, 2023 resulting in an overstatement of federal revenue of $209,446.
Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The above errors have been corrected on the SEFA as of June 30, 2023.
Recommendation - The College should implement a process to ensure that the SEFA is prepared timely and that it is complete, accurate, and reconciled to the related federal revenue and expenditures. The College should also ensure all federal grants are appropriately classified as federal within the general ledger.
Views of Responsible Officials and Corrective Action Plan - The Albion College Business Office has established revised procedures for SEFA funds, in tandem with the Financial Aid Office, in which all Federal Awards and Grants will be reconciled on a quarterly basis, to be completed no later than the end of the first proceeding month of the quarter. The procedures create a dual- control process for the drawdown, recordation, and reporting of SEFA funds. Additionally, in FY24, the Perkins portfolio was divested. The Perkins Close- out will be part of the FY24 Single Audit.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Direct Student Loan Program ALN 84.268 and Federal Pell Grants ALN 84.063
Federal Award Identification Number and Year - Various
Finding Type - Significant deficiency and material noncompliance with laws and regulations
Repeat Finding - No
Criteria - Changes in a student’s status are required to be reported to the National Student Loan Data System (NSLDS) within 30 days of the change or included in a student status confirmation report sent to the NSLDS within 60 days of the status change (Pell, 34 CFR Section 690.83(b); Direct Loan, 34 CFR Section 685.309(b)).
Condition - The College did not properly update student enrollment information for campus record and program record in a timely manner due to not correcting errors in the enrollment roster uploads identified and returned by NSLDS.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - There were three errors identified that were attributed to this finding:
1. Of the 40 students tested, there were 4 students who attended the College during fiscal year 2023 that transferred out but were never reported as attending the College on the campus and program record.
2. Of the 40 students tested, there were 2 students that started attending the College in the Fall of 2021 and Fall of 2022 that were not reported as attending the College in the correct year. Both students were reported as not enrolling until the Fall of 2023 on the campus and program record.
3. Of the 40 students tested, there was 1 student that started attending the College in the Fall of 2022 that was not reported as enrolled on the campus and program record until April 2024.
All seven students showed on the error reports from NSLDS enrollment roster uploads as "NO SSN".
Cause and Effect - The College did not have a control in place to ensure that errors reports returned from NSLDS were corrected. As a result, certain student status changes including first time enrollment and transfers were not reported to NSLDS in a timely and accurate manner.
Recommendation - The College should implement a process between the Financial Aid Department and Registrar's Office to ensure enrollment information, including error reports from enrollment roster uploads to NSLDS, are updated timely and accurately.
Views of Responsible Officials and Planned Corrective Actions - The Registrar’s office in conjunction with the Financial Aid office will implement controls to ensure accurate and timely reporting to NSLDS for student enrollment status. The current cause of the untimely reporting is due to students missing social security numbers with our database which does not allow them to match to existing student in NSLDS. A report is being created through Argos (reporting software) that will be run on a monthly basis to be sure all students have the proper information needed for enrollment reporting. This report is being created through the registrar’s office and will work in conjunction with financial aid to get these records updated according with the accurate SS# for the students. Enrollment reporting is done through National Student Clearinghouse which returns error reports for a multitude of different reason one being SS#. The Assistant Registrar handles all enrollment reporting on a monthly basis. After each monthly submission the Registrar will be cross referencing the error reports to be sure that all necessary errors have been corrected and cleared. The Assistant Registrar will also be doing an analysis on the Argos report that pulls all data for the enrollment reporting submission to be sure that all data fields are still correct due to system changes on a consistent basis.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Pell Grant Program ALN 84.063, Federal Direct Student Loan Program ALN 84.268, Federal Supplemental Educational Opportunity Grant (SEOG) Program ALN 84.007, Federal Work Study (FWS) Program ALN 84.033, and Federal Perkins Loan Program ALN 84.038; TRIO Student Support Service (SSS) Grant Program ALN 84.042; and Corporation for National and Community Service AmeriCorps Vista Grant Program ALN 94.006
Federal Award Identification Number and Year - 2022-2023
Finding Type - Significant deficiency
Repeat Finding - No
Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of federal expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502.
Condition - The schedule of expenditures of federal awards (SEFA) was not complete and accurate.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - The SEFA provided did not include all expenditures of the FWS and TRIO SSS programs and no expenditures of the AmeriCorps Vista program. In addition, the SEFA did not include the correct outstanding Federal Perkins Loan Balance as of the beginning of the fiscal year. As a result, the SEFA was overstated by $1,220,928. In addition, we noted the SEFA was not fully reconciled to the related federal expenditures and grant revenue as of June 30, 2023 resulting in an overstatement of federal revenue of $209,446.
Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The above errors have been corrected on the SEFA as of June 30, 2023.
Recommendation - The College should implement a process to ensure that the SEFA is prepared timely and that it is complete, accurate, and reconciled to the related federal revenue and expenditures. The College should also ensure all federal grants are appropriately classified as federal within the general ledger.
Views of Responsible Officials and Corrective Action Plan - The Albion College Business Office has established revised procedures for SEFA funds, in tandem with the Financial Aid Office, in which all Federal Awards and Grants will be reconciled on a quarterly basis, to be completed no later than the end of the first proceeding month of the quarter. The procedures create a dual- control process for the drawdown, recordation, and reporting of SEFA funds. Additionally, in FY24, the Perkins portfolio was divested. The Perkins Close- out will be part of the FY24 Single Audit.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Direct Student Loan Program ALN 84.268 and Federal Pell Grants ALN 84.063
Federal Award Identification Number and Year - Various
Finding Type - Significant deficiency and material noncompliance with laws and regulations
Repeat Finding - No
Criteria - Changes in a student’s status are required to be reported to the National Student Loan Data System (NSLDS) within 30 days of the change or included in a student status confirmation report sent to the NSLDS within 60 days of the status change (Pell, 34 CFR Section 690.83(b); Direct Loan, 34 CFR Section 685.309(b)).
Condition - The College did not properly update student enrollment information for campus record and program record in a timely manner due to not correcting errors in the enrollment roster uploads identified and returned by NSLDS.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - There were three errors identified that were attributed to this finding:
1. Of the 40 students tested, there were 4 students who attended the College during fiscal year 2023 that transferred out but were never reported as attending the College on the campus and program record.
2. Of the 40 students tested, there were 2 students that started attending the College in the Fall of 2021 and Fall of 2022 that were not reported as attending the College in the correct year. Both students were reported as not enrolling until the Fall of 2023 on the campus and program record.
3. Of the 40 students tested, there was 1 student that started attending the College in the Fall of 2022 that was not reported as enrolled on the campus and program record until April 2024.
All seven students showed on the error reports from NSLDS enrollment roster uploads as "NO SSN".
Cause and Effect - The College did not have a control in place to ensure that errors reports returned from NSLDS were corrected. As a result, certain student status changes including first time enrollment and transfers were not reported to NSLDS in a timely and accurate manner.
Recommendation - The College should implement a process between the Financial Aid Department and Registrar's Office to ensure enrollment information, including error reports from enrollment roster uploads to NSLDS, are updated timely and accurately.
Views of Responsible Officials and Planned Corrective Actions - The Registrar’s office in conjunction with the Financial Aid office will implement controls to ensure accurate and timely reporting to NSLDS for student enrollment status. The current cause of the untimely reporting is due to students missing social security numbers with our database which does not allow them to match to existing student in NSLDS. A report is being created through Argos (reporting software) that will be run on a monthly basis to be sure all students have the proper information needed for enrollment reporting. This report is being created through the registrar’s office and will work in conjunction with financial aid to get these records updated according with the accurate SS# for the students. Enrollment reporting is done through National Student Clearinghouse which returns error reports for a multitude of different reason one being SS#. The Assistant Registrar handles all enrollment reporting on a monthly basis. After each monthly submission the Registrar will be cross referencing the error reports to be sure that all necessary errors have been corrected and cleared. The Assistant Registrar will also be doing an analysis on the Argos report that pulls all data for the enrollment reporting submission to be sure that all data fields are still correct due to system changes on a consistent basis.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Pell Grant Program ALN 84.063, Federal Direct Student Loan Program ALN 84.268, Federal Supplemental Educational Opportunity Grant (SEOG) Program ALN 84.007, Federal Work Study (FWS) Program ALN 84.033, and Federal Perkins Loan Program ALN 84.038; TRIO Student Support Service (SSS) Grant Program ALN 84.042; and Corporation for National and Community Service AmeriCorps Vista Grant Program ALN 94.006
Federal Award Identification Number and Year - 2022-2023
Finding Type - Significant deficiency
Repeat Finding - No
Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of federal expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502.
Condition - The schedule of expenditures of federal awards (SEFA) was not complete and accurate.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - The SEFA provided did not include all expenditures of the FWS and TRIO SSS programs and no expenditures of the AmeriCorps Vista program. In addition, the SEFA did not include the correct outstanding Federal Perkins Loan Balance as of the beginning of the fiscal year. As a result, the SEFA was overstated by $1,220,928. In addition, we noted the SEFA was not fully reconciled to the related federal expenditures and grant revenue as of June 30, 2023 resulting in an overstatement of federal revenue of $209,446.
Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The above errors have been corrected on the SEFA as of June 30, 2023.
Recommendation - The College should implement a process to ensure that the SEFA is prepared timely and that it is complete, accurate, and reconciled to the related federal revenue and expenditures. The College should also ensure all federal grants are appropriately classified as federal within the general ledger.
Views of Responsible Officials and Corrective Action Plan - The Albion College Business Office has established revised procedures for SEFA funds, in tandem with the Financial Aid Office, in which all Federal Awards and Grants will be reconciled on a quarterly basis, to be completed no later than the end of the first proceeding month of the quarter. The procedures create a dual- control process for the drawdown, recordation, and reporting of SEFA funds. Additionally, in FY24, the Perkins portfolio was divested. The Perkins Close- out will be part of the FY24 Single Audit.
Assistance Listing, Federal Agency, and Program Name - Student Financial Assistance Cluster - Federal Pell Grant Program ALN 84.063, Federal Direct Student Loan Program ALN 84.268, Federal Supplemental Educational Opportunity Grant (SEOG) Program ALN 84.007, Federal Work Study (FWS) Program ALN 84.033, and Federal Perkins Loan Program ALN 84.038; TRIO Student Support Service (SSS) Grant Program ALN 84.042; and Corporation for National and Community Service AmeriCorps Vista Grant Program ALN 94.006
Federal Award Identification Number and Year - 2022-2023
Finding Type - Significant deficiency
Repeat Finding - No
Criteria - Per 2 CFR 200.510(b) - The auditee must also prepare a schedule of federal expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502.
Condition - The schedule of expenditures of federal awards (SEFA) was not complete and accurate.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - The SEFA provided did not include all expenditures of the FWS and TRIO SSS programs and no expenditures of the AmeriCorps Vista program. In addition, the SEFA did not include the correct outstanding Federal Perkins Loan Balance as of the beginning of the fiscal year. As a result, the SEFA was overstated by $1,220,928. In addition, we noted the SEFA was not fully reconciled to the related federal expenditures and grant revenue as of June 30, 2023 resulting in an overstatement of federal revenue of $209,446.
Cause and Effect - Controls in place did not ensure the SEFA was completed in a timely manner and that it was complete and accurate. The above errors have been corrected on the SEFA as of June 30, 2023.
Recommendation - The College should implement a process to ensure that the SEFA is prepared timely and that it is complete, accurate, and reconciled to the related federal revenue and expenditures. The College should also ensure all federal grants are appropriately classified as federal within the general ledger.
Views of Responsible Officials and Corrective Action Plan - The Albion College Business Office has established revised procedures for SEFA funds, in tandem with the Financial Aid Office, in which all Federal Awards and Grants will be reconciled on a quarterly basis, to be completed no later than the end of the first proceeding month of the quarter. The procedures create a dual- control process for the drawdown, recordation, and reporting of SEFA funds. Additionally, in FY24, the Perkins portfolio was divested. The Perkins Close- out will be part of the FY24 Single Audit.