HomeMy WebLinkAbout[05] Accounts Payable and Financial Reports '�' CITY OF ST. 1 OSEPH
www.cityof stjoseph.com
DATE: March 21, 2012
MEMO TO: St. Joseph Economic Development Authority
FROM: Cynthia Smith - Strack, Municipal Development Group
Administrator
Judy Weyrens RE: Accounts Payable
February 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. Feb. Econ. Dev. Service 150 -46500 -300 $ 2,817.00
Dale Wick Total $ 2,817.00
EDA
Carolyn Yaggie— Action:
Heinen A MOTION is in order to approve the Accounts Payable.
Chad Davey
Steve Frank
Tom Skahen B. Financial Report:
Dale Wick February 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.
Page 12 of 36
6.4 INVOICE
MUNICIPAL DEVELOPMENT GROUP, INC.
25562 WILLOW LANE
NEW PRAGUE, MN 56071 City of St. Joseph
952 - 758 -7399
FAX: 952 - 758 -3711 Attn: Judy Weyrens
staff@municipaldevelopmentgroup.com City Administrator
PO 668
St. Joseph, MN 56374
Invoice Date 2 -10 -12 Payment Terms: 30 days Customer ID #:
STJ10EDA
Project February Economic Development Services
See attached detail
Amount: $2,200.00 Monthly contract fee
$ 617.00 1122 miles x .555
$2,817.00
Code to: 150 -46500 -300 for general EDA
Remit To: Municipal Development Group, Inc.
25562 Willow Lane
New Prague, MN 56071
Dates -EDA Hours
February 1, 2012 EDA Office Hours: C. Strack 8.00 Hours
February 8, 2012 EDA Office Hours: C. Strack 8.00 Hours
February 15, 2012 EDA Office Hours: C. Strack 8.00 Hours
February 16, 2012 Attend Council Meeting: C. Strack 2.75 Hours
February 22, 2012 EDA Office Hours: C. Strack 10.00 Hours
February 29. 2012 EDA Office Hours: C. Strack 6.00 Hours
Total February 2012 42.75 Hours
Total Contract Hours Thru February 29, 2012: 99.50 Hours
Thank you! We appreciated the opportunity to work with you!
Check No.
Date: Principal
Page 13 of 36
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
February 2012
Fund 150, EDA Balance as of December 31, 2010 (unaudited) 49,582.49
Year to Date Revenue:
Interest Earnings 99.55
Ad Valorem Taxes -
Total Revenue 99.55
Year to Date Expenditure Total by Protect:
Market Development 1,064.79 **
Business Development 2,386.04 **
Organizational Development 2,103.37 **
Infrastructure Development - **
Workforce Development **
5,554.20
Year to Date Expenditures by Obiect:
Board Stipends (1,085.00)
Staff Salaries -
Workers Comp Premium -
Office Supplies -
Software Support (529.52)
Municipal Development Group (4,815.51)
Legal /Engineering Fees (391.50)
Telephone (128.13)
Postage -
Business Luncheon -
Advertising (375.81)
Recording Fee -
Rentals (Postage Machine) -
St. Cloud EDA Membership Dues -
EDA Programs (362.88)
Total Expenses (7,688.35)
Fund Summaries as of January 31, 2011:
EDA Fund Balance - Fund 150 - unaudited 41,993.69
Designated for Capital Programs 3,763.30
Designated for DEED Housing Projects 16,368.57
Undesignated 21,861.82
TIF 1-4 St. Joseph Development Fund Balance - Fund 156 (1,950.85)
TIF 2 -1 Millstream Shops and Lofts Fund Balance - Fund 157 5,986.78
TIF 2 -2 St. Joseph Meat Market Fund Balance - Fund 158 (296.74)
Revolving Loan Fund Balance - Fund 250 15,573.11
** Detail available upon request
Page 14 of 36
r CITY OF ST JOSEPH 03/21/12 8:49 AM
g
'� EDA Balance Sheet Pa e 1
Current Period: February 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 $99.55 $7,688.35 $43,739.62
Economic Development G 150 -10450 Interest Receivable $33.58 $0.00 $0.00 $33.58
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 $0.00 $0.00 - $4,079.51
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 $7,688.35 $99.55 - $21,861.82
FUND 150 Economic Development $0.00 $7,787.90 $7,787.90 $0.00
FUND 156 TIF 1 -4 St. Ice Development
TIF 1-4 St. Joe Develop G 156 -10100 Cash $17.95 $0.00 $9.17 $8.78
TIF 1-4 St. Joe Develop G 156 -10450 Interest Receivable $40.37 $0.00 $0.00 $40.37
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 $9.17 $0.00 $1,950.85
FUND 156 TIF 1 -4 St. Ice Development $0.00 $9.17 $9.17 $0.00
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream G 157 -10100 Cash $8,443.84 $60.24 $1,284.90 $7,219.18
TIF 2 -1 Millstream G 157 -10450 Interest Receivable $10.02 $0.00 $0.00 $10.02
TIF 2 -1 Millstream G 157 -13113 Due From other Gov t Units $42.48 $0.00 $0.00 $42.48
TIF 2 -1 Millstream G 157 -20200 Accounts Payable - $1,284.90 $0.00 $0.00 - $1,284.90
TIF 2 -1 Millstream G 157 -25310 Appropriated Fund Balance - $7,211.44 $1,284.90 $60.24 45,986.78
FUND 157 TIF 2 -1 Millstream $0.00 $1,345.14 $1,345.14 $0.00
FUND 158 TIF 2 -2 Meat Market
TIF 2 -2 Meat Market G 158 -10100 Cash $3.26 $0.00 $0.00 $3.26
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 $0.00 $0.00 $296.74
FUND 158 TIF 2 -2 Meat Market $0.00 $0.00 $0.00 $0.00
FUND 250 Revolving Loan Fund
Revolving Loan Fund G 250 -10100 Cash $14,158.07 $1,381.09 $0.00 $15,539.16
Revolving Loan Fund G 250 -10450 Interest Receivable $33.95 $0.00 $0.00 $33.95
Revolving Loan Fund G 250 -11900 Notes Receivable $43,017.08 $0.00 $0.00 $43,017.08
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 $0.00 $0.00 - $43,017.08
Revolving Loan Fund G 250 -25310 Appropriated Fund Balance - $14,192.02 $0.00 $1,381.09 - $15,573.11
FUND 250 Revolving Loan Fund $0.00 $1,381.09 $1,381.09 $0.00
$0.00 $10,523.30 $10,523.30 $0.00
Page 15 of 36
r CITY OF ST JOSEPH 03/21/12 8:52 AM
`�� -'�� ' EDA Expenditure Report Page 1
Current Period: February 2012
2012 February 2012
Account Descr YTD Budget 2012 Amt YTD Amt
FUND 150 Economic Development
E 150 -46500 -103 Legislative Bodies $1,390.00 $0.00 $1,085.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 $0.00
E 150 -46500 -215 Software Support $540.00 $0.00 $529.52
E 150-46500 -300 Professional Services $28,000.00 $2,506.34 $4,815.51
E 150 - 46500-303 Engineering Fee $2,000.00 $0.00 $0.00
E 150 - 46500 -304 Legal Fees $1,000.00 $391.50 $391.50
E 150 -46500 -321 Telephone $785.00 $64.41 $128.13
E 150 -46500 -322 Postage $350.00 $0.00 $0.00
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 $375.81
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 $56.91 $362.88
E 150- 46500 -622 TIF /Abatement Payments $0.00 $0.00 $0.00
FUND 150 Economic Development $70,725.00 $3,019.16 $7,688.35
FUND 156 TIF 1-4 St. Joe Development
E 156 -46500 -101 Salaries $0.00 $0.00 $0.00
E 156 -46500 -121 PERA Contributions $0.00 $0.00 $0.00
E 156 -46500 -122 FICA Contributions $0.00 $0.00 $0.00
E 156 -46500 -123 Deferred Comp - Employer $0.00 $0.00 $0.00
E 156 - 46500 -125 Medicare Contributions $0.00 $0.00 $0.00
E 156-46500 -131 Health Insurance $0.00 $0.00 $0.00
E 156 -46500 -133 Life Insurance $0.00 $0.00 $0.00
E 156 - 46500 -134 Disabilty Insurance $0.00 $0.00 $0.00
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 $0.00 $0.00
FUND 156 TIF 1-4 St. Joe Development $0.00 $0.00 $0.00
FUND 157 TIF 2 -1 Millstream
E 157 -46500 -101 Salaries $0.00 $0.00 $0.00
E 157 -46500 -121 PERA Contributions $0.00 $0.00 $0.00
E 157 - 46500 -122 FICA Contributions $0.00 $0.00 $0.00
E 157 -46500 -123 Deferred Comp - Employer $0.00 $0.00 $0.00
E 157 -46500 -125 Medicare Contributions $0.00 $0.00 $0.00
E 157 -46500 -131 Health Insurance $0.00 $0.00 $0.00
E 157 -46500 -133 Life Insurance $0.00 $0.00 $0.00
E 157 - 46500 -134 Disabilty Insurance $0.00 $0.00 $0.00
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 $1,284.90 $1,284.90
E 157 -49300 -720 Transfers to Other Funds $0.00 $0.00 $0.00
FUND 157 TIF 2 -1 Millstream $0.00 $1,284.90 $1,284.90
FUND 158 TIF 2 -2 Meat Market
Page 16 of 36
( CITY OF ST JOSEPH 03/21/12 8:52 AM
{�� J _. Page 2
/ A
EDA Expenditure Report
Current Period: February 2012
2012 February 2012
Account Descr YTD Budget 2012 Amt YTD Amt
E 158 -46500 -101 Salaries $0.00 $0.00 $0.00
E 158 -46500 -121 PERA Contributions $0.00 $0.00 $0.00
E 158 -46500 -122 FICA Contributions $0.00 $0.00 $0.00
E 158 -46500 -123 Deferred Comp - Employer $0.00 $0.00 $0.00
E 158 - 46500 -125 Medicare Contributions $0.00 $0.00 $0.00
E 158 -46500 -131 Health Insurance $0.00 $0.00 $0.00
E 158 - 46500 -133 Life Insurance $0.00 $0.00 $0.00
E 158 -46500 -134 Disabilty Insurance $0.00 $0.00 $0.00
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 $0.00 $0.00
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 $4,304.06 $8,973.25
Page 17 of 36
(i CITY OF ST JOSEPH 03/21/12 8:52 AM
„If I fl.A 1
EDA Rev enue Report Page 1
Current Period: February 2012
2012 February 2012
FUND Descr SOURCE SOURCE Descr ¥TD Budget 2012 Amt YTD Amt
FUND 150 Economic Development
Economic Development 31010 Current Ad Valorem Taxes $70,500.00 $0.00 $0.00
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 Eamings $225.00 $45.05 $99.55
Economic Development 39201 Transfers from Other Funds $0.00 $0.00 $0.00
FUND 150 Economic Development $70,725.00 $45.05 $99.55
FUND 156 TIF 1-4 St. Joe Development
TIF 1-4 St. Joe Development 31050 Tax Increment $0.00 $0.00 $0.00
TIF 1-4 St. Joe Development 36210 Interest Earnings $0.00 -$3.18 -$9.17
FUND 156 TIF 1-4 St. Joe Development $0.00 -$3.18 -$9.17
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream 31050 Tax Increment $0.00 $0.00 $42.48
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 Eamings $0.00 $7.92 $17.76
FUND 157 TIF 2 -1 Millstream $0.00 $7.92 $60.24
FUND 250 Revolving Loan Fund
Revolving Loan Fund 36210 Interest Eamings $300.00 $14.58 $33.99
Revolving Loan Fund 39320 Revolving Loan Principal $6,885.00 $567.42 $1,133.43
Revolving Loan Fund 39321 Revolving Loan Interest $1,195.00 $106.13 $213.67
Revolving Loan Fund 39322 Revolving Loan Origination $0.00 $0.00 $0.00
FUND 250 Revolving Loan Fund $8,380.00 $688.13 $1,381.09
$79,105.00 $737.92 $1,531.71
Page 18 of 36
O V1 01 N O .O ct 01 '7 a
V p • r- 00 N O V 1� • a p 8
Q 0 0 m co to 0 O m M O
G O N =: N ct to u1 u1 n
ei o
O • u1 Na
to
a
a 0
d u o
12
: E w N o1 .1 n a v o0 00
0) O N O O C 00 00 00
O1 \ . , N
a
CD 0 /3 Q w N L No. at t-I C e4 N 00 , N 1 M .M
x i
a O0 a O
E o co c,nN
co a a, LL
u 10 . 4- tz
N U c O N
O '0 CO ......'4 N a N
N C CJ 7 C N
76 fo 2 I
C
t., .
, ;8;88 ' 8' 8
N., � § fig g
ID O c a-i . tD 00 N N N
CO
N
..
v■I 8 in O `r,D O q 1D Q1 M M
� O)
N ,p j O 1 N e-1 C tf1 Vl et M m
to O1 A O N a W O
iI Lr1 t W 0 O
rl g N r1 4 V l0 N N N M co
eft Q ce m N 0)
N M
M
M
0 Ea
E x'E
0a�
£ v F2 nC2 • o o E c o
W T 13 0(1 1 1 M
° 2k2mo
N m
E C '� o Q c 5
U _
' T '` -k 4 5 ; s..�4 ,'-"' " y g -' .,fitt,,;
v N o
u ° d 6
e cr
a ,l 'Al
a _
r V
e Q
0
V, w
G. a. < Q H
G w w 0 1