Finding 403817 (2022-002)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2022
Accepted
2024-06-28

AI Summary

  • Core Issue: The Organization lacks proper internal controls, leading to unsupported salary allocations for federal grants.
  • Impacted Requirements: CFR 200.430 mandates accurate records for salary charges to federal awards, which were not maintained.
  • Recommended Follow-Up: Implement a system requiring all employees to submit timesheets to ensure accurate payroll allocations to grant programs.

Finding Text

#2022-002 – Material Weakness – Allowable Costs/Cost Principles Opioid STR Grant ALN 93.788 Block Grants for Prevention and Treatment of Substance Abuse 93.959 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 54 employee time periods, 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 the overbilling of expenses to the grant program. Questioned Costs $397,499 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 multiple 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 #2021-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.

Corrective Action Plan

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

  • 403816 2022-001
    Material Weakness Repeat
  • 403818 2022-003
    Material Weakness Repeat
  • 403819 2022-004
    Material Weakness Repeat
  • 403820 2022-005
    Material Weakness Repeat
  • 403821 2022-006
    Material Weakness Repeat
  • 403822 2022-007
    Significant Deficiency Repeat
  • 403823 2022-001
    Material Weakness Repeat
  • 403824 2022-002
    Material Weakness Repeat
  • 403825 2022-003
    Material Weakness Repeat
  • 403826 2022-004
    Material Weakness Repeat
  • 403827 2022-005
    Material Weakness Repeat
  • 403828 2022-006
    Material Weakness Repeat
  • 403829 2022-007
    Significant Deficiency Repeat
  • 980258 2022-001
    Material Weakness Repeat
  • 980259 2022-002
    Material Weakness Repeat
  • 980260 2022-003
    Material Weakness Repeat
  • 980261 2022-004
    Material Weakness Repeat
  • 980262 2022-005
    Material Weakness Repeat
  • 980263 2022-006
    Material Weakness Repeat
  • 980264 2022-007
    Significant Deficiency Repeat
  • 980265 2022-001
    Material Weakness Repeat
  • 980266 2022-002
    Material Weakness Repeat
  • 980267 2022-003
    Material Weakness Repeat
  • 980268 2022-004
    Material Weakness Repeat
  • 980269 2022-005
    Material Weakness Repeat
  • 980270 2022-006
    Material Weakness Repeat
  • 980271 2022-007
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
93.788 Opioid Str $1.16M
93.959 Block Grants for Prevention and Treatment of Substance Abuse $615,643