Finding 1204988 (2024-003)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2024
Accepted
2026-03-30
Audit: 396662
Organization: The City of Frederick, Maryland (MD)
Auditor: SB & COMPANY LLC

AI Summary

  • Core Issue: There is a significant deficiency in how payroll costs are allocated to federal programs, as timesheets do not accurately reflect hours worked by program.
  • Impacted Requirements: Non-compliance with 2 CFR §200.303 and 2 CFR 200.430 regarding documentation and internal controls for federal awards.
  • Recommended Follow-Up: Implement a system for employees to record hours worked by program on timesheets and maintain documentation for payroll cost allocations.

Finding Text

Finding 2024-003 U.S. Department of Housing and Urban Development (HUD) Assistance Listing Number 14.218 – CDBG - Entitlement Grants Cluster Significant Deficiency and Noncompliance over Activities Allowed or Unallowed and Allowable Costs/Cost Principles (Payroll) Repeat Finding: No Criteria: In accordance with 2 CFR §200.303, The non-federal entity must: (a) Establish and maintain effective internal controls 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 In accordance with 2 CFR 200.430: (i) Standards for Documentation of Personnel Expenses (1) Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-federal entity; and (vi) 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 and Context: For the 3 out of 3 employees selected for testing, the timesheet does not support the allocation of work performed to be funded by the federal program. Cause: Timesheets do not report hours by program, so payroll expenses are not allocated to the federal programs based off actual time spent on the grant program. Effect or Potential Effect: Failure to allocate employee pay in accordance with federal requirements could result in a loss of funding. Unallowed costs could be charged to the grant. Questioned Costs: Unknown. Recommendation: The department 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 Officials: Management agrees with the finding. Refer to the Corrective Action Plan Section of this report

Corrective Action Plan

Finding reference: 2024-003 - 14.218 – CDBG - Entitlement Grants Cluster Significant Deficiency and Noncompliance over Activities Allowed or Unallowed and Allowable Costs/Cost Principles Recommendation: The department 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. Action taken: The City has moved to personnel activity reports (PARS) for timesheet reporting to ensure the allocation of the number of hours performed on each program is accurate. The only exception is when an employee works 100% on one grant. Then all working hours are recorded to the grant.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1204983 2024-003
    Material Weakness Repeat
  • 1204984 2024-003
    Material Weakness Repeat
  • 1204985 2024-003
    Material Weakness Repeat
  • 1204986 2024-003
    Material Weakness Repeat
  • 1204987 2024-003
    Material Weakness Repeat
  • 1204989 2024-008
    Material Weakness Repeat
  • 1204990 2024-009
    Material Weakness Repeat
  • 1204991 2024-010
    Material Weakness Repeat
  • 1204992 2024-008
    Material Weakness Repeat
  • 1204993 2024-009
    Material Weakness Repeat
  • 1204994 2024-010
    Material Weakness Repeat
  • 1204995 2024-008
    Material Weakness Repeat
  • 1204996 2024-009
    Material Weakness Repeat
  • 1204997 2024-010
    Material Weakness Repeat
  • 1204998 2024-008
    Material Weakness Repeat
  • 1204999 2024-009
    Material Weakness Repeat
  • 1205000 2024-010
    Material Weakness Repeat
  • 1205001 2024-004
    Material Weakness Repeat
  • 1205002 2024-005
    Material Weakness Repeat
  • 1205003 2024-006
    Material Weakness Repeat
  • 1205004 2024-007
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $2.27M
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE $1.67M
93.137 COMMUNITY PROGRAMS TO IMPROVE MINORITY HEALTH $815,135
10.558 CHILD AND ADULT CARE FOOD PROGRAM $786,906
93.224 COVID-19 - HEALTH CENTER PROGRAM $448,049
93.569 COMMUNITY SERVICES BLOCK GRANT $304,444
93.224 HEALTH CENTER PROGRAM $218,425
14.218 COVID-19 - COMMUNITY DEVELOPMENT BLOCK GRANTS/EMTITLEMENT GRANTS $167,294
10.935 URBAN AGRICULTURE AND INNOVATIVE PRODUCTION $152,301
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $151,662
81.042 WEATHERIZATION ASSISTANCE FOR LOW-INCOME PERSONS $114,445
20.106 AIRPORT IMPROVEMENT PROGRAM $107,000
16.745 CRIMINAL AND JUVENILE JUSTICE AND MENTAL HEALTH COLLABORATION PROGRAM $94,283
16.738 TRAINING AND TECHNOLOGY IMPROVEMENT PROJECT $89,837
16.738 BRYNE DISCRETIONARY COMMUNITY PROJECT FUNDING/BYRNE DISCRETIONARY GRANTS PROGRAM $83,450
93.150 PROJECTS FOR ASSISTANCE IN TRANSITION FROM HOMELESSNESS (PATH) $76,265
16.710 PUBLIC SAFETY PARTNERSHIP AND COMMUNITY POLICING GRANTS $70,125
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $62,686
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $42,538
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN $35,917
93.527 GRANTS FOR NEW AND EXPANDED SERVICES UNDER THE HEALTH CENTER PROGRAM $22,020
95.001 HIGH INTENSITY DRUG TRAFFICKING AREAS PROGRAM $19,548
93.568 LOW-INCOME HOME ENERGY ASSISTANCE $18,097
97.067 STATE HOMELAND SECURITY GRANT PROGRAM $15,800
93.499 LOW INCOME HOUSEHOLD WATER ASSISTANCE PROGRAM $10,156
21.026 HOMEOWNER ASSISTANCE FUND $8,503
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $8,086
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $7,677
14.267 CONTINUUM OF CARE PROGRAM $6,610
84.425 EDUCATION STABILIZATION FUND $5,010