Finding 573727 (2024-003)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2025-08-16

AI Summary

  • Core Issue: There is a material weakness in how payroll-related expenses are allocated to grants, as they do not align with timesheets and lack timely management approval.
  • Impacted Requirements: Policies for reviewing payroll expenditures charged to grants are insufficient, leading to potential inaccuracies in grant reporting.
  • Recommended Follow-Up: Implement a policy for management to review and approve timecards regularly, and establish a system to track and reconcile hours charged to grants with payroll expenses.

Finding Text

Finding 2024-003: 11.307 Economic Development Cluster: Material Weakness: Allocation and Approval of Time Charged to Grants Criteria: Policies and procedures should be in place to identify and review payroll-related expenditures charged to grants to ensure accurate grant reporting. This should include documentation of proper supervision and review. Condition: The allocation of payroll-related expenditures charged to grants did not directly tie to timesheets and could not easily be reconciled. Furthermore, timecards were not reviewed and approved by management on a timely basis. Cause: Employees code time to various projects and functions, including grants, however, there was no evidence or supporting documentation of management’s review and approval of the timecards used to allocate personnel expenses between programs. While payroll-related expenditures are charged to grants, the amount charged does not tie to timecards/paystubs. Instead, wages are allocated based on a percentage calculated during an analysis of each employee’s time worked on the program, while the fringe benefits are charged at a budgeted 25% of the wages. Effect: Payroll-related expenditures are not easily tied back to underlying timecards and paystubs. These expenses did not have evidence of approval which creates the potential for payroll-related amounts on specific grants to be inaccurate. Recommendation: A policy should be implemented for management to review and document approval of timecards to determine whether time coded to grants is appropriate. Additionally, management should implement a system where hours are tracked and coded to grants during each pay period and payroll-related expenditures charged to the grant are reconciled to the time coded. This includes payroll related taxes and employee benefits. Management’s Response: The WV Community Development Hub management is actively addressing the deficiencies related to allocation and approval of time charge to federal grants. We have implemented improved internal processes over the past year to better track and allocate staff time across all grants, including federal grants, and maintain detailed time tracking for all staff that determine payroll allocations. We recognize there is further need to directly link time tracking to payroll allocation, and that we need more standardized bi-monthly supervisory approval processes for staff time tracking, and management approval of payroll allocations on a consistent basis. We are implementing a new, significantly more robust financial accounting system that will standardize time tracking, payroll allocation and approval processes all within one system. This system was determined as a need at the beginning of 2024, and we have conducted a multi-month review and analysis process to identify the best system for our organizational needs. The system will be in place and fully operational within six (6) months and we expect it will directly address and remediate current challenges in all of the areas identified by the auditors.

Corrective Action Plan

Planned Corrective Action: The Hub implemented a new software system with fully integrated payroll and timekeeping functionality. Name of Contact Person: Cindy Heltzel, CPA, CFO c.heltzel@wvhub.org Anticipated completion date: Completed

Categories

Allowable Costs / Cost Principles Material Weakness Reporting

Other Findings in this Audit

  • 573728 2024-003
    Material Weakness Repeat
  • 1150169 2024-003
    Material Weakness Repeat
  • 1150170 2024-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
23.002 Appalachian Area Development $579,966
11.307 Economic Adjustment Assistance $143,327
66.957 Greenhouse Gas Reduction Fund: National Clean Investment Fund $88,140
10.446 Rural Community Development Initiative $61,764
14.270 Appalachia Economic Development Initiative $58,828
94.013 Americorps Volunteers in Service to America 94.013 $48,976
14.251 Economic Development Initiative, Community Project Funding, and Miscellaneous Grants $10,856