Audit 32528

FY End
2022-09-30
Total Expended
$166.88M
Findings
4
Programs
58
Organization: Tarrant County (TX)
Year: 2022 Accepted: 2023-05-23

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
38340 2022-001 Significant Deficiency - L
38341 2022-001 Significant Deficiency - L
614782 2022-001 Significant Deficiency - L
614783 2022-001 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $55.25M Yes 0
21.023 Emergency Rental Assistance Program $15.13M Yes 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $9.74M Yes 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $6.62M - 0
20.205 Highway Planning and Construction $1.93M Yes 1
14.218 Community Development Block Grants/entitlement Grants $1.81M Yes 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $1.79M - 0
14.231 Emergency Solutions Grant Program $1.52M - 0
14.879 Mainstream Vouchers $1.31M Yes 0
93.268 Immunization Cooperative Agreements $1.14M Yes 0
14.U00 Hcv Cares Funds $981,139 - 0
93.566 Refugee and Entrant Assistance_state Administered Programs $924,170 - 0
93.778 Medical Assistance Program $732,733 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $661,391 - 0
14.267 Continuum of Care Program $572,668 Yes 0
16.606 State Criminal Alien Assistance Program $555,990 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $401,287 - 0
21.019 Coronavirus Relief Fund $394,524 - 0
93.686 Ending the Hiv Epidemic: A Plan for America Ryan White Hiv/aids Program Parts A and B (b) $320,917 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $313,234 - 0
10.555 National School Lunch Program $284,278 - 0
16.575 Crime Victim Assistance $268,054 - 0
93.917 Hiv Care Formula Grants $242,995 - 0
14.896 Family Self-Sufficiency Program $219,939 - 0
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $207,011 - 0
16.320 Services for Trafficking Victims $206,320 - 0
93.558 Temporary Assistance for Needy Families $206,000 - 0
16.839 Stop School Violence $124,602 - 0
90.404 2018 Hava Election Security Grants $120,865 - 0
93.944 Human Immunodeficiency Virus (hiv)/acquired Immunodeficiency Virus Syndrome (aids) Surveillance $105,510 - 0
93.940 Hiv Prevention Activities_health Department Based $83,177 - 0
93.590 Community-Based Child Abuse Prevention Grants $70,000 - 0
14.239 Home Investment Partnerships Program $65,175 - 0
93.597 Grants to States for Access and Visitation Programs $62,202 - 0
93.658 Foster Care_title IV-E $61,946 - 0
97.067 Homeland Security Grant Program $58,565 - 0
93.994 Maternal and Child Health Services Block Grant to the States $48,170 - 0
93.069 Public Health Emergency Preparedness $39,557 - 0
21.016 Equitable Sharing $38,857 - 0
14.241 Housing Opportunities for Persons with Aids $36,924 - 0
16.588 Violence Against Women Formula Grants $28,238 - 0
97.024 Emergency Food and Shelter National Board Program $25,000 - 0
14.U01 McAre Act Mainstream Voucher Funding $23,726 - 0
93.991 Preventive Health and Health Services Block Grant $18,820 - 0
93.918 Grants to Provide Outpatient Early Intervention Services with Respect to Hiv Disease $17,575 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $13,788 - 0
16.543 Missing Children's Assistance $13,666 - 0
93.556 Promoting Safe and Stable Families $11,288 - 0
14.238 Shelter Plus Care $10,590 - 0
16.741 Dna Backlog Reduction Program $8,939 - 0
14.871 Section 8 Housing Choice Vouchers $8,889 Yes 0
93.322 Csels Partnership: Strengthening Public Health Laboratories $4,746 - 0
93.153 Coordinated Services and Access to Research for Women, Infants, Children, and Youth $4,482 - 0
93.914 Hiv Emergency Relief Project Grants $3,631 - 0
93.283 Centers for Disease Control and Prevention_investigations and Technical Assistance $624 - 0
16.922 Equitable Sharing Program $579 - 0
93.008 Medical Reserve Corps Small Grant Program $149 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $-23 - 0

