HomeMy WebLinkAbout[06] Accounts Payable and Financial Report •
CITY OF ST. 1 OSEPH
www.cityoistioseph.com
DATE: May 16, 2012
MEMO TO: St. Joseph Economic Development Authority
FROM: Cynthia Smith - Strack, Municipal Development Group
Administrator
Judy Weyrens RE: Accounts Payable
April 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. April Econ. Dev. Service 150 -46500 -300 $ 2,511.35
Dale Wick Total $ 2,511.35
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:
April 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.
441 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 5 -10 -12 Payment Terms: 30 days Customer ID #:
STJI2EDA
Project March Economic Development Services
See attached detail
Amount: $2,200.00 Monthly contract fee
$ 311.35 561 miles x .555
$2,511.35
Code to: 150 -46500 -300 for general EDA
Remit To: Municipal Development Group, Inc.
25562 Willow Lane
New Prague, MN 56071
Dates -EDA Hours
April 4, 2012 EDA Office Hours: C. Strack 7.00 Hours
April 11, 2012 EDA Office Hours: C. Strack 8.00 Hours
April 18, 2012 EDA Office Hours: C. Strack 7.50 Hours
April 19, 2012 Hours in MDG Office: C. Strack 2.75 Hours
Total April 2012 25.25 Hours
Total Contract Hours Thru April 31, 2012: 157.75 Hours
Thank you! We appreciated the opportunity to work with you!
Check No.
Date: Principal
( 0
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
April 30, 2012
Fund 150, EDA Balance as of December 31, 2011 (audited) 49,582.49
Year to Date Revenue:
Interest Earnings 312.64
Ad Valorem Taxes -
Total Revenue 312.64
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 (6,379.99)
Legal /Engineering Fees (405.00)
Telephone (253.96)
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 (9,439.23)
Fund Summaries as of April 30, 2011:
EDA Fund Balance - Fund 150 - unaudited 40,455.90
Designated for Capital Programs 29,388.11
Designated for DEED Housing Projects 16,368.57
Undesignated (5,300.78)
TIF 1-4 St. Joseph Development Fund Balance - Fund 156 (1,991.19)
TIF 2 -1 Millstream Shops and Lofts Fund Balance - Fund 157 7,218.69
TIF 2 -2 St. Joseph Meat Market Fund Balance - Fund 158 (296.74)
Revolving Loan Fund Balance - Fund 250 16,965.99
** Detail available upon request
1 ?
1" CITY OF ST JOSEPH 05/11/12 1:48 PM
yx.4 A .. , � EDA Balance Sheet Page 1
Current Period: April 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 $346.22 $13,518.74 $38,155.90
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 420,131.87
Economic Development G 150 -25310 Appropriated Fund Balance - $29,450.62 $13,552.32 $4,425.73 - $20,324.03
FUND 150 Economic Development $0.00 $17,978.05 $17,978.05 $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 14 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.03 $1,991.19
FUND 156 TIF 1 -4 St. Joe Development $0.00 $49.57 $49.57 $0.00
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream G 157 -10100 Cash $8,443.84 $102.48 $1,327.63 $7,218.69
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,387.38 - $7,218.69
FUND 157 TIF 2 -1 Millstream $0.00 $2,767.51 $2,767.51 $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,807.92 $0.00 $16,965.99
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 $2,807.92 416,965.99
FUND 250 Revolving Loan Fund $0.00 $45,858.95 $45,858.95 $0.00
$0.00 $66,654.08 $66,654.08 $0.00
(2
{ r l CITY OF ST JOSEPH 05/11/12 1:50 eM
`� EDA Expenditure Report
Current Period: April 2012
2012 April 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 $225.45 $225.45
E 150 -46500 -215 Software Support $540.00 $0.00 $529.52
E 150- 46500 -300 Professional Services $28,000.00 $2,255.67 $6,379.99
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 $60.13 $253.96
E 150 -46500 -322 Postage $350.00 $1.90 $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 $307.58 $1,569.22
E 150 - 46500 -622 TIF /Abatement Payments $0.00 $0.00 $0.00
FUND 150 Economic Development $70,725.00 $2,850.73 $9,439.23
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
I3
r' CITY OF ST JOSEPH 05/11/12 1:50 PM
q1 )A� - --1. EDA Expenditure Report Page 2
Current Period: April 2012
2012 April 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,850.73 $9,481.96
1i-f
i i CITY OF ST JOSEPH 05/11/121:50 eM
��' EDA Revenue Report
Current Period: April 2012
2012 April 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 $54.82 $312.64
Economic Development 39201 Transfers from Other Funds $0.00 $0.00 $0.00
FUND 150 Economic Development $70,725.00 $54.82 $312.64
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.00 149.51
FUND 156 TIF 1 -4 St. Joe Development $0.00 $0.00 -$49.51
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 $9.56 $49.98
FUND 157 TIF 2 -1 Millstream $0.00 $9.56 $49.98
FUND 250 Revolving Loan Fund
Revolving Loan Fund 36210 Interest Eamings $300.00 $19.46 $79.77
Revolving Loan Fund 39320 Revolving Loan Principal $6,885.00 $570.26 $2,272.53
Revolving Loan Fund 39321 Revolving Loan Interest $1,195.00 $103.29 $421.67
Revolving Loan Fund 39322 Revolving Loan Origination $0.00 $0.00 $0.00
FUND 250 Revolving Loan Fund $8,380.00 $693.01 $2,773.97
$79,105.00 $757.39 $3,087.08
f5