Finding 605660 (2022-002)

Material Weakness
Requirement
A
Questioned Costs
$1
Year
2022
Accepted
2023-05-01

AI Summary

  • Core Issue: Payroll transactions were incorrectly processed due to insufficient internal controls, leading to discrepancies between timesheets and general ledger entries.
  • Impacted Requirements: Compliance with Title 2 U.S. Code of Federal Regulations Part 200, which mandates that charges to federal awards must be for allowable costs supported by proper documentation.
  • Recommended Follow-Up: Implement effective controls over payroll procedures, including a review process to ensure accurate time allocation from timesheets to the general ledger.

Finding Text

Federal program information: Funding agency: U.S. Department of Health and Human Services Title: Low-Income Home Energy Assistance CFDA number: 93.568 Award number: F19-53101-410, F19-53101-428, F21-32606-069, F21-32607-069, F21-5310C-410, F21-63260A-069, F22-32606-069 Award period: 10/1/2020 ? 9/30/2024 Funding agency: U.S. Department of Health and Human Services Title: Community Services Block Grant CFDA number: 93.569 Award number: F20-3210C-009, F21-32101-009, F22-32101-009 Award period: 1/20/2020 ? 9/30/2023 Criteria: The CAC must establish internal control procedures over compliance with provisions of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), that require, among other things, that direct charges to federal awards be for allowable costs. To be an allowable cost, charges must be supported by appropriate documentation and be properly approved. The specific requirements for allowable activities are unique to each Federal Program and are found in the laws, regulations, and the provisions of each contract or grant agreement pertaining to the federal program. Condition: Results of Tests of Internal Controls Over Compliance and Compliance ? 93.568 ? We selected a sample of 25 transactions to test controls over compliance and compliance of payroll disbursement costs charged to the major program. We identified 3 instances of the 25 payroll transactions where the employee's timesheet was reviewed by the supervisor, but the contract charged in the general ledger did not agree to the actual hour allocation noted on the employee?s timesheet and personnel action notice. The errors noted resulted in over charges to the program of $775. The total sample population of the 25 payroll items tested was $28,187. 93.569 ? We selected a sample of 25 transactions to test controls over compliance and compliance of payroll disbursement costs charged to the major program. We identified 1 instance of the 25 payroll transactions where the employee's timesheet was reviewed by the supervisor, but the contract charged in the general ledger did not agree to the actual hour allocation noted on the employee?s timesheet and personnel action notice. The errors noted resulted in an under charge to the program of $165. The total sample population of the 25 payroll items tested was $28,696. Cause: The primary factor that contributed to the deficiencies was the lack of sufficient controls implemented to appropriately review and monitor payroll activity and ensure amounts were properly recorded in the general ledger. Effect: Payroll transactions were being processed incorrectly. Context: Management did not implement effective internal controls over payroll disbursements. Questioned costs: 93.568 ? Known questioned costs were $775 of over charges. 93.569 ? Known questioned costs were $165 of under charges. Repeat Finding: This is not a repeat finding. Recommendation: In order to ensure payroll transactions are properly reviewed, approved, and supporting documentation maintained, we recommend the CAC ensure controls over payroll procedures are operating effectively ? this includes implementing a review process over employee time allocation from timesheets to the general ledger. Views of Responsible Officials: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 29210 2022-002
    Material Weakness
  • 29211 2022-002
    Material Weakness
  • 29212 2022-002
    Material Weakness
  • 29213 2022-002
    Material Weakness
  • 29214 2022-002
    Material Weakness
  • 29215 2022-002
    Material Weakness
  • 29216 2022-002
    Material Weakness
  • 29217 2022-002
    Material Weakness
  • 29218 2022-002
    Material Weakness
  • 29219 2022-002
    Material Weakness
  • 605652 2022-002
    Material Weakness
  • 605653 2022-002
    Material Weakness
  • 605654 2022-002
    Material Weakness
  • 605655 2022-002
    Material Weakness
  • 605656 2022-002
    Material Weakness
  • 605657 2022-002
    Material Weakness
  • 605658 2022-002
    Material Weakness
  • 605659 2022-002
    Material Weakness
  • 605661 2022-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.415 Rural Rental Housing Loans $5.51M
14.195 Section 8 Housing Assistance Payments Program $457,304
10.569 Emergency Food Assistance Program (food Commodities) $390,654
21.023 Emergency Rental Assistance Program $352,033
14.U01 Mark-To-Market Program - Loan (mortgage Restructuring Loan) $284,736
93.569 Community Services Block Grant $240,248
14.U02 Mark-To-Market Program - Loan (contingent Repayment Loan) $168,343
81.999 Bonneville Power Administration Weatherization $136,420
14.231 Emergency Solutions Grant Program $86,444
93.669 Child Abuse and Neglect State Grants $74,855
16.575 Crime Victim Assistance $44,649
21.027 Coronavirus State and Local Fiscal Recovery Funds $43,524
16.034 Coronavirus Emergency Supplemental Funding Program $38,470
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $22,610
81.042 Weatherization Assistance for Low-Income Persons $21,386
93.497 Family Violence Prevention and Services/ Sexual Assault/rape Crisis Services and Supports $11,059
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $4,836
93.568 Low-Income Home Energy Assistance $1,552