Ripon City Council
December 13, 2022

Fund Description
Beginning Balance
7/1/2021 YTD Income YTD Expenditures YTD Transfers
Ending Balance
6/30/2022
OPERATING FUNDS
General Funds
General Fund               5,215,340.02 $15,220,108.59 (13,697,018.36)               ($237,245.49) 6,501,184.76 Sick Leave Contingency                  353,947.24 $1,599.80 $0.00 $0.00                  355,547.04 PERS Contingency                  972,997.66 $4,830.02 $0.00 $157,568.97 1,135,396.65 Healthcare Contingency                  208,135.65 $889.20 $0.00 $0.00                  209,024.85 Liability SIR Contingency                  624,406.97 $2,667.60 $0.00 $0.00                  627,074.57 Litigation/Natural Disaster Contingency                  505,514.03 $1,970,472.94 $0.00 $0.00 2,475,986.97 Asset/Liability adjustments                    46,075.42 $54,342.88 $0.00 $0.00                  100,418.30 Street & Road Funds
Street & Roads $2,934,729.30 $4,954,583.01 ($4,499,881.92) $0.00 $3,389,430.39 Street & Road Reserve               2,451,594.00 $9,790.26 $0.00 $0.00 2,461,384.26 Transit funds $22,504.86 $55,449.05 ($55,926.28) $0.00 $22,027.63 Enterprise Operating Funds
Water Operating                  926,513.59 $3,816,116.28 ($2,509,104.61) ($1,307,011.67)                  926,513.59 Sewer Operating                  763,708.89 $1,927,363.07 ($1,335,462.69) ($645,000.00)                  710,609.27 Garbage Operating                  211,230.50 $2,403,992.23 ($2,309,684.88) ($94,307.35)                  211,230.50 $         15,236,698.13 $         30,422,204.93 $           (24,407,078.74) $             (2,125,995.54) $         19,125,828.78 CAPITAL FUNDS
General Capital Funds
Parks & Recreation                  930,684.27 $89,359.57 ($138,615.05) $0.00                  881,428.79 Jack Tone Golf Course Capital Reserve                  401,758.25 $71,223.18 $0.00 $0.00                  472,981.43 CNG Station Capital Reserve                  202,066.30 $1,458.00 ($23,419.80) $15,878.35                  195,982.85 Department Funds $1,547,067.66 $90,677.73 ($578,131.14) $0.00 $1,059,614.25 Underground Utilties $10,124.77 $73.05 $0.00 $0.00 $10,197.82 Mitigation Fees               7,922,809.43 $115,633.92 $0.00 $0.00 8,038,443.35 Enterprise Capital Funds
Water Enterprise Capital               7,368,413.00 $242,091.98 ($1,684,122.19) $1,307,011.67 7,233,394.46 Sewer Enterprise Capital               1,875,485.96 $11,340.61 ($554,123.94) $355,000.00 1,687,702.63 Sewer WWTP Reserve                  864,884.96 $6,240.53 $0.00 $290,000.00 1,161,125.49 Garbage Enterprise Capital                  988,842.10 $12,323.62 ($28,338.21) $94,307.35 1,067,134.86 Storm Drain Enterprise Capital                  465,228.99 $3,130.12 ($97,336.81) $0.00                  371,022.30 PFFP Capital Funds
Water               2,639,213.83 $155,147.46 $0.00 $0.00 2,794,361.29 SSJID Connection Reserve                  774,052.44 $44,332.20 $0.00 $0.00                  818,384.64 Garbage                 (668,185.11) $14,395.27 ($9,816.51) $0.00                 (663,606.35) Wastewater               5,133,140.77 $247,327.76 $0.00 $0.00 5,380,468.53 Storm Drainage               2,167,143.66 $112,916.05 $0.00 $0.00 2,280,059.71 Transportation $717,616.41 $507,310.99 $0.00 $0.00 $1,224,927.40 Regional Transportation Impact Fee $1,246,219.84 $64,461.10 $0.00 $0.00 $1,310,680.94 Parks & Recreation $1,107,552.14 $95,244.05 $0.00 $0.00 $1,202,796.19 Parks & Recreation loan repayment funds                  545,049.46 ($5,526.82) $0.00                  539,522.64 Police ($1,198,258.28) $9,371.56 ($8,632.14) $0.00 ($1,197,518.86) City Hall             (3,786,867.64) $19,611.53 ($27,295.88) $0.00 (3,794,551.99) Corporation Yard                  589,479.31 $31,138.98 ($175,554.85) $0.00                  445,063.44 Library                 (605,307.31) $2,539.69 ($4,364.90) $0.00                 (607,132.52) $         31,238,215.21 $           1,941,822.13 $             (3,329,751.42) $              2,062,197.37 $         31,912,483.29 RESTRICTED FUNDS
Special Revenue/Restricted Funds
Benefit Assessment Districts                  278,846.70 $161,937.54 $0.00 $0.00                  440,784.24 NPSP Assessment District                  802,039.47 $5,787.08 $0.00 $0.00                  807,826.55 Landscape & Lighting Districts                  206,850.55 $443,558.52 ($464,954.41) $63,798.17                  249,252.83 Redevelopment ‐ Housing $4,124,336.69 $971,260.70 $0.00 $0.00 $5,095,597.39 Redevelopment ‐ City $1,718,980.83 $12,403.24 $0.00 $0.00 $1,731,384.07 Redevelopment ‐ State $1,231,349.62 $785,744.85 ($1,132,279.69) $0.00 $884,814.78 Housing Fund               1,467,634.54 $283,758.16 $52,446.85 $0.00 1,803,839.55 CDBG                               0.00 $35,836.96 ($35,836.96) $0.00                                 ‐ $           9,830,038.40 $           2,700,287.05 $             (1,580,624.21) $                    63,798.17 $         11,013,499.41 GRAND TOTAL $  56,304,951.74 $  35,064,314.11 $    (29,317,454.37) $                       0.00 $  62,051,811.48 Bank Accounts‐Balances 5/31/2022 Bank Accounts
B of Stkn ‐Gen                  2,367,206.40 B of Stkn ‐Gen                    26,441.41 Petty Cash                              Petty Cash 700.00                          700.00 Police ‐ petty cash                              Police ‐ petty cash 400.00                          400.00 Petty Cash ‐ A/C                              Petty Cash ‐ A/C 200.00                          200.00 B of Stkn.‐PR                           B of Stkn.‐PR 5,999.99                       6,000.00 B of Stkn.‐Rec                        18,376.80 B of Stkn.‐Rec                    36,192.43 B of Stkn.‐PD Voucher Pr                           B of Stkn.‐PD Voucher Pr 1,984.40 o                       1,984.40 B of America‐Prkg Cit.                        11,345.88 B of America‐Prkg Cit.                    14,757.88 LAIF                32,519,941.09 LAIF             35,519,941.09 Bk of New York                26,364,893.84 Bk of New York             26,445,097.53 Redev. Debt ‐ 2020                                   Redev. Debt ‐ 2020 0.45                               0.50 Water Bonds‐2006                                 Water Bonds‐2006 94.06                            94.11 Water Bonds‐2012                                   Water Bonds‐2012 2.13                               2.13 BANK TOTALS 61,291,145.04 $      BANK TOTALS 62,051,811.48 $ TOTAL RESTRICTED FUNDS
CITY OF RIPON
FUND BALANCES SUMMARY
TOTAL CAPITAL FUNDS
TOTAL OPERATING FUNDS
2021‐2022
June‐22 FINAL
C:\Users\lroos\Documents\Month End\06.2022\11. cash June 2022 FINAL.xls - Summary Fund Balances 2022.06.30