Finding 1147361 (2023-005)

-
Requirement
B
Questioned Costs
$1
Year
2023
Accepted
2025-07-10
Audit: 361880
Organization: YWCA New Hampshire (NH)

AI Summary

  • Core Issue: Payroll charges for the grant were based on management-set percentages, not actual hours worked, violating time and effort documentation requirements.
  • Impacted Requirements: Compliance with 2 CFR 200.430 is necessary to ensure proper allocation of employee time to federal programs.
  • Recommended Follow-Up: Implement a system for tracking and documenting actual hours worked by employees for each grant program to ensure accurate expense allocation.

Finding Text

Criteria: Time and effort requirements state that employee time must be maintained with sufficient documentation to provide for appropriate allocation to the federal program. Time and effort requirements are outlined in 2 CFR 200.430. 32 Condition: Payroll charges for the grant were based on a percentage of time by employee. This percentage was based on management’s decision and set when budgeting; the percentage charged to the grant was not based on actual hours worked. Cause: Payroll was processed by an outside service provider based on information provided by management. Management did not require the breakdown of hours as it relates to the federal programs which were being charged. Management was unaware of this time and effort requirement. Effect or potential effect: The costs submitted for reimbursement under the grant may not be appropriate. The failure to report time appropriately and allocate by program could increase the risk of errors in amounts reported as expended. Questioned costs: The questioned costs are unknown, as the amount of payroll that could have been inappropriately charged to the grant is unable to be recalculated at this time. The true allocation of hours was not recorded. Context: The YWCA New Hampshire expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2023 requiring a compliance audit in accordance with the Uniform Guidance. The organization has not required a compliance audit in previous years and management was not aware of the various requirements of the Uniform Guidance. The payroll deficiencies were a systemic problem noted during the audit. Recommendation: We recommend that time and effort be maintained in accordance with the Uniform Guidance. We recommend that employees clearly identify hours by grant program for appropriate allocation of the expenses. Views of Responsible Officials: YWCA New Hampshire’s management concurs with this audit finding.

Categories

Questioned Costs Allowable Costs / Cost Principles Cash Management

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
16.575 Crime Victim Assistance $252,827
14.218 Community Development Block Grants/entitlement Grants $173,991
93.493 Congressional Directives $94,240
14.267 Continuum of Care Program $60,543
16.736 Transitional Housing Assistance for Victims of Domestic Violence, Dating Violence, Stalking, Or Sexual Assault $36,334
16.017 Sexual Assault Services Formula Program $31,629
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $28,302
93.136 Injury Prevention and Control Research and State and Community Based Programs $15,310
21.027 Coronavirus State and Local Fiscal Recovery Funds $10,000
16.588 Violence Against Women Formula Grants $9,321