Audit 314697

FY End
2023-12-31
Total Expended
$2.38M
Findings
0
Programs
15
Organization: Lake County (MI)
Year: 2023 Accepted: 2024-07-09
Auditor: Maner Costerisan

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Contacts

Name Title Type
RM6FL3FX54K3 Tobi. G. Lake Auditee
2317456231 William I. Tucker IV Auditor
No contacts on file

Notes to SEFA

Title: BASIS OF PRESENTATION Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the Federal grant activity of Lake County, Michigan, and is presented on the modified accrual basis of accounting. The information in this schedule is presented in accordance with the 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). Therefore, some amounts presented in this schedule may differ from amounts presented in or used in the preparation of the basic financial statements, which are reconciled in Note 3. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10 percent de minimis indirect rate allowed under the Uniform Guidance. The accompanying Schedule of Expenditures of Federal Awards includes the Federal grant activity of Lake County, Michigan, and is presented on the modified accrual basis of accounting. The information in this schedule is presented in accordance with the 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). Therefore, some amounts presented in this schedule may differ from amounts presented in or used in the preparation of the basic financial statements, which are reconciled in Note 3. The County has elected not to use the 10 percent de minimis indirect rate allowed under the Uniform Guidance. Federal Awards of the Lake County Road Commission are excluded from the accompanying Schedule of Expenditures of Federal Awards. This component unit’s audit report is issued under separate cover. Single Audits, when applicable, are included in their report. To view copies of those reports, contact the administrative offices of the component unit or the Lake County Clerk’s office.
Title: SUMMARY OF SIGNIFICANT EXPLANATIONS OF SCHEDULE Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the Federal grant activity of Lake County, Michigan, and is presented on the modified accrual basis of accounting. The information in this schedule is presented in accordance with the 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). Therefore, some amounts presented in this schedule may differ from amounts presented in or used in the preparation of the basic financial statements, which are reconciled in Note 3. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10 percent de minimis indirect rate allowed under the Uniform Guidance. The following descriptions identified below as (a) – (c) represent explanations that cross reference to amounts on the Schedule of Expenditures of Federal Awards: a. Reimbursement of these contracts is passed through the State Department of Health and Human Services (DHHS). The amounts reported on the Schedule of Expenditures of Federal Awards represent the Federal portion of the respective amounts based on 66% of Title IV-D eligible expenditures for the applicable grants. The entire amount paid by DHHS for the reimbursed expenditures is considered Federal. b. The reimbursements for the IV-D Incentive Payments Program are based on support payments collected. Expenditures have been reported to the extent of earned revenues and are 100% Federal. c. The U.S. Department of Agriculture awarded a total of $3,350,000 in 2005. The U.S. Department of Agriculture has developed ongoing requirements as identified in its terms and conditions. In accordance wit presentation requirements, the Schedule of Expenditures of Federal Awards includes the amount of $1,000,238. This balance includes the balance of principal outstanding on loans at the beginning of the fiscal year.
Title: RECONCILIATION TO SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the Federal grant activity of Lake County, Michigan, and is presented on the modified accrual basis of accounting. The information in this schedule is presented in accordance with the 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). Therefore, some amounts presented in this schedule may differ from amounts presented in or used in the preparation of the basic financial statements, which are reconciled in Note 3. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10 percent de minimis indirect rate allowed under the Uniform Guidance. The following reconciles the intergovernmental revenues reported in the December 31, 2023, basic financial statements to the expenditures of the County administered federal programs reported on the Schedule of Expenditures of Federal Awards: Federal/ Less State State Federal Revenue Revenue Adjustments Expenditures PRIMARY GOVERNMENT GENERAL FUND Payment in Lieu of Taxes (PILT) $ 222,465 $ - $ - $ 222,465 Forest Service Schools and Roads Clusters 45,671 - - 45,671 COVID-19 Coronavirus Emergency Supplemental Funding 25,290 - - 25,290 Child Support Enforcement 71,903 - - 71,903 Foster Care - Title IV-E 4,947 - - 4,947 Emergency Management Performance Grants 17,306 - - 17,306 Local Assistance and Tribal Consistency 296,204 - - 296,204 Community Wildfire Protection Grant 5,000 - - 5,000 Other programs 833,396 ( 833,396) - - TOTAL GENERAL FUND 1,522,182 ( 833,396) - 688,786 OTHER MAJOR FUNDS Sherriff Road Patrol Non-cash Award 28,283 - - 28,283 Cooperative Law Enforcement Operating & Financial Plan 6,075 - - 6,075 Edward Byrne Memorial Justice Assistance Grant Program 20,000 - - 20,000 Boating Safety Financial Assistance 8,500 - - 8,500 Other grants 30,144 (30,144) - - Total Sheriff Road Patrol 93,002 (30,144) - 62,858 Debt Service Fund Local Assistance and Tribal Consistency 296,204 - - 296,204 TOTAL OTHER MAJOR FUNDS 389,206 (30,144) - 359,062 NONMAJOR GOVERNMENTAL FUNDS Cooperative Reimbursement - Friend of the Court 193,444 - - 193,444 Federal Incentive Payments - FOC 8,733 - - 8,733 Public Safety Partnership and Community Policing Grants 58,011 - - 58,011 State and Community Highway Safety 67,635 - - 67,635 Other grants 685,620 ( 685,620) - - TOTAL NONMAJOR GOVERNMENTAL FUNDS 1,013,443 ( 685,620) - 327,823 Outstanding community facilities loans and grants cluster debt - - 1,000,238 1,000,238 TOTAL PRIMARY GOVERNMENT $ 2,924,831 $ (1,549,160) $ 1,000,238 $ 2,375,909