Audit 53743

FY End
2022-12-31
Total Expended
$5.32M
Findings
0
Programs
33
Organization: Mercer County (IL)
Year: 2022 Accepted: 2023-09-24

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $345,893 - 0
93.658 Foster Care_title IV-E $343,961 - 0
93.667 Social Services Block Grant $318,141 - 0
93.778 Medical Assistance Program $269,728 Yes 0
93.659 Adoption Assistance $199,049 - 0
14.239 Home Investment Partnerships Program $172,740 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $131,567 Yes 0
66.469 Great Lakes Program $117,503 - 0
93.563 Child Support Enforcement $107,622 - 0
66.460 Nonpoint Source Implementation Grants $81,376 - 0
17.259 Wia Youth Activities $77,681 - 0
20.205 Highway Planning and Construction $77,130 - 0
93.767 Children's Health Insurance Program $75,079 - 0
17.258 Wia Adult Program $74,851 - 0
97.042 Emergency Management Performance Grants $70,517 - 0
93.556 Promoting Safe and Stable Families $59,531 - 0
93.597 Grants to States for Access and Visitation Programs $59,446 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $47,402 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $47,331 - 0
84.181 Special Education-Grants for Infants and Families $32,933 - 0
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $30,731 - 0
93.558 Temporary Assistance for Needy Families $29,037 Yes 0
93.575 Child Care and Development Block Grant $23,070 - 0
17.277 Workforce Investment Act (wia) National Emergency Grants $22,882 - 0
17.278 Wia Dislocated Worker Formula Grants $18,705 - 0
10.902 Soil and Water Conservation $17,650 - 0
17.207 Employment Service/wagner-Peyser Funded Activities $16,629 - 0
97.039 Hazard Mitigation Grant $8,750 - 0
93.747 Elder Abuse Prevention Interventions Program $7,653 - 0
20.600 State and Community Highway Safety $7,574 - 0
16.575 Crime Victim Assistance $5,004 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $4,005 Yes 0
17.245 Trade Adjustment Assistance $2,606 - 0

Contacts

Name Title Type
SQ6KLGRJVJC3 Lauren Baucher Auditee
4195866402 Brad Billet Auditor
No contacts on file

Notes to SEFA

Title: CDBG REVOLVING LOAN PROGRAMS WITHOUT CONTINUING COMPLIANCE REQUIRMENTS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of Mercer County (the County) under programs of the federal government for the year ended December 31, 2022. The information on this Schedule is prepared 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). Because the Schedule presents only a selected portion of the operations of the County, it is not intended to and does not present the financial position, changes in net position, or cash flows of the County. Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance, wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The County has a revolving loan fund (RLF) program to provide low-interest loans to businesses to create jobs for low to moderate income persons and also to lend money to eligible persons to rehabilitate homes. The Federal Department of Housing and Urban Development (HUD) grants money for these loans to the County, passed through the Ohio Development Services Agency. The Schedule reports loans made and administrative costs as disbursements on the Schedule. Subsequent loans are subject to the same compliance requirements imposed by HUD as the initial loans. These loans are collateralized by mortgages on the property and by UCCs on machinery and equipment. The current balance as of December 31, 2022 was $465,562.
Title: MATCHING REQUIRMENTS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of Mercer County (the County) under programs of the federal government for the year ended December 31, 2022. The information on this Schedule is prepared 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). Because the Schedule presents only a selected portion of the operations of the County, it is not intended to and does not present the financial position, changes in net position, or cash flows of the County. Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance, wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. Certain Federal programs require the County to contribute non-Federal funds (matching funds) to support the Federally-funded programs. The County has met its matching requirements. The Schedule does not include the expenditure of non-Federal matching funds.
Title: TRANSFERS BETWEEN FEDERAL PROGRAMS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of Mercer County (the County) under programs of the federal government for the year ended December 31, 2022. The information on this Schedule is prepared 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). Because the Schedule presents only a selected portion of the operations of the County, it is not intended to and does not present the financial position, changes in net position, or cash flows of the County. Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance, wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. During 2022, the County made allowable transfers of $33,596 from the Social Services Block Grant (SSBG) (ALN 93.667) program to the Temporary Assistance for Needy Families (TANF) (ALN 93.558) program. The Schedule shows the County spent $342,528 on the SSBG program. The amount reported for the SSBG program excludes the amount transferred to the TANF program. The amount transferred to the TANF program is included as TANF expenditures when disbursed. The following table shows the gross amount for the SSBG program for the year 2022 and the amount transferred to the TANF program.Social Service Block Grant: $376,124; Transfer to Temporary Assistance for Needy Families: (33,596); Total Social Service Block Grant: $342,528.