Finding 960229 (2023-001)

Significant Deficiency
Requirement
AB
Questioned Costs
-
Year
2023
Accepted
2024-03-22

AI Summary

  • Core Issue: There is a significant deficiency in tracking employee hours accurately in payroll software, leading to potential misallocation of wages across federal programs.
  • Impacted Requirements: Compliance with 2 CFR 200.430 for documenting personnel expenses is not being met, risking penalties or repayment obligations.
  • Recommended Follow-Up: Provide updated training for staff on proper employee setup in ADP to ensure accurate wage allocation based on actual work performed.

Finding Text

Type of Finding: Significant Deficiency in Internal Control over Compliance Federal Agency: Department of Veterans Affairs, Department of Health and Human Services Federal Program Name: VA Supportive Services for Veteran Families Program, Unaccompanied Alien Children Program Assistance Listing Number: 64.033, 93.676 Federal Award Identification Number and Year: 20-WA-146-2023, 90ZU0386-3-0-2022, 90ZU0386-3-0-2023 Pass-Through Agency: United States Conference of Catholic Bishops Award Period: October 1, 2020, to September 30, 2023, January 1, 2022, to December 31, 2022, January 1, 2023, to December 31, 2023 Criteria or specific requirement: Under the standards for documentation of personnel expenses, 2 CFR 200.430(i)(1) states that charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. Furthermore, 2 CFR 200.430(i)(1)(vii) indicates that these records must: "Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one federal award; a federal award and a non-federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity". Condition: During testing it was discovered that employees in CCS’s payroll software (ADP) were not being consistently set up to accurately track hours worked per the timesheets to their associated job cost centers. Hours tracked to the major program are sometimes erroneously split-up between the "home department" and the major program cost center. The opposite is also sometimes true in that hours worked under the "home department" are erroneously split between the home department and the major program cost centers, even though those hours were not worked on the major program. This error appears to occur on an employee-by-employee basis, based on the setup of the individual employee. Discussion with management indicates that this error is limited to the SW division and only occurs if an employee has a home department that is a non-holding account. Questioned costs: None Context: (64.033) A sample of 40 was made from a population of 1,044 transactions charged to the major program for salaries and benefit expenses. Of the 40 sampled costs, 1 was found to be out of compliance with the provisions for 2 CFR 200.430 Compensation – personal services of the Uniform Guidance. (93.676) A sample of 40 was made from a population of 926 transactions charged to the major program for salaries and benefit expenses. Of the 40 sampled costs, 7 were found to be out of compliance with the provisions for 2 CFR 200.430 Compensation – personal services of the Uniform Guidance. Cause: There is a misunderstanding on how employees and cost centers must be set up in ADP in order to achieve the desired allocation splits. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: No. Recommendation: CLA recommends that those charged with establishing new employees in ADP receive an updated training on the correct setup steps to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. CCS has already implemented a fix going forward and is currently assessing the cumulative error for the year under audit. Views of responsible officials: There is no disagreement with the audit finding.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 383771 2023-003
    Material Weakness
  • 383772 2023-003
    Material Weakness
  • 383773 2023-003
    Material Weakness
  • 383774 2023-003
    Material Weakness
  • 383775 2023-003
    Material Weakness
  • 383776 2023-003
    Material Weakness
  • 383777 2023-003
    Material Weakness
  • 383778 2023-003
    Material Weakness
  • 383779 2023-003
    Material Weakness
  • 383780 2023-003
    Material Weakness
  • 383781 2023-003
    Material Weakness
  • 383782 2023-003
    Material Weakness
  • 383783 2023-003
    Material Weakness
  • 383784 2023-002
    Significant Deficiency
  • 383785 2023-002
    Significant Deficiency
  • 383786 2023-002
    Significant Deficiency
  • 383787 2023-001
    Significant Deficiency
  • 383788 2023-001
    Significant Deficiency
  • 383789 2023-001
    Significant Deficiency
  • 383790 2023-004
    Significant Deficiency
  • 960213 2023-003
    Material Weakness
  • 960214 2023-003
    Material Weakness
  • 960215 2023-003
    Material Weakness
  • 960216 2023-003
    Material Weakness
  • 960217 2023-003
    Material Weakness
  • 960218 2023-003
    Material Weakness
  • 960219 2023-003
    Material Weakness
  • 960220 2023-003
    Material Weakness
  • 960221 2023-003
    Material Weakness
  • 960222 2023-003
    Material Weakness
  • 960223 2023-003
    Material Weakness
  • 960224 2023-003
    Material Weakness
  • 960225 2023-003
    Material Weakness
  • 960226 2023-002
    Significant Deficiency
  • 960227 2023-002
    Significant Deficiency
  • 960228 2023-002
    Significant Deficiency
  • 960230 2023-001
    Significant Deficiency
  • 960231 2023-001
    Significant Deficiency
  • 960232 2023-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.498 Provider Relief Fund $1.19M
93.676 Unaccompanied Alien Children Program $336,758
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $320,591
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $292,906
14.267 Continuum of Care Program $273,963
64.024 Va Homeless Providers Grant and Per Diem Program $236,651
93.959 Block Grants for Prevention and Treatment of Substance Abuse $230,402
14.241 Housing Opportunities for Persons with Aids $218,707
14.239 Home Investment Partnerships Program $200,000
64.033 Va Supportive Services for Veteran Families Program $176,453
93.788 Opioid Str $136,967
21.027 Coronavirus State and Local Fiscal Recovery Funds $96,016
94.002 Retired and Senior Volunteer Program $65,455
14.231 Emergency Solutions Grant Program $54,666
93.242 Mental Health Research Grants $43,283
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $31,698
93.224 Consolidated Health Centers (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $27,170
14.218 Community Development Block Grants/entitlement Grants $25,426
93.958 Block Grants for Community Mental Health Services $23,850
93.914 Hiv Emergency Relief Project Grants $23,456
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $19,593
93.053 Nutrition Services Incentive Program $12,420
93.778 Medical Assistance Program $6,835
97.024 Emergency Food and Shelter National Board Program $5,431
10.569 Emergency Food Assistance Program (food Commodities) $1,589
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $1,458
93.052 National Family Caregiver Support, Title Iii, Part E $244