Finding 392243 (2022-005)

Significant Deficiency
Requirement
A
Questioned Costs
-
Year
2022
Accepted
2024-04-03

AI Summary

  • Core Issue: Internal controls over payroll transactions are inadequate, leading to potential inaccuracies in payroll costs charged to federal awards.
  • Impacted Requirements: Compliance with 2 CFR 200.303 and 2 CFR 200.430(i)(1) is compromised due to lack of proper review and monitoring of payroll transactions.
  • Recommended Follow-Up: Management should implement robust policies and procedures to ensure payroll costs are accurately recorded and compliant with federal requirements.

Finding Text

FINDINGS AND QUESTIONED COSTS – MAJOR FEDERAL AWARD PROGRAMS AUDIT 2022-005 Significant Deficiency in Internal Controls over Compliance – Allowability – Payroll Transactions Agency: U.S. Department of Health and Human Services Program(s) and Federal Award Identification Number(s): Special Programs for The Aging – Title III, Part B—Grants For Supportive Services And Senior Centers, Cares Act For Supportive Services Under Title III-B Of The Older Americans Act, And American Rescue Plan For Supportive Services Under Title III-B Of The Older Americans Act AL 93.044 Nutrition Services for Nutrition Services Under Title III-C Of The Older Americans Act, Cares Act For Nutrition Services Under Title III-C Of The Older Americans Act, And American Rescue Plan For Nutrition Services Under Title III-C Of The Older Americans Act AL 93.045 Nutrition Services Incentive Program AL 93.053 Special Programs for the Aging, Title VI, Part A, Grants to Indian Tribes AL 93.047 Children’s Advocacy Centers AL 93.558 New or Repeat: Repeat Criteria: Per 2 CFR 200.303, the non-Federal entity is responsible for maintaining effective internal control over federal awards that provides reasonable assurance that awards are being managed in compliance with the terms and conditions of the Federal award. Additionally, 2 CFR 200.430(i)(1) requires that charges to federal awards for salaries and wages must be based on records that accurately reflect the work being performed and are supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Condition: Internal controls over payroll transactions were not properly designed or implemented to ensure that payroll transactions posted to the accounting system are accurate, allowable, and properly allocated. Cause: Vacancies in key financial positions and lack of adequate resources in the finance department lead to a breakdown of established controls and inadequate monitoring of account balances for compliance with requirements. Context: Audit procedures identified the following conditions: • Payroll-related journal entries were not reviewed or approved by an individual other than the preparer prior to posting. • During fiscal year 2022, CCS outsourced payroll services to an external service organization. CCS did not perform reviews or reconciliations of payroll journal entries generated by the external service organization, including entries to record payroll costs allocated to grant awards, prior to posting the payroll entries to the CCS accounting system. • CCS uses multiple allocation pools and the accounting system automatically allocates costs based on system configurations. During fiscal year 2022, CCS had been running the monthly system allocations before all month-end adjustments had been made. Consequently, the allocations were not capturing the system changes to costs that had been made after the allocations had been run. Through substantive procedures, we were able to conclude that costs that were eligible to be allocated to the federal major programs exceeded what was actually allocated and unallowable costs were not identified. Effect: Lack of review or approval of payroll journal entries, system cost pool allocations, and payroll amounts generated by the external payroll service organization could result in inaccurate or unallowable payroll costs charged to grant awards. Questioned costs: No questioned costs. Recommendation: We recommend management establish policies and procedures to ensure controls are properly designed and implemented to ensure that payroll costs charged to federal awards are accurate, allowable, and properly allocated. View of responsible officials: Management concurs with this finding, see corrective action plan.

Categories

Allowable Costs / Cost Principles Internal Control / Segregation of Duties

Other Findings in this Audit

  • 392231 2022-004
    Material Weakness
  • 392232 2022-003
    Significant Deficiency
  • 392233 2022-004
    Material Weakness
  • 392234 2022-003
    Significant Deficiency
  • 392235 2022-004
    Material Weakness
  • 392236 2022-003
    Significant Deficiency Repeat
  • 392237 2022-004
    Material Weakness
  • 392238 2022-003
    Significant Deficiency
  • 392239 2022-003
    Significant Deficiency Repeat
  • 392240 2022-005
    Significant Deficiency
  • 392241 2022-005
    Significant Deficiency
  • 392242 2022-005
    Significant Deficiency Repeat
  • 392244 2022-005
    Significant Deficiency Repeat
  • 392245 2022-006
    Significant Deficiency Repeat
  • 968673 2022-004
    Material Weakness
  • 968674 2022-003
    Significant Deficiency
  • 968675 2022-004
    Material Weakness
  • 968676 2022-003
    Significant Deficiency
  • 968677 2022-004
    Material Weakness
  • 968678 2022-003
    Significant Deficiency Repeat
  • 968679 2022-004
    Material Weakness
  • 968680 2022-003
    Significant Deficiency
  • 968681 2022-003
    Significant Deficiency Repeat
  • 968682 2022-005
    Significant Deficiency
  • 968683 2022-005
    Significant Deficiency
  • 968684 2022-005
    Significant Deficiency Repeat
  • 968685 2022-005
    Significant Deficiency
  • 968686 2022-005
    Significant Deficiency Repeat
  • 968687 2022-006
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
93.047 Special Programs for the Aging_title Vi, Part A, Grants to Indian Tribes_part B, Grants to Native Hawaiians $1.40M
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $903,018
93.558 Temporary Assistance for Needy Families $321,695
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $229,273
93.054 National Family Caregiver Support, Title Vi, Part C, Grants to Indian Tribes and Native Hawaiians $182,827
93.052 National Family Caregiver Support, Title Iii, Part E $162,127
16.575 Crime Victim Assistance $153,680
16.758 Improving the Investigation and Prosecution of Child Abuse and the Regional and Local Children's Advocacy Centers $84,966
93.053 Nutrition Services Incentive Program $79,886
14.881 Moving to Work Demonstration Program $79,867
14.870 Resident Opportunity and Supportive Services - Service Coordinators $57,882
93.048 Special Programs for the Aging_title Iv_and Title Ii_discretionary Projects $30,190
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $21,741