Loading...
HomeMy WebLinkAbout12.07.2022 @630 Regular Measure W COCWednesday, December 7, 2022 6:30 PM City of South San Francisco P.O. Box 711 (City Hall, 400 Grand Avenue) South San Francisco, CA Virtual Meeting Measure W Citizens' Oversight Committee Regular Meeting Agenda 1 December 7, 2022Measure W Citizens' Oversight Committee Regular Meeting Agenda TELECONFERENCE MEETING NOTICE This meeting is being held in accordance with the Brown Act as currently in effect under the provisions of Assembly Bill 361 which allows attendance by members of the Measure W Citizen’s Oversight Committee, City staff and the public to participate and conduct the meeting by teleconference. Teleconference locations are not open to the public. ZOOM LINK BELOW -NO REGISTRATION REQUIRED MEMBERS OF THE PUBLIC MAY VIEW A VIDEO BROADCAST OF THE MEETING BY: Via Zoom: Join Zoom meeting https://ssf-net.zoom.us/j/81744336213 (Enter your email and name) Or Join by One Tap Mobile: +16699006833,,81744336213# US (San Jose) +16694449171,,81744336213# US Join by Telephone: Dial(for higher quality, dial a number based on your current location): US: +1 669 900 6833 or +1 669 444 9171 or +1 719 359 4580 or +1 253 205 0468 or +1 253 215 8782 or +1 346 248 7799 or +1 929 205 6099 or +1 301 715 8592 or +1 305 224 1968 or +1 309 205 3325 or +1 312 626 6799 or +1 360 209 5623 or +1 386 347 5053 or +1 507 473 4847 or +1 564 217 2000 or +1 646 931 3860 or +1 689 278 1000 or 888 475 4499 (Toll Free) or 833 548 0276 (Toll Free) or 833 548 0282 (Toll Free) or 877 853 5257 (Toll Free) Webinar ID: 817 4433 6213 International numbers available: https://ssf-net.zoom.us/u/keoSv03dys Page 2 City of South San Francisco Printed on 1/5/2024 2 December 7, 2022Measure W Citizens' Oversight Committee Regular Meeting Agenda Call To Order. Roll Call. Agenda Review. Remote Public Comments. How to submit written Public Comment before the Meeting: Members of the public wishing to participate are encouraged to submit public comments in writing in advance of the meeting to email:[email protected] by 1:00 p.m. on the meeting date. Emails received by the deadline will be forwarded to the Committee and read into the record by the Committee Secretary. Emails received after 1:00 p.m. will not be read during the meeting but will be entered into the record for the meeting. Approximately 300 words total can be read in three minutes. How to provide Public Comment during the Meeting: 1) By Phone +1(888)475-4499 Webinar ID 817 4433 6213 Click *9 to raise a hand to speak. Click *6 to unmute when called. By One tap mobile: +16699006833,,81744336213# US (San Jose) +16694449171,,81744336213# US 2) Online at https://ssf-net.zoom.us/j/81744336213 (Enter your email and name) a. Enter an email address and name. The name will be visible online and will be used to notify you that it is your turn to speak. b. When the Committee Secretary calls for the item on which you wish to speak, click on "raise hand." Speakers will be notified shortly before they are called to speak. c. When called, please limit your remarks to the time limit allotted. Page 3 City of South San Francisco Printed on 1/5/2024 3 December 7, 2022Measure W Citizens' Oversight Committee Regular Meeting Agenda Welcome and Introductions. MATTERS FOR CONSIDERATION Motion to approve the Minutes from the meeting of October 19, 2022.1. Presentation of audit overview and draft Measure W financial results by City’s independent auditor. (Amy L. Meyer, CPA, Partner, Maze and Associates) 2. Report providing Measure W financial overview and transmitting results for Fiscal Year 2021-22 and update for FY 2022-23 (Karen Chang, Finance Director) 3. Adjournment. Page 4 City of South San Francisco Printed on 1/5/2024 4 City of South San Francisco Legislation Text P.O. Box 711 (City Hall, 400 Grand Avenue) South San Francisco, CA File #:22-1039 Agenda Date:12/7/2022 Version:1 Item #:1. Motion to approve the Minutes from the meeting of October 19, 2022. City of South San Francisco Printed on 12/2/2022Page 1 of 1 powered by Legistar™5 CALL TO ORDER Chair Del Rosario called the meeting to order at 6:47 p.m. ROLL CALL Committee member Brosnan, present Committee member Rey, present Committee member Zemke, present Committee member Romero (alternate), absent Vice Chair DeGuzman, present Chair Del Rosario, present AGENDA REVIEW No changes. REMOTE PUBLIC COMMENTS No public comments MATTERS FOR CONSIDERATION 1. Motion to approve the Minutes from the meeting of August 3, 2022 Motion - Chair Del Rosario/Second – Vice Chair De Guzman: To approve the Minutes from the meeting of August 3, 2022, by roll call vote: AYES Committee member Brosnan, Committee member Rey, Committee member Zemke, Vice Chair DeGuzman, Chair Del Rosario NAYS: None; ABSENT: None; ABSTAIN: None 2. Informational report on Measure W fund balance and expenditures for FY 2021-22 update and FY 2022-23 1st Quarter (Karen Chang, Director of Finance) Director of Finance Karen Chang introduced her item. Prior to beginning the presentation Director Chang invited Assistant City Attorney Alexandra “Ali” Wolf to give a brief overview of the Measure W Committee’s responsibilities. MINUTES MEETING SPECIAL MEASURE W CITIZENS’ OVERSIGHT COMMITTEE CITY OF SOUTH SAN FRANCISCO Wednesday, October 19, 2022 6:30 p.m. TELECONFERENCE MEETING This meeting is being held in accordance with the Brown Act as currently in effect under the provisions of Assembly Bill 361 which allows attendance by members of the Measure W Citizens’ Oversight Committee, City staff and the public to participate and conduct the 6 SPECIAL MEASURE W COC MINUTES OCTOBER 19, 2022 PAGE 2 Assistant City Attorney Wolf began by stating that the oversight committee’s role is to review and report on the revenue received and expenditure funds from the Measure W tax. She stated that the Committee’s responsibility is to ensure that Measure W funds are used in alignment with the services and projects stated in the ballot measure language, but that oversight responsibility is not specific to any one project. Referencing South San Francisco Municipal code Section 4.36.140, she restated that Measure W requires City Council to appoint a Measure W Oversight Committee and that the jurisdiction of the Committee is limited to what is assigned to Measure W by city voters and by City Council and that this is established in the municipal code and the bylaws adopted by City Council which are available for review. Assistant City Attorney Wolf shared that Measure W is a general tax and that use of Measure W funds is not restricted by the examples listed in the ballot measure. She restated that funds generated from the measure may be used for any legitimate governmental purpose and that the Committee is tasked with ensuring that there is no improper use of funds, such as spending the money for a non- public purpose. She went on to explain that the Committee was created to provide an independent oversight process, however, the Committee doesn’t have a formal role in contracting, project management or any other aspect related to the use of Measure W tax revenue as explicitly stated in the bylaws for the Committee. She further explained that the Committee is not tasked with reviewing or auditing case-by-case the projects funded by Measure W. She stated that the purpose of this is to ensure that Committee members are able to distance themselves from individual projects or specific spending on individual projects and so that Committee members can look at funding of the project as a whole for a public purpose. Director Chang continued her presentation with an update on FY 2021-22 unaudited revenue and expenditures and FY 2022-23 1st Quarter preliminary revenues and expenditures. Director Chang shared that FY 2021-22 revenue is projected to be about $15.4 million and that expenditures total about $11.4 million with revenue exceeding expenditures by about $4 million. She explained that revenue for 1st Quarter FY 2022-23 is about $1.1 million because we have only received July 2022 receipts due to two-month lag in collections as explained at the last meeting. Director Chang stated that the auditors are still auditing FY 2021-22 books and that the report will be available around December. She stated that if a draft financial report is available by the next meeting it will be presented. Vice Chair DeGuzman asked if the committee will be able to meet with the auditors to which Director Chang replied that she will address this in her presentation. Continuing with her presentation, Director Chang stated that Measure W is expected to receive $13.8 million in revenue in FY 2022-23, with about $13 million in expenditures leaving a slight surplus. Director Chang then gave an overview on the three bond transactions and a summary of the projects funded by the bonds including the Police Station, LPR, Streets, Solar, Sports Field, Aquatics Center, Bridges and Playgrounds. Vice Chair DeGuzman asked for clarification on when the bonds will mature. Director Chang stated that the last payment is scheduled to coincide with the expiration of Measure W sales tax, to which Deputy Finance Director Jason Wong confirmed that the bonds will mature in 2046. 7 SPECIAL MEASURE W COC MINUTES OCTOBER 19, 2022 PAGE 3 Vice Chair DeGuzman then asked if the properties would be the asset of the City of South San Francisco following the final payment of the bonds, to which Deputy Finance Director Wong confirmed. Director Chang concluded her presentation by addressing Vice Chair DeGuzman’s earlier request regarding meeting with the auditors. Director Chang stated that she will invite the auditors to meet with the Committee at the next meeting. Director Chang then addressed a question received by Vice Chair DeGuzman prior to the meeting related to SUTA services reflected on a revenue detail report. Director Chang explained that SUTA represents Sales and Use Tax Audit Services that the City has contracted with Muniservices/Avenu to provide sales and use tax audit services to detect incorrect point of sales distribution errors thereby generating new sales tax revenue for the City. Vice Chair DeGuzman then asked if the City has access to the State Board of Equalization to view the State or Local taxes that will be received from the State Controller’s Office. Director Chang responded that the City of South San Francisco receives a report with periodic distribution information but that it does not have the level of detail that the Consultant uses for recovery efforts. Deputy Director Wong then clarified that the Board of Equalization no longer collects sales and use taxes rather the State of California agency that collects these taxes is the California Department of Tax and Fee Administration and that the City contractor, Avenu, does have a contract with that State agency to audit all of the receipts received to provide the City with information and cross- reference what is reported to the State versus what is reported to the City. Vice Chair DeGuzman then stated the importance of getting accurate Measure W revenues. Chair Del Rosario then clarified that Vice Chair DeGuzman’s intention is to ensure that there are checks and balances so that Measure W receives all expected revenue, to which Vice Chair DeGuzman agreed. Director Chang addressed a second question from Vice Chair DeGuzman related to the FY 2021-22 annual revenue to which Director Chang stated that annual revenue will close at about $15.4 million and going back to the question related to the audit reports Director Chang stated that Finance expects to have a report by mid-December or early January and that the report will be shared when available. Addressing a final question from Vice Chair DeGuzman related to a budgeted amount presented to the committee, Director Chang clarified that staff creates an estimate as part of the budget process based on economic data and previous year’s revenue. Being satisfied with Director Chang’s responses, the committee had no further questions. ADJOURNMENT Being no further business, Chair Del Rosario adjourned the meeting at 7:16 p.m. 8 SPECIAL MEASURE W COC MINUTES OCTOBER 19, 2022 PAGE 4 Submitted by: Approved by: ___________________________________ _____________________________ Amanda Parker Engy Del Rosario Measure W COC Secretary Chair Approved by the Measure W Citizens’ Oversight Committee: / / 9 City of South San Francisco Legislation Text P.O. Box 711 (City Hall, 400 Grand Avenue) South San Francisco, CA File #:22-1030 Agenda Date:12/7/2022 Version:1 Item #:2. Presentation of audit overview and draft Measure W financial results by City’s independent auditor.(Amy L. Meyer, CPA, Partner, Maze and Associates) RECOMMENDATION No formal action is required. The item is for information purposes only. BACKGROUND/DISCUSSION The City’s independent auditor,Maze and Associates,presents the audit overview to the Measure W Citizens’ Oversight Committee,pursuant to the committee bylaws.The Independent Auditor Presentation,included as Attachment 1,describes the independent auditor’s responsibility under United States Generally Accepted Auditing Standards,defines materiality,the scope of the audit,the general timeline for City’s audit as well as draft results for Measure W. CONCLUSION The auditor,Maze and Associates,is an independent CPA firm.The audit is being conducted in accordance with Generally Accepted Auditing Standards. Attachment 1- Independent Auditor Presentation City of South San Francisco Printed on 12/2/2022Page 1 of 1 powered by Legistar™10 11/30/2022 1 Independent Auditor Presentation – South San Francisco Measure W For the fiscal year ended June 30, 2022 Citizens’ Oversight Committee December 7, 2022 Amy L. Meyer, CPA Partner 1 An Audit Maze & Associates – we are an independent CPA firm, independent from the City of South San Francisco and its Component Units. Audit of the City’s Basic Financial Statements is being conducted in accordance with auditing standards generally accepted in the United States of America and Government Auditing Standards issued by the Comptroller General of the United States of America. 2 1 2 11 11/30/2022 2 Our Responsibilities Under U.S. Generally Accepted Auditing Standards Express opinions about whether the financial statements prepared by management are fairly presented, in all material respects, in conformity with U.S. generally accepted accounting principles (GAAP) Does not relieve management of its responsibilities As part of the audit, we will consider the City’s internal control for the purpose of determining audit procedures, but will not provide any assurance concerning such internal control. 3 Materiality SAS AU-C Section 320,Materiality in Planning and Performing an Audit – concept of materiality includes: Misstatements, including omissions, are considered to be material if there is a substantial likelihood that, individually or in the aggregate, they would influence the judgment made by a reasonable user based on the financial statements Judgments about materiality are made in light of surrounding circumstances and are affected by the size or nature of a misstatement, or a combination of both Judgments about materiality involve both qualitative and quantitative considerations 4 3 4 12 11/30/2022 3 Audit Scope Generally includes the following, subject to adaptation from our risk assessment process: Perform risk assessment brainstorming and planning Create audit plan tailored to the City and sector Transactions cycles subject to control testing and sampling Transactions cycles testing Transactions and balances tested in total Evaluate overall duty assignments Information system controls tests Perform compliance tests 5 Audit Timing We have met with Finance staff and agreed the following schedule: Interim fieldwork: May 2022 Final fieldwork: October 2022 Reports finalization: December 2022 6 5 6 13 11/30/2022 4 Measure W Activity is Recorded in Fund 101 in the City’s General Ledger Included in the City’s General Fund for financial reporting purposes Does not meet the GAAP requirements for separate presentation 7 Measure W –Draft Results Balance Sheet Measure W ASSETS Cash and investments $8,780,342 Receivables: Accounts 3,078,388 Total Assets $11,858,730 LIABILITIES Accounts payable $6,891 FUND BALANCES Committed 11,839,164 Assigned 12,675 Total Fund Balances 11,851,839 Total Liabilities and Fund Balances $11,858,730 8 7 8 14 11/30/2022 5 Measure W –Draft Results Income Statement Measure W REVENUES Sales taxes $15,399,766 EXPENDITURES Current: City Manager 279,786 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 15,119,980 OTHER FINANCING SOURCES (USES) Transfers out (11,201,861) Net Change in Fund Balances 3,918,119 Fund balance - July 1 7,933,720 Fund balance - June 30 $11,851,839 9 Measure W –Draft Results Budget-Actual Statement Variance with Final Budget Actual Positive Original Final Amount (Negative) Resources (inflows): Sales taxes $12,708,000 $12,708,000 $15,399,766 $2,691,766 Amounts available for appropriation 12,708,000 12,708,000 15,399,766 2,691,766 Charges to appropriations (outflows) City Manager 393,090 229,265 292,461 (63,196) Total charges to appropriations 393,090 229,265 292,461 (63,196) OTHER FINANCING SOURCES (USES) Transfers out (8,646,783) (21,417,675) (11,201,861) 10,215,814 Total Other Financing Sources (Uses) (8,646,783) (21,417,675) (11,201,861) 10,215,814 Net Change in Fund Balances $3,668,127 ($8,938,940) $3,905,444 $12,844,384 Fund Balance - July 1 7,933,720 Adjustment to budgetary basis: Encumbrance adjustments 12,675 Fund Balance - June 30 $11,851,839 Measure W Budgeted Amounts 10 9 10 15 11/30/2022 6 QUESTIONS? 11 “We are in the business to help our clients succeed” 11 16 City of South San Francisco Legislation Text P.O. Box 711 (City Hall, 400 Grand Avenue) South San Francisco, CA File #:22-1029 Agenda Date:12/7/2022 Version:1 Item #:3. Report providing Measure W financial overview and transmitting results for Fiscal Year 2021-22 and update for FY 2022-23 (Karen Chang, Finance Director) RECOMMENDATION This report is informational and requires no formal action from the Committee. BACKGROUND/DISCUSSION On November 3,2015,South San Francisco residents approved a half-cent sales tax by an overwhelming majority.The adoption of Measure W ensures that the City of South San Francisco will be able to maintain and enhance locally controlled City services that the community cares about and has come to expect -including neighborhood police patrols,911 response times,crime and gang suppression programs,street maintenance and pothole repair,maintaining youth/teen educational/recreational programs,providing a police operations center that meets earthquake safety codes, and other essential services. The voter-approved half-cent sales tax (Measure W)went into effect on April 1,2016.Since that time,the sales tax proceeds have been accounted for separately from the City’s General Fund to track the commensurate revenues and expenditures. Major projects currently funded by Measure W are: 1.Community Civic Campus Program a.Police Operations & 911 Dispatch Center (pf1707) b.Library, Parks and Recreation and Community Theater/Council Chamber (pf2103) 2.Orange Memorial Park Project a.Multi-Use Sports Fields b.Aquatic Center c.Park Playground d.Park Bridges 3.Paving Program Use to augment City efforts towards street maintenance and pothole repairs In this meeting,the City’s auditor,Maze &Associates (Maze)will provide an overview of our FY 2021-22 audit plan and scope.The City is still in the process of finalizing the FY 2021-22 Annual Comprehensive Financial Report, but Maze will present a draft Measure W result during their presentation. Staff would like to discuss with Committee whether it would like to provide an update to the Council during their next Council meeting. A.MEASURE W FUND BALANCE THROUGH NOVEMBER 30, 2022 City of South San Francisco Printed on 12/2/2022Page 1 of 3 powered by Legistar™17 File #:22-1029 Agenda Date:12/7/2022 Version:1 Item #:3. The following is a summary of Measure W revenues and expenditures since its inception through November 30, 2022: Table 1: Measure W Fund Balance Summary As shown above,the fund balance for Measure W as of June 30,2021,was $7,933,720 which is reflected in pages 111 and 113 of the City’s Comprehensive Annual Financial Report for year ended June 30,2021.The significant increase in debt services expenditure in FY 2021-22 is due to the commencement of debt service payments for the 2nd tranche of lease revenue bond (Series 2021A.)The fund balance (unaudited)for fiscal year ended June 30, 2022, is $11,851,840. The completed financial report for fiscal year 2020-21 can be found on the City’s website: <https://www.ssf.net/departments/finance/financial-reports/comprehensive-annual-financial-reports-cafr> B.FISCAL YEAR (FY) 2022-23 REVENUES There is normally a two months’lag between the time that City receives its sales tax revenue against the actual collection date.The $2 million revenue shown in Table 1 represents collections for the months of July & August 2022.Total revenue for FY 2022-23 is projected to be approximately $13.8 million.While collections for FY 2021-22 hit a record high of $15.3 million (unaudited),staff will continue to closely monitor this revenue stream considering the growing risk of recession in FY 2022-23. C.FY 2022-23 EXPENDITURES The following is a summary of expenditures as of November 30, 2022: City of South San Francisco Printed on 12/2/2022Page 2 of 3 powered by Legistar™18 File #:22-1029 Agenda Date:12/7/2022 Version:1 Item #:3. Table 2: Expenditures by project Debt service payments,which are required to be made in December and June,will be reflected in reports for the next three quarters.We anticipated the total debt service payment to be $8.3 million for FY 2022-23. Payroll expenditures related to the administration of Measure W funds will be allocated to the projects during year end. Funds appropriated in prior years by Council but unspent will be carried over as appropriated funds to be spent in FY 2022-23 or future years as part of the ongoing capital projects. CONCLUSION In FY 2021-22, the City received $15.4 million in Measure W tax revenues and expended $11.5 million in compliance with the Measure W ballot measure language. Attachments: 1.Financial Status Balances - Fund 101 - Measure W (FY 2021-22 and FY 2022-23 through 11-30-22) 2.Revenue Detail Report - Measure W Revenues FY 2022-23 3.Expenditure Detail Report - Measure W Expenditures FY 2022-23 4.Power Point Presentations City of South San Francisco Printed on 12/2/2022Page 3 of 3 powered by Legistar™19 11/30/2022 4:22PM revexpbyfund Revenue and Expenditure by Fund CITY OF SOUTH SAN FRANCISCO Page: 1 Fiscal Year: 2022 Through Period: 16 Periods: 0 through 16 ExpendYear-To-Date20220 - 16 Budget Actual Actual Encumbrances Balance % FUND: 101 MEASURE W REVENUES 101-00000-30207 MEASURE W AND USE TAX (0.5%) 12,708,000.00 15,399,766.39 15,399,766.39 0.00 (2,691,766.39) 121.18 12,708,000.00 15,399,766.39 15,399,766.39 0.00 (2,691,766.39)TOTAL REVENUES 121.18 EXPENDITURES 101-00000-9461 TRANSFER OUT TO DEBT SERVICE 8,287,833.33 8,287,833.32 8,287,833.32 0.00 0.01 100.00 101-05101-4001 REGULAR SALARIES 216,590.40 180,208.03 180,208.03 0.00 36,382.37 83.20 101-05101-4008 REGULAR HOLIDAY 0.00 11,779.34 11,779.34 0.00 (11,779.34) 0.00 101-05101-4009 VACATION PAY 0.00 11,767.85 11,767.85 0.00 (11,767.85) 0.00 101-05101-4010 SICK PAY 0.00 14,146.40 14,146.40 0.00 (14,146.40) 0.00 101-05101-4011 ACCRUED VACATION/SICK LEAVE 0.00 2,376.36 2,376.36 0.00 (2,376.36) 0.00 101-05101-4013 MEDICAL APPT LEAVE 0.00 235.42 235.42 0.00 (235.42) 0.00 101-05101-4016 ADMINISTRATIVE LEAVE 0.00 8,580.00 8,580.00 0.00 (8,580.00) 0.00 101-05101-4018 RETROACTIVE PAY 0.00 836.80 836.80 0.00 (836.80) 0.00 101-05101-4306 IN LIEU HEALTH INSURANCE 0.00 6,625.49 6,625.49 0.00 (6,625.49) 0.00 101-05101-4308 CITY SPONSORED MEDICAL 0.00 46.20 46.20 0.00 (46.20) 0.00 101-05101-4309 HEALTH BENEFIT-MISCELLANEOUS 0.00 1,100.00 1,100.00 0.00 (1,100.00) 0.00 101-05101-4311 PERS-EMPLOYER 0.00 18,224.17 18,224.17 0.00 (18,224.17) 0.00 101-05101-4315 AUTO ALLOWANCE 0.00 5,420.97 5,420.97 0.00 (5,420.97) 0.00 101-05101-4326 WORKERS COMP INSURANCE 0.00 640.16 640.16 0.00 (640.16) 0.00 101-05101-4329 RHS ER EXPENSE 0.00 3,413.31 3,413.31 0.00 (3,413.31) 0.00 101-05101-4338 OTHER BENEFITS - LIFE / ADD / LTD / STD 0.00 1,579.58 1,579.58 0.00 (1,579.58) 0.00 101-05101-4340 FICA ER AND MEDICARE ER EXPENSE 0.00 12,805.48 12,805.48 0.00 (12,805.48) 0.00 101-05101-4350 BUDGETED P/R BENEFITS 176,499.52 0.00 0.00 0.00 176,499.52 0.00 101-05101-5005 PROFESSIONAL & SPECIALIZED SVCS 12,675.00 0.00 0.00 0.00 12,675.00 0.00 101-99999-9510 TRANSFER OUT TO CAPITAL IMPROV 10,497,925.82 2,811,485.88 2,811,485.88 0.00 7,686,439.94 26.78 101-99999-9516 TRANSFER OUT TO FUND 516 CIVIC CAMPUS 2,631,916.08 102,542.34 102,542.34 0.00 2,529,373.74 3.90 21,823,440.15 11,481,647.10 11,481,647.10 0.00 10,341,793.05 TOTAL EXPENDITURES 52.61 3,918,119.29 3,918,119.29 (9,115,440.15) 0.00 (13,033,559.44)EXCESS OF REVENUES OVER EXPENDITURES (42.98) 20 11/30/2022 4:22PM revexpbyfund Revenue and Expenditure by Fund CITY OF SOUTH SAN FRANCISCO Page: 2 Fiscal Year: 2022 Through Period: 16 Periods: 0 through 16 ExpendYear-To-Date20220 - 16 Budget Actual Actual Encumbrances Balance % 21,823,440.15 12,708,000.00 GRAND TOTAL EXPENDITURES GRAND TOTAL REVENUES 11,481,647.10 15,399,766.39 11,481,647.10 15,399,766.39 0.00 0.00 10,341,793.05 GRAND EXCESS OF REVENUES OVER EXPENDITURES (9,115,440.15) 3,918,119.29 3,918,119.29 0.00 (13,033,559.44) -2,691,766.39 121.18 52.61 (42.98) 21 11/30/2022 CITY OF SOUTH SAN FRANCISCO 1 4:16PM Page:revdetl.rpt Revenue Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY 2022-23 Revenue Detail Report MEASURE W101 Account Number Adjusted Estimate Revenues Year-to-date Revenues Balance Prct Rcvd 101-00000 NON EXPENSE ACCT 101-00000-30000 TAXES 101-00000-30207 MEASURE W AND USE TAX (0.5%) 13,800,000.00 0.00 0.00 13,800,000.00 0.00 1,903,171.18 1017/25/2022 gl_crj CR 76259 Line Description: Measure W Sales Tax -1,903,171.18 1017/25/2022 acrul_r_je GJ 76272-R Line Description: FY21-22 Measure W Tax-CA -7.81 1018/15/2022 invoice IN INV06-014437 Line Description: SUTA SVCS - CA TAX QTR ENDING Vendor: AVENU MUNISERVICES LLC Check # 302285 -1,175,216.76 1018/26/2022 acrul_r_je GJ 76413-R Line Description: FY21-22 Meaure W Tax-CA 1,175,216.76 1018/26/2022 gl_crj CR 76410 Line Description: Measure W Sales Tax 1,132,113.95 1019/26/2022 gl_crj CR 76526 Line Description: Measure W Sales Tax 843,914.60 10110/24/2022 gl_crj CR 76805 Line Description: Measure W Sales Tax 101-00000-30207 MEASURE W AND USE TAX (0.5%) 1,976,020.74 1,976,020.74 14.32 13,800,000.00 11,823,979.26 Total MEASURE W 14.32 1,976,020.74 1,976,020.74 13,800,000.00 11,823,979.26 Grand Total 1,976,020.74 1,976,020.74 14.32 13,800,000.00 11,823,979.26 1Page: 22 11/30/2022 CITY OF SOUTH SAN FRANCISCO 1 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 NON EXPENSE ACCT00000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-00000-6000 CAPITAL OUTAY Total CAPITAL OUTAY 0.00 0.00 0.00 0.00 0.00 0.00 101-00000-9000 TRANSFERS 101-00000-9461 TRANSFER OUT TO DEBT SERVICE 0.00 0.00 8,289,450.00 0.00 8,289,450.00 0.00 0.00 0.00 0.00 0.00 8,289,450.00 8,289,450.00Total NON EXPENSE ACCT 1Page: 23 11/30/2022 CITY OF SOUTH SAN FRANCISCO 2 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 CITY COUNCIL01000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-01000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total CITY COUNCIL 2Page: 24 11/30/2022 CITY OF SOUTH SAN FRANCISCO 3 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 CITY CLERK02000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-02000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total CITY CLERK 3Page: 25 11/30/2022 CITY OF SOUTH SAN FRANCISCO 4 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 CITY TREASURER03000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-03000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total CITY TREASURER 4Page: 26 11/30/2022 CITY OF SOUTH SAN FRANCISCO 5 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 CITY ATTORNEY04000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-04000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total CITY ATTORNEY 5Page: 27 11/30/2022 CITY OF SOUTH SAN FRANCISCO 6 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 CITY MANAGER05000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-05000-4000 PAYROLL 101-05101-4001 REGULAR SALARIES 0.00 0.00 234,234.00 0.00 234,234.00 0.00 470.84 7/7/2022 payexp LD LD07/07/2 101Line Description: Wages 8,475.12 7/21/2022 payexp LD LD07/21/2 101Line Description: Wages 1,010.40 8/4/2022 payexp LD LD08/04/2 101Line Description: Wages 9,093.60 8/18/2022 payexp LD LD08/18/2 101Line Description: Wages 9,093.60 9/1/2022 payexp LD LD09/01/2 101Line Description: Wages 8,083.20 9/15/2022 payexp LD LD09/15/2 101Line Description: Wages 9,598.80 9/29/2022 payexp LD LD09/29/2 101Line Description: Wages 9,093.60 10/13/2022 payexp LD LD10/13/2 101Line Description: Wages 9,093.60 10/27/2022 payexp LD LD10/27/2 101Line Description: Wages 64,012.76 64,012.76 27.33101-05101-4001 REGULAR SALARIES 0.00 170,221.24 234,234.00 101-05101-4008 REGULAR HOLIDAY 0.00 0.00 0.00 0.00 0.00 0.00 470.84 7/7/2022 payexp LD LD07/07/2 101Line Description: Wages 1,010.40 9/15/2022 payexp LD LD09/15/2 101Line Description: Wages 1,010.40 10/13/2022 payexp LD LD10/13/2 101Line Description: Wages 2,491.64 2,491.64 0.00101-05101-4008 REGULAR HOLIDAY 0.00 -2,491.64 0.00 101-05101-4009 VACATION PAY 0.00 0.00 0.00 0.00 0.00 0.00 6Page: 28 11/30/2022 CITY OF SOUTH SAN FRANCISCO 7 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 CITY MANAGER05000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-05101-4009 VACATION PAY (Continued) 1,010.40 9/15/2022 payexp LD LD09/15/2 101Line Description: Wages 1,010.40 10/27/2022 payexp LD LD10/27/2 101Line Description: Wages 2,020.80 2,020.80 0.00101-05101-4009 VACATION PAY 0.00 -2,020.80 0.00 101-05101-4010 SICK PAY 0.00 0.00 0.00 0.00 0.00 0.00 3,766.72 7/7/2022 payexp LD LD07/07/2 101Line Description: Wages 941.68 7/21/2022 payexp LD LD07/21/2 101Line Description: Wages 1,010.40 9/1/2022 payexp LD LD09/01/2 101Line Description: Wages 505.20 9/29/2022 payexp LD LD09/29/2 101Line Description: Wages 6,224.00 6,224.00 0.00101-05101-4010 SICK PAY 0.00 -6,224.00 0.00 101-05101-4016 ADMINISTRATIVE LEAVE 0.00 0.00 0.00 0.00 0.00 0.00 9,093.60 8/4/2022 payexp LD LD08/04/2 101Line Description: Wages 1,010.40 8/18/2022 payexp LD LD08/18/2 101Line Description: Wages 10,104.00 10,104.00 0.00101-05101-4016 ADMINISTRATIVE LEAVE 0.00 -10,104.00 0.00 101-05101-4021 INCENTIVE PAY 0.00 0.00 0.00 0.00 0.00 0.00 4,800.00 8/4/2022 payexp LD LD08/04/2 101Line Description: Wages 4,800.00 4,800.00 0.00101-05101-4021 INCENTIVE PAY 0.00 -4,800.00 0.00 101-05101-4306 IN LIEU HEALTH INSURANCE 0.00 0.00 0.00 0.00 0.00 0.00 126.92 7/7/2022 payexp LD LD07/07/2 101Line Description: Benefits/Contributions 253.85 7/21/2022 payexp LD LD07/21/2 101Line Description: Benefits/Contributions 7Page: 29 11/30/2022 CITY OF SOUTH SAN FRANCISCO 8 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 CITY MANAGER05000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-05101-4306 IN LIEU HEALTH INSURANCE (Continued) 253.85 8/4/2022 payexp LD LD08/04/2 101Line Description: Benefits/Contributions 253.85 8/18/2022 payexp LD LD08/18/2 101Line Description: Benefits/Contributions 253.85 9/1/2022 payexp LD LD09/01/2 101Line Description: Benefits/Contributions 253.85 9/15/2022 payexp LD LD09/15/2 101Line Description: Benefits/Contributions 253.85 9/29/2022 payexp LD LD09/29/2 101Line Description: Benefits/Contributions 253.85 10/13/2022 payexp LD LD10/13/2 101Line Description: Benefits/Contributions 253.85 10/27/2022 payexp LD LD10/27/2 101Line Description: Benefits/Contributions 2,157.72 2,157.72 0.00101-05101-4306 IN LIEU HEALTH INSURANCE 0.00 -2,157.72 0.00 101-05101-4308 CITY SPONSORED MEDICAL 0.00 0.00 0.00 0.00 0.00 0.00 0.88 7/7/2022 payexp LD LD07/07/2 101Line Description: Benefits/Contributions 1.77 7/21/2022 payexp LD LD07/21/2 101Line Description: Benefits/Contributions 1.77 8/4/2022 payexp LD LD08/04/2 101Line Description: Benefits/Contributions 1.77 8/18/2022 payexp LD LD08/18/2 101Line Description: Benefits/Contributions 1.77 9/1/2022 payexp LD LD09/01/2 101Line Description: Benefits/Contributions 1.77 9/15/2022 payexp LD LD09/15/2 101Line Description: Benefits/Contributions 8Page: 30 11/30/2022 CITY OF SOUTH SAN FRANCISCO 9 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 CITY MANAGER05000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-05101-4308 CITY SPONSORED MEDICAL (Continued) 1.77 9/29/2022 payexp LD LD09/29/2 101Line Description: Benefits/Contributions 1.77 10/13/2022 payexp LD LD10/13/2 101Line Description: Benefits/Contributions 1.77 10/27/2022 payexp LD LD10/27/2 101Line Description: Benefits/Contributions 15.04 15.04 0.00101-05101-4308 CITY SPONSORED MEDICAL 0.00 -15.04 0.00 101-05101-4309 HEALTH BENEFIT-MISCELLANEOUS 0.00 0.00 0.00 0.00 0.00 0.00 500.00 7/7/2022 payexp LD LD07/07/2 101Line Description: Benefits/Contributions 500.00 500.00 0.00101-05101-4309 HEALTH BENEFIT-MISCELLANEOUS 0.00 -500.00 0.00 101-05101-4311 PERS-EMPLOYER 0.00 0.00 0.00 0.00 0.00 0.00 354.54 7/7/2022 payexp LD LD07/07/2 101Line Description: Benefits/Contributions 709.09 7/21/2022 payexp LD LD07/21/2 101Line Description: Benefits/Contributions 760.83 8/4/2022 payexp LD LD08/04/2 101Line Description: Benefits/Contributions 760.83 8/18/2022 payexp LD LD08/18/2 101Line Description: Benefits/Contributions 760.83 9/1/2022 payexp LD LD09/01/2 101Line Description: Benefits/Contributions 760.82 9/15/2022 payexp LD LD09/15/2 101Line Description: Benefits/Contributions 760.83 9/29/2022 payexp LD LD09/29/2 101Line Description: Benefits/Contributions 760.83 10/13/2022 payexp LD LD10/13/2 101Line Description: Benefits/Contributions 9Page: 31 11/30/2022 CITY OF SOUTH SAN FRANCISCO 10 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 CITY MANAGER05000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-05101-4311 PERS-EMPLOYER (Continued) 760.83 10/27/2022 payexp LD LD10/27/2 101Line Description: Benefits/Contributions 6,389.43 6,389.43 0.00101-05101-4311 PERS-EMPLOYER 0.00 -6,389.43 0.00 101-05101-4315 AUTO ALLOWANCE 0.00 0.00 0.00 0.00 0.00 0.00 103.85 7/7/2022 payexp LD LD07/07/2 101Line Description: Benefits/Contributions 207.70 7/21/2022 payexp LD LD07/21/2 101Line Description: Benefits/Contributions 207.70 8/4/2022 payexp LD LD08/04/2 101Line Description: Benefits/Contributions 207.70 8/18/2022 payexp LD LD08/18/2 101Line Description: Benefits/Contributions 207.70 9/1/2022 payexp LD LD09/01/2 101Line Description: Benefits/Contributions 207.70 9/15/2022 payexp LD LD09/15/2 101Line Description: Benefits/Contributions 207.70 9/29/2022 payexp LD LD09/29/2 101Line Description: Benefits/Contributions 207.70 10/13/2022 payexp LD LD10/13/2 101Line Description: Benefits/Contributions 207.70 10/27/2022 payexp LD LD10/27/2 101Line Description: Benefits/Contributions 1,765.45 1,765.45 0.00101-05101-4315 AUTO ALLOWANCE 0.00 -1,765.45 0.00 101-05101-4326 WORKERS COMP INSURANCE 0.00 0.00 0.00 0.00 0.00 0.00 14.58 7/7/2022 payexp LD LD07/07/2 101Line Description: Benefits/Contributions 26.37 7/21/2022 payexp LD LD07/21/2 101Line Description: Benefits/Contributions 10Page: 32 11/30/2022 CITY OF SOUTH SAN FRANCISCO 11 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 CITY MANAGER05000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-05101-4326 WORKERS COMP INSURANCE (Continued) 28.29 8/4/2022 payexp LD LD08/04/2 101Line Description: Benefits/Contributions 28.29 8/18/2022 payexp LD LD08/18/2 101Line Description: Benefits/Contributions 28.29 9/1/2022 payexp LD LD09/01/2 101Line Description: Benefits/Contributions 28.29 9/15/2022 payexp LD LD09/15/2 101Line Description: Benefits/Contributions 28.29 9/29/2022 payexp LD LD09/29/2 101Line Description: Benefits/Contributions 28.29 10/13/2022 payexp LD LD10/13/2 101Line Description: Benefits/Contributions 28.29 10/27/2022 payexp LD LD10/27/2 101Line Description: Benefits/Contributions 238.98 238.98 0.00101-05101-4326 WORKERS COMP INSURANCE 0.00 -238.98 0.00 101-05101-4329 RHS ER EXPENSE 0.00 0.00 0.00 0.00 0.00 0.00 70.62 7/7/2022 payexp LD LD07/07/2 101Line Description: Benefits/Contributions 141.25 7/21/2022 payexp LD LD07/21/2 101Line Description: Benefits/Contributions 223.56 8/4/2022 payexp LD LD08/04/2 101Line Description: Benefits/Contributions 151.56 8/18/2022 payexp LD LD08/18/2 101Line Description: Benefits/Contributions 151.56 9/1/2022 payexp LD LD09/01/2 101Line Description: Benefits/Contributions 151.56 9/15/2022 payexp LD LD09/15/2 101Line Description: Benefits/Contributions 11Page: 33 11/30/2022 CITY OF SOUTH SAN FRANCISCO 12 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 CITY MANAGER05000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-05101-4329 RHS ER EXPENSE (Continued) 151.56 9/29/2022 payexp LD LD09/29/2 101Line Description: Benefits/Contributions 151.56 10/13/2022 payexp LD LD10/13/2 101Line Description: Benefits/Contributions 151.56 10/27/2022 payexp LD LD10/27/2 101Line Description: Benefits/Contributions 1,344.79 1,344.79 0.00101-05101-4329 RHS ER EXPENSE 0.00 -1,344.79 0.00 101-05101-4338 OTHER BENEFITS - LIFE / ADD / LTD / STD 0.00 0.00 0.00 0.00 0.00 0.00 30.25 7/7/2022 payexp LD LD07/07/2 101Line Description: Benefits/Contributions 60.52 7/21/2022 payexp LD LD07/21/2 101Line Description: Benefits/Contributions 60.52 8/4/2022 payexp LD LD08/04/2 101Line Description: Benefits/Contributions 60.52 8/18/2022 payexp LD LD08/18/2 101Line Description: Benefits/Contributions 60.52 9/1/2022 payexp LD LD09/01/2 101Line Description: Benefits/Contributions 60.52 9/15/2022 payexp LD LD09/15/2 101Line Description: Benefits/Contributions 60.52 9/29/2022 payexp LD LD09/29/2 101Line Description: Benefits/Contributions 60.52 10/13/2022 payexp LD LD10/13/2 101Line Description: Benefits/Contributions 60.52 10/27/2022 payexp LD LD10/27/2 101Line Description: Benefits/Contributions 514.41 514.41 0.00101-05101-4338 OTHER BENEFITS - LIFE / ADD / LTD / STD 0.00 -514.41 0.00 101-05101-4340 FICA ER AND MEDICARE ER EXPENSE 0.00 0.00 0.00 0.00 0.00 0.00 12Page: 34 11/30/2022 CITY OF SOUTH SAN FRANCISCO 13 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 CITY MANAGER05000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-05101-4340 FICA ER AND MEDICARE ER EXPENSE (Continued) 375.92 7/7/2022 payexp LD LD07/07/2 101Line Description: Benefits/Contributions 751.87 7/21/2022 payexp LD LD07/21/2 101Line Description: Benefits/Contributions 662.65 8/4/2022 payexp LD LD08/04/2 101Line Description: Benefits/Contributions 152.47 8/18/2022 payexp LD LD08/18/2 101Line Description: Benefits/Contributions 152.48 9/1/2022 payexp LD LD09/01/2 101Line Description: Benefits/Contributions 152.48 9/15/2022 payexp LD LD09/15/2 101Line Description: Benefits/Contributions 152.47 9/29/2022 payexp LD LD09/29/2 101Line Description: Benefits/Contributions 152.48 10/13/2022 payexp LD LD10/13/2 101Line Description: Benefits/Contributions 152.47 10/27/2022 payexp LD LD10/27/2 101Line Description: Benefits/Contributions 2,705.29 2,705.29 0.00101-05101-4340 FICA ER AND MEDICARE ER EXPENSE 0.00 -2,705.29 0.00 101-05101-4350 BUDGETED P/R BENEFITS 0.00 0.00 164,387.65 0.00 164,387.65 0.00 Total PAYROLL 26.41 105,284.31 0.00 293,337.34 105,284.31 398,621.65 101-05000-5000 SUPPLIES & SERVICES 101-05101-5005 PROFESSIONAL & SPECIALIZED SVCS 0.00 0.00 0.00 0.00 0.00 0.00 12,675.00 7/1/2022 budadj BA 2023-PO-OPEN 101Line Description: Auto PO Open (0101942) 12,675.00 7/1/2022 po_open OP 0101942 101Line Description: COMMUNITY CIVIC CAMPUS FUNDRAI Vendor: 108252 PARTNERSHIP RESOURCES GROUP Check # 0 13Page: 35 11/30/2022 CITY OF SOUTH SAN FRANCISCO 14 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 CITY MANAGER05000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 0.00 0.00 100.00101-05101-5005 PROFESSIONAL & SPECIALIZED SVCS 12,675.00 0.00 12,675.00 Total SUPPLIES & SERVICES 100.00 0.00 12,675.00 0.00 0.00 12,675.00 28.68 105,284.31 105,284.31 12,675.00 293,337.34 411,296.65Total CITY MANAGER 14Page: 36 11/30/2022 CITY OF SOUTH SAN FRANCISCO 15 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 FINANCE DEPARTMENT06000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-06000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total FINANCE DEPARTMENT 15Page: 37 11/30/2022 CITY OF SOUTH SAN FRANCISCO 16 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 NON-DEPARTMENTAL07000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-07000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total NON-DEPARTMENTAL 16Page: 38 11/30/2022 CITY OF SOUTH SAN FRANCISCO 17 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 HUMAN RESOURCES09000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-09000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total HUMAN RESOURCES 17Page: 39 11/30/2022 CITY OF SOUTH SAN FRANCISCO 18 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 ECONOMIC & COMMUNITY DEVELOPMENT DEPT10000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-10000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total ECONOMIC & COMMUNITY DEVELOPMENT DEPT 18Page: 40 11/30/2022 CITY OF SOUTH SAN FRANCISCO 19 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 FIRE DEPARTMENT11000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-11000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total FIRE DEPARTMENT 19Page: 41 11/30/2022 CITY OF SOUTH SAN FRANCISCO 20 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 POLICE DEPARTMENT12000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-12000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total POLICE DEPARTMENT 20Page: 42 11/30/2022 CITY OF SOUTH SAN FRANCISCO 21 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 PUBLIC WORKS13000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-13000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total PUBLIC WORKS 21Page: 43 11/30/2022 CITY OF SOUTH SAN FRANCISCO 22 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 LIBRARY DEPARTMENT15000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-15000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total LIBRARY DEPARTMENT 22Page: 44 11/30/2022 CITY OF SOUTH SAN FRANCISCO 23 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 INFORMATION TECHNOLOGY DEPARTMENT16000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-16000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total INFORMATION TECHNOLOGY DEPARTMENT 23Page: 45 11/30/2022 CITY OF SOUTH SAN FRANCISCO 24 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 PARKS & RECREATION DEPARTMENT17000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-17000-5000 SUPPLIES & SERVICES 0.00 0.00 0.00 0.00 0.00 0.00Total PARKS & RECREATION DEPARTMENT 24Page: 46 11/30/2022 CITY OF SOUTH SAN FRANCISCO 25 4:13PM Page:expdetl.rpt Expenditure Detail Report 07/01/2022 through 06/30/2023 Periods: 0 through 16 FY2022-23 YTD Expenditure Detail Report MEASURE W101 CIP99000 Prct Used Balance Year-to-date Encumbrances Year-to-date Expenditures Expenditures Adjusted Appropriation Account Number 101-99000-9000 TRANSFERS 101-99999-9516 TRANSFER OUT TO FUND 516 CIVIC CAMPUS 0.00 0.00 4,455,000.00 0.00 4,455,000.00 0.00 0.00 0.00 0.00 0.00 4,455,000.00 4,455,000.00Total CIP 0.90 105,284.31 105,284.31 12,675.00 13,037,787.34 13,155,746.65Total MEASURE W Grand Total 105,284.31 105,284.31 0.90 12,675.00 13,037,787.34 13,155,746.65 25Page: 47 Karen Chang, Director of Finance December 7, 2022 Presentation to Measure W Citizens’ Oversight Committee 48 Agenda 1.Introductions 2.Review Minutes 3.Auditor’s Presentation 4.Financial Update 5.Questions 249 Overview of Measure W Financials 3 Fiscal Year Ended Cumulative Total as of 6/30/2020 6/30/2021 6/30/2022 (unaudited) 7/1-11/30/22 (Preliminary) Total (Inception thru 11-30-22) REVENUES $45,891,353 $13,379,292 $15,399,766 $1,976,021 $76,646,432 EXPENDITURES Civic Campus 24,569,553 16,693,441 3,019,534 105,284 44,387,812 Paving Program 5,935,264 964,312 174,279 -7,073,855 Debt Service 407,155 2,767,200 8,287,833 -11,462,188 TOTAL EXPENDITURES 30,911,972 20,424,953 11,481,646 105,284 62,923,855 Revenues less Expenditures 14,979,381 (7,045,661)3,918,120 1,870,736 13,722,576 FUND BALANCE 14,979,381 7,933,720 11,851,840 13,722,576 13,722,576 50 FY 2022-23 Revenue/ Expenditures Summary 4 Expenditure Budget Actual (11/30/22) Remaining Balance Revenues*$13,800,000 $1,976,021 $11,823,979 Expenditures Civic Campus $4,866,297 $105,284 $4,761,012 Debt Service 8,289,450 -8,289,450 Total Expenditures 13,155,747 105,284 13,050,462 Revenues Less Expenditures 644,253 1,870,737 (1,226,483) *Sales taxes receipt has a 2-month lag 51 Next step •Council Update 552 QUESTIONS 653