Finding 1228706 (2024-003)

Material Weakness Repeat Finding
Requirement
A
Questioned Costs
-
Year
2024
Accepted
2026-09-03

AI Summary

  • Core Issue: The Coalition used estimates to allocate payroll costs to grants without proper documentation, violating federal requirements.
  • Impacted Requirements: Compliance with 2 CFR §200.430(i) regarding accurate records for salary and wage charges to federal awards.
  • Recommended Follow-up: Implement formal procedures for tracking actual time and effort, ensure documentation supports payroll allocations, and conduct regular reviews for accuracy.

Finding Text

Finding No. 2024-003: Activities Allowed or Unallowed and Allowable Costs/Cost Principles (Payroll) –Significant Deficiency in Internal Control over Compliance Federal Program Name: All Pass-through Entity: All Federal Assistance Listing Number: All Criteria In accordance with 2 CFR §200.430(i), charges to federal awards for salaries and wages are required to be based on records that accurately reflect the work performed. These records must support the distribution of the employee’s salary or wages among specific activities or cost objectives. Condition The Coalition allocated employees’ payroll costs to grants based on estimates and did not maintain documentation to support allocations based on actual time and effort. Questioned Costs Unknown. Context The Coalition allocated payroll costs to multiple funding sources based on estimates during the audit period and did not maintain formal documentation to support how costs were distributed. Effect The employee time and payroll costs that are charged to the grant could differ from the actual time and payroll costs expended in support of the grant activities. Cause The Coalition does not have established procedures to ensure that salaries and wages charged to federal awards are supported by records that accurately reflect the work performed. Documentation of personnel expenses should 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; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Repeat Finding No Recommendation We recommend that management strengthen processes over payroll cost allocations to ensure amounts charged to funding sources are supported by documented actual time and effort. This may include implementing a formal methodology for allocating payroll costs, establishing procedures for employees to track or otherwise document time spent by program or funding source, and performing periodic reviews and adjustments based on actual activity. In addition, management should ensure that sufficient documentation is maintained to support how payroll costs are allocated and that such processes are consistently applied. Management’s Response/View of Responsible Officials Management agrees with this finding, see the Corrective Action Plan.

Corrective Action Plan

During fiscal year 2026, the Coalition engaged an outsourced accounting firm to assist with grant compliance and financial reporting. The Coalition has implemented procedures requiring employees whose activities benefit multiple funding sources to document actual time and effort by program or activity. Payroll allocations will be reviewed periodically and adjusted as necessary to reflect actual work performed. Management and the outsourced accounting team will maintain supporting documentation for payroll allocations and monitor compliance with Uniform Guidance requirements.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1228703 2024-003
    Material Weakness Repeat
  • 1228704 2024-003
    Material Weakness Repeat
  • 1228705 2024-003
    Material Weakness Repeat
  • 1228707 2024-004
    Material Weakness Repeat
  • 1228708 2024-004
    Material Weakness Repeat
  • 1228709 2024-004
    Material Weakness Repeat
  • 1228710 2024-004
    Material Weakness Repeat
  • 1228711 2024-005
    Material Weakness Repeat
  • 1228712 2024-005
    Material Weakness Repeat
  • 1228713 2024-005
    Material Weakness Repeat
  • 1228714 2024-005
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $181,576
14.267 CONTINUUM OF CARE PROGRAM $156,790