Cities Index.
Attachment

Public Safety, Finance and Strategic Support Committee (psfss)
April 18, 2024

Document
Attachment
Meeting
April 18, 2024
Body
Public Safety, Finance and Strategic Support Committee (psfss)
Pages
17
Original file
488 KB
Text extracted from the city's file for reading and search. Open the original on legistar.granicus.com. That file is the official record.

CITYOF A

SANJOSE

CAPITAL OF SILICON VALLEY

FINANCE DEPARTMENT
Monthly Financial Report
Financial Results for the Month Ended February 29, 2024 Fiscal Year 2023-2024
(UNAUDITED)
General Fund
Finance Department, City of San Jose
Monthly Financial Report
Financial Results for the Month Ended February 29, 2024 Fiscal Year 2023-2024
(UNAUDITED)
Table of Contents
Comparison of Current Year's Monthly Cash Balance vs.

Prior Year's Balance ...................................................................................... .

Comparison of Current Year-to-Date Revenues vs.

Prior Year-to-Date Revenues ......................................................................... .

Comparison of Current Year-to-Date Expenditures vs.

Prior Year-to-Date Expenditures .................................................................... .

Comparison of Current Year-to-Date Revenues for Major Revenue Sources vs. Prior Year-to-Date Revenues ........................................................................ .

Comparison of Current Year-to-Date Expenditures by Type vs. Prior Year-to-Date Expenditures .............................................................. .

Source and Use of Funds ..................................................................................... .

Supplemental Schedule of Departmental Revenues ................................................. .

Other Funds
Special Funds
Comparison of Current Year-to-Date Construction & Conveyance Tax Revenues vs. Prior Year-to-Date Revenues .................................................................... .

Comparison of Current Year-to-Date Construction & Conveyance Tax Expenditures vs. Prior Year-to-Date Expenditures ................................................................ .

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

WPCP Operation Fund 513 ............................................................................ .

General Purpose Parking Fund 533 & 559 ................................................... .

Clean Energy Fund 501 ........................................................................... .

Source and Use of Funds ............................................................................... .

Page
Reference
1 2
2 3
3 4
7 8
8 9
10 11
12 13
Finance Department, City of San Jose
Monthly Financial Report
Financial Results for the Month Ended February 29, 2024 Fiscal Year 2023-2024
(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:

RICK BRUNEAU
Director of Finance
MONTH FY 2023-2024 FY 2022-2023 FY 2021-2022 FY 2020-2021 JULY (1) $ 439,558,442 $ 566,915,115 $ 358,124,221 $ 238,661,153 AUGUST 481,331,154 538,605,518 367,985,840 323,738,458
SEPTEMBER 454,215,277 542,042,503 428,548,372 215,370,108 OCTOBER 426,618,323 564,251,170 440,238,436 170,467,897 NOVEMBER 453,578,125 622,142,937 442,957,719 100,622,899 DECEMBER 442,840,961 613,707,115 437,194,188 71,502,262 JANUARY (2) 529,348,366 710,351,741 580,885,854 108,130,590 FEBRUARY 520,153,859 584,487,275 496,453,999 217,629,193 MARCH - 599,096,267 508,488,546 200,717,737
APRIL - 615,840,435 500,240,167 318,260,683
MAY - 695,301,954 605,557,239 303,297,059
JUNE - 679,263,084 575,342,891 384,019,042

GENERAL FUND MONTHLY CASH BALANCES
(1) The General Fund Cash balance decreased in July as part of the annual lump-sum pre-funding of a portion of the employer's share of retirement contributions to achieve budgetary savings. In the past, the City issued short-term Tax and Revenue Anticipation Notes (TRAN) to pre-fund retirement contributions. In 2023-2024, the City chose to pre-fund with $211 million cash.
(2) The General Fund Cash balance increased in January 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
$700
$750

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 Balances
FY 2023-2024 FY 2022-2023
FY 2021-2022 FY 2020-2021

Page 1 ends

Note: 1) Decrease in revenues is primarily due to $275.0 million received in TRAN proceeds in FY 2023 compared to $0 received in FY 2024.
2) Decrease in expenditures is primarily due to $140 million TRAN debt service expenditures as of February 2023 compared to $0 as of February 2024. $
$250
$500
$750
$1,000
$1,250
$1,500
$1,750
$2,000

JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN
(MILLIONS)

GENERAL FUND
Comparison of YTD Revenues vs. Prior YTD Revenues
FY 2022-2023 YTD FY 2023-2024 YTD
$
$250
$500
$750
$1,000
$1,250
$1,500
$1,750
$2,000

JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN
(MILLIONS)

GENERAL FUND
Comparison of YTD Expenditures vs. Prior YTD Expenditures FY 2022-2023 YTD FY 2023-2024 YTD

Page 2 ends

Note: 1) The decrease in Other Revenues is mainly attributed to the $275.0 million received in TRAN proceeds in FY 2023, compared to $0 received in FY 2024.
2) The decrease in non-departmental expenditures is primarily due to the $140 million TRAN debt service expenditures as of February 2023 compared to $0 as of February 2024. $
$50
$100
$150
$200
$250
$300
$350
Prop Tax Sales Tax Util Tax Business
Taxes
Fran Fees Real Prop
Transfer Tax
Licenses and
Permits
Other Rev
(MILLIONS)

GENERAL FUND MAJOR REVENUES
Comparison of YTD vs. Prior YTD
FY 2022-2023 YTD FY 2023-2024 YTD
$
$50
$100
$150
$200
$250
$300
$350
(MILLIONS)

GENERAL FUND MAJOR EXPENDITURES
Comparison of YTD vs. Prior YTD
FY 2022-2023 YTD FY 2023-2024 YTD

Page 3 ends

PRIOR YTD % % CHANGE

