Audit 323005

FY End
2023-12-31
Total Expended
$4.17M
Findings
2
Programs
37
Organization: Vilas County (WI)
Year: 2023 Accepted: 2024-09-30

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
500167 2023-003 Significant Deficiency - L
1076609 2023-003 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.72M Yes 1
93.575 Child Care and Development Block Grant $587,202 - 0
21.032 Local Assistance and Tribal Consistency Fund $178,439 - 0
93.788 Opioid Str $139,662 - 0
93.778 Medical Assistance Program $84,413 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $65,643 - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $64,103 - 0
20.219 Recreational Trails Program $54,528 - 0
93.069 Public Health Emergency Preparedness $37,385 - 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $36,348 - 0
97.042 Emergency Management Performance Grants $35,021 - 0
93.556 Promoting Safe and Stable Families $27,459 - 0
93.090 Guardianship Assistance $24,103 - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $17,360 - 0
97.047 Pre-Disaster Mitigation $15,750 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $14,846 - 0
16.835 Body Worn Camera Policy and Implementation $14,000 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $13,465 - 0
93.053 Nutrition Services Incentive Program $13,350 - 0
93.658 Foster Care_title IV-E $12,116 - 0
93.268 Immunization Cooperative Agreements $10,909 - 0
93.994 Maternal and Child Health Services Block Grant to the States $9,442 - 0
16.710 Public Safety Partnership and Community Policing Grants $6,079 - 0
93.991 Preventive Health and Health Services Block Grant $5,596 - 0
93.767 Children's Health Insurance Program $5,234 - 0
93.324 State Health Insurance Assistance Program $3,500 - 0
93.958 Block Grants for Community Mental Health Services $3,363 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $3,326 - 0
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $3,258 - 0
93.071 Medicare Enrollment Assistance Program $2,265 - 0
93.667 Social Services Block Grant $1,979 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $1,307 - 0
93.558 Temporary Assistance for Needy Families $1,285 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $743 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $583 - 0
15.226 Payments in Lieu of Taxes $176 - 0
93.563 Child Support Enforcement $-19,692 - 0

Contacts

Name Title Type
XH19DQCMGBK1 Darcy Smith Auditee
7154793674 Jon Trautman Auditor
No contacts on file

Notes to SEFA

Title: BASIS OF PRESENTATION Accounting Policies: Revenues and expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with revenues and expenditures reported in the County’s 2023 fund financial statements. Accrued revenue at year-end consists of federal and state program expenditures scheduled for reimbursement to the County in the succeeding year while unearned revenue represents advances for federal and state programs that exceed recorded County expenditures. Because of subsequent program adjustments, these amounts may differ from the prior year’s ending balances. Such expenditures are recognized following the cost principles contained in the Uniform Guidance and State Single Audit Guidelines, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has not elected to charge a de minimis rate of 10% of modified total costs. The accompanying Schedules of Expenditures of Federal and State Awards for the County are 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 issued by the Wisconsin Department of Administration. The Schedules of Expenditures of Federal and State Awards include all federal and state awards of the County. Because the schedules present 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: OVERSIGHT AGENCIES Accounting Policies: Revenues and expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with revenues and expenditures reported in the County’s 2023 fund financial statements. Accrued revenue at year-end consists of federal and state program expenditures scheduled for reimbursement to the County in the succeeding year while unearned revenue represents advances for federal and state programs that exceed recorded County expenditures. Because of subsequent program adjustments, these amounts may differ from the prior year’s ending balances. Such expenditures are recognized following the cost principles contained in the Uniform Guidance and State Single Audit Guidelines, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has not elected to charge a de minimis rate of 10% of modified total costs. The federal and state oversight agencies for the County are as follows: Federal – U.S. Department of the Treasury State – Wisconsin Department of Natural Resources
Title: PASS-THROUGH ENTITIES Accounting Policies: Revenues and expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with revenues and expenditures reported in the County’s 2023 fund financial statements. Accrued revenue at year-end consists of federal and state program expenditures scheduled for reimbursement to the County in the succeeding year while unearned revenue represents advances for federal and state programs that exceed recorded County expenditures. Because of subsequent program adjustments, these amounts may differ from the prior year’s ending balances. Such expenditures are recognized following the cost principles contained in the Uniform Guidance and State Single Audit Guidelines, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has not elected to charge a de minimis rate of 10% of modified total costs. Federal awards have been passed through the following entities: GWAAR – Greater Wisconsin Agency on Aging Resources WI DCF – Wisconsin Department of Children and Families WI DHS – Wisconsin Department of Health Services WI DMA – Wisconsin Department of Military Affairs WI DNR – Wisconsin Department of Natural Resources Wood County, WI Oneida County, WI Small Rural Tribal
Title: STATE DIRECT PAYMENTS Accounting Policies: Revenues and expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with revenues and expenditures reported in the County’s 2023 fund financial statements. Accrued revenue at year-end consists of federal and state program expenditures scheduled for reimbursement to the County in the succeeding year while unearned revenue represents advances for federal and state programs that exceed recorded County expenditures. Because of subsequent program adjustments, these amounts may differ from the prior year’s ending balances. Such expenditures are recognized following the cost principles contained in the Uniform Guidance and State Single Audit Guidelines, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has not elected to charge a de minimis rate of 10% of modified total costs. Payments made directly to recipients and vendors by the state of Wisconsin under the FoodShare Wisconsin program on behalf of the County are not included the Schedules of Expenditures of Federal and State Awards.

