Finding 1172298 (2024-007)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2026-02-03

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) reported incorrect Assistance Listing numbers for 23 out of 27 programs, impacting compliance and program identification.
  • Impacted Requirements: Noncompliance with 2 CFR 200.510(b) due to inadequate procedures for compiling and reviewing SEFA information.
  • Recommended Follow-Up: Establish a formal SEFA preparation process with a verification checklist, assign responsibility for timely submission, and maintain centralized documentation for Assistance Listing numbers.

Finding Text

Finding 2024-007 – Schedule of Expenditures of Federal Awards (SEFA) – Incorrect CFDA / Assistance Listing Numbers Reporting; Internal Control over Compliance (Significant Deficiency) Name of Federal Agency: U.S. Environmental Protection Agency Federal Program Name: Nonpoint Source Implementation Grants Assistance Listing Numbers: 66.460 Pass-Through Entity: Oregon Department of Environmental Quality Name of Federal Agency: U.S. Department of Commerce – National Oceanic and Atmospheric Administration Federal Program Name: Pacific Coast Salmon Recovery Program Assistance Listing Numbers: 11.438, 15.015, 15.244 Pass-Through Entity: State of Oregon – Oregon Watershed Enhancement Board (OWEB) Name of Federal Agency: U.S. Department of Agriculture Federal Program Name: National Fish and Wildlife FoundationAssistance Listing Numbers: 10.665 Pass-Through Entity: U.S. Forest Service Name of Federal Agency: U.S. Department of Agriculture Federal Program Name: Natural Resources Conservation Service Assistance Listing Numbers: 10.905 Pass-Through Entity: U.S. Forest Service Name of Federal Agency: U.S. Department of the Interior Federal Program Name: Wildlife, Sport Fish and Restoration Program Assistance Listing Numbers: 15.244 Pass-Through Entity: Bureau of Land Management Name of Federal Agency: U.S. Department of the Interior Federal Program Name: Secure Rural Schools and community Self-Determination – Watershed and water-quality improvements Assistance Listing Numbers: 15.234 Pass-Through Entity: Bureau of Land Management Criteria: Under 2 CFR 200.510(b), auditees must prepare a complete and accurate SEFA including correct Assistance Listing (formerly CFDA) numbers, program names, and amounts. This is essential for proper identification of federal programs and determination of major programs. Condition: The SEFA for fiscal year ended June 30, 2024 was provided after asking for the SEFA repeatedly. When finally received, the SEFA contained incorrect Assistance Listing numbers for multiple programs/awards, which could lead to misclassification of federal awards. Context: The SEFA reported $1,381,646 in federal expenditures across 27 programs/grant agreements. Testing revealed that 23 of the 27 grant awards had incorrect Assistance Listing numbers on the SEFA and were not aligned with agreements or program information. The SEFA was finalized, only after significant auditor follow-up. Cause: Management did not have adequate procedures for compiling and reviewing SEFA information, including verification of Assistance Listing numbers against official sources and award documents. Effect or Potential Effect: Incorrect CFDA / Assistance Listing numbers may:  Impair auditor’s ability to properly identify major programs,  Result in noncompliance with Uniform Guidance reporting requirements,  Increase risk of audit findings and questioned costs in future periods. Questioned Cost: None identified Repeat of a Prior-Year Finding: No, Prior- year did not require a Single Audit. Recommendation: We recommend that Partnership for the Umpqua Rivers:  Establish a formal SEFA preparation process, including a checklist for verifying Assistance Listing numbers against award documents and official listings, Assign responsibility for timely SEFA submission, and require supervisory review before providing to auditors.  Maintain documentation supporting CFDA/ Assistance Listing numbers and program details in a centralized grant file. District Response: Partnership for the Umpqua Rivers acknowledges the deficiencies. Corrective Action Plan: ____________ (To be completed by Partnership for the Umpqua Rivers) Planned Implementation Date: ___________ Responsible Person: Partnership for the Umpqua Rivers Finance Manager

Corrective Action Plan

