Finding 969932 (2023-005)

Material Weakness
Requirement
AB
Questioned Costs
$1
Year
2023
Accepted
2024-04-16
Audit: 303684
Organization: City of Elizabeth (NJ)

AI Summary

  • Core Issue: Salaries charged to the federal award lacked proper documentation to support the time employees spent on grant activities.
  • Impacted Requirements: The City failed to meet Uniform Guidance standards for documenting personnel expenses, leading to questioned costs of $697,935.
  • Recommended Follow-Up: The City should enhance internal controls over payroll and implement a time tracking system to ensure accurate salary charges to the grant.

Finding Text

Criteria:The accounting practices of the non-Federal entity must provide for adequate documentation to support costs charged to the Federal award. Standards for documentation of personnel expenses in Uniform Guidance 2 CFR part 200.430 Compensation – personal services state that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. Among various other requirements, these records must: Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. 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 bases; or an unallowable activity and a direct cost activity. Budget estimates (i.e. estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: The system for establishing the estimates produces reasonable approximations of the activity actually performed; Significant changes in the corresponding work activity are identified and entered into the records in a timely manner. Condition: Salaries charged to the federal award were not supported by distribution schedule identifying the percentage of time each employee was working on the Federal award objective. Cause: The City charged salary expenditures to the grant baased upon percentages used in the grant application. Effect: The City was unable to provide supporting documentation that the costs charged to the grant were allowable. Questioned Costs: $697,935 Context/Sampling: The internal control and compliance testing performed included all salaries charged to the grant. Out of the items tested none of the salaries charged were supported by documentation supporting the allocation charged to the federal award. Prior Year: None Recommendation: We recommend the City review its policies and procedures related to the internal controls over payroll expenditures related to grants and implement a time system to capture appropriate salaries to be charged to the grant. Client Response: The City recognizes the importance of internal controls and plans to enhance procedures to ensure payroll expenditures related to grants are properly captured, documented and charged to the grant. Covid interruptions with related illnesses, early retirements and hiring difficulties all contributed to a negative impact on productivity.

Categories

Questioned Costs Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 393490 2023-005
    Material Weakness
  • 393491 2023-005
    Material Weakness
  • 393492 2023-006
    Material Weakness
  • 393493 2023-006
    Material Weakness
  • 393494 2023-007
    Significant Deficiency
  • 393495 2023-003
    Material Weakness
  • 393496 2023-004
    Significant Deficiency
  • 969933 2023-005
    Material Weakness
  • 969934 2023-006
    Material Weakness
  • 969935 2023-006
    Material Weakness
  • 969936 2023-007
    Significant Deficiency
  • 969937 2023-003
    Material Weakness
  • 969938 2023-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $4.72M
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.61M
14.218 Community Development Block Grants/entitlement Grants $1.51M
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $835,481
14.241 Housing Opportunities for Persons with Aids $678,104
16.922 Equitable Sharing Program $261,103
14.239 Home Investment Partnerships Program $208,027
10.559 Summer Food Service Program for Children $201,220
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $129,600
16.738 Edward Byrne Memorial Justice Assistance Grant Program $108,675
93.268 Immunization Cooperative Agreements $94,991
20.205 Highway Planning and Construction $56,469
97.056 Port Security Grant Program $16,925
93.136 Injury Prevention and Control Research and State and Community Based Programs $5,803
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation’s Health $779