Finding 561992 (2024-004)

Material Weakness
Requirement
B
Questioned Costs
$1
Year
2024
Accepted
2025-05-30
Audit: 357595
Organization: Colorado Legal Services, INC (CO)

AI Summary

  • Core Issue: Errors totaling $906 were found in salary allocations due to inconsistent application of time and effort records, leading to potential misrepresentation of employee contributions to grants.
  • Impacted Requirements: Federal regulations require that costs be documented and consistently applied across all activities, which was not met due to manual adjustments and varying allocation methods.
  • Recommended Follow-Up: Update the cost allocation methodology to minimize manual adjustments and ensure consistent, automated calculations, while maintaining proper documentation for all allocations.

Finding Text

Criteria or Specific Requirement: Federal regulations (CFR 200.403), state that allowable costs must be consistent with policies and procedures of federal award recipients that apply uniformly to both federally-financed and other activities of the Organization. It also states that costs must be adequately documented. Condition: During our testing, we noted four instances of errors totaling a net error of $906 (an absolute value error of $1,030) where the incorrect number of hours were utilized in the allocation of the employee's pay, the incorrect employee's time was used in the allocation of the employee's pay, or there were unsupported amounts added to the allocation of the employee's pay. As such, the salary costs mentioned above were allocated in an inconsistent manner to other grant payroll costs and were not fully representative of the employees' time and effort and benefit obtained by grant from the allocated cost. Management noted that it performed year-end grant reconciliations to ensure costs were properly allocated to each grant in total. We noted a lower frequency of differences in sample selections that occurred during the last several months of the year after management implemented a change to its allocation processes in response to the prior year audit. Questioned Costs: $906 of allocated salaries expense described above, which is related to Assistance Listing Number 93.044. Context: These five instances were noting during testing of 26 payroll and payroll-related disbursements. Cause: The Organization’s salary, wage and employee benefit cost allocation methodology is primarily based on time and effort records and a periodic calculation of specific grant hours versus general fund hours multiplied by period costs, but it often includes manual adjustments based on review of individual time records and expense data. Therefore, the methodology is challenging to apply consistently, document contemporaneously, and apply in accordance with federal regulations. Effect: The inclusion of frequent manual adjustments and varying allocation bases in the Organization’s salaries, wages, and employee benefit cost allocation methodology could cause costs to be allocated to grants that are not reflective of the time and effort spent on grant activities nor compensation paid to employees during relevant work periods. It could also lead to challenges in maintaining sufficient supporting documentation of such cost allocations. Repeat Finding: This is not a repeat finding. Recommendation: We recommend that the Organization consider updating its salaries, wages, and employee benefit cost allocation methodology and process to reduce the frequency of manual adjustments based on review of individual time records and expense data and maximize the use of automated allocations based on employees’ time and effort records, effective compensation during work periods, and that are calculated in a consistent manner. We also recommend that the Organization maintain contemporaneous documentation supporting all cost allocations. Views of responsible officials: Management does not agree with this finding. LSC program letter 22-5 emphasizes the importance of reconciliations of timekeeping reports with labor costs, distribution report or alternative reports. CLS prioritizes this practice of reconciliation and used it during the last months of 2024 to improve internal controls and minimize potential errors. We do not believe that CLA fully and fairly considered CLS’s thorough and complete reconciliation. A “material weakness” is defined as a deficiency “such that there is a reasonable possibility that a material misstatement of the entity’s financial statements will not be prevented, or detected and corrected, on a timely basis.” Given that reconciliation is part of our internal control process used to prevent and detect/correct any errors, it should have been fully considered and is unfairly excluded from the review. For this reason, CLS considers that this is not a material weakness as the reconciliation caught and corrected these errors. Finally, the total amount of this finding is very low and should not rise to the level of material weakness. Auditor’s Concluding Remarks: Management’s response did not persuade the auditor to revise the finding. The aging cluster is not an LSC program and so its relevance to this finding is unclear. Federal regulations (CFR 200.403), state that allowable costs must be consistent with policies and procedures of federal award recipients that apply uniformly to both federally-financed and other activities of the Organization. It also states that costs must be adequately documented. Such costs should be contemporaneously applied to grants as they are incurred using a system of processes and controls.

Categories

Questioned Costs Allowable Costs / Cost Principles HUD Housing Programs Material Weakness

