HomeMy WebLinkAbout[06] Accounts Payable and Financial Report •
CITY OF ST. JOSEPH
www.cityofstrseph.com
DATE: July 5, 2012
MEMO TO: St. Joseph Economic Development Authority
FROM: Joanne Foust, Municipal Development Group
Administrator
Judy Weyrens RE: Accounts Payable
June 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. June Econ. Dev. Service 150 -46500 -300 $ 2,655.10
Dale Wick Matt Newlander Designs, LLC Cone Castle Landscape 150 -46500 -588 $ 1,000.00
Total $ 3,655.10
EDA
Larry Hosch
Chad Davey Action:
Steve Frank A MOTION is in order to approve the Accounts Payable.
Tom Skahen
Dale Wick
B. Financial Report:
May 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.
Matt Newlander Designs, LLC Invoice
19298 181st Ave N.W.
Big Lake, MN 55309 Date 06/28/2012
Name and Address
Cone Castle
118 1st Ave N.W.
St. Joseph, MN 56374
Description Total
Sprinkler system supplies $1,543.41
Price includes all materials and rentals including: Hunter and Rainbird heads,
hunter control box, piping and fittings to complete installation of the system
Sprinkler system total labor $1,500.00
Total sprinkler system supplies and installation $3,043.41
Landscaping supplies $2,084.88
Price includes all materials including: 1 Bali Cherry tree, 1 Purple Price Crab tree,
20 Emerald Green Arborvitae's, all landscape edging, fabric, staples,
grass seed and fertilizer to complete installation of landscaping
Landscaping installation total labor $660.00
Total Landscaping supplies and installation $2,744.88
Subtotal $5,788.29
Total $5,788.29
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
June 30, 2012
Fund 150, EDA Balance as of December 31, 2011 (audited) 49,582.49
Year to Date Revenue:
Interest Earnings 438.48
Ad Valorem Taxes 24,229.88
Total Revenue 24,668.36
Year to Date Expenditure Total by Project:
Market Development 1,871.68 **
Business Development 3,922.57 **
Organizational Development 3,584.41 **
Infrastructure Development 33.03 **
Workforce Development - **
9,411.69
Year to Date Expenditures by Object:
Board Stipends (35.00)
Staff Salaries -
Workers Comp Premium -
Office Supplies (225.45)
Software Support (529.52)
Municipal Development Group (11,409.79)
Legal /Engineering Fees (405.00)
Telephone (386.01)
Postage (1.90)
Business Luncheon -
Advertising (39.19)
Recording Fee -
Rentals -
St. Cloud EDA Membership Dues -
EDA Programs (2,653.99)
Total Expenses (15,685.85)
Fund Summaries as of June 30, 2012:
EDA Fund Balance - Fund 150 - unaudited 58,565.00
Designated for Capital Programs 28,303.34
Designated for DEED Housing Projects 16,368.57
Undesignated 13,893.09
TIF 1-4 St. Joseph Development Fund Balance - Fund 156 19,429.45
TIF 2 -1 Millstream Shops and Lofts Fund Balance - Fund 157 19,897.66
TIF 2 -2 St. Joseph Meat Market Fund Balance - Fund 158 (296.74)
Revolving Loan Fund Balance - Fund 250 18,708.00
** Detail available upon request
f CITY OF ST JOSEPH 07/18/12 8:53 AM
,m111/ A� Page 1
ED Balance Sheet
Current Period: June 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 $24,701.94 $19,765.36 $56,265.00
Economic Development G 150 -10450 Interest Receivable $33.58 $0.00 $33.58 $0.00
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 $4,079.51 $0.00 $0.00
Economic Development G 150 -24415 Design. Fd Bal - Capital Proj - $20,131.87 $0.00 $0.00 - $20,131.87
Economic Development G 150 -25310 Appropriated Fund Balance - $29,450.62 $19,798.94 $28,781.45 - $38,433.13
FUND 150 Economic Development $0.00 $48,580.39 $48,580.39 $0.00
FUND 156 TIF 1 -4 St. Joe Development
TIF 1-4 St. Joe Develop G 156 -10100 Cash $17.95 $21,420.67 $9.17 $21,429.45
TIF 1 -4 St. Joe Develop G 156 -10450 Interest Receivable $40.37 $0.00 $40.37 $0.00
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 $49.54 $21,420.67 - $19,429.45
FUND 156 TIF 1 -4 St. Joe Development $0.00 $21,470.21 $21,470.21 $0.00
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream G 157 -10100 Cash $8,443.84 $12,781.45 $1,327.63
$19,897.66
TIF 2 -1 Millstream G 157 -10450 Interest Receivable $10.02 $0.00 $10.02 $0.00
TIF 2 -1 Millstream G 157 -13113 Due From other Gov t Units $42.48 $0.00 $42.48 $0.00
TIF 2 -1 Millstream G 157 -20200 Accounts Payable - $1,284.90 $1,284.90 $0.00
$0.00
TIF 2 -1 Millstream G 157 -25310 Appropriated Fund Balance - $7,211.44 $1,380.13 $14,066.35 - $19,897.66
FUND 157 TIF 2 -1 Millstream $0.00 $15,446.48 $15,446.48 $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 $4,549.93 $0.00 $18,708.00
Revolving Loan Fund G 250 -10450 Interest Receivable $33.95 $0.00 $33.95 $0.00
Revolving Loan Fund G 250 -11900 Notes Receivable $43,017.08 $0.00 $43,017.08 $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 Revenue - $43,017.08 $43,017.08 $0.00 $0.00
Revolving Loan Fund G 250-25310 Appropriated Fund Balance - $14,192.02 $33.95 $4,549.93 - $18,708.00
FUND 250 Revolving Loan Fund $0.00 $47,600.96 $47,600.96 $0.00
$0.00 $133,098.04 $133,098.04 $0.00
A CITY OF ST JOSEPH 07/18/12 8:54 AM
/ .�1� , -+ g
EDA Check Register Pa e 1
CHECK
# Search Name Comments FUND DEPART Amount
045431 CENTRYLINK T1 /PD /WTP2 telephone June 150 46500 $50.59
045432 CENTURYLINK BUSINESS SERVICES long distance telephone 4/24 -5 150 46500 $6.21
045434 CLOSET TO CLOSET SHOP BFA store front grant - EDA 150 46500 $200.00
045459 MUNICIPAL DEVELOPMENT CORP May EDA services 150 46500 $2,518.45
045491 CENTRYLINK 20 sets of 229 telephone #s 6/ 150 46500 $9.54
045512 SUNSET MFG CO., INC. flower pot brackets -BFA grant 150 46500 $884.77
$3,669.56
f CITY OF ST JOSEPH 07/18/12 8:54 AM
/�} ' Page 1
EDA Revenue Report
Current Period: June 2012
2012 June 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 $24,229.88 $24,229.88
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 $29.88 $438.48
Economic Development 39201 Transfers from Other Funds $0.00 $0.00 $0.00
FUND 150 Economic Development $70,725.00 $24,259.76 $24,668.36
FUND 156 TIF 1-4 St. Joe Development
TIF 1-4 St. Joe Development 31050 Tax Increment $0.00 $21,420.62 $21,420.62
TIF 1-4 St. Joe Development 36210 Interest Earnings $0.00 $0.00 _ - $49.49
FUND 156 TIF 1-4 St. Joe Development $0.00 $21,420.62 $21,371.13
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream 31050 Tax Increment $0.00 $12,656.42 $12,656.42
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 $5.64 $72.53
FUND 157 TIF 2 -1 Millstream $0.00 $12,662.06 $12,728.95
FUND 250 Revolving Loan Fund
Revolving Loan Fund 36210 Interest Earnings $300.00 $13.26 $131.13
Revolving Loan Fund 39320 Revolving Loan Principal $6,885.00 $856.57 $3,700.79
Revolving Loan Fund 39321 Revolving Loan Interest $1,195.00 $160.53 $684.06
Revolving Loan Fund 39322 Revolving Loan Origination $0.00 $0.00 $0.00
FUND 250 Revolving Loan Fund $8,380.00 $1,030.36 $4,515.98
$79,105.00 $59,372.80 $63,284.42
r r� 07/18/12 8:54 AM
a� A�� CITY OF ST JOSEPH
Page 1
EDA Expenditure Report
Current Period: June 2012
2012 June 2012
Account Descr YTD Budget 2012 Amt YTD Amt
FUND 150 Economic Development
E 150 - 46500 -103 Legislative Bodies $1,390.00 $0.00 $35.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 $225.45
E 150 -46500 -215 Software Support $540.00 $0.00 $529.52
E 150 - 46500 -300 Professional Services $28,000.00 $2,518.45 $11,409.79
E 150 - 46500 -303 Engineering Fee $2,000.00 $0.00 $0.00
E 150 - 46500 -304 Legal Fees $1,000.00 $0.00 $405.00
E 150 - 46500 -321 Telephone $785.00 $66.34 $386.01
E 150 - 46500 -322 Postage $350.00 $0.00 $1.90
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 $0.00 $39.19
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,084.77 $2,653.99
E 150 - 46500 -622 TIF /Abatement Payments $0.00 $0.00 $0.00
FUND 150 Economic Development $70,725.00 $3,669.56 $15,685.85
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 $0.00 $36.22
E 157 -46500 -121 PERA Contributions $0.00 $0.00 $2.62
E 157- 46500 -122 FICA Contributions $0.00 $0.00 $2.25
E 157 -46500 -123 Deferred Comp - Employer $0.00 $0.00 $0.57
E 157 -46500 -125 Medicare Contributions $0.00 $0.00 $0.53
E 157- 46500 -131 Health Insurance $0.00 $0.00 $0.00
E 157 -46500 -133 Life Insurance $0.00 $0.00 $0.07
E 157 -46500 -134 Disabilty Insurance $0.00 $0.00 $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 $0.00
E 157- 49300 -720 Transfers to Other Funds $0.00 $0.00 $0.00
FUND 157 TIF 2 -1 Millstream $0.00 $0.00 $42.73
FUND 158 TIF 2 -2 Meat Market
f CITY OF ST JOSEPH 07/18/12 8:54 AM
0,4 n A y A� Page 2
EDA Expenditure Report
Current Period: June 2012
2012 June 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,669.56 $15,728.58
O a o
W O. y V \
3 v ''y o c a
L D LL 2 L O o N
U L U U U
e1
al
ICI N N 0 0 011 N. M m
W
O Ni 0 N 0 ' 4 ' ' m' evi M.
C
fti M N t) O 1D 00 0 N 0 00
A 0 10 .--I ci 111 01 N. N
a _0 N 0 -"'i N
in
a) •C E m
'd E 0 0
0) p IN
W CL Q M on C 0 0 V 1 0 0 0 0 1 O
a 'CD C s y . " -� � �00o0 m n =m m
+' 4-
B- t+ 3 M N v N r
u O m O O
.-I u �Q r
O 'a 0°
N 7 a 0 1 N 0 0 v O r i
N
LL U ID W N ' 0 ' O i O '
i m .0 17, C 4 t0 u1 N
C N O co N W ti l�
r-1
N
0 0 0 0 0 O
]).0 O N O O O O u ' 1O 3 N O H 10 00 N N
0
H
C a) 0 u ' l 0 . 0 0 v 1 0 M M
N.0 > 4.) O rl Ni N O u1 u) •Q m 40 ni
N. 0) 10 O N R 1D u1 u1 l0 10 u)
\ C m .4 N --' N •-- N fl7
N Q
N
a) E
LL w (6
F- = o E 2
G C 0_ (n
r a) C C O N 0
0)
E f0 O O v) = a D U
6 C O V O N '` (1)
c ° 3 a ° a E ) _1 > 0
W o 0 f-, 1 .. C V
C O co
-5 O( N U)) N U N
Q CD C C 0 1 C 0 m=
EE N .N 0 .1 Q C Q
0 J0 mre0
t 0 ) N N N N N N N N
O 0 r r P r r r r {;
a Z 0 Cl 0 ▪ 0 0 0 0 0
W W W W W W W W
-O 0 CO OD
O 0 0
u
c 0 ul
o co co
v 1
Q `� LO) 0_
U
.... d
Q
aJ £ 0
O L J
a aJ 0 0 0
0 W W 1-