Finding 1154823 (2024-003)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
$1
Year
2024
Accepted
2025-09-23

AI Summary

  • Core Issue: Payroll charges to the federal grant were based on inaccurate records, leading to unallowable costs.
  • Impacted Requirements: Compliance with CFR 200.430(i) regarding accurate payroll records reflecting actual work performed.
  • Recommended Follow-Up: Review and correct payroll allocations; implement a new in-house payroll system by January 2026 to improve accuracy.

Finding Text

Finding 2024-003 Identification of the Federal Program: 16.575 – Crime Victim Assistance Compliance finding over activities allowed or unallowed and allowable costs/cost principles and significant deficiency in internal controls Criteria: According to CFR 200.430(i), charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. Condition: The Organization charged payroll expenditures to the grant which were not based on records maintained which reflected the work performed. Cause: Payroll is processed by an external third party, and the system was setup originally to base pay on time budgets rather than actual hours spent. In addition, there were errors in the payroll allocations to various programs Effect: The Organization charged expenditures to the grant which were unallowable. Likely Questioned Costs: $4,059 Repeat Finding: No Recommendations: We recommend the Organization review the payroll allocations in the payroll system to ensure they are supported by actual time spent on the program. In addition, the payroll calculations should be reviewed to ensure the amounts allocated to the various programs are correct. Views of Responsible Officials: The Organization uses a third-party vendor to process payroll. This system does not have the capability to allocate salaried employees based on time spent on the program recorded in the time keeping system. Because of this, the hours worked in each program need to be converted into percentages before payroll is submitted for processing. To ensure accuracy, the Organization will have a second reviewer confirm the manual entry conversion from hours worked to percentage of time worked for salaried employees for the remaining duration of time in a third-party payroll system. Effective January 2026, the Organization will implement a new payroll system that will be processed in-house. This system has improved functionality that will eliminate the need to make this conversion and the potential for errors.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1154818 2024-003
    Material Weakness Repeat
  • 1154819 2024-004
    Material Weakness Repeat
  • 1154820 2024-005
    Material Weakness Repeat
  • 1154821 2024-006
    Material Weakness Repeat
  • 1154822 2024-007
    Material Weakness Repeat
  • 1154824 2024-004
    Material Weakness Repeat
  • 1154825 2024-005
    Material Weakness Repeat
  • 1154826 2024-006
    Material Weakness Repeat
  • 1154827 2024-007
    Material Weakness Repeat
  • 1154828 2024-003
    Material Weakness Repeat
  • 1154829 2024-004
    Material Weakness Repeat
  • 1154830 2024-005
    Material Weakness Repeat
  • 1154831 2024-006
    Material Weakness Repeat
  • 1154832 2024-007
    Material Weakness Repeat
  • 1154833 2024-008
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.568 Low-Income Home Energy Assistance $956,194
14.267 Continuum of Care Program $279,546
16.575 Crime Victim Assistance $190,426
93.569 Community Services Block Grant $111,325
21.027 Coronavirus State and Local Fiscal Recovery Funds $97,405
21.023 Emergency Rental Assistance Program $87,000
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $76,087
84.287 Twenty-First Century Community Learning Centers $58,790
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $57,357
93.136 Injury Prevention and Control Research and State and Community Based Programs $32,652
16.588 Violence Against Women Formula Grants $20,379
93.497 Family Violence Prevention and Services/ Sexual Assault/rape Crisis Services and Supports $12,500
93.499 Low Income Household Water Assistance Program $8,262
93.044 Special Programs for the Aging, Title Iii, Part B, Grants for Supportive Services and Senior Centers $7,078
93.052 National Family Caregiver Support, Title Iii, Part E $2,876
93.053 Nutrition Services Incentive Program $620
93.045 Special Programs for the Aging, Title Iii, Part C, Nutrition Services $306