Finding 1229813 (2024-003)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2026-09-15
Audit: 411097
Organization: Coquille Watershed Association (OR)
Auditor: JONES & ROTH PC

AI Summary

  • Core Issue: There is a significant deficiency in internal controls over compliance related to employee pay rates, lacking proper documentation and approval processes.
  • Impacted Requirements: Federal award terms and Uniform Guidance require that costs charged to federal awards be adequately supported and authorized, including documented approval of salary rates.
  • Recommended Follow-Up: Implement formal payroll rate documentation and approval controls, including maintaining records of pay rate approvals, restricting access to the master rate spreadsheet, and ensuring independent reviews of changes.

Finding Text

Federal Award Program: U.S. Department of Commerce Pacific Coast Salmon Recovery - Pacific Salmon Treaty Program (Assistance Listing #11.438) Type of Finding: Significant deficiency in internal control over compliance Compliance Requirement: Allowable costs Criteria: Federal award terms and Uniform Guidance cost principles require costs charged to federal awards to be adequately supported and authorized. In addition, effective internal control over compliance should include documented approval of employee salary/wage rates and subsequent rate changes, such as through a pay rate authorization form or equivalent documentation, and independent review or approval of changes to pay rates before those rates are used to charge payroll costs to federal awards. Condition: Audit procedures identified that the Organization maintains employee salary and wage rates in a master rate spreadsheet; however, it does not maintain documentation to support approved pay rates. Evidence of approval for initial pay rates and subsequent rate changes was not retained. In addition, the master spreadsheet serves as the sole source of pay rate information and may be modified without documented oversight. Cause: The Organization has not designed and implemented a formal personnel action or pay rate approval process that requires documented authorization of initial pay rates and subsequent rate changes. The Organization relies on an internally maintained, editable spreadsheet as the primary support for pay rate information, without sufficient documented independent review, approval, or restriction over changes. Effect and Context: Unauthorized, unsupported, or incorrect pay rates could be entered into the payroll system and charged to federal awards without timely prevention or detection. If payroll or personnel compensation costs are charged to a major federal program, this deficiency could result in unallowable or unsupported payroll costs being charged to the program. Our sample size was 40 payroll trans ctions, and all selections in our sample used personnel pay rates for which evidence of approval could not be provided. Our sample was not statistically valid. Repeat finding: No. Auditor’s recommendation: We recommend that the Organization establish and implement formal payroll rate documentation and approval controls. At a minimum, management should maintain documentation to support all initial salary/wage rates and subsequent rate changes; require documented approval by an appropriate supervisor, executive, or governing body designee before pay rate changes are entered into the payroll system; restrict access to the master rate spreadsheet and maintain version history or change logs, and require independent review of all pay rate changes before payroll is processed. Management’s response: Management is in agreement with the finding. See corrective action plan.

Corrective Action Plan

Recommendation: We recommend that the Organization establish and implement formal payroll rate documentation and approval controls. At a minimum, management should maintain documentation to support all initial salary/wage rates and subsequent rate changes; require documented approval by an appropriate supervisor, executive, or governing body designee before pay rate changes are entered into the payroll system; restrict access to the master rate spreadsheet and maintain version history or change logs, and require independent review of all pay rate changes before payroll is processed. Corrective action planned: At the end of 2025, the Organization began providing letters from the director to staff when any pay rate changes occurred. The board will provide such a letter to the director when the director’s rate changes. The Organization already had and continues to provide offer letters upon hiring staff that includes the initial rate. Payroll is now run by the Operations Manager and sent for approval by the Executive Director. Pay rate is reviewed as part of the submission process. Persons responsible for corrective action: Justin Queen, Executive Director Date by which the corrective action will be completed: Complete

Categories

Allowable Costs / Cost Principles Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1229805 2024-003
    Material Weakness Repeat
  • 1229806 2024-003
    Material Weakness Repeat
  • 1229807 2024-003
    Material Weakness Repeat
  • 1229808 2024-003
    Material Weakness Repeat
  • 1229809 2024-003
    Material Weakness Repeat
  • 1229810 2024-003
    Material Weakness Repeat
  • 1229811 2024-003
    Material Weakness Repeat
  • 1229812 2024-003
    Material Weakness Repeat
  • 1229814 2024-004
    Material Weakness Repeat
  • 1229815 2024-004
    Material Weakness Repeat
  • 1229816 2024-004
    Material Weakness Repeat
  • 1229817 2024-004
    Material Weakness Repeat
  • 1229818 2024-004
    Material Weakness Repeat
  • 1229819 2024-004
    Material Weakness Repeat
  • 1229820 2024-004
    Material Weakness Repeat
  • 1229821 2024-004
    Material Weakness Repeat
  • 1229822 2024-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $503,415
15.631 PARTNERS FOR FISH AND WILDLIFE $43,760
15.228 BLM FUELS MANAGEMENT AND COMMUNITY FIRE ASSISTANCE PROGRAM ACTIVITIES $15,357
10.715 INFRASTRUCTURE INVESTMENT AND JOBS ACT COLLABORATIVE FOREST LANDSCAPE RESTORATION PROGRAM $9,604
15.244 AQUATICS RESOURCES MANAGEMENT $7,446
15.630 COASTAL $5,881
15.245 PLANT CONSERVATION AND RESTORATION MANAGEMENT $5,405
15.234 SECURE RURAL SCHOOLS AND COMMUNITY SELF-DETERMINATION $3,045
15.015 GOOD NEIGHBOR AUTHORITY $806
10.665 SCHOOLS AND ROADS - GRANTS TO STATES $500
11.463 HABITAT CONSERVATION $459
15.614 COASTAL WETLANDS PLANNING, PROTECTION AND RESTORATION $44
11.438 PACIFIC SALMON TREATY PROGRAM $23