FINANCE DEPARTMENT
Monthly Financial Report
Financial Results for the Month Ended April 30, 2022
Fiscal Year 2021-2022
(UNAUDITED)
Attachment
Finance Department, City of San José
Monthly Financial Report
Financial Results for the Month Ended April 30, 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 April 30, 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 367,985,840 323,738,458 304,849,235 91,972,139 SEPTEMBER (2)
428,548,372 215,370,108 283,092,234 67,970,290
OCTOBER (3)
440,238,436 170,467,897 288,196,905 93,654,030
NOVEMBER 442,957,719 100,622,899 299,006,136 126,316,418 DECEMBER (4)
437,194,188 71,502,262 317,868,572 121,024,958
JANUARY (4, 5, 6)
580,885,854 108,130,590 360,969,681 214,000,120
FEBRUARY (5)
496,453,999 217,629,193 348,806,133 197,277,698
MARCH (3, 5)
508,488,546 200,717,737 325,495,352 220,734,066
APRIL(3, 5)
500,240,167 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
(5) Between September 2020 - April 2021 Tax and Revenue Anticipation Note (TRAN) payments totaled $131.5 million, compared to $142.8 million paid on the TRAN notes through April 2022. (6) The General Fund cash balance generally increases in January of every year mainly due to the bi-annual receipt of property taxes from Santa Clara County.
(4) 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.
GENERAL FUND MONTHLY CASH BALANCES
(1) 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.
(2) The General Fund received a transfer of $53.8 million from the American Rescue Plan Fund for revenue loss replacement. (3) Cash increases attributable to higher sales tax collections and growth in real property transfer taxes (Measure E). $
$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 $53.8 million from the American Rescue Plan Fund for revenue loss replacement.
Real property transfer tax receipts grew by $53.3 million due to an increase in property transfers subject to the tax.
Increase in expenditures is due to the payback of the TRAN debt of $142.8 million from July 2021 - April 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 $322.5 million compared to $166 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 $53.3 million due to an increase in property transfers subject to the tax.
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
$360
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
$360
$400
$440 (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,496 56,496 56,496 100.00% 46,538 100.19% 46,451 9,958 21.40% Available Balance 321,188 47,992 - 369,180 369,180 100.00% 400,284 100.00% 400,284 (31,104) -7.77% Total Fund Balance 321,188 47,992 56,496 425,676 425,676 100.00% 446,822 100.02% 446,735 (21,146) -4.73% General Revenues
Property Tax 395,500 11,000 - 406,500 226,348 55.68% 314,460 80.89% 388,760 (88,112) -28.02% Sales Tax 280,200 20,000 - 300,200 214,536 71.46% 189,583 66.75% 284,020 24,953 13.16% Telephone Line Tax 20,000 - - 20,000 15,445 77.23% 15,193 72.79% 20,873 252 1.66% Transient Occupancy Tax 10,000 (1,000) - 9,000 6,468 71.87% 3,660 67.67% 5,409 2,808 76.72% Franchise Fees 44,652 (0) - 44,652 24,492 54.85% 33,073 72.48% 45,628 (8,581) -25.95% Utility Tax 97,060 - - 97,060 76,487 78.80% 78,892 73.84% 106,846 (2,405) -3.05% Business Taxes 74,500 8,000 - 82,500 68,360 82.86% 53,765 76.77% 70,036 14,595 27.15% Real Property Transfer Tax 40,000 50,000 - 90,000 86,011 95.57% 32,692 64.70% 50,531 53,319 163.09% Licenses and Permits 21,003 (551) - 20,452 20,550 100.48% 19,088 98.44% 19,391 1,462 7.66% Fines, Forfeits and Penalties 8,676 - - 8,676 11,999 138.30% 6,816 67.55% 10,090 5,183 76.04% Use of Money and Property 9,304 - - 9,304 6,557 70.48% 6,637 75.47% 8,794 (80) -1.21% Revenue from Local Agencies 18,784 7,418 - 26,202 11,647 44.45% 12,253 60.45% 20,270 (606) -4.95% Revenue from State of CA 13,247 11,067 - 24,314 10,928 44.95% 17,093 82.98% 20,598 (6,165) -36.07% Revenue from Federal Government 3,685 6,131 - 9,816 1,624 16.54% 993 27.58% 3,600 631 63.54% Fees, Rates and Charges 14,832 4,141 - 18,973 16,436 86.63% 5,568 75.07% 7,417 10,868 195.19% Other Revenues 9,242 318,387 - 327,629 322,545 98.45% 165,974 99.12% 167,442 156,571 94.33% Total General Revenues 1,060,685 434,592 - 1,495,277 1,120,433 74.93% 955,740 77.72% 1,229,705 164,693 17.23% Transfers & Reimbursements
Overhead Reimbursements 68,557 12,698 - 81,255 50,348 61.96% 48,643 94.07% 51,707 1,705 3.51% Transfers from Other Funds 72,608 - - 72,608 74,079 102.03% 23,504 62.49% 37,611 50,575 215.18% Reimbursements for Services 16,792 500 - 17,292 24,191 139.90% 23,381 67.50% 34,640 810 3.46% Total Transfers & Reimbursements 157,957 13,198 - 171,155 148,618 86.83% 95,528 77.06% 123,958 53,090 55.58% Total Sources 1,539,831 495,782 56,496 2,092,109 1,694,727 81.01% 1,498,090 83.21% 1,800,398 196,637 13.13% (*) - 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 APRIL 30, 2022
(UNAUDITED)
( $000's )
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 690 19,203 175 12,551 147 65.36% 10,885 79.95% 13,614 1,666 15.31% City Attorney 16,830 1,084 1,253 19,167 13,818 1,412 72.09% 13,234 79.34% 16,681 584 4.41% City Auditor 2,506 (1) 2,511 6 1,812 72.16% 1,787 5 79.35% 2,252 25 1.40% City Clerk 2,651 420 319 3,390 2,836 83.66% 2,032 28 78.85% 2,577 804 39.57% City Manager 21,671 1,238 645 23,554 14,870 1,307 63.13% 12,884 77.56% 16,611 1,986 15.41% Finance 20,216 691 21,588 681 15,145 1,042 70.15% 14,282 79.28% 18,015 863 6.04% Information Technology 25,795 292 3,159 29,246 15,897 2,918 54.36% 15,949 73.90% 21,582 (52) -0.33% Human Resources 10,448 630 11,510 432 8,295 1,281 72.07% 7,557 79.72% 9,479 738 9.77% Independent Police Auditor 1,531 61 147 1,739 1,270 73.03% 1,094 - 79.97% 1,368 176 16.09% Office of Economic Development 5,638 297 552 6,487 4,104 783 63.26% 4,208 75.74% 5,556 (104) -2.47% Total General Government 125,624 4,809 7,962 138,395 90,598 8,923 65.46% 83,912 77.89% 107,735 6,686 7.97% Public Safety
Fire 267,922 (2,687) 1,409 266,644 212,959 2,588 79.87% 188,842 78.82% 239,599 24,117 12.77% Police 481,147 3,839 3,213 488,199 386,427 4,312 79.15% 365,988 79.18% 462,198 20,439 5.58% Total Public Safety 749,069 1,152 4,622 754,843 599,386 6,900 79.41% 554,830 79.06% 701,797 44,556 8.03% Capital Maintenance
Transportation 37,517 1,197 49 38,763 27,806 1,989 71.73% 25,879 75.14% 34,440 1,927 7.45% Public Works 38,480 757 1,410 40,647 30,854 3,687 75.91% 27,620 77.42% 35,674 3,234 11.71% Total Capital Maintenance 75,997 806 2,607 79,410 58,660 5,676 73.87% 53,499 76.30% 70,114 5,161 9.65% Community Service
Housing 539 135 - 674 351 135 52.08% 124 53.68% 231 227 183.06% Library 37,239 1,491 1,942 40,672 30,002 3,362 73.77% 26,773 78.88% 33,941 3,229 12.06% Planning, Bldg & Code Enf. 15,414 402 16,402 586 10,980 556 66.94% 11,337 80.37% 14,106 (357) -3.15% Parks, Rec & Neigh Svcs 87,280 2,731 1,696 91,707 62,251 3,923 67.88% 54,957 76.01% 72,303 7,294 13.27% Environmental Services 3,492 (51) 296 3,737 2,011 873 53.81% 2,697 67.06% 4,022 (686) -25.44% Total Community Services 143,964 4,573 4,655 153,192 105,595 8,849 68.93% 95,888 76.95% 124,603 9,707 10.12% Total Dept. Expenditures 1,094,654 11,340 1,125,840 19,846 854,239 30,348 75.88% 788,129 78.48% 1,004,249 66,110 8.39% (*) - 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 APRIL 30, 2022
( UNAUDITED )
( $000's )
Note: Figures may not total due to rounding.
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 APRIL 30, 2022
( UNAUDITED )
( $000's )
Non-Dept Expenditures
City-wide Expenditures:
Econ & Neighborhood Develop. 20,638 43,217 9,687 73,542 17,282 11,613 23.50% 13,356 76.25% 17,515 29.40% 3,926 Environmental & Utility Services 1,932 1,069 3,057 56 1,375 348 44.98% 1,725 89.89% 1,919 -20.29% (350) Public Safety 21,704 10,163 32,666 799 20,223 478 61.91% 15,902 79.50% 20,003 27.17% 4,321 Recreation & Cultural Services 19,208 7,467 27,577 902 12,433 3,911 45.08% 12,657 71.20% 17,776 -1.77% (224) Transportation Services 4,406 2,113 6,525 6 3,037 6 46.54% 1,974 76.39% 2,584 53.85% 1,063 Strategic Support 53,137 298,563 357,057 5,357 167,665 5,168 46.96% 181,322 93.20% 194,542 -7.53% (13,657) Total City-wide Expenditures 121,025 362,592 16,807 500,424 222,015 21,524 44.37% 226,936 89.23% (4,921) 254,339 -2.17% Other Non-Dept Expenditures:
Capital Improvements 84,117 (1,993) 19,843 101,967 24,880 29,220 24.40% 18,084 51.58% 35,060 6,796 37.58% Transfers to Other Funds 30,391 2 - 30,393 28,092 - 92.43% 88,050 108.94% 80,824 -68.10% (59,958) Total Non-Dept Expenditures 235,533 360,601 36,650 632,784 274,987 50,744 43.46% 333,070 89.96% (58,083) 370,223 -17.44% Reserves
Contingency Reserve 40,000 500 - 40,500 - - 0.00% - 0.00% - 0.00% - Earmarked Reserves 169,645 123,340 - 292,985 55 1,945 0.02% - 0.00% - 0.00% 55 Total Reserves 209,645 123,840 - 333,485 55 1,945 0.02% - 0.00% 55 - 0.00% Total Uses 495,782 1,539,831 56,496 2,092,109 1,129,281 83,037 53.98% 1,121,199 81.57% 8,082 1,374,472 0.72% Note: Figures may not total due to rounding.
(*) - 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.
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 542 55.42% 613 84.20% 728 (71) -11.58% Public Works - - - - 4 - - 0.00% 275 4 #DIV/0!
Transportation 1,796 - - 1,796 1,211 67.43% 1,013 92.60% 1,094 198 19.55% Library 72 - - 72 31 43.06% 30 85.71% 35 1 3.33%
Planning, Bldg & Code Enforcement - - - - - - 1 0.00% - (1) -100.00% Parks Rec & Neigh Svcs 8,788 - - 8,788 11,906 135.48% 1,171 56.06% 2,089 10,735 916.74% Miscellaneous Dept Charges 3,198 4,141 - 7,339 2,742 37.36% 2,740 85.73% 3,196 2 0.07% Total Fees, Rates, and Charges 4,141 14,832 - 18,973 16,436 86.63% 5,568 75.07% 10,868 7,417 195.19% Note: Figures may not total due to rounding.
(*) - 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. (UNAUDITED)
( $000's )
CITY OF SAN JOSE
GENERAL FUND SOURCE AND USE OF FUNDS
FOR THE MONTHS ENDED APRIL 30, 2022
SUPPLEMENTAL SCHEDULE - DEPARTMENTAL REVENUES
PRIOR YEAREND
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 - April 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: Year-to-year decrease in expenditures as of close of April 2022 is primarily due to a decrease in transfers of funds between the General Purpose Parking Capital Fund (559) and the General Purpose Parking Operating Fund (533). Fund 533's revenue outlook ha improved from FY2021, precluding the need for the transfer of funds from Fund 559.
-$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 from July 2021 - February 2022 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. In March 2022, Clean Energy implemented a rate increase to align with PG&E rate increase which provided an increase to Clean Energy's revenues for March and future months. Increase in expense is due to the increase in power costs in the energy market year over 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,756 7,756 7,756 - 5,260
Beginning Fund Balance 77,562 21,741 - 99,303 99,303 - 85,176 Revenues 72,809 34,273 - 107,082 71,217 - 40,273
Total Sources 150,371 56,014 214,141 7,756 178,276 - 130,709 Total Uses 150,371 56,014 214,141 7,756 52,719 7,870 34,974 Airport
Prior Year Encumbrance - 22,214 - 22,214 22,214 - 17,685 Beginning Fund Balance 217,500 15,166 - 232,666 232,666 - 251,826 Revenues 437,053 35,634 - 472,687 341,214 - 378,547
Total Sources 654,553 50,800 22,214 727,567 596,094 648,058 - Total Uses 654,553 50,800 22,214 727,567 283,774 41,021 350,740 Waste Water Treatment
Prior Year Encumbrance - 261,329 - 261,329 261,329 - 312,959 Beginning Fund Balance 235,009 (87,473) 147,536 - 147,536 - 156,220 Revenues 566,110 114,451 680,561 - 459,819 - 369,592
Total Sources 801,119 26,978 261,329 1,089,426 868,684 838,771 - Total Uses 801,119 26,978 261,329 1,089,426 365,215 211,256 375,879 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 - 10,818 - 10,896
Total Sources 41,410 7,069 8,355 56,834 54,770 - 60,218 Total Uses 41,410 7,069 8,355 56,834 11,253 8,204 17,559 Municipal Water
Prior Year Encumbrance - 4,241 - 4,241 4,241 - 6,435
Beginning Fund Balance 32,108 (932) 31,176 - 31,176 - 29,446 Revenues 65,459 500 65,959 - 48,462 - 45,612
Total Sources 97,567 (432) 101,376 4,241 83,879 - 81,493 Total Uses 97,567 (432) 101,376 4,241 48,049 5,409 47,537 Note: Figures may not total due to rounding.
FOR THE MONTHS ENDED APRIL 30, 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 APRIL 30, 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 266,131 - 242,250
Total Sources 338,344 80,972 11,076 430,392 305,331 296,206 - Total Uses 338,344 80,972 11,076 430,392 274,614 43,824 246,063 Gas Tax
Revenues 16,000 - 16,000 - 10,347 - 11,696
Total Sources 16,000 - 16,000 - 10,347 - 11,696
Total Uses 16,000 - 16,000 - 10,347 - 9,534
Building and Structures
Prior Year Encumbrance - 4,062 - 4,062 4,062 - 6,278
Beginning Fund Balance 87,119 10,336 - 97,455 97,455 - 94,061 Revenues 74,121 700 74,821 - 21,770 - 28,094
Total Sources 161,240 11,036 176,338 4,062 123,287 - 128,433 Total Uses 161,240 11,036 176,338 4,062 18,595 4,639 20,768 Residential Construction
Beginning Fund Balance 2,319 409 2,728 - 2,728 - 2,504
Revenues 240 - - 240 188 - 184
Total Sources 2,559 409 2,968 - 2,916 - 2,688
Total Uses 2,559 409 - 2,968 65 - 49
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 - 9,697 - 5,453
Total Sources 15,448 176 16,573 949 12,715 - 10,721
Total Uses 15,448 176 16,573 949 11,698 1,250 9,759
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 - 9,896 - 10,793
Total Sources 12,673 (222) 125 12,576 13,190 - 21,527
Total Uses 12,673 (222) 125 12,576 9,417 1,344 14,489
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 APRIL 30, 2022
YEAR-TO-DATE
Golf
Beginning Fund Balance 1,977 (7) - 1,970 1,970 - 1,487
Revenues 850 - - 850 623 - 9,942
Total Sources (7) 2,827 - 2,820 2,593 - 11,429
Total Uses 2,827 (7) - 2,820 170 - 1,226
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 (12) - 869
Total Sources 3,827 10,000 723 14,550 11,577 - 1,540
Total Uses 3,827 10,000 723 14,550 8,236 327 94,760 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 (164) - -
Total Sources 22,945 130,955 216 154,116 128,581 - -
Total Uses 22,945 130,955 216 154,116 91,728 16,849 - Emergency Reserve Beginning Fund Balance 413 (35,066) - (34,654) (34,654) - - Revenues 26,381 49,744 - 76,125 30,310 - 30,400
Total Sources 14,678 26,794 - 41,471 (4,344) - 30,400
Total Uses 14,678 - 41,471 26,715 4,392 26,794 8,850 Low and Moderate Income Housing Asset Beginning Fund Balance 145,715 9,467 - 155,182 155,182 - 136,413 Revenues 17,000 19,099 - 36,099 (414) - 16,629
Total Sources 28,566 162,715 - 191,281 154,767 - 153,042 Total Uses 28,566 162,715 - 191,281 20,886 47,408 21,405 Other Funds Prior Year Encumbrance - - 76,527 76,527 76,527 - 72,181 Beginning Fund Balance 333,660 10,132 - 343,792 343,792 - 260,954 Revenues 542,540 95,318 - 637,858 526,351 - 617,707
Total Sources 105,450 876,200 76,527 1,058,177 946,670 - 950,842 Total Uses 105,450 876,200 76,527 1,058,177 427,159 128,925 404,597 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,687 60,687 60,687 - 43,075 Beginning Fund Balance 151,118 33,987 - 185,105 185,105 - 270,965 Revenues 295,086 45,393 - 340,479 255,945 - 49,201
Total Sources 446,204 79,380 60,687 586,271 501,737 - 363,241 Total Uses 79,380 446,204 60,687 586,271 101,760 73,594 117,875 Other Prior Year Encumbrance - - 837 837 837 - 615
Beginning Fund Balance 23,932 75,607 - 99,539 99,539 - 29,581 Revenues 169 - - 169 61 - 1,803
Total Sources 75,607 24,101 837 100,545 100,437 - 31,999 Total Uses 75,607 24,101 837 100,545 37,131 1,457 3,638 Note: Figures may not total due to rounding.
FOR THE MONTHS ENDED APRIL 30, 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 - - 102 102 102 - 114
Beginning Fund Balance 5,003 6,696 - 11,699 11,699 - 10,208 Revenues 3,912 137 4,049 - 4,594 - 5,074
Total Sources 8,915 6,833 15,850 102 16,395 15,396 -
Total Uses 8,915 6,833 102 15,850 3,715 69 4,068
FOR THE MONTHS ENDED APRIL 30, 2022
SOURCE AND USE OF FUNDS
YEAR-TO-DATE
Note: Figures may not total due to rounding.