ADOPTED YTD REVISED CUR YTD PRIOR OF PRIOR CUR YTD LESS CUR YTD ACTUAL FY 2023-2024 BUDGET C/O FY 2023-2024 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 - - 84,434 84,434 84,434 100.00% 53,047 83.12% 63,818 31,387 59.17% Available Balance 629,627 9,732 - 639,359 639,359 100.00% 558,987 100.00% 558,987 80,372 14.38% Total Fund Balance 629,627 9,732 84,434 723,793 723,793 100.00% 612,034 98.27% 622,805 111,759 18.26% General Revenues
Property Tax 460,400 13,500 - 473,900 220,781 46.59% 221,528 49.34% 449,014 (747) -0.34% Sales Tax 336,400 - - 336,400 173,343 51.53% 181,922 52.97% 343,472 (8,579) -4.72% Telephone Line Tax 22,000 - - 22,000 12,643 57.47% 12,599 59.73% 21,094 44 0.35% Transient Occupancy Tax 16,000 - - 16,000 8,569 53.56% 8,413 56.32% 14,937 156 1.86% Franchise Fees 51,825 - - 51,825 11,987 23.13% 23,478 52.38% 44,824 (11,491) -48.94% Utility Tax 126,550 - - 126,550 78,262 61.84% 74,878 60.26% 124,267 3,384 4.52% Business Taxes 87,500 - - 87,500 55,062 62.93% 57,230 63.85% 89,627 (2,168) -3.79% Real Property Transfer Tax 50,000 50,000 26,971 53.94% 40,674 72.27% 56,280 (13,703) -33.69% Licenses and Permits 22,006 (202) - 21,804 19,413 89.03% 16,749 94.32% 17,757 2,664 15.90% Fines, Forfeits and Penalties 15,080 - - 15,080 9,045 59.98% 10,794 62.20% 17,353 (1,749) -16.20% Use of Money and Property 14,864 3,500 - 18,364 12,476 67.94% 9,988 52.13% 19,158 2,488 24.91% Revenue from Local Agencies 18,975 3,040 - 22,015 12,180 55.33% 11,094 43.51% 25,497 1,086 9.79% Revenue from State of CA 22,111 18,917 - 41,028 3,325 8.10% 3,800 19.08% 19,913 (475) -12.49% Revenue from Federal Government 7,496 4,627 - 12,123 1,394 11.50% 1,489 30.01% 4,962 (95) -6.40% Fees, Rates and Charges 22,373 1,996 - 24,369 14,110 57.90% 12,928 54.79% 23,595 1,182 9.15% Other Revenues 10,258 1,643 - 11,901 13,411 112.69% 284,150 97.56% 291,249 (270,739) -95.28% Total General Revenues 1,283,838 47,020 - 1,330,858 672,973 50.57% 971,714 62.17% 1,562,999 (298,741) -30.74% Transfers & Reimbursements
Overhead Reimbursements 78,155 - - 78,155 65,198 83.42% 47,836 63.11% 75,800 17,362 36.29% Transfers from Other Funds 29,782 2,629 - 32,411 20,544 63.39% 27,060 57.36% 47,176 (6,516) -24.08% Reimbursements for Services 17,831 - - 17,831 9,466 53.09% 22,901 128.86% 17,772 (13,435) -58.67% Total Transfers & Reimbursements 125,768 2,629 - 128,397 95,208 74.15% 97,797 69.48% 140,748 (2,589) -2.65% Total Sources 2,039,233 59,381 84,434 2,183,048 1,491,974 68.34% 1,681,545 72.28% 2,326,552 (189,571) -11.27% (*) - The figures for Current Year-to-Date (YTD) Actual, Prior YTD Actual, and Prior Year-End Actual are reported on the budgetary basis. Consequently, variances from the budgetary basis may arise because certain transactions, such as unrealized gains and losses, are recognized as revenues or expenditures on a Generally Accepted Accounting Principles (GAAP) basis but not on a budgetary 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 29, 2024
(UNAUDITED)
( $000's )

Page 4 ends

EXPENDITURES
PRIOR YTD % % CHANGE

ADOPTED YTD REVISED CUR YTD PRIOR OF PRIOR CUR YTD LESS CUR YTD ACTUAL FY 2023-2024 BUDGET C/O FY 2023-2024 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 17,930 302 52 18,284 9,283 23 50.77% 9,197 64.02% 14,366 86 0.94% City Attorney 17,857 760 1,937 20,554 12,323 2,115 59.95% 11,779 65.16% 18,076 544 4.62% City Auditor 2,922 62 4 2,988 1,730 4 57.90% 1,510 60.47% 2,497 220 14.57% City Clerk 3,857 132 (20) 3,969 2,430 128 61.22% 1,962 58.94% 3,329 468 23.85% City Manager 23,044 956 1,489 25,489 13,942 1,476 54.70% 14,086 68.34% 20,613 (144) -1.02% Finance 23,364 800 1,158 25,322 14,002 1,126 55.30% 12,793 63.74% 20,071 1,209 9.45% Information Technology 32,629 807 4,548 37,984 16,451 4,685 43.31% 14,848 59.50% 24,953 1,603 10.80% Human Resources 15,049 435 312 15,796 9,023 2,324 57.12% 7,241 58.03% 12,479 1,782 24.61% Independent Police Auditor 1,630 87 - 1,717 856 20 49.85% 782 65.00% 1,203 74 9.46% Office of Economic Development 6,410 539 722 7,671 3,833 641 49.97% 3,639 61.97% 5,872 194 5.33% Total General Government 144,692 4,880 10,202 159,774 83,873 12,542 52.49% 77,837 63.05% 123,459 6,036 7.75% Public Safety
Fire 280,269 3,137 2,760 286,166 181,444 2,719 63.41% 178,311 64.03% 278,490 3,133 1.76% Police 505,805 15,964 3,318 525,087 325,628 5,056 62.01% 314,190 76.59% 410,220 11,438 3.64% Total Public Safety 786,074 19,101 6,078 811,253 507,072 7,775 62.50% 492,501 71.51% 688,710 14,571 2.96% Capital Maintenance
Transportation 47,797 1,201 1,188 50,186 28,889 2,797 57.56% 24,928 58.74% 42,441 3,961 15.89% Public Works 48,461 5,055 3,175 56,691 32,323 7,048 57.02% 29,178 64.78% 45,040 3,145 10.78% Total Capital Maintenance 96,258 6,256 4,363 106,877 61,212 9,845 57.27% 54,106 61.85% 87,481 7,106 13.13% Community Service
Housing 601 24 126 751 336 126 44.74% 345 66.86% 516 (9) -2.61% Library 46,409 1,857 1,948 50,214 27,269 5,524 54.31% 26,541 64.42% 41,200 728 2.74% Planning, Bldg & Code Enf. 17,742 1,258 672 19,672 10,557 953 53.67% 9,117 61.25% 14,884 1,440 15.79% Parks, Rec & Neigh Svcs 123,327 2,196 1,836 127,359 74,159 4,527 58.23% 58,341 60.47% 96,475 15,818 27.11% Environmental Services 5,746 167 617 6,530 3,018 1,415 46.22% 2,708 66.68% 4,061 310 11.45% Total Community Services 193,825 5,502 5,199 204,526 115,339 12,545 56.39% 97,052 61.76% 157,136 18,287 18.84% Total Dept. Expenditures 1,220,849 35,739 25,842 1,282,430 767,496 42,707 59.85% 721,496 68.27% 1,056,786 46,000 6.38% (*) - The figures for Current Year-to-Date (YTD) Actual, Prior YTD Actual, and Prior Year-End Actual are reported on the budgetary basis. Consequently, variances from the budgetary basis may arise because certain transactions, such as unrealized gains and losses, are recognized as revenues or expenditures on a Generally Accepted Accounting Principles (GAAP) basis but not on a budgetary basis.

YEAR-TO-DATE

CITY OF SAN JOSE

GENERAL FUND SOURCE AND USE OF FUNDS
FOR THE MONTHS ENDED FEBRUARY 29, 2024
( UNAUDITED )
( $000's )
Note: Figures may not total due to rounding.

Page 5 ends

EXPENDITURES
PRIOR YTD % % CHANGE

ADOPTED YTD REVISED CUR YTD PRIOR OF PRIOR CUR YTD LESS CUR YTD ACTUAL FY 2023-2024 BUDGET C/O FY 2023-2024 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
FOR THE MONTHS ENDED FEBRUARY 29, 2024
( UNAUDITED )
( $000's )
Non-Dept Expenditures
City-wide Expenditures:

Community and Economic Develop. 151,145 29,188 27,904 208,237 25,587 51,645 12.29% 12,736 19.12% 66,605 12,851 100.90% Environmental & Utility Services 2,701 425 386 3,512 1,218 354 34.68% 1,238 66.59% 1,859 (20) -1.62% Public Safety 27,724 8,468 2,173 38,365 20,418 2,392 53.22% 18,382 68.11% 26,987 2,036 11.08% Neighborhood Services 63,686 (6,031) 12,742 70,397 17,699 19,691 25.14% 12,343 23.86% 51,733 5,356 43.39% Transportation Services 5,473 628 9 6,110 1,454 12 23.80% 1,732 45.19% 3,833 (278) -16.05% Strategic Support 75,894 6,884 5,043 87,821 21,182 5,212 24.12% 159,540 49.96% 319,307 (138,358) -86.72% Total City-wide Expenditures 326,623 39,562 48,257 414,442 87,558 79,306 21.13% 205,971 43.79% 470,324 (118,413) -57.49% Other Non-Dept Expenditures:

Capital Improvements 62,264 2,274 10,334 74,872 8,844 21,268 11.81% 17,452 63.85% 27,331 (8,608) -49.32% Transfers to Other Funds 30,406 66 - 30,472 30,472 - 100.00% 37,811 100.00% 37,811 (7,339) -19.41% Total Non-Dept Expenditures 419,293 41,902 58,591 519,786 126,874 100,574 24.41% 261,234 48.79% 535,466 (134,360) -51.43% Reserves
Contingency Reserve 47,000 3,000 - 50,000 - - 0.00% - 0.00% - - 0.00% Earmarked Reserves 352,091 (21,259) - 330,832 - - 0.00% 690 0.00% - (690) -100.00% Total Reserves 399,091 (18,259) - 380,832 - - 0.00% 690 0.00% - (690) -100.00% Total Uses 2,039,233 59,382 84,433 2,183,048 894,370 143,281 40.97% 983,420 61.76% 1,592,252 (89,050) -9.06% Note: Figures may not total due to rounding.
(*) - The figures for Current Year-to-Date (YTD) Actual, Prior YTD Actual, and Prior Year-End Actual are reported on the budgetary basis. Consequently, variances from the budgetary basis may arise because certain transactions, such as unrealized gains and losses, are recognized as revenues or expenditures on a Generally Accepted Accounting Principles (GAAP) basis but not on a budgetary basis.

Page 6 ends

PRIOR YTD % % CHANGE

ADOPTED YTD REVISED CUR CUR YTD PRIOR OF PRIOR CUR YTD LESS CUR YTD ACTUAL FY 2023-2024 BUDGET C/O FY 2023-2024 YTD ACTUAL % YTD YEAR-END PRIOR YTD LESS PRIOR YTD

BUDGET AMENDMENTS ENCUMBR BUDGET ACTUAL OF BUDGET ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL Police 978 278 - 1,256 999 79.54% 623 52.89% 1,178 376 60.35% Public Works - - - - - - 1 0.00% - (1) -100.00%
Transportation 1,899 (3) - 1,896 1,052 55.50% 1,305 79.91% 1,633 (253) -19.37% Library 66 - - 66 72 109.63% 42 53.85% 78 30 72.28%
Planning, Bldg & Code Enforcement - - - - - - 3 0.00% - (3) 0.00% Parks Rec & Neigh Svcs 16,623 2,000 - 18,623 10,377 55.72% 8,783 49.60% 17,707 1,594 18.15% Miscellaneous Dept Charges 2,807 (279) - 2,528 1,610 63.68% 2,171 72.39% 2,999 (561) -25.85% Total Fees, Rates, and Charges 22,373 1,996 - 24,369 14,110 57.90% 12,928 54.79% 23,595 1,182 9.15% Note: Figures may not total due to rounding.
(*) - The figures for Current Year-to-Date (YTD) Actual, Prior YTD Actual, and Prior Year-End Actual are reported on the budgetary basis. Consequently, variances from the budgetary basis may arise because certain transactions, such as unrealized gains and losses, are recognized as revenues or expenditures on a Generally Accepted Accounting Principles (GAAP) basis but not on a budgetary basis. (UNAUDITED)
( $000's )

CITY OF SAN JOSE

GENERAL FUND SOURCE AND USE OF FUNDS
FOR THE MONTHS ENDED FEBRUARY 29, 2024

SUPPLEMENTAL SCHEDULE - DEPARTMENTAL REVENUES

PRIOR YEAR-END

Page 7 ends

Note: 1) FY 2024 revenues have decreased primarily due to the downward trend in real property transfers. 2) Increase in expenditures is due to an increase in the number of construction and capital maintenance projects.
$
$10
$20
$30
$40
$50
$60
$70

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 2022-2023 YTD FY 2023-2024 YTD
$
$10
$20
$30
$40
$50
$60
$70

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 2022-2023 YTD FY 2023-2024 YTD

Page 8 ends

$
$25
$50
$75
$100
$125
$150
$175
$200
$225
$250

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 2022-2023 YTD FY 2023-2024 YTD
$
$15
$30
$45
$60
$75
$90
$105
$120
$135
$150

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 2022-2023 YTD FY 2023-2024 YTD

Page 9 ends

Note: 1) Increase in revenues as of February 2024 is mainly due to transfers from the Sewer Service & Use Charge Fund (541). As of February 2024, $94.9 million was transferred, whereas only $86.8 million was transferred as of February 2023.
2) Increase in expenditures was due to a $19.2 million transfer to the South Bay Water Recycling Operating Fund (570) as of February 2024; whereas $0 million was transferred as of February 2023.
$
$25
$50
$75
$100
$125
$150
$175
$200

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 2022-2023 YTD FY 2023-2024 YTD
$
$25
$50
$75
$100
$125
$150
$175
$200

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 2022-2023 YTD FY 2023-2024 YTD

