Finding 48306 (2022-001)

Material Weakness
Requirement
B
Questioned Costs
$1
Year
2022
Accepted
2023-05-30

AI Summary

  • Core Issue: Payroll costs are being allocated to federal grants based on budget estimates rather than actual work performed, leading to potential inaccuracies.
  • Impacted Requirements: Compliance with Uniform Guidance section 200.430(h)(8)(i) is not met, as there is no reliable system to ensure payroll charges are accurate and properly documented.
  • Recommended Follow-Up: Management should establish a robust internal control process to ensure payroll allocations are based on actual time records and accurately reflect employee activities related to federal grants.

Finding Text

Finding 2022-001 ? Allowable Costs/Cost Principles (Allocation of Payroll) Federal Agency: U.S. Department of Health and Human Services Federal program title: Block Grants for Community Mental Health Services Assistance Listing Number: 93.958 Award Period: 09/30/2021 ? 09/29/2023 Type of Finding: Compliance and material weakness in internal control over compliance Criteria: Uniform Guidance section 200.430(h)(8)(i) indicates that the standards for documentation of personnel expenses are such that (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 nonfederal entity and(iii) Reasonably reflect the total activity for which the employee is compensated by the nonfederal entity, not exceeding 100% of compensated activities. Furthermore, subsection (viii) indicates: Budget estimates alone do not qualify as support for charges to federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) Significant changes in the corresponding work activity are identified and entered into the records in a timely manner and (C) The nonfederal entity?s system of internal controls includes processes to review after-the-fact interim charges made to a federal awards based on budget estimates. Condition: The Organization is allocating payroll costs to grants based upon budgeted amounts/percentages submitted to the funding agency and does not currently have a system for ensuring that the estimates used produce reasonable approximations of the activity actually performed. Questioned Costs: Unknown Context: This condition occurred in all 60 payroll transactions selected for testing, and represented six different employees. Cause: The Organization has a tracking system in place to monitor the wages by employee charged to federal grants to avoid over-allocation of individual employee wages per the grant budget, but this tracking system does not contain a process for identifying and allocating wages based on submitted time records.Effect: Inaccurate payroll costs may be charged to federal programs if the Organization does not have procedures in place to monitor and record employee time devoted to federal programs. Recommendation: Management should develop a process whereby payroll costs allocated to federal grants are supported by a system of internal controls which provides reasonable assurance that the charges are accurate allowable and properly allocated, reasonably reflect the total activity for which the employee is compensated, and support the distribution of the employee?s wages among specific activities or cost objectives if the employee works on more than one federal award.

Corrective Action Plan

Finding 2022-001 ? Allowable Costs/Cost Principles (Allocation of Payroll) Type of Finding: Compliance and material weakness in internal control over compliance Corrective Action Plan: The Organization is in the process of implementing procedures around time and effort reporting with federal grants. The new process will include a formal written policy for time and effort reporting across all federal grants that will provide the required documentation that federal funds were charged only for time actually worked. The Organization will be implementing a time and effort certification process that will be completed on a quarterly basis. It will be included in our documented policies and procedures and will be completed for all employees charging time to federal grants The certifications will be signed by the employee and the supervisor.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 48307 2022-003
    Material Weakness
  • 48308 2022-002
    Material Weakness
  • 48309 2022-003
    Material Weakness
  • 624748 2022-001
    Material Weakness
  • 624749 2022-003
    Material Weakness
  • 624750 2022-002
    Material Weakness
  • 624751 2022-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.676 Unaccompanied Alien Children Program $3.83M
93.958 Block Grants for Community Mental Health Services $1.44M
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $852,276
14.267 Continuum of Care Program $603,186
17.274 Youthbuild $247,234
16.575 Crime Victim Assistance $214,259
16.123 Community-Based Violence Prevention Program $131,174