Loading...
HomeMy WebLinkAbout[09a] Treasurer's Report11,�� C.1W OF ST. jQSEM MEETING DATE: January 21, 2010 Council Agenda Item 9(a) AGENDA ITEM: Treasurer's Report — Requested Action: Accept the November, December and 4th Quarter 2009 Financial Reports. SUBMITTED BY: Finance BOARD /COMMISSION /COMMITTEE RECOMMENDATION: N/A PREVIOUS COUNCIL ACTION: None BACKGROUND INFORMATION: November and December 2009 reconciled cash /investment and budget to actual position for Council review. The final expenditure and revenue s cannot be determined until all the expenses for 2009 have been recorded. Part of the audit preparation is preparing the 2009 accruals, expenses incurred in 2009 but not billed until 2010. A final 2009 report will be provided by our auditors in May after the audit is complete. The cash and investment balance of the City increased approximately $587,000 in 2009. Some of the increase is the result of the City Council cutting expenditures in light of the State Aid cuts and increased building activity in 2009; however the largest portion of the increase is a result of the assessment payoff for the Northland Heights improvements. Lumber One chose to pay the balance of the assessment instead of carrying the assessments for 2010. The prepaid assessments will be invested until the final debt payments come due for Northland Heights in 2010. The rate of return on investments decreased over 2009. The City has realized interest expense savings with refinancing four bonds. The bond market interest rates remained low over the year. When this happens, the investment market also offers a lower rate of return. The average rate of return in 2008 was 4% versus 3.5% in 2009. As a result interest earnings decreased for the year and are anticipated to remain lower than recent years during 2010. Overall the General fund has spent 85% of the expenditure budget and has received 103% of the revenue budget as of December 31St and before the 2009 accruals are recorded. Revenue received is over the budgeted amount because building permit activity was higher than expected. The General fund also realized a repayment of capital expenditures that was funded by various bond funds. The repayment is shown as transferred revenue. Expenditures were under budget due to the Council choosing to forego the 2009 general capital budget until the impact of the State Aid reduction is known. The City also lost two full -time staff during 2009 that were not replaced by the end of the year. The Enterprise funds show more expended versus received with exception of the water fund. The water fund shows higher revenue versus expenses due to a transfer from the sewer fund to pay for a portion of the 2008 meter conversion project. Utilities will generally show higher expenses at the close of the year as the final revenue is not recorded until the November /December utility bills are received (January 20, 2010). This revenue is recorded in the same manner as the expenditures. Therefore, the final revenue will be recorded as part of the audit. BUDGET /FISCAL IMPACT: None ATTACHMENTS: November, December and 4th Quarter 2009 Treasurer's Reports REQUESTED COUNCIL ACTION: Accept the Treasurer's Report as presented. rt CITY OF ST JOSEPH Cash and Investment- Council Report Current Period: November 2009 $9,949,121.69 $17,143,353.32 $15,525,800.48 $11,566,674.53 Current FUND FUND Descr Begin Yr YTD Debit YTD Credit _Balance 101 General $505,737.24 $2,593,128.04 $2,902,022.11 $196,843.17 105 Fire Fund $476,173.24 $347,295.26 $245,009.23 $578,459.27 108 Cable Access Fee $18,081.74 $9,242.59 $1,013.77 $26,310.56 150 Economic Development $21,974.87 $33,132.50 $52,339.23 $2,768.14 156 TIF 1-4 St. Joe Development $26,638.18 $57,331.99 $53,349.02 $30,621.15 157 TIF 2 -1 Millstream $5,747.09 $8,969.48 $14,573.76 $142.81 200 State Collected Sales Tax $624,429.86 $260,889.55 $3,080.00 $882,239.41 205 Park Dedication $59,424.72 $3,087.34 $17,130.79 $45,381.27 210 Recreation Center $48,136.81 $1,756.42 $27.59 $49,865.64 215 Charitable Gambling $0.00 $6,720.54 $3,303.26 $3,417.28 232 City Beautification - College Av $59.11 $0.00 $0.00 $59.11 250 Revolving Loan Fund $52,547.82 $1,917.36 $30.11 $54,435.07 318 2009A CrossoverRefunding Bonds $0.00 $5,990,590.24 $3,005,270.60 $2,985,319.64 318 2009A CrossoverRefunding Bonds $0.00 $1,974.71 $977.00 $997.71 320 2007 Refunding (98199 St Bond) $380,307.69 $121,582.06 $219,592.40 $282,297.35 321 Joseph Street Improvement $33,433.39 $2,353.06 $29,414.35 $6,372.10 322 City Hall Refunded, 2005 $3,922.27 $95,706.69 $135,653.19 - $36,024.23 323 20041mprovements/Northland $83,613.05 $33,024.10 $142,001.26 - $25,364.11 325 2002 Street Improvement $623,881.81 $371,747.79 $494,965.78 $500,663.82 328 2003 Liberty Pointe Street Imp $303.32 $1,157.79 $220.26 $1,240.85 329 2003 Maintenance Facility $2.63 $538,550.39 $566,398.30 - $27,845.28 331 2003 Refunding Fire Hall $137,738.87 $129,811.97 $149,175.29 $118,375.55 332 2003 Cross Over (93 Streets) $124,351.76 $35,882.19 $71,101.78 $89,132.17 333 2005 Improve (Hill /Clover) $602,729.24 $87,549.90 $181,215.59 $509,063.55 335 Northland Heights/Trans Corrid $564,379.94 $1,198,619.81 $1,145,370.97 $617,628.78 337 2006 Equipment Certificate $7,900.37 $60,569.10 $94,347.40 - $25,877.93 338 2006 Interior St Improvements $785,185.12 $224,058.38 $293,056.70 $716,186.80 341 2007 St Impry -E Side /Jade /8 Av $372,036.99 $444,246.29 $722,657.75 $93,625.53 342 2008 Equipment Certificates $9,523.23 $53,056.24 $85,301.31 - $22,721.84 343 2009B GO CIP Bonds $0.00 $21,955.28 $21,372.74 $582.54 390 Debt Service Relief $116,642.75 $30,305.68 $20,557.99 $126,390.44 435 Northland Heights/Trans Corrid $548,205.56 $23,690.56 $224,546.92 $347,349.20 441 2007 Street Impr (Jade Rd /E $504,478.86 $8,411.89 $20,782.60 $492,108.15 490 Capital Outlay $346,461.81 $21,984.13 $142,128.04 $226,317.90 501 Water Extension $514,426.39 $740,268.10 $878,201.82 $376,492.67 502 Sewer Extension $608,551.30 $240,443.43 $171,962.01 $677,032.72 601 Water Fund $640,567.84 $2,051,539.70 $2,156,673.98 $535,433.56 602 Sewer Fund $564,840.08 $839,626.62 $823,973.83 $580,492.87 603 Refuse Collection $273,169.52 $290,901.60 $292,695.39 $271,375.73 651 Storm Water Utility $263,517.22 $160,274.55 $144,306.36 $279,485.41 $9,949,121.69 $17,143,353.32 $15,525,800.48 $11,566,674.53 r' ,nn,Rl/ L'i�k � ." CITY OF ST JOSEPH Council Month End Expenditure Summary Current Period: November 2009 $4,363,116.00 $4,307,670.66 $8,388,887.34 2009 November 2009 FUND Description YTD Budget 2009 Amt YTD Amt 101 General $2,356,691.00 $140,496.49 $1,933,877.35 105 Fire Fund $239,295.00 $2,571.90 $152,047.61 108 Cable Access Fee $0.00 $214.03 $1,013.77 150 Economic Development $31,700.00 $3,126.59 $46,307.76 155 TIF 1 -3 Borgert (SKN) $0.00 $0.00 $5,948.15 156 TIF 1-4 St. Joe Development $0.00 $0.00 $30,166.31 157 TIF 2 -1 Millstream $0.00 $0.00 $8,945.33 200 State Collected Sales Tax $0.00 $35.00 $165.80 205 Park Dedication $0.00 $134.22 $16,971.20 215 Charitable Gambling $0.00 $1,200.00 $3,300.00 318 2009A CrossoverRefunding Bonds $0.00 $0.00 $73,075.71 320 2007 Refunding (98/99 St Bond) $0.00 $156,553.75 $172,902.76 321 Joseph Street Improvement $0.00 $0.00 $29,154.97 322 City Hall Refunded, 2005 $0.00 $85,565.00 $96,775.26 323 20041mprovements/Northland $0.00 $127,250.00 $129,720.26 325 2002 Street Improvement $0.00 $313,902.50 $368,025.26 328 2003 Liberty Pointe Street Imp $0.00 $0.00 $220.26 329 2003 Maintenance Facility $0.00 $531,391.25 $543,002.76 331 2003 Refunding Fire Hall $0.00 $71,298.75 $82,817.76 332 2003 Cross Over (93 Streets) $0.00 $57,766.25 $60,752.76 333 2005 Improve (HIIUCIover) $0.00 $122,532.50 $150,285.26 335 Northland Heights/Trans Corrid $0.00 $812,912.50 $841,045.26 337 2006 Equipment Certificate $0.00 $67,340.00 $69,900.27 338 2006 Interior St Improvements $0.00 $173,884.38 $217,989.02 341 2007 St Imprv-E Side/Jade /8 Av $0.00 $552,534.38 $600,289.02 342 2008 Equipment Certificates $0.00 $59,855.00 $64,930.27 343 2009B GO CIP Bonds $0.00 $0.00 $18,316.34 390 Debt Service Relief $0.00 $0.00 $4,987.08 435 Northland Heights/Trans Corrid $0.00 $235.40 $189,424.59 441 2007 Street Impr (Jade Rd /E $0.00 $682.04 - $69,321.06 442 2008 Equipment Certificates $0.00 $0.00 $8,513.81 490 Capital Outlay $0.00 $0.00 $29,723.21 501 Water Extension $0.00 $0.00 $436,900.00 502 Sewer Extension $0.00 $2,761.43 $103,109.92 601 Water Fund $923,802.00 $935,853.60 $1,093,847.81 602 Sewer Fund $448,898.00 $60,878.04 $532,457.64 603 Refuse Collection $280,030.00 $24,122.07 $245,688.98 651 Storm Water Utility $82,700.00 $2,573.59 $95,608.88 $4,363,116.00 $4,307,670.66 $8,388,887.34 r' Description 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 General General FUND 101 General FUND 108 Cable Access Fee Cable Access Fee FUND 150 Economic Development CITY OF ST JOSEPH Council Month End Expenditure - General Fund Current Period: November 2009 2009 November 2009 DEPART Descr YTD Budget 2009 Amt YTD Amt Council Legislative Commities Ordinance & Proceedings Mayor Elections Salaries & Adminstrative Accounting Audit Service Assessing City Attorney Planning and Zoning General Government City Offices Facilites and Planning Cable Access Crime Control & Investigation Police Training Communication Service Automotive Services Building Inspec. Admistration Emergency Management Signal Lights Animal Control Ordinance/Easement Enforcement Street Maintenance Ice & Snow Removal Engineering Fee Street Lighting Street Cleaning Ball Park and Skating Rink Maint Shop Park Areas Communty Support Other Financing Uses Fire Protection Cable Access $55,995.00 $10,230.00 $9,950.00 $12,425.00 $2,000.00 $219,515.00 $163,330.00 $25,650.00 $19,000.00 $28,000.00 $54,270.00 $28,200.00 $24,050.00 $10,000.00 $14,540.00 $812,010.00 $10,000.00 $21,670.00 $73,475.00 $121,050.00 $2,950.00 $400.00 $1,600.00 $600.00 $224,365.00 $70,385.00 $40,000.00 $45,000.00 $23,240.00 $5,250.00 $45,395.00 $242,486.00 $11,100.00 $42,010.00 $84,800.00 $2,554,941.00 $0.00 $3,162.39 $875.00 $0.00 $1,100.26 $0.00 $14,172.33 $7,684.72 $0.00 $0.00 $481.50 $0.00 $872.44 $1,928.57 $0.00 $1,049.59 $56,972.66 $22.35 $771.69 $3,760.03 $8,100.00 $6.90 $71.73 $0.00 $0.00 $12,802.29 $522.81 $8,984.20 $3,404.17 $1,279.51 $35.53 $2,003.96 $10,431.86 $0.00 $0.00 $0.00 $140,496.49 $214.03 $35,269.25 $2,963.19 $2,360.94 $7,858.64 $295.51 $174,958.02 $105,307.72 $23,920.00 $18,570.79 $9,633.15 $2,452.20 $15,901.19 $23,087.73 $0.00 $10,688.40 $690,111.01 $4,775.79 $9,600.30 $42,195.75 $94,150.29 $2,400.77 $746.30 $807.88 $0.00 $210,100.33 $54,717.99 $32,596.22 $40,531.97 $14,103.25 $2,604.88 $16,436.82 $173,265.27 $4,322.68 $21,005.00 $86,138.12 $1,933,877.35 $1,013.77 Economic Development Economic Development Authority $35,540.00 $3,126.59 $46,307.76 FUND 150 Economic Development $35,540.00 $3,126.59 $46,307.76 FUND 490 Capital Outlay Capital Outlay Elections $0.00 $0.00 $0.00 Capital Outlay Salaries & Adminstrative $0.00 $0.00 $3,836.02 Capital Outlay City Offices $0.00 $0.00 $0.00 Capital Outlay Cable Access $0.00 $0.00 $0.00 Capital Outlay Crime Control & Investigation $0.00 $0.00 $1,329.07 Capital Outlay Communication Service $0.00 $0.00 $0.00 Capital Outlay Automotive Services $0.00 $0.00 $0.00 Capital Outlay Emergency Management $0.00 $0.00 $0.00 Capital Outlay Street Maintanence $0.00 $0.00 $1,654.06 Capital Outlay Ice & Snow Removal $0.00 $0.00 $14,452.00 r' Description Capital Outlay Capital Outlay Capital Outlay Capital Outlay Capital Outlay FUND 490 Capital Outlay CITY OF ST JOSEPH Council Month End Expenditure - General Fund Current Period: November 2009 $2,590,481.00 $143,837.11 $2,010,922.09 2009 November 2009 DEPART Descr YTD Budget 2009 Amt YTD Amt Street Lighting $0.00 $0.00 $0.00 Ball Park and Skating Rink $0.00 $0.00 $0.00 Maint Shop $0.00 $0.00 $8,400.00 Park Areas $0.00 $0.00 $52.06 Other Financing Uses $0.00 $0.00 $0.00 $0.00 $0.00 $29,723.21 $2,590,481.00 $143,837.11 $2,010,922.09 r' CITY OF ST JOSEPH Council Month End Revenue Summary Current Period: November 2009 $5,402,301.00 $181,075.98 $10,010,270.01 2009 November 2009 FUND FUND Descr YTD Budget 2009 Amt YTD Amt ~$1,592,622.77 101 General $2,545,471.00 $43,795.73 105 Fire Fund $258,150.00 $1,921.88 $239,758.13 108 Cable Access Fee $0.00 $1,444.19 $7,793.39 150 Economic Development $45,010.00 $22.98 $29,362.70 155 TIF 1 -3 Borgert (SKN) $0.00 $0.00 $0.00 156 TIF 1-4 St. Joe Development $0.00 $68.36 $34,082.59 157 TIF 2 -1 Millstream $0.00 $0.32 $3,326.61 200 State Collected Sales Tax $0.00 $26,300.62 $194,792.67 205 Park Dedication $0.00 $101.93 $1,888.76 210 Recreation Center $0.00 $111.37 $1,637.31 215 Charitable Gambling $0.00 $10.31 $6,717.28 230 Lake Wobegon Trail $0.00 $0.00 $9,987.08 232 City Beautification - College Av $0.00 $0.00 $0.00 250 Revolving Loan Fund $0.00 $121.59 $1,787.45 318 2009A CrossoverRefunding Bonds $0.00 $2.23 $3,059,393.06 320 2007 Refunding (98199 St Bond) $2,500.00 $1,009.23 $74,028.63 321 Joseph Street Improvement $0.00 $0.00 $1,387.61 322 City Hall Refunded, 2005 $110,000.00 $66.92 $54,726.47 323 20041mprovements/Northland $33,000.00 $225.83 $20,046.50 325 2002 Street Improvement $66,000.00 $1,682.05 $242,446.05 328 2003 Liberty Pointe Street Imp $0.00 $0.00 $591.81 329 2003 Maintenance Facility $66,000.00 $765.34 $513,799.27 331 2003 Refunding Fin; Hall $77,120.00 $420.51 $62,301.69 332 2003 Cross Over (93 Streets) $14,000.00 $327.36 $24,679.40 333 2005 Improve (Hill /Clover) $15,000.00 $1,409.88 $55,057.58 335 Northland Heights/Trans Corrid $55,000.00 $3,198.62 $869,529.64 337 2006 Equipment Certificate $69,000.00 $88.99 $34,830.05 338 2006 Interior St Improvements $61,000.00 $1,940.16 $146,311.60 341 2007 St Imprv-E Side /Jade /8 Av $36,000.00 $2,478.25 $318,989.88 342 2008 Equipment Certificates $65,500.00 $79.50 $32,494.87 343 2009B GO CIP Bonds $0.00 $0.88 $18,898.88 390 Debt Service Relief $0.00 $274.82 $4,600.97 441 2007 Street Impr (Jade Rd/E $0.00 $0.00 $0.00 490 Capital Outlay $0.00 $0.00 $0.00 501 Water Extension $0.00 $6,393.33 $297,366.58 502 Sewer Extension $0.00 $3,745.27 $170,145.41 601 Water Fund $965,400.00 $31,662.54 $1,317,582.62 602 Sewer Fund $530,850.00 $24,121.55 $262,336.43 603 Refuse Collection $278,600.00 $18,161.98 $213,686.20 651 Storrs Water Utility $108,700.00 $9,121.46 $91,282.07 $5,402,301.00 $181,075.98 $10,010,270.01 r' FUND FUND Descr FUND 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General 101 General FUND 101 General CITY OF ST JOSEPH Council Month End Revenue - General Fund Current Period: November 2009 $2,545,471.00 $43,795.73 $1,592,622.77 FUND 108 Cable Access Fee 108 Cable Access Fee Cable Franchise Fee $0.00 $1,444.19 $7,793.39 2009 November 2009 SOURCE Descr YTD Budget 2009 Amt YTD Amt Current Ad Valorem Taxes $1,179,551.00 $0.00 $543,942.84 Special Levy- City St. Joe $0.00 $0.00 $0.00 State Sales Tax $125.00 - $151.15 $416.52 Gas Franchise $30,500.00 $5,822.12 $20,639.59 Electric Franchise $50,000.00 $9,118.30 $35,591.39 Beer $2,000.00 $431.64 $431.64 Liquor $22,200.00 $0.00 $11,210.00 Outdoor Liquor Permit $1,200.00 $0.00 $1,800.00 Gambling Permits $200.00 $0.00 $110.00 Amusement/Hunting Permit $1,500.00 $690.00 $690.00 Contractors License $100.00 $0.00 $0.00 Excavation Permit $500.00 $0.00 $350.00 Cigarette License $500.00 $433.36 $408.34 Cable Franchise Fee $21,700.00 $1,946.98 $18,147.98 Building Permits $122,000.00 $3,974.66 $132,876.61 Animal License $2,500.00 $60.00 $3,240.00 Rental Housing Registration $17,000.00 $0.00 $21,156.50 Federal Grants - Other $2,000.00 $1,161.56 $6,572.14 Local Government Aid $865,754.00 $0.00 $388,591.50 Market Value Credit $0.00 $0.00 $41,725.07 PERA Rate Increase Aid $1,541.00 $0.00 $770.50 Police Training Reim $3,500.00 $0.00 $3,567.72 State Municipal Funds Aid $6,200.00 $0.00 $6,180.00 State Police Aid $35,000.00 $0.00 $54,009.00 County Grants - Road Maintena $7,750.00 $0.00 $0.00 Zoning and Subdivision Fee $1,250.00 $0.00 $1,170.00 Land Use Deposit Fee $4,000.00 $0.00 $3,798.80 Sale of Maps and Publications $100.00 $0.00 $116.05 Assessments Search $4,000.00 $125.00 $3,550.00 Special Hearing $4,000.00 $0.00 $4,760.00 Administration Reimb $15,000.00 $250.00 $266.00 Weed Cutting $1,500.00 $100.00 $3,520.00 Park Fees $5,000.00 $0.00 $4,600.00 Winter Recreation Donation $0.00 $0.00 $0.00 Kennel Fees $1,000.00 $0.00 $712.00 County Fines $45,000.00 $1,676.01 $24,831.96 Policy Fines $27,000.00 $10,760.00 $32,965.50 Accident Report Fee $1,000.00 $40.00 $584.05 Seized Property $1,500.00 $0.00 $3,123.10 Special Assessments $1,500.00 $0.00 $1,705.75 Interest Earnings $20,000.00 $1,457.59 $16,018.85 Interest Charges $300.00 -$4.97 - $498.70 Co-op Dividend -MN League of C $10,000.00 $191.74 $191.74 Water Tower Antenna Lease $1,100.00 $269.50 $3,519.75 Land Rental $0.00 $0.00 $1,500.00 Contributions from Private Sou $0.00 $0.00 $500.00 Contribution - Health Ins Div $10,000.00 $0.00 415,000.00 Contributions -Pete Christmas $0.00 $0.00 $3,000.00 Contributions - Parks $600.00 $8.39 $858.67 Surplus Property $250.00 $0.00 $35.00 Reimbursement $4,050.00 $5,435.00 $15,574.13 Transfers from Other Funds $14,000.00 $0.00 $188,792.78 $2,545,471.00 $43,795.73 $1,592,622.77 FUND 108 Cable Access Fee 108 Cable Access Fee Cable Franchise Fee $0.00 $1,444.19 $7,793.39 r� CITY OF ST JOSEPH Council Month End Revenue - General Fund Current Period: November 2009 2009 November 2009 FUND FUND Descr SOURCE Descr YTD Budget 2009 Amt YTD Amt FUND 150 Economic Development 150 Economic Development TIF /MIF Deposit $0.00 $0.00 $7,500.00 150 Economic Development Interest Earnings $3,000.00 $22.98 $542.10 150 Economic Development Transfers from Other Funds $42,010.00 $0.00 $21,320.60 FUND 150 Economic Development $45,010.00 $22.98 $29,362.70 $2,590,481.00 $45,262.90 $1,629,778.86 r' CITY OF ST JOSEPH Council Month End Revenue - Enterprise Funds Current Period: November 2009 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 602 Sewer Fund 602 Sewer Fund 602 Sewer Fund 602 Sewer Fund 602 Sewer Fund FUND 602 Sewer Fund Contributed Revenue Reimbursement Special Assessments Interest Earnings Sanitary Sewer Service St. Benedict Sewer Charges St Benedict's SCAWAC fees Penalties and Forfeited Disc Sewer Line Charge Sewer Inspection Fee Sewer Surcharge - (Monthly) Transfers from Other Funds General Oblig. Bond Proceeds Surplus Property 2009 November 2009 YTD Budget 2009 Amt YTD Amt $500.00 $200.00 $0.00 $0.00 $479,000.00 $0.00 $0.00 $9,000.00 $90,000.00 $4,000.00 $150.00 $0.00 $0.00 $300,000.00 $0.00 $0.00 $22,000.00 $0.00 $50,000.00 $1,550.00 $9,000.00 $965,400.00 $0.00 $0.00 $555.00 $35,000.00 $206,795.00 $187,300.00 $0.00 $2,000.00 $50,000.00 $1,000.00 $1,000.00 $47,200.00 $0.00 $0.00 $637.18 - $35.72 $0.00 $0.00 $0.00 $0.00 $0.00 $682.49 $6,496.07 $365.00 $0.00 - $2,320.72 $0.00 $21,337.57 $0.00 $0.00 $2,425.63 $0.00 $1,975.04 $0.00 $100.00 $31,662.54 $0.00 $2,460.76 $0.00 $1,622.40 $12,309.82 $0.00 $0.00 $362.47 $7,266.10 $100.00 $0.00 $0.00 $0.00 $0.00 $530,850.00 $24,121.55 $6,896.44 - $166.77 $1,708.00 $425,000.00 $536,900.00 $0.00 $0.00 $7,541.10 $72,085.23 $7,956.00 $225.00 - $6,562.63 $3,320.16 $218,225.58 $0.00 $0.00 $26,549.65 $0.00 $19,844.06 - $2,139.20 $200.00 $1,317,582.62 $0.00 $2,460.76 - $195.11 $20,785.91 $127,779.83 - $21,054.84 $0.00 $3,932.63 $81,077.25 $200.00 $0.00 $47,200.00 $0.00 $150.00 $262,336.43 FUND 603 Refuse Collection FUND FUND Descr SOURCE Descr FUND 601 Water Fund $15.00 601 Water Fund Penalties and Forfeited Disc 601 Water Fund State Sales Tax 601 Water Fund Bond Premium Proceeds 601 Water Fund General Oblig. Bond Proceeds 601 Water Fund Transfers from Other Funds 601 Water Fund Contributed Revenue 601 Water Fund Wellhead Protection Fee 601 Water Fund MDS Test Fee 601 Water Fund Water Line Charge 601 Water Fund Water Meter 601 Water Fund Connection /Reconnection fees 601 Water Fund Undesignated Funds 601 Water Fund Bulk Water 601 Water Fund Rate Class One 601 Water Fund Reimbursement 601 Water Fund Surplus Property 601 Water Fund Water Tower Antenna Lease 601 Water Fund Amortization of Bond Premium 601 Water Fund Interest Earnings 601 Water Fund Special Assessments 601 Water Fund Inspection Fees 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 602 Sewer Fund 602 Sewer Fund 602 Sewer Fund 602 Sewer Fund 602 Sewer Fund FUND 602 Sewer Fund Contributed Revenue Reimbursement Special Assessments Interest Earnings Sanitary Sewer Service St. Benedict Sewer Charges St Benedict's SCAWAC fees Penalties and Forfeited Disc Sewer Line Charge Sewer Inspection Fee Sewer Surcharge - (Monthly) Transfers from Other Funds General Oblig. Bond Proceeds Surplus Property 2009 November 2009 YTD Budget 2009 Amt YTD Amt $500.00 $200.00 $0.00 $0.00 $479,000.00 $0.00 $0.00 $9,000.00 $90,000.00 $4,000.00 $150.00 $0.00 $0.00 $300,000.00 $0.00 $0.00 $22,000.00 $0.00 $50,000.00 $1,550.00 $9,000.00 $965,400.00 $0.00 $0.00 $555.00 $35,000.00 $206,795.00 $187,300.00 $0.00 $2,000.00 $50,000.00 $1,000.00 $1,000.00 $47,200.00 $0.00 $0.00 $637.18 - $35.72 $0.00 $0.00 $0.00 $0.00 $0.00 $682.49 $6,496.07 $365.00 $0.00 - $2,320.72 $0.00 $21,337.57 $0.00 $0.00 $2,425.63 $0.00 $1,975.04 $0.00 $100.00 $31,662.54 $0.00 $2,460.76 $0.00 $1,622.40 $12,309.82 $0.00 $0.00 $362.47 $7,266.10 $100.00 $0.00 $0.00 $0.00 $0.00 $530,850.00 $24,121.55 $6,896.44 - $166.77 $1,708.00 $425,000.00 $536,900.00 $0.00 $0.00 $7,541.10 $72,085.23 $7,956.00 $225.00 - $6,562.63 $3,320.16 $218,225.58 $0.00 $0.00 $26,549.65 $0.00 $19,844.06 - $2,139.20 $200.00 $1,317,582.62 $0.00 $2,460.76 - $195.11 $20,785.91 $127,779.83 - $21,054.84 $0.00 $3,932.63 $81,077.25 $200.00 $0.00 $47,200.00 $0.00 $150.00 $262,336.43 FUND 603 Refuse Collection 603 Refuse Collect Licenses & Permits $8,000.00 $15.00 $10,750.00 603 Refuse Collect Contributions from Private Sou $0.00 $0.00 $150.00 603 Refuse Collect Interest Earnings $10,000.00 $621.50 $9,131.46 603 Refuse Collect Special Assessments $1,600.00 $0.00 - $612.49 603 Refuse Collect Refuse Collection Charges $240,000.00 $17,705.86 $189,681.31 603 Refuse Collect State Sales Tax $17,000.00 - $794.22 - $1,153.10 603 Refuse Collect Penalties and Forleifted Disc $2,000.00 $613.84 $5,739.02 FUND 603 Refuse Collection $278,600.00 $18,161.98 $213,686.20 FUND 651 Storm Water Utility 651 Storm Water Transfers from Other Funds $0.00 $0.00 $97.00 651 Storm Water Special Assessments $1,200.00 $0.00 - $689.51 651 Storm Water Interest Earnings $7,000.00 $673.41 $9,629.06 651 Storm Water Reimbursement $0.00 $0.00 $0.00 651 Storm Water Contributed Revenue $0.00 $0.00 $0.00 r' CITY OF ST JOSEPH Council Month End Revenue - Enterprise Funds SOURCE Descr Development Fee Rate Class One Penalties and Forfeifted FUND 651 Storm Water Utility Current Period: November 2009 2009 YTD Budget $20,000.00 $80,000.00 Disc $500.00 $108,700.00 November FUND FUND Descr 651 Storm Water 651 Storm Water 651 Storm Water CITY OF ST JOSEPH Council Month End Revenue - Enterprise Funds SOURCE Descr Development Fee Rate Class One Penalties and Forfeifted FUND 651 Storm Water Utility Current Period: November 2009 2009 YTD Budget $20,000.00 $80,000.00 Disc $500.00 $108,700.00 November 2009 2009 Amt YTD Amt a_ m $0.00 $0.00. $8,313.05 $80,603.69 $135.00 $1,641.83 $9,121.46 $91,282.07 $1,883,550.00 $83,067.53 $1,884,887.32 r' CITY OF ST JOSEPH Council Month End Expenditure - Enterprise Funds Current Period: November 2009 FUND 601 Water Fund FUND 602 Sewer Fund Sewer Fund 2009 November 2009 Description DEPART Descr YTD Budget 2009 Amt YTD Amt FUND 601 Water Fund Sewer Fund Lift Station - Northland Sewer Fund Lift Station -CR 121 Water Fund Bond Payment (P & 1) $545,192.00 $912,671.88 $718,102.33 Water Fund Other Financing Uses $55,000.00 $0.00 $55,000.00 Water Fund Power and Pumping $16,700.00 $541.75 $21,308.98 Water Fund Purification -Plant 1 $16,320.00 $1,014.08 $13,751.40 Water Fund Purification -Plant 2 $46,520.00 $3,090.09 $55,049.19 Water Fund Distribution $22,200.00 $680.85 $23,274.04 Water Fund CIP- Treatment Plant 2 $0.00 $0.00 $17,460.00 Water Fund Wellhead Protection $1,000.00 $0.00 $0.00 Water Fund Storage -Tower 1 $2,300.00 $172.49 $2,921.59 Water Fund CIP -Meter Installation $0.00 $0.00 $148.19 Water Fund Water Maintenance $227,145.00 $15,114.17 $158,683.07 Water Fund Administration and general $0.00 $2,568.29 $28,149.02 Water Fund Depreciation Expense $185,000.00 $0.00 $0.00 FUND 601 Water Fund FUND 602 Sewer Fund Sewer Fund Bond Payment (P & 1) Sewer Fund Other Financing Uses Sewer Fund Sanitary Sewer Maintenanc Sewer Fund Lift Station -Baker Street Sewer Fund Lift Station -DBL Labs Area Sewer Fund Lift Station - Northland Sewer Fund Lift Station -CR 121 Sewer Fund Lift Station -Main Sewer Fund Administration and general Sewer Fund Depreciation Expense FUND 602 Sewer Fund FUND 603 Refuse Collection Refuse Collectio Waste Collection Refuse Collectio Other Financing Uses FUND 603 Refuse Collection FUND 651 Storm Water Utility $1,117,377.00 $935,853.60 $1,093,847.81 $47,663.00 $36,331.25 $21,004.77 $55,000.00 $0.00 $155,000.00 $162,505.00 $11,241.73 $95,341.66 $5,000.00 $161.86 $5,543.21 $4,500.00 $117.78 $2,408.94 $3,800.00 $122.67 $2,304.47 $4,000.00 $121.03 $4,672.34 $170,600.00 $33,997.78 $177,742.26 $55,595.00 $3,783.94 $68,439.99 $200,000.00 $0.00 $0.00 $708,663.00 $85,878.04 $532,457.64 $280,280.00 $24,122.07 $245,688.98 $0.00 $0.00 _ $0.00 $280,280.00 $24,122.07 $245,688.98 Storm Water LIN Other Financing Uses $44,075.00 $0.00 Storm Water Util Administration and general $0.00 $799.54 Stone Water Util Storm Water Maintenance $39,545.00 $1,774.05 Storm Water Util Depreciation Expense $80,000.00 $0.00 FUND 651 Storm Water Utility $163,620.00 $2,573.59 $2,269,940.00 $1,048,427.30 $44,075.00 $15,021.46 $36,512.42 $0.00 $95,608.88 $1,967,603.31 r" 4 "d " CITY OF ST JOSEPH Cash and Investment- Council Report Current Period: December 2009 Current FUND FUND Descr Begin Yr YTD Debit YTD Credit Balance 101 General $505,737.24... $3,615,.., 163.89 $3,084,917.66 $1,035,983.47 105 Fire Fund $476,173.24 $365,360.26 $282,646.91 $558,886.59 108 Cable Access Fee $18,081.74 $9,242.59 $1,013.77 $26,310.56 150 Economic Development $21,974.87 $33,160.29 $55,565.57 - $430.41 156 TIF 1-4 St. Joe Development $26,638.18 $90,554.61 $83,135.46 $34,057.31 157 TIF 2 -1 Millstream $5,747.09 $9,363.41 $17,453.76 - $2,343.26 200 State Collected Sales Tax $624,429.86 $288,232.24 $3,080.00 $909,582.10 205 Park Dedication $59,424.72 $3,275.45 $17,200.58 $45,499.59 210 Recreation Center $48,136.81 $1,962.50 $27.59 $50,071.72 215 Charitable Gambling $0.00 $8,923.69 $3,303.26 $5,620.43 232 City Beautification - College Av $59.11 $0.00 $0.00 $59.11 250 Revolving Loan Fund $52,547.82 $2,929.03 $25,019.66 $30,457.19 318 2009A CrossoverRefunding Bonds $0.00 $1,978.84 $996.04 $982.80 320 2007 Refunding (98/99 St Bond) $380,307.69 $175,293.99 $219,592.40 $336,009.28 321 Joseph Street Improvement $33,433.39 $2,908.70 $29,414.35 $6,927.74 322 City Hall Refunded, 2005 $3,922.27 $149,434.62 $135,653.19 $17,703.70 323 20041mprovements/Northland $83,613.05 $50,109.78 $142,001.26 - $8,278.43 325 2002 Street Improvement $623,881.81 $446,793.36 $494,965.78 $575,709.39 328 2003 Liberty Pointe Street Imp $303.32 $1,157.79 $220.26 $1,240.85 329 2003 Maintenance Facility $2.63 $572,222.14 $566,398.30 $5,826.47 331 2003 Refunding Fire Hall $137,738.87 $147,901.55 $149,175.29 $136,465.13 332 2003 Cross Over (93 Streets) $124,351.76 $51,182.86 $71,101.78 $104,432.84 333 2005 Improve (Hill /Clover) $602,729.24 $130,320.80 $181,215.59 $551,834.45 335 Northland Heights/Trans Corrid $564,379.94 $1,524,081.61 $1,145,370.97 $943,090.58 337 2006 Equipment Certificate $7,900.37 $94,443.70 $94,347.40 $7,996.67 338 2006 Interior St Improvements $785,185.12 $285,515.42 $293,056.70 $777,643.84 341 2007 St Imprv-E Side/Jade /8 Av $372,036.99 $837,290.48 $722,657.75 $486,669.72 342 2008 Equipment Certificates $9,523.23 $84,031.25 $85,301.31 $8,253.17 343 2009B GO CIP Bonds $0.00 $21,957.69 $21,372.74 $584.95 390 Debt Service Relief $116,642.75 $31,545.46 $20,557.99 $127,630.22 435 Northland Heights/Trans Corrid $548,205.56 $23,690.56 $227,819.06 $344,077.06 441 2007 Street Impr (Jade Rd /E $504,478.86 $8,411.89 $99,842.87 $413,047.88 490 Capital Outlay $346,461.81 $21,984.13 $143,787.81 $224,658.13 501 Water Extension $514,426.39 $755,199.82 $878,201.82 $391,424.39 502 Sewer Extension $608,551.30 $250,085.13 $171,962.01 $686,674.42 601 Water Fund $640,567.84 $2,107,447.13 $2,181,388.30 $566,626.67 602 Sewer Fund $564,840.08 $880,972.51 $872,553.57 $573,259.02 603 Refuse Collection $273,169.52 $324,030.95 $317,176.41 $280,024.06 651 Storm Water Utility $263,517.22 $171,695.95 $147,559.23 $287,653.94 $9,949,121.69 $13,579,856.07 $12,987,054.42 $10,541,923.34 r' CITY OF ST JOSEPH Council Month End Expenditure Summary Current Period: December 2009 2009 December 2009 FUND Description YTD Budget 2009 Amt YTD Amt 101 General $2,359,191.00 $197,674.10 $2,131,551.45 105 Fire Fund $239,795.00 $37,609.78 $189,657.39 108 Cable Access Fee $0.00 $0.00 $1,013.77 150 Economic Development $33,090.00 $3,225.90 $49,533.66 155 TIF 1 -3 Borgert (SKN) $0.00 $0.00 $5,948.15 156 TIF 1 -4 St. Joe Development $0.00 $29,786.46 $59,952.77 157 TIF 2 -1 Millstream $0.00 $2,880.00 $11,825.33 200 State Collected Sales Tax $0.00 $0.00 $165.80 205 Park Dedication $0.00 $69.79 $17,040.99 215 Charitable Gambling $0.00 $0.00 $3,300.00 250 Revolving Loan Fund $0.00 $24,442.85 $24,442.85 318 2009A CrossoverRefunding Bonds $0.00 $56,651.26 $129,726.97 320 2007 Refunding (98/99 St Bond) $0.00 $0.00 $172,902.76 321 Joseph Street Improvement $0.00 $0.00 $29,154.97 322 City Hall Refunded, 2005 $0.00 $0.00 $96,775.26 323 20041mprovements/Northland $0.00 $0.00 $129,720.26 325 2002 Street Improvement $0.00 $2,500,000.00 $2,868,025.26 328 2003 Liberty Pointe Street Imp $0.00 $0.00 $220.26 329 2003 Maintenance Facility $0.00 $0.00 $543,002.76 331 2003 Refunding Fire Hall $0.00 $0.00 $82,817.76 332 2003 Cross Over (93 Streets) $0.00 $0.00 $60,752.76 333 2005 Improve (Hill /Clover) $0.00 $0.00 $150,285.26 335 Northland Heights/Trans Corrid $0.00 $0.00 $841,045.26 337 2006 Equipment Certificate $0.00 $0.00 $69,900.27 338 2006 Interior St Improvements $0.00 $0.00 $217,989.02 341 2007 St Imprv-E Side/Jade/8 Av $0.00 $0.00 $600,289.02 342 2008 Equipment Certificates $0.00 $0.00 $64,930.27 343 2009B GO CIP Bonds $0.00 $0.00 $18,316.34 390 Debt Service Relief $0.00 $0.00 $4,987.08 435 Northland Heights/Trans Corrid $0.00 $3,272.14 $192,696.73 441 2007 Street Impr (Jade Rd /E $0.00 $79,060.27 $9,739.21 442 2008 Equipment Certificates $0.00 $0.00 $8,513.81 490 Capital Outlay $0.00 $1,659.77 $31,382.98 501 Water Extension $0.00 $0.00 $436,900.00 502 Sewer Extension $0.00 $0.00 $103,109.92 601 Water Fund $923,802.00 $22,645.53 $1,116,493.34 602 Sewer Fund $473,898.00 $488,467.75 $1,020,925.39 603 Refuse Collection $280,030.00 $24,293.39 $269,982.37 651 Storm Water Utility $82,700.00 _$3,252.39 $98,861.27 $4,392,506.00 $3,474,991.38 $11,863,878.72 r' .,A Description 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 General General FUND 101 General CITY OF ST JOSEPH Council Month End Expenditure - General Fund Current Period: December 2009 FUND 108 Cable Access Fee Cable Access Fee Cable Access $0.00 $0.00 $1,013.77 FUND 150 Economic Development Economic Development 2009 December 2009 DEPART Descr YTD Budget 2009 Amt YTD Amt Council $55,995.00 $2,554.31 $37,823.56 Legislative Commities $10,230.00 $689.00 $3,652.19 Ordinance & Proceedings $9,950.00 $295.50 $2,656.44 Mayor $12,425.00 $930.77 $8,789.41 Elections $2,000.00 $0.00 $295.51 Salaries & Adminstrative $219,515.00 $21,306.22 $196,264.24 Accounting $163,330.00 $10,228.61 $115,536.33 Audit Service $25,650.00 $0.00 $23,920.00 Assessing $19,000.00 $0.00 $18,570.79 City Attorney $28,000.00 $297.00 $9,930.15 Planning and Zoning $54,270.00 $200.00 $2,652.20 General Government $28,200.00 $1,416.50 $17,317.69 City Offices $24,050.00 $2,657.30 $25,745.03 Facilites and Planning $10,000.00 $0.00 $0.00 Cable Access $14,540.00 $1,043.99 $11,732.39 Crime Control & Investigation $812,010.00 $87,243.64 $777,354.65 Police Training $10,000.00 $0.00 $4,775.79 Communication Service $21,670.00 $811.57 $10,411.87 Automotive Services $73,475.00 $4,012.60 $46,208.35 Building Inspec. Admistration $121,050.00 $8,500.00 $102,650.29 Emergency Management $2,950.00 $7.39 $2,408.16 Signal Lights $400.00 $77.67 $823.97 Animal Control $1,600.00 $40.25 $848.13 Ordinance/Easement Enforcement $600.00 $0.00 $0.00 Street Maintanence $224,365.00 $19,853.86 $229,954.19 Ice & Snow Removal $70,385.00 $11,478.18 $66,196.17 Engineering Fee $40,000.00 $2,850.89 $35,447.11 Street Lighting $45,000.00 $6,378.54 $46,910.51 Street Cleaning $23,240.00 $1,822.83 $15,926.08 Ball Park and Skating Rink $5,250.00 $83.84 $2,688.72 Maint Shop $45,395.00 $1,731.07 $18,167.89 Park Areas $242,486.00 $11,148.57 $184,413.84 Communty Support $11,100.00 $14.00 $4,336.68 Other Financing Uses $42,010.00 $0.00 $21,005.00 Fire Protection $84,800.00 _ $_0.0_0 _ $86,138.12 $2,554,941.00 $197,674.10 $2,131,551.45 FUND 108 Cable Access Fee Cable Access Fee Cable Access $0.00 $0.00 $1,013.77 FUND 150 Economic Development Economic Development Economic Development Authority $35,540.00 $3,225.90 $49,533.66 FUND 150 Economic Development $35,540.00 $3,225.90 $49,533.66 FUND 490 Capital Outlay Capital Outlay Elections $0.00 $0.00 $0.00 Capital Outlay Salaries & Adminstrative $0.00 $1,659.77 $5,495.79 Capital Outlay City Offices $0.00 $0.00 $0.00 Capital Outlay Cable Access $0.00 $0.00 $0.00 Capital Outlay Crime Control & Investigation $0.00 $0.00 $1,329.07 Capital Outlay Communication Service $0.00 $0.00 $0.00 Capital Outlay Automotive Services $0.00 $0.00 $0.00 Capital Outlay Emergency Management $0.00 $0.00 $0.00 Capital Outlay Street Maintanence $0.00 $0.00 $1,654.06 Capital Outlay Ice & Snow Removal $0.00 $0.00 $14,452.00 Description Capital Outlay Capital Outlay Capital Outlay Capital Outlay Capital Outlay FUND 490 Capital Outlay CITY OF ST JOSEPH Council Month End Expenditure - General Fund Current Period: December 2009 DEPART Descr Street Lighting Ball Park and Skating Rink Maint Shop Park Areas Other Financing Uses 2009 December 2009 YTO Budget 2009 Amt YTD Amt r. $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8,400.00 $0.00 $0.00 $52.06 $0.00 $0.00 $0.00 $0.00 $1,659.77 $31,382.98 $2,590,481.00 $202,559.77 $2,213.481.86 r' FUND FUND Descr CITY OF ST JOSEPH Council Month End Revenue Summary 101 General 105 Fire Fund 108 Cable Access Fee 150 Economic Development 155 TIF 1 -3 Borgert (SKN) 156 TIF 1-4 St. Joe Development 157 TIF 2 -1 Millstream 200 State Collected Sales Tax 205 Park Dedication 210 Recreation Center 215 Charitable Gambling 230 Lake Wobegon Trail 232 City Beautification - College Av 250 Revolving Loan Fund 318 2009A CrossoverRefunding Bonds 320 2007 Refunding (98199 St Bond) 321 Joseph Street Improvement 322 City Hall Refunded, 2005 323 20041mprovements/Northland 325 2002 Street Improvement 328 2003 Liberty Pointe Street Imp 329 2003 Maintenance Facility 331 2003 Refunding Fire Hall 332 2003 Cross Over (93 Streets) 333 2005 Improve (Hill /Clover) 335 Northland Heights/Trans Corrid 337 2006 Equipment Certificate 338 2006 Interior St Improvements 341 2007 St Imprv-E Side /Jade/8 Av 342 2008 Equipment Certificates 343 2009B GO CIP Bonds 390 Debt Service Relief 441 2007 Street Impr (Jade Rd /E 490 Capital Outlay 501 Water Extension 502 Sewer Extension 601 Water Fund 602 Sewer Fund 603 Refuse Collection 651 Storm Water Utility Current Period: December 2009 2009 December 2009 YTD Budget 2009 Amt YTD Amt $2,545,471.00 $1,015,975.43 $2,608,598.20 $258,150.00 $18,037.10 $257,795.23 $0.00 $0.00 $7,793.39 $45,010.00 $27.35 $29,390.05 $0.00 $0.00 $0.00 $0.00 $33,222.62 $67,305.21 $0.00 $393.93 $3,720.54 $0.00 $27,342.69 $222,135.36 $0.00 $188.11 $2,076.87 $0.00 $206.08 $1,843.39 $0.00 $2,203.15 $8,920.43 $0.00 $0.00 $9,987.08 $0.00 $0.00 $0.00 $0.00 $464.97 $2,252.42 $0.00 - $2,928,683.29 $130,709.77 $2,500.00 $53,711.93 $127,740.56 $0.00 $555.64 $1,943.25 $110,000.00 $53,727.93 $108,454.40 $33,000.00 $17,085.68 $37,132.18 $66,000.00 $2,575,045.57 $2,817,491.62 $0.00 $0.00 $591.81 $66,000.00 $33,671.75 $547,471.02 $77,120.00 $18,089.58 $80,391.27 $14,000.00 $15,300.67 $39,980.07 $15,000.00 $42,770.90 $97,828.48 $55,000.00 $325,461.80 $1,194,991.44 $69,000.00 $33,874.60 $68,704.65 $61,000.00 $61,457.04 $207,768.64 $36,000.00 $393,044.19 $712,034.07 $65,500.00 $30,975.01 $63,469.88 $0.00 $2.41 $18,901.29 $0.00 $1,239.78 $5,840.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14,931.72 $312,298.30 $0.00 $9,641.70 $179,787.11 $965,400.00 $53,838.64 $1,371,421.26 $530,850.00 $481,233.90 $743,570.33 $278,600.00 $32,941.72 $246,627.92 $108,700.00 $11,420.92 $102,702.99 $5,402,301.00 $2,429,401.22 $12,439,671.23 i It"d If lii� " CITY OF ST JOSEPH Council Month End Revenue - General Fund Current Period: December 2009 2009 December 2009 FUND FUND Descr SOURCE Descr YTD Budget 2009 Amt YTD Amt FUND 101 General 101 General Current Ad Valorem Taxes $1,179,551.00 $536,794.84 $1,080,737.68 101 General Special Levy- City St. Joe $0.00 $0.00 $0.00 101 General State Sales Tax $125.00 -$7.00 $409.52 101 General Gas Franchise $30,500.00 $0.00 $20,639.59 101 General Electric Franchise $50,000.00 $1,348.75 $36,940.14 101 General Beer $2,000.00 $225.00 $656.64 101 General Liquor $22,200.00 $5,000.00 $16,210.00 101 General Outdoor Liquor Permit $1,200.00 $0.00 $1,800.00 101 General Gambling Permits $200.00 $0.00 $110.00 101 General AmusemenNHunting Permit $1,500.00 $510.00 $1,200.00 101 General Contractors License $100.00 $0.00 $0.00 101 General Excavation Permit $500.00 $0.00 $350.00 101 General Cigarette License $500.00 $0.00 $408.34 101 General Cable Franchise Fee $21,700.00 $0.00 $18,147.98 101 General Building Permits $122,000.00 $6,769.53 $139,646.14 101 General Animal License $2,500.00 $30.00 $3,270.00 101 General Rental Housing Registration $17,000.00 $0.00 $21,156.50 101 General Federal Grants - Other $2,000.00 $0.00 $6,572.14 101 General Local Government Aid $865,754.00 $388,591.50 $777,183.00 101 General Market Value Credit $0.00 $42,269.26 $83,994.33 101 General PERA Rate Increase Aid $1,541.00 $770.50 $1,541.00 101 General Police Training Reim $3,500.00 $0.00 $3,567.72 101 General State Municipal Funds Aid $6,200.00 $0.00 $6,180.00 101 General State Police Aid $35,000.00 $0.00 $54,009.00 101 General County Grants - Road Maintens $7,750.00 $0.00 $0.00 101 General Zoning and Subdivision Fee $1,250.00 $0.00 $1,170.00 101 General Land Use Deposit Fee $4,000.00 $0.00 $3,798.80 101 General Sale of Maps and Publications $100.00 $0.00 $116.05 101 General Assessments Search $4,000.00 $125.00 $3,675.00 101 General Special Hearing $4,000.00 $200.00 $4,960.00 101 General Administration Reimb $15,000.00 $0.00 $266.00 101 General Weed Cutting $1,500.00 $0.00 $3,520.00 101 General Park Fees $5,000.00 $0.00 $4,600.00 101 General Winter Recreation Donation $0.00 $0.00 $0.00 101 General Kennel Fees $1,000.00 $0.00 $712.00 101 General County Fines $45,000.00 $2,304.17 $27,136.13 101 General Policy Fines $27,000.00 $1,615.00 $34,580.50 101 General Accident Report Fee $1,000.00 $90.25 $674.30 101 General Seized Property $1,500.00 $0.00 $3,123.10 101 General Special Assessments $1,500.00 $2,456.18 $4,161.93 101 General Interest Earnings $20,000.00 $2,273.54 $18,292.39 101 General Interest Charges $300.00 $2.00 - $496.70 101 General Co-op Dividend -MN League of C $10,000.00 $9,049.50 $9,241.24 101 General Water Tower Antenna Lease $1,100.00 $269.51 $3,789.26 101 General Land Rental $0.00 $15,000.00 $16,500.00 101 General Contributions from Private Sou $0.00 $0.00 $500.00 101 General Contribution - Health Ins Div $10,000.00 $0.00 - $15,000.00 101 General Contributions -Pvte Christmas $0.00 $0.00 $3,000.00 101 General Contributions - Parks $600.00 $10.40 $869.07 101 General Surplus Property $250.00 $0.00 $35.00 101 General Reimbursement $4,050.00 $277.50 $15,851.63 101 General Transfers from Other Funds $14,000.00 $0.00 $188,792.78 FUND 101 General $2,545,471.00 $1,015,975.43 $2,608,598.20 FUND 108 Cable Access Fee 108 Cable Access Fee Cable Franchise Fee $0.00 $0.00 $7,793.39 r' CITY OF ST JOSEPH Council Month End Revenue - General Fund Current Period: December 2009 2009 December 2009 FUND FUND Descr SOURCE Descr YTD Budget 2009 Amt YTD Amt FUND 150 Economic Development 150 Economic Development TIF /MIF Deposit $0.00 $0.00 $7,500.00 150 Economic Development Interest Earnings $3,000.00 $27.35 $569.45 150 Economic Development Transfers from Other Funds $42,010.00 $0.00 $21,320.60 FUND 150 Economic Development $45,010.00 $27.35 $29,390.05 $2,590,481.00 $1,016,002.78 $2,645,781.64 r' FUND FUND Descr 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 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 602 Sewer Fund 602 Sewer Fund 602 Sewer Fund 602 Sewer Fund 602 Sewer Fund FUND 602 Sewer Fund CITY OF ST JOSEPH Council Month End Revenue - Enterprise Funds SOURCE Descr Penalties and Forfeited Disc State Sales Tax Bond Premium Proceeds General Oblig. Bond Proceeds Transfers from Other Funds Contributed Revenue Wellhead Protection Fee MDS Test Fee Water Line Charge Water Meter Connection/Reconnection fees Undesignated Funds Bulk Water Rate Class One Reimbursement Surplus Property Water Tower Antenna Lease Amortization of Bond Premium Interest Earnings Special Assessments Inspection Fees Contributed Revenue Reimbursement Special Assessments Interest Earnings Sanitary Sewer Service St. Benedict Sewer Charges St. Benedict's SCAWAC fees Penalties and Forfeited Disc Sewer Line Charge Sewer Inspection Fee Sewer Surcharge - (Monthly) Transfers from Other Funds General Oblig. Bond Proceeds Surplus Property FUND 603 Refuse Collection 603 Refuse Collect Licenses & Permits 603 Refuse Collect Contributions from Private Sou 603 Refuse Collect Interest Earnings 603 Refuse Collect Special Assessments 603 Refuse Collect Refuse Collection Charges 603 Refuse Collect State Sales Tax 603 Refuse Collect Penalties and Forfeifted Disc FUND 603 Refuse Collection Current Period: December 2009 2009 December 2009 YTD Budget 2009 Amt YTD Amt $500.00 $406.48 $200.00 - $1,455.55 $0.00 $0.00 $0.00 $0.00 $479,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9,000.00 $1,084.41 $90,000.00 $10,986.50 $4,000.00 $1,275.00 $150.00 $0.00 $0.00 $906.28 $0.00 $0.00 $300,000.00 $34,668.61 $0.00 $30.00 $0.00 $0.00 $22,000.00 $2,425.62 $0.00 $0.00 $50,000.00 $3,467.14 $1,550.00 $44.15 $9,000.00 $0.00 $965,400.00 $53,838.64 $0.00 $0.00 $0.00 $0.00 $555.00 $2,101.54 $35,000.00 $2,773.41 $206,795.00 $23,793.95 $187,300.00 $0.00 $0.00 $0.00 $2,000.00 $236.82 $50,000.00 $12,328.18 $1,000.00 $0.00 $1,000.00 $0.00 $47,200.00 $0.00 $0.00 $440,000.00 $0.00 $0.00 $530,850.00 $481,233.90 $8,000.00 $0.00 $0.00 $0.00 $10,000.00 $1,135.99 $1,600.00 $778.14 $240,000.00 $28,094.19 $17,000.00 $2,552.45 $2,000.00 $380.95 $278,600.00 $32,941.72 $7,302.92 -$1,622.32 $1,708.00 $425,000.00 $536,900.00 $0.00 $0.00 $8,625.51 $83,071.73 $9,231.00 $225.00 - $5,656.35 $3,320.16 $252,894.19 $30.00 $0.00 $28,975.27 $0.00 $23,311.20 - $2,095.05 $200.00 $1,371,421.26 $0.00 $2,460.76 $1,906.43 $23,559.32 $151,573.78 - $21,054.84 $0.00 $4,169.45 $93,405.43 $200.00 $0.00 $47,200.00 $440,000.00 $150.00 $743,570.33 $10,750.00 $150.00 $10,267.45 $165.65 $217,775.50 $1,399.35 $6,119.97 $246,627.92 FUND 651 Storm Water Utility 651 S Storm Water T Transfers from Other Funds $ r' CITY OF ST JOSEPH Council Month End Revenue - Enterprise Funds Current Period: December 2009 FUND 2009 December 2009 FUND Descr SOURCE Descr YTD Budget 2009 Amt YTD Amt 651 Storm Water Development Fee $20,000.00 $0.00 $0.00 651 Storm Water Rate Class One $80,000.00 $10,157.62 $90,761.31 651 Storm Water Penalties and Forfeifted Disc $500.00 $64.01 $1,705.84 FUND 651 Storm Water Utility $108,700.00 $11,420.92 $102,702.99 $1,883,550.00 $579,435.18 $2,464,322.50 r' Description DEPART Descr FUND 601 Water Water Fund Water Fund Water Fund Water Fund Water Fund Water Fund Water Fund Water Fund Water Fund Water Fund Water Fund Water Fund Water Fund CITY OF ST JOSEPH Council Month End Expenditure - Enterprise Funds Fund Bond Payment (P & 1) Other Financing Uses Power and Pumping Purification -Plant 1 Purification -Plant 2 Distribution CIP- Treatment Plant 2 Wellhead Protection Storage -Tower 1 CIP -Meter Installation Water Maintenance Administration and general Depreciation Expense FUND 601 Water Fund FUND 602 Sewer Fund Sewer Fund Bond Payment (P & 1) Sewer Fund Other Financing Uses Sewer Fund Sanitary Sewer Maintenanc Sewer Fund Lift Station -Baker Street Sewer Fund Lift Station -DBL Labs Area Sewer Fund Lift Station - Northland Sewer Fund Lift Station -CR 121 Sewer Fund Lift Station -Main Sewer Fund Administration and general Sewer Fund Depreciation Expense FUND 602 Sewer Fund Current Period: December 2009 2009 December 2009 YTD Budget 2009 Amt YTD Amt $545,192.00 $0.00 $718,102.33 $55,000.00 $0.00 $55,000.00 $16,700.00 $438.91 $21,747.89 $16,320.00 $1,819.00 $15,570.40 $46,520.00 $3,043.80 $58,092.99 $22,200.00 $0.00 $23,274.04 $0.00 $0.00 $17,460.00 $1,000.00 $0.00 $0.00 $2,300.00 $202.13 $3,123.72 $0.00 $0.00 $148.19 $227,145.00 $13,671.51 $172,354.58 $0.00 $3,470.18 $31,619.20 $185,000.00 $0.00 $0.00 $1,117,377.00 $22,645.53 $1,116,493.34 $47,663.00 $440,000.00 $461,004.77 $55,000.00 $0.00 $155,000.00 $162,505.00 $12,388.97 $107,730.63 $5,000.00 $182.13 $5,725.34 $4,500.00 $145.63 $2,554.57 $3,800.00 $134.49 $2,438.96 $4,000.00 $154.62 $4,826.96 $170,600.00 $31,550.23 $209,292.49 $55,595.00 $3,911.68 $72,351.67 $200,000.00 $0.00 $0.00 $708,663.00 $488,467.75 $1,020,925.39 FUND 603 Refuse Collection Refuse Collectio Waste Collection $280,280.00 $24,293.39 $269,982.37 Refuse Collectio Other Financing Uses $0.00 $0.00 _ $0.00 FUND 603 Refuse Collection $280,280.00 $24,293.39 $269,982.37 FUND 651 Storm Water Utility Storm Water Util Other Financing Uses $44,075.00 $0.00 $44,075.00 Storm Water Util Administration and general $0.00 $1,012.90 $16,034.36 Storm Water Util Storm Water Maintenance $39,545.00 $2,239.49 $38,751.91 Stone Water Util Depreciation Expense $80,000.00 H� � S$163,620.00 $_0.00 $0.00 FUND 651 Storm Water Utility ty $3,252.39 $98,861_ 1.27 7 $2,269,940.00 $538,659.06 $2,506,262.37 City of St. Joseph, Minnesota Cash Position As of 12/31/09 First State Bank Maturity Date Interest Current Balance # Securities % of Total Checking Account (Reconciled) N/A 0.3% $ 3,567,385 N/A Money Market Savings N/A 1.40% 980,672 N/A Bank Certificates of Deposit Tiered 5 -36 months 4.17% avg 2,225,394 8 averages 20 months 3.50% Total FSB $ 6,773,451 64% Central MN Federal Credit Union Share Savings Account N/A 0.81% $ 15 N/A Money Market Savings N/A 1.35% 118,472 N/A Power Money Market Checking N/A 1.85% 1,888,567 N/A Jumbo Bank Certificates of Deposit 48months 4.45% avg 218,215 1 averages 48 months 2.12% Total CMFCU $ 2,225,269 21% Total Deposits $ 8,998,720 Salomon Smith Barney Brokered Money Market Savings N/A 0.01% $ 12,279 N/A Government Securities /Notes 105 months 3.07% avg 122,149 1 Brokered Certificates of Deposit Tiered 9 -59 months 4.59% avg 1,197,137 12 averages 39 months 4.15% Total SSB $ 1,331,565 13% Northland Securities Brokered Money Market Savings N/A 0.00% $ 112,474 N/A Brokered Certificates of Deposit 1 month 4.00% avg 99,164 1 averages 1 months 2.00% Total NS $ 211,638 2% Cash Held in Escrow (Cross -Over Bond Refunding) 0.00% $ - 0% Total Investments $ 1,543,203 Total Deposits and Investments $ 10,541,923 Average Interest APY 3.52% 10,541,923 Cash and Investment Balance Petty Cash Administration N/A N/A $ 200 Police Department N/A N/A 75 Total Petty Cash $ 275 Custodial Credit Risk: All deposits and investments insured by FDIC /SPIC /NCUSIF or secured by perfected pledged collateral. Interest Rate Risk: The City is not exposed to interest rate risk because the City does not invest in highly sensitive, interest fluctuating investments. The City attempts to purchase longer termed investments when the interest rates are favorable and depending on cash flow needs to lock into a favorable rate. Credit Risk: There are no instruments exposed to credit risk. Maturity Concentration of Credit Risk: The City invests in various instruments and several financial institutions. $ Securities Averages Brokered Money Markets $ 124,753 1% N/A (over 5% of investment portfolio) Brokered Certificates of Deposit $ 1,296,301 12% 2.58 years Government Bonds /Notes $ 122,149 8% 8.75 years State /Local Government Securities $ - 0% N/A Foreign Currency Risk: The City only invests in USA and USA territories. N txo O 2 A� W E AY'I `W 0 M N W Cli eI .Ln V N C O lD M zT N a� blo s Y C ca f6 V N C O m N a--I 0 M N W Cli eI .Ln V N C O lD M zT N a� blo Y C f6 J C f0 N >` 41 N f0 L DU N 4) Y u v v cu o c 0 U 0 m m m R ■ ■ 0 M N W Cli eI .Ln V N C O lD M zT N N M M V N (U N 00 O N m W N N h m O M O M O h °1 O F' LL O t2 m r O N O O t 0 N V UJ m cli o (h 0 O N J (mj (0 (A 6% (fl l6 cc 0) cH 6% (A 6% (H N O O m O Fl- M O I.- N O M r- a-- O c0 M m m m N M I'- '7 N W O V' m 00 N (— N O I� M P M O O 00 m m ' N't ' N r tf O (O I� O O N N CO m N C N O N co ti v O M co N M I� N CO (O Cl M M I� N O R N O N m y E O co O O M O r (O �' O ' N e» ' V � O O m 'd' N O m O o r.- 00 t N Z to O O O V cq O O O O m r N LL W M (° m o m V r M Or V O O i M i O N i O m i i C O VO oc (00 O CD O O N (° O M M Lq N 'IT N m N O W O N co N r N Or LL M M V N 00 O m W F' LL 6 L6 m O 0 N V UJ a0 cli 0 m N J (mj (0 l6 cc 0) 0 m v> fa (» us (» cs (» U) d Q C ° m M I� CO (O O M N O O O M O N m y E O V m O O M O N (� (O �' O ' O M ' ' V � O O m 'd' N O m O o r.- 00 t N Z V cq m m m N LL W M (° m o m V r M V N O 00 O m M O N m CO O m M (O C O C C O N O N cq E N m N co r N Or LL o (» u> «: y ¢ U O cu m e v m r m m T -e O O (� m (— U N d � N Cl) ct oo v ccli (' m W N U m 0 (n I-- O't N O N O m � M O Vl It N m 'C V M N W O 00 M W O (-- N O O N N N h N O N O N 00 V m c V 1� O O O ( I P r V O O N O O m O W Z (O 00 OD O M m O O d' O O O O Cl) O c0 f— O m (O W m m Cl) � O w 00 V O 0 O CO J O m O (� M (O O O N N O m 0 ¢ � a o m m x U) a U (» ER (fl N N U U) C m (xc ~ (c N Im y c m C R C C O c C C LL M U) O LL (i > > C J ('mnn U U Z •° c O c N E W c« ° V c A V LL y LL y _ ¢ H 00 m LL ,d,, li .0 q C m d t'j m is 3 7 c ® W ° ® C 7 LL a ¢ LL LL N d LL LL 3 �j A d m LL Y W c LL L.JCD LL. w F= y a W 0 J c) W e o 3 J) f6 3 d m m° Ir y N L X W 3 V Q O 4a a-+ 8A 3 m M 0 0 0 0 0 0 0 0 0 0 ° o Lq o Ln N N a--I e I c LL co L N c 0 _� C7 'c N EL E o c U =3 o L w p � o c y -0 Q o M > U � C m a o� co d CL to Go W ^^3 /L Y. 3 V Q O -0 W W M� W «) Q) tio = U = u m Q 7 D Q O w a c LL. LL C 7 LL f6 L v C v C7 a c N C N N L O w >, N � C N a r= 7 d � 6 � L O d � C Q' 0 N �O a m m O O r a d d O Cl) O r O O O O O O O O O O O O O O O O O ' O 0 0 0 O Lri 0 0 Q O w a c LL. LL C 7 LL f6 L v C v C7 a c N C N N L O w >, N � C N a r= 7 d � 6 � L O d � C Q' 0 N �O a m m O O r a d d O Cl) O r •5 V Q N LL 0) N L Q C W Q) a) V v a� 0_ > X a� w oc m � y L 41 4J m w 3 m E 0 V) H. 0 0 0 0 0 v ri 0 0 0 0 0 N r-1 0 0 0 0 0 00 0 0 0 °o �o 0 0O 0 0 0 0 0 0 0 N