CITYOF A
SANJOSE
CAPITAL OF SILICON VALLEY
FINANCE DEPARTMENT
Monthly Financial Report
Financial Results for the Month Ended August 31, 2023
Fiscal Year 2023-2024
(UNAUDITED)
General Fund
Finance Department, City of San Jose
Monthly Financial Report
Financial Results for the Month Ended August 31, 2023
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 August 31, 2023
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 - 542,042,503 428,548,372 215,370,108
OCTOBER - 564,251,170 440,238,436 170,467,897
NOVEMBER - 622,142,937 442,957,719 100,622,899
DECEMBER - 613,707,115 437,194,188 71,502,262
JANUARY - 710,351,741 580,885,854 108,130,590
FEBRUARY - 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.
$
$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 Balance
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.
$
$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
Actual
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 Actual
FY 2022-2023 YTD FY 2023-2024 YTD
Note: 1) The 'Other Revenue' category was omitted from the General Fund Major Revenues chart to prevent the yaxis from extending to $300 million, which would make other categories illegible. FY 2024 YTD actual other revenue was $10.3 million, down from $279.6 million in FY 2023. 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) Sales Tax revenue lower in FY 2024 is due to a timing difference in posting Sales Tax receipts. $
$20
$40
$60
$80
Sales Tax Util Tax Business Taxes Fran Fees Real Prop
Transfer Tax
Licenses and
Permits
(MILLIONS)
GENERAL FUND MAJOR REVENUES
Comparison of YTD Actual vs. Prior YTD Actual
FY 2022-2023 YTD FY 2023-2024 YTD
$
$20
$40
$60
$80
(MILLIONS)
GENERAL FUND MAJOR EXPENDITURES
Comparison of YTD Actual vs. Prior YTD Actual
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,495 81,495 81,495 100.00% 53,358 83.61% 63,818 28,137 52.73%Available Balance - 629,627 - 629,627 629,627 100.00% 507,609 90.81% 558,987 122,018 24.04% Total Fund Balance - 629,627 81,495 711,122 711,122 100.00% 560,967 90.07% 622,805 150,155 26.77%General Revenues Property Tax - 460,400 - 460,400 - 0.00% - 0.00% 449,014 - 0.00% Sales Tax - 336,400 - 336,400 - 0.00% 8,400 2.45% 343,472 (8,400) -100.00%Telephone Line Tax - 22,000 - 22,000 1,783 8.10% 1,386 6.57% 21,094 397 28.64%Transient Occupancy Tax - 16,000 - 16,000 1,012 6.33% 857 5.74% 14,937 155 18.09%Franchise Fees - 51,825 - 51,825 1,344 2.59% 1,120 2.50% 44,824 224 20.00%Utility Tax - 126,550 - 126,550 12,911 10.20% 9,847 7.92% 124,267 3,064 31.12%Business Taxes - 87,500 - 87,500 11,642 13.31% 11,814 13.18% 89,627 (172) -1.46%Real Property Transfer Tax 50,000 50,000 3,911 7.82% 8,838 15.70% 56,280 (4,927) -55.75%Licenses and Permits - 22,006 - 22,006 6,606 30.02% 4,076 22.95% 17,757 2,530 62.07%Fines, Forfeits and Penalties - 15,080 - 15,080 2,014 13.36% 1,987 11.45% 17,353 27 1.36%Use of Money and Property - 14,864 - 14,864 3,130 21.06% 1,140 5.95% 19,158 1,990 174.56%Revenue from Local Agencies - 18,975 - 18,975 310 1.63% 1,017 3.99% 25,497 (707) -69.52%Revenue from State of CA 759 22,111 - 22,870 352 1.54% (376) -1.89% 19,913 728 -193.62%Revenue from Federal Government 36 7,496 - 7,532 195 2.59% (303) -6.11% 4,962 498 -164.36%Fees, Rates and Charges - 22,373 - 22,373 4,793 21.42% 2,399 10.17% 23,595 2,394 99.79%Other Revenues - 10,258 - 10,258 10,275 100.17% 279,558 95.99% 291,249 (269,283) -96.32% Total General Revenues 795 1,283,838 - 1,284,633 60,278 4.69% 331,760 21.23% 1,562,999 (271,482) -81.83%Transfers & Reimbursements Overhead Reimbursements - 89,127 89,127 42,906 48.14% 38,699 51.05% 75,800 4,207 10.87% Transfers from Other Funds - 9,898 - 9,898 12,997 131.31% 7,240 15.35% 47,176 5,757 79.52%Reimbursements for Services - 26,743 - 26,743 0.00% - 0.00% 17,772 - 0.00% Total Transfers & Reimbursements - 125,768 - 125,768 55,903 44.45% 45,939 32.64% 140,748 9,964 21.69%Total Sources 795 2,039,233 81,495 2,121,523 827,303 39.00% 938,666 40.35% 2,326,552 (111,363) -11.86% (*) - 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 AUGUST 31, 2023
(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 - 17,930 52 17,982 1,965 82 10.93% 2,191 15.25% 14,366 (226) -10.31% City Attorney - 17,857 1,937 19,794 2,836 2,391 14.33% 2,454 13.58% 18,076 382 15.57%City Auditor - 2,922 4 2,926 355 4 12.13% 338 13.54% 2,497 17 5.03% City Clerk - 3,857 (20) 3,837 430 218 11.21% 364 10.93% 3,329 66 18.13% City Manager - 23,044 1,489 24,533 2,954 1,944 12.04% 2,791 13.54% 20,613 163 5.84%Finance - 23,364 1,158 24,522 2,614 1,304 10.66% 2,404 11.98% 20,071 210 8.74%Information Technology - 32,629 4,548 37,177 3,408 4,841 9.17% 2,550 10.22% 24,953 858 33.65%Human Resources - 15,049 354 15,403 1,715 4,582 11.13% 1,403 11.24% 12,479 312 22.24%Redevelopment Agency - - - - - - 0.00% - 0.00% - - 0.00%Planning Commission - - - - - - 0.00% - 0.00% - - 0.00% Civil Service Commission - - - - - - 0.00% - 0.00% - - 0.00%Independent Police Auditor - 1,630 - 1,630 205 - 12.58% 175 14.55% 1,203 30 17.14% Office of Economic Development - 6,410 722 7,132 751 706 10.53% 828 14.10% 5,872 (77) -9.30% Office of Emergency Services - - - - - - 0.00% 0.00% - - 0.00% Total General Government 144,692 - 10,244 154,936 17,233 16,072 11.12% 15,498 12.55% 1,735 123,459 11.19% Public Safety
Fire 280,269 - 283,030 2,761 39,506 3,089 13.96% 39,652 14.24% 278,490 -0.37% (146) Police 505,805 - 509,123 3,318 69,881 4,172 13.73% 66,468 16.20% 410,220 5.13% 3,413 Total Public Safety 786,074 - 6,079 792,153 109,387 7,261 13.81% 106,120 15.41% 3,267 688,710 3.08% Capital Maintenance
Transportation 47,797 - 48,985 1,188 5,823 3,875 11.89% 4,739 11.17% 42,441 22.87% 1,084 Public Works 48,461 - 51,636 3,175 8,842 4,837 17.12% 5,642 12.53% 45,040 56.72% 3,200 Total Capital Maintenance 96,258 - 4,363 100,621 14,665 8,712 14.57% 10,381 11.87% 4,284 87,481 41.27% Community Service
Housing 601 - 727 126 36 126 4.95% 46 8.91% 516 -21.74% (10) Library 46,409 - 48,357 1,948 5,668 5,450 11.72% 4,984 12.10% 41,200 13.72% 684Planning, Bldg & Code Enf. 17,742 - 18,414 672 2,156 712 11.71% 1,985 13.34% 14,884 8.61% 171Parks, Rec & Neigh Svcs 123,327 - 125,163 1,836 14,470 4,308 11.56% 13,197 13.68% 96,475 9.65% 1,273 Environmental Services 5,746 - 6,367 621 356 1,827 5.59% 422 10.39% 4,061 -15.64% (66) Conventions, Arts & Enter - - - - - - 0.00% - 0.00% - 0.00% - Total Community Services 193,825 - 5,203 199,028 22,686 12,423 11.40% 20,634 13.13% 2,052 157,136 9.94%Total Dept. Expenditures 1,220,849 - 25,889 1,246,738 163,971 44,468 13.15% 152,633 14.44% 11,338 1,056,786 7.43%(*) - 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
FOR THE MONTHS ENDED AUGUST 31, 2023
( 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 AUGUST 31, 2023
( UNAUDITED )
( $000's )
Non-Dept Expenditures
City-wide Expenditures: Community and Economic Develop. 151,145 25,708 - 176,853 (7,914) 38,900 -4.47% (6,628) -9.95% 66,605 19.40% (1,286) Environmental & Utility Services 2,701 232 - 2,933 3 477 0.10% (37) -1.99% 1,859 -108.11% 40 Public Safety 27,724 2,194 795 30,713 4,847 2,197 15.78% 3,519 13.04% 26,987 37.74% 1,328 Neighborhood Services 63,686 12,255 - 75,941 (21) 18,333 -0.03% 472 0.91% 51,733 -104.45% (493) Transportation Services 5,473 9 - 5,482 378 9 6.90% 88 2.30% 3,833 329.55% 290 Strategic Support 75,894 4,874 - 80,768 2,632 5,326 3.26% 3,510 1.10% 319,307 -25.01% (878)Total City-wide Expenditures 326,623 795 45,272 372,690 (75) 65,242 -0.02% 924 0.20% (999) 470,324 -108.12% Other Non-Dept Expenditures: Capital Improvements 62,264 - 72,598 10,334 682 11,142 0.94% 981 3.59% 27,331 (299) -30.48% Transfers to Other Funds 30,406 - 30,406 - - - 0.00% 25,469 67.36% 37,811 -100.00% (25,469) Other Operating Expenditures - - - - - - 0.00% - 0.00% - 100.00% - Total Non-Dept Expenditures 419,293 795 55,606 475,694 607 76,384 0.13% 27,374 5.11% (26,767) 535,466 -97.78% Reserves
Contingency Reserve 47,000 - 47,000 - - - 0.00% - 0.00% - 0.00% - Earmarked Reserves 352,091 - 352,091 - - - 0.00% - 0.00% - 0.00% - Total Reserves 399,091 - - 399,091 - - 0.00% - 0.00% - - 0.00% Total Uses 795 2,039,233 81,495 2,121,523 164,578 120,852 7.76% 180,007 11.31% (15,429) 1,592,252 -8.57% 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 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 - - 978 214 21.88% 177 15.03% 1,178 20.90% 37 Public Works - - - - - - 1 0.00% - -100.00% (1)
Transportation 1 - ,899 - 1 636 ,899 33.49% 255 15.62% 1,633 149.41% 381 Library - 66 - 66 18 27.27% 11 14.10% 78 63.64% 7
Planning, Bldg & Code Enforcement - - - - - - - 0.00% - 0.00% - Parks Rec & Neigh Svcs 16 - ,623 - 16 3 ,623 19.50% 1 ,242 ,436 8.11% 17,707 125.77% 1,806 Miscellaneous Dept Charges - 2,807 - 2 683 ,807 24.33% 519 17.31% 2,999 31.60% 164 Total Fees, Rates, and Charges - 22,373 - 22,373 4,793 21.42% 2,399 10.17% 2,394 23,595 99.79%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 AUGUST 31, 2023
SUPPLEMENTAL SCHEDULE - DEPARTMENTAL REVENUES
PRIOR YEAR-END
Note: 1) August 2023 revenues were lower primarily due to a timing difference in posting the construction and conveyance tax transfer from the General Fund to the Communications Construction and Conveyance Tax Fund (397).
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
Note: 1) Increase in expeditures as of August 2023 is mainly due to a lump-sum overhead reimbursement to General Fund for $5.2 million in August 2023 compared to $1.4 million in August 2022. $
$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) August 2023 revenues were higher due to a timing difference in posting transfers from the Sewer Service & Use Charge Fund (541). In August 2023, $94.9 million was transferred, whereas there were no transfers in August 2022.
2) Increase in expenditures in August 2023 was due to a $19.2 million transfer to South Bay Water Recycling Operating Fund (570); whereas $0 was transferred in August 2022. $
$25
$50
$75
$100
$125
$150
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
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 August 2023 is due to an internal transfer between General Purpose Parking Funds (533 & 559) for $4 million, and an additional increase of $5 million for Downtown Parking Garage projects, whereas only $32 thousand was expended as of August 2022. -$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
Note: 1) Increase in Clean Energy expenditures is due to the increase in Cost of Energy for $83.2 million as of August 2023 compared to $67.1 million as of August 2022. $
$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,202 11,202 11,202 - 9,867 Beginning Fund Balance 101,742 - - 101,742 101,742 - 107,423 Revenues 63,259 - - 63,259 3,444 - 8,451
Total Sources - 165,001 11,202 176,203 116,388 - 125,741 Total Uses - 165,001 11,202 176,203 14,353 11,984 4,585 Airport
Prior Year Encumbrance - - 45,467 45,467 45,467 - 31,540 Beginning Fund Balance 312,656 - - 312,656 312,656 - 230,050 Revenues 706,209 - - 706,209 30,328 - 32,537
Total Sources - 1,018,865 45,467 1,064,332 388,451 - 294,127 Total Uses - 1,018,865 45,467 1,064,332 23,910 56,425 17,294 Waste Water Treatment
Prior Year Encumbrance - - 189,216 189,216 189,216 - 276,775 Beginning Fund Balance 337,449 - - 337,449 337,449 - 303,253 Revenues 541,583 - - 541,583 414,611 - 196,848
Total Sources - 879,032 189,216 1,068,248 941,276 - 776,876 Total Uses - 879,032 189,216 1,068,248 235,077 228,432 23,704 Parking
Prior Year Encumbrance - - 4,144 4,144 4,144 - 7,501
Beginning Fund Balance 27,298 - - 27,298 27,298 - 28,170 Revenues 19,150 - - 19,150 5,243 - 1,837
Total Sources - 46,448 4,144 50,592 36,685 - 37,508
Total Uses - 46,448 4,144 50,592 12,803 7,251 2,407
Municipal Water
Prior Year Encumbrance - - 5,300 5,300 5,300 - 8,443
Beginning Fund Balance 35,584 - - 35,584 35,584 - 28,677 Revenues 131,902 - - 131,902 16,689 - 5,503
Total Sources - 167,486 5,300 172,786 57,573 - 42,623
Total Uses - 167,486 5,300 172,786 17,108 4,828 7,016
Note: Figures may not total due to rounding.
FOR THE MONTHS ENDED AUGUST 31, 2023
YEAR-TO-DATE
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 AUGUST 31, 2023
YEAR-TO-DATE
Community Energy
Prior Year Encumbrance - - 22,761 22,761 22,761 - 4,793 Beginning Fund Balance 180,030 - - 180,030 180,030 - 85,706 Revenues 522,847 - - 522,847 109,301 - 108,183
Total Sources - 702,877 22,761 725,638 312,092 - 198,682 Total Uses - 702,877 22,761 725,638 86,685 201,685 70,770 Gas Tax
Prior Year Encumbrance - - - - - - -
Beginning Fund Balance - - - - - - -
Revenues 17,000 - - 17,000 1,424 - -
Total Sources - 17,000 - 17,000 1,424 - -
Total Uses - 17,000 - 17,000 - - -
Building and Structures
Prior Year Encumbrance - - 22,191 22,191 22,191 - 3,874 Beginning Fund Balance 78,505 - - 78,505 78,505 - 94,604 Revenues 86,569 - - 86,569 4,042 - 4,062
Total Sources - 165,074 22,191 187,265 104,738 - 102,540 Total Uses - 165,074 22,191 187,265 4,035 22,694 2,791
Residential Construction
Prior Year Encumbrance - - - - - - -
Beginning Fund Balance 2,695 - - 2,695 2,695 - 2,537
Revenues 260 - - 260 72 - 49
Total Sources - 2,955 - 2,955 2,767 - 2,586
Total Uses - 2,955 - 2,955 68 - 2
Transient Occupancy Tax
Prior Year Encumbrance - - 775 775 775 - 675
Beginning Fund Balance 4,518 - - 4,518 4,518 - 3,069
Revenues 24,055 - - 24,055 1,510 - 1,287
Total Sources - 28,573 775 29,348 6,803 - 5,031
Total Uses - 28,573 775 29,348 13,438 4,257 1,415
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 2023-2024 BUDGET C/O FY 2023-2024 Y-T-D
BUDGET AMENDMENTS ENCUMBR BUDGET ACTUAL ENCUMBR ACTUAL
FOR THE MONTHS ENDED AUGUST 31, 2023
YEAR-TO-DATE
Conventions, Arts & Entertainment
Prior Year Encumbrance - - 311 311 311 - 64
Beginning Fund Balance 5,941 - - 5,941 5,941 - 1,898
Revenues 11,957 - - 11,957 11,916 - 1,072
Total Sources - 17,898 311 18,209 18,168 - 3,034
Total Uses - 17,898 311 18,209 4,916 7,249 5,040
Golf
Prior Year Encumbrance - - - - - - -
Beginning Fund Balance 2,646 - - 2,646 2,646 - 2,355
Revenues 820 - - 820 236 - 2
Total Sources - 3,466 - 3,466 2,882 - 2,357
Total Uses - 3,466 - 3,466 (136) - (1)
Emergency Reserve
Prior Year Encumbrance - - 2,321 2,321 2,321 - -
Beginning Fund Balance 663 - - 663 663 - (40,221)
Revenues 20 - - 20 - - -
Total Sources - 683 2,321 3,004 2,984 - (40,221)
Total Uses - 683 2,321 3,004 46 2,791 15
Low and Moderate Income Housing Asset
Prior Year Encumbrance - - 42,735 42,735 42,735 - -
Beginning Fund Balance 52,614 - - 52,614 52,614 - 106,444 Revenues 14,500 - - 14,500 5,727 - 6,042
Total Sources - 67,114 42,735 109,849 101,076 - 112,485 Total Uses - 67,114 42,735 109,849 3,829 43,446 5,617
Other Special Revenue Funds
Prior Year Encumbrance - - 51 51 ,137 51 ,137 - ,137 109 ,050 Beginning Fund Balance 395,463 - - 395,463 395,463 - 457,718 Revenues 630,726 - - 630,726 244,104 - 227,108
Total Sources - 1,026,189 51,137 1,077,326 690,704 - 793,876 Total Uses - 1,026,189 51,137 1,077,326 53,842 252,354 78,037 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 2023-2024 BUDGET C/O FY 2023-2024 Y-T-D
BUDGET AMENDMENTS ENCUMBR BUDGET ACTUAL ENCUMBR ACTUAL
Construction Excise
Prior Year Encumbrance - - 29,650 29,650 29,650 - 65,068 Beginning Fund Balance 89,219 - - 89,219 89,219 - 218,699 Revenues 97,043 - - 97,043 5,728 - (10,053)
Total Sources - 186,262 29,650 215,912 124,597 - 273,714 Total Uses - 186,262 29,650 215,912 4,104 49,045 8,185
Other Capital Funds
Prior Year Encumbrance - - 22,860 22,860 22,860 - 1,159 Beginning Fund Balance 172,546 - - 172,546 172,546 - 39,943 Revenues 350 - - 350 83 - 1
Total Sources - 172,896 22,860 195,756 195,489 - 41,103 Total Uses - 172,896 22,860 195,756 1,240 44,939 100
Note: Figures may not total due to rounding.
FOR THE MONTHS ENDED AUGUST 31, 2023
YEAR-TO-DATE
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 - - 4,509 4,509 - 6,897
Revenues 3,920 - - 3,920 200 - 2,456
Total Sources - 8,429 379 8,808 5,088 - 9,783
Total Uses - 8,429 379 8,808 285 311 64
Note: Figures may not total due to rounding.
FOR THE MONTHS ENDED AUGUST 31, 2023
SOURCE AND USE OF FUNDS
YEAR-TO-DATE