FINAL
Fund Description
Beginning Balance
7/1/2023 YTD Income YTD Expenditures YTD Transfers
Ending Balance
6/30/2024
OPERATING FUNDS
General Funds
General Fund 6,544,782.32 $17,170,679.57 (15,187,165.03) (753,621.39) 7,774,675.47 Sick Leave Contingency 419,275.77 11,958.06 ‐ ‐ 431,233.83 PERS Contingency 1,370,535.06 149,506.14 ‐ 161,805.43 1,681,846.63 Healthcare Contingency 217,232.77 5,560.09 ‐ ‐ 222,792.86 Liability SIR Contingency 651,698.33 16,680.28 ‐ ‐ 668,378.61 Litigation/Natural Disaster Contingency 536,310.94 13,726.94 ‐ ‐ 550,037.88 Asset/Liability adjustments 164,503.06 14,274.14 ‐ ‐ 178,777.20 Street & Road Funds
Street & Roads 4,554,837.52 2,975,546.30 (1,033,405.19) (1,148,585.15) 5,348,393.48 Street & Road Reconstruction Fund 546,642.74 9,942.83 ‐ 1,148,585.15 1,705,170.72 Street & Road Reserve 2,915,286.93 53,025.86 ‐ ‐ 2,968,312.79 Transit funds 22,119.78 86,645.82 (87,444.31) ‐ 21,321.29 LTF Transit funds 169,761.00 520,672.00 ‐ ‐ 690,433.00 Enterprise Operating Funds
Water Operating 926,513.59 3,853,296.83 (2,811,573.10) (1,041,723.73) 926,513.59 Sewer Operating 697,425.71 2,101,215.72 (1,374,863.05) (726,352.67) 697,425.71 Garbage Operating 211,230.50 2,650,584.64 (2,488,898.42) (161,686.22) 211,230.50 $ 19,948,156.02 $ 29,633,315.22 $ (22,983,349.10) $ (2,521,578.58) $ 24,076,543.56
CAPITAL FUNDS
General Capital Funds
Parks & Recreation 3,176,913.90 205,731.00 (221,971.06) ‐ 3,160,673.84 Jack Tone Golf Course Capital Reserve 533,656.20 74,175.07 ‐ ‐ 607,831.27 Mistlin Sport Park‐ Turf Replacement Res ‐ 24,000.00 ‐ ‐ 24,000.00 CNG Station Capital Reserve 216,448.48 5,492.76 ‐ 51,565.33 273,506.57 Department Funds 2,391,459.66 228,296.61 (134,751.56) 475,000.00 2,960,004.71 Underground Utilties 10,351.62 262.68 ‐ ‐ 10,614.30
Mitigation Fees 2,539,814.47 168,238.35 ‐ 60,912.19 2,768,965.01 Corporation Yard 1,882,705.34 937,000.00 (2,321,690.49) ‐ 498,014.85 Enterprise Capital Funds
Water Enterprise Capital 7,320,874.98 367,044.99 (823,042.15) 1,041,723.73 7,906,601.55 Sewer Enterprise Capital 1,548,837.26 28,485.14 (787,988.42) 365,285.73 1,154,619.71 Sewer WWTP Reserve 1,497,635.52 38,005.08 ‐ 361,066.94 1,896,707.54 Garbage Enterprise Capital 868,699.32 97,041.86 (216.32) 161,686.22 1,127,211.08 Storm Drain Enterprise Capital 341,600.06 4,103.39 (353,149.56) ‐ (7,446.11) PFFP Capital Funds
Water 2,981,046.95 327,450.48 (27,616.59) ‐ 3,280,880.84 SSJID Connection Reserve 871,876.41 93,854.86 ‐ ‐ 965,731.27 Garbage (755,440.60) 15,947.54 (19,021.33) ‐ (758,514.39) Wastewater 5,685,746.37 745,001.76 ‐ ‐ 6,430,748.13 Storm Drainage 2,415,847.98 320,546.04 ‐ ‐ 2,736,394.02 Transportation 1,843,787.96 1,089,743.48 (228,736.37) ‐ 2,704,795.07 Regional Transportation Impact Fee 1,614,802.91 95,757.49 ‐ ‐ 1,710,560.40 Parks & Recreation 45,650.93 32,593.03 (0.00) ‐ 78,243.96 Parks & Recreation loan repayment funds 550,028.48 33,384.72 583,413.20 Police (1,193,034.45) 10,074.19 (30,184.63) ‐ (1,213,144.89) City Hall (3,804,692.88) 20,516.01 (96,359.17) ‐ (3,880,536.04) Corporation Yard 7,246,354.21 201,498.56 (6,100,112.61) (43,999.93) 1,303,740.23 Library (615,202.58) 1,633.20 (15,582.82) ‐ (629,152.20) $ 39,215,768.50 $ 5,165,878.29 $ (11,160,423.08) $ 2,473,240.21 $ 35,694,463.92
RESTRICTED FUNDS
Special Revenue/Restricted Funds
Benefit Assessment Districts 466,089.47 84,919.53 ‐ ‐ 551,009.00 NPSP Assessment District 820,008.75 73,367.87 ‐ ‐ 893,376.62 Landscape & Lighting Districts 337,414.84 472,249.59 (485,740.77) 65,250.63 389,174.29 Redevelopment ‐ Housing 5,256,400.15 134,070.19 ‐ ‐ 5,390,470.34 Redevelopment ‐ City 16,493.71 418.55 ‐ (16,912.26) (0.00) Redevelopment ‐ State 758,130.64 1,145,035.51 (1,175,231.02) ‐ 727,935.13 Housing Fund 1,819,629.11 143,752.75 (6,250.62) ‐ 1,957,131.24 CDBG ‐ 17,338.95 (30,058.95) ‐ (12,720.00)
$ 9,474,166.67 $ 2,071,152.94 $ (1,697,281.36) $ 48,338.37 $ 9,896,376.62 GRAND TOTAL 68,638,091.19 $ $ 36,870,346.45 $ (35,841,053.54) $ (0.00) $ 69,667,384.10 Bank Accounts‐Balances 5/31/24 Bank Accounts
B of Stkn ‐Gen 469,817.00 B of Stkn ‐Gen 222,370.63 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 6,000.00 B of Stkn.‐PR 6,000.00
B of Stkn.‐Rec 94,978.86 B of Stkn.‐Rec 5,579.69
B of Stkn.‐PD Voucher Pr 973.16 B of Stkn.‐PD Voucher Pro 973.16 B of America‐Prkg Cit. 18,510.23 B of America‐Prkg Cit. 19,076.23 LAIF 382,501.81 LAIF 382,501.81
Bk of New York 32,423,683.27 Bk of New York 32,599,724.45 CAMP 30,268,742.82 CAMP 34,909,220.91 US Bank Sec 115 Trust 1,456,723.92 US Bank Sec 115 Trust 1,520,041.20 Redev. Debt ‐ 2020 0.32 Redev. Debt ‐ 2020 0.32
Water Bonds‐2006 402.38 Water Bonds‐2006 404.17
Water Bonds‐2012 190.70 Water Bonds‐2012 191.53
BANK TOTALS 65,123,824.47 $ BANK TOTALS 69,667,384.10 $
TOTAL RESTRICTED FUNDS
CITY OF RIPON
FUND BALANCES SUMMARY
TOTAL CAPITAL FUNDS
TOTAL OPERATING FUNDS
2023‐2024
June‐24
\\rcityfs2\users\lroos\My Documents\Month End\06.2024\11. cash June 2024 FINAL.xlsx - Summary Fund Balances 2024.06.30