HomeMy WebLinkAbout[05] Accounts Payable & Financial Report •
CITY OF ST. JOSEPH
vvv.cityoistjoseph.com
DATE: January 18, 2012
MEMO TO: St. Joseph Economic Development Authority
FROM: Cynthia Smith - Strack, Municipal Development Group
Administrator
Judy Weyrens RE: Accounts Payable — December & January
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. Nov. Econ. Dev. Service 150 -46500 -300 $ 2,718.93
Dale Wick MDG, Inc. Dec. Econ. Dev. Service 150 - 46500 -300 $ 2,615.14
Total $ 5,334.07
EDA
Carolyn Yaggie—
Heinen Action:
Chad Davey A MOTION is in order to approve the Accounts Payable.
Steve Frank
Tom Skahen
Dale Wick B. Financial Report:
September 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.
6•4 INVOICE
MUNICIPAL DEVELOPMENT GROUP, INC.
25562 WILLOW LANE
NEW PRAGUE, MN 56071 City 0 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 1 -10 -12 Payment Terms: 30 days Customer ID #:
STJ 10EDA
Project December Economic Development Services
See attached detail
Amount: $2,200.00 Monthly contract fee
$ 615.14 748 miles x .555
$2,615.14
Code to: 150 -46500 -300 for general EDA
Remit To: Municipal Development Group, Inc.
25562 Willow Lane
New Prague, MN 56071
Dates -EDA Hours
December 7, 2011 EDA Office Hours: C. Strack 8.00 Hours
December 14, 2011 EDA Office Hours: C. Strack 8.00 Hours
December 21, 2011 EDA Office Hours: C. Strack 7.50 Hours
December 28, 2011 EDA Office Hours: C. Strack 7.00 Hours
December 29, 2011 EDA Office Hours: C. Strack 1.75 Hours
Total December 2011 32.25 Hours
Total Contract Hours December 31, 201 443 Hours
Thank you! We appreciated the opportunity to work with you!
a .. / Z AA
Check No.
Date: Prin ipal
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 12 - 10 - 11 I Payment Terms: 30 days Customer ID #:
STJI OEDA
Project November Economic Development Services
See attached detail
Amount: $2,200.00 Monthly contract fee
$ 518.93 935 miles x .555
$2,718.93
Code to: 150 -46500 -300 for general EDA
Remit To: Municipal Development Group, Inc.
25562 Willow Lane
New Prague, MN 56071
Dates -EDA Hour -
November 2, 2011 EDA Office Hours: C. Strack 8.00 Hour
November 9, 2011 EDA Office Hours: C. Strack 8.00 Hour
November 16, 2011 EDA Office Hours: C. Strack 8.00 Hour
November 23, 2011 EDA Office Hours: C. Strack 5.00 Hour
November 30, 2011 EDA Office Hours: C. Strack 8.75 Hour
Total November 2011 37.75 Hou -
Total Contract Hours November 30, 2011: 410.75 Hours
Thank you! We appreciated the opportunity to work with you!
Check No. '
Date: Principal
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
December 31, 2011
Fund 150, EDA Balance as of December 31, 2010 (Audited) 5,162.57
Year to Date Revenue:
Interest Earnings 289.16
DEED Housing Reimbursement 16,368.57
Transfers from the City's General Fund 133,840.00
Total Revenue 150,497.73
Year to Date Expenditure Total by Proiect:
Market Development 2,129.13 **
Business Development 39,502.32 **
Organizational Development 3,730.93 **
Infrastructure Development 1,509.18 **
Workforce Development - **
46,871.56
Year to Date Expenditures by Obiect:
Board Stipends -
Staff Salaries -
Workers Comp Premium 0.76
Office Supplies (63.83)
Software Support (529.52)
Municipal Development Group (14,062.58)
Legal /Engineering Fees (3,123.54)
Telephone (765.72)
Postage -
Business Luncheon -
Advertising (88.89)
Recording Fee -
Rentals (Postage Machine) -
St. Cloud EDA Membership Dues -
Coborn's Abatement Payment (50,000.00)
EDA Programs (33,398.56)
Total Expenses (102,031.88)
Fund Summaries as of December 31, 2011:
EDA Fund Balance - Fund 150 - (Unaudited) 53,628.42
Designated for Capital Programs 3,763.30
Designated for DEED Housing Projects 16,368.57
Undesignated 33,496.55
TIF 1-4 St. Joseph Development Fund Balance - Fund 156 (1,982.05)
TIF 2 -1 Millstream Shops and Lofts Fund Balance - Fund 157 8,443.84
TIF 2 -2 St. Joseph Meat Market Fund Balance - Fund 158 (296.74)
Revolving Loan Fund Balance - Fund 250 14,158.07
** Detail available upon request
r � CITY OF ST JOSEPH 01/18/12 8:40 A
eM
EDA Balance Sheet g
,ft(011 Irl_Ai,ee'S . Current Period: December 2011
YTD YTD Current
FUND Descr Account Descr Begin Yr Debit Credit Balance
FUND 150 Economic Development
Economic Development G 150 -10100 Cash $8,841.22 .163,521.94 .118,734.74 $53,628.42
Economic Development G 150 -10450 Interest Receivable $31.27 $0.00 $31.27 $0.00
Economic Development G 150 -20200 Accounts Payable ($3,709.92) $3,709.92 $0.00 $0.00
Economic Development G 150 -24415 Design. Fd Bal - Capital Proj ($5,162.57) $0.00 $0.00 ($5,162.57)
Economic Development G 150 -25310 Appropriated Fund Balance $0.00 .118,766.01 .167,231.86 ($48,465.85)
$0.00 285,997.87 285,997.87 $0.00
FUND 156 TIF 1 -4 St. Toe Development
TIF 1 -4 St. Joe Develop G 156 -10100 Cash $41,593.09 $67,137.79 .110,712.93 ($1,982.05)
TIF 1 -4 St. Joe Develop G 156 -10450 Interest Receivable $105.67 $0.00 $105.67 $0.00
TIF 1 -4 St. Joe Develop G 156 -25310 Appropriated Fund Balance ($41,698.76) .110,818.60 $67,137.79 $1,982.05
$0.00 .177,956.39 .177,956.39 $0.00
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream G 157 -10100 Cash $4,020.96 $38,765.18 $34,342.30 $8,443.84
TIF 2 -1 Millstream G 157 -10450 Interest Receivable $4.82 $0.00 $4.82 $0.00
TIF 2 -1 Millstream G 157 -20200 Accounts Payable $0.00 $0.00 $0.00 $0.00
TIF 2 -1 Millstream G 157 -25310 Appropriated Fund Balance _ ($4,025.78) $34,347.12 $38,765.18 ($8,443.84)
$0.00 $73412.30 $73,112.30 $0.00
FUND 158 TIF 2 -2 Meat Market
TIF 2 -2 Meat Market G 158 -10100 Cash $0.00 $11,204.94 $11,501.68 ($296.74)
TIF 2 -2 Meat Market G 158 -25310 Appropriated Fund Balance $0.00 $11,501.68 $11,204.94 $296.74
$0.00 $22,706.62 $22,706.62 $0.00
FUND 250 Revolving Loan Fund
Revolving Loan Fund G 250 -10100 Cash $34,565.78 $6,004.33 $26,412.04 $14,158.07
Revolving Loan Fund G 250 -10450 Interest Receivable $89.51 $0.00 $89.51 $0.00
Revolving Loan Fund G 250 -11900 Notes Receivable $20,715.08 $0.00 $20,715.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 ($20,715.08) $20,715.08 $0.00 $0.00
Revolving Loan Fund G 250 -25310 Appropriated Fund Balance ($34,655.29) $26,501.55 $6,004.33 ($14,158.07)
$0.00 $53,220.96 $53,220.96 $0.00
$0.00 612,994.14 612,994.14 $0.00
�i C ITY OF ST JOSEPH 01/18/12 8:40 g M
EDA Expenditure Report y , Current Period: December 2011
2011 December 2011
Account Descr YTD Budget 2011 Amt YTD Amt
FUND 150 Economic Development
E 150 - 46500 -103 Legislative Bodies $1,390.00 $0.00 $0.00
E 150 - 46500 -151 Workers Comp. Insur. Prem. $150.00 ($2.51) ($0.76)
E 150 - 46500 -200 Office Supplies $500.00 $0.00 $63.83
E 150 - 46500 -215 Software Support $450.00 $0.00 $529.52
E 150 - 46500 -300 Professional Services $30,500.00 $1,690.78 $14,062.58
E 150 - 46500 -303 Engineering Fee $2,000.00 $0.00 $1,947.04
E 150 - 46500 -304 Legal Fees $1,000.00 $0.00 $1,176.50
E 150 - 46500 -321 Telephone $1,200.00 $63.51 $765.72
E 150 - 46500-322 Postage $350.00 $0.00 $0.00
E 150 -46500 -328 Marketing $0.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 $88.89
E 150 -46500 -410 Rentals $0.00 $0.00 $0.00
E 150 - 46500 -433 Dues & Memberships $5,500.00 $0.00 $0.00
E 150 -46500 -434 Certification Fee $0.00 $0.00 $0.00
E 150-46500 -582 Computer Software $300.00 $0.00 $0.00
E 150 -46500 -588 EDA Programs $40,000.00 $2,023.15 $33,398.56
E 150 - 46500 -622 TIF /Abatement Payments $0.00 $50,000.00 $50,000.00
$83,990.00 $53,774.93 $102,031.88
FUND 156 TIF 1-4 St. Joe Development
E 156 - 46500-101 Salaries $0.00 $0.00 $322.29
E 156 -46500 -121 PERA Contributions $0.00 $0.00 $23.38
E 156 -46500 -122 FICA Contributions $0.00 $0.00 $19.07
E 156 - 46500 -123 Deferred Comp- Employer $0.00 $0.00 $5.78
E 156 -46500 -125 Medicare Contributions $0.00 $0.00 $4.46
E 156- 46500 -131 Health Insurance $0.00 $0.00 $52.41
E 156 - 46500 -133 Life Insurance $0.00 $0.00 $0.69
E 156 -46500 -134 Disabilty Insurance $0.00 $0.00 $3.60
E 156 - 46500 -300 Professional Services $0.00 $0.00 $3,371.00
E 156 - 46500 -340 Advertising $0.00 $0.00 $98.34
E 156 -46500 -588 EDA Programs $0.00 $0.00 $47,000.00
E 156 - 46500 -622 TIF /Abatement Payments $0.00 $29,873.24 $59,746.48
$0.00 $29,873.24 $110,647.50
FUND 157 TIF 2 -1 Millstream
E 157 - 46500 -101 Salaries $0.00 $0.00 $253.46
E 157 - 46500 -121 PERA Contributions $0.00 $0.00 $18.38
E 157 - 46500 -122 FICA Contributions $0.00 $0.00 $14.99
E 157 - 46500 -123 Deferred Comp- Employer $0.00 $0.00 $4.54
E 157- 46500 -125 Medicare Contributions $0.00 $0.00 $3.51
E 157 - 46500 -131 Health Insurance $0.00 $0.00 $43.44
E 157 - 46500 -133 Life Insurance $0.00 $0.00 $0.53
E 157- 46500 -134 Disabilty Insurance $0.00 $0.00 $3.07
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 $32.34
E 157 - 46500 -622 TIF /Abatement Payments $0.00 $12,728.19 $33,950.99
E 157 - 49300 -720 Transfers to Other Funds $0.00 $0.00 $0.00
$0.00 $12,728.19 $34,325.25
01/18/12 8:40 AM
2011 December 2011 Page 2
Account Descr YTD Budget 2011 Amt YTD Amt
FUND 158 TIF 2 -2 Meat Market
E 158- 46500 -101 Salaries $0.00 $0.00 $17.58
E 158 - 46500 -121 PERA Contributions $0.00 $0.00 $1.27
E 158- 46500 -122 FICA Contributions $0.00 $0.00 $1.05
E 158 - 46500 -123 Deferred Comp- Employer $0.00 $0.00 $0.31
E 158 - 46500 -125 Medicare Contributions $0.00 $0.00 $0.25
E 158 - 46500 -131 Health Insurance $0.00 $0.00 $3.00
E 158 - 46500 -133 Life Insurance $0.00 $0.00 $0.03
E 158 - 46500 -134 Disabilty Insurance $0.00 $0.00 $0.25
E 158 - 46500 -300 Professional Services $0.00 $0.00 $108.00
E 158- 46500 -340 Advertising $0.00 $0.00 $165.00
E 158 - 46500 -622 TIF /Abatement Payments $0.00 $0.00 $0.00
$0.00 $0.00 $296.74
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 $54.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 $26,000.00
$0.00 $0.00 $26,054.00
$83,990.00 $96,376.36 $273,355.37
�I CITY OF ST JOSEPH 01/18/12 8:42 M
Page 1
/
EDA Revenue Report •
,, Current Period: December 2011
2011 December 2011
FUND Descr SOURCE SOURCE Descr YTD Budget 2011 Amt YTD Amt
FUND 150 Economic Development
Economic Development 31010 Current Ad Valorem Taxes $0.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 $16,368.57
Economic Development 36210 Interest Earnings $150.00 $72.45 $289.16
Economic Development 39201 Transfers from Other Funds $83,840.00 $77,840.00 $133,840.00
FUND 150 $83,990.00 $77,912.45 $150,497.73
FUND 156 TIF 1-4 St. Joe Development
TIF 1-4 St. Joe Development 31050 Tax Increment $0.00 $33,192.49 $66,384.98
TIF 1-4 St. Joe Development 36210 Interest Earnings $0.00 ($11.89) $581.71
FUND 156 $0.00 $33,180.60 $66,966.69
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream 31050 Tax Increment $0.00 $14,142.43 $37,723.32
TIF 2 -1 Millstream 33404 Market Value Credit $0.00 $912.00 $912.00
TIF 2 -1 Millstream 34150 TIF /MIF Deposit $0.00 $0.00 $0.00
TIF 2 -1 Millstream 36210 Interest Earnings $0.00 $13.70 $107.99
FUND 157 $0.00 $15,068.13 $38,743.31
FUND 250 Revolving Loan Fund
Revolving Loan Fund 36210 Interest Earnings $0.00 $29.44 $434.20
Revolving Loan Fund 39320 Revolving Loan Principal $0.00 $564.60 $3,698.70
Revolving Loan Fund 39321 Revolving Loan Interest $0.00 $108.95 $638.88
Revolving Loan Fund 39322 Revolving Loan Origination $0.00 $0.00 $785.00
FUND 250 $0.00 $702.99 $5,556.78
$83,990.00 $126,864.17 $261,764.51
N Z N C
N a O _ _ O
N d N N N J) N 4 fq fA
Y L N
N N O N E N
m E m
W III_ W •Vi l O W t0 1 p l0 N l0 z t
U U y g U 2 ..., m �_
O Z 0 'E T. E d E m_ W c d= 2 8
o i
U O d C7 O i o_ m1 M 2 U in 2 N u)
O m ii O r) r4 0, m M u,
r4 0 m 'O, Ii VI G ' N. N M tD n
01 0
N v 10( t) „in- 143 W to
N .�
ei N O 00 tD to .--1 N 1- N
M O O W ,..-1 r u1 t L 01 N
N a+ r O .--I O .--1 4 t!1 V 01 01
01
.c a - 0 0
'.0 V) .-I 1 N m • v l t0
m a " to 0 of ry oo m ,;r "
3 to N c-1 V er
O
i
Q O . en 0
W O N P ' ' ' 1 11 1 1 r 1 '
. N N \ ,1
O • N L r O
F. d 3 C N
d 4 ' e-1 ` O VI
3
6 * C N w p r (7
±' E u N
y a) e- N_ O .f O O O O O t '
tV
0. ` M N , , v O to O O O O O to t0
X O. Y a. a) co 01 0 N O IJ1 t!1 N N
W E O .D m i 01 f0 es;
.-1 V
— o E Na cc al
a=
a .�
'a a ' o a)
I')
a ° C m
N �m c c � , in
E
c 1 c o E o ° , o
a E m O ° u) c 8
CIJ • N 7 N N J>
: Q d C O M
O co to 8 m U N
S. W CD C7 m 2
E N ' t c Q
LL O
to .N Q
U -J m m H a m ct U
i •ifi i t za s - �r�
d 00 00
o 0 0
c
3 in ul
u CO 1
Q
t° 0 a
U
ti E 0
W
' t: J
s ) O O
W W H