HomeMy WebLinkAbout[05] Accounts Payable & Financial ReportCITY OF ST. JOSEPH
VVV. cityofstjoscph.com
DATE: April 20, 2011
MEMO TO: St. Joseph Economic Development Authority
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 8 of 27
FROM: Cynthia Smith- Strack, Municipal Development Group
Administrator
Judy Weyrens
RE: Accounts Payable — April
March 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. Mar. Econ. Dev. Service 150 -46500 -300 $ 2,676.85
Dale Wick
Total $ 2,676.85
EDA
Carolyn Yaggie-
Action:
Heinen
A MOTION is in order to approve the Accounts Payable.
Chad Davey
Al Rassier
Tom Skahen
B. Financial Report:
Dale Wick
March 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 8 of 27
ae%
MUNICIPAL DEVELOPMENT GROUP, INC.
25562 WILLOW LANE
NEW PRAGUE, MN 56071
952 - 758 -7399
FAX: 952 - 758 -3711
staff @municipaidevelopmentgroup.com
INVOICE
City of St. Joseph
Attn: Judy Weyrens
City Administrator
PO 668
St. Joseph, MN 56374
Invoice Date 4 -10 -11
Payment Terms: 30 days
Customer ID #:
ISTJ10EDA
Project March Economic Development Services
See attached detail
Amount: $2,200.00 Monthly contract fee
476.85 935 miles x .51
$2,676.85
Code to: 150 -46500 -300 for general EDA
Remit To: Municipal Development Group, Inc.
25562 Willow Lane
New Prague, MN 56071
Dates -EDA
Hours
March 2, 2011 EDA Office Hours: C. Strack
8.00 Hour
March 9, 2011 EDA Office Hours: C. Strack
8.00 Hour
March 16, 2011 EDA Office Hours: C. Strack
8.00 Hour
March 23, 2011 EDA Office Hours: C. Strack
7.00 Hour
March 30, 2011 EDA Office Hours: C. Strack
9.00 Hour
March 31, 2011 Attend workshop with Council
2.50 Hour
Total March 2011
42.50 Hour
Total Contract Hours Thru March 31, 2011: 117.50 Hours
Check No.
Date:
Thank youl We appreciated the opportunity to work with youl
Page 9 of 27
Principal
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
March 2011
Fund 150, EDA Balance as of December 31, 2010 (unaudited)
Year to Date Revenue:
Interest Earnings
Transfers from the City's General Fund
Total Revenue
Y_ ear to Date Expenditure Total by Project:
Market Development
Business Development
Organizational Development
Infrastructure Development
Workforce Development
Year to Date Expenditures by Object:
Board Stipends
Staff Salaries
Workers Comp Premium
Office Supplies
Software Support
Municipal Development Group
Legal /Engineering Fees
Telephone
Postage
Business Luncheon
Advertising
Recording Fee
Rentals (Postage Machine)
St. Cloud EDA Membership Dues
EDA Programs
Total Expenses
Fund Summaries as of December 31, 2010:
1.42
438.26 **
3,714.19
981.27 **
211.45
5,345.17
EDA Fund Balance - Fund 150 - unaudited
Designated for Capital Programs
Undesignated
TIF 1-4 St. Joseph Development Fund Balance - Fund 156
TIF 2 -1 Millstream Shops and Lofts Fund Balance - Fund 157
Revolving Loan Fund Balance - Fund 250
** Detail available upon request
Page 11 of 27
0.52
(21.32)
(529.52)
(2,997.67)
(96.00)
(189.79)
(2,251.50)
5,162.57
1.42
(6,085.28)
(921.29)
5,162.57
(6,083.86)
41,790.14
4,037.04
35,721.27
r'
Ir"dI ..'
CITY OF ST JOSEPH
EDA Balance Sheet
Current Period: March 2011
04/15/119:07 AM
Page 1
FUND 156 TIF 1-4 St. Joe Development
TIF 1-4 St. Joe Develop
G 156 -10100 Cash
$41,593.09
YTD
YTD
Current
FUND Descr
Account Descr
Begin Yr
Debit
Credit
Balance
FUND 150 Economic Development
G 156 -25310 Appropriated Fund Balance
- $41,698.76
$115.50
$206.88
Economic Development
G 150 -10100 Cash
$8,841.22
$35.93
$9,798.44
- $921.29
Economic Development
G 150 -10450 Interest Receivable on Invest.
$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
$9,829.71
$3,745.85
$6,083.86
FUND 150 Economic Development
$0.00
$13,575.56
$13,575.56
$0.00
FUND 156 TIF 1-4 St. Joe Development
TIF 1-4 St. Joe Develop
G 156 -10100 Cash
$41,593.09
$206.88
$9.83
$41,790.14
TIF 1-4 St. Joe Develop
G 156 -10450 Interest Receivable on Invest.
$105.67
$0.00
$105.67
$0.00
TIF 1-4 St. Joe Develop
G 156 -25310 Appropriated Fund Balance
- $41,698.76
$115.50
$206.88
- $41,790.14
FUND 156 TIF 1-4 St. Joe Development
$0.00
$322.38
$322.38
$0.00
FUND 157 TIF 24 Millstream
TIF 2 -1 Millstream
G 157 -10100 Cash
$4,020.96
$16.80
$0.72
$4,037.04
TIF 2 -1 Millstream
G 157 -10450 Interest Receivable on Invest.
$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
$5.54
$16.80
- $4,037.04
FUND 157 TIF 2 -1 Millstream
$0.00
$22.34
$22.34
$0.00
FUND 158 TIF 2 -2 Meat Market
TIF 2 -2 Meat Market
G 158 -10100 Cash
$0.00
$0.00
$0.00
$0.00
TIF 2 -2 Meat Market
G 158 -25310 Appropriated Fund Balance
$0.00
ry
$0.00 _..
$0.00
_._. y5$0.00
_...._., $0.00
FUND 158 TIF 2 -2 Meat Market
$0.00.,
$0.00
$0.00
FUND 250 Revolving Loan Fund
Revolving Loan Fund
G 250 -10100 Cash
Revolving Loan Fund
G 250 -10450 Interest Receivable on Invest.
Revolving Loan Fund
G 250 -11900 Notes Receivable
Revolving Loan Fund
G 250 -20200 Accounts Payable
Revolving Loan Fund
G 250 -22204 Deferred Revenue
Revolving Loan Fund
G 250 -25310 Appropriated Fund Balance
FUND 250 Revolving Loan Fund
$34,565.78 $1,163.86 $8.37
$89.51 $0.00 $89.51
$20,715.08 $0.00 $20,715.08
$0.00 $0.00 $0.00
- $20,715.08 $20,715.08 $0.00
- $34,655.29 $97.88 $1,163.86
$0.00 $21,976.82 $21,976.82
$0.00 $35,897.10 $35,897.10
Page 12 of 27
$35,721.27
$0.00
$0.00
$0.00
$0.00
- $35,721.27
$0.00
$0.00
I
� ! I" l._.
CITY OF ST JOSEPH
EDA Expenditure Report
Current Period: March 2011
FUND 150 Economic Development $83,990.00
FUND 156 TIF 1-4 St. Joe Development
March 2011
2011 Amt YTD Amt
$0.00
2011
Account Descr
YTD Budget
FUND 150 Economic Development
$21.32
E 150 -46500 -103 Legislative Bodies
$1,390.00
E 150 -46500 -151 Workers Comp. Insur. Prem.
$150.00
E 150 -46500 -200 Office Supplies
$500.00
E 150 - 46500 -215 software support
$450.00
E 150 -46500 -300 Professional Services
$28,000.00
E 150 -46500 -303 Engineering Fee
$2,000.00
E 150 -46500 -304 Legal Fees
$1,000.00
E 150 -46500 -321 Telephone
$1,200.00
E 150 -46500 -322 Postage
$350.00
E 150 -46500 -331 Travel & Conference Expense
$150.00
E 150 -46500 -340 Advertising
$500.00
E 150 - 46500 -410 Rentals
$0.00
E 150 - 46500 -433 Dues & Memberships
$8,000.00
E 150 - 46500 -434 Certification Fee
$0.00
E 150 - 46500 -582 Computer Software
$300.00
E 150 - 46500 -588 EDA Programs
$40,000.00
FUND 150 Economic Development $83,990.00
FUND 156 TIF 1-4 St. Joe Development
March 2011
2011 Amt YTD Amt
$0.00
$0.00
$0.00
-$0.52
$0.00
$21.32
$0.00
$529.52
$1,054.30
$2,997.67
$0.00
$96.00
$0.00
$0.00
$65.29
$189.79
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$1,574.87
$2,251.50
$2,694.46 $6,085.28
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 -130 Health Ins - Deductible
$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 -136 Fringe Benefits- Employee
$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 -622 Tax Increment 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 -130 Health Ins - Deductible
$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 -136 Fringe Benefits - Employee
$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 Tax Increment Payments
$0.00
$0.00
$0.00
E 157 -49300 -720 Transfers to Other Funds
$0.00
$0.00
$0.00
FUND 157 TIF 2 -1 Millstream
$0.00
$0.00
$0.00
FUND 158 TIF 2 -2 Meat Market
E 158-46500 -300 Professional Services
$0.00
$0.00
$0.00
E 158-46500 -340 Advertising
$0.90
$0.00
$0.00
Pagel of 27
04/14/11 11:24 AM
Page 1
r' CITY OF ST JOSEPH 04/14/11 11:24 AM
Page 2
EDA Expenditure Report
Current Period: March 2011
2011 March 2011
Account Descr YTD Budget 2011 Amt YTD Amt
E 158 -46500 -622 Tax Increment 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
$83,990.00 $2,694.46 $6,085.28
Page 14 of 27
r' CITY OF ST JOSEPH 04/14/11 11:24 AM
4-1J � Page 1
EDA Revenue Report
Current Period: March 2011
FUND Descr
SOURCE
SOURCE Descr
FUND 150 Economic Development
2011 Amt
YTD Amt
Economic Development
34150
TIF /MIF Deposit
Economic Development
36210
Interest Earnings
Economic Development
39201
Transfers from Other Funds
FUND 150 Economic Development
$0.00
FUND 156 TIF 1 -4 St. Joe Development
$12.70
TIF 1 -4 St. Joe Development
31050
Tax Increment
TIF 1 -4 St. Joe Development
36210
Interest Earnings
FUND 156 TIF 1-4 St. Joe Development
$104.67
FUND 157 TIF 2 -1 Millstream
$0.00
TIF 2 -1 Millstream
31050
Tax Increment
TIF 2 -1 Millstream
33404
Market Value Credit
TIF 2 -1 Millstream
34150
TIF /MIF Deposit
TIF 2 -1 Millstream
36210
Interest Earnings
FUND 157 TIF 2 -1 Millstream
$0.00
FUND 250 Revolving Loan Fund
$8.70
$11.26
Revolving Loan Fund
36210
Interest Earnings
Revolving Loan Fund
39320
Revolving Loan Principal
Revolving Loan Fund
39321
Revolving Loan Interest
Revolving Loan Fund
39322
Revolving Loan Origination
FUND 250 Revolving Loan Fund
$0.00
$49.70
2011
March
2011
YTD Budget
2011 Amt
YTD Amt
$0.00
$0.00
$0.00
$150.00
$12.70
$1.42
$83,840.00
$0.00
$0.00
$83,990.00
$12.70
$1.42
$0.00
$0.00
$0.00
$0.00
$104.67
$91.38
$0.00
$104.67
$91.38
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$8.70
$11.26
$0.00
$8.70
$11.26
$0.00
$87.82
$75.98
$0.00
$280.30
$837.42
$0.00
$49.70
$152.58
$0.00
$0.00
$0.00
$0.00
$417.82
$1,065.98
$83,990.00
$543.89
$1,170.04
Page 15 of 27
ti
M
C
C
3 V) N
O
L
O
O O O O
z N
0
W 0
p
a
N
a
- 0
O
a a`
fn
C
en
o
C>
O
Gl O -O a--I
O m
m
x a ai
l7
W E
U
O
y '6 m
r1 4!
m
c d U
c d
�o c
•O O
•-
n ' Z m
N a
o
-_
N 3 CO
a
3 N
U d m
U n
V
G1 H
o
I- m C(1 n
LD O V1
Dl
W
N
o
Ln N N Dl
v It Ln
a
v
CC)
a
In
3
m
V
ON
Ln N
N
O
�••�
C
C� N
rl
Ln w .--I
L/1
W �
lD
W
N
N
N f0
O
O
N
In
LO
ti
M
C
C
3 V) N
O
L
O
O O O O
O
0
W 0
p
a
N
O
O O O O
O
a a`
fn
C
en
o
C>
O
Gl O -O a--I
O m
m
x a ai
l7
W E
U
O
y '6 m
r1 4!
m
d d
m 0
�o c
•O O
•-
n ' Z m
N a
C 7
O
N 3 CO
a
3 N
N
V
G1 H
c c c
C11
C>
y O
W
N
ti
M
C
C
3 V) N
O
L
a�
Z
N
L
O
U
C
3
O
V
a
a
o„
a a
a
0
ii
O M Ol n V O V1 00
O I� N C1 LIl lD V �n
lD O .1 N N .--I lD
v v tD m o Ln v
N v �
O On O O I.
Ln v Ln o a
O II Ln O O O O O I Ln
C) c 0 c 0 l l o
N v
N
C c
00 �
O0
V r
C E
0
W 0
p
a
N
it
V) 0
C N
10
p
a a`
fn
C
en
o
C>
N
Gl O -O a--I
O m
m
x a ai
l7
W E
U
O
y '6 m
r1 4!
m
d d
m 0
�o c
U W
-4 l.7 '"
G V a
•-
n ' Z m
N a
C 7
O
N 3 CO
LL C1
m U
o
G1 H
c c c
C
C>
y O
W
N
N
w
E
CC)
a
In
3
Q
W
a�
Z
N
L
O
U
C
3
O
V
a
a
o„
a a
a
0
ii
O M Ol n V O V1 00
O I� N C1 LIl lD V �n
lD O .1 N N .--I lD
v v tD m o Ln v
N v �
O On O O I.
Ln v Ln o a
O II Ln O O O O O I Ln
C) c 0 c 0 l l o
N v
N
C c
Q a
w w
N
a)
03
p U C
a C: o
C ,o U
p N O
> U
C O co
@ _U N
(7 to 2
U- m CO
c X U
M V In
O O O
c o o
w W W
a
U
a
0
w
F
O
F
N
O
CD
N
m
(6
a
N -
E o
m
3
n N
p
C
3
O U
o
0
a
O
O
O
U
U
CL
E
cn
c
LL O
p
U
O
c 1- CL
r
N
O
O
3 3 3
o
C
c c c
W
W
N
co
CC)
CC)
In
L9
O
O
O
O
LO
LO
(D
(D
V
V
O
O
In
In
Q a
w w
N
a)
03
p U C
a C: o
C ,o U
p N O
> U
C O co
@ _U N
(7 to 2
U- m CO
c X U
M V In
O O O
c o o
w W W
a
U
a
0
w
F
O
F
N
O
CD
N
m
(6
a