Finding 2024-007 – Schedule of Expenditures of Federal Awards (SEFA) – Incorrect CFDA / Assistance Listing Numbers Reporting; Internal Control over Compliance (Significant Deficiency) Name of Federal Agency: U.S. Environmental Protection Agency Federal Program Name: Nonpoint Source Implementation Grants Assistance Listing Numbers: 66.460 Pass-Through Entity: Oregon Department of Environmental Quality Name of Federal Agency: U.S. Department of Commerce – National Oceanic and Atmospheric Administration Federal Program Name: Pacific Coast Salmon Recovery Program Assistance Listing Numbers: 11.438, 15.015, 15.244 Pass-Through Entity: State of Oregon – Oregon Watershed Enhancement Board (OWEB) Name of Federal Agency: U.S. Department of Agriculture Federal Program Name: National Fish and Wildlife FoundationAssistance Listing Numbers: 10.665 Pass-Through Entity: U.S. Forest Service Name of Federal Agency: U.S. Department of Agriculture Federal Program Name: Natural Resources Conservation Service Assistance Listing Numbers: 10.905 Pass-Through Entity: U.S. Forest Service Name of Federal Agency: U.S. Department of the Interior Federal Program Name: Wildlife, Sport Fish and Restoration Program Assistance Listing Numbers: 15.244 Pass-Through Entity: Bureau of Land Management Name of Federal Agency: U.S. Department of the Interior Federal Program Name: Secure Rural Schools and community Self-Determination – Watershed and water-quality improvements Assistance Listing Numbers: 15.234 Pass-Through Entity: Bureau of Land Management Criteria: Under 2 CFR 200.510(b), auditees must prepare a complete and accurate SEFA including correct Assistance Listing (formerly CFDA) numbers, program names, and amounts. This is essential for proper identification of federal programs and determination of major programs. Condition: The SEFA for fiscal year ended June 30, 2024 was provided after asking for the SEFA repeatedly. When finally received, the SEFA contained incorrect Assistance Listing numbers for multiple programs/awards, which could lead to misclassification of federal awards. Context: The SEFA reported $1,381,646 in federal expenditures across 27 programs/grant agreements. Testing revealed that 23 of the 27 grant awards had incorrect Assistance Listing numbers on the SEFA and were not aligned with agreements or program information. The SEFA was finalized, only after significant auditor follow-up. Cause: Management did not have adequate procedures for compiling and reviewing SEFA information, including verification of Assistance Listing numbers against official sources and award documents. Effect or Potential Effect: Incorrect CFDA / Assistance Listing numbers may:  Impair auditor’s ability to properly identify major programs,  Result in noncompliance with Uniform Guidance reporting requirements,  Increase risk of audit findings and questioned costs in future periods. Questioned Cost: None identified Repeat of a Prior-Year Finding: No, Prior- year did not require a Single Audit. Recommendation: We recommend that Partnership for the Umpqua Rivers:  Establish a formal SEFA preparation process, including a checklist for verifying Assistance Listing numbers against award documents and official listings, Assign responsibility for timely SEFA submission, and require supervisory review before providing to auditors.  Maintain documentation supporting CFDA/ Assistance Listing numbers and program details in a centralized grant file. District Response: Partnership for the Umpqua Rivers acknowledges the deficiencies. Corrective Action Plan: ____________ (To be completed by Partnership for the Umpqua Rivers) Planned Implementation Date: ___________ Responsible Person: Partnership for the Umpqua Rivers Finance Manager

Categories

Reporting

