Audit 1231

FY End
2023-06-30
Total Expended
$16.44M
Findings
4
Programs
17
Organization: Lake Land College (IL)
Year: 2023 Accepted: 2023-10-25
Auditor: Martin Hood LLC

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
657 2023-002 Material Weakness - I
658 2023-002 Material Weakness - I
577099 2023-002 Material Weakness - I
577100 2023-002 Material Weakness - I

Programs

ALN Program Spent Major Findings
84.063 Federal Pell Grant Program $4.89M Yes 0
84.268 Federal Direct Student Loans $1.03M Yes 0
17.258 Wia Adult Program $895,773 - 0
17.259 Wia Youth Activities $638,706 - 0
84.048 Career and Technical Education -- Basic Grants to States $421,964 - 0
84.044 Trio_talent Search $335,222 - 0
93.575 Child Care and Development Block Grant $313,431 Yes 0
84.002 Adult Education - Basic Grants to States $269,641 - 0
84.042 Trio_student Support Services $259,510 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $205,645 - 0
17.278 Wia Dislocated Worker Formula Grants $143,442 - 0
84.007 Federal Supplemental Educational Opportunity Grants $106,100 Yes 0
84.425 Education Stabilization Fund $92,478 Yes 0
64.028 Post-9/11 Veterans Educational Assistance $57,911 - 0
17.245 Trade Adjustment Assistance $30,174 - 0
84.033 Federal Work-Study Program $23,818 Yes 0
47.076 Education and Human Resources $5,078 - 0

Contacts

Name Title Type
CXUHYLV7VZN7 Madge Shoot Auditee
2172345375 Jeff Livesay Auditor
No contacts on file

Notes to SEFA

