Finding 498486 (2023-001)

Significant Deficiency
Requirement
B
Questioned Costs
$1
Year
2023
Accepted
2024-09-26
Audit: 321192
Organization: Enterprisekc (KS)
Auditor: Rubinbrown LLP

AI Summary

  • Core Issue: Payroll costs were overbilled to the grant due to insufficient documentation of time and effort for one employee, leading to questioned costs of $10,565.
  • Impacted Requirements: Compliance with 2 CFR 200.430 and 2 CFR 200.413 was not met, as costs were not accurately tracked and direct costs were duplicated in fringe benefit calculations.
  • Recommended Follow-Up: Implement a time tracking review process and revise fringe benefit rates to exclude costs already billed as direct expenses, with completion expected by September 2024.

Finding Text

Finding 2023-001 - Significant Deficiency, Compliance Federal Assistance Listing Number. 21.027 U.S. Department Of Treasury State and Local Fiscal Recovery Funds – Allowable Costs Criteria: According to 2 CFR 200.430(i)(1)(vii) “Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must:….(vii) 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; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity….”. Additionally, according to 2 CFR 200.413(a) “Cost incurred for the same purpose in like circumstances must be treated consistently as either direct or indirect (F&A) costs.” Condition: In our nonstatistical sample of 13 allowable cost selections we identified 2 payments that covered payroll costs that were not supported by sufficient documentation of time and effort for one employee. For select administrative employees for which time was allocated to the grant, the use of a fringe benefits rate included the allocation of rent built into the rate when rent was already billed as a direct cost. Context: Monthly payroll was billed to EnterpriseKC and to the grant by a related organization based on the time and effort tracked by the related organization for that month; however, it was noted that one employee’s full salary was billed to the grant and the time and effort spent on grant-related activities was less than full-time, with remaining time being spent on non-Federal award activities. Based on the employee’s time spent on the grant related activities the employee’s payroll costs billed to the grant for the 2 months evaluated was overbilled to the grant by $10,416. The related organization also billed EnterpriseKC and the grant for administrative employees’ time using an hourly billing rate that was determined by using the employees’ salaries divided by the standard hours worked plus an estimate of fringe benefits that ranged from 25% to 32%. The fringe benefits rate included allocation of rent expense which was already separately billed by the related organization as a direct cost. The actual fringe benefit rate excluding the rent was approximately 24% which resulted in estimated overbillings to the grant for the 2 months reviewed totaling $149. Effect: As a result of the overbillings noted, the grant expenditures were overstated by $10,565 for the questioned costs identified. Questioned Costs: Known questioned costs totaled $10,565. Additional likely questioned costs totaled $39,937 and were determined by allocating the percentage of known questioned costs as a percentage of the total costs included in the sample tested from the related organization multiplied by the total costs incurred with the related organization. It was not considered appropriate to project questioned costs to the remaining population of costs as the questioned costs were isolated to payroll related costs. Cause: EnterpriseKC did not have internal controls in place with sufficient precision to detect errors related to overbilling payroll costs to the grant. Further, EnterpriseKC did not have controls in place to ensure that direct costs billed to the grant were not duplicated by also being included in the payroll fringe rate. Identification Of Repeat Finding: This is not a repeat finding. Recommendation: We recommend that EnterpriseKC should ensure that any payroll costs for each individual employee allocated to the grant are supported by appropriate time and effort. We recommend that EnterpriseKC ensure that its billing rate for administrative employees only includes allocable fringe benefits and does not including any costs already separately billed as a direct cost. Views Of Responsible Officials (Unaudited): Management will implement a comprehensive time tracking review process that also extends to reviewing time for employees that choose to work remotely and will ensure that time not allocated to the grant is not included in the costs allocated to the grant. Management will revise the fringe benefit rate that gets charged to the hourly rates to ensure that none of the costs included in the fringe benefits are also direct expenses billed to the grant. The unallowable costs will be redirected to other allowable grant costs in 2024. Anticipated Completion Date: September 2024 Contact Person: Jay Konomos, Pillar Leader

Corrective Action Plan

Corrective Action Plan 2023-001: Management will implement a comprehensive time tracking review process that also extends to reviewing time for employees that choose to work remotely and will ensure that time not allocated to the grant is not included in the costs allocated to the grant. Management will revise the fringe benefit rate that gets charged to the hourly rates to ensure that none of the costs included in the fringe benefits are also direct expenses billed to the grant. The unallowable costs will be redirected to other allowable grant costs in 2024. Anticipated Completion Date: September 2024 Contact Person: Jay Konomos, Pillar Leader

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 498487 2023-002
    Significant Deficiency
  • 1074928 2023-001
    Significant Deficiency
  • 1074929 2023-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $3.85M