Finding 619026 (2022-001)

Material Weakness
Requirement
AB
Questioned Costs
-
Year
2022
Accepted
2023-03-30

AI Summary

  • Core Issue: The Organization lacks adequate documentation for payroll allocations, relying on estimates instead of actual time worked.
  • Impacted Requirements: This violates the requirement for accurate, allowable, and properly allocated charges to federal awards.
  • Recommended Follow-Up: Implement time tracking for employees on federal grants and establish internal controls to ensure payroll expenses are accurately allocated.

Finding Text

CRITERIA: The Organization is required to implement a system of internal controls which provides reasonable assurance that charges to federal awards for personnel expenses are accurate, allowable, and properly allocated. CONDITION: The Organization does not have adequate documentation to support payroll allocations. CONTEXT: During dual purpose tests of controls and compliance over payroll disbursements, we noted employees do not maintain time sheets to support their activities. Therefore, allocations to grants are based on estimates of time commitment instead of actual work performed. Additionally, we noted that salary and benefit amounts used in allocations did not agree to underlying payroll records; in some instances amounts were understated, and in other instances they were overstated. In a sample of six pay periods, errors were noted in all six pay periods. EFFECT: Payroll expenses based on actual work performed cannot be determined, and therefore, the accuracy and proper allocation of costs cannot be verified. CAUSE: The Organization received significant passthrough grants as a result of the COVID-19 pandemic, resulting in a substantial increase in federal funding expended within a short period of time. The Organization had limited capacity to implement all requirements included in Uniform Guidance. RECOMMENDATION: We recommend that management: require employees working on federal grants to track their time; allocate payroll expenses to federal grants based on actual time incurred; and establish a system of internal controls over payroll expenses to ensure that charges are accurate, allowable, and properly allocated. VIEWS OF RESPONSIBLE OFFICIALS: The Organization concurs with the finding.

Categories

Allowable Costs / Cost Principles Internal Control / Segregation of Duties

Other Findings in this Audit

  • 42583 2022-001
    Material Weakness
  • 42584 2022-001
    Material Weakness
  • 42585 2022-001
    Material Weakness
  • 42586 2022-001
    Material Weakness
  • 42587 2022-001
    Material Weakness
  • 42588 2022-001
    Material Weakness
  • 619025 2022-001
    Material Weakness
  • 619027 2022-001
    Material Weakness
  • 619028 2022-001
    Material Weakness
  • 619029 2022-001
    Material Weakness
  • 619030 2022-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.575 Child Care and Development Block Grant $589,073
93.434 Every Student Succeeds Act/preschool Development Grants $436,019
84.425 Education Stabilization Fund $305,927
93.558 Temporary Assistance for Needy Families $108,500
93.110 Maternal and Child Health Federal Consolidated Programs $43,226
21.009 Volunteer Income Tax Assistance (vita) Matching Grant Program $37,698