HomeMy WebLinkAbout[05b] Approval of Financial Reports lr CITY OF ST. JOSEPH
www.cityofstioseph.com
DATE: August 8, 2012
MEMO TO: St. Joseph Economic Development Authority
FROM: Joanne Foust, Municipal Development Group
Administrator
Judy Weyrens RE: Accounts Payable
July Financial Reports
Mayor
Richard Schultz
A. Accounts Payable:
Councilors Following are Accounts Payable for the EDA's Consideration.
Steve Frank
Bob Loso Payable To For Fund Amount
Renee Symanietz MDG, Inc. July Econ. Dev. Service 150 - 46500 -300 $ 2,638.45
Dale Wick
Total $ 2,638.45
EDA
Larry Bosch
Chad Davey Action:
Steve Frank A MOTION is in order to approve the Accounts Payable.
Tom Skahen
Dale Wick
B. Financial Report:
May financial reports are attached for your consideration.
The reports consist of:
1. Monthly Report.
2. Balance Sheet.
3. EDA revenue to date.
4. EDA expenditures to date.
5. CIP Summary
A MOTION is in order to approve the Financial Reports.
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
July 31, 2012
Fund 150, EDA Balance as of December 31, 2011 (audited) 49,582.49
Year to Date Revenue:
Interest Earnings 530.48
Ad Valorem Taxes 34,614.13
Total Revenue 35,144.61
Year to Date Expenditure Total by Project:
Market Development 4,008.65 **
Business Development 7,532.88 **
Organizational Development 5,522.03 **
Infrastructure Development 33.03 **
Workforce Development - **
17,096.59
Year to Date Expenditures by Obiect:
Board Stipends (35.00)
Staff Salaries -
Workers Comp Premium -
Office Supplies (225.45)
Software Support (529.52)
Municipal Development Group (13,183.33)
Legal /Engineering Fees (405.00)
Telephone (451.82)
Postage (1.90)
Business Luncheon -
Advertising (39.19)
Recording Fee -
Rentals -
St. Cloud EDA Membership Dues -
EDA Programs (3,535.55)
Total Expenses (18,406.76)
Fund Summaries as of July 31, 2012:
EDA Fund Balance - Fund 150 - unaudited 66,320.34
Designated for Capital Programs 26,003.96
Designated for DEED Housing Projects 16,368.57
U ndesignated 23,947.81
TIF 1-4 St. Joseph Development Fund Balance • Fund 156 827.12
TIF 2 -1 Millstream Shops and Lofts Fund Balance -Fund 157 8,816.63
TIF 2 -2 St. Joseph Meat Market Fund Balance -Fund 158 (435,98)
Revolving Loan Fund Balance -Fund 250 19,419.27
** Detail available upon request
r l CITY OF ST JOSEPH 08/06/12 2:01 PM
�r .A. '� EDA Balance Sheet Page 1
Current Period: July 2012
YTD YTD Current
FUND Descr Account Descr Begin Yr Debit Credit Balance
FUND 150 Economic Development
Economic Development G 150 -10100 Cash $51,328.42 $40,207.99 $27,516.07 $64,020.34
Economic Development G 150 -10450 Interest Receivable $33.58 $0.00 $33.58 $0.00
Economic Development G 150 -15500 Due From Other Fund $2,300.00 $0.00 $0.00 $2,300.00
Economic Development G 150 -20200 Accounts Payable - $4,079.51 $4,079.51 $0.00 $0.00
Economic Development G 150 -24415 Design. Fd Bal - Capital Proj - $20,131.87 $0.00 $0.00 - $20,131.87
Economic Development G 150 -25310 Appropriated Fund Balance - $29,450.62 $27,549.65 $44,287.50 - $46,188.47
FUND 150 Economic Development $0.00 $71,837.15 $71,837.15 $0.00
FUND 156 TIF 1 -4 St. Joe Development
TIF 1 -4 St. Joe Develop G 156 -10100 Cash $17.95 $30,616.06 $27,806.89 $2,827.12
TIF 1 -4 St. Joe Develop G 156 -10450 Interest Receivable $40.37 $0.00 $40.37 $0.00
TIF 1-4 St. Joe Develop G 156 -20500 Due To Other Fund - $2,000.00 $0.00 $0.00 - $2,000.00
TIF 1-4 St. Joe Develop G 156 -25310 Appropriated Fund Balance $1,941.68 $27,847.26 $30,616.06 - $827.12
FUND 156 TIF 1 -4 St. Joe Development $0.00 $58,463.32 $58,463.32 $0.00
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream G 157 -10100 Cash $8,443.84 $18,229.91 $17,857.12 $8,816.63
TIF 2 -1 Millstream G 157 -10450 Interest Receivable $10.02 $0.00 $10.02 $0.00
TIF 2 -1 Millstream G 157 -13113 Due From other Gov t Units $42.48 $0.00 $42.48 $0.00
TIF 2 -1 Millstream G 157 -20200 Accounts Payable - $1,284.90 $1,284.90 $0.00 $0.00
TIF 2 -1 Millstream G 157 -25310 Appropriated Fund Balance - $7,211.44 $17,909.62 $19,514.81 - $8,816.63
FUND 157 TIF 2 -1 Millstream $0.00 $37,424.43 $37,424.43 $0.00
FUND 158 TIF 2 -2 Meat Market
TIF 2 -2 Meat Market G 158 -10100 Cash $3.26 $0.00 $139.24 - $135.98
TIF 2 -2 Meat Market G 158 -20500 Due To Other Fund - $300.00 $0.00 $0.00 - $300.00
TIF 2 -2 Meat Market G 158 -25310 Appropriated Fund Balance $296.74 $139.24 $0.00 $435.98
FUND 158 TIF 2 -2 Meat Market $0.00 $139.24 $139.24 $0.00
FUND 250 Revolving Loan Fund
Revolving Loan Fund G 250 -10100 Cash $14,158.07 $5,261.20 $0.00 $19,419.27
Revolving Loan Fund G 250 -10450 Interest Receivable $33.95 $0.00 $33.95 $0.00
Revolving Loan Fund G 250 -11900 Notes Receivable $43,017.08 $0.00 $43,017.08 $0.00
Revolving Loan Fund G 250 -20200 Accounts Payable $0.00 $0.00 $0.00 $0.00
Revolving Loan Fund G 250 -22204 Deferred Revenue - $43,017.08 $43,017.08 $0.00 $0.00
Revolving Loan Fund G 250 -25310 Appropriated Fund Balance - $14,192.02 $33.95 $5,261.20 - $19,419.27
FUND 250 Revolving Loan Fund $0.00 $48,312.23 $48,312.23 $0.00
$0.00 $216,176.37 $216,176.37 $0.00
r' CITY OF ST JOSEPH 08/06/12 2:03 PM
/ A EDA Check Register Page 1
CHECK
# Search Name Comments FUND DEPART Amount
045368 MUNICIPAL DEVELOPMENT CORP reallocate - downtown 150 46500 $195.89
045368 MUNICIPAL DEVELOPMENT CORP reallocate - mtgs /research /info 150 46500 $657.97
045368 MUNICIPAL DEVELOPMENT CORP reallocate - website 150 46500 $533.78
045368 MUNICIPAL DEVELOPMENT CORP reallocate - business retention 150 46500 $2,688.43
045368 MUNICIPAL DEVELOPMENT CORP reallocate - organizational deve 150 46500 $926.03
045368 MUNICIPAL DEVELOPMENT CORP Allocate May Services 150 46500 - $2,518.45
045368 MUNICIPAL DEVELOPMENT CORP reallocate - BFA loans 150 46500 $27.70
045368 MUNICIPAL DEVELOPMENT CORP Allocate April Services 150 46500 - $2,511.35
045534 CENTRYLINK telephone WTP2 /PD/T1 Line 150 46500 $50.59
045535 CENTURYLINK BUSINESS SERVICES long distance telephone 5/24 -6 150 46500 $4.79
045561 MUNICIPAL DEVELOPMENT CORP June EDA services 150 46500 $2,655.10
045572 CENTRYLINK 20 sets of 229 #s - 7/10 -8/9/1 150 46500 $10.43
045580 MINNWEST BANK TIF 1 -4 payment 156 46500 $27,540.76
045587 SENTRY BANK TIF 2 -1 payment 157 46500 $16,272.53
$46,534.20
f i CITY OF ST JOSEPH 08/06/12 2:03 PM
d / l - � EDA Expenditure Report Pagel
Current Period: July 2012
2012 July 2012
Account Descr YTD Budget 2012 Amt YTD Amt
FUND 150 Economic Development
E 150- 46500 -103 Legislative Bodies $1,390.00 $0.00 $35.00
E 150- 46500 -151 Workers Comp. Insur. Prem. $10.00 $0.00 $0.00
E 150 - 46500 -200 Office Supplies $500.00 $0.00 $225.45
E 150 - 46500 -215 Software Support $540.00 $0.00 $529.52
E 150 -46500 -300 Professional Services $28,000.00 $1,773.54 $13,183.33
E 150-46500-303 Engineering Fee $2,000.00 $0.00 $0.00
E 150 - 46500 -304 Legal Fees $1,000.00 $0.00 $405.00
E 150 - 46500 -321 Telephone $785.00 $65.81 $451.82
E 150- 46500 -322 Postage $350.00 $0.00 $1.90
E 150- 46500 -328 Marketing $8,000.00 $0.00 $0.00
E 150-46500 -331 Travel & Conference Expense $150.00 $0.00 $0.00
E 150-46500 -340 Advertising $500.00 $0.00 $39.19
E 150 - 46500 -410 Rentals $0.00 $0.00 $0.00
E 150 - 46500 -433 Dues & Memberships $0.00 $0.00 $0.00
E 150 - 46500 -434 Certification Fee $0.00 $0.00 $0.00
E 150 - 46500 -582 Computer Software $0.00 $0.00 $0.00
E 150 - 46500 -588 EDA Programs $27,500.00 $881.56 $3,535.55
E 150-46500 -622 TIF /Abatement Payments $0.00 $0.00 $0.00
FUND 150 Economic Development $70,725.00 $2,720.91 $18,406.76
FUND 156 TIF 1 -4 St. Joe Development
E 156- 46500 -101 Salaries $0.00 $217.32 $217.32
E 156 - 46500 -121 PERA Contributions $0.00 $15.75 $15.75
E 156- 46500 -122 FICA Contributions $0.00 $13.47 $13.47
E 156 - 46500 -123 Deferred Comp- Employer $0.00 $3.75 $3.75
E 156 - 46500 -125 Medicare Contributions $0.00 $3.15 $3.15
E 156- 46500 -131 Health Insurance $0.00 $0.00 $0.00
E 156 - 46500 -133 Life Insurance $0.00 $0.45 $0.45
E 156 - 46500 -134 Disabilty Insurance $0.00 $3.07 $3.07
E 156 - 46500 -300 Professional Services $0.00 $0.00 $0.00
E 156- 46500 -340 Advertising $0.00 $0.00 $0.00
E 156 - 46500 -588 EDA Programs $0.00 $0.00 $0.00
E 156 - 46500 -622 TIF /Abatement Payments $0.00 $27,540.76 $27,540.76
FUND 156 TIF 1-4 St. Joe Development $0.00 $27,797.72 $27,797.72
FUND 157 TIF 2 -1 Millstream
E 157 - 46500 -101 Salaries $0.00 $217.32 $253.54
E 157 - 46500 -121 PERA Contributions $0.00 $15.75 $18.37
E 157 - 46500 -122 FICA Contributions $0.00 $13.47 $15.72
E 157 - 46500 -123 Deferred Comp - Employer $0.00 $3.75 $4.32
E 157 - 46500 -125 Medicare Contributions $0.00 $3.15 $3.68
E 157 -46500 -131 Health Insurance $0.00 $0.00 $0.00
E 157- 46500 -133 Life Insurance $0.00 $0.45 $0.52
E 157 - 46500 -134 Disabilty Insurance $0.00 $3.07 $3.54
E 157 - 46500 -300 Professional Services $0.00 $0.00 $0.00
E 157 - 46500 -317 Other fees $0.00 $0.00 $0.00
E 157- 46500 -331 Travel & Conference Expense $0.00 $0.00 $0.00
E 157 - 46500 -340 Advertising $0.00 $0.00 $0.00
E 157 - 46500 -622 TIF /Abatement Payments $0.00 $16,272.53 $16,272.53
E 157 - 49300 -720 Transfers to Other Funds $0.00 $0.00 $0.00
FUND 157 TIF 2 -1 Millstream $0.00 $16,529.49 $16,572.22
FUND 158 TIF 2 -2 Meat Market
r' CITY OF ST JOSEPH 08/06/12 2:03 PM
�� A�� V EDA Expenditure Report Page 2
Current Period: July 2012
2012 July 2012
Account Descr YTD Budget 2012 Amt YTD Amt
E 158 - 46500 -101 Salaries $0.00 $117.72 $117.72
E 158- 46500 -121 PERA Contributions $0.00 $8.54 $8.54
E 158- 46500 -122 FICA Contributions $0.00 $7.31 $7.31
E 158- 46500 -123 Deferred Comp - Employer $0.00 $2.03 $2.03
E 158 - 46500 -125 Medicare Contributions $0.00 $1.71 $1.71
E 158- 46500 -131 Health Insurance $0.00 $0.00 $0.00
E 158- 46500 -133 Life Insurance $0.00 $0.25 $0.25
E 158 - 46500 -134 Disabilty Insurance $0.00 $1.68 $1.68
E 158 - 46500 -300 Professional Services $0.00 $0.00 $0.00
E 158 - 46500 -340 Advertising $0.00 $0.00 $0.00
E 158 -46500 -622 TIF /Abatement Payments $0.00 _ $0.00 $0.00
FUND 158 TIF 2 -2 Meat Market $0.00 $139.24 $139.24
FUND 250 Revolving Loan Fund
E 250 - 46500 -300 Professional Services $0.00 $0.00 $0.00
E 250 - 46500 -304 Legal Fees $0.00 $0.00 $0.00
E 250 - 46500 -317 Other fees $0.00 $0.00 $0.00
E 250- 46500 -434 Certification Fee $0.00 $0.00 $0.00
E 250 - 46500 -455 Revolving Loan Proceeds $0.00 $0.00 $0.00
FUND 250 Revolving Loan Fund $0.00 $0.00 $0.00
$70,725.00 $47,187.36 $62,915.94
r l C ITY OF ST JOSEPH 08/06/12 2:04 PM
X41 hA� - ' EDA Revenue Report Page 1
Current Period: July 2012
2012 July 2012
FUND Descr SOURCE SOURCE Descr YTD Budget 2012 Amt YTD Amt
FUND 150 Economic Development
Economic Development 31010 Current Ad Valorem Taxes $70,500.00 $10,384.25 $34,614.13
Economic Development 34150 TIF /MIF Deposit $0.00 $0.00 $0.00
Economic Development 34200 DEED Housing Reimbursem $0.00 $0.00 $0.00
Economic Development 36210 Interest Earnings $225.00 $92.00 $530.48
Economic Development 39201 Transfers from Other Funds $0.00 $0.00 $0.00
FUND 150 Economic Development $70,725.00 $10,476.25 $35,144.61
FUND 156 TIF 1 -4 St. Joe Development
TIF 1 -4 St. Joe Development 31050 Tax Increment $0.00 $9,180.22 $30,600.84
TIF 1 -4 St. Joe Development 36210 Interest Earnings $0.00 $15.17 - $34.32
FUND 156 TIF 1 -4 St. Joe Development $0.00 $9,195.39 $30,566.52
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream 31050 Tax Increment $0.00 $5,424.17 $18,080.59
TIF 2 -1 Millstream 33404 Market Value Credit $0.00 $0.00 $0.00
TIF 2 -1 Millstream 34150 TIF /MIF Deposit $0.00 $0.00 $0.00
TIF 2 -1 Millstream 36210 Interest Earnings $0.00 $24.29 $96.82
FUND 157 TIF 2 -1 Millstream $0.00 $5,448.46 $18,177.41
FUND 250 Revolving Loan Fund
Revolving Loan Fund 36210 Interest Earnings $300.00 $37.72 $168.85
Revolving Loan Fund 39320 Revolving Loan Principal $6,885.00 $575.26 $4,276.05
Revolving Loan Fund 39321 Revolving Loan Interest $1,195.00 $98.29 $782.35
Revolving Loan Fund 39322 Revolving Loan Origination $0.00 $0.00 $0.00
FUND 250 Revolving Loan Fund $8,380.00 $711.27 $5,227.25
$79,105.00 $25,831.37 $89,115.79
2 ' 1 t - o -
oLLt °2<
a
.0
Q
Ci O 0 0 l ,~-I •:r O a
: O O e-i .-1 ' to n ' ' fn C
C M N �.. N a n 00 N 00 •
RI g II ,-1 O V1 Ol N N
,,a ta
(u E 4°
1- c a)
3 N u
C j ON
X Q O _ m m N 0 0 lD M 00 0 fel
>. n .. of of ,-i rri ai v m ai of
Y a S LA CI W O V r M N N to S o
V fa "a 0 r
o - a m
r•4 c a , - 1 in frl 0 00 V
3 M N lD N O a 01
U. n L ' '
` N ,-1 V lD 2 N
C qa
r, C ` N 00 N lD
N
p p �
0 0 0 0
N t g 8 r 8�
m
N a, x-) (.0 0> <,. ■ N g
O ul N tD O Ul e-I ,--I 0 C
p al N d O Li-) O ,--I 0 V lD al frl frl
N a u o ,-r `i g o ui vi V r e
@ N R O V l , O � (.0 l(0 M ,L l
co ,T3 N Q
C m ,--I ,4 01 N l0 N N N M
V
.) m
LI j 6 N
(n f0 —
C N C d m U)
d w C E O O , O
C . N O . O 12 a)
C —
C a) N
Q 0 3 2 a) J > O
W - 0� C O
o u N m U N
°' �c.c 0 m=
E N'w 4 c4
o a) 2 ° w a) m
V J m 0 m m X U
a C 0 0 to 0 0 th
u E ' 7 � N 1
I. E oc 4C4{C 4Q<
Z, 0 C] 0 • 0 Q CI 0 Ca
w w wr' W„ . w w'W
a) N 00
O 1 .9 L
o 0 0
= u in
co co
u
c l ll ° l 0
U
4
'
0
y £ w
'g L' J
C. d 0 O p
0 w w r-