Audit 350428

FY End
2024-09-30
Total Expended
$18.72M
Findings
4
Programs
51
Organization: City of Columbia, Missouri (MO)
Year: 2024 Accepted: 2025-03-30

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
540741 2024-001 Significant Deficiency Yes L
540742 2024-001 Significant Deficiency Yes L
1117183 2024-001 Significant Deficiency Yes L
1117184 2024-001 Significant Deficiency Yes L

Programs

ALN Program Spent Major Findings
20.507 Federal Transit Formula Grants $2.25M - 0
93.917 Hiv Case Management $990,393 Yes 0
14.218 Community Development Block Grants/entitlement Grants $842,199 Yes 0
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $629,401 - 0
20.505 Federal Transit Technical Studies Grant $408,844 - 0
93.767 Core Public Health $386,448 - 0
93.354 Workforce $362,427 - 0
93.977 Disease Intervention Specialist Workforce Program $323,777 - 0
15.916 Albert-Oakland Park Improvement $288,265 - 0
93.323 Elc: Community Health Worker Initiative $281,097 Yes 1
14.239 Home Program $223,281 - 0
20.106 Airport Improvement Program, Infrastructure Investment and Jobs Act Programs, and Covid-19 Airports Programs $203,130 - 0
93.940 Hiv Prevention Activities $197,092 - 0
93.069 Phep-Regional Bio-Terrorism $170,956 - 0
93.994 Healthy Families Missouri Home Visiting $147,504 - 0
93.391 Local Public Health Disparities Initiative $129,445 - 0
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $124,559 - 0
93.940 Ending the Hiv Epidemic $119,337 - 0
16.035 Coronavirus Emergency Supplies Funding $108,717 - 0
93.268 Covid-19 and Adult Vaccinations $101,328 - 0
20.939 Safe Streets and Roads for All $87,861 - 0
93.008 Medical Reserve Corps $82,731 - 0
15.916 Philips Pickleball Court $75,212 - 0
93.994 Maternal and Child Health $75,102 - 0
93.217 Family Planning Services $59,938 - 0
14.218 Covid-19-Cdbg-Cares $58,973 Yes 0
16.588 Domestic Violence Enforcement Grant (dove) $56,501 - 0
20.600 Dedicated Hmv Unit $56,405 - 0
93.323 Elc: Enhancing Detection Expansion $51,563 Yes 1
93.136 Overdose Data to Action $49,797 - 0
97.137 State and Local Cybersecurity $43,819 - 0
93.967 Public Health Infrastructure $42,782 - 0
20.219 Recreational Trails Agreement - Perche Creek Trail $41,405 - 0
93.575 Local Sanitation Inspections for Child Care Facilities $38,977 - 0
93.994 Teen Outreach Program $37,000 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $21,777 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $20,000 Yes 0
20.616 Dwi Traffic Unit $19,510 - 0
97.090 Law Enforcement Officer Reimbursement, Transportation Security Administration (tsa) $18,594 - 0
93.575 Child Care and Development Block Grant $15,000 - 0
10.559 Summer Food Service Program for Children $14,682 - 0
93.116 Tuberculosis Diagnostic Services $7,754 - 0
97.036 Fema $5,285 - 0
66.046 Climate Pollution Reduction Grants $5,027 - 0
20.616 Dwi Saturation Enforcement $3,901 - 0
95.001 High Intensity Drug Trafficking Areas Program $3,071 - 0
20.600 Hmv Enforcement $2,372 - 0
93.898 Show Me Healthy Women $1,393 - 0
20.607 Youth Alcohol Enforcement Campaign $512 - 0
11.307 Economic Development and Food Supply Chain Stabilization $-105,709 - 0
20.205 Highway Planning and Construction $-119,124 - 0

Contacts

