Legislation Details

File #: 22-0224   
Type: Report to Council Status: Public Hearing/General Business
Meeting Body: City Council
On agenda: 1/25/2022
Title: Receive and File the FY 2020/21 Annual Comprehensive Annual Financial Report (ACFR), the Sunnyvale Financing Authority Financial Report, Agreed Upon Procedure Reports, and the Report to the City Council Issued by the Independent Auditors, and Approve Budget Modification No. 15 in the amount of $13,258,782.
Attachments: 1. FY 2020-21 Annual Comprehensive Financial Reort, 2. Auditor's Report to the City Council, 3. FY 2020-21 Sunnyvale Procurement Card Purchases adn CASH AUP, 4. FY 2020-21 Sunnyvale Gas and Diesel Reconciliation and Cash AUP, 5. FY 2020-21 Sunnyvale Monthly Golf Membership Card and AUP, 6. FY 2020-21 Sunnyvale Financing Authority Financial Report, 7. Presentation to Council 20220125

REPORT TO COUNCIL AND FINANCING AUTHORITY

SUBJECT

Title

Receive and File the FY 2020/21 Annual Comprehensive Annual Financial Report (ACFR), the Sunnyvale Financing Authority Financial Report, Agreed Upon Procedure Reports, and the Report to the City Council Issued by the Independent Auditors, and Approve Budget Modification No. 15 in the amount of $13,258,782.

 

Report

REPORT IN BRIEF

The City’s audited Annual Comprehensive Annual Financial Report (ACFR), Special Agreed Upon Procedure Reports (AUP) and Sunnyvale Financing Authority Financial Report for FY 2020/21 are being presented to the City Council and the Authority Board.

 

The City’s ACFR and Sunnyvale Financing Authority Financial Report were independently audited by the firm of Macias Gini & O’Connell, LLP (MGO) who rendered unmodified opinions and found no material weaknesses during the financial audit of the City. Receiving an unmodified opinion is the optimal result from the independent audit.

 

In addition, MGO performed three Agreed Upon Procedures (AUP) related to Fiscal Administration of Public Funds. No material findings were noted in these reports.

 

Staff is also recommending Budget Modification No. 15 to appropriate $12,929,159 in General Fund Savings, $219,761 from other funding sources, and $2 M to various projects, to fund future liabilities, and to increase the Budget Stabilization Fund.

 

BACKGROUND

Each year, staff coordinates and facilitates completion of the annual audit with the independent auditor. For the annual audit process, staff prepares audit schedules and responds to audit queries while the auditor examines the City’s financial transactions and reviews records. The independent auditor conducts the audit, according to the auditing standards generally accepted in the United States of America and the Governmental Auditing Standards issued by the Comptroller General of the United States. Along with completion of the audit each year, staff prepares the City’s ACFR and Sunnyvale Financing Authority Financial Report, which includes the auditor’s opinion and audited financial statements. Staff also engaged with MGO to perform Agreed Upon Procedures (AUP) to evaluate the City’s custody and control of public funds.

 

EXISTING POLICY

City Charter Article XIII Fiscal Administration, Section 1318 (Independent Audit): Requires that an independent audit of the City’s financial transactions be conducted at the end of each fiscal year. A final audit and report shall be submitted by a Certified Public Accountant to the City Council.

Council Policy 7.1.1 B.1.6 - One-time revenues should not be used for ongoing expenditures.

 

Pursuant to Sunnyvale Charter Section 1305, at any meeting after the adoption of the budget, the City Council may amend or supplement the budget by a motion adopted by affirmative votes of at least four members to authorize the transfer of unused balances appropriated for one purpose or another, or to appropriate available revenue included in the budget.

 

ENVIRONMENTAL REVIEW

The action being considered does not constitute a “project” with the meaning of the California Environmental Quality Act (“CEQA”) pursuant to CEQA Guidelines section 15378 (b) (4) in that it is a fiscal activity that does not involve any commitment to any specific project which may result in a potential significant impact on the environment.                     

 

DISCUSSION

Annual Comprehensive Financial Report

City Charter Section 1318 requires that “At the end of each fiscal year, a final audit and report shall be submitted by [a Certified Public Accountant] to the City Council. The City’s Annual Comprehensive Financial Report (ACFR) is prepared annually to meet this requirement and is submitted to Council as Attachment 1 to this report.

 

