C
ITY OF ALAMEDA
SINGLE AUDIT REPORT
FOR THE YEAR ENDED JUNE 30, 2023
This Page Left Intentionally Blank
C
ITY OF ALAMEDA
SINGLE AUDIT REPORT
For the Year Ended June 30, 2023
TABLE OF CONTENTS
Pag
e
Schedule of Findings and Questioned Costs .............................................................................. 1 Section I – Summary of Auditor’s Results .......................................................................... 1 Section II – Financial Statement Findings ........................................................................... 2 Section III – Federal Award Findings and Questioned Costs ............................................. 2 Schedule of Expenditures of Federal Awards ............................................................................ 3 Notes to the Schedule of Expenditures of Federal Awards ........................................................ 5 Independent Auditor’s Report on Internal Control over Financial Reporting and Report on Compliance and Other Matters Based on an Audit of Financial Statements Performed in Accordance with Government Auditing Standards ................. 7 Independent Auditor's Report on Compliance for Each Major Federal Program; Report on Internal Control Over Compliance; and Report on the Schedule of Expenditures of Federal Awards Required by the Uniform Guidance ...... 9 This Page Left Intentionally Blank
CITY OF ALAMEDA
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
For the Year Ended June 30, 2023
SECTION I – SUMMARY OF AUDITOR’S RESULTS
SECTION I—SUMMARY OF AUDITOR’S RESULTS
Financial Statements
Type of
report the auditor issued on whether the financial
statements audited were prepared in accordance with GAAP Unmodified Internal control over financial reporting:
• Mate
rial weakness(es) identified? Yes X No
• Signific
ant deficiency(ies) identified? X Yes
None
Reported
Noncompliance material to financial statements noted? Yes X No Fede
ral Awards
Internal control over major federal programs:
• Material weakness(es) identified? Yes X No
• Significant deficiency(ies) identified? Yes X
None
Reported
Type of
auditor’s report issued on compliance for major
federal programs: Unmodified
Any audit find
ings disclosed that are required to be reported
in accordance with 2 CFR 200.516(a)? Yes X No
Identifi
cation of major program(s):
Assistance
Listing
Number(s) Name of Federal Program or Cluster
21.027 COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Dollar threshold used to d
istinguish between type A and type B programs: $798,410 Auditee qualified
as low-risk auditee? Yes X No
1 SECTION II – FINANCIAL STATEMENT FINDINGS
Our audit did disclose significant de ficiencies, but no material weakne sses or instances of noncompliance material to the basic financial statements. We have also issued a separate Memorandum on Internal Control dated February 29, 2024, which is an integral part of our audits and should be read in conjunction with this report.
SECTION III – FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Our audit did not disclose any findings or questioned costs required to be reported in accordance with Uniform Guidance.
2 CITY OF ALAMEDA
SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
For the Fiscal Year Ended June 30, 2023
Federal Pass-Through Pass-Throu gh
Federal Grantor/ Assistance Listing Identifying To Federal Pass-Through Grantor/Program or Cluster Title Number Number Subrecipients Ex penditures Department of Housing and Urban Development Direct Program:
CDBG -Entitlement Grants Cluster
Community Development Block Grants (CDBG)/ Entitlement Grant 14.218 Subgrants $355,682 $355,682
Program Expenditures 1,042,154
Loan Program Unexpended Cash Balance 495,652
Loan Program Balance, Beginning of Year 1,943,069
COVID-19 - CDBG-CV Program Expenditures 6,574 6,751
CDBG -Entitlem
ent Grants Cluster subtotal 362,256 3,843,308
Department of Housing and Urban Development Pass-Through Programs from:
County of Alameda
HOME Investment Partnerships Program 14.239
Program Expenditures M22DC060201 11,065
Loan Program Balance, Beginning of Year M22DC060201 6,962,076 Program subtotal 6,973,141
Total Department of Housing and Urban Development 362,256 10,816,449 Department of Interior National Park Service Direct Program:
Preservation of Japanese American Confinement Sites 15.933 83,228 Department of Justice Direct Programs:
COVID-19 - Coronavirus Emergency Supplemental Funding 16.034 41,660 Edward Byrne Memorial Justice Assistance Grant Program 16.738 17,389 Total Department of Justice 59,049
Department of Transportation Pass-Through Programs from:
State of California, Department of Transportation
Highway Planning and Construction (Federal-Aid Highway Program) 20.205 Clement Ave Complete Streets CML-5014(046) 4,029
Central Avenue Safety Improvements ATPL-5014(047) 300,000 Program subtotal 304,029
California Office of Traffic Safety
Highway Safety Cluster
State and Community Highway Safety 20.600 PT21002 6,960 National Priority Safety Program 20.616 TR21001 24,800
National Priority Safety Program 20.616 TR22030 35,205
Highway Safety Cluster subtotal 66,965
Minimum Penalties for Repeat Offenders for Driving While Intoxicated 20.608 PT21002 3,480 Total Department of Transportation 374,474
Department of the Treasury Direct Program:
COVID-19 - Coronavirus State and Local Fiscal Recovery Funds 21.027 6,119,980 14,698,270 National Endowment for the Humanities Pass-Through Program From:
California State Library
Grants to States 45.310 45.310 10,000
Department of Health and Human Services Pass-Through Program From:
Aging Cluster:
Alameda County Social Services Agency
Special Programs for the Aging Title III, Part B,
Grants for Supportive Services and Senior Centers 93.044 1901CAOASS-01 39,684 Department of Homeland Security Pass-Through Program from:
California Governor's Office of Emergency Services
Disaster Grants - Public Assistance (Presidentially Declared Disasters) 97.036 FEMA-4482-DR-CA 127,957 Department of Homeland Security Direct Programs:
Homeland Security Grant Program (HSGP) 97.067 11,969
Staffing for Adequate Fire and Emergency Response (SAFER) Grant 97.083 392,578 Total Department of Homeland Security 532,504
Total Expenditures of Federal Awards $6,482,236 $26,613,658 See Accompanying Notes to Schedule of Expenditures of Federal Awards 3 This Page Left Intentionally Blank
CITY OF ALAMEDA
NOTES TO THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS For The Year Ended June 30, 2023
NOTE 1 – REPORTING ENTITY
The Schedule of Expenditure of Federal Awards (the Schedule) includes expenditures of federal awards for the City of Alameda, California, and its component un its as disclosed in the notes to the Basic Financial Statements, except for federal awards of the federal awards of the Alameda Municipal Power (AMP) Enterprise Fund. Federal awards expended by AMP, if any, are excluded from the Schedule and are subject to a separate audit of compliance.
NOTE 2 – SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
Basis of accounting refers to when revenues and expenditures or expenses are recognized in the accounts and reported in the financial statements , regardless of the measurement fo cus applied. The governmental fund financial statements are reported using the current financial resources measurement focus and the modified accrual basis of accounting . The proprietary and fiduciary fund financial statements are reported using the economic resources measurement focus and the accrual basis of accounting. Expenditures of Federal Awards reported on the Schedule are recognized when incurred.
NOTE 3 – INDIRECT COST ELECTION
The City has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance.
NOTE 4 – OUTSTANDING LOANS OF FEDERAL FUNDS AT JUNE 30, 2023 The following loan programs balances and transactions relating to these programs are included in City’s basic financial statements. Loans outstanding at the beginning of the year and loans made during the year are included in the federal expenditures presented in the Schedule. The balance of loans outstanding at June 30, 2023 consists of the following:
CFDA
Numbe
r Program Name
Outstanding
Balance
at Jun
e 30,
2023
14.218 Community Development Block Gr ants/Entitlement Grants $2,269,066
14.239 HOME Investment Partnerships Program 6,885,469
5 This Page Left Intentionally Blank
INDEPENDENT AUDITOR’S REPORT ON
INTERNAL CONTROL OVER FINANCIAL REPORTING
AND ON COMPLIANCE AND OTHER MATTERS BASED ON AN
AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE
WITH GOVERNMENT AUDITING STANDARDS
To the Honorable Members of the City Council
City of Alameda, California
We have audited, in accordance with the auditing st andards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards issued by the Comptroller General of the United States, the financial statements of the governmental activities, the business-type activities, each major fund, and the aggr egate remaining fund information of the City of Alameda, California, as of and for the year ended J une 30, 2023, and the related notes to the financial statements, which collectively comprise the City’s basic financial statements, and have issued our report thereon dated February 29, 2024. Our report included an emphasis of a matter paragraph disclosing the implementation of new accounting principles.
Report on Internal Control over Financial Reporting
In planning and performing our audit of the financial statements, we considered the City’s internal control over financial reporting (internal control) as a basis for designing audit procedures that are appropriate in the circumstances for the purpose of expressing our opinions on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the City’s internal control. Accordingly, we do not express an opinion on the effectiveness of the City’s internal control.
A deficiency in internal control exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, misstatements on a timely basis. A material weakness is a deficiency, or a combination of deficiencies, in internal control such that there is a reasonable possibility that a material misstatement of the City’s financial statements will not be prevented, or detected and corrected on a timely basis. A significant deficiency is a deficiency, or a combination of deficiencies, in internal control that is less severe than a material weakness, yet important enough to merit attention by those charged with governance.
Our consideration of internal control was for the lim ited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control that might be material weaknesses or significant deficiencies and therefore, material we aknesses or significant deficiencies may exist that were not identified. Given these limitations, during our audit we did not identify any deficiencies in internal control that we consider to be material weaknesses. We iden tified certain deficiencies in internal control that we consider to be significant deficiencies as listed on the Schedule of Significant Deficiencies included as part of our separately issued Memorandum on Internal Control date d February 29, 2024 which is an integral part of our audit and should be read in conjunction with this report. 7 Report on Compliance and Other Matters
As part of obtaining reasonable assurance about whether th e City’s financial statements are free from material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have a direct and material effect on the financial statements. However, providing an opinion on compliance with those provisions was not an objective of our audit, and accordingly, we do not express such an opinion.
The results of our tests disclosed no instances of noncompliance that are requi red to be reported under Government Auditing Standards.
City’s Response to Findings
Government Auditing Standards require the auditor to perform limited procedures on the City’s response to the findings identified in our audit and described in our separately issu ed Memorandum on Internal Control dated February 29, 2024, which is an integral part of our audit and should be read in conjunction with this report.
The City’s response was not subjected to the other aud iting procedures applied in the audit of the financial statements and, accordingly, we express no opinion on the response.
Purpose of this Report
The purpose of this report is solely to describe the scope of our testing of internal control and compliance and the result of that testing, and not to provide an opinion on the effectiveness of the City’s internal control or on compliance. This report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the City’s internal control and compliance. Accordingly, this communication is not suitable for any other purpose.
Pleasant Hill
, California
February 29, 2024
8 INDEPENDENT AUDITOR'S REPORT
ON COMPLIANCE FOR EACH MAJOR PROGRAM;
REPORT ON INTERNAL CONTROL OVER COMPLIANCE;
AND REPORT ON THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
REQUIRED BY THE UNIFORM GUIDANCE
To the Honorable Members of the City Council
City of Alameda, California
Report on Compliance for Each Major Federal Program
Opinion on Each Major Federal Program
We have audited City of Alameda’s compliance with the types of compliance requirements identified as subject to audit in the OMB Compliance Supplement that could have a direct and material effect on each of the City’s major federal programs for the year ended June 30,2023. The City’s major federal programs are identified in the summary of auditor’s results s ection of the accompanying Schedule of Findings and Questioned Costs.
The City of Alameda’s basic financial statements include the operations of the Alameda Municipal Power (AMP) Enterprise Fund, which received no federal awards during the year ended June 30, 2023. Our audit, described below, did not include the operations of AM P, because AMP is subject to a separate audit of compliance.
In our opinion, the City complied, in all material respects, with the compliance requirements referred to above that could have a direct and material effect on each of its major federal programs for the year ended June 30, 2023.
Basis for Opinion on Each Major Federal Program
We conducted our audit of compliance in accordance with auditing standards generally accepted in the United States of America (GAAS); the standards app licable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States ( Government Auditing Standards); and the audit requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and A udit Requirements for Federal Awards (Uniform Guidance). Our responsibilities under those standards and the Uniform Guidance are further descr ibed in the Auditor’s Responsibilities for the Audit of Compliance section of our report.
We are required to be independent of the City and to meet our other ethical responsibilities, in accordance with relevant ethical requirements relating to our audit. We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our opinion on compliance for each major federal program.
Our audit does not provide a legal determination of th e City’s compliance with the compliance requirements referred to above.
Responsibilities of Management for Compliance
Management is responsible for compliance with the requirements referred to above and for the design, implementation, and maintenance of effective internal control over compliance with the requirements of laws, statutes, regulations, rules and provisions of contracts or grant agreements applicable to the City’s federal programs.
9 Auditor’s Responsibilities for the Audit of Compliance Our objectives are to obtain reasonable assurance about whether material noncompliance with the compliance requirements referred to above occurred, whether due to fraud or error, and expr ess an opinion on the City’s compliance based on our audit. Reasonable assurance is a high level of assurance but is not absolute assurance and therefore is not a guarantee that an audit conducted in accordance with GAAS, Government Auditing Standards, and the Uniform Guidance will always detect material noncompliance when it exists. The risk of not detecting material noncompliance resulting from fraud is higher than for that resulting from error, as fraud may involve collusion, forgery, intentional omissions, misrepresenta tions, or the override of internal control. Noncompliance with the compliance requirements referred to above is considered material, if there is a substantial likelihood that, individually or in the aggregate, it would influence the judgment made by a reasonable user of the report on compliance about the C ity’s compliance with the requirements of each major federal program as a whole.
In performing an audit in accordance with GAAS, Government Auditing Standards , and the Uniform Guidance, we:
• Exercise professional judgment and maintain professional skepticism throughout the audit. • Identify and assess the risks of material noncompliance, whether due to fraud or error, and design and perform audit procedures responsive to those risks. Such procedures include examining, on a test basis, evidence regarding the City’s compliance with the compliance requirements referred to above and performing such other procedures as we considered necessary in the circumstances. • Obtain an understanding of the City’s internal cont rol over compliance relevant to the audi t in order to design audit procedures that are appropriate in th e circumstances and to test and report on internal control over compliance in accordance with the Uniform Guidance, but not for the purpose of expressing an opinion on the effectiveness of the City’s internal control over compliance.
Accordingly, no such opinion is expressed.
We are required to communicate with those charged with governance regarding, among other matters, the planned scope and timing of the audit and any significant deficiencies and material weaknesses in internal control over compliance that we identified during the audit.
Report on Internal Control Over Compliance
A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis. A material weakness in internal control over compliance is a deficiency, or a combination of deficiencies, in internal control over compliance, such that there is a reasonable possibility that material noncompliance with a type of compliance requirement of a federal program will not be prevented, or detected and corrected, on a timely basis. A significant deficiency in internal control over compliance is a deficiency, or a combination of deficiencies, in internal control over compliance with a type of compliance requirement of a federal program that is less severe than a material weakness in internal control over compliance, yet important enough to merit attention by those charged with governance. 10 Our consideration of internal control over compliance was for the limited purpose described in the Auditor’s Responsibilities for the Audit of Compliance section above and was not designed to identify all deficiencies in internal control over compliance that might be material weaknesses or significant deficiencies in internal control over compliance. Given these limitations, during our audit we did not identify any deficiencies in internal control over compliance that we consider to be material weaknesses, as defined above. However, material weaknesses or significant deficiencies in intern al control over compliance may exist that were not identified.
Our audit was not designed for the purpose of expressing an opinion on the effectiveness of internal control over compliance. Accordingly, no such opinion is expressed.
The purpose of this report on internal control over compliance is solely to describe the scope of our testing of internal control over compliance and the results of that testing based on the requirements of the Uniform Guidance. Accordingly, this report is not suitable for any other purpose.
Report on Schedule of Expenditures of Federal Awards Required by the Uniform Guidance We have audited the financial stat ements of the governmental activiti es, the business-type activities, each major fund, and the aggregate remaining funds informati on of the City as of and for the year ended June 30, 2023, and the related notes to the financial statements, which collectively comprise the City’s basic financial statements. We issued our report thereon dated Febr uary 29, 2024, which contained an unmodified opinion on those financial statements. Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the basic financial statements. The accompanying schedule of expenditures of federal awards is presented for purposes of additional analysis as required by the Uniform Guidance and is not a required part of the basic financial statements. Such information is the responsibility of management and was derived from and relates directly to the underlying accounting and other records used to prepare the basic financial statements. The information has been subjected to the auditing procedures applied in the audit of the basic financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the basic financial statements or to the basic financial stat ements themselves, and other additional procedures in accordance with auditing standards gene rally accepted in the United States of America. In our opinion, the schedule of expenditures of federal awards is fairly st ated, in all material respects in relation to the basic financial statements as a whole.
Pleasan
t Hill, California
April 1, 2024
11 This Page Left Intentionally Blank