Finding Details

Review of Grant Reports Federal Agency: U.S. Department of the Treasury Federal Program Title: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Pass-Through Agency: Direct Program Pass-Through Numbers: N/A Award Period: March 3, 2021 – December 31, 2026 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or Specific Requirement: Federal reports filed by the County to the various granting agencies must be accurate, reconcile to the County’s general ledger system. Internal controls should be designed and implemented to prevent and detect errors in the data reported on the grant claims. Segregation of duties is an internal control intended to prevent or decrease the occurrence of errors or intentional fraud. Segregation of duties ensures that no single employee has control over all phases of a transaction. Condition: There was no review of the annual performance report by a position other than the preparer. Accordingly, this does not allow for a proper segregation of duties for internal control purposes over reporting compliance requirements. Questioned Costs: None Context: The County did not have documentation of review and approval of the annual performance report required by the grant. Cause: The County had not completed an assessment of the internal control requirements from the grant and had not identified an individual to review the report for accuracy prior to submission. Effect: The report submitted by the County may contain errors that would not be detected. Repeat Finding: No Recommendation: We recommend that the County review its internal controls and implement a procedure to ensure all reports required under the grant have a designated reviewer that is distinct from the individual responsible for preparing. We also recommend the County develop a procedure to ensure any new grants awarded to the County have an internal control assessment performed to document the responsibilities of individuals involved in the grant’s management. Views of Responsible Officials: Refer to the management response per the corrective action plan.
Review of Grant Reports Federal Agency: U.S. Department of the Treasury Federal Program Title: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Pass-Through Agency: Direct Program Pass-Through Numbers: N/A Award Period: March 3, 2021 – December 31, 2026 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or Specific Requirement: Federal reports filed by the County to the various granting agencies must be accurate, reconcile to the County’s general ledger system. Internal controls should be designed and implemented to prevent and detect errors in the data reported on the grant claims. Segregation of duties is an internal control intended to prevent or decrease the occurrence of errors or intentional fraud. Segregation of duties ensures that no single employee has control over all phases of a transaction. Condition: There was no review of the annual performance report by a position other than the preparer. Accordingly, this does not allow for a proper segregation of duties for internal control purposes over reporting compliance requirements. Questioned Costs: None Context: The County did not have documentation of review and approval of the annual performance report required by the grant. Cause: The County had not completed an assessment of the internal control requirements from the grant and had not identified an individual to review the report for accuracy prior to submission. Effect: The report submitted by the County may contain errors that would not be detected. Repeat Finding: No Recommendation: We recommend that the County review its internal controls and implement a procedure to ensure all reports required under the grant have a designated reviewer that is distinct from the individual responsible for preparing. We also recommend the County develop a procedure to ensure any new grants awarded to the County have an internal control assessment performed to document the responsibilities of individuals involved in the grant’s management. Views of Responsible Officials: Refer to the management response per the corrective action plan.