Page 10 ends

Note: 1) Increase in revenue and expenditure as of February 2024 is due to an internal transfer between General Purpose Parking Funds (533 & 559) by $2.2 million, and an additional expenditure increase of $5.1 million for Parking Garage projects.
-$5
$
$5
$10
$15
$20
$25

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 2022-2023 YTD FY 2023-2024 YTD
$
$5
$10
$15
$20
$25

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 2022-2023 YTD FY 2023-2024 YTD

Page 11 ends

$
$50
$100
$150
$200
$250
$300
$350
$400
$450
$500
$550

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 2022-2023 YTD FY 2023-2024 YTD
$
$50
$100
$150
$200
$250
$300
$350
$400

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 2022-2023 YTD FY 2023-2024 YTD

Page 12 ends

CITY OF SAN JOSE

SPECIAL FUNDS

SOURCE AND USE OF FUNDS
(UNAUDITED)
( $000's )

ADOPTED YTD REVISED PRIOR
FY 2023-2024 BUDGET C/O FY 2023-2024 Y-T-D

BUDGET AMENDMENTS ENCUMBR BUDGET ACTUAL ENCUMBR ACTUAL
Construction/Conveyance Tax
Prior Year Encumbrance - - 11,090 11,090 11,090 - 9,712 Beginning Fund Balance 101,742 15,387 - 117,129 117,129 - 122,254 Revenues 63,259 (6,101) - 57,158 26,146 - 31,790
Total Sources 165,001 9,286 11,090 185,377 154,365 - 163,756 Total Uses 165,001 9,286 11,090 185,377 39,433 13,636 33,243 Airport
Prior Year Encumbrance - - 44,503 44,503 44,503 - 31,244 Beginning Fund Balance 312,656 (5,254) - 307,402 307,402 - 257,271 Revenues 706,209 (12,838) - 693,371 339,708 - 323,937
Total Sources 1,018,865 (18,092) 44,503 1,045,276 691,613 - 612,452 Total Uses 1,018,865 (18,092) 44,503 1,045,276 320,236 42,381 275,268 Waste Water Treatment
Prior Year Encumbrance - - 188,423 188,423 188,423 - 276,774 Beginning Fund Balance 337,449 (59,083) - 278,366 278,366 - 181,203 Revenues 541,583 85,000 - 626,583 470,708 - 404,620
Total Sources 879,032 25,917 188,423 1,093,372 937,497 - 862,597 Total Uses 879,032 25,917 188,423 1,093,372 391,262 181,583 345,261 Parking
Prior Year Encumbrance - - 4,144 4,144 4,144 - 7,501
Beginning Fund Balance 27,298 11,868 - 39,166 39,166 - 38,079 Revenues 19,150 1,143 - 20,293 13,724 - 11,471
Total Sources 46,448 13,011 4,144 63,603 57,034 - 57,051 Total Uses 46,448 13,011 4,144 63,603 21,345 8,943 14,367 Municipal Water
Prior Year Encumbrance - - 4,064 4,064 4,064 - 7,756
Beginning Fund Balance 35,584 2,177 - 37,761 37,761 - 31,638 Revenues 131,902 - - 131,902 54,925 - 45,753
Total Sources 167,486 2,177 4,064 173,727 96,750 - 85,147 Total Uses 167,486 2,177 4,064 173,727 51,307 29,646 43,361 Note: Figures may not total due to rounding.

FOR THE MONTHS ENDED FEBRUARY 29, 2024

YEAR-TO-DATE
(*) Certain accounts such as the change in fair value of investments included in the City's GAAP basis amounts, for which no formal budgets are prepared, are excluded from the budgetary basis amounts.

Page 13 ends

CITY OF SAN JOSE

SPECIAL FUNDS

SOURCE AND USE OF FUNDS
(UNAUDITED)
( $000's )

ADOPTED YTD REVISED PRIOR
FY 2023-2024 BUDGET C/O FY 2023-2024 Y-T-D

BUDGET AMENDMENTS ENCUMBR BUDGET ACTUAL ENCUMBR ACTUAL
FOR THE MONTHS ENDED FEBRUARY 29, 2024

YEAR-TO-DATE
Community Energy
Prior Year Encumbrance - - 22,761 22,761 22,761 - 5,217 Beginning Fund Balance 180,030 (6,304) - 173,726 173,726 - 100,614 Revenues 522,847 1,314 - 524,161 351,760 - 349,470
Total Sources 702,877 (4,990) 22,761 720,648 548,247 - 455,301 Total Uses 702,877 (4,990) 22,761 720,648 268,656 70,451 268,785 Gas Tax
Revenues 17,000 - - 17,000 9,137 - 8,841
Total Sources 17,000 - - 17,000 9,137 - 8,841
Total Uses 17,000 - - 17,000 9,137 - 8,841
Building and Structures
Prior Year Encumbrance - - 22,093 22,093 22,093 - 3,874 Beginning Fund Balance 78,505 1,388 - 79,893 79,893 - 99,342 Revenues 86,569 8,189 - 94,758 28,754 - 22,325
Total Sources 165,074 9,577 22,093 196,744 130,740 - 125,541 Total Uses 165,074 9,577 22,093 196,744 27,765 13,912 16,717 Residential Construction

Beginning Fund Balance 2,695 374 - 3,069 3,069 - 2,891
Revenues 260 35 - 295 198 - 175
Total Sources 2,955 409 - 3,364 3,267 - 3,066
Total Uses 2,955 409 - 3,364 80 - 45
Transient Occupancy Tax
Prior Year Encumbrance - - 775 775 775 - 675
Beginning Fund Balance 4,518 450 - 4,968 4,968 - 5,375
Revenues 24,055 - - 24,055 12,872 - 12,611
Total Sources 28,573 450 775 29,798 18,615 - 18,661
Total Uses 28,573 450 775 29,798 19,548 2,544 15,095
Note: Figures may not total due to rounding.
(*) Certain accounts such as the change in fair value of investments included in the City's GAAP basis amounts, for which no formal budgets are prepared, are excluded from the budgetary basis amounts.

Page 14 ends

CITY OF SAN JOSE

SPECIAL FUNDS

SOURCE AND USE OF FUNDS
(UNAUDITED)
( $000's )

ADOPTED YTD REVISED PRIOR
FY 2023-2024 BUDGET C/O FY 2023-2024 Y-T-D

BUDGET AMENDMENTS ENCUMBR BUDGET ACTUAL ENCUMBR ACTUAL
FOR THE MONTHS ENDED FEBRUARY 29, 2024

YEAR-TO-DATE
Conventions, Arts & Entertainment
Prior Year Encumbrance - - 311 311 311 - 64

Beginning Fund Balance 5,941 (356) - 5,585 5,585 - 3,505 Revenues 11,957 (50) - 11,907 12,287 - 13,067
Total Sources 17,898 (406) 311 17,803 18,183 - 16,636
Total Uses 17,898 (406) 311 17,803 10,818 1,702 12,138
Golf

Beginning Fund Balance 2,646 153 - 2,799 2,799 - 2,749
Revenues 820 6 - 826 1,068 - 324
Total Sources 3,466 159 - 3,625 3,867 - 3,073
Total Uses 3,466 159 - 3,625 179 - 219
Emergency Reserve
Prior Year Encumbrance - - 2,551 2,551 2,551 - 3,897
Beginning Fund Balance 663 (27,539) - (26,876) (26,876) - (31,712) Revenues 20 34,431 - 34,451 998 - 7,149
Total Sources 683 6,892 2,551 10,126 (23,327) - (20,666) Total Uses 683 6,892 2,551 10,126 267 299 1,439
Low and Moderate Income Housing Asset
Prior Year Encumbrance - - 42,837 42,837 42,837 - 53,627 Beginning Fund Balance 52,614 58,327 - 110,941 110,941 - 118,668 Revenues 14,500 - - 14,500 12,596 - 9,931
Total Sources 67,114 58,327 42,837 168,278 166,374 - 128,599 Total Uses 67,114 58,327 42,837 168,278 26,481 49,134 24,050 Other Special Revenue Funds
Prior Year Encumbrance - - 46,858 46,858 46,858 - 51,425 Beginning Fund Balance 395,463 2,075 - 397,538 397,538 - 487,616 Revenues 630,726 46,931 - 677,657 459,727 - 421,197
Total Sources 1,026,189 49,006 46,858 1,122,053 904,123 - 960,238 Total Uses 1,026,189 49,006 46,858 1,122,053 360,556 177,722 333,368 Note: Figures may not total due to rounding.
(*) Certain accounts such as the change in fair value of investments included in the City's GAAP basis amounts, for which no formal budgets are prepared, are excluded from the budgetary basis amounts.

Page 15 ends

CITY OF SAN JOSE

CAPITAL PROJECT FUNDS

SOURCE AND USE OF FUNDS
(UNAUDITED)
( $000's )

ADOPTED YTD REVISED PRIOR
FY 2023-2024 BUDGET C/O FY 2023-2024 Y-T-D

BUDGET AMENDMENTS ENCUMBR BUDGET ACTUAL ENCUMBR ACTUAL
Construction Excise
Prior Year Encumbrance - - 28,547 28,547 28,547 - 53,704 Beginning Fund Balance 89,219 (9,803) - 79,416 79,416 - 225,244 Revenues 97,043 41,492 - 138,535 53,801 - 43,592
Total Sources 186,262 31,689 28,547 246,498 161,764 - 322,540 Total Uses 186,262 31,689 28,547 246,498 73,646 28,120 108,535 Other Capital Funds
Prior Year Encumbrance - - 22,905 22,905 22,905 - 1,102 Beginning Fund Balance 172,546 23,720 - 196,266 196,266 - 43,738 Revenues 350 - - 350 4,277 - 196
Total Sources 172,896 23,720 22,905 219,521 223,448 - 45,036 Total Uses 172,896 23,720 22,905 219,521 35,010 78,027 18,395 Note: Figures may not total due to rounding.

FOR THE MONTHS ENDED FEBRUARY 29, 2024

YEAR-TO-DATE
(*) Certain accounts such as the change in fair value of investments included in the City's GAAP basis amounts, for which no formal budgets are prepared, are excluded from the budgetary basis amounts.

Page 16 ends

CITY OF SAN JOSE

OTHER FUND TYPES
(UNAUDITED)
( $000's )

ADOPTED YTD REVISED PRIOR
FY 2023-2024 BUDGET C/O FY 2023-2024 Y-T-D

BUDGET AMENDMENTS ENCUMBR BUDGET ACTUAL ENCUMBR ACTUAL
Trust and Agency
Prior Year Encumbrance - - 379 379 379 - 430
Beginning Fund Balance 4,509 5,240 - 9,749 9,749 - 11,993 Revenues 3,920 96 - 4,016 3,066 - 4,445
Total Sources 8,429 5,336 379 14,144 13,194 - 16,868
Total Uses 8,429 5,336 379 14,144 4,606 37 3,928
Note: Figures may not total due to rounding.

FOR THE MONTHS ENDED FEBRUARY 29, 2024

SOURCE AND USE OF FUNDS

YEAR-TO-DATE
(*) Certain accounts such as the change in fair value of investments included in the City's GAAP basis amounts, for which no formal budgets are prepared, are excluded from the budgetary basis amounts.

Page 17 ends
← All documents from this meeting