Finding 1221744 (2024-004)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2026-06-30

AI Summary

  • Core Issue: Payroll expenses submitted for grants contained errors, including an unallowable cost of $83 and incorrect shift differential calculations.
  • Impacted Requirements: Grant agreements mandate that payroll expenses must be both allowable and accurately calculated.
  • Recommended Follow-Up: Establish clear procedures for allowable costs, enhance payroll system checks, implement secondary reviews, and provide training on grant requirements.

Finding Text

Criteria: Payroll expenses are required to be allowable and accurate per the grant agreement. Condition: Grant claims submitted and paid had various errors in shift differential payroll. Errors included an unallowable cost and incorrect calculations for grant claims. Cause: There is not an adequate internal control system in place to determine what is an allowable cost and ensure payroll calculations are accurate. Effect: Several errors were found including an unallowable cost and incorrect calculation of shift differential claimed. Questioned Costs: Unallowable cost of $83 was identified in the sample of ten employee payments reviewed. There were also incorrect calculations on five out of ten employee payments tested resulting in underclaimed amounts. Perspective Information: The shift differential findings are isolated to payroll samples tested but may be pervasive to other payrolls. Repeat Findings: Not a repeat finding. Context: Payroll testing was conducted on a sample of ten employees. One employee had an unallowable cost of $83 that was claimed and reimbursed by the grantor. Five out of ten employees tested had incorrect calculations resulting in underclaimed amounts. Recommendation: Procedures should be established to ensure only allowable costs are submitted to grantors and payroll calculations are accurate. Views of Responsible Officials and Planned Corrective Actions: YWCA acknowledges weaknesses in payroll allowability and calculation accuracy. • Update written payroll procedures for grant-funded employees that define allowable and unallowable pay elements (including shift differentials) and specify documentation requirements. • Configure payroll and accounting systems to properly classify VOCAfunded positions and apply standard shift differential calculations, with automated checks where possible. • Require a secondary review of payroll registers and allocations for VOCAfunded staff before costs are included in reimbursement requests, with sign-off by designated finance team member. • Provide training to HR, payroll, and finance staff on VOCA grant requirements, federal cost principles, and internal review procedures.

Corrective Action Plan

Views of Responsible Officials and Planned Corrective Actions: YWCA acknowledges weaknesses in payroll allowability and calculation accuracy. • Update written payroll procedures for grant-funded employees that define allowable and unallowable pay elements (including shift differentials) and specify documentation requirements. • Configure payroll and accounting systems to properly classify VOCAfunded positions and apply standard shift differential calculations, with automated checks where possible. • Require a secondary review of payroll registers and allocations for VOCAfunded staff before costs are included in reimbursement requests, with sign-off by designated finance team member. • Provide training to HR, payroll, and finance staff on VOCA grant requirements, federal cost principles, and internal review procedures.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1221743 2024-003
    Material Weakness Repeat
  • 1221745 2024-005
    Material Weakness Repeat
  • 1221746 2024-006
    Material Weakness Repeat
  • 1221747 2024-007
    Material Weakness Repeat
  • 1221748 2024-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
16.575 CRIME VICTIM ASSISTANCE $298,506
93.898 CANCER PREVENTION AND CONTROL PROGRAMS FOR STATE, TERRITORIAL AND TRIBAL ORGANIZATIONS $157,564
14.267 CONTINUUM OF CARE PROGRAM $92,723
93.671 FAMILY VIOLENCE PREVENTION AND SERVICES/DOMESTIC VIOLENCE SHELTER AND SUPPORTIVE SERVICES $66,723
93.436 WELL-INTEGRATED SCREENING AND EVALUATION FOR WOMEN ACROSS THE NATION (WISEWOMAN) $34,042
16.588 VIOLENCE AGAINST WOMEN FORMULA GRANTS $27,207
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $22,508
93.667 SOCIAL SERVICES BLOCK GRANT $21,800
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $19,781