Finding 970377 (2023-001)

Significant Deficiency
Requirement
AB
Questioned Costs
-
Year
2023
Accepted
2024-04-22

AI Summary

  • Core Issue: The organization failed to review and adjust salaried employees' wage allocations after-the-fact, violating federal guidelines.
  • Impacted Requirements: Non-compliance with 2 CFR Section 200.430(i)(1)(viii) regarding documentation and adjustments of personnel expenses.
  • Recommended Follow-Up: Implement a process for after-the-fact reviews and adjustments of wage distributions to ensure accuracy and compliance with federal requirements.

Finding Text

Crime Victim Assistance U.S. Department of Justice Passed through California Office of Emergency Services Federal Catalog Number 16.575 Federal Award Identification Number XC 22 05 1248 (January 1, 2023 - December 31, 2023) Federal Award Identification Number RC 22 31 1248 (October 1, 2022 - September 30, 2023) Federal Award Identification Number XL 21 04 1248 (January 1, 2022 - December 31, 2022) Federal Award Identification Number SP 22 05 1248 (May 1, 2023 - April 30, 2024) Federal Award Identification Number XH 21 04 1248 (January 1, 2022 - December 31, 2022) Criteria Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), The Internal Control - Integrated Framework, published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) and numerous federal guidelines require the establishment and maintenance of internal control designed to reasonable ensure accurate financial reporting and compliance with laws, regulations and program requirements. The Organization is required to be in compliance with the criteria contained in 2 CFR Part 200. 430(i)(1 )(viii). Which require documentation of personnel expenses based on: "Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes provided that: A. The system for establishing the estimates produces reasonable approximations of the activity actually performed; B. Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and C. The non-Federal entity's system of internal controls includes processes to review after-the- fact interim charges made to a Federal award based on budget estimates. All necessary adjustment must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated." Condition The budgeted allocation of salaried employees' wages among multiple projects were not reviewed and adjusted after-the-fact as required by 2 CFR Section 200.403(i)(1 )(viii). Questioned Costs The known questioned costs were $1,427 of personnel costs charges to federal program. Proper Perspective Twenty-eight payroll cash disbursements were tested totaling $25,645. The total sample population was $1,221,287. Therefore, likely questioned costs are $36,471. Our sample was a statistically valid sample. The issue is systematic to the organization's salaried employee payroll process. Effect The Organization is out of compliance with Uniform Guidance requirements for Allowable Costs/Cost Principle. Cause The Organization's internal control process over charging salaried personnel cost based on the labor distribution report, does not include an after-the-fact review and adjustment based on actual time worked. Recommendation We recommend that the Organization have support for the distribution of the employees' wages among each project. If budget or estimates are used for allocations among projects, we recommend an after- the-fact review is done and the necessary adjustments are made to the final amount charged for that period to ensure the amount charges to the project is accurate, allowable and properly allocated following the requirements of 2 CFR Section 200.430(i)(1 )(viii).

Categories

Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 393934 2023-002
    Significant Deficiency
  • 393935 2023-001
    Significant Deficiency
  • 970376 2023-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
16.575 Crime Victim Assistance $1.47M
14.238 Shelter Plus Care $240,077
14.241 Housing Opportunities for Persons with Aids $202,003
14.267 Continuum of Care Program $179,537
16.320 Services for Trafficking Victims $172,629
93.497 Family Violence Prevention and Services/ Sexual Assault/rape Crisis Services and Supports $103,119
93.671 Family Violence Prevention and Services/grants for Battered Women's Shelters-Grants to States and Indian Tribes $100,833
97.024 Emergency Food and Shelter National Board Program $99,540
93.597 Grants to States for Access and Visitation Programs $83,437
93.959 Block Grants for Prevention and Treatment of Substance Abuse $78,680
16.588 Domestic Violence Response Team $74,819
93.136 Injury Prevention and Control Research and State and Community Based Programs $73,803
93.558 Temporary Assistance for Needy Families $69,617
97.024 Dept of Homeland Security Food Distribution $46,658
16.588 Grants to Encourage Arrest Policies and Enforcement of Protection $27,749
14.239 Home Investment Partnerships Program $5,423