HomeMy WebLinkAbout[04ab] Accounts Payabe & Financial ReportDATE: July 15, 2011
MEMO TO: St. Joseph Economic Development Authority
FROM: Cynthia Smith-Strack, Municipal Development Group
RE: Accounts Payable – July
June Financial Reports
A. Accounts Payable:
Following are Accounts Payable for the EDA’s Consideration.
Payable To For Fund Amount
MDG, Inc. June Econ. Dev. Service 150-46500-300 $ 2,772.22
David Drown Assoc. Traci Ryan TIF Svcs 150-46500-588 $10,347.90
Total $13,120.12
Action:
A MOTION is in order to approve the Accounts Payable.
B. Financial Report:
June 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.
п¹»é±ºêê
п¹»è±ºêê
INVOICE
MDG,I.
UNICIPAL EVELOPMENT ROUPNC
25562 WILLOW LANE
NEW PRAGUE, MN 56071
City of St. Joseph
952-758-7399
Attn: Judy Weyrens
FAX: 952-758-3711
City Administrator
ÉÈÛÖÖüÏÇÎÓÙÓÌÛÐØ×Æ×ÐÍÌÏ×ÎÈÕÊÍÇÌÙÍÏ
PO 668
St. Joseph, MN 56374
Payment TermsCustomer ID #:
Invoice Date 7-10-11
: 30 days
STJ10EDA
Project June EconomicDevelopment Services
See attached detail
Amount:
$2,200.00 Monthly contract fee
$ 572.22 1122 miles x .51
$2,772.22
Code to: 150-46500-300 for general EDA
Remit To
: Municipal Development Group, Inc.
25562 Willow Lane
New Prague, MN 56071
Dates-EDAHours
June 1, 2011 EDA Office Hours: C. Strack 8.00 Hours
June 8, 2011 EDA Office Hours: C. Strack 8.00 Hours
June 15, 2011 EDA Office Hours: C. Strack 8.00 Hours
June 16, 2011 EDA Hours in MDG Office: C. Strack 2.25 Hours
June 22, 2011 EDA Office Hours: C. Strack 8.00 Hours
June 27, 2011 EDA Office and MDG Office: C. Strack 4.75 Hours
June 29, 2011 EDA Office Hours: C. Strack8.25 Hours
Total June 201147.25 Hours
Total Contract Hours June 30, 2011: 236.50 Hours
Thank you! We appreciated the opportunity to work with you!
_________________________________
Check No
.__________________
Principal
Date
: ______________________
п¹»ç±ºêê
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
June 2011
Fund 150, EDA Balance as of December 31, 201(Audited)
0
5,162.57
Year to Date Revenue:
Interest Earnings 67.10
DEED Housing Reimbursement 16,368.57
Transfers from the City's General Fund 28,000.00
Total Revenue 44,435.67
Year to Date Expenditure Total by Project:
Market Developmen1,260.02
t
**
Business Developmen12,009.13
t
**
Organizational Developmen1,886.93
t
**
Infrastructure Developmen
1,103.41
t
**
Workforce Developmen
t
**
-
16,259.49
Year to Date Expenditures by Object:
Board Stipends
-
Staff Salaries
-
Workers Comp Premium 0.52
Office Supplies (63.83)
Software Support (529.52)
Municipal Development Group (5,936.85)
Legal/Engineering Fees (1,362.64)
Telephone (381.49)
Postage
-
Business Luncheon
-
Advertising
-
Recording Fee
-
Rentals (Postage Machine)
-
St. Cloud EDA Membership Dues
-
EDA Programs(8,960.00)
Total Expenses (17,233.81)
Fund Summaries as of June 30, 2011:
EDA Fund Balance - Fund 150
- (Unaudited)
32,364.43
31,602.66
Designated for Capital Programs
16,368.57
Designated for DEED Housing Projects
(15,606.80)
Undesignated
TIF 1-4 St. Joseph Development Fund Balance -Fund 156
65,183.96
TIF 2-1 Millstream Shops and Lofts Fund Balance - Fund 157
20,527.73
TIF 2-2 St. Joseph Meat Market Fund Balance - Fund 158
(165.00)
Revolving Loan Fund Balance - Fund 250
11,720.41
** Detail available upon request
п¹»ïð±ºêê
07/13/11 2:46 PM
CITY OF ST JOSEPH
Page 1
EDA Balance Sheet
Current Period: June 2011
YTDYTDCurrent
FUND DescrAccount DescrBegin YrDebitCreditBalance
FUND 150 Economic Development
Economic DevelopmentG 150-10100 Cash$8,841.22$44,470.18$20,946.97$32,364.43
Economic DevelopmentG 150-10450 Interest Receivable$31.27$0.00$31.27$0.00
Economic DevelopmentG 150-20200 Accounts Payable-$3,709.92$3,709.92$0.00$0.00
Economic DevelopmentG 150-24415 Design. Fd Bal - Capital Proj-$5,162.57$0.00$0.00-$5,162.57
Economic DevelopmentG 150-25310 Appropriated Fund Balance$0.00$20,978.24$48,180.10-$27,201.86
FUND 150 Economic Development$0.00$69,158.34$69,158.34$0.00
FUND 156 TIF 1-4 St. Joe Development
TIF 1-4 St. Joe DevelopG 156-10100 Cash$41,593.09$23,757.07$166.20$65,183.96
TIF 1-4 St. Joe DevelopG 156-10450 Interest Receivable$105.67$0.00$105.67$0.00
TIF 1-4 St. Joe DevelopG 156-25310 Appropriated Fund Balance-$41,698.76$271.87$23,757.07-$65,183.96
FUND 156 TIF 1-4 St. Joe Development$0.00$24,028.94$24,028.94$0.00
FUND 157 TIF 2-1 Millstream
TIF 2-1 MillstreamG 157-10100 Cash$4,020.96$16,552.68$45.91$20,527.73
TIF 2-1 MillstreamG 157-10450 Interest Receivable$4.82$0.00$4.82$0.00
able$0.00$0.00$0.00$0.00
TIF 2-1 MillstreamG 157-20200 Accounts Pay
TIF 2-1 MillstreamG 157-25310 Appropriated Fund Balance-$4,025.78$50.73$16,552.68-$20,527.73
FUND 157 TIF 2-1 Millstream$0.00$16,603.41$16,603.41$0.00
FUND 158 TIF 2-2 Meat Market
TIF 2-2 Meat MarketG 158-10100 Cash$0.00$0.00$165.00-$165.00
TIF 2-2 Meat MarketG 158-25310 Appropriated Fund Balance$0.00$165.00$0.00$165.00
FUND 158 TIF 2-2 Meat Market$0.00$165.00$165.00$0.00
FUND 250 Revolving Loan Fund
Revolving Loan FundG 250-10100 Cash$34,565.78$2,432.00$25,277.37$11,720.41
Revolving Loan FundG 250-10450 Interest Receivable$89.51$0.00$89.51$0.00
Revolving Loan FundG 250-11900 Notes Receivable$20,715.08$0.00$20,715.08$0.00
Revolving Loan FundG 250-20200 Accounts Payable$0.00$0.00$0.00$0.00
Revolvin Loan FundG 250-22204 Deferred Revenue-$20,715.08$20,715.08$0.00$0.00
g
Revolving Loan FundG 250-25310 Appropriated Fund Balance-$34,655.29$25,366.88$2,432.00-$11,720.41
FUND 250 Revolving Loan Fund$0.00$48,513.96$48,513.96$0.00
$0.00$158,469.65$158,469.65$0.00
п¹»ïﱺêê
07/13/11 3:01 PM
CITY OF ST JOSEPH
Page 1
EDA Expenditure Report
Current Period: June 2011
2011June2011
Account DescrYTD Budget2011 AmtYTD Amt
FUND 150 Economic Development
E 150-46500-103 Legislative Bodies$1,390.00$0.00$0.00
E 150-46500-151 Workers Comp. Insur. Prem.$150.00$0.00-$0.52
E 150-46500-200 Office Supplies$500.00$42.51$63.83
E 150-46500-215 Software Support$450.00$0.00$529.52
E 150-46500-300 Professional Services$28,000.00$942.25$5,936.85
E 150-46500-303 Engineering Fee$2,000.00$0.00$714.64
E 150-46500-304 Legal Fees$1,000.00$648.00$648.00
E 150-46500-321 Telephone$1,200.00$65.37$381.49
E 150-46500-322 Postage$350.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$0.00
E 150-46500-410 Rentals$0.00$0.00$0.00
E 150-46500-433 Dues & Memberships$8,000.00$0.00$0.00
E 150-46500-434 Certification Fee$0.00$0.00$0.00
E 150-46500-582 Computer Software$300.00$0.00$0.00
E 150-46500-588 EDA Programs$40,000.00$1,639.23$8,960.00
FUND 150 Economic Development
$83,990.00$3,337.36$17,233.81
FUND 156 TIF 1-4 St. Joe Development
E 156-46500-101 Salaries$0.00$67.31$67.31
E 156-46500-121 PERA Contributions$0.00$4.88$4.88
E 156-46500-122 FICA Contributions$0.00$3.89$3.89
E 156-46500-123 Deferred Comp-Employer$0.00$1.25$1.25
E 156-46500-125 Medicare Contributions$0.00$0.91$0.91
E 156-46500-130 Health Ins-Deductible$0.00$0.00$0.00
E 156-46500-131 Health Insurance$0.00$11.98$11.98
E 156-46500-133 Life Insurance$0.00$0.15$0.15
E 156-46500-134 Disabilty Insurance$0.00$0.00$0.00
E 156-46500-136 Fringe Benefits-Employee$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$66.00
E 156-46500-622 Tax Increment Payments$0.00$0.00$0.00
FUND 156 TIF 1-4 St. Joe Development$0.00$90.37$156.37
FUND 157 TIF 2-1 Millstream
E 157-46500-101 Salaries$0.00$33.65$33.65
E 157-46500-121 PERA Contributions$0.00$2.44$2.44
E 157-46500-122 FICA Contributions$0.00$1.95$1.95
E 157-46500-123 Deferred Comp-Employer$0.00$0.63$0.63
E 157-46500-125 Medicare Contributions$0.00$0.46$0.46
E 157-46500-130 Health Ins-Deductible$0.00$0.00$0.00
E 157-46500-131 Health Insurance$0.00$5.99$5.99
E 157-46500-133 Life Insurance$0.00$0.07$0.07
E 157-46500-134 Disabilty Insurance$0.00$0.00$0.00
E 157-46500-136 Fringe Benefits-Employee$0.00$0.00$0.00
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 Tax Increment 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$45.19$45.19
FUND 158 TIF 2-2 Meat Market
E 158-46500-300 Professional Services$0.00$0.00$0.00
E 158-46500-340 Advertising$0.00$0.00$165.00
п¹»ïêê
07/13/11 3:01 PM
CITY OF ST JOSEPH
Page 2
EDA Expenditure Report
Current Period: June 2011
2011June2011
Account DescrYTD Budget2011 AmtYTD Amt
E 158-46500-622 Tax Increment Payments$0.00$0.00$0.00
FUND 158 TIF 2-2 Meat Market$0.00$0.00$165.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$54.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$25,215.00
FUND 250 Revolving Loan Fund$0.00$0.00$25,269.00
$83,990.00$3,472.92$42,869.37
п¹»ïí±ºêê
07/13/11 3:02 PM
CITY OF ST JOSEPH
Page 1
EDA Revenue Report
Current Period: June 2011
2011June2011
FUND DescrSOURCESOURCE DescrYTD Budget2011 AmtYTD Amt
FUND 150 Economic Development
Economic Development34150TIF/MIF Deposit$0.00$0.00$0.00
Economic Development34200DEED Housing Reimbursem$0.00$16,368.57$16,368.57
Economic Development36210Interest Earnings$150.00$41.60$67.10
Economic Development39201Transfers from Other Funds$83,840.00$0.00$28,000.00
FUND 150 Economic Development$83,990.00$16,410.17$44,435.67
FUND 156 TIF 1-4 St. Joe Development
TIF 1-4 St. Joe Development31050Tax Increment$0.00$23,234.74$23,234.74
TIF 1-4 St. Joe Development36210Interest Earnings$0.00$130.15$406.83
FUND 156 TIF 1-4 St. Joe Development$0.00$23,364.89$23,641.57
FUND 157 TIF 2-1 Millstream
TIF 2-1 Millstream31050Tax Increment$0.00$16,506.62$16,506.62
TIF 2-1 Millstream33404Market Value Credit$0.00$0.00$0.00
TIF 2-1 Millstream34150TIF/MIF Deposit$0.00$0.00$0.00
TIF 2-1 Millstream36210Interest Earnings$0.00$12.59$40.52
FUND 157 TIF 2-1 Millstream$0.00$16,519.21$16,547.14
FUND 250 Revolving Loan Fund
Revolving Loan Fund36210Interest Earnings$0.00$86.22$320.09
Revolving Loan Fund39320Revolving Loan Principal$0.00$281.79$1,714.54
Revolving Loan Fund39321Revolving Loan Interest$0.00$48.21$299.49
Revolving Loan Fund39322Revolving Loan Origination $0.00$0.00$0.00
FUND 250 Revolving Loan Fund$0.00$416.22$2,334.12
$83,990.00$56,710.49$86,958.50
п¹»ï챺êê