!PRILº
º
Attachment: Finance Department Monthly Financial Report
!PRILº
/-0!1)4/.:/&:611%.5: %!14:/.5(,9:!4(:!,!.#%:74:
1)/1: %!14:!,!.#%:::
/-0!1)4/.:/&:611%.5: %!15/!5%:%7%.6%4:74:
1)/1: %!15/!5%:%7%.6%4:::
/-0!1)4/.:/&:611%.5: %!15/!5%:80%.$)561%4:74:
1)/1: %!15/!5%:80%.$)561%4:::
/-0!1)4/.:/&:611%.5: %!15/!5%:%7%.6%4:&/1:!*/1:%7%.6%:
/61#%4:
74:1)/1: %!25/!5%:%7%.6%4:::
/-0!1)4/.:/&:611%.5: %!15/!5%:80%.$)561%4:"9:
90%:
74:1)/1: %!25/!5%:80%.$)561%4:::
/61#%:!.$:
4%:/&:6.$4:::
600,%-%.5!,:
#(%$6,%:/&:%0!15-%.5!,:%7%.6%4:::
/-0!1)4/.:/&:611%.5: %!15/!5%:/.4516#5)/.::/.7%9!.#%:
!8:%7%.6%4:
74:1)/1: %!15/!5%:%7%.6%4:::
/-0!1)4/.:/&:611%.5: %!15/!5%:/.4516#5)/.::/.7%9!.#%:
!8:80%.$)561%4:
74:1)/1: %!15/!5%:80%.$)561%4:::
/-0!1)4/.:/&: %!15/!5%:%7%.6%4:!.$:
:80%.$)561%4:74:1)/1: %!15/!5%:
%7%.6%:!.$:80%.$)561%4:&/1:
)10/3:%7%.6%:6.$:
:!.$:)10/15:!).5%.!.#%::0%1!5)/.:6.$:
:::
:0%1!5)/.: 6.$:
:::
%.%1!,:610/4%:!1+).':6.$:
::
:::
,%!.:.%1'9:6.$:
:::
/61#%:!.$:
4%:/&:6.$4:::
:
:
:
:
:
:
:
:
:
:
:
:
:
:
!"
"
"
"
"
" "
"
"!PRILº"
"
"
"
"
"
""
"
"
"""""""""""""""""""""""""""""""""""""""""""""""""" "
""
"
"
"""""""""""""""""""""""""""""""""""""""""""""""""" " "!"
"
"
"
"
"
Rick
Bruneau
Digitally signed by Rick
Bruneau
Date: 2024.06.04
11:39:16 -07'00'
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) 710,351,741 529,348,366 580,885,854 108,130,590 FEBRUARY 520,153,859 584,487,275 496,453,999 217,629,193 MARCH 528,642,315 559,096,267 508,488,546 200,717,737
APRIL (3) 615,840,435 603,219,478 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.0 (2) The General Fund Cash balance increased in January due to the bi-annual receipt of property taxes from Santa Clara County.
(3) The General Fund Cash balance increased in April due to the following: $29.0M in property tax, $31.1M in franchise fees, and $13.7M in state revenues.
$
$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
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.0 million TRAN debt service expenditures as of April 2023 compared to $0 as of April 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
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.0 million TRAN debt service expenditures as of April 2023 compared to $0 as of April 2024. $
$50
$100
$150
$200
$250
$300
$350
$400
$450
$500
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
$400
$450
$500
(MILLIONS)
GENERAL FUND MAJOR EXPENDITURES
Comparison of YTD vs. Prior YTD
FY 2022-2023 YTD FY 2023-2024 YTD
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 - - 81,740 81,740 81,740 100.00% 52,956 82.98% 63,818 28,784 54.35%Available Balance 9,732 629,627 - 639,359 639,359 100.00% 558,987 100.00% 558,987 80,372 14.38% Total Fund Balance 9,732 629,627 81,740 721,099 721,099 100.00% 611,943 98.26% 622,805 109,156 17.84%General Revenues Property Tax 13,500 460,400 - 473,900 305,463 64.46% 286,399 63.78% 449,014 19,064 6.66% Sales Tax - 336,400 - 336,400 222,581 66.17% 205,344 59.78% 343,472 17,237 8.39%Telephone Line Tax - 22,000 - 22,000 16,263 73.92% 14,415 68.34% 21,094 1,848 12.82%Transient Occupancy Tax - 16,000 - 16,000 11,131 69.57% 10,546 70.60% 14,937 585 5.55%Franchise Fees - 51,825 - 51,825 45,423 87.65% 37,933 84.63% 44,824 7,490 19.75%Utility Tax - 126,550 - 126,550 100,763 79.62% 96,018 77.27% 124,267 4,745 4.94%Business Taxes - 87,500 - 87,500 68,973 78.83% 71,082 79.31% 89,627 (2,109) -2.97%Real Property Transfer Tax 50,000 50,000 33,050 66.10% 44,009 78.20% 56,280 (10,959) -24.90%Licenses and Permits (202) 22,006 - 21,804 20,770 95.26% 17,844 100.49% 17,757 2,926 16.40%Fines, Forfeits and Penalties - 15,080 - 15,080 12,084 80.13% 13,550 78.08% 17,353 (1,466) -10.82%Use of Money and Property 3,500 14,864 - 18,364 16,478 89.73% 13,857 72.33% 19,158 2,621 18.91%Revenue from Local Agencies 3,040 18,975 - 22,015 14,368 65.27% 12,948 50.78% 25,497 1,420 10.97%Revenue from State of CA 20,586 22,111 - 42,697 18,295 42.85% 16,975 85.25% 19,913 1,320 7.78%Revenue from Federal Government 5,000 7,391 - 12,391 2,585 20.86% 2,639 53.18% 4,962 (54) -2.05%Fees, Rates and Charges 1,996 22,373 - 24,369 19,775 81.15% 17,737 75.17% 23,595 2,038 11.49%Other Revenues 1,643 10,258 - 11,901 16,915 142.13% 285,516 98.03% 291,249 (268,601) -94.08% Total General Revenues 49,062 1,283,733 - 1,332,795 924,917 69.40% 1,146,812 73.37% 1,562,999 (221,895) -19.35%Transfers & Reimbursements Overhead Reimbursements - 78,155 - 78,155 71,801 91.87% 50,700 66.89% 75,800 21,101 41.62% Transfers from Other Funds 2,629 29,782 - 32,411 26,689 82.35% 30,001 63.59% 47,176 (3,312) -11.04%Reimbursements for Services - 17,831 - 17,831 12,401 69.55% 30,184 169.84% 17,772 (17,783) -58.92% Total Transfers & Reimbursements 2,629 125,768 - 128,397 110,891 86.37% 110,885 78.78% 140,748 6 0.01%Total Sources 61,423 2,039,128 81,740 2,182,291 1,756,907 80.51% 1,869,640 80.36% 2,326,552 (112,733) -6.03% (*) - 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 APRIL 30, 2024
(UNAUDITED)
( $000's )
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 302 17,930 52 18,284 11,411 48 62.41% 11,337 78.92% 14,366 74 0.65% City Attorney 1,510 17,857 1,937 21,304 15,198 1,801 71.34% 14,723 81.45% 18,076 475 3.23% City Auditor 62 2,922 4 2,988 2,153 4 72.05% 1,928 77.21% 2,497 225 11.67% City Clerk 132 3,857 (20) 3,969 2,975 239 74.96% 2,559 76.87% 3,329 416 16.26%City Manager 956 23,044 1,439 25,439 17,804 1,232 69.99% 17,216 83.52% 20,613 588 3.42% Finance 799 23,364 1,158 25,321 17,690 1,450 69.86% 15,928 79.36% 20,071 1,762 11.06% Information Technology 807 32,629 4,548 37,984 21,007 3,791 55.30% 18,437 73.89% 24,953 2,570 13.94% Human Resources 435 15,049 156 15,640 11,380 1,526 72.76% 9,308 74.59% 12,479 2,072 22.26% Independent Police Auditor 87 1,630 - 1,717 1,035 - 60.28% 966 80.30% 1,203 69 7.14%Office of Economic Development 539 6,410 697 7,646 4,786 632 62.59% 4,546 77.42% 5,872 240 5.28% Total General Government 144,692 5,629 9,971 160,292 105,439 10,723 65.78% 96,948 78.53% 8,491 123,459 8.76% Public Safety
Fire 280,269 3,137 286,166 2,760 225,565 2,998 78.82% 221,319 79.47% 278,490 1.92% 4,246 Police 505,805 15,964 524,796 3,027 404,432 4,295 77.06% 391,305 95.39% 410,220 3.35% 13,127 Total Public Safety 786,074 19,101 5,787 810,962 629,997 7,293 77.69% 612,624 88.95% 17,373 688,710 2.84% Capital Maintenance
Transportation 47,797 1,201 50,186 1,188 36,557 2,296 72.84% 32,085 75.60% 42,441 13.94% 4,472 Public Works 48,461 5,055 56,691 3,175 42,657 3,315 75.24% 36,980 82.10% 45,040 15.35% 5,677 Total Capital Maintenance 96,258 6,256 4,363 106,877 79,214 5,611 74.12% 69,065 78.95% 10,149 87,481 14.69% Community Service
Housing 601 24 751 126 470 126 62.58% 308 59.69% 516 52.60% 162 Library 46,409 1,857 50,214 1,948 35,155 4,413 70.01% 33,098 80.33% 41,200 6.21% 2,057 Planning, Bldg & Code Enf. 17,742 1,258 19,672 672 13,221 729 67.21% 11,518 77.39% 14,884 14.79% 1,703 Parks, Rec & Neigh Svcs 123,327 2,196 127,359 1,836 95,623 4,534 75.08% 73,130 75.80% 96,475 30.76% 22,493 Environmental Services 5,746 167 6,410 497 3,899 1,217 60.83% 3,335 82.12% 4,061 16.91% 564 Total Community Services 193,825 5,502 5,079 204,406 148,368 11,019 72.58% 121,389 77.25% 26,979 157,136 22.23% Total Dept. Expenditures 1,220,849 36,488 25,200 1,282,537 963,018 34,646 75.09% 900,026 85.17% 62,992 1,056,786 7.00% (*) - 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 APRIL 30, 2024
( UNAUDITED )
( $000's )
Note: Figures may not total due to rounding.
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 APRIL 30, 2024
( UNAUDITED )
( $000's )
Non-Dept Expenditures
City-wide Expenditures: Community and Economic Develop. 151,145 26,580 53,329 231,054 33,149 48,620 14.35% 23,936 35.94% 66,605 38.49% 9,213 Environmental & Utility Services 2,596 376 530 3,502 1,250 337 35.69% 1,372 73.80% 1,859 -8.89% (122) Public Safety 27,724 2,173 8,736 38,633 25,431 2,944 65.83% 22,557 83.58% 26,987 12.74% 2,874 Neighborhood Services 63,686 12,103 (8,118) 67,671 22,551 15,585 33.32% 16,459 31.82% 51,733 37.01% 6,092 Transportation Services 5,473 9 628 6,110 2,112 12 34.57% 2,672 69.71% 3,833 -20.96% (560) Strategic Support 75,894 4,965 7,140 87,999 26,731 5,134 30.38% 164,890 51.64% 319,307 -83.79% (138,159) Total City-wide Expenditures 326,518 62,245 46,206 434,969 111,224 72,632 25.57% 231,886 49.30% (120,662) 470,324 -52.04% Other Non-Dept Expenditures: Capital Improvements 62,264 15,703 88,301 10,334 11,465 20,985 12.98% 20,523 75.09% 27,331 (9,058) -44.14% Transfers to Other Funds 30,406 66 30,472 - 30,472 - 100.00% 37,811 100.00% 37,811 -19.41% (7,339) Total Non-Dept Expenditures 419,188 78,014 56,540 553,742 153,161 93,617 27.66% 290,220 54.20% (137,059) 535,466 -47.23% Reserves
Contingency Reserve 47,000 3,000 50,000 - - - 0.00% - 0.00% - 0.00% - Earmarked Reserves 352,091 (56,079) 296,012 - - - 0.00% 1,054 0.00% - -100.00% (1,054) Total Reserves 399,091 (53,079) - 346,012 - - 0.00% 1,054 0.00% (1,054) - -100.00% Total Uses 61,423 2,039,128 81,740 2,182,291 1,116,179 128,263 51.15% 1,191,300 74.82% (75,121) 1,592,252 -6.31% 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.
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 1 ,256 88.69% 778 ,114 66.04% 1,178 43.19% 336 Public Works - - - - 8 - 1 0.00% - 700.00% 7
Transportation 1,899 - (3) 1 1 ,896 68.88% 1 ,306 ,498 91.73% 1,633 -12.82% (192) Library - 66 - 66 92 139.39% 59 75.64% 78 55.93% 33
Planning, Bldg & Code Enforcement - - - - - - 4 0.00% - 0.00% (4) Parks Rec & Neigh Svcs 16 2 ,623 - ,000 18 14 ,623 80.48% 12 ,987 ,851 72.58% 17,707 16.62% 2,136 Miscellaneous Dept Charges 2,807 - (279) 2 2 ,528 89.72% 2 ,268 ,546 84.89% 2,999 -10.92% (278)Total Fees, Rates, and Charges 1,996 22,373 - 24,369 19,775 81.15% 17,737 75.17% 2,038 23,595 11.49% 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 APRIL 30, 2024
SUPPLEMENTAL SCHEDULE - DEPARTMENTAL REVENUES
PRIOR YEAR-END
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
$
$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
Note: 1) Increase in revenues as of April 2024 is mainly due to transfers from the Sewer Service & Use Charge Fund (541). As of April 2024, $94.9 million was transferred, whereas only $86.8 million was transferred as of April 2023.
2) Increase in expenditures was due to a $19.2 million transfer to the South Bay Water Recycling Operating Fund (570) as of April 2024; whereas $1.0 million was transferred as of April 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
Note: 1) Increase in revenue and expenditure as of April 2024 is due to an internal transfer between General Purpose Parking Funds (533 & 559) by $2.2 million, and an additional expenditure increase of $3.4 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
$
$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
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 31,692 - 36,670
Total Sources 9,286 165,001 11,090 185,377 159,911 - 168,636 Total Uses 9,286 165,001 11,090 185,377 48,324 14,346 41,351 Airport
Prior Year Encumbrance - - 43,524 43,524 43,524 - 31,244 Beginning Fund Balance 312,656 (5,254) - 307,402 307,402 - 257,271 Revenues 706,209 - (12,838) 693,371 489,082 - 435,388
Total Sources (18,092) 1,018,865 43,524 1,044,297 840,008 - 723,903 Total Uses (18,092) 1,018,865 43,524 1,044,297 420,597 59,837 370,324 Waste Water Treatment
Prior Year Encumbrance - - 181,677 181,677 181,677 - 276,774 Beginning Fund Balance 337,449 (59,083) - 278,366 278,366 - 181,203 Revenues 541,583 85,000 - 626,583 459,186 - 745,195
Total Sources 25,917 879,032 181,677 1,086,626 919,229 - 1,203,172 Total Uses 25,917 879,032 181,677 1,086,626 449,199 225,412 402,419 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 16,717 - 14,127
Total Sources 13,011 46,448 4,144 63,603 60,027 - 59,707 Total Uses 13,011 46,448 4,144 63,603 23,348 7,834 17,930 Municipal Water
Prior Year Encumbrance - - 3,894 3,894 3,894 - 7,756
Beginning Fund Balance 35,584 2,177 - 37,761 37,761 - 31,638 Revenues 131,902 - - 131,902 64,417 - 53,528
Total Sources 2,177 167,486 3,894 173,557 106,072 - 92,922 Total Uses 2,177 167,486 3,894 173,557 58,862 29,075 52,076 Note: Figures may not total due to rounding.
FOR THE MONTHS ENDED APRIL 30, 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.
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 APRIL 30, 2024
YEAR-TO-DATE
Community Energy
Prior Year Encumbrance - - 22,754 22,754 22,754 - 5,217 Beginning Fund Balance 180,030 (6,304) - 173,726 173,726 - 100,614 Revenues 522,847 1,314 - 524,161 447,362 - 424,137
Total Sources (4,990) 702,877 22,754 720,641 643,842 - 529,968 Total Uses (4,990) 702,877 22,754 720,641 337,248 56,059 322,145 Gas Tax
Revenues 17,000 - - 17,000 11,953 11,518 -
Total Sources - 17,000 - 17,000 11,953 11,518 -
Total Uses - 17,000 - 17,000 11,953 - 8,841
Building and Structures
Prior Year Encumbrance - - 22,036 22,036 22,036 - 3,874 Beginning Fund Balance 78,505 1,388 - 79,893 79,893 - 99,342 Revenues 86,569 9,133 - 95,702 36,715 - 26,104
Total Sources 10,521 165,074 22,036 197,631 138,644 - 129,320 Total Uses 10,521 165,074 22,036 197,631 33,473 14,395 21,934 Residential Construction
Beginning Fund Balance 2,695 374 - 3,069 3,069 - 2,891
Revenues 260 35 - 295 237 - 209
Total Sources 409 2,955 - 3,364 3,306 - 3,100
Total Uses 409 2,955 - 3,364 103 - 64
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 16,743 - 15,789
Total Sources 450 28,573 775 29,798 20,090 2,392 21,839 Total Uses 450 28,573 775 29,798 19,548 2,544 16,505
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.
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 APRIL 30, 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,453 - 13,161
Total Sources (406) 17,898 311 17,803 18,349 - 16,730
Total Uses (406) 17,898 311 17,803 10,887 1,702 12,405
Golf
Beginning Fund Balance 2,646 153 - 2,799 2,799 - 2,749
Revenues 820 6 - 826 1,087 - 352
Total Sources 159 3,466 - 3,625 3,886 - 3,101
Total Uses 159 3,466 - 3,625 179 - 280
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 6,892 683 2,551 10,126 (23,327) - (20,666) Total Uses 6,892 683 2,551 10,126 329 69 1,940
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 17,381 - 10,733
Total Sources 58,327 67,114 42,837 168,278 171,159 - 129,401 Total Uses 58,327 67,114 42,837 168,278 33,136 68,693 29,970 Other Special Revenue Funds
Prior Year Encumbrance - - 44 44 ,642 44 ,642 - ,642 51 ,408 Beginning Fund Balance 395,463 3,777 - 399,240 399,240 - 487,616 Revenues 630,726 49,662 - 680,388 528,691 - 483,758
Total Sources 53,439 1,026,189 44,642 1,124,270 972,573 - 1,022,782 Total Uses 53,439 1,026,189 44,642 1,124,270 460,631 150,908 423,491 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.
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 - - 26,043 26,043 26,043 - 53,704 Beginning Fund Balance 89,219 (9,803) - 79,416 79,416 - 225,244 Revenues 97,043 41,578 - 138,621 63,557 - 56,678
Total Sources 31,775 186,262 26,043 244,080 169,016 - 335,626 Total Uses 31,775 186,262 26,043 244,080 85,181 25,747 125,416 Other Capital Funds
Prior Year Encumbrance - - 22,900 22,900 22,900 - 1,102 Beginning Fund Balance 172,546 23,720 - 196,266 196,266 - 43,738 Revenues 350 - - 350 6,569 - 327
Total Sources 23,720 172,896 22,900 219,516 225,735 - 45,167 Total Uses 23,720 172,896 22,900 219,516 48,565 91,298 20,448 Note: Figures may not total due to rounding.
FOR THE MONTHS ENDED APRIL 30, 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.
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 296 - 4,216 4,613 - 4,582
Total Sources 5,536 8,429 379 14,344 14,741 - 17,005
Total Uses 5,536 8,429 379 14,344 4,712 90 5,524
Note: Figures may not total due to rounding.
FOR THE MONTHS ENDED APRIL 30, 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.