HomeMy WebLinkAbout[04d] Treasurer Report
4(d)
Council Agenda Item
MEETING DATE:
July 18, 2013
nd
AGENDA ITEM:
Financial Report – Requested Action: Accept the 2 Quarter 2013 and
June 2013 Financial Reports
SUBMITTED BY:
Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION:
N/A
PREVIOUS COUNCIL ACTION:
Council accepted the April and May Financial Reports.
BACKGROUND INFORMATION:
Quarterly and monthly reconciled cash/investment and budget to
actual position are provided for Council review. The numbers presented are the cash balances as of June
30, 2013.
There are a couple points to highlight from the reports.
CASH POSITION
:
- The market rate of return is approximately 1.73%. The 10-year Treasuries spiked 1% from May
st
1 to the end of June. The 10-year Treasuries are currently 2.65%. Investment return rates have
now also increased. The City purchased a couple investments in July at 2.78% (7-year) and 1.9%
(5-year) to capitalize on the better rates of return. The broker consultant stated he felt this
increase will be temporary.
- The funds showing a cash deficit will be positive with the 2013 bond issue and future utility
revenues.
- Overall, the cash and investments balance decreased $365,557 from the beginning of the year.
rd
When the remaining July 3 tax settlement is factored in, the cash balance is close to the same as
st
Jan. 1. The first half bond interest payments were made in the second quarter.
FUNDS REPORT
:
General fund
- The spent 47% of the 2013 budget and received 23% of the revenue budget.
Expenditures are operational in nature. The capital budget was transferred to the General Capital
Reserve account and Park Dedication account for annually budgeted capital outlay. An additional
transfer was made to the Street Light Utility to begin operating the first four months of the year.
Enterprise Funds
- The show expenses more than revenues with exception of the storm water
fund. The reports show 6 months of expenses and approximately 4 months utility revenue
received. The street light utility began billing with the May utility bills. The first two months
were funded by the general fund transfer. The negative cash balances in the street light utility
will balance out once the billings catch up to the monthly expenses.
Water fund analysis (fund 601/501)
– The enclosed spreadsheet shows an analysis of the water fund,
including the Water fund (601) and the Water Access fund (WAC-501). The City received WAC and
th
Trunk fees from the Army Reserve facility and 1 Collegeville cottage as of June 30. The water fund
shows a cash surplus when combined with fund 501 of $47,431.97 after paying the first half bond interest
payments. The first half of the year shows operational activity and a portion of the PW truck purchase
along with the bond interest payments.
½ ¢ Sales Tax (fund 200):
The sales tax fund has a balance of $1,143,258 at the end of June. The City
anticipates collecting $3,000,000 in sales tax revenue through 2017; $1,829,756 collected to date. The
anticipated expenditures approved by Council totals $864,216 leaving approximately $2,135,784
remaining for future projects.
CIP REPORTS:
thnd
- The 2013 CIP summary is included to show the capital expenditures through June 30. The 2
quarter capital expenditures include computer upgrades, police squad, defibulators, PW truck,
Gator and trailer, turnout gear, gazebo and EDA programs.
BUDGET/FISCAL IMPACT:
Information Only
ATTACHMENTS:
Request for Council Action – Quarterly and June Financial Reports
nd
2 Quarter Reports:
Cash Position as of 6/30/13
Cash and Investment Holdings Chart
Cash Balances by Fund/Remaining Budget
General & Fire Budget to Actual Expenditures & Revenues
Enterprise Funds Activity Graph
Quarterly Water Fund Analysis
½ ¢ Sales Tax Fund Summary
June Treasurer’s Reports:
Cash and Investment – Council Report
Council Month End Revenue Summary
Council Month End Revenue – General Fund
Council Month End Revenue – Enterprise Funds
Council Month End Expenditure Summary
Council Month End Expenditure – General Fund
Council Month End Expenses - Enterprise Funds
Capital Summary Reports:
General Fund Capital Improvement Plan – Summary
Fire Fund Capital Improvement Plan
Park Board Capital Improvement Plan – Summary
Capital Improvement Plan – Enterprise
REQUESTED COUNCIL ACTION:
Accept the financial reports as presented.
City of St. Joseph, Minnesota
Cash Position
As of 6/30/13
Sentry BankMaturity DateInterestCurrent Balance# Securities% of Total
Checking Account (Reconciled)N/A0.15%358,843$ N/A
Money Market SavingsN/A0.47%709,594 N/A
Bank Certificates of DepositTiered 7-16 months1.45% 31,150,764
avg
averages10 months0.99%
Total Sentry Bank$2,219,20230%
Central MN Credit Union
Share Savings AccountN/A0.25%30$ N/A
Money Market SavingsN/A0.75%248,214 N/A
Power Money Market CheckingN/A0.70%1,076,191 N/A
Jumbo Bank Certificates of Deposit31 months2.25% 31,057,931
avg
averages31 months1.64%
Total CMCU$2,382,36533%
Total Deposits4,601,567$
Morgan Stanley Smith Barne
y
Brokered Money Market SavingsN/A0.01%20,648$ N/A
Government Securities/Notes115 months1.50% 1756,992
avg
Brokered Certificates of DepositTiered 14-80 months2.61% 141,901,474
avg
averages37 months2.54%
Total SB$ 37%2,679,113
Northland Securities
Brokered Money Market SavingsN/A0.00%1,832$ N/A
Brokered Certificates of DepositN/AN/A 0-
avg
averagesN/A0.00%
Total NS$ 0%1,832
Total Investments2,680,946$
Total Deposits and Investments$7,282,512
Average Interest APY16 months2.13%
2013 YTD
Interest Earned
Cash Held With Fiscal Agent - Northland Securities
(2011A/2012A Crossover Refunding Bonds)
Brokered Money Market SavingsN/A0.39% 6,168,990$7,331
avg
Total Cash Held With Fiscal Agent$6,168,990
Total Deposits, Investments & Cash w/Fiscal Agent$ Cash and Investment Balance13,451,503
Petty Cash
AdministrationN/AN/A200$
Police DepartmentN/AN/A75
Total Petty Cash$275
Custodial Credit Risk: All deposits and investments insured by FDIC/SPIC/NCUA or secured by perfected pledged collateral.
: The City is not exposed to interest rate risk because the City does not invest in highly
Interest Rate Risk
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.
% SecuritiesAverages
Brokered Money Markets22,480$ 0%N/A
Brokered Certificates of Deposit1,901,474$ 26.11%2.7 years
Government Bonds/Notes756,992$ 10.39%9.5 years
State/Local Government Securities6,168,990$ 46%1.5 years
Foreign Currency Risk: The City only invests in USA and USA territories.
07/08/13 10:16 AM
CITY OF ST. JOSEPH
Page 1
Cash Balances Only
Current Period: June 2013
MTDMTDCurrent
FUND DescrAccountBegin YrDebitCreditBalance
Last Dim 10100
GeneralG 101-10100$1,144,450.61$636,226.17$354,147.44$677,178.35
Fire FundG 105-10100$504,034.02$2,067.55$44,776.81$519,761.91
Cable Access FeeG 108-10100$8,577.58$719.36$0.00$11,952.68
Economic DevelopmentG 150-10100$79,525.68$65,561.83$23,166.26$106,517.61
TIF 1-4 St. Joe DevelopmentG 156-10100$0.00$0.00$0.00$0.00
TIF 2-1 MillstreamG 157-10100$10,832.25$19,011.79$5,847.86$23,967.71
TIF 2-2 Meat MarketG 158-10100$30.02$1,864.26$634.22$1,152.88
State Collected Sales TaxG 200-10100$1,215,122.64$0.00$123,883.17$1,143,258.25
Park DedicationG 205-10100$70,749.08$76.82$843.37$76,647.50
Recreation CenterG 210-10100$27,308.67$22.74$181.92$27,215.06
Charitable GamblingG 215-10100$5,232.23$4.02$32.18$4,813.74
Revolving Loan FundG 250-10100$22,746.98$1,038.39$170.35$27,058.50
2009A CrossoverRefunding BoG 318-10100$434,664.74$134,299.91$43,036.12$504,454.26
2007 Refunding (98/99 St BonG 320-10100$197,678.52$25,491.32$8,903.76$209,451.42
City Hall Refunded, 2005G 322-10100$849.45$49,041.23$14,711.49$29,807.89
2011A Refunding Fire HallG 331-10100$119,430.28$13,489.84$4,867.78$139,363.65
2010B Refundin (Hill/Clover)G 333-10100$376,176.86$25,286.89$9,984.05$382,903.43
2011A CO Refund (Interior StsG 338-10100$244,075.81$49,148.05$16,245.62$245,598.69
2007 St Imprv-E Side/Jade/8 AG 341-10100$140,707.28$10,128.49$6,280.48$139,020.25
2008 Equipment CertificatesG 342-10100$12,215.54$26,185.77$7,932.81$29,602.42
2009B GO CIP BondsG 343-10100$4,271.68$34,848.87$10,471.15$23,255.96
2010 Equipment CertificatesG 344-10100$2,396.76$17,740.66$5,334.82$13,554.11
2010B Street Impr (16th Ave)G 345-10100$245,516.01$14,044.74$5,701.09$235,063.25
2011A Pumper Truck CertificatG 346-10100$1,102.54$10,480.69$3,188.26$16,090.12
2011A GO CIP BondsG 347-10100$14,173.45$11,638.27$4,696.22$21,506.97
2013 Street Improve BondsG 348-10100$0.00$0.00$0.00$0.00
2013 Equipment CertificatesG 349-10100$0.00$0.00$0.00$0.00
Debt Service ReliefG 390-10100$508,858.85$1,338.98$1,134.45$524,084.83
2007 Street Impr (Jade Rd/EG 441-10100$366,958.57$0.00$0.00$366,958.57
2011A GO CIP BondsG 447-10100$174,042.45$0.00$0.00$174,042.45
2013 Imp Cedar/Baker/RidgewG 448-10100$0.00$0.00$9,447.60-$18,685.10
2013 Equipment CertificatesG 449-10100$0.00$0.00$32,862.32-$54,098.27
Capital OutlayG 490-10100$219,824.55$2,146.56$2,813.81$219,958.68
Water ExtensionG 501-10100$27.37$35.53$284.34$86,554.59
Sewer ExtensionG 502-10100$565,381.43$491.63$3,933.82$616,618.22
Water FundG 601-10100$952.39$71,931.48$44,205.21-$39,122.62
Sewer FundG 602-10100$275,956.66$76,760.86$63,324.01$139,023.73
Refuse CollectionG 603-10100$267,112.09$41,761.24$39,220.58$250,698.51
Storm Water UtilityG 651-10100$189,817.22$10,057.23$5,150.89$214,517.51
Street Light UtilityG 652-10100$0.00$5,897.26$3,664.51-$4,504.26
Last Dim 10100$7,450,800.26$1,358,838.43$901,078.77$7,085,243.45
Last Dim 10200
GeneralG 101-10200$275.00$0.00$0.00$275.00
Last Dim 10200$275.00$0.00$0.00$275.00
Last Dim 10300
2011A CO Refund (Interior StsG 338-10300$1,452,878.26$46.07$0.00$1,442,109.33
Water FundG 601-10300$4,770,732.87$10,151.74$0.00$4,726,880.86
Last Dim 10300$6,223,611.13$10,197.81$0.00$6,168,990.19
07/08/13 10:18 AM
CITY OF ST. JOSEPH
Page 1
Council Month End Revenue Summary
Current Period: June 2013
2013June2013
FUNDFUND DescrYTD Budget2013 AmtYTD Amt
101General$2,274,225.00$438,703.91$575,629.63
105Fire Fund$258,675.00-$2,327.16$95,003.33
108Cable Access Fee$7,450.00$719.36$3,610.21
150Economic Development$126,595.00$45,460.77$45,645.05
157TIF 2-1 Millstream$0.00$13,238.88$13,262.29
158TIF 2-2 Meat Market$0.00$1,304.98$1,304.98
200State Collected Sales Tax$0.00$0.00$0.00
205Park Dedication$0.00-$420.56$11,013.18
210Recreation Center$0.00-$159.18-$128.12
215Charitable Gambling$0.00-$28.16-$17.38
250Revolving Loan Fund$8,380.00$868.04$4,287.27
3182009A CrossoverRefunding Bonds$0.00$91,263.79$92,035.39
3202007 Refunding (98/99 St Bond)$0.00$16,587.56$16,889.31
322City Hall Refunded, 2005$0.00$34,329.74$34,313.36
3312011A Refunding Fire Hall$55,050.00$8,622.06$23,393.90
3332010B Refundin (Hill/Clover)$0.00$15,302.84$15,972.61
3382011A CO Refund (Interior Sts)$0.00$32,948.50$33,365.14
3412007 St Imprv-E Side/Jade/8 Av$0.00$3,848.01$4,659.58
3422008 Equipment Certificates$0.00$18,252.96$18,269.71
3432009B GO CIP Bonds$0.00$24,377.72$24,377.87
3442010 Equipment Certificates$0.00$12,405.84$12,406.27
3452010B Street Impr (16th Ave)$0.00$8,343.65$8,816.48
3462011A Pumper Truck Certificate$42,980.00$7,292.43$18,495.20
3472011A GO CIP Bonds$0.00$6,942.05$9,026.07
3482013 Street Improve Bonds$0.00$0.00$0.00
3492013 Equipment Certificates$0.00$0.00$0.00
390Debt Service Relief$0.00$937.29$18,137.19
4472011A GO CIP Bonds$0.00$0.00$0.00
4482013 Imp Cedar/Baker/Ridgewood$0.00$0.00$0.00
4492013 Equipment Certificates$0.00$0.00$0.00
490Capital Outlay$0.00$0.00$24,603.54
501Water Extension$0.00-$248.81$65,800.42
502Sewer Extension$0.00-$3,442.19$39,718.58
601Water Fund$1,381,790.00$60,769.61$189,779.93
602Sewer Fund$992,305.00$75,573.66$192,275.34
603Refuse Collection$303,710.00$29,600.83$98,110.67
651Storm Water Utility$124,645.00$8,638.46$30,537.95
652Street Light Utility$42,500.00$5,893.80$16,468.96
$5,618,305.00$955,600.68$1,737,063.91
07/05/13 10:05 AM
CITY OF ST. JOSEPH
Page 1
Council Month End Revenue -General Fund
Current Period: June 2013
2013June2013
FUNDFUND DescrSOURCE DescrYTD Budget2013 AmtYTD Amt
FUND 101 General
101GeneralCurrent Ad Valorem Taxes$1,154,645.00$422,211.29$422,211.29
101GeneralSpecial Levy- City St. Joe$0.00$0.15$0.15
101GeneralState Sales Tax$0.00$1.46$23.63
101GeneralGas Franchise$31,500.00$0.00$7,841.00
101GeneralElectric Franchise$51,300.00$1,735.58$16,906.69
101GeneralBeer$375.00$0.00$270.00
101GeneralLiquor$22,635.00$2,700.00$13,260.00
101GeneralOutdoor Liquor Permit$2,500.00$0.00$1,500.00
101GeneralGambling Permits$120.00$0.00$200.00
101GeneralAmusement/Hunting Permit$1,000.00$0.00$0.00
101GeneralExcavation Permit$300.00$0.00$350.00
101GeneralCigarette License$525.00$0.00$37.50
101GeneralCable Franchise Fee$32,000.00$998.40$9,504.45
101GeneralBuilding Permits$40,000.00$1,835.00$10,639.37
101GeneralAnimal License$3,150.00$180.00$2,870.00
101GeneralRental Housing Registration$20,000.00$5,976.00$6,498.60
101GeneralFederal Grants - Other$5,000.00$0.00$558.58
101GeneralState Grants and Aids$965.00$0.00$0.00
101GeneralLocal Government Aid$645,150.00$0.00$0.00
101GeneralPERA Rate Increase Aid$1,540.00$0.00$0.00
101GeneralPolice Training Reim$3,500.00$0.00$0.00
101GeneralState Municipal Funds Aid$6,180.00$0.00$3,772.50
101GeneralState Police Aid$45,000.00$0.00$487.50
101GeneralOther Grants/Aids$250.00$0.00$0.00
101GeneralOther Governmental Unit$10,000.00$0.00$5,000.00
101GeneralCounty Grants - Road Maint.$7,750.00$0.00$0.00
101GeneralZoning and Subdivision Fee$1,000.00$0.00$0.00
101GeneralLand Use Deposit Fee$4,000.00$0.00$15,350.00
101GeneralSale of Maps and Publications$50.00$0.00$9.35
101GeneralAssessments Search$2,500.00$270.00$1,920.00
101GeneralSpecial Hearing$4,500.00$400.00$2,000.00
101GeneralAdministration Reimb$11,600.00$0.00$0.00
101GeneralWeed Cutting$1,000.00$0.00$660.00
101GeneralPark Fees$5,500.00$1,010.00$4,330.00
101GeneralBall Field Donation$500.00$0.00$0.00
101GeneralSchneider Field Rental$2,700.00$765.00$765.00
101GeneralKennel Fees$700.00$75.00$250.00
101GeneralCounty Fines$27,000.00$2,615.97$13,004.50
101GeneralPolicy Fines$35,000.00$640.00$11,500.25
101GeneralAccident Report Fee$1,000.00$30.00$320.75
101GeneralSeized Property$500.00$83.03$896.53
101GeneralSpecial Assessments$1,500.00$888.76$888.76
07/05/13 10:05 AM
CITY OF ST. JOSEPH
Page 2
Council Month End Revenue -General Fund
Current Period: June 2013
2013June2013
FUNDFUND DescrSOURCE DescrYTD Budget2013 AmtYTD Amt
101GeneralInterest Earnings$18,000.00-$4,456.43-$1,382.85
101GeneralInterest Charges$100.00$15.76$68.18
101GeneralCo-op Dividend - LMCIT$10,000.00$0.00$7,597.60
101GeneralWater Tower Antenna Lease$3,550.00$262.59$2,180.63
101GeneralLand Rental$0.00$0.00$0.00
101GeneralAdvertising$2,000.00$0.00$780.00
101GeneralContributions - General$1,500.00$0.00$1.00
101GeneralContribution - Health Ins Div$19,090.00$0.00$0.00
101GeneralContributions - Parks$1,000.00$179.19$303.69
101GeneralSurplus Property$0.00$0.00$2,200.00
101GeneralReimbursement$32,550.00$287.16$10,054.98
101GeneralStreet Access Fee$0.00$0.00$0.00
101GeneralTransfers from Other Funds$2,000.00$0.00$0.00
FUND 101 General$2,274,225.00$438,703.91$575,629.63
FUND 108 Cable Access Fee
108Cable Access FeeCable Franchise Fee$7,450.00$719.36$3,610.21
108Cable Access FeeTransfers from Other Funds$0.00$0.00$0.00
FUND 108 Cable Access Fee$7,450.00$719.36$3,610.21
FUND 150 Economic Development
150Economic DevelopmentCurrent Ad Valorem Taxes$126,095.00$45,853.97$45,853.97
150Economic DevelopmentTIF/MIF Deposit$0.00$0.00$0.00
150Economic DevelopmentInterest Earnings$500.00-$393.20-$208.92
150Economic DevelopmentTransfers from Other Funds$0.00$0.00$0.00
FUND 150 Economic Development$126,595.00$45,460.77$45,645.05
$2,408,270.00$484,884.04$624,884.89
07/08/13 10:18 AM
CITY OF ST. JOSEPH
Page 1
Council Month End Revenue -Enterprise Funds
Current Period: June 2013
FUND2013June2013
FUNDDescrSOURCE DescrYTD Budget2013 AmtYTD Amt
FUND 601 Water Fund
601Water FundWater Meter$5,000.00$100.00$1,675.00
601Water FundTransfers from Other Funds$584,000.00$0.00$0.00
601Water FundContributed Revenue$0.00$0.00$0.00
601Water FundMDS Test Fee$11,570.00$1,068.74$3,391.43
601Water FundState Sales Tax$425.00-$220.37-$369.27
601Water FundInspection Fees$0.00$0.00$0.00
601Water FundPenalties and Forfeited Disc$5,680.00$350.21$3,647.25
601Water FundConnection/Reconnection fees$500.00-$100.00-$40.00
601Water FundUndesignated Funds$0.00$1,769.98$2,299.43
601Water FundInterest Earnings$44,370.00-$289.11$2,727.54
601Water FundWater Line Charge$223,495.00$23,194.74$68,978.84
601Water FundSpecial Assessments$800.00$215.26-$10,642.32
601Water FundBulk Water$1,000.00$60.00$1,043.50
601Water FundAmortization of Bond Premium$0.00$0.00$0.00
601Water FundWater Tower Antenna Lease$31,950.00$2,363.33$19,625.62
601Water FundSurplus Property$0.00$0.00$0.00
601Water FundReimbursement$0.00$0.00$0.00
601Water FundRate Class One$473,000.00$32,256.83$97,442.91
FUND 601 Water Fund$1,381,790.00$60,769.61$189,779.93
FUND 602 Sewer Fund
602Sewer FundPenalties and Forfeited Disc$4,085.00$268.90$2,318.15
602Sewer FundInterest Earnings$19,250.00-$911.92-$548.12
602Sewer FundAmortization of Bond Premium$0.00$0.00$0.00
602Sewer FundSurplus Property$0.00$0.00$0.00
602Sewer FundReimbursement$3,255.00$0.00$0.00
602Sewer FundContributed Revenue$0.00$0.00$0.00
602Sewer FundSanitary Sewer Service$425,075.00$48,137.94$117,112.38
602Sewer FundSpecial Assessments$800.00$106.85-$477.68
602Sewer FundSt. Benedict Sewer Charges$0.00$0.00$0.00
602Sewer FundSewer Line Charge$237,840.00$27,971.89$73,870.61
602Sewer FundSewer Inspection Fee$0.00$0.00$0.00
602Sewer FundTransfers from Other Funds$302,000.00$0.00$0.00
602Sewer FundGeneral Oblig. Bond Proceeds$0.00$0.00$0.00
602Sewer FundBond Premium Proceeds$0.00$0.00$0.00
602Sewer FundSt. Benedict s SCAWAC fees$0.00$0.00$0.00
FUND 602 Sewer Fund$992,305.00$75,573.66$192,275.34
FUND 603 Refuse Collection
603Refuse CollecInterest Earnings$5,000.00-$1,442.05-$929.72
603Refuse CollecContributions - General$1,350.00$0.00$0.00
603Refuse CollecSpecial Assessments$850.00$135.35-$457.63
603Refuse CollecRefuse Collection Charges$272,135.00$26,792.66$83,640.62
603Refuse CollecLicenses & Permits$18,875.00$2,925.00$15,315.00
603Refuse CollecState Sales Tax$0.00$770.16-$2,570.26
603Refuse CollecPenalties and Forfeifted Disc$5,500.00$419.71$3,112.66
FUND 603 Refuse Collection$303,710.00$29,600.83$98,110.67
FUND 651 Storm Water Utility
651Storm Water Contributed Revenue$0.00$0.00$0.00
651Storm Water Transfers from Other Funds$0.00$0.00$0.00
651Storm Water Penalties and Forfeifted Disc$2,000.00$95.05$808.11
651Storm Water Special Assessments$400.00$102.87-$229.43
07/08/13 10:18 AM
CITY OF ST. JOSEPH
Page 2
Council Month End Revenue -Enterprise Funds
Current Period: June 2013
FUND2013June2013
FUNDDescrSOURCE DescrYTD Budget2013 AmtYTD Amt
651Storm Water Development Fee$4,000.00$0.00$0.00
651Storm Water Reimbursement$0.00$0.00$0.00
651Storm Water Interest Earnings$3,450.00-$1,191.40-$812.46
651Storm Water Rate Class One$114,795.00$9,631.94$30,771.73
FUND 651 Storm Water Utility$124,645.00$8,638.46$30,537.95
FUND 652 Street Light Utility
652Street Light UTransfers from Other Funds$0.00$0.00$8,500.00
652Street Light USpecial Assessments$0.00$0.00$0.00
652Street Light UInterest Earnings$0.00$24.28$34.54
652Street Light URate Class One$42,500.00$5,869.52$7,934.42
652Street Light UPenalties and Forfeited Disc$0.00$0.00$0.00
FUND 652 Street Light Utility$42,500.00$5,893.80$16,468.96
$2,844,950.00$180,476.36$527,172.85
07/05/13 10:09 AM
CITY OF ST. JOSEPH
Page 1
Council Month End Expenditure - Summary
Current Period: June 2013
2013June2013
DescriptionYTD Budget2013 Amt YTD Amt
General$2,240,065.00$178,454.35$1,082,994.94
Fire Fund$284,081.00$40,382.10$77,871.89
Cable Access Fee$0.00$0.00$736.25
Economic Development$126,595.00$3,065.20$16,279.01
TIF 1-4 St. Joe Development$0.00$0.00$0.00
TIF 2-1 Millstream$0.00$74.95$139.26
TIF 2-2 Meat Market$0.00$74.94$182.12
State Collected Sales Tax$0.00$123,883.17$121,566.14
Park Dedication$46,400.00$345.99$5,176.33
Recreation Center$0.00$0.00$25.00
Charitable Gambling$0.00$0.00$407.88
Revolving Loan Fund$0.00$0.00$0.00
2009A CrossoverRefunding Bon$0.00$0.00$24,372.09
2007 Refunding (98/99 St Bond$0.00$0.00$5,513.34
City Hall Refunded, 2005$0.00$0.00$5,843.33
2011A Refunding Fire Hall$0.00$0.00$3,790.83
2010B Refundin (Hill/Clover)$0.00$0.00$11,114.59
2011A CO Refund (Interior Sts)$0.00$0.00$43,990.22
2007 St Imprv-E Side/Jade/8 A$0.00$0.00$7,225.22
2008 Equipment Certificates$0.00$0.00$1,240.83
2009B GO CIP Bonds$0.00$0.00$5,740.83
2010 Equipment Certificates$0.00$0.00$1,428.33
2010B Street Impr (16th Ave)$0.00$0.00$9,085.01
2011A Pumper Truck Certificate$0.00$0.00$3,870.83
2011A GO CIP Bonds$0.00$0.00$2,050.83
2013 Street Improve Bonds$0.00$0.00$0.00
2013 Equipment Certificates$0.00$0.00$0.00
Debt Service Relief$100,000.00$732.76$2,911.21
2007 Street Impr (Jade Rd/E$0.00$0.00$0.00
2011A GO CIP Bonds$0.00$0.00$0.00
2013 Imp Cedar/Baker/Ridgew$0.00$9,447.60$18,685.10
2013 Equipment Certificates$0.00$32,862.32$54,098.27
Capital Outlay$105,410.00$667.25$24,469.41
Water Extension$0.00$0.00$0.00
Sewer Extension$0.00$0.00$0.00
Water Fund$971,700.00$22,891.60$278,320.45
Sewer Fund$1,186,600.00$62,136.81$283,848.98
Refuse Collection$328,175.00$27,060.17$141,470.37
Storm Water Utility$214,485.00$3,732.12$16,684.56
Street Light Utility$51,000.00$3,661.05$20,973.22
$5,654,511.00$509,472.38$2,272,106.67
07/05/13 10:10 AM
CITY OF ST. JOSEPH
Page 1
Council Month End Expenditure - General Fund
Current Period: June 2013
2013June2013
DescriptionDEPART DescrYTD Budget2013 Amt YTD Amt
FUND 101 General
GeneralCouncil$47,165.00$3,389.81$20,916.11
GeneralLegislative Committees$6,195.00$525.00$746.79
GeneralOrdinance & Proceedings$1,350.00$0.00$1,993.13
GeneralMayor$10,960.00$1,420.71$4,949.21
GeneralElections$3,000.00$0.00$1,162.50
GeneralGeneral Adminstration$210,045.00$14,418.51$92,487.73
GeneralFinance$115,035.00$6,976.06$47,273.01
GeneralAudit Service$25,450.00$0.00$25,450.00
GeneralAssessing$20,000.00$0.00$0.00
GeneralCity Attorney$17,000.00-$1,012.50$3,209.00
GeneralPlanning and Zoning$1,850.00$67.08$1,547.83
GeneralGeneral Government$24,480.00$1,099.60$9,319.03
GeneralCity Offices$28,880.00$488.27$13,274.09
GeneralFacilites and Planning$0.00$0.00$13.00
GeneralCable Access$11,660.00$1,066.85$4,904.00
GeneralCrime Control & Investigation$860,935.00$99,089.25$417,592.13
GeneralPolice Training$7,000.00$682.11$6,042.57
GeneralCommunication Service$12,080.00$781.29$5,047.33
GeneralAutomotive Services$60,000.00$6,545.56$25,583.14
GeneralBuilding Inspec. Admistration$92,000.00$7,500.00$38,210.24
GeneralEmergency Management$1,300.00$3.80$382.14
GeneralSignal Lights CSAH 75$2,000.00$81.00$778.89
GeneralAnimal Control$1,150.00$0.00$201.65
GeneralOrdinance/Easement Enforcement$0.00$0.00$0.00
GeneralStreet Maintanence$217,195.00$12,790.19$97,991.60
GeneralIce & Snow Removal$91,700.00$29.00$65,740.19
GeneralEngineering Fee$35,000.00$1,367.96$12,709.18
GeneralStreet Lighting$0.00$0.00$0.00
GeneralStreet Cleaning$14,255.00$732.05$6,078.42
GeneralSkate Park and Ice Rink$3,435.00$0.00$1,899.24
GeneralBall Park$1,800.00$73.28$73.28
GeneralMaintenance Shop$19,820.00$920.38$9,930.62
GeneralPark Areas$208,950.00$19,419.09$90,260.27
GeneralCommunity Support$0.00$0.00$0.00
GeneralOther Financing Uses$0.00$0.00$34,160.00
GeneralFire Protection$88,375.00$0.00$43,068.62
FUND 101 General$2,240,065.00$178,454.35$1,082,994.94
FUND 108 Cable Access Fee
Cable Access FeeCable Access$0.00$0.00$736.25
FUND 108 Cable Access Fee$0.00$0.00$736.25
FUND 150 Economic Development
07/05/13 10:10 AM
CITY OF ST. JOSEPH
Page 2
Council Month End Expenditure - General Fund
Current Period: June 2013
2013June2013
DescriptionDEPART DescrYTD Budget2013 Amt YTD Amt
Economic DevelopmentEconomic Development Authority$126,595.00$3,065.20$16,279.01
Economic DevelopmentOther Financing Uses$0.00$0.00$0.00
FUND 150 Economic Development$126,595.00$3,065.20$16,279.01
FUND 490 Capital Outlay
Capital OutlayElections$0.00$0.00$0.00
Capital OutlayGeneral Adminstration$3,250.00$0.00$0.00
Capital OutlayGeneral Government$35,000.00$0.00$0.00
Capital OutlayCity Offices$35,000.00$0.00$0.00
Capital OutlayCable Access$0.00$0.00$0.00
Capital OutlayCrime Control & Investigation$0.00$0.00$0.00
Capital OutlayCommunication Service$1,150.00$0.00$0.00
Capital OutlayAutomotive Services$3,695.00$0.00$13,245.00
Capital OutlayEmergency Management$2,000.00$0.00$0.00
Capital OutlayStreet Maintanence$3,000.00$0.00$5,129.26
Capital OutlayIce & Snow Removal$8,750.00$0.00$0.00
Capital OutlayStreet Lighting$5,000.00$0.00$0.00
Capital OutlayStreet Cleaning$0.00$0.00$0.00
Capital OutlaySkate Park and Ice Rink$0.00$0.00$0.00
Capital OutlayMaintenance Shop$2,190.00$319.55$319.55
Capital OutlayPark Areas$6,375.00$347.70$5,775.60
Capital OutlayOther Financing Uses$0.00$0.00$0.00
FUND 490 Capital Outlay$105,410.00$667.25$24,469.41
$2,472,070.00$182,186.80$1,124,479.61
07/05/13 10:10 AM
CITY OF ST. JOSEPH
Page 1
Council Month End Expense - Enterprise Funds
Current Period: June 2013
2013June2013
DescriptionDEPART DescrYTD Budget2013 Amt YTD Amt
FUND 601 Water Fund
Water FundBond Payment (P & I)$183,575.00$0.00$151,437.62
Water FundOther Financing Uses$48,000.00$0.00$0.00
Water FundPower and Pumping$26,600.00$0.00$3,458.06
Water FundPurification-Plant 1$31,800.00$694.14$9,070.74
Water FundPurification-Plant 2$79,130.00$3,406.27$33,069.90
Water FundDistribution$10,000.00$0.00$8,071.31
Water FundWellhead Protection$2,000.00$189.75$740.78
Water FundStorage-Tower 1$5,000.00$0.00$1,248.13
Water FundStorage-Tower 2$0.00$0.00$0.00
Water FundWater Maintenance$189,770.00$16,313.03$62,666.82
Water FundAdministration and General$35,825.00$2,288.41$8,557.09
Water FundDepreciation Expense$360,000.00$0.00$0.00
FUND 601 Water Fund$971,700.00$22,891.60$278,320.45
FUND 602 Sewer Fund
Sewer FundBond Payment (P & I)$20,885.00$0.00-$27,960.59
Sewer FundOther Financing Uses$48,000.00$0.00$0.00
Sewer FundSanitary Sewer Maintenanc$204,480.00$9,382.10$39,436.69
Sewer FundLift Station-Baker Street$6,305.00$48.40$1,142.75
Sewer FundLift Station-DBL Labs Area$2,765.00$107.28$893.33
Sewer FundLift Station-Northland$5,410.00$125.17$781.25
Sewer FundLift Station-CR 121$5,675.00$144.27$2,912.89
Sewer FundLift Station-Main$638,780.00$49,657.32$255,383.06
Sewer FundAdministration and General$39,300.00$2,672.27$11,259.60
Sewer FundDepreciation Expense$215,000.00$0.00$0.00
FUND 602 Sewer Fund$1,186,600.00$62,136.81$283,848.98
FUND 603 Refuse Collection
Refuse CollectioWaste Collection$328,175.00$27,060.17$141,470.37
Refuse CollectioOther Financing Uses$0.00$0.00$0.00
FUND 603 Refuse Collection$328,175.00$27,060.17$141,470.37
FUND 651 Storm Water Utility
Storm Water UtiOther Financing Uses$21,250.00$0.00$0.00
Storm Water UtiAdministration and General$13,095.00$708.24$3,972.05
Storm Water UtiStorm Water Maintenance$80,140.00$3,023.88$12,712.51
Storm Water UtiDepreciation Expense$100,000.00$0.00$0.00
FUND 651 Storm Water Utility$214,485.00$3,732.12$16,684.56
FUND 652 Street Light Utility
Street Light UtiliStreet Lighting$51,000.00$3,661.05$20,973.22
FUND 652 Street Light Utility$51,000.00$3,661.05$20,973.22
$2,751,960.00$119,481.75$741,297.58