Audit 302780

FY End
2023-06-30
Total Expended
$517.39M
Findings
0
Programs
79
Organization: County of Alameda, California (CA)
Year: 2023 Accepted: 2024-04-06

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 $85.66M Yes 0
93.563 Child Support Enforcement $16.58M - 0
93.659 Adoption Assistance $13.23M - 0
93.747 Elder Abuse Prevention Interventions Program $9.84M - 0
93.914 Hiv Emergency Relief Project Grants $6.72M - 0
93.224 Consolidated Health Centers (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $5.88M - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $4.84M - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $2.65M - 0
21.019 Coronavirus Relief Fund $2.27M - 0
66.468 Capitalization Grants for Drinking Water State Revolving Funds $2.10M - 0
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $2.05M - 0
93.958 Block Grants for Community Mental Health Services $1.68M - 0
16.710 Public Safety Partnership and Community Policing Grants $1.37M - 0
16.320 Services for Trafficking Victims $1.29M - 0
93.917 Hiv Care Formula Grants $1.25M - 0
93.667 Social Services Block Grant $1.25M Yes 0
93.926 Healthy Start Initiative $1.21M - 0
93.137 Community Programs to Improve Minority Health Grant Program $1.16M - 0
93.686 Ending the Hiv Epidemic: A Plan for America — Ryan White Hiv/aids Program Parts A and B (b) $1.12M - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $1.09M - 0
17.259 Wia Youth Activities $967,658 - 0
16.812 Second Chance Act Reentry Initiative $923,655 - 0
93.495 Community Health Workers for Public Health Response and Resilient $862,253 - 0
93.994 Maternal and Child Health Services Block Grant to the States $839,778 Yes 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $836,333 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $826,462 - 0
93.556 Promoting Safe and Stable Families $819,179 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $784,454 - 0
93.940 Hiv Prevention Activities_health Department Based $734,065 - 0
14.276 Youth Homelessness Demonstration Program $640,777 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $585,200 - 0
97.042 Emergency Management Performance Grants $550,136 - 0
17.258 Wia Adult Program $531,070 - 0
93.053 Nutrition Services Incentive Program $525,468 - 0
93.268 Immunization Cooperative Agreements $491,744 Yes 0
10.331 Food Insecurity Nutrition Incentive Grants Program $464,296 - 0
93.889 National Bioterrorism Hospital Preparedness Program $380,685 - 0
16.734 Special Data Collections and Statistical Studies $376,032 - 0
93.558 Temporary Assistance for Needy Families $346,155 Yes 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $297,965 - 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $272,320 - 0
93.150 Projects for Assistance in Transition From Homelessness (path) $270,001 - 0
93.855 Allergy, Immunology and Transplantation Research $263,776 - 0
14.267 Continuum of Care Program $238,600 - 0
10.555 National School Lunch Program $222,366 - 0
84.215 Fund for the Improvement of Education $189,985 - 0
16.741 Dna Backlog Reduction Program $176,197 - 0
93.643 Children's Justice Grants to States $165,754 - 0
93.069 Public Health Emergency Preparedness $165,688 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $165,105 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $163,270 Yes 0
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $156,595 - 0
17.277 Workforce Investment Act (wia) National Emergency Grants $143,873 - 0
93.526 Affordable Care Act (aca) Grants for Capital Development in Health Centers $138,174 - 0
93.090 Guardianship Assistance $128,708 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $108,205 - 0
16.842 Opioid Affected Youth Initiative $100,631 - 0
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation’s Health $100,000 - 0
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $99,160 - 0
16.575 Crime Victim Assistance $97,000 - 0
93.324 State Health Insurance Assistance Program $90,515 - 0
93.071 Medicare Enrollment Assistance Program $89,264 - 0
17.235 Senior Community Service Employment Program $76,072 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $67,691 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $62,399 - 0
93.042 Special Programs for the Aging_title Vii, Chapter 2_long Term Care Ombudsman Services for Older Individuals $61,583 - 0
17.278 Wia Dislocated Worker Formula Grants $58,385 - 0
93.778 Medical Assistance Program $45,477 - 0
21.009 Volunteer Income Tax Assistance (vita) Matching Grant Program $37,311 - 0
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $28,807 - 0
93.566 Refugee and Entrant Assistance_state Administered Programs $21,855 Yes 0
93.041 Special Programs for the Aging_title Vii, Chapter 3_programs for Prevention of Elder Abuse, Neglect, and Exploitation $21,472 - 0
20.205 Highway Planning and Construction $19,868 - 0
97.067 Homeland Security Grant Program $12,408 - 0
16.839 Stop School Violence $8,243 - 0
45.310 Grants to States $7,986 - 0
10.025 Plant and Animal Disease, Pest Control, and Animal Care $2,800 - 0
93.658 Foster Care_title IV-E $2,559 Yes 0
97.056 Port Security Grant Program $937 - 0

Contacts

Name Title Type
ZK45GWUKWMH2 Melissa Wilk Auditee
5102726565 Annie Louie Auditor
No contacts on file

Notes to SEFA

Title: 1.GENERAL Accounting Policies: The accompanying SEFA is presented using the modified accrual basis of accounting, which is described in note 1(C) to the County’s basic financial statements. De Minimis Rate Used: Both Rate Explanation: The County did not elect to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs, with the exception of the following departments: • District Attorney’s Office • Sheriff’s Office The accompanying Schedule of Expenditures of Federal Awards (SEFA) presents the expenditures for all federal award programs of the County of Alameda (the County), except as discussed (in notes 6 and 7). The County’s financial reporting entity is defined in note 1(A) to the County’s basic financial statements. The County’s basic financial statements include the operations of the Alameda County Housing and Community Development Department and Alameda County Healthy Homes which, during the year ended June 30, 2023, expended $73,562,152 and $738,445 in federal awards, respectively. These federal expenditures are not included in the accompanying schedule. Additionally, Medical Assistance (Medi-Cal) and Medicare Hospital Insurance (Medicare) are not considered federal awards (note 4).
Title: 2.BASIS OF ACCOUNTING Accounting Policies: The accompanying SEFA is presented using the modified accrual basis of accounting, which is described in note 1(C) to the County’s basic financial statements. De Minimis Rate Used: Both Rate Explanation: The County did not elect to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs, with the exception of the following departments: • District Attorney’s Office • Sheriff’s Office The accompanying SEFA is presented using the modified accrual basis of accounting, which is described in note 1(C) to the County’s basic financial statements. The County did not elect to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs, with the exception of the following departments: • District Attorney’s Office. • Sheriff’s Office
Title: 3.RELATIONSHIP TO FEDERAL FINANCIAL REPORTS AND FINANCIAL STATEMENTS Accounting Policies: The accompanying SEFA is presented using the modified accrual basis of accounting, which is described in note 1(C) to the County’s basic financial statements. De Minimis Rate Used: Both Rate Explanation: The County did not elect to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs, with the exception of the following departments: • District Attorney’s Office • Sheriff’s Office Expenditures of federal awards are reported in the County’s basic financial statements in the general fund and other governmental funds. Amounts reported in the accompanying SEFA agree or can be reconciled with amounts reported in the related federal award reports and the County’s basic financial statements.
Title: 4.MEDI-CAL AND MEDICARE Accounting Policies: The accompanying SEFA is presented using the modified accrual basis of accounting, which is described in note 1(C) to the County’s basic financial statements. De Minimis Rate Used: Both Rate Explanation: The County did not elect to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs, with the exception of the following departments: • District Attorney’s Office • Sheriff’s Office Medi-Cal and Medicare program expenditures are excluded from the SEFA. These expenditures represent fees for services; therefore, neither is considered a federal award program of the County for the purposes of the SEFA or in determining major programs. The County assists the State of California in determining eligibility and provides Medi-Cal and Medicare services through County-owned health facilities. Medi-Cal administrative expenditures are included in the SEFA under assistance listing no. 93.778 as they do not represent fees for services.
Title: 5.OTHER CLUSTER DESIGNATED BY THE STATE OF CALIFORNIA Accounting Policies: The accompanying SEFA is presented using the modified accrual basis of accounting, which is described in note 1(C) to the County’s basic financial statements. De Minimis Rate Used: Both Rate Explanation: The County did not elect to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs, with the exception of the following departments: • District Attorney’s Office • Sheriff’s Office The SEFA includes the State-designated Aging Cluster, which is different from Part 5 of the 2023 OMB Compliance Supplement, as permitted by the Uniform Guidance in 2 CFR 200.1. The State-designated Aging Cluster includes assistance listing numbers 93.041, 93.042, 93.043, 93.044, 93.045, 93.052, and 93.053.
Title: 6.FEDERAL EXPENDITURES OF THE ALAMEDA COUNTY HOUSING & COMMUNITY DEVELOPMENT DEPARTMENT NOT INCLUDED IN THE COUNTY'S SEFA Accounting Policies: The accompanying SEFA is presented using the modified accrual basis of accounting, which is described in note 1(C) to the County’s basic financial statements. De Minimis Rate Used: Both Rate Explanation: The County did not elect to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs, with the exception of the following departments: • District Attorney’s Office • Sheriff’s Office The Alameda County Housing & Community Development Department (the Department) federal expenditures are excluded from the County’s SEFA because such expenditures are audited separately. Expenditures for the programs of the Department listed below are taken from the separate single audit report for the year ended June 30, 2023. The programs of the Department are as follows:
Title: 7.FEDERAL EXPENDITURES OF THE ALAMEDA COUNTY HEALTHY HOMES NOT INCLUDED IN THE COUNTY'S SEFA Accounting Policies: The accompanying SEFA is presented using the modified accrual basis of accounting, which is described in note 1(C) to the County’s basic financial statements. De Minimis Rate Used: Both Rate Explanation: The County did not elect to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs, with the exception of the following departments: • District Attorney’s Office • Sheriff’s Office The Alameda County Healthy Homes (“the Program”) federal expenditures are excluded from the County’s SEFA because such expenditures are audited separately. Expenditures for the Program for the year ended June 30, 2023 were less than the $750,000 threshold requiring a single audit. The data below is taken from the Program’s transaction records for the year ended June 30, 2023:
Title: 8.DEPARTMENT OF AGING FEDERAL/STATE SHARE Accounting Policies: The accompanying SEFA is presented using the modified accrual basis of accounting, which is described in note 1(C) to the County’s basic financial statements. De Minimis Rate Used: Both Rate Explanation: The County did not elect to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs, with the exception of the following departments: • District Attorney’s Office • Sheriff’s Office The California Department of Aging (CDA) requires agencies that receive CDA funding to display state-funded expenditures discretely along with federal expenditures. The County expended the following federal and state amounts under these grants in the year ended June 30, 2023.
Title: 9.CLUSTER PROGRAM TOTALS Accounting Policies: The accompanying SEFA is presented using the modified accrual basis of accounting, which is described in note 1(C) to the County’s basic financial statements. De Minimis Rate Used: Both Rate Explanation: The County did not elect to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs, with the exception of the following departments: • District Attorney’s Office • Sheriff’s Office The following table summarizes clusters funded by various sources or grants whose totals are not shown on the SEFA: