Audit 300570

FY End
2023-06-30
Total Expended
$12.54M
Findings
2
Programs
34
Organization: Josephine County, Oregon (OR)
Year: 2023 Accepted: 2024-03-29
Auditor: Moss Adams LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
389664 2023-002 Significant Deficiency - L
966106 2023-002 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $4.00M Yes 1
20.507 Federal Transit_formula Grants $2.58M - 0
93.778 Medical Assistance Program $1.28M Yes 0
93.958 Block Grants for Community Mental Health Services $637,773 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $509,433 - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $508,668 - 0
20.106 Airport Improvement Program $435,591 - 0
93.967 Cdc's Collaboration with Academia to Strengthen Public Health $423,077 - 0
20.509 Formula Grants for Rural Areas and Tribal Transit Program $382,969 - 0
16.575 Crime Victim Assistance $250,295 - 0
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $198,782 - 0
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $192,079 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $189,580 - 0
16.585 Drug Court Discretionary Grant Program $189,019 - 0
97.042 Emergency Management Performance Grants $131,473 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $114,345 - 0
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $109,968 - 0
93.069 Public Health Emergency Preparedness $103,705 - 0
97.039 Hazard Mitigation Grant $64,183 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $42,035 - 0
93.994 Maternal and Child Health Services Block Grant to the States $35,530 - 0
66.432 State Public Water System Supervision $32,172 - 0
66.468 Capitalization Grants for Drinking Water State Revolving Funds $32,171 - 0
93.217 Family Planning_services $26,536 - 0
93.268 Immunization Cooperative Agreements $24,927 - 0
10.555 National School Lunch Program $14,374 - 0
15.214 Non-Sale Disposals of Mineral Material $8,830 - 0
10.553 School Breakfast Program $6,353 - 0
93.889 National Bioterrorism Hospital Preparedness Program $5,865 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $4,165 - 0
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $1,457 - 0
93.940 Hiv Prevention Activities_health Department Based $908 - 0
16.607 Bulletproof Vest Partnership Program $884 - 0
84.126 Rehabilitation Services_vocational Rehabilitation Grants to States $95 - 0

Contacts

Name Title Type
MCM8TATKED46 Trevin Mikels Auditee
5414745257 Amanda McCleary-Moore Auditor
No contacts on file

Notes to SEFA

