HomeMy WebLinkAbout[04d] Treasurer's Report
Council Agenda Item 4d
MEETING DATE: August 21, 2017
AGENDA ITEM: Treasurer’s Report – July 2017
SUBMITTED BY: Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A
PREVIOUS COUNCIL ACTION: None
BACKGROUND INFORMATION:
Cash/investment reconciled through July 31, 2017. Budget to actual reports attached for Council review.
The cash and investment balance decreased $680,112 since the beginning of the year. We continue to
spend down bond funds for the government center and Field Street projects. The 2017 bond issues will
be received in later August.. Fund deficits will be covered by the end of the year. Some TIF funds show
deficits. This is normal until increments start flowing in. The EDA fund is covering the deficits until TIF
is received. The EDA fund will be paid back. The CBD Alley project fund and Government Center
project funds will be recovered when bonds are issued.
The General fund spent 53% of the expenditure budget and received 56% of the revenue budget at the end
of July. Of note, the building permit revenue far exceeds budget by $108,000.
The Enterprise funds spent 29% (without depreciation) and received 35% of the revenue budget. The
utility bills represent the Jan-May usage. Expenses represent seven months.
BUDGET/FISCAL IMPACT: None – Information Only
ATTACHMENTS: Request for Council Action – Treasurer’s Report
July 2017 Treasurer’s Reports:
Cash Balances
Month End Revenue Summary
Month End Revenue Summary – General Fund
Month End Revenue Summary – Enterprise Funds
Month End Expenditure summary
Month End Expenditure Summary – General Fund
Month End Expense Summary – Enterprise Funds
REQUESTED COUNCIL ACTION: Accept the Treasurer’s Report as presented.
Current Period: July 2017
FUND Descr Account Begin Yr
MTD
Debit
MTD
Credit
Current
Balance
Last Dim 10100
General G 101-10100 $1,766,671.46 $750,717.65 $242,892.81 $1,713,495.01
Employee Retirement Reserve G 102-10100 $99,763.34 $0.00 $0.00 $115,843.34
Fire Fund G 105-10100 $563,122.18 $47,389.67 $61,318.84 $582,954.19
Cable Access Fee G 108-10100 $25,893.55 $647.18 $0.00 $30,185.59
Economic Development G 150-10100 $123,620.69 $12,921.68 $5,800.99 $133,829.52
TIF 3-1 CMCU G 152-10100 $154.37 $6,372.10 $20,545.33 $667.46
TIF 4-1 Fortitude Senior Apts G 153-10100 $1.38 $0.00 $0.00 $2,279.50
TIF 2-1 Millstream G 157-10100 $20,737.15 $5,512.15 $17,709.13 $21,354.29
TIF 2-2 Meat Market G 158-10100 $316.33 $1,252.01 $3,972.62 $406.58
TIF 2-3 Bayou Blues/Alley Flat G 159-10100 $30.97 $13.27 $1,419.91 -$2,090.58
State Collected Sales Tax G 200-10100 $1,481,459.54 $41,889.01 $208,349.34 $1,370,459.34
Park Dedication G 205-10100 $120,162.18 $3,040.19 $529.00 $122,999.90
Charitable Gambling G 215-10100 $2,067.07 $5.71 $0.00 $2,082.09
Lodging Tax G 220-10100 $7,675.51 $26.89 $0.00 $10,294.22
DEED CDAP Grant G 225-10100 $0.00 $30.54 $0.00 $11,121.44
Revolving Loan Fund G 250-10100 $25,212.38 $736.94 $0.00 $37,246.14
2016 CIP Bonds [govt center] G 301-10100 $56,584.50 $35,391.92 $189.40 $128,966.20
2017A CIP Bonds [Gov Center] G 303-10100 $0.00 $0.00 $0.00 $0.00
2016 Street Impr [Field St] G 304-10100 $1,376.01 $2,841.44 $0.00 -$396.26
2017B Impr Bonds [CBD Alleys G 305-10100 $0.00 $19,150.00 $0.00 $25,338.69
2009A CrossoverRefunding Bo G 318-10100 $159,645.38 $28,283.29 $0.00 $248,885.55
2011A Refunding Fire Hall G 331-10100 $22,252.66 $4,874.20 $0.00 $42,852.63
2010B Refundin [Hill/Clover] G 333-10100 $157,765.71 $9,164.92 $0.00 $191,612.70
2011A CO Refund[Interior St] G 338-10100 $116,941.10 $17,890.64 $0.00 $164,302.24
2009B GO CIP Bonds G 343-10100 $5,746.75 $10,012.01 $0.00 $36,792.64
2010B Street Impr [16th Ave] G 345-10100 $195,202.21 $3,828.85 $0.00 $201,550.14
2011A Pumper Truck Certificat G 346-10100 $3,525.84 $3,204.61 $0.00 $15,397.42
2011A GO CIP Bonds[roof/gar] G 347-10100 $59.72 $4,002.13 $0.00 $12,413.30
2013 Street Improve Bonds G 348-10100 $130,929.47 $3,318.98 $0.00 $138,325.69
2013 Equipment Certificates G 349-10100 $7,430.98 $8,787.47 $0.00 $35,785.09
2014 Street Impr [ParkTerrace G 350-10100 $182,088.00 $17,097.39 $0.00 $213,131.60
2015 Street[Clinton/Northland] G 351-10100 $31,684.84 $29,133.18 $0.00 $106,437.76
2015 Equipment Certificates G 352-10100 $1,243.62 $17,869.94 $0.00 $60,314.85
2015 Abatement Bonds[Kenne G 353-10100 $12,168.01 $119.50 $0.00 -$9,843.96
Debt Service Relief G 390-10100 $220,080.03 $1,468.62 $58.06 $224,809.27
2016 Government Center G 401-10100 $663,617.86 $0.00 $3,057.98 -$325,266.45
Community Center phase I G 402-10100 $0.00 $1.97 $0.00 $1,036.97
2016 Imp Field St G 404-10100 $1,292,725.42 $0.00 $29,066.64 $727,473.82
2017 CBD Alley Improve ph 1 G 405-10100 $0.00 $0.00 $2,940.20 -$35,878.65
2014 Imp Park Terrace G 450-10100 $174,269.28 $0.00 $0.00 $174,269.28
2015 Street[Clinton/Northland]G 451-10100 $208,291.12 $0.00 $244.10 $109,151.38
2015 Equipment Certificates G 452-10100 $9,075.06 $0.00 $0.00 $0.00
Capital Outlay G 490-10100 $263,036.29 $10,412.20 $404.75 $305,067.08
WAC Fund G 501-10100 $51,304.65 $20,211.70 $0.00 $150,373.22
SAC Fund G 502-10100 $11,182.25 $9,200.00 $24.85 $25,181.98
Water Fund G 601-10100 $60,868.49 $88,656.71 $27,809.74 $305,736.43
Sewer Fund G 602-10100 $5,777.56 $118,714.35 $14,471.29 $147,526.97
Refuse Collection G 603-10100 $247,661.61 $21,123.14 $26,497.86 $249,951.41
Storm Water Utility G 651-10100 $241,498.11 $9,100.28 $4,646.50 $267,378.41
Street Light Utility G 652-10100 $22,772.31 $6,184.31 $4,337.27 $21,775.18
FUND Descr Account Begin Yr
MTD
Debit
MTD
Credit
Current
Balance
Cash Balances Only
City of St. Joseph
Current Period: July 2017
$8,793,692.94 $1,370,598.74 $676,286.61 $8,113,580.61Last Dim 10100
Last Dim 10200
General G 101-10200 $275.00 $0.00 $0.00 $275.00
$275.00 $0.00 $0.00 $275.00Last Dim 10200
$8,793,967.94 $1,370,598.74 $676,286.61 $8,113,855.61
Current Period: July 2017
FUND FUND Descr
2017
YTD Budget
July
2017 Amt
2017
YTD Amt
101 General $2,680,270.00 $740,458.73 $1,488,960.56
102 Employee Retirement Reserve $0.00 $0.00 $16,080.00
105 Fire Fund $323,020.00 $47,220.47 $187,756.62
108 Cable Access Fee $6,700.00 $647.18 $3,618.44
150 Economic Development $95,320.00 $12,921.68 $42,660.46
152 TIF 3-1 CMCU $0.00 $6,372.10 $21,308.42
153 TIF 4-1 Fortitude Senior Apts $0.00 $0.00 $0.00
157 TIF 2-1 Millstream $275.00 $5,512.15 $18,267.68
158 TIF 2-2 Meat Market $5.00 $1,252.01 $4,185.55
159 TIF 2-3 Bayou Blues/Alley Flat $0.00 $13.27 $44.36
200 State Collected Sales Tax $408,000.00 $41,889.01 $141,545.58
205 Park Dedication $583,520.00 $3,040.19 $14,819.84
215 Charitable Gambling $4,540.00 $5.71 $10.47
220 Lodging Tax $0.00 $26.89 $2,240.18
225 DEED CDAP Grant $0.00 $30.54 $11,121.44
250 Revolving Loan Fund $10,500.00 $736.94 $3,384.51
301 2016 CIP Bonds [govt center] $230,955.00 $35,202.52 $119,150.07
303 2017A CIP Bonds [Gov Center] $0.00 $0.00 $0.00
304 2016 Street Impr [Field St] $63,585.00 $2,841.44 $6,673.67
305 2017B Impr Bonds [CBD Alleys] $0.00 $19,150.00 $25,338.69
318 2009A CrossoverRefunding Bonds $199,480.00 $28,283.29 $93,416.62
331 2011A Refunding Fire Hall $56,700.00 $4,874.20 $21,184.70
333 2010B Refundin [Hill/Clover]$65,560.00 $9,164.92 $39,308.71
338 2011A CO Refund[Interior St] $124,670.00 $17,890.64 $51,923.51
343 2009B GO CIP Bonds $65,000.00 $10,012.01 $33,298.41
345 2010B Street Impr [16th Ave] $42,285.00 $3,828.85 $12,012.27
346 2011A Pumper Truck Certificate $45,365.00 $3,204.61 $13,972.90
347 2011A GO CIP Bonds[roof/gar] $26,000.00 $4,002.13 $13,218.24
348 2013 Street Improve Bonds $21,460.00 $3,318.98 $11,369.76
349 2013 Equipment Certificates $57,075.00 $8,787.47 $29,211.04
350 2014 Street Impr [ParkTerrace] $108,230.00 $17,097.39 $55,600.34
351 2015 Street[Clinton/Northland] $61,305.00 $29,133.18 $79,350.47
352 2015 Equipment Certificates $32,005.00 $17,869.94 $59,380.13
353 2015 Abatement Bonds[Kennedy] $162,300.00 $119.50 $108.44
390 Debt Service Relief $0.00 $1,410.56 $4,702.16
401 2016 Government Center $0.00 $0.00 $14,016.84
402 Community Center phase I $0.00 $1.97 $1,211.97
404 2016 Imp Field St $0.00 $0.00 $0.00
405 2017 CBD Alley Improve ph 1 $0.00 $0.00 $0.00
450 2014 Imp Park Terrace $0.00 $0.00 $0.00
451 2015 Street[Clinton/Northland] $0.00 $0.00 $0.00
FUND FUND Descr
2017
YTD Budget
July
2017 Amt
2017
YTD Amt
Council Month End Revenue Summary
City of St. Joseph
Current Period: July 2017
452 2015 Equipment Certificates $0.00 $0.00 $0.00
490 Capital Outlay $87,080.00 $10,412.20 $48,107.33
501 WAC Fund $291,490.00 $20,211.70 $109,274.24
502 SAC Fund $96,590.00 $9,175.15 $50,138.77
601 Water Fund $1,408,355.00 $82,789.25 $377,761.00
602 Sewer Fund $1,398,215.00 $118,674.06 $573,217.69
603 Refuse Collection $294,170.00 $18,605.90 $124,019.26
651 Storm Water Utility $110,125.00 $9,099.55 $37,892.72
652 Street Light Utility $64,240.00 $6,183.95 $25,807.66
$9,224,390.00 $1,351,472.23 $3,986,671.72
Current Period: July 2017
FUND FUND Descr SOURCE Descr
2017
YTD Budget
July
2017 Amt
2017
YTD Amt
FUND 101 General
101 General Current Ad Valorem Taxes $1,060,000.00 $151,633.92 $508,557.83
101 General Special Levy- City St. Joe $0.00 $2.52 $8.39
101 General State Sales Tax $0.00 -$82.62 $12.54
101 General Gas Franchise $30,500.00 $0.00 $8,200.56
101 General Electric Franchise $55,800.00 $1,916.62 $20,021.96
101 General Licenses & Permits $0.00 $0.00 $4,500.00
101 General Beer $1,625.00 $5.00 $1,668.33
101 General Liquor $21,860.00 $250.00 $24,372.28
101 General Outdoor Liquor Permit $2,500.00 $0.00 $1,350.00
101 General Gambling Permits $250.00 $0.00 $390.00
101 General Amusement/Hunt/Peddler/Golf $1,300.00 $0.00 $705.00
101 General Excavation Permit $500.00 $50.00 $200.00
101 General Cigarette License $600.00 $0.00 $62.50
101 General Cable Franchise Fee $33,300.00 $5,673.31 $16,524.73
101 General Building Permits $99,000.00 $16,779.11 $206,889.17
101 General Animal License $3,400.00 $195.00 $2,635.00
101 General Rental Housing Registration $26,000.00 $6,370.00 $18,743.28
101 General Federal Grants - Other $60,800.00 $0.00 $2,315.97
101 General State Grants and Aids $950.00 $0.00 $0.00
101 General Local Government Aid $919,430.00 $459,707.50 $459,707.50
101 General PERA Rate Increase Aid $1,540.00 $770.50 $770.50
101 General Police Training Reim $3,500.00 $0.00 $0.00
101 General State Municipal Funds Aid $50,000.00 $24,980.50 $49,961.00
101 General State Police Aid $60,000.00 $0.00 $0.00
101 General Other Grants/Aids $0.00 $0.00 $0.00
101 General Other Governmental Unit $10,000.00 $5,000.00 $10,000.00
101 General County Grants - Road Maint. $4,500.00 $0.00 $0.00
101 General Zoning and Subdivision Fee $5,000.00 $0.00 $800.00
101 General Land Use Deposit Fee $4,000.00 $50,000.00 $51,000.00
101 General Sale of Maps and Publications $50.00 $0.00 $3.50
101 General Assessments Search $2,750.00 $330.00 $3,100.00
101 General Special Hearing $5,000.00 $250.00 $5,050.00
101 General Administration Reimb $12,635.00 $0.00 $30.32
101 General Weed Cutting $500.00 $55.00 $200.00
101 General Admission Fee $0.00 $0.00 $0.00
101 General Shelter/Room Rental Fees $8,200.00 $170.00 $4,519.30
101 General Ball Field Donation $250.00 $0.00 $23.09
101 General Schneider Field Rental $1,500.00 $1,420.00 $1,495.00
101 General Rents and Royalties $53,450.00 $4,324.42 $30,270.94
101 General Kennel Fees $700.00 $0.00 $40.00
FUND FUND Descr SOURCE Descr
2017
YTD Budget
July
2017 Amt
2017
YTD Amt
Council Month End Revenue -General Fund
City of St. Joseph
Current Period: July 2017
101 General County Fines $28,000.00 $2,516.89 $21,421.77
101 General Policy Fines $14,000.00 $1,235.00 $9,765.00
101 General Accident Report Fee $1,200.00 $74.00 $685.00
101 General Seized Property $1,000.00 $0.00 $157.25
101 General Special Assessments $3,000.00 $137.14 $2,036.60
101 General Interest Earnings $28,000.00 $3,293.22 $6,819.77
101 General Interest Charges $100.00 $0.00 $211.63
101 General Co-op Dividend - LMCIT $12,000.00 $0.00 $0.00
101 General Water Tower Antenna Lease $3,830.00 $156.70 $2,067.64
101 General Advertising $1,700.00 $400.00 $600.00
101 General Contributions - General $600.00 $0.00 $1,120.00
101 General Contributions - Parks $1,200.00 $60.12 $157.54
101 General Surplus Property $12,000.00 $0.00 $0.00
101 General Reimbursement $32,250.00 $2,784.88 $9,789.67
101 General Transfers from Other Funds $0.00 $0.00 $0.00
$2,680,270.00 $740,458.73 $1,488,960.56FUND 101 General
FUND 102 Employee Retirement Reserve
102 Employee Retirement Res Transfers from Other Funds $0.00 $0.00 $16,080.00
$0.00 $0.00 $16,080.00FUND 102 Employee Retirement Reserve
FUND 108 Cable Access Fee
108 Cable Access Fee Cable Franchise Fee $6,700.00 $647.18 $3,618.44
108 Cable Access Fee Transfers from Other Funds $0.00 $0.00 $0.00
$6,700.00 $647.18 $3,618.44FUND 108 Cable Access Fee
FUND 150 Economic Development
150 Economic Development Current Ad Valorem Taxes $93,920.00 $12,613.78 $42,045.94
150 Economic Development Federal Grants - Other $0.00 $0.00 $0.00
150 Economic Development TIF/MIF Deposit $0.00 $0.00 $0.00
150 Economic Development Interest Earnings $1,400.00 $307.90 $614.52
150 Economic Development Transfers from Other Funds $0.00 $0.00 $0.00
$95,320.00 $12,921.68 $42,660.46FUND 150 Economic Development
FUND 490 Capital Outlay
490 Capital Outlay Current Ad Valorem Taxes $77,080.00 $10,412.20 $34,707.33
490 Capital Outlay Federal Grants - Other $0.00 $0.00 $0.00
490 Capital Outlay Surplus Property $10,000.00 $0.00 $13,400.00
$87,080.00 $10,412.20 $48,107.33FUND 490 Capital Outlay
$2,869,370.00 $764,439.79 $1,599,426.79
Current Period: July 2017
FUND
FUND
Descr SOURCE Descr
2017
YTD Budget
July
2017 Amt
2017
YTD Amt
FUND 601 Water Fund
601 Water Fund Penalties and Forfeited Disc $8,000.00 $440.64 $4,640.55
601 Water Fund Bond Premium Proceeds $0.00 $0.00 $0.00
601 Water Fund Transfers from Other Funds $290,990.00 $0.00 $0.00
601 Water Fund Contributed Revenue $0.00 $0.00 $0.00
601 Water Fund MDS Test Fee $12,085.00 $792.36 $4,477.13
601 Water Fund Current Ad Valorem Taxes $23,500.00 $3,638.42 $11,735.49
601 Water Fund Water Meter $5,000.00 $2,235.00 $8,675.00
601 Water Fund Connection/Reconnection fees $200.00 $0.00 $0.00
601 Water Fund Undesignated Funds $0.00 -$3,617.14 $7,945.82
601 Water Fund Bulk Water $2,500.00 $398.00 $1,184.25
601 Water Fund State Sales Tax $0.00 $555.81 $501.99
601 Water Fund Reimbursement $0.00 $0.00 $0.00
601 Water Fund Surplus Property $0.00 $0.00 $0.00
601 Water Fund General Oblig. Bond Proceeds $0.00 $0.00 $0.00
601 Water Fund Water Tower Antenna Lease $34,480.00 $1,410.33 $18,608.75
601 Water Fund Amortization of Bond Premium $0.00 $0.00 $0.00
601 Water Fund Interest Earnings $31,500.00 $758.21 $1,320.21
601 Water Fund Special Assessments $400.00 $0.00 -$604.53
601 Water Fund Rate Class One $705,100.00 $54,078.20 $205,984.71
601 Water Fund Water Line Charge $294,600.00 $22,099.42 $113,291.63
$1,408,355.00 $82,789.25 $377,761.00FUND 601 Water Fund
FUND 602 Sewer Fund
602 Sewer Fund Reimbursement $0.00 $1,154.40 $15,018.49
602 Sewer Fund Surplus Property $0.00 $0.00 $0.00
602 Sewer Fund Contributions - General $0.00 $129.96 $299.56
602 Sewer Fund Amortization of Bond Premium $0.00 $0.00 $0.00
602 Sewer Fund Interest Earnings $500.00 $4,433.22 $9,030.95
602 Sewer Fund Special Assessments $300.00 $0.00 $0.00
602 Sewer Fund Other Grants/Aids $0.00 $0.00 $0.00
602 Sewer Fund Penalties and Forfeited Disc $7,075.00 $479.62 $4,493.19
602 Sewer Fund Other Governmental Unit $1,500.00 $0.00 $0.00
602 Sewer Fund Sewer Line Charge $493,105.00 $41,354.15 $205,906.92
602 Sewer Fund Transfers from Other Funds $96,090.00 $0.00 $0.00
602 Sewer Fund Contributed Revenue $0.00 $0.00 $0.00
602 Sewer Fund Sanitary Sewer Service $799,645.00 $71,122.71 $338,468.58
$1,398,215.00 $118,674.06 $573,217.69FUND 602 Sewer Fund
FUND 603 Refuse Collection
603 Refuse Collec Special Assessments $400.00 $0.00 $0.00
603 Refuse Collec Contributed Revenue $0.00 $0.00 $0.00
603 Refuse Collec Reimbursement $2,515.00 $314.55 $1,782.45
603 Refuse Collec Interest Earnings $4,000.00 $699.54 $1,367.75
603 Refuse Collec Penalties and Forfeifted Disc $5,700.00 $303.49 $3,013.79
603 Refuse Collec Refuse Collection Charges $263,205.00 $17,454.72 $103,158.78
603 Refuse Collec Licenses & Permits $18,350.00 $650.00 $17,765.00
603 Refuse Collec State Sales Tax $0.00 -$816.40 -$3,068.51
603 Refuse Collec Contributions - General $0.00 $0.00 $0.00
$294,170.00 $18,605.90 $124,019.26FUND 603 Refuse Collection
FUND 651 Storm Water Utility
FUND
FUND
Descr SOURCE Descr
2017
YTD Budget
July
2017 Amt
2017
YTD Amt
Council Month End Revenue -Enterprise Funds
City of St. Joseph
Current Period: July 2017
651 Storm Water Special Assessments $360.00 $564.21 -$3,731.45
651 Storm Water Rate Class One $98,675.00 $7,752.61 $39,377.61
651 Storm Water Transfers from Other Funds $0.00 $0.00 $0.00
651 Storm Water Penalties and Forfeifted Disc $2,090.00 $77.76 $881.96
651 Storm Water Development Fee $5,000.00 $0.00 $0.00
651 Storm Water Contributed Revenue $0.00 $0.00 $0.00
651 Storm Water Interest Earnings $4,000.00 $704.97 $1,364.60
651 Storm Water Reimbursement $0.00 $0.00 $0.00
$110,125.00 $9,099.55 $37,892.72FUND 651 Storm Water Utility
FUND 652 Street Light Utility
652 Street Light U Special Assessments $50.00 $0.00 $0.00
652 Street Light U Interest Earnings $400.00 $55.40 $112.23
652 Street Light U Reimbursement $3,000.00 $0.00 $0.00
652 Street Light U Rate Class One $60,190.00 $6,082.73 $25,067.50
652 Street Light U Penalties and Forfeited Disc $600.00 $45.82 $627.93
652 Street Light U Transfers from Other Funds $0.00 $0.00 $0.00
$64,240.00 $6,183.95 $25,807.66FUND 652 Street Light Utility
$3,275,105.00 $235,352.71 $1,138,698.33
Current Period: July 2017
Description
2017
YTD Budget
July
2017 Amt
2017
YTD Amt
General $2,792,755.00 $233,485.02 $1,474,494.42
Employee Retirement Reserve $0.00 $0.00 $0.00
Fire Fund $367,020.00 $61,149.64 $117,336.73
Cable Access Fee $2,010.00 $0.00 $0.00
Economic Development $95,320.00 $5,800.99 $30,561.60
TIF 3-1 CMCU $795.00 $20,545.33 $20,795.33
TIF 4-1 Fortitude Senior Apts $0.00 $0.00 $0.00
TIF 2-1 Millstream $34,545.00 $17,709.13 $17,755.13
TIF 2-2 Meat Market $4,545.00 $3,972.62 $4,096.20
TIF 2-3 Bayou Blues/Alley Flat $795.00 $1,419.91 $1,465.91
State Collected Sales Tax $1,187,050.00 $208,349.34 $340,674.91
Park Dedication $653,350.00 $529.00 $12,120.95
Charitable Gambling $4,500.00 $0.00 $0.00
Lodging Tax $0.00 $0.00 $0.00
DEED CDAP Grant $0.00 $0.00 $0.00
Revolving Loan Fund $0.00 $0.00 $0.00
2016 CIP Bonds [govt center] $271,945.00 $0.00 $48,371.25
2017A CIP Bonds [Gov Center] $0.00 $0.00 $0.00
2016 Street Impr [Field St] $28,855.00 $0.00 $8,617.78
2017B Impr Bonds [CBD Alleys] $0.00 $0.00 $0.00
2009A CrossoverRefunding Bon $360,350.00 $0.00 $5,075.00
2011A Refunding Fire Hall $76,700.00 $0.00 $750.00
2010B Refundin [Hill/Clover] $142,050.00 $0.00 $5,923.75
2011A CO Refund[Interior St] $144,830.00 $0.00 $7,115.00
2009B GO CIP Bonds $64,800.00 $0.00 $2,595.00
2010B Street Impr [16th Ave] $63,855.00 $0.00 $6,827.50
2011A Pumper Truck Certificate $44,560.00 $0.00 $2,180.00
2011A GO CIP Bonds[roof/gar] $22,320.00 $0.00 $1,060.00
2013 Street Improve Bonds $43,670.00 $0.00 $4,235.00
2013 Equipment Certificates $57,500.00 $0.00 $1,150.00
2014 Street Impr [ParkTerrace] $161,835.00 $0.00 $25,817.50
2015 Street[Clinton/Northland] $66,810.00 $0.00 $5,805.00
2015 Equipment Certificates $32,310.00 $0.00 $1,055.00
2015 Abatement Bonds[Kenned $154,835.00 $0.00 $22,167.49
Debt Service Relief $141,000.00 $0.00 $0.00
2016 Government Center $0.00 $3,057.98 $807,520.93
Community Center phase I $0.00 $0.00 $175.00
2016 Imp Field St $0.00 $29,066.64 $506,015.07
2017 CBD Alley Improve ph 1 $0.00 $2,940.20 $35,878.65
2014 Imp Park Terrace $0.00 $0.00 $0.00
2015 Street[Clinton/Northland] $0.00 $244.10 $20,795.80
Description
2017
YTD Budget
July
2017 Amt
2017
YTD Amt
Council Month End Expenditure - Summary
City of St. Joseph
Current Period: July 2017
2015 Equipment Certificates $0.00 $0.00 $9,075.06
Capital Outlay $87,080.00 $404.75 $7,398.75
WAC Fund $290,990.00 $0.00 $0.00
SAC Fund $96,090.00 $0.00 $0.00
Water Fund $1,808,355.00 $21,942.28 $255,482.01
Sewer Fund $1,848,215.00 $14,431.00 $488,527.11
Refuse Collection $298,675.00 $23,980.62 $153,304.88
Storm Water Utility $260,740.00 $4,645.77 $32,951.95
Street Light Utility $71,970.00 $4,336.91 $33,237.63
$11,783,025.00 $658,011.23 $4,518,409.29
Current Period: July 2017
Description DEPART Descr
2017
YTD Budget
July
2017 Amt
2017
YTD Amt
FUND 101 General
General Council $64,010.00 $7,095.12 $35,693.31
General Legislative Committees $7,485.00 $210.00 $1,295.00
General Ordinance & Proceedings $2,400.00 $369.50 -$6,824.00
General Mayor $11,930.00 $706.83 $4,401.33
General Elections $750.00 $0.00 $1,291.19
General General Adminstration $249,295.00 $21,151.60 $138,354.27
General Finance $130,230.00 $9,196.05 $63,094.87
General Audit Service $28,000.00 $0.00 $27,450.00
General Assessing $23,500.00 $0.00 $0.00
General City Attorney $18,000.00 $29.17 $2,795.42
General Planning and Zoning $71,925.00 $16,135.00 $89,905.15
General General Government $21,850.00 $1,920.24 $21,827.05
General City Offices $22,600.00 $2,293.04 $28,719.34
General Cable Access $10,950.00 $645.90 $3,918.76
General Crime Control & Investigation $1,063,225.00 $76,161.44 $524,170.41
General Police Training $9,545.00 $161.00 $2,770.44
General Communication Service $12,390.00 $1,101.82 $6,661.95
General Automotive Services $54,050.00 $2,389.13 $18,084.31
General Building Inspec. Admistration $94,000.00 $9,621.75 $47,121.75
General Emergency Management $995.00 $7.73 $827.26
General Animal Control $815.00 $0.00 $275.50
General Street Maintanence $309,240.00 $17,619.06 $118,543.38
General Ice & Snow Removal $113,465.00 $0.00 $29,612.62
General Engineering Fee $35,000.00 $4,450.40 $21,920.69
General Street Cleaning $13,800.00 $539.99 $8,019.69
General Skate Park and Ice Rink $5,590.00 $45.53 $2,386.84
General Ball Park $1,750.00 $115.20 $413.80
General Maintenance Shop $21,315.00 $1,408.98 $12,172.72
General Park Areas $224,015.00 $23,829.93 $132,467.12
General Community Center $68,115.00 $5,315.51 $31,228.95
General Other Financing Uses $0.00 $0.00 $13,000.00
General Fire Protection $102,520.00 $30,965.10 $92,895.30
$2,792,755.00 $233,485.02 $1,474,494.42FUND 101 General
FUND 102 Employee Retirement Reserve
Employee Retirement Reserv General Adminstration $0.00 $0.00 $0.00
$0.00 $0.00 $0.00FUND 102 Employee Retirement Reserve
FUND 108 Cable Access Fee
Cable Access Fee Cable Access $2,010.00 $0.00 $0.00
$2,010.00 $0.00 $0.00FUND 108 Cable Access Fee
Description DEPART Descr
2017
YTD Budget
July
2017 Amt
2017
YTD Amt
Council Month End Expenditure - General Fund
City of St. Joseph
Current Period: July 2017
FUND 150 Economic Development
Economic Development Economic Development Authority $95,320.00 $5,800.99 $30,561.60
Economic Development Other Financing Uses $0.00 $0.00 $0.00
$95,320.00 $5,800.99 $30,561.60FUND 150 Economic Development
FUND 490 Capital Outlay
Capital Outlay General Adminstration $9,350.00 $0.00 $199.00
Capital Outlay Crime Control & Investigation $3,450.00 $0.00 $0.00
Capital Outlay Communication Service $7,350.00 $0.00 $0.00
Capital Outlay Automotive Services $16,930.00 $404.75 $7,199.75
Capital Outlay Emergency Management $2,000.00 $0.00 $0.00
Capital Outlay Street Maintanence $3,000.00 $0.00 $0.00
Capital Outlay Ice & Snow Removal $7,800.00 $0.00 $0.00
Capital Outlay Street Cleaning $6,000.00 $0.00 $0.00
Capital Outlay Maintenance Shop $7,000.00 $0.00 $0.00
Capital Outlay Park Areas $24,200.00 $0.00 $0.00
Capital Outlay Community Center $0.00 $0.00 $0.00
Capital Outlay Other Financing Uses $0.00 $0.00 $0.00
$87,080.00 $404.75 $7,398.75FUND 490 Capital Outlay
$2,977,165.00 $239,690.76 $1,512,454.77
Current Period: July 2017
Description DEPART Descr
2017
YTD Budget
July
2017 Amt
2017
YTD Amt
FUND 601 Water Fund
Water Fund Bond Payment (P & I) $618,775.00 $0.00 $51,509.25
Water Fund Other Financing Uses $36,770.00 $0.00 $770.00
Water Fund Power and Pumping $18,690.00 $504.45 $2,806.03
Water Fund Purification-Plant 1 $348,985.00 $1,266.08 $13,730.02
Water Fund Purification-Plant 2 $86,210.00 $3,925.04 $36,046.23
Water Fund Distribution $10,000.00 $0.00 $17,115.06
Water Fund Wellhead Protection $3,000.00 $0.00 $0.00
Water Fund Storage-Tower 1 $15,630.00 $231.00 $3,717.27
Water Fund Water Maintenance $238,235.00 $13,047.99 $110,632.34
Water Fund Administration and General $32,060.00 $2,967.72 $19,155.81
Water Fund Depreciation Expense $400,000.00 $0.00 $0.00
$1,808,355.00 $21,942.28 $255,482.01FUND 601 Water Fund
FUND 602 Sewer Fund
Sewer Fund Bond Payment (P & I) $234,320.00 $0.00 $22,058.75
Sewer Fund Other Financing Uses $37,540.00 $0.00 $1,540.00
Sewer Fund Sanitary Sewer Maintenanc $216,790.00 $9,594.06 $99,402.61
Sewer Fund Lift Station-Baker Street $92,390.00 $261.74 $3,597.08
Sewer Fund Lift Station-Ridgewood/DBL $2,810.00 $144.16 $1,083.15
Sewer Fund Lift Station-Northland $4,425.00 $121.12 $918.86
Sewer Fund Lift Station-CR 121 $4,650.00 $141.18 $1,108.46
Sewer Fund Lift Station-Main $769,100.00 $1,188.79 $339,467.03
Sewer Fund Administration and General $36,190.00 $2,979.95 $19,351.17
Sewer Fund Depreciation Expense $450,000.00 $0.00 $0.00
$1,848,215.00 $14,431.00 $488,527.11FUND 602 Sewer Fund
FUND 603 Refuse Collection
Refuse Collectio Waste Collection $291,230.00 $23,980.62 $152,534.88
Refuse Collectio Other Financing Uses $770.00 $0.00 $770.00
Refuse Collectio Depreciation Expense $6,675.00 $0.00 $0.00
$298,675.00 $23,980.62 $153,304.88FUND 603 Refuse Collection
FUND 651 Storm Water Utility
Storm Water Uti Other Financing Uses $19,250.00 $0.00 $0.00
Storm Water Uti Administration and General $16,580.00 $1,240.50 $10,497.60
Storm Water Uti Storm Water Maintenance $109,910.00 $3,405.27 $22,454.35
Storm Water Uti Depreciation Expense $115,000.00 $0.00 $0.00
$260,740.00 $4,645.77 $32,951.95FUND 651 Storm Water Utility
FUND 652 Street Light Utility
Street Light Utili Street Lighting $71,970.00 $4,336.91 $33,237.63
$71,970.00 $4,336.91 $33,237.63FUND 652 Street Light Utility
Description DEPART Descr
2017
YTD Budget
July
2017 Amt
2017
YTD Amt
Council Month End Expense - Enterprise Funds
City of St. Joseph
Current Period: July 2017
$4,287,955.00 $69,336.58 $963,503.58