Audit 23054

FY End
2022-12-31
Total Expended
$8.37M
Findings
4
Programs
34
Organization: Green County (WI)
Year: 2022 Accepted: 2023-09-17

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
21162 2022-002 Significant Deficiency - I
21163 2022-002 Significant Deficiency - I
597604 2022-002 Significant Deficiency - I
597605 2022-002 Significant Deficiency - I

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $2.67M Yes 1
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $1.25M Yes 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $436,851 - 0
93.563 Child Support Enforcement $342,909 - 0
93.658 Foster Care_title IV-E $310,274 - 0
93.778 Medical Assistance Program $236,797 Yes 0
93.767 Children's Health Insurance Program $159,045 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $156,749 - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $146,379 - 0
93.667 Social Services Block Grant $108,382 - 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $96,940 - 0
93.788 Opioid Str $84,089 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $81,303 - 0
93.268 Immunization Cooperative Agreements $58,193 - 0
93.558 Temporary Assistance for Needy Families $43,789 - 0
93.556 Promoting Safe and Stable Families $42,827 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $41,116 - 0
84.181 Special Education-Grants for Infants and Families $37,659 - 0
93.575 Child Care and Development Block Grant $36,277 - 0
93.069 Public Health Emergency Preparedness $34,819 - 0
93.958 Block Grants for Community Mental Health Services $26,052 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $20,405 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $19,141 - 0
16.575 Crime Victim Assistance $17,000 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $15,815 - 0
93.324 State Health Insurance Assistance Program $14,633 - 0
93.994 Maternal and Child Health Services Block Grant to the States $12,258 - 0
15.615 Cooperative Endangered Species Conservation Fund $10,163 - 0
97.067 Homeland Security Grant Program $9,509 - 0
93.071 Medicare Enrollment Assistance Program $7,044 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $5,446 - 0
93.991 Preventive Health and Health Services Block Grant $5,444 - 0
93.747 Elder Abuse Prevention Interventions Program $4,426 - 0
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $3,530 - 0

Contacts

Name Title Type
KSQABKLF78M8 Andrea Sweeney Auditee
6083289449 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: Green 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 Green 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 Green County, it is not intended to and does not present the financial position, changes in net position or cash flows of Green 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: Green 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 following Community Aids Reporting System (CARS) reports dated May 31, 2023 and System for Payments and Reports of Contracts (SPARC) reports for December 2022. Federal/state funding splits for awards passed through Wisconsin Department of Health Services (DHS) are based on the splits provided by DHS on February 4, 2023. Federal/state funding splits for awards passed through Wisconsin Department of Children and Families (DCF) are based on the splits provided by DCF on January 12, 2023.
Title: Pass-Through Grantors 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: Green County has not elected to use the 10% de minimis indirect cost rate of the Uniform Guidance. 6.Pass-Through GrantorsGreen County received federal awards from the following pass-through agencies:DHSWisconsin Department of Health ServicesDCFWisconsin Department of Children and FamiliesRock CoRock County, WisconsinGWAARGreater Wisconsin Agency on Aging Resources, Inc.DOJWisconsin Department of JusticeDOAWisconsin Department of AdministrationDNRWisconsin Department of Natural Resources

Finding Details

