HomeMy WebLinkAbout[05a] Accounts Payable and Financial Reports •
CITY OF ST. JOSEPH
www.cityofstioseph.com
DATE: September 17,2014
MEMO TO: St.Joseph Economic Development Authority
FROM: Cynthia Smith-Strack Municipal Development Group
Administrator
Judy Weyrens RE: Accounts Payable
August 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. August Econ. Dev. Service 150-46500-300 $ 3,023.60
Dale Wick $2,500 services$523.60 mileage
Total $ 3,023.60
EDA
Doug Danielson *Plus invoices noted on enclosed check register.
Steve Frank
Larry Hosch As of August 31,2014 a total of 282.25 hours of service have been provided.Remaining balance
Gary Osberg for annual contract is 137.75 hours.
Dale Wick
Action:
A MOTION is in order to approve the Accounts Payable.
B. Financial Report:
August 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. Check Register
6. CIP Summary
A MOTION is in order to approve the Financial Reports.
7
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 09-10-14 Payment Terms: 30 days Customer ID#:
STJ14EDA
Project Aug Economic Development Services
Amount: $2,500.00 Monthly contract fee
$ 523.60 935 miles x .56
$3,023.60
Code to: 150-46500-300 for general EDA
Remit To: Municipal Development Group, Inc.
25562 Willow Lane
New Prague, MN 56071
Dates-EDA Hours
August 6, 2014 EDA Office Hours: C. Strack 8.00 Hours
August 12, 2014 EDA Office Hours: C. Strack 7.00 Hours
August 13, 2014 EDA Office Hours: C. Strack 8.00 Hours
August 15, 2014 EDA Office Hours: C. Strack 1.00 Hours
August 20, 2014 EDA Office Hours: C. Strack 8.00 Hours
August 27, 2014 EDA Office Hours: C. Strack 9.25 Hours
Total August 2014 41.25 Hours
Total Contract Hours August 31, 2014: 282.25 Hours
Thank you! We appreciated the opportunity to work with you!
Check No. Cynt iiia .S'mifIi-Strack
Date: Cynthia Smith-Strack,Principal MDG
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
August 2014
Fund 150, EDA Balance as of December 31, 2013 (Audited) 112,485.64
Year to Date Revenue:
Interest Earnings 1,345.71
DEED Housing Grant Proceeds 175,733.00
Ad Valorem Taxes 69,879.68
Total Revenue 246,958.39
Year to Date Expenditure Total by Project:
Market Development 2,683.73 **
Business Development 19,242.52 **
Organizational Development 3,219.49 **
Infrastructure Development - **
Workforce Development - **
25,145.74
Year to Date Expenditures by Object:
Board Stipends -
Staff Salaries -
Workers Comp Premium (3.50)
Software Support/Office Supplies (547.61)
Municipal Development Group (17,563.43)
Legal/Engineering Fees (76.50)
Telephone (563.02)
Greater St. Cloud Development Investment (5,000.00)
Business Round Table Outreach -
Marketing -
Advertising (63.00)
Coborn's Abatement -
CM Housing Grant Reimbursement (184,670.00)
EDA Programs (10,529.41)
Total Expenses (219,016.47)
Fund Summaries as of August 31, 2014:
EDA Fund Balance - Fund 150 -unaudited 140,427.56
Designated for Capital Programs 58,960.74
Designated for DEED Housing Projects 6,368.57
Undesignated 75,098.25
TIF 2-1 Millstream Shops and Lofts Fund Balance - Func 157 16,406.05
TIF 2-2 St.Joseph Meat Market Fund Balance - Fund 15E (482.86)
Revolving Loan Fund Balance-Fund 250 36,627.28
**Detail available upon request
7
J,„,94, . CITY OF ST. JOSEPH
Current Period:August 2014
YTD YTD Current
FUND Descr Account Descr Begin Yr Debit Credit Balance
FUND 150 Economic Development
Economic Development G 150-10100 Cash $116,317.66 $247,571.74 $223,961.84 $139,927.56
Economic Development G 150-10450 Interest Receivable $32.82 $0.00 $32.82 $0.00
Economic Development G 150-10700 Taxes Receivable-Delinquen $1,961.95 $0.00 $1,961.95 $0.00
Economic Development G 150-13113 Due From other Govt Units $569.16 $0.00 $569.16 $0.00
Economic Development G 150-15500 Due From Other Fund $500.00 $0.00 $0.00 $500.00
Economic Development G 150-20200 Accounts Payable -$4,934.00 $4,934.00 $0.00 $0.00
Economic Development G 150-22204 Deferred Revenue -$1,961.95 $1,961.95 $0.00 $0.00
Economic Development G 150-24415 Design. Fd Bal-Capital Proj -$37,151.57 $0.00 $0.00 -$37,151.57
Economic Development G 150-25310 Appropriated Fund Balance -$75,334.07 $224,011.59 $251,953.51 -$103,275.99
FUND 150 Economic Development $0.00 $478,479.28 $478,479.28 $0.00
FUND 157 TIF 2-1 Millstream
TIF 2-1 Millstream G 157-10100 Cash $14,115.17 $22,326.10 $20,035.22 $16,406.05
TIF 2-1 Millstream G 157-10450 Interest Receivable $4.56 $0.00 $4.56 $0.00
TIF 2-1 Millstream G 157-13113 Due From other Gov t Units $0.00 $0.00 $0.00 $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 -$14,119.73 $20,039.78 $22,326.10 -$16,406.05
FUND 157 TIF 2-1 Millstream $0.00 $42,365.88 $42,365.88 $0.00
FUND 158 TIF 2-2 Meat Market
TIF 2-2 Meat Market G 158-10100 Cash $34.13 $2,015.39 $2,032.38 $17.14
TIF 2-2 Meat Market G 158-10450 Interest Receivable $0.07 $0.00 $0.07 $0.00
TIF 2-2 Meat Market G 158-20500 Due To Other Fund -$500.00 $0.00 $0.00 -$500.00
TIF 2-2 Meat Market G 158-25310 Appropriated Fund Balance $465.80 $2,032.45 $2,015.39 $482.86
FUND 158 TIF 2-2 Meat Market $0.00 $4,047.84 $4,047.84 $0.00
FUND 250 Revolving Loan Fund
Revolving Loan Fund G 250-10100 Cash $30,853.05 $5,777.07 $2.84 $36,627.28
Revolving Loan Fund G 250-10450 Interest Receivable $8.76 $0.00 $8.76 $0.00
Revolving Loan Fund G 250-11900 Notes Receivable $29,035.23 $0.00 $29,035.23 $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 -$29,035.23 $29,035.23 $0.00 $0.00
Revolving Loan Fund G 250-25310 Appropriated Fund Balance -$30,861.81 $11.60 $5,777.07 -$36,627.28
FUND 250 Revolving Loan Fund $0.00 $34,823.90 $34,823.90 $0.00
$0.00 $559,716.90 $559,716.90 $0.00
f G-
CITY OF ST. JOSEPH
„ti\t„.9, EDA Check Register
CHECK
# Search Name Comments FUND DEPART Amount
048108 CENTURYLINK T1 line/20 sets 229#'s 150 46500 $111.90
048115 LODGE HOTELS&RESORTS final EDA payment-hotel stud 150 46500 $500.00
048117 MINNESOTA HOME IMPROVEMENTS CDAP#12-Supan 150 46500 $10,000.00
048144 MUNICIPAL DEVELOPMENT CORP June business retention 150 46500 $2,238.27
048144 MUNICIPAL DEVELOPMENT CORP June organizational developme 150 46500 $471.17
048169 CENTURYLINK BUSINESS SERVICES long distance telephone July 150 46500 $4.38
048183 MINNWEST BANK 1st half TIF-Millstream Shops 157 46500 $19,912.75
048186 PFANNENSTEIN, HARVEY&CAROL 1st half TIF-Meat Market 158 46500 $1,911.07
$35,149.54
1/
j&A-.44A- CITY OF ST. JOSEPH
Current Period:August 2014
2014 August 2014
Account Descr YTD Budget 2014 Amt YTD Amt
FUND 150 Economic Development
E 150-46500-101 Salaries $4,000.00 $0.00 $0.00
E 150-46500-103 Legislative Bodies $1,260.00 $0.00 $0.00
E 150-46500-121 PERA Contributions $0.00 $0.00 $0.00
E 150-46500-122 FICA Contributions $0.00 $0.00 $0.00
E 150-46500-123 Deferred Comp-Employer $0.00 $0.00 $0.00
E 150-46500-125 Medicare Contributions $0.00 $0.00 $0.00
E 150-46500-151 Workers Comp.Insur. Prem. $10.00 $3.50 $3.50
E 150-46500-200 Office Supplies $500.00 $25.28 $25.28
E 150-46500-215 Software Support $540.00 $0.00 $522.33
E 150-46500-300 Professional Services $28,000.00 $2,268.01 $17,563.43
E 150-46500-303 Engineering Fee $2,000.00 $0.00 $76.50
E 150-46500-304 Legal Fees $1,000.00 $0.00 $0.00
E 150-46500-321 Telephone $785.00 $58.52 $563.02
E 150-46500-322 Postage $350.00 $0.00 $0.00
E 150-46500-328 Marketing $3,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 $63.00
E 150-46500-410 Rentals $0.00 $0.00 $0.00
E 150-46500-433 Dues&Memberships $5,000.00 $0.00 $5,000.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 $33,500.00 $4,332.59 $195,199.41
E 150-46500-622 TIF/Abatement Payments $50,000.00 $0.00 $0.00
E 150-49300-720 Transfers to Other Funds $0.00 $0.00 $0.00
FUND 150 Economic Development $130,595.00 $6,687.90 $219,016.47
FUND 157 TIF 2-1 Millstream
E 157-46500-101 Salaries $0.00 $0.00 $55.98
E 157-46500-121 PERA Contributions $0.00 $0.00 $4.06
E 157-46500-122 FICA Contributions $0.00 $0.00 $3.01
E 157-46500-123 Deferred Comp-Employer $0.00 $0.00 $0.94
E 157-46500-125 Medicare Contributions $0.00 $0.00 $0.70
E 157-46500-131 Health Insurance $0.00 $0.00 $9.15
E 157-46500-132 Dental Insurance $0.00 $0.00 $1.55
E 157-46500-133 Life Insurance $0.00 $0.00 $0.12
E 157-46500-134 Disabilty Insurance $0.00 $0.00 $0.77
E 157-46500-300 Professional Services $0.00 $0.00 $0.00
E 157-46500-340 Advertising $0.00 $0.00 $45.00
E 157-46500-622 TIF/Abatement Payments $0.00 $0.00 $19,912.75
E 157-49300-720 Transfers to Other Funds $0.00_ $0.00 $0.00
FUND 157 TIF 2-1 Millstream $0.00 $0.00 $20,034.03
FUND 158 TIF 2-2 Meat Market
E 158-46500-101 Salaries $0.00 $0.00 $55.98
E 158-46500-121 PERA Contributions $0.00 $0.00 $4.06
E 158-46500-122 FICA Contributions $0.00 $0.00 $3.02
E 158-46500-123 Deferred Comp-Employer $0.00 $0.00 $0.94
E 158-46500-125 Medicare Contributions $0.00 $0.00 $0.71
E 158-46500-131 Health Insurance $0.00 $0.00 $9.15
E 158-46500-132 Dental Insurance $0.00 $0.00 $1.55
E 158-46500-133 Life Insurance $0.00 $0.00 $0.13
E 158-46500-134 Disabilty Insurance $0.00 $0.00 $0.77
E 158-46500-300 Professional Services $0.00 $0.00 $0.00
/Z--
CITY OF ST. JOSEPH
EDA Expenditure Report
Current Period:August 2014
2014 August 2014
Account Desa YTD Budget 2014 Amt YTD Amt
E 158-46500-340 Advertising $0.00 $0.00 $45.00
E 158-46500-622 TIF/Abatement Payments $0.00 $0.00 $1,911.07
FUND 158 TIF 2-2 Meat Market $0.00 $0.00 $2,032.38
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
$130,595.00 $6,687.90 $241,082.88
/3
j\LA.,PAA CITY OF ST. JOSEPH
Current Period:August 2014
2014 August 2014
FUND Descr SOURCE SOURCE Descr YTD Budget 2014 Amt YTD Amt
FUND 150 Economic Development
Economic Development 31010 Current Ad Valorem Taxes $130,095.00 $0.00 $69,879.68
Economic Development 33160 Federal Grants-Other $0.00 $3,577.00 $175,733.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 $500.00 $178.28 $1,345.71
Economic Development 39201 Transfers from Other Funds $0.00 $0.00 $0.00
FUND 150 Economic Development $130,595.00 $3,755.28 $246,958.39
FUND 157 TIF 2-1 Millstream
TIF 2-1 Millstream 31050 Tax Increment $0.00 $0.00 $22,125.28
TIF 2-1 Millstream 33404 Market Value Credit $0.00 $0.00 $0.00
TIF 2-1 Millstream 36210 Interest Earnings $0.00 $30.90 $195.07
FUND 157 TIF 2-1 Millstream $0.00 $30.90 $22,320.35
FUND 158 TIF 2-2 Meat Market
TIF 2-2 Meat Market 31050 Tax Increment $0.00 $0.00 $2,011.66
TIF 2-2 Meat Market 36210 Interest Earnings $0.00 $0.75 $3.66
TIF 2-2 Meat Market 39201 Transfers from Other Funds $0.00 $0.00 $0.00
FUND 158 TIF 2-2 Meat Market $0.00 $0.75 $2,015.32
FUND 250 Revolving Loan Fund
Revolving Loan Fund 36210 Interest Earnings $300.00 $54.26 $377.07
Revolving Loan Fund 39320 Revolving Loan Principal $7,095.00 $611.56 $4,849.98
Revolving Loan Fund 39321 Revolving Loan Interest $985.00 $61.99 $538.42
Revolving Loan Fund 39322 Revolving Loan Origination _ $0.00 $0.00 $0.00
FUND 250 Revolving Loan Fund $8,380.00 $727.81 $5,765.47
$138,975.00 $4,514.74 $277,059.53
/y
• > N V
o
qua
o w 43 r
0 0
F L - N
m
< .--1
O 0 0 0 00 I. 00 01 V n
Lu N 0 O CO 1/1 V .--1 I,
O Ql Vl .--I a; Ul O O
C m R u O^ N ul NO m tO .-I N rn up
C
0 fa .--I lfl l/l Ol N- LA
v, 0 m N '-i V1
a) a'
C a)u
+3+ . a) •
a) 0 O
C > 0 N
O C
O. Y
Q rn .1 0 CO m .-1 ti
x E m m o 1� v v
`+' Op > Co co N m O1
(p Q 0 C a l0 V .--I N N
+ f4 �.., t y �"� N N Ifl
a „ v w = N N ao v o i
C.
f0 a to O 0
U co -O v
[t U m Q «_+
.-i
N C O_ .i
7 U m H
6L y i
(p a0 a)
f0 C L 4 V
N
a) cl 7 ,C(o N
C c} O
0 O C
N
O O O O
0
O O 0 i ■ o O O O 0 a O Ln'O p vi 00 m m
7 N r-I .--1 CO
m
m O O LO N e-I Ol if)
0 - ) O O LC Vl .--I .-I 1-1 ""1
N > u O N V .-1 ' 1� ul O 0
CO 0) 0 N v CO o`oo � N Cn rn
m m aJ co c-i O 111 Oi Oi M m
N Q m
N
E
LL @
H o aa) O
a) E
C � a
CD+' C O O C
E 2 co
O O 'O > 0 0
O. C s' O Q "' " a)
S O a) a) ....1 > O
up
3
w ° 0o ca C 0M
O (`2n ( 0 T6 U N
o- C C (.7 (6 =
E n co Q C Q
O r) 7 7 0 W a) (n
U _J m000 03WU
T N 1, co O1 M at 10
0000 O O O
0) O M Ma- a- a- a- Ma-
2 E T T T T T T T T
7 Q Q Q Q Q Q Q Q
a z in 0 0 0 0 0 0 0
w wwww www
a' (N CO
0 00
o LO u)
U O O
c 0 In In
0• CO CO
u V V
u
a 0 O in a
_
U
c a
v
`) E �w
a)
'0 ` J
a v D 0 H
0 W W I-