FAC Explorer

Finding 51842 (2022-002)

Material Weakness
Requirement
AB
Questioned Costs
-
Year
2022
Accepted
2023-04-12
Audit: 42772
Organization: City of Columbus, Ohio (OH)
Auditor: Ohio Auditor of State

AI Summary

  • Core Issue: The City did not consistently follow internal control procedures for payroll, leading to potential inaccuracies in federal fund allocations.
  • Impacted Requirements: Compliance with 2 CFR §200.303(a) and §200.430(i)(1)(i) regarding internal controls and accurate timekeeping records.
  • Recommended Follow-Up: The City should enhance its policies to ensure all timesheets are reviewed and approved by a knowledgeable supervisor before allocation to federal programs.

Finding Text

2 CFR ?2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR ?200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Furthermore, 2 CFR ?200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. During testing of payroll expenses for AL #14.218 CDBG Entitlement Grant Cluster, we noted the City utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the City?s established internal control procedures did not occur for six out of 40 timesheets. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee?s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Failure to ensure all time sheets are appropriately approved by a knowledgeable supervisor could result in unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the City review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 51834 2022-002
    Material Weakness
  • 51835 2022-002
    Material Weakness
  • 51836 2022-002
    Material Weakness
  • 51837 2022-002
    Material Weakness
  • 51838 2022-002
    Material Weakness
  • 51839 2022-002
    Material Weakness
  • 51840 2022-002
    Material Weakness
  • 51841 2022-002
    Material Weakness
  • 51843 2022-001
    Material Weakness Repeat
  • 628276 2022-002
    Material Weakness
  • 628277 2022-002
    Material Weakness
  • 628278 2022-002
    Material Weakness
  • 628279 2022-002
    Material Weakness
  • 628280 2022-002
    Material Weakness
  • 628281 2022-002
    Material Weakness
  • 628282 2022-002
    Material Weakness
  • 628283 2022-002
    Material Weakness
  • 628284 2022-002
    Material Weakness
  • 628285 2022-001
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.778 Medical Assistance Program $114.20M
66.458 Capitalization Grants for Clean Water State Revolving Funds $58.22M
21.027 Coronavirus State and Local Fiscal Recovery Funds $21.99M
21.023 Emergency Rental Assistance Program $17.89M
66.468 Capitalization Grants for Drinking Water State Revolving Funds $10.16M
20.205 Highway Planning and Construction $6.57M
16.922 Equitable Sharing Program $3.26M
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $2.33M
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $1.35M
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $1.06M
14.900 Lead-Based Paint Hazard Control in Privately-Owned Housing $950,727
93.053 Special Programs for the Aging_title Iii, Part C_nutrition Services $949,736
10.559 Summer Food Service Program for Children (smp) $757,551
14.218 Community Development Block Grants/entitlement Grants $729,549
93.926 Healthy Start Initiative $702,961
14.241 Housing Opportunities for Persons with Aids $548,347
93.145 Aids Education and Training Centers $467,591
93.217 Family Planning_services $366,692
14.239 Home Investment Partnerships Program $345,148
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $338,040
14.191 Multifamily Housing Services Coordinator $309,221
16.754 Harold Rogers Prescription Drug Monitoring Program $263,553
14.231 Emergency Solutions Grant Program $261,902
93.069 Public Health Emergency Preparedness $260,624
16.838 Comprehensive Opioid Abuse Site-Based Program $252,121
10.576 Senior Farmers Market Nutrition Program $247,046
16.034 Coronavirus Emergency Supplemental Funding Program $205,122
16.585 Drug Court Discretionary Grant Program $196,539
97.044 Assistance to Firefighters Grant $187,175
93.268 Immunization Cooperative Agreements $120,149
93.136 Injury Prevention and Control Research and State and Community Based Programs $118,205
93.994 Maternal and Child Health Services Block Grant to the States $111,464
21.016 Equitable Sharing $102,098
93.959 Block Grants for Prevention and Treatment of Substance Abuse $101,675
93.788 Opioid Str $92,316
93.940 Hiv Prevention Activities_health Department Based $79,675
93.137 Community Programs to Improve Minority Health Grant Program $78,193
93.071 Medicare Enrollment Assistance Program $72,625
93.558 Temporary Assistance for Needy Families $69,980
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $61,948
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $60,000
93.914 Hiv Emergency Relief Project Grants $52,032
93.041 Special Programs for the Aging_title Vii, Chapter 3_programs for Prevention of Elder Abuse, Neglect, and Exploitation $49,262
16.588 Violence Against Women Formula Grants $47,239
97.012 Boating Safety Financial Assistance $46,553
20.616 National Priority Safety Programs $44,617
16.575 Crime Victim Assistance $44,286
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $43,027
14.913 Healthy Homes Production Program $38,644
93.568 Low-Income Home Energy Assistance $32,733
16.320 Services for Trafficking Victims $31,428
93.991 Preventive Health and Health Services Block Grant $28,978
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $25,755
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nations Health $25,000
16.726 Juvenile Mentoring Program $24,368
93.516 Affordable Care Act (aca) Public Health Training Centers Program $20,905
93.478 Preventing Maternal Deaths: Supporting Maternal Mortality Review Committees (b) $20,000
93.855 Allergy, Immunology and Transplantation Research $18,672
93.387 National and State Tobacco Control Program (b) $17,500
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $16,135
16.738 Edward Byrne Memorial Justice Assistance Grant Program $14,943
93.052 National Family Caregiver Support, Title Iii, Part E $11,250
93.958 Block Grants for Community Mental Health Services $3,942
93.074 Hospital Preparedness Program (hpp) and Public Health Emergency Preparedness (phep) Aligned Cooperative Agreements $3,396
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $2,409
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $2,291
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $1,806
20.600 State and Community Highway Safety $1,141
21.019 Coronavirus Relief Fund $445
16.741 Dna Backlog Reduction Program $173
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $15