Audit 308829

FY End
2023-06-30
Total Expended
$116.84M
Findings
12
Programs
83
Organization: Clackamas County, Oregon (OR)
Year: 2023 Accepted: 2024-06-13
Auditor: Moss Adams LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
400798 2023-002 Significant Deficiency - L
400799 2023-002 Significant Deficiency - L
400800 2023-002 Significant Deficiency - L
400801 2023-002 Significant Deficiency - L
400802 2023-002 Significant Deficiency - L
400803 2023-002 Significant Deficiency - L
977240 2023-002 Significant Deficiency - L
977241 2023-002 Significant Deficiency - L
977242 2023-002 Significant Deficiency - L
977243 2023-002 Significant Deficiency - L
977244 2023-002 Significant Deficiency - L
977245 2023-002 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
93.527 Affordable Care Act (aca) Grants for New and Expanded Services Under the Health Center Program $30.52M Yes 1
14.239 Home Investment Partnerships Program $18.95M - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $10.42M Yes 0
93.224 Consolidated Health Centers (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $4.88M Yes 1
20.224 Federal Lands Access Program $3.13M Yes 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $1.40M - 0
14.267 Continuum of Care Program $1.29M - 0
93.563 Child Support Enforcement $1.29M - 0
14.218 Community Development Block Grants/entitlement Grants $1.13M - 0
93.967 Cdc's Collaboration with Academia to Strengthen Public Health $1.09M - 0
93.498 Provider Relief Fund $1.01M - 0
93.958 Block Grants for Community Mental Health Services $863,008 - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $803,098 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $673,153 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $567,185 - 0
93.268 Immunization Cooperative Agreements $536,853 - 0
16.575 Crime Victim Assistance $459,536 - 0
93.568 Low-Income Home Energy Assistance $441,505 - 0
14.256 Neighborhood Stabilizations Program $428,223 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $419,482 - 0
97.012 Boating Safety Financial Assistance $351,528 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $249,672 - 0
93.069 Public Health Emergency Preparedness $238,539 - 0
16.585 Drug Court Discretionary Grant Program $224,257 - 0
20.205 Highway Planning and Construction $219,091 Yes 0
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $186,784 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $186,061 - 0
93.499 Low Income Household Water Assistance Program $172,959 - 0
97.042 Emergency Management Performance Grants $166,327 - 0
93.558 Temporary Assistance for Needy Families $157,403 - 0
93.667 Social Services Block Grant $148,408 - 0
93.788 Opioid Str $138,424 - 0
93.053 Nutrition Services Incentive Program $137,687 - 0
95.007 Research and Data Analysis $129,129 - 0
15.605 Sport Fish Restoration Program $121,956 - 0
20.509 Formula Grants for Rural Areas and Tribal Transit Program $116,000 - 0
94.016 Senior Companion Program $111,560 - 0
97.024 Emergency Food and Shelter National Board Program $96,242 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $93,676 - 0
93.940 Hiv Prevention Activities_health Department Based $87,056 - 0
93.994 Maternal and Child Health Services Block Grant to the States $80,977 - 0
16.842 Opioid Affected Youth Initiative $80,301 - 0
93.434 Every Student Succeeds Act/preschool Development Grants $77,699 - 0
20.507 Federal Transit_formula Grants $76,625 - 0
93.556 Promoting Safe and Stable Families $71,092 - 0
17.805 Homeless Veterans Reintegration Project $69,123 - 0
94.002 Retired and Senior Volunteer Program $68,673 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $63,728 - 0
81.042 Weatherization Assistance for Low-Income Persons $63,036 - 0
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $60,643 - 0
66.468 Capitalization Grants for Drinking Water State Revolving Funds $56,752 - 0
66.432 State Public Water System Supervision $56,752 - 0
10.447 The Rural Development (rd) Multi-Family Housing Revitalization Demonstration Program (mpr) $50,000 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $44,539 - 0
17.259 Wia Youth Activities $43,000 - 0
10.664 Cooperative Forestry Assistance $34,582 - 0
93.569 Community Services Block Grant $34,512 - 0
93.324 State Health Insurance Assistance Program $29,500 - 0
94.017 Senior Demonstration Program $29,009 - 0
20.218 National Motor Carrier Safety $27,975 - 0
16.021 Justice Systems Response to Families $26,493 - 0
97.046 Fire Management Assistance Grant $21,589 - 0
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $19,534 - 0
10.665 Schools and Roads - Grants to States $19,152 - 0
81.U01 Low-Income Energy Efficiency Program (liee) $18,158 - 0
16.922 Equitable Sharing Program $17,408 - 0
93.048 Special Programs for the Aging_title Iv_and Title Ii_discretionary Projects $15,800 - 0
20.616 National Priority Safety Programs $14,573 - 0
20.600 State and Community Highway Safety $13,142 - 0
93.136 Injury Prevention and Control Research and State and Community Based Programs $12,584 - 0
39.003 Donation of Federal Surplus Personal Property $11,311 - 0
14.231 Emergency Solutions Grant Program $10,918 - 0
97.067 Homeland Security Grant Program $7,200 - 0
93.658 Foster Care_title IV-E $6,415 - 0
93.071 Medicare Enrollment Assistance Program $6,301 - 0
93.526 Affordable Care Act (aca) Grants for Capital Development in Health Centers $5,817 - 0
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $4,182 - 0
93.103 Food and Drug Administration_research $3,814 - 0
16.812 Second Chance Act Reentry Initiative $2,955 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $2,866 - 0
15.616 Clean Vessel Act Program $1,350 - 0
97.039 Hazard Mitigation Grant $854 - 0
21.023 Emergency Rental Assistance Program $-2,523 Yes 0

Contacts

Name Title Type
NVWKAVB8JND6 Joseph Rosevear Auditee
5037425429 Ashley Osten Auditor
No contacts on file

Notes to SEFA

Title: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES Accounting Policies: The Schedule of Expenditures of Federal Awards (the Schedule) is presented using the modified accrual basis of accounting, which is described in Note 1 to the basic financial statements of Clackamas County, Oregon (the County). Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) wherein certain types of expenses are not allowable or are limited as to reimbursement. The Pass through entity identifying numbers are presented where applicable. De Minimis Rate Used: N Rate Explanation: During the fiscal year ended, June 30, 2023, the County did not elect to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The Schedule of Expenditures of Federal Awards (the Schedule) is presented using the modified accrual basis of accounting, which is described in Note 1 to the basic financial statements of Clackamas County, Oregon (the County). Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) wherein certain types of expenses are not allowable or are limited as to reimbursement. The pass-through entity identifying numbers are presented where applicable.
Title: ELECTION OF DE MINIMIS INDIRECT COST RATE Accounting Policies: The Schedule of Expenditures of Federal Awards (the Schedule) is presented using the modified accrual basis of accounting, which is described in Note 1 to the basic financial statements of Clackamas County, Oregon (the County). Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) wherein certain types of expenses are not allowable or are limited as to reimbursement. The Pass through entity identifying numbers are presented where applicable. De Minimis Rate Used: N Rate Explanation: During the fiscal year ended, June 30, 2023, the County did not elect to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. During the fiscal year ended, June 30, 2023, the County did not elect to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance.
Title: BASIS OF PRESENTATION Accounting Policies: The Schedule of Expenditures of Federal Awards (the Schedule) is presented using the modified accrual basis of accounting, which is described in Note 1 to the basic financial statements of Clackamas County, Oregon (the County). Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) wherein certain types of expenses are not allowable or are limited as to reimbursement. The Pass through entity identifying numbers are presented where applicable. De Minimis Rate Used: N Rate Explanation: During the fiscal year ended, June 30, 2023, the County did not elect to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The Schedule presents the activity of all federally-funded programs of the County, except for the Housing Authority of Clackamas County (HACC) and the Workforce Investment Council of Clackamas County, Inc. (dba Clackamas Workforce Partnership), which issue separate reports. The reporting entity is defined in Note 1 to the County's basic financial statements. The information in the Schedule is presented in accordance with the requirements of the Uniform Guidance. Because the Schedule presents only a selected portion of the operations of the County, it is not intended to and does not present the financial position, changes in financial position, or the cash flows of the County.
Title: REVOLVING LOAN PROGRAMS Accounting Policies: The Schedule of Expenditures of Federal Awards (the Schedule) is presented using the modified accrual basis of accounting, which is described in Note 1 to the basic financial statements of Clackamas County, Oregon (the County). Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) wherein certain types of expenses are not allowable or are limited as to reimbursement. The Pass through entity identifying numbers are presented where applicable. De Minimis Rate Used: N Rate Explanation: During the fiscal year ended, June 30, 2023, the County did not elect to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The County makes loans to developers for the construction of low-income housing units. The seed money for these loans used to establish the program initially was provided through Federal funds under the Rural Development Multi-Family Housing Revitalization Demonstration Program (ALN #10.447), Community Development Block Grants/Entitlement Grants (ALN #14.218), HOME Investment Partnerships Program (ALN #14.239), and Neighborhood Stabilization Program (ALN #14.256). The County's responsibility over these loans is to ensure that a specified percentage of the total rental units are rented to low-income individuals, and the ongoind compliance requirements related to the accumulated loan balances. The outstanding loan balances as of June 30, 2023, consists of: See the Notes to the SEFA for chart/table.

Finding Details

FINDING 2023-002 - Reporting - Significant Deficiency in Internal Controls over Compliance See the Notes to the SEFA for chart/table. Criteria or specific requirement: As a condition of the award, the County is required to submit a Federal Financial Report (FFR) annually. Condition: During our testing, we were provided with documentation that indicated the County did not file FFR by the due date specified in the award document. Context: Of the 5 reports available for testing, we randomly selected three FFRs filed during fiscal year 2023 noting all were filed untimely. Effect: The reports were not filed by the due date specified in the award document. Cause: The County does not have an effective control in place to monitor reporting timelines. Repeat funding: No Recommendation: We recommend the County work to establish an internal tracking system to memorialize reporting deadlines and track the submission of required reports under the program. Views of responsible officials: Management agrees with the finding and auditor recommendation.
FINDING 2023-002 - Reporting - Significant Deficiency in Internal Controls over Compliance See the Notes to the SEFA for chart/table. Criteria or specific requirement: As a condition of the award, the County is required to submit a Federal Financial Report (FFR) annually. Condition: During our testing, we were provided with documentation that indicated the County did not file FFR by the due date specified in the award document. Context: Of the 5 reports available for testing, we randomly selected three FFRs filed during fiscal year 2023 noting all were filed untimely. Effect: The reports were not filed by the due date specified in the award document. Cause: The County does not have an effective control in place to monitor reporting timelines. Repeat funding: No Recommendation: We recommend the County work to establish an internal tracking system to memorialize reporting deadlines and track the submission of required reports under the program. Views of responsible officials: Management agrees with the finding and auditor recommendation.
FINDING 2023-002 - Reporting - Significant Deficiency in Internal Controls over Compliance See the Notes to the SEFA for chart/table. Criteria or specific requirement: As a condition of the award, the County is required to submit a Federal Financial Report (FFR) annually. Condition: During our testing, we were provided with documentation that indicated the County did not file FFR by the due date specified in the award document. Context: Of the 5 reports available for testing, we randomly selected three FFRs filed during fiscal year 2023 noting all were filed untimely. Effect: The reports were not filed by the due date specified in the award document. Cause: The County does not have an effective control in place to monitor reporting timelines. Repeat funding: No Recommendation: We recommend the County work to establish an internal tracking system to memorialize reporting deadlines and track the submission of required reports under the program. Views of responsible officials: Management agrees with the finding and auditor recommendation.
FINDING 2023-002 - Reporting - Significant Deficiency in Internal Controls over Compliance See the Notes to the SEFA for chart/table. Criteria or specific requirement: As a condition of the award, the County is required to submit a Federal Financial Report (FFR) annually. Condition: During our testing, we were provided with documentation that indicated the County did not file FFR by the due date specified in the award document. Context: Of the 5 reports available for testing, we randomly selected three FFRs filed during fiscal year 2023 noting all were filed untimely. Effect: The reports were not filed by the due date specified in the award document. Cause: The County does not have an effective control in place to monitor reporting timelines. Repeat funding: No Recommendation: We recommend the County work to establish an internal tracking system to memorialize reporting deadlines and track the submission of required reports under the program. Views of responsible officials: Management agrees with the finding and auditor recommendation.
FINDING 2023-002 - Reporting - Significant Deficiency in Internal Controls over Compliance See the Notes to the SEFA for chart/table. Criteria or specific requirement: As a condition of the award, the County is required to submit a Federal Financial Report (FFR) annually. Condition: During our testing, we were provided with documentation that indicated the County did not file FFR by the due date specified in the award document. Context: Of the 5 reports available for testing, we randomly selected three FFRs filed during fiscal year 2023 noting all were filed untimely. Effect: The reports were not filed by the due date specified in the award document. Cause: The County does not have an effective control in place to monitor reporting timelines. Repeat funding: No Recommendation: We recommend the County work to establish an internal tracking system to memorialize reporting deadlines and track the submission of required reports under the program. Views of responsible officials: Management agrees with the finding and auditor recommendation.
FINDING 2023-002 - Reporting - Significant Deficiency in Internal Controls over Compliance See the Notes to the SEFA for chart/table. Criteria or specific requirement: As a condition of the award, the County is required to submit a Federal Financial Report (FFR) annually. Condition: During our testing, we were provided with documentation that indicated the County did not file FFR by the due date specified in the award document. Context: Of the 5 reports available for testing, we randomly selected three FFRs filed during fiscal year 2023 noting all were filed untimely. Effect: The reports were not filed by the due date specified in the award document. Cause: The County does not have an effective control in place to monitor reporting timelines. Repeat funding: No Recommendation: We recommend the County work to establish an internal tracking system to memorialize reporting deadlines and track the submission of required reports under the program. Views of responsible officials: Management agrees with the finding and auditor recommendation.
FINDING 2023-002 - Reporting - Significant Deficiency in Internal Controls over Compliance See the Notes to the SEFA for chart/table. Criteria or specific requirement: As a condition of the award, the County is required to submit a Federal Financial Report (FFR) annually. Condition: During our testing, we were provided with documentation that indicated the County did not file FFR by the due date specified in the award document. Context: Of the 5 reports available for testing, we randomly selected three FFRs filed during fiscal year 2023 noting all were filed untimely. Effect: The reports were not filed by the due date specified in the award document. Cause: The County does not have an effective control in place to monitor reporting timelines. Repeat funding: No Recommendation: We recommend the County work to establish an internal tracking system to memorialize reporting deadlines and track the submission of required reports under the program. Views of responsible officials: Management agrees with the finding and auditor recommendation.
FINDING 2023-002 - Reporting - Significant Deficiency in Internal Controls over Compliance See the Notes to the SEFA for chart/table. Criteria or specific requirement: As a condition of the award, the County is required to submit a Federal Financial Report (FFR) annually. Condition: During our testing, we were provided with documentation that indicated the County did not file FFR by the due date specified in the award document. Context: Of the 5 reports available for testing, we randomly selected three FFRs filed during fiscal year 2023 noting all were filed untimely. Effect: The reports were not filed by the due date specified in the award document. Cause: The County does not have an effective control in place to monitor reporting timelines. Repeat funding: No Recommendation: We recommend the County work to establish an internal tracking system to memorialize reporting deadlines and track the submission of required reports under the program. Views of responsible officials: Management agrees with the finding and auditor recommendation.
FINDING 2023-002 - Reporting - Significant Deficiency in Internal Controls over Compliance See the Notes to the SEFA for chart/table. Criteria or specific requirement: As a condition of the award, the County is required to submit a Federal Financial Report (FFR) annually. Condition: During our testing, we were provided with documentation that indicated the County did not file FFR by the due date specified in the award document. Context: Of the 5 reports available for testing, we randomly selected three FFRs filed during fiscal year 2023 noting all were filed untimely. Effect: The reports were not filed by the due date specified in the award document. Cause: The County does not have an effective control in place to monitor reporting timelines. Repeat funding: No Recommendation: We recommend the County work to establish an internal tracking system to memorialize reporting deadlines and track the submission of required reports under the program. Views of responsible officials: Management agrees with the finding and auditor recommendation.
FINDING 2023-002 - Reporting - Significant Deficiency in Internal Controls over Compliance See the Notes to the SEFA for chart/table. Criteria or specific requirement: As a condition of the award, the County is required to submit a Federal Financial Report (FFR) annually. Condition: During our testing, we were provided with documentation that indicated the County did not file FFR by the due date specified in the award document. Context: Of the 5 reports available for testing, we randomly selected three FFRs filed during fiscal year 2023 noting all were filed untimely. Effect: The reports were not filed by the due date specified in the award document. Cause: The County does not have an effective control in place to monitor reporting timelines. Repeat funding: No Recommendation: We recommend the County work to establish an internal tracking system to memorialize reporting deadlines and track the submission of required reports under the program. Views of responsible officials: Management agrees with the finding and auditor recommendation.
FINDING 2023-002 - Reporting - Significant Deficiency in Internal Controls over Compliance See the Notes to the SEFA for chart/table. Criteria or specific requirement: As a condition of the award, the County is required to submit a Federal Financial Report (FFR) annually. Condition: During our testing, we were provided with documentation that indicated the County did not file FFR by the due date specified in the award document. Context: Of the 5 reports available for testing, we randomly selected three FFRs filed during fiscal year 2023 noting all were filed untimely. Effect: The reports were not filed by the due date specified in the award document. Cause: The County does not have an effective control in place to monitor reporting timelines. Repeat funding: No Recommendation: We recommend the County work to establish an internal tracking system to memorialize reporting deadlines and track the submission of required reports under the program. Views of responsible officials: Management agrees with the finding and auditor recommendation.
FINDING 2023-002 - Reporting - Significant Deficiency in Internal Controls over Compliance See the Notes to the SEFA for chart/table. Criteria or specific requirement: As a condition of the award, the County is required to submit a Federal Financial Report (FFR) annually. Condition: During our testing, we were provided with documentation that indicated the County did not file FFR by the due date specified in the award document. Context: Of the 5 reports available for testing, we randomly selected three FFRs filed during fiscal year 2023 noting all were filed untimely. Effect: The reports were not filed by the due date specified in the award document. Cause: The County does not have an effective control in place to monitor reporting timelines. Repeat funding: No Recommendation: We recommend the County work to establish an internal tracking system to memorialize reporting deadlines and track the submission of required reports under the program. Views of responsible officials: Management agrees with the finding and auditor recommendation.