Finding 547919 (2024-002)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2025-03-31

AI Summary

  • Core Issue: Inadequate documentation for payroll cost allocations to the Federal program led to unsupported costs for 9 out of 19 samples tested.
  • Impacted Requirements: Compliance with Section §200.405 of the Uniform Guidance regarding cost allocation and documentation standards.
  • Recommended Follow-Up: Enhance internal controls for payroll cost allocations, ensuring timely updates and supervisory reviews of all allocations.

Finding Text

Allocation of Program Payroll Costs (Significant Deficiency) and Compliance Federal Agency: U.S. Department of Health and Human Services Program Title: Temporary Assistance for Needy Families Assistance Listing Number: 93.558 Federal Award Source: Pass-through funding Pass-Through Entity: Arizona Department of Economic Security Pass-Through Identifying Number: CTR 066191 Criteria – Section §200.405 of the Uniform Guidance states that a cost is allocable to a Federal award or other cost objective if the cost is assignable to that Federal award or other cost objective in accordance with the relative benefits received and this standard is considered to be met if the cost (a) is incurred specifically for the Federal award; (b) benefits both the Federal award and other work of the recipient or subrecipient and can be distributed in proportions that may be approximated using reasonable methods; or (c) is necessary to the overall operation of the recipient or subrecipient and is assignable in part to the Federal award in accordance with the Uniform Guidance cost principles. Condition and Context – During our audit of allowable costs as it pertained to payroll costs, we noted the Organization could not provide adequate documentation to support the percentage of employee payroll costs allocated to the Federal program for 4 employees. This resulted in an unsupported allocation of payroll costs for 9 samples out of a total of 19 samples selected for testing, and $5,383 in payroll costs out of $14,585 total payroll costs selected for testing. Our sample was a statistically valid sample. Cause and Effect - Due to a transition in the billing structure of the program, which was previously fee for service in nature, to being cost reimbursement in nature, the Organization did not consistently maintain adequate supporting documentation for the allocation of payroll costs to the Federal program for all employees. It is possible the allocations used were not reflective of the actual or approximate time spent by the employees on the Federal program. Questioned Costs – Undetermined. We were unable to determine whether the allocations used were appropriate or not. Recommendation – We recommend that the Organization improve its internal controls over the allocation of payroll costs to the Federal program and ensure any allocations are updated timely, and appropriately reviewed and approved by supervisory personnel. View of Responsible Officials - We agree with the finding. We have implemented procedures to ensure secondary reviews of all billings. See our Corrective Action Plan for the fiscal year ended June 30, 2024 for additional detail.

Corrective Action Plan

CCS transitioned to a new payroll system during the fiscal year ended June 30, 2024. The payroll system had deficiencies with reporting and allocation capabilities that are being resolved. Manual processes to track and record payroll allocations have been cumbersome and inefficient. These systems are being updated to create accurate and timely reports to facilitate more efficient allocation processes. This is the responsibility of the CCS Executive Director of Human Resources. Additionally, internal review requirements are being enhanced and reinforced. This is the responsibility of the CCS Chief Financial Officer. Enhanced oversight has been implemented to ensure proper payroll approvals, documentation, tracking and allocations, and additional training is being provided as needed. This is the responsibility of the CCS Controller and is expected to be completed by June 30, 2025.

Categories

Allowable Costs / Cost Principles Subrecipient Monitoring

Other Findings in this Audit

  • 547918 2024-001
    Significant Deficiency
  • 1124360 2024-001
    Significant Deficiency
  • 1124361 2024-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
97.024 Emergency Food and Shelter National Board Program $4.21M
93.045 Special Programs for the Aging, Title Iii, Part C, Nutrition Services $1.47M
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $1.37M
97.141 Shelter and Services Program $978,874
19.510 U.s. Refugee Admissions Program $459,074
93.560 Payments to Territories – Adults $401,593
93.575 Child Care and Development Block Grant $393,741
93.576 Refugee and Entrant Assistance Discretionary Grants $295,149
93.053 Nutrition Services Incentive Program $233,787
93.667 Social Services Block Grant $146,706
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $131,369
21.009 Volunteer Income Tax Assistance (vita) Matching Grant Program $129,360
21.027 Coronavirus State and Local Fiscal Recovery Funds $114,759
16.575 Crime Victim Assistance $103,668
21.008 Low Income Taxpayer Clinics $99,062
93.052 National Family Caregiver Support, Title Iii, Part E $97,781
14.239 Home Investment Partnerships Program $73,930
14.218 Community Development Block Grants/entitlement Grants $60,568
93.044 Special Programs for the Aging, Title Iii, Part B, Grants for Supportive Services and Senior Centers $59,763
97.067 Homeland Security Grant Program $57,048
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $43,677
93.570 Community Services Block Grant Discretionary Awards $41,860
14.231 Emergency Solutions Grant Program $34,045
93.558 Temporary Assistance for Needy Families $33,408
10.558 Child and Adult Care Food Program $21,381
93.566 Refugee and Entrant Assistance State/replacement Designee Administered Programs $12,617
84.126 Rehabilitation Services Vocational Rehabilitation Grants to States $3,768
14.267 Continuum of Care Program $2,657