Audit 32407

FY End
2022-09-30
Total Expended
$275.72M
Findings
12
Programs
68
Organization: Dallas County (TX)
Year: 2022 Accepted: 2023-06-22

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
34655 2022-004 Significant Deficiency - L
34656 2022-003 Significant Deficiency - N
34657 2022-004 Significant Deficiency - L
34658 2022-003 Significant Deficiency - N
34659 2022-002 Significant Deficiency - L
34660 2022-002 Significant Deficiency - L
611097 2022-004 Significant Deficiency - L
611098 2022-003 Significant Deficiency - N
611099 2022-004 Significant Deficiency - L
611100 2022-003 Significant Deficiency - N
611101 2022-002 Significant Deficiency - L
611102 2022-002 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
14.871 Section 8 Housing Choice Vouchers $49.19M - 0
21.023 Emergency Rental Assistance Program $26.78M Yes 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $16.90M Yes 0
21.019 Coronavirus Relief Fund $15.18M - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $10.53M - 0
93.268 Immunization Cooperative Agreements $4.48M - 0
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $2.48M - 0
20.205 Highway Planning and Construction $2.26M - 0
84.425 Education Stabilization Fund $2.07M Yes 0
93.686 Ending the Hiv Epidemic: A Plan for America Ryan White Hiv/aids Program Parts A and B (b) $1.86M - 0
93.074 Hospital Preparedness Program (hpp) and Public Health Emergency Preparedness (phep) Aligned Cooperative Agreements $1.86M - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $1.72M Yes 0
93.940 Hiv Prevention Activities_health Department Based $1.54M - 0
93.566 Refugee and Entrant Assistance_state Administered Programs $1.33M - 0
14.231 Emergency Solutions Grant Program $1.17M - 0
14.218 Community Development Block Grants/entitlement Grants $962,221 Yes 2
16.606 State Criminal Alien Assistance Program $856,696 - 0
93.137 Community Programs to Improve Minority Health Grant Program $845,865 - 0
16.575 Crime Victim Assistance $830,109 - 0
16.593 Residential Substance Abuse Treatment for State Prisoners $797,619 - 0
93.778 Medical Assistance Program $762,719 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $715,757 - 0
84.010 Title I Grants to Local Educational Agencies $671,340 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $568,957 Yes 0
14.241 Housing Opportunities for Persons with Aids $541,865 - 0
10.555 National School Lunch Program $518,706 - 0
14.879 Mainstream Vouchers $499,971 - 0
93.568 Low-Income Home Energy Assistance $499,525 - 0
93.944 Human Immunodeficiency Virus (hiv)/acquired Immunodeficiency Virus Syndrome (aids) Surveillance $494,936 - 0
16.922 Equitable Sharing Program $390,127 - 0
81.042 Weatherization Assistance for Low-Income Persons $385,554 - 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $352,444 Yes 0
21.016 Equitable Sharing $327,365 - 0
16.588 Violence Against Women Formula Grants $290,732 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $285,843 - 0
10.553 School Breakfast Program $283,427 - 0
93.270 Adult Viral Hepatitis Prevention and Control $257,990 - 0
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $255,568 - 0
93.914 Hiv Emergency Relief Project Grants $233,573 Yes 0
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nations Health $232,861 - 0
96.001 Social Security_disability Insurance $213,300 - 0
97.067 Homeland Security Grant Program $201,280 - 0
16.123 Community-Based Violence Prevention Program $191,796 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $185,026 - 0
16.820 Postconviction Testing of Dna Evidence to Exonerate the Innocent $164,054 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $156,106 - 0
93.070 Environmental Public Health and Emergency Response $149,742 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $148,829 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $141,822 - 0
90.404 2018 Hava Election Security Grants $114,522 - 0
16.585 Drug Court Discretionary Grant Program $110,776 - 0
14.239 Home Investment Partnerships Program $104,341 - 0
16.833 National Sexual Assault Kit Initiative $88,953 - 0
14.896 Family Self-Sufficiency Program $74,361 - 0
93.991 Preventive Health and Health Services Block Grant $60,279 - 0
97.091 Homeland Security Biowatch Program $48,000 - 0
84.424 Student Support and Academic Enrichment Program $40,388 - 0
16.540 Juvenile Justice and Delinquency Prevention_allocation to States $29,055 - 0
95.001 High Intensity Drug Trafficking Areas Program $19,318 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $18,339 - 0
84.367 Improving Teacher Quality State Grants $17,263 - 0
84.027 Special Education_grants to States $15,285 - 0
93.008 Medical Reserve Corps Small Grant Program $13,191 - 0
93.917 Hiv Care Formula Grants $10,964 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $7,288 Yes 1
84.365 English Language Acquisition State Grants $3,099 - 0
84.184 Safe and Drug-Free Schools and Communities_national Programs $974 - 0
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $568 - 0