The ACFR, which is prepared in the format prescribed by the Governmental Accounting Standards Board (GASB), contains the Independent Auditor’s Report, Management’s Discussion and Analysis, Basic Financial Statements with Notes, Required Supplementary Information, Supplementary Information, and the Statistical Section. The City’s independent audit was performed by Macias Gini & O’Connell, LLP (MGO) who rendered an unmodified opinion on the City’s ACFR. Receiving an unmodified opinion is the optimal result from the independent audit.

 

Effective FY 2014/15, with the implementation of the GASB Statement No. 68, the City’s net pension liability, representing unfunded pension obligations, is now presented as a liability on the statement of net position. Previously the information was provided as part of the Notes to the Basic Financial Statements section of the ACFR. The City’s Net Pension Liability totaled $397.0 million as of June 30, 2021, which increased by $17.8 million from the prior fiscal year. The City, like most other local agencies, has had significant unfunded pension liability for several years; however, the reporting of this liability does not require changes to the City’s plans to fund its pension liability. Through the City’s long-term financial planning process, Sunnyvale began to address the liability several years ago, with higher than required contributions to CalPERS and funding of a pension uncertainty reserve to continue to address the liability into the future. In addition, to address the pension liabilities on a long-term basis, a Section 115 Pension Trust was established in May 2018 and is managed by investment professionals. The Trust received contributions in the amount of $3.5 million during FY 2020/21, including an annual payment $1 million, and an additional $1.6 million from General Fund budget savings, with the remaining $0.9 million from the other major funds. The current twenty-year plan includes a contribution of $1 million annually to the Trust through FY 2027/28 to accumulate reserves to fund future pension liabilities. Pension costs are expected to peak in FY 2030/31, at which point in is anticipated that the City will begin drawing down the Pension Trust funds to help cover these liabilities.

 

 

GASB Statement No. 75, Accounting and Financial Reporting for Postemployment Benefits Other Than Pensions went into effect in FY 2017/18. Consequently, the City began reporting net OPEB liability on the Statement of Net Position. With the requirement to disclose the OPEB liability, the City began funding the OPEB Trust Fund in 2011. An audited stand-alone report of the Sunnyvale Retiree Healthcare Trust Plan was issued at the end of June 30, 2020. The Report reflected the OPEB Trust fund balance of $115.5 million that was used in the calculation of the net OPEB liability. As of June 30, 2021, net OPEB liability was $61.8 million, which decreased by $7.8 million from the prior fiscal year. The OPEB liability reporting standard is parallel to the pension liability reporting standard (GASB Statement No. 68) and does not require changes to the City’s plan to fund its OPEB liability. Nonetheless, the City continues to budget and plans to fund the full annual required contribution until the OPEB liability is fully funded, which is anticipated to occur at the end of the 20-year planning period.

 

Auditor’s Report to the City Council

As part of the City’s annual external audit, MGO reviews and comments on the City’s internal control over financial reporting for the purpose of the audit of the financial statements. The comments are intended to advise management of the existence of any material weaknesses in the City’s internal controls. In addition, the report aids City staff in improving its operations and communicates other advisory information, such as future accounting and reporting requirements which may have an effect on the City.

 

No material weaknesses were noted by MGO in the City’s internal control. A material weakness is a significant deficiency, or combination of deficiencies in internal controls such that there is a reasonable possibility that a material misstatement of the financial statements will not be prevented or detected and corrected on a timely basis. The report is provided as Attachment 2.

 

Agreed Upon Procedure Reports

City Finance Staff engaged MGO to perform Agreed Upon Procedures (AUP) to evaluate internal control related to the fiscal administration of public funds. The AUP was conducted in accordance with attestation standards established by the American Institute of Certified Public Accountants. Seven cash collection sites and three programs were selected for review in FY 2020/21. Accordingly, MGO issued three AUP reports (Attachments 3, 4 & 5). Surprise cash counts were also conducted on seven sites. No exceptions were noted for the surprise cash counts.

 

Three programs: 1) Sunnyvale Procurement Card Purchases; 2) Sunnyvale Gas and Diesel Reconciliation; and 3) Sunnyvale Monthly Golf Membership Card were selected for review. MGO conducted the review based on the agreed upon procedures. No major exceptions were noted for these three programs. However, MGO recommends that the City develop procedures to track manual issuance of gas and diesel which were not included as individual transactions in the daily gas and diesel usage report. City staff believes that the discrepancy is related to fuel purchase and consumption for remote sites and will implement procedures to track inventory and usage at those sites as appropriate.

 

 

 

 

 

Sunnyvale Financing Authority Report

