Audit 323515

FY End
2023-12-31
Total Expended
$5.82M
Findings
4
Programs
35
Organization: Trempealeau County (WI)
Year: 2023 Accepted: 2024-10-01

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
501234 2023-002 Significant Deficiency - L
501235 2023-002 Significant Deficiency - L
1077676 2023-002 Significant Deficiency - L
1077677 2023-002 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $2.37M Yes 1
93.778 Medical Assistance Program $807,567 Yes 0
93.563 Child Support Services $470,604 - 0
93.658 Foster Care Title IV-E $251,408 - 0
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $209,176 - 0
93.575 Child Care and Development Block Grant $148,799 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $131,770 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $93,126 - 0
93.045 Special Programs for the Aging, Title Iii, Part C, Nutrition Services $72,618 - 0
93.044 Special Programs for the Aging, Title Iii, Part B, Grants for Supportive Services and Senior Centers $43,231 - 0
93.556 Marylee Allen Promoting Safe and Stable Families Program $38,069 - 0
93.667 Social Services Block Grant $37,095 - 0
97.042 Emergency Management Performance Grants $36,331 - 0
93.069 Public Health Emergency Preparedness $35,469 - 0
84.181 Special Education-Grants for Infants and Families $34,533 - 0
93.053 Nutrition Services Incentive Program $19,531 - 0
93.994 Maternal and Child Health Services Block Grant to the States $18,391 - 0
93.958 Block Grants for Community Mental Health Services $18,252 - 0
20.600 State and Community Highway Safety $17,314 - 0
93.558 Temporary Assistance for Needy Families $15,109 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $14,962 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $12,653 - 0
93.767 Children's Health Insurance Program $12,150 - 0
93.090 Guardianship Assistance $11,061 - 0
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $8,483 - 0
16.606 State Criminal Alien Assistance Program $6,856 - 0
93.268 Immunization Cooperative Agreements $6,331 - 0
93.991 Preventive Health and Health Services Block Grant $5,303 - 0
16.710 Public Safety Partnership and Community Policing Grants $5,275 - 0
93.071 Medicare Enrollment Assistance Program $3,945 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $3,834 - 0
93.043 Special Programs for the Aging, Title Iii, Part D, Disease Prevention and Health Promotion Services $2,680 - 0
90.404 Hava Election Security Grants $2,647 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $1,983 - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $311 - 0

Contacts

Name Title Type
CH7PR8S5Y183 Paul Syverson Auditee
7155382311 Sheanne Hediger 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: Trempealeau County has not elected to use the 10% de minimis indirect cost rate. The accompanying schedule of expenditures of federal and state awards (the Schedule) includes the federal and state award activity of Trempealeau 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 the Trempealeau County, it is not intended to and does not present the financial position, changes in net position or cash flows of the Trempealeau County. The reporting entity for the Trempealeau County is based upon criteria established by the Governmental Accounting Standards Board. Trempealeau County is the primary government according to GASB criteria, while the Health Care Center is an enterprise fund. Federal awards received directly by the Health Care Center are not included in this report since the Health Care Center has been audited by other auditors for their grants and those amounts are reported in a separate report.
Title: 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: Trempealeau County has not elected to use the 10% de minimis indirect cost rate. The schedule of expenditures of federal and state awards includes adjustments through the July 1, 2024 (expected payment date) Grant Enrollment, Application and Reporting System (GEARS) reports and the December 2023 SPARC reports. Federal/state funding splits for awards passed through the Wisconsin Department of Health Services (DHS) are based on the splits provided by DHS on February 14, 2024; awards passed through the Wisconsin Department of Children and Families (DCF) are based on the splits provided by DCF on April 2, 2024.
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: Trempealeau County has not elected to use the 10% de minimis indirect cost rate. Trempealeau County received federal awards from the following pass-through agencies: WI DHS Wisconsin Department of Health Services WI DCF Wisconsin Department of Children and Families WI DMA Wisconsin Department of Military Affairs WI DOT Wisconsin Department of Transportation WI DVA Wisconsin Department of Veterans Affairs WEC Wisconsin Elections Commission GWAAR Greater Wisconsin Agency on Aging Resources La Crosse County La Crosse County, Wisconsin
Title: Matching Contribution 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: Trempealeau County has not elected to use the 10% de minimis indirect cost rate. Trempealeau County makes a 20 percent matching contribution for the Specialized Transportation program. The contribution was $15,978 in 2023 from Trempealeau County’s tax levy.

Finding Details

