Finding 7999 (2021-002)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2021
Accepted
2024-01-09

AI Summary

  • Core Issue: The Organization lacks proper documentation for salary allocations to the federal grant, with eleven employees not providing timesheets.
  • Impacted Requirements: This violates CFR 200.430, which mandates accurate records and internal controls for federal awards.
  • Recommended Follow-Up: Implement mandatory timesheets for all employees to ensure accurate payroll charges to grant programs.

Finding Text

#2021-002 – Material Weakness – Allowable Costs/Cost Principles Opioid STR Grant ALN 93.788 Criteria The Office of Management and Budget issuance of the Code of Federal Regulations (CFR) specifically states uniform administrative requirements, cost principles, and audit requirements for federal awards. CFR 200.430 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 control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated.” Condition During the course of the audit, we noted that the Organization used an allocation methodology to allocate salaries to the federal award based upon time spent on the program. However, for eleven of the employees, there were no timesheets to support the amount of time allocated to the Organization’s grant programs. Cause The cause is a lack of proper internal controls which would require the Organization to maintain adequate support for time spent on grant programs and a formal allocation process to allocate payroll costs across the grant programs. Effect The potential effects of not having supporting documentation for the allocation of payroll expenses is potential overbilling of expenses to the grant program. Questioned Costs $33,316 Perspective Information We reviewed a sample of monthly reports filed with the Pennsylvania Department of Military and Veterans Affairs and the Drug and Alcohol Program. We examined the payroll for each employee charged to the grant for a total of twenty-six employees. The finding is related to eleven individuals who did not complete timesheets or provide supporting documentation for the amount of time spent on the Organization’s grant programs. Identification as a repeat finding A similar issue was noted in prior year finding #2020-002. Recommendation We recommend that the Organization require timesheets for the hours allocated to the grant programs for all employees whether they are salary or hourly to ensure that the payroll charged to grants is accurate and properly supported. View of responsible officials and planned corrective action Starting in 2023 all employees of the Organization will complete formal time sheets. These sheets will be signed by the Administrative Coordinator and by the Fiscal Coordinator and then entered into the system each pay period to rectify this finding.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 7991 2021-001
    Material Weakness Repeat
  • 7992 2021-002
    Material Weakness Repeat
  • 7993 2021-003
    Material Weakness
  • 7994 2021-004
    Material Weakness Repeat
  • 7995 2021-005
    Material Weakness Repeat
  • 7996 2021-006
    Material Weakness Repeat
  • 7997 2021-007
    Significant Deficiency
  • 7998 2021-001
    Material Weakness Repeat
  • 8000 2021-003
    Material Weakness
  • 8001 2021-004
    Material Weakness Repeat
  • 8002 2021-005
    Material Weakness Repeat
  • 8003 2021-006
    Material Weakness Repeat
  • 8004 2021-007
    Significant Deficiency
  • 584433 2021-001
    Material Weakness Repeat
  • 584434 2021-002
    Material Weakness Repeat
  • 584435 2021-003
    Material Weakness
  • 584436 2021-004
    Material Weakness Repeat
  • 584437 2021-005
    Material Weakness Repeat
  • 584438 2021-006
    Material Weakness Repeat
  • 584439 2021-007
    Significant Deficiency
  • 584440 2021-001
    Material Weakness Repeat
  • 584441 2021-002
    Material Weakness Repeat
  • 584442 2021-003
    Material Weakness
  • 584443 2021-004
    Material Weakness Repeat
  • 584444 2021-005
    Material Weakness Repeat
  • 584445 2021-006
    Material Weakness Repeat
  • 584446 2021-007
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.788 Opioid Str $411,974
93.959 Block Grants for Prevention and Treatment of Substance Abuse $335,472