HomeMy WebLinkAbout[06a] Finance Report
Council Agenda Item
MEETING DATE: July 16, 2009
AGENDA ITEM: Finance Report - 2"d Quarter Report
SUBMITTED BY: Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A
PREVIOUS COUNCIL ACTION: In the past when the Council received the Quarterly finance position,
you also received the last month of the quarter. The reports are redundant and include the same
information. Therefore, the month that you receive the quarterly report, that data includes the last
month of the quarter.
BACKGROUND INFORMATION: Quarterly reconciled cash/investment and budget to actual position are
provided for Council review. The charts presented are to assist your visual understanding of the last
quarter's financial summaries. The numbers presented are the numbers as of June 30, 2009.
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.
June Activity
70% of the first half property tax settlement was received by the city on June 26tH and is reflected in the
Treasurer's Report. The remaining 30% was received on July 6tH and will be reported next month. The
settlements include property taxes, special assessments and tax increments. Further, the 1St half LGA
less % the Governor's 2009 unallotment will be deposited into the City's accounts around July 20tH. The
amount will be $388,591.50. The City would have received $432,877 in July without the unallotment.
Overall the General fund has spent 40% of the expenditure budget and has received 22% of the revenue
budget as of June 30tH
As of June 30, 2009 two funds remain in a deficit -fund 157 TIF 2-1Millstream Shops and Lofts and fund
343- 20098 GO CIP bonds. TIF 2-1 incurred administrative expenses to establish the TIF that will be
covered by increments once they are received. The increments will not begin until 2010. The 20096 CIP
bonds have not been issued yet. The refinancing of the Public Works facility will occur later this year if
the market rates are favorable. There was an initial hearing expense for the bond hearing that was
incurred. If the bonds are not issued, the advertising expense will be covered by the General Fund.
The City issued 4 new home building permits so far in 2009 (each with aWAC/SAC connection}. 1n
addition, there have been 3non-residential permits with WAC/SAC charges including China One, Central
MN Federal Credit Union, College of St. Benedict's medical facility. WAC connection charges total
$15,539 and SAC connection charges total $20,320 for the first half of 2009.
CASH REPORT:
- The City has investments in money market accounts, bank CDs, brokered CDs and government
securities. The City has reviewed other investment options, but the rates of return are less
favorable and more volatile in the current market. The government securities the City holds are
in escrow for the 2009A cross-over refunding bonds. The bond escrow money is not available
for current City expenses.
FUNDS REPORT:
- The City's cash grew by $317,347 since the beginning of the year (excluding bond proceeds held
in escrow for the 2009A bond refunding). % cent sales tax proceeds, CSB sewer use payments,
special assessment payments, and building permit activity resulted in the increase in cash. The
next major cash inflow will be in July when the City receives the remaining first half payments of
taxes, assessments and the first half LGA.
- The General Fund spent down 40% of the 2009 budget and received 22%" of the revenue budget.
The revenue budget will be closer to the expenditures by the end of July when the remaining 1St
half tax settlement and the 1St half LGA is received.
The Enterprise Funds show expenses greater than revenues. This is due to 6 months worth of
expenses were incurred, but only 4 months of utility usage has been billed in received as of June
30, 2009. The May and June 2009 utility usage will be billed in July with a due date of August.
CIP REPORTS:
- The 2009 CIP reports are shown without the 2008 and 2009 capital budgets as a result of the
Council's decision to reduce the capital expenditures to cover portions of the Governor's
unallotment. There is also a column showing the CIP amounts if the capital budget for 2008 and
2009 was still in place. There has been very little capital expenditure activity in 2009.
BUDGET/FISCAL IMPACT: Information Only
ATTACHMENTS: 2"d Quarter 2009 Financial Position Summaries/CIP Updates
REQUESTED COUNCIL ACTION: Accept the 2"d Quarter 2009 financial positions as presented.
City of St. Joseph, Minnesota
Cash Position
As of 6/30/09
First State Bank Maturity Date Interest Current Balance # Securities % of Total
Checking Account (Reconciled) N!A 0.3% $ 1,281,791 t`I/A
Money Market Savings N/A 1.56% 310,189 t`l/A
Bank Certificates of Deposit Tiered 5-42 months 4.55% avg 3,911,594 10
averages 21 months 4 2 r `~
Total FSB $ 5,503,574 42%
Central MN Federal Credit Union
Share Savings Account N/A 1.18% $ 10 ~/A
Money Market Savings N/A 1.45% 117,636 r\/A
Power Money Market Checking N/A 2.30% 409,382 t\/A
Jumbo Bank Certificates of Deposit Tiered 1-54 months 3.87% avg 2,746,882 5
averages 14 rnonihr 3.3p°i~
Total CMFCU $ 3,273,910 25%
Total Deposits $ 8, 777,484
Salomon Smith Barnev
Brokered Money Market Savings N/A 0.17% $ 12,624 N/A
Government Securities/Notes all called early 0.00% avg - )
Brokered Certificates of Deposit Tiered 3-65 months 4.57% avg 1,275,356 13
averages 37 months 4.26`r~
Total SSB $ 1,287,980 10%
Northland Securities
Brokered Money Market Savings N/A 0.00% $ 6,099 N/A
Brokered Certificates of Deposit Tiered 6-7 months 4.00% avg 200,866 :?
averagrs 7 mgntti~ 2.67%.
Total NS $ 206,965 2%
Cash Held in Escrow (Cross-0ver Bond Refunding) 0.54% $ 2,985,320 23%
Totallnvestments $ 4,480,265
Total Deposits and Investments $ 13,257,749
Averagt= Interest A~'Y 3 76~;.
Pettv 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 FD IC/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 S 18,723 0°o N/A
(over 5% of investment portfolio) Brokered Certificates of Deposit ~ 1,476,222 11"/ 2.13 years
Government Bonds/Notes 3 0°o N/A
State/Local Government Securities 5 2,985,320 67' o NIA
Foreign Currency Risk. The City only invests in USA and USA territories
~ Y
C f0
N T
a--~ ~
C
~c
O N
~ ~ ~
N
C ~ ~ N dl
_ U
Y
V ~
~
Y 4/
Y 41
Y
L O ~ O O
U ~ [O [O [O
~ ^ ^ •-
N
_~
2
o
m
m
~ ~
N ~
N
V
W
W
n
ti
rv
m
i
~, ,
O] h I~ N W m r`
LL N (O 01 ~ 'cT W (D ~
uJ O ~
W ~ N ~ m M
J
~
~?
O M f~
N c0 .r-~ O
V
EA ~ ~ fA d9 69 to EA
~ uN'7 M
W N IA O
~ ~ W
1~ V ~ ~
m ~
f
~ O
O N
' h O
~ N m ch
~ ~
~
W~ O N N c~0 ~ p
t0 ~- O)
N
° V
N V
v c~ O)
M
rn CO
O
O) a0 m
co rn c~ O
U~ ~ m ~
W
rn
o ~ ~
~ ~ ~
W V
~
D ~
O
~ ~
~ '
~
'
~
~ N
~ ' O
at ~ O O
o7 (O r,
u7 a
Q ~ ~
~ O ~A
~ O a~ c0
~ N ~
N
N t0
m
~
O _
b9
O ~
a0 V M O)
c0
V
F
N OD
LL O ~ ~
~ r d
W r- O
~ ~ M M
h O O ~
V <O V
C
a~ J {n N W
° ° ~ a
O m e» t9 e3 - to E» EA e» L
C ~ ~
c
c~
O ~ h O)
Z 'R O O ~ ~ i ~ i O ~
ap rn 1n m O ~
O
~ N
~ N
a~ ~
_ ~ ~,
W ^ ~
N
N
~ 4
7
N
1n O m ~
1~ ~ V
M t
a~ 0 d Q
N
~ i0 M
N O)
N ~ ~ N ~
m
~ C
O
~
N ~ ~
O -
"' ~ O ~
~
b9
EA M
N
N v ~
Q [6 _
0 V IA
V
~ i
~ ~
~
cD M N
(0 ~ ~ ~ ~ ~ . ~ i ~ i ~
1 ~ r` (U (O
m ~ M 10
CO r` O) r`
h c+>
L
V ~
!O d u
'~ N
_
W N 00 V N
~: ~
O ~
F
I~ N
W O h
V O N r`
N
M a0 ~ O
N N O
.- O 's ) r-
D a
r ~- e~{{
t0
t0 M
N D)
l0 V
Q~
c0 t0 m
tp N
M O M f~
h ~
V M
st
f0 V M m
M 10 M
V ~ 1~ O1
N
V N h
M V
O M
Z O ~
Q M If1 O
N O N <
4) ~ I O O:
C! C of M
~ M m
N Q7 O V
IA V M
CO f~ N N
CO OD m N
r` In n
In
J tf m ~ cD of n N N N Q) M
Q '~f O O
m
S
Q
U
~
' ,
;; i ~ ~
k:~; U VJ
K
~p C N
~0 N
F 'O ~ v
d g ~' [ O L ~ m L
D
h
r
~ f0
H
~ O
LL C
i
7 LL
~ N
Z
7 y
~
« ~
t~
d
E
4
c
O
«
~
c
~ l
V
LL LL
N
=
U J
Q
F U U
O O
LL G J ~p ~ G1 D ? a1 ~ O
LL 'O L OD ~ V O ~ L ~ C ~ ~ R
" (U7 ~ ~ 0 d F (\ N
~
° ~ V 10 A 3 m LL ~ a LL LL m~
-
LL
C LL O
7
LL « ~
U Z d m >
C
> ~a
"
~ 4 i d
3
« m d
3
i ~
a p LL m w i
a L x
J ~ ~
o ~ +
~~ ~ W ~ to 0 < 0' V U R. Q U 3 t '~ ~ in
t/.
v
m a
~ ~
I /N~'
t W
L !
~_
^~
Y
i
X i
W
•~
V
Q
+~
~-+
dA
m
a~
o a
v
i
w o
0
M
I
i i
_ ~D
i
t
I
I
': i j
a
+
I
~ ' C
I ~ d
LL Q
~ N (II
LL G
r
M
~ .,,
c ~
~i Q.
io ~
v o
c o
a O
l7 ~
V
J
O O O O O
O O O O O
O O O O O
O 00 O 00 O
N N N .--I
v
OD
~ ~
a-+
~ U
CI] Q
J
W
~^ ,
`W`
^/
W
V
a
M~
W
O
O
O
O
O
00
r-i
O O O O
O O O O
O O O O
O O O O
O O O O
LI') N p1 lD
r-i r-i
Q
W
C
v
LL
C
7
LL
f0
UJ
C
N
O
O '
O
O
O
m
.~
V
NQ~
LL
O
.~
U
Q1
O
N
'C
d
.~
V
d
O
N
N
r~ 1~ CITY OF ST JOSEPH
Cash and Investment- Council Report
Current Period: June 2009
Current
FUND FUND Descr Begin Yr YTD Debit YTD Credit Balance
101 General $505,737.24 $1,227,260.06 $1,678,517.48 $54,479.82
105 Fire Fund $476,173.24 $170,484.98 $132,385.77 $514,272.45
108 Cable Access Fee $18,081.74 $4,375.99 $0.00 $22,457.73
150 Economic Development $21,974.87 $29,471.17 $25,119.41 $26,326.63
156 TIF 1-4 St. Joe Development $26,638.18 $46,923.11 $23,430.32 $50,130.97
157 TIF 2-1 Millstream $5,747.09 $5,753.77 $11,503.40 -$2.54
200 State Collected Sales Tax $624,429.86 $130,530.71 $2,935.15 $752,025.42
205 Park Dedication $59,424.72 $2,329.07 $5,264.55 $56,489.24
210 Recreation Center $48,136.81 $1,074.50 $24.56 $49,186.75
215 Charitable Gambling $0.00 $6,657.40 $2,102.98 $4,554.42
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 $1,172.94 $26.81 $53,693.95
318 2009A CrossoverRefunding Bonds $0.00 $1,961.07 $976.94 $984.13
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 $66,474.16 $43,822.59 $402,959.26
321 Joseph Street Improvement $33,433.39 $1,878.96 $259.38 $35,052.97
322 City Hall Refunded, 2005 $3,922.27 $72,077.74 $46,195.34 $29,804.67
323 20041mprovements/Northland $83,613.05 $24,413.27 $13,577.81 $94,448.51
325 2002 Street Improvement $623,881.81 $134,505.20 $88,684.80 $669,702.21
328 2003 Liberty Pointe Street Imp $303.32 $1,157.79 $220.26 $1,240.85
329 2003 Maintenance Faality $2.63 $43,431.60 $32,661.36 $10,772.87
331 2003 Refunding Fire Hall $137,738.87 $64,361.71 $40,806.14 $161,294.44
332 2003 Cross Over (93 Streets) $124,351.76 $27,019.55 $12,831.41 $138,539.90
333 2005 Improve (HilUClover) $602,729.24 $66,638.07 $58,114.18 $611,253.13
335 Northland Heights/Trans Corrid $564,379.94 $553,521.50 $330,433.40 $787,468.04
337 2006 Equipment Certificate $7,900.37 $45,469.61 $24,564.24 $28,805.74
338 2006 Interior St Improvements $785,185.12 $123,578.95 $86,962.45 $821,801.62
341 2007 St Imprv-E Side/Jade/8 Av $372,036.99 $247,063.36 $134,708.45 $484,391.90
342 2008 Equipment Certificates $9,523.23 $41,298.67 $25,444.20 $25,377.70
343 20096 GO CIP Bonds $0.00 $0.00 $33.84 -$33.84
390 Debt Service Relief $116,642.75 $3,391.04 $566.46 $119,467.33
435 Northland Heights/Trans Corrid $548,205.56 $23,690.56 $66,438.44 $505,457.68
441 2007 Street Impr (Jade Rd/E $504,478.86 $8,411.89 $19,319.46 $493,571.29
490 Capital Outlay $346,461.81 $19,509.13 $114,807.66 $251,163.28
501 Water Extension $514,426.39 $44,009.80 $262.71 $558,173.48
502 Sewer Extension $608,551.30 $36,176.16 $310.59 $644,416.87
301 Water Fund $640,567,84 $207,453.46 $384,378.72 $463,642.58
302 Sewer Fund $564,840.08 $405,289.23 $202,695.59 $767,433.72
303 Refuse Collection $273,169.52 $159,210.09 $149,627.07 $282,752.54
351 Storm Water Utility $263,517.22 $62,387.05 $27,115.38 $298,788.89
07/07!09 9:22 AM
Page 1
$9,949,144.61 $10,101,003.56 $6,792,399.90 $13,257,748.27
CITY OF ST JOSEPH
Council Month End Revenue Summary
Current Period: June 2009
2009 June 2009
FUND FUND Descr YTD Budget 2009 Amt YTD Amt
101 General $2,545,471.00 $453,666.57 $556,325.31
105 Fire Fund $258,150.00 $27,688.87 $108,512.57
108 Cable Access Fee $0.00 $0.00 $2,926.79
150 Economic Development $45,010.00 $7,902.14 $29,103.27
155 TIF 1-3 Borgert (SKN) $0.00 $0.00 $0.00
156 TIF 1-4 St. Joe Development $0.00 $23,334.30 $23,675.57
157 TIF 2-1 Millstream $0.00 $36.04 $110.90
200 State Collected Sales Tax $0.00 $26,190.65 $64,482.88
205 Park Dedication $0.00 $375.93 $1,184.63
210 Recreation Center $0.00 $301.91 $958.42
215 Charitable Gambling $0.00 $32.24 $6,654.42
230 Lake Wobegon Trail $0.00 $0.00 $0.00
232 City Beautification-College Av $0.00 $0.00 $0.00
250 Revolving Loan Fund $0.00 $329.59 $1,046.33
318 2009A CrossoverRefunding Bonds $0.00 $6.05 $3,059,379.48
320 2007 Refunding (98/99 St Bond) $2,500.00 $23,775.39 $38,136.79
321 Joseph Street Improvement $0.00 $455.68 $913.51
322 City Hall Refunded, 2005 $110,000.00 $34,985.08 $34,990.37
323 20041mprovements/Northland $33,000.00 $11,547.31 $12,609.12
325 2002 Street Improvement $66,000.00 $87,570.71 $97,581.94
328 2003 Liberty Pointe Street Imp $0.00 $0.00 $591.81
329 2003 Maintenance Facility $66,000.00 $21,016.47 $21,026.17
331 2003 Refunding Fire Hall $77,120.00 $12,303.96 $33,921.83
332 2003 Cross Over (93 Streets) $14,000.00 $11,655.57 $16,320.88
333 20051mprove (HiIUClover) $15,000.00 $26,300.32 $34,714.66
335 Northland Heights/Trans Corrid $55,000.00 $211,797.80 $226,456.40
337 2006 Equipment Certificate $69,000.00 $22,050.75 $22,173.72
338 2006 Interior St Improvements $61,000.00 $55,069.13 $78,042.04
341 2007 St Imprv-E Side/Jade/8 Av $36,000.00 $144,212.90 $157,221.87
342 2008 Equipment Certificates $65,500.00 $20,413.57 $20,739.41
343 20098 GO CIP Bonds $0.00 $0.00 $0.00
390 Debt Service Relief $0.00 $1,207.90 $2,700.78
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 $15,719.45 $42,147.39
502 Sewer Extension $0.00 $14,332.19 $34,419.64
601 Water Fund $965,400.00 $47,034.33 $93,901.56
602 Sewer Fund $530,850.00 $147,460.13 $69,018.69
603 Refuse Collection $278,600.00 $36,742.45 $98,960.97
651 Storm Water Utility $108,700.00 $14,958.58 $39,852.98
$5,402,301.00 $1,500,473.96 $5,030,803.10
07/07/09 10:34 AM
Page 1
rl CITY OF ST JOSEPH
Council Month End Revenue -Ge neral Fund
Current Period: June 2009
2009 June 2009
FUND FUND Descr SOURCE Descr YTD Budget 2009 Amt YTD Amt
FUND 1 01 General
101 General Current Ad Valorem Taxes $1,179,551.00 $376,216.78 $376,216.78
101 General State Sales Tax $125.00 $416.79 $440.17
101 General Gas Franchise $30,500.00 $0.00 $1,391.92
101 General Electric Franchise $50,000.00 $1,340.83 $20,499.17
101 General Beer $2,000.00 $0.00 $0.00
101 General Liquor $22,200.00 $3,120.00 $10,560.00
101 General Outdoor Liquor Permit $1,200.00 $0.00 $2,800.00
101 General Gambling Permits $200.00 $35.00 $85.00
101 General AmusemenUHunting Permit $1,500.00 $0.00 $0.00
101 General Contractors License $100.00 $0.00 $0.00
101 General Excavation Permit $500.00 $50.00 $150.00
101 General Cigarette License $500.00 $0.00 $0.00
101 General Cable Franchise Fee $21,700.00 $0.00 $6,058.62
101 General Building Permits $122,000.00 $16,451.74 $46,473.54
101 General Animal License $2,500.00 $397.00 $2,795.00
101 General Rental Housing Registration $17,000.00 $3,279.50 $3,354.50
101 General Federal Grants -Other $2,000.00 $2,774.67 $3,314.29
101 General Local Government Aid $865,754.00 $0.00 $0.00
101 General Market Value Credit $0.00 $0.00 $0.00
101 General PERA Rate Increase Aid $1,541.00 $0.00 $0.00
101 General Police Training Reim $3,500.00 $0.00 $0.00
101 General State Municipal Funds Aid $6,200.00 $0.00 $3,090.00
101 General State Police Aid $35,000.00 $0.00 $0.00
101 General County Grants -Road Maintena $7,750.00 $0.00 $0.00
101 General Zoning and Subdivision Fee $1,250.00 $0.00 $920.00
101 General Land Use Deposit Fee $4,000.00 $1,000.00 $4,250.00
101 General Sale of Maps and Publications $100.00 $20.00 $81.75
101 General Assessments Search $4,000.00 $475.00 $2,475.00
101 General Special Hearing $4,000.00 $0.00 $2,000.00
101 General Administration Reimb $15,000.00 $0.00 $16.00
101 General Weed Cutting $1,500.00 $100.00 $100.00
101 General Park Fees $5,000.00 $345.00 $3,495.00
101 General Summer Recreation Charges $0.00 $0.00 $0.00
101 General Kennel Fees $1,000.00 $0.00 $149.00
101 General County Fines $45,000.00 $3,759.77 $15,252.52
101 General Policy Fines $27,000.00 $660.00 $11,760.50
101 General Accident Report Fee $1,000.00 $15.75 $413.55
101 General Seized Property $1,500.00 -$172.90 -$149.90
101 General Special Assessments $1,500.00 $1,094.35 $1,108.57
101 General Interest Earnings $20,000.00 $1,002.45 $9,275.85
101 General Interest Charges $300.00 $202.70 -$558.23
101 General Co-op Dividend-MN League of C $10,000.00 $0.00 $0.00
101 General Water Tower Antenna Lease $1,100.00 $715.59 -$792.61
101 General Land Renta! $0.00 $1,500.00 $1,500.00
101 General Contribution -Health Ins Div $10,000.00 $0.00 -$15,000.00
101 General Contributions-Pule Christmas $0.00 $0.00 $3,000.00
101 General Contributions -Parks $600.00 $260.94 $404.73
101 General Surplus Property $250.00 $0.00 $35.00
101 General Reimbursement $4,050.00 $3,203.00 $3,956.98
101 General Transfers from Other Funds $14,000.00 $35,402.61 $35,402.61
FUND 101 General $2,545,471.00 $453,666.57 $556,325.31
FUND 108 Cable Access Fee
108 Cable Access Fee Cable Franchise Fee $0.00 $0.00 $2,926.79
07/07/09 10:35 AM
Page 1
FUND 150 Economic Development
r'
CITY OF ST JOSEPH
Council Month End Revenue -General Fund
Current Period: June 2009
2009 June 2009
FUND FUND Descr SOURCE Descr YTD Budget 2009 Amt YTD Amt
150 Economic Development TIF/MIF Deposit $0.00 $7,500.00 $7,500.00
150 Economic Development Interest Earnings $3,000.00 $86.54 $282.67
150 Economic Development Transfers from Other Funds $42,010.00 $315.60 $21,320.60
FUND 150 Economic Development $45,010.00 $7,902.14 $29,103.27
$2,590,481.00 $461,568.71 $588,355.37
07/07/09 10:35 AM
Page 2
rl
CITY OF ST JOSEPH
Council Month End Revenue -Enterprise Funds
Current Period: June 2009
FUND 2009 June 2009
FUND Descr SOURCE Descr YTD Budget 2009 Amt YTD Amt
FUND 6 01 Water Fund
601 Water Fund Contributed Revenue $0.00 $0.00 $0.00
601 Water Fund Water Meter $4,000.00 $560.00 $2,381.00
601 Water Fund Penalties and Forfeited Disc $500.00 $427.47 $2,833.68
601 Water Fund Transfers from Other Funds $479,000.00 $0.00 $0.00
601 Water Fund MDS Test Fee $9,000.00 $1,197.87 $3,303.88
601 Water Fund Water Line Charge $90,000.00 $11,653.75 $30,611.63
601 Water Fund Inspection Fees $9,000.00 $0.00 $0.00
601 Water Fund State Sales Tax $200.00 -$61.89 -$179.82
601 Water Fund Special Assessments $1,550.00 $303.51 -$2,306.63
601 Water Fund Undesignated Funds $0.00 $1,615.17 $2,192.39
601 Water Fund Amortization of Bond Premium $0.00 $0.00 $0.00
601 Water Fund Water Tower Antenna Lease $22,000.00 $954.20 -$12,691.77
601 Water Fund Reimbursement $0.00 $0.00 $0.00
601 Water Fund Rate Class One $300,000.00 $25,194.84 $52,552.86
601 Water Fund Bulk Water $0.00 $1,584.16 $3,224.16
601 Water Fund Interest Earnings $50,000.00 $3,505.25 $11,805.18
601 Water Fund Connection/Reconnection fees $150.00 $100.00 $175.00
FUND 601 Water Fund $965,400.00 $47,034.33 $93,901.56
FUND 602 Sewer Fund
602 Sewer Fund Sewer Line Charge $50,000.00 $13,085.73 $34,615.20
602 Sewer Fund Sewer Inspection Fee $1,000.00 $0.00 $0.00
602 Sewer Fund Sewer Surcharge - (Monthly) $1,000.00 $0.00 $0.00
602 Sewer Fund Transfers from Other Funds $47,200.00 $0.00 $0.00
602 Sewer Fund St. Benedict Sewer Charges $187,300.00 $108,459.60 -$21,054.84
602 Sewer Fund Sanitary Sewer Service $206,795.00 $21,789.84 $42,885.21
602 Sewer Fund Contributed Revenue $0.00 $0.00 $0.00
602 Sewer Fund Special Assessments $555.00 $156.45 -$285.26
602 Sewer Fund Surplus Property $0.00 $0.00 $0.00
602 Sewer Fund Interest Earnings $35,000.00 $3,663.90 $10,770.49
602 Sewer Fund Penalties and Forfeited Disc $2,000.00 $304.61 $2,087.89
602 Sewer Fund Reimbursement $0.00 $0.00 $0.00
FUND 602 Sewer Fund $530,850.00 $147,460.13 $69,018.69
FUND 603 Refuse Collection
603 Refuse Coliect Special Assessments $1,600.00 $207.66 -$733.20
603 Refuse Collect State Sales Tax $17,000.00 $1,725.12 $173.96
603 Refuse Collect Licenses 8 Permits $8,000.00 $1,190.00 $9,820.00
603 Refuse Collect Penalties and Forfeifted Disc $2,000.00 $529.14 $2,971.69
603 Refuse Collect Interest Earnings $10,000.00 $1,686.26 $5,313.41
603 Refuse Collect Contributions from Private Sou $0.00 $0.00 $150.00
603 Refuse Collect Refuse Collection Charges $240,000.00 $31,404.27
... $81,265.11
FUND 603 Refuse Collection $278,600.00 $36,742.45 $98,960.97
FUND 651 Storm Water Utitily
651 Storm Water Special Assessments $1,200.00 $27.44 -$705.72
651 Storm Water Interest Earnings $7,000.00 $1,757.87 $5,495.33
651 Storm Water Reimbursement $0.00 $0.00 $0.00
651 Storm Water Contributed Revenue $0.00 $0.00 $0.00
651 Storm Water Development Fee $20,000.00 $0.00 $0.00
651 Storm Water Rafe Class One $80,000.00 $13,064.94 $34,199.07
651 Storm Water Penalties and Forfeifted Disc $500.00 $108.33 $864.30
FUND 651 Storm Water Utility
$108,700.00
$14,958.58 _._
$39,852.98
07/07/09 10:35 AM
Page 1
i
,n,,~'r~~l,, .
CITY OF ST JOSEPH
Council Month End Revenue -Enterprise Funds
Current Period: June 2009
FUND 2009 June 2009
FUND Descr SOURCE Descr YTD Budget 2009 Amt YTD Amt
$1,883,550.00 $246,195.49
$301,734.20
07107109 10:35 AM
Page 2
CITY OF ST JOSEPH
Council Month End Expenditure Summary
Current Period: June 2009
2009 June 2009
FUND Description YTD Budget 2009 Amt YTD Amt
101 General $2,265,616.00 $151,627.49 $1,012,829.68
105 Fire Fund $232,045.00 $44,649.79 $84,988.87
150 Economic Development $29,700.00 $2,918.03 $22,489.84
155 TIF 1-3 Borgert (SKN) $0.00 $5,948.15 $5,948.15
156 TIF 1-4 St. Joe Development $0.00 $249.47 $249.47
157 TIF 2-1 Millstream $0.00 $5,874.97 $5,874.97
200 State Collected Sales Tax $0.00 $0.00 $70.00
205 Park Dedication $0.00 $4,323.49 $5,159.10
215 Charitable Gambling $0.00 $0.00 $2,100.00
318 2009A CrossoverRefunding Bonds $0.00 $0.00 $73,075.71
320 2007 Refunding (98/99 St Bond) $0.00 $0.00 $16,349.01
322 City Hall Refunded, 2005 $0.00 $0.00 $11,210.26
323 20041mprovements/Northland $0.00 $0.00 $2,470.26
325 2002 Street Improvement $0.00 $0.00 $54,122.76
328 2003 Liberty Pointe Street Imp $0.00 $0.00 $220.26
329 2003 Maintenance Facility $0.00 $0.00 $11,611.51
331 2003 Refunding Fire Hall $0.00 $0.00 $11,519.01
332 2003 Cross Over (93 Streets) $0.00 $0.00 $2,986.51
333 2005 Improve (Hill/Clover) $0.00 $0.00 $27,752.76
335 Northland Heightslfrans Corrid $0.00 $0.00 $28,132.76
337 2006 Equipment Certificate $0.00 $0.00 $2,560.27
338 2006 Interior St Improvements $0.00 $0.00 $44,104.64
341 2007 St Imprv-E Side/Jade/8 Av $0.00 $0.00 $47,754.64
342 2008 Equipment Certificates $0.00 $0,00 $5,075.27
343 20098 GO CIP Bonds $0.00 $33.84 $33.84
435 Northland Heights/Trans Corrid $0.00 $23,743.41 $31,316.11
441 2007 Street Impr (Jade Rd/E $0.00 $941.25 -$70,784.20
442 2008 Equipment Certificates $0.00 $0.00 $8,513.81
490 Capital Outlay $0.00 $935.13 $4,877.83
601 Water Fund $865,442.00 $28,454.08 -$58,042.27
602 Sewer Fund $417,763.00 $37,481.29 $152,199.05
603 Refuse Collection $279,630.00 $25,344.25 $119,586.94
651 Storm Water Utility $37,625.00 $3,861.42 $24,876.31
07/07/09 10:32 AM
Page 1
$4,127,821.00 $336,386.06 $1,691,233.13