Audit 43096

FY End
2022-12-31
Total Expended
$16.28M
Findings
0
Programs
70
Organization: Ozaukee County (WI)
Year: 2022 Accepted: 2023-09-13
Auditor: Kerberrose Sc

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.92M Yes 0
14.228 Cares - Community Development Block Grant Coronavirus Funds $1.55M Yes 0
93.778 Medical Assistance Program $1.42M - 0
14.228 Small Cities Cdbg State Program $1.01M Yes 0
10.664 U.s. Forest Service Community Forest Program Grant for Acquisition $600,000 - 0
20.507 Federal Transit Capital Improvements Grant (5307) $570,678 Yes 0
15.614 US Fish and Wildlife Service National Coastal Wetlands Conservation Program Grant $538,290 - 0
93.323 Elc Cares - Covid19 $507,148 - 0
66.469 Clay Bluffs Cedar Gorge Nature Preserve Acquisition in Ozaukee County $450,000 - 0
20.526 Bus and Bus Facilities Formula Program (5339) $261,677 Yes 0
15.662 Clay Bluffs/cedar Gorge Acquisition $261,000 - 0
11.419 Clay Bluffs Cedar Gorge Acquisition $250,000 - 0
93.667 Social Services Block Grant $224,678 - 0
10.561 State Administrative Matching Grants for Food Stamp Program $216,750 - 0
97.039 Fema Grant - Hazard Mitigation Grant $202,079 - 0
66.469 Mineral Springs Creek Fish Passage $164,217 - 0
93.045 Special Programs for the Aging Title Iii, Part C Nutrition Services $144,939 - 0
93.044 Special Programs for the Aging Title Iii, Part B Grants for Supportive Services and Senior Centers $119,677 - 0
84.181 Special Education - Grants for Infants and Families $91,555 - 0
20.507 Bus and Bus Facilities Formula Program (5339) $81,630 Yes 0
93.568 Low Income Home Energy Assistance $80,988 - 0
93.575 Child Care Administration & Operations $79,835 - 0
97.042 Emergency Management Performance Grant Ffy2022 $77,995 - 0
10.664 Native Tree Planting in the Ozaukee County Hawthorne Hills County Park Project Area $63,089 - 0
15.662 Enhancing Habitat Restoration Benefits Through Invasive Species Management $60,235 - 0
93.658 Foster Care (title IV-E) $57,975 - 0
15.662 Ozaukee County Fish Passage Project $53,752 - 0
93.556 Promoting Safe and Stable Families $52,345 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $50,980 - 0
93.958 Block Grants for Community Mental Health Services $50,158 - 0
15.608 Milwaukee River Mequon- Thiensville Dam Fishway Enhancement $49,880 - 0
66.469 Little Menomonee River Corridor Ecosystem Restoration - Milwaukee $49,825 - 0
93.069 Public Health Emergency Preparedness $48,613 - 0
66.469 River Corridor Ecosystem Restoration - Milwaukee County Lmr Section 1 $47,110 - 0
93.053 Nutrition Services Incentive Program $46,427 - 0
20.507 Federal Transit Capital Investment Grants $44,820 Yes 0
93.994 Maternal and Child Health Services Block Grant to the States $43,891 - 0
93.767 Children's Health Insurance Program $35,878 - 0
93.268 Capacity Building Assistance to Strengthen Public Health Immunization $35,011 - 0
93.558 Temporary Assistance for Needy Families (tanf) $30,464 - 0
11.419 Wi Coastal Management Program $30,000 - 0
10.561 Im Arpa Funds $29,025 - 0
16.922 Equitable Sharing Program $22,316 - 0
10.902 Soil and Water Conservation $15,654 - 0
66.472 Beach Monitoring and Notification Program $15,000 - 0
93.991 Preventive Health and Health Services Block Grant $13,860 - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $12,838 - 0
15.623 Tendick Nature County Park Prairie Restoration $10,432 - 0
11.419 Wcmp Meekwon Stormwater Grant $9,358 - 0
93.556 Relative Caregiver Support Group $7,520 - 0
66.032 State Indoor Radon Grants $7,258 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $7,165 - 0
93.043 Special Programs for the Aging Title Iii, Part D Disease Prevention and Health Promotion Services $7,163 - 0
93.747 Covid Support Aps $6,902 - 0
15.662 National Fish and Wildlife Foundation $6,334 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $6,146 - 0
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $5,139 - 0
93.575 Child Care Fraud $4,813 - 0
10.561 Im Arpa Overtime $3,499 - 0
93.324 State Health Assistance Program $3,218 - 0
93.071 Medicare Enrollment Assistance Program $3,155 - 0
93.558 Temporary Assistance for Needy Families $2,937 - 0
93.898 Cancer Prevention and Control Programs $2,913 - 0
66.469 Restoring Fish and Aquatic Life Passage at Sucker Creek in the Town of Port Washington and Silver Beach Creek in the Town of Belgiu $2,794 - 0
10.664 Usda Forest Service (usfs) & Great Lakes Restoration Initiative (glri) $2,295 - 0
93.747 Covid Arp Aps $2,140 - 0
93.575 Child Care Certification $846 - 0
93.575 Cc Inclusive Birth to 3 Child Care Pilot Program $640 - 0
10.664 State and Private Forestry - Meekwon County Park Project Area - Ph III $116 - 0
93.563 Child Support Enforcement (title IV-D) $-56,487 - 0