Finding 2022-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 Not applicable Department Green County Department of Finance Criteria: The Uniform Guidance require that prior to entering into subawards and contracts with award funds, recipients must verify that such contractors and sub recipients are not suspended, debarred or otherwise excluded pursuant to 31 CFR section 19.300. Condition/Context: During testing, it was noted that the County could not provide evidence this verification had been completed for the two vendors tested. The sample was not statistically valid. Cause: The County did not have evidence verification was completed. Questioned Costs: None noted. Effect: The County could conduct business with a vendor who is suspended or barred. Recommendation: We recommend the County create a procedure that includes one of the following ways to complete this verification. 1. checking the System for Award Management Exclusions maintained by the General Services Administration and available at SAM.gov. Note: The OMB guidance at 2 CFR Part 180 and agency implementing regulations still refer to the SAM Exclusions as the Excluded Parties List System, 2. collecting a certification from the entity, or 3. adding a clause or condition to the covered transaction with that entity, 2 CFR section 180.300. Management's Response: The County has established the process of doing the System for Award Management validation and attaching screen shots of the results to each vendor. Contracts are reviewed by Corporation Counsel and they determine if the clause should be added. Regardless, they are still validated by SAM.
Finding 2022-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 Not applicable Department Green County Department of Finance Criteria: The Uniform Guidance require that prior to entering into subawards and contracts with award funds, recipients must verify that such contractors and sub recipients are not suspended, debarred or otherwise excluded pursuant to 31 CFR section 19.300. Condition/Context: During testing, it was noted that the County could not provide evidence this verification had been completed for the two vendors tested. The sample was not statistically valid. Cause: The County did not have evidence verification was completed. Questioned Costs: None noted. Effect: The County could conduct business with a vendor who is suspended or barred. Recommendation: We recommend the County create a procedure that includes one of the following ways to complete this verification. 1. checking the System for Award Management Exclusions maintained by the General Services Administration and available at SAM.gov. Note: The OMB guidance at 2 CFR Part 180 and agency implementing regulations still refer to the SAM Exclusions as the Excluded Parties List System, 2. collecting a certification from the entity, or 3. adding a clause or condition to the covered transaction with that entity, 2 CFR section 180.300. Management's Response: The County has established the process of doing the System for Award Management validation and attaching screen shots of the results to each vendor. Contracts are reviewed by Corporation Counsel and they determine if the clause should be added. Regardless, they are still validated by SAM.
Finding 2022-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 Not applicable Department Green County Department of Finance Criteria: The Uniform Guidance require that prior to entering into subawards and contracts with award funds, recipients must verify that such contractors and sub recipients are not suspended, debarred or otherwise excluded pursuant to 31 CFR section 19.300. Condition/Context: During testing, it was noted that the County could not provide evidence this verification had been completed for the two vendors tested. The sample was not statistically valid. Cause: The County did not have evidence verification was completed. Questioned Costs: None noted. Effect: The County could conduct business with a vendor who is suspended or barred. Recommendation: We recommend the County create a procedure that includes one of the following ways to complete this verification. 1. checking the System for Award Management Exclusions maintained by the General Services Administration and available at SAM.gov. Note: The OMB guidance at 2 CFR Part 180 and agency implementing regulations still refer to the SAM Exclusions as the Excluded Parties List System, 2. collecting a certification from the entity, or 3. adding a clause or condition to the covered transaction with that entity, 2 CFR section 180.300. Management's Response: The County has established the process of doing the System for Award Management validation and attaching screen shots of the results to each vendor. Contracts are reviewed by Corporation Counsel and they determine if the clause should be added. Regardless, they are still validated by SAM.
Finding 2022-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 Not applicable Department Green County Department of Finance Criteria: The Uniform Guidance require that prior to entering into subawards and contracts with award funds, recipients must verify that such contractors and sub recipients are not suspended, debarred or otherwise excluded pursuant to 31 CFR section 19.300. Condition/Context: During testing, it was noted that the County could not provide evidence this verification had been completed for the two vendors tested. The sample was not statistically valid. Cause: The County did not have evidence verification was completed. Questioned Costs: None noted. Effect: The County could conduct business with a vendor who is suspended or barred. Recommendation: We recommend the County create a procedure that includes one of the following ways to complete this verification. 1. checking the System for Award Management Exclusions maintained by the General Services Administration and available at SAM.gov. Note: The OMB guidance at 2 CFR Part 180 and agency implementing regulations still refer to the SAM Exclusions as the Excluded Parties List System, 2. collecting a certification from the entity, or 3. adding a clause or condition to the covered transaction with that entity, 2 CFR section 180.300. Management's Response: The County has established the process of doing the System for Award Management validation and attaching screen shots of the results to each vendor. Contracts are reviewed by Corporation Counsel and they determine if the clause should be added. Regardless, they are still validated by SAM.