Audit 310675

FY End
2023-09-30
Total Expended
$329.81M
Findings
8
Programs
74
Organization: Dallas County (TX)
Year: 2023 Accepted: 2024-06-28

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
403623 2023-002 Significant Deficiency - F
403624 2023-002 Significant Deficiency - F
403625 2023-003 Significant Deficiency Yes L
403626 2023-003 Significant Deficiency Yes L
980065 2023-002 Significant Deficiency - F
980066 2023-002 Significant Deficiency - F
980067 2023-003 Significant Deficiency Yes L
980068 2023-003 Significant Deficiency Yes L

Programs

ALN Program Spent Major Findings
14.871 Section 8 Housing Choice Vouchers $50.62M - 0
93.914 Hiv Emergency Relief Project Grants $19.95M - 0
21.023 Emergency Rental Assistance Program $16.63M Yes 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $11.00M - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $10.87M - 0
93.268 Immunization Cooperative Agreements $6.68M - 0
93.917 Hiv Care Formula Grants $4.09M - 0
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $2.82M - 0
93.686 Ending the Hiv Epidemic: A Plan for America — Ryan White Hiv/aids Program Parts A and B (b) $2.40M Yes 1
93.137 Community Programs to Improve Minority Health Grant Program $2.17M Yes 1
93.499 Low Income Household Water Assistance Program $2.12M - 0
93.566 Refugee and Entrant Assistance_state Administered Programs $2.07M - 0
20.205 Highway Planning and Construction $1.63M Yes 1
93.074 Hospital Preparedness Program (hpp) and Public Health Emergency Preparedness (phep) Aligned Cooperative Agreements $1.50M - 0
93.940 Hiv Prevention Activities_health Department Based $1.39M - 0
84.010 Title I Grants to Local Educational Agencies $1.19M - 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $1.14M - 0
16.741 Dna Backlog Reduction Program $1.08M - 0
14.231 Emergency Solutions Grant Program $1.06M - 0
14.218 Community Development Block Grants/entitlement Grants $1.05M - 0
16.593 Residential Substance Abuse Treatment for State Prisoners $976,171 - 0
14.239 Home Investment Partnerships Program $898,620 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $877,062 Yes 0
16.606 State Criminal Alien Assistance Program $868,167 - 0
14.879 Mainstream Vouchers $780,089 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $777,621 - 0
14.241 Housing Opportunities for Persons with Aids $710,907 Yes 0
81.042 Weatherization Assistance for Low-Income Persons $704,258 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $694,057 - 0
93.069 Public Health Emergency Preparedness $692,576 - 0
16.833 National Sexual Assault Kit Initiative $682,706 - 0
10.555 National School Lunch Program $586,360 - 0
21.016 Equitable Sharing $541,709 - 0
93.778 Medical Assistance Program $458,023 - 0
93.944 Human Immunodeficiency Virus (hiv)/acquired Immunodeficiency Virus Syndrome (aids) Surveillance $456,789 - 0
16.922 Equitable Sharing Program $423,973 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $362,090 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $322,453 - 0
10.553 School Breakfast Program $320,805 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $319,625 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $315,878 - 0
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $272,143 - 0
16.575 Crime Victim Assistance $267,496 - 0
16.820 Postconviction Testing of Dna Evidence to Exonerate the Innocent $253,489 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $198,369 - 0
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $194,247 - 0
16.588 Violence Against Women Formula Grants $193,647 - 0
10.872 Healthy Food Financing Initiative (b) $189,955 - 0
93.967 Cdc's Collaboration with Academia to Strengthen Public Health $183,565 - 0
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation’s Health $175,294 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $163,906 - 0
97.067 Homeland Security Grant Program $155,235 - 0
96.001 Social Security_disability Insurance $154,000 - 0
84.425 Education Stabilization Fund $117,191 - 0
93.270 Adult Viral Hepatitis Prevention and Control $114,986 - 0
93.070 Environmental Public Health and Emergency Response $103,086 - 0
84.027 Special Education_grants to States $96,263 - 0
93.008 Medical Reserve Corps Small Grant Program $95,058 - 0
93.991 Preventive Health and Health Services Block Grant $90,759 - 0
14.896 Family Self-Sufficiency Program $83,487 - 0
21.032 Local Assistance and Tribal Consistency Fund $81,057 - 0
16.812 Second Chance Act Reentry Initiative $61,929 - 0
10.175 Farmers Market and Local Food Promotion Program (b) $58,966 - 0
95.001 High Intensity Drug Trafficking Areas Program $38,123 - 0
16.746 Capital Case Litigation Initiative $35,357 - 0
16.585 Drug Court Discretionary Grant Program $33,711 - 0
93.433 Acl National Institute on Disability, Independent Living, and Rehabilitation Research $31,950 - 0
84.424 Student Support and Academic Enrichment Program $24,475 - 0
84.367 Improving Teacher Quality State Grants $20,073 - 0
93.918 Grants to Provide Outpatient Early Intervention Services with Respect to Hiv Disease $10,417 - 0
16.540 Juvenile Justice and Delinquency Prevention_allocation to States $9,889 - 0
97.091 Homeland Security Biowatch Program $4,561 - 0
84.365 English Language Acquisition State Grants $1,574 - 0
93.568 Low-Income Home Energy Assistance $322 Yes 0

