Audit 304116

FY End
2023-06-30
Total Expended
$7.85M
Findings
2
Programs
29
Organization: Yamhill County (OR)
Year: 2023 Accepted: 2024-04-22
Auditor: Singerlewak LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
393936 2023-002 Material Weakness - M
970378 2023-002 Material Weakness - M

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $3.55M Yes 1
20.509 Formula Grants for Rural Areas and Tribal Transit Program $906,166 - 0
93.563 Child Support Enforcement $368,959 - 0
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $319,982 - 0
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $315,567 Yes 0
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $309,209 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $254,871 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $243,987 - 0
16.575 Crime Victim Assistance $190,298 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $190,000 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $142,024 - 0
93.268 Immunization Cooperative Agreements $141,032 - 0
93.788 Opioid Str $131,538 - 0
93.069 Public Health Emergency Preparedness $123,742 - 0
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $112,683 - 0
93.958 Block Grants for Community Mental Health Services $112,292 - 0
97.042 Emergency Management Performance Grants $88,928 - 0
93.994 Maternal and Child Health Services Block Grant to the States $44,022 - 0
93.217 Family Planning_services $25,376 - 0
16.606 State Criminal Alien Assistance Program $20,787 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $15,780 - 0
10.555 National School Lunch Program $13,394 - 0
93.136 Injury Prevention and Control Research and State and Community Based Programs $11,378 - 0
10.553 School Breakfast Program $8,111 - 0
39.003 Donation of Federal Surplus Personal Property $6,269 - 0
96.008 Social Security - Work Incentives Planning and Assistance Program $5,000 - 0
20.616 National Priority Safety Programs $3,627 - 0
15.659 National Wildlife Refuge Fund $3,459 - 0
97.067 Homeland Security Grant Program $396 - 0

Contacts

Name Title Type
HS8KMKC9LQL6 Mike Barnhart Auditee
5037282622 Brad Bingenheimer Auditor
No contacts on file

Notes to SEFA

Title: 1. Basis of Presentation Accounting Policies: Modified accrual basis of accounting De Minimis Rate Used: N Rate Explanation: Indirect costs are allocated as allowed by each grant. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Yamhill County under programs of the federal government for the year ended June 30, 2023. The information in the Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of Yamhill County, it is not intended to and does not present the financial position, changes in net position, or cash flows of Yamhill County.
Title: 2. Summary of Significant Accounting Policies Accounting Policies: Modified accrual basis of accounting De Minimis Rate Used: N Rate Explanation: Indirect costs are allocated as allowed by each grant. Expenditures reported on the Schedule are presented on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement.
Title: 3. Indirect costs Accounting Policies: Modified accrual basis of accounting De Minimis Rate Used: N Rate Explanation: Indirect costs are allocated as allowed by each grant. The County does not use the 10 percent deminimis indirect cost rate as allowed under the Uniform Guidance. The County allocates indirect costs as allowed by each grant.

Finding Details

Criteria: CFR 200.332(d) states: All pass-through entities must… monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward goals are achieved. Pass-through entity monitoring of the subrecipient must include: (1) Reviewing financial and performance reports required by the pass-through entity (2) Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particulate subaward. (3) Issuing a management decision for applicable audit findings pertaining to the Federal award provided to the subrecipient from the pass-through entity as required by 200.521. (4) The pass-through entity is responsible for resolving audit findings specifically related to the subaward and not responsible for resolving crosscutting findings. If a subrecipient has a current Single Audit report posted in the Federal Audit Clearinghouse and has not otherwise been excluded from receipt of Federal funding (e.g., has been debarred or suspended), the pass through entity may rely on the subrecipient's cognizant audit agency or cognizant oversight agency to perform audit follow-up and make management decisions related to cross-cutting findings in accordance with section 200.513(a)(3)(vii). Such reliance does not conform to the agency and award-specific requirements, to manage risk through ongoing subaward monitoring, and to monitor the status of the findings that are specifically related to the subaward. Condition: The County did not perform subrecipient monitoring of a school district that received the subaward. Cause: The County was not aware of the requirement to monitor the subrecipient. Effect: Unallowed activities could be undertaken or unallowed costs could be claimed under the program. Questioned Costs: None Perspective: Amounts passed through to subrecipients for the year totaled $2,042,606, of which $1,400,000 was passed through to the Sheridan School District which is subject to its own separate audit under the Uniform Guidance. Views of Officials: The County agrees with the findings and will develop a corrective action plan to implement to have all future grant recipients, regardless of whether they are administered by a third party partner or a non-competitive discretionary allocation, be required to register their organization on the County's online portal.
Criteria: CFR 200.332(d) states: All pass-through entities must… monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward goals are achieved. Pass-through entity monitoring of the subrecipient must include: (1) Reviewing financial and performance reports required by the pass-through entity (2) Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particulate subaward. (3) Issuing a management decision for applicable audit findings pertaining to the Federal award provided to the subrecipient from the pass-through entity as required by 200.521. (4) The pass-through entity is responsible for resolving audit findings specifically related to the subaward and not responsible for resolving crosscutting findings. If a subrecipient has a current Single Audit report posted in the Federal Audit Clearinghouse and has not otherwise been excluded from receipt of Federal funding (e.g., has been debarred or suspended), the pass through entity may rely on the subrecipient's cognizant audit agency or cognizant oversight agency to perform audit follow-up and make management decisions related to cross-cutting findings in accordance with section 200.513(a)(3)(vii). Such reliance does not conform to the agency and award-specific requirements, to manage risk through ongoing subaward monitoring, and to monitor the status of the findings that are specifically related to the subaward. Condition: The County did not perform subrecipient monitoring of a school district that received the subaward. Cause: The County was not aware of the requirement to monitor the subrecipient. Effect: Unallowed activities could be undertaken or unallowed costs could be claimed under the program. Questioned Costs: None Perspective: Amounts passed through to subrecipients for the year totaled $2,042,606, of which $1,400,000 was passed through to the Sheridan School District which is subject to its own separate audit under the Uniform Guidance. Views of Officials: The County agrees with the findings and will develop a corrective action plan to implement to have all future grant recipients, regardless of whether they are administered by a third party partner or a non-competitive discretionary allocation, be required to register their organization on the County's online portal.