Audit 309661

FY End
2023-09-30
Total Expended
$234.59M
Findings
2
Programs
60
Organization: Tarrant County (TX)
Year: 2023 Accepted: 2024-06-24

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
401731 2023-002 Significant Deficiency - L
978173 2023-002 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $126.21M Yes 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $9.96M - 0
21.023 Emergency Rental Assistance Program $7.00M Yes 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $6.81M - 0
93.914 Hiv Emergency Relief Project Grants $3.24M - 0
93.268 Immunization Cooperative Agreements $2.79M - 0
14.218 Community Development Block Grants/entitlement Grants $2.58M - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $2.05M Yes 1
14.879 Mainstream Vouchers $1.53M - 0
93.566 Refugee and Entrant Assistance_state Administered Programs $1.53M Yes 0
93.778 Medical Assistance Program $1.03M - 0
14.231 Emergency Solutions Grant Program $958,302 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $774,878 - 0
93.686 Ending the Hiv Epidemic: A Plan for America — Ryan White Hiv/aids Program Parts A and B (b) $758,131 - 0
16.606 State Criminal Alien Assistance Program $585,635 - 0
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $401,602 - 0
93.917 Hiv Care Formula Grants $391,565 - 0
16.575 Crime Victim Assistance $385,589 - 0
16.320 Academic-Based Drug Field Testing and Training Initiative $375,976 - 0
10.555 National School Lunch Program $306,677 - 0
93.940 Hiv Prevention Activities_health Department Based $204,177 - 0
21.016 Equitable Sharing $152,517 - 0
93.918 Grants to Provide Outpatient Early Intervention Services with Respect to Hiv Disease $150,000 - 0
93.991 Preventive Health and Health Services Block Grant $131,482 - 0
20.205 Highway Planning and Construction $129,212 - 0
14.239 Home Investment Partnerships Program $104,037 - 0
97.039 Hazard Mitigation Grant $95,321 - 0
93.558 Temporary Assistance for Needy Families $84,806 - 0
93.153 Coordinated Services and Access to Research for Women, Infants, Children, and Youth $81,829 - 0
93.597 Grants to States for Access and Visitation Programs $66,300 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $64,395 - 0
93.945 Assistance Programs for Chronic Disease Prevention and Control $62,289 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $60,028 - 0
14.871 Housing Choice Voucher Program $51,994 - 0
93.069 Public Health Emergency Preparedness $46,015 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $42,253 - 0
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $42,108 - 0
93.658 Foster Care_title IV-E $35,780 - 0
93.944 Human Immunodeficiency Virus (hiv)/acquired Immunodeficiency Virus Syndrome (aids) Surveillance $33,993 - 0
14.871 Section 8 Housing Choice Vouchers $32,652 - 0
97.024 Emergency Food and Shelter National Board Program $30,416 - 0
16.741 Dna Backlog Reduction Program $29,174 - 0
97.067 Homeland Security Grant Program $27,200 - 0
93.994 Maternal and Child Health Services Block Grant to the States $25,000 - 0
14.241 Housing Opportunities for Persons with Aids $24,898 - 0
93.590 Community-Based Child Abuse Prevention Grants $19,324 - 0
14.267 Continuum of Care Program $17,667 - 0
93.967 Cdc's Collaboration with Academia to Strengthen Public Health $16,691 - 0
93.008 Medical Reserve Corps Small Grant Program $9,440 - 0
16.922 Equitable Sharing Program $8,111 - 0
16.588 Violence Against Women Formula Grants $7,845 - 0
16.839 Stop School Violence $5,000 - 0
93.322 Csels Partnership: Strengthening Public Health Laboratories $4,788 - 0
16.543 Missing Children's Assistance $4,351 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $3,202 - 0
93.556 Promoting Safe and Stable Families $1,828 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $1,280 - 0
15.904 Historic Preservation Fund Grants-in-Aid $1,191 - 0
90.404 2018 Hava Election Security Grants $-2,930 - 0
14.896 Family Self-Sufficiency Program $-3,106 - 0

Contacts

Name Title Type
DBH1UNN8U5J3 Kimberly Buchanan Auditee
8178841011 Blake Rodgers Auditor
No contacts on file

Notes to SEFA

