Finding 497937 (2023-006)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2023
Accepted
2024-09-24

AI Summary

  • Core Issue: The organization lacks proper controls to ensure that only allowable payroll costs are charged to federal grants, leading to repeated compliance findings.
  • Impacted Requirements: Costs billed to the grant were based on estimates rather than actual expenses, resulting in questioned costs of approximately $40,400.
  • Recommended Follow-Up: Implement comprehensive payroll controls, including independent reviews and accurate documentation, to ensure costs align with grant budgets and actual expenditures.

Finding Text

#2023-006 – Major Federal Award Finding – Allowable Costs – Payroll Nature of Finding: Compliance Finding – Allowable Costs and Material Weakness in Internal Controls Over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: A non-federal entity may only charge allowable costs to federal programs. The Organization did not have controls in place to verify that costs were being charged to the award were based upon actual costs incurred and consistent with those provided in the grant budget. Questioned Costs: Approximately $40,400 Identification of How Questioned Costs Were Computed: Payroll expenditures charged to the grant during the year were traced in total to the year-to-date payroll reports. Questioned costs represent the error identified in the testing of the population of payroll expenditures of the major program. Cause/Context: There are not proper controls in place to review payroll costs monthly to ensure costs were charge to the grant appropriately. This resulted in three instances of noncompliance: • Amounts were billed to the grant using estimated monthly wages rather than actual wages incurred. • The employee portion of payroll taxes were billed to the grant twice – once as part of gross wages and again as fringe benefits and added to employer payroll tax costs. • Costs were charged to the grant for one employee who was not listed in the grant budget as an allowable cost. Effect: An overstatement of expenditures for the grant was reported and submitted for reimbursement. Recommendation: We recommend that a full-range of controls over payroll and payroll related costs be implemented. The Organization should devote the resources necessary to ensure that such costs are of direct benefit to the program, are reviewed, approved, documented, and that the accounting and reporting process is accurate. Further, controls over grant billings should be established to ensure expenditures represent actual costs incurred. All control activities, including independent review should be documented and evidence of review and approval be maintained. Views of Responsible Officials and Planned Corrective Actions: MARR will retain a CPA consultant to implement a full-range of control over costs charged to federal programs. MARR’s primary decision-making authority regarding such controls shall be placed with the MARR’s president. MARR’s protocol shall ensure that such costs are the direct benefit to the program, are reviewed, approved, documented and ensure the accounting and reporting process be accurate. Further, controls over grant billings will be established to ensure expenditures represent actual costs incurred. All control activities, including independent review, should be documented and evidence of review and approval will be maintained.

Corrective Action Plan

Planned Corrective Actions: MARR will retain a CPA consultant to implement a full-range of control over costs charged to federal programs. MARR’s protocol shall ensure that such costs are the direct benefit to the program, are reviewed, approved, documented and ensure the accounting and reporting process be accurate. Further, controls over grant billings will be established to ensure expenditures represent actual costs incurred. All control activities, including independent review, should be documented and evidence of review and approval will be maintained.

Categories

Questioned Costs Allowable Costs / Cost Principles Cash Management Material Weakness Reporting Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 497935 2023-004
    Material Weakness Repeat
  • 497936 2023-005
    Material Weakness Repeat
  • 497938 2023-007
    Material Weakness Repeat
  • 497939 2023-008
    Material Weakness Repeat
  • 497940 2023-009
    Material Weakness Repeat
  • 497941 2023-010
    Material Weakness Repeat
  • 497942 2023-004
    Material Weakness Repeat
  • 497943 2023-005
    Material Weakness Repeat
  • 497944 2023-006
    Material Weakness Repeat
  • 497945 2023-007
    Material Weakness Repeat
  • 497946 2023-008
    Material Weakness Repeat
  • 497947 2023-009
    Material Weakness Repeat
  • 497948 2023-010
    Material Weakness Repeat
  • 1074377 2023-004
    Material Weakness Repeat
  • 1074378 2023-005
    Material Weakness Repeat
  • 1074379 2023-006
    Material Weakness Repeat
  • 1074380 2023-007
    Material Weakness Repeat
  • 1074381 2023-008
    Material Weakness Repeat
  • 1074382 2023-009
    Material Weakness Repeat
  • 1074383 2023-010
    Material Weakness Repeat
  • 1074384 2023-004
    Material Weakness Repeat
  • 1074385 2023-005
    Material Weakness Repeat
  • 1074386 2023-006
    Material Weakness Repeat
  • 1074387 2023-007
    Material Weakness Repeat
  • 1074388 2023-008
    Material Weakness Repeat
  • 1074389 2023-009
    Material Weakness Repeat
  • 1074390 2023-010
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.788 Opioid Str $117,344
93.959 Block Grants for Prevention and Treatment of Substance Abuse $35,139