Audit 13365

FY End
2022-12-31
Total Expended
$13.24M
Findings
6
Programs
25
Organization: Douglas County, Kansas (KS)
Year: 2022 Accepted: 2024-01-24
Auditor: Bt&co P A

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
9654 2022-001 Material Weakness Yes AB
9655 2022-001 Material Weakness Yes AB
9656 2022-001 Material Weakness Yes AB
586096 2022-001 Material Weakness Yes AB
586097 2022-001 Material Weakness Yes AB
586098 2022-001 Material Weakness Yes AB

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $10.76M Yes 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $402,131 - 0
93.778 Medical Assistance Program $276,057 - 0
93.268 Immunization Cooperative Agreements $193,711 - 0
97.042 Emergency Management Performance Grants $107,523 - 0
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $78,964 - 0
10.902 Soil and Water Conservation $70,170 - 0
16.922 Equitable Sharing Program $51,348 - 0
93.069 Public Health Emergency Preparedness $51,219 - 0
16.575 Crime Victim Assistance $50,186 - 0
93.217 Family Planning_services $46,996 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $40,817 - 1
10.935 Urban Agriculture and Innovative Production $40,700 - 0
93.991 Preventive Health and Health Services Block Grant $37,548 - 0
93.994 Maternal and Child Health Services Block Grant to the States $34,695 - 0
20.205 Highway Planning and Construction $31,473 - 0
93.558 Temporary Assistance for Needy Families $27,524 - 0
16.588 Violence Against Women Formula Grants $23,879 - 0
14.218 Community Development Block Grants/entitlement Grants $22,916 - 0
14.231 Emergency Solutions Grant Program $14,966 - 0
15.916 Outdoor Recreation_acquisition, Development and Planning $12,052 - 0
93.387 National and State Tobacco Control Program (b) $10,000 - 0
93.575 Child Care and Development Block Grant $8,894 - 0
15.904 Historic Preservation Fund Grants-in-Aid $5,163 - 0
20.600 State and Community Highway Safety $428 - 0

Contacts

