Finding 502915 (2023-002)

Material Weakness Repeat Finding
Requirement
ABL
Questioned Costs
$1
Year
2023
Accepted
2024-10-16

AI Summary

  • Core Issue: The Agency overpaid $17,680 in unemployment expenses due to errors in payroll processing and accounting software transition.
  • Impacted Requirements: Unemployment expenses should be accurately recorded according to calculated liabilities, affecting federal program funding.
  • Recommended Follow-Up: Establish formal procedures for recording unemployment expenses, reconcile payroll and general ledger reports, and initiate refunds for overpayments.

Finding Text

Known Questioned Cost: $17,680. Criteria: The Agency should be paying its unemployment expenses in accordance with what has been calculated. Condition: The transition to new accounting software and returning payroll processing back to in-house has created a challenging process that requires additional training and changes in accounting procedures to accommodate the software. Context: The Agency’s payroll software automatically accrues payroll liabilities to each grant. When those liabilities were paid by the Agency, the Agency used the expense reports for unemployment from the general ledger instead of the payroll liability report from the payroll module. Additionally, when the liabilities were paid, the Agency recorded the payments into the expense account and not the liability account. These compounding factors led to the overpayment of $17,680 in unemployment expenses charged to federal programs. The cumulative balance of overpayments, net of refunds and credits applied during the current year, is $105,902 and are broken down as follows: (SEE CHART IN SCHEDULE OF FINGINGS AND QUESTIONED COSTS FOR THE YEAR ENDED DECEMBER 31, 2023) Both the Head Start Cluster and the Low-Income Home Energy Assistance Program were major programs identified for the audit of the year ended December 31, 2023. Cause: The Agency has gone through several staff changes and a new software implementation that led to gaps in the skills, knowledge and experience required to process the unemployment payments properly. Effect: Unemployment expenses were overstated to the grantors and overpaid by the Agency. Recommendation: We recommend that formal procedures be put in place for recording and reporting unemployment expenses. This should include a reconciliation between the payroll module, general ledger and quarterly filing reports. Additionally, the Agency needs to have the overpayments refunded and notify the grantors of overpayments. Views of responsible officials and planned corrective action: Management has reviewed the matter and agrees that an error has occurred. Corrections in payroll processing procedures will be implemented and the South Carolina Department of Employment and Workforce has been contacted to retrieve the overpayments.

Categories

Questioned Costs Reporting

Other Findings in this Audit

  • 502913 2023-002
    Material Weakness Repeat
  • 502914 2023-002
    Material Weakness Repeat
  • 502916 2023-002
    Material Weakness Repeat
  • 502917 2023-002
    Material Weakness Repeat
  • 1079355 2023-002
    Material Weakness Repeat
  • 1079356 2023-002
    Material Weakness Repeat
  • 1079357 2023-002
    Material Weakness Repeat
  • 1079358 2023-002
    Material Weakness Repeat
  • 1079359 2023-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.600 Head Start $4.76M
93.568 Low-Income Home Energy Assistance $1.21M
10.558 Child and Adult Care Food Program $208,576
93.569 Community Services Block Grant $158,145
93.499 Low-Income Home Energy Assistance - Water Assistance Program $143,315
81.042 Weatherization Assistance for Low-Income Persons $101,072