FINANCE DEPARTMENT
Monthly Financial Report
Financial Results for the Month Ended February 28, 2022 Fiscal Year 2021-2022
(UNAUDITED)
Attachment
Finance Department, City of San José
Monthly Financial Report
Financial Results for the Month Ended February 28, 2022 Fiscal Year 2021-2022
(UNAUDITED)
Table of Contents
Page
Reference
General Fund
Comparison of Current Year's Monthly Cash Balance vs.
Prior Year’s Balance......................................……………………………………….… 1 Comparison of Current Year-to-Date Revenues vs.
Prior Year-to-Date Revenues……….........................….……………………………… 2 Comparison of Current Year-to-Date Expenditures vs.
Prior Year-to-Date Expenditures……….……………………...................…….……… 2 Comparison of Current Year-to-Date Revenues for Major Revenue Sources vs. Prior Year-to-Date Revenues……….................................................…………… 3 Comparison of Current Year-to-Date Expenditures by Type vs. Prior Year-to-Date Expenditures .……..............……………………...…………… 3 Source and Use of Funds.............................………………………………………………… 4 Supplemental Schedule of Departmental Revenues.......................……………………… 7 Other Funds
Special Funds
Comparison of Current Year-to-Date Construction & Conveyance Tax Revenues vs. Prior Year-to-Date Revenues.………………..........………....………...………...… 8 Comparison of Current Year-to-Date Construction & Conveyance Tax Expenditures vs. Prior Year-to-Date Expenditures................………….………..…………..……….. 8 Comparison of Year-to-Date Revenues and YTD Expenditures vs. Prior Year-to-Date Revenue and Expenditures for:
Airport Revenue Fund 521 and Airport Maintenance & Operation Fund 523…….. 9 WPCP Operation Fund 513.......................................……………………………….. 10 General Purpose Parking Fund …................………………………………….……...
Clean Energy Fund 501……………………………………………………………….... 1112
Source and Use of Funds ………………………………………………..…………….…….. 13 Finance Department, City of San José
Monthly Financial Report
Financial Results for the Month Ended February 28, 2022 Fiscal Year 2021-2022
(UNAUDITED)
Table of Contents
Page
Reference
Other Funds (Cont’d)
Capital Project Funds
Source and Use of Funds.................................…………………………....................... 16 Other Fund Types
Source and Use of Funds.................................…………………………....................... 17 Submitted by:
JULIA H. COOPER
Director of Finance
MONTH FY 2021-2022 FY 2020-2021 FY 2019-2020 FY 2018-2019 JULY (1) $ 358,124,221 $ 238,661,153 358,057,314 $ 133,276,057 AUGUST 323,738,458 367,985,840 304,849,235 91,972,139 SEPTEMBER (2) 215,370,108 428,548,372 283,092,234 67,970,290 OCTOBER (3) 170,467,897 440,238,436 288,196,905 93,654,030 NOVEMBER 100,622,899 442,957,719 299,006,136 126,316,418 DECEMBER (4) 71,502,262 437,194,188 317,868,572 121,024,958 JANUARY (4, 5, 6) 580,885,854 108,130,590 360,969,681 214,000,120 FEBRUARY (5) 217,629,193 496,453,999 348,806,133 197,277,698 MARCH 200,717,737 325,495,352 - 220,734,066 APRIL 318,260,683 326,537,038 - 290,493,766
MAY 303,297,059 327,914,999 - 291,171,986 JUNE - 384,019,042 419,046,570 383,572,703
GENERAL FUND MONTHLY CASH BALANCES
The General Fund cash balance generally decreases each July due to City Council direction to annually pre-fund the employer share of retirement contributions in a lump-sum to achieve budgetary savings. The City did not pre-fund retirement contributions in FY 2020 and resumed pre-funding in FY 2021.
The General Fund received a transfer of $52.4 million from the American Rescue Plan Fund for revenue loss replacement.
Cash increases attributable to higher sales tax collections and growth in real property transfer taxes (Measure E).
Significant increase in December 2021 compared to December 2020 is mainly due to the following: timing differences in posting property tax receipts and vehicle license fees and growth in real property transfer tax revenue.
Between September 2020 - February 2021 Tax and Revenue Anticipation Note (TRAN) payments totaled $105.5 million, compared to $142.8 million paid on the TRAN notes through February 2022 The General Fund cash balance generally increases in January of every year due to the bi-annual receipt of property taxes from Santa Clara County.
$
$50
$100
$150
$200
$250
$300
$350
$400
$450
$500
$550
$600
$650
JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN MONTH-END BALANCES (MILLIONS)
GENERAL FUND
Comparison of Cash Balances vs. Prior Year's Balance
FY 2021-2022 FY 2020-2021 FY 2019-2020 FY 2018-2019
Note: 1) Increase in revenues is primarily due to $285.0 million received in Tax Revenue Anticipation Notes (TRAN) proceeds in FY 2022 compared to $130.0 million in TRAN proceeds in FY 2021.
The General Fund received a transfer of $52.4 million from the American Rescue Plan Fund for revenue loss replacement.
Real property transfer tax receipts grew by $46.9 million due to an increase in property transfers subject to the tax.
Year-over-year increase in property tax revenues of $14.4 million is due to a growth in assessed values and $8.4 million distributed from the Redevelopment Agency Property Tax Trust Fund after all obligations of the Successor Agency to the Redevelopmen Agency were paid.
Increase in expenditures is due to the payback of the TRAN debt of $142.8 million from July 2021 - February 2022.
$
$300
$600
$900
$1,200
$1,500
JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN (MILLIONS)
GENERAL FUND
Comparison of YTD Revenues vs. Prior YTD Revenues
Actual
FY 2020-2021 YTD FY 2021-2022 YTD
$
$300
$600
$900
$1,200
$1,500
JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN (MILLIONS)
GENERAL FUND
Comparison of YTD Expenditures vs. Prior YTD Expenditures Actual
FY 2020-2021 YTD FY 2021-2022 YTD
Note: 1) The Other Revenue category FY 2022 YTD actuals are $304 million compared to $164 million in FY 2021. Increase in Other Revenue is primarily due to $285 million received in TRAN proceeds in FY 2022 compared to $130 million received in TRAN proceeds in FY 2021.
Real property transfer tax receipts grew by $46.9 million due to an increase in property transfers subject to the tax.
Year-over-year increase in property tax revenues of $14.4 million is due to a growth in assessed values and $8.4 million distributed from the Redevelopment Agency Property Tax Trust Fund after all obligations of the Successor Agency to the Redevelopmen Agency were paid.
Increase in sales tax revenues is primarily due to an increase in taxpayer spending.
Decrease in non-department expenditures is due to timing differences in the TRAN repayment schedule and timing of other transfers out of the General Fund. $
$40
$80
$120
$160
$200
$240
$280
$320
Prop Tax Sales Tax Util Tax Business
Taxes
Fran Fees Real Prop
Transfer Tax
Other Revenue (MILLIONS)
GENERAL FUND MAJOR REVENUES
Comparison of YTD Actual vs. Prior YTD Actual
FY 2020-2021 YTD FY 2021-2022 YTD
$
$40
$80
$120
$160
$200
$240
$280
$320 (MILLIONS)
GENERAL FUND MAJOR EXPENDITURES
Comparison of YTD Actual vs. Prior YTD Actual
FY 2020-2021 YTD FY 2021-2022 YTD
PRIOR YTD % % CHANGE ADOPTED YTD REVISED CUR YTD PRIOR OF PRIOR CUR YTD LESS CUR YTD ACTUAL FY 2021-2022 BUDGET C/O FY 2021-2022 CUR YTD ACTUAL % YTD YEAR-END PRIOR YEAR-END PRIOR YTD LESS PRIOR YTD BUDGET AMENDMENTS ENCUMBR BUDGET ACTUAL (*) OF BUDGET ACTUAL (*) ACTUAL ACTUAL (*) ACTUAL ACTUAL Fund Balance Prior Year Encumbrances - - 56,701 56,701 56,701 100.00% 46,742 100.63% 46,451 9,959 21.31% Available Balance 321,188 47,992 - 369,180 100.00% 400,284 100.00% 400,284 (31,104) -7.77% Total Fund Balance 321,188 47,992 56,701 425,881 425,881 100.00% 447,026 100.07% 446,735 (21,145) -4.73% General Revenues Property Tax 395,500 11,000 - 406,500 203,649 50.10% 189,218 48.67% 388,760 14,431 7.63% Sales Tax 280,200 20,000 - 300,200 175,418 58.43% 146,347 51.53% 284,020 29,071 19.86% Telephone Line Tax 20,000 - - 20,000 11,926 59.63% 10,414 49.89% 20,873 1,512 14.52% Transient Occupancy Tax 10,000 (1,000) - 9,000 4,722 52.47% 2,737 50.60% 5,409 1,985 72.52% Franchise Fees 44,652 (0) - 44,652 22,185 49.68% 21,014 46.06% 45,628 1,171 5.57% Utility Tax 97,060 - - 97,060 57,404 59.14% 61,183 57.26% 106,846 (3,779) -6.18% Business Taxes 74,500 8,000 - 82,500 54,861 66.50% 39,988 57.10% 70,036 14,873 37.19% Real Property Transfer Tax 40,000 50,000 - 90,000 76,308 84.79% 29,428 58.24% 50,531 46,880 159.30% Licenses and Permits 21,003 (551) - 20,452 18,980 92.80% 17,946 92.55% 19,391 1,034 5.76% Fines, Forfeits and Penalties 8,676 - - 8,676 9,151 105.47% 3,746 37.13% 10,090 5,405 144.29% Use of Money and Property 9,304 - - 9,304 4,866 52.30% 5,340 60.72% 8,794 (474) -8.88% Revenue from Local Agencies 18,784 3,542 - 22,326 10,328 46.26% 9,824 48.47% 20,270 504 5.13% Revenue from State of CA 13,247 10,758 - 24,005 8,110 33.78% 1,184 5.75% 20,598 6,926 584.97% Revenue from Federal Government 3,685 4,841 - 8,526 1,046 12.27% 659 18.31% 3,600 387 58.73% Fees, Rates and Charges 14,832 4,141 - 18,973 13,094 69.02% 3,872 52.20% 7,417 9,222 238.17% Other Revenues 9,242 313,587 - 322,829 304,116 94.20% 164,209 98.07% 167,442 139,907 85.20% Total General Revenues 1,060,685 424,317 - 1,485,002 976,164 65.73% 707,109 57.50% 1,229,705 269,055 38.05% Transfers & Reimbursements Overhead Reimbursements 68,557 12,698 - 81,255 47,486 58.44% 46,200 89.35% 51,707 1,286 2.78% Transfers from Other Funds 72,608 - - 72,608 69,979 96.38% 18,882 50.20% 37,611 51,097 270.61% Reimbursements for Services 16,792 - - 16,792 17,052 101.55% 17,534 50.62% 34,640 (482) -2.75% Total Transfers & Reimbursements 157,957 12,698 - 170,655 134,517 78.82% 82,616 66.65% 123,958 51,901 62.82% Total Sources 1,539,831 485,007 56,701 2,081,539 1,536,562 73.82% 1,236,751 68.69% 1,800,398 299,811 24.24% (*) - Current YTD Actual, Prior YTD Actual and Prior Year-End Actual are based on the Generally Accepted Accounting Principles (GAAP) basis in the United States. This results in some variances from the budgetary basis as certain transactions are recognized as revenues or expenditures on a budgetary basis but not on a GAAP basis. Note: Figures may not total due to rounding. CITY OF SAN JOSE GENERAL FUND SOURCE AND USE OF FUNDS FUND BALANCE, REVENUE, TRANSFERS & REIMBURSEMENTS FOR THE MONTHS ENDED FEBRUARY 28, 2022 (UNAUDITED) ( $000's ) Page 4 PRIOR YTD % % CHANGE ADOPTED YTD REVISED CUR YTD PRIOR OF PRIOR CUR YTD LESS CUR YTD ACTUAL FY 2021-2022 BUDGET C/O FY 2021-2022 ACTUAL % YTD YEAR-END PRIOR YEAR-END PRIOR YTD LESS PRIOR YTD BUDGET AMENDMENTS ENCUMBR BUDGET ACTUAL (*) ENCUMBR OF BUDGET ACTUAL (1)(*) ACTUAL ACTUAL (1)(*) ACTUAL (1) ACTUAL General Government Mayor and Council 18,338 689 175 19,202 9,999 144 52.07% 8,541 62.74% 13,614 1,458 17.07% City Attorney 16,830 1,084 1,253 19,167 11,192 1,458 58.39% 10,647 63.83% 16,681 545 5.12% City Auditor 2,506 (1) 6 2,511 1,487 5 59.22% 1,428 63.41% 2,252 59 4.13% City Clerk 2,651 420 319 3,390 2,316 92 68.32% 1,609 62.44% 2,577 707 43.94% City Manager 21,671 645 1,238 23,554 11,644 1,352 49.44% 10,304 62.03% 16,611 1,340 13.00% Finance 20,216 691 681 21,588 12,147 1,136 56.27% 11,545 64.09% 18,015 602 5.21% Information Technology 25,795 292 3,159 29,246 12,709 3,291 43.46% 12,716 58.92% 21,582 (7) -0.06% Human Resources 10,448 630 565 11,643 6,683 1,950 57.40% 5,974 63.02% 9,479 709 11.87% Independent Police Auditor 1,531 61 147 1,739 1,072 9 61.64% 882 64.47% 1,368 190 21.54% Office of Economic Development 5,638 297 552 6,487 3,276 727 50.50% 3,619 65.14% 5,556 (343) -9.48% Total General Government 125,624 4,808 8,095 138,527 72,525 10,164 52.35% 67,265 62.44% 107,735 5,260 7.82% Public Safety Fire 267,922 (2,687) 1,409 266,644 171,651 2,720 64.37% 151,447 63.21% 239,599 20,204 13.34% Police 481,147 3,839 3,213 488,199 308,710 4,050 63.23% 289,915 62.73% 462,198 18,795 6.48% Total Public Safety 749,069 1,152 4,622 754,843 480,361 6,770 63.64% 441,362 62.89% 701,797 38,999 8.84% Capital Maintenance Transportation 37,517 49 1,197 38,763 21,591 2,444 55.70% 20,818 60.45% 34,440 773 3.71% Public Works 38,480 757 1,410 40,647 24,864 4,676 61.17% 22,195 62.22% 35,674 2,669 12.03% Total Capital Maintenance 75,997 806 2,607 79,410 46,455 7,120 58.50% 43,013 61.35% 70,114 3,442 8.00% Community Service Housing 539 - 135 674 96 136 14.24% 80 34.63% 231 16 20.00% Library 37,239 1,491 1,942 40,672 23,960 4,159 58.91% 20,321 59.87% 33,941 3,639 17.91% Planning, Bldg & Code Enf. 15,414 402 586 16,402 8,858 584 54.01% 9,209 65.28% 14,106 (351) -3.81% Parks, Rec & Neigh Svcs 87,280 2,731 1,723 91,734 51,088 3,820 55.69% 43,949 60.78% 72,303 7,139 16.24% Environmental Services 3,492 (51) 296 3,737 1,640 981 43.89% 2,168 53.90% 4,022 (528) -24.35% Total Community Services 143,964 4,573 4,682 153,219 85,642 9,680 55.90% 75,727 60.77% 124,603 9,915 13.09% Total Dept. Expenditures 1,094,654 11,339 20,006 1,125,999 684,983 33,734 60.83% 627,367 62.47% 1,004,249 57,616 9.18% (*) - Current YTD Actual, Prior YTD Actual and Prior Year-End Actual are based on the Generally Accepted Accounting Principles (GAAP) basis in the United States. This results in some variances from the budgetary basis as certain transactions are recognized as revenues or expenditures on a budgetary basis but not on a GAAP basis. YEAR-TO-DATE CITY OF SAN JOSE GENERAL FUND SOURCE AND USE OF FUNDS EXPENDITURES FOR THE MONTHS ENDED FEBRUARY 28, 2022 ( UNAUDITED ) ( $000's ) Note: Figures may not total due to rounding. Page 5 PRIOR YTD % % CHANGE ADOPTED YTD REVISED CUR YTD PRIOR OF PRIOR CUR YTD LESS CUR YTD ACTUAL FY 2021-2022 BUDGET C/O FY 2021-2022 ACTUAL % YTD YEAR-END PRIOR YEAR-END PRIOR YTD LESS PRIOR YTD BUDGET AMENDMENTS ENCUMBR BUDGET ACTUAL (*) ENCUMBR OF BUDGET ACTUAL (1)(*) ACTUAL ACTUAL (1)(*) ACTUAL (1) ACTUAL YEAR-TO-DATE CITY OF SAN JOSE GENERAL FUND SOURCE AND USE OF FUNDS EXPENDITURES FOR THE MONTHS ENDED FEBRUARY 28, 2022 ( UNAUDITED ) ( $000's ) Non-Dept Expenditures City-wide Expenditures: Econ & Neighborhood Develop. 20,638 38,417 9,687 68,742 13,983 9,171 20.34% 9,664 55.18% 17,515 4,319 44.69% Environmental & Utility Services 1,932 869 56 2,857 1,266 367 44.31% 1,411 73.53% 1,919 (145) -10.28% Public Safety 21,704 8,833 799 31,336 15,641 421 49.91% 12,602 63.00% 20,003 3,039 24.12% Recreation & Cultural Services 19,208 7,158 902 27,268 7,926 3,344 29.07% 9,398 52.87% 17,776 (1,472) -15.66% Transportation Services 4,406 2,113 6 6,525 2,659 6 40.75% 1,467 56.77% 2,584 1,192 81.25% Strategic Support 53,137 294,727 5,402 353,266 163,294 5,874 46.22% 136,422 70.12% 194,542 26,872 19.70% Total City-wide Expenditures 121,025 352,117 16,852 489,994 204,769 19,183 41.79% 170,964 67.22% 254,339 33,805 19.77% Other Non-Dept Expenditures: Capital Improvements 84,117 (1,993) 19,843 101,967 22,410 32,391 21.98% 14,902 42.50% 35,060 7,508 50.38% Transfers to Other Funds 30,391 2 - 30,393 28,092 - 92.43% 89,050 110.18% 80,824 (60,958) -68.45% Total Non-Dept Expenditures 235,533 350,126 36,695 622,354 255,271 51,574 41.02% 274,916 74.26% 370,223 (19,645) -7.15% Reserves Contingency Reserve 40,000 500 - 40,500 - - 0.00% - 0.00% - - 0.00% Earmarked Reserves 169,645 123,041 - 292,686 - 2,000 0.00% - 0.00% - - 0.00% Total Reserves 209,645 123,541 - 333,186 - 2,000 0.00% - 0.00% - - 0.00% Total Uses 1,539,831 485,007 56,701 2,081,539 940,254 87,308 45.17% 902,283 65.65% 1,374,472 37,971 4.21% (*) - Current YTD Actual, Prior YTD Actual and Prior Year-End Actual are based on the Generally Accepted Accounting Principles (GAAP) basis in the United States. This results in some variances from the budgetary basis as certain transactions are recognized as revenues or expenditures on a budgetary basis but not on a GAAP basis. Note: Figures may not total due to rounding. Page 6 PRIOR YTD % % CHANGE ADOPTED YTD REVISED CUR CUR YTD PRIOR OF PRIOR CUR YTD LESS CUR YTD ACTUAL FY 2021-2022 BUDGET C/O FY 2021-2022 YTD ACTUAL % YTD YEAR-END PRIOR YTD LESS PRIOR YTD BUDGET AMENDMENTS ENCUMBR BUDGET ACTUAL (*) OF BUDGET ACTUAL (*) ACTUAL ACTUAL (*) ACTUAL ACTUAL Police 978 - - 978 371 37.93% 433 59.48% 728 (62) -14.32% Public Works - - - - 3 - (172) -62.55% 275 175 -101.74% Transportation 1,796 - - 1,796 922 51.34% 795 72.67% 1,094 127 15.97% Library 72 - - 72 22 30.56% 26 74.29% 35 (4) -15.38% Planning, Bldg & Code Enforcement - - - - - - - 0.00% - - 0.00% Parks Rec & Neigh Svcs 8,788 - - 8,788 9,385 106.79% 722 34.56% 2,089 8,663 1199.86% Miscellaneous Dept Charges 3,198 4,141 - 7,339 2,391 32.58% 2,068 64.71% 3,196 323 15.62% Total Fees, Rates, and Charges 14,832 4,141 - 18,973 13,094 69.01% 3,872 52.20% 7,417 9,222 238.17% (*) - Current YTD Actual, Prior YTD Actual and Prior Year-End Actual are based on the Generally Accepted Accounting Principles (GAAP) basis in the United States. This results in some variances from the budgetary basis as certain transactions are recognized as revenues or expenditures on a budgetary basis but not on a GAAP basis. Note: Figures may not total due to rounding. (UNAUDITED) ( $000's ) CITY OF SAN JOSE GENERAL FUND SOURCE AND USE OF FUNDS FOR THE MONTHS ENDED FEBRUARY 28, 2022 SUPPLEMENTAL SCHEDULE - DEPARTMENTAL REVENUES PRIOR YEAR- END Page 7 Note: 1) Negative revenues in July 2021 is due to year-end adjustments (accrual reversals). 2) Increase in expenditures is due to various flood projects in the City-Wide Parks (Fund 391), acquisition of materials in the Library C&C (Fund 393), the Silicon Valley Regional interoperability and the Silicon Valley Regional Communications Systems - Radios in the Communications C&C (Fund 397). 3) Increase in revenues in November 2021 is due to a $6.95 million transfer from the General Fund to support the Communications Capital Program's effort to maintain and replace radio equipment.
-$10
$
$10
$20
$30
$40
$50
$60
$70
$80
JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN (MILLIONS) CONSTRUCTION & CONVEYANCE TAX FUNDS 377-378 & 380-398
Comparison of YTD Revenues vs. Prior YTD Revenues
FY 2020-2021 YTD FY 2021-2022 YTD
$
$10
$20
$30
$40
$50
$60
$70
$80
JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN (MILLIONS) CONSTRUCTION & CONVEYANCE TAX FUNDS 377-378 & 380-398
Comparison of YTD Expenditures vs. Prior YTD Expenditures FY 2020-2021 YTD FY 2021-2022 YTD
Note: 1) The Airport received CARES Act grant reimbursement of $12.1 million in Coronavirus Response in September 2021 compared to $18.9 million in September 2020. The Airport also received Relief Supplemental Appropriations (CRRSA) Act Concessions of $3.0 million in September 2021, $3.0 million in November 2021, $2.8 million in December 2021, $2.8 million in January 2022, $1.8 million in February 2022 compared to $0 in September 2020 - February 2021. 2) Increase in passenger activity resulted in an overall increase in rentals/concession income, parking and landing fees' revenues.
$
$20
$40
$60
$80
$100
$120
$140
$160
$180
JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN (MILLIONS) AIRPORT REVENUE FUND 521
Comparison of YTD Revenues vs. Prior YTD Revenues
FY 2020-2021 YTD FY 2021-2022 YTD
$
$20
$40
$60
$80
$100
JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN (MILLIONS) AIRPORT MAINTENANCE & OPERATION FUND 523
Comparison of YTD Expenditures vs. Prior YTD Expenditures FY 2020-2021 YTD FY 2021-2022 YTD
Note: Decrease in revenues in September 2021 is due to $64.0 million transferred in from Sewer Service & Use Charge Fund (541); whereas $85.5 million was transferred in September 2020. $
$20
$40
$60
$80
$100
$120
JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN (MILLIONS) WPCP OPERATION FUND 513
Comparison of YTD Revenues vs. Prior YTD Revenues
FY 2020-2021 YTD FY 2021-2022 YTD
$
$20
$40
$60
$80
$100
$120
JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN (MILLIONS) WPCP OPERATION FUND 513
Comparison of YTD Expenditures vs. Prior YTD Expenditures FY 2020-2021 YTD FY 2021-2022 YTD
Note: 1) Increase in revenues and expenditures is due to a $4.9 million transfer from the General Purpose Parking Capital Fund (559) to the General Purpose Parking Operating Fund (533) in September 2021. 2) Year-to-year decrease in expenditures as of close of February 2022 is primarily due to the decrease in $0.5 million of indirect overhead charge because of fewer full-time equivalents (FTE), control equipment purchase of $0.6 million, downtown event parking dynamic message sign of $0.4 million, and transfer out of $0.8 million from Fund 559 to Fund 533.
-$2
$
$2
$4
$6
$8
$10
$12
$14
$16
$18
$20
JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN (MILLIONS) GENERAL PURPOSE PARKING FUNDS 533 & 559
Comparison of YTD Revenues vs. Prior YTD Revenues
FY 2020-2021 YTD FY 2021-2022 YTD
$
$2
$4
$6
$8
$10
$12
$14
$16
$18
$20
JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN (MILLIONS) GENERAL PURPOSE PARKING FUNDS 533 & 559
Comparison of YTD Expenditures vs. Prior YTD Expenditures FY 2020-2021 YTD FY 2021-2022 YTD
Note: Decrease in Clean Energy revenue is due to a variance in electricity rates and energy load delivered.
Clean Energy establishes rates to align with PG&E's rates, while shielding Clean Energy's customers from increased PG&E fees. As a result, Clean Energy's default rate plan (GreenSource) is lower than the rates compared to prior year.
$
$40
$80
$120
$160
$200
$240
$280
$320
JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN (MILLIONS) CLEAN ENERGY FUND 501
Comparison of YTD Revenues vs. Prior YTD Revenues
FY 2020-2021 YTD FY 2021-2022 YTD
$
$40
$80
$120
$160
$200
$240
$280
$320
JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN (MILLIONS) CLEAN ENERGY FUND 501
Comparison of YTD Expenditures vs. Prior YTD Expenditures FY 2020-2021 YTD FY 2021-2022 YTD
CITY OF SAN JOSE
SPECIAL FUNDS
SOURCE AND USE OF FUNDS
(UNAUDITED)
( $000's )
ADOPTED YTD REVISED PRIOR
FY 2021-2022 BUDGET C/O FY 2021-2022 Y-T-D
BUDGET AMENDMENTS ENCUMBR BUDGET ACTUAL ENCUMBR ACTUAL
Construction/Conveyance Tax
Prior Year Encumbrance - - 7,770 7,770 7,770 - 5,289
Beginning Fund Balance 77,562 21,741 - 99,303 99,303 - 85,176 Revenues 72,809 34,273 - 107,082 50,473 - 30,071
Total Sources 56,014 150,371 7,770 214,155 157,546 - 120,536 Total Uses 150,371 56,014 7,770 214,155 40,404 9,738 25,672 Airport Prior Year Encumbrance - - 23,498 23,498 23,498 - 11,424 Beginning Fund Balance 217,500 15,166 - 232,666 232,666 - 251,826 Revenues 437,053 32,634 - 469,687 254,632 - 235,533
Total Sources 47,800 654,553 23,498 725,851 510,796 - 498,783 Total Uses 47,800 654,553 23,498 725,851 215,025 40,188 270,010 Waste Water Treatment Prior Year Encumbrance - - 264,453 264,453 264,453 - 313,014 Beginning Fund Balance 235,009 (87,473) - 147,536 147,536 - 156,220 Revenues 566,110 114,451 - 680,561 410,453 - 350,066
Total Sources 26,978 801,119 264,453 1,092,550 822,442 - 819,300 Total Uses 26,978 801,119 264,453 1,092,550 301,777 235,044 327,596 Parking Prior Year Encumbrance - - 8,355 8,355 8,355 - 9,548
Beginning Fund Balance 28,528 7,069 - 35,597 35,597 - 39,774 Revenues 12,882 - - 12,882 11,999 - 9,646
Total Sources 7,069 41,410 8,355 56,834 55,951 - 58,968 Total Uses 7,069 41,410 8,355 56,834 13,247 8,774 15,950 Municipal Water Prior Year Encumbrance - - 4,894 4,894 4,894 - 6,507
Beginning Fund Balance 32,108 (932) - 31,176 31,176 - 29,446 Revenues 65,459 - - 65,459 40,638 - 38,517
Total Sources (932) 97,567 4,894 101,529 76,708 - 74,470 Total Uses (932) 97,567 4,894 101,529 41,286 4,828 40,944 Note: Figures may not total due to rounding.
FOR THE MONTHS ENDED FEBRUARY 28, 2022
YEAR-TO-DATE
CITY OF SAN JOSE
SPECIAL FUNDS
SOURCE AND USE OF FUNDS
(UNAUDITED)
( $000's )
ADOPTED YTD REVISED PRIOR
FY 2021-2022 BUDGET C/O FY 2021-2022 Y-T-D
BUDGET AMENDMENTS ENCUMBR BUDGET ACTUAL ENCUMBR ACTUAL
FOR THE MONTHS ENDED FEBRUARY 28, 2022
YEAR-TO-DATE
Community Energy
Prior Year Encumbrance - - 11,076 11,076 11,076 - 3,430 Beginning Fund Balance 43,752 (15,628) - 28,124 28,124 - 50,526 Revenues 294,592 96,600 - 391,192 195,765 - 211,046
Total Sources 80,972 338,344 11,076 430,392 234,965 - 265,002 Total Uses 338,344 80,972 11,076 430,392 219,706 88,536 204,859 Gas Tax Revenues 16,000 - - 16,000 7,811 - 8,293
Total Sources - 16,000 - 16,000 7,811 - 8,293
Total Uses - 16,000 - 16,000 7,811 - 8,293 Building and Structures Prior Year Encumbrance - - 4,757 4,757 4,757 - 6,353
Beginning Fund Balance 87,119 10,336 - 97,455 97,455 - 94,061 Revenues 74,121 500 - 74,621 14,594 - 23,862
Total Sources 10,836 161,240 4,757 176,833 116,806 - 124,276 Total Uses 10,836 161,240 4,757 176,833 14,572 5,282 15,324 Residential Construction Beginning Fund Balance 2,319 409 - 2,728 2,728 - 2,504
Revenues 240 - - 240 89 - 154
Total Sources 409 2,559 - 2,968 2,817 - 2,658
Total Uses 2,559 409 - 2,968 61 - 40
Transient Occupancy Tax
Prior Year Encumbrance - - 949 949 949 - 984
Beginning Fund Balance 393 1,676 - 2,069 2,069 - 4,284
Revenues 15,055 (1,500) - 13,555 7,094 - 4,065
Total Sources 176 15,448 949 16,573 10,112 - 9,333
Total Uses 176 15,448 949 16,573 11,539 1,991 9,416 Conventions, Arts & Entertainment Prior Year Encumbrance - - 125 125 125 - 294
Beginning Fund Balance 2,524 645 - 3,169 3,169 - 10,440 Revenues 10,149 (867) - 9,282 10,722 - 10,746
Total Sources (222) 12,673 125 12,576 14,016 - 21,480
Total Uses (222) 12,673 125 12,576 9,400 1,344 13,464 Note: Figures may not total due to rounding.
CITY OF SAN JOSE
SPECIAL FUNDS
SOURCE AND USE OF FUNDS
(UNAUDITED)
( $000's )
ADOPTED YTD REVISED PRIOR
FY 2021-2022 BUDGET C/O FY 2021-2022 Y-T-D
BUDGET AMENDMENTS ENCUMBR BUDGET ACTUAL ENCUMBR ACTUAL
FOR THE MONTHS ENDED FEBRUARY 28, 2022
YEAR-TO-DATE
Golf
Beginning Fund Balance 1,977 (7) - 1,970 1,970 - 1,487
Revenues 850 - - 850 505 - 10,652
Total Sources (7) 2,827 - 2,820 2,475 - 12,139
Total Uses 2,827 (7) - 2,820 143 - 1,207
CARES Act
Prior Year Encumbrance - - 723 723 723 - 8,043
Beginning Fund Balance 10,866 - 10,866 10,866 - (7,372) Revenues 10,000 (7,039) - 2,961 (17) - 824
Total Sources 3,827 10,000 723 14,550 11,572 - 1,495
Total Uses 3,827 10,000 723 14,550 7,208 418 89,886 American Rescue Plan Act Prior Year Encumbrance - - 216 216 216 - -
Beginning Fund Balance 130,955 (2,426) - 128,529 128,529 - - Revenues - 25,371 - 25,371 (202) - -
Total Sources 22,945 130,955 216 154,116 128,543 - -
Total Uses 22,945 130,955 216 154,116 80,410 7,430 - Emergency Reserve Beginning Fund Balance 413 (35,066) - (34,654) (34,654) - - Revenues 26,381 49,744 - 76,125 30,310 - 32,424
Total Sources 14,678 26,794 - 41,471 (4,344) - 32,424
Total Uses 26,794 14,678 - 41,471 23,156 6,989 6,565
Low and Moderate Income Housing Asset
Beginning Fund Balance 145,715 9,467 - 155,182 155,182 - 136,414 Revenues 17,000 19,099 - 36,099 26,661 - 19,661
Total Sources 28,566 162,715 - 191,281 181,842 - 156,075 Total Uses 28,566 162,715 - 191,281 32,756 42,562 17,028 Other Funds Prior Year Encumbrance - - 76,647 76,647 76,647 - 72,944 Beginning Fund Balance 333,660 10,132 - 343,792 343,792 - 260,953 Revenues 542,540 94,929 - 637,469 435,295 - 555,483
Total Sources 105,061 876,200 76,647 1,057,908 855,734 - 889,380 Total Uses 105,061 876,200 76,647 1,057,908 321,365 158,048 320,720 Note: Figures may not total due to rounding.
CITY OF SAN JOSE
CAPITAL PROJECT FUNDS
SOURCE AND USE OF FUNDS
(UNAUDITED)
( $000's )
ADOPTED YTD REVISED PRIOR
FY 2021-2022 BUDGET C/O FY 2021-2022 Y-T-D
BUDGET AMENDMENTS ENCUMBR BUDGET ACTUAL ENCUMBR ACTUAL
Construction Excise
Prior Year Encumbrance - - 60,717 60,717 60,717 - 43,657 Beginning Fund Balance 151,118 33,987 - 185,105 185,105 - 270,965 Revenues 295,086 45,318 - 340,404 243,959 - 45,314
Total Sources 446,204 79,305 60,717 586,226 489,781 - 359,936 Total Uses 79,305 446,204 60,717 586,226 78,506 74,071 81,093 Other Prior Year Encumbrance - - 837 837 837 - 615
Beginning Fund Balance 23,932 75,607 - 99,539 99,539 - 29,581 Revenues 169 - - 169 45 - 1,769
Total Sources 75,607 24,101 837 100,545 100,421 - 31,965 Total Uses 75,607 24,101 837 100,545 30,245 680 3,112 Note: Figures may not total due to rounding.
FOR THE MONTHS ENDED FEBRUARY 28, 2022
YEAR-TO-DATE
CITY OF SAN JOSE
OTHER FUND TYPES
(UNAUDITED)
( $000's )
ADOPTED YTD REVISED PRIOR
FY 2021-2022 BUDGET C/O FY 2021-2022 Y-T-D
BUDGET AMENDMENTS ENCUMBR BUDGET ACTUAL ENCUMBR ACTUAL
Trust and Agency
Prior Year Encumbrance - - 103 103 103 - 114
Beginning Fund Balance 5,003 6,696 - 11,699 11,699 - 10,208 Revenues 3,912 137 - 4,049 4,614 - 4,874
Total Sources 6,833 8,915 103 15,851 16,416 - 15,196
Total Uses 8,915 6,833 103 15,851 3,688 103 3,887
FOR THE MONTHS ENDED FEBRUARY 28, 2022
SOURCE AND USE OF FUNDS
YEAR-TO-DATE
Note: Figures may not total due to rounding.