Audit 42483

FY End
2022-12-31
Total Expended
$36.70M
Findings
4
Programs
61
Organization: Rock County (WI)
Year: 2022 Accepted: 2023-09-28

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
49600 2022-003 Significant Deficiency Yes L
49601 2022-002 Material Weakness Yes L
626042 2022-003 Significant Deficiency Yes L
626043 2022-002 Material Weakness Yes L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $7.35M Yes 1
93.563 Child Support Enforcement $2.75M Yes 0
93.658 Foster Care_title IV-E $2.19M Yes 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $789,640 - 0
93.667 Social Services Block Grant $789,425 - 0
93.558 Temporary Assistance for Needy Families $787,673 - 0
93.778 Medical Assistance Program $779,295 Yes 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $723,126 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $535,356 - 0
93.788 Opioid Str $513,826 - 0
93.669 Child Abuse and Neglect State Grants $500,264 - 0
93.498 Provider Relief Fund $429,060 Yes 1
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $336,110 - 0
16.585 Drug Court Discretionary Grant Program $287,052 - 0
93.575 Child Care and Development Block Grant $244,864 - 0
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $177,316 - 0
84.181 Special Education-Grants for Infants and Families $159,377 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $155,739 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $142,555 - 0
97.039 Hazard Mitigation Grant $130,195 - 0
93.767 Children's Health Insurance Program $112,351 - 0
93.069 Public Health Emergency Preparedness $111,908 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $111,008 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $92,893 - 0
93.665 Emergency Grants to Address Mental and Substance Use Disorders During Covid-19 $90,964 - 0
93.958 Block Grants for Community Mental Health Services $83,377 - 0
93.053 Nutrition Services Incentive Program $74,219 - 0
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $68,892 - 0
93.090 Guardianship Assistance $66,100 - 0
10.931 Agricultural Conservation Easement Program $64,000 - 0
20.106 Airport Improvement Program $57,000 - 0
16.606 State Criminal Alien Assistance Program $56,517 - 0
95.001 High Intensity Drug Trafficking Areas Program $54,077 - 0
20.616 National Priority Safety Programs $44,307 - 0
93.268 Immunization Cooperative Agreements $33,421 - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $32,180 - 0
93.994 Maternal and Child Health Services Block Grant to the States $31,898 - 0
10.902 Soil and Water Conservation $31,073 - 0
10.912 Environmental Quality Incentives Program $31,073 - 0
20.602 Occupant Protection Incentive Grants $29,966 - 0
93.426 Improving the Health of Americans Through Prevention and Management of Diabetes and Heart Disease and Stroke $23,361 - 0
97.042 Emergency Management Performance Grants $22,012 - 0
93.590 Community-Based Child Abuse Prevention Grants $17,786 - 0
10.924 Conservation Stewardship Program $17,172 - 0
10.555 National School Lunch Program $17,014 - 0
93.991 Preventive Health and Health Services Block Grant $14,797 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $14,735 - 0
93.747 Elder Abuse Prevention Interventions Program $12,272 - 0
10.578 Wic Grants to States (wgs) $11,675 - 0
93.556 Promoting Safe and Stable Families $11,206 - 0
93.071 Medicare Enrollment Assistance Program $11,162 - 0
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $10,778 - 0
93.324 State Health Insurance Assistance Program $9,547 - 0
10.553 School Breakfast Program $8,626 - 0
20.600 State and Community Highway Safety $8,357 - 0
20.601 Alcohol Impaired Driving Countermeasures Incentive Grants I $5,826 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $4,209 - 0
93.659 Adoption Assistance $2,959 - 0
10.069 Conservation Reserve Program $2,453 - 0
93.940 Hiv Prevention Activities_health Department Based $2,423 - 0
16.710 Public Safety Partnership and Community Policing Grants $2,219 - 0

Contacts

Name Title Type
Z9JZC1G27GH1 Sherry Oja Auditee
6087575534 Andrea Jansen Auditor
No contacts on file

Notes to SEFA

Title: 1.Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the accrual or 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. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available.The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The accompanying schedule of expenditures of federal and state awards (the Schedule) includes the federal and state award activity of the Rock County, Wisconsin (the County) under programs of the federal and state government for the year ended December 31, 2022. The information in this 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) and the State Single Audit Guidelines. 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 net position or cash flows of the County.
Title: 3.ALN 93.498 Provider Relief Fund and American Rescue Plan (ARP) Rural Dis Accounting Policies: Expenditures reported on the Schedule are reported on the accrual or 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. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available.The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The Health Resources and Services Administration (HRSA) has directed health care providers to report expenditures on the Schedule using periods that are based on the deadline to use the funds along with the PRF portal reporting time period. In accordance with this guidance, the County has reported expenditures for ALN 93.498 that were incurred between January 1, 2020 and December 31, 2022, which represent Periods 3 and 4 as identified by HRSA, in the accompanying Schedule.
Title: 4.CARS/SPARC Report Dates Accounting Policies: Expenditures reported on the Schedule are reported on the accrual or 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. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available.The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The Schedule of Expenditures of Federal and State Awards includes adjustments through the following Community Aids Reporting System (CARS) reports dated April 30, 2023, and the System for Payments and Reports of Contracts (SPARC) reports for December 2022.
Title: 6.Pass-Through Agencies Accounting Policies: Expenditures reported on the Schedule are reported on the accrual or 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. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available.The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The County received federal awards from the following pass-through agencies:DHSWisconsin Department of Health ServicesDOTWisconsin Department of TransportationDCFWisconsin Department of Children and FamiliesDOJWisconsin Department of JusticeDPIWisconsin Department of Public InstructionJanesville PDCity of Janesville Police DepartmentBeloit PDCity of Beloit Police DepartmentMKE HIDTAMilwaukee High-Intensity Drug Trafficking AreasWEMWisconsin Emergency Management

