L-2 - Monthly Departmental Budget Report

Monthly Activity Report Tiffin, IA Group Summary December January February March April May June July August September October November Account Typ… 2022 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 Fund: 001 - General Fund Revenue 71,356.48 80,911.62 40,517.49 155,923.63 867,672.27 365,243.88 121,913.48 114,954.71 66,188.61 221,965.48 1,135,910.31 139,203.67 Expense 233,502.58 152,486.26 152,337.86 144,961.97 220,013.17 275,889.23 264,496.69 251,809.64 117,090.70 210,114.86 233,052.15 91,169.49 Fund 001 Surplus (Deficit): -162,146.10 -71,574.64 -111,820.37 10,961.66 647,659.10 89,354.65 -142,583.21 -136,854.93 -50,902.09 11,850.62 902,858.16 48,034.18 Fund: 110 - Road Use Tax Revenue 52,904.38 44,687.26 51,643.29 30,518.93 50,544.00 56,003.79 69,778.16 50,708.03 50,316.83 70,493.52 50,656.55 0.00 Expense 49,539.10 48,009.24 18,105.64 43,766.44 40,370.84 36,473.07 46,941.68 220,233.56 34,908.27 65,121.61 64,318.70 57,377.87 Fund 110 Surplus (Deficit): 3,365.28 -3,321.98 33,537.65 -13,247.51 10,173.16 19,530.72 22,836.48 -169,525.53 15,408.56 5,371.91 -13,662.15 -57,377.87 Fund: 112 - Employee Benefit Revenue 632.49 5,298.51 331.33 12,127.08 83,996.61 7,292.05 3,413.71 1,418.85 0.00 8,738.21 103,710.44 10,602.98 Expense 12,643.76 16,172.44 39,569.42 22,244.74 20,846.18 18,836.81 11,435.43 43,407.02 14,995.77 25,937.35 26,510.40 6,424.06 Fund 112 Surplus (Deficit): -12,011.27 -10,873.93 -39,238.09 -10,117.66 63,150.43 -11,544.76 -8,021.72 -41,988.17 -14,995.77 -17,199.14 77,200.04 4,178.92 Fund: 119 - Emergency Fund Revenue 83.68 556.32 43.82 1,604.34 11,112.26 800.93 451.62 187.70 0.00 0.00 0.00 0.00 Expense 0.00 0.00 0.00 0.00 0.00 0.00 29,571.43 0.00 0.00 0.00 0.00 0.00 Fund 119 Surplus (Deficit): 83.68 556.32 43.82 1,604.34 11,112.26 800.93 -29,119.81 187.70 0.00 0.00 0.00 0.00 Fund: 125 - TIF Revenue 5,766.07 42,467.64 16,684.87 82,687.81 594,640.80 60,225.24 21,294.24 18,261.20 0.00 60,510.36 759,217.21 136,694.02 Expense 81,677.79 0.00 0.00 0.00 0.00 0.00 1,556,282.21 0.00 0.00 0.00 0.00 36,666.70 Fund 125 Surplus (Deficit): -75,911.72 42,467.64 16,684.87 82,687.81 594,640.80 60,225.24 -1,534,987.97 18,261.20 0.00 60,510.36 759,217.21 100,027.32 Fund: 200 - Debt Service Revenue 1,978.56 16,753.68 2,111.59 35,743.25 249,295.04 22,608.34 1,580,050.12 4,857.54 0.00 27,030.00 324,136.98 37,929.81 Expense 550.00 0.00 0.00 600.00 0.00 1,908,006.25 0.00 1,150.00 0.00 1,200.00 0.00 0.00 Fund 200 Surplus (Deficit): 1,428.56 16,753.68 2,111.59 35,143.25 249,295.04 -1,885,397.91 1,580,050.12 3,707.54 0.00 25,830.00 324,136.98 37,929.81 Fund: 301 - DEVELOPER - ESCROW Revenue 0.00 108,367.60 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Expense 0.00 0.00 174,896.00 0.00 0.00 0.00 0.00 11,497.50 0.00 0.00 0.00 0.00 Fund 301 Surplus (Deficit): 0.00 108,367.60 -174,896.00 0.00 0.00 0.00 0.00 -11,497.50 0.00 0.00 0.00 0.00 Fund: 307 - Park Road Paving Expense 0.00 0.00 48,621.12 31,667.54 85,465.17 44,694.27 1,765.00 62,793.94 0.00 0.00 6,140.00 4,480.00 Fund 307 Total: 0.00 0.00 48,621.12 31,667.54 85,465.17 44,694.27 1,765.00 62,793.94 0.00 0.00 6,140.00 4,480.00 Fund: 310 - Trail Project Revenue 0.00 0.00 0.00 6,286.89 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11/17/2023 1:57:38 PM Page 1 of 4