Finding 966531 (2021-003)

-
Requirement
B
Questioned Costs
-
Year
2021
Accepted
2024-03-29
Audit: 300971
Auditor: Mun CPAS LLP

AI Summary

  • Core Issue: Lack of formal documentation for payroll charged to the grant and incorrect allocation methods used throughout the year.
  • Impacted Requirements: Compliance with federal guidelines for maintaining accurate payroll records and proper allocation of costs.
  • Recommended Follow-Up: Establish a clear process for payroll allocation, including tracking actual hours worked and conducting time studies for salaried employees.

Finding Text

Federal Award Information: Name of Federal Agency: Department of Housing and Urban Development Federal Program Title: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Federal Award Year: 2021 Passed Through: County of Yuba Pass Through Number: COVID-19 Criteria Funding provided through the County of Yuba to initiate and continue operation of a Vulnerable Populations Food Delivery Program. Condition During our testing of payroll charged to the grant, we noted formal documentation was not maintained to support payroll allocated to the grant. In addition, the Organization allocated net, rather than gross, pay to the grant throughout the year and posted an adjustment at year-end to correct wages and taxes. Cause Due to personnel turnover, documentation was not maintained and wages were not correctly allocated to the grant throughout the year. Effect Failure to maintain documentation supporting allocation percentages and using an incorrect allocation basis could lead to incorrect payroll amounts charged to grants. Questioned Costs No costs are questioned. Repeat Finding This is not a repeat finding. Recommendation We recommend the Organization develop a process to allocate payroll to grants, such as using actual hours worked for hourly employees and performing a time study for salaried employees, implement procedures to consistently allocate payroll to grants, and use the proper base for the allocation.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
21.019 Coronavirus Relief Fund $309,815
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $194,704
10.568 Emergency Food Assistance Program (administrative Costs) $27,227
93.469 Assistive Technology Alternative Financing Program $25,000
97.024 Emergency Food and Shelter National Board Program $17,063
93.569 Community Services Block Grant $1,813
10.178 Trade Mitigation Program Eligible Recipient Agency Operational Funds (a) $421