Finding 1207132 (2025-002)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2025
Accepted
2026-04-16
Audit: 398969
Organization: City of Columbus, Ohio (OH)

AI Summary

  • Core Issue: Supervisors are not reviewing timesheets on time, which violates internal control policies.
  • Impacted Requirements: Compliance with 2 CFR regulations for payroll approvals and accurate reporting of grant-funded hours.
  • Recommended Follow-Up: Strengthen training for supervisors and consider new procedures to ensure timely review and approval of timesheets.

Finding Text

Finding Number: 2025-002 Federal Program: Ending the HIV Epidemic: A Plan for America Federal Award Identification Number: UT833926 Assistance Listing Number (ALN): 93.686 Federal Awarding Agency: Department of Health & Human Services Compliance Requirement: Activities Allowed or Unallowed & Allowable Costs/Cost Principles Pass-through Entity: Direct Award Repeat Finding: No Prior Audit Finding Number: N/A Material Weakness – Payroll Approvals Criteria 2 CFR § 300.106 gives regulatory effect to U.S. Department of Health & Human Services for 2 CFR § 200.303(a), which requires non-Federal entities to establish and maintain effective internal control over Federal awards. These controls must provide reasonable assurance that awards are managed in compliance with applicable statutes, regulations, and award terms, and should align with standards issued by the Government Accountability Office or the Committee of Sponsoring Organizations of the Treadway Commission. Additionally, 2 CFR § 200.430(g)(1)(i) requires that charges to Federal awards for salaries and wages be supported by records that accurately reflect the work performed and are backed by a system of internal controls ensuring the charges are accurate, allowable, and properly allocated. The City of Columbus’ Department of Public Health policy titled, “Staff Timekeeping for Grant Funded Positions,” Part I, requires all grant funded staff to complete timesheets reflecting total hours worked and grant-related hours. Section D, specifically, requires that timesheets must be signed by and submitted for approval on the Tuesday following the end of a pay period. Timesheets submitted for approval must be approved by either the employees’ supervisor or the director of the program by the Thursday following the end of a pay period. Condition Although the City has established policies consistent with Federal requirements, supervisory review of timesheets was not performed timely in all instances. During testing of the payroll records under AL #93.686 (Ending the HIV Epidemic: A Plan for America), none of the 40 timesheets tested were reviewed within the required timeframe referenced in the Criteria section. Cause Supervisory personnel did not consistently follow established procedures for timely review and approval of timesheets. Effect Failure to follow the established internal control policy and ensuring all timesheets are appropriately reviewed and approved by a knowledgeable supervisor, within the required timeframe referenced in the Criteria section, could result in unallowable costs being allocated to a federal program and could ultimately result in noncompliance and/or a questioned cost. Recommendation The City should reinforce its existing policies with supervisory staff and implement additional procedures, if necessary, to ensure timesheets are reviewed and approved within the required timeframe prior to charging costs to Federal programs. Officials’ Response: Refer to the Corrective Action Plan.

Corrective Action Plan

Finding Number: 2025-002 Planned Corrective Action: The City concurs with the finding and will take the following actions in response: • 100% Federally Funded Employees: Columbus Public Health will require all employees whose salaries are 100% funded by a single federal award to comply with 2 CFR § 200.430 through after-the-fact time and effort certifications completed quarterly of the grant period. These certifications will confirm that 100% of the employee’s actual work performed was allocable to the federal award and will include both employee certification and supervisory review. They will be due 30 days following the quarterly end date. In addition, CPH will implement enhanced internal monitoring procedures, including periodic activity verification and supervisory attestation by the Fiscal Analyst, to ensure that work performed aligns with the grant’s scope and that payroll charges are accurate and properly supported;• Partially Federally Funded Employees: Employees whose salaries are allocated across multiple funding sources will follow full federal time and effort reporting requirements in accordance with 2 CFR § 200.430. These employees will complete afterthe- fact time and effort reporting reflecting the actual distribution of work performed across all cost objectives. Reported time will be supported by appropriate documentation and will not be based on budget estimates. Supervisors will review and formally sign off on reported time and effort on at least a quarterly basis to ensure accuracy, reasonableness, and alignment with actual activities. Additional internal monitoring, including periodic review and payroll-to-activity reconciliation reviewed by the Fiscal Analyst, will be conducted to ensure compliance and proper allocation of personnel costs. Anticipated Completion Date: 7/1/2026 Responsible Contact Persons: Anita Clark, Assistant Health Commissioner, Columbus Public Health Katie Pettiford, Fiscal Manager

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1207125 2025-001
    Material Weakness Repeat
  • 1207126 2025-001
    Material Weakness Repeat
  • 1207127 2025-001
    Material Weakness Repeat
  • 1207128 2025-001
    Material Weakness Repeat
  • 1207129 2025-001
    Material Weakness Repeat
  • 1207130 2025-002
    Material Weakness Repeat
  • 1207131 2025-002
    Material Weakness Repeat
  • 1207133 2025-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.778 MEDICAL ASSISTANCE PROGRAM $124.55M