Name Title Type
WZR4KM9CBTV3 Matthew Lue Auditee
5738747457 Brian Holst Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures of federal awards are recognized under the modified accrual basis of accounting. Such expenditures 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: City voluntarily elected not to use the de minimis cost rate. The accompanying schedule of expenditures of federal awards (SEFA) includes the federal grant activity of the City of Columbia, Missouri (City) for the year ended September 30. 2024. All federal financial assistance received directly from federal agencies, as well as federal assistance passed through other governmental agencies expended during the year, is included in the schedule. The information in the schedule is presented in accordance with the requirement of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles and Audit Requirement for Federal Awards (Uniform Guidance). Therefore, some amounts presented in the schedule may differ from the amounts presented in or used in the preparation of the basic financial statements. Because the SEFA presents only a select portion of the operations of the City, it is not intended to and does not present the basic financial position of the City,
Title: Significant Accounting Policies Accounting Policies: Expenditures of federal awards are recognized under the modified accrual basis of accounting. Such expenditures 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: City voluntarily elected not to use the de minimis cost rate. Expenditures of federal awards are recognized under the modified accrual basis of accounting. Such expenditures 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: Indirect Cost Rate Accounting Policies: Expenditures of federal awards are recognized under the modified accrual basis of accounting. Such expenditures 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: City voluntarily elected not to use the de minimis cost rate. The City elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance.

Finding Details

