HomeMy WebLinkAbout[05] Accounts Payable & Financial ReportsCITY OF ST. JOSEPH
VVV. cityo f stjoseph. com
DATE: December 11, 2013
MEMO TO: St. Joseph Economic Development Authority
Administrator FROM: Cynthia Smith - Strack Municipal Development Group
Judy Weyrens RE: Accounts Payable
Mayor November Financial Reports
Richard Schultz
A. Accounts Payable:
Councilors
Steve Frank Following are Accounts Payable for the EDA's Consideration.
Bob Loso Payable To For Fund
Renee Symanietz MDG, Inc. Nov. Econ. Dev. Service 150 -46500 -300
Dale Wick $2,200 services, $422.62 mileage
Total
EDA
Doug Danielson
Steve Frank
Larry Hosch
Gary Osberg
Dale Wick
Amount
$ 2,622.62
$ 2,622.62
'Plus invoices noted on enclosed check register.
Through November 30th a total of 396.50 contract hours have been provided; 23.50 hours
remain on the contract.
Action:
A MOTION is in order to approve the Accounts Payable.
B. Financial Report:
November 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.
I
a6VA
MUNICIPAL DEVELOPMENT GROUP, INC.
25562 WILLOW LANE
NEW PRAGUE, MN 56071
952 - 758 -7399
FAX: 952 - 758 -3711
staff @municipaideveiopmentgroup.com
INVOICE
City of St. Joseph
Attn: Judy Weyrens
City Administrator
PO 668
St. Joseph, MN 56374
Invoice Date 12 -10 -13
Payment Terms: 30 days
Customer ID #:
STJ13EDA
Project Nov. 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
Hour
November 6, 2013 EDA Office Hours: C. Strack
7.50 Hour
November 13, 2013 EDA Office Hours: C. Strack
7.50 Hour
November 20, 2013 EDA Office Hours: C. Strack
7.50 Hour
November 27, 2013 EDA Office Hours: C. Strack
9.00 Hour
Total November 2013
31.50 Hours
Total Contract Hours November 30, 2013: 396.50 Hours
Check No.
Date:
Thank you! We appreciated the opportunity to work with you!
04
Principal
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
November 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 Expenditures 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 November 30, 2013:
9,524.21 **
14,759.26 **
4,318.96 **
165.19 **
**
28,767.62
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
y
295.82
13,475.00
125,503.22
(107.14)
(16.57)
(622.93)
(21,043.59)
(91.80)
(709.82)
(3,810.83)
(30.62)
(20,473.55)
77,651.57
139,274.04
(46,906.85)
170,018.76
38,089.78
15,368.57
116,560.41
28,451.24
1,302.11
30,194.51
CITY OF ST. JOSEPH
EDA Balance Sheet
Current Period: November 2013
YTD YTD Current
FUND Descr Account Descr Beqin Yr Debit Credit Balance
FUND 150 Economic Development
Economic Development
Economic Development
Economic Development
Economic Development
Economic Development
Economic Development
Economic Development
Economic Development
G 150 -10100 Cash
G 150 -10450 Interest Receivable
G 150 -10700 Taxes Receivable - Delinquen
G 150 -13113 Due From other Gov t Units
G 150 -15500 Due From Other Fund
G 150 -20200 Accounts Payable
G 150 -22204 Deferred Revenue
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 Millstream
$79,525.68 $198,980.00 $108,986.92 $169,518.76
$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 $109,414.16 $201,781.35
- $156,722.05
$0.00 $312,088.61 $312,088.61
$0.00
TIF 2 -1 Millstream
G 157 -10100 Cash
$10,832.25
$57,881.48
$40,262.49
$28,451.24
TIF 2 -1 Millstream
G 157 -10450 Interest Receivable
$12.43
$0.00
$12.43
$0.00
TIF 2 -1 Millstream
G 157 -13113 Due From other Gov t Units
$0.00
$0.00
$0.00
$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
- $10,844.68
$40,274.92
$57,881.48
- $28,451.24
FUND 157 TIF 2 -1 Millstream
$0.00
$98,156.40
$98,156.40
$0.00
FUND 158 TIF 2 -2 Meat Market
TIF 2 -2 Meat Market
G 158 -10100 Cash
$30.02
$4,285.63
$2,513.54
$1,802.11
TIF 2 -2 Meat Market
G 158 -20500 Due To Other Fund
- $500.00
$0.00
$0.00
- $500.00
TIF 2 -2 Meat Market
G 158 -25310 Appropriated Fund Balance
$469.98
$2,513.54
$4,285.63
- $1,302.11
FUND 158 TIF 2 -2 Meat Market
$0.00
$6,799.17
$6,799.17
$0.00
FUND 250 Revolving Loan Fund
Revolving Loan Fund
G 250 -10100 Cash
Revolving Loan Fund
G 250 -10450 Interest Receivable
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
$22,746.98
$7,743.41
$295.88
$30,194.51
$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
$7,743.41
- $30,194.51
$0.00
$44,194.44
$44,194.44
$0.00
/v
$0.00 $461,238.62 $461,238.62 $0.00
12/03/13 3:04 PM
Page 1
CITY OF ST. JOSEPH
EDA Revenue Report
Current Period: November 2013
2013 November 2013
FUND Descr SOURCE SOURCE Descr YTD Budget 2013 Amt YTD Amt
FUND 150 Economic Development
Economic Development
31010
Current Ad Valorem Taxes
$126,095.00
$59,997.55
$125,503.22
Economic Development
33160
Federal Grants - Other
$0.00
$2,225.00
$13,475.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 Earnings
$500.00
$113.75
$295.82
Economic Development
39201
Transfers from Other Funds
$0.00
$0.00
$0.00
FUND 150 Economic Development
$126,595.00
$62,336.30
$139,274.04
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream
31050
Tax Increment
$0.00
$15,908.68
$34,911.46
TIF 2 -1 Millstream
33404
Market Value Credit
$0.00
$0.00
$0.00
TIF 2 -1 Millstream
36210
Interest Earnings
$0.00
$11.90
$17.86
FUND 157 TIF 2 -1 Millstream
$0.00
$15,920.58
$34,929.32
FUND 158 TIF 2 -2 Meat Market
TIF 2 -2 Meat Market
31050
Tax Increment
$0.00
$1,860.52
$3,724.78
TIF 2 -2 Meat Market
36210
Interest Earnings
$0.00
-$0.06
$0.48
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,860.46
$3,725.26
FUND 250 Revolving Loan Fund
Revolving Loan Fund
36210
Interest Earnings
$300.00
$27.48
$14.23
Revolving Loan Fund
39320
Revolving Loan Principal
$7,095.00
$302.95
$6,496.18
Revolving Loan Fund
39321
Revolving Loan Interest
$985.00
$27.05
$912.87
Revolving Loan Fund
39322
Revolving Loan Origination
$0.00
$0.00
$0.00
FUND 250 Revolving Loan Fund
$8,380.00
$357.48
$7,423.28
$134,975.00
$80,474.82
$185,351.90
12/03/13 3:05 PM
Page 1
CITY OF ST. JOSEPH
EDA Expenditure Report
Current Period: November 2013
12/03/13 3:05 PM
Page 1
/ Z-
2013
November
2013
Account Descr
YTD Budget
2013 Amt
YTD Amt
FUND 150 Economic Development
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
$14.00
$16.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
$1,768.21
$21,043.59
E 150 -46500 -303 Engineering Fee
$2,000.00
$91.80
$91.80
E 150 -46500 -304 Legal Fees
$1,000.00
$0.00
$0.00
E 150 -46500 -321 Telephone
$785.00
$65.85
$709.82
E 150 -46500 -322 Postage
$350.00
$0.00
$0.00
E 150 -46500 -328 Marketing
$8,000.00
$755.85
$3,810.83
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
$2,545.02
$20,473.55
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,240.73
$46,906.85
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 Disability 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
/ Z-
CITY OF ST. JOSEPH
EDA Expenditure Report
Current Period: November 2013
12103/13 3:05 PM
Page 2
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
$0.00
2013
November
2013
Account Descr
YTD Budget
2013 Amt
YTD Amt
E 158 -46500 -131 Health Insurance
$0.00
$0.00
$0.00
E 158 -46500 -132 Dental Insurance
$0.00
$0.00
$0.91
E 158 -46500 -133 Life Insurance
$0.00
$0.00
$0.07
E 158 -46500 -134 Disabilty Insurance
$0.00
$0.00
$0.52
E 158 -46500 -300 Professional Services
$0.00
$0.00
$0.00
E 158 -46500 -340 Advertising
$0.00
$0.00
$30.63
E 158 - 46500 -622 TIF /Abatement Payments
$0.00
$0.00
$1,771.05
FUND 158 TIF 2 -2 Meat Market
$0.00
$0.00
$1,953.17
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
$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
13
$5,240.73 $66,182.78
CITY OF ST. JOSEPH 12/03/13 3:05 PM
EDA Check Register Page 1
CHECK
#
Search Name
Comments
FUND
DEPART
Amount
047197
CENTRYLINK
20 sets 229 #'s
150
46500
$11.12
047198
CENTURYLINK BUSINESS SERVICES
Oct long distance telephone
150
46500
$4.37
047209
THE LOCAL BLEND
cater EDA business breakfast
150
46500
$115.80
047211
TRI- COUNTY ACTION PROGRAM INC
DEED housing grant -admin ser
150
46500
$2,225.00
047215
CENTRYLINK
Nov T1 line
150
46500
$50.36
047234
LEAGUE OF MN CITIES INS TRUST
final workers comp due 12 -13
150
46500
$14.00
047237
MUNICIPAL DEVELOPMENT CORP
Oct EDA -CR2 infrastructure de
150
46500
$50.47
047237
MUNICIPAL DEVELOPMENT CORP
Oct EDA -mtgs qualified project
150
46500
$269.55
047237
MUNICIPAL DEVELOPMENT CORP
Oct EDA - website
150
46500
$117.86
047237
MUNICIPAL DEVELOPMENT CORP
Oct EDA- marketing
150
46500
$640.05
047237
MUNICIPAL DEVELOPMENT CORP
Oct EDA - business retention
150
46500
$1,347.22
047237
MUNICIPAL DEVELOPMENT CORP
Oct EDA - organizational develo
150
46500
$303.13
047288
SEH, INC
review home site near Gatewa
150
46500
$91.80
$5,240.73
144
2013 Capital Expenditures
General Fund Capital Improvement Plan - EDA
2013 final CIP Budget Adopted December 6, 2012
As of November 30, 2013
through 11/30 through 11/30
Transfers Spent 2013
2013 2013 Balance
1,200.00
12/31/2012
Available
(2,869.06)
Project
Project
Reserve
Budget
Department Account Code
Number Equipment
Balance
2013
EDA 150 -46500 -582
EDA -1301 Computer Software
1,200.00
9,341.57
EDA 150 -46500 -588
EDA -1302 Let's Go Downtown
3,338.66
10,000.00
EDA -1307 Business Development/TIF
-
11,500.00
9,896.32
EDA -1308 Business Demolition Program
3,341.57
6,000.00
EDA -1309 CDBG Grant Development
-
-
EDA -1303 BFA Grant/Loan Program
5,416.48
6,000.00
(8,706.93)
EDA -1304 Rental Conversions
-
EDA -1305 CSAH 2/3 Collection Street
12,096.71
33,500.00
TOTAL EDA CIP
13.296.71
1 33.500.00
2013 Capital Expenditures
General Fund Capital Improvement Plan - EDA
2013 final CIP Budget Adopted December 6, 2012
As of November 30, 2013
through 11/30 through 11/30
Transfers Spent 2013
2013 2013 Balance
1,200.00
includes flower
(2,869.06)
10,469.60
brackets
(4,152.52)
7,347.48
2013 student
housing unit
9,341.57
$2500
2012 Scenic
Specialties/
(1,520.16)
9,896.32
Retail Therapy
(165.19)
(165.19)
(8,706.93)
36,889.78
38,089.78
(8,706.93)