Finding 967911 (2023-002)

Material Weakness
Requirement
AB
Questioned Costs
-
Year
2023
Accepted
2024-04-01
Audit: 301952
Organization: Legal Aid Soceity of Hawaii (HI)
Auditor: N&k CPAS INC

AI Summary

  • Core Issue: Salaries and wages were improperly allocated to the LSC grant, with multiple instances of overcharging and incorrect calculations.
  • Impacted Requirements: Compliance with 45 CFR 1630(a)(3) and 45 CFR 1630.5(c)(3) regarding proper cost allocation and accounting system maintenance.
  • Recommended Follow-Up: Modify the accounting system for accurate time allocation and enhance internal controls to ensure payroll data is reviewed and validated.

Finding Text

Criteria: 45 CFR 1630(a)(3) provides that expenditures are allowable under a Legal Services Corporation (LSC) grant or contract only if the recipient can demonstrate that the cost was allocable to the grant or contract. Further, 45 CFR 1630.5(c)(3) requires that recipients maintain accounting systems sufficient to demonstrate the proper allocation of costs to each of their funding sources. Condition: During our audit, we noted that salaries and wages were incorrectly allocated and charged to the Legal Services Corporation grant. Of the twenty-five (25) payroll samples selected for testing, there were nine (9) instances in which salaries and wages were overcharged to LSC. There were four (4) instances in which the Organization’s accounting system allocated salaries and wages based on an improper calculation. For three (3) instances the employee records in the Organization’s time entry system did not match the employee records in the accounting system. This resulted in salaries and wages being allocated based on an outdated default calculation determined by the system. For two (2) instances, time entries prepared by employees were not properly reviewed prior to being recorded in the accounting system to ensure that valid time codes were used. There were no questioned costs as the organization subsequently recorded correcting entries to revise the allocations. Cause: The Organization’s accounting system is not properly configured to allocate time charged by personnel based on actual hours spent on each of the grants or contracts. In addition, data entered into the accounting system was not properly reviewed and validated prior to being imported. Effect: The lack of effective internal controls over the preparation of payroll data and a properly configured accounting system resulted in salaries and wages for time spent by employees on non-LSC grants or contracts being charged to the LSC grant. Identification as a Repeat Fidning, if applicable: Not applicable. Recommendation: that modifications are made to properly allocate time charged by employees to the various funding sources based on actual time spent. Management should also evaluate internal controls over the payroll transaction cycle to ensure that entries prepared by employees are accurate. Views of Responsible Officials and Planned Corrective Action: Management agrees with the finding and the recommendation. See Part V Corrective Action Plan.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 391469 2023-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
09.U01 Lsc - Basic Field Grant $1.91M
14.408 Fair Housing Initiatives Program $572,928
94.006 Americorps $293,384
09.U02 Lsc - Native American $270,279
93.332 Cooperative Agreement to Support Navigators in Federally-Facilitated and State Partnership Marketplaces $209,697
93.558 Temporary Assistance for Needy Families $120,046
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $99,066
09.U04 Lsc - Tig Program Pb21p-0004 $93,687
09.U06 Lsc - Tig Program Pb21p-00015 $26,898
09.U05 Lsc - Tig Program Pb21p-0006 $26,632
09.U03 Lsc - Tig Program 17023 $19,241
93.591 Family Violence Prevention and Services/state Domestic Violence Coalitions $1,632