Audit 250890

FY End
2022-12-31
Total Expended
$236.31M
Findings
0
Programs
64
Organization: Franklin County (IN)
Year: 2022 Accepted: 2023-09-27

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
93.558 Temporary Assistance for Needy Families $42.84M - 0
93.658 Foster Care_title IV-E $23.83M - 0
21.023 Covid-19 Emergency Rental Assistance Program I $17.00M Yes 0
93.778 Medical Assistance Program $13.92M Yes 0
93.659 Adoption Assistance $13.12M Yes 0
21.023 Covid-19 Emergency Rental Assistance Program II $12.43M Yes 0
10.561 State Administrative Grants for the Supplemental Nutrition Assistance Program $11.10M - 0
93.563 Child Support Enforcement $10.71M Yes 0
20.205 Highway Planning and Construction $7.83M Yes 0
93.658 Funding Certainty Grant $5.94M - 0
93.788 Opioid Str $5.20M - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $4.61M Yes 0
93.575 Child Care and Development Block Grant $2.86M - 0
97.036 Disaster Grants - Public Assistance $2.80M - 0
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $1.70M Yes 0
93.556 Promoting Safe and Stable Families $1.33M - 0
14.231 Emergency Solutions Grant Program $1.22M - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $1.04M - 0
93.958 Block Grants for Community Mental Health Services $948,605 - 0
14.218 Community Development Block Grants/entitlement Grants $940,970 - 0
96.001 Social Security_disability Insurance $787,901 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $749,720 - 0
16.034 Covid-19 Coronavirus Emergency Supplemental Funding Program $740,092 - 0
97.067 Homeland Security Grant Program $720,649 - 0
16.588 Violence Against Women Formula Grants $706,986 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $678,168 - 0
10.561 Covid-19 Snap American Rescue Plan Act $654,348 - 0
21.019 Covid-19 Cares Act - Coronavirus Relief Fund Local Government Assistance Program $600,750 - 0
93.667 Social Services Block Grant $585,410 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $400,305 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $383,155 - 0
93.150 Projects for Assistance in Transition From Homelessness (path) $340,790 - 0
16.575 Crime Victim Assistance $286,550 - 0
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $255,452 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $244,692 - 0
96.006 Supplemental Social Security Income $220,493 - 0
93.665 Emergency Grants to Address Mental and Substance Use Disorders During Covid-19 $213,500 - 0
16.831 Children of Incarcerated Parents $205,238 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $204,075 - 0
84.027 Special Education_grants to States $196,246 - 0
93.354 Public Health Crisis Response $182,546 - 0
14.239 Home Investment Partnerships Program $155,747 - 0
16.548 Title V_delinquency Prevention Program $143,160 - 0
84.425 Covid-19 Education Stabilization Fund (esf) - Govenors Emergency Education Relief (geer) $132,418 - 0
10.555 National School Lunch Program $130,362 - 0
93.674 Covid-19 John H. Chafee Foster Care Program Stimulus $119,408 - 0
97.042 Emergency Management Performance Grants $118,380 - 0
20.616 National Priority Safety Programs $118,137 - 0
93.471 Kinship Support Intervention $105,166 - 0
93.564 Child Support Enforcement $94,664 - 0
84.173 Special Education_preschool Grants $87,010 - 0
20.600 State and Community Highway Safety - Dui Enforcement $78,768 - 0
10.553 School Breakfast Program $72,607 - 0
97.067 Bssa Grant $51,000 - 0
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $48,250 - 0
93.747 Elder Abuse Prevention Interventions Program $46,035 - 0
93.597 Access and Visitation $21,443 - 0
16.540 Juvenile Justice and Delinquency Prevention_allocation to States $10,855 - 0
93.566 Refugee and Entrant Assistance_state Administered Programs $7,257 - 0
93.767 Children's Health Insurance Program $6,725 - 0
93.136 Publci Health Crisis Response $5,146 - 0
21.016 Equitable Sharing $4,122 - 0
10.561 Covid-19 Snap American Rescue Plan Incentives $0 - 0
90.404 2022 Election Security Grants $0 - 0

Contacts

Name Title Type
ETN8QVA981S7 Robert Caldwell Auditee
6145257520 Stacie Scholl Auditor
No contacts on file

Notes to SEFA

