Fund Description
Beginning Balance
7/1/2022 YTD Income YTD Expenditures YTD Transfers
Ending Balance
June 2023 ‐ FINAL
OPERATING FUNDS
General Funds
General Fund 6,501,184.76 $16,909,055.41 (14,955,133.70) (1,910,324.15) 6,544,782.32 Sick Leave Contingency 355,547.04 18,728.73 ‐ 45,000.00 419,275.77 PERS Contingency 1,135,396.65 73,277.18 ‐ 161,861.23 1,370,535.06 Healthcare Contingency 209,024.85 8,207.92 ‐ ‐ 217,232.77 Liability SIR Contingency 627,074.57 24,623.76 ‐ ‐ 651,698.33 Litigation/Natural Disaster Contingency 2,475,986.97 1,980,203.97 ‐ (3,919,880.00) 536,310.94 Asset/Liability adjustments 100,418.30 64,084.76 ‐ ‐ 164,503.06 Street & Road Funds
Street & Roads 3,389,430.39 2,728,028.88 (1,015,979.01) (546,642.74) 4,554,837.52 Street & Road Reconstruction Fund ‐ ‐ ‐ 546,642.74 546,642.74 Street & Road Reserve 2,461,384.26 29,574.67 ‐ 424,328.00 2,915,286.93 Transit funds 22,027.63 60,588.80 (60,496.65) ‐ 22,119.78 LTF Transit funds ‐ 169,761.00 ‐ ‐ 169,761.00 Enterprise Operating Funds
Water Operating 926,513.59 3,825,116.66 (2,678,581.33) (1,146,535.33) 926,513.59 Sewer Operating 710,609.27 2,015,969.03 (1,355,152.59) (674,000.00) 697,425.71 Garbage Operating 211,230.50 2,526,053.94 (2,300,398.33) (225,655.61) 211,230.50 $ 19,125,828.78 $ 30,433,274.71 $ (22,365,741.61) $ (7,245,205.86) $ 19,948,156.02
CAPITAL FUNDS
General Capital Funds
Parks & Recreation 881,428.79 137,136.99 (88,651.88) 2,247,000.00 3,176,913.90 Jack Tone Golf Course Capital Reserve 472,981.43 60,674.77 ‐ ‐ 533,656.20 CNG Station Capital Reserve 195,982.85 2,115.45 (95,148.82) 113,499.00 216,448.48 Department Funds 1,059,614.25 147,831.94 (673,141.53) 1,857,155.00 2,391,459.66 Underground Utilties 10,197.82 153.80 ‐ ‐ 10,351.62
Mitigation Fees 8,038,443.35 188,671.12 ‐ (5,687,300.00) 2,539,814.47 Corporation Yard ‐ ‐ (254,535.66) 2,137,241.00 1,882,705.34 Enterprise Capital Funds
Water Enterprise Capital 7,233,394.46 288,008.72 (1,347,063.53) 1,146,535.33 7,320,874.98 Sewer Enterprise Capital 1,687,702.63 85,911.85 (579,777.22) 355,000.00 1,548,837.26 Sewer WWTP Reserve 1,161,125.49 17,510.03 ‐ 319,000.00 1,497,635.52 Garbage Enterprise Capital 1,067,134.86 11,921.39 (436,012.54) 225,655.61 868,699.32 Storm Drain Enterprise Capital 371,022.30 5,595.09 (35,017.33) ‐ 341,600.06 PFFP Capital Funds
Water 2,794,361.29 186,685.66 ‐ ‐ 2,981,046.95 SSJID Connection Reserve 818,384.64 53,491.77 ‐ ‐ 871,876.41 Garbage (663,606.35) 14,370.14 (106,204.39) ‐ (755,440.60) Wastewater 5,380,468.53 305,277.84 ‐ ‐ 5,685,746.37 Storm Drainage 2,280,059.71 135,788.27 ‐ ‐ 2,415,847.98 Transportation 1,224,927.40 637,617.79 (18,757.23) ‐ 1,843,787.96 Regional Transportation Impact Fee 1,310,680.94 304,121.97 ‐ ‐ 1,614,802.91 Parks & Recreation 1,202,796.19 42,854.74 (0.00) (1,200,000.00) 45,650.93 Parks & Recreation loan repayment funds 539,522.64 10,505.84 550,028.48 Police (1,197,518.86) 22,424.21 (17,939.80) ‐ (1,193,034.45) City Hall (3,794,551.99) 46,832.96 (56,973.85) ‐ (3,804,692.88) Corporation Yard 445,063.44 124,439.23 (751,448.46) 7,428,300.00 7,246,354.21 Library (607,132.52) 1,076.29 (9,146.35) ‐ (615,202.58) $ 31,912,483.29 $ 2,831,017.86 $ (4,469,818.59) $ 8,942,085.94 $ 39,215,768.50
RESTRICTED FUNDS
Special Revenue/Restricted Funds
Benefit Assessment Districts 440,784.24 25,305.23 ‐ ‐ 466,089.47 NPSP Assessment District 807,826.55 12,182.20 ‐ ‐ 820,008.75 Landscape & Lighting Districts 249,252.83 468,710.22 (424,668.13) 44,119.92 337,414.84 Redevelopment ‐ Housing 5,095,597.39 160,802.76 ‐ ‐ 5,256,400.15 Redevelopment ‐ City 1,731,384.07 26,109.64 ‐ (1,741,000.00) 16,493.71 Redevelopment ‐ State 884,814.78 1,027,918.00 (1,154,602.14) ‐ 758,130.64 Housing Fund 1,803,839.55 28,693.94 (12,904.38) ‐ 1,819,629.11 CDBG ‐ 52,423.95 (52,423.95) ‐ ‐
$ 11,013,499.41 $ 1,802,145.94 $ (1,644,598.60) $ (1,696,880.08) $ 9,474,166.67 GRAND TOTAL 62,051,811.48 $ $ 35,066,438.51 $ ‐ (28,480,158.80) $ $ 68,638,091.19 Bank Accounts‐Balances 5/31/2023 Bank Accounts
B of Stkn ‐Gen 129,560.44 B of Stkn ‐Gen 75,802.15
Petty Cash 700.00 Petty Cash 700.00
Police ‐ petty cash 400.00 Police ‐ petty cash 400.00
Petty Cash ‐ A/C 200.00 Petty Cash ‐ A/C 200.00
B of Stkn.‐PR 368,371.40 B of Stkn.‐PR 6,000.00
B of Stkn.‐Rec 3,211.08 B of Stkn.‐Rec 11,315.67
B of Stkn.‐PD Voucher Pr 1,242.00 B of Stkn.‐PD Voucher Pro 1,242.00 B of America‐Prkg Cit. 50,409.23 B of America‐Prkg Cit. 4,639.23 LAIF 19,575,782.52 LAIF 5,425,782.52 Bk of New York 31,761,664.79 Bk of New York 31,896,619.87 CAMP 15,000,000.00 CAMP 30,010,802.95 US Bank Sec 115 Trust 1,177,929.49 US Bank Sec 115 Trust 1,204,095.65 Redev. Debt ‐ 2020 0.32 Redev. Debt ‐ 2020 0.32
Water Bonds‐2006 299.35 Water Bonds‐2006 300.61
Water Bonds‐2012 189.43 Water Bonds‐2012 190.22
BANK TOTALS 68,069,960.05 $ BANK TOTALS 68,638,091.19 $
TOTAL RESTRICTED FUNDS
CITY OF RIPON
FUND BALANCES SUMMARY
TOTAL CAPITAL FUNDS
TOTAL OPERATING FUNDS
2022‐2023
June 2023 ‐ FINAL
\\rcityfs2\users\lroos\My Documents\Month End\06.2023\11. cash June 2023 FINAL 2.xls - Summary Fund Balances 2023.06.30