HomeMy WebLinkAbout[06] Accounts Payable and Financial Report • CITY OF ST. J OSEPH
www.cityofstioseph.com
DATE: June 13, 2012
MEMO TO: St. Joseph Economic Development Authority
FROM: Joanne Foust, Municipal Development Group
Administrator
Judy Weyrens RE: Accounts Payable
May 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. May Econ. Dev. Service 150 -46500 -300 $ 2,518.45
Dale Wick Total $ 2,518.45
EDA
Larry Bosch Action:
Chad Davey A MOTION is in order to approve the Accounts Payable.
Steve Frank
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.
I 0
Municipal Development Group NVO IC E
25562 Willow Lane
New Prague, MN 56071 Invoice Number: STJ061012
United States Invoice Date: Jun 10, 2012
ISA Page: 1
Voice: 952 - 758 -7399 MUNICIPAL Duplicate
Fax: 952 - 758 - 3711 DEVELOPMENT GROUP, INC.
Bill To: — — — ;Ship to'
• � ...:,, � , • -•; xr toEr.,
r CITY OF ST. JOSEPH CITY OF ST. JOSEPH
PO BOX 668 PO BOX 668
ST. JOSEPH, MN 56374 ST. JOSEPH, MN 56374
Custorr�e D CustonterPO �}
ST. JOSEPH Net 30 Days
Sales Rep ID
Sfi� ping MiatFiod ' _ ip ® x n {
STRACKC US Mail 6/11/12 7/10/12
Quantity - Item Description Unit arice
s.,
1.00 May 2012 22.0 Contract Hours. May 9th (8 2,200.00 2,200.00
hrs), May 16th (7.5 hrs) May 30th (6.5 hrs).
Please see the attached detail.
1.00 Mileage 579 miles at $.555 for the above noted 318.45 318.45
dates.
Contract hours as of 5 -31 -2012: 190.
Thank you for the opportunity to work with
the City of St. Joseph!
R CEIV ED
Jim 13 2012
CY JE ., iOSiH
OK TO DAY Su ACOT t'o5 300
DATE - (3 -
Subtotal 2,518.45
Sales Tax
Total Invoice Amount 2,518.45
Check /Credit Memo No: Payment/Credk Applied
TOTAL ' r r :, ' ° $g ; -
1 t
25562 Willow Lane • New Prague, MN 56071 • (952) 758 -7399 • Fax (952) 758 -3711
www .municipaldevelopmentgroup.com • staff @municipaldevelopmentgroup.com
i 06/13/12 11:20 AM
f CITY OF ST JOSEPH
/_- EDA Check Register Page 1
CHECK
# Search Name Comments FUND DEPART Amount
045336 CENTRYLINK T1 Line /PD /WTP2 phone 150 46500 $50.59
045337 CENTURYLINK BUSINESS SERVICES long distance telephone April 150 46500 $5.58
045368 MUNICIPAL DEVELOPMENT CORP April EDA services 150 46500 $2,511.35
045382 CENTRYLINK 20 sets 229 numbers 5/10 -6/9 150 46500 $9.54
$2,577.06
1 Z-
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
May 31, 2012
Fund 150, EDA Balance as of December 31, 2011 (audited) 49,582.49
Year to Date Revenue:
Interest Earnings 408.60
Ad Valorem Taxes -
Total Revenue 408.60
Year to Date Expenditure Total by Proiect:
Market Development 1,871.68 **
Business Development 2,837.80 **
Organizational Development 3,584.41 **
Infrastructure Development 33.03 **
Workforce Development **
8,326.92
Year to Date Expenditures by Obiect:
Board Stipends (35.00)
Staff Salaries -
Workers Comp Premium -
Office Supplies (225.45)
Software Support (529.52)
Municipal Development Group (8,891.34)
Legal /Engineering Fees (405.00)
Telephone (319.67)
Postage (1.90)
Business Luncheon -
Advertising (39.19)
Recording Fee -
Rentals (Postage Machine) -
St. Cloud EDA Membership Dues -
EDA Programs (1,569.22)
Total Expenses (12,016.29)
Fund Summaries as of May 31, 2012:
EDA Fund Balance - Fund 150 - unaudited 37,974.80
Designated for Capital Programs 29,388.11
Designated for DEED Housing Projects 16,368.57
Undesignated (7,781.88)
TIF 1-4 St. Joseph Development Fund Balance - Fund 156 (1,991.17)
TIF 2 -1 Millstream Shops and Lofts Fund Balance - Fund 157 7,235.60
TIF 2 -2 St. Joseph Meat Market Fund Balance - Fund 158 (296.74)
Revolving Loan Fund Balance - Fund 250 17,677.64
** Detail available upon request
i3
r' CITY O ST JOSEPH 06/13/12 11:19 AM
�/ �A� -.. , � EDA Balance Sheet Page 1
Current Period: May 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 $442.18 $16,095.80 $35,674.80
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 $16,129.38 $4,521.69 -$17,842.93
FUND 150 Economic Development $0.00 $20,651.07 $20,651.07 $0.00
FUND 156 TIF 1 -4 St. Joe Development
TIF 1-4 St. Joe Develop G 156 -10100 Cash $17.95 $0.05 $9.17 $8.83
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 $0.05 $1,991.17
FUND 156 TIF 1 -4 St. Joe Development $0.00 $49.59 $49.59 $0.00
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream G 157 -10100 Cash $8,443.84 $119.39 $1,327.63 $7,235.60
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 $1,404.29 - $7,235.60
FUND 157 TIF 2 -1 Millstream $0.00 $2,784.42 $2,784.42 $0.00
FUND 158 TIF 2 -2 Meat Market
TIF 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 1300.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 $3,519.57 $0.00 $17,677.64
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 $3,519.57 - $17,677.64
FUND 250 Revolving Loan Fund $0.00 $46,570.60 $46,570.60 $0.00
$0.00 $70,055.68 $70,055.68 $0.00
i 4
f l CITY OF ST JOSEPH 06/13/12 11:20 AM
A . EDA Expenditure Report Page 1
Current Period: May 2012
2012 May 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,511.35 $8,891.34
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 $65.71 $319.67
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 $0.00 $1,56922
E 150 - 46500 -622 TIF /Abatement Payments $0.00 $0.00 $0.00
FUND 150 Economic Development $70,725.00 $2,577.06 $12,016.29
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
15
� r ' C ITY OF ST JOSEPH 06/13/12 11:20 e 2
�-� EDA Expenditure Report
Current Period: May 2012
2012 May 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 $2,577.06 $12,059.02
i
f CITY OF ST JOSEPH 06/13/12 11:21 AM
/ �' 1 EDA Revenue Report Page 1
Current Period: May 2012
2012 May 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 $95.96 $408.60
Economic Development 39201 Transfers from Other Funds $0.00 $0.00 $0.00
FUND 150 Economic Development $70,725.00 $95.96 $408.60
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 Earnings $0.00 $0.02 - $49.49
FUND 156 TIF 1 -4 St. Joe Development $0.00 $0.02 - $49.49
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream 31050 Tax Increment $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 $16.91 $66.89
FUND 157 TIF 2 -1 Millstream $0.00 $16.91 $66.89
FUND 250 Revolving Loan Fund
Revolving Loan Fund 36210 Interest Eamings $300.00 $38.10 $117.87
Revolving Loan Fund 39320 Revolving Loan Principal $6,885.00 $571.69 $2,844.22
Revolving Loan Fund 39321 Revolving Loan Interest $1,195.00 $101.86 $523.53
Revolving Loan Fund 39322 Revolving Loan Origination $0.00 $0.00 $0.00
FUND 250 Revolving Loan Fund $8,380.00 $711.65 $3,485.62
$79,105.00 $824.54 $3,911.62
1 '1
O a1 N 00 to a1
0 0 01 Lf1 to a1 co
Q �O O to 0 01 i i 00 M
W N ' 4' ; N N ,-I 01 M a1
ai c-I t t O 0 N t-1 IN
C a4
= W urLi
' E IL _.I .-1 O1 t-1 N N O N M • Of I
•O N 0 O M 00 0 0 4 Qt 00 0
N CO 01 a1 N t/1 M to
Q• • a- r-I t C e'l N a 00 00 0 — N M o
X 0. !.M 04 p•O V ..1
f0 G o N 2O y N
!•' m Q 2 .
. + .1
Q
0)
-) v • a o
I-) 10 0 1-1 to r M O 0o v
wl u 3 Q M N l0 N O 01
wi • G m `
N c d .0 N N ,D in N
U. U j en N 00 e 4 to
i C L ~
C Y
y N
0, ,,,, .,,,*. ,:,,,,,„ r 1 - , z v. ' ','
ffi� r Q
. o LJ1 N t0 O tf1 a1 a1 o o
ti y 0 1.11 o a1 O Cr t0 01 M el
N .. E v d a1 N a--i O to tti 4 M m
W 1C0 N t0 LA L5 t0 tD M tt1 N
M d c a a --I a 1 0 1 N tO N N N
..... Q Ce m
a-1
N E
1 " 1 - ' y
O E N
c C Q. 2 Cii
'I•' N C O C
E • O C °' f.0 O a C U
o. a ° (3
W 0 0 0- 0 C C °
'Cr) O H P N a U N
o
. C 7 C o f6 =
E fn •y C •y Q C Q
w N 00
o LO LO
u
▪ O O
3 co W
V
u 1
Q t� 14 d
v
w E w
•� t J
a d 0 0
0 w w I-
I'i?