Finding 528485 (2023-002)

Significant Deficiency Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2023
Accepted
2025-03-17
Audit: 346487
Organization: Public Law Center (CA)
Auditor: Davis Farr LLP

AI Summary

  • Core Issue: The Center billed $852,359 to the State Bar of California, with $371,621 in questioned costs due to unsupported payroll allocations.
  • Impacted Requirements: Federal guidelines (2 CFR 200.430(i)) require payroll charges to be based on accurate records of actual work performed, which were not maintained.
  • Recommended Follow-Up: Ensure payroll allocations are based on actual hours worked as recorded in timesheets to comply with federal standards.

Finding Text

(2023-002) Allowable Costs Federal Agency: U.S. Department of Treasury CFDA No.: 21.027 Federal Program: Coronavirus State and Local Fiscal Recovery Funds Federal Award Year: 2023 Control Category: Allowable Costs Questioned Costs: $371,621 Condition The Center billed $852,359 to the State Bar of California for the above mentioned grant during the year ended December 31, 2023. Of the total costs charged, $694,940 was for payroll and benefit costs. The Center provided a detail of quarterly expenses by employee that totaled $603,238, leaving $91,702 of questioned costs. From the $603,238 of employee costs, we selected a sample of 20 individual payroll expenses covering both grants and two quarters. We then obtained the employee’s personnel action form and timesheet to determine if the time billed to the grant was supported by the timesheet. In situations where the employee completed a timesheet, we identified differences between what was allocated to the grant and what was reported on the timesheet. For other employees, we noted that no timesheet was retained to support the allocation. Criteria 2 CFR 200.430(i), Standards for Documentation of Personnel Expenses, states, in part: “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed…” Charges must “support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award;…” And “budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Cause The Center's calculation of payroll allocated to the grant is not reconciled to the actual hours reported by the employee on their individual timesheet, and in many cases no timesheet is maintained by the employee. Effect Payroll costs allocated to the program are not supported by the Center’s accounting records. Questioned Costs We identified $52,780 of unsupported allocations to the grant from the sample selected, which extrapolates to a possible error of $279,919. Additionally, as previously reported, $91,702 of costs allocated to the grant were not supported by the accounting records. The total questioned costs are $371,621. Per discussion with Center staff, the State Bar of California does not require the payroll allocation to be supported by evidence of actual time spent on the grant. Recommendation We recommend that the Center allocate time to the grants based on actual hours worked per the employees' timesheets to comply with the federal guidelines. Management Response Beginning in March of 2024, when the Center received the 2022 Single Audit findings, the Center has been charging personnel costs to the federal program based on actual time recorded in the organization’s case management software. On a quarterly basis, the Unit Heads, CFO, CEO/ED, and Chief Legal Program Officer review the hours to ensure accuracy and completeness. Management notes that this finding involved the period of time before the Center had submitted its Corrective Action Plan (which was on March 28, 2024).

Corrective Action Plan

Since March 2024, PLC has been charging personnel costs to the program based on actual time recorded in the organization’s case management software, with quarterly audits of time to ensure accuracy. PLC also began charging non-personnel costs based on ratio tied to actual time recorded. For program costs prior to March of 2024, PLC completed a regressive analysis to determine the amount of actual time worked on the program. This process included review of time recorded in our case management software to determine which portions should have been allocated to this program and, for those staff who do not record time in the case management software, forensics analysis of their grant activities during the period to determine the actual time worked. Personnel and non-personnel costs charged to the program prior to March 2024 were recalculated based on these calculations of actual time worked on the program

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1104927 2023-002
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $312,483
16.575 Crime Victim Assistance $191,245
21.008 Low Income Taxpayer Clinics $131,200
93.604 Assistance for Torture Victims $112,065
93.914 Hiv Emergency Relief Project Grants $88,445
14.218 Community Development Block Grants/entitlement Grants $30,225
93.048 Special Programs for the Aging, Title Iv, and Title Ii, Discretionary Projects $17,878