Finding 384374 (2022-006)

Significant Deficiency
Requirement
A
Questioned Costs
-
Year
2022
Accepted
2024-03-25
Audit: 297486
Organization: The City of Frederick, Maryland (MD)
Auditor: Brown Plus

AI Summary

  • Core Issue: Employee pay was charged to the federal program without proper support for allocation.
  • Impacted Requirements: Federal rules require accurate records for salary allocation based on actual work performed across multiple programs.
  • Recommended Follow-Up: Ensure timesheets detail hours worked on each program and maintain documentation for payroll cost allocations.

Finding Text

Federal Agency: Department of Health and Human Services Federal Program: 93.224 Health Center Program Identification Number: H80CS29007 Requirement: Activities Allowed or Unallowed Type of Finding: Significant deficiency in internal control over major program Criteria: Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one federal award; a federal award and non-federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases or an unallowable activity and a direct or indirect cost activity. Condition: An employee was charged to the federal program without the allocation of pay being supported. Cause: Timesheets are not broken down by program, so payroll expenses are not allocated based off actual time spent on the grant program. Effect: Failure to allocate employee pay in accordance with federal requirements could result in a loss of funding. Context: For four out of eight pay periods tested, an employee’s pay was allocated 50% to the Health Center Program. Support could not be provided showing that this allocation was appropriate. Recommendation: The Health Center should maintain support and rationale for all allocations of payroll costs for employees charged to federal awards. Additionally, employees should earmark their timesheets with the number of hours worked on each program. Views of Responsible Official(s) and Planned Corrective Actions: See corrective action plan.

Corrective Action Plan

Staff allocations are reviewed regularly to ensure they are based on work assignments. We are now tracking changes to allocations for historical reference.

Categories

Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking Significant Deficiency

Other Findings in this Audit

  • 384370 2022-002
    Significant Deficiency Repeat
  • 384371 2022-003
    Material Weakness
  • 384372 2022-004
    Significant Deficiency Repeat
  • 384373 2022-005
    Significant Deficiency Repeat
  • 384375 2022-007
    Material Weakness
  • 384376 2022-008
    Material Weakness
  • 384377 2022-009
    Material Weakness
  • 384378 2022-010
    Material Weakness
  • 384379 2022-011
    Significant Deficiency
  • 384380 2022-012
    Material Weakness
  • 384381 2022-013
    Significant Deficiency
  • 384382 2022-014
    Significant Deficiency
  • 384383 2022-015
    Material Weakness
  • 384384 2022-016
    Significant Deficiency
  • 384385 2022-017
    Significant Deficiency
  • 960812 2022-002
    Significant Deficiency Repeat
  • 960813 2022-003
    Material Weakness
  • 960814 2022-004
    Significant Deficiency Repeat
  • 960815 2022-005
    Significant Deficiency Repeat
  • 960816 2022-006
    Significant Deficiency
  • 960817 2022-007
    Material Weakness
  • 960818 2022-008
    Material Weakness
  • 960819 2022-009
    Material Weakness
  • 960820 2022-010
    Material Weakness
  • 960821 2022-011
    Significant Deficiency
  • 960822 2022-012
    Material Weakness
  • 960823 2022-013
    Significant Deficiency
  • 960824 2022-014
    Significant Deficiency
  • 960825 2022-015
    Material Weakness
  • 960826 2022-016
    Significant Deficiency
  • 960827 2022-017
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
20.106 Airport Improvement Program $4.76M
93.224 Consolidated Health Centers (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $1.39M
93.137 Community Programs to Improve Minority Health Grant Program $985,426
59.075 Shuttered Venue Operators Grant Program $807,851
10.558 Child and Adult Care Food Program $805,355
93.568 Low-Income Home Energy Assistance $780,504
14.231 Emergency Solutions Grant Program $660,699
21.027 Coronavirus State and Local Fiscal Recovery Funds $415,035
93.569 Community Services Block Grant $407,287
14.267 Continuum of Care Program $182,884
14.218 Community Development Block Grants/entitlement Grants $151,936
81.042 Weatherization Assistance for Low-Income Persons $133,099
93.150 Projects for Assistance in Transition From Homelessness (path) $74,103
16.738 Edward Byrne Memorial Justice Assistance Grant Program $70,867
95.001 High Intensity Drug Trafficking Areas Program $58,844
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $27,718
10.559 Summer Food Service Program for Children $16,751
93.499 Low Income Household Water Assistance Program $16,206
97.067 Homeland Security Grant Program $9,802
20.616 National Priority Safety Programs $9,148
21.026 Homeowner Assistance Fund $7,726
21.016 Equitable Sharing $6,000
20.600 State and Community Highway Safety $5,838
66.466 Chesapeake Bay Program $3,675