Finding 2023-002: Significant Deficiency – Reporting Program: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Agency: U.S. Department of the Treasury Federal Award Identification Number: N/A Federal Award Year: December 31, 2023 Criteria: Based on 42 USC 802 and 803 as implemented by the Treasury's Interim Final Rule and Final Rule at 31 CFR Part 35, recipients of the Coronavirus State and Local Fiscal Recovery Funds are required to submit special reporting on an annual basis. The annual report must be reviewed and approved by knowledgeable supervisors, which includes comparing to source documentation and performing reconciliations needed between source data and final reporting when needed. Condition/Context: The annual report did not have evidence of review by a manager or supervisor above the preparer. Effect: Amounts included on the annual report could be inaccurate or misleading. Cause: There was no review of the annual report by someone other than the preparer. Questioned Costs: Not applicable. Recommendation: We recommend that the County implement proper review procedures of the annual reporting process. Someone other than the preparer of the report should provide adequate review prior to finalizing the report. This review should include verification that reported expenditure totals agree to the underlying general ledger detail as of the report date. These procedures should be documented and retained. Views of Responsible Officials: Trempealeau County, being a small county, has limited resources in personnel to accomplish a multi-verification in the reporting process. We will use additional current employees in-house to do the verification to make sure the reporting is accurate before submitting.
Finding 2023-002: Significant Deficiency – Reporting Program: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Agency: U.S. Department of the Treasury Federal Award Identification Number: N/A Federal Award Year: December 31, 2023 Criteria: Based on 42 USC 802 and 803 as implemented by the Treasury's Interim Final Rule and Final Rule at 31 CFR Part 35, recipients of the Coronavirus State and Local Fiscal Recovery Funds are required to submit special reporting on an annual basis. The annual report must be reviewed and approved by knowledgeable supervisors, which includes comparing to source documentation and performing reconciliations needed between source data and final reporting when needed. Condition/Context: The annual report did not have evidence of review by a manager or supervisor above the preparer. Effect: Amounts included on the annual report could be inaccurate or misleading. Cause: There was no review of the annual report by someone other than the preparer. Questioned Costs: Not applicable. Recommendation: We recommend that the County implement proper review procedures of the annual reporting process. Someone other than the preparer of the report should provide adequate review prior to finalizing the report. This review should include verification that reported expenditure totals agree to the underlying general ledger detail as of the report date. These procedures should be documented and retained. Views of Responsible Officials: Trempealeau County, being a small county, has limited resources in personnel to accomplish a multi-verification in the reporting process. We will use additional current employees in-house to do the verification to make sure the reporting is accurate before submitting.
Finding 2023-002: Significant Deficiency – Reporting Program: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Agency: U.S. Department of the Treasury Federal Award Identification Number: N/A Federal Award Year: December 31, 2023 Criteria: Based on 42 USC 802 and 803 as implemented by the Treasury's Interim Final Rule and Final Rule at 31 CFR Part 35, recipients of the Coronavirus State and Local Fiscal Recovery Funds are required to submit special reporting on an annual basis. The annual report must be reviewed and approved by knowledgeable supervisors, which includes comparing to source documentation and performing reconciliations needed between source data and final reporting when needed. Condition/Context: The annual report did not have evidence of review by a manager or supervisor above the preparer. Effect: Amounts included on the annual report could be inaccurate or misleading. Cause: There was no review of the annual report by someone other than the preparer. Questioned Costs: Not applicable. Recommendation: We recommend that the County implement proper review procedures of the annual reporting process. Someone other than the preparer of the report should provide adequate review prior to finalizing the report. This review should include verification that reported expenditure totals agree to the underlying general ledger detail as of the report date. These procedures should be documented and retained. Views of Responsible Officials: Trempealeau County, being a small county, has limited resources in personnel to accomplish a multi-verification in the reporting process. We will use additional current employees in-house to do the verification to make sure the reporting is accurate before submitting.
Finding 2023-002: Significant Deficiency – Reporting Program: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Agency: U.S. Department of the Treasury Federal Award Identification Number: N/A Federal Award Year: December 31, 2023 Criteria: Based on 42 USC 802 and 803 as implemented by the Treasury's Interim Final Rule and Final Rule at 31 CFR Part 35, recipients of the Coronavirus State and Local Fiscal Recovery Funds are required to submit special reporting on an annual basis. The annual report must be reviewed and approved by knowledgeable supervisors, which includes comparing to source documentation and performing reconciliations needed between source data and final reporting when needed. Condition/Context: The annual report did not have evidence of review by a manager or supervisor above the preparer. Effect: Amounts included on the annual report could be inaccurate or misleading. Cause: There was no review of the annual report by someone other than the preparer. Questioned Costs: Not applicable. Recommendation: We recommend that the County implement proper review procedures of the annual reporting process. Someone other than the preparer of the report should provide adequate review prior to finalizing the report. This review should include verification that reported expenditure totals agree to the underlying general ledger detail as of the report date. These procedures should be documented and retained. Views of Responsible Officials: Trempealeau County, being a small county, has limited resources in personnel to accomplish a multi-verification in the reporting process. We will use additional current employees in-house to do the verification to make sure the reporting is accurate before submitting.