HomeMy WebLinkAbout[05] Accounts Payable and Financial ReportCITY OF ST. JOSEPH
vvww.cityof stiosepli.ccm
DATE: October 16, 2013
The reports consist of:
1. Monthly Report.
2. Balance Sheet.
3. EDA revenue to date.
4. EDA expenditures to date.
5. Check Register
6. CIP Summary
A MOTION is in order to approve the Financial Reports.
Page 6 of 40
MEMO TO: St. Joseph Economic Development Authority
FROM: Cynthia Smith - Strack Municipal Development Group
Administrator
Judy Weyrens
RE: Accounts Payable
September 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. Sept. Econ. Dev. Service 150 - 46500 -300 $ 2,622.62
Dale Wick
$2,200 services, $422.62 mileage
Total $ 2,622.62
EDA
Doug Danielson
'Plus invoices noted on enclosed check register.
Steve Frank
Larry Hosch
Through September 30th a total of 324.50 contract hours have been provided; 95.50 hours
Gary Osberg
remain on the contract.
Dale Wick
Action:
A MOTION is in order to approve the Accounts Payable.
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. Check Register
6. CIP Summary
A MOTION is in order to approve the Financial Reports.
Page 6 of 40
4%
MUNICIPAL DEVELOPMlNT GROUP, INC.
25562 WILLOW LANE
NEW PRAGUE, MN 56071
952 - 758 -7399
FAX: 952 - 758 -3711
staff @municipaldevelopmentgroup.com
INVOICE
City of St. Joseph
Attn: Judy Weyrens
City Administrator
PO 668
St. Joseph, MN 56374
Invoice Date 10 -10 -13
Payment Terms: 30 days
Customer ID #:
STJ 13EDA
Project Aug Economic Development Services
Amount: $2,200.00 Monthly contract fee
422.62 748 miles x.565
$2,622.62
Code to: 150 - 46500 -300 for general EDA
Remit To: Municipal Development Group, Inc.
25562 Willow Lane
New Prague, MN 56071
Dates -EDA
Hours
September 4, 2013 EDA Office Hours: C. Strack
8.00 Hours
September 6, 2013 EDA Office Hours: C. Strack in MDG Office
4.50 Hours
September 11, 2013 EDA Office Hours: C. Strack
7.50 Hours
September 11, 2013 EDA Office Hours: J. Anderson in MDG Office
0.50 Hours
September 18, 2013 EDA Office Hours: C. Strack
7.50 Hours
September 25, 2013 EDA Office Hours: C. Strack
9.00 Hours
Total September 2013
37.00 Hours
Total Contract Hours September 30, 2013: 324.50 Hours
Check No.
Date:
Thank you! We appreciated the opportunity to work with you!
Page 7 of 40
Principal
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
September 2013
Fund 150, EDA Balance as of December 31, 2012 (audited)
Year to Date Revenue:
Interest Earnings
DEED Housing Fees
Ad Valorem Taxes
Total Revenue
Year to Date Expenditure Total by Project:
Market Development
Business Development
Organizational Development
Infrastructure Development
Workforce Development
Year to Date Exoenditures by Object:
Board Stipends
Staff Salaries
Workers Comp Premium
Office Supplies
Software Support
Municipal Development Group
Legal /Engineering Fees
Telephone
Postage
Business Luncheon
Marketing
Advertising
Rentals (Postage Machine)
EDA Programs
Total Expenses
Fund Summaries as of September 30,2013:
8,672.79
13,165.41 "
4,015.83
25,854.03
EDA Fund Balance - Fund 150 - unaudited
Designated for Capital Programs
Designated for DEED Housing Projects
Undesignated
TIF 2 -1 Millstream Shops and Lofts Fund Balance - Fund 157
TIF 2 -2 St. Joseph Meat Market Fund Balance - Fund 158
Revolving Loan Fund Balance - Fund 250
"" Detail available upon request
Page 8 of 40
38.63
11,250.00
65.505.67
(107.14)
(2.57)
(622.93)
(17,556.51)
(578.87)
(2,736.07)
(30.62)
(6.093.69)
77,651.57
76,794.30
(27.728.40)
126.717.47
39,086.44
15,368.57
72,262.46
12,516.10
(558.28)
28,787.28
CITY OF ST. JOSEPH
EDA Balance Sheet
Current Period: September 2013
YTD YTD Current
FUND Descr Account Descr Begin Yr Debit Credit Balance
FUND 150 Economic Development
Economic Development
G 150 -10100 Cash
Economic Development
G 150 -10450 Interest Receivable
Economic Development
G 150 -10700 Taxes Receivable - Delinquen
Economic Development
G 150 -13113 Due From other Gov t Units
Economic Development
G 150 -15500 Due From Other Fund
Economic Development
G 150 -20200 Accounts Payable
Economic Development
G 150 -22204 Deferred Revenue
Economic Development
G 150 -24415 Design. Fd Bal - Capital Proj
Economic Development
G 150 -25310 Appropriated Fund Balance
FUND 150 Economic Development
FUND 157 TIF 2 -1 Mills
TIF 2 -1 Millstream
TIF 2 -1 Millstream
TIF 2 -1 Millstream
TIF 2 -1 Millstream
TIF 2 -1 Millstream
tream
G 157 -10100 Cash
G 157 -10450 Interest Receivable
G 157 -13113 Due From other Gov t Units
G 157 -20200 Accounts Payable
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 -20500 Due To Other Fund
TIF 2 -2 Meat Market G 158 -25310 Appropriated Fund Balance
FUND 158 TIF 2 -2 Meat Market
FUND 250 Revolving Loan Fund
Revolving Loan Fund
Revolving Loan Fund
Revolving Loan Fund
Revolving Loan Fund
Revolving Loan Fund
Revolving Loan Fund
FUND 250 Revolving Loa
G 250 -10100 Cash
G 250 -10450 Interest Receivable
G 250 -11900 Notes Receivable
G 250 -20200 Accounts Payable
G 250 -22204 Deferred Revenue
G 250 -25310 Appropriated Fund Balance
n Fund
$79,525.68 $102,750.26 $56,058.47 $126,217.47
$75.73
$0.00
$75.73
$0.00
$893.10
$0.00
$893.10
$0.00
$351.51
$0.00
$351.51
$0.00
$500.00
$0.00
$0.00
$500.00
- $2,801.35
$2,801.35
$0.00
$0.00
- $893.10
$893.10
$0.00
$0.00
- $13,296.71
$0.00
$0.00
- $13,296.71
- $64,354.86
$56,485.71
$105,551.61
- $113,420.76
$0.00
$162,930.42
$162,930.42
$0.00
$10,832.25
$41,946.34
$40,262.49
$12,516.10
$12.43
$0.00
$12.43
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
- $10,844.68
$40,274.92
$41,946.34
- $12,516.10
$0.00
$82,221.26
$82,221.26
$0.00
$30.02
$2,425.11
$2,513.41
- $58.28
- $500.00
$0.00
$0.00
- $500.00
$469.98
$2,513.41
$2,425.11
$558.28
$0.00
$4,938.52
$4,938.52
$0.00
$22,746.98
$6,336.18
$295.88
$28,787.28
$24.25
$0.00
$24.25
$0.00
$36,130.90
$0.00
$36,130.90
$0.00
$0.00
$0.00
$0.00
$0.00
- $36,130.90
$36,130.90
$0.00
$0.00
- $22,771.23
$320.13
$6,336.18
- $28,787.28
$0.00
$42,787.21
$42,787.21
$0.00
$0.00 $292,877.41 $292,877.41 $0.00
Page 9 of 40
10/16/13 9:22 AM
Page 1
CITY OF ST. JOSEPH
EDA Revenue Report
Current Period: September 2013
10/16/13 9:31 AM
Page 1
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream
31050
Tax Increment
2013
September
2013
FUND Descr
SOURCE
SOURCE Descr
YTD Budget
2013 Amt
YTD Amt
FUND 150 Economic Development
34150
TIF /MIF Deposit
$0.00
$0.00
$0.00
Economic Development
31010
Current Ad Valorem Taxes
$126,095.00
$0.00
$65,505.67
Economic Development
33160
Federal Grants - Other
$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
$11,250.00
$11,250.00
Economic Development
36210
Interest Earnings
$500.00
$373.67
$38.63
Economic Development
39201
Transfers from Other Funds
$0.00
$0.00
$0.00
FUND 150 Economic Development
39201
Transfers from Other Funds
$126,595.00
$11,623.67
$76,794.30
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream
31050
Tax Increment
$0.00
$0.00
$19,002.78
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
$52.28
-$8.60
FUND 157 TIF 2 -1 Millstream
$0.00
$52.28
$18,994.18
FUND 158 TIF 2-2 Meat Market
TIF 2 -2 Meat Market
31050
Tax Increment
$0.00
$0.00
$1,864.26
TIF 2 -2 Meat Market
34150
TIF /MIF Deposit
$0.00
$0.00
$0.00
TIF 2 -2 Meat Market
36210
Interest Earnings
$0.00
$1.11
$0.61
TIF 2 -2 Meat Market
39201
Transfers from Other Funds
$0.00
$0.00
$0.00
FUND 158 TIF 2 -2 Meat Market
$0.00
$1.11
$1,864.87
FUND 250 Revolving Loan Fund
Revolving Loan Fund
36210
Interest Earnings
$300.00
$88.00
- $45.90
Revolving Loan Fund
39320
Revolving Loan Principal
$7,095.00
$594.98
$5,301.75
Revolving Loan Fund
39321
Revolving Loan Interest
$985.00
$78.57
$760.20
Revolving Loan Fund
39322
Revolving Loan Origination
$0.00
$0.00
$0.00
FUND 250 Revolving Loan Fund
$8,380.00
$761.55
$6,016.05
$134,975.00 $12,438.61 $103,669.40
Page 10 of 40
CITY OF ST. JOSEPH
EDA Expenditure Report
Current Period: September 2013
10/16/13 9:24 AM
Page 1
FUND 157 TIF 2 -1 Millstream
E 157 - 46500 -101 Salaries
2013
September
2013
Account Descr
YTD Budget
2013 Amt
YTD Amt
FUND 150 Economic Development
$0.00
$0.00
$5.66
E 150 - 46500 -101 Salaries
$0.00
$0.00
$91.92
E 150 -46500 -103 Legislative Bodies
$1,260.00
$0.00
$0.00
E 150 -46500 -121 PERA Contributions
$0.00
$0.00
$6.67
E 150 - 46500 -122 FICA Contributions
$0.00
$0.00
$5.66
E 150 - 46500 -123 Deferred Comp- Employer
$0.00
$0.00
$1.57
E 150 -46500 -125 Medicare Contributions
$0.00
$0.00
$1.32
E 150 -46500 -151 Workers Comp. Insur. Prem.
$10.00
$0.00
$2.57
E 150 -46500 -200 Office Supplies
$500.00
$0.00
$0.00
E 150 - 46500 -215 Software Support
$540.00
$0.00
$622.93
E 150 -46500 -300 Professional Services
$28,000.00
$2,371.11
$17,556.51
E 150 -46500 -303 Engineering Fee
$2,000.00
$0.00
$0.00
E 150 -46500 -304 Legal Fees
$1,000.00
$0.00
$0.00
E 150 -46500 -321 Telephone
$785.00
$61.63
$578.87
E 150 -46500 -322 Postage
$350.00
$0.00
$0.00
E 150 -46500 -328 Marketing
$8,000.00
$2,500.00
$2,736.07
E 150 -46500 -331 Travel & Conference Expense
$150.00
$0.00
$0.00
E 150 -46500 -340 Advertising
$500.00
$0.00
$30.62
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
$33,500.00
$454.30
$6,093.69
E 150 - 46500 -622 TIF /Abatement Payments
$50,000.00
$0.00
$0.00
E 150 -49300 -720 Transfers to Other Funds
$0.00
$0.00
$0.00
FUND 150 Economic Development
$126,595.00
$5,387.04
$27,728.40
FUND 157 TIF 2 -1 Millstream
E 157 - 46500 -101 Salaries
$0.00
$0.00
$91.92
E 157 -46500 -121 PERA Contributions
$0.00
$0.00
$6.67
E 157 - 46500 -122 FICA Contributions
$0.00
$0.00
$5.66
E 157 -46500 -123 Deferred Comp - Employer
$0.00
$0.00
$1.57
E 157 -46500 -125 Medicare Contributions
$0.00
$0.00
$1.32
E 157 -46500 -131 Health Insurance
$0.00
$0.00
$0.00
E 157 - 46500 -132 Dental Insurance
$0.00
$0.00
$0.90
E 157 -46500 -133 Life Insurance
$0.00
$0.00
$0.08
E 157 -46500 -134 Disabilty Insurance
$0.00
$0.00
$0.51
E 157 -46500 -300 Professional Services
$0.00
$0.00
$81.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
$30.63
E 157 - 46500 -622 TIF /Abatement Payments
$0.00
$0.00
$17,102.50
E 157 -49300 -720 Transfers to Other Funds
$0.00
$0.00
$0.00
FUND 157 TIF 2 -1 Millstream
$0.00
$0.00
$17,322.76
FUND 158 TIF 2-2 Meat Market
E 158 - 46500 -101 Salaries
$0.00
$0.00
$128.70
E 158 -46500 -121 PERA Contributions
$0.00
$0.00
$9.31
E 158- 46500 -122 FICA Contributions
$0.00
$0.00
$7.94
E 158 - 46500 -123 Deferred Comp- Employer
$0.00
$0.00
$2.18
E 158 -46500 -125 Medicare Contributions
$0.00
$0.00
$1.86
Page 11 of 40
CITY OF ST. JOSEPH
EDA Expenditure Report
Current Period: September 2013
Account Descr
E 158 -46500 -131 Health Insurance
E 158 - 46500 -132 Dental Insurance
E 158 -46500 -133 Life Insurance
E 158 -46500 -134 Disabilty Insurance
E 158 -46500 -300 Professional Services
E 158 -46500 -340 Advertising
E 158- 46500 -622 TIF /Abatement Payments
FUND 158 TIF 2 -2 Meat Market
FUND 250 Revolving Loan Fund
E 250 -46500 -300 Professional Services
E 250 -46500 -304 Legal Fees
E 250 -46500 -317 Other fees
E 250 - 46500 -434 Certification Fee
E 250 - 46500 -455 Revolving Loan Proceeds
FUND 250 Revolving Loan Fund
2013 September 2013
YTD Budget 2013 Amt YTD Amt
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.91
$0.00
$0.07
$0.00
$0.52
$0.00
$0.00
$0.00
$30.63
$0.00
$1,771.05
$0.00 $1,953.17
$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
$0.00
$0.00
$0.00
$0.00
$126,595.00 $5,387.04 $47,004.33
Page 12 of 40
10/16/13 9:24 AM
Page 2
CITY OF ST. JOSEPH
EDA Check Register
10/16/13 9:23 AM
Page 1
CHECK
#
Search Name
Comments
FUND
DEPART
Amount
046971
CENTRYLINK
Sep Tl /long distance/PD /WTP
150
46500
$61.63
046977
GREATER ST. CLOUD DEVELOP CORP
2013 investment - 3rd & 4th q
150
46500
$2,500.00
047010
MUNICIPAL DEVELOPMENT CORP
Aug website
150
46500
$71.87
047010
MUNICIPAL DEVELOPMENT CORP
Aug marketing material
150
46500
$341.20
047010
MUNICIPAL DEVELOPMENT CORP
Aug mtgs /research /Qualified p
150
46500
$1,616.58
047010
MUNICIPAL DEVELOPMENT CORP
Aug business retention
150
46500
$251.51
047010
MUNICIPAL DEVELOPMENT CORP
Organizational development -A
150
46500
$341.46
047010
MUNICIPAL DEVELOPMENT CORP
allocate Aug EDA services
150
46500
- $2,622.62
047010
MUNICIPAL DEVELOPMENT CORP
August EDA services
150
46500
$2,622.62
047057
RETAIL THERAPY, LLC
BFA grant
150
46500
$202.79
$5,387.04
Page 13 of 40
N
`w
-4
C �
a
LL
W N
W
>
O
CL E
CL
v v
m m
L
m~
Cl
m'
u u
m g
E m
c -
O N 0
O
U)
C
N
p d
7 0J u O
Qom
O w
Co
y Ur
E 01 N
0
C
°o
(3)
O O O M
CL
m
w
W CL N
E 'a O
n
m U
E
Q
Lem
M
!� M °�
CL a a
�
o. o
=
,� N
o
U to
M u 7 0
r
N
a U Q
0
m
U. m
M
°
.-1
m
o P.
of
N
o
L
W rM1
� N
L
~
~
N
N
N Q 0
cc �0
7
a,
0
u
c
0
0
u
u
a
c
d
w �
CL` a
a,
0
�8
O t0
o IR
CD
O M
N m
1 m'
1l
`w
-4
to
a
LL
O
W
>
O
CL E
CL
v v
N c
L
m~
Cl
m'
u u
m g
ry A
c -
O N 0
O
U)
N
p d
.O+
Qom
O w
Co
y Ur
U N
C
°o
(3)
W
m
w
U
a
m U
00 rn
Ln
rn
rn
tu
°N
rn
L
m
°
.-1
m
o P.
of
o
o00o
r-:
m
.4
m
n
~
Il O
Ln
N
O
0)
m
N
O
tto
N m
-
^
n
�8
O t0
o IR
CD
O M
N m
1 m'
1l
00
-4
to
a
LL
«•
C
N
O
CL E
CL
@ G7
m
3 CL
Cl
m'
V1
N
o m
E
c -
O N 0
O
U)
m m
a
U
Q
O
w
J
F-
0
F-
O
d
CA
07
IL
E
LL
«•
C
N
O
CL E
CL
@ G7
3 CL
C O
>
O y c
a o 0
o °
c>
o m
E
c -
O N 0
O
U)
p c
� �U
.O+
Qom
O w
Co
y Ur
U N
C
C �
O7 =
W
m
w
U
-i m
m U
m U
tu
R
m m
a
U
Q
O
w
J
F-
0
F-
O
d
CA
07
IL
This page intentionally left blank