Attachment 1 Page 1 of 5
FY 2021-2022 Midyear Fund Balances
General Fund1 State Gas Tax
Storm Drain
Improvement
St
Landscaping/
Lighting
Local
Transport
Article 3 Measure M
Prop A Local
Trans Tax
Prop C Local
Trans Tax
Beginning Fund Balance (includes carryovers) 5,144,303 1,694,887 406,100 - 37,152 2,545,319 2,267,630 5,917,133 Adopted Revenues 94,655,364 3,058,268 28,000 1,553,500 49,074 983,872 1,919,909 1,242,203 Carry-over Revenues - - - - - - - -
Other Council-Approved Revenues - - - - - 85,000 - -
Transfers In 2,874,946 - - 1,018,856 - - - -
Total Revenue 97,530,310 3,058,268 28,000 2,572,356 49,074 1,068,872 1,919,909 1,242,203 Adopted Appropriations 86,929,791 2,511,531 - 2,572,356 95,000 1,300,000 - 1,682,151 Prior Year Encumbrances 981,809 95,035 36,190 186,338 - 644,160 - 1,914,199 Carryover Appropriations 1,051,868 962,350 251,802 - - 1,412,418 75,000 3,499,110 Other Council-Approved Appropriations (Exhibit A) - - - - - 85,000 - - Transfers Out 13,777,302 38,278 - - - - 2,867,624 -
Total Uses 102,740,769 3,607,194 287,992 2,758,694 95,000 3,441,578 2,942,624 7,095,460 Estimated Ending Fund Balance (66,156) 1,145,961 146,108 (186,338) (8,774) 172,613 1,244,915 63,876 Adjustments to Revenue (Exhibit B - General Fund 2,883,707 (143,688) - - - - - - Adjustments to Appropriations (Exhibit C) (570,330) 54,190 829 25,455 2,574 6,407 2,393 11,415 Adjustments to Revenue/Transfers In (Decision Pkg - 3,400,540 - - - - - - Adjustments to Appropriations/Transfers Out (Decis - (7,049,432) - - - - - - Revised Estimated Ending Fund Balance 13,837,853 948,083 145,279 (211,793) (11,348) 166,207 1,242,522 52,461 12 Beginning Balance of Intergovernmental Grants is usually negative so it is updated to zero.345 The Successor Agency is identified in the ACFR as the Redevelopment Obligation Retirement Fund.6 The Housing Successor Agency is identified in the ACFR as the Low-Mod Income Housing Fund.7 The Community Financing Authority is identified in the ACFR as the Public Financing Authority.
Because any fund balance (positive or negative) is eliminated with an adjustment to the transfer from the Proposition A Fund, the Transit Fund’s beginning fund balance was shown as zero.The General Fund beginning fund balance excludes the 8.33% minimum contingency reserve set by the City Council.The Self-Insurance Program Fund beginning fund balance reflects a positive cash balance of $14,201,733 reduced by liabilities for future workers' compensation and liability claims of $23,468,542.
Attachment 1 Page 2 of 5
FY 2021-2022 Midyear Fund Balances
Beginning Fund Balance (includes carryovers)Adopted RevenuesCarry-over RevenuesOther Council-Approved RevenuesTransfers In Total Revenue
Adopted AppropriationsPrior Year EncumbrancesCarryover AppropriationsOther Council-Approved Appropriations (Exhibit A)Transfers Out Total Uses
Estimated Ending Fund BalanceAdjustments to Revenue (Exhibit B - General Fund Adjustments to Appropriations (Exhibit C)Adjustments to Revenue/Transfers In (Decision PkgAdjustments to Appropriations/Transfers Out (DecisRevised Estimated Ending Fund Balance Measure R Transit3 Measure W
Air Quality
Improvement
Intergovernmental
Grants2
Comm
Develop
Block Grant
Housing
Authority
Parks/Rec
Facilities
- 1,620,386 (142,701) 273,540 (167,575) 1,582,809 56,843 3,208,892 856,652 648,000 90,000 11,810,729 290,479 6,627,168 31,500 - - - - 10,106,211 - - -
- 175,000 - - 596,992 - - -
2,867,624 - - - - - - -
6,076,516 1,031,652 648,000 90,000 22,513,932 290,479 6,627,168 31,500 6,045,079 1,015,000 690,637 72,722 11,806,500 290,479 6,652,874 50,000 582,192 339,315 - 85,182 8,782,641 44,179 - -
690,000 956,831 471,527 59,650 10,106,211 118,920 - 50,000 - 175,000 - - 596,992 - - -
31,437 - 4,663 1,464 4,229 - 17,094 -
7,348,708 2,486,146 1,166,827 219,018 31,296,573 453,578 6,669,968 100,000 (1,272,192) 165,892 (661,528) 144,522 (8,782,641) (330,674) 1,540,009 (11,657) - - 72,000 - - - - 3,500
(17,745) 12,388 (7,339) 5,048 118,845 38,903 11,872 286 - - - - - - - -
- - - - - - - -
(1,254,447) 153,504 (582,189) 139,474 (8,901,486) (369,577) 1,528,137 (8,443) Attachment 1 Page 3 of 5
FY 2021-2022 Midyear Fund Balances
Beginning Fund Balance (includes carryovers)Adopted RevenuesCarry-over RevenuesOther Council-Approved RevenuesTransfers In Total Revenue
Adopted AppropriationsPrior Year EncumbrancesCarryover AppropriationsOther Council-Approved Appropriations (Exhibit A)Transfers Out Total Uses
Estimated Ending Fund BalanceAdjustments to Revenue (Exhibit B - General Fund Adjustments to Appropriations (Exhibit C)Adjustments to Revenue/Transfers In (Decision PkgAdjustments to Appropriations/Transfers Out (DecisRevised Estimated Ending Fund Balance Narcotic
Forfeiture/Seizure
Subdivision
Park Trust
Disaster
Recovery
CalPERS
Reserve
Capital
Projects
Major Facilities
Reconstruction
Open Space
Acquisition
Harbor
Tidelands
1,943,240 379,084 172,846 5,105,721 6,047,998 660,714 1,303,695 12,370,892 600,000 20,000 51,000 - 492,678 - - 6,119,389
- - - - - - - -
- - - - - - - -
- - - - 6,865,770 - - -
600,000 20,000 51,000 - 7,358,448 - - 6,119,389
660,000 52,957 17,060 - 6,301,488 640,000 186,500 10,101,108 6,674 116,060 - - 1,395,419 - - 1,310,102
1,621,713 103,563 - - 3,546,670 625,491 18,047 4,929,487 - - - - - - - 415,200
- - - - 9,663 - - 364,179
2,288,387 272,581 17,060 - 11,253,240 1,265,491 204,547 17,120,076 254,853 126,503 206,786 5,105,721 2,153,206 (604,777) 1,099,148 1,370,206 175,000 32,000 - - (318) - - (122,992)
4,640 20,139 44,424 - 84,905 - 972 (402,249)
- - - - - - - -
- - - - - - - 195,000
425,213 138,364 162,363 5,105,721 2,067,983 (604,777) 1,098,176 1,454,463 Attachment 1 Page 4 of 5
FY 2021-2022 Midyear Fund Balances
Beginning Fund Balance (includes carryovers)Adopted RevenuesCarry-over RevenuesOther Council-Approved RevenuesTransfers In Total Revenue
Adopted AppropriationsPrior Year EncumbrancesCarryover AppropriationsOther Council-Approved Appropriations (Exhibit A)Transfers Out Total Uses
Estimated Ending Fund BalanceAdjustments to Revenue (Exhibit B - General Fund Adjustments to Appropriations (Exhibit C)Adjustments to Revenue/Transfers In (Decision PkgAdjustments to Appropriations/Transfers Out (DecisRevised Estimated Ending Fund Balance Harbor
Uplands Solid Waste Wastewater
SelfInsurance
Program4
Vehicle
Replacement
Building
Occupancy
Information
Technology
Emergency
Communications
1,426,983 1,951,342 15,477,501 (9,008,664) 7,679,984 438,513 (390,574) 917,132 5,385,061 6,312,696 5,880,014 8,278,012 3,081,619 3,507,846 3,997,649 4,207,747 44,030 - - - - - - -
- - - - - - - -
4,000 - - - - - - -
5,433,091 6,312,696 5,880,014 8,278,012 3,081,619 3,507,846 3,997,649 4,207,747 5,728,974 4,843,448 3,700,162 7,367,025 3,588,339 3,012,467 3,820,631 3,066,919 69,696 176,874 892,263 - 1,040,517 69,889 250,952 90,980 44,030 335,503 8,925,862 - 267,396 - 650,000 -
- - 2,419,161 - - - - -
52,895 1,774,834 78,989 3,547 29,821 61,720 62,627 99,506 5,895,595 7,130,659 16,016,437 7,370,572 4,926,073 3,144,076 4,784,210 3,257,405 964,479 1,133,379 5,341,078 (8,101,224) 5,835,530 802,283 (1,177,135) 1,867,474 (22,396) (281,396) - - 37,500 - - -
(236,064) 114,350 104,681 (24,225) (23,084) (32,016) (257,362) (164,595) - - - - - - - -
8,276 - - - 14,195 - - -
1,169,871 737,633 5,236,397 (8,076,999) 5,881,919 834,299 (919,773) 2,032,070 Attachment 1 Page 5 of 5
FY 2021-2022 Midyear Fund Balances
Beginning Fund Balance (includes carryovers)Adopted RevenuesCarry-over RevenuesOther Council-Approved RevenuesTransfers In Total Revenue
Adopted AppropriationsPrior Year EncumbrancesCarryover AppropriationsOther Council-Approved Appropriations (Exhibit A)Transfers Out Total Uses
Estimated Ending Fund BalanceAdjustments to Revenue (Exhibit B - General Fund Adjustments to Appropriations (Exhibit C)Adjustments to Revenue/Transfers In (Decision PkgAdjustments to Appropriations/Transfers Out (DecisRevised Estimated Ending Fund Balance Major
Facilities
Repair
Successor
Agency5
Housing
Successor
Agency6
Community
(Public) Financing
Authority7 Total
4,137,151 - 4,693,537 76,542,921 1,325,915 107,076 269,520 273,975 176,963,807 - - - - 10,150,241 - - - - 856,992
- - - 7,516,966 21,148,162
1,325,915 107,076 269,520 7,790,941 209,119,202
271,770 155,000 429,000 6,976,796 182,633,764
- 9,551 47,153 - 19,167,368
- - - - 40,773,448 - - - - 3,691,353
1,054,145 - - 814,145 21,148,162
1,325,915 164,551 476,153 7,790,941 267,414,095
- (57,475) 3,930,518 4,693,537 18,248,027 - - - - 2,632,917 2,477 3,609 (16,545) 6,879 (1,073,871)
- - - - - - - 100,000 - (6,731,961)
(2,477) (61,084) 3,847,062 4,686,658 32,087,317