Other Findings in this Audit

  • 561972 2024-002
    Material Weakness Repeat
  • 561973 2024-003
    Material Weakness Repeat
  • 561974 2024-006
    Material Weakness
  • 561975 2024-002
    Material Weakness Repeat
  • 561976 2024-003
    Material Weakness Repeat
  • 561977 2024-006
    Material Weakness
  • 561978 2024-002
    Material Weakness Repeat
  • 561979 2024-003
    Material Weakness Repeat
  • 561980 2024-006
    Material Weakness
  • 561981 2024-004
    Material Weakness Repeat
  • 561982 2024-005
    Material Weakness Repeat
  • 561983 2024-006
    Material Weakness
  • 561984 2024-004
    Material Weakness
  • 561985 2024-005
    Material Weakness Repeat
  • 561986 2024-004
    Material Weakness
  • 561987 2024-005
    Material Weakness Repeat
  • 561988 2024-004
    Material Weakness
  • 561989 2024-005
    Material Weakness Repeat
  • 561990 2024-004
    Material Weakness
  • 561991 2024-005
    Material Weakness Repeat
  • 561993 2024-005
    Material Weakness Repeat
  • 561994 2024-004
    Material Weakness
  • 561995 2024-005
    Material Weakness Repeat
  • 561996 2024-004
    Material Weakness
  • 561997 2024-005
    Material Weakness Repeat
  • 561998 2024-004
    Material Weakness
  • 561999 2024-005
    Material Weakness Repeat
  • 562000 2024-004
    Material Weakness
  • 562001 2024-005
    Material Weakness Repeat
  • 562002 2024-004
    Material Weakness
  • 562003 2024-005
    Material Weakness Repeat
  • 562004 2024-004
    Material Weakness
  • 562005 2024-005
    Material Weakness Repeat
  • 562006 2024-004
    Material Weakness
  • 562007 2024-005
    Material Weakness Repeat
  • 562008 2024-004
    Material Weakness
  • 562009 2024-005
    Material Weakness Repeat
  • 1138414 2024-002
    Material Weakness Repeat
  • 1138415 2024-003
    Material Weakness Repeat
  • 1138416 2024-006
    Material Weakness
  • 1138417 2024-002
    Material Weakness Repeat
  • 1138418 2024-003
    Material Weakness Repeat
  • 1138419 2024-006
    Material Weakness
  • 1138420 2024-002
    Material Weakness Repeat
  • 1138421 2024-003
    Material Weakness Repeat
  • 1138422 2024-006
    Material Weakness
  • 1138423 2024-004
    Material Weakness Repeat
  • 1138424 2024-005
    Material Weakness Repeat
  • 1138425 2024-006
    Material Weakness
  • 1138426 2024-004
    Material Weakness
  • 1138427 2024-005
    Material Weakness Repeat
  • 1138428 2024-004
    Material Weakness
  • 1138429 2024-005
    Material Weakness Repeat
  • 1138430 2024-004
    Material Weakness
  • 1138431 2024-005
    Material Weakness Repeat
  • 1138432 2024-004
    Material Weakness
  • 1138433 2024-005
    Material Weakness Repeat
  • 1138434 2024-004
    Material Weakness
  • 1138435 2024-005
    Material Weakness Repeat
  • 1138436 2024-004
    Material Weakness
  • 1138437 2024-005
    Material Weakness Repeat
  • 1138438 2024-004
    Material Weakness
  • 1138439 2024-005
    Material Weakness Repeat
  • 1138440 2024-004
    Material Weakness
  • 1138441 2024-005
    Material Weakness Repeat
  • 1138442 2024-004
    Material Weakness
  • 1138443 2024-005
    Material Weakness Repeat
  • 1138444 2024-004
    Material Weakness
  • 1138445 2024-005
    Material Weakness Repeat
  • 1138446 2024-004
    Material Weakness
  • 1138447 2024-005
    Material Weakness Repeat
  • 1138448 2024-004
    Material Weakness
  • 1138449 2024-005
    Material Weakness Repeat
  • 1138450 2024-004
    Material Weakness
  • 1138451 2024-005
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
09.706 Basic Field Grant $6.73M
21.027 Coronavirus State and Local Fiscal Recovery Arapahoe Eviction Clinic $750,000
93.044 Special Programs for the Aging, Title Iii, Part B $632,601
16.575 Civil Legal Services for Victims $545,178
21.026 Energy/mineral Impact Assistance Fund $240,432
09.706 Agricultural Worker Grant $214,417
21.008 Low Income Taxpayer Clinics $199,407
16.320 Services for Victims of Human Trafficking $182,240
09.706 Native American Grant $144,792
09.706 Technology Innovation Grants (tig) $131,117
21.027 Coronavirus State and Local Fiscal Recovery Eviction Diversion $47,544
21.023 Coronavirus State and Local Fiscal Recovery Emergency Rental Assistance $22,281
93.044 Special Programs for the Aging, Title Iii, Part B, Grants for Supportive Services and Senior Centers $22,015
14.218 Community Development Block Grants/entitlement Grants $21,440
16.815 Tribal Civil Legal Assistance $17,610