Other Findings in this Audit

  • 1172164 2024-003
    Material Weakness Repeat
  • 1172165 2024-003
    Material Weakness Repeat
  • 1172166 2024-003
    Material Weakness Repeat
  • 1172167 2024-003
    Material Weakness Repeat
  • 1172168 2024-003
    Material Weakness Repeat
  • 1172169 2024-003
    Material Weakness Repeat
  • 1172170 2024-003
    Material Weakness Repeat
  • 1172171 2024-003
    Material Weakness Repeat
  • 1172172 2024-003
    Material Weakness Repeat
  • 1172173 2024-003
    Material Weakness Repeat
  • 1172174 2024-003
    Material Weakness Repeat
  • 1172175 2024-003
    Material Weakness Repeat
  • 1172176 2024-003
    Material Weakness Repeat
  • 1172177 2024-003
    Material Weakness Repeat
  • 1172178 2024-003
    Material Weakness Repeat
  • 1172179 2024-003
    Material Weakness Repeat
  • 1172180 2024-003
    Material Weakness Repeat
  • 1172181 2024-003
    Material Weakness Repeat
  • 1172182 2024-003
    Material Weakness Repeat
  • 1172183 2024-003
    Material Weakness Repeat
  • 1172184 2024-003
    Material Weakness Repeat
  • 1172185 2024-003
    Material Weakness Repeat
  • 1172186 2024-003
    Material Weakness Repeat
  • 1172187 2024-003
    Material Weakness Repeat
  • 1172188 2024-003
    Material Weakness Repeat
  • 1172189 2024-003
    Material Weakness Repeat
  • 1172190 2024-003
    Material Weakness Repeat
  • 1172191 2024-004
    Material Weakness Repeat
  • 1172192 2024-004
    Material Weakness Repeat
  • 1172193 2024-004
    Material Weakness Repeat
  • 1172194 2024-004
    Material Weakness Repeat
  • 1172195 2024-004
    Material Weakness Repeat
  • 1172196 2024-004
    Material Weakness Repeat
  • 1172197 2024-004
    Material Weakness Repeat
  • 1172198 2024-004
    Material Weakness Repeat
  • 1172199 2024-004
    Material Weakness Repeat
  • 1172200 2024-004
    Material Weakness Repeat
  • 1172201 2024-004
    Material Weakness Repeat
  • 1172202 2024-004
    Material Weakness Repeat
  • 1172203 2024-004
    Material Weakness Repeat
  • 1172204 2024-004
    Material Weakness Repeat
  • 1172205 2024-004
    Material Weakness Repeat
  • 1172206 2024-004
    Material Weakness Repeat
  • 1172207 2024-004
    Material Weakness Repeat
  • 1172208 2024-004
    Material Weakness Repeat
  • 1172209 2024-004
    Material Weakness Repeat
  • 1172210 2024-004
    Material Weakness Repeat
  • 1172211 2024-004
    Material Weakness Repeat
  • 1172212 2024-004
    Material Weakness Repeat
  • 1172213 2024-004
    Material Weakness Repeat
  • 1172214 2024-004
    Material Weakness Repeat
  • 1172215 2024-004
    Material Weakness Repeat
  • 1172216 2024-004
    Material Weakness Repeat
  • 1172217 2024-004
    Material Weakness Repeat
  • 1172218 2024-005
    Material Weakness Repeat
  • 1172219 2024-005
    Material Weakness Repeat
  • 1172220 2024-005
    Material Weakness Repeat
  • 1172221 2024-005
    Material Weakness Repeat
  • 1172222 2024-005
    Material Weakness Repeat
  • 1172223 2024-005
    Material Weakness Repeat
  • 1172224 2024-005
    Material Weakness Repeat
  • 1172225 2024-005
    Material Weakness Repeat
  • 1172226 2024-005
    Material Weakness Repeat
  • 1172227 2024-005
    Material Weakness Repeat
  • 1172228 2024-005
    Material Weakness Repeat
  • 1172229 2024-005
    Material Weakness Repeat
  • 1172230 2024-005
    Material Weakness Repeat
  • 1172231 2024-005
    Material Weakness Repeat
  • 1172232 2024-005
    Material Weakness Repeat
  • 1172233 2024-005
    Material Weakness Repeat
  • 1172234 2024-005
    Material Weakness Repeat
  • 1172235 2024-005
    Material Weakness Repeat
  • 1172236 2024-005
    Material Weakness Repeat
  • 1172237 2024-005
    Material Weakness Repeat
  • 1172238 2024-005
    Material Weakness Repeat
  • 1172239 2024-005
    Material Weakness Repeat
  • 1172240 2024-005
    Material Weakness Repeat
  • 1172241 2024-005
    Material Weakness Repeat
  • 1172242 2024-005
    Material Weakness Repeat
  • 1172243 2024-005
    Material Weakness Repeat
  • 1172244 2024-005
    Material Weakness Repeat
  • 1172245 2024-006
    Material Weakness Repeat
  • 1172246 2024-006
    Material Weakness Repeat
  • 1172247 2024-006
    Material Weakness Repeat
  • 1172248 2024-006
    Material Weakness Repeat
  • 1172249 2024-006
    Material Weakness Repeat
  • 1172250 2024-006
    Material Weakness Repeat
  • 1172251 2024-006
    Material Weakness Repeat
  • 1172252 2024-006
    Material Weakness Repeat
  • 1172253 2024-006
    Material Weakness Repeat
  • 1172254 2024-006
    Material Weakness Repeat
  • 1172255 2024-006
    Material Weakness Repeat
  • 1172256 2024-006
    Material Weakness Repeat
  • 1172257 2024-006
    Material Weakness Repeat
  • 1172258 2024-006
    Material Weakness Repeat
  • 1172259 2024-006
    Material Weakness Repeat
  • 1172260 2024-006
    Material Weakness Repeat
  • 1172261 2024-006
    Material Weakness Repeat
  • 1172262 2024-006
    Material Weakness Repeat
  • 1172263 2024-006
    Material Weakness Repeat
  • 1172264 2024-006
    Material Weakness Repeat
  • 1172265 2024-006
    Material Weakness Repeat
  • 1172266 2024-006
    Material Weakness Repeat
  • 1172267 2024-006
    Material Weakness Repeat
  • 1172268 2024-006
    Material Weakness Repeat
  • 1172269 2024-006
    Material Weakness Repeat
  • 1172270 2024-006
    Material Weakness Repeat
  • 1172271 2024-006
    Material Weakness Repeat
  • 1172272 2024-007
    Material Weakness Repeat
  • 1172273 2024-007
    Material Weakness Repeat
  • 1172274 2024-007
    Material Weakness Repeat
  • 1172275 2024-007
    Material Weakness Repeat
  • 1172276 2024-007
    Material Weakness Repeat
  • 1172277 2024-007
    Material Weakness Repeat
  • 1172278 2024-007
    Material Weakness Repeat
  • 1172279 2024-007
    Material Weakness Repeat
  • 1172280 2024-007
    Material Weakness Repeat
  • 1172281 2024-007
    Material Weakness Repeat
  • 1172282 2024-007
    Material Weakness Repeat
  • 1172283 2024-007
    Material Weakness Repeat
  • 1172284 2024-007
    Material Weakness Repeat
  • 1172285 2024-007
    Material Weakness Repeat
  • 1172286 2024-007
    Material Weakness Repeat
  • 1172287 2024-007
    Material Weakness Repeat
  • 1172288 2024-007
    Material Weakness Repeat
  • 1172289 2024-007
    Material Weakness Repeat
  • 1172290 2024-007
    Material Weakness Repeat
  • 1172291 2024-007
    Material Weakness Repeat
  • 1172292 2024-007
    Material Weakness Repeat
  • 1172293 2024-007
    Material Weakness Repeat
  • 1172294 2024-007
    Material Weakness Repeat
  • 1172295 2024-007
    Material Weakness Repeat
  • 1172296 2024-007
    Material Weakness Repeat
  • 1172297 2024-007
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
11.438 PACIFIC COAST SALMON RECOVERY PACIFIC SALMON TREATY PROGRAM $243,309
15.244 AQUATICS RESOURCES MANAGEMENT $74,760
15.234 SECURE RURAL SCHOOLS AND COMMUNITY SELF-DETERMINATION $16,287
66.460 NONPOINT SOURCE IMPLEMENTATION GRANTS $8,905
10.665 SCHOOLS AND ROADS - GRANTS TO STATES $7,132
15.015 GOOD NEIGHBOR AUTHORITY $3,062