Loading...
HomeMy WebLinkAbout[4d] Treasuer's Report . . . . . . . ... . ~'.QJ;HT.JOS"~..H Council Agenda Item ~ cl MEETING DATE: January 17,2008 AGENDA ITEM: Treasurer's Report. Treasurer's Report - Requested Action: Accept the December 2007 SUBMITTED BY: Finance BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A PREVIOUS COUNCIL ACTION: None BACKGROUND INFORMATION: December 2007 reconciled cash/investment and budget to actual position for Council review. BUDGET/FISCAL IMPACT: None ATTACHMENTS: December 2007 Financial Reports REQUESTED COUNCIL ACTION: Accept the December 2007 Treasurer's Report as presented. CITY OF ST JOSEPH 01/11/089:47 AM Page 1 Cash and Investment- Council Report Current Period: December 2007 Current FUND FUND Descr Begin Yr MTD Debit MTD Credit Balance 101 General $629,699.92 $939,312.26 $194,867.84 $967,367.79 105 Fire Fund $428,731.73 $23,411.46 $37,952.19 $486,502.71 106 Street Maintenanc -$117,187.94 $0.00 $0.00 -$117,187.94 108 Cable Access Fee $6,101.22 $494.40 $0.00 $11,038.50 150 Economic Develop $65,213.21 $173.08 $3,609.17 $30,981.57 155 TIF 1-3 Borgert (S $4,255.80 $12,000.23 $11,385.54 $4,981.57 156 TIF 1-4 St. Joe De $33,794.48 $29,846.00 $26,744.68 $39,747.19 157 TIF 2-1 Millstream $0.00 $38.39 $0.01 $10,881.81 200 State Collected Sal $143,544.24 $13,657.70 $0.45 $374,279.49 205 Park Dedication $149,261.98 $215.00 $522.87 $60,418.08 210 Recreation Center $43,989.71 $161.98 $0.06 $45,913.82 225 DARE $373.67 $0.00 $0.00 $373.67 230 Lake Wobegon Tra -$10,007.08 $0.00 $0.00 -$10,007.08 232 City Beautification- -$58,940.89 $0.00 $0.00 -$58,940.89 250 Revolving Loan Fu $48,020.66 $176.83 $0.06 $50,121.12 307 2004 EqUipment C -$1,344.64 $41,603.37 $0.00 $6,350.94 320 2007 Refunding (9 $0.00 $503,685.05 $1,005,001.66 $456,767.74 321 Joseph Street Impr $291,460.29 $115,132.52 $300,000.02 $31,298.93 322 City Hall Refunded, -$14,891.73 $4,292.64 $403.00 -$67,445.44 322 City Hall Refunded, $619,535.98 $0.00 $0.00 $619,535.98 323 2004 Improvement $258,190.70 $33,631.08 $0.19 $184,738.74 324 Northland V Improv $122,120.00 $1,263.21 $128,706.81 $538.68 325 2002 Street Improv $949,588.00 $78,367.48 $0.47 $897,730.84 327 2002 Equipment C $48,662.05 $182.33 $51,501.96 $182.27 328 2003 Liberty Pointe $657,739.68 $10,940.01 $45,606.92 $335,425.25 329 2003 Maintenance -$5,102.26 $29,311.61 $123,288.37 -$132,044.66 331 2003 Refunding Fir $98,214.50 $157,399.13 $0.00 $130,814.97 332 2003 Cross Over ( $251,940.20 $26,275.29 $0.19 $180,840.76 333 2005 Improve (HilV $502,502.36 $76,389.94 $120,195.80 $593,585.78 335 Northland Heights/ $836,876.38 $234,886.09 $1.28 $577,276.54 337 2006 Equipment C $7,041.39 $32,492.78 $0.00 $5,599.37 338 2006 Interior St 1m $473,358.12 $113,952.53 $1.08 $554,218.13 341 2007 St Imprv-E Si $0.00 $417,162.01 $1.58. $585,928.93 390 Debt Service Relief $0.00 $128,706.62 $0.00 $128,706.62 425 2002 Street Improv -$24,105.87 $0.00 $162.50 -$435,689.79 435 Northland Heights/ $869,331.04 $0.00 $7,068.73 $685,218.44 438 2006 Interior St 1m $689,268.26 $0.00 $1,138.07 $437,107.41 441 2007 Street Impr (J $0.00 $0.00 $258,567.13 $848,933.47 490 Capital Outlay $424,291.04 $0.00 $10,267.20 $361,086.79 501 Utility Extension - $1,627,249.81 $6,667.34 $1.03 $844,788.18 502 Utility Extension - $0.00 $5,396.73 $1.18 $964,794.42 601 Water Fund $3,060,486.77 $66,051.64 $35,863.28 $1,392,433.78 602 Sewer Fund $953,974.70 $46,684.05 $29,911.64 $1,074,881.88 603 Refuse Collection $328,102.32 $35,709.38 $20,735.31 $264,548.30 651 Storm Water Utility $116,535.90 $15,225.98 $10,062.86 $294,952.62 """"",-""-~"'""""--",,,,,,,-_.,-,.._-,,,,,,,, -^-"".-.mN<o'<,=.,^..___,_....,~.._.",.'-..~_"""'................""""" $14,507,875.70 $13,719,577.28 CITY OF ST JOSEPH 01/11/089:49 AM Page 1 Council Month End Revenue Summary Current Period: December 2007 2007 2007 YTD December 2007 2007 YTD %of FUND FUND Descr Budget 2007 Amt YTD Amt Balance Budget 101 General $2,251,145.00 $929,933.56 $2,351,051.69 -$99,906.69 104.44% 105 Fire Fund $249,023.00 $22,067.14 $247,258.78 $1,764.22 99.29% 108 Cable Access Fee $0.00 $494.40 $11,997.13 -$11,997.13 0.00% 150 Economic Development $0.00 $125.38 $3,733.72 -$3,733.72 0.00% 155 TIF 1-3 Borgert (SKN) $0.00 $12,000.67 $24,055.31 -$24,055.31 0.00% 156 TIF 1-4 St. Joe Development $0.00 $29,849.75. $60,135.34 -$60,135.34 0.00% 157 TIF 2-1 Millstream $0.00 $39.51 $11,209.58 -$11,209.58 0.00% 200 State Collected Sales Tax $0.00 $13,694.68 $181,514.28 -$181,514.28 0.00% 205 Park Dedication $0.00 $221.23 $5,124.64 -$5,124.64 0.00% 210 Recreation Center $0.00 $166.67 $2,003.25 -$2,003.25 0.00% 250 Revolving Loan Fund $0.00 $181.95 $2,186.77 -$2,186.77 0.00% 307 2004 Equipment Certificates $0.00 $41 ,603.37 $81,289.35 -$81,289.35 0.00% 317 Fire Facility, 1997 $0.00 -$93.96 $10,020.26 -$10,020.26 0.00% 319 98 Street Improvement $0.00 $11,228.93 $31,254.08 -$31,254.08 0.00% 320 2007 Refunding (98/99 St Bon $0.00 $505,431.18 $1,486,758.53 -$1,486,758.53 0.00% 321 Joseph Street Improvement $0.00 $113,955.14 $192,367.35 -$192,367.35 0.00% 322 City Hall Refunded, 2005 $0.00 $4,292.64 $52,220.67 -$52,220.67 0.00% 323 2004 Improvements/Northland $0.00 $33,646.58 $53,957.32 -$53,957.32 0.00% 324 Northland V Improvement $0.00 $534.12 $6,643.84 -$6,643.84 0.00% 325 2002 Street Improvement $0.00 $78,406.85 $305,218.00 -$305,218.00 0.00% 327 2002 Equipment Certificates $0.00 $55.14 $2,299.81 -$2,299.81 0.00% 328 2003 Liberty Pointe Street Imp $0.00 $10,973.29 $136,300.60 -$136,300.60 0.00% 329 2003 Maintenance Facility $0.00 $29,311.61 $61,014.13 -$61,014.13 0.00% 331 2003 Refunding Fire Hall $75,073.00 $37,204.13 $110,841.16 -$35,768.16 147.64% 332 2003 Cross Over (93 Streets) $0.00 $26,291.14 $59,626.74 -$59,626.74 0.00% 333 2005 Improve (Hill/Clover) $0.00 $76,456.10 $241,929.62 -$241 ,929.62 0.00% 335 Northland HeightslTrans Corri $0.00 $234,992.21 $590,901.55 -$590,901.55 0.00% 337 2006 Equipment Certificate $0.00 $32,492.78 $67,080.92 -$67,080.92 0.00% 338 2006 Interior St Improvements $0.00 $114,042.64 $300,271.48 -$300,271.48 0.00% 341 2007 St Imprv-E Side/Jade/8 $0.00 $417,292.91 $681,451.81 -$681,451.81 0.00% 390 Debt Service Relief $0.00 $128,706.62 $128,706.62 -$128,706.62 0.00% 428 2003 Street Improvements $0.00 $45,606.52 $45,606.52 -$45,606.52 0.00% 429 Maintenance Facility $0.00 $123,288.37 $123,288.37 -$123,288.37 0.00% 431 Cloverdale Area $0.00 $502,710.60 $502,710.60 -$502,710.60 0.00% 437 2006 Equipment Certificate $0.00 $0.00 $11,382.95 -$11,382.95 0.00% 439 EDA Crossover 2005A $0.00 $403.00 $403.00 -$403.00 0.00% 440 2006 8th Ave Improvement $0.00 $0.00 $157,719.73 -$157,719.73 0.00% 441 2007 Street Impr (Jade Rd/E $0.00 $0.00 $2,816,437.00 -$2,816,437.00 0.00% 501 Utility Extension - Water $0.00 $6,753.31 $403,071.54 -$403,071.54 0.00% 502 Utility Extension - Sewer $0.00 $5,495.14 $1,098,034.36 -$1,098,034.36 0.00% 601 Water Fund $390,100.00 $60,971.20 $837,666.65 -$447,566.65 214.73% 602 Sewer Fund $0.00 $41,466.82 $298,694.82 -$298,694.82 0.00% 603 Refuse Collection $232,000.00 $35,559.91 $222,478.64 $9,521.36 95.90% 651 Storm Water $0.00 $15,255.70 $250,827.55 -$250,827.55 0.00% ....~H'~k.~U_._"..,,__.___.,.,.~..-,~.~...-,..w,u.=~.'~-N_',m_~'.,,_~'_~____~""""'___'~~__-'_Y__"'~"~.'_~n...~.'_"",,._,,,,,",,~.,_.,,~~_____.,,,,__~.=~_w._... .,~~,v,''''''''''''''A''.,~~~''-'''''''~'~_''_''^''' $3,197,341.00 $3,743,108.93 $14,268,746.06 $11,071,405.06 446.27% CITY OF ST JOSEPH Council Month End Revenue -General Fund Current Period: December 2007 2007 %of FUND 2007 YTD December 2007 2007 YTD Budget FUND Oeser SOURCE Descr 2007 Amt YTD Amt Balance Remain FUND 101 General 101 General Current Ad Valorem Taxes $907,611.00 $383,457.49 $798,580.04 $109,030.96 12.01% 101 General State Sales Tax $0.00 $0.00 $216.30 -$216.30 0.00% 101 General Gas Franchise $30,000.00 $0.00 $12,978.06 $17,021.94 56.74% 101 General Electric Franchise $45,000.00 $1,364.99 $43,401.48 $1,598.52 3.55% 101 General Beer $2,100.00 $50.00 $1,926.64 $173.36 8.26% 101 General Liquor $15,000.00 $0.00 $18,470.88 -$3,470.88 -23.14% 101 General Outdoor Liquor Permit $200.00 $0.00 $400.00 -$200.00 -100.00% 101 General Amusement/Hunting Permi $1,500.00 $0.00 $1,220.00 $280.00 18.67% 101 General Excavation Permit $1,500.00 $50.00 $350.00 $1,150.00 76.67% 101 General Cigarette License $700.00 $0.00 $416.66 $283.34 40.48% 101 General Cable Franchise Fee $18,000.00 $0.00 $15,094.36 $2,905.64 16.14% 101 General Building Permits $190,000.00 $3,002.32 $229,823.14 -$39,823.14 -20.96% 101 General Animal License $1,300.00 -$10.00 $2,362.00 -$1,062.00 -81.69% 101 General Rental Housing Registratio $12,000.00 $555.12 $12,335.12 -$335.12 -2.79% 101 General Federal Grants - Other $0.00 $0.00 $1,463.99 -$1,463.99 0.00% 101 General Local Govemment Aid $841,993.00 $420,996.50 $841 ,993.00 $0.00 0.00% 101 General Market Value Credit $0.00 $38,771.72 $76,951.01 -$76,951.01 0.00% 101 General PERA Rate Increase Aid $1,541.00 $770.50 $1,541.00 $0.00 0.00% 101 General Police Training Reim $3,500.00 $0.00 $3,617.82 -$117.82 -3.37% 101 General State aid - Police Fund $32,000.00 $3,983.76 $42,714.39 -$10,714.39 -33.48% 101 General County Grants - Road Main $7,200.00 $7,745.22 $12,815.22 -$5,615.22 -77.99% 101 General Zoning and Subdivision Fe $2,000.00 $0.00 $1,870.00 $130.00 6.50% 101 General Land Use Deposit Fee $20,000.00 -$1,000.00 $9,512.21 $10,487.79 52.44% 101 General Sale of Maps and Publicati $500.00 $30.25 $282.25 $217.75 43.55% 101 General Assessments and research $7,000.00 $440.00 $4,040.00 $2,960.00 42.29% 101 General Special Hearing $4,000.00 $0.00 $4,400.00 -$400.00 -10.00% 101 General Administration Reimb $10,000.00 $8.00 $1,128.00 $8,872.00 88.72% 101 General Weed Cutting $0.00 $0.00 $825.00 -$825.00 0.00% 101 General Park Fees $0.00 $0.00 $4,225.00 -$4,225.00 0.00% 101 General Kennel Fees $0.00 $0.00 $1,030.00 -$1,030.00 0.00% 101 General County Fines $0.00 $5,007.27 $45,164.63 -$45,164.63 0.00% 101 General Policy Fines $25,000.00 $2,220.00 $26,245.00 -$1,245.00 -4.98% 101 General Accident Report Fee $0.00 $0.00 $1,526.25 -$1,526.25 0.00% 101 General Seized Property $1,500.00 $270.00 $3,426.00 -$1,926.00 -128.40% 101 General Special Assessments $2,000.00 $515.02 $966.46 $1,033.54 51.68% 101 General Interest Earnings $30,000.00 $1,676.50 $33,233.15 -$3,233.15 -10.78% 101 General Interest Charges $0.00 $25.00 ~$6,509.70 $6,509.70 0.00% 101 General Co-op Dividend-MN Leagu $12,000.00 $8,413.03 $8,418.84 $3,581.16 29.84% 101 General Water Tower Antenna Leas $2,000.00 $88.97 $1,131.20 $868.80 43.44% 101 General Contributions - Parks $0.00 $0.00 $756.09 -$756.09 0.00% 101 General Surplus Property $0.00 $51,501.90 $53,542.88 -$53,542.88 0.00% 101 General Reimbursement $0.00 $0.00 $23,667.32 -$23,667.32 0.00% 101 General Transfers from Other Fund $24,000.00 $0.00 $13,500.00 $10,500.00 43.75% "--"-""~"".""_'M""'-~'_'_"'""""=NM~' "M'~~"_"'_~W'""_'~'_""-_""'m_w,.~ '-"~""-___.=h.~_M'_"'_,..~'m~.. _.--W.-, ""'N~Y_~N~."NM"_____''''''^___'',,,,,,,,",W^'~'_ "'__'.'''=__'''''~'''Y_..'=Y''''^,' FUND 101 General $2,251,145.00 $929,933.56 $2,351,051.69 -$99,906.69 -4.44% FUND 105 Fire Fund 105 Fire Fund State Grants and Aids $65,000.00 $0.00 $42,230.20 $22,769.80 35.03% 105 Fire Fund Special Fire Service $175,523.00 $20,241.83 $175,596.03 -$73.03 -0.04% 105 Fire Fund Fire Fighting Reimburseme $500.00 $0.00 $1,577.17 -$1,077.17 -215.43% 105 Fire Fund Fire Hall Rental $2,000.00 $0.00 $2,675.00 -$675.00 -33.75% 105 Fire Fund Interest Earnings $6,000.00 $1,825.31 $21,011.38 -$15,011.38 -250.19% 105 Fire Fund Contributions from Private $0.00 $0.00 $500.00 -$500.00 0.00% 105 Fire Fund Reimbursement $0.00 $0.00 $3,669.00 -$3,669.00 0.00% ~M '''A--'''''_N~'_''~~_'~','N,~~_ _~'~~N._"'.yy.........",~.'_~_ ~~__~',~'''A'__'''~~'____'''''''''NAY "'~~='~_"""'''''_'A-._~'_~_'''~''''.'''A_''V_ "--'Y"""""'-__'""''''''_''~W.v FUND 105 Fire Fund $249,023.00 $22,067.14 $247,258.78 . $1,764.22 0.71% FUND 108 Cable Access Fee 108 Cable Access Cable Franchise Fee $0.00 $494.40 $11,997.13 -$11,997.13 0.00% 01/11/08 9:50 AM Page 1 FUND FUND Oescr SOURCE Oescr FUND 108 Cable Access Fee FUND 150 Economic Development 150 Economic Dev Interest Eamings FUND 150 Economic Development FUND 155 TIF 1-3 Borgert (SKN) 155 TIF 1-3 Borge Tax Increment 155 TIF 1-3 Borge Interest Earnings FUND 155 TIF 1-3 Borgert (SKN) FUND 156 TIF 1-4 St. Joe Development 156 TIF 1-4 St. Jo Tax Increment 156 TIF 1-4 SUo Interest Earnings FUND 156 TIF 1-4 St. Joe Development FUND 157 TIF 2-1 Millstream 157 TIF 2-1 Millstr TIF/MIF Deposit 157 TIF 2-1 Millstr Interest Earnings FUND 157 TIF 2-1 Millstream CITY OF ST JOSEPH Council Month End Revenue -General Fund Current Period: December 2007 2007 YTO December 2007 Amt 2007 YTO Amt 2007 %of 2007 YTD Budget Balance Remain $494.40 $11,985.06 $15.61 $12,000.67 $29,716.26 $133.49 $29,849.75 $0.00 ~=W"'_"'~",_''''''$''V","'_W._^W_'.<-'''rl_'.'N." ........'_.:.~,.,""~,~_,........,_""="""'^'N~""MV,'W.._"'=".-,,~_~.^_',,,,,,,~,'___~""'=""'~"> "__".",,",-_~_..,,,,,?,_.,,,.. "........,..,"'..",_., ,_.,_.,...w"'........... $11 ,997.13 -$11,997.13 0.00% __.~___.~~9.____ $12~.:~~.__._w_~2.33. ?~._._..~.~3..'.!~_3.:-E__._.~.O~!~ $0.00 $125.38 $3,733.72 -$3,733.72 0.00% $23,988.58 -$23,988.58 $66.73 -$66.73 $24,055.31 -$24,055.31 0.00% 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $59,432.53 -$59,432.53 0.00% $702.81 -$702.81 0.00% __~_~_~,_~___~~~'___'A.^'_._~~ $60,135.34 -$60,135.34 0.00% $0.00 $0.00 $11,000.00 -$11,000.00 0.00% $0.00 $39.51 $209.58 -$209.58 0.00% ,,~-~--~--,~-_._._~,~-_._---_.~.._-~ $0.00 $39.51 $11,209.58 -$11,209.58 0.00% .N'_"~.~ N_'~__~_,__-_._,_~~_~_~._.____"N..-...""_____...._~~___~_..-___._."__,__~^..__._~.~_.-~____,~~__~,,._~_",'.n~~~'-.-.--' -8.37% $2,500,168.00 $994,510.41 $2,709,441.55 -$209,273.55 01/11/089:50 AM Page 2 FUND FUND Deser FUND 601 Water Fund 601 Water Fund 601 Water Fund 601 Water Fund 601 Water Fund 601 Water Fund 601 Water Fund 601 Water Fund 601 Water Fund 601 Water Fund 601 Water Fund 601 Water Fund 601 Water Fund 601 Water Fund FUND 601 Water Fund FUND 602 Sewer Fund 602 Sewer Fund 602 Sewer Fund 602 Sewer Fund 602 Sewer Fund 602 Sewer Fund 602 Sewer Fund 602 Sewer Fund 602 Sewer Fund 602 Sewer Fund FUND 602 Sewer Fund CITY OF ST JOSEPH 01/11/089:50 AM Page 1 Council Month End Revenue -Enterprise Funds SOURCE Oeser water meters, meter repair State Sales Tax Transfers from Other Funds Water Filtration Surcharge MDS Test Fee inspection fees Penalties and Forfeited Disc Connection/Reconnection fees Undesignated Funds Rate Class One Water Tower Antenna Lease Interest Eamings Water Surcharge - (Monthly) Penalties and Forfeited Disc Sanitary Sewer Service Special Assessments Sewer Line Charge Sewer Inspection Fee Sewer Surcharge - (Monthly) Insurance Settlement Transfers from Other Funds Interest Earnings FUND 603 Refuse Collection 603 Refuse Collec Licenses & Permits 603 Refuse Collec Interest Earnings 603 Refuse Collec Refuse Collection Charges 603 Refuse Collee State Sales Tax 603 Refuse Collee Penalties and Forfeifted Disc FUND 603 Refuse Collection FUND 651 Storm Water Utility 651 Storm Water Penalties and Forfeifted Disc 651 Storm Water Special Assessments 651 Storm Water Interest Earnings 651 Storm Water Development Fee 651 Stom\ Water Rate Class One FUND 651 Storm Water Utility Current Period: December 2007 2007 %of 2007 YTO December 2007 2007 YTO Budget 2007 Amt YTO Amt Balance Remain $1,100.00 $100.00 $4,920.00 -$3,820.00 -347.27% $0.00 $449.65 $2,320.17 -$2,320.17 0.00% $0.00 $0.00 $345,200.00 -$345,200.00 0.00% $0.00 $0.00 $13.65 -$13.65 0,00% $7,000.00 $1,325.28 $7,339.D1 -$339.01 -4.84% $9,000.00 $100.00 $2,800.00 $6,200.00 68.89% $0.00 $856.78 $6,067.68 -$6,067.68 0.00% $0.00 $0.00 $425.00 -$425.00 0.00% $0.00 $638.58 $4,489.90 -$4,489.90 0.00% $250,000.00 $39,195.94 $281,746.45 -$31,746.45 -12.70% $21,000.00 $1 ,680.10 $21,369.64 -$369.64 -1.76% $20,000.00 $4,962.71 $91,817.86 -$71,817.88 -359.09% $82,000.00 $11,662.16 $69,157.27 $12,842.73 15.66% -_"""""___~_N_" _....._X<."...."__,"""'__....'_<,,,""'''''.,'''.__,,_...~_ $390,100.00 $60,971.20 $837,666.65 -$447,566.65 114.73% $0.00 $374.64 $3,610.82 -$3,610.82 0.00% $0.00 $25,238.47 $154,488.14 -$154,486.14 0.00% $0.00 $3,049.53 -$19,590.79 $19,590.79 0.00% $0.00 $8,849.43 $52,447.12 -$52,447.12 0.00% $0.00 $100.00 $2,700.00 -$2,700.00 0.00% $0.00 $0.00 $463.04 -$463.04 0.00% $0.00 $0.00 $10,000.00 -$10,000.00 0.00% $0.00 $0.00 $47,200.00 -$47,200.00 0.00% $0.00 $3,854.75 $47,376.49 -$47,376.49 0.00% M_~^","",~____~'_~"'-^W_"_='~Y~~=-'__"~"_"'_'''''_'____~''_''^'_'____~,____.__.____,.~,_,..YA__'~N."d'_~.~'~W.'.._._ $0.00 $41,466.82 $298,694.82 -$298,694.82 0.00% $9,000.00 $0.00 $8,495.00 $505.00 5.61% $13,000.00 $909.20 $12,386.99 $613.01 4.72% $210,000.00 $31,063.85 $178,730.81 $31,269.19 14.89% $0.00 $3,030.74 $17,836.30 -$17,836.30 0.00% $0.00 $556.12 $5,029.54 -$5,029.54 0.00% ~,~.,^"..-"~.........-",_>",.",..,,,.........,,,,,..,_.v.,,,,,,,,--.,~_.,,.....<<__,,,,,,.,.~_--.,,,",,,.-..__,"'_,..,"".....,_,'_"",'" 'N~_=,'.V;"_""'-~_-"~~''''.,_-.-...-_,_.__'.,..",."^,~_.'M~,,"~_ $232,000.00 $35,559.91 $222,478.64 $9,521.36 4.10% $0.00 $257.08 $1,526.88 -$1,526.86 0.00% $0.00 $94.42 -$210.05 $210.05 0.00% $0.00 $1,055.71 $8,133.26 -$8,133.26 0.00% $0.00 $0.00 $166,589.52 -$166,589.52 0.00% _______$0.00 __~~~.~~A9 _~~74,787.9-:_-=!74,7~7.9~..__ o.oo~ $0.00 $15,255.70 $250,827.55 -$250,827.55 0.00% $622,100.00 $153,253.63 $1,609,667.66 -$987,567.66 -158.75% CITY OF ST JOSEPH 01/11/089:51 AM Page 1 Council Month End Expenditure Summary CUlTent Period: December 2007 2007 2007 2007 YTD % YTD Balance Balance FUND Description 2007 YTD Budget December 2007 Amt YTD Amt 101 General $2,028,976.00 $184,475.82 $1,961,899.33 $67,076.67 3.00% 105 Fire Fund $211,546.00 $36,555.86 $188,108.82 $23,437.18 11.00% 108 Cable Access Fee $0.00 $0.00 $5,665.83 -$5,665.83 0.00% 150 Economic Development $26,350.00 $3,557.90 $35,873.99 -$9,523.99 -36.00% 155 TIF 1-3 Borgert (SKN) $19,705.00 $11,385.53 $23,310.49 -$3,605.49 -18.00% 156 T1F 1-4 St. Joe Development $51,942.00 $26,744.63 $54,028.70 -$2,086.70 -4.00% 157 TIF2-1Millstream $0.00 $0.00 $281.65 -$281.65 0.00% 205 Park Dedication $0.00 $522.80 $79,007.30 -$79,007.30 0.00% 307 2004 Equipment Certificates $0.00 $0.00 $74,467.50 -$74,467.50 0.00% 317 Fire Facility, 1997 $0.00 $17,798.21 $17,798.21 -$17,798.21 0.00% 319 98 Street Improvement $49,620.00 $198,458.59 $248,078.59 -$198,458.59 -400.00% 320 2007 Refunding (98/99 St Bond) $0.00 $1,004,532.42 $1,027,775.42 -$1,027,775.42 0.00% 321 Joseph Street Improvement $155,599.97 $300,000.00 $455,599.99 -$300,000.02 -193.00% 322 City Hall Refunded, 2005 $102,677.00 $403.00 $103,483.50 -$806.50 .1.00% 323 2004 Improvements/Northland $127,145.00 $0.00 $127,145.00 $0.00 0.00% 324 Northland V Improvement $0.00 $128,706.62 $128,706.62 -$128,706.62 0.00% 325 2002 Street Improvement $362,337.50 $0.00 $362,337.50 $0.00 0.00% 327 2002 Equipment Certificates $0.00 $51,501.90 $51,501.90 -$51,501.90 0.00% 328 2003 Liberty Pointe Street Imp $419,997.00 $45,606.52 $465,604.02 -$45,607.02 -11.00% 329 2003 Maintenance Facility $65,322.00 $123,288.37 $188,610.87 -$123,288.87 -189.00% 331 2003 Refunding Fire Hall $75,072.00 -$120,195.00 $76,997.50 -$1,925.50 -3.00% 332 2003 Cross Over (93 Streets) $130,692.00 $0.00 $130,692.50 -$0.50 0.00% 333 2005 Improve (HilUClover) $150,390.00 $120,195.00 $150,390.00 $0.00 0.00% 335 Northland HeightslTrans Corrid $848,500.00 $0.00 $848,500.00 $0.00 0.00% 337 2006 Equipment Certificate $74,468.00 $0.00 $68,760.00 $5,708.00 8.00% 338 2006 Interior Stlmprovements $217,568.00 $0.00 $217,568.76 -$0.76 0.00% 340 2006 8th Ave Improvement $0.00 $0.00 $38,450.40 -$38,450.40 0.00% 341 2007 St Imprv-E Side/Jade/8 Av $0.00 $0.00 $92,398.65 -$92,398.65 0.00% 425 2002 Street Improvement $0.00 $162.50 $406,042.86 -$406,042.86 0.00% 430 2004 Improvements $0.00 $24,220.46 $24,220.46 -$24,220.46 0.00% 431 Cloverdale Area $0.00 $0.00 $2,375.08 -$2,375.08 0.00% 432 2004 Equipment Certificates $0.00 $5,079.27 $5,079.27 -$5,079.27 0.00% 433 2005 Improvements (HilUClover $0.00 $510,353.70 $525,903.12 -$525,903.12 0.00% 435 Northland HeightslTrans Corrid $0.00 $7,068.73 $100,937.36 -$100,937.36 0.00% 438 2006 Interior St Improvements $0.00 $1,138.07 $140,606.12 -$140,606.12 0.00% 441 2007 Street Impr (Jade RdlE $0.00 $258,567.13 $1,967,503.53 -$1,967,503.53 0.00% 490 Capital Outlay $122,289.00 $10,267.20 $63,204.25 $59,084.75 48.00% 501 Utility Extension - Water $0.00 $0.00 $1,200,215.94 -$1,200,215.94 0.00% 502 Utility Extension - Sewer $0.00 $0.00 $129,100.00 -$129,100.00 0.00% 601 Water Fund $796,943.00 $30,641.44 $1,710,617.88 -$913,674.88 -115.00% 602 Sewer Fund $285,228.00 $24,584.55 $411,820.60 -$126,592.60 -44.00% 603 Refuse Collection $195,738.00 $20,559.93 $258,761.64 -$63,023.64 -32.00% 6.5.J...__. Sto~_~aterytil!!L~_.__.__.___.._.!! 0,0~0'~~._.._~.1..~,06~~...._ $86,949:!~..._-=~!_6!~~.!~____-!6~~0~. $6,528,105.47 $3,036,243.65 $14,256,380.88 -$7,728,275.41 -118.00% DEPART Oeser CITY OF ST JOSEPH 01/11/089:51 AM Page 1 Council Month End Expenditure - General Fund Current Period: December 2007 2007 2007 2007 YTD % YTD Balance Balance 2007 YTD December 2007 Amt YTD Amt FUND 101 General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General General FUND 101 General Council Legislative Committie Ordinance & Proceedi Mayor Salaries & Adminstrati Accounting Audit Service Assessing City Attorney Planning and Zonning Community Center City Offices Community Sign Cable Access Crime Control & -Inves Police Training Communication Servic Automotive Services Building Inspec. Admi Emergency Managem Signal Lights Animal Control Street Maintanence Ice & Snow Removal Engineering Fee Street Lighting Street Cleaning Ball Park and Skating Maint Shop Park Areas Miscellaneous Communty Support Fire Protection $47,124.00 $3,647.10 $52,466.01 -$5,342.01 -11.00% $5,950.00 $2,135.00 $5,197.76 $752.24 13.00% $4,250.00 $550.75 $10,594.50 -$6,344.50 -149.00%- $11,915.00 $152.08 $5,565.89 $6,349.11 53.00% $188,682.00 $14,794.09 $192,005.58 -$3,323.58 -2.00% $146,228.00 $10,240.98 $109,287.82 $36,940.18 25.00% $25,000.00 $0.00 $33,675.50 -$8,675.50 -35.00% $20,000.00 $0.00 $21,783.92 -$1,783.92 -9.00% $30,000.00 $3,276.25 $25,162.17 $4,837.83 16.00% $4,000.00 $2,558.13 $32,756.00 -$28,756.00 -719.00% $28,953.00 $643.63 $21,253.17 $7,699.83 27.00% $27,450.00 $1,671.57 $29,271.71 -$1,821.71 -7.00% $0.00 -$44.84 $976.80 -$976.80 0.00% $11,000.00 $1,014.26 $10,065.36 $934.64 8.00% $688,300.00 $58,772.59 $701,540.89 -$13,240.89 -2.00% $13,000.00 $0.00 $7,064.43 $5,935.57 46.00% $10,250.00 $610.23 $12,434.57 -$2,184.57 -21.00% $57,680.00 $7,045.85 $52,865.64 . $4,814.36 8.00% $167,800.00 $9,575.00 $113,200.89 $54,599.11 33.00% $1,100.00 $109.67 $1,051.30 $48.70 4.00% $750.00 $30.06 $276.00 $474.00 63.00% $1,110.00 $464.38 - $2,446.88 -$1,336.88 -120.00% $162,633.00 $16,324.91 $144,821.72 $17,811.28 11.00% $57,313.00 $16,799.70 $53,944.53 $3,368.47 6.00% $35,000.00 $1,420.47 $51,636.19 -$16,636.19 -48.00% $35,650.00 $3,250.60 $41,539.90 -$5,889.90 -17.00% $15,703.00 $723.70 $15,514.66 $188.34 1.00% $4,830.00 $36.97 $2,898.96 $1,931.04 40.00% $20,750.00 $1,638.76 $14,421.34 $6,328.66 31.00% $121,655.00 $5,292.10 $105,993.65 $15,661.35 13.00% $0.00 $0.00 $20.00 -$20.00 0.00% $4,900.00 $1,500.00 $9,198.27 -$4,298.27 -88.00% $80,000.00 $20,241.83 $80,967.32 -$967.32 -1.00% "_.~_'_W"'NN~,'.'_Y_~_~._.=~ ~~~~~=~~~^',^V^',YW"'_"'_'^_^"_"''-N.,.,W-'.'._.'H'-''-__'_''''_''".~__H'''','.''.' ~~"__-'_k.""~"_~__.'_"'____""W_~_ -^-_"'_"".-."~'.~_~~"~___ $2,028,976.00 $184,475.82 $1,961,899.33 $67,076.67 3.00% FUND 105 Fire Fund Fire Fund Fire Administration Fire Fund Fire Fighting Fire Fund Fire Training Fire Fund Fire Communications Fire Fund Fire Repair Service Fire Fund Medical Services Fire Fund Fire Station and Buildi Fire Fund Community Room FUND 105 Fire Fund FUND 108 Cable Access Fee Cable Access Cable Access FUND 108 Cable Access Fee $14,600.00 $643.77 $9,730.11 $4,869.89 33.00% $154,146.00 $33,145.87 $142,496.42 $11,649.58 8.00% $14,700.00 -$1,344.00 $8,403.24 $6,296.76 43.00% $3,000.00 $404.16 $5,069.62 -$2,069.62 -69.00% $3,000.00 $0.00 $6,046.94 -$3,046.94 -102.00% $2,000.00 $86.28 $2,024.47 -$24.47 -1.00% $18,100.00 $2,824.46 $13,060.07 $5,039.93 28.00% $2,000.00 $795.32 $1,277.95 $722.05 36.00% "".>>:.,"O'_"""'M-:"H"'''.;.'''''''''''''"'~'",,,, ^"';'--;:_:"""""""<*""""".'"''_:<<<-'''''''>K'O>>'''''''",_,,:<,,,,,.-,.<<<;''''''''''''''<''''''<<''<<''''''''"'''''''''''':<<<__~'<<<'*;<',;<<:_'_'~'''"''O:<>;/ ,_"_','_""->"':<~,>>"",,,"""'_'."".-;, $211,546.00 $36,555.86 $188,108.82 $23,437.18 11.00% $0.00 $0.00 $5,665.83 -$5,665.83 0.00% W,,,,,,,",,_;.,mm,',v'_'..,..__,__~., ,_..,_.".."..."....~-....'_.,,'.....-=-<<<__.=^"-_____""'-'"__._'..-,,-.---._'dw~.__.,~...,,-..;...........__w___,~."'v.-....~._""",....~._v.._,_,.."'~_ '<-'-"_ $0.00 $0.00 $5,665.83 -$5,665.83 0.00% FUND 150 Economic Development Economic De Economic Developme FUND 150 Economic Development $26,350.00 $3,557.90 $35,873.99 -$9,523.99 -36.00% ".".....,...',.......^,,,....,,.,,.,''''',.,,,__...''''.._W''.N...,.. __...N_..____""__,"...""~._____,'~^'._.",...=.""'"-......w=...y_..w._.".~,...w.~,~.....,_.,._ ."._._._....'^__w~_~.-._.~_""w......._,_ ~_y~~~~'.w..,_.,'. $26,350.00 $3,557.90 $35,873.99 -$9,523.99 -36.00% FUND 155 TIF 1-3 Borgert (SKN) TIF 1-3 Borge Economic Developme $19,705.00 $11,385.53 $23,310.49 -$3,605.49 -18.00% CITY OF ST JOSEPH 01/11/089:51 AM Page 2 Council Month End Expenditure - General Fund Description DEPART Descr 2007 YTD Budget Current Period: December 2007 2007 December 2007 Amt YTD Amt 2007 2007 YTD % YTD Balance Balance -$3,605.49 -18.00% FUND 155 T1F 1-3 Borgert (SKN) FUND 156 TIF 1-4 St. Joe Development TIF 1-4 St. Jo Economic Developme FUND 156 TIF 1-4 St. Joe Development ,~...""......,,,,",__w..,,,,,,.=-<~_.,~",,.......,,_........,,,,_,,,,,_,_,,.._,,,,,,...__,,,,,,....,..-_........,,.w.w<---.,..,,,^,,~W'''''''__''''''__'''H'____'~''''''''"'''~'_'_='' $19,705.00 $51,942.06 w.",",'w...-m_"",""""W""-"''''_''^'''_'~.~ , $51,942.00 $11,385.53 $23,310.49 -4.00% '$26,744.63 $54,028.70 -$2,086.70 ,,,,,,,~.~~.._,w...,,..WNYnWMY-',~.,,v,,,,,,,N."',""~'_'_''''''~_'M'_._..,_w_"""....~_"w.w".."'_..."w,w.'......_~~..".."'''"'''''''^_.w"..'....w.mM''''",__,_'N' $26,744.63 $54,028.70 -$2,086.70 FUND 157 TIF 2-1 Millstream TIF 2-1 MiIIstr Economic Developme ,,___._~~g.:90_____~:29_ FUND 157 TIF 2-1 Millstream $0.00 $0.00 $281.65 $281.65 -4.00% -$281.65 0.00% -~----"'-- -$281.65 0.00% ,.,~~,~,._,,_'~m~""~'"_''~''''''''''' _= ,"""""",w~=~~,'_'.'m~.......".,,,.~N.~YM'__.~....m"v.~"'''''__'~.~~""""""'_'_'M",,,,^',y.,,~~.~m","-~,-" '_'h="~""""W""""""~,^,,,,,,,,,~'_"'_','m,.,,,,,,,,",__,,~_,_'_""'-'''''''~^w_. 'M___"",.~_,,"""''''A'''''''''''',~''''''''-_''''_W _~_.~^""""""^'..v~'~...".^ $2,338,519.00 $262,719.74 $2,269,168.81 $69,350.19 3.00% CITY OF ST JOSEPH 01/11/089:52 AM Page 1 Council Month End Expenditure - Enterprise Funds Current Period: December 2007 2007 2007 2007 YTO December 2007 YTO %YTD DEPART Oescr 2007 Amt YTD Amt Balance Balance FUND 601 Water Fund Water Fund Bond Payment (P & I) $658,820.00 $0.00 $630,894.14 $27,925.86 4.00% Water Fund Other Financing Uses $0.00 -$5,000.00 $50,000.00 -$50,000.00 0.00% Water Fund Power and Pumping $42,900.00 $1,515.93 $20,952.24 $21,947.76 51.00% Water Fund Purification $22,900.00 $1,763.50 $16,528.82 $6,371.18 28.00% Water Fund Purification-Plant 2 $0.00 $6,825.36 $47,458.56 -$47,458.56 0.00% Water Fund Distribution $28,200.00 $0.00 $20,783.20 $7,416.80 26.00% Water Fund CIP-Treatment Plant $0.00 $812.50 $744,929.19 -$744,929.19 0.00% Water Fund CIP-Trunk Water Mains $0.00 $.11,009.14 $12,369.14 -$12,369.14 0.00% Water Fund CIP-Municipal Wells $0.00 $0.00 $0.00 $0.00 0.00% Water Fund CIP-Wellhead Protection $0.00 $0.00 $2,863.09 -$2,863.09 0.00% Water Fund Storage $4,000.00 $177.39 $2,157.37 $1,842.63 46.00% Water Fund Storage-Tower 2 $0.00 $1,675.00 $11,386.50 -$11,386.50 0.00% Water Fund Wa Meter Installation $0.00 $0.00 $32.50 -$32.50 0.00% Water Fund Administration and Gene $74,123.00 $11,862.62 $150,263.13 -$76,140.13 -103.00% Water Fund Depreciation Expense $0.00 $0.00 $0.00 $0.00 0.00% FUND 601 Water Fund $830,943.00 $30,641.44 $1,710,617.88 -$879,674.88 -106.00% FUND 602 Sewer Fund Sewer Fund Bond Payment (P & I) $49,713.00 $0.00 $47,675.76 $2,037.24 4.00% Sewer Fund Other Financing Uses $0.00 -$5,000.00 $50,000.00 -$50,000.00 0.00% Sewer Fund Sanitary Sewer Maintena $18,325.00 $5,197.53 $50,241.31 -$31,916.31 -174.00% Sewer Fund Lift Station-Baker Street $5,525.00 $187.74 $3,630.01 $1,894.99 34.00% Sewer Fund Lift Station-DBl labs Ar $6,225.00 $208.13 $9,253.50 -$3,028.50 -49.00% Sewer Fund Lift Station-Northland $3,725.00 $187.47 $2,482.96 $1,242.04 33.00% Sewer Fund Lift Station-CR 121 $23,425.00 $199.68 $2,504.09 $20,920.91 89.00% Sewer Fund Sewage Treatment Plant $207,900.00 $20,292.33 $197,741.95 $10,158.05 5.00% Sewer Fund Administration and gener $17,323.00 $3,311.67 $48,291.02 -$30,968.02 -179.00% Sewer Fund Depreciation Expense $200,000.00 $0.00 $0.00 $200,000.00 100.00% ~'~___~'~#'_-~~~^'"""^__^'_'_"=___-~~m'-",~_" w_y.'A">>__'''_'~~_'_''~'~_''V_''~._''_'_''--'A~_''''_'~'_A~.'~_"",....W~~'~H~'~..V_.,...__....~ FUND 602 Sewer Fund . $532,161.00 $24,584.55 $411,820.60 $120,340.40 23.00% FUND 603 Refuse Collection Refuse Colle Waste Collection $195,738.00 $20,559.93 $245,261.64 -$49,523.64 -25.00% Refuse Colle Other Financing Uses $0.00 $0.00 -$13,500.00 0.00% FUND 603 Refuse Collection $195,738.00 $20,559.93 $258,761.64 -$63,023.64 -32.00% FUND 651 Storm Water Utility Storm Water Other Financing Uses $0.00 $10,000.00 $79,075.00 -$79,075.00 0.00% Storm Water Storm Water Administrati $10,700.00 $62.50 $7,874.73 $2,825.27 26.00% Storm Water Depreciation Expense $0.00 $0.00 $0.00 $0.00 0.00% ^~'~-"""'"~""""-'-~~-~-~_"~_~_-_~"""=-^"'"'^""""""_"'_~'A~~-".'~_.__-""'"'".....N."""...~H._.__...~._''''''' FUND 651 Storm Water Utility $10,700.00 $10,062.50 $86,949.73 -$76,249.73 -713.00% ""_.A'..A.^_....'__~~___~....-'^'~.,~~~~.~ __.h_~.-....~~,.~~_'"....,,'^"N.~,~.~..~ NY.W'.,',.~~~..............___",WN =^~Mm_'"."..m....~._.'.,,~__._~._......'"N,=__.__~_.-=.,,_~'_'^~^' ""-_",___._."N,~N=~',"'YN..~......,, "~.,'~'V_"N'_'_'_'__'.'_"".'.-.',",__,,,"~'_"'~_ "._~_.._.....-m=.'.w'.,w,~_.....,_~._., $1,569,542.00 $85,848.42 $2,468,149.85 -$898,607.85 -57.00%