L-2 - Monthly Departmental Budget Report

Monthly Activity Report Tiffin, IA Group Summary June July August September October November December January February March April May Account Typ… 2022 2022 2022 2022 2022 2022 2022 2023 2023 2023 2023 2023 Fund: 001 - General Fund Revenue 167,032.11 56,376.33 405,206.12 221,598.55 856,288.24 156,350.07 71,356.48 80,911.62 40,517.49 155,923.63 867,672.27 34,982.68 Expense 246,891.61 167,148.44 117,103.97 382,392.50 143,197.76 109,364.76 233,502.58 152,486.26 152,337.86 144,961.97 220,013.17 54,512.47 Fund 001 Surplus (Deficit): -79,859.50 -110,772.11 288,102.15 -160,793.95 713,090.48 46,985.31 -162,146.10 -71,574.64 -111,820.37 10,961.66 647,659.10 -19,529.79 Fund: 110 - Road Use Tax Revenue 105,062.88 47,753.45 46,033.81 70,760.82 51,970.08 50,155.95 52,904.38 44,687.26 51,643.29 30,518.93 50,544.00 0.00 Expense 38,620.74 24,599.10 41,509.85 42,437.65 35,925.55 65,157.06 49,539.10 48,009.24 18,105.64 43,766.44 40,370.84 5,823.67 Fund 110 Surplus (Deficit): 66,442.14 23,154.35 4,523.96 28,323.17 16,044.53 -15,001.11 3,365.28 -3,321.98 33,537.65 -13,247.51 10,173.16 -5,823.67 Fund: 112 - Employee Benefit Revenue 904.66 1,104.75 0.10 18,395.66 86,488.57 6,328.44 632.49 5,298.51 331.33 12,127.08 83,996.61 0.00 Expense 13,384.29 15,694.70 14,301.75 16,839.76 15,140.91 11,803.94 12,643.76 16,172.44 39,569.42 22,244.74 20,846.18 0.00 Fund 112 Surplus (Deficit): -12,479.63 -14,589.95 -14,301.65 1,555.90 71,347.66 -5,475.50 -12,011.27 -10,873.93 -39,238.09 -10,117.66 63,150.43 0.00 Fund: 119 - Emergency Fund Revenue 38,410.96 205.65 0.01 2,433.65 11,441.94 837.21 15,085.82 556.32 43.82 1,604.34 11,112.26 0.00 Expense 39,261.98 0.00 0.00 0.00 0.00 0.00 15,002.14 0.00 0.00 0.00 0.00 0.00 Fund 119 Surplus (Deficit): -851.02 205.65 0.01 2,433.65 11,441.94 837.21 83.68 556.32 43.82 1,604.34 11,112.26 0.00 Fund: 125 - TIF Revenue 4,771.32 16,986.66 4.67 145,919.53 621,596.61 45,617.60 5,766.07 42,467.64 16,684.87 82,687.81 594,640.80 0.00 Expense 452,767.88 0.00 0.00 0.00 0.00 0.00 81,677.79 0.00 0.00 0.00 0.00 0.00 Fund 125 Surplus (Deficit): -447,996.56 16,986.66 4.67 145,919.53 621,596.61 45,617.60 -75,911.72 42,467.64 16,684.87 82,687.81 594,640.80 0.00 Fund: 200 - Debt Service Revenue 485,110.07 3,464.59 0.60 55,831.38 257,423.87 18,846.53 1,978.56 16,753.68 2,111.59 35,743.25 249,295.04 0.00 Expense 850.00 0.00 0.00 1,200.00 0.00 255,992.74 550.00 0.00 0.00 600.00 0.00 1,908,006.25 Fund 200 Surplus (Deficit): 484,260.07 3,464.59 0.60 54,631.38 257,423.87 -237,146.21 1,428.56 16,753.68 2,111.59 35,143.25 249,295.04 -1,908,006.25 Fund: 301 - DEVELOPER - ESCROW Revenue 0.00 0.00 0.00 0.00 0.00 0.00 0.00 108,367.60 0.00 0.00 0.00 0.00 Expense 0.00 0.00 0.00 110,686.00 0.00 0.00 0.00 0.00 174,896.00 0.00 0.00 0.00 Fund 301 Surplus (Deficit): 0.00 0.00 0.00 -110,686.00 0.00 0.00 0.00 108,367.60 -174,896.00 0.00 0.00 0.00 Fund: 307 - Park Road Paving Expense 120.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 48,621.12 31,667.54 85,465.17 0.00 Fund 307 Total: 120.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 48,621.12 31,667.54 85,465.17 0.00 Fund: 310 - Trail Project Revenue 0.00 0.00 0.00 58,193.99 0.00 0.00 0.00 0.00 0.00 6,286.89 0.00 0.00 5/10/2023 11:19:57 AM Page 1 of 5