L-4 - Monthly Departmental Budget Report

Monthly Activity Report Tiffin, IA Group Summary April May June July August September October November December January February March Account Typ… 2023 2023 2023 2023 2023 2023 2023 2023 2023 2024 2024 2024 Fund: 001 - General Fund Revenue 867,672.27 365,243.88 144,823.25 114,954.71 67,880.61 246,202.49 1,135,910.31 166,165.07 90,835.17 58,178.80 134,159.61 28,166.93 Expense 220,013.17 275,889.23 264,496.69 251,809.64 118,782.70 210,114.86 233,052.15 174,568.46 244,286.30 870,970.56 156,319.17 185,360.71 Fund 001 Surplus (Deficit): 647,659.10 89,354.65 -119,673.44 -136,854.93 -50,902.09 36,087.63 902,858.16 -8,403.39 -153,451.13 -812,791.76 -22,159.56 -157,193.78 Fund: 110 - Road Use Tax Revenue 50,544.00 56,003.79 69,778.16 50,708.03 50,316.83 70,493.52 50,656.55 49,943.77 54,414.52 52,820.17 88,233.33 0.00 Expense 40,370.84 36,473.07 46,941.68 220,233.56 34,908.27 65,121.61 64,318.70 74,167.82 81,912.31 66,770.20 40,074.71 25,779.99 Fund 110 Surplus (Deficit): 10,173.16 19,530.72 22,836.48 -169,525.53 15,408.56 5,371.91 -13,662.15 -24,224.05 -27,497.79 -13,950.03 48,158.62 -25,779.99 Fund: 112 - Employee Benefit Revenue 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 1,267.91 790.98 0.00 Expense 20,846.18 18,836.81 11,435.43 43,407.02 14,995.77 25,937.35 26,510.40 22,118.26 21,971.22 25,170.40 22,805.18 22,442.25 Fund 112 Surplus (Deficit): 63,150.43 -11,544.76 -8,021.72 -41,988.17 -14,995.77 -17,199.14 77,200.04 -11,515.28 -18,513.99 -23,902.49 -22,014.20 -22,442.25 Fund: 119 - Emergency Fund Revenue 11,112.26 800.93 451.62 187.70 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Expense 0.00 0.00 29,571.43 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund 119 Surplus (Deficit): 11,112.26 800.93 -29,119.81 187.70 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund: 121 - Local Option Sales Tax Revenue 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 75,631.65 0.00 Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 55,598.01 0.00 Fund 121 Surplus (Deficit): 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 20,033.64 0.00 Fund: 125 - TIF Revenue 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 58,533.37 4,885.39 0.00 Expense 0.00 0.00 1,556,282.21 0.00 0.00 0.00 0.00 36,666.70 0.00 923,769.56 0.00 0.00 Fund 125 Surplus (Deficit): 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 -865,236.19 4,885.39 0.00 Fund: 200 - Debt Service Revenue 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 1,100,407.50 2,398.72 0.00 Expense 0.00 1,908,006.25 0.00 1,150.00 0.00 1,200.00 0.00 234,438.75 0.00 550.00 0.00 600.00 Fund 200 Surplus (Deficit): 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 1,099,857.50 2,398.72 -600.00 Fund: 301 - DEVELOPER - ESCROW Expense 0.00 0.00 0.00 11,497.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund 301 Total: 0.00 0.00 0.00 11,497.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund: 307 - Park Road Paving Expense 85,465.17 44,694.27 1,765.00 62,793.94 0.00 0.00 6,140.00 4,480.00 0.00 20,270.00 0.00 23,057.74 3/15/2024 11:04:59 AM Page 1 of 4