Audit 299091

FY End
2023-06-30
Total Expended
$132.23M
Findings
4
Programs
59
Organization: Hamilton County, Tennessee (TN)
Year: 2023 Accepted: 2024-03-28

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
386805 2023-002 Material Weakness - L
386806 2023-002 Material Weakness - L
963247 2023-002 Material Weakness - L
963248 2023-002 Material Weakness - L

Programs

ALN Program Spent Major Findings
84.010 Title I Grants to Local Educational Agencies $18.28M - 0
84.425 Education Stabilization Fund $17.96M Yes 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $12.95M Yes 0
93.575 Child Care and Development Block Grant $7.11M Yes 1
84.367 Improving Teacher Quality State Grants $2.44M - 0
93.558 Temporary Assistance for Needy Families $2.44M - 0
93.527 Affordable Care Act (aca) Grants for New and Expanded Services Under the Health Center Program $1.98M - 0
84.424 Student Support and Academic Enrichment Program $1.25M - 0
84.287 Twenty-First Century Community Learning Centers $932,153 - 0
84.048 Career and Technical Education -- Basic Grants to States $932,031 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $830,277 - 0
16.710 Public Safety Partnership and Community Policing Grants $814,691 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $657,003 - 0
93.069 Public Health Emergency Preparedness $543,317 - 0
84.365 English Language Acquisition State Grants $525,188 - 0
93.224 Consolidated Health Centers (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $365,553 - 0
93.667 Social Services Block Grant $314,851 - 0
93.217 Family Planning_services $273,819 - 0
93.563 Child Support Enforcement $256,266 - 0
10.582 Fresh Fruit and Vegetable Program $230,665 Yes 0
32.009 Emergency Connectivity Fund Program $227,152 - 0
93.268 Immunization Cooperative Agreements $208,703 - 0
93.994 Maternal and Child Health Services Block Grant to the States $191,520 - 0
93.940 Hiv Prevention Activities_health Department Based $175,176 - 0
93.991 Preventive Health and Health Services Block Grant $159,904 - 0
97.029 Flood Mitigation Assistance $156,695 - 0
97.042 Emergency Management Performance Grants $150,500 - 0
10.555 National School Lunch Program $140,423 Yes 0
97.067 Homeland Security Grant Program $135,768 - 0
93.917 Hiv Care Formula Grants $133,840 - 0
84.173 Special Education_preschool Grants $131,583 - 0
84.196 Education for Homeless Children and Youth $131,469 - 0
16.585 Drug Court Discretionary Grant Program $98,329 - 0
16.812 Second Chance Act Reentry Initiative $97,063 - 0
10.579 Child Nutrition Discretionary Grants Limited Availability $89,127 - 0
93.136 Injury Prevention and Control Research and State and Community Based Programs $88,571 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $88,259 - 0
84.371 Striving Readers $84,959 - 0
93.977 Hiv Prevention Activities_health Department Based $79,194 - 0
93.305 National State Based Tobacco Control Programs $72,061 - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $67,281 - 0
16.606 State Criminal Alien Assistance Program $66,872 - 0
84.126 Rehabilitation Services_vocational Rehabilitation Grants to States $63,784 - 0
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $61,971 - 0
93.197 Childhood Lead Poisoning Prevention Projects_state and Local Childhood Lead Poisoning Prevention and Surveillance of Blood Lead Levels in Children $61,677 - 0
16.839 Stop School Violence $56,913 - 0
16.922 Equitable Sharing Program $50,873 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $50,316 - 0
84.041 Impact Aid $30,575 - 0
93.426 Improving the Health of Americans Through Prevention and Management of Diabetes and Heart Disease and Stroke $27,143 - 0
93.232 Loan Repayment Program for General Research $22,500 - 0
84.027 Special Education_grants to States $17,496 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $15,947 - 0
93.747 Elder Abuse Prevention Interventions Program $13,760 - 0
16.575 Crime Victim Assistance $9,363 - 0
10.649 Pandemic Ebt Administrative Costs $5,950 - 0
14.231 Emergency Solutions Grant Program $4,252 - 0
84.184 Safe and Drug-Free Schools and Communities_national Programs $3,987 - 0
16.607 Bulletproof Vest Partnership Program $1,162 - 0

Contacts

Name Title Type
Y9C3ZS4WJNN5 Holly Wormsley Auditee
4232096309 James Bence Auditor
No contacts on file

Notes to SEFA

Title: NOTE B. SUBRECIPIENTS Accounting Policies: The accompanying schedule of expenditures of federal and state awards includes the federal and state grant activity of the County and is presented on the accrual basis of accounting. 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 . Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in, the preparation of the general-purpose financial statements. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10% de minimis cost rate. Program Title: Federal AL Number; Amount Provided to Subrecipient Special Supplemental Nutrition Program for Women, Infants, and Children: 10.557; $2,653 Social Services Block Grant: 93.667; $290,118 Title XX - Partnership COVID Program: 93.747; $1,119 COVID-19 Coronavirus State and Local Fiscal Recovery Funds: 21.027; $8,731,487
Title: NOTE C. INDIRECT COST Accounting Policies: The accompanying schedule of expenditures of federal and state awards includes the federal and state grant activity of the County and is presented on the accrual basis of accounting. 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 . Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in, the preparation of the general-purpose financial statements. De Minimis Rate Used: N Rate Explanation: The County has elected not to use the 10% de minimis cost rate. The County has elected to not use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance.

Finding Details

Reporting Child Care and Development Block Grant (Assistance Listing Number 93.575) U.S. Department of Health and Human Services, Passed Through the Tennessee Department of Human Services Criteria: Per review of the grant agreements between the State of Tennessee and the Hamilton County Department of Education (the Department), the Department was required to submit periodic reports to the State at least every ninety (90) days after the receipt of the award and at three month subsequent intervals. Condition: During testing, it was noted that the Department was not submitting the required reports in the required three month intervals. The reports were being submitted at the conclusion of the expending of the awards, but not within the 3 month intervals required by the grant agreements. Context/Cause: The Department did not submit the quarterly reports for the fiscal year ended June 30, 2023 and were only filing the reports once all funds were expended. Effects: The Department was not compliant with the 34 grant agreements in place for funding at 34 schools. However, the County has continued to receive funding from the State under three different rounds of funding for the program. At each interval, any outstanding reports were brought current and the additional funding was provided. Recommendation: We recommend the Department ensure they have carefully reviewed and complied to all requirements in the agreements signed with the State or other grantors. Controls should be put in place to obtained written waivers for any requirements which are later deemed not applicable, so as to have documentation for any amendments to the agreements. Auditee’s Response (Department of Education): The Department agrees with the recommendation and has implemented to new procedures to ensure the quarterly reports are being loaded into the State’s dashboard for compliance with the requirement.
Reporting Child Care and Development Block Grant (Assistance Listing Number 93.575) U.S. Department of Health and Human Services, Passed Through the Tennessee Department of Human Services Criteria: Per review of the grant agreements between the State of Tennessee and the Hamilton County Department of Education (the Department), the Department was required to submit periodic reports to the State at least every ninety (90) days after the receipt of the award and at three month subsequent intervals. Condition: During testing, it was noted that the Department was not submitting the required reports in the required three month intervals. The reports were being submitted at the conclusion of the expending of the awards, but not within the 3 month intervals required by the grant agreements. Context/Cause: The Department did not submit the quarterly reports for the fiscal year ended June 30, 2023 and were only filing the reports once all funds were expended. Effects: The Department was not compliant with the 34 grant agreements in place for funding at 34 schools. However, the County has continued to receive funding from the State under three different rounds of funding for the program. At each interval, any outstanding reports were brought current and the additional funding was provided. Recommendation: We recommend the Department ensure they have carefully reviewed and complied to all requirements in the agreements signed with the State or other grantors. Controls should be put in place to obtained written waivers for any requirements which are later deemed not applicable, so as to have documentation for any amendments to the agreements. Auditee’s Response (Department of Education): The Department agrees with the recommendation and has implemented to new procedures to ensure the quarterly reports are being loaded into the State’s dashboard for compliance with the requirement.
Reporting Child Care and Development Block Grant (Assistance Listing Number 93.575) U.S. Department of Health and Human Services, Passed Through the Tennessee Department of Human Services Criteria: Per review of the grant agreements between the State of Tennessee and the Hamilton County Department of Education (the Department), the Department was required to submit periodic reports to the State at least every ninety (90) days after the receipt of the award and at three month subsequent intervals. Condition: During testing, it was noted that the Department was not submitting the required reports in the required three month intervals. The reports were being submitted at the conclusion of the expending of the awards, but not within the 3 month intervals required by the grant agreements. Context/Cause: The Department did not submit the quarterly reports for the fiscal year ended June 30, 2023 and were only filing the reports once all funds were expended. Effects: The Department was not compliant with the 34 grant agreements in place for funding at 34 schools. However, the County has continued to receive funding from the State under three different rounds of funding for the program. At each interval, any outstanding reports were brought current and the additional funding was provided. Recommendation: We recommend the Department ensure they have carefully reviewed and complied to all requirements in the agreements signed with the State or other grantors. Controls should be put in place to obtained written waivers for any requirements which are later deemed not applicable, so as to have documentation for any amendments to the agreements. Auditee’s Response (Department of Education): The Department agrees with the recommendation and has implemented to new procedures to ensure the quarterly reports are being loaded into the State’s dashboard for compliance with the requirement.
Reporting Child Care and Development Block Grant (Assistance Listing Number 93.575) U.S. Department of Health and Human Services, Passed Through the Tennessee Department of Human Services Criteria: Per review of the grant agreements between the State of Tennessee and the Hamilton County Department of Education (the Department), the Department was required to submit periodic reports to the State at least every ninety (90) days after the receipt of the award and at three month subsequent intervals. Condition: During testing, it was noted that the Department was not submitting the required reports in the required three month intervals. The reports were being submitted at the conclusion of the expending of the awards, but not within the 3 month intervals required by the grant agreements. Context/Cause: The Department did not submit the quarterly reports for the fiscal year ended June 30, 2023 and were only filing the reports once all funds were expended. Effects: The Department was not compliant with the 34 grant agreements in place for funding at 34 schools. However, the County has continued to receive funding from the State under three different rounds of funding for the program. At each interval, any outstanding reports were brought current and the additional funding was provided. Recommendation: We recommend the Department ensure they have carefully reviewed and complied to all requirements in the agreements signed with the State or other grantors. Controls should be put in place to obtained written waivers for any requirements which are later deemed not applicable, so as to have documentation for any amendments to the agreements. Auditee’s Response (Department of Education): The Department agrees with the recommendation and has implemented to new procedures to ensure the quarterly reports are being loaded into the State’s dashboard for compliance with the requirement.