The Joint Exercise of Powers Agreement which created the Sunnyvale Financing Authority by and between the City of Sunnyvale and the former Redevelopment Agency of the City of Sunnyvale requires that “the Controller of the Authority shall either make, or contract with a Certified Public Accountant or public accountant to make, an annual audit of the accounts and records of the Authority…a report thereof shall be filed as a public record with each of the Member Agencies.” The Sunnyvale Financing Authority Report is prepared annually to meet this requirement and is submitted to Council as Attachment 6 to this report.

 

The Sunnyvale Financing Authority Report, which is prepared in the format prescribed by the Governmental Accounting Standards Board (GASB), contains the Independent Auditor’s Report, Management’s Discussion and Analysis, Basic Financial Statements, and the Notes to Basic Financial Statements.

 

Year End Budgetary Recommendations

On December 14, 2021, Council received the Budgetary Year End Financial Report (RTC 21-1784) which identified that the ending position of the General Fund was $12.9 million better than planned. Approximately half of that favorable position was due to the receipt of $6.5 million in unplanned Excess Educational Revenue Augmentation Fund (ERAF) revenue, with the remainder coming approximately half in half from operating and project savings. Consistent with past practice, staff is recommending options to appropriate portions of the fund balance. The remainder will fall to reserve, making it available to be considered as part of the regular budget process. Staff’s recommendations are as follows:

 

$6.5 Million in Excess ERAF

Staff recommends that Council treat this as one time revenue, consistent with Council Policy, allocate it partially to one-time expenditures, with the remainder falling to the Infrastructure Reserve in the City’s Infrastructure Fund for needed future projects. The recommended allocation is as follows:

 

-                     $1.0 M additional payment to the City’s Irrevocable Pension Trust with $780,239 coming from the General Fund and the balance made up by the other major funds based on total budgeted full-time employees.

-                     $500,000 to a new project for Relocation and Temporary Housing for Unhoused Individuals. City staff is working with the County of Santa Clara and non-profit agencies to identify opportunities for case management services in the field and shelter beds or other temporary housing.

-                     $1.0 M to the Lakewood Branch Library Project. Staff has taken steps to value engineer the project, while keeping previously commitments for square footage and partner spaces. Approximately $600 K of the overage is due to unforeseen utility connection needs (extension of water line, storm drain, and new PGE service point). Rising escalation, labor shortages, and supply chain issues for materials have driven up the estimated cost beyond what could have been foreseen at project budget development.

-                     $4.2 M to the Infrastructure Reserve to fund future infrastructure projects

 

 

 

$6.4 Million in Savings from Operations and Projects

Staff recommends that Council appropriate $500,000 in funding to DPS Recruitment Project 826350 to fund higher than expected expenditures resulting from extended training timelines due to injury or illness of recruits. These savings are from an earlier DPS Recruitment Project where fewer recruits completed than anticipated. The remainder will fall to the Budget Stabilization Fund for consideration during the budget process.

 

One significant remaining near-term need is additional funding for the Enterprise Resource Planning (ERP) project. The ERP, which is the software package being implemented to replace the City’s current financial, human resources, and payroll software, is being implemented in two phases. The first phase, Financials, went live in February 2021 and staff is in the process of stabilizing operations under the new software. The implementation of the second phase, Human Content Management (HCM) which includes payroll and HR functions, has been delayed due to the complexity of implementing compliant (and therefore required) functionality around the Federal Fair Labor Standards Act, CalPERS reporting, and portions of tax reporting. As a result, staff is anticipating the need for additional funding due to the extended project timeline and the potential for needed additional consulting resources. Staff is currently refining its final numbers and will include this request with the FY 2022/23 Recommended Budget.

 

Lastly, in November 2021, Council adopted an ordinance to recover attorney’s fees and costs associated with bringing legal action to court to file for receiverships to address substandard residential properties. Staff recently received a reimbursement related to this activity in the amount of $109,862. Staff is recommending appropriation of this funding to a new project to fund outside counsel fees related to other enforcement actions, which if successful will provide additional reimbursements to continue funding these activities. This is a clean-up modification and not related to the year-end position.

 

FISCAL IMPACT

Receipt of the ACFR, Sunnyvale Financing Authority Report, AUP reports and the Report to Council issued by the Independent Auditors has no fiscal impact.

 

Budget Modification No. 15 has been prepared to take the actions recommended in the Discussion section of this report related to the year end fund balance in the General Fund. The Budget Modification totals $13,258,782, which includes the General Fund appropriations, allocations for the other major funds to the Pension Trust, and the new project to fund code enforcement activities.

 

Budget Modification No. 15

FY 2021/22

 

 

