HomeMy WebLinkAbout[05] Accounts Payable & Financial Report . " CITY OF ST. J OSEPH
www.cityofstjoseph.com
DATE: October 17,2014
MEMO TO: St. Joseph Economic Development Authority
FROM: Cynthia Smith-Strack Municipal Development Group
Administrator
Judy Weyrens RE: Accounts Payable
Nov. 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. Oct Econ. Dev. Service 150-46500-300 $ 3,128.32
Dale Wick $2,500 services;628.32 mileage
MDG, Inc. Nov Econ. Dev. Service 150-46500-300 $ 3,023.60
EDA $2,500 services$523.60 mileage
Doug Danielson Total $ 6,151.92
Steve Frank
Larry Hosch *Plus invoices noted on enclosed check register.
Gary Osberg
Dale Wick As of November 30, 2014 a total of 402 hours of service have been provided. Remaining
balance for annual contract is 18 hours.
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.
q
THIS PAGE INTENTIONALLY LEFT BLANK
/0
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
staffemunicipaldevelopmentgroup.com City Administrator
PO 668
St. Joseph, MN 56374
Invoice Date 10-10-14 Payment Terms: 30 days Customer ID#:
STJI4EDA
Project Oct Economic Development Services
Amount: $2,500.00 Monthly contract fee
$ 628.32 1122 miles x .56
$3,128.32
Code to: 150-46500-300 for general EDA
Remit To: Municipal Development Group, Inc.
25562 Willow Lane
New Prague, MN 56071
Dates-EDA Hours
October 1, 2014 EDA Office Hours: C. Strack 9.00 Hours
October 8, 2014 EDA Office Hours: C. Strack 9.50 Hours
October 10, 2014 EDA Office Hours: C. Strack 6.50 Hours
October 15, 2014 EDA Office Hours: C. Strack 8.00 Hours
October 22, 2014 EDA Office Hours: C. Strack 8.25 Hours
October 24, 2014 EDA Office Hours: C. Strack 1.00 Hours
October 29, 2014 EDA Office Hours: C. Strack 8.50 Hours
Total October 2014 50.75 Hours
Total Contract Hours October 31, 2014: 366.50 Hours
Thank you! We appreciated the opportunity to work with you!
Check No. CJL ntliia Smitf-Strack
Date: Cynthia Smith-Strack,Principal MDG
//
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 11-10-14 Payment Terms: 30 days Customer ID#:
STJI4EDA
Project Nov Economic Development Services
Amount: $2,500.00 Monthly contract fee
$ 523.60 935 miles x .56
$3,023.60
Code to: 150-46500-300 for general EDA
Remit To: Municipal Development Group, Inc.
25562 Willow Lane
New Prague, MN 56071
Dates-EDA Hours
November 5, 2014 EDA Office Hours: C. Strack 8.50 Hours
November 12, 2014 EDA Office Hours: C. Strack 7.25 Hours
November 13, 2014 EDA Office Hours: C. Strack 5.00 Hours
November 19, 2014 EDA Office Hours: C. Strack 7.75 Hours
November 26, 2014 EDA Office Hours: C. Strack 7.00 Hours
Total November 2014 35.50 Hours
Total Contract Hours November 30, 2014: 402.00 Hours
Thank you! We appreciated the opportunity to work with you!
Check No. Cynt!'iia SmitI.-Stracf
Date: Cynthia Smith-Strack,Principal MDG
/
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
October/November 2014
Fund 150, EDA Balance as of December 31, 2013 (Audited) 112,485.64
Year to Date Revenue:
Interest Earnings 1,700.52
TIF/MIF Deposit 16,751.78
DEED Housing Grant Proceeds 224,261.00
Ad Valorem Taxes 69,879.68
Total Revenue 312,592.98
Year to Date Expenditure Total by Project:
Market Development 3,783.11 **
Business Development 20,923.45 ""
Organizational Development 3,515.78 **
Infrastructure Development 110.10 **
Workforce Development - **
28,332.44
Year to Date Expenditures by Object:
Board Stipends -
Staff Salaries -
Workers Comp Premium (3.57)
Software Support/Office Supplies (547.61)
Municipal Development Group (24,090.66)
Legal/Engineering Fees (186.60)
Telephone (761.55)
Greater St. Cloud Development Investment (5,000.00)
Business Round Table Outreach -
Marketing (50.00)
Advertising (79.38)
Coborn's Abatement -
CM Housing Grant Reimbursement (236,261.00)
EDA Programs (16,009.98)
Total Expenses (282,990.35)
Fund Summaries as of November 30, 2014:
EDA Fund Balance- Fund 150 -unaudited 142,088.27
Designated for Capital Programs 54,607.07
Designated for DEED Housing Projects 3,368.57
Undesignated 84,112.63
TIF 2-1 Millstream Shops and Lofts Fund Balance - Fund 157 16,445.77
TIF 2-2 St. Joseph Meat Market Fund Balance - Fund 158 (482.72)
Revolving Loan Fund Balance-Fund 250 38,734.62
**Detail available upon request
CITY OF ST. JOSEPH
EDA Balance Sheet
"' Current Period:November 2014
YTD YTD Current
FUND Descr Account Descr Begin Yr Debit Credit Balance
FUND 150 Economic Development
Economic Development G 150-10100 Cash $116,317.66 $331,713.07 $306,442.46 $141,588.27
Economic Development G 150-10450 Interest Receivable $32.82 $0.00 $32.82 $0.00
Economic Development G 150-10700 Taxes Receivable-Delinquen $1,961.95 $0.00 $1,961.95 $0.00
Economic Development G 150-13113 Due From other Govt Units $569.16 $0.00 $569.16 $0.00
Economic Development G 150-15500 Due From Other Fund $500.00 $0.00 $0.00 $500.00
Economic Development G 150-20200 Accounts Payable -$4,934.00 $4,934.00 $0.00 $0.00
Economic Development G 150-22204 Deferred Inflow of Resources -$1,961.95 $1,961.95 $0.00 $0.00
Economic Development G 150-24415 Design. Fd Bal-Capital Proj -$37,151.57 $0.00 $0.00 -$37,151.57
Economic Development G 150-25310 Appropriated Fund Balance -$75,334.07 $306,492.21 $336,094.84 -$104,936.70
FUND 150 Economic Development $0.00 $645,101.23 $645,101.23 $0.00
FUND 157 TIF 2-1 Millstream
TIF 2-1 Millstream G 157-10100 Cash $14,115.17 $22,369.17 $20,038.57 $16,445.77
TIF 2-1 Millstream G 157-10450 Interest Receivable $4.56 $0.00 $4.56 $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 -$14,119.73 $20,043.13 $22,369.17 -$16,445.77
FUND 157 TIF 2-1 Millstream $0.00 $42,412.30 $42,412.30 $0.00
FUND 158 TIF 2-2 Meat Market
TIF 2-2 Meat Market G 158-10100 Cash $34.13 $2,015.61 $2,032.46 $17.28
TIF 2-2 Meat Market G 158-10450 Interest Receivable $0.07 $0.00 $0.07 $0.00
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 $465.80 $2,032.53 $2,015.61 $482.72
FUND 158 TIF 2-2 Meat Market $0.00
$4,048.14 $4,048.14 $0.00
FUND 250 Revolving Loan Fund
Revolving Loan Fund G 250-10100 Cash $30,853.05 $7,890.19 $8.62 $38,734.62
Revolving Loan Fund G 250-10450 Interest Receivable $8.76 $0.00 $8.76 $0.00
Revolving Loan Fund G 250-11900 Notes Receivable $29,035.23 $0.00 $29,035.23 $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 Inflow of Resources -$29,035.23 $29,035.23 $0.00 $0.00
Revolving Loan Fund G 250-25310 Appropriated Fund Balance -$30,861.81 $17.38 $7,890.19 -$38,734.62
FUND 250 Revolving Loan Fund $0.00 $36,942.80 $36,942.80 $0.00
$0.00 $728,504.47 $728,504.47 $0.00
/ I/
CITY OF ST. JOSEPH
EDA Check Register
...c. ,nm
CHECK
# Search Name Comments FUND DEPART Amount
048401 BRAND BUILT HOMES,INC. CDAP grant pmt#15-Beehler 150 46500 $17,478.00
048406 TRI-COUNTY ACTION PROGRAM INC CDAP grant pmt#15-Pekarek 150 46500 $445.00
048407 CENTURYLINK BUSINESS SERVICES Sept long distance telephone 150 46500 $4.83
048413 CENTURYLINK T1 line/20 sets 229#'s-Oct 150 46500 $61.82
048444 MUNICIPAL DEVELOPMENT CORP Sept-business retention 150 46500 $1,372.16
048444 MUNICIPAL DEVELOPMENT CORP Sept-demolition grant 150 46500 $130.77
048444 MUNICIPAL DEVELOPMENT CORP Sept-mtgs w/qualified projects 150 46500 $762.41
048444 MUNICIPAL DEVELOPMENT CORP Sept-marketing 150 46500 $196.15
048444 MUNICIPAL DEVELOPMENT CORP Sept-organizational developme 150 46500 $413.90
048444 MUNICIPAL DEVELOPMENT CORP Sept-website 150 46500 $43.49
048449 ST.JOSEPH NEWSLEADER,INC discount 150 46500 -$3.78
048449 ST.JOSEPH NEWSLEADER,INC TIF redevelopment PH notice 150 46500 $189.00
048449 ST.JOSEPH NEWSLEADER,INC apply TIF exp against TIF dep 150 46500 -$248.22
048449 ST.JOSEPH NEWSLEADER,INC apply TIF exp against TIF dep 150 46500 $248.22
048509 CENTURYLINK BUSINESS SERVICES long distance telephone Oct 150 46500 $3.85
048519 MINNESOTA HOME IMPROVEMENTS DEED draw[Supan] 150 46500 $3,000.00
048519 MINNESOTA HOME IMPROVEMENTS CDAP draw#16[Supan] 150 46500 $8,379.00
048528 TRI-COUNTY ACTION PROGRAM INC CDAP draw#16[Oren/] 150 46500 $695.00
048538 CENTURYLINK T1 line/20 sets 229#'s-Nov 150 46500 $11.50
048578 CENTURYLINK T1 line Nov 150 46500 $50.36
048597 LEAGUE OF MN CITIES INS TRUST clean up w/c premium 2013-2 150 46500 $0.07
048601 MUNICIPAL DEVELOPMENT CORP Oct organizational developmen 150 46500 $631.92
048601 MUNICIPAL DEVELOPMENT CORP Oct business retention 150 46500 $1,525.36
048601 MUNICIPAL DEVELOPMENT CORP Oct marketing materials 150 46500 $123.26
048601 MUNICIPAL DEVELOPMENT CORP Oct website 150 46500 $76.96
048601 MUNICIPAL DEVELOPMENT CORP Oct mtgs qualified projects 150 46500 $739.85
048601 MUNICIPAL DEVELOPMENT CORP Oct BFA grants 150 46500 $30.97
048624 BRAND BUILT HOMES,INC. DEED housing reserve Beehler 150 46500 $3,000.00
048624 BRAND BUILT HOMES,INC. DEED grant draw#17 Beehler 150 46500 $2,522.00
048641 ST.JOSEPH NEWSLEADER,INC legals-CDBG funds 150 46500 $81.00
048641 ST.JOSEPH NEWSLEADER,INC discount 150 46500 -$1.62
$41,963.23
/ 5
JitA.SkA-j\i'L. CITY OF ST. JOSEPH
EDA Revenue Report
Current Period:November 2014
2014 November 2014
FUND Descr SOURCE SOURCE Descr YTD Budget 2014 Amt YTD Amt
FUND 150 Economic Development
Economic Development 31010 Current Ad Valorem Taxes $130,095.00 $0.00 $69,879.68
Economic Development 33160 Federal Grants-Other $0.00 $2,522.00 $224,261.00
Economic Development 34150 TIF/MIF Deposit $0.00 $0.00 $16,751.78
Economic Development 34200 DEED Housing Reimbursem $0.00 $0.00 $0.00
Economic Development 36210 Interest Earnings $500.00 $151.63 $1,700.52
Economic Development 39201 Transfers from Other Funds $0.00 $0.00 $0.00
FUND 150 Economic Development $130,595.00 $2,673.63 $312,592.98
FUND 157 TIF 2-1 Millstream
TIF 2-1 Millstream 31050 Tax Increment $0.00 $0.00 $22,125.28
TIF 2-1 Millstream 33404 Market Value Credit $0.00 $0.00 $0.00
TIF 2-1 Millstream 36210 Interest Earnings $0.00 $16.23 $234.79
..___...--------
FUND 157 TIF 2-1 Millstream $0.00 $16.23 $22,360.07
FUND 158 TIF 2-2 Meat Market
TIF 2-2 Meat Market 31050 Tax Increment $0.00 $0.00 $2,011.66
TIF 2-2 Meat Market 36210 Interest Earnings $0.00 $0.01 $3.80
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 $0.01 $2,015.46
FUND 250 Revolving Loan Fund
Revolving Loan Fund 36210 Interest Earnings $300.00 $36.89 $463.76
Revolving Loan Fund 39320 Revolving Loan Principal $7,095.00 $616.16 $6,693.84
Revolving Loan Fund 39321 Revolving Loan Interest $985.00 $57.39 $715.21
Revolving Loan Fund 39322 Revolving Loan Origination $0.00 $0.00 $0.00
FUND 250 Revolving Loan Fund $8,380.00 $710.44 $7,872.81
$138,975.00 $3,400.31 $344,841.32
1k
iltiA.-P ,_, /� CITY OF ST. JOSEPH
EDA Expenditure Report
Current Period:November 2014
2014 November 2014
Account Descr YTD Budget 2014 Amt YTD Amt
FUND 150 Economic Development
E 150-46500-101 Salaries $4,000.00 $0.00 $0.00
E 150-46500-103 Legislative Bodies $1,260.00 $0.00 $0.00
E 150-46500-122 FICA Contributions $0.00 $0.00 $0.00
E 150-46500-125 Medicare Contributions $0.00 $0.00 $0.00
E 150-46500-151 Workers Comp.Insur. Prem. $10.00 $0.07 $3.57
E 150-46500-200 Office Supplies $500.00 $0.00 $25.28
E 150-46500-215 Software Support $540.00 $0.00 $522.33
E 150-46500-300 Professional Services $28,000.00 $2,357.50 $24,090.66
E 150-46500-303 Engineering Fee $2,000.00 $0.00 $186.60
E 150-46500-304 Legal Fees $1,000.00 $0.00 $0.00
E 150-46500-321 Telephone $785.00 $61.86 $761.55
E 150-46500-322 Postage $350.00 $0.00 $0.00
E 150-46500-328 Marketing $3,000.00 $0.00 $50.00
E 150-46500-331 Travel&Conference Expense $150.00 $0.00 $0.00
E 150-46500-340 Advertising $500.00 $79.38 $79.38
E 150-46500-433 Dues&Memberships $5,000.00 $0.00 $5,000.00
E 150-46500-582 Computer Software $0.00 $0.00 $0.00
E 150-46500-588 EDA Programs $33,500.00 $6,292.82 $252,270.98
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 $130,595.00 $8,791.63 $282,990.35
FUND 157 TIF 2-1 Millstream
E 157-46500-101 Salaries $0.00 $0.00 $55.98
E 157-46500-121 PERA Contributions $0.00 $0.00 $4.06
E 157-46500-122 FICA Contributions $0.00 $0.00 $3.01
E 157-46500-123 Deferred Comp-Employer $0.00 $0.00 $0.94
E 157-46500-125 Medicare Contributions $0.00 $0.00 $0.70
E 157-46500-131 Health Insurance $0.00 $0.00 $9.15
E 157-46500-132 Dental Insurance $0.00 $0.00 $1.55
E 157-46500-133 Life Insurance $0.00 $0.00 $0.12
E 157-46500-134 Disabilty Insurance $0.00 $0.00 $0.77
E 157-46500-300 Professional Services $0.00 $0.00 $0.00
E 157-46500-340 Advertising $0.00 $0.00 $45.00
E 157-46500-622 TIF/Abatement Payments $0.00 $0.00 $19,912.75
E 157-49300-720 Transfers to Other Funds $0.00 $0.00 $0.00
FUND 157 TIF 2-1 Millstream $0.00 $0.00 $20,034.03
FUND 158 TIF 2-2 Meat Market
E 158-46500-101 Salaries $0.00 $0.00 $55.98
E 158-46500-121 PERA Contributions $0.00 $0.00 $4.06
E 158-46500-122 FICA Contributions $0.00 $0.00 $3.02
E 158-46500-123 Deferred Comp-Employer $0.00 $0.00 $0.94
E 158-46500-125 Medicare Contributions $0.00 $0.00 $0.71
E 158-46500-131 Health Insurance $0.00 $0.00 $9.15
E 158-46500-132 Dental Insurance $0.00 $0.00 $1.55
E 158-46500-133 Life Insurance $0.00 $0.00 $0.13
E 158-46500-134 Disabilty Insurance $0.00 $0.00 $0.77
E 158-46500-300 Professional Services $0.00 $0.00 $0.00
E 158-46500-340 Advertising $0.00 $0.00 $45.00
E 158-46500-622 TIF/Abatement Payments $0.00 $0.00 $1,911.07
FUND 158 TIF 2-2 Meat Market $0.00 $0.00 $2,032.38
I -i
J CITY OF ST. JOSEPH
EDA Expenditure Report
Current Period:November 2014
2014 November 2014
Account Descr YTD Budget 2014 Amt YTD Amt
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
$130,595.00 $8,791.63 $305,056.76
Jd
>m o
Y o`
u
T,
o w 0 ' o o. 0 0
F 2 0 v
1 G m rv - ,7'
QO O LIl O O .--, Ql N n
LUO O Ol 00 O V) .-I O p
0,1 O Ln .--I 1 N 00 l0 CO
C a ` N N N N l0 Vl N c-1 IN Q00j
CO '� Lf1 N Ql N N en
cn
N .--I m Ol (U
V) Y N m m m M
aJ
= d a) cN
O
C 7
CU 0 m v _
X a o N n o LU 0 00
0
w � U U �- R m`D v0 en CO
ams a) L a) ,-1
N. ri N N
G O OA fl. O O V LU N Ol 0
LL 3 N N .-i 0-)
V V
L)as Q' 2 _.
CO rl
Cr V O Q
r1 a N O
0
cn
N 0 < in
LL ,I
CO �" N
It
- C C
Iy , N
C
CD
O r
C7 -
O 0 O O p
�+
C. O O O O
N� 111 0 0
O v1
-6 LP 00 M M
Nm
N '-I `-I m m
M O O l0 I� O .-i Ol L/1
.-i y O O lD LU O c-I r-I rl
O - > V O N V .--I O r---. Vl O p
N O N V1 V ,I"
m lD m
0
�•_ d N m V m Ol co_
r-1 I� OMl
Ln
( Lo Li,
fin d 10 O 111 Qi M QCO C
coN
'i
E
as
Ll_
lY) N
E 92
O N
-.c.
) 0)
EO g o o aC .0ao > o N E @ o p 0
' 0 3 aw) aa)) 0 > o
ICD c) w 0 0 c o
v m 01
0 0 0 a) ZQ c .cm Q cQ� � OE mmO u_ cu-
0
r N P 00 0) M nt K)
Li N c‘,
Cl)0
M M M M co) Z:-.4
a Z O G 0 G c"="3
W W W W W www
COCNJCOCU
(0 COin
0
0 0
c O O
in in
0 v CO
V
O
V
Q 0 d
inU
E.
v 0
Lu
4! J
O
a s < Q H
v 0
0
O LL L1J F-
11/1
THIS PAGE INTENTIONALLY LEFT BLANK