L-2 - Monthly Departmental Budget Report

Monthly Activity Report Tiffin, IA Group Summary January February March April May June July August September October November December Account Typ… 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 Fund: 001 - General Fund Revenue 80,911.62 40,517.49 191,835.29 867,672.27 365,243.88 166,316.57 116,767.13 66,188.61 267,348.52 1,135,910.31 166,165.07 42,837.35 Expense 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 174,568.46 46,062.51 Fund 001 Surplus (Deficit): -71,574.64 -111,820.37 46,873.32 647,659.10 89,354.65 -98,180.12 -135,042.51 -50,902.09 57,233.66 902,858.16 -8,403.39 -3,225.16 Fund: 110 - Road Use Tax Revenue 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 49,943.77 70.50 Expense 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 74,167.82 16,259.17 Fund 110 Surplus (Deficit): -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 -24,224.05 -16,188.67 Fund: 112 - Employee Benefit Revenue 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 3,457.23 Expense 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 22,118.26 6,151.10 Fund 112 Surplus (Deficit): -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 -11,515.28 -2,693.87 Fund: 119 - Emergency Fund Revenue 556.32 43.82 1,604.34 11,112.26 800.93 451.62 187.70 0.00 0.00 0.00 0.00 0.00 Expense 0.00 0.00 0.00 0.00 0.00 29,571.43 0.00 0.00 0.00 0.00 0.00 0.00 Fund 119 Surplus (Deficit): 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 0.00 Fund: 125 - TIF Revenue 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 22,307.38 Expense 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 0.00 Fund 125 Surplus (Deficit): 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 22,307.38 Fund: 200 - Debt Service Revenue 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 10,561.92 Expense 0.00 0.00 600.00 0.00 1,908,006.25 0.00 1,150.00 0.00 1,200.00 0.00 234,438.75 0.00 Fund 200 Surplus (Deficit): 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 -196,508.94 10,561.92 Fund: 301 - DEVELOPER - ESCROW Revenue 108,367.60 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Expense 0.00 174,896.00 0.00 0.00 0.00 0.00 11,497.50 0.00 0.00 0.00 0.00 0.00 Fund 301 Surplus (Deficit): 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 0.00 Fund: 307 - Park Road Paving Expense 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 0.00 Fund 307 Total: 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 0.00 Fund: 310 - Trail Project Revenue 0.00 0.00 6,286.89 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 12/15/2023 2:59:48 PM Page 1 of 4