HomeMy WebLinkAbout[05] Accounts Payable & Financial Reports CITY OF ST. J�S�PH
�v��w.cityof stjoseph.com
DATE: October 17,2012
MEMO TO: St.Joseph Economic Development Authority
FROM: Joanne Foust 8�Cynthia Smith-Strack, Municipal Development Group
Administrator
,Tudy Weyrens RE: Accounts Payable
September Financial Reports
Mayor
Richard Schultz
A. Accounts Payable:
Coun�ilors Following are Accounts Payable for the EDA's Consideration.
Steve Frank
Bob Loso Payable To For Fund Amount
Renee symanietZ MDG, Inc. Sept. Econ. Dev. Service 150-46500-300 $ 2,738.91
Dale wi�k $2,200 services, $538.91 mileage
Tota! (Extra trip to meet with business prospect) $ 2,738.91
EDA
Larry Hosch `Plus invoices noted on enclosed check register.
Doug Danielson
Steve Frank Action:
'rom Skahen A MOTION is in order to approve the Accounts Payable.
Dale Wick
B. Financial Report:
May financial reports are attached for your consideration.
Z
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 Repo�ts.
ri CITY OF ST JOSEPH 10/05/12 3:27 PM
�`����-�'"� "� EDA Balance Sheet Pa9e�
Current Period:September 2012
YTD YTD Current
FUND Descr Account Descr Beain Yr Debit Credit Balance
FUND 150 Economic Development
Economic Development G 150-10100 Cash $51,328.42 $43,060.70 $41,268.33 $53,120.79
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 Desiqn.Fd Bal-Capital Proi -$20,131.87 $0.00 $0.00 -$20,131.87
Economic Development G 150-25320 Appropriated Fund Balance -$29,450.62 $41,301.91 $47,140.21 -$35,288.92
FUND 150 Economic Development $0.00 $88,442.12 $88,442.12 $0.00
FUND 156 7IF 1-4 St.7ce Development
TIF 1-4 St.Jce Develop G 156-10100 Cash $17.95 $30,646.29 $27,840.89 $2,823.35
TIF i-4 St.Jce Develop G 156-10450 Interest Receivable $40.37 $0.00 $40.37 $0.00
TIF 1-4 St.Jce Develop G 156-20500 Due To Other Fund -$2,000.00 $0.00 $0.00 -$2,000.00
TIF 1-4 St.]oe Develop G 156-25310 Appropriated Fund Balance $1,941.68 $27,881.26 $30,646.29 -$823.35
FUND 156 T!F i-4 St 7ce Development $0.00 $58,527.55 $58,527.55 $0.00
FUND 157 TIF 2-1 Millstream
TIF 2-1 Millstream G 157-10100 Cash $8,443.84 $24,046.99 $23,109.15 $9,381.68
TIF 2-1 Millstream G 157-10450 Interest Receivable $10.02 $0.00 $10.02 $0.00
TIF 2-1 Miilstream 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 $23,161.65 $25,331.89 -$9,381.68
FUND 157 TIF 2-i Millstream $0.00 $48,493.54 $48,493.54 $0.00
FUND 158 TIF 2-2 Meat Market
TIF 2-2 Meat Market G 158-10100 Cash $3.26 $0.00 $173.24 -$169.98
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 $173.24 $0.00 $469.98
FUND 158 TIF 2-2 Meat Market $0.00 $173.24 $173.24 $0.00
FUND 250 Revolving Loan Fund
Revolving Loan Fund G 250-10100 Cash $14,158.07 $6,330.58 $0.00 $20,488.65
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 $6,330.58 -$20,488.65
FUND 250 Revolving Loan Fund $0.00 $49,381.61 $49,381.61 $0.00
$0.00 $245,018.06 $245,018.06 $0.00
t� CITY OF ST JOSEPH 10/05/12 3:32 PM
�����--�'��'� EDA Check Register Page 1
CHECK
# Search Name Comments FUND DEPART Amount
045725 CENTRYLINK Sep Tl Line 150 46500 $50.59
045730 INTEGRATED MEDIA photographs-website/EDA 150 46500 $375.00
045756 MUNICIPAL DEVELOPMENT CORP BFA loans 150 46500 $46.73
045756 MUNICIPAL DEVELOPMENT CORP Qualified project contacts 150 46500 $1,514.64
045756 MUNICIPAL DEVELOPMENT CORP Downtown 150 46500 $60.48
045756 MUNICIPAL DEVELOPMENT CORP Website 150 46500 $217.16
045756 MUNICIPAL DEVELOPMENT CORP Public speaking engagement 150 46500 $30.24
045756 MUNICIPAL DEVELOPMENT CORP Business retension 150 46500 $294.13
045756 MUNICIPAL DEVELOPMENT CORP Organizational development 150 46500 $585.52
045768 CENTRYLINK 20 sets of 229 numbers 9-/10- 150 46500 $10.37
045773 FLORAL ARTS EDA BFA grant-sign 150 46500 $1,000.00
045791 SENTRY BANK-CREDIf CARD EDA toner 150 46500 $71.93
045791 SENTRY BANK{REDIf CARD EDA logo cups/pens 150 46500 $629.68
$4.886.47
fi CITY OF ST JOSEPH 10/05/12 3:32 PM
������-'��''��'" - � EDA Expenditure Report Pa9e�
Current Period:September 2072
2012 September 2012
Account Descr YTD Budqet 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 $2.17
E 150-46500-200 Office Supplies $500.00 $71.93 $297.38
E 150-46500-215 Software Support $540.00 $0.00 $529.52
E 150-46500-300 Professional Services $28,000.00 $1,502.05 $15,225.29
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.96 $582.85
E 150-46500-322 Postage $350.00 $0.00 $1.90
E 150-46500-328 Marketing $8,000.00 $629.68 $629.68
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 $2,621.85 $11,755.94
E 150-46500-622 TIF/Abatement Payments $0.00 $0.00 $0.00
FUND 150 Economic Development $70,725.00 $4,886.47 $29,503.92
FUND 156 TIF i-4 St.Joe Development
E 156-46500-101 Salaries $0.00 $0.00 $217.32
E 156-46500-121 PERA Contributions $0.00 $0.00 $15.75
E 156-46500-122 FICA Contributions $0.00 $0.00 $13.47
E 156-46500-123 Deferred Comp-Employer $0.00 $0.00 $3.75
E 156-46500-125 Medicare Contributions $0.00 $0.00 $3.15
E 156-46500-131 Health Insurance $0.00 $0.00 $0.00
E 156-46500-133 Life Insurance $0.00 $0.00 $0.45
E 156-46500-134 Disabilty Insurance $0.00 $0.00 $3.07
E 156-46500-300 Professional Services $0.00 $0.00 $0.00
E 156-46500-340 Advertising $0.00 $0.00 $34.00
E 156-46500-588 EDA Programs $0.00 $0.00 $0.00
E 156-46500-622 TIF/Abatement Payments $0.00 $0.00 $27,540.76
FUND 156 TIF 1-4 St.]ce Development $0.00 $0.00 $27,831.72
FUND 157 TIF 2-1 Millstream
E 157-46500-101 Salaries $0.00 $0.00 $271.65
E 157-46500-121 PERA Contributions $0.00 $0.00 $19.68
E 157-46500-122 FICA Contributions $0.00 $0.00 $16.84
E 157-46500-123 Deferred Comp-Employer $0.00 $0.00 $4.63
E 157-46500-125 Medicare Contributions $0.00 $0.00 $3.94
E 157-46500-131 Health Insurance $0.00 $0.00 $0.00
E 157-46500-133 Life Insurance $0.00 $0.00 $0.56
E 157-46500-134 Disabilty Insurance $0.00 $0.00 $3.80
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 $34.00
E 157-46500-622 TIF/Abatement Payments $0.00 $0.00 $21,469.15
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,824.25
FUND 158 TIF 2-2 Meat Market
ri CITY OF ST JOSEPH 10J05/12 3:32 PM
�`� ���� "" - � EDA Expenditure Report Page 2
Current Period:September 2012
2012 September 2012
Account Descr YTD Budaet 2012 Amt YTD Amt
E 158-46500-101 Salaries $0.00 $0.00 $117.72
E 158-46500-121 PERA Contributions $0.00 $0.00 $8.54
E 158-46500-122 FICA Contributions $0.00 $0.00 $7.31
E 158-46500-123 Deferred Comp-Employer $0.00 $0.00 $2.03
E 158-46500-125 Medicare Contributions $0.00 $0.00 $1.71
E 158-46500-131 Health Insurance $0.00 $0.00 $0.00
E 158-46500-133 Life Insurance $0.00 $0.00 $0.25
E 158-46500-134 Disabilty Insurance $0.00 $0.00 $1.68
E 158-46500-300 Professional Services $0.00 $0.00 $0.00
E 158-46500-340 Advertising $0.00 $0.00 $34.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 $173.24
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 $4,886.47 $79,333.13
ri CITY OF ST JOSEPH 10/05/12 3:35 PM
��I����_� Page 1
EDA Revenue Report
Current Period:September 2012
2012 September 2012
FUND Descr SOURCE SOURCE Descr YTD Budqet 2012 Amt YTD Amt
FUND 150 Economic Development
Economic Development 31010 Current Ad Valorem Taxes $70,500.00 $0.00 $34,614.13
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 $151.67 $728.09
Economic Development 39201 Transfers from Other Funds $0.00 $0.00 $0.00
FUND 150 Economic Development $70,725.00 $151.67 $35,342.22
FUND 156 TIF 1-4 St.Joe Development
TIF 1-4 St.Joe Development 31050 Tax Increment $0.00 $0.00 $30,600.84
TIF 1-4 St.Joe Development 36210 Interest Eamings $0.00 $23.07 -$4.09
FUND 156 TIF 1-4 St.]oe Development $0.00 $23.07 $30,596.75
FUND 157 TIF 2-1 Millstream
TIF 2-1 Millstream 31050 Tax Increment $0.00 $0.00 $23,854.61
TIF 2-1 Millstream 33404 Market Value Credit $0.00 $0.00 $0.00
TIF 2-1 Milistream 34150 TIF/MIF Deposit $0.00 $0.00 $0.00
TIF 2-1 Millstream 36210 Interest Eamings $0.00 $32.46 $139.88
FUND 157 TIF 2-1 Millstream $0.00 $32.46 $23,994.49
FUND 250 Revolving Loan Fund
Revolving Loan Fund 36210 Interest Eamings $300.00 $49.38 $234.68
Revolving Loan Fund 39320 Revolving Loan Principal $6,885.00 $577.43 $5,145.30
Revolving Loan Fund 39321 Revolving Loan Interest $1,195.00 $96.12 $916.65
Revolving Loan Fund 39322 Revolving Loan Origination $0.00 $0.00 $0.00
FUND 250 Revolving Loan Fund $8,380.00 $722.93 $6,2%.63
$79,105.00 $930.13 $96,230.09
St. Joseph Economic Development Authority
Summary Treasurer's Report- Fund 150
September 30, 2012
Fund 150,EDA Balance as of December 31,2017 (audited) 49,582.49
Year to Date Revenue:
Interest Earnings 728.09
Ad Valorem Taxes 34,614.13
Total Revenue 35,342.22
Year to Date Exaenditure Total bv Proiect:
Market Development 5,230.49 **
Business Development 10,479.10 '"
Organizational Development 6,707.55 "*
Infrastructure Development 33.03 ""
Workforce Development - "*
21,850.17
Year to Date Exnenditures bv Obiect:
Board Stipends (35A0)
Staff Salaries -
Workers Comp Premium (2.17)
Office Supplies (297.38)
Soflware Support (529.52)
Municipal Development Group (15,225.29)
Legal/Engineering Fees (405.00)
Telephone (582.85)
Postage (1.90)
Marketing (629.68)
Advertising (39.19)
Recording Fee -
Rentals -
St.Cloud EDA Membership Dues -
EDA Programs (11,755.94)
Total Expenses (29,503.92)
Fund Summaries as of September 30,2072:
EDA Fund Balance-Fund 150-unaudited 55,420.79
Designated for Capital Programs 21,$23.24
Designated for DEED Housing Projects 16,368.57
Undesignated 17,228.98
TIF 7�S�Joseph Development Fund Balance-Fund 156 823.00
TIF 2-1 Millstream Shops and Lofts Fund Balance-Fund 157 9,382.00
TIF 2-2 St.Joseph Meat Market Fund Balance-Fund 158 (469.98)
Revolving Loan Fund Balance-Fund 250 20,489.00
"*Detail availab/e upon request
2031 Capital Expenditures
General Fund Capital Improvement Plan-EDA
2012 finat CIP Budget Adopted December 30,2011
As of September 30,2012
12/31/2011
Available through 9/30 through 9/30
Project ��"� Reserve � <�a; Transfers Spent �� .
, :�z ��
Department Account Code �,��i ��; Equipment Balance ? � 2012 2012 ;��;�€� y
� � �
N 3 ;.
EDA 150-46500-582 �p�'I�§�Computer Software 1,200.00 � ,_ ���,,.:;: - 1,200.00 �`'.
� . ����
EDA 150-46500-588 �#�'1 LeYs Go Downtown 21,431.55 � �j (8,490.65) (2,956 47) ;; 9,984.43
���; �Business Development/TIF (9,692.02) � \ j � - (2,847 71)�6� (2,539.73)
�
� ProducedProcessor Institute (2,571.16) � * 1,652.23 (81 07)� ° - � ;
� Business Demolition Program (6,500.00) �� �S, � 6,500.00 (2,603 66) ; 3,396.34 ��� Del Win
��e t� ��� �: �'s�`-
E .g � ��� ': Fbral Arts,
y������'� g �`\\ �� . j:
�\ \_ f� ��
� ��J \ . . ; ��:Goset to Closet,
���; �� �:= L�,� ���Flower Pot
. �. � . "_ � c�° breckets,
-� y --' � �'s � � °Chiroprectic
��
o � ,:Connection,
. � � :R �:;�.
� '.. ��' � � � , • '�- e
-Cone Castl
��( ;��� � ������ :shrubs/trees,
-r�� � �• :Scenic
� BFA GranULoan Program 2,625.45 !�� - (3,465 10).�; 7,160.35 specialties
� Rental Conversions (2,695.61) � _. 270.48 (74 87) , - �
�..�'I� CSAH 2/3 Collection Street (34.91) r��"� 67.94 (33 03) � -
2,563.30 � , ; - (12,06191) ��;, 18,001.39 �
� �.,, ; \��'
TOTAL EDA CIP 3,763.30 - (12,06191),-': 19,201.39 �,��