Audit 350264

FY End
2024-06-30
Total Expended
$27.59M
Findings
0
Programs
27
Organization: City of Berkeley (CA)
Year: 2024 Accepted: 2025-03-28

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 $5.59M Yes 0
20.205 Highway Planning and Construction $3.28M Yes 0
14.238 Shelter Plus Care $885,012 - 0
11.307 Economic Adjustment Assistance $669,157 Yes 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $617,282 Yes 0
93.268 Immunization Cooperative Agreements $413,639 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $392,555 - 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $184,671 - 0
20.600 State and Community Highway Safety $171,934 - 0
93.778 Medical Assistance Program $148,676 - 0
97.044 Assistance to Firefighters Grant $147,424 - 0
93.945 Assistance Programs for Chronic Disease Prevention and Control $119,791 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $100,808 - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $90,218 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $86,571 - 0
14.239 Home Investment Partnerships Program $65,998 - 0
93.217 Family Planning_services $48,596 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $47,054 - 0
93.074 Hospital Preparedness Program (hpp) and Public Health Emergency Preparedness (phep) Aligned Cooperative Agreements $32,945 - 0
97.039 Hazard Mitigation Grant $31,118 Yes 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $19,715 - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $0 - 0
14.218 Community Development Block Grants/entitlement Grants $0 - 0
14.231 Emergency Solutions Grant Program $0 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $0 - 0
93.994 Maternal and Child Health Services Block Grant to the States $0 - 0
93.569 Community Services Block Grant $0 - 0

Contacts

Name Title Type
KC7DYLV9EF25 Henry Oyekanmi Auditee
5109817300 Mitesh Desai Auditor
No contacts on file

Notes to SEFA

Title: 1. REPORTING ENTITY Accounting Policies: Funds received under the various grant programs have been recorded within the general, special revenue, capital projects, and enterprise funds of the City. The City utilizes the modified accrual basis of accounting for the general, special revenue, and capital project funds. The accrual basis of accounting is used for the enterprise fund. The accompanying Schedule of Expenditures of Federal Awards (Schedule) is presented in accordance with the requirements of the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). De Minimis Rate Used: N Rate Explanation: The City did not elect to use the 10% de minimis indirect cost rate. The financial reporting entity, as defined by Governmental Accounting Standards Board (GASB), consists of the primary government, which is the City of Berkeley (City), organizations for which the primary government is financially accountable, and other organizations for which the nature and significance of their relationship with the primary government are such that exclusion would cause the reporting entity’s financial statements to be misleading or incomplete. The City of Berkeley Rent Stabilization Board is the only component unit of the City.
Title: 2. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES Accounting Policies: Funds received under the various grant programs have been recorded within the general, special revenue, capital projects, and enterprise funds of the City. The City utilizes the modified accrual basis of accounting for the general, special revenue, and capital project funds. The accrual basis of accounting is used for the enterprise fund. The accompanying Schedule of Expenditures of Federal Awards (Schedule) is presented in accordance with the requirements of the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). De Minimis Rate Used: N Rate Explanation: The City did not elect to use the 10% de minimis indirect cost rate. Basis of Accounting Funds received under the various grant programs have been recorded within the general, special revenue, capital projects, and enterprise funds of the City. The City utilizes the modified accrual basis of accounting for the general, special revenue, and capital project funds. The accrual basis of accounting is used for the enterprise fund. The accompanying Schedule of Expenditures of Federal Awards (Schedule) is presented in accordance with the requirements of the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Schedule of Expenditures of Federal Awards The accompanying Schedule presents the activity of all Federal financial assistance programs of the City. Federal financial assistance received directly from Federal agencies as well as Federal financial assistance passed through the State of California and other agencies are included in the Schedule. The Schedule of Expenditures of Federal Awards was prepared from only the accounts of various grant programs and, therefore, does not present the financial position or results of operations of the City.
Title: 3. INDIRECT COSTS Accounting Policies: Funds received under the various grant programs have been recorded within the general, special revenue, capital projects, and enterprise funds of the City. The City utilizes the modified accrual basis of accounting for the general, special revenue, and capital project funds. The accrual basis of accounting is used for the enterprise fund. The accompanying Schedule of Expenditures of Federal Awards (Schedule) is presented in accordance with the requirements of the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). De Minimis Rate Used: N Rate Explanation: The City did not elect to use the 10% de minimis indirect cost rate. The City did not elect to use the 10% de minimis indirect cost rate.
Title: 4. CALCULATION OF FEDERAL EXPENDITURES – ALN 11.307 Accounting Policies: Funds received under the various grant programs have been recorded within the general, special revenue, capital projects, and enterprise funds of the City. The City utilizes the modified accrual basis of accounting for the general, special revenue, and capital project funds. The accrual basis of accounting is used for the enterprise fund. The accompanying Schedule of Expenditures of Federal Awards (Schedule) is presented in accordance with the requirements of the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). De Minimis Rate Used: N Rate Explanation: The City did not elect to use the 10% de minimis indirect cost rate. Federal expenditures for the Business Economic Development Administration Revolving Loan Fund (ALN 11.307) were calculated as follows per program requirements: