Audit 298543

FY End
2023-06-30
Total Expended
$17.09M
Findings
4
Programs
23
Organization: Calvin University (MI)
Year: 2023 Accepted: 2024-03-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
386133 2023-001 Significant Deficiency - N
386134 2023-001 Significant Deficiency - N
962575 2023-001 Significant Deficiency - N
962576 2023-001 Significant Deficiency - N

Programs

ALN Program Spent Major Findings
84.268 Federal Direct Student Loans $10.80M Yes 1
84.063 Federal Pell Grant Program $2.13M Yes 1
84.038 Federal Perkins Loans $991,897 Yes 0
84.007 Federal Supplemental Educational Opportunity Grants $526,448 Yes 0
84.033 Federal Work-Study Program $422,095 Yes 0
66.460 Nonpoint Source Implementation Grants $286,704 - 0
66.605 Performance Partnership Grants $269,240 - 0
84.407 Transition Programs for Students with Intellectual Disabilities Into Higher Education $239,884 - 0
45.162 Promotion of the Humanities_teaching and Learning Resources and Curriculum Development $231,705 - 0
47.076 Education and Human Resources $186,492 - 0
84.042 Trio_student Support Services $172,531 - 0
93.855 Allergy, Immunology and Transplantation Research $133,562 - 0
16.525 Grants to Reduce Domestic Violence, Dating Violence, Sexual Assault, and Stalking on Campus $66,444 - 0
47.041 Engineering $63,530 - 0
15.662 Great Lakes Restoration $55,262 - 0
84.016 Undergraduate International Studies and Foreign Language Programs $51,432 - 0
47.074 Biological Sciences $49,111 - 0
47.049 Mathematical and Physical Sciences $29,120 - 0
84.379 Teacher Education Assistance for College and Higher Education Grants (teach Grants) $26,404 Yes 0
93.136 Injury Prevention and Control Research and State and Community Based Programs $23,867 - 0
12.300 Basic and Applied Scientific Research $17,129 - 0
45.025 Promotion of the Arts_partnership Agreements $9,206 - 0
43.008 Education $5,878 - 0

Contacts

Name Title Type
NNLQK7LNGL93 Jillisa Teitsma Auditee
6165266813 Brian Greko Auditor
No contacts on file

Notes to SEFA

Title: Adjustments and Transfers Accounting Policies: The accompanying schedule of expenditures of federal awards (the "Schedule") includes the federal grant activity of Calvin University (the "University") under programs of the federal government for the year ended June 30, 2023. The information in the 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 (the "Uniform Guidance"). Because the Schedule presents only a selected portion of the operations of the University, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the University. Expenditures reported in the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. The passthrough entity identifying numbers are presented where available. The University has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs, as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The Organization has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs, as allowed under the Uniform Guidance. As allowable and in accordance with federal regulations, the University carried forward $38,448 of the 2022-2023 Federal Supplemental Education Opportunity Grant (SEOG) Program (ALN 84.007) and $34,226 of the 2022-2023 Federal Work-Study (FWS) Program (ALN 84.033) award funds to provide aid to students in 2023-2024. The University also carried forward $45,132 of the 2021-2022 Federal Supplemental Education Opportunity Grant Program that was spent in 2022-2023. Additionally, the University transferred $30,000 of FWS program funds to the SEOG program during 2022-2023.
Title: Loans Balances Accounting Policies: The accompanying schedule of expenditures of federal awards (the "Schedule") includes the federal grant activity of Calvin University (the "University") under programs of the federal government for the year ended June 30, 2023. The information in the 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 (the "Uniform Guidance"). Because the Schedule presents only a selected portion of the operations of the University, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the University. Expenditures reported in the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. The passthrough entity identifying numbers are presented where available. The University has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs, as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The Organization has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs, as allowed under the Uniform Guidance. Loans outstanding at the beginning of the year, loans made during the year, and the administrative cost allowance claimed are included in the federal expenditures presented in the schedule of expenditures of federal awards. The balances of loans outstanding consist solely of the Perkins Loan program, which had an outstanding loan balance of $685,657 at June 30, 2023.

Finding Details