Title: Summary of Significant Accounting Policies Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (Schedule 33) includes the federal grant activity of Lake Land College (the College) for the year ended June 30, 2023. The information in this 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 (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements of the College, which are presented in conformity with accounting principles generally accepted in the United States of America. The College did not use the 10 percent de minimis indirect cost rate. De Minimis Rate Used: N Rate Explanation: The College did not use the 10 percent de minimis indirect cost rate. The accompanying Schedule of Expenditures of Federal Awards (Schedule 33) includes the federal grant activity of Lake Land College (the College) for the year ended June 30, 2023. The information in this 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 (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements of the College, which are presented in conformity with accounting principles generally accepted in the United States of America. The College did not use the 10 percent de minimis indirect cost rate.
Title: Basis of Accounting Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (Schedule 33) includes the federal grant activity of Lake Land College (the College) for the year ended June 30, 2023. The information in this 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 (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements of the College, which are presented in conformity with accounting principles generally accepted in the United States of America. The College did not use the 10 percent de minimis indirect cost rate. De Minimis Rate Used: N Rate Explanation: The College did not use the 10 percent de minimis indirect cost rate. The schedule has been prepared on the accrual basis of accounting. Expenditures include all accounts payable representing liabilities for goods and services received as of June 30, 2023.
Title: Property and Equipment Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (Schedule 33) includes the federal grant activity of Lake Land College (the College) for the year ended June 30, 2023. The information in this 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 (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements of the College, which are presented in conformity with accounting principles generally accepted in the United States of America. The College did not use the 10 percent de minimis indirect cost rate. De Minimis Rate Used: N Rate Explanation: The College did not use the 10 percent de minimis indirect cost rate. Property and equipment purchases that are presented as expenditures in the schedule may be capitalized by the College, if applicable.

Finding Details

Criteria Under Uniform Guidance, management of the College is responsible for establishing and maintaining effective internal control over compliance requirements that have a direct and material effect on the College's federal programs. Condition The internal controls established for the Higher Education Emergency Relief Fund (HEERF) were not effective in selecting the proper procurement method. Population of Items Tested Expenditures for which procurement was tested during our audit procedures under the HEERF Institutional fund totaled $1,372,042 and expenditures tested under the Strengthening Institutions Fund portion totaled $290,176. Cause of Condition The College's policies and procedures allow for exceptions to procurement methods which are not allowed under federal regulations. Effects of Condition The College did not procure goods and services under the proper federal methodology for certain purchases during the fiscal year. Questioned Costs No questioned costs over $25,000. Context Our audit procedures identified $488,078 of expenditures that the College did not obtain quotes or bids as required by federal procurement policies. Repeat Finding This finding does not repeat a previous finding. Auditor's Recommendations The College should amend the policies and procedures to only allow for specific exceptions using federal funds as allowed by federal procurement regulations. View of Responsible Official Based on the guidance from Robbins Schwartz, the purchase may be made only after receiving an adequate number of competitive quotes from qualified sources, unless it is a nonexempt purchase in an amount between $25,000 and $250,000. In such cases, biding requirements under board policy 10.22 and the Illinois Public Community College Act will apply. In the future, the College will continue working with our auditors and legal counsel to ensure all bidding requirements are met for state, local, and federal funds.
Criteria Under Uniform Guidance, management of the College is responsible for establishing and maintaining effective internal control over compliance requirements that have a direct and material effect on the College's federal programs. Condition The internal controls established for the Higher Education Emergency Relief Fund (HEERF) were not effective in selecting the proper procurement method. Population of Items Tested Expenditures for which procurement was tested during our audit procedures under the HEERF Institutional fund totaled $1,372,042 and expenditures tested under the Strengthening Institutions Fund portion totaled $290,176. Cause of Condition The College's policies and procedures allow for exceptions to procurement methods which are not allowed under federal regulations. Effects of Condition The College did not procure goods and services under the proper federal methodology for certain purchases during the fiscal year. Questioned Costs No questioned costs over $25,000. Context Our audit procedures identified $488,078 of expenditures that the College did not obtain quotes or bids as required by federal procurement policies. Repeat Finding This finding does not repeat a previous finding. Auditor's Recommendations The College should amend the policies and procedures to only allow for specific exceptions using federal funds as allowed by federal procurement regulations. View of Responsible Official Based on the guidance from Robbins Schwartz, the purchase may be made only after receiving an adequate number of competitive quotes from qualified sources, unless it is a nonexempt purchase in an amount between $25,000 and $250,000. In such cases, biding requirements under board policy 10.22 and the Illinois Public Community College Act will apply. In the future, the College will continue working with our auditors and legal counsel to ensure all bidding requirements are met for state, local, and federal funds.
Criteria Under Uniform Guidance, management of the College is responsible for establishing and maintaining effective internal control over compliance requirements that have a direct and material effect on the College's federal programs. Condition The internal controls established for the Higher Education Emergency Relief Fund (HEERF) were not effective in selecting the proper procurement method. Population of Items Tested Expenditures for which procurement was tested during our audit procedures under the HEERF Institutional fund totaled $1,372,042 and expenditures tested under the Strengthening Institutions Fund portion totaled $290,176. Cause of Condition The College's policies and procedures allow for exceptions to procurement methods which are not allowed under federal regulations. Effects of Condition The College did not procure goods and services under the proper federal methodology for certain purchases during the fiscal year. Questioned Costs No questioned costs over $25,000. Context Our audit procedures identified $488,078 of expenditures that the College did not obtain quotes or bids as required by federal procurement policies. Repeat Finding This finding does not repeat a previous finding. Auditor's Recommendations The College should amend the policies and procedures to only allow for specific exceptions using federal funds as allowed by federal procurement regulations. View of Responsible Official Based on the guidance from Robbins Schwartz, the purchase may be made only after receiving an adequate number of competitive quotes from qualified sources, unless it is a nonexempt purchase in an amount between $25,000 and $250,000. In such cases, biding requirements under board policy 10.22 and the Illinois Public Community College Act will apply. In the future, the College will continue working with our auditors and legal counsel to ensure all bidding requirements are met for state, local, and federal funds.
Criteria Under Uniform Guidance, management of the College is responsible for establishing and maintaining effective internal control over compliance requirements that have a direct and material effect on the College's federal programs. Condition The internal controls established for the Higher Education Emergency Relief Fund (HEERF) were not effective in selecting the proper procurement method. Population of Items Tested Expenditures for which procurement was tested during our audit procedures under the HEERF Institutional fund totaled $1,372,042 and expenditures tested under the Strengthening Institutions Fund portion totaled $290,176. Cause of Condition The College's policies and procedures allow for exceptions to procurement methods which are not allowed under federal regulations. Effects of Condition The College did not procure goods and services under the proper federal methodology for certain purchases during the fiscal year. Questioned Costs No questioned costs over $25,000. Context Our audit procedures identified $488,078 of expenditures that the College did not obtain quotes or bids as required by federal procurement policies. Repeat Finding This finding does not repeat a previous finding. Auditor's Recommendations The College should amend the policies and procedures to only allow for specific exceptions using federal funds as allowed by federal procurement regulations. View of Responsible Official Based on the guidance from Robbins Schwartz, the purchase may be made only after receiving an adequate number of competitive quotes from qualified sources, unless it is a nonexempt purchase in an amount between $25,000 and $250,000. In such cases, biding requirements under board policy 10.22 and the Illinois Public Community College Act will apply. In the future, the College will continue working with our auditors and legal counsel to ensure all bidding requirements are met for state, local, and federal funds.