HomeMy WebLinkAbout[04g] Treasurer's ReportCITY UP t+T. J[kC1+.pH .
Council Agenda Item 4
MEETING DATE: May 21, 2009
AGENDA ITEM: Treasurer's Report -Requested Action: Accept the Apri12009
Treasurer's Report.
SUBMITTED BY: Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N!A
PREVIOUS COUNCIL ACTION: None
BACKGROUND INFORMATION: Apri12009 reconciled cash/investment and budget to actual
position for Council review.
The 2008 accruals were reversed out. This will cause some revenues and expenditures to show a negative
balance. The negative balance will remain until the revenue or expenditure occurs in 2009. Most of these
revenues and expenditures already occurred in 2009, but there are a few items remaining.
BUDGET/FISCAL IMPACT:
ATTACHMENTS:
None
Apri12009 Financial Reports
REQUESTED COUNCIL ACTION: Accept the Apri12009 Treasurer's Report as presented.
r'
~~ ~~~~~
CITY OF ST JOSEPH
Council Month End Revenue Summary
Currer>t Period: April 2009
2008 April 2009
FUND FUND Descr YTD Budget 2009 Amt YTD Amt
101 General $358,325.00 $17,145.96 $37,991.36
105 Fire Fund $246,850.00 $24,779.37 $80,014.06
108 Cable Access Fee $9,700.00 $0.00 $959.19
150 Economic Development $3,000.00 $17,57 $186.94
155 TIF 1-3 Borgert (SKN) $126.00 $12.46 $72.60
156 TIF 1-4 St. Joe Development $903.00 $55.92 $308.59
157 TIF 2-1 Millstream $200.00 $12,06 $67.81
200 State Collected Sales Tax $0.00 $7,894.97 $17,250.97
205 Park Dedication $0.00 $125.16 $735.27
210 Recreation Center $0.00 $101.08 $597.44
215 Charitable Gambling $0.00 $13.72 $6,615.02
250 Revolving Loan Fund $2,300.00 $110.33 $652.27
318 2009A CrossoverRefunding Bonds $0.00 $0.68 $3,059,372.64
320 2007 Refunding (98/99 SI Bond) $0.00 $817.42 $13,883.78
321 Joseph Street Improvement $0.00 $71.54 $416.03
322 City Hall Refunded, 2005 $0.00 $0.00 $5.29
323 20041mprovements/Northland $0.00 $176.05 $958.93
325 2002 Street Improvement $0.00 $1,315.11 $9,242.80
328 2003 Liberty Pointe Street Imp $0.00 $0.00 $591.81
329 2003 Maintenance Facility $0.00 $2.38 $8.32
331 2003 Refunding Fire Hall $77,605.00 $10,139.99 530,377.23
332 2003 Cross Over (93 Streets) $0.00 $264.69 $2,870.76
333 20051mprove (HilUClover) $0.00 $1,266.41 $7,674.35
335 Northland Heights/Trans Corrid $0.00 $2,317.59 $13,301.84
337 2006 Equipment Certificate $0.00 $18.80 $111.99
338 2006 Interior St Improvements $0.00 $1,652.95 $10,820.80
341 2007 St Imprv-E Side/Jade/8 Av $0.00 $1,826.04 $11,942.09
342 2008 Equipment Certificates $0.00 $30.37 $311.48
390 Debt Service Relief $0.00 $244.55 $1,350.00
501 Water Extension 50.00 $1,081.00 $6,157.28
502 Sewer Extension $0.00 51,278.03 $7,358.67
601 Water Fund $477,250.00 $35,589.55 $22,392.43
602 Sewer Fund $481,650.00 $32,051.83 -$222,918.80
603 Refuse Collection $278,600.00 $32,191.76 $44,135.57
651 Storm Water Utility $88,700.00 $11,919.37 $19,443.19
05/14/09 9:52 AM
Page 1
$2,025,209.00 $184,524.71 $3,185,260.00
ri CITY OF ST JOSEPH
'"``~ ~''~~ it Month End Revenue -General Fund
Counc
Current Period: April 2009
2009 April
FUND FUND Descr SOURCE Descr YTD Budget 2009 Amt
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
FUND 101 General
FUND 105 Fire Fund
105 Fire Fund
105 Fire Fund
105 Fire Fund
105 Fire Fund
105 Fire Fund
State Sates Tax
Gas Franchise
Electric Franchise
Outdoor Liquor Permit
Gambling Permits
Excavation Permit
Building Permits
Animal License
Federal Grants -Other
State Municipal Funds Aid
Zoning and Subdivision Fee
Land Use Deposit Fee
Sale of Maps and Publications
Assessments Search
Special Hearing
Administration Reimb
Park Fees
Kennel Fees
County Fines
Policy Fines
Acadent Report Fee
Seized Property
Specal Assessments
Interest Earnings
Interest Charges
Water Tower Antenna Lease
Contribution -Health Ins Div
Contributions-Pule Christmas
Contributions -Parks
Reimbursement
State Grants and Aids
Other Governmental Unit
Special Fire Service
Fire Hall Rental
Interest Earnings
FUND 105 Fire Fund
FUND 108 Cable Access Fee
108 Cable Access Fee
Cable Franchise Fee
FUND 150 Economic Development
150 Economic Development Interest Earnings
2009
YTD Amt
$125.00 $1.33 $44.38
$30,500.00 $0.00 -$6,606.40
$50,000.00 $1,187.13 $10,368.79
$1,200.00 $500.00 $2,500.00
$200.00 $0.00 $50.00
$500.00 $50.00 $100.00
$122,000.00 $1,477.51 $3,746.31
$2,500.00 $1,088.00 $2,208.00
$2,000.00 $0.00 -$0.38
$6,200.00 $0.00 $3,090.00
$1,250.00 $0.00 $600.00
$4,000.00 $2,500.00 $3,250.00
$100.00 $33.75 $58.25
$4,000.00 $375.00 $1,575.00
$4,000.00 $800.00 $2,000.00
$15,000.00 $8.00 $16.00
$5,000.00 $540.00 $2,910.00
$1,000.00 $43.00 $149.00
$45,000.00 $2,479.57 $9,153.24
$27,000.00 $4,205.50 $9,240.50
$1,000.00 $165.00 $312.30
$1,500.00 $0.00 $23.00
$1,500.00 $0.00 $14.22
$20,000.00 $953.37 $7,829.14
$300.00 $0.04 -$764.93
$1,100.00 $202.80 -$1,711.00
$10,000.00 $0.00 -$15,000.00
$0.00 $0.00 $2,000.00
$600.00 $81.96 $81.96
_
$750.00 $454.00 $753.98
$358,325.00 $17,145.96 $37,991.36
$42,000.00 $0.00 $3,000.00
$1,200.00 $0.00 $700.00
$186,650.00 $23,627.97 $68,790.47
$3,000.00 $75.00 $1,325.00
$14,000.00 $1,076.40 $6,198.59
$246,850.00 $24,779.37 $80,014.06
$9,700.00 $0.00 $959.19
$3,000.00 $17.57 $186.94
$617,875.00 $41,942.90 $119,151.55
05/14/09 9:46 AM
Page 1
i
CITY OF ST JOSEPH
Council Month End Revenue -Enterprise Funds
Current Period: April 2009
FUND 2009 April 2009
FUND Descr SOURCE Descr YTD Budget 2009 Amt YTD Amt
FUND 601 Water Fund
601 Water Fund Special Assessments $1,550.00 $0.00 -$2,610.14
601 Water Fund Interest Earnings $50,000.00 $1,341.21 $7,529.45
601 Water Fund Water Tower Antenna Lease $22,000.00 $1,825.09 -$15,399.44
601 Water Fund Rate Class One $300,000.00 $20,175.33 $14,540.13
601 Water Fund Bulk Waier $0.00 $60.00 $60.00
601 Water Fund Undesignated Funds $0.00 $801.63 $568.18
601 Water Fund Penalties and Forteited Disc $500.00 $520.67 $2,077.58
601 Water Fund Water Meter $4,000.00 $0.00 $616.00
601 Water Fund Water Line Charge $90,000.00 $9,862.50 $13,742.61
601 Water Fund MDS Test Fee $9,000.00 $1,070.41 $1,548.87
601 Water Fund State Sales Tax $200.00 -$67.29 -$280.81
FUND 601 Water Fund $477,250.00 $35,589.55 $22,392.43
FUND 602 Sewer Fund
602 Sewer Fund St. Benedict Sewer Charges $187,300.00 $0.00 -$255,892.51
602 Sewer Fund Special Assessments $555.00 $0.00 -$441.71
602 Sewer Fund Sanitary Sewer Service $206,795.00 $19,173.31 $9,828.92
602 Sewer Fund Penalties and Forteited Disc $2,000.00 $459.79 $1,512.38
602 Sewer Fund Sewer Line Charge $50,000.00 $11,257.70 515,648.76
602 Sewer Fund Interest Earnings $35,000.00 $1,161.03 $6,425.36
FUND 602 Sewer Fund 5481,650.00 $32,051.83 -$222,918.80
FUND 603 Refuse Collection
603 Refuse Collect State Sales Tax $17,000.00 $785.70 -$2,094.00
603 Refuse Collect Licenses 8 Permits $8,000.00 55,515.00 S5,515.00
603 Refuse Coiled Refuse Collection Charges $240,000.00 $24,710.54 $36,204.00
603 Refuse Collect Penalties and ForfeiRed Disc $2,000.00 $476.66 52,005.99
603 Refuse Collect Special Assessments $1,600.00 $0.00 -$940.86
603 Refuse Collect Interest Earnings $10,000.00 $553.86 $3,295.44
603 Refuse Collect Contributions from Private Sou $0.00 $150.00 $150.00
FUND 603 Refuse Collection $278,600.00 $32,191.76 544,135.57
FUND 651 Storm Water Utility
651 Storm Water Penalties and Forfeifted Disc $500.00 $179.16 $665.35
651 Storm Water Special Assessments $1,200.00 $0.00 -$733.16
651 Storm Water Interest Earnings $7,000.00 $565.38 53,397.82
651 Storm Water Rate Class One $80,000.00 $11,174.83 $16,113.18
FUND 651 Storm Water Utility $88,700.00 $11,919.37 $19,443.19
$1,326,200.00 $111,752.51 -$136,947.61
05/14/09 9:54 AM
Page 1
ii CITY OF ST JOSEPH
Council Month End Expenditure Summary
Current Period: April 2009
2009 April 2009
FUND Description YTD Budget 2009 Amt YTD Amt
101 General $2,206,986.00 $213,398.36 $720,696.24
105 Fire Fund $151,590.00 $17,476.28 $37,462.41
150 Economic Development $29,700.00 $2,590.81 $16,859.07
200 State Collected Sales Tax $0.00 $70.00 $70.00
205 Park Dedication $0.00 $74.90 $224.70
215 Charitable Gambling $0.00 $2,100.00 $2,100.00
318 2009A CrossoverRetunding Bonds $0.00 $0.00 $73,075.71
320 2007 Refunding (98/99 St Bond) $0.00 $0.00 $220.26
322 City Hall Refunded, 2005 $0.00 $0.00 $220.26
323 20041mprovementsMorthland $0.00 $0.00 $220.26
325 2002 Street Improvement $0.00 $0.00 $220.26
328 2003 Liberty Pointe Street Imp $0.00 $0.00 $220.26
329 2003 Maintenance Facility $0.00 $0.00 $220.26
331 2003 Refunding Fire Hall $0.00 $0.00 $220.26
332 2003 Cross Over (93 Streets) $0.00 $0.00 $220.26
333 2005 Improve {HilUClover) $0.00 $0.00 $220.26
335 Northland Heights/Trans Corrid $0.00 $0.00 $220.26
337 2006 Equipment Certificate $0.00 $0.00 $220.27
338 2006 Interior St Improvements $0.00 $0.00 $220.26
341 2007 St Imprv-E Side/Jade/8 Av $0.00 $0.00 $220.26
342 2008 Equipment Certificates $0.00 $0.00 $220.27
435 Northland Heights/Trans Corrid $0.00 $2,573.27 $7,351.85
441 2007 Street Impr (Jade Rd/E $0.00 $1,094.22 -$71,770.80
442 2008 Equipment Certificates $0.00 $0.00 $8,513.81
490 Capital Outlay $0.00 $661.06 $3,942.70
601 Water Fund $857,902.00 $89,334.75 -$266,558.66
602 Sewer Fund $415,213.00 $37,514.42 $70,627.29
603 Refuse Collection $278,630.00 $22,499.29 $69,413.07
651 Storm Water Utility $37,325.00 $2,767.45 $16,226.81
$3,978,346.00 $392,154.81 $691,317.86
05/14/09 9:42 AM
Page 1
rlt CITY OF ST JOSEPH
~
...
,nti.~l fn~t..~
Council Month End Expenditure -General Fund
Current Period: April 2009
2009 April 2009
Description DEPART Descr YTD Budget 2009 Amt YTD Amt
FUND 101 General
General Council $55,995.00 $3,284.74 $11,533.21
General Legislative Commities $10,230.00 $420.00 $516.00
General Ordinance 8 Proceedings $9,950.00 $40.00 $40.00
General Mayor $12,425.00 $960.35 $2,114.50
General Elections $2,000.00 $0.00 $295.51
General Salaries & Adminstrative $219,515.00 $16,495.53 $62,800.77
General Accounting $163,330.00 $10,758.51 $49,052.96
General Audit Service $25,650.00 $12,620.00 $23,420.00
General Assessing $19,000.00 $0.00 $0.00
General City Attorney $28,000.00 $756.00 $19,586.38
General Planning and Zoning $54,270.00 $222.05 $1,646.63
General General Government $28,200.00 $2,435.66 $6,020.54
General City Offices $24,050.00 $3,534.96 $9,667.58
General Facilites and Planning $10,000.00 $0.00 $0.00
General Cable Access $14,540.00 $1,030.05 $3,079.08
General Crime Control 8 Investigation $812,010.00 $67,996.17 $246,183.14
General Police Training $10,000.00 -$439.31 $3,637.09
General Communication Service $21,670.00 $899.60 $3,214.71
General Automotive Services $73,475.00 $6,530.89 $14,084.35
General Building Inspec. Admistration $121,050.00 $7,600.00 $24,747.50
General Emergency Management $2,950.00 $207.39 $852.09
General Signal Lights $400.00 $82.73 $280.45
General Animal Control $1,600.00 $32.10 $428.73
General Ordinance/Easement Enforcerrrent $600.00 $0.00 $0.00
General Street Maintanence $219,365.00 $31,016.55 $63,781.54
General Ice 8 Snow Removal $70,385.00 $5,645.04 $45,342.42
General Engineering Fee $40,000.00 $1,695.12 $26,899.81
General Street Lighting $50,000.00 $3,847.47 $11,233.19
General Street Cleaning $23,240.00 $3,523.25 $3,523.25
General Ball Park and Skating Rink $7,250.00 $80.32 $2,214.24
General Maint Shop $45,395.00 $2,130.60 $7,706.51
General Park Areas $240,486.00 $29,992.59 $46,441.94
General Communty Support $11,100.00 $0.00 -$134.77
General Other Financing Uses $42,010.00 $0.00 $0.00
General Fire Protection $84,800.00 $0.00 $30,486.89
FUND 101 General $2,554,941.00 $213,398.36 $720,696.24
FUND 108 Cable Access Fee
Cable Aa:ess Fee Cable Access $0.00 $0.00 $0.00
FUND 150 Economic Development
Economic Development Economic Development Authority $35,540.00
._ $2,590.81 $16,859.07
FUND 150 Economic Development $35,540.00 $2,590.81 $16,859.07
FUND 490 Capital Outlay
Capital Outlay Elections $0.00 $0.00 $0.00
Capital Outlay Salaries & Adminstrative $0.00 $681.06 $2,238.58
Capital Outlay City Offices $0.00 $0.00 $0.00
Capital Outlay Cable Access $0.00 $0.00 $0.00
Capital Outlay Crime Control 8 Investigation $0.00 $0.00 $0.00
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 $0.00
05/14/09 9:43 AM
Page 1
~~r~~~ r~' - ~ CITY OF ST JOSEPH
fin- Council Month End Expenditure -General Fund
Current Period: April 2009
Description
Capital Outlay
Capital Outlay
Capital Outlay
Capital Outlay
Capital Outlay
FUND 490 Capital Outlay
2009 April 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 $0.00
Park Areas $0.00 $0.00 $52.06
Other Financing Uses $0.00 $0.00 $0.00
$0.00 $661.06 $3,942.70
$2,590,481.00 $216,650.23 $741,498.01
05114/09 9:43 AM
Page 2
~ CITY OF ST JOSEPH
Council Month End Expenditure -Enterprise Funds
Current Period: ApNI 2009
2009 April 2009
Description DEPART Descr YTD Budget 2009 Amt YTD Amt
FUND 601 Water Fund
Water Fund Bond Payment (P 6 I) $545,192.00 $47,520.00 -$374,178.93
Water Fund Other Financing Uses $55,000.00 $0.00 $0.00
Water Fund Power and Pumping $16,700.00 $518.34 $3,158.95
Water Fund Purification $16,320.00 $2,031.43 $6,839.96
Water Fund Purification-Plant 2 $46,520.00 $7,591.90 $19,556.08
Water Fund Distribution $22,200.00 $980.00 $1,431.86
Water Fund CIP-Wellhead Protection $1,000.00 $0.00 $0.00
Water Fund Storage $2,300.00 $240.19 $741.44
Water Fund Wa Meter Installation $0.00 $0.00 $148.19
Water Fund Water Maintenance $227,145.00 $27,484.19 $66,568.50
Water Fund AdminisUation and general $0.00 $2,968.70 $9,175.29
Water Fund Depreciation Expense $185,000.00 $0.00 $0.00
FUND 601 Water Fund $1,117,377.00 $89,334.75 -$266,558.66
FUND 602 Sewer Fund
Sewer Fund Bond Payment (P 8 I) $47,663.00 $0.00 -$26,657.73
Sewer Fund Other Financing Uses $55,000.00 $0.00 $0.00
Sewer Fund Sanitary Sewer Maintenanc $162,505.00 $13,912.39 $29,953.41
Sewer Fund Lift Station-Baker Street $5,000.00 $527.82 $1,233.31
Sewer Fund Lift Station-DBL Labs Area $4,500.00 $174.45 $854.57
Sewer Fund Lift Station-Northland $3,800.00 $279.47 $871.97
Sewer Fund Lift Station-CR 121 $4,000.00 $407.73 $1,477.22
Sewer Fund Sewage TreatmenUMain St $170,600.00 $13,012.97 $40,105.90
Sewer Fund Administration and general $55,595.00 $9,199.59 $22,788.64
Sewer Fund Depredation Expense $200,000.00
..._.. $0.00 $0.00
FUND 602 Sewer Fund _
$708,663.00 .
$37,514.42
$70,627.29
FUND 603 Refuse Collection
Refuse Collectio Waste Collection $280,280.00 $22,499.29 $69,385.48
Refuse Collectio Other Financing Uses $0.00 $0.00 $0.00
Refuse Coilectio Administration and general $0.00 $0.00 $27.59
FUND 603 Refuse Collection $280,280.00 $22,499.29 $69,413.07
FUND 651 Storm Water Utility
Storm Water Util Other Financing Uses $44,075.00 $0.00 $0.00
Storm Water Util Administration and general $0.00 $868.48 $4,993.05
Storm Water Util Storm Water Maintenance $39,545.00 $1,898.97 $11,233.76
Sloan Water Util Depredation Expense $80,000.00 $0.00 $0.00
FUND 651 Storm Water Utility $183,620.00 $2,767.45 $16,226.81
$2,269,940.00 $152,115.91 -$110,291.49
05/14/09 9:44 AM
Page 1
~~/r'~~ ~ ~ CITY OF ST JOSEPH
Cash and Investment- Council Report
Current Period: April 2009
Current
FUND FUND Descr Begln Yr YTD Deblt YTD Credit Balance
101 General $505,737.24 $169,438.15 $820,278.85 -$145,103.46
105 Fire Fund $476,173.24 $97,324.39 $40,197.23 $533,300.40
108 Cable Access Fee $18,081.74 $2,408.39 $0.00 $20,490.13
150 Economic Development $21,974.87 $235.42 $19,169.22 $3,041.07
155 TIF 1-3 Borgert (SKN) $5,936.91 $83.84 $0.00 $6,020.75
156 TIF 1-4 St. Jce Development $26,638.18 $375.28 $0.00 $27,013.46
157 TIF 2-1 Millstream $5,747.09 $82.25 $0.00 $5,829.34
200 State Collected Sales Tax $624,429.86 $80,433.65 $70.00 $704,793.51
205 Park Dedication $59,424.72 $1,849.16 $299.60 $60,974.28
210 Recreation Center $48,136.81 $688.96 $0.00 $48,825.77
215 Charitable Gambling $0.00 $6,615.02 $2,100.00 $4,515.02
230 Lake Wobegon Trail $22.92 $0.00 $0.00 $22.92
232 City Beautification-College Av $59.11 $0.00 $0.00 $59.11
250 Revolving Loan Fund $52,547.82 $752.07 $0.00 $53,299.89
318 2009A CrossoverRefunding Bonds $0.00 $977.29 $0.00 $977.29
318 2009A CrossoverRefunding Bonds $0.00 $5,990,590.24 $3,005,270.60 $2,985,319.64
320 2007 Refunding (98/99 St Bond) $380,307.69 $14,747.57 $220.26 $394,835.00
321 Joseph Street Improvement $33,433.39 $1,122.10 $0.00 $34,555.49
322 City Hall Refunded, 2005 $3,922.27 $2,107.58 $220.26 $5,809.59
323 20041mprovements/Northland $83,613.05 $1,655.53 $220.26 $85,048.32
325 2002 Street Improvement $623,881.81 $11,604.02 $220.26 $635,265.57
328 2003 Liberty Pointe Street Imp $303.32 $1,157.79 $220.26 $1,240.85
329 2003 Maintenance Faality $2.63 $1,363.90 $220.26 $1,146.27
331 2003 Refunding Fire Hall $137,738.87 $31,529.98 $220.26 $169,048.59
332 2003 Cross Over (93 Streets) $124,351.76 $3,724.53 $220.26 $127,856.03
333 2005 Improve (HiIVClover) $602,729.24 $9,236.34 $220.26 $611,745.32
335 Northland Heights/Trans Corrid $564,379.94 $38,066.30 $220.26 $602,225.98
337 2006 Equipment Certificate $7,900.37 $1,403.91 $220.27 $9,084.01
338 2006 Interior St Improvements $785,185.12 $13,499.90 $220.26 $798,464.76
341 2007 St Imprv-E Side/Jade/8 Av $372,036.99 $14,829.77 $220.26 $386,646.50
342 2008 Equipment Certificates $9,523.23 $501.81 $220.27 $9,804.77
390 Debt Senrice Relief $116,642.75 $1,473.80 $0.00 $118,116.55
035 Northland Heightslfrans Corrid $548,205.56 $0.00 $18,783.62 $529,421.94
041 2007 Street Impr (Jade Rd/E $504,478.86 $7,957.89 $17,878.86 $494,557.89
090 Capital Outlay $346,461.81 $19,509.13 $113,872.53 $252,098.41
501 Water Extension $514,426.39 $7,756.98 $0.00 $522,183.37
502 Sewer Extension $608,551.30 $8,804.60 $0.00 $617,355.90
501 Water Fund $640,567.84 $132,511.22 $172,429.22 $600,649.84
302 Sewer Fund $564,840.08 $113,068.41 $120,840.50 $557,067.99
503 Refuse Collection $273,169.52 $102,132.49 $97,201.00 $278,101.01
551 Storm Water Utility $263,517.22 $41,836.01 $18,324.63 $287,028.60
$9,955,081.52 $6,933,455.67 $4,449,799.52 $12,438,737.67
05/14/09 9:53 AM
Page 1