Title: A. Purpose of the Schedule Accounting Policies: B. Summary of Significant Accounting Policies Reporting Entity. The reporting entity is fully described in Note 1.A. to the County's basic financial statements. The Schedule includes all federal financial assistance programs administered by the County for the year ended June 30, 2023. Basis of Presentation. 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). Federal Financial Assistance. Pursuant to Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, federal financial assistance is defined as assistance provided by a federal agency, either directly or indirectly, in the form of grants, contracts, cooperative agreements, loans, loan guarantees, property, interest subsidies, insurance or direct appropriations. Accordingly, nonmonetary federal assistance, including federal surplus property, is included in federal financial assistance and, therefore, is reported on the Schedule, if applicable. Federal financial assistance does not include direct federal cash assistance to individuals. Solicited contracts between the County and the federal government for which the federal government procures tangible goods or services are not considered to be federal financial assistance. Basis of accounting. Receipts and expenditures are accounted for using the modified accrual basis of accounting. Revenues are recorded when measurable and available. Expenditures are recorded when a liability is incurred. C. Non-cash Assistance The County did not receive any non-cash assistance during the year. If any is received it will be included in the federal awards expended. D. Indirect Rate In accordance with the Uniform Guidance section 2 CFR 200.414(f), the County has elected to use a de minimis indirect rate of 10 percent. De Minimis Rate Used: Y Rate Explanation: De minimis cost rate was used. The accompanying schedule of expenditures of federal awards (the Schedule) is a supplementary schedule to Josephine County, Oregon's (the County) basic financial statements and is presented for purposes of additional analysis. Because the Schedule presents only a selected portion of the activities of the County, it is not intended to and does not present either the financial position, changes in financial position, or the cash flow of the County. Pass-through entity identifying numbers are presented where available.
Title: B. Summary of Significant Accounting Policies Accounting Policies: B. Summary of Significant Accounting Policies Reporting Entity. The reporting entity is fully described in Note 1.A. to the County's basic financial statements. The Schedule includes all federal financial assistance programs administered by the County for the year ended June 30, 2023. Basis of Presentation. 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). Federal Financial Assistance. Pursuant to Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, federal financial assistance is defined as assistance provided by a federal agency, either directly or indirectly, in the form of grants, contracts, cooperative agreements, loans, loan guarantees, property, interest subsidies, insurance or direct appropriations. Accordingly, nonmonetary federal assistance, including federal surplus property, is included in federal financial assistance and, therefore, is reported on the Schedule, if applicable. Federal financial assistance does not include direct federal cash assistance to individuals. Solicited contracts between the County and the federal government for which the federal government procures tangible goods or services are not considered to be federal financial assistance. Basis of accounting. Receipts and expenditures are accounted for using the modified accrual basis of accounting. Revenues are recorded when measurable and available. Expenditures are recorded when a liability is incurred. C. Non-cash Assistance The County did not receive any non-cash assistance during the year. If any is received it will be included in the federal awards expended. D. Indirect Rate In accordance with the Uniform Guidance section 2 CFR 200.414(f), the County has elected to use a de minimis indirect rate of 10 percent. De Minimis Rate Used: Y Rate Explanation: De minimis cost rate was used. Reporting Entity. The reporting entity is fully described in Note 1.A. to the County's basic financial statements. The Schedule includes all federal financial assistance programs administered by the County for the year ended June 30, 2023. Basis of Presentation. 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). Federal Financial Assistance. Pursuant to Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, federal financial assistance is defined as assistance provided by a federal agency, either directly or indirectly, in the form of grants, contracts, cooperative agreements, loans, loan guarantees, property, interest subsidies, insurance or direct appropriations. Accordingly, nonmonetary federal assistance, including federal surplus property, is included in federal financial assistance and, therefore, is reported on the Schedule, if applicable. Federal financial assistance does not include direct federal cash assistance to individuals. Solicited contracts between the County and the federal government for which the federal government procures tangible goods or services are not considered to be federal financial assistance. Basis of accounting. Receipts and expenditures are accounted for using the modified accrual basis of accounting. Revenues are recorded when measurable and available. Expenditures are recorded when a liability is incurred.
Title: C. Non-cash Assistance Accounting Policies: B. Summary of Significant Accounting Policies Reporting Entity. The reporting entity is fully described in Note 1.A. to the County's basic financial statements. The Schedule includes all federal financial assistance programs administered by the County for the year ended June 30, 2023. Basis of Presentation. 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). Federal Financial Assistance. Pursuant to Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, federal financial assistance is defined as assistance provided by a federal agency, either directly or indirectly, in the form of grants, contracts, cooperative agreements, loans, loan guarantees, property, interest subsidies, insurance or direct appropriations. Accordingly, nonmonetary federal assistance, including federal surplus property, is included in federal financial assistance and, therefore, is reported on the Schedule, if applicable. Federal financial assistance does not include direct federal cash assistance to individuals. Solicited contracts between the County and the federal government for which the federal government procures tangible goods or services are not considered to be federal financial assistance. Basis of accounting. Receipts and expenditures are accounted for using the modified accrual basis of accounting. Revenues are recorded when measurable and available. Expenditures are recorded when a liability is incurred. C. Non-cash Assistance The County did not receive any non-cash assistance during the year. If any is received it will be included in the federal awards expended. D. Indirect Rate In accordance with the Uniform Guidance section 2 CFR 200.414(f), the County has elected to use a de minimis indirect rate of 10 percent. De Minimis Rate Used: Y Rate Explanation: De minimis cost rate was used. The County did not receive any non-cash assistance during the year. If any is received it will be included in the federal awards expended.
Title: D. Indirect Rate Accounting Policies: B. Summary of Significant Accounting Policies Reporting Entity. The reporting entity is fully described in Note 1.A. to the County's basic financial statements. The Schedule includes all federal financial assistance programs administered by the County for the year ended June 30, 2023. Basis of Presentation. 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). Federal Financial Assistance. Pursuant to Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, federal financial assistance is defined as assistance provided by a federal agency, either directly or indirectly, in the form of grants, contracts, cooperative agreements, loans, loan guarantees, property, interest subsidies, insurance or direct appropriations. Accordingly, nonmonetary federal assistance, including federal surplus property, is included in federal financial assistance and, therefore, is reported on the Schedule, if applicable. Federal financial assistance does not include direct federal cash assistance to individuals. Solicited contracts between the County and the federal government for which the federal government procures tangible goods or services are not considered to be federal financial assistance. Basis of accounting. Receipts and expenditures are accounted for using the modified accrual basis of accounting. Revenues are recorded when measurable and available. Expenditures are recorded when a liability is incurred. C. Non-cash Assistance The County did not receive any non-cash assistance during the year. If any is received it will be included in the federal awards expended. D. Indirect Rate In accordance with the Uniform Guidance section 2 CFR 200.414(f), the County has elected to use a de minimis indirect rate of 10 percent. De Minimis Rate Used: Y Rate Explanation: De minimis cost rate was used. In accordance with the Uniform Guidance section 2 CFR 200.414(f), the County has elected to use a de minimis indirect rate of 10 percent

