Finding 33797 (2022-004)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2022
Accepted
2023-03-26
Audit: 34716
Organization: Howard Area Community Center (IL)
Auditor: Pkf Mueller

AI Summary

  • Core Issue: Payroll records did not accurately reflect actual hours worked, leading to potential misallocation of costs across federal awards.
  • Impacted Requirements: Charges to federal awards must be based on accurate records and supported by internal controls, as per 2 CFR 200.430(i).
  • Recommended Follow-Up: Implement policies to ensure accurate documentation of employee hours and allocation percentages, and conduct regular reviews of payroll allocations.

Finding Text

FINDING 2022-004 - ALLOWABLE PAYROLL COSTS AND CONTROLS OVER PAYROLL (REPEAT) - HEAD START CLUSTER, FEDERAL ASSISTANCE LISTING NUMBER 93.600 Criteria: Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These charges must be supported by a system of internal control, which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Records must support the distribution of the employee?s salary or wages among the specific activities or cost objectives, if the employee works on more than one federal award. 2 CFR 200.430(i) Standards for Documentation of Personnel Expenses. Condition: The Organization?s payroll records did not accurately reflect the actual hours worked by employees whose salaries and wages were charged to the various direct and indirect cost centers for fiscal year 2022. We tested five pay periods and identified a lack of time studies performed in each pay period to support the budgeted percentages used to allocate an employee?s payroll to more than one cost center. Questioned Costs: $80,277 - Payroll and payroll tax expenses totaling $445,531 and $32,971, respectively, were charged to the Early Head Start federal award during fiscal year 2022 and subject to sampling. Our testing identified $74,862 and $5,415 of payroll and payroll tax expenses, respectively, of questioned costs. Our sample was a statistically valid sample. Effect: The current methodology of allocating payroll amongst the various programs and supporting cost centers could result in over allocating payroll costs to certain awards and other cost centers and allocating too little payroll costs to others. Cause: The Organization allocates payroll based on budgeted percentages, however, budget estimates alone do not qualify as support for charges to federal awards. Recommendation: The Organization should establish policies and procedures to support a system of internal controls, which provides a reasonable assurance that the charges to federal awards for salaries and other payroll related costs are accurate, allowable, and properly allocated. Documentation of all employees? approved pay rates, hours worked, and support for the allocation percentages (or actual hours worked) should be maintained. Management's Response: The Organization terminated our professional relationship with our financial services provider in FY23, Quatrro BSS. We established a financial services contract with Metropolitan Family Services (MFS) that began July 1, 2022. MFS manages over 130 million dollars in revenue each year and the current finance team has over 50+ years of combined experience managing government and private contracts. MFS is a Professional Employer Organization (PEO) for five organizations averaging four million dollars in annual revenue and has established back-office and finance service contracts with those organizations. MFS has policies and procedures to support a system of internal controls which provides a reasonable assurance that charges to federal awards for payroll related costs are accurate, allowable, and properly allocated. Budget estimates are used for interim accounting purposes provided the estimates produce reasonable approximations of activity performed. The MFS finance team and the Organization's executive team review payroll allocations each quarter. Allocations are supported by an after-the-fact accounting of employee time and effort in a Personal Activity Report (PAR), significant changes in work activity are identified and entered into the record, and the after-the-fact review is completed to make all necessary adjustments to the final amount charged to the Organization's federal awards to help ensure charges are accurate, allowable, and properly allocated.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 33791 2022-003
    Material Weakness
  • 33792 2022-003
    Material Weakness
  • 33793 2022-002
    Material Weakness Repeat
  • 33794 2022-004
    Material Weakness Repeat
  • 33795 2022-005
    Material Weakness
  • 33796 2022-002
    Material Weakness Repeat
  • 33798 2022-005
    Material Weakness
  • 610233 2022-003
    Material Weakness
  • 610234 2022-003
    Material Weakness
  • 610235 2022-002
    Material Weakness Repeat
  • 610236 2022-004
    Material Weakness Repeat
  • 610237 2022-005
    Material Weakness
  • 610238 2022-002
    Material Weakness Repeat
  • 610239 2022-004
    Material Weakness Repeat
  • 610240 2022-005
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.569 Emergency Food Assistance Program (food Commodities) $301,202
14.218 Community Development Block Grants/entitlement Grants $254,313
16.575 Crime Victim Assistance $142,156
84.002 Adult Education - Basic Grants to States $136,849
10.558 Child and Adult Care Food Program $125,823
93.600 Head Start $83,063
93.667 Social Services Block Grant $79,949
93.917 Hiv Care Formula Grants $64,750
16.726 Juvenile Mentoring Program $41,960
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $37,251
21.019 Coronavirus Relief Fund $27,210
93.569 Community Services Block Grant $16,632
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $12,501
21.027 Coronavirus State and Local Fiscal Recovery Funds $5,637
93.558 Temporary Assistance for Needy Families $1,344
97.024 Emergency Food and Shelter National Board Program $1,290