Contacts

Name Title Type
UMZVGH9B5RM7 Timothy J Hicks Auditee
2146536470 Tracey Cooley Auditor
No contacts on file

Notes to SEFA

Title: General Accounting Policies: The Schedules were prepared using the modified accrual basis of accounting. Federal and state award revenues/expenses are reported as intergovernmental revenues and expenses in the General Fund and the Special Revenue funds in the County’s basic financial statements. De Minimis Rate Used: N Rate Explanation: The County has not elected to use the 10% de minimis indirect cost rate for federal awards. The accompanying schedules of expenditures of federal and state awards (the Schedules) present the activity of all federal and state award programs of Dallas County, Texas (the County), except for the federal and state award programs of the Dallas County Hospital District (the District), a component unit of the County, which has been excluded. The District issued a separate single audit report for the year ended September 30, 2023. The County’s reporting entity is defined in Note 1.A to the County’s basic financial statements
Title: Indirect Cost rate Accounting Policies: The Schedules were prepared using the modified accrual basis of accounting. Federal and state award revenues/expenses are reported as intergovernmental revenues and expenses in the General Fund and the Special Revenue funds in the County’s basic financial statements. De Minimis Rate Used: N Rate Explanation: The County has not elected to use the 10% de minimis indirect cost rate for federal awards. The County has not elected to use the 10% de minimis indirect cost rate for federal awards.
Title: Basis of Accounting Accounting Policies: The Schedules were prepared using the modified accrual basis of accounting. Federal and state award revenues/expenses are reported as intergovernmental revenues and expenses in the General Fund and the Special Revenue funds in the County’s basic financial statements. De Minimis Rate Used: N Rate Explanation: The County has not elected to use the 10% de minimis indirect cost rate for federal awards. The Schedules were prepared using the modified accrual basis of accounting. Federal and state award revenues/expenses are reported as intergovernmental revenues and expenses in the General Fund and the Special Revenue funds in the County’s basic financial statements.
Title: IMMUNIZATION VACCINES Accounting Policies: The Schedules were prepared using the modified accrual basis of accounting. Federal and state award revenues/expenses are reported as intergovernmental revenues and expenses in the General Fund and the Special Revenue funds in the County’s basic financial statements. De Minimis Rate Used: N Rate Explanation: The County has not elected to use the 10% de minimis indirect cost rate for federal awards. Dallas County is a vaccine provider, not a sub recipient, for the State of Texas Health Department Childhood Immunization Grant. The value of vaccines received from the State was $3,933,779 for the fiscal year ended September 30, 2023.
Title: State Grants Accounting Policies: The Schedules were prepared using the modified accrual basis of accounting. Federal and state award revenues/expenses are reported as intergovernmental revenues and expenses in the General Fund and the Special Revenue funds in the County’s basic financial statements. De Minimis Rate Used: N Rate Explanation: The County has not elected to use the 10% de minimis indirect cost rate for federal awards. Grants with “N/A” under ALN number represent state grants received from the State of Texas, which are not federally funded.
Title: COVID-19 Disaster Grants Accounting Policies: The Schedules were prepared using the modified accrual basis of accounting. Federal and state award revenues/expenses are reported as intergovernmental revenues and expenses in the General Fund and the Special Revenue funds in the County’s basic financial statements. De Minimis Rate Used: N Rate Explanation: The County has not elected to use the 10% de minimis indirect cost rate for federal awards. As the Health Authority, Dallas County applied for reimbursement of COVID-19 related expenditures on behalf of certain cities located in the county; of the total mutual aid expenses reflected in the schedules, a portion of the costs have been reimbursed to the cities.

