Audit 259756

FY End
2022-12-31
Total Expended
$15.31M
Findings
0
Programs
37
Organization: Hancock County (IN)
Year: 2022 Accepted: 2023-08-20

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
93.558 Temporary Assistance for Needy Families $1.98M - 0
93.563 Child Support Enforcement $716,645 - 0
93.778 Medical Assistance Program $656,160 - 0
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $444,079 - 0
93.659 Adoption Assistance $278,715 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $274,209 - 0
17.258 Wia Adult Program $220,505 - 0
17.259 Wia Youth Activities $118,515 - 0
93.767 Children's Health Insurance Program $91,923 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $88,315 - 0
93.575 Child Care and Development Block Grant $73,529 - 0
93.556 Promoting Safe and Stable Families $62,498 - 0
93.669 Child Abuse and Neglect State Grants $53,242 - 0
84.181 Special Education-Grants for Infants and Families $51,028 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $48,230 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $47,158 - 0
93.667 Social Services Block Grant $45,211 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $45,150 Yes 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $39,780 - 0
93.747 Elder Abuse Prevention Interventions Program $38,268 - 0
20.205 Highway Planning and Construction $32,220 - 0
97.029 Flood Mitigation Assistance $28,291 - 0
93.104 Comprehensive Community Mental Health Services for Children with Serious Emotional Disturbances (sed) $25,761 Yes 0
93.788 Opioid Str $24,800 - 0
93.958 Block Grants for Community Mental Health Services $21,893 - 0
84.027 Special Education_grants to States $14,677 - 0
97.042 Emergency Management Performance Grants $13,828 - 0
17.207 Employment Service/wagner-Peyser Funded Activities $13,468 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $9,793 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $8,932 - 0
93.658 Foster Care_title IV-E $8,904 - 0
84.173 Special Education_preschool Grants $7,468 - 0
16.575 Crime Victim Assistance $5,655 - 0
17.225 Unemployment Insurance $4,523 - 0
17.245 Trade Adjustment Assistance $2,112 - 0
17.278 Wia Dislocated Worker Formula Grants $1,929 - 0
20.616 National Priority Safety Programs $1,762 - 0

Contacts

Name Title Type
JW1YMYDFH5J1 Charity A. Rauschenberg Auditee
4194247015 Brian Mosier Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: 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 auditee did not use the de minimis cost rate. The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of Hancock County (the County's) 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.
Title: Subrecipients Accounting Policies: 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 auditee did not use the de minimis cost rate. The County passes certain federal awards received from the United States Department of Justice, United States Department of Health and Human Services and United Statements Department of the Treasury to other governments or not-for-profit agencies (subrecipients). As Note B describes, the County reports expenditures of Federal awards to subrecipients when paid in cash. As a subrecipient, the County has certain compliance responsibilities, such as monitoring its subrecipients to help assure they use these subawards as authorized by laws, regulations, and the provisions of contracts or grant agreements, and that subrecipients achieve the award's performance goals.
Title: Community Development Block Grant (CDBG with Revolving Loan Cash Balance) Accounting Policies: 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 auditee did not use the de minimis cost rate. The County has established a revolving loan program to provide low-interest loans to businesses to create jobs for persons from low-moderate income households. The Federal Department of Housing and Urban Development (HUD) grants money for these loans to the County passed through the Ohio Department of Development. The initial loan of this money is recorded as a disbursement on this schedule. Loans repaid, including interest, are used to make additional loans. Such subsequent loans are subject to certain compliance requirements imposed by HUD, but are not included as disbursements on this schedule. These loans are collateralized by mortgages on the property. The County incurred $8,932 in administrative costs during 2022. Beginning loans receivable as of January 1, 2022 $347,086 Loans Disbursed - Loans Repaid (63,190)Ending loans receivable as of December 31, 2022 $283,896 Cash balance on hand as of December 31, 2022 $514,328 Delinquent amounts due as of December 31, 2022 $79,370
Title: Matching Requirements Accounting Policies: 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 auditee did not use the de minimis cost rate. Certain Federal programs require the County to contribute non-Federal funds (matching funds) to support the Federal-funding programs. The County has met its matching requirements. The Schedule does not include the expenditures of non-Federal matching funds.
Title: Transfers Between Federal Programs Accounting Policies: 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 auditee did not use the de minimis cost rate. During 2022, the County made allowable transfers of $19,489 from the Child Care and Development Block Grant (CCDBG) (93.575) program to the Temporary Assistance for Needy Families (TANF) (93.558) program. The Schedule shows the County spent approximately $73,529 on the CCDBG program. The amount reported for the CCDBG program on the Schedule 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 drawn for the CCDBG program during 2022 and the amount transferred to the TANF program. CCDBG $93,018 Transfer to TANF (19,489) Total CCDBG $73,529