Finding 393929 (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.

Corrective Action Plan

Response to Deficiency: Concur. The control has been added effective January 1, 2024. Corrective Action Plan: The current process has been modified to add internal audit to process for adding grant codes to allocation tables. Audit will be conducted by staff accountant who is not a part of the code input process. Internal auditor will review allocation tables to ensure new grant codes are properly included and communicate compliance to requestor and the CFO. Preventative Action Plan: All finance team members will be retrained regarding addition to the current process. Responsbile Personnel: Priya Sarathy, Chief Financial Officer Date: 4/11/2024

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