Audit 316691

FY End
2023-12-31
Total Expended
$7.21M
Findings
2
Programs
34
Organization: Shawano County, Wisconsin (WI)
Year: 2023 Accepted: 2024-08-06

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
480497 2023-002 Significant Deficiency - L
1056939 2023-002 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.80M Yes 1
93.778 Medical Assistance Program $719,452 Yes 0
93.563 Child Support Enforcement $374,267 - 0
93.658 Foster Care_title IV-E $355,661 - 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $203,794 - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $182,347 - 0
93.575 Child Care and Development Block Grant $112,214 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $110,089 - 0
93.069 Public Health Emergency Preparedness $82,811 - 0
93.667 Social Services Block Grant $56,350 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $51,819 - 0
84.181 Special Education-Grants for Infants and Families $43,894 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $43,439 - 0
93.556 Promoting Safe and Stable Families $42,827 - 0
20.616 National Priority Safety Programs $40,027 - 0
93.958 Block Grants for Community Mental Health Services $35,834 - 0
81.041 State Energy Program $35,000 - 0
93.053 Nutrition Services Incentive Program $34,889 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $26,948 - 0
93.090 Guardianship Assistance $24,541 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $23,418 - 0
93.994 Maternal and Child Health Services Block Grant to the States $22,265 - 0
93.767 Children's Health Insurance Program $14,183 - 0
93.967 Cdc's Collaboration with Academia to Strengthen Public Health $13,987 - 0
93.991 Preventive Health and Health Services Block Grant $12,942 - 0
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $11,825 - 0
10.902 Soil and Water Conservation $9,581 - 0
93.747 Elder Abuse Prevention Interventions Program $9,534 - 0
16.607 Bulletproof Vest Partnership Program $7,202 - 0
93.788 Opioid Str $6,140 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $5,926 - 0
93.071 Medicare Enrollment Assistance Program $4,736 - 0
93.324 State Health Insurance Assistance Program $3,552 - 0
93.268 Immunization Cooperative Agreements $743 - 0

Contacts

Name Title Type
UG4VPSVKV3D3 Carrie Buntjer Auditee
7155264840 John Rader Auditor
No contacts on file

Notes to SEFA

Title: 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: Shawano County has not elected to use the 10% de minimis indirect cost rate of the Uniform Guidance. The accompanying schedule of expenditures of federal and state awards (the Schedule) includes the federal and state award activity of Shawano County under programs of the federal and state government for the year ended December 31, 2023. 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 Shawano County, it is not intended to and does not present the financial position, changes in net position or cash flows of Shawano County.
Title: 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: Shawano County has not elected to use the 10% de minimis indirect cost rate of the Uniform Guidance. The schedule of expenditures of federal and state awards includes adjustments through the February 14, 2024 Grant Enrollment, Application and Reporting System (GEARS) reports and the April 2, 2024 SPARC report.
Title: 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: Shawano County has not elected to use the 10% de minimis indirect cost rate of the Uniform Guidance. Shawano County received federal awards from the following pass-through agencies: DHS Wisconsin Department of Health Services DCF Wisconsin Department of Children and Families GWAAR Greater Wisconsin Agency on Aging Resources, Inc. City of Shawano City of Shawano Police Department PSC Public Service Commission DOJ Wisconsin Department of Justice Bay Lakes Bay Lakes Consortium Fox Wolf Fox Wolf Alliance

Finding Details

Finding 2023-002 AL No. 21.027 COVID-19 Coronavirus State and Local Fiscal Recovery Funds Federal Agency U.S. Department of Treasury Pass-through Agency Not applicable Award Number / Year 2023 Department Shawano County Department of Finance Criteria: The Uniform Guidance and State Single Audit Guidelines require that local entities receiving federal and state awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. The Uniform Guidance and State Single Audit Guidelines further require auditors to obtain an understanding of the local entity's internal control over federal and state programs. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including the preparation and submission of monthly reports, which should be reviewed and approved by a responsible party other than the original preparer before they are submitted to the granting agency. Condition/Context: During our testing, it was noted that the 2023 project and expenditure report was not reviewed by an independent person before submission for reimbursement. Our sample was not statistically valid. Cause: The county did not have internal control procedures in place requiring an independent person to review the reports before submission to ensure the report was accurate. Questioned Costs: None noted. Effect: Reports submitted could contain errors. Recommendation: We recommend that an employee other than the preparer review all reports before they are submitted to grantors. Management’s Response: Internal guidance has been provided to all departments for documented reviews of compliance requirements. An update will be made to the financial policy.
Finding 2023-002 AL No. 21.027 COVID-19 Coronavirus State and Local Fiscal Recovery Funds Federal Agency U.S. Department of Treasury Pass-through Agency Not applicable Award Number / Year 2023 Department Shawano County Department of Finance Criteria: The Uniform Guidance and State Single Audit Guidelines require that local entities receiving federal and state awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations and program compliance requirements. The Uniform Guidance and State Single Audit Guidelines further require auditors to obtain an understanding of the local entity's internal control over federal and state programs. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including the preparation and submission of monthly reports, which should be reviewed and approved by a responsible party other than the original preparer before they are submitted to the granting agency. Condition/Context: During our testing, it was noted that the 2023 project and expenditure report was not reviewed by an independent person before submission for reimbursement. Our sample was not statistically valid. Cause: The county did not have internal control procedures in place requiring an independent person to review the reports before submission to ensure the report was accurate. Questioned Costs: None noted. Effect: Reports submitted could contain errors. Recommendation: We recommend that an employee other than the preparer review all reports before they are submitted to grantors. Management’s Response: Internal guidance has been provided to all departments for documented reviews of compliance requirements. An update will be made to the financial policy.