HomeMy WebLinkAbout[05] Accounts Payable & Financial Reports .J,;� CITY OF ST. JOSEPH
WWW.cltyoist)oseph.com
DATE: August 20, 2015
MEMO TO: St. Joseph Economic Development Authority
FROM: Cynthia Smith-Strack Municipal Development Group
Administrator
Judy weyrens RE: Accounts Payable
July Financial Reports
Mayor
Rick Schultz
A. Accounts Payable:
Councilors Following are Accounts Payable for the EDA's Consideration.
Matt Killam
Bob Loso Payable To For Fund Amount
Renee Symanietz MDG, Inc. July Econ. Dev. Service 150-46500-300 $ 3,037.63
Dale wick Total $ 3,037.63
EDA *Plus invoices noted on enclosed check register.
Doug Danielson
Larry Hosch As of July 31, 2015 a total of 248 hours of service have been provided.
Gary Osberg
Rick Schultz Action:
Dale wick A MOTION is in order to approve the Accounts Payable.
B. Financial Report:
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. Check Register
6. CIP Summary
A MOTION is in order to approve the Financial Reports.
&OVA 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 8-10-15 Payment Terms: 30 days Customer ID #:
::IISTJ15EDA
Project July Economic Development Services
Amount: $2,500.00 Monthly contract fee
$ 537.63 935 miles x .575
$3,037.63
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 1, 2015 EDA Office Hours: C. Strack 7.50 Hours
July 8, 2015 EDA Office Hours: C. Strack 8.00 Hours
July 15, 2015 EDA Office Hours: C. Strack 7.50 Hours
July 22, 2015 EDA Office Hours: C. Strack 9.00 Hours
July 29, 2015 EDA Office Hours: C. Strack 8.00 Hours
Total July 2015 40.00 Hours
Total Contract Hours July 31, 2015: 248 Hours
Thank you! We appreciated the opportunity to work with you!
Check No. Cynthia Smi[6-,Yfrae�
Date: Cynthia Smith-Strack,Principal MDG
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
July 2015
Fund 150, EDA Balance as of December 31, 2014(Audited) 103,522.49
Year to Date Revenue:
Interest Earnings 711.33
TIF/MIF Deposit (unused returned to Bayou Blues) (10,751.78)
DEED Housing Grant Proceeds 69,036.00
Ad Valorem Taxes 49,362.75
Transfers from Other Funds 9,134.00
Total Revenue 117,492.30
Year to Date Expenditure Total by Project:
Market Development 1,193.14 **
Business Development 5,756.10 **
Organizational Development 1,706.48 **
Infrastructure Development 1,016.70 **
Workforce Development - **
9,672.42
Year to Date Expenditures by Object:
Board Stipends (385.00)
Staff Salaries (1,651.23)
Workers Comp Premium -
Software Support/Office Supplies (554.47)
Municipal Development Group (15,252.41)
Legal/Engineering Fees (1,583.80)
Telephone (459.07)
Greater St. Cloud Development Investment (5,000.00)
Business Round Table Outreach -
Marketing (1,772.69)
Advertising (194.91)
Coborn's Abatement -
CM Housing Grant Reimbursement (69,036.00)
EDA Programs (11,589.21)
Transfer to Other Funds (7,951.00)
Total Expenses (115,429.79)
Fund Summaries as of July 31, 2015:
EDA Fund Balance -Fund 150 - unaudited 105,585.00
Designated for Capital Programs 68,170.78
Designated for DEED Housing Projects 368.57
Undesignated 37,045.65
TIF 3-1 Central MN Credit Union Fund Balance -Fund 152 (5,596.51)
TIF 2-1 Millstream Shops and Lofts Fund Balance -Fund 157 15,623.95
TIF 2-2 St. Joseph Meat Market Fund Balance -Fund 158 (357.12)
TIF 2-3 Bayou Blues &Alley Flats Fund Balance -Fund 159 (4,262.70)
Revolving Loan Fund Balance -Fund 250 5,815.00
'*Detail available upon request
CITY OF ST. JOSEPH 08/14/15 9:27 AM
EDA Balance Sheet Page 1
Current Period:July 2015
YTD YTD Current
FUND Descr Account Descr Beqin Yr Debit Credit Balance
FUND 150 Economic Development
Economic Development G 150-10100 Cash $109,443.65 $139,035.56 $143,394.21 $105,085.00
Economic Development G 150-10450 Interest Receivable $215.50 $0.00 $215.50 $0.00
Economic Development G 150-10700 Taxes Receivable-Delinquen $1,316.15 $0.00 $1,316.15 $0.00
Economic Development G 150-13113 Due From other Gov t Units $0.00 $0.00 $0.00 $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 -$6,601.63 $6,601.63 $0.00 $0.00
Economic Development G 150-20201 Salaries Payable -$35.03 $35.03 $0.00 $0.00
Economic Development G 150-22204 Deferred Inflow of Resources -$1,316.15 $1,316.15 $0.00 $0.00
Economic Development G 150-24415 Design. Fd Bal-Capital Proj -$53,041.94 $0.00 $0.00 -$53,041.94
Economic Development G 150-25310 Appropriated Fund Balance -$50,480.55 $143,609.71 $145,672.22 -$52,543.06
FUND 150 Economic Development $0.00 $290,598.08 $290,598.08 $0.00
FUND 152 TIF 3-1 CMCU
TIF 3-1 CMCU G 152-10100 Cash $0.00 $0.00 $5,596.51 -$5,596.51
TIF 3-1 CMCU G 152-10450 Interest Receivable $0.00 $0.00 $0.00 $0.00
TIF 3-1 CMCU G 152-20200 Accounts Payable $0.00 $0.00 $0.00 $0.00
TIF 3-1 CMCU G 152-25310 Appropriated Fund Balance $0.00 $5,596.51 $0.00 $5,596.51
FUND 152 TIF 3-1 CMCU $0.00 $5,596.51 $5,596.51 $0.00
FUND 157 TIF 2-1 Millstream
TIF 2-1 Millstream G 157-10100 Cash $17,951.81 $21,678.56 $24,006.42 $15,623.95
TIF 2-1 Millstream G 157-10450 Interest Receivable $29.72 $0.00 $29.72 $0.00
TIF 2-1 Millstream G 157-25310 Appropriated Fund Balance -$17,981.53 $24,036.14 $21,678.56 -$15,623.95
FUND 157 TIF 2-1 Millstream $0.00 $45,714.70 $45,714.70 $0.00
FUND 158 TIF 2-2 Meat Market
TIF 2-2 Meat Market G 158-10100 Cash $116.36 $1,984.52 $1,958.00 $142.88
TIF 2-2 Meat Market G 158-10450 Interest Receivable $0.25 $0.00 $0.25 $0.00
TIF 2-2 Meat Market G 158-20201 Salaries Payable -$17.52 $17.52 $0.00 $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 $400.91 $1,958.25 $2,002.04 $357.12
FUND 158 TIF 2-2 Meat Market $0.00 $3,960.29 $3,960.29 $0.00
FUND 159 TIF 2-3 Bayou Blues/Alley Flat
TIF 2-3 Bayou Blues/All G 159-10100 Cash $0.00 $0.00 $4,262.70 -$4,262.70
TIF 2-3 Bayou Blues/All G 159-10450 Interest Receivable $0.00 $0.00 $0.00 $0.00
TIF 2-3 Bayou Blues/All G 159-20200 Accounts Payable $0.00 $0.00 $0.00 $0.00
TIF 2-3 Bayou Blues/All G 159-25310 Appropriated Fund Balance $0.00 $4,262.70 $0.00 $4,262.70
FUND 159 TIF 2-3 Bayou Blues/Alley Flat $0.00 $4,262.70 $4,262.70 $0.00
FUND 250 Revolving Loan Fund
Revolving Loan Fund G 250-10100 Cash $39,469.77 $15,340.96 $48,995.73 $5,815.00
Revolving Loan Fund G 250-10450 Interest Receivable $63.29 $0.00 $63.29 $0.00
Revolving Loan Fund G 250-11900 Notes Receivable $21,723.72 $0.00 $21,723.72 $0.00
Revolving Loan Fund G 250-22204 Deferred Inflow of Resources -$21,723.72 $21,723.72 $0.00 $0.00
Revolving Loan Fund G 250-25310 Appropriated Fund Balance -$39,533.06 $49,059.02 $15,340.96 -$5,815.00
FUND 250 Revolving Loan Fund $0.00 $86,123.70 $86,123.70 $0.00
$0.00 $436,255.98 $436,255.98 $0.00
CITY OF ST. JOSEPH 08/14/15 9:27 AM
''1 EDA Check Register Page 1
R�.Cily4."ePkA.
CHECK
# Search Name Comments FUND DEPART Amount
049069 OSBERG,GARY move 1st quarter mtgs to EDA 150 46500 $140.00
049412 COLLEGEVILLE COMMUNITIES,LLC demolition grant 24 College Av 150 46500 $2,500.00
049415 ENGHOLM,STACIE&JEFF BFA grant-27 MN St W 150 46500 $1,000.00
049417 GARY S PIZZA BFA grant- 17 College Ave N 150 46500 $829.99
049431 MINNWEST BANK 1st half TIF pmt Millstream Sh 157 46500 $19,302.34
049434 PFANNENSTEIN, HARVEY&CAROL 1st half TIF pmt Meat Market 158 46500 $1,882.34
049437 SEH,INC May Warehouse 150 46500 $147.60
049437 SEH,INC May EDA maps 150 46500 $419.50
049445 BRAND BUILT HOMES,INC. DEED grant draw#24 [Brinker 150 46500 $10,826.00
049455 CENTURYLINK July T1 line/20 sets 229#'s 150 46500 $62.01
049456 CENTURYLINK BUSINESS SERVICES June long distance telephone 150 46500 $4.72
049480 BRIGGS AND MORGAN legal consult-TIF 3-1 credit u 152 46500 $3,000.00
049492 JOVANOVICH,KADLEC&ATHMANN June RLF loan recording fees 250 46500 $92.00
049500 MUNICIPAL DEVELOPMENT CORP June business retention 150 46500 $1,590.20
049500 MUNICIPAL DEVELOPMENT CORP June mtgs w/qualified projects 150 46500 $232.68
049500 MUNICIPAL DEVELOPMENT CORP June BFA loans 150 46500 $232.68
049500 MUNICIPAL DEVELOPMENT CORP June website 150 46500 $116.48
049500 MUNICIPAL DEVELOPMENT CORP June organization development 150 46500 $543.01
049517 BAYOU ALLEY FLATS, LLC unused TIF deposit returned 150 46500 $5,251.78
049521 DANIELSON, DOUG EDA mtgs Jan-June 150 46500 $175.00
049528 OSBERG,GARY EDA mtgs Jan-June 150 46500 $70.00
049530 RYAN CONSULTING TIF Plan/Developer's Agreeme 150 46500 $5,500.00
049530 RYAN CONSULTING TIF Plan/Developer's Agreeme 150 46500 $1,500.00
049530 RYAN CONSULTING TIF Plan/Developer's Agreeme 150 46500 $6,500.00
049533 SENTRY BANK-CREDIT CARD ESRI reports-EDA 150 46500 $50.00
$61,968.33
CITY OF ST. JOSEPH 08/14/15 9:28 AM
EDA Revenue Report Page 1
Current Period:July 2015
2015 July 2015
FUND Descr SOURCE SOURCE Descr YTD Budget 2015 Amt YTD Amt
FUND 150 Economic Development
Economic Development 31010 Current Ad Valorem Taxes $94,595.00 $14,808.35 $49,362.75
Economic Development 33160 Federal Grants-Other $0.00 $10,826.00 $69,036.00
Economic Development 34150 TIF/MIF Deposit $0.00 -$10,751.78 -$10,751.78
Economic Development 34200 DEED Housing Reimbursem $0.00 $0.00 $0.00
Economic Development 36210 Interest Earnings $1,000.00 $174.36 $711.33
Economic Development 39201 Transfers from Other Funds $0.00 $0.00 $9,134.00
FUND 150 Economic Development $95,595.00 $15,056.93 $117,492.30
FUND 152 TIF 3-1 CMCU
TIF 3-1 CMCU 31050 Tax Increment $0.00 $0.00 $0.00
TIF 3-1 CMCU 36210 Interest Earnings $0.00 $0.00 $0.00
FUND 152 TIF 3-1 CMCU $0.00 $0.00 $0.00
FUND 157 TIF 2-1 Millstream
TIF 2-1 Millstream 31050 Tax Increment $0.00 $6,434.11 $21,447.04
TIF 2-1 Millstream 36210 Interest Earnings $0.00 $38.07 $122.36
FUND 157 TIF 2-1 Millstream $0.00 $6,472.18 $21,569.40
FUND 158 TIF 2-2 Meat Market
TIF 2-2 Meat Market 31050 Tax Increment $0.00 $594.41 $1,981.41
TIF 2-2 Meat Market 36210 Interest Earnings $0.00 $1.01 $1.19
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 $595.42 $1,982.60
FUND 159 TIF 2-3 Bayou Blues/Alley Flat
TIF 2-3 Bayou Blues/Alley Fla 31050 Tax Increment $0.00 $0.00 $0.00
TIF 2-3 Bayou Blues/Alley Fla 36210 Interest Earnings $0.00 $0.00 $0.00
FUND 159 TIF 2-3 Bayou Blues/Alley Flat $0.00 $0.00 $0.00
FUND 250 Revolving Loan Fund
Revolving Loan Fund 36210 Interest Earnings $300.00 $33.19 $253.70
Revolving Loan Fund 39201 Transfers from Other Funds $0.00 $0.00 $7,951.00
Revolving Loan Fund 39320 Revolving Loan Principal $7,095.00 $814.21 $4,555.95
Revolving Loan Fund 39321 Revolving Loan Interest $985.00 $74.96 $377.52
Revolving Loan Fund 39322 Revolving Loan Origination $0.00 $0.00 $470.00
FUND 250 Revolving Loan Fund $8,380.00 $922.36 $13,608.17
$103,975.00 $23,046.89 $154,652.47
CITY OF ST. JOSEPH 08/14/15 9:27 AM
EDA Expenditure Report Page 1
Current Period:July 2015
2015 July 2015
Account Descr YTD Budget 2015 Amt YTD Amt
FUND 150 Economic Development
E 150-46500-101 Salaries $4,000.00 $0.00 $1,533.90
E 150-46500-103 Legislative Bodies $1,260.00 $385.00 $385.00
E 150-46500-121 PERA Contributions $0.00 $0.00 $0.57
E 150-46500-122 FICA Contributions $0.00 $0.00 $94.98
E 150-46500-123 Deferred Comp-Employer $0.00 $0.00 -$0.43
E 150-46500-125 Medicare Contributions $0.00 $0.00 $22.21
E 150-46500-130 H S A-Employer Contribution $0.00 $0.00 $0.00
E 150-46500-131 Health Insurance $0.00 $0.00 $0.00
E 150-46500-132 Dental Insurance $0.00 $0.00 $0.00
E 150-46500-133 Life Insurance $0.00 $0.00 $0.00
E 150-46500-134 Disabilty Insurance $0.00 $0.00 $0.00
E 150-46500-151 Workers Comp. Insur. Prem. $10.00 $0.00 $0.00
E 150-46500-171 Clothing Allowance $0.00 $0.00 $0.00
E 150-46500-200 Office Supplies $500.00 $0.00 $32.14
E 150-46500-215 Software Support $540.00 $0.00 $522.33
E 150-46500-300 Professional Services $28,000.00 $2,249.69 $15,252.41
E 150-46500-303 Engineering Fee $2,000.00 $567.10 $1,151.80
E 150-46500-304 Legal Fees $1,000.00 $0.00 $432.00
E 150-46500-321 Telephone $785.00 $66.73 $459.07
E 150-46500-322 Postage $350.00 $0.00 $0.00
E 150-46500-328 Marketing $3,000.00 $1,550.00 $1,772.69
E 150-46500-331 Travel&Conference Expense $150.00 $0.00 $0.00
E 150-46500-340 Advertising $500.00 $0.00 $194.91
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 $22,121.35 $80,625.21
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 $7,951.00
FUND 150 Economic Development $130,595.00 $26,939.87 $115,429.79
FUND 152 TIF 3-1 CMCU
E 152-46500-300 Professional Services $0.00 $3,000.00 $4,579.51
E 152-46500-301 Audit&Accounting Services $0.00 $0.00 $0.00
E 152-46500-340 Advertising $0.00 $0.00 $0.00
E 152-46500-622 TIF/Abatement Payments $0.00 $0.00 $0.00
E 152-49300-720 Transfers to Other Funds $0.00 $0.00 $1,017.00
FUND 152 TIF 3-1 CMCU $0.00 $3,000.00 $5,596.51
FUND 157 TIF 2-1 Millstream
E 157-46500-101 Salaries $420.00 $0.00 $0.00
E 157-46500-121 PERA Contributions $30.00 $0.00 $0.00
E 157-46500-122 FICA Contributions $25.00 $0.00 $0.00
E 157-46500-123 Deferred Comp-Employer $10.00 $0.00 $0.00
E 157-46500-125 Medicare Contributions $5.00 $0.00 $0.00
E 157-46500-131 Health Insurance $60.00 $0.00 $0.00
E 157-46500-132 Dental Insurance $10.00 $0.00 $0.00
E 157-46500-133 Life Insurance $5.00 $0.00 $0.00
E 157-46500-134 Disabilty Insurance $5.00 $0.00 $0.00
E 157-46500-300 Professional Services $0.00 $0.00 $312.51
E 157-46500-301 Audit&Accounting Services $0.00 $0.00 $0.00
E 157-46500-340 Advertising $0.00 $0.00 $45.32
E 157-46500-622 TIF/Abatement Payments $0.00 $19,302.34 $19,302.34
E 157-49300-720 Transfers to Other Funds $0.00 $0.00 $4,266.81
CITY OF ST. JOSEPH 08/14/15 9:27 AM
EDA Expenditure Report Page 2
Current Period:July 2015
2015 July 2015
Account Descr YTD Budget 2015 Amt YTD Amt
FUND 157 TIF 2-1 Millstream $570.00 $19,302.34 $23,926.98
FUND 158 TIF 2-2 Meat Market
E 158-46500-101 Salaries $420.00 $0.00 $3.83
E 158-46500-121 PERA Contributions $30.00 $0.00 $0.29
E 158-46500-122 FICA Contributions $25.00 $0.00 $0.17
E 158-46500-123 Deferred Comp-Employer $10.00 $0.00 $0.05
E 158-46500-125 Medicare Contributions $5.00 $0.00 $0.04
E 158-46500-131 Health Insurance $60.00 $0.00 $5.37
E 158-46500-132 Dental Insurance $10.00 $0.00 $0.89
E 158-46500-133 Life Insurance $5.00 $0.00 $0.07
E 158-46500-134 Disabilty Insurance $5.00 $0.00 $0.44
E 158-46500-300 Professional Services $0.00 $0.00 $0.00
E 158-46500-301 Audit&Accounting Services $0.00 $0.00 $0.00
E 158-46500-340 Advertising $0.00 $0.00 $45.32
E 158-46500-622 TIF/Abatement Payments $0.00 $1,882.34 $1,882.34
FUND 158 TIF 2-2 Meat Market $570.00 $1,882.34 $1,938.81
FUND 159 TIF 2-3 Bayou Blues/Alley Flat
E 159-46500-300 Professional Services $0.00 $0.00 $412.51
E 159-46500-301 Audit&Accounting Services $0.00 $0.00 $0.00
E 159-46500-340 Advertising $0.00 $0.00 $0.00
E 159-46500-622 TIF/Abatement Payments $0.00 $0.00 $0.00
E 159-49300-720 Transfers to Other Funds $0.00 $0.00 $3,850.19
FUND 159 TIF 2-3 Bayou Blues/Alley Flat $0.00 $0.00 $4,262.70
FUND 250 Revolving Loan Fund
E 250-46500-300 Professional Services $0.00 $0.00 $434.23
E 250-46500-304 Legal Fees $0.00 $0.00 $0.10
E 250-46500-317 Other fees $0.00 $0.00 -$108.10
E 250-46500-434 Certification Fee $0.00 $92.00 $0.00
E 250-46500-455 Revolving Loan Proceeds $0.00 $0.00 $47,000.00
FUND 250 Revolving Loan Fund $0.00 $92.00 $47,326.23
$131,735.00 $51,216.55 $198,481.02
ff
m
m �
u a
u v
u 7
O Oi B O O m O O W
Ln O^ M l0 v r` r` 'i N
2 c-I rr00 w r` w W
N m w ci
CO N
M OU� W OM O Ol LFII LQ O
N
L = N w O Ol O C M
t y 0 Lr r` O ri O
3 N N v Ln ci NN NN N �
O
L
a+
O
\ N U1 N chi O O
O
0 �1/f CO Ol �O O C
14 �" m W O
3 R N
O H
a
0
LJJ O O O O O
C O O O O O
m O O O ' O N
IA D_ -a 0 CO N M M M
al 4+ -1 N c-I ci M
C 4, O CO
al alb N
Nt
y O m v
X CL O_ �"� y O O N m W Ln I-i M m O
W U v N u 00 Ln Ln m -i ' � r, r O
f6 a1 41 r`41 N W r` N Lr) ci Ol 0 M
f6UQ. Ln N Q N
LR U O Li
'a N O
N = Q E E
E
M Q
f6 LL O) N 0
i O) O N
C 0-y 0 N 0 N
C7 E o O CO .o J o 0 0
34 a) O LL (J) a)
LU
0 0 w > 0 (�
U
0 m c 0 CO m
O U)
�
Z3 U N 0
C9 = U
E .- Q c Q CO
O Z) Z)Z) LL a) cn
U Jm0- CO oo � U N
T N f'- h OD M 'I N 0)
O O O O O O O O O
d M M M M M M M M M
a` Z D coca 0 0 0 a
W W W W W W W W W
00 00
0 L? L?O
V o O
+ O O
Lr) LO
O � �
V
Q
O O 0-
C)U
c Q
+. v 0
£ W
X
i
0 J
It aai 0 0 ~
W W