Finding 970371 (2023-001)

-
Requirement
AB
Questioned Costs
-
Year
2023
Accepted
2024-04-22
Audit: 304090
Organization: Legal Aid Bureau, Inc. (MD)
Auditor: Sb&company

AI Summary

  • Core Issue: Management failed to update FTE allocation tables for 3 out of 25 transactions, leading to overcharged personnel costs to Federal programs.
  • Impacted Requirements: Non-compliance with 2 CFR §200.303 and 2 CFR 200.430 regarding accurate documentation and internal controls for Federal awards.
  • Recommended Follow-Up: Conduct a thorough review of FTE allocations to ensure accurate personnel cost allocation to Federal programs.

Finding Text

Condition: For 3 out of 25 selected transactions, management did not properly update the Full Time Equivalent (FTE) allocation tables, resulting in an overcharge of personnel costs to its Federal programs. Criteria: In accordance with 2 CFR §200.303: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.430: (i) Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity; and (vi) 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 which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Cause: Maryland Legal Aid did not have controls in place to detect errors in the FTE allocation tables that were used to allocate personnel costs to its Federal programs. Effect: Unallowed payroll costs could be charged to Federal grants. Questioned Costs: Unknown. Recommendation: We recommend Maryland Legal Aid perform a detailed review of the FTE allocations used to allocate personnel costs to its Federal programs. Auditee Response and Corrective Action Plan: Refer to management’s corrective action plan.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
09.321 Basic Field and Migrant Worker Grants $6.96M
93.914 Hiv Emergency Relief Grant Program Ema $140,614
16.575 Protecting the Legal Rights of Victims of Crime (voca) $135,560
14.218 Cdbg-Entitlement Grants Cluster $111,782
21.026 Homeowner Assistance Fund - Covid 19 $87,465
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior - Montgomery County $83,734
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers - Prince George's County $70,782
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers - Baltimore County $53,784
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers - Anne Arundel County $49,537
21.027 Recovery Fund - Eviction Prevention - Covid 19 $44,829
14.218 Community Development Block Grants/entitlement Grants $44,117
14.218 Community Development Block Grant - Cv3 $40,371
21.023 Era 2 Program - Covid 19 $15,399
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers - Frederick County $13,806
21.023 Era 1 Program - Covid 19 $13,224
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers - Howard County $12,773
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers - Mac, Inc. Area on Aging: Dorchester, Somerset, Wicomico & Worchester Counties $11,648
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers - Harford County $10,741
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers - Charles County $6,741
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers - St. Mary's County $6,325
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers - Carroll County $6,009
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers - Queen Anne's County $3,653
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers - Calvery County $3,173
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers - Cecil County $2,949
16.588 Enhanced Legal Representation (vawa) $2,484