Contacts

Name Title Type
GW2QBT46RKR1 Jay McMahon, Cpa, Mba Auditee
2622848235 Greg Pitel, CPA Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with expenditures reported in the Countys 2022 fund financial statements. Accounts receivable 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 years 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 auditee did not use the de minimis cost rate. 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: Expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with expenditures reported in the Countys 2022 fund financial statements. Accounts receivable 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 years 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 auditee did not use the de minimis cost rate. The federal and state oversight agencies for the County are as follows: Federal - U.S. Department of Justice State - Wisconsin Department of Health Services
Title: Title 19 Medical Assistant Payments Accounting Policies: Expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with expenditures reported in the Countys 2022 fund financial statements. Accounts receivable 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 years 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 auditee did not use the de minimis cost rate. The Schedules of Expenditures of Federal and State Awards do not include repayments received by the Countys Human Service Department for Title 19 Medical Assistance programs. The payments are considered a contract for services between the State and the County and therefore are not reported as federal or state awards.
Title: Pass Through Entities Accounting Policies: Expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with expenditures reported in the Countys 2022 fund financial statements. Accounts receivable 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 years 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 auditee did not use the de minimis cost rate. Federal awards have been passed through the following entities:GWAAR - Greater Wisconsin Agency on Aging ResourcesWI DCF - Wisconsin Department of Children and FamiliesWI DHS - Wisconsin Department of Health ServicesWI DMA - Wisconsin Department of Military AffairsWI DNR - Wisconsin Department of Natural ResourcesWI DOA - Wisconsin Department of AdministrationWI DOJ - Wisconsin Department of JusticeWI DOT - Wisconsin Department of Transportation
Title: State Direct Payments Accounting Policies: Expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with expenditures reported in the Countys 2022 fund financial statements. Accounts receivable 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 years 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 auditee did not use the de minimis cost rate. 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 in the Schedules of Expenditures of Federal and State Awards.
Title: State of Wisconsin Community Aids Reporting System Accounting Policies: Expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with expenditures reported in the Countys 2022 fund financial statements. Accounts receivable 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 years 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 auditee did not use the de minimis cost rate. The Wisconsin Departments of Health Services (DHS) and Children and Families (DCF) utilize the Community Aids Reporting System (CARS) and the System for Payments and Reports of Contracts (SPARC) for reimbursing the County for various federal and state program expenditures. The expenditures reported on the Schedules of Expenditures of Federal and State Awards for various DHS & DCF programs agree with the expenditures reported on the May 2023 CARS for the Human Services and Public Health Departments, and the December 2022 SPARC for Child Support and Child Care programs.
Title: Indirect Cost Rate Accounting Policies: Expenditures in the schedules are presented in accordance with the modified accrual basis of accounting and are generally in agreement with expenditures reported in the Countys 2022 fund financial statements. Accounts receivable 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 years 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 auditee did not use the de minimis cost rate. A nonfederal and state entity may have a federal and stately negotiated indirect cost rate that is being used for federal and state awards. In general, under 2 CFR 200.414(f), if an entity has never received a negotiated indirect cost rate, the entity may elect to use a 10% de minimis indirect cost rate. Further, 2 CFR 200.510(b)(6) states that the notes to the schedule of expenditures of federal and state awards must include whether or not the nonfederal and state entity has elected to use the 10% de minimis indirect cost rate. The County has elected not to use the 10% de minimis indirect cost rate and allocates indirect costs on a cost allocation plan.