66.468 DRINKING WATER STATE REVOLVING FUND $36.81M
21.023 EMERGENCY RENTAL ASSISTANCE PROGRAM $13.09M
10.557 WIC SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN $5.58M
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $2.76M
93.914 HIV EMERGENCY RELIEF PROJECT GRANTS $2.60M
93.044 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART B, GRANTS FOR SUPPORTIVE SERVICES AND SENIOR CENTERS $2.51M
93.967 CENTERS FOR DISEASE CONTROL AND PREVENTION COLLABORATION WITH ACADEMIA TO STRENGTHEN PUBLIC HEALTH $2.50M
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $2.41M
93.045 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART C, NUTRITION SERVICES $2.41M
20.205 HIGHWAY PLANNING AND CONSTRUCTION $2.36M
93.686 ENDING THE HIV EPIDEMIC: A PLAN FOR AMERICA — RYAN WHITE HIV/AIDS PROGRAM PARTS A AND B $1.78M
16.922 EQUITABLE SHARING PROGRAM $1.34M
14.241 HOUSING OPPORTUNITIES FOR PERSONS WITH AIDS $1.33M
20.263 BRIDGE FORMULA PROGRAM $1.25M
14.913 HEALTHY HOMES PRODUCTION PROGRAM $915,239
93.959 BLOCK GRANTS FOR PREVENTION AND TREATMENT OF SUBSTANCE ABUSE $905,425
93.052 NATIONAL FAMILY CAREGIVER SUPPORT, TITLE III, PART E $851,165
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN $841,893
93.053 NUTRITION SERVICES INCENTIVE PROGRAM $775,206
93.977 SEXUALLY TRANSMITTED DISEASES (STD) PREVENTION AND CONTROL GRANTS $738,423
93.940 HIV PREVENTION ACTIVITIES HEALTH DEPARTMENT BASED $680,012
93.926 HEALTHY START INITIATIVE $656,857
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $631,653
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $616,427
93.217 FAMILY PLANNING SERVICES $550,753
66.458 CLEAN WATER STATE REVOLVING FUND $520,147
20.939 SAFE STREETS AND ROADS FOR ALL $482,006
93.243 SUBSTANCE ABUSE AND MENTAL HEALTH SERVICES PROJECTS OF REGIONAL AND NATIONAL SIGNIFICANCE $423,651
16.590 GRANTS TO ENCOURAGE ARREST POLICIES AND ENFORCEMENT OF PROTECTION ORDERS PROGRAM $402,707
16.742 PAUL COVERDELL FORENSIC SCIENCES IMPROVEMENT GRANT PROGRAM $350,000
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $325,599
66.046 CLIMATE POLLUTION REDUCTION GRANTS $303,873
16.741 DNA BACKLOG REDUCTION PROGRAM $290,342
16.585 TREATMENT COURT DISCRETIONARY GRANT PROGRAM $263,079
21.016 EQUITABLE SHARING $253,294
93.391 ACTIVITIES TO SUPPORT STATE, TRIBAL, LOCAL AND TERRITORIAL (STLT) HEALTH DEPARTMENT RESPONSE TO PUBLIC HEALTH OR HEALTHCARE CRISES $251,538
81.041 STATE ENERGY PROGRAM $250,000
97.067 HOMELAND SECURITY GRANT PROGRAM $247,534
14.900 LEAD HAZARD REDUCTION GRANT PROGRAM $226,179
93.958 BLOCK GRANTS FOR COMMUNITY MENTAL HEALTH SERVICES $187,463
93.071 MEDICARE ENROLLMENT ASSISTANCE PROGRAM $139,500
16.710 PUBLIC SAFETY PARTNERSHIP AND COMMUNITY POLICING GRANTS $128,907
93.043 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART D, DISEASE PREVENTION AND HEALTH PROMOTION SERVICES $107,841
16.588 VIOLENCE AGAINST WOMEN FORMULA GRANTS $106,000
16.575 CRIME VICTIM ASSISTANCE $102,728
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $96,491
16.745 CRIMINAL AND JUVENILE JUSTICE AND MENTAL HEALTH COLLABORATION PROGRAM $94,164
16.838 COMPREHENSIVE OPIOID, STIMULANT, AND OTHER SUBSTANCES USE PROGRAM $89,479
93.991 PREVENTIVE HEALTH AND HEALTH SERVICES BLOCK GRANT $82,410
87.002 VIRGINIA GRAEME BAKER POOL AND SPA SAFETY $80,447
20.200 HIGHWAY RESEARCH AND DEVELOPMENT PROGRAM $76,354
93.136 INJURY PREVENTION AND CONTROL RESEARCH AND STATE AND COMMUNITY BASED PROGRAMS $73,289
93.268 IMMUNIZATION COOPERATIVE AGREEMENTS $66,035
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $60,711
93.568 LOW-INCOME HOME ENERGY ASSISTANCE $50,383
93.041 SPECIAL PROGRAMS FOR THE AGING, TITLE VII, CHAPTER 3, PROGRAMS FOR PREVENTION OF ELDER ABUSE, NEGLECT, AND EXPLOITATION $50,228
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $50,000
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $44,965
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $39,343
93.788 OPIOID STR $35,167
97.012 BOATING SAFETY FINANCIAL ASSISTANCE $33,704
93.387 NATIONAL AND STATE TOBACCO CONTROL PROGRAM $28,730
97.091 HOMELAND SECURITY BIOWATCH PROGRAM $21,643
10.576 SENIOR FARMERS MARKET NUTRITION PROGRAM $21,379
20.608 MINIMUM PENALTIES FOR REPEAT OFFENDERS FOR DRIVING WHILE INTOXICATED $20,278
93.516 PUBLIC HEALTH TRAINING CENTERS PROGRAM $18,284
93.088 ADVANCING SYSTEM IMPROVEMENTS FOR KEY ISSUES IN WOMEN'S HEALTH $4,852
93.889 NATIONAL BIOTERRORISM HOSPITAL PREPAREDNESS PROGRAM $2,665
66.202 CONGRESSIONALLY MANDATED PROJECTS $579