Current

Increase/ (Decrease)

Revised

General Fund

 

 

 

 

 

 

 

Expenditures

 

 

 

Transfer to Employee Benefits Fund - Pension Trust

$0

$780,239

$780,239

 

 

 

 

New Project - Temporary Housing for Unhoused Individuals

$0

$500,000

$500,000

 

 

 

 

Project 830600 - Lakewood Branch Library Facility

$27,415,000

$1,000,000

$28,415,000

 

 

 

 

Project 826350 - FY 2018/19 Recruitment and Training for Sworn Officers

$11,142,547

$500,000

$11,642,547

 

 

 

 

Transfer to Infrastructure Fund, Infrastructure Reserve

$0

$4,219,761

$4,219,761

 

 

 

 

New Project - Code Enforcement Activities to Address Substandard Residential Properties

$0

$109,862

$109,862

 

 

 

 

Reserves

 

 

 

Budget Stabilization Fund

$55,070,932

$5,929,159

$61,000,091

 

 

 

 

 

 

 

 

Other Funds

 

 

 

 

 

 

 

Expenditures

 

 

 

Housing Fund

 

 

 

 

 

 

 

Transfer to Employee Benefits Fund - Pension Trust

$0

$2,955

$2,955

 

 

 

 

Employment Development Fund

 

 

 

 

 

 

 

Transfer to Employee Benefits Fund - Pension Trust

$0

$25,942

$25,942

 

 

 

 

Water Supply and Distribution Fund

 

 

 

 

 

 

 

Transfer to Employee Benefits Fund - Pension Trust

$0

$22,320

$22,320

 

 

 

 

Wastewater Management Fund

 

 

 

 

 

 

 

Transfer to Employee Benefits Fund - Pension Trust

$0

$51,994

$51,994

 

 

 

 

Solid Waste Management Fund

 

 

 

 

 

 

 

Transfer to Employee Benefits Fund - Pension Trust

$0

$5,999

$5,999

 

 

 

 

Development Enterprise Fund

 

 

 

 

 

 

 

Transfer to Employee Benefits Fund - Pension Trust

$0

$40,016

$40,016

 

 

 

 

Golf and Tennis Operations Fund

 

 

 

 

 

 

 

Transfer to Employee Benefits Fund - Pension Trust

$0

$12,425

$12,425

 

 

 

 

General Services Fund

 

 

 

 

 

 

 

Transfer to Employee Benefits Fund - Pension Trust

$0

$58,110

$58,110

 

 

 

 

 

 

 

 

PUBLIC CONTACT

Public contact was made by posting the Council agenda on the City's official-notice bulletin board outside City Hall, at the Sunnyvale Senior Center, Community Center and Department of Public Safety; and by making the agenda and report available at the Sunnyvale Public Library, the Office of the City Clerk and on the City's website.

 

ALTERNATIVES

City Council:

1.                     Receive and file the audited Comprehensive Annual Financial Report, Agreed Upon Procedure Reports and the Report to the City Council issued by the independent auditors, and Approve Budget Modification No. 15 in the amount of $13,258,782.

2.                     Other action as directed by Council.

 

Sunnyvale Financing Authority:

1.                     Receive and file the Sunnyvale Financing Authority Financial Report.

2.                     Other action as determined by the Authority Board.

 

 

 

 

 

 

 

STAFF RECOMMENDATION

Recommendation:

City Council:

1.                     Receive and file the audited Comprehensive Annual Financial Report, Agreed Upon Procedure Reports and the Report to the City Council issued by the independent auditors, and Approve Budget Modification No. 15 in the amount of $13,258,782

Sunnyvale Financing Authority:

1.                     Receive and file the Sunnyvale Financing Authority Financial Report

 

Staff

Prepared by: Inderdeep Dhillon, Finance Manager

Reviewed by: Dennis Jaw, Assistant Director of Finance

Reviewed by: Tim Kirby, Director, Director of Finance
Reviewed by: Teri Silva, City Manager

Approved by: Kent Steffens, City Manager

 

ATTACHMENTS

1.                     FY 2020/21 Annual Comprehensive Financial Report

2.                     Auditor’s Report to the City Council

3.                     FY 2020/21 Sunnyvale Procurement Card Purchases & Cash AUP

4.                     FY 2020/21 Sunnyvale Gas and Diesel Reconciliation & Cash AUP

5.                     FY 2020/21 Sunnyvale Monthly Golf Membership Card & Cash AUP

6.                     FY 2020/21 Sunnyvale Financing Authority Financial Report