Finding 638139 (2022-005)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-04-02
Audit: 57136
Organization: City of Columbia, Missouri (MO)

AI Summary

  • Core Issue: Quarterly reports lacked documented secondary review and approval, leading to potential inaccuracies.
  • Impacted Requirements: Compliance with reporting criteria was not met, as reports were not properly reviewed before submission.
  • Recommended Follow-Up: Establish a formal policy for secondary review and timely filing of reports to ensure compliance with grant agreements.

Finding Text

Finding 2022-005 ? Report review (Significant Deficiency): Assistance # 93.323 ? Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Federal Award # and Year: DH220051246, 2021 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: A secondary review or approval of quarterly reports was not documented. One of the required quarterly reports was not filed until requested for the audit. Criteria: Someone other than the preparer of the reports should be reviewing the information for accuracy prior to submission. Someone should also be ensuring that quarterly reports are being properly submitted. Questioned Costs: N/A Context: Supervisor approval was not documented for 2 of the 3 reports selected. Additionally, one of the required quarterly reports was not filed until requested for the audit. The sample size was determined based upon guidelines provided by the AICPA which is not a statistically valid sample. Cause: The City did not have a formal policy in place to require a 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 the City implement a policy to ensure reports are being reviewed by someone other than the preparer and documented. Additionally, 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 a secondary review or approval of grant reports is a worthwhile internal control.

Categories

Reporting Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 61695 2022-003
    Significant Deficiency
  • 61696 2022-004
    Significant Deficiency
  • 61697 2022-005
    Significant Deficiency
  • 61698 2022-003
    Significant Deficiency
  • 638137 2022-003
    Significant Deficiency
  • 638138 2022-004
    Significant Deficiency
  • 638140 2022-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $12.84M
20.106 Airport Improvement Program $9.27M
20.507 Federal Transit_formula Grants $2.98M
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $703,828
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $549,340
14.218 Community Development Block Grants/entitlement Grants $287,594
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $241,680
15.916 Outdoor Recreation_acquisition, Development and Planning $236,792
93.940 Hiv Prevention Activities_health Department Based $228,885
14.239 Home Investment Partnerships Program $216,294
93.767 Children's Health Insurance Program $205,522
97.044 Assistance to Firefighters Grant $182,606
93.069 Public Health Emergency Preparedness $145,107
45.024 Promotion of the Arts_grants to Organizations and Individuals $134,916
93.036 Fema $130,779
97.083 Staffing for Adequate Fire and Emergency Response (safer) $109,097
93.994 Maternal and Child Health Services Block Grant to the States $91,125
20.205 Highway Planning and Construction $73,932
20.600 State and Community Highway Safety $66,983
16.588 Violence Against Women Formula Grants $64,059
93.268 Immunization Cooperative Agreements $51,562
16.738 Edward Byrne Memorial Justice Assistance Grant Program $45,082
97.090 Law Enforcement Officer Reimbursement, Transportation Security Administration $31,620
93.217 Family Planning_services $28,359
93.575 Child Care and Development Block Grant $19,104
93.136 Injury Prevention and Control Research and State and Community Based Programs $17,326
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $17,248
20.607 Alcohol Open Container Requirements $11,138
10.559 Summer Food Service Program for Children $7,488
20.616 National Priority Safety Programs $4,490
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $3,867
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $3,377
93.103 Food and Drug Administration_research $2,500