Title: General Accounting Policies: The accompanying Schedule is presented using the cash basis of accounting in which revenues are recognized when received and expenditures are recognized when paid. Therefore, some amounts presented in the Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. Such expenditures are recognized following as applicable, either the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principle, and Audit Requirements for Federal Awards, wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. Amounts reported may also differ from other federal award reports the County submits directly to federal granting agencies or pass-through entities because the award reports may be presented for a different fiscal period, and/or may include cumulative (from prior years) data rather than data for the current year only. The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The accompanying Schedule of Receipts and Expenditures of Federal Awards (the Schedule) includes the federal grant activity of Franklin County, Ohio (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). The Schedule only reflects the federal awards of the primary government. It is not intended to and does not present the financial position, changes in net position or cash flows for the County.
Title: Subrecipients Accounting Policies: The accompanying Schedule is presented using the cash basis of accounting in which revenues are recognized when received and expenditures are recognized when paid. Therefore, some amounts presented in the Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. Such expenditures are recognized following as applicable, either the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principle, and Audit Requirements for Federal Awards, wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. Amounts reported may also differ from other federal award reports the County submits directly to federal granting agencies or pass-through entities because the award reports may be presented for a different fiscal period, and/or may include cumulative (from prior years) data rather than data for the current year only. The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The County passes-through to local governments or not-for-profit agencies (subrecipients) certain federal assistance received by the County directly from the federal awarding agency or from a pass-through entity. As described in Note 2, the County records expenditures of federal awards to subrecipients when paid in cash.The subrecipients have certain compliance responsibilities related to administering these federal programs. Under 2 CFR 200, the County is responsible for monitoring subrecipients to help assure that federal awards are expended for authorized purposes in compliance with laws, regulations, and the provisions of contracts or grant agreements, and that performance goals are achieved. The total amounts of federal assistance provided to subrecipients by the County for each federal program is included in the Schedule.
Title: Child Nutrition Accounting Policies: The accompanying Schedule is presented using the cash basis of accounting in which revenues are recognized when received and expenditures are recognized when paid. Therefore, some amounts presented in the Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. Such expenditures are recognized following as applicable, either the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principle, and Audit Requirements for Federal Awards, wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. Amounts reported may also differ from other federal award reports the County submits directly to federal granting agencies or pass-through entities because the award reports may be presented for a different fiscal period, and/or may include cumulative (from prior years) data rather than data for the current year only. The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The County commingles cash receipts from the U.S. Department of Agriculture with similar State grants. When reporting expenditures on this Schedule, the County assumes it expends federal monies first.
Title: Loan Programs Accounting Policies: The accompanying Schedule is presented using the cash basis of accounting in which revenues are recognized when received and expenditures are recognized when paid. Therefore, some amounts presented in the Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. Such expenditures are recognized following as applicable, either the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principle, and Audit Requirements for Federal Awards, wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. Amounts reported may also differ from other federal award reports the County submits directly to federal granting agencies or pass-through entities because the award reports may be presented for a different fiscal period, and/or may include cumulative (from prior years) data rather than data for the current year only. The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. 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 rehabilitate homes for persons from low-moderate income households and to businesses to create jobs. The Federal Department of Housing and Urban Development (HUD) grants money for these loans to the County. The initial loan of this money is recorded as a disbursement on the accompanying Schedule of Receipts and Expenditures of Federal Awards (the 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 the Schedule. The County had the following loan balances outstanding at December 31, 2022, $7,695,685, including delinquent or deferred loans of $992,934 for the Community Development Block Grant and $4,349,569 for the Home Investment in Affordable Housing. Loan Balances Outstanding for Community Development Block Grant AL# 14.218 of $1,872,313 and Home Investment in Affordable Housing AL# 14.239 of $5,823,372.
Title: Matching Requirements Accounting Policies: The accompanying Schedule is presented using the cash basis of accounting in which revenues are recognized when received and expenditures are recognized when paid. Therefore, some amounts presented in the Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. Such expenditures are recognized following as applicable, either the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principle, and Audit Requirements for Federal Awards, wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. Amounts reported may also differ from other federal award reports the County submits directly to federal granting agencies or pass-through entities because the award reports may be presented for a different fiscal period, and/or may include cumulative (from prior years) data rather than data for the current year only. The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. 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 federally funded programs. The County has complied with the matching requirements (if applicable) for the major federal programs identified in the summary of auditors results section of the accompanying schedule of findings. Expenditures of matching funds are not included in the Schedule.
Title: Temporary Assistance for Needy Families (TANF) Accounting Policies: The accompanying Schedule is presented using the cash basis of accounting in which revenues are recognized when received and expenditures are recognized when paid. Therefore, some amounts presented in the Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. Such expenditures are recognized following as applicable, either the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principle, and Audit Requirements for Federal Awards, wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. Amounts reported may also differ from other federal award reports the County submits directly to federal granting agencies or pass-through entities because the award reports may be presented for a different fiscal period, and/or may include cumulative (from prior years) data rather than data for the current year only. The County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The Schedule shows the County spent $42,839,247 on the Temporary Assistance for Needy Families (TANF) (93.558) program. The amount reported for the TANF program on the Schedule excludes allowable TANF expenditures of $255,879 that are included as Social Services Block Grant (SSBG) (93.667) program expenditures. The following table shows the gross amount drawn for the TANF program during fiscal year 2022 and the allowable TANF expenditures for the Social Services Block Grant program. Temporary Assistance for Needy Families $42,839,247 plus Social Services Block Grant (TANF Allowable) $255,879 equal Total Temporary Assistance for Needy Families $43,095,126.