Contacts

Name Title Type
DBH1UNN8U5J3 Juana Casas Auditee
8178841022 Blake Rodgers Auditor
No contacts on file

Notes to SEFA

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, which are reported in relation to the financial statements taken as a whole. The program affected is as follows: Foster Care Title IV-E ALN# 93.658 $512,702 De Minimis Rate Used: N Rate Explanation: The auditee did not use 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

Finding 2022-001: Reporting ? Significant Deficiency in Controls over Compliance and Noncompliance Federal/State Program: Highway Planning & Construction ? Courtesy Patrol Program ALN 20.205 FAIN: 693JJ22130000Z230TX2022073 Year(s): 2022 Federal Agency: U.S. Department of Transportation Pass-Through Entity: Texas Department of Transportation (Award 02-0XXF5001) Criteria The grant agreements stipulate that the monthly financial expense reports are to be submitted within 90 days after month end to the grantor. Condition and Perspective The grant accounting team responsible for the program experienced turnover of key personnel, which led to 5 out of the 12 monthly reports to be submitted late. Cause The turnover in the grant management personnel caused delays in the report submissions. 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. Recommendations Management should ensure that they have a mechanism for tracking the reporting requirements and due dates so that the monthly financial expense reports are submitted timely to the grantor.
Finding 2022-001: Reporting ? Significant Deficiency in Controls over Compliance and Noncompliance Federal/State Program: Highway Planning & Construction ? Courtesy Patrol Program ALN 20.205 FAIN: 693JJ22130000Z230TX2022073 Year(s): 2022 Federal Agency: U.S. Department of Transportation Pass-Through Entity: Texas Department of Transportation (Award 02-0XXF5001) Criteria The grant agreements stipulate that the monthly financial expense reports are to be submitted within 90 days after month end to the grantor. Condition and Perspective The grant accounting team responsible for the program experienced turnover of key personnel, which led to 5 out of the 12 monthly reports to be submitted late. Cause The turnover in the grant management personnel caused delays in the report submissions. 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. Recommendations Management should ensure that they have a mechanism for tracking the reporting requirements and due dates so that the monthly financial expense reports are submitted timely to the grantor.
Finding 2022-001: Reporting ? Significant Deficiency in Controls over Compliance and Noncompliance Federal/State Program: Highway Planning & Construction ? Courtesy Patrol Program ALN 20.205 FAIN: 693JJ22130000Z230TX2022073 Year(s): 2022 Federal Agency: U.S. Department of Transportation Pass-Through Entity: Texas Department of Transportation (Award 02-0XXF5001) Criteria The grant agreements stipulate that the monthly financial expense reports are to be submitted within 90 days after month end to the grantor. Condition and Perspective The grant accounting team responsible for the program experienced turnover of key personnel, which led to 5 out of the 12 monthly reports to be submitted late. Cause The turnover in the grant management personnel caused delays in the report submissions. 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. Recommendations Management should ensure that they have a mechanism for tracking the reporting requirements and due dates so that the monthly financial expense reports are submitted timely to the grantor.
Finding 2022-001: Reporting ? Significant Deficiency in Controls over Compliance and Noncompliance Federal/State Program: Highway Planning & Construction ? Courtesy Patrol Program ALN 20.205 FAIN: 693JJ22130000Z230TX2022073 Year(s): 2022 Federal Agency: U.S. Department of Transportation Pass-Through Entity: Texas Department of Transportation (Award 02-0XXF5001) Criteria The grant agreements stipulate that the monthly financial expense reports are to be submitted within 90 days after month end to the grantor. Condition and Perspective The grant accounting team responsible for the program experienced turnover of key personnel, which led to 5 out of the 12 monthly reports to be submitted late. Cause The turnover in the grant management personnel caused delays in the report submissions. 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. Recommendations Management should ensure that they have a mechanism for tracking the reporting requirements and due dates so that the monthly financial expense reports are submitted timely to the grantor.