Finding 516657 (2022-004)

Significant Deficiency
Requirement
A
Questioned Costs
-
Year
2022
Accepted
2024-12-23

AI Summary

  • Core Issue: Payroll costs are manually allocated to grants using spreadsheets, increasing the risk of errors.
  • Impacted Requirements: Non-compliance with 2 CFR 200.400 regarding proper cost allocation and documentation.
  • Recommended Follow-Up: Implement automated timesheets or time studies to accurately track payroll costs for grant projects.

Finding Text

Finding 2022-004: Significant Deficiency – Grant Claim Support Federal grantor: Department of Commerce Condition: The allocation of payroll costs to programs are done manually using spreadsheets instead of done based on entity-wide timesheets. Criteria: Under 2 CFR 200.400, direct cost allocation principles state that if a cost benefits two or more projects or activities in proportions that can be determined without undue effort or cost, the cost must be allocated to the projects based on the proportional benefit. If a cost benefits two or more projects or activities in proportions that cannot be determined because of the interrelationship of the work involved, then the costs may be allocated or transferred to benefitted projects on any reasonable documented basis. Further, a cost may not be assigned to a Federal award as a direct cost if any other cost incurred for the same purpose in like circumstances has been allocated to the Federal award as an indirect cost. Costs are required to be adequately documented. Cause: The Chamber is not able to readily determine the amount of payroll costs billable to the grants. Effect: The approach of manually allocating payroll costs to grant projects leaves room for error, and makes it difficult to determine that costs are not being reimbursed by more than one source. Recommendation: The Chamber needs to prepare time studies or require employees to prepare timesheets on an automated system to support the payroll costs allocated to programs. Views of Responsible Officials and Planned Corrective Actions: The Chamber agrees with the finding and is in the process of implementing a better time and expense tracking system that will be effective in 2024.

Corrective Action Plan

Description of Finding: The allocation of payroll costs to programs are done manually instead of done based on entity-wide timesheets Statement of Concurrence or Nonconcurrence: The California Asian Pacific Chamber of Commerce (CalAsian) agrees with the finding. Corrective Action: CalAsian acknowledges the serious nature of this finding and the potential for damage to relationships with the grantors and Federal entities. The Interim Controller and Director of Finance are currently implementing an ERP system which will allow for better cost collection, reporting and reviews of the grant-related expenses for accuracy, reliability, and reconciliation. We also understand these findings are repetitive from the 2021 audit; however, due to catch-up of the prior year audits, we were unable to address these issues prior to completion of the 2022 audit. This delay was caused by a change in auditors as our previous auditor did not have the capacity to retain us as clients due to staff shortages related to COVID. A subcontractor has been retained to assist with providing information for the 2023 audit to bring the audits current. The ERP system includes electronic timesheets for daily charging to specific grants, as well as more visibility into the proper separation of direct, indirect, and unallowable costs per the CFR. Timesheet training has been performed and timesheet completion is required for all employees each day. This will begin on 1/1/2025 and will provide support for hours worked/billed, as well as document the certification and approvals that all time entered is accurate and in compliance with contract requirements. and provide proper support for all grant labor costs and indirect costs. An indirect cost pool allocation structure is being designed and implemented to properly allocate the allowable indirect costs to each work effort, including Fringe, Overhead and G&A. This proposed structure and rates will be submitted for approval in 2025 for use in billing the contracts properly. Monthly reviews by the Project Directors/Managers plus Accounting will be performed to identify any potential cost charging issues and corrective action(s) required. Name of Contact Person: Ryan Fong, Director of Finance, 916-446-7883, rfong@calasiancc.org Susan Wright, Controller, 256-689-7055, swright@calasiancc.org Pat Fong Kushida, President & CEO, 916-446-7883, patfongkushida@calasiancc.org Projected Completion Date: January 2025

Categories

Allowable Costs / Cost Principles Significant Deficiency

Other Findings in this Audit

  • 516654 2022-001
    Material Weakness
  • 516655 2022-002
    Material Weakness
  • 516656 2022-003
    Material Weakness
  • 1093096 2022-001
    Material Weakness
  • 1093097 2022-002
    Material Weakness
  • 1093098 2022-003
    Material Weakness
  • 1093099 2022-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
11.802 Minority Business Resource Development $457,771
20.910 Assistance to Small and Disadvantaged Businesses $62,344