Audit 323337

FY End
2023-12-31
Total Expended
$1.98M
Findings
0
Programs
33
Organization: Pepin County (WI)
Year: 2023 Accepted: 2024-09-30
Auditor: Wipfli LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $179,412 - 0
93.658 Foster Care_title IV-E $154,237 - 0
93.778 Medical Assistance Program $100,927 Yes 0
93.217 Family Planning_services $66,611 - 0
93.667 Social Services Block Grant $55,209 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $51,808 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $48,900 - 0
93.563 Child Support Enforcement $48,795 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $45,802 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $41,421 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $36,265 - 0
93.558 Temporary Assistance for Needy Families $29,344 - 0
93.069 Public Health Emergency Preparedness $22,228 - 0
97.042 Emergency Management Performance Grants $19,405 - 0
93.053 Nutrition Services Incentive Program $19,318 - 0
93.556 Promoting Safe and Stable Families $17,067 - 0
93.788 Opioid Str $10,000 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $8,753 - 0
84.181 Special Education-Grants for Infants and Families $8,614 - 0
93.767 Children's Health Insurance Program $8,094 - 0
93.958 Block Grants for Community Mental Health Services $7,578 - 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $6,663 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $6,161 - 0
97.067 Homeland Security Grant Program $5,520 - 0
93.991 Preventive Health and Health Services Block Grant $4,477 - 0
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $4,259 - 0
93.994 Maternal and Child Health Services Block Grant to the States $4,220 - 0
93.268 Immunization Cooperative Agreements $2,396 - 0
93.071 Medicare Enrollment Assistance Program $2,303 - 0
93.575 Child Care and Development Block Grant $1,313 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $1,230 - 0
97.047 Pre-Disaster Mitigation $1,016 - 0
93.747 Elder Abuse Prevention Interventions Program $695 - 0

Contacts

Name Title Type
S9JABJG5ND63 Pam Hansen Auditee
7156728704 Rob Ganschow Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: The accompanying schedules of expenditures of federal awards and state financial assistance (the Schedule) includes the federal and state grant activity of Pepin 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 (the "Uniform Guidance”) and State of Wisconsin Single Audit Guidelines. Because the schedules present only a selected portion of the operations of Pepin County, it is not intended to and does not present the financial position, changes in net position, or cash flows of Pepin County. Expenditures reported on the Schedule are reported on the 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 reimbursment. 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. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate The accompanying schedule of expenditures of federal awards and state financial assistance (the schedule) includes the federal and state award activity of Pepin 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 Pepin County, it is not intended to, and does not, present the financial position, changes in net position, or cash flows of Pepin County. Expenditures reported on the Schedule are reported on the 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 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.
Title: Significant Accounting Principles Accounting Policies: The accompanying schedules of expenditures of federal awards and state financial assistance (the Schedule) includes the federal and state grant activity of Pepin 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 (the "Uniform Guidance”) and State of Wisconsin Single Audit Guidelines. Because the schedules present only a selected portion of the operations of Pepin County, it is not intended to and does not present the financial position, changes in net position, or cash flows of Pepin County. Expenditures reported on the Schedule are reported on the 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 reimbursment. 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. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate Pepin County has not elected to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance.
Title: State Direct Payments (Unaudited) Accounting Policies: The accompanying schedules of expenditures of federal awards and state financial assistance (the Schedule) includes the federal and state grant activity of Pepin 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 (the "Uniform Guidance”) and State of Wisconsin Single Audit Guidelines. Because the schedules present only a selected portion of the operations of Pepin County, it is not intended to and does not present the financial position, changes in net position, or cash flows of Pepin County. Expenditures reported on the Schedule are reported on the 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 reimbursment. 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. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate Benefits distributed by the State directly to residents of Pepin County were: Food Share Benefits $1,653,034 WHEAP Benefits $549,817
Title: Claims Paid Via Third-Party Administrator Accounting Policies: The accompanying schedules of expenditures of federal awards and state financial assistance (the Schedule) includes the federal and state grant activity of Pepin 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 (the "Uniform Guidance”) and State of Wisconsin Single Audit Guidelines. Because the schedules present only a selected portion of the operations of Pepin County, it is not intended to and does not present the financial position, changes in net position, or cash flows of Pepin County. Expenditures reported on the Schedule are reported on the 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 reimbursment. 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. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate Amounts shown as paid via Third-Party Administrator (TPA) are payments made by a TPA for County authorized services. The TPA makes payments directly to the service providers and receives reimbursement for these services directly from the Wisconsin Department of Health Services (DHS). The activity between the TPA and service providers is not recorded in the County's financial accounting system; however, DHS guidance dictates that these transactions are to be included in the schedules of expenditures of federal awards and state financial assistance.
Title: Solid and Water Resource Management Activities Accounting Policies: The accompanying schedules of expenditures of federal awards and state financial assistance (the Schedule) includes the federal and state grant activity of Pepin 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 (the "Uniform Guidance”) and State of Wisconsin Single Audit Guidelines. Because the schedules present only a selected portion of the operations of Pepin County, it is not intended to and does not present the financial position, changes in net position, or cash flows of Pepin County. Expenditures reported on the Schedule are reported on the 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 reimbursment. 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. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate Detail of the sources and uses of the Soil and Water Resource Management (SWRM) Activities program for County Staff and Support and Land and Water Resource Management (LWRM) Plan Implementation for 2023 are as follows: SWRM Plan Implementation 115.150 Sources: Receipts from state $125,528 Less - Beginning receivable (125,528) Plus ending receivable 104,565 Total state sources 104,565 Local share 49,621 Total sources $154,186 Uses: Reimbursed staff and support $154,186 LWRM Plan Implementation 115.400 Sources: Receipts from state $67,134 Less - Beginning receivable (67,134) Plus ending receivable 82,354 Total state sources 82,354 Local share 0 Total sources $82,354 Uses: Total cost share payments $82,354