FY 22-23 Year to Date (YTD) Fund Balance Report - All Funds Through September 30, 2022
General Fund
Preliminary
Beginning
Available Balance
Revenues and
Transfers In
Expenditures and
Transfers Out Net Activities
Ending Available
Balance Revenue Expenditure
Fund NumberFund Name 7/1/22 9/30/22 % Collected 9/30/22 % Used 9/30/22 9/30/22 Estimate Budget 100 GENERAL FUND 3,909,022 4,007,563 24% 5,312,443 30% (1,304,880) 2,604,142 16,895,000 17,709,337 103 ARPA (Revenue Loss Allowance) 2,171,889 - 0% - 0% - 2,171,889 - 225,000 6,080,911 4,007,563 5,312,443 (1,304,880) 4,776,031 16,895,000 17,934,337 Special Revenue Funds
Preliminary
Beginning
Available Balance
Revenues and
Transfers In
Expenditures and
Transfers Out Net Activities
Ending Available
Balance Revenue Expenditure
Fund NumberFund Name 7/1/22 9/30/22 % Collected 9/30/22 % Used 9/30/22 9/30/22 Estimate Budget 101 ASSET SEIZURE 69,395 - 0% 7,500 17% (7,500) 61,895 33,000 45,000 201 AB 3229 COPS Program 18,011 74,358 50% - 0% 74,358 92,369 150,000 150,000 220 CITYWIDE L&L DIST 83-2 (235,297) - 0% 571,202 26% (571,202) (806,499) 2,162,025 2,180,718 221 VICTORIA BY THE BAY L&L (315,422) - 0% 180,188 31% (180,188) (495,610) 482,897 588,273 222 HERCULES VILLAGE L&L DIST 179,767 - 0% 63,863 31% (63,863) 115,904 166,305 208,350 223 BAYWOOD ASSESS 04-1 L&L 55,009 - 0% 193,277 129% (193,277) (138,268) 157,261 149,764 224 BAYSIDE ASSESS DIST L&L 146,427 - 0% 40,305 30% (40,305) 106,122 149,231 134,417 225 ARTERIAL ROADWAYS 574,312 - 0% 26,631 8% (26,631) 547,681 314,000 333,123 231 STORMWATER ASSESSMENT (183,570) - 0% 115,316 29% (115,316) (298,886) 376,000 399,540 241 DIF-GEN PUBLIC FACILITIES 143,087 - 0% - 0% - 143,087 - - 242 COMMUNITY DEVELOPMENT FND 166,708 - 0% - 0% - 166,708 - - 243 DEVELOPMENT FEE FUND 71,122 - 0% - 0% - 71,122 - - 244 DIF-POLICE FACILITIES 262,940 - 0% - 0% - 262,940 - 60,000 246 DIF-FIRE FACILITIES 820 - 0% - 0% - 820 - - 247 DIF-PARK & REC 184,426 - 0% - 0% - 184,426 - - 249 PUBLIC BENEFIT FEE 964,565 - 0% - 0% - 964,565 - - 261 DIF-TRAFFIC FACILITIES 153,233 - 0% 12,949 99% (12,949) 140,284 - 13,036 262 STATE GAS TAX FUND 686,466 315,211 22% 140,294 7% 174,917 861,383 1,434,597 1,970,795 263 MEASURE "C" STREET FUND 42,356 - 0% 159,976 27% (159,976) (117,620) 450,000 593,805 264 STMP TRAFFIC IMPACT FUND - - 0% - 0% - - - 24,753 267 GENERAL PLAN UPDATE - 970,072 4619% 73,867 172% 896,205 896,205 21,000 42,936 291 SOLID WASTE AND RECYCLING 828,649 43,904 25% 4,058 2% 39,846 868,495 178,000 243,745 521 REGIONAL WATER QUALITY 51,144 - 0% - 0% - 51,144 - - 266 BART (PARK & RIDE) 275,881 17,884 40% 5,661 33% 12,223 288,104 45,000 17,192 4,140,029 1,421,429 23% 1,595,087 22% (173,658) 3,966,371 6,119,316 7,155,447 Enterprise Funds
Preliminary
Beginning
Available Balance
Revenues and
Transfers In
Expenditures and
Transfers Out Net Activities
Ending Available
Balance Revenue Expenditure
Fund NumberFund Name 7/1/22 9/30/22 % Collected 9/30/22 % Used 9/30/22 9/30/22 Estimate Budget 420 WASTEWATER 34,270,401 11,435 0% 977,937 10% (966,502) 33,303,899 6,053,000 9,915,922 This fund is used to account for all revenues and expenditures necessary to carry out basic governmental activities of the City. The General Fund includes activities for police, planning, public works, operations and maintenance, and legal and administration.
Special Revenue Funds account for the proceeds of specific revenue sources (other than trusts for individuals, private organizations, or other governments, or for major capital projects) that are restricted or committed to expenditures for specified purposes.
This fund accounts for wastewater treatment to the cities of Hercules and Pinole and for the maintenance of the City's sewer lines and related facilities. It is a self-supporting activity which provides services on a user charge basis to residences and businesses.
FY 22-23 Year to Date (YTD) Fund Balance Report - All Funds Through September 30, 2022
Internal Service Funds
Preliminary
Beginning
Available Balance
Revenues and
Transfers In
Expenditures and
Transfers Out Net Activities
Ending Available
Balance Revenue Expenditure
Fund NumberFund Name 7/1/22 9/30/22 % Collected 9/30/22 % Used 9/30/22 9/30/22 Estimate Budget 450 VEHICLE REPLACEMENT FUND 908,085 - 0% - 0% - 908,085 148,300 276,000 460 IT EQUIPMENT REPLACEMENT 605,110 1,702 0% 467,779 36% (466,077) 139,033 1,271,986 1,306,068 470 FACILITY MAINTENANCE FUND 517,075 - 0% 188,005 24% (188,005) 329,070 787,000 795,735 2,030,270 1,702 0% 655,784 28% (654,082) 1,376,188 2,207,286 2,377,803 Debt Service Funds
Preliminary
Beginning
Available Balance
Revenues and
Transfers In
Expenditures and
Transfers Out Net Activities
Ending Available
Balance Revenue Expenditure
Fund NumberFund Name 7/1/22 9/30/22 % Collected 9/30/22 % Used 9/30/22 9/30/22 Estimate Budget 672 2003B DEBT SERVICE PFA 158,687 - 0% 1,500 0% (1,500) 157,187 355,934 513,000 673 2009 DEBT SERVICE PFA 1,993,825 - 0% 1,300 0% (1,300) 1,992,525 908,000 908,000 383 SUNTRUST LEASE - 102,549 100% 102,549 100% - - 103,000 103,000 388 EQUIPMENT LEASE - 226,432 100% 226,432 100% - - 227,000 227,000 2,152,512 328,981 331,781 (2,800) 2,149,712 1,593,934 1,751,000 Capital Projects Funds
Preliminary
Beginning
Available Balance
Revenues and
Transfers In
Expenditures and
Transfers Out Net Activities
Ending Available
Balance Revenue Expenditure
Fund NumberFund Name 7/1/22 9/30/22 % Collected 9/30/22 % Used 9/30/22 9/30/22 Estimate Budget 295 STREET CIP GRANTS 473,625 - 0% - 0% - 473,625 492,000 492,000 300 CITY CAPITAL PROJ-SINGLE 1,265,836 - 0% 31,649 4% (31,649) 1,234,187 247,000 708,508 301 ENERGY CONSERVATION PROJECT 117,303 - 0% - 0% - 117,303 - 282,637 340 GRANT FUND / STIP / RIP (40,522) 300 0% 12,097 2% (11,797) (52,319) - 780,433 387 WATER QUALITY RET BASIN 182,539 - 0% 9,747 294% (9,747) 172,792 - 3,317 1,998,781 300 53,493 (53,193) 1,945,588 739,000 2,266,895 Agency Funds
Preliminary
Beginning
Available Balance
Revenues and
Transfers In
Expenditures and
Transfers Out Net Activities
Ending Available
Balance Revenue Expenditure
Fund NumberFund Name 7/1/22 9/30/22 % Collected 9/30/22 % Used 9/30/22 9/30/22 Estimate Budget 382 ASSMT DIST 05-01 DEBT SVC 415,829 - 0% 193,196 83% (193,196) 222,633 232,910 232,910 501 TAYLOR WOODROW MAINT LMOD 69,457 - 0% - 0% - 69,457 - - 511 GASB 45 OPEB LIABILITY 2,629,051 (106,945) 0% 14,446 14% (121,391) 2,507,660 118,000 102,000 3,114,337 (106,945) 207,642 (314,587) 2,799,750 350,910 334,910 These funds are used to account for assets held in trust by the City for the benefit of individuals or other entities. Financial Statements may further distinguish fiduciary funds as either trust or agency funds; a trust fund generally exists for a longer period of time than an agency fund.
These funds account for activities related to vehicle replacement, IT equipment replacement, and facilities maintenance.
These funds are used to account for money that will be used to pay the interest and principal of long-term debts. Bonds used by a government to finance major construction projects, to be paid by tax levies over a period of years, require a deby service fund to account for their repayment. The debts of special assessment and proprietary funds are serviced within those funds, rather than by a separate debt service fund.
These funds are used to account for the construction or acquisition of fixed assets, such as buildings, equipment and roads. Depending on its use, a fixed asset may instead be financed by a special revenue fund or a proprietary fund. A capital project fund exists only until completion of the project.