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… 2023 2023 2023 2023 2023 2023 2023 2024 2024 2024 2024 2024 Fund: 001 - General Fund Revenue 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 149,018.14 996,187.12 154,441.76 Expense 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 295,454.11 183,255.07 568,024.29 Fund 001 Surplus (Deficit): -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 -146,435.97 812,932.05 -413,582.53 Fund: 110 - Road Use Tax Revenue 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 121,564.95 51,680.21 79,641.52 Expense 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 34,143.85 34,896.21 38,847.54 Fund 110 Surplus (Deficit): 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 87,421.10 16,784.00 40,793.98 Fund: 112 - Employee Benefit Revenue 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 4,054.96 94,602.36 13,883.06 Expense 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 28,135.86 26,141.05 15,936.45 Fund 112 Surplus (Deficit): -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 -24,080.90 68,461.31 -2,053.39 Fund: 119 - Emergency Fund Revenue 451.62 187.70 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Expense 29,571.43 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund 119 Surplus (Deficit): -29,119.81 187.70 0.00 0.00 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 75,631.65 57,546.40 60,358.55 0.00 Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 55,598.01 0.00 0.00 0.00 Fund 121 Surplus (Deficit): 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 20,033.64 57,546.40 60,358.55 0.00 Fund: 125 - TIF Revenue 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 54,109.47 671,865.13 78,634.61 Expense 1,556,282.21 0.00 0.00 0.00 0.00 36,666.70 0.00 923,769.56 0.00 0.00 26,483.89 904,875.74 Fund 125 Surplus (Deficit): -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 54,109.47 645,381.24 -826,241.13 Fund: 200 - Debt Service Revenue 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 99,704.38 293,994.72 1,190,798.72 Expense 0.00 1,150.00 0.00 1,200.00 0.00 234,438.75 0.00 550.00 0.00 600.00 0.00 0.00 Fund 200 Surplus (Deficit): 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 99,104.38 293,994.72 1,190,798.72 Fund: 301 - DEVELOPER - ESCROW Expense 0.00 11,497.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund 301 Total: 0.00 11,497.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund: 307 - Park Road Paving Expense 1,765.00 62,793.94 0.00 0.00 6,140.00 4,480.00 0.00 20,270.00 0.00 53,033.44 28,223.89 0.00 5/17/2024 4:28:50 PM Page 1 of 4