Audit 290965

FY End
2023-09-30
Total Expended
$18.97M
Findings
4
Programs
45
Organization: City of Columbia, Missouri (MO)
Year: 2023 Accepted: 2024-02-16

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
369581 2023-001 Significant Deficiency Yes L
369582 2023-001 Significant Deficiency Yes L
946023 2023-001 Significant Deficiency Yes L
946024 2023-001 Significant Deficiency Yes L

Programs

ALN Program Spent Major Findings
20.106 Cares Act Grant $2.35M - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $2.28M Yes 0
20.507 Federal Transit_formula Grants $2.22M - 0
20.106 Airport Improvement Program $2.16M - 0
11.307 Economic Development and Food Supply Chain Stabilization $1.08M Yes 0
20.205 Highway Planning and Construction $608,187 - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $501,773 - 0
93.391 Local Public Health Disparities Initiative $317,654 - 0
97.036 Fema $273,684 - 0
93.323 Elc: Enhancing Detection Expansion $264,233 Yes 1
93.767 Core Public Health $246,626 - 0
93.323 Elc: Community Health Worker Initiative $237,297 Yes 1
14.218 Community Development Block Grants/entitlement Grants $236,222 - 0
93.994 Hiv Case Management $214,297 - 0
14.239 Home Investment Partnerships Program $206,243 - 0
93.268 Covid-19 and Adult Vaccinations $200,987 - 0
15.916 Phillips Pickleball Court $199,432 - 0
93.977 Disease Intervention Specialist Workforce Program $175,676 - 0
93.069 Public Health Emergency Preparedness $161,743 - 0
93.994 Healthy Families Missouri Home Visiting $137,954 - 0
93.940 Ending the Hiv Epidemic $129,831 - 0
93.217 Family Planning_services $105,638 - 0
93.354 Workforce $96,457 - 0
20.616 Dwi Traffic Unit $85,479 - 0
93.994 Maternal and Child Health Services Block Grant to the States $72,508 - 0
93.940 Hiv Prevention Activities_health Department Based $71,334 - 0
16.588 Domestic Violence Enforcement Grant (dove) $69,565 - 0
20.600 Dedicated Hmv Unit $51,533 - 0
93.994 Teen Outreach Program $45,000 - 0
93.136 Overdose Data to Action $41,500 - 0
97.090 Law Enforcement Officer Reimbursement, Transportation Security Administration (tsa) $40,790 - 0
15.916 Albert-Oakland Park Improvement $21,997 - 0
93.575 Local Sanitation Inspections for Child Care Facilities $20,075 - 0
45.024 American Rescue Plan Grants to Local Arts Agencies $14,987 - 0
10.559 Summer Food Service Program for Children $12,993 - 0
20.616 Dwi Saturation Enforcement $10,667 - 0
93.575 Child Care and Development Block Grant $10,374 - 0
93.997 Monkeypox Response $10,000 - 0
20.607 Hiring Cops $6,136 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $4,043 - 0
20.607 Youth Alcohol Enforcement Campaign $2,101 - 0
20.505 Federal Transit Technical Studies Grant $2,076 - 0
20.600 Hmv Enforcement $1,996 - 0
93.898 Show Me Healthy Women $1,862 - 0
95.001 High Intensity Drug Trafficking Areas Program $972 - 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. 2023. 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 2023-001 - Report review (Significant Deficiency): Assistance # 93.323 - Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Federal Award # and Year: DH220051246, DH220051699, 2023 Name of Federal Agency: U.S. Department of Health and Human Services Name of Pass-Thru Entity: Missouri Department of Health Type of Compliance Finding: L - Reporting Condition: A secondary review or approval of quarterly reports was not documented. One of the required quarterly reports was not filed during the year. Neither of the annual reports we filed until requested during the audit. Criteria: Someone other than the preparer of the reports should be reviewing the information for accuracy prior to submission. Someone should be ensuring that all required reports are being properly submitted. Questioned Costs: N/A Repeat Finding: Yes. Reported as 2022-005 in prior year. Context: Supervisor approval was not documented for the quarterly reports. Additionally, one of the required quarterly reports was not filed during the year. Neither of the annual reports were filed until requested during the audit. Cause: The City did not have a formal policy in place to document secondary review or approval of the reports prior to submission or to monitor reporting process to ensure required reports were completed. Effect: Information could be incorrectly reported to the pass-thru agency. Recommendations: We recommend that City implement a policy to ensure reports are being reviewed by someone other than the preparer and the documentation of that review be maintained. Additionally, we recommend that the City implement a o=policy to ensure reports are filed in accordance with the grant agreement. Views of Responsible Officials (Unaudited): Management acknowledges that a secondary review or approval of grant reports is an important internal control, and 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 notify departments of upcoming submission deadlines. Contact Person: Matthew Lue, Director of Finance Anticipated completion date: This will be accomplished for the fiscal year 2024 year-end.
Finding 2023-001 - Report review (Significant Deficiency): Assistance # 93.323 - Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Federal Award # and Year: DH220051246, DH220051699, 2023 Name of Federal Agency: U.S. Department of Health and Human Services Name of Pass-Thru Entity: Missouri Department of Health Type of Compliance Finding: L - Reporting Condition: A secondary review or approval of quarterly reports was not documented. One of the required quarterly reports was not filed during the year. Neither of the annual reports we filed until requested during the audit. Criteria: Someone other than the preparer of the reports should be reviewing the information for accuracy prior to submission. Someone should be ensuring that all required reports are being properly submitted. Questioned Costs: N/A Repeat Finding: Yes. Reported as 2022-005 in prior year. Context: Supervisor approval was not documented for the quarterly reports. Additionally, one of the required quarterly reports was not filed during the year. Neither of the annual reports were filed until requested during the audit. Cause: The City did not have a formal policy in place to document secondary review or approval of the reports prior to submission or to monitor reporting process to ensure required reports were completed. Effect: Information could be incorrectly reported to the pass-thru agency. Recommendations: We recommend that City implement a policy to ensure reports are being reviewed by someone other than the preparer and the documentation of that review be maintained. Additionally, we recommend that the City implement a o=policy to ensure reports are filed in accordance with the grant agreement. Views of Responsible Officials (Unaudited): Management acknowledges that a secondary review or approval of grant reports is an important internal control, and 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 notify departments of upcoming submission deadlines. Contact Person: Matthew Lue, Director of Finance Anticipated completion date: This will be accomplished for the fiscal year 2024 year-end.
Finding 2023-001 - Report review (Significant Deficiency): Assistance # 93.323 - Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Federal Award # and Year: DH220051246, DH220051699, 2023 Name of Federal Agency: U.S. Department of Health and Human Services Name of Pass-Thru Entity: Missouri Department of Health Type of Compliance Finding: L - Reporting Condition: A secondary review or approval of quarterly reports was not documented. One of the required quarterly reports was not filed during the year. Neither of the annual reports we filed until requested during the audit. Criteria: Someone other than the preparer of the reports should be reviewing the information for accuracy prior to submission. Someone should be ensuring that all required reports are being properly submitted. Questioned Costs: N/A Repeat Finding: Yes. Reported as 2022-005 in prior year. Context: Supervisor approval was not documented for the quarterly reports. Additionally, one of the required quarterly reports was not filed during the year. Neither of the annual reports were filed until requested during the audit. Cause: The City did not have a formal policy in place to document secondary review or approval of the reports prior to submission or to monitor reporting process to ensure required reports were completed. Effect: Information could be incorrectly reported to the pass-thru agency. Recommendations: We recommend that City implement a policy to ensure reports are being reviewed by someone other than the preparer and the documentation of that review be maintained. Additionally, we recommend that the City implement a o=policy to ensure reports are filed in accordance with the grant agreement. Views of Responsible Officials (Unaudited): Management acknowledges that a secondary review or approval of grant reports is an important internal control, and 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 notify departments of upcoming submission deadlines. Contact Person: Matthew Lue, Director of Finance Anticipated completion date: This will be accomplished for the fiscal year 2024 year-end.
Finding 2023-001 - Report review (Significant Deficiency): Assistance # 93.323 - Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Federal Award # and Year: DH220051246, DH220051699, 2023 Name of Federal Agency: U.S. Department of Health and Human Services Name of Pass-Thru Entity: Missouri Department of Health Type of Compliance Finding: L - Reporting Condition: A secondary review or approval of quarterly reports was not documented. One of the required quarterly reports was not filed during the year. Neither of the annual reports we filed until requested during the audit. Criteria: Someone other than the preparer of the reports should be reviewing the information for accuracy prior to submission. Someone should be ensuring that all required reports are being properly submitted. Questioned Costs: N/A Repeat Finding: Yes. Reported as 2022-005 in prior year. Context: Supervisor approval was not documented for the quarterly reports. Additionally, one of the required quarterly reports was not filed during the year. Neither of the annual reports were filed until requested during the audit. Cause: The City did not have a formal policy in place to document secondary review or approval of the reports prior to submission or to monitor reporting process to ensure required reports were completed. Effect: Information could be incorrectly reported to the pass-thru agency. Recommendations: We recommend that City implement a policy to ensure reports are being reviewed by someone other than the preparer and the documentation of that review be maintained. Additionally, we recommend that the City implement a o=policy to ensure reports are filed in accordance with the grant agreement. Views of Responsible Officials (Unaudited): Management acknowledges that a secondary review or approval of grant reports is an important internal control, and 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 notify departments of upcoming submission deadlines. Contact Person: Matthew Lue, Director of Finance Anticipated completion date: This will be accomplished for the fiscal year 2024 year-end.