Assistance Listing Number, 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 Pass-through Entity - None Finding Type - Significant deficiency 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 University did not report the status changes of certain students to the NSLDS in an accurate and timely manner during the fiscal year. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - There were three errors identified that were attributed to this finding. Of the 40 students tested, 2 students' status changes were not received by NSLDS, and 1 student's status change was reported as a withdrawal instead of a leave of absence. Cause and Effect - The University did not have a control in place to ensure all enrollment changes are reported timely and accurately to the NSLDS. As a result, certain student status changes were not reported to the NSLDS in a timely and accurate manner. Recommendation - The University should implement controls to ensure student status changes are reported accurately and timely to the NSLDS. These controls should include a thorough review of the enrollment rosters prior to reporting to the NSLDS. Views of Responsible Officials and Corrective Action Plan - The University agrees with the condition of the finding. The University submits student rosters to NSC every 30 days, certainly meeting federal regulations. Academic year 2022-2023 was no different regarding our timely submissions of data. What was different, however, was the use of a brand new campuswide software system (Workday) for that academic year. During the academic year, the University identified SSN values brought into the Workday system from a students' ISIR did not populate the SSN field used to submit data to NSC. An internal report was created to identify students needing an edit to their personal data. This was the immediate and internal solution to fix the problem. During the same time frame, Workday identified the same problem and created a systemwide fix resolving this problem. The software update was released in March 2023 and became immediately active. Documentation of the Workday software implementation is available if desired.
Assistance Listing Number, 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 Pass-through Entity - None Finding Type - Significant deficiency 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 University did not report the status changes of certain students to the NSLDS in an accurate and timely manner during the fiscal year. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - There were three errors identified that were attributed to this finding. Of the 40 students tested, 2 students' status changes were not received by NSLDS, and 1 student's status change was reported as a withdrawal instead of a leave of absence. Cause and Effect - The University did not have a control in place to ensure all enrollment changes are reported timely and accurately to the NSLDS. As a result, certain student status changes were not reported to the NSLDS in a timely and accurate manner. Recommendation - The University should implement controls to ensure student status changes are reported accurately and timely to the NSLDS. These controls should include a thorough review of the enrollment rosters prior to reporting to the NSLDS. Views of Responsible Officials and Corrective Action Plan - The University agrees with the condition of the finding. The University submits student rosters to NSC every 30 days, certainly meeting federal regulations. Academic year 2022-2023 was no different regarding our timely submissions of data. What was different, however, was the use of a brand new campuswide software system (Workday) for that academic year. During the academic year, the University identified SSN values brought into the Workday system from a students' ISIR did not populate the SSN field used to submit data to NSC. An internal report was created to identify students needing an edit to their personal data. This was the immediate and internal solution to fix the problem. During the same time frame, Workday identified the same problem and created a systemwide fix resolving this problem. The software update was released in March 2023 and became immediately active. Documentation of the Workday software implementation is available if desired.
Assistance Listing Number, 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 Pass-through Entity - None Finding Type - Significant deficiency 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 University did not report the status changes of certain students to the NSLDS in an accurate and timely manner during the fiscal year. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - There were three errors identified that were attributed to this finding. Of the 40 students tested, 2 students' status changes were not received by NSLDS, and 1 student's status change was reported as a withdrawal instead of a leave of absence. Cause and Effect - The University did not have a control in place to ensure all enrollment changes are reported timely and accurately to the NSLDS. As a result, certain student status changes were not reported to the NSLDS in a timely and accurate manner. Recommendation - The University should implement controls to ensure student status changes are reported accurately and timely to the NSLDS. These controls should include a thorough review of the enrollment rosters prior to reporting to the NSLDS. Views of Responsible Officials and Corrective Action Plan - The University agrees with the condition of the finding. The University submits student rosters to NSC every 30 days, certainly meeting federal regulations. Academic year 2022-2023 was no different regarding our timely submissions of data. What was different, however, was the use of a brand new campuswide software system (Workday) for that academic year. During the academic year, the University identified SSN values brought into the Workday system from a students' ISIR did not populate the SSN field used to submit data to NSC. An internal report was created to identify students needing an edit to their personal data. This was the immediate and internal solution to fix the problem. During the same time frame, Workday identified the same problem and created a systemwide fix resolving this problem. The software update was released in March 2023 and became immediately active. Documentation of the Workday software implementation is available if desired.
Assistance Listing Number, 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 Pass-through Entity - None Finding Type - Significant deficiency 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 University did not report the status changes of certain students to the NSLDS in an accurate and timely manner during the fiscal year. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - There were three errors identified that were attributed to this finding. Of the 40 students tested, 2 students' status changes were not received by NSLDS, and 1 student's status change was reported as a withdrawal instead of a leave of absence. Cause and Effect - The University did not have a control in place to ensure all enrollment changes are reported timely and accurately to the NSLDS. As a result, certain student status changes were not reported to the NSLDS in a timely and accurate manner. Recommendation - The University should implement controls to ensure student status changes are reported accurately and timely to the NSLDS. These controls should include a thorough review of the enrollment rosters prior to reporting to the NSLDS. Views of Responsible Officials and Corrective Action Plan - The University agrees with the condition of the finding. The University submits student rosters to NSC every 30 days, certainly meeting federal regulations. Academic year 2022-2023 was no different regarding our timely submissions of data. What was different, however, was the use of a brand new campuswide software system (Workday) for that academic year. During the academic year, the University identified SSN values brought into the Workday system from a students' ISIR did not populate the SSN field used to submit data to NSC. An internal report was created to identify students needing an edit to their personal data. This was the immediate and internal solution to fix the problem. During the same time frame, Workday identified the same problem and created a systemwide fix resolving this problem. The software update was released in March 2023 and became immediately active. Documentation of the Workday software implementation is available if desired.