Audit 48612

FY End
2022-06-30
Total Expended
$10.26M
Findings
2
Programs
11
Organization: Ripon College (WI)
Year: 2022 Accepted: 2023-02-23

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
43783 2022-002 - - L
620225 2022-002 - - L

Programs

ALN Program Spent Major Findings
84.268 Federal Direct Student Loans $4.79M Yes 0
84.038 Federal Perkins Loan Program $1.86M Yes 0
84.063 Federal Pell Grant Program $1.35M Yes 0
84.425 Education Stabilization Fund $1.22M Yes 0
84.042 Trio_student Support Services $227,674 Yes 0
84.007 Federal Supplemental Educational Opportunity Grants $164,306 Yes 0
84.033 Federal Work-Study Program $132,090 Yes 0
47.049 Mathematical and Physical Sciences $63,507 - 0
47.076 Education and Human Resources $32,627 - 0
84.334 Gaining Early Awareness and Readiness for Undergraduate Programs $2,000 - 0
84.063 Federal Pell Aca Payment $1,450 Yes 0

Contacts

Name Title Type
HHASQQ5NK611 Dennis Bangart Auditee
9207488310 Ryan Lay Auditor
No contacts on file

Notes to SEFA

Title: Federal Perkins Loan Program Accounting Policies: Expenditures reported on the Schedules are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedules represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: The College has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. The Federal Perkins Loan Program is administered directly by the College, and balances and transactions relating to these programs are included in the College's 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 Schedules. The balance of loans outstanding at June 30, 2022 totaled $1,301,425. The Perkins Loan Program is ending and no additional loans were granted in the year ended June 30, 2022.
Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedules are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedules represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: The College has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying schedules of expenditures of federal and state awards (the Schedules) includes the federal and state award activity of Ripon College (the College) under programs of the federal and state government for the year ended June 30, 2022. The information in these Schedules 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 Schedules present only a selected portion of the operations of the College, they are not intended to and do not present the financial position, changes in net assets or cash flows of the College.
Title: Federal Pell Grant Accounting Policies: Expenditures reported on the Schedules are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedules represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: The College has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. The College received federal Pell grants under the Administrative Cost Allowance (ACA), in addition to the grant program. Below is a summary of the total funding under assistance listing number 84.063. Federal Pell Grant Program: $1,345,828. Federal Pell ACA Payment: $1,450. Total ALN 84.063: $1,347,278.

Finding Details

2022-002 Agencies: U.S Department of Education Federal Assistance Listing Number: 84.425F Programs: COVID-19-0 Education Stablization Fund, Institutional Criteria: The College is required to post its quarterly institutional funds report on the College?s website no later than 10 days after the end of each calendar quarter (October 10, January 10, April 10, July 10). Statement of Condition: The College?s report for the first calendar quarter of 2022 was not posted to the College?s website within the 10 day requirement. Questioned Costs: The amount of questioned costs could not be determined. Context: The quarterly institutional funds report was not posted prior to the due date. Cause: The first calendar quarter report was not posted by the required due date and was posted in conjuction with the second calendar quarter?s report. Effect: The College was not in compliance with the reporting requirements of the contracts. Recommendation: We recommend management track all reporting due dates related to the contracts and establish policies and timelines within the College?s accounting and finance team to ensure that all reports are submitted by the required due dates. The tracking system used should be available for all necessary employees and training should be included with onboarding of employees. Management Response: The College agrees and concurs with the audit finding. The Business office will review and post any new quarterly HEERF information to the College?s website within the 10 day required time. The College has not received or used HEERF funding in fiscal year 2023. The final quarterly HEERF report was for June 30, 2022.
2022-002 Agencies: U.S Department of Education Federal Assistance Listing Number: 84.425F Programs: COVID-19-0 Education Stablization Fund, Institutional Criteria: The College is required to post its quarterly institutional funds report on the College?s website no later than 10 days after the end of each calendar quarter (October 10, January 10, April 10, July 10). Statement of Condition: The College?s report for the first calendar quarter of 2022 was not posted to the College?s website within the 10 day requirement. Questioned Costs: The amount of questioned costs could not be determined. Context: The quarterly institutional funds report was not posted prior to the due date. Cause: The first calendar quarter report was not posted by the required due date and was posted in conjuction with the second calendar quarter?s report. Effect: The College was not in compliance with the reporting requirements of the contracts. Recommendation: We recommend management track all reporting due dates related to the contracts and establish policies and timelines within the College?s accounting and finance team to ensure that all reports are submitted by the required due dates. The tracking system used should be available for all necessary employees and training should be included with onboarding of employees. Management Response: The College agrees and concurs with the audit finding. The Business office will review and post any new quarterly HEERF information to the College?s website within the 10 day required time. The College has not received or used HEERF funding in fiscal year 2023. The final quarterly HEERF report was for June 30, 2022.