Contacts

Name Title Type
UMZVGH9B5RM7 Darryl D Thomas Auditee
2146536472 Tracey Cooley Auditor
No contacts on file

Notes to SEFA

Title: BASIS OF ACCOUNTING Accounting Policies: The accompanying schedules of expenditures of federal and state awards "the Schedules" presents 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, 2022. The County's reporting entity is defined in Note 1.A to 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 Countys basic financial statements.
Title: IMMUNIZATION VACCINES Accounting Policies: The accompanying schedules of expenditures of federal and state awards "the Schedules" presents 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, 2022. The County's reporting entity is defined in Note 1.A to 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 subrecipient, for the State of Texas Health Department Childhood Immunization Grant. The value of vaccines received from the State was $4,094,397.86 for the fiscal year ended September 30, 2022.
Title: STATE GRANTS Accounting Policies: The accompanying schedules of expenditures of federal and state awards "the Schedules" presents 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, 2022. The County's reporting entity is defined in Note 1.A to 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 Assistance Listing Number represents state grants received from the State of Texas which are not federally funded.
Title: COVID-19 DISASTER GRANTS Accounting Policies: The accompanying schedules of expenditures of federal and state awards "the Schedules" presents 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, 2022. The County's reporting entity is defined in Note 1.A to 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

Finding 2022-04: Special Test ? Reporting ? Significant Deficiency in Controls over Compliance and Noncompliance ALN #14.218? Community Development Block/Entitlement Grants 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 $2,497,138 was passed through to sub recipients during the year and the subawards were not reported in the FSRS. There was a total of seven subrecipients that had expenses greater than $30,000 that were not reported in the FSRS. Dollar amount of Tested Transactions $2,497,138 Subaward not reported $2,497,138 Report not timely $2,497,138 Subaward amount incorrect 0 Subaward missing key elements. $2,497,138 Cause ? Grant Management was not aware of the reporting requirement. Effect ? Failure to report sub-award 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 in the FSRS. Views of Responsible Officials ? See Corrective Action Plan.
Finding 2022-03: Special Tests ? Required Certifications and HUD Approvals and Environmental Reviews ? Significant Deficiency in Controls over Compliance and Noncompliance ALN #14.218? Community Development Block/Entitlement Grants (CDBG) Criteria ? CDBG funds (and local funds to be reimbursed with CDBG funds) cannot be obligated or expended before receipt of Department of Housing and Urban Development (HUD) approval of a Request for Release of Funds (RROF) and environmental certification, except for exempt activities under 24 CFR section 58.34 Projects must have an environmental review unless they meet criteria specified in the regulations that would exempt or exclude them from Request for Release of Funds (RROF) and environmental certification requirements (24 CFR sections 58.1, 58.22, 58.34, 58.35, and 570.604). Accordingly, the grantee should maintain documentation if any determination not to make an environmental review was made consistent with the criteria contained in 24 CFR sections 58.34 and 58.35(b). Condition/Context ? Per discussion with grant management, the documentation substantiating the exempt status of the environmental reviews were completed, however the documentation was lost due to unforeseen circumstances and was unavailable for observation during the audit process. Per our understanding of the projects and discussions with management, the projects are effectively exempt based on 24 CFR 58.34. However, the exempt status of the projects could not be verified because the documentation was not properly retained by the County. Cause ? During the year the grant management team had to relocate, and the physical documentation got misplaced during the process. The grant manager handling the documentation of the environmental reviews experienced technology issues which further caused a loss of information. Effect ? Failure to retain or backup documentation 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 storing and backing up documentation pertaining to environmental review. Views of Responsible Officials ? See Corrective Action Plan
Finding 2022-04: Special Test ? Reporting ? Significant Deficiency in Controls over Compliance and Noncompliance ALN #14.218? Community Development Block/Entitlement Grants 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 $2,497,138 was passed through to sub recipients during the year and the subawards were not reported in the FSRS. There was a total of seven subrecipients that had expenses greater than $30,000 that were not reported in the FSRS. Dollar amount of Tested Transactions $2,497,138 Subaward not reported $2,497,138 Report not timely $2,497,138 Subaward amount incorrect 0 Subaward missing key elements. $2,497,138 Cause ? Grant Management was not aware of the reporting requirement. Effect ? Failure to report sub-award 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 in the FSRS. Views of Responsible Officials ? See Corrective Action Plan.
Finding 2022-03: Special Tests ? Required Certifications and HUD Approvals and Environmental Reviews ? Significant Deficiency in Controls over Compliance and Noncompliance ALN #14.218? Community Development Block/Entitlement Grants (CDBG) Criteria ? CDBG funds (and local funds to be reimbursed with CDBG funds) cannot be obligated or expended before receipt of Department of Housing and Urban Development (HUD) approval of a Request for Release of Funds (RROF) and environmental certification, except for exempt activities under 24 CFR section 58.34 Projects must have an environmental review unless they meet criteria specified in the regulations that would exempt or exclude them from Request for Release of Funds (RROF) and environmental certification requirements (24 CFR sections 58.1, 58.22, 58.34, 58.35, and 570.604). Accordingly, the grantee should maintain documentation if any determination not to make an environmental review was made consistent with the criteria contained in 24 CFR sections 58.34 and 58.35(b). Condition/Context ? Per discussion with grant management, the documentation substantiating the exempt status of the environmental reviews were completed, however the documentation was lost due to unforeseen circumstances and was unavailable for observation during the audit process. Per our understanding of the projects and discussions with management, the projects are effectively exempt based on 24 CFR 58.34. However, the exempt status of the projects could not be verified because the documentation was not properly retained by the County. Cause ? During the year the grant management team had to relocate, and the physical documentation got misplaced during the process. The grant manager handling the documentation of the environmental reviews experienced technology issues which further caused a loss of information. Effect ? Failure to retain or backup documentation 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 storing and backing up documentation pertaining to environmental review. Views of Responsible Officials ? See Corrective Action Plan
Finding 2022-02: Control and Compliance Finding ? Significant Deficiency Coronavirus State and Local Fiscal Recovery Funds ? Reporting ALN #21.027 ? Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Criteria ? As noted in the 2022 OMB Compliance Supplement and the grant agreements, Quarterly Project and Expenditure Reports are required to be submitted to the Treasury?s Office of Inspector General by grantees to report financial data, projects funded, expenditures, and contracts/subawards over $50,000. Condition/Context ? During the testing of the reporting compliance requirement for the CSLFRF program, we tested all four Project and Expenditure reports that were submitted to the grantor in fiscal year 2022 (one initial report and three quarterly reports). We noted that within each quarterly report, subsequent to the initial report submitted for the March 2021 ? December 2021 reporting period, the cumulative expenditures and obligations from the prior period report plus the current period expenditures and obligations reported did not mathematically agree to the cumulative expenditures and obligations on the report for that period. In addition to the mathematical differences found, the reported cumulative obligations following the initial report (Quarters 2, 3, and 4) did not agree to underlying support. Cause ? The grants administrators did not accurately report cumulative expenditures and obligations that occurred over the cumulation of the grant. There also was a lack of review by the grants audit to ensure accurate reporting. Effect ? Inaccurate reporting of expenditures and obligations of each project from report to report was communicated to the grantor. Inappropriate representation of expenditures and obligations on reporting may result in the early termination of the grant award or cessation of future funding. Questioned Cost ? None. Recommendations ? Management should ensure that they have a mechanism for tracking the reporting requirements and activity occurring in each reporting period. Management should also ensure all submitted reports are properly reviewed for all reporting requirements. Views of Responsible Officials ? See Corrective Action Plan.
Finding 2022-02: Control and Compliance Finding ? Significant Deficiency Coronavirus State and Local Fiscal Recovery Funds ? Reporting ALN #21.027 ? Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Criteria ? As noted in the 2022 OMB Compliance Supplement and the grant agreements, Quarterly Project and Expenditure Reports are required to be submitted to the Treasury?s Office of Inspector General by grantees to report financial data, projects funded, expenditures, and contracts/subawards over $50,000. Condition/Context ? During the testing of the reporting compliance requirement for the CSLFRF program, we tested all four Project and Expenditure reports that were submitted to the grantor in fiscal year 2022 (one initial report and three quarterly reports). We noted that within each quarterly report, subsequent to the initial report submitted for the March 2021 ? December 2021 reporting period, the cumulative expenditures and obligations from the prior period report plus the current period expenditures and obligations reported did not mathematically agree to the cumulative expenditures and obligations on the report for that period. In addition to the mathematical differences found, the reported cumulative obligations following the initial report (Quarters 2, 3, and 4) did not agree to underlying support. Cause ? The grants administrators did not accurately report cumulative expenditures and obligations that occurred over the cumulation of the grant. There also was a lack of review by the grants audit to ensure accurate reporting. Effect ? Inaccurate reporting of expenditures and obligations of each project from report to report was communicated to the grantor. Inappropriate representation of expenditures and obligations on reporting may result in the early termination of the grant award or cessation of future funding. Questioned Cost ? None. Recommendations ? Management should ensure that they have a mechanism for tracking the reporting requirements and activity occurring in each reporting period. Management should also ensure all submitted reports are properly reviewed for all reporting requirements. Views of Responsible Officials ? See Corrective Action Plan.
Finding 2022-04: Special Test ? Reporting ? Significant Deficiency in Controls over Compliance and Noncompliance ALN #14.218? Community Development Block/Entitlement Grants 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 $2,497,138 was passed through to sub recipients during the year and the subawards were not reported in the FSRS. There was a total of seven subrecipients that had expenses greater than $30,000 that were not reported in the FSRS. Dollar amount of Tested Transactions $2,497,138 Subaward not reported $2,497,138 Report not timely $2,497,138 Subaward amount incorrect 0 Subaward missing key elements. $2,497,138 Cause ? Grant Management was not aware of the reporting requirement. Effect ? Failure to report sub-award 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 in the FSRS. Views of Responsible Officials ? See Corrective Action Plan.
Finding 2022-03: Special Tests ? Required Certifications and HUD Approvals and Environmental Reviews ? Significant Deficiency in Controls over Compliance and Noncompliance ALN #14.218? Community Development Block/Entitlement Grants (CDBG) Criteria ? CDBG funds (and local funds to be reimbursed with CDBG funds) cannot be obligated or expended before receipt of Department of Housing and Urban Development (HUD) approval of a Request for Release of Funds (RROF) and environmental certification, except for exempt activities under 24 CFR section 58.34 Projects must have an environmental review unless they meet criteria specified in the regulations that would exempt or exclude them from Request for Release of Funds (RROF) and environmental certification requirements (24 CFR sections 58.1, 58.22, 58.34, 58.35, and 570.604). Accordingly, the grantee should maintain documentation if any determination not to make an environmental review was made consistent with the criteria contained in 24 CFR sections 58.34 and 58.35(b). Condition/Context ? Per discussion with grant management, the documentation substantiating the exempt status of the environmental reviews were completed, however the documentation was lost due to unforeseen circumstances and was unavailable for observation during the audit process. Per our understanding of the projects and discussions with management, the projects are effectively exempt based on 24 CFR 58.34. However, the exempt status of the projects could not be verified because the documentation was not properly retained by the County. Cause ? During the year the grant management team had to relocate, and the physical documentation got misplaced during the process. The grant manager handling the documentation of the environmental reviews experienced technology issues which further caused a loss of information. Effect ? Failure to retain or backup documentation 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 storing and backing up documentation pertaining to environmental review. Views of Responsible Officials ? See Corrective Action Plan
Finding 2022-04: Special Test ? Reporting ? Significant Deficiency in Controls over Compliance and Noncompliance ALN #14.218? Community Development Block/Entitlement Grants 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 $2,497,138 was passed through to sub recipients during the year and the subawards were not reported in the FSRS. There was a total of seven subrecipients that had expenses greater than $30,000 that were not reported in the FSRS. Dollar amount of Tested Transactions $2,497,138 Subaward not reported $2,497,138 Report not timely $2,497,138 Subaward amount incorrect 0 Subaward missing key elements. $2,497,138 Cause ? Grant Management was not aware of the reporting requirement. Effect ? Failure to report sub-award 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 in the FSRS. Views of Responsible Officials ? See Corrective Action Plan.
Finding 2022-03: Special Tests ? Required Certifications and HUD Approvals and Environmental Reviews ? Significant Deficiency in Controls over Compliance and Noncompliance ALN #14.218? Community Development Block/Entitlement Grants (CDBG) Criteria ? CDBG funds (and local funds to be reimbursed with CDBG funds) cannot be obligated or expended before receipt of Department of Housing and Urban Development (HUD) approval of a Request for Release of Funds (RROF) and environmental certification, except for exempt activities under 24 CFR section 58.34 Projects must have an environmental review unless they meet criteria specified in the regulations that would exempt or exclude them from Request for Release of Funds (RROF) and environmental certification requirements (24 CFR sections 58.1, 58.22, 58.34, 58.35, and 570.604). Accordingly, the grantee should maintain documentation if any determination not to make an environmental review was made consistent with the criteria contained in 24 CFR sections 58.34 and 58.35(b). Condition/Context ? Per discussion with grant management, the documentation substantiating the exempt status of the environmental reviews were completed, however the documentation was lost due to unforeseen circumstances and was unavailable for observation during the audit process. Per our understanding of the projects and discussions with management, the projects are effectively exempt based on 24 CFR 58.34. However, the exempt status of the projects could not be verified because the documentation was not properly retained by the County. Cause ? During the year the grant management team had to relocate, and the physical documentation got misplaced during the process. The grant manager handling the documentation of the environmental reviews experienced technology issues which further caused a loss of information. Effect ? Failure to retain or backup documentation 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 storing and backing up documentation pertaining to environmental review. Views of Responsible Officials ? See Corrective Action Plan
Finding 2022-02: Control and Compliance Finding ? Significant Deficiency Coronavirus State and Local Fiscal Recovery Funds ? Reporting ALN #21.027 ? Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Criteria ? As noted in the 2022 OMB Compliance Supplement and the grant agreements, Quarterly Project and Expenditure Reports are required to be submitted to the Treasury?s Office of Inspector General by grantees to report financial data, projects funded, expenditures, and contracts/subawards over $50,000. Condition/Context ? During the testing of the reporting compliance requirement for the CSLFRF program, we tested all four Project and Expenditure reports that were submitted to the grantor in fiscal year 2022 (one initial report and three quarterly reports). We noted that within each quarterly report, subsequent to the initial report submitted for the March 2021 ? December 2021 reporting period, the cumulative expenditures and obligations from the prior period report plus the current period expenditures and obligations reported did not mathematically agree to the cumulative expenditures and obligations on the report for that period. In addition to the mathematical differences found, the reported cumulative obligations following the initial report (Quarters 2, 3, and 4) did not agree to underlying support. Cause ? The grants administrators did not accurately report cumulative expenditures and obligations that occurred over the cumulation of the grant. There also was a lack of review by the grants audit to ensure accurate reporting. Effect ? Inaccurate reporting of expenditures and obligations of each project from report to report was communicated to the grantor. Inappropriate representation of expenditures and obligations on reporting may result in the early termination of the grant award or cessation of future funding. Questioned Cost ? None. Recommendations ? Management should ensure that they have a mechanism for tracking the reporting requirements and activity occurring in each reporting period. Management should also ensure all submitted reports are properly reviewed for all reporting requirements. Views of Responsible Officials ? See Corrective Action Plan.
Finding 2022-02: Control and Compliance Finding ? Significant Deficiency Coronavirus State and Local Fiscal Recovery Funds ? Reporting ALN #21.027 ? Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Criteria ? As noted in the 2022 OMB Compliance Supplement and the grant agreements, Quarterly Project and Expenditure Reports are required to be submitted to the Treasury?s Office of Inspector General by grantees to report financial data, projects funded, expenditures, and contracts/subawards over $50,000. Condition/Context ? During the testing of the reporting compliance requirement for the CSLFRF program, we tested all four Project and Expenditure reports that were submitted to the grantor in fiscal year 2022 (one initial report and three quarterly reports). We noted that within each quarterly report, subsequent to the initial report submitted for the March 2021 ? December 2021 reporting period, the cumulative expenditures and obligations from the prior period report plus the current period expenditures and obligations reported did not mathematically agree to the cumulative expenditures and obligations on the report for that period. In addition to the mathematical differences found, the reported cumulative obligations following the initial report (Quarters 2, 3, and 4) did not agree to underlying support. Cause ? The grants administrators did not accurately report cumulative expenditures and obligations that occurred over the cumulation of the grant. There also was a lack of review by the grants audit to ensure accurate reporting. Effect ? Inaccurate reporting of expenditures and obligations of each project from report to report was communicated to the grantor. Inappropriate representation of expenditures and obligations on reporting may result in the early termination of the grant award or cessation of future funding. Questioned Cost ? None. Recommendations ? Management should ensure that they have a mechanism for tracking the reporting requirements and activity occurring in each reporting period. Management should also ensure all submitted reports are properly reviewed for all reporting requirements. Views of Responsible Officials ? See Corrective Action Plan.