Finding Details

Equipment and Real Property Management – Significant Deficiency in Controls over Compliance and Noncompliance ALN #20.205 – Contract # 18-22XXIA001– Highway Planning and Construction Criteria – A physical inventory of the property purchased with grant funds must be performed and the results reconciled with the property records at least once every two years. Condition/Context - The grant program maintains 21 total pieces of equipment all of which are courtesy patrol vehicles used to carry out the purpose of the grant program. Grant management did not perform a complete physical inventory of all vehicles in service during the fiscal year; 13 of the 21 vehicles were improperly excluded from the Courtesy Patrol department on the Sheriff’s Department’s Annual Property Certification. Of the 13 vehicles, 9 were identified as improperly included in a separate department within the Certification and 4 were excluded entirely. Cause - Management did not maintain a proper control to ensure all courtesy patrol vehicles are included in the Annual Property Certification for the Sheriff's Department or reported within the correct department. Effect - Failure to perform a proper inventory control could lead to inaccurate and incomplete property records or a misappropriation of assets. Failure to properly track and report inventory could result in a loss of funding. Questioned Cost - None. Recommendations - Management should perform a complete inventory of all equipment maintained by the grant program. View of Responsible Officials - See Corrective Action Plan. New/Repeat Finding - New Finding
Equipment and Real Property Management – Significant Deficiency in Controls over Compliance and Noncompliance ALN #20.205 – Contract # 18-22XXIA001– Highway Planning and Construction Criteria – A physical inventory of the property purchased with grant funds must be performed and the results reconciled with the property records at least once every two years. Condition/Context - The grant program maintains 21 total pieces of equipment all of which are courtesy patrol vehicles used to carry out the purpose of the grant program. Grant management did not perform a complete physical inventory of all vehicles in service during the fiscal year; 13 of the 21 vehicles were improperly excluded from the Courtesy Patrol department on the Sheriff’s Department’s Annual Property Certification. Of the 13 vehicles, 9 were identified as improperly included in a separate department within the Certification and 4 were excluded entirely. Cause - Management did not maintain a proper control to ensure all courtesy patrol vehicles are included in the Annual Property Certification for the Sheriff's Department or reported within the correct department. Effect - Failure to perform a proper inventory control could lead to inaccurate and incomplete property records or a misappropriation of assets. Failure to properly track and report inventory could result in a loss of funding. Questioned Cost - None. Recommendations - Management should perform a complete inventory of all equipment maintained by the grant program. View of Responsible Officials - See Corrective Action Plan. New/Repeat Finding - New Finding
Reporting – Significant Deficiency in Controls over Compliance and Noncompliance ALN #93.686 – Contract #UT8HA33930 - HIV Emergency Relief Project Grants RW Supplement ALN #93.137 – Contract #CPIMP211284-01-0 - COVID-19 Minority Health Community Programs Criteria - Under the requirements of the Federal Funding Accountability and Transparency Act, direct recipients of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). Condition/Context - A total of $1,117,769 of costs was passed through to selected sub recipients during the year and the subawards were not reported in the FSRS. HIV Emergency Relief Project Grants RW Supplement Transactions Tested Subaward not reported Report not timely Subaward amount incorrect Subaward missing key elements There were a total of five subrecipients selected that had awards/expenditures greater than $30,000 that were not reported in the FSRS. Dollar amount of Tested Transactions Subaward not reported Report not timely Subaward amount incorrect Subaward missing key elements $1,030,818 $1,212,555 $1,212,555 $1,212,555 $1,212,555 COVID-19 Minority Health Community Programs Transactions Tested Subaward not reported Report not timely Subaward amount incorrect Subaward missing key elements There were two subrecipients that had awards/expenditures greater than $30,000 that were not reported in the FSRS. Dollar amount of Tested Transactions Subaward not reported Report not timely Subaward amount incorrect Subaward missing key elements $86,951 $99,300 $99,300 $99,300 $99,300 Cause - Grant Management was not aware of the subaward reporting requirement. Effect - Failure to report subaward data 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 reporting subaward data completely and accurately in the FSRS on a timely basis. View of Responsible Officials - See Corrective Action Plan. New/Repeat Finding – This finding is repeat from prior year’s finding #2022-004 ALN #14.218– Community Development Block/Entitlement Grants. Recommendations - Management should ensure that they have a mechanism for reporting subaward data completely and accurately in the FSRS on a timely basis. View of Responsible Officials - See Corrective Action Plan.
Reporting – Significant Deficiency in Controls over Compliance and Noncompliance ALN #93.686 – Contract #UT8HA33930 - HIV Emergency Relief Project Grants RW Supplement ALN #93.137 – Contract #CPIMP211284-01-0 - COVID-19 Minority Health Community Programs Criteria - Under the requirements of the Federal Funding Accountability and Transparency Act, direct recipients of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). Condition/Context - A total of $1,117,769 of costs was passed through to selected sub recipients during the year and the subawards were not reported in the FSRS. HIV Emergency Relief Project Grants RW Supplement Transactions Tested Subaward not reported Report not timely Subaward amount incorrect Subaward missing key elements There were a total of five subrecipients selected that had awards/expenditures greater than $30,000 that were not reported in the FSRS. Dollar amount of Tested Transactions Subaward not reported Report not timely Subaward amount incorrect Subaward missing key elements $1,030,818 $1,212,555 $1,212,555 $1,212,555 $1,212,555 COVID-19 Minority Health Community Programs Transactions Tested Subaward not reported Report not timely Subaward amount incorrect Subaward missing key elements There were two subrecipients that had awards/expenditures greater than $30,000 that were not reported in the FSRS. Dollar amount of Tested Transactions Subaward not reported Report not timely Subaward amount incorrect Subaward missing key elements $86,951 $99,300 $99,300 $99,300 $99,300 Cause - Grant Management was not aware of the subaward reporting requirement. Effect - Failure to report subaward data 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 reporting subaward data completely and accurately in the FSRS on a timely basis. View of Responsible Officials - See Corrective Action Plan. New/Repeat Finding – This finding is repeat from prior year’s finding #2022-004 ALN #14.218– Community Development Block/Entitlement Grants. Recommendations - Management should ensure that they have a mechanism for reporting subaward data completely and accurately in the FSRS on a timely basis. View of Responsible Officials - See Corrective Action Plan.
Equipment and Real Property Management – Significant Deficiency in Controls over Compliance and Noncompliance ALN #20.205 – Contract # 18-22XXIA001– Highway Planning and Construction Criteria – A physical inventory of the property purchased with grant funds must be performed and the results reconciled with the property records at least once every two years. Condition/Context - The grant program maintains 21 total pieces of equipment all of which are courtesy patrol vehicles used to carry out the purpose of the grant program. Grant management did not perform a complete physical inventory of all vehicles in service during the fiscal year; 13 of the 21 vehicles were improperly excluded from the Courtesy Patrol department on the Sheriff’s Department’s Annual Property Certification. Of the 13 vehicles, 9 were identified as improperly included in a separate department within the Certification and 4 were excluded entirely. Cause - Management did not maintain a proper control to ensure all courtesy patrol vehicles are included in the Annual Property Certification for the Sheriff's Department or reported within the correct department. Effect - Failure to perform a proper inventory control could lead to inaccurate and incomplete property records or a misappropriation of assets. Failure to properly track and report inventory could result in a loss of funding. Questioned Cost - None. Recommendations - Management should perform a complete inventory of all equipment maintained by the grant program. View of Responsible Officials - See Corrective Action Plan. New/Repeat Finding - New Finding
Equipment and Real Property Management – Significant Deficiency in Controls over Compliance and Noncompliance ALN #20.205 – Contract # 18-22XXIA001– Highway Planning and Construction Criteria – A physical inventory of the property purchased with grant funds must be performed and the results reconciled with the property records at least once every two years. Condition/Context - The grant program maintains 21 total pieces of equipment all of which are courtesy patrol vehicles used to carry out the purpose of the grant program. Grant management did not perform a complete physical inventory of all vehicles in service during the fiscal year; 13 of the 21 vehicles were improperly excluded from the Courtesy Patrol department on the Sheriff’s Department’s Annual Property Certification. Of the 13 vehicles, 9 were identified as improperly included in a separate department within the Certification and 4 were excluded entirely. Cause - Management did not maintain a proper control to ensure all courtesy patrol vehicles are included in the Annual Property Certification for the Sheriff's Department or reported within the correct department. Effect - Failure to perform a proper inventory control could lead to inaccurate and incomplete property records or a misappropriation of assets. Failure to properly track and report inventory could result in a loss of funding. Questioned Cost - None. Recommendations - Management should perform a complete inventory of all equipment maintained by the grant program. View of Responsible Officials - See Corrective Action Plan. New/Repeat Finding - New Finding
Reporting – Significant Deficiency in Controls over Compliance and Noncompliance ALN #93.686 – Contract #UT8HA33930 - HIV Emergency Relief Project Grants RW Supplement ALN #93.137 – Contract #CPIMP211284-01-0 - COVID-19 Minority Health Community Programs Criteria - Under the requirements of the Federal Funding Accountability and Transparency Act, direct recipients of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). Condition/Context - A total of $1,117,769 of costs was passed through to selected sub recipients during the year and the subawards were not reported in the FSRS. HIV Emergency Relief Project Grants RW Supplement Transactions Tested Subaward not reported Report not timely Subaward amount incorrect Subaward missing key elements There were a total of five subrecipients selected that had awards/expenditures greater than $30,000 that were not reported in the FSRS. Dollar amount of Tested Transactions Subaward not reported Report not timely Subaward amount incorrect Subaward missing key elements $1,030,818 $1,212,555 $1,212,555 $1,212,555 $1,212,555 COVID-19 Minority Health Community Programs Transactions Tested Subaward not reported Report not timely Subaward amount incorrect Subaward missing key elements There were two subrecipients that had awards/expenditures greater than $30,000 that were not reported in the FSRS. Dollar amount of Tested Transactions Subaward not reported Report not timely Subaward amount incorrect Subaward missing key elements $86,951 $99,300 $99,300 $99,300 $99,300 Cause - Grant Management was not aware of the subaward reporting requirement. Effect - Failure to report subaward data 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 reporting subaward data completely and accurately in the FSRS on a timely basis. View of Responsible Officials - See Corrective Action Plan. New/Repeat Finding – This finding is repeat from prior year’s finding #2022-004 ALN #14.218– Community Development Block/Entitlement Grants. Recommendations - Management should ensure that they have a mechanism for reporting subaward data completely and accurately in the FSRS on a timely basis. View of Responsible Officials - See Corrective Action Plan.
Reporting – Significant Deficiency in Controls over Compliance and Noncompliance ALN #93.686 – Contract #UT8HA33930 - HIV Emergency Relief Project Grants RW Supplement ALN #93.137 – Contract #CPIMP211284-01-0 - COVID-19 Minority Health Community Programs Criteria - Under the requirements of the Federal Funding Accountability and Transparency Act, direct recipients of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). Condition/Context - A total of $1,117,769 of costs was passed through to selected sub recipients during the year and the subawards were not reported in the FSRS. HIV Emergency Relief Project Grants RW Supplement Transactions Tested Subaward not reported Report not timely Subaward amount incorrect Subaward missing key elements There were a total of five subrecipients selected that had awards/expenditures greater than $30,000 that were not reported in the FSRS. Dollar amount of Tested Transactions Subaward not reported Report not timely Subaward amount incorrect Subaward missing key elements $1,030,818 $1,212,555 $1,212,555 $1,212,555 $1,212,555 COVID-19 Minority Health Community Programs Transactions Tested Subaward not reported Report not timely Subaward amount incorrect Subaward missing key elements There were two subrecipients that had awards/expenditures greater than $30,000 that were not reported in the FSRS. Dollar amount of Tested Transactions Subaward not reported Report not timely Subaward amount incorrect Subaward missing key elements $86,951 $99,300 $99,300 $99,300 $99,300 Cause - Grant Management was not aware of the subaward reporting requirement. Effect - Failure to report subaward data 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 reporting subaward data completely and accurately in the FSRS on a timely basis. View of Responsible Officials - See Corrective Action Plan. New/Repeat Finding – This finding is repeat from prior year’s finding #2022-004 ALN #14.218– Community Development Block/Entitlement Grants. Recommendations - Management should ensure that they have a mechanism for reporting subaward data completely and accurately in the FSRS on a timely basis. View of Responsible Officials - See Corrective Action Plan.