HomeMy WebLinkAbout01-22-2013 Council Handouts City of Oak Park Heights
Bills Presented for Payment January 22, 2013
Payroll
Gross Payroll with PERA, FICA, and Medicare
City Administration:
1 -31 -13 8,012.76
Part-Time
1 -19 -13 0.00
Finance:
Full -Time
1 -31 -13 10,149.89
Police Department:
Full -Time
1 -31 -13 36,736.09
Part-Time
1 -19 -13 0.00
Total Police 36,736.09
Building Inspection Department:
1 -31 -13 3,591.23
Public Works- Street Maint. Department:
Full -Time
1 -31 -13 1,019.70
Park and Recreation Department:
Full -Time
1 -31 -13 1,115.00
Part-Time
1 -19 -13 1,375.24
Water Department
Full -Time
1 -31 -13 6,675.97
Sewer Department
Full -Time
1 -31 -13 4,126.76
Storm Sewer Department
Full -Time
1 -31 -13 788.70
Total Utility Fund 11,591.43
Total Payroll 73,591.34
a
E O Of R O O 01 Cl) M
Z O O
O N M O O N M O M M
O O O O O O O O O O
a o 0 0 0 0 ° m G
Q m in o �_ m_ _
rn N Q N Y r N Y N
O. O O O O w O O O O O O O
M O
O p p p p m m p W O O N N O O O O
N l0 N N O O m v m m M M C',
N LL O O O O 0 O N N O O O O m O
N N N M 1N+7 O O m m N N M f0+7 N N
cc
0
Q
C
O O N O O 0
O O M O R
0 N O m
O O O O N O O m
E m N N Of m N O N
N
Q O M M
Z
O
C
rd- M M M M M M M M M M M
N O O O O O O O O O O O
❑ N N N N N N N N N N N
N N N N N N N N N N N
❑ O O O O O O O O O O O
C
G1
T
f0
a
r 01 M M M M M M M M N M M
❑ N N N N N N N_ N O O O
N N N
N C O
C O O O a O O O O O O O
Cl) � O �
W !00 cn
Q J C W
LL a N
ca j c 0 0
cli
c W Z m ik ° Z a
"' 3 r GO
U ❑ w
o W U w w
0 a w w Q v w a (gw
CL
o a.
❑
� I a of
> Q
w ° w r r
o N Q a Om ° LL Y m z Q m
CL LL C9 Z w V U
c N Q�Q W Im ? r H r C7 } W
N LLl W W W W W � R' W O Q'
LL ui T 10 o x m m m c7 ❑ m r❑
. r
a CL
Ix E m Cl)
c °D
Z M M M O M v N C m
co O
co
N n N N M O O Y LO
w Z Z w Z v U N N cli
C N O m � Z N �X x
d
E y
Z O
O r
N O
co W N co
mo Z Z ? w Qo Z r r
C7 N
0 LL CL
m J Z O ' 2 2
W Z r O O
❑ O N LLJ w Z Z w J J LU F-
W F Q >- O W Q Z W W
F Q Q m m m m U U °°
(' O m O m O M M a � Cl)
x E M M V
M Cl)
Y �
a Z
co O) O N N C14 O N
� n n rl
C O O O O O L i I u
Y d m O O O O O O O O
O > !9
LL OD O Of O O O O N O M O < O O O tD r N N
O Y I N r r A r r r n r N r r b
d E n n a n n N n M n
U
0 Z
d
a
E
7 O O N O M CD N CA N
N Z O N m O N N N
Q O O O O O O O O O N
N N a iS o o ro m 0 Ln o
a O co co N O co O N
'Q Q N Y '4 Y N
O_ O J O O O O O O O O O O
O 'O m Q C C N_ _ M O O O O O O O O O O co CD
N ' a N O O O O O O O O O O ap CO
N d CA m Cl) LO UO r w Cl) r r r r O O r r in W)
N in rn rn m w r r rn N N Q Q N N N N
C C �O rD tD CD Q r (D O O r •- .-
N N N N W) N
Q
O cli L co r r o r- LO r
coo (DD r O C N r
Z N r N U0 1 0
C
C
N M M M m M M M M M M
l0
O N N N N N N N N N N
d a a a s a a a a a a
O N N N N N N N N N N
C O O O O O O O O O O
d
E
T
N
a
d N N M M m N m N M N
0 0 0 0 0 Q 0 0 0 0
Qj N N N N_ N N N
C�7 M O M r C7 o co
o r M
a a a a
00 0 0 0
Q U
� W O
F w w
co Ix w z
m c w Q (n rn a U
r N ° a z w v ¢ x
n N N
CO) d W, w 0 w w (n
W
K p w w w O m ° Z
CI U 4: W g Z a o ix
> 0 > w z z g w
M w 2 0 p a O o
¢ J w x O x ° U J z a
C d � N H F N M F W O
E ' J N �2 r N N O
T
L C
d CL N N
N
O
7
Q N
z m m M aW m W
CI O co C m N co O N °
O Z
> N O 0 0 Q 1� O U) Q �q
CD m r
E O Z
cc CO
Z C7 to to x
0 z
fA w LL Q W Z
O o w U
W F H a W Y
J 2 W U 0
w W a s x ¢ D m LH
F- o
LL1 U to -'
r w c7 x x x x g z
x _
W N r Q Q L O O O l)
x E ` co
Y :3
a. Z
d O N N N M m M M co Cl) cn
'O n n r n r r n r r r
Y c in iD W) LO vl w h in U) In
Q m n LO w w w W) w m n
O
LL O CO O CA O O O O O N O t9 O Q O O m O
O Y N ~ N N M Cl) M M � M M � M
O z n r P r n r r r A n
d E h to w W) n n n an n
L = N N N N w N h N 1n h
V U Z
a
E
o m r r M o m O
Z o 0 0 0 0 0 o O
M o C? 1 M n M o o
ih o O o o v o 0 0 0
o O M
a ° ° 0
o 0 o n v (o m cn m
co
C if Q C �, N n N
a 0 -1 N O O O O N O O n O
M
O r r O O "t O O O O O O M M v R O O
N O O) N N O O m m m m M M n n m c0 m m m m
N a m m m m M ti n n M ri r r M M n n
N r r n n r r M M N N M M n n n n N N
n)
ca
E Cl) M O C r m m
C 07 N O c�0 m M cp m m
p c0 co m r V) i[i n M Ln
E r n n M N M n n N
E W M m r m
z 8 °
O
C
N M M M M M M M M M M
N
O N N N N N N N N N N
N N N N N N N
Q 7 N N N N N N N N N N
C O O O O O O O O O O i
d
E
r
m
a
U7 M M M M M N M M M M
O O O O O O O O O O
N N N N N N N N N N
n O N CD M C7 in m M
C O O O O O a O O O O
O W
O m
O
O
W 0
O
co F
_o
M c ik OJ m
E; ►- a 2 co
o N 'c U fA W U m W
0) N ¢ fn 0 ? a' w LL J
W W a
d' W a ° m ZQ a a.
> o F a 2 O LL W a co
L N O U -� :3 W
rn 2 y
Z co m d 0: W W CL N « LL y N j ca Z LL O
W W
g N LL a' O LL
O J 41
d o
CL w m o
LL O
a E O F O Z
7 N m� LL m M
Z Cl) J
O O ¢ W M O O)
O Z M M 0 2 N m co
> O W O O M O O
C L O Cl) LO z N c W O O
O
� U
E z
Z U W m
O W It J LL g
z LU cn
> 5 3 0 0 Lj
x
a
w LL o r z Q w
w W ¢ �' U n v z
W 0 U O U W U W
Y Q W W C7 V U Z 2
} W W Z Y LL LL g
x
0 0 0 v�
_ m M
CD n m n N
W M O O W N m r N n
2 E V R M R M
Y �
a: z
a `0 M a
n r n r n r r n r n
y in n n n in n n in n n
Q j n w n n n LO n n io n
O
LL r O M O W O O O O
O Y M ~ M ~ M ~ a ~ a ~ ~ Q ~ ~ a ~ Q ~
c� a r
a� E in on n n n in n n n n
r n in n an n n n in to n
U U Z
d
a
E CD M M O_ O_ O W N CO N N_
2 N M M M N N M N M M N N
C O O O O O O O O O O O O O O O O O
a O O n O 0 O N N
O In 0 N M O O O 0 0 O N O O 0 O
C Q _ IT I T 1 7
a O O O O O O O O O CD O O O O O O O O
M r r �- r r �- 01 O d1
O O O 01 n 01 Lo 0 0 0 0 0 O O O n r w M OD w CD q O a
N 0 0 0 e 0 0 0 0 0 0 0 o a a o r r N o 0
cli a 0 0 0 m 0 of v t'- o Co 0
N N N ( n O W) O R C CD Lo N N N N 0 O W O Cl) to M
C C N M co N CD N O O a
7 r r r d' N
E
Q
C O O r O O O O O O M O Q1 O
O n r o 0
0 V CD C 0 0 0 O ill co Ili
E N 0 n Ill O a 0 0 N N (0 0 0 O
Z
Q N M N cc N O O O O O M
Z
.
C
y M M M M M M M M M M M M M M M M M
O O O O O O O O O O O O O O O O O
° N N N N N N N N N N N N N N N N N
N a a N N a a N N N N a a s a s a s
7 N N N N N N N N N N N N N N N N N
O O O O O O O O O O O O O O O O O
C
C1
E
T
l0
CL
N N M M M M M M M M M M M M N M N M
O O O O O O O O O O O O O O O O O
° N N N N N N N N N N N N N N N N N
I� f- f- n a m f0 N O M
.' •- ` V
C O O O O O O O O O O O O O O
N
Z
w
W
x
Y W W W W W z
M o
oa WWWWW � LLJ
CL CJ Q O W W C/) > > > >> W W O ljj
�0 A V -0i a w w w w w j ti N N
>o J Waa WU)coco(n w x F �� °w
CV IL ui CL ° C Q U U Z Z Z Z Z z ui C=_9 a O
z z z z z z z w o
E m ? g aaaa g a a a wo vc°.t
a o
CL a`1
Q 7 N
7 N M M
2 y O O 0 a M O O O CD 0
C_1 O O n N N O N N r a0
Cl) n
r CO W O 2 Cl) 0 0 CD Q1 Cl)
a w 0 m 0 f0 O
C 0 00-1 2 W ' O O M V) n r
N
U U U U U
U
(D J J J J J LL LL
2 J J J J J ? LL LL
z z z z Z cn W W
as U. aaaaa J =x
> F U U U U U N y
U U U U U U z 3 U U U U
a: U to In z z z z Z 0 F }' 2 2 Z z
N W W W 22222 J F F O O O O
gg3g5 o ?? ??
w w w a a a a a x x x S x
co x 2 2 x 2 S co
co wcncn r— F- F r t— ° 33 39
(, O CD CD 0 W O 0 Q) 01 O (D N N 0 0 O O
C1 r coo w w w w w 01 M n r
w CD CD 0 O O O O O N 0 co co
x E a
Z
r 0 M O N LCM
a Lo Lo n n n Lo Lo
C 0 Ill O 0 0 O
Y 01 In In In In w Ir1 Lo
0
LL
0 A CO 0 - 0/ 01 W 01 0 O 0 N N F IMO h F Ian Yak
O Y ~ A A A F- la► A A n A ~ ^ F- n ~ A A A A A 1�
d E I w W) n in n n n n w IU) I' I' U2 W) n N
U U z
F
a
E
7 O. N w m w w e O
Z O N N N N N M O
O c O O O O O O O O
a o o m o
f0 O N O O o m
Qj N 00 sf N R
if Q N N
d 0 O O O O O O O Q
Cl)
O D t0 m O O n N CO co O W O O M
N '� O V V Q N N M O M OO OO O O fD
N 0_ n n n Il- M W OV v n O• r-
04 0) O O O N M N N On M M O) 03
7 M O to O N M M n n O
0 N N N N m
Q
c V N N M O M O
0
E O O N M N N M O
E W o m n
a) Q N N
z g
0
c
N m m M M M m m m
fa
❑ N N N N N N N N
a) N N N N N N N m
7 N N N N N N N
c
0 0 0 0 0 0 0 0
d
E
T
X.
a
a1 N m M m M m M M
C3 O 0 0 0 0 o O
❑ N N N N N N N N
c o 0 o o 0 0 0
QQ w
N J O
U W
L
M c o a p U LU o a W ❑
N N a) Z a ' w F F_ U'
❑ w _ CD J J J J
M LU
O O 5 H > > > > > On
N U U U U U Ix O
CL W K K K § cb
O H
H H H F N
>, v > U w w w w m u
m 'C
a d m � U) Ci Ci
E i
M N w
Z C N f` M O N co N
n N n m M O N
Z m 01 O N O (�
0: w N O n m O
c On w M to w 10 N ❑ LU
E w
E U
Z w
0 W U LL
cn O
o z rn a
w w
> z
❑ >- >- >- >- w z
J
w
O Z Z Z Z U 7
_ w w w w Z Z
J J J J W
w H LLJJ
w w w w a
F X X X X N Q
2
0 N N co O LO N Ln LO m M
w a o (D o
= E M m c
Z M w
Y c o LO Lo -n in F-
Q a� in -n in LO LO v
O �e 0 f 12 N N n N F co H F C7
a n n n n n n n c
E In M) n n w w n
Z
U U
6
CO
Z
CL 8 �
N N t7
� V Q
a . O J
M �
O O
N �
N Q
N
C C
7
E
Q
C
O
E
N Q
Z
0
c
d
m
7
C
d
E
T
m
a
a�
m
0
c�
.
M C
O
C N O.
c
CL N �
� � 0
N M
O O
N
CL O
Q
c y
d ..
E 1 °
T
a o
CL d
E
z'
c�
'o
c
E
E
m
Z
o V
c
co
t,
r
x
CD d cJ
z E
� z
C v
T
LL
O x O O
cr
U U z U Q
CITY OF OAK PARK HEIGHTS Joumals - TREASURER'S REPORT (2) Page: 1
JOURNAL ENTRIES (JE) Jan 22, 2013 04:29PM
Period: 12/31/2012 (12/12)
Report Criteria:
Journal Code.Journal Code = JE
Transaction.GL Account = 90110900000
Reference Account Debit Credit
Date Number Payee or Description Number Account Title Amount Amount
JE
12/12/2012 1 #12 -35 INV FHLB CALL 901 - 10900 -000 INVESTMENTS - AT PAR 100,000.00-
12/19/2012 1 #08-47 INV MORGAN STANLEY MATU 901 -10900 -000 INVESTMENTS -AT PAR 96,000.00-
12/31/2012 1 PURCHASE SB MM 901- 10900 -000 INVESTMENTS -AT PAR 201,112.98
12/18/2012 2 SALE OF 4M FUNDS 901 - 10900 -000 INVESTMENTS - AT PAR 301,000.00-
12/18/2012 2 PURCHASE SB MM 901 - 10900 -000 INVESTMENTS - AT PAR 301,000.00
12/1912012 3 #12 -48 PURCHASE INV COMENITY BA 901 - 10900 -000 INVESTMENTS - AT PAR 100,000.00
12/20/2012 3 #12-47 PURCHASE INV FHLB 901- 10900 -000 INVESTMENTS - AT PAR 399,996.00
12/31/2012 3 SALE OF SB MM 901 - 10900 -000 INVESTMENTS - AT PAR 499,996.00-
12/05/2012 4 SALE OF 4M FUNDS 901 - 10900 -000 INVESTMENTS -AT PAR 100,000.00-
12/12/2012 4 #12 -34 PURCHASE UBS MM 901 - 10900 -000 INVESTMENTS - AT PAR 100,075.34
12117/2012 5 SALE OF 4M FUNDS 901 - 10900 -000 INVESTMENTS - AT PAR 295,000.00-
12/19/2012 5 SALE OF 4M FUNDS 901 - 10900 -000 INVESTMENTS - AT PAR 988,000.00-
12/21/2012 5 #12 -21 INV FHLB CALLED 901 - 10900 -000 INVESTMENTS - AT PAR 147,000.00-
12/31/2012 5 PURCHASE WF MM 901- 10900 -000 INVESTMENTS -AT PAR 1,434,320.05
12/21/2012 6 #12-49 PURCHASE INV FHLB 901- 10900 -000 INVESTMENTS -AT PAR 500,000.00
12/21/2012 6 #12 -50 PURCHASE INV BANK BAROD 901 - 10900 -000 INVESTMENTS - AT PAR 245,000.00
12/26/2012 6 #12 -51 PURCHASE INV BANK INDIA 901- 10900 -000 INVESTMENTS - AT PAR 245,000.00
12/26/2012 6 #12 -52 PURCHASE INV MIZUHO 901 - 10900 -000 INVESTMENTS - AT PAR 245,000.00
12128/2012 6 #12 -53 PURCHASE INV FHLB 901 - 10900 -000 INVESTMENTS - AT PAR 400,000.00
12/31/2012 6 SALE OF WF MM 901 - 10900 -000 INVESTMENTS - AT PAR 1,635,000.00-
12/01/2012 7 #11 -13 CD MATURED CENTRAL BANK 901 - 10900 -000 INVESTMENTS -AT PAR 400,000.00-
12/01/2012 7 #12 -45 PURCHASE CD CENTRAL BAN 901- 10900 -000 INVESTMENTS -AT PAR 400,000.00
12/03/2012 8 #11 -11 CD MATURED FIRST STATE B 901 - 10900 -000 INVESTMENTS -AT PAR 500,000.00-
12/03/2012 8 #12 -46 PURCHASE CD FIRST STATE B 901- 10900 -000 INVESTMENTS - AT PAR 500,000.00
12/31/2012 9 INTEREST ON MONEY MARKETS 901 - 10900 -000 INVESTMENTS - AT PAR 34.78
12/19/2012 12 DECEMBER TAX SETTLEMENT 901 - 10900 -000 INVESTMENTS - AT PAR 1,995,773.08
Total JE: 7,067,312.23 5,061,996.00-
* * *
Journal is out of balance: $ 2,005,316.23 * * *
Grand Totals: 7,067,312.23 5,061,996.00-
CITY OF OAK PARK HEIGHTS Journals - Council Report (2) Page: 1
CASH DISBURSEMENTS (CD) Jan 22, 2013 04:30PM
Report Criteria:
Total By Reference Number and Date
Journal Code.Joumal Code = CD
Transaction.G Account = { < >} 990
Reference Account Debit Credit
Date Number Payee or Description Number Account Title Amount Amount
CD
1
02/01/2012 1 CORRECT CK 54460 -END CODING ER 101 - 21600 -000 DUE TO STATE - SALES TAX .01
99000
02/01/2012 99000 TOTAL CHECKS & OTHER CHARGES - 990 - 10100 -000 COMBINED CASH .01-
1
05/03/2012 1 COR BANK ERROR CK 54754 WAL MA 101 -41510 -311 OTHER MATERIALS & SUPPLIES .03
2
05/03/2012 2 COR CODING ERROR CK 50420129 B 101 - 40690 -415 EMPLOYEE HOSP & LIFE INS 10.00-
99000
05/0312012 99000 TOTAL CHECKS & OTHER CHARGES - 990 - 10100 -000 COMBINED CASH 9.97
1
08101/2012 1 CONTRIBUTION DEFICIT FOR JIM BUT 101 -41530 -212 OTHER CONTRACTUAL SERVICES 696.00
99001
08/01/2012 99001 TOTAL CHECKS & OTHER CHARGES - 990 - 10100 -000 COMBINED CASH 696.00-
99001
11/22/2012 99001 TOTAL CHECKS & OTHER CHARGES - 990 - 10100 -000 COMBINED CASH •22-
99002
11/30/2012 99002 TOTAL CHECKS & OTHER CHARGES - 990- 10100 -000 COMBINED CASH •22
1
12/22/2012 1 PSN SET UP FEES 705 -48100 -212 OTHER CONTRACTUAL SERVICES .22
2
12122/2012 2 PSN SET UP FEE INVOICE #56868 - N 705 -48100 -212 OTHER CONTRACTUAL SERVICES 49.50
PSN SET UP FEE INVOICE #56868 - N 706 -48200 -212 OTHER CONTRACTUAL SERVICES 49.50
99001
99.00•
12/2212012 99001 TOTAL CHECKS & OTHER CHARGES - 990 - 10100 -000 COMBINED CASH 99.22 -
Documents: 12 Transactions: 13
Total CD: 805.45 805.45 -
Grand Totals: 805.45 805.45-