HomeMy WebLinkAbout[05] Accounts Payable and Financial Report • CITY OF ST. JOSEPH
www.cityofstjoseph.com
DATE: April 18, 2012
MEMO TO: St. Joseph Economic Development Authority
FROM: Cynthia Smith - Strack, Municipal Development Group
Administrator
Judy Weyrens RE: Accounts Payable
March 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. Feb. Econ. Dev. Service 150 -46500 -300 $ 2,563.25
Dale Wick Total $ 2,563.25
EDA
Larry Hosch Action:
Chad Davey A MOTION is in order to approve the Accounts Payable.
Steve Frank
Tom Skahen
Dale Wick B. Financial Report:
March 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.
664 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 3 -10 -12 Payment Terms: 30 days Customer ID #:
STJ I2EDA
Project March Economic Development Services
See attached detail
Amount: $2,200.00 Monthly contract fee
$ 363.25 654.5 miles x .555
$2,563.25
Code to: 150 -46500 -300 for general EDA
Remit To: Municipal Development Group, Inc.
25562 Willow Lane
New Prague, MN 56071
Dates -EDA Hours
March 7, 2012 EDA Office Hours: C. Strack 8.00 Hours
March 14, 2012 EDA Office Hours: C. Strack 8.00 Hours
March 21, 2012 EDA Office Hours: C. Strack 8.00 Hours
March 28, 2012 EDA Office Hours: C. Strack 9.00 Hours
Total March 2012 33.00 Hours
Total Contract Hours Thru March 31, 2012: 132.50 Hours
Thank you! We appreciated the opportunity to work with you!
6: ja - * 04--
Check No.
Date: Principal
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
March 31, 2012
Fund 150, EDA Balance as of December 31, 2011 (audited) 49,582.49
Year to Date Revenue:
Interest Earnings 291.40
Ad Valorem Taxes -
Total Revenue 291.40
Year to Date Expenditure Total by Project:
Market Development 1,708.94 **
Business Development 2,583.91 **
Organizational Development 4,051.03 **
Infrastructure Development 33.03 **
Workforce Development **
8,376.91
Year to Date Expenditures by Obiect:
Board Stipends (1,120.00)
Staff Salaries -
Workers Comp Premium -
Office Supplies -
Software Support (529.52)
Municipal Development Group (6,433.49)
Legal /Engineering Fees (405.00)
Telephone (197.39)
Postage -
Business Luncheon -
Advertising (415.00)
Recording Fee -
Rentals (Postage Machine) -
St. Cloud EDA Membership Dues -
EDA Programs (1,567.61)
Total Expenses (10,668.01)
Fund Summaries as of March 31, 2011:
EDA Fund Balance - Fund 150 - unaudited 39,205.88
Designated for Capital Programs 29,695.69
Designated for DEED Housing Projects 16,368.57
Undesignated (6,858.38)
TIF 1-4 St. Joseph Development Fund Balance - Fund 156 (1,950.82)
TIF 2 -1 Millstream Shops and Lofts Fund Balance - Fund 157 5,976.73
TIF 2 -2 St. Joseph Meat Market Fund Balance - Fund 158 (296.74)
Revolving Loan Fund Balance - Fund 250 16,306.93
** Detail available upon request
t CITY OF ST JOSEPH 04/13/12 9:24 AM
`l /�' 1.1& EDA Balance Sheet Page 1
Current Period: March 2012
YTD YTD Current
FUND Descr Account Descr Begin Yr Debit Credit Balance
FUND 150 Economic Development
Economic Development G 150 -10100 Cash $51,328.42 $291.40 $10,668.01 $40,951.81
Economic Development G 150 -10450 Interest Receivable $33.58 $0.00 $0.00 $33.58
Economic Development G 150 -15500 Due From Other Fund $2,300.00 $0.00 $0.00 $2,300.00
Economic Development G 150 -20200 Accounts Payable - $4,079.51 $0.00 $0.00 - $4,079.51
Economic Development G 150 -24415 Design. Fd Bal - Capital Proj - $20,131.87 $0.00 $0.00 120,131.87
Economic Development G 150 -25310 Appropriated Fund Balance - $29,450.62 $10,668.01 $291.40 - $19,074.01
FUND 150 Economic Development $0.00 $10,959.41 $10,959.41 $0.00
FUND 156 TIF 1 -4 St. Joe Development
TIF 1-4 St. Joe Develop G 156 -10100 Cash $17.95 $0.03 $9.17 $8.81
TIF 1 -4 St. Joe Develop G 156-10450 Interest Receivable $40.37 $0.00 $0.00 $40.37
TIF 1-4 St. Joe Develop G 156 -20500 Due To Other Fund - $2,000.00 $0.00 $0.00 - $2,000.00
TIF 1-4 St. Joe Develop G 156 -25310 Appropriated Fund Balance $1,941.68 $9.17 $0.03 $1,950.82
FUND 156 TIF 1 -4 St. Joe Development $0.00 $9.20 $9.20 $0.00
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream G 157 -10100 Cash $8,443.84 $92.92 $1,327.63 $7,209.13
TIF 2 -1 Millstream G 157 -10450 Interest Receivable $10.02 $0.00 $0.00 $10.02
TIF 2 -1 Millstream G 157 -13113 Due From other Gov t Units $42.48 $0.00 $0.00 $42.48
TIF 2 -1 Millstream G 157 -20200 Accounts Payable - $1,284.90 $0.00 $0.00 - $1,284.90
TIF 2 -1 Millstream G 157 -25310 Appropriated Fund Balance - $7,211.44 $1,327.63 $92.92 - $5,976.73
FUND 157 TIF 2 -1 Millstream $0.00 $1,420.55 $1,420.55 $0.00
FUND 158 TIF 2 -2 Meat Market
TIF 2 -2 Meat Market G 158 -10100 Cash $3.26 $0.00 $0.00 $3.26
TIF 2 -2 Meat Market G 158 -20500 Due To Other Fund - $300.00 $0.00 $0.00 - $300.00
TIF 2 -2 Meat Market G 158 -25310 Appropriated Fund Balance $296.74 $0.00 $0.00 $296.74
FUND 158 TIF 2 -2 Meat Market $0.00 $0.00 $0.00 $0.00
FUND 250 Revolving Loan Fund
Revolving Loan Fund G 250 -10100 Cash $14,158.07 $2,114.91 $0.00 $16,272.98
Revolving Loan Fund G 250 -10450 Interest Receivable $33.95 $0.00 $0.00 $33.95
Revolving Loan Fund G 250 -11900 Notes Receivable $43,017.08 $0.00 $0.00 $43,017.08
Revolving Loan Fund G 250 -20200 Accounts Payable $0.00 $0.00 $0.00 $0.00
Revolving Loan Fund G 250 -22204 Deferred Revenue - $43,017.08 $0.00 $0.00 - $43,017.08
Revolving Loan Fund G 250 -25310 Appropriated Fund Balance - $14,192.02 $0.00 $2,114.91 - $16,306.93
FUND 250 Revolving Loan Fund $0.00 $2,114.91 $2,114.91 $0.00
$0.00 $14,504.07 $14,504.07 $0.00
A CITY OF ST JOSEPH 04/13/12 9:26 AM
ri►/ Page 1
E DA Revenue Report
Current Period: March 2012
2012 March 2012
FUND Descr SOURCE SOURCE Descr YTD Budget 2012 Amt YTD Amt
FUND 150 Economic Development
Economic Development 31010 Current Ad Valorem Taxes $70,500.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 $0.00
Economic Development 36210 Interest Earnings $225.00 $191.85 $291.40
Economic Development 39201 Transfers from Other Funds $0.00 $0.00 $0.00
FUND 150 Economic Development $70,725.00 $191.85 $291.40
FUND 156 TIF 1 -4 St. Joe Development
TIF 1-4 St. Joe Development 31050 Tax Increment $0.00 $0.00 $0.00
TIF 1-4 St. Joe Development 36210 Interest Eamings $0.00 $0.03 19.14
FUND 156 TIF 1-4 St. Joe Development $0.00 $0.03 19.14
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream 31050 Tax Increment $0.00 $0.00 $42.48
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 Eamings $0.00 $32.68 $50.44
FUND 157 TIF 2 -1 Millstream $0.00 $32.68 $92.92
FUND 250 Revolving Loan Fund
Revolving Loan Fund 36210 Interest Eamings $300.00 $60.27 $94.26
Revolving Loan Fund 39320 Revolving Loan Principal $6,885.00 $568.84 $1,702.27
Revolving Loan Fund 39321 Revolving Loan Interest $1,195.00 $104.71 $318.38
Revolving Loan Fund 39322 Revolving Loan Origination $0.00 $0.00 $0.00
FUND 250 Revolving Loan Fund $8,380.00 $733.82 $2,114.91
$79,105.00 $958.38 $2,490.09
f CITY OF ST JOSEPH 04/13/12 9:25 AM
`�/ EDA Expenditure Report Page 1
Current Period: March 2012
2012 March 2012
Account Descr YTD Budget 2012 Amt YTD Amt
FUND 150 Economic Development
E 150 - 46500 -103 Legislative Bodies $1,390.00 $35.00 $1,120.00
E 150 - 46500 -151 Workers Comp. Insur. Prem. $10.00 $0.00 $0.00
E 150 - 46500 -200 Office Supplies $500.00 $0.00 $0.00
E 150 - 46500 -215 Software Support $540.00 $0.00 $529.52
E 150-46500 -300 Professional Services $28,000.00 $1,617.98 $6,433.49
E 150 - 46500 -303 Engineering Fee $2,000.00 $0.00 $0.00
E 150 - 46500 -304 Legal Fees $1,000.00 $13.50 $405.00
E 150 - 46500 -321 Telephone $785.00 $69.26 $197.39
E 150 - 46500 -322 Postage $350.00 $0.00 $0.00
E 150 - 46500 -328 Marketing $8,000.00 $0.00 $0.00
E 150 - 46500 -331 Travel & Conference Expense $150.00 $0.00 $0.00
E 150 - 46500 -340 Advertising $500.00 $39.19 $415.00
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 $27,500.00 $1,204.73 $1,567.61
E 150 -46500 -622 TIF /Abatement Payments $0.00 $0.00 $0.00
FUND 150 Economic Development $70,725.00 $2,979.66 $10,668.01
FUND 156 TIF 1-4 St. Joe Development
E 156 - 46500 -101 Salaries $0.00 $0.00 $0.00
E 156 - 46500 -121 PERA Contributions $0.00 $0.00 $0.00
E 156 -46500 -122 FICA Contributions $0.00 $0.00 $0.00
E 156 - 46500 -123 Deferred Comp- Employer $0.00 $0.00 $0.00
E 156 - 46500 -125 Medicare Contributions $0.00 $0.00 $0.00
E 156- 46500 -131 Health Insurance $0.00 $0.00 $0.00
E 156 - 46500 -133 Life Insurance $0.00 $0.00 $0.00
E 156- 46500 -134 Disabilty Insurance $0.00 $0.00 $0.00
E 156 - 46500 -300 Professional Services $0.00 $0.00 $0.00
E 156 -46500 -340 Advertising $0.00 $0.00 $0.00
E 156 -46500 -588 EDA Programs $0.00 $0.00 $0.00
E 156 - 46500 -622 TIF /Abatement Payments $0.00 $0.00 $0.00
FUND 156 TIF 1-4 St. Joe Development $0.00 $0.00 $0.00
FUND 157 TIF 2-1 Millstream
E 157 - 46500 -101 Salaries $0.00 $36.22 $36.22
E 157 - 46500 -121 PERA Contributions $0.00 $2.62 $2.62
E 157 - 46500 -122 FICA Contributions $0.00 $2.25 $2.25
E 157 - 46500 -123 Deferred Comp- Employer $0.00 $0.57 $0.57
E 157 - 46500-125 Medicare Contributions $0.00 $0.53 $0.53
E 157 -46500 -131 Health Insurance $0.00 $0.00 $0.00
E 157 - 46500 -133 Life Insurance $0.00 $0.07 $0.07
E 157- 46500 -134 Disabilty Insurance $0.00 $0.47 $0.47
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 TIF /Abatement Payments $0.00 $0.00 $1,284.90
E 157 - 49300 -720 Transfers to Other Funds $0.00 $0.00 $0.00
FUND 157 TIF 2 -1 Millstream $0.00 $42.73 $1,327.63
FUND 158 TIF 2 -2 Meat Market
A CITY OF ST JOSEPH 04/13/12 9:25 AM
Page 2
,,,,fil A.,-- EDA Expenditure Report
Current Period: March 2012
2012 March 2012
Account Descr YTD Budget 2012 Amt YTD Amt
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
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 $0.00 $0.00
E 158-46500 -340 Advertising $0.00 $0.00 $0.00
E 158- 46500 -622 TIF /Abatement Payments $0.00 $0.00 $0.00
FUND 158 TIF 2 -2 Meat Market $0.00 $0.00 $0.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 $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
$70,725.00 $3,022.39 $11,995.64
z v >
O n Q N .4 N V al l0 $ Ln al
Q O h� O N Ti.- l0 111 Tr N - V Crl 0
W .-I g3 1 v 0 00 N
' Lr; N ei N
C
CO 4-,
, \ %„.....„
E: .n >, in
3 N O N 1, xxea..
V
C E O \ 0 O o V 00 o 0 0 0 1O
C V 0 - r M i+ M Ol e- N M ct M N
X a °; M s d N O^1 V o% 0 v m i 0
n tie 0 0
To E 0 L `O N N
a' N a+
u OS o N
U O .n — In
ri C -0 C a. m Q M Q i i i
N
N LL _ V 3 C N
T2 G w
C r
QJ N > r > ; 1 -A,0, 4t i 'lr'' - 4 1 , ,, : '71
ai O V1 N t0 O LI.1 ei a -1 O O
awl y O V1 O a--1 O l0 01 M M
0 ` V O e-I N .-� O 1 11 m to M
-F. CU A N 'd• l0 V in t0 t0 m u1
M 73 d7 r1 ; I V1 — ti; N N r.1
M
N a CC m N
ei
CD of
LL j N
cn E N
VJ O` fC i r,
C C 0- co U)
n'' N C O C
= aJ C E O= C O
al G to = a C
E 2 C N V O W •` N
a o 3 a ° aa) > o
w 0 o o o c o M
7 O y 8 N U N
a C7 C 7 C (7 as 2
E .51) •y C • y Q C Q
U L -1) m O m m O
m
c4 co
11/ co 00
G
u O O LO
C
v
C O O
a u1 uo
a
U
a, o
E w
•O
a d o a p
o w w