Audit 332131

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

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
513910 2024-003 Significant Deficiency - N
1090352 2024-003 Significant Deficiency - N

Contacts

Name Title Type
TN54X3XMNYZ8 Noah Lamb Auditee
3092688100 Sara McKenna Auditor
No contacts on file

Notes to SEFA

Title: Note 1: 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: N Rate Explanation: Heartland Community College District 540 has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The College has a federally negotiated rate with the US Department of Health and Human Services of 20.50%. The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of Heartland Community College District 540 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 Heartland Community College District 540, it is not intended to and does not present the financial position, changes in net position or cash flows of Heartland Community College District 540.
Title: Note 4: 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: N Rate Explanation: Heartland Community College District 540 has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The College has a federally negotiated rate with the US Department of Health and Human Services of 20.50%. 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,890,702.
Title: Note 5: 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: N Rate Explanation: Heartland Community College District 540 has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The College has a federally negotiated rate with the US Department of Health and Human Services of 20.50%. The College did not expend any federal awards in the form of non-cash assistance during the year ended June 30, 2024.
Title: Note 6: 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: N Rate Explanation: Heartland Community College District 540 has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The College has a federally negotiated rate with the US Department of Health and Human Services of 20.50%. The College did not receive or administer any insurance or loan guarantees during fiscal year ended June 30, 2024.

Finding Details

Criteria or Specific Requirement: The College must accurately report the student's effective date of their out of school status. Condition: The examination disclosed 4 students, out of 17 student files tested, in which the verification was performed inaccurately. Student A was selected for V1 verification. The taxes paid on the ISIR reflect a dollar amount of $0, but according to the 1040 taxes paid should have been report as $1,765. Student B was selected for V4 verification. The V4 form was not dated by the financial aid official, or the driver's license was not annotated with the date it was received to verify the student signed in front of the financial aid official. Student C was selected for V5 verification. The V5 form was not dated by the financial aid official, or the driver's license was not annotated with the date it was received to verify the dtudent signed in front of the financial aid official. Student D was selected for V4 verification. The V4 form was not dated by the student and the financial aid official, or the driver's license was not annotated with the date it was received to verify the student signed in front of the financial aid official. Context: In planning and performing our audit procedures, we obtained an understanding of the design and implementation of internal controls related to the College's student financial aid grants. Additionally, we performed substantive audit procedures to obtain audit evidence verifying the completeness, validity, and accuracy of the student financail aid grants. Questioned Costs: $0 Effect: The student's interest rates for the repayment of the direct loans may be effected. Cause: An oversight was made by the institution. Repeat: No Auditor's Recommendation: We recommend that the institution update the student's effective date after the error was identified. View of Responsible Officials: Management acknowledges the finding and has prepared a corrective action plan.
Criteria or Specific Requirement: The College must accurately report the student's effective date of their out of school status. Condition: The examination disclosed 4 students, out of 17 student files tested, in which the verification was performed inaccurately. Student A was selected for V1 verification. The taxes paid on the ISIR reflect a dollar amount of $0, but according to the 1040 taxes paid should have been report as $1,765. Student B was selected for V4 verification. The V4 form was not dated by the financial aid official, or the driver's license was not annotated with the date it was received to verify the student signed in front of the financial aid official. Student C was selected for V5 verification. The V5 form was not dated by the financial aid official, or the driver's license was not annotated with the date it was received to verify the dtudent signed in front of the financial aid official. Student D was selected for V4 verification. The V4 form was not dated by the student and the financial aid official, or the driver's license was not annotated with the date it was received to verify the student signed in front of the financial aid official. Context: In planning and performing our audit procedures, we obtained an understanding of the design and implementation of internal controls related to the College's student financial aid grants. Additionally, we performed substantive audit procedures to obtain audit evidence verifying the completeness, validity, and accuracy of the student financail aid grants. Questioned Costs: $0 Effect: The student's interest rates for the repayment of the direct loans may be effected. Cause: An oversight was made by the institution. Repeat: No Auditor's Recommendation: We recommend that the institution update the student's effective date after the error was identified. View of Responsible Officials: Management acknowledges the finding and has prepared a corrective action plan.