Cities Index.
B - FY 2020-21 GAGAS Report

Cupertino City Council
May 17, 2022

Document
B - FY 2020-21 GAGAS Report
Meeting
May 17, 2022
Body
Cupertino City Council
Original file
1.1 MB
Text extracted from the city's file for reading and search. Open the original on legistar.granicus.com. That file is the official record.

Preliminary Draft

CITY OF CUPERTINO,

CALIFORNIA

SINGLE AUDIT
Year ended June 30, 2021

Preliminary Draft

CITY OF CUPERTINO
Cupertino, California

SINGLE AUDIT
Year ended June 30, 2021

CONTENTS

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............................................................................................ 1

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 ........................................................................................ 3

SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS ................................................................... 5

NOTES TO SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS ............................................... 6

SCHEDULE OF FINDINGS AND QUESTIONED COSTS ....................................................................... 7

SCHEDULE OF PRIOR YEAR FINDINGS ............................................................................................... 8

Preliminary Draft

Crowe LLP
Independent Member Crowe Global

(Continued)

1 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 Mayor and City Council
City of Cupertino, California

We have audited, in accordance with the auditing standards 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 aggregate remaining fund information of the City of Cupertino, California (the City), as of and for the year ended June 30, 2021, and the related notes to the financial statements, which collectively comprise the City’s basic financial statements, and have issued our report thereon dated November 16, 2021.

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 entity’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 limited 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. Given these limitations, during our audit we did not identify any deficiencies in internal control that we consider to be material weakness. However, material weaknesses may exist that have not been identified.

Preliminary Draft

2 Compliance and Other Matters

As part of obtaining reasonable assurance about whether the 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 or other matters that are required to be reported under Government Auditing Standards.

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 results of that testing, and not to provide an opinion on the effectiveness of the entity’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 entity’s internal control and compliance. Accordingly, this communication is not suitable for any other purpose.

Crowe LLP

Costa Mesa, California
April 8, 2022

Preliminary Draft

Crowe LLP
Independent Member Crowe Global

(Continued)

3 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

To the Honorable Mayor and City Council
City of Cupertino, California

Report on Compliance for Each Major Federal Program

We have audited the City of Cupertino, California (the City’s) compliance with the types of compliance requirements described in the OMB Compliance Supplement that could have a direct and material effect on each of City’s major federal programs for the year ended June 30, 2021. The City’s major federal programs are identified in the summary of auditor’s results section of the accompanying schedule of findings and questioned costs.

Management’s Responsibility

Management is responsible for compliance with federal statutes, regulations, and the terms and conditions of its federal awards applicable to its federal programs.

Auditor’s Responsibility

Our responsibility is to express an opinion on compliance for each of the City’s major federal programs based on our audit of the types of compliance requirements referred to above. We conducted our audit of compliance in accordance with auditing standards generally accepted in the United States of America; the standards applicable to financial audits contained in Government Auditing Standards , issued by the Comptroller General of the United States; and the audit 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). Those standards and the Uniform Guidance require that we plan and perform the audit to obtain reasonable assurance about whether noncompliance with the types of compliance requirements referred to above that could have a direct and material effect on a major federal program occurred. An audit includes examining, on a test basis, evidence about the City’s compliance with those requirements and performing such other procedures as we considered necessary in the circumstances.

We believe that our audit provides a reasonable basis for our opinion on compliance for each major federal program. However, our audit does not provide a legal determination of the City’s compliance.

Opinion on Each Major Federal Program

In our opinion, the City of Cupertino complied, in all material respects, with the types of 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, 2021.

Preliminary Draft

4 Report on Internal Control over Compliance

Management of the City is responsible for establishing and maintaining effective internal control over compliance with the types of compliance requirements referred to above. In planning and performing our audit of compliance, we considered the City’s internal control over compliance with the types of requirements that could have a direct and material effect on each major federal program to determine the auditing procedures that are appropriate in the circumstances for the purpose of expressing an opinion on compliance for each major federal program 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 internal control over compliance. Accordingly, we do not express an opinion on the effectiveness of the City’s 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 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.

