Finding 29512 (2022-002)

-
Requirement
AB
Questioned Costs
-
Year
2022
Accepted
2023-08-02
Audit: 31514
Organization: Prc (CA)

AI Summary

  • Core Issue: PRC lacks proper controls for payroll documentation, leading to unsupported payroll charges to federal programs.
  • Impacted Requirements: Non-compliance with 2 CFR 200.430(i)(1) regarding accurate time tracking and documentation for salaries and wages.
  • Recommended Follow-Up: PRC should establish control procedures for payroll documentation and conduct semi-annual time studies to ensure proper allocation of staff time.

Finding Text

2022-002: Activities Allowed or Unallowed and Allowable Costs/Cost Principles: , No Time Studies, Proper Time Tracking, Time Allocation, and Time Reporting (Significant Deficiency) Federal program information: Funding agency: U.S. Department of Human Health and Services Title: HIV Emergency Relief Formula Grant ALN: 93.914 Funding agency: U.S. Department of Housing and Urban Development Title: Housing Opportunities for Persons With AIDS ALN: 14.241 Criteria: According to 2 CFR ?225, Appendix B, charges to federal awards for salaries and wages should be based on payrolls documented in accordance with generally accepted practices within the Organization and approved by a responsible official of the Organization. Further, charges for salaries and wages will be signed by the employee and supervisory official having firsthand knowledge of the work performed by the employee. Additionally, in accordance with 2 CFR 200.430(i)(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. Condition: We noted that PRC did not have controls in place to ensure that all payroll expenditures were properly supported per PRC?s policies and procedures. ? HIV Emergency Relief Formula Grant (ALN 93.914) - As per PRC's internal procedure manual, time sheets should be updated by both salaried and hourly employees; however, time cards for 22 samples could not be located. ? Housing Opportunities for Persons With AIDS (ALN 14.241) - For payroll samples selected for testing, we were unable to determine how payroll was tracked and charged for all of the employees who provide direct services related to this program. Cause: PRC did not follow its policies and procedures regarding the retention of payroll supporting documentation. Effect: Payroll related charges to the program are not supported. PRC is not in compliance with 2 CFR 200.430(i)(1) regarding documentation in support of salaries and wages charge to the federal program. Questioned Costs: Questioned costs were not determinable. Repeat finding: No Recommendation: We recommend that PRC implement control procedures to ensure that all payroll costs charged to the federal program are supported by documentation as required by 2 CFR 200.430(i)(1). Further, we recommend PRC to conduct and document semi-annual time studies to ensure that all staff time is allocated properly across all contracts and funding sources.

Corrective Action Plan

July 6, 2023 Harshwal & Company, LLP 333 Hegenberger Rd, Suite 328 Oakland, CA 94621 As required by Title 2 As required by Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), we have provided below our responses and corrective action plans addressing the findings noted in the PRC's Single Audit reporting package for the year ended June 30, 2022. Response and Corrective Action Plan 1. Finding 2022-002 (Prior Year Finding 2021-002) - Activities Allowed or Unallowed and Allowable Costs/Cost Principles, No Time Studies, Proper Time Tracking, Time Allocation and Time Reporting (Significant Deficiency) Response and Corrective Action Plan: 35& DQG %DNHU 3ODFHV ,QF FROOHFWLYHO\ ?35&' FRQFXUV ZLWK WKH ILQGLQJ DQG has implemented the following steps to correct the condition: a. PRC instituted new payroll procedures requiring supervisors to document approval of time submitted by all staff through our electronic payroll system, including a retroactive review and approval of all time submitted since July 2022. b. Staff were trained on the new procedures during June 2022 and the procedures are being incorporated into a new combined PRC and Baker Places, Inc. Financial Policies and Procedures Manual which will be finalized and circulated to all staff in July, 2023. Anticipated completion date: July 2023 Responsible person: Leo Levenson, CFO, PRC and Baker Places, Inc.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
93.914 Hiv Emergency Relief Project Grants $1.63M
14.241 Housing Opportunities for Persons with Aids $1.36M
14.218 Community Development Block Grants/entitlement Grants $71,971
84.126 Rehabilitation Services_vocational Rehabilitation Grants to States $46,636