Title: Basis of Accounting and Summary of Significant Accounting Policies Accounting Policies: The schedule of expenditures of federal awards (the “Schedule”) was prepared on the modified accrual basis of accounting. Amounts reported as expenditures in the accompanying Schedule may not agree with the amounts reported in the related federal financial reports filed with the grantor agencies because of accruals, which would be included in the next report filed with the agency. Federal grant funds are considered to be earned to the extent of expenditures made under the provisions of the grant, and accordingly, when such funds are received, they are recorded as unavailable revenues until earned. The accompanying Schedule is presented on the modified accrual basis of accounting. The County participates in numerous federal grant programs, which are governed by various rules and regulations of the grantor agencies. Costs charged to the respective grant programs are subject to audit and adjustments by the grantor agencies; therefore, to the extent that the County has not complied with rules and regulations governing the grants, refund of any money received may be required and the collectability of any related receivable at year-end maybe impaired. The Schedule includes certain program expenditures that relate to prior years. These expenditures have been deemed immaterial to the Schedule in relation to the financial statements taken as a whole. The program affected is as follows: Assistance Prior Year Listing Expenditure Program Name Number Amount Foster Care Title IV-E 93.658 $ 586,473 De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate. The schedule of expenditures of federal awards (the “Schedule”) was prepared on the modified accrual basis of accounting. Amounts reported as expenditures in the accompanying Schedule may not agree with the amounts reported in the related federal financial reports filed with the grantor agencies because of accruals, which would be included in the next report filed with the agency. Federal grant funds are considered to be earned to the extent of expenditures made under the provisions of the grant, and accordingly, when such funds are received, they are recorded as unavailable revenues until earned. The accompanying Schedule is presented on the modified accrual basis of accounting. The County participates in numerous federal grant programs, which are governed by various rules and regulations of the grantor agencies. Costs charged to the respective grant programs are subject to audit and adjustments by the grantor agencies; therefore, to the extent that the County has not complied with rules and regulations governing the grants, refund of any money received may be required and the collectability of any related receivable at year-end maybe impaired. The Schedule includes certain program expenditures that relate to prior years. These expenditures have been deemed immaterial to the Schedule in relation to the financial statements taken as a whole. The program affected is as follows:
Title: De Minimis Indirect Cost Rate Accounting Policies: The schedule of expenditures of federal awards (the “Schedule”) was prepared on the modified accrual basis of accounting. Amounts reported as expenditures in the accompanying Schedule may not agree with the amounts reported in the related federal financial reports filed with the grantor agencies because of accruals, which would be included in the next report filed with the agency. Federal grant funds are considered to be earned to the extent of expenditures made under the provisions of the grant, and accordingly, when such funds are received, they are recorded as unavailable revenues until earned. The accompanying Schedule is presented on the modified accrual basis of accounting. The County participates in numerous federal grant programs, which are governed by various rules and regulations of the grantor agencies. Costs charged to the respective grant programs are subject to audit and adjustments by the grantor agencies; therefore, to the extent that the County has not complied with rules and regulations governing the grants, refund of any money received may be required and the collectability of any related receivable at year-end maybe impaired. The Schedule includes certain program expenditures that relate to prior years. These expenditures have been deemed immaterial to the Schedule in relation to the financial statements taken as a whole. The program affected is as follows: Assistance Prior Year Listing Expenditure Program Name Number Amount Foster Care Title IV-E 93.658 $ 586,473 De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate. The County has elected to use the 10% de minimis indirect cost rate for federal grant programs.
Title: Period of Availability Accounting Policies: The schedule of expenditures of federal awards (the “Schedule”) was prepared on the modified accrual basis of accounting. Amounts reported as expenditures in the accompanying Schedule may not agree with the amounts reported in the related federal financial reports filed with the grantor agencies because of accruals, which would be included in the next report filed with the agency. Federal grant funds are considered to be earned to the extent of expenditures made under the provisions of the grant, and accordingly, when such funds are received, they are recorded as unavailable revenues until earned. The accompanying Schedule is presented on the modified accrual basis of accounting. The County participates in numerous federal grant programs, which are governed by various rules and regulations of the grantor agencies. Costs charged to the respective grant programs are subject to audit and adjustments by the grantor agencies; therefore, to the extent that the County has not complied with rules and regulations governing the grants, refund of any money received may be required and the collectability of any related receivable at year-end maybe impaired. The Schedule includes certain program expenditures that relate to prior years. These expenditures have been deemed immaterial to the Schedule in relation to the financial statements taken as a whole. The program affected is as follows: Assistance Prior Year Listing Expenditure Program Name Number Amount Foster Care Title IV-E 93.658 $ 586,473 De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate. The period of availability for federal funds for the purpose of liquidation of outstanding obligations made on or before the ending date of the federal project period extends 30 to 90 days beyond the federal project period ending date, in accordance with provisions in the OMB Compliance Supplement.

Finding Details

Criteria The grant contract requires quarterly progress reports to be submitted to the grantor on or before the 15th of the month following the end of the quarter. Condition and Perspective 4 out of 4 quarterly progress reports tested for award HHS000812700030 were submitted after the due date. Cause Grant administration did not adequately track the due dates to ensure timely submission of the quarterly progress reports. Effect Failure to meet submission deadlines of reports could potentially constitute an event of noncompliance with the award contract, which may result in the early termination of the grant award, non-reimbursement of grant funding, or cessation of future funding. Questioned Cost None. Repeat Finding from Prior Year No. Recommendations Management should ensure that they have a mechanism for tracking the due dates so that the quarterly progress reports are submitted timely to the grantor
Criteria The grant contract requires quarterly progress reports to be submitted to the grantor on or before the 15th of the month following the end of the quarter. Condition and Perspective 4 out of 4 quarterly progress reports tested for award HHS000812700030 were submitted after the due date. Cause Grant administration did not adequately track the due dates to ensure timely submission of the quarterly progress reports. Effect Failure to meet submission deadlines of reports could potentially constitute an event of noncompliance with the award contract, which may result in the early termination of the grant award, non-reimbursement of grant funding, or cessation of future funding. Questioned Cost None. Repeat Finding from Prior Year No. Recommendations Management should ensure that they have a mechanism for tracking the due dates so that the quarterly progress reports are submitted timely to the grantor