HomeMy WebLinkAbout[04b] Treasurer's Report 11 Council Agenda Item 4b
url,v 01Z S-1,josEl"10[i
MEETING DATE: June 15, 2016
AGENDA ITEM: Finance Report
SUBMITTED BY: Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A
PREVIOUS COUNCIL ACTION: None
BACKGROUND INFORMATION: The monthly Treasurer's Report is enclosed for the FDA's
review.
BUDGET/FISCAL IMPACT: For Information Only
ATTACHMENTS: Request for EDA Action
Summary Treasurer's Report
EDA Balance Sheet
EDA Check Register
EDA Revenue Report
EDA Expenditure Report
EDA Summary CIP
REQUESTED COUNCIL ACTION: Accept the May 2016 Treasurer's Report as presented.
St. Joseph Economic Development Authority
Summary Treasurer's Report - Fund 150
May 2016
Fund 150, EDA Balance as of December 31, 2015(Audited) 85,663.85
Year to Date Revenue:
Interest Earnings 912.78
TIF/Abatement Deposit 22,500.00
TIF/Abatement Fee 5,000.00
DEED Housing Grant Proceeds 23,057.00
Ad Valorem Taxes -
Transfers from Other Funds -
Total Revenue 51,469.78
Year to Date Expenditure Total by Prosect:
Market Development - **
Business Development 648.29 **
Organizational Development - **
Infrastructure Development - **
Workforce Development - **
648.29
Year to Date Expenditures by Object:
Board Stipends -
Staff Salaries/Training (5,273.39)
Workers Comp Premium -
Software Support/Office Supplies (591.87)
Professional Services (1,720.00)
Legal/Engineering Fees (29.10)
Telephone (269.85)
Greater St. Cloud Development Investment -
Marketing -
Advertising (256.37)
Coborn's Abatement -
CM Housing Grant Reimbursement (23,057.00)
Computer Hardware/Software (301.42)
EDA Programs -
Transfer to Other Funds -
Total Expenses (31,499.00)
Fund Summaries as of May 31, 2016:
EDA Fund Balance - Fund 150- (Unaudited) 105,634.63
Designated for Capital Programs 93,414.10
Designated for DEED Housing Projects 368.57
Undesignated 11,851.96
TIF 3-1 Central MN Credit Union Fund Balance - Fund 152 (5,692.56)
TIF 2-1 Millstream Shops and Lofts Fund Balance - Fund 157 17,250.28
TIF 2-2 St.Joseph Meat Market Fund Balance -Fund 158 (314.03)
TIF 2-3 Bayou Blues &Alley Flats Fund Balance -Fund 159 (4,358.75)
Revolving Loan Fund Balance-Fund 250 18,443.70
**Detail available upon request
EDA Balance Sheet
Current Period: May 2016
YTD YTD Current
FUND Descr Account Descr __��Yr Debit Cred it Balance
FUND 15oEconomic Development
Economic Development G 150-10100 Cash $73,788.56 $0,728.87 $*3,382.80 $94,13*.0
Economic Development G 150-10450 Interest Receivable $2*2.55 $8.80 $2*2.55 $8.80
Economic Development G 150-10700 Taxes Receivable oe|mqven $1,786.71 $8.88 $1,786.71 $8.80
Economic Development G zs8-z3zz3Due From other Gov tUnits $12,815.7* $8.80 $12,815.7* $8.80
Economic Development G zs8'zss8UDue From Other Fund $11,580.80 $8.80 $8.80 $11,580.80
Economic Development G 150-20200 Accounts pnynU|e -$11,883.80 $11,883.80 $8.80 $8.80
Economic Development G zs8'2828zSalaries Payable $8.80 $8.80 $8.88 $8.80
Economic Development G 158'22284 Deferred Inflow ofResources -$1,786.71 $1,786.71 $8.80 $8.80
Economic Development G 158'2**15 Design. Fd Bal [npno| pnoj -$62,583.81 $8.88 $8.80 -$62,583.81
Economic Development G 150-25310 Appropriated Fund Balance
FUND 150 Economic Development $8.80 $132,798.87 $132,798.87 $8.80
Fumo 152 TIF 3-1 CMCu
TIF 3-1 CMCu G 152-10100 Cash $*83.*9 $8.88 $96.85 $387.**
TIF 3-1 CMCu G 152-10450 Interest Receivable $8.80 $8.88 $8.80 $8.80
TIF 3-1 CMCu G 152-20200 Accounts pnynU|e $8.80 $8.88 $8.80 $8.80
TIF 3-1 CMCu G 152-28580 Due ToOther Fund -$6,800.80 $8.80 $8.88 -$6,800.80
TIF 3-1 CMCu G 152-25310 Appropriated Fund Balance
Fumo 152 TIF 3-1 CMCu $8.80 $96.85 $96.85 $8.80
FUND 153TIF 4-1 Fortitude Senior Apts
TIF 4-1 pommge Senior G 153-10100 Cash $8.80 $8.80 $8.80 $8.80
TIF 4-1 pommge Senior G 153-18458 Interest Receivable $8.80 $8.88 $8.80 $8.80
TIF 4-1 Fortitude Senior G 153-28580 Due ToOther Fund $8.80 $8.88 $8.80 $8.80
TIF 4-1 Fortitude Senior G 153-25310 Appropriated Fund Balance
FUND 153TIF 4-1 Fortitude Senior Apts $8.80 $8.80 $8.88 $8.80
FUND 157TIF 2-1 Millstream
TIF 2-1 Millstream G 157-10100 Cash $17,162.21 $1,*5*.82 $1,365.95 $17,258.28
TIF 2-1 Millstream G 157-10450 Interest Receivable $*7.95 $8.80 $*7.95 $8.80
TIF 2-1 Millstream G 157-13113 Due From other Gov tUnits $1,285.2* $8.88 $1,285.2* $8.80
TIF 2-zMillstream Gzs7-2828UAccounts Payable -$1,88*.72 $1,88*.72 $8.80 $8.80
TIF 2-1 Millstream G 157-25310 Appropriated Fund Balance
FUND 157TIF 2-1 Millstream $8.80 $5,157.88 $5,157.88 $8.80
Fumo 158 TIF 2-2 Meat Market
TIF 2-2 Ment Market G 158-10100 Cash $2*2.94 $3.84 $60.81 $185.97
TIF 2-2 Ment Market G 158-10450 Interest Receivable $8.62 $8.88 $8.62 $8.80
TIF 2-2 Ment Market G 158-28281 Salaries Payable $8.80 $8.80 $8.80 $8.80
TIF 2-2 Ment Market G 158-28580 Due ToOther Fund -$580.80 $8.80 $8.80 -$588.80
TIF 2-2 Ment Market G 158-25310 Appropriated Fund Balance
Fumo 158 TIF 2-2 Meat Market $8.80 $0.67 $63.67 $8.80
FUND 15yTIF 2-3 Bayou Blues/Alley Flat
TIF 2-3 Bayou a|ve$A|| G 159-10100 Cash $737.38 $8.80 $96.85 $6*1.25
TIF 2-3 Bayou a|ve$A|| G 159-10450 Interest Receivable $8.88 $8.80 $8.80 $8.80
TIF 2-3 Bayou a|ve$A|| G 159-20200 Accounts pnynU|e $8.88 $8.80 $8.80 $8.80
TIF 2-3 Bayou a|ve$A|| G 159-28580 Due ToOther Fund $5,808.80 $8.80 $8.80 -$5,808.80
TIF 2-3 Bayou a|ve$A|| G 159-25310 Appropriated Fund Balance
FUND 15yTIF 2-3 Bayou Blues/Alley Flat $8.80 $96.85 $96.85 $8.80
FUND 25oRevolving Loan Fund
Revolving Loan Fund G2s8'z8z8UCash $11,993.78 $6,7*5.80 $295.80 $18,**3.78
Revolving Loan Fund G2s8'z84s8Interest Receivable $56.68 $8.80 $56.68 $8.80
CITY OF ST. JOSEPH
Current Period: May 2016
YTD YTD Current
FUND Descr Account Descr Begin Debit Credit Balance
Revolving Loan Fund G 250-11900 Notes Receivable $58,816.28 $0.00 $58,816.28 $0.00
Revolving Loan Fund G 250-22204 Deferred Inflow of Resources -$58,816.28 $58,816.28 $0.00 $0.00
Revolving Loan Fund G 250-25310 Appropriated Fund Balance -$12,050.38 $351.68 $6,745.00 -$18,443.70
FUND 250 Revolving Loan Fund $0.00 $65,912.96 $65,912.96 $0.00
$0.00 $204,124.68 $204,124.68 $0.00
EDA Check Register
c*sCx
# Search Name Comments FUND DEPART Amount
058523 CsmTunxumK TI |me/28sets 229 #'s 158 *6580 $*9.6*
85852* CsmTunxumK BUSINESS SERVICES long distance telephone 158 *6580 $*.22
858573 BRAND BUILT HOMES,INC. CoApdraw#33 [Oren] 158 *6580 $18,289.80
858575 s*LsRSAND ASSOCIATES senior housing developments 158 *6580 $1,728.88
858587 TRI-COUNTY ACTION PROGRAM INC CoAp Draw#33 [aozzo,St|c4 158 *6580 $1,195.80
$13,177.86
Current Period: May 2016
2816 May 2816
FUND Descr SOURCE SOURCE Descr YTD Bud2et 2016 Amt YTD Amt
FUND zs8Economic Development
Economic Development 31818 Current Ad Valorem Taxes $122,365.80 $8.80 $8.80
Economic Development 33160 Federal Grants Other $8.80 $11,*84.80 $23,857.80
Economic Development 3*158 Tzp/Mzroepos|t $8.80 $17,580.80 $27,580.80
Economic Development 3*280 DEED Housing Re|mUvmem $8.88 $8.80 $8.80
Economic Development 36218 Interest Earnings $1,258.88 $159.57 $912.78
Economic Development 39281 Transfers from Other Funds
pumo zs8Economic Development $123,615.80 $29,863.57 $51,*69.78
pumo zs2TIF 3-z CMCu
TIF 3-1 CMCu 31858 Tax Increment $8.80 $8.88 $8.80
TIF 3-1 CMCu 36218 Interest Earnings $8.80 $8.80 $8.88
TIF 3-1 CMCu 39281 Transfers from Other Funds
pumo zs2TIF 3-z CMCu $8.88 $8.88 $8.80
pumo zs3TIF*-z Fortitude Senior Aps
TIF 4-1 Fortitude Senior Aps 31858 Tax Increment $8.80 $8.88 $8.80
TIF*-zFortitude Senior Aps 362z8 Interest Earnings $8.80 $8.80 $8.88
TIF*-zFortitude Senior Apts 39281 Transfers from Other Funds
FUND zs3TIF*-zFortitude Senior Aps $8.88 $8.88 $8.80
FUND zs7TIF 2-1 Millstream
TIF 2-1 Millstream 31858 Tax Increment $37,880.80 $8.80 $8.80
TIF 2-1 Millstream 36218 Interest Earnings
FUND zs7TIF 2-1 Millstream $37,275.80 $36.85 $280.83
FUND zs8TIF 2-2Meat Market
TIF 2-2 Ment Market 31858 Tax Increment $*,800.88 $8.80 $8.80
TIF 2-2 Ment Market 36218 Interest Earnings $5.88 $8.*9 $2.*2
TIF 2-2 Ment Market 39281 Transfers from Other Funds
FUND zs8TIF 2-2Meat Market $*,805.88 $8.*9 $2.*2
pumo zs9TIF 2-3 Bayou a|ve$A||ey Flat
TIF 2-3 Bayou a|ve$A||eyRn 31858 Tax Increment $8.88 $8.80 $8.80
TIF 2-3 Bayou a|ve$A||eyRn 36218 Interest Earnings $8.80 $8.80 $8.88
TIF 2-3 Bayou Blues/Alley Rn 39281 Transfers from Other Funds
pumo zs9TIF 2-3 Bayou a|ve$A||ey Flat $8.88 $8.80 $8.80
FUND 2s8Revolving Loan Fund
Revolving Loan Fund 36218 Interest Earnings $258.80 $33.86 $128.95
Revolving Loan Fund 39281 Transfers from Other Funds $8.80 $8.80 $8.80
Revolving Loan Fund 39328 Revolving Loan Principal $18,995.88 $1,367.88 $5,531.16
Revolving Loan Fund 39321 Revolving Loan Interest $1,618.88 $168.0 $733.21
Revolving Loan Fund 39322 Revolving Loan Origination
FUND 2s8Revolving Loan Fund $12,855.88 $1,560.77 $6,393.32
$177,758.80 $38,660.88 $58,866.35
CITY OF ST. JOSEPH
Expenditure Report
Current Period:May 2016
2016 May 2016
Account Descr YTD Budget 2016 Amt YTD Amt
FUND 150 Economic Development
E 150-46500-101 Salaries $18,985.00 $1,935.78 $3,868.40
E 150-46500-103 Legislative Bodies $1,260.00 $0.00 $0.00
E 150-46500-121 PERA Contributions $1,425.00 $145.19 $286.67
E 150-46500-122 FICA Contributions $920.00 $116.96 $233.54
E 150-46500-123 Deferred Comp-Employer $385.00 $0.31 $8.74
E 150-46500-125 Medicare Contributions $215.00 $27.35 $54.62
E 150-46500-130 H S A- Employer Contribution $790.00 $0.00 $419.50
E 150-46500-131 Health Insurance $4,190.00 $0.00 $0.00
E 150-46500-132 Dental Insurance $755.00 $35.57 $50.35
E 150-46500-133 Life Insurance $60.00 $0.00 $0.00
E 150-46500-134 Disabilty Insurance $175.00 $0.00 $0.00
E 150-46500-151 Workers Comp. Insur. Prem. $140.00 $0.00 $0.00
E 150-46500-171 Clothing Allowance $60.00 $0.00 $0.00
E 150-46500-200 Office Supplies $500.00 $0.00 $0.00
E 150-46500-215 Software Support $530.00 $0.00 $591.87
E 150-46500-300 Professional Services $3,000.00 $1,720.00 $1,720.00
E 150-46500-303 Engineering Fee $2,000.00 $0.00 $0.00
E 150-46500-304 Legal Fees $1,000.00 $0.00 $29.10
E 150-46500-321 Telephone $630.00 $53.86 $269.85
E 150-46500-322 Postage $350.00 $0.00 $0.00
E 150-46500-328 Marketing $2,000.00 $0.00 $0.00
E 150-46500-331 Travel&Conference Expense $245.00 $0.00 $351.57
E 150-46500-340 Advertising $500.00 $0.00 $256.37
E 150-46500-433 Dues&Memberships $0.00 $0.00 $0.00
E 150-46500-582 Computer Software $0.00 $0.00 $301.42
E 150-46500-588 EDA Programs $33,500.00 $11,404.00 $23,057.00
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 $123,615.00 $15,439.02 $31,499.00
FUND 152 TIF 3-1 CMCU
E 152-46500-101 Salaries $0.00 $80.56 $80.56
E 152-46500-121 PERA Contributions $0.00 $6.05 $6.05
E 152-46500-122 FICA Contributions $0.00 $4.86 $4.86
E 152-46500-123 Deferred Comp-Employer $0.00 $1.25 $1.25
E 152-46500-125 Medicare Contributions $0.00 $1.14 $1.14
E 152-46500-132 Dental Insurance $0.00 $2.19 $2.19
E 152-46500-133 Life Insurance $0.00 $0.00 $0.00
E 152-46500-134 Disabilty Insurance $0.00 $0.00 $0.00
E 152-46500-300 Professional Services $0.00 $0.00 $0.00
E 152-46500-301 Audit&Accounting Services $750.00 $0.00 $0.00
E 152-46500-340 Advertising $45.00 $0.00 $0.00
E 152-46500-622 TIF/Abatement Payments $0.00 $0.00 $0.00
E 152-49300-720 Transfers to Other Funds $0.00 $0.00 $0.00
FUND 152 TIF 3-1 CMCU $795.00 $96.05 $96.05
FUND 153 TIF 4-1 Fortitude Senior Apts
E 153-46500-101 Salaries $0.00 $0.00 $0.00
E 153-46500-121 PERA Contributions $0.00 $0.00 $0.00
E 153-46500-122 FICA Contributions $0.00 $0.00 $0.00
E 153-46500-125 Medicare Contributions $0.00 $0.00 $0.00
E 153-46500-300 Professional Services $0.00 $0.00 $0.00
E 153-46500-340 Advertising $0.00 $0.00 $0.00
��
-
Current Period: May 2016
2816 May 2816
Account Descr YTD Bud2et 2016 Amt YTD Amt
szs3-*ds8U's88EDA Programs
FUND zs3TIF*-zFortitude Senior Aps $8.80 $8.80 $8.88
FUND zs7TIF 2-1 Millstream
szs7-*ds8U'z8zSalaries $8.88 $60.*2 $2*8.56
E 157-*6580'121 psRA[onmUvuons $8.88 $*.53 $17.7*
E 157-*6580'122 FICA Contributions $8.80 $3.65 $z*.*z
szs7-*ds8U'z23 Deferred Comp-Employer $8.80 $8.94 $1.88
E 157-*6580'125 Medicare Contributions $8.80 $8.85 $3.36
szs7-*ds8U'z32Dental Insurance $8.80 $z.d* $3.28
szs7-*ds8U'z33 Life Insurance $8.88 $8.80 $8.80
E 157-*6580'13* o|snU||ty Insurance $8.88 $8.80 $8.80
szs7-*ds8U'38UProfessional Services $8.88 $8.80 $8.80
szs7-*ds8U'38zAudit&Accounting Services $580.80 $8.80 $8.80
E 157-46500-340 Advertising $*5.80 $8.80 $8.80
E zs7-*ds8U'd22TIF/Abatement Payments $3*,800.88 $8.80 $8.80
E zs7-*938U'728Transfers onOther Funds
FUND zs7TIF 2-1 Millstream $3*,5*5.80 $72.83 $281.23
FUND zs8TIF 2-2Meat Market
szs8-*ds8U'z8zSalaries $8.88 $*8.28 $58.35
E 158-*6580'121 psRA[onmUvuons $8.88 $3.82 $3.77
E 158-*6580'122 FICA Contributions $8.80 $2.*3 $3.84
szs8-*ds8U'z23 Deferred Comp-Employer $8.80 $8.62 $8.78
E 158-*6580'125 Medicare Contributions $8.80 $8.57 $8.71
szs8-*ds8U'z3z Health Insurance $8.88 $8.80 $8.80
szs8-*ds8U'z32Dental Insurance $8.88 $1.89 $1.36
szs8-*ds8U'z33 Life Insurance $8.88 $8.80 $8.80
szs8-*ds8U'z3* o|snU||tyInsurance $8.88 $8.80 $8.80
szs8-*ds8U'38UProfessional Services $8.88 $8.80 $8.80
szs8-*ds8U'38zAudit&Accounting Services $580.80 $8.80 $8.80
E 158-46500-340 Advertising $*5.80 $8.80 $8.80
E zs8-*ds8U'd22TIF/Abatement Payments
FUND zs8TIF 2-2Meat Market $*,5*5.88 $*8.81 $60.81
pumo zs9TIF 2-3 Bayou a|ve$A||ey Flat
szs9-*ds8U'z8zSalaries $8.88 $88.56 $88.56
E 159-*6580'121 psRA[onmUvuons $8.88 $6.85 $6.85
E 159-*6580'122 FICA Contributions $8.80 $*.86 $*.86
szs9-*ds8U'z23 Deferred Comp-Employer $8.80 $1.25 $1.25
E 159-*6580'125 Medicare Contributions $8.80 $z.z* $z.z*
szs9-*ds8U'z32Dental Insurance $8.80 $2.19 $2.19
szs9-*ds8U'z33 Life Insurance $8.88 $8.80 $8.80
szs9-*ds8U'z3* o|snU||tyInsurance $8.88 $8.80 $8.80
szs9-*ds8U'38UProfessional Services $8.88 $8.80 $8.80
szs9-*ds8U'38zAudit&Accounting Services $758.80 $8.80 $8.80
E 159-46500-340 Advertising $*5.80 $8.80 $8.80
szs9-*ds8U'd22TIF/Abatement Payments $8.88 $8.80 $8.80
E zs9-*938U'728Transfers onOther Funds
pumo zs9TIF 2-3 Bayou a|ve$A||ey Flat $795.80 $96.85 $96.85
FUND 2s8Revolving Loan Fund
s2s8'*ds8U'38UProfessional Services $8.88 $8.80 $8.80
s2s8'*ds8U'384 Legal pees $8.88 $8.80 $8.80
s2s8'*ds8U'3z7Other fees $8.88 $8.80 $8.80
CITY OF ST. JOSEPH
Expenditure Report
Current Period:May 2016
2016 May 2016
Account Descr YTD Budget 2016 Amt YTD Amt
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
$164,295.00 $15,751.16 $32,032.34
00 o Ln 0 h r14 0 0
a) Ln Ln Ln 00 w Ln � Ln
U 06 of n 6 n Lji 14C 1
a CY) m m 0--I Ln
o 12 Ili Ili Ili 't
m
m en
Nw r14 rg
ca
CY) 0
rn 't r14 0
1-1 1-4 06 06 r�
Ln 'o 0 w Ln
= r_
a) Vq m m m kc� o
bD 0 r4 cyi
=1 M N
0 (A
Ln
4
W 0
=1 a
0
R
0
0
w kD Ln Ln Lli
bD .q
m 'Y en
uj 04 N m en
to
r- Ln
U) F4 Ln
Q r- tm 0 Ln0 't 0 0
:3 a) r4 a) Oh r-I q-q Ln 00 00 w 00
E a) a)
0 > r u 0 cy) Lj0 i (Yi
N 00 en
0 m -1 Go
0 a) r-I m 00 w
CL C > N Cj' m 06
ux CL E eq
E a) r4
u
a) E E
0
CL E -o LL Cc" c) 0)
Cl)
M E 0 0 0)
0
CL
ri 0E
d U) CL
E 0 M (n 0 0
LZ w (n 0 0= >0)
(n
E 0
uj
0 = 0 LL
> E -i
rr 0 �: 0 0 E 0>0 co
uj U) C) C) —
(n
0 co
(n cu
0 W cu W o —
C14
CL
W
E < cQ
0 CO 0- CO 0�LL 0 C)U)
r® r® co m le LO a)
CD CD CD CD CD CD CD CD CD
u w
W M
E
:3
O. Z
uj uj uj uj uj uj uj uj uj
w 00 C14 00
_0 00
0 L? L?
u CD CD
CD CD
r_ LO LO
:3 (D (D
0
LO LO
<
u
w E
<
CL I-
w <0 <0 0
a Wui I-
St Joseph Economic Development Authority
Expense Report
Name PayPeriod:
Date Event Location Mtg # Reimbursement
Total
CERTIFICATION: I DECLARE THAT THIS TIMESHEET IS ATRUE AND CORRECT STATEMENT
OF MEETINGS WORKED AND THAT NO PART OF IT HAS BEEN PAID.
Signed Date