HomeMy WebLinkAbout[04] Accounts Payable and Financial Report . CITY OF ST. ]C�S�PH
�v�v�.cityo f stjoseph.com
DATE: September 12,2012
MEMO TO: St.Joseph Economic Development Authority
FROM: Joanne Foust, Municipal Development Group
Administrator
Sudy Weyrens RE: Accounts Payable
August Financial Reports
Mayor
Richard Schultz
A. Accounts Payable:
Coun�ilors Following are Accounts Payable for the EDA's Consideration.
Steve Frank
sob Loso Payable To For Fund Amount
Renee Symanietz MDG, Inc. August Econ. Dev. Service 150-46500-300 $ 2,655.10
Dale wick $2200 services, $455.10 mileage
Total $ 2,655.10
EDA
Larry Hosch *Plus invoices noted on enclosed check register.
Doug Danielson
Steve Frank Action:
Tom skahen A MOTION is in order to approve the Accounts Payable.
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.
�r� CITY OF ST JOSEPH os/10/12 9Pa9 M
�`� ������� EDA Revenue Report
Current Period:August 2012
2012 August 2012
FUND Descr SOURCE SOURCE Descr YTD Budaet 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 $45.94 $576.42
Economic Development 39201 Transfers from Other Funds $0.00 $0.00 $0.00
FUND 150 Economic Development $70,725.00 $45.94 $35,190.55
FUND 156 TIF 1-4 St.]oe Development
TIF 1-4 St.]oe Development 31050 Tax Increment $0.00 $0.00 $30,600.84
TIF 1-4 St.Jce Development 36210 Interest Earnings $0.00 $7.16 -$27.16
FUND 156 TIF 1-4 St.Joe Development $0.00 $7.16 $30,573.68
FUND 157 TIF 2-1 Millstream
TIF 2-1 Millstream 31050 Tax Increment $0.00 $5,774.02 $23,854.61
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 Eamings $0.00 $10.60 $107.42
FUND 157 TIF 2-1 Millstream $0.00 $5,784.62 $23,962.03
FUND 250 Revolving Loan Fund
Revolving Loan Fund 36210 Interest Eamings $300.00 $16.45 $185.30
Revolving Loan Fund 39320 Revolving Loan Principal $6,885.00 $291.82 $4,567.87
Revolving Loan Fund 39321 Revolving Loan Interest $1,195.00 $38.18 $820.53
Revolving Loan Fund 39322 Revolving Loan Origination $0.00 $0.00 $0.00
FUND 250 Revolving Loan Fund $8,380.00 $346.45 $5,573.70
$79,105.00 $6,184.17 $95,299.96
r� CITY OF ST JOSEPH 09/10/12 9:04 AM
�`�r����� '" - � EDA Expenditure Report Page 1
Current Period:August 2012
2012 August 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 $2.17 $2.17
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 $539.91 $13,723.24
E 150-46500-303 Engineering Fee $2,0OO.OQ $0.00 $0.00
E 150-46500-304 Legal Fees $1,000.00 $0.00 $405.00
E 150-46500-321 Telephone $785.00 $70.07 $521.89
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 $5,598.54 $9,134.09
E 150-46500-622 TIF/Abatement Payments $0.00 $0.00 $0.00
FUND 150 Economic Development $70,725.00 $6,210.69 $24,617.45
FUND 156 TIF 1-4 St.Joe Development
E 156-46500-101 Salaries $0.00 $0.00 $21732
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 LifeInsurance $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 $34.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.Joe Development $0.00 $34.00 $27,831.72
FUND 157 lIF 2-1 Millstream
E 157-46500-101 Salaries $0.00 $18.11 $271.65
E 157-46500-121 PERA Contributions $0.00 $1.31 $19.68
E 157-46500-122 FICA Contributions $0.00 $1.12 $16.84
E 157-46500-123 Deferred Comp-Employer $0.00 $0.31 $4.63
E 157-46500-125 Medicare Contributions $0.00 $0.26 $3.94
E 157-46500-131 Health Insurance $0.00 $0.00 $0.00
E 157-46500-133 Life Insurance $0.00 $0.04 $0.56
E 157-46500-134 Disabilty Insurance $0.00 $0.26 $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 $34.00 $34.00
E 157-46500-622 TIF/Abatement Payments $0.00 $5,196.62 $21,469.15
E 157-49300-720 Transfers to Other Funds $0.00 $0.00 $D.00
FUND 157 TIF 2-1 Millstream $0.00 $5,252.03 $21,824.25
FUND 158 TIF 2-2 Meat Market
r� CITY OF ST JOSEPH 09/10/12 9:04 AM
��f���^�'� ''� EDA Expenditure Report Page 2
Current Period:August 2012
2012 August 2012
Account Descr YfD Budaet 2012 Amt YTD Amt
E 158-46500-SOl 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 LifeInsurance $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 $34.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 $34.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 $11,530.72 $74,446.66
r�� CITY OF ST JOSEPH 09/10/12 9�.�0 9 M
�`� ��� "� EDA Check Register
CHECK
# Search Name Comments FUND DEPART Amount
045561 MUNICIPAL DEVEIOPMENT CORP organizational development 150 46500 $1,011.59
045561 MUNICIPAL DEVELOPMENT CORP allocate]une services 150 46500 -$2,655.10
045561 MUNICIPAL DEVELOPMENT CORP demolition grant 150 46500 $21.24
045561 MUNICIPAL DEVELOPMENT CORP website 150 46500 $45.14
045561 MUNICIPAL DEVELOPMENT CORP downtown 150 46500 $496.50
045561 MUNICIPAL DEVELOPMENT CORP mtgs/research-qualified conta 150 46500 $900.08
045561 MUNICIPAL DEVELOPMENT CORP business retention 150 46500 $180.55
045615 CENTRYLINK Tl line Aug 150 46500 $50.59
045616 CENTURYLINK BUSINESS SERVICES long distance telephone July 150 46500 $4.08
045621 KJ DEVELOPMENT OF ST.JOE,LLC demolition grant-Delwin bldg 150 46500 $2,500.00
045631 SENTRY BANK Millstream TIF payment-8/9/ 157 46500 $5,196.62
045646 LEAGUE OF MN CITIES INS TRUST workers comp premium 8/8/12 150 46500 $2.17
045649 MUNICIPAL DEVELOPMENT CORP July EDA services-Business Ret 150 46500 $1,126.62
045649 MUNICIPAL DEVELOPMENT CORP July EDA services-Website 150 46500 $221.63
045649 MUNICIPAL DEVELOPMENT CORP July EDA services-Downtown 150 46500 $366.74
045649 MUNICIPAL DEVELOPMENT CORP July EDA services-Qualified Pro 150 46500 $313.98
045649 MUNICIPAL DEVELOPMENT CORP July EDA services-Organization 150 46500 $609.48
045654 ST.JOSEPH NEWSLEADER,INC TIF 2-2 annual report summar 158 46500 $34.00
045654 ST.JOSEPH NEWSLEADER,INC TIF 2-1 annual report summar 157 46500 $34.00
045654 ST.JOSEPH NEWSLEADER,INC TIF 1-4 annual report summar 156 46500 $34.00
045661 CENTRYLINK 20 sets of 229#'s-8/10-9/9/12 150 46500 $10.36
045665 CONE CASTLE,LLC BFA Loan-trees/shrubs 150 46500 $1,000.00
045709 CENTURYLINK BUSINESS SERVICES long distance telephone 7/24-8 150 46500 $5.04
$11,509.31
ri CITY OF ST JOSEPH 09/10/12 9:03 AM
���������'" _- � EDA Balance Sheet Pa9e�
Current Period:August 2012
YTD YTD Current
FUND Descr Account Descr Beqin Yr Debit Credit Balance
FUND 150 Economic Development
Economic Development G 150-10100 Cash $51,328.42 $42,909.03 $36,381.86 $57,855.59
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 $36,415.44 $46,988.54 -$40,023.72
FUND 150 Economic Development $0.00 $83,403.98 $83,403.98 $0.00
FUND 156 TIF 1-4 St.7oe Development
TIF 1-4 St.Jce Develop G 156-10100 Cash $17.95 $30,623.22 $27,840.89 $2,800.28
TIF 1-4 St.]ce 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.]ce Develop G 156-25310 Appropriated Fund Balance $1,941.68 $27,881.26 $30,623.22 -$800.28
FUND 156 TiF i-4 St.7oe Development $0.00 $58,504.48 $58,504.48 $0.00
FUNQ 157 TIF 2-1 Millstream
TIF 2-1 Millstream G 157-10100 Cash $8,443.84 $24,014.53 $23,109.15 $9,349.22
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 $23,161.65 $25,299.43 -$9,349.22
FUND 157 TIF 2-1 Millstream $0.00 $48,461.08 $48,461.08 $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-SO100 Cash $14,158.07 $5,607.65 $0.00 $19,765.72
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
Revoiving 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 $5,607.65 -$19,765.72
FUND 250 Revolving Loan Fund $0.00 $48,658.68 $48,658.68 $0.00
$0.00 $239,201.46 $239,201.46 $0.00
St. Joseph Economic Development Authority
Summary Treasurer's Report- Fund 150
August 31, 2012
Fund 150,EDA Balance as of December 37,2011(audited) 49,582.49
Year to Date Revenue:
Interest Earnings 576.42
Ad Valorem Taxes 34,614.13
Total Revenue 35,190.55
Year to Date Expenditure Total bv Proiect:
Market Development 4,008.65 *"
Business Development 7,532.88 "`*
Organizational Development 5,522.03 *"
Infrastructure Development 33.03 "'
Workforce Development - "`*
17,096.59
Year to Date Expenditures bv Obiect:
Board Stipends (35.00)
Staff Salaries -
Workers Comp Premium (2.17)
Office Supplies (225.45)
Software Support (529.52)
Municipal Development Group (13,723.24)
Legal/Engineering Fees (405.00)
Telephone (521.89)
Postage (1.90)
Business Luncheon -
Advertising (39.19)
Recording Fee -
Rentals -
St.Cloud EDA Membership Dues -
EDA Programs (9,134.09)
Total Expenses (24,617.45)
Fund Summaries as of August 31,2012:
EDA Fund Balance-Fund 150-unaudited 60,155.59
Designated for Capital Programs 29,823.24
Designated for DEED Housing Projects 16,368.57
Undesig nated 27,963,78
TIF 1-4 St.Joseph Development Fund Balance-Fund 156 800.28
TIF 2-1 Milistream Shops and Lofts Fund Balance-Fund 157 9,349.22
TIF 2-2 St.Joseph Meat Market Fund Balance-Fund 158 (469.9$)
Revolving Loan Fund Balance-Fund 250 19,765.72
•*Detail available upon request
2011 Capital Expenditures
General Fund Capital Improvement Plan-EDA
2012 final CIP Budget Adopted December 30,2011
As of August 31,2012
12/31/2011
Available through 8/31 through 8/31
Project �� ' Reserve � ° Transfers Spent �' � � `
Y�j��,'. � ' i
Department Account Code �r�,,,i Equipment Balance ,�� �F � 2012 2012 ,;� �� � � h ;
�i*: "' `� €�:
EDA 150-46500-582 Computer Software 1,200.00 �`��� : - ;� 1,200.00
€ �
�.� ��� �� �, a �,
�
EDA 150-46500-588 � � Let s Go Downtown 21,431.55 y ��=� �JF/ (8,490.65) (2,895 99) „ : 10,044.91 �y
��;Business Development/TIF (9,692.02) �W ���� ,\ - (1,333 07)�\ (1,025.09) ;�
�ProducedProcessor Institute (2,571.16) �'�� % 1,652.23 (81.07)``.' ��,
��1�,�,��`Business Demolition Program (6,500.00) ; 6,500.00 (2,603.66) 3,396.34 �, Del Win
,�.
,� �;, . � : �.Closet to Closet,
�
: � � ' Flower Pot
� 5
� �� �;breckets,
� �
a�� � �� � � r '- �
�� \,� -, y -Chiropractic
\,� �
�� _ ;':;,_ ,� ;Connection,
� �� a�Cone Castle
�BFA GranULoan Program 2,625.45 � �: - (2,418 37) 8,207.08 �shrubs/trees
�
, Rental Conversions (2,695.61) � ���,�E ` � 270.48 (74 87)R�e� - �
;��'CSAH 2/3 Collection Street (34.91) �x� �° ; 67.94 (33 03) ' °,
�. �. ,,, - �1
2,563.30 ���,, � - (9,440 06)v'� - 20,623.24 � �
� `�s
TOTAL EDA CIP 3,76330 ,, �..�� ,,;°,, - (9,440.06) ;,', 21,823.24