Finding 1084302 (2023-002)

Material Weakness
Requirement
B
Questioned Costs
$1
Year
2023
Accepted
2024-11-14

AI Summary

  • Core Issue: The Organization has a material weakness in internal controls over compliance, leading to inaccurate payroll expense reporting for federal grants.
  • Impacted Requirements: Noncompliance with Uniform Guidance section 200.430(i) regarding documentation and allocation of personnel expenses.
  • Recommended Follow-up: Implement stronger internal controls to ensure accurate tracking and reporting of payroll expenses for federal grants.

Finding Text

2023-002 – Allowable Costs/Cost Principles Material Weakness in Internal Control over Compliance and Instance of Material Noncompliance Criteria: Uniform Guidance section 200.430(i) indicates that the standards for documentation of personnel expenses are such that (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 and (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities. Condition: The Organization maintains a spreadsheet outside of the accounting software to allocate salaries and wages, benefits, and payroll taxes to each federal cost center/grant. Entry into the spreadsheet is done manually and is based on actual time and effort for each pay period by employee. Results of the spreadsheet are used to record payroll allocation journal entries into the accounting system. This spreadsheet was updated at the beginning of 2023. In updating the spreadsheet, there was an error in the way the payroll tax expense was being manually entered. This resulted in certain payroll tax expenses being included in both gross wages expense and taxes and benefit expense. This resulted in federal grant requests for reimbursement being overstated and the excess expense being unallowable. The Organization had insufficient controls over the federal grant compliance process to detect and correct errors in the requests for reimbursement before submission. Context: The Organization failed to follow required federal allowable cost/cost principles across multiple federal programs. Cause: Management did not maintain internal controls sufficient to prevent or detect material noncompliance with federal grant awards. Repeat Finding: No Effect: The Organization was not in compliance with allowable costs/cost principles in accordance with the Uniform Guidance. This finding impacts all of the Organization’s federal awards. Known Questioned Costs: See table below

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 507844 2023-002
    Material Weakness
  • 507845 2023-002
    Material Weakness
  • 507846 2023-002
    Material Weakness
  • 507847 2023-002
    Material Weakness
  • 507848 2023-002
    Material Weakness
  • 507849 2023-002
    Material Weakness
  • 507850 2023-002
    Material Weakness
  • 507851 2023-002
    Material Weakness
  • 507852 2023-002
    Material Weakness
  • 507853 2023-002
    Material Weakness
  • 507854 2023-002
    Material Weakness
  • 507855 2023-002
    Material Weakness
  • 507856 2023-002
    Material Weakness
  • 507857 2023-002
    Material Weakness
  • 507858 2023-002
    Material Weakness
  • 507859 2023-002
    Material Weakness
  • 507860 2023-002
    Material Weakness
  • 507861 2023-002
    Material Weakness
  • 507862 2023-002
    Material Weakness
  • 1084286 2023-002
    Material Weakness
  • 1084287 2023-002
    Material Weakness
  • 1084288 2023-002
    Material Weakness
  • 1084289 2023-002
    Material Weakness
  • 1084290 2023-002
    Material Weakness
  • 1084291 2023-002
    Material Weakness
  • 1084292 2023-002
    Material Weakness
  • 1084293 2023-002
    Material Weakness
  • 1084294 2023-002
    Material Weakness
  • 1084295 2023-002
    Material Weakness
  • 1084296 2023-002
    Material Weakness
  • 1084297 2023-002
    Material Weakness
  • 1084298 2023-002
    Material Weakness
  • 1084299 2023-002
    Material Weakness
  • 1084300 2023-002
    Material Weakness
  • 1084301 2023-002
    Material Weakness
  • 1084303 2023-002
    Material Weakness
  • 1084304 2023-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.48M
93.568 Low-Income Home Energy Assistance $798,093
10.569 Emergency Food Assistance Program (food Commodities) $523,541
16.575 Crime Victim Assistance $483,551
10.565 Commodity Supplemental Food Program $278,700
93.276 Drug-Free Communities Support Program Grants $127,657
10.568 Emergency Food Assistance Program (administrative Costs) $118,592
93.959 Block Grants for Prevention and Treatment of Substance Abuse $111,800
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $110,237
14.267 Continuum of Care Program $101,187
93.569 Community Services Block Grant $95,719
93.788 Opioid Str $91,526
14.231 Emergency Solutions Grant Program $79,085
93.497 Family Violence Prevention and Services/ Sexual Assault/rape Crisis Services and Supports $60,014
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $43,123
16.588 Violence Against Women Formula Grants $14,675
14.276 Youth Homelessness Demonstration Program $13,475
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $11,070
10.182 Pandemic Relief Activities: Local Food Purchase Agreements with States, Tribes, and Local Governments $7,916
93.011 National Organizations for State and Local Officials $6,764
10.187 The Emergency Food Assistance Program (tefap) Commodity Credit Corporation Eligible Recipient Funds $792