HomeMy WebLinkAbout[04] Accounts Payable & Financial Report^ CITY OF ST. JOSEPH
WWW.cityof stjoseph.ccM
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 July 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.
DATE:
August 17, 2011
MEMO TO:
St. Joseph Economic Development Authority
FROM:
Cynthia Smith - Strack, Municipal Development Group
Administrator
Judy Weyrens
RE:
Accounts Payable — August
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,390.74
Dale Wick
Total
$ 2,390.74
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 July 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.
IVA
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 8 -10 -11
Payment Terms: 30 days
Customer ID #:
ISTJ10EDA
Project July Economic Development Services
See attached detail
Amount: $2,200.00 Monthly contract fee
190.74 374 miles x .51
$2,390.74
Code to: 150 -46500 -300 for general EDA
Remit To: Municipal Development Group, Inc.
25562 Willow Lane
New Prague, MN 56071
Dates -EDA
Hours
July 6, 2011 EDA Office Hours: C. Strack
6.00 Hour
July 13, 2011 EDA Office Hours: C. Strack
8.00 Hour
July 15, 2011 EDA Hours in MDG Office: C. Strack
2.25 Hour
July 19, 2011 EDA Hours in MDG Office: J. Anderson
2.50 Hour
July 20, 2011 EDA Hours in MDG Office: J. Anderson
5.00 Hour
July 21, 2011 EDA Hours in MDG Office: J. Anderson
2.50 Hour
July 21, 2011 EDA Hours in MDG (remote) Office: C. Strack
3.75 Hour
Total July 2011
30.00 Hours
Total Contract Hours July 31, 2011: 266.50 Hours
Check No.
Date:
Thank you! We appreciated the opportunity to work with youl
Principal
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
July 2011
Fund 150, EDA Balance as of December 31, 2010 (Audited) 5,162.57
Year to Date Revenue:
Interest Earnings 105.11
DEED Housing Reimbursement 16,368.57
Transfers from the City's General Fund 28,000.00
Total Revenue 44,473.68
Year to Date Expenditure Total by Proiect:
Market Development
1,304.38
**
Business Development
14,376.09
**
Organizational Development
2,430.29
**
Infrastructure Development
1,178.26
**
Workforce Development
-
**
19,289.02
Year to Date Expenditures by Object:
Board Stipends
-
Staff Salaries
-
Workers Comp Premium
0.52
Office Supplies
(63.83)
Software Support
(529.52)
Municipal Development Group
(7,478.21)
Legal /Engineering Fees
(1,619.14)
Telephone
(446.21)
Postage
-
Business Luncheon
-
Advertising
-
Recording Fee
-
Rentals (Postage Machine)
-
St. Cloud EDA Membership Dues
-
EDA Programs
(10,190.86)
Total Expenses
(20,327.25)
Fund Summaries as of July 31, 2011:
EDA Fund Balance - Fund 150 - (Unaudited) 29,309.00
Designated for Capital Programs 28,513.66
Designated for DEED Housing Projects 16,368.57
Undesignated (12,517.80)
TIF 1-4 St. Joseph Development Fund Balance - Fund 156
17,698.01
TIF 2 -1 Millstream Shops and Lofts Fund Balance - Fund 157
6,097.33
TIF 2 -2 St. Joseph Meat Market Fund Balance - Fund 158
(273.00)
Revolving Loan Fund Balance - Fund 250
12,081.10
** Detail available upon request
r'
CITY OF ST JOSEPH
EDA Balance Sheet
Current Period: July 2011
08/17/11 9:54 AM
Page 1
FUND 150 Economic Development
FUND 156 TIF 1-4 St Joe Development
TIF 1-4 St. Joe Develop G 156 -10100 Cash
TIF 1 -4 St. Joe Develop G 156 -10450 Interest Receivable
TIF 1 -4 St. Joe Develop G 156 -25310 Appropriated Fund Balance
FUND 156 TIF 1 -4 St. Joe Development
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream G 157 -10100 Cash
TIF 2 -1 Millstream G 157 -10450 Interest Receivable
TIF 2 -1 Millstream G 157 -20200 Accounts Payable
TIF 2 -1 Millstream G 157 -25310 Appropriated Fund Balance
FUND 157 TIF 2 -1 Millstream
FUND 158 TIF 2 -2 Meat Market
TIF 2 -2 Meat Market G 158 -10100 Cash
TIF 2 -2 Meat Market G 158 -25310 Appropriated Fund Balance
FUND 158 TIF 2 -2 Meat Market
FUND 250 Revolving Loan Fund
$0.00 $77,834.23 $77,834.23 $0.00
$41,593.09
$33,792.10
$57,687.18
YTD
YTD
Current
FUND Descr
Account Descr
Begin Yr
Debit
Credit
Balance
FUND 150 Economic Development
$91,584.95
$91,584.95
$0.00
$4,020.96
Economic Development
G 150 -10100 Cash
$8,841.22
$47,280.41
$26,812.63
$29,309.00
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
$26,843.90
$50,990.33
- $24,146.43
FUND 150 Economic Development
FUND 156 TIF 1-4 St Joe Development
TIF 1-4 St. Joe Develop G 156 -10100 Cash
TIF 1 -4 St. Joe Develop G 156 -10450 Interest Receivable
TIF 1 -4 St. Joe Develop G 156 -25310 Appropriated Fund Balance
FUND 156 TIF 1 -4 St. Joe Development
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream G 157 -10100 Cash
TIF 2 -1 Millstream G 157 -10450 Interest Receivable
TIF 2 -1 Millstream G 157 -20200 Accounts Payable
TIF 2 -1 Millstream G 157 -25310 Appropriated Fund Balance
FUND 157 TIF 2 -1 Millstream
FUND 158 TIF 2 -2 Meat Market
TIF 2 -2 Meat Market G 158 -10100 Cash
TIF 2 -2 Meat Market G 158 -25310 Appropriated Fund Balance
FUND 158 TIF 2 -2 Meat Market
FUND 250 Revolving Loan Fund
$0.00 $77,834.23 $77,834.23 $0.00
$41,593.09
$33,792.10
$57,687.18
$17,698.01
$105.67
$0.00
$105.67
$0.00
- $41,698.76
$57,792.85
$33,792.10
- $17,698.01
$0.00
$91,584.95
$91,584.95
$0.00
$4,020.96
$23,641.81
$21,565.44
$6,097.33
$4.82
$0.00
$4.82
$0.00
$0.00
$0.00
$0.00
$0.00
- $4,025.78
$21,570.26
$23,641.81
- $6,097.33
$0.00
$45,212.07
$45,212.07
$0.00
$0.00
$7,469.96
$7,742.96
- $273.00
$0.00
$7,742.96
$7,469.96
$273.00
$0.00 $15,212.92 $15,212.92 $0.00
Revolving Loan Fund
G 250 -10100 Cash
$34,565.78
$3,122.69
$25,607.37
$12,081.10
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
$25,696.88
$3,122.69
- $12,081.10
FUND 250 Revolving Loan Fund
$0.00
$49,534.65
$49,534.65
$0.00
$0.00 $279,378.82 $279,378.82 $0.00
rl CITY OF ST JOSEPH 08/17/11 9:23 AM
Page 1
EDA Revenue Report
Current Period: July 2011
FUND 156 TIF 1-4 St. Joe Development
TIF 1-4 St. Joe Development
31050
Tax Increment
2011
July
2011
FUND Descr
SOURCE
SOURCE Descr
YTD Budget
2011 Amt
YTD Amt
FUND 150 Economic Development
$0.00
$10,035.03
$33,676.60
FUND 157 TIF 2 -1 Millstream
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
$38.01
$105.11
Economic Development
39201
Transfers from Other Funds
$83,840.00
$0.00
$28,000.00
FUND 150 Economic Development
$0.00
$83,990.00
$38.01
$44,473.68
FUND 156 TIF 1-4 St. Joe Development
TIF 1-4 St. Joe Development
31050
Tax Increment
$0.00
$9,957.75
$33,192.49
TIF 1-4 St. Joe Development
36210
Interest Earnings
$0.00
$77.28
$484.11
FUND 156 TIF 1-4 St. Joe Development
$0.00
$10,035.03
$33,676.60
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream
31050
Tax Increment
$0.00
$7,074.27
$23,580.89
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
$14.86
$55.38
FUND 157 TIF 2 -1 Millstream
$0.00
$7,089.13
$23,636.27
FUND 250 Revolving Loan Fund
Revolving Loan Fund
36210
Interest Earnings
$0.00
$30.69
$350.78
Revolving Loan Fund
39320
Revolving Loan Principal
$0.00
$282.50
$1,997.04
Revolving Loan Fund
39321
Revolving Loan Interest
$0.00
$47.50
$346.99
Revolving Loan Fund
39322
Revolving Loan Origination
$0.00
$0.00
$0.00
FUND 250 Revolving Loan Fund
$0.00
$360.69
$2,694.81
$83,990.00
$17,522.86
$104,481.36
�i } }} CITY OF ST JOSEPH 08/17/11 9:55 AM
Page 1
(n EDA Expenditure Report
Current Period: July 2011
FUND 156 TIF 1-4 St. Joe Development
E 156 -46500 -101 Salaries
2011
July
2011
Account Descr
YTD Budget
2011 Amt
YTD Amt
FUND 150 Economic Development
$0.00
$13.05
$16.94
E 150 -46500 -103 Legislative Bodies
$1,390.00
$0.00
$0.00
E 150 -46500 -151 Workers Comp. Insur. Prem.
$150.00
$0.00
-$0.52
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,541.36
$7,478.21
E 150 -46500 -303 Engineering Fee
$2,000.00
$0.00
$714.64
E 150 -46500 -304 Legal Fees
$1,000.00
$256.50
$904.50
E 150 -46500 -321 Telephone
$1,200.00
$64.72
$446.21
E 15046500 -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 15046500 -340 Advertising
$500.00
$0.00
$0.00
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 15046500 -588 EDA Programs
$40,000.00
$1,230.86
$10,190.86
FUND 150 Economic Development
$83,990.00
$3,093.44
$20,327.25
FUND 156 TIF 1-4 St. Joe Development
E 156 -46500 -101 Salaries
$0.00
$219.81
$287.12
E 156 -46500 -121 PERA Contributions
$0.00
$15.94
$20.82
E 156 -46500 -122 FICA Contributions
$0.00
$13.05
$16.94
E 156 -46500 -123 Deferred Comp - Employer
$0.00
$3.91
$5.16
E 156 -46500 -125 Medicare Contributions
$0.00
$3.05
$3.96
E 156 -46500 -131 Health Insurance
$0.00
$37.44
$49.42
E 156 -46500 -133 Life Insurance
$0.00
$0.46
$0.61
E 156 - 46500 -134 Disabilty Insurance
$0.00
$3.08
$3.08
E 156 -46500 -300 Professional Services
$0.00
$351.00
$351.00
E 156 -46500 -340 Advertising
$0.00
$0.00
$66.00
E 156 -46500 -588 EDA Programs
$0.00
$27,000.00
$27,000.00
E 156 - 46500 -622 Tax Increment Payments
$0.00
$29,873.24
$29,873.24
FUND 156 TIF 1 -4 St. Joe Development
$0.00
$57,520.98
$57,677.35
FUND 157 TIF 2 -1 Millstream
E 157 -46500 -101 Salaries
$0.00
$219.81
$253.46
E 157 -46500 -121 PERA Contributions
$0.00
$15.94
$18.38
E 157 -46500 -122 FICA Contributions
$0.00
$13.04
$14.99
E 157 -46500 -123 Deferred Comp - Employer
$0.00
$3.91
$4.54
E 157 -46500 -125 Medicare Contributions
$0.00
$3.05
$3.51
E 157 -46500 -131 Health Insurance
$0.00
$37.45
$43.44
E 157 -46500 -133 Life Insurance
$0.00
$0.46
$0.53
E 157 -46500 -134 Disabilty Insurance
$0.00
$3.07
$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
$0.00
E 157 -46500 -622 Tax Increment Payments
$0.00
$21,222.80
$21,222.80
E 157 -49300 -720 Transfers to Other Funds
$0.00
$0.00
$0.00
FUND 157 TIF 2 -1 Millstream
$0.00
$21,519.53
$21,564.72
FUND 158 TIF 2 -2 Meat Market
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
fi CITY OF ST JOSEPH 08/17/11 9:55 AM
Page 2
EDA Expenditure Report
Current Period: July 2011
$83,990.00 $82,241.95 $125,111.32
2011
July
2011
Account Descr
YTD Budget
2011 Amt
YTD Amt
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
$108.00
$108.00
E 158 -46500 -340 Advertising
$0.00
$0.00
$165.00
E 158 -46500 -622 Tax Increment Payments
$0.00
$0.00
$0.00
FUND 158 TIF 2 -2 Meat Market
$0.00
$108.00
$273.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
$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
$25,215.00
FUND 250 Revolving Loan Fund
$0.00
$0.00
$25,269.00
$83,990.00 $82,241.95 $125,111.32
a
M
N a o°
L
H
n
C 'y
E
Uw U aN m
3 C' N
a
O
ji Z g
L
U� U It
C
Q%
W C �:
co
O
W O
N
6 CL.
VI'V
C nj
N
O O w O m
a
J."
-4 O N O 01
u1 l!1 lO 01 !:
c E
v
c-I l0 VI N
Ln .... c-I
n <
to
c W O
�
C N
N
d p
� �
X CL M
3
W E D
?
O
O
O
pj
N L V
0
CL o
A
rl V m Q
O 7
M 1 d
cc
Q m
N 3 CO
LL a
E
L u
d �
C
d O
N N
U
-i m
a
Z
N a o°
L
H
0 m t
H m
E
Uw U aN m
E
WU� 0(n
a
Z
ji Z g
12 =
U� U It
O)6,
Q%
.
co
Ln
C? N li
V1
V 1p
001 l0O 01 lO
O O w O m
O m m
-4 O N O 01
u1 l!1 lO 01 !:
O N E rl
—t 1� M
v
c-I l0 VI N
Ln .... c-I
d co 9 00
V L L9
a a
LO LO
V Cl C.
Q
c
.. w
v E
CE d 0 O
C W W
a
U
0
w
O
F-
a�
N
N
H lip
O lD O Ol
Q%
f
co
V1
N
p1 ^
Op N 01
Cl
N
N
N
ID
C
E
E
po N
d
0
3
>
0
O
o o
.�..
pj
tyA
�yy
O
CL
An
C
l0 S
E
U.
N N
U
-i m
m
a
r,
O
S S S
S
O
un1
c5
eq
0
Lo
0
8
S°°°
d co 9 00
V L L9
a a
LO LO
V Cl C.
Q
c
.. w
v E
CE d 0 O
C W W
a
U
0
w
O
F-
a�
E
Q%
f
co
o
E
`o
a c
Cl
N
N
N
O V
C
E
E
po N
d
0
3
>
0
O
o o
.�..
0o
O N
tyA
CL
C OM
O V N
CL
C
C
l0 S
E
U.
Q Q
m
� U
U
-i m
m
a
d co 9 00
V L L9
a a
LO LO
V Cl C.
Q
c
.. w
v E
CE d 0 O
C W W
a
U
0
w
O
F-