Name Title Type
X1JBJMDRYNV1 Brooke Sauer Auditee
7853302863 Emily Sheldon Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Summary of Significant Accounting Policies Expenditures reported on the schedule are reported on a regulatory basis of accounting. This basis is designed to follow the financial reporting provisions of the Kansas Municipal Audit and Accounting Guide, which is a basis of accounting other than accounting principles generally accepted in the United States of America. The expenditures on the schedule are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has not elected to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the schedule) includes the federal grant activity of Douglas County, Kansas and the related municipal entity of Lawrence/Douglas County Health Department (collectively, “the County”) under programs of the federal government for the year ended December 31, 2022. 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 (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the financial statements. Because the Schedule presents only a selected portion of the operations of the County, it is not intended to and does not present the financial position of the County.
Title: Summary of Significant Accounting Policies Accounting Policies: Summary of Significant Accounting Policies Expenditures reported on the schedule are reported on a regulatory basis of accounting. This basis is designed to follow the financial reporting provisions of the Kansas Municipal Audit and Accounting Guide, which is a basis of accounting other than accounting principles generally accepted in the United States of America. The expenditures on the schedule are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has not elected to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. Expenditures reported on the schedule are reported on a regulatory basis of accounting. This basis is designed to follow the financial reporting provisions of the Kansas Municipal Audit and Accounting Guide, which is a basis of accounting other than accounting principles generally accepted in the United States of America. The expenditures on the schedule are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement.
Title: De Minimus Indirect Cost Rate Accounting Policies: Summary of Significant Accounting Policies Expenditures reported on the schedule are reported on a regulatory basis of accounting. This basis is designed to follow the financial reporting provisions of the Kansas Municipal Audit and Accounting Guide, which is a basis of accounting other than accounting principles generally accepted in the United States of America. The expenditures on the schedule are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has not elected to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The County has not elected to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance.

Finding Details

Grant Program/Award – U.S. Department of Health and Human Services, ALN: 93.323, COVID-19 -Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Prior Reference Number – 2021-002 Compliance Requirements – Activities Allowed or Unallowed and Allowable Costs/Cost Principles Condition – In fiscal year 2021, our expense testing revealed that 45 of 60 expenditures tested, all related to salaries and benefits expenditures, showed no evidence of time and effort to support how the salaries and benefits allocation was determined, with 6 of the same 45 expenditures lacking evidence of payroll documentation for the amounts charged to the grant. Further, 47 of 60 expenses tested showed no evidence of review by a person knowledgeable of the grant. As the finding was not identified until fiscal year 2022, the condition was present in fiscal year 2022. Criteria – The County’s internal controls should be designed to ensure proper recordkeeping of expenses charged to the federal program and review of the documentation that supports expenses. Cause – The County experienced turnover during and after the fiscal year. Questioned Costs – None for fiscal year 2022. Known questioned costs in fiscal year 2021 - $ 4,513. Likely questioned costs in fiscal year 2021 - $ 23,792. Effect – Unallowed costs could be charged to the federal program. Recommendation – We recommend that the County implement controls and processes that ensure that expenditures charged to the program are reviewed and documented to ensure costs are allowable and properly supported.
Grant Program/Award – U.S. Department of Health and Human Services, ALN: 93.323, COVID-19 -Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Prior Reference Number – 2021-002 Compliance Requirements – Activities Allowed or Unallowed and Allowable Costs/Cost Principles Condition – In fiscal year 2021, our expense testing revealed that 45 of 60 expenditures tested, all related to salaries and benefits expenditures, showed no evidence of time and effort to support how the salaries and benefits allocation was determined, with 6 of the same 45 expenditures lacking evidence of payroll documentation for the amounts charged to the grant. Further, 47 of 60 expenses tested showed no evidence of review by a person knowledgeable of the grant. As the finding was not identified until fiscal year 2022, the condition was present in fiscal year 2022. Criteria – The County’s internal controls should be designed to ensure proper recordkeeping of expenses charged to the federal program and review of the documentation that supports expenses. Cause – The County experienced turnover during and after the fiscal year. Questioned Costs – None for fiscal year 2022. Known questioned costs in fiscal year 2021 - $ 4,513. Likely questioned costs in fiscal year 2021 - $ 23,792. Effect – Unallowed costs could be charged to the federal program. Recommendation – We recommend that the County implement controls and processes that ensure that expenditures charged to the program are reviewed and documented to ensure costs are allowable and properly supported.
Grant Program/Award – U.S. Department of Health and Human Services, ALN: 93.323, COVID-19 -Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Prior Reference Number – 2021-002 Compliance Requirements – Activities Allowed or Unallowed and Allowable Costs/Cost Principles Condition – In fiscal year 2021, our expense testing revealed that 45 of 60 expenditures tested, all related to salaries and benefits expenditures, showed no evidence of time and effort to support how the salaries and benefits allocation was determined, with 6 of the same 45 expenditures lacking evidence of payroll documentation for the amounts charged to the grant. Further, 47 of 60 expenses tested showed no evidence of review by a person knowledgeable of the grant. As the finding was not identified until fiscal year 2022, the condition was present in fiscal year 2022. Criteria – The County’s internal controls should be designed to ensure proper recordkeeping of expenses charged to the federal program and review of the documentation that supports expenses. Cause – The County experienced turnover during and after the fiscal year. Questioned Costs – None for fiscal year 2022. Known questioned costs in fiscal year 2021 - $ 4,513. Likely questioned costs in fiscal year 2021 - $ 23,792. Effect – Unallowed costs could be charged to the federal program. Recommendation – We recommend that the County implement controls and processes that ensure that expenditures charged to the program are reviewed and documented to ensure costs are allowable and properly supported.
Grant Program/Award – U.S. Department of Health and Human Services, ALN: 93.323, COVID-19 -Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Prior Reference Number – 2021-002 Compliance Requirements – Activities Allowed or Unallowed and Allowable Costs/Cost Principles Condition – In fiscal year 2021, our expense testing revealed that 45 of 60 expenditures tested, all related to salaries and benefits expenditures, showed no evidence of time and effort to support how the salaries and benefits allocation was determined, with 6 of the same 45 expenditures lacking evidence of payroll documentation for the amounts charged to the grant. Further, 47 of 60 expenses tested showed no evidence of review by a person knowledgeable of the grant. As the finding was not identified until fiscal year 2022, the condition was present in fiscal year 2022. Criteria – The County’s internal controls should be designed to ensure proper recordkeeping of expenses charged to the federal program and review of the documentation that supports expenses. Cause – The County experienced turnover during and after the fiscal year. Questioned Costs – None for fiscal year 2022. Known questioned costs in fiscal year 2021 - $ 4,513. Likely questioned costs in fiscal year 2021 - $ 23,792. Effect – Unallowed costs could be charged to the federal program. Recommendation – We recommend that the County implement controls and processes that ensure that expenditures charged to the program are reviewed and documented to ensure costs are allowable and properly supported.
Grant Program/Award – U.S. Department of Health and Human Services, ALN: 93.323, COVID-19 -Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Prior Reference Number – 2021-002 Compliance Requirements – Activities Allowed or Unallowed and Allowable Costs/Cost Principles Condition – In fiscal year 2021, our expense testing revealed that 45 of 60 expenditures tested, all related to salaries and benefits expenditures, showed no evidence of time and effort to support how the salaries and benefits allocation was determined, with 6 of the same 45 expenditures lacking evidence of payroll documentation for the amounts charged to the grant. Further, 47 of 60 expenses tested showed no evidence of review by a person knowledgeable of the grant. As the finding was not identified until fiscal year 2022, the condition was present in fiscal year 2022. Criteria – The County’s internal controls should be designed to ensure proper recordkeeping of expenses charged to the federal program and review of the documentation that supports expenses. Cause – The County experienced turnover during and after the fiscal year. Questioned Costs – None for fiscal year 2022. Known questioned costs in fiscal year 2021 - $ 4,513. Likely questioned costs in fiscal year 2021 - $ 23,792. Effect – Unallowed costs could be charged to the federal program. Recommendation – We recommend that the County implement controls and processes that ensure that expenditures charged to the program are reviewed and documented to ensure costs are allowable and properly supported.
Grant Program/Award – U.S. Department of Health and Human Services, ALN: 93.323, COVID-19 -Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Prior Reference Number – 2021-002 Compliance Requirements – Activities Allowed or Unallowed and Allowable Costs/Cost Principles Condition – In fiscal year 2021, our expense testing revealed that 45 of 60 expenditures tested, all related to salaries and benefits expenditures, showed no evidence of time and effort to support how the salaries and benefits allocation was determined, with 6 of the same 45 expenditures lacking evidence of payroll documentation for the amounts charged to the grant. Further, 47 of 60 expenses tested showed no evidence of review by a person knowledgeable of the grant. As the finding was not identified until fiscal year 2022, the condition was present in fiscal year 2022. Criteria – The County’s internal controls should be designed to ensure proper recordkeeping of expenses charged to the federal program and review of the documentation that supports expenses. Cause – The County experienced turnover during and after the fiscal year. Questioned Costs – None for fiscal year 2022. Known questioned costs in fiscal year 2021 - $ 4,513. Likely questioned costs in fiscal year 2021 - $ 23,792. Effect – Unallowed costs could be charged to the federal program. Recommendation – We recommend that the County implement controls and processes that ensure that expenditures charged to the program are reviewed and documented to ensure costs are allowable and properly supported.