Finding Details

Criteria: Under Title 2 CFR 200.327 and 200.328, Financial reporting, and grant contract conditions require a non-federal entity direct recipient to report on federal awards and include all activity of the reporting period on a quarterly basis, and be supported by applicable accounting or performance records, and are fairly presented in accordance with applicable governing requirements. Condition/Context: We tested two quarterly reports and noted that neither of the Project and Expenditure Report reports tied to supporting detail schedules of expenditures accumulated. Cause: The individuals preparing the reports did not have the proper knowledge and understanding to perform those duties. Effect: The County was not able to file correct quarterly reports in compliance with federal regulations and contained material errors. Without a centralized system of internal controls that includes documentation and preparation by an individual with the required skills and knowledge, review and timely reconciliation of reported expenditures and amounts reported to federal agencies may be inaccurate. Question costs: None. Repeat finding: No. Recommendation: We recommend the County assigns a knowledgeable individual with proper training and skill to complete the reports, ensuring that the reviewer also ties the reports to the support before sending to federal agencies. Views of Responsible Officials: The County has restructured the duties of the Finance office to ensure the staff with the most appropriate knowledge base is performing the duties that are new or unusual while providing the training necessary to ensure that the source work is done in a way that supports the appropriate reporting outcomes.
Criteria: Under Title 2 CFR 200.327 and 200.328, Financial reporting, and grant contract conditions require a non-federal entity direct recipient to report on federal awards and include all activity of the reporting period on a quarterly basis, and be supported by applicable accounting or performance records, and are fairly presented in accordance with applicable governing requirements. Condition/Context: We tested two quarterly reports and noted that neither of the Project and Expenditure Report reports tied to supporting detail schedules of expenditures accumulated. Cause: The individuals preparing the reports did not have the proper knowledge and understanding to perform those duties. Effect: The County was not able to file correct quarterly reports in compliance with federal regulations and contained material errors. Without a centralized system of internal controls that includes documentation and preparation by an individual with the required skills and knowledge, review and timely reconciliation of reported expenditures and amounts reported to federal agencies may be inaccurate. Question costs: None. Repeat finding: No. Recommendation: We recommend the County assigns a knowledgeable individual with proper training and skill to complete the reports, ensuring that the reviewer also ties the reports to the support before sending to federal agencies. Views of Responsible Officials: The County has restructured the duties of the Finance office to ensure the staff with the most appropriate knowledge base is performing the duties that are new or unusual while providing the training necessary to ensure that the source work is done in a way that supports the appropriate reporting outcomes.