HomeMy WebLinkAbout[04b] Financial Report ,� CITY OF ST. JOSEPH
www.cityofstjoseph.com
DATE: December 21, 2011
MEMO TO: St. Joseph Economic Development Authority
FROM: Cynthia Smith - Strack, Municipal Development Group
Administrator
Judy Weyrens RE: Accounts Payable — December
November 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. Nov. Econ. Dev. Service 150 -46500 -300 $ 2,718.93
Dale Wick Total $ 2,718.93
EDA
Carolyn Yaggie— Action:
Heinen A MOTION is in order to approve the Accounts Payable.
Chad Davey
Steve Frank
Tom Skahen B. Financial Report:
Dale Wick September 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.
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
November 30, 2011
Fund 150, EDA Balance as of December 31, 2010 (Audited) 5,162.57
Year to Date Revenue:
Interest Earnings 216.71
DEED Housing Reimbursement 16,368.57
Transfers from the City's General Fund 56,000.00
Total Revenue 72,585.28
Year to Date Expenditure Total by Proiect:
Market Development 2,129.13 **
Business Development 39,502.32 **
Organizational Development 3,730.93 **
Infrastructure Development 1,509.18 **
Workforce Development - **
46,871.56
Year to Date Expenditures by Obiect:
Board Stipends -
Staff Salaries -
Workers Comp Premium (1.75)
Office Supplies (63.83)
Software Support (529.52)
Municipal Development Group (12,371.80)
Legal /Engineering Fees (3,123.54)
Telephone (702.21)
Postage -
Business Luncheon -
Advertising (88.89)
Recording Fee -
Rentals (Postage Machine) -
St. Cloud EDA Membership Dues -
EDA Programs (31,375.41)
Total Expenses (48,256.95)
Fund Summaries as of November 30, 2011:
EDA Fund Balance - Fund 150 - (Unaudited) 29,490.90
Designated for Capital Programs 5,786.45
Designated for DEED Housing Projects 16,368.57
Undesignated 7,335.88
TIF 1-4 St. Joseph Development Fund Balance - Fund 156 (5,289.41)
TIF 2 -1 Millstream Shops and Lofts Fund Balance - Fund 157 6,103.90
TIF 2 -2 St. Joseph Meat Market Fund Balance - Fund 158 (296.74)
Revolving Loan Fund Balance - Fund 250 13,455.08
** Detail available upon request
r l CITY OF ST JOSEPH 12/06/11 2:16 PM
� I G1 -AA,.... , Page 1
EDA Balance Sheet
Current Period: November 2011
YTD YTD Current
FUND Descr Account Descr Begin Yr Debit Credit Balance
FUND 150 Economic Development
Economic Development G 150 -10100 Cash $8,841.22 $85,606.98 $64,957.30 $29,490.90
Economic Development G 150 -10450 Interest Receivable $31.27 $0.00 $31.27 $0.00
Economic Development G 150 -20200 Accounts Payable - $3,709.92 $3,709.92 $0.00 $0.00
Economic Development G 150 -24415 Design. Fd Bal - Capital Proj - $5,162.57 $0.00 $0.00 - $5,162.57
Economic Development G 150 -25310 Appropriated Fund Balance $0.00 $64,988.57 $89,316.90 - $24,328.33
FUND 150 Economic Development $0.00 $154,305.47 $154,305.47 $0.00
FUND 156 TIF 1-4 St. Joe Development
TIF 1-4 St. Joe Develop G 156 -10100 Cash $41,593.09 $33,945.30 $80,827.80 - $5,289.41
TIF 1-4 St. Joe Develop G 156 -10450 Interest Receivable $105.67 $0.00 $105.67 $0.00
TIF 1-4 St. Joe Develop G 156 -25310 Appropriated Fund Balance - $41,698.76 $80,933.47 $33,945.30 $5,289.41
FUND 156 TIF 1-4 St. Joe Development $0.00 $114,878.77 $114,878.77 $0.00
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream G 157 -10100 Cash $4,020.96 $23,697.05 $21,614.11 $6,103.90
TIF 2 -1 Millstream G 157 -10450 Interest Receivable $4.82 $0.00 $4.82 $0.00
TIF 2 -1 Millstream G 157 -20200 Accounts Payable $0.00 $0.00 $0.00 $0.00
TIF 2 -1 Millstream G 157 -25310 Appropriated Fund Balance - $4,025.78 $21,618.93 $23,697.05 - $6,103.90
FUND 157 TIF 2 -1 Millstream $0.00 $45,315.98 $45,315.98 $0.00
FUND 158 TIF 2 -2 Meat Market
TIF 2 -2 Meat Market G 158 -10100 Cash $0.00 $11,204.94 $11,501.68 - $296.74
TIF 2 -2 Meat Market G 158 -25310 Appropriated Fund Balance $0.00 $11,501.68 $11,204.94 $296.74
FUND 158 TIF 2 -2 Meat Market $0.00 $22,706.62 $22,706.62 $0.00
FUND 250 Revolving Loan Fund
Revolving Loan Fund G 250 -10100 Cash $34,565.78 $5,301.34 $26,412.04 $13,455.08
Revolving Loan Fund G 250 -10450 Interest Receivable $89.51 $0.00 $89.51 $0.00
Revolving Loan Fund G 250 -11900 Notes Receivable $20,715.08 $0.00 $20,715.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 - $20,715.08 $20,715.08 $0.00 $0.00
Revolving Loan Fund G 250 -25310 Appropriated Fund Balance - $34,655.29 $26,501.55 $5,301.34 - $13,455.08
_...........
FUND 250 Revolving Loan Fund $0.00 $52,517.97 $52,517.97 $0.00
$0.00 $389,724.81 $389,724.81 $0.00
�� CITY OF ST JOSEPH 12/06/11 2:17 PM
� Page 1
EDA Expenditure Report
Current Period: November 2011
2011 November 2011
Account Descr YTD Budget 2011 Amt YTD 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 $1.75
E 150 -46500 -200 Office Supplies $500.00 $0.00 $63.83
E 150 -46500 -215 Software Support $450.00 $0.00 $529.52
E 150 -46500 -300 Professional Services $30,500.00 $1,572.12 $12,371.80
E 150 -46500 -303 Engineering Fee $2,000.00 $0.00 $1,947.04
E 150 -46500 -304 Legal Fees $1,000.00 $0.00 $1,176.50
E 150 -46500 -321 Telephone $1,200.00 $63.56 $702.21
E 150 -46500 -322 Postage $350.00 $0.00 $0.00
E 150 -46500 -328 Marketing $0.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 $88.89
E 150 - 46500 -410 Rentals $0.00 $0.00 $0.00
E 150 -46500 -433 Dues & Memberships $5,500.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,009.36 $31,375.41
FUND 150 Economic Development $83,990.00 $2,645.04 $48,256.95
FUND 156 TIF 1-4 St. Joe Development
E 156 -46500 -101 Salaries $0.00 $0.00 $322.29
E 156 -46500 -121 PERA Contributions $0.00 $0.00 $23.38
E 156 -46500 -122 FICA Contributions $0.00 $0.00 $19.07
E 156 -46500 -123 Deferred Comp - Employer $0.00 $0.00 $5.78
E 156 -46500 -125 Medicare Contributions $0.00 $0.00 $4.46
E 156 -46500 -131 Health Insurance $0.00 $0.00 $52.41
E 156 -46500 -133 Life Insurance $0.00 $0.00 $0.69
E 156 -46500 -134 Disabilty Insurance $0.00 $0.00 $3.60
E 156 -46500 -300 Professional Services $0.00 $0.00 $3,371.00
E 156 -46500 -340 Advertising $0.00 $0.00 $98.34
E 156 -46500 -588 EDA Programs $0.00 $0.00 $47,000.00
E 156 -46500 -622 Tax Increment Payments $0.00 $0.00 $29,873.24
FUND 156 TIF 1-4 St. Joe Development $0.00 $0.00 $80,774.26
FUND 157 TIF 2 -1 Millstream
E 157 -46500 -101 Salaries $0.00 $0.00 $253.46
E 157 -46500 -121 PERA Contributions $0.00 $0.00 $18.38
E 157 -46500 -122 FICA Contributions $0.00 $0.00 $14.99
E 157 - 46500 -123 Deferred Comp - Employer $0.00 $0.00 $4.54
E 157 -46500 -125 Medicare Contributions $0.00 $0.00 $3.51
E 157 -46500 -131 Health Insurance $0.00 $0.00 $43.44
E 157 -46500 -133 Life Insurance $0.00 $0.00 $0.53
E 157 -46500 -134 Disabilty Insurance $0.00 $0.00 $3.07
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 $32.34
E 157 -46500 -622 Tax Increment Payments $0.00 $0.00 $21,222.80
E 157 -49300 -720 Transfers to Other Funds $0.00 $0.00 $0.00
FUND 157 TIF 2 -1 Millstream $0.00 $0.00 $21,597.06
FUND 158 TIF 2 -2 Meat Market
E 158 -46500 -101 Salaries $0.00 $0.00 $17.58
E 158 -46500 -121 PERA Contributions $0.00 $0.00 $1.27
E 158 -46500 -122 FICA Contributions $0.00 $0.00 $1.05
E 158 -46500 -123 Deferred Comp - Employer $0.00 $0.00 $0.31
1 CITY OF ST JOSEPH 12106/11 2:17 PM .1 1
' / � A Expenditure Re Page 2
E
D Report
p
Current Period: November 2011
2011 November 2011
Account Descr YTD Budget 2011 Amt YTD Amt
E 158 -46500 -125 Medicare Contributions $0.00 $0.00 $0.25
E 158 -46500 -131 Health Insurance $0.00 $0.00 $3.00
E 158 -46500 -133 Life Insurance $0.00 $0.00 $0.03
E 15846500 -134 Disabilty Insurance $0.00 $0.00 $0.25
E 158 -46500 -300 Professional Services $0.00 $0.00 $108.00
E 158- 46500 -340 Advertising $0.00 $0.00 $165.00
E 158 -46500 -622 Tax Increment Payments $0.00 $0.00 $0.00
FUND 158 TIF 2 -2 Meat Market $0.00 $0.00 $296.74
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 25046500 -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 $26,000.00
FUND 250 Revolving Loan Fund $0.00 $0.00 $26,054.00
$83,990.00 $2,645.04 $176,979.01
Pi CITY OF ST JOSEPH 12/06/11 2:18 PM
'"L ,N�- 1/11L` p
EDA Revenue Report Page 1
Current Period: November 2011
2011 November 2011
FUND Descr SOURCE SOURCE Descr YTD Budget 2011 Amt YTD Amt
FUND 150 Economic Development
Economic Development 31010 Current Ad Valorem Taxes $0.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 $16,368.57
Economic Development 36210 Interest Earnings $150.00 $34.77 $216.71
Economic Development 39201 Transfers from Other Funds $83,840.00 $0.00 $56,000.00
FUND 150 Economic Development $83,990.00 $34.77 $72,585.28
FUND 156 TIF 1 -4 St. Joe Development
TIF 1-4 St. Joe Development 31050 Tax Increment $0.00 $0.00 $33,192.49
TIF 1-4 St. Joe Development 36210 Interest Earnings $0.00 $1.80 $593.60
FUND 156 TIF 1-4 St. Joe Development $0.00 $1.80 $33,786.09
FUND 157 TIF 2 -1 Millstream
TIF 2 -1 Millstream 31050 Tax Increment $0.00 $0.00 $23,580.89
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 $8.00 $94.29
FUND 157 TIF 2 -1 Millstream $0.00 $8.00 $23,675.18
FUND 250 Revolving Loan Fund
Revolving Loan Fund 36210 Interest Earnings $0.00 $16.77 $404.76
Revolving Loan Fund 39320 Revolving Loan Principal $0.00 $285.33 $3,134.10
Revolving Loan Fund 39321 Revolving Loan Interest $0.00 $44.67 $529.93
Revolving Loan Fund 39322 Revolving Loan Origination $0.00 $0.00 $785.00
FUND 250 Revolving Loan Fund $0.00 $346.77 $4,853.79
$83,990.00 $391.34 $134,900.34
a W Z H
a i W m H u - a u,,� m
. N N W N E W E c' d
W W W W W O N � W fn :r
U U y E 1 c d U d Z a
cz c m E W'N W = m O N=o, of
o Z o . O.. W W O m a
U2 o ac9U �c�in cvm
Lf1 175 ei. to O
Q in 0 .4. � r1 0 V: O O
C" N V 1J1 'd' l0 tD ".. Lfl
n
1-4 r-I h e't M n
N i N
mo v ..
,6x+3 8 Q 4
N O n t\ LT , Lf1 .--I N N
fyf O O V . m V1 O 01. ei '"�
N
L d "'� 6 O� l O M 14 l (0 N. 'CI
7 vi
N Ol Q N ^ M m
O
2
L
a+
Q O O
res N
W O � � '
f N el \ -
c N -c la O
V1 0 . v 3
C N
V1 O
i- C E 0 t l7
7 CO O O ++ In
0 0
C
is , N •
X O. N a) — w co o W
o N O Lf1 N
ei
W £ a _0 AI . Gl to N e-i a
n a v N Q ae m
fa M Q
N
a z 67
�u o + E E.D. �
.-i .oa
N a C C a Cl)
LL a t N C E 2 N O
O O
v d m 3 : o ui d o ,
OJ `'1 E 0 O N 0 • ' 0 0®0
CU N .2'
O O 3 N N `O J> O
0 W Cr 0 d C O M
7 O CO 2 s
ps V N
E in +` LL O
0 gy m I-o_ m�U
01
u° 0 0
e
o ((0 co
0
u
a 11 1 a
r• U
t ' E W
d t' J
a s 0 0 O
0 W w H