Finding Details

Finding 2022-003 Program ALN: 21.027 Program Title: COVID-19 State and Local Fiscal Recovery Funds (SLFRF) Award Number/Year: Not applicable / 2022 Federal Agency: U.S. Department of Treasury Repeat of Finding 2021-007 Criteria: The U.S. Department of Treasury issued Compliance and Reporting Guidance on February 28, 2022 which specifies the information to be reported for each contract, grant, loan, transfer, or direct payment greater than $50,000 pertaining to the State and Local Fiscal Recovery Funds (SLFRF). The required information includes identification of subrecipients which are entities that receive a subaward from a recipient to carry out the purposes (program or project) of the SLFRF award on behalf of the recipient. Subrecipient relationships require additional monitoring and compliance steps. The direct recipient (the County) is responsible for determining if an entity is considered to be a subrecipient. Condition/Context: The County reported eight subrecipients within the 2022 Project and Expenditure report to U.S. Treasury which is not in line with the County?s non-subrecipient relationship determination and the zero subrecipient expenditures reported in the Schedule of Expenditures of Federal Awards for SLFRF. The sample was not statistically valid. Cause: The County did not have internal controls in place requiring an independent person with an understanding of the subrecipient terminology and classification to review the report prior to submission to the U.S. Department of Treasury. Effect: The report was submitted with subrecipient misclassifications. Questioned Costs: None noted. Recommendation: The County should review its internal control procedures to ensure there are proper review and approval processes in place over completeness and accuracy of reports before submissions to federal agencies are completed.
Finding 2022-002 Program ALN: 93.498 Program Title: COVID-19 Provider Relief Fund Award Number/Year: Not applicable / 2022 Federal Agency: U.S. Department of Health and Human Services Repeat of Finding 2021-004 Criteria: Nonfederal entities in receipt of federal funds must comply with the requirements of 2 CFR 200.303(a), which require an entity to establish and maintain effective internal control over the Federal award to ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Recipients of Provider Relief Funds (PRF) payments must also comply with the reporting requirements described in the PRF terms and conditions and specified in directions issued by the U.S. Department of Health and Human Services (HHS). Condition/Context: Both reports selected for testing were not reviewed and approved by an independent person separate from the preparer prior to submission to DHS. In addition the amounts reported could not be supported by expense details and awards were incorrectly claimed against expenses when they were meant to be applied against available lost revenues. The sample was not statistically valid. Cause: The County did not have internal control processes and procedures in place requiring an independent person to review the reports before submission to ensure the amounts reported were accurate. Effect: Information within the period reports contained errors. Questioned Costs: None noted. Recommendation: The County should review its internal control procedures to ensure there are proper review and approval processes over completeness and accuracy of reports are in place before submissions to federal agencies.
Finding 2022-003 Program ALN: 21.027 Program Title: COVID-19 State and Local Fiscal Recovery Funds (SLFRF) Award Number/Year: Not applicable / 2022 Federal Agency: U.S. Department of Treasury Repeat of Finding 2021-007 Criteria: The U.S. Department of Treasury issued Compliance and Reporting Guidance on February 28, 2022 which specifies the information to be reported for each contract, grant, loan, transfer, or direct payment greater than $50,000 pertaining to the State and Local Fiscal Recovery Funds (SLFRF). The required information includes identification of subrecipients which are entities that receive a subaward from a recipient to carry out the purposes (program or project) of the SLFRF award on behalf of the recipient. Subrecipient relationships require additional monitoring and compliance steps. The direct recipient (the County) is responsible for determining if an entity is considered to be a subrecipient. Condition/Context: The County reported eight subrecipients within the 2022 Project and Expenditure report to U.S. Treasury which is not in line with the County?s non-subrecipient relationship determination and the zero subrecipient expenditures reported in the Schedule of Expenditures of Federal Awards for SLFRF. The sample was not statistically valid. Cause: The County did not have internal controls in place requiring an independent person with an understanding of the subrecipient terminology and classification to review the report prior to submission to the U.S. Department of Treasury. Effect: The report was submitted with subrecipient misclassifications. Questioned Costs: None noted. Recommendation: The County should review its internal control procedures to ensure there are proper review and approval processes in place over completeness and accuracy of reports before submissions to federal agencies are completed.
Finding 2022-002 Program ALN: 93.498 Program Title: COVID-19 Provider Relief Fund Award Number/Year: Not applicable / 2022 Federal Agency: U.S. Department of Health and Human Services Repeat of Finding 2021-004 Criteria: Nonfederal entities in receipt of federal funds must comply with the requirements of 2 CFR 200.303(a), which require an entity to establish and maintain effective internal control over the Federal award to ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Recipients of Provider Relief Funds (PRF) payments must also comply with the reporting requirements described in the PRF terms and conditions and specified in directions issued by the U.S. Department of Health and Human Services (HHS). Condition/Context: Both reports selected for testing were not reviewed and approved by an independent person separate from the preparer prior to submission to DHS. In addition the amounts reported could not be supported by expense details and awards were incorrectly claimed against expenses when they were meant to be applied against available lost revenues. The sample was not statistically valid. Cause: The County did not have internal control processes and procedures in place requiring an independent person to review the reports before submission to ensure the amounts reported were accurate. Effect: Information within the period reports contained errors. Questioned Costs: None noted. Recommendation: The County should review its internal control procedures to ensure there are proper review and approval processes over completeness and accuracy of reports are in place before submissions to federal agencies.