Finding 2024-001 – Report review (Significant Deficiency) (Repeat Finding): Assistance # 93.323 – Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Federal Award # and Year: DH220051246, DH220051699, 2024 Name of Federal Agency: U.S. Department of Health and Human Services Name of Pass-Thru Agency: Missouri Department of Health Type of Compliance Finding: L - Reporting Condition: One of the quarterly reports was not filed during the year. Three quarterly reports were not filed timely within their due dates and one of the required annual reports was not filed timely. Criteria: Someone should be ensuring that all required reports are being properly submitted prior to their due dates. Questioned Costs: N/A Repeat Finding: Yes. Reported as 2023-001 in prior year. Context: One of the quarterly reports was not filed until requested during the audit. Three quarterly reports were not filed timely within their due dates and one of the required annual reports was not filed timely. Cause: The City did not follow their policy in place to monitor reporting process, or notify departments of upcoming deadlines, to ensure required reports were completed. Effect: Information could be incorrectly reported to the pass-thru agency. Recommendations: We recommend that the City implement a policy to ensure reports are filed in accordance with the grant agreement. Views of Responsible Officials (Unaudited): Management acknowledges that timely grant reporting is essential. Corrective Action Plan (Unaudited): The Department of Public Health and Human Services (PHHS) will create the proper processes and procedures to track reporting requirements and document internal review and approvals prior to report submissions. The Grant Administrator will create the proper processes and procedures to track reporting requirements and completed submissions, and notify departments of upcoming submission deadlines. Contact Person: Matthew Lue, Director of Finance Anticipated Completion Date: This will be accomplished for the fiscal year 2025 year-end.
Finding 2024-001 – Report review (Significant Deficiency) (Repeat Finding): Assistance # 93.323 – Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Federal Award # and Year: DH220051246, DH220051699, 2024 Name of Federal Agency: U.S. Department of Health and Human Services Name of Pass-Thru Agency: Missouri Department of Health Type of Compliance Finding: L - Reporting Condition: One of the quarterly reports was not filed during the year. Three quarterly reports were not filed timely within their due dates and one of the required annual reports was not filed timely. Criteria: Someone should be ensuring that all required reports are being properly submitted prior to their due dates. Questioned Costs: N/A Repeat Finding: Yes. Reported as 2023-001 in prior year. Context: One of the quarterly reports was not filed until requested during the audit. Three quarterly reports were not filed timely within their due dates and one of the required annual reports was not filed timely. Cause: The City did not follow their policy in place to monitor reporting process, or notify departments of upcoming deadlines, to ensure required reports were completed. Effect: Information could be incorrectly reported to the pass-thru agency. Recommendations: We recommend that the City implement a policy to ensure reports are filed in accordance with the grant agreement. Views of Responsible Officials (Unaudited): Management acknowledges that timely grant reporting is essential. Corrective Action Plan (Unaudited): The Department of Public Health and Human Services (PHHS) will create the proper processes and procedures to track reporting requirements and document internal review and approvals prior to report submissions. The Grant Administrator will create the proper processes and procedures to track reporting requirements and completed submissions, and notify departments of upcoming submission deadlines. Contact Person: Matthew Lue, Director of Finance Anticipated Completion Date: This will be accomplished for the fiscal year 2025 year-end.
Finding 2024-001 – Report review (Significant Deficiency) (Repeat Finding): Assistance # 93.323 – Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Federal Award # and Year: DH220051246, DH220051699, 2024 Name of Federal Agency: U.S. Department of Health and Human Services Name of Pass-Thru Agency: Missouri Department of Health Type of Compliance Finding: L - Reporting Condition: One of the quarterly reports was not filed during the year. Three quarterly reports were not filed timely within their due dates and one of the required annual reports was not filed timely. Criteria: Someone should be ensuring that all required reports are being properly submitted prior to their due dates. Questioned Costs: N/A Repeat Finding: Yes. Reported as 2023-001 in prior year. Context: One of the quarterly reports was not filed until requested during the audit. Three quarterly reports were not filed timely within their due dates and one of the required annual reports was not filed timely. Cause: The City did not follow their policy in place to monitor reporting process, or notify departments of upcoming deadlines, to ensure required reports were completed. Effect: Information could be incorrectly reported to the pass-thru agency. Recommendations: We recommend that the City implement a policy to ensure reports are filed in accordance with the grant agreement. Views of Responsible Officials (Unaudited): Management acknowledges that timely grant reporting is essential. Corrective Action Plan (Unaudited): The Department of Public Health and Human Services (PHHS) will create the proper processes and procedures to track reporting requirements and document internal review and approvals prior to report submissions. The Grant Administrator will create the proper processes and procedures to track reporting requirements and completed submissions, and notify departments of upcoming submission deadlines. Contact Person: Matthew Lue, Director of Finance Anticipated Completion Date: This will be accomplished for the fiscal year 2025 year-end.
Finding 2024-001 – Report review (Significant Deficiency) (Repeat Finding): Assistance # 93.323 – Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Federal Award # and Year: DH220051246, DH220051699, 2024 Name of Federal Agency: U.S. Department of Health and Human Services Name of Pass-Thru Agency: Missouri Department of Health Type of Compliance Finding: L - Reporting Condition: One of the quarterly reports was not filed during the year. Three quarterly reports were not filed timely within their due dates and one of the required annual reports was not filed timely. Criteria: Someone should be ensuring that all required reports are being properly submitted prior to their due dates. Questioned Costs: N/A Repeat Finding: Yes. Reported as 2023-001 in prior year. Context: One of the quarterly reports was not filed until requested during the audit. Three quarterly reports were not filed timely within their due dates and one of the required annual reports was not filed timely. Cause: The City did not follow their policy in place to monitor reporting process, or notify departments of upcoming deadlines, to ensure required reports were completed. Effect: Information could be incorrectly reported to the pass-thru agency. Recommendations: We recommend that the City implement a policy to ensure reports are filed in accordance with the grant agreement. Views of Responsible Officials (Unaudited): Management acknowledges that timely grant reporting is essential. Corrective Action Plan (Unaudited): The Department of Public Health and Human Services (PHHS) will create the proper processes and procedures to track reporting requirements and document internal review and approvals prior to report submissions. The Grant Administrator will create the proper processes and procedures to track reporting requirements and completed submissions, and notify departments of upcoming submission deadlines. Contact Person: Matthew Lue, Director of Finance Anticipated Completion Date: This will be accomplished for the fiscal year 2025 year-end.