Audit 332323

FY End
2024-06-30
Total Expended
$8.07M
Findings
2
Programs
14
Year: 2024 Accepted: 2024-12-13
Auditor: Wipfli LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
514149 2024-001 - - N
1090591 2024-001 - - N

Programs

ALN Program Spent Major Findings
84.063 Federal Pell Grant Program $3.41M Yes 1
84.268 Federal Direct Student Loans $1.22M Yes 0
11.307 Economic Adjustment Assistance $1.07M - 0
93.575 Child Care and Development Block Grant $429,746 Yes 0
84.042 Trio_student Support Services $387,112 - 0
84.044 Trio_talent Search $385,144 - 0
84.047 Trio_upward Bound $222,621 - 0
84.048 Career and Technical Education -- Basic Grants to States $171,087 - 0
94.002 Retired and Senior Volunteer Program $152,368 - 0
84.002 Adult Education - Basic Grants to States $103,169 - 0
84.007 Federal Supplemental Educational Opportunity Grants $72,899 Yes 0
84.033 Federal Work-Study Program $52,920 Yes 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $20,272 - 0
17.259 Wioa Youth Activities $18,386 - 0

Contacts

Name Title Type
T7WMLBN6EJM3 Josh Welker Auditee
2176414200 Sara McKenna Auditor
No contacts on file

Notes to SEFA

Title: General Accounting Policies: Expenditures reported on the Schedule are reported on the 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. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: Y Rate Explanation: John Wood Community College District #539 has elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of John Wood Community College District #539 under programs of the federal government for the year ended June 30, 2024. The information in this schedule is presented in accordance with requirements of the Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (“Uniform Guidance”). Because the schedule presents only a selected portion of the operations of John Wood Community College District #539, it is not intended to and does not present the financial position, changes in net position or cash flows of John Wood Community College District #539.
Title: Loan Program Accounting Policies: Expenditures reported on the Schedule are reported on the 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. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: Y Rate Explanation: John Wood Community College District #539 has elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. For the year ended June 30, 2024, the College acted a pass-through agency for Federal Direct Loans (subsidized and unsubsidized) to students in the amount of $1,219,212.
Title: Non-Cash Assistance Accounting Policies: Expenditures reported on the Schedule are reported on the 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. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: Y Rate Explanation: John Wood Community College District #539 has elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The College did not expend any federal awards in the form of non-cash assistance during the year ended June 30, 2024.
Title: Other Federal Award Information Accounting Policies: Expenditures reported on the Schedule are reported on the 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. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: Y Rate Explanation: John Wood Community College District #539 has elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The College did not receive or administer any insurance or loan guarantees during fiscal year ended June 30, 2024.

Finding Details

The examination disclosed 6 students, out of 25 student files who had an enrollment status change tested, in which their enrollment status was inaccurately reported. Student A – The student's last day of attendance was 9/6/23 but the effective date of withdraw was reported to NSLDS as 9/22/23. Student B - The student's last day of attendance was 3/1/24 but the effective date of withdraw was reported to NSLDS as 4/8/24. Student C – The student's last day of attendance was 4/12/24 but the effective date of withdraw was reported to NSLDS as 5/15/24. Student D – The student's last day of attendance was 10/16/23 but the effective date of withdraw was reported to NSLDS as 12/15/23. Student E – The student's graduation date according to the institution was 5/16/24 but the effective date of graduation was reported to NSLDS as 5/9/24. Student F – The certification date for the status update was on 9/20/24, 196 days after the student’s effective date of withdraw.
The examination disclosed 6 students, out of 25 student files who had an enrollment status change tested, in which their enrollment status was inaccurately reported. Student A – The student's last day of attendance was 9/6/23 but the effective date of withdraw was reported to NSLDS as 9/22/23. Student B - The student's last day of attendance was 3/1/24 but the effective date of withdraw was reported to NSLDS as 4/8/24. Student C – The student's last day of attendance was 4/12/24 but the effective date of withdraw was reported to NSLDS as 5/15/24. Student D – The student's last day of attendance was 10/16/23 but the effective date of withdraw was reported to NSLDS as 12/15/23. Student E – The student's graduation date according to the institution was 5/16/24 but the effective date of graduation was reported to NSLDS as 5/9/24. Student F – The certification date for the status update was on 9/20/24, 196 days after the student’s effective date of withdraw.