Finding 1155354 (2024-002)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2024
Accepted
2025-09-25

AI Summary

  • Core Issue: The Organization cannot reconcile payroll expenses between the general ledger and the payroll software, risking unallowed costs on federal grants.
  • Impacted Requirements: This violates CFR Part 200, which mandates a robust internal control system for tracking federal funds.
  • Recommended Follow-Up: Management should conduct monthly reconciliations of the payroll software, general ledger, and draw details to ensure accuracy.

Finding Text

SIGNIFICANT DEFICIENCY 2024-002 PAYROLL POPULATION Federal Agency: Department of Labor Federal Program: WIOA Adult Programs/WIOA Youth Activities Assistance Listing Number: 17.258, 17.259 Federal Award Numbers and Year: CWI 23-001 MARCH 1, 2023-JUNE 30, 2024 CWI 25-012 JULY 1, 2024-JUNE 30, 2025 CWI 25-013 JULY 1, 2024-JUNE 30, 2025 Questioned Costs: None reported Condition: The Organization uses general ledger detail to create draws to submit reimbursement claims. Some reimbursments are for payroll expenses that are paid through a separate system. The Organization could not reconcile the general ledger to the payroll software detail used to submit reimbursments. Criteria: According to CFR Part 200, the auditee must maintain a system of internal control that provides for the tracking and use of federal funds. Cause: The Organization did not regularly reconcile detailed support from the payroll system to match monthly draws. Effect: The Organization could charge unallowed costs to the grant. Identification of Repeat Finding: This is not a repeat finding. Recommendation: We recommend management perform and maintain monthly reconciliations of the payroll software, general ledger, and draw detail that all agree. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding, will verify coding in the general ledger and reconcile the general ledger to the draw request and payroll reports.

Corrective Action Plan

2024-002 PAYROLL POPULATION The Organization uses general ledger detail to create draws to submit reimbursement claims. Some reimbursements are for payroll expenses that are paid through a separate system. The Organization could not reconcile the general ledger to the payroll software detail used to submit reimbursements. Recommendation: The Organization should perform and maintain monthly reconciliations of the payroll software, general ledger, and draw detail that all agree. Action Taken: The Organization was billing the grantor for payroll fees, the additional fees for each employee or contract that participated in the grant. Originally, the funds were coded to payroll (compensation) expenses, which generated a discrepancy between the Payroll Register and the General Ledger. The unemployment expense was also coded to benefits, which created a variance between the payroll register (generated from payroll software) and the general ledger. Going forward, the trail balance and general ledger will be reconciled to the draw request. Additionally, the team has been trained in how to properly code these expenses. Contact Person: Shire Kuch Effective Date: 25 September 2025.

Categories

Cash Management Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1155349 2024-001
    Material Weakness Repeat
  • 1155350 2024-002
    Material Weakness Repeat
  • 1155351 2024-002
    Material Weakness Repeat
  • 1155352 2024-002
    Material Weakness Repeat
  • 1155353 2024-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
17.259 Wioa Youth Activities $900,357
93.994 Maternal and Child Health Services Block Grant to the States $858,632
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $252,617
84.425 Education Stabilization Fund $164,376
17.258 Wioa Adult Program $112,690
17.270 Reentry Employment Opportunities $95,597
21.009 Volunteer Income Tax Assistance (vita) Matching Grant Program $46,367
93.778 Medical Assistance Program $34,473
84.027 Special Education Grants to States $11,169
17.235 Senior Community Service Employment Program $10,966
17.805 Homeless VeteransÂ’ Reintegration Program $7,000
14.218 Community Development Block Grants/entitlement Grants $5,400