Our consideration of internal control over compliance was for the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control over compliance that might be material weaknesses or significant deficiencies. We did not identify any deficiencies in internal control over compliance that we consider to be material weaknesses. However, material weaknesses may exist that have not been identified.

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 statements of the governmental activities, the business-type activities, each major fund, and the aggregate remaining fund information as of and for the year ended June 30, 2021, and the related notes to the financial statements, which collectively comprise the City’s basic financial statements. We issued our report thereon dated November 16, 2021, which contained unmodified opinions 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 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 statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, the schedule of expenditures of federal awards is fairly stated in all material respects in relation to the basic financial statements as a whole.

Crowe LLP

Costa Mesa, California
November 16, 2021
Preliminary Draft

CITY OF CUPERTINO, CALIFORNIA

SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Year ended June 30, 2021

See accompanying notes to schedule of expenditures of federal awards.

5 Federal Agreement Number
Assistance / Pass-Through Amount
Federal Grantor/ Listing Identifying Federal Provided to Pass-Through Grantor/Program or Cluster Title Number Number Expenditures Subrecipients U.S. Department of Housing and Urban Development
CDBG – Entitlement Grants Cluster
Community Development Block Grants/Entitlement Grants 14.218 B20MC060057 360,438$ 288,981$ COVID-19 - CDBG 14.218 N/A 229,017 185,000
Total U.S. Department of Housing and Urban Development 589,455 473,981 U.S Department of Treasury
Passed through the State of California Controller's Office COVID-19 - Coronavirus Relief Fund 21.019
Budget Act of 2020,
Control Section 11.90 735,259 -
Total U.S. Department of Treasury 735,259 -
U.S. Department of Transportation
Passed through the State of California Department of Transportation Highway Planning and Construction Cluster
Highway Planning and Construction 20.205 BPMP-5318(029) 13,656 - Highway Safety Improvement Program (HSIP) 20.205 HSIPL-5318 (030) 18,866 - 750 OBAG 20.205 STPL 5318(031) 701,250 -
Total U.S. Department of Transportation 733,772 - Total Expenditures of Federal Awards 2,058,486$ 473,981$ Preliminary Draft

CITY OF CUPERTINO, CALIFORNIA

NOTES TO SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Year ended June 30, 2021
6 NO
TE 1 - BASIS OF PRESENTATION
The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of the City of Cupertino, California (the City) for the year ended June 30, 2021. 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). Because the Schedule presents only a selected portion of the City’s operations, it does not present the financial position, changes in net position, or cash flows of the City.

NOTE 2 – SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the 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. The City has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance.

NOTE 3 – MAJOR PROGRAMS
In accordance with the Uniform Guidance, major programs for the City are individual programs or a cluster of programs determined by using a risk-based analysis. The threshold for distinguishing Type A and Type B programs was $750,000 and $187,500, respectively. Awards from the CDBG-Entitlement Grants Cluster and Highway Planning and Construction Cluster are designated as clusters of programs.

NOTE 4 - NON-CASH ASSISTANCE
The City had no non-cash assistance during the year.

NOTE 5 - FEDERAL INSURANCE
The City had no Federal Insurance in force during the year.

Preliminary Draft

CITY OF CUPERTINO, CALIFORNIA

SCHEDULE OF FINDINGS AND QUESTIONED COSTS
Year ended June 30, 2021

7 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:

Material weakness(es) identified? Yes X No

Significant deficiency(ies) identified? Yes X None reported

Noncompliance material to financial statements noted? Yes X No

Federal Awards

Internal control over major federal programs:

Material weakness(es) identified? Yes X No

Significant deficiencies identified not
considered to be material weaknesses? Yes X None reported

Type of auditor’s report issued on compliance for
major federal programs: Unmodified

Any audit findings disclosed that are required to be
reported in accordance with 2 CFR 200.516(a)? Yes X No

Identification of major federal programs:

Federal Assistance Listing Number Name of Federal Program or Cluster

20.205 Highway Planning and Construction Cluster

21.019 COVID-19 - Coronavirus Relief Funding

Dollar threshold used to distinguish between
type A and type B programs: $ 750,000

Auditee qualified as low-risk auditee? Yes x No

SECTION II – FINANCIAL STATEMENT FINDINGS

None.

SECTION III – FEDERAL AWARD FINDINGS AND QUESTIONED COSTS

None.

Preliminary Draft

CITY OF CUPERTINO, CALIFORNIA

SCHEDULE OF PRIOR YEAR FINDINGS
Year ended June 30, 2021

8 None.

← All documents from this meeting