HomeMy WebLinkAboutMINUTES - 09281999 - C96 C.96
THE BOARD OF SUPERVISORS O
CONTRA COSTA COUNTY, CALIFORNIA
Adopted this Order on September 28, 1999 by the following vote:
AYES: Swervisors Gioia, Uilkerna, Gerber, DeSaulnier, Canciarnilla
NOES: None
ABSENT. eons
ABSTAIN: lone
SUBJECT: Treasurer's Reconciliation Report As Of May 28, 1999
IT 1S BY THE BOARD ORDERED that receipt of the Treasurer's
Monthly Reconcliliation Report as of May 28, 1999, is ACKNOWLEDGED.
I hereby certify that this is a tyre and correct copy of
an action takers and entered on the minutes ofthe
Board of Sunervisors or.the date shown.
Attested:
Phil Batchelor, Jerk of the Board
of Supervisors a Countyinlstrator
n � �l
By:
Deputy Clerk
CONTRA COSTA COUNTY
TREASURER-TAX COLLECTOR
625 COURT STREET, ROOM 100-102
MARTINEZ, CA 94653-0063
PA: July 20, 1999
TO: Phil Batchelor, County Administrator
trator
FROM: William J. Pollacek, Treasurer-Tax Collector
SUBJECT: TREASURER'S MONTHLY 1 ECONCI IATIO
REPORT AS OF MAY 28, 1999
Submitted Derain is the Treasurer's Reconciliation Report as requested by the 1992
Audit Management L tt r of December 30, 1992, from KPMG Peat Mari,vic ,
Attached are two exhibits; the Treasurer's internal cash and investments report (Exhibit
11; and, the Auditor's Treasurer's Control Fund General Ledger Report (Exhibit 2). A
reconciliation page with explanations of the differences between the two reports is also
Attachment
cc: Jack Cooper, Internal *edit
mydoc1>rsasurerd
recon iat onreptpb.doc
S
Reconciliation Report as of May 28,1999
EXHIBIT 1 EXHIBIT 2
TREASURER'S OFFICE AUDITOR'S REPORT
INTERNAL REPORT TREASURER'S CONTROL
ACCOUNT CASH ON HAND FUND GENERAL LEDGER DIFFERENCE
Cash On Hann Bank
0002 $62,974,664,49 $65,133,708.95 d$2,159,044,46(y}
Retirement Investments
0€105 52,616,711,702.79 $2,616,711,702.79 $0,00
District Investments
0015 $660,144,943.42 $776,316,94142 -$116,172,000.00(2)
County Investments
0025 $517,586,595.0€3 $401,414,595.00 $11.6,172,000,00(2)
Trust Accounts
0031. $104,657,27€3.93 $102,500,270.93 $2,157,000.00(�}
Bank Settlement
0€335 $0.00 6$529,545.42 $529,595.42(�}
Totals $3,962,07.5,176063 $3,961,547,625.67 $527,55€3.96
Explanation of Differences
1. The difference of$2,159,044.46 in Account 0002 indicates that Treasurer Journals numbered 1447 and 1452
rejected. Those journals were subsequently corrected and resubmitted. (Journal copies attacked)
2. The differences of$116,172,000.00 in Account 0015 and 0025 are of the County Tax Revenue Anticipation:
Nate pledge fund, Though the borrowings are in effect a County investment,the pledge fund for the repayment
is assigned the District fund nurnber of 1015 to fully encumber and isolate the legally required pledged monies
in the formal accounting records of the County.
3. The difference of$2,157,000.00 in Account 0031 indicates that Treasurer Journals numbered 1447 and ?462
resected, Those journals were subsequently corrected and resubmitted. (Journal copies attached)
4. Account 0035 shows a beginning balance of$3,689,022.'6 in the Treasurers Control Fund General Ledger plus
a debit of$3,370.8` and a credit of$4,221,988.39 which includes Treasure.Journals numbered 1450, 1457,and
1465. The$529,595.42 represents the difference between the Auditor's office Redeemed Warrant System and
the banks redeemed records. (Journal copies and copy of the'Treasurers Control Fund General Ledger attached)
CONTRA COSTA COUNTY
05/28/99
NEW BALANCE
CASH-VAULT&DRAWERS 178,142.05
CHECKS,ETC 1,354,026.40
LN€43N-REGENCY BILLS 138,661.86
WEB-ACCT 1312351 25,442,348.00
CASE IN BANKS 35,86€,436.x:5
***CASH ON HAND*** 62,974,664.49
TRUST-C.€3'S 0.00
TRUST a NEC(D.C.D. 6,012,000.00
TRUST-COMIL NANE€8 34,472,000.00
TRUST-REN£D 0.00
TRUST-€KR'S ACCEPT 0.00
TRUST-U.S.GOVT 60,400,000.00
TRUST-L.A.1.F.TJ#1462 3,635,892.50
TRUST.OTHER(TAX GUAR&MT°N 5169&8171) 137,378.43
"**TRUST ACCOUNTS***8000 104,657,270.93
RET.ASSN._REPO sic L.S.Govt 10,957,000.00
RET.ASSN.- REAL ESTATE 159,036,253,56
RET.ASSN.-ALTERNATIVE INV 32,080,46&71
RET.ASSN.-BONDS €,072,477,713.79
R.T.ASSN.-€€,€DGS.T.$#1465 32,321.30
RET.A SSM-STKS €,342,127,748.43
***RET.ASSN.INVEST***8401 2,616,711,702.79
DIST-C.D.'S 1,540,000.00
DIST-NEGt3.C.D.'S 1,000,000.00
DIST-COM_ 'L PAPER 19,924,000.00
DIST-ACALANES LSD 26,048,908.71
DIST-MT iDIABLO USD 0>00
DIST-BRENTWOOD USD 2,9199551.6€
DIST-CCC COE 6,362,679.56
DIST-JOHN SWETT USD 2,454,264.05
DIST-MARTINEZ USD 0§00
DIST-OAKLEY LESbD 2,949,315.19
DIST-PITTSBURG€S D 4,020,902.61
DIST-WEST CTY USD 20,000,000.00
DIST-LAFAYETTE SCHOOL DIST-CIC 10,750,261.91
DIST-BKR'S ACCENT. 0.00
DIST-REPO 0.00
DIST-L.S.GOVT 114,717,000.00
DIST-1,.A.€.E.TJ#€463 417,1139438.41
DIST-IFE1D TERM NOTE 12,230,000,00
DIST-OTHER&MUNI BOND €89054,641,37
***DISTRICT TOTAL"*1000-7999 660,144,943.42
COUNTY-C.D.'S 0.00
COUNTY-BOA Asset Mgxnt 25,000,000.00
COUNTY-NEGO.C.D.'S 105,300,000.00
COUNTY-COM'L PAPER 55,266,000m
COUNTY-BKR'S ACCENT 0.00
COUNTY-L.S.GOVT 58,175,000:40
COUNTY.REPO 2519103,000.00
COUNTY-€,.Al.1+.TJ# 1464 14,742,595.00
COUNTY-OT€'dER 0.00
***COUNTY LNTVEST***8177 517,586,595.00
***TOT'A€.ACCOUNTABILITY"* 3,962,075,176.63
05/25094
F77 1--::
- �...1.
- I
...ll-- --:�:
. ''. - �
- -.. - ''..
. . 1-1 ... I
t�l " ---: i
-.. 1.
1.1-1-- ...........
.. . ' ' .
...--.'�'. � :50:
... .....
I-I.I.-I
. -. -
.......I.- �M'��P
["..�.-�. -.��...
1-1-.1- :,V.:":::
rI...� ....... .
....... . -9-:��N'
��.. .... : .-.��...............: GGA �sGc"�: cs mac . r.�G�Gc� r,� G . :.::
I..'-�'. - : fi€fE€ •Casts.L+t £Yx:? rS�$ ����:, �GG `w� GCCi`�GS G G - ..-�...,--
?s �� ssesst eaaotsa�sr:: Visas r» 1 £ €� �,€e� Fsy r� -1.a '#
s CS .4. . �r3 $`?$a�t t sn3�g tmrss k e
- -- . 0>0 V'Y'r*-•su.'« CSs�d�^�:. 39"i+.....:�-;®� �ad8 -1.u�wbr+J;4. --S �=*. 'e�- m!`> > dmf
.� ... -:...: :':.`Ef; G E?k .� � �G :J^"•.f .,: `43�; ...2 ^add tyi 'Z/D .....�...-:.i
'._ Cf�'SZ " �� : � C3 s ?''o' a'�i"� Cv"t ro G Gri` -_.-_
:.: !;w c t [M"nf"-4 F zzm:: S 3 3 t`r: F arg "r3 .�`�t`f°, P+"PY '{S.; '{4`a, F ,.W :
Y 111t�c :s= �t � r rnm t rot-m 0- rt-ir ��—M--ir?°-
_-_ �'- - G£d'S 4 YESSr�m# .4 0-4--i ::;-O'T3t�s'°-m—i gt'�tfitl.�3tm.4 SzSE'r.C*""1-4nf,�fX 4d" qw -=
:::: # 33
•I. e Ems§ 9^Fk�i,: `... tgi z dt "§C _J�.. Qisro d pi m
f
-#� { .:; .
0,
.. ':: ts. ,-[— tm6e, 6.,° � t��, ,G G.eC,a;m�✓.�,C�c"S4b.� C,yia,
:: :. } •-_+ "i : es -uays:...:.•,a mei -- �r.-...�mr.na�a,a.�.}w.t.�,,...f':: '
--V.Eik V. akak%n - Cel : tN CAC:hC"x '[ itY.CA",S;l,fi�7rL Vii,:' S
Wt w WeX '�3 w :sG' Ct 'stat .
; -<' '." ; G s�P£? t' G s C� G� Gt�Ge�t i S C t,`
,
.:
i - .. ! W:. r b e d e
e
a "til bd -. �a as -a CO ra --ts: -; >X tk :
f. .. G G '.: \°4 3s Js: Yu ca i?a @� tae .
V.. 2:"t Cht w1. 1. "1. a9 £!� ^M.t "i LT' 1 . 4T. -; { -:
i :. -. .` b
6a+ : _:
f �., _. ' 4a: . .' ...;. .:; C G Cit 0.- :.
> : C9 CJS t C�3 d, OC, ^aC �3 f1; f + *0 L'.G9 r O
C5G LJ �' -: GGG '• '- :G Cxd - 4d.G._.d �Y. ..
H C?G GGG G : sCC-+ d -4
x G M C C0 0! 4 o-S : €d5
. . o a . . . e . y y :� . . -fw a > -
cs Goo C) 0 � b.a0 :�ate.
GCJ . . 1.G GGG � :::G G M CGCt ::00' #�:
- > :-.
�3
%
Cs
f ;:..: mo- -a ':' 1. f�7 m,; -::
^�ar w E �# . �..:. v s
' ? a v 4��
kSS 'a�EA. , -40 'KFS - a0 Vow : -� 'p .:!
o :� 0098 ..€si - 0050 ,a- �.,GG8:
r .. --i- - . :�e: G5' i�.. .a ..'C 1'FsGG .. ..j
"aax ':: 0.0. 'tee -�G _:i?. —GG'c�: ,fid 4
4 .: .y � - � . - - . .
tam' �. .. o •po GGf� w
'
. ..: .. ...- 0';=::i>. Lei ,mow GG. .:.:,�, L.GG ::.. ...t"'' :::-?
<.
i
. - :.X:::..
I e
t .: [% ''1.1 1 toy "' Ca: m,� na
G �s::: wb CzY
G : C% Ta W n
G
'. . q G
"�
ei7 �' �,
t . : r -.
i '" '*- * I—."'""*"" - I � : '::::::*::'--:�::�-.�: ,, I.... xn'':
C
{
t :: - '�^ G
-- --• ' C5, ,�pq
y :
zI. M. �
lb...--�I���1. --j.::.'::::'�. ::'::l
[ '. �_ .
x =' a
%
1'4-
:: > �.::� ,,.,
E ;a
r +' woCs�sis ��C3CssS ub :�ac� �t�9�'sescc oosGsrc7
Sf' +. C' AC3 ® ft�cea dam ::tr5zesussr�cw raF ds C>aar�ta..SfsGtaSra,.asf�zt�s w �g,i :-=:,
+ ' SSC��Cit`3`�s,}E' �S7 Y0000� - 1.
i,J't vl;.n 7- ,'.::l,5?&3'tVOIAs IM719,�f1�,."'?r3S I" tai G.{- '{:..
ats :
'3 f�tf+f lfTf4i tq3 tf 4?f�F�94Pf :> >>>M. fti�€fnr�fst Tai x
"
cs� � e� � 0 ===a =Odom 0s b M '�z:
. x � �ce �v
>; `YS � w"'�x �:.i : ffi - f'�°€'�'iftY� Ck � '1 at X315+
i a` � k33� ,r"..,a' _. .r'�..�X x;o .£'S Yd3-3-i-,,= w' w.w. =�;O;U;2�wv.�9 � fm M° - >.
.9
�-T- l"-M,>�t-n-","M-q,3i"�3 Pf"sf°xs rs-s"t *i - -w: -- 'si ss-t*3 f'��*st 3
P??"!!i'sFo^torF`r".'•T �'F"Y"i".i"yR"yE�t`aC`yt�'-,.i'7°s`rf .I)r,m?r,lrr 4t�sF�at`;•"`pt`yt"7.�.`P9`rt'g'S'�k''`"yR ^f"��', �£ -E
': i t5"g3'RS'.1 --n- r.'1-ss".^d"�S'Qt''Mfl �t.�i` `ot.�4. _4 :C>�S--i al^e,..n,. g3". `g5'°t,�"..A�.'.13'44'"S`Q°'gY`� �3 I
t!. y�� iL�Ti� w�i t.�. 6:+��0 ! �d /�p� .w�6s� � p4pa,..t /� �
r ?Kb°�b' L.!C�'..ILY��LXf£ N^`"^4 , �C��wD CSB .++a ..`9i W.:- "idYWC72 C`�9Q��.Y'^i W-0^:L
#_ ..3�C S f3�tO L`Jiat.. .QStrr 6ls��Jtra ; .C� 4'��ww'dwCa worn iXmow . co
.6;,XM4-+�3Fti�,m- m,--W-'�,") :°.'�CO�JI.'10%ro .: 43' a# �iS:+s£A34.8aiJ e�.+;5 7r.-'140''..n ...¢ .t
1Cs���7G7 s� ? 5 tat��9t� f� �C �S+ k?A 7�t��J i 0000 �
.� s �ca� � � �c7000 c3�?����1.esca�ac 3���srs�rs
§ �3. 'i�' 7 '�`'is �^a"�s #...t^e#�w� ' .. .Z73�u:Aiaw� 1:«�S 'V
.: � 5 �e`t'�?C�OC�C?`34'� 3 3C7 :GYc�0 ---OtYktoc 40000 X0000 0 ..+rte'
VttS:t,S4�T'11t' `.=t3s13•LTtt3,tSslSiig331SSr`^..,itf�34tF#'L.tt37t,9� 6;. f '
pa7£t3f}1ft3fV:VN?Vft.. itckdtSFV,h3.'V.'ft7flSro3 - : G"4t15,nN),'RC2>t"'F`.2S3R?Nt�:f0) ,V�K?W.YJN `rt
# € =t aid-wdat�,e1��+ is .C�cot +3-w-tgi�ttssce �+ ti�as �.
� c+�wtc3tctavc� utatc:tca e»ei�o +aria �atutiaO
Ln
,Y ,*:?� =:
,}' f g
9
a :.p - V''
C. .
Mo :�
^`e :t3t M': _t
a �£
. 0 �."
C: d
;:��sfv
� vzx� ex vase V-,
st s 4;4\00 its._ ra <c„
f?S
I ...t —4F- 6�: .'2twk .-sr ixCO.�;V :'c3Y -::+.t � -tatI. `._
;::; - .4: >.: $'t' t WrrtLtt�e -:�h :-°ti -"FM14,V tstEV.C' - °,
... �., ti,##G5 Pt5��45 -'d6.:'� Co 0.'.�t..{R'emo Gt46,�`7
>::r r o s y: . r a:.e o r <
L A
C} -:
..
,... . ?
�: <
_. e
:. SadLra�»S:'sfl2 bn -:t%� dd % ao&GWW. I4a% -i
k 8 a itxi,-tie e a.. LSa .� �c9 0t014�€s9K�*y�f�e
...
:„.. �
r am. '� C7
iaf 1. :':
t. b
<e
1.
Ch L « v+
z
,:;.
i1. .}D. p� pb /eOq p��, pV�
'. y���3 �'I �] pV�ys ,1o1-}i tid STpry Fyr••✓� .I,,/y;'� : ' L.'.
i 4 Yom° w.�.f V i 2✓ S°� Sl 1 6../ n_.: : '.: . ,I tr t
,1. tvV
} �d� �.J ` '+rteZ :.
B Y. 6 a 90a� po. d �0 : %1. , .„
) 11114
I 4 4d V+��,gTc, b -
yy r
{ �!
Jy/
/ � �V411 - + .
s
�,
_:::
g}g��y
....................................................... ..
..................................................................................................................................................................................................................................................................................... ..... ...
........._. ....._.........._........ ........... .........._...._.__.._.. ......... .....''I' .........._....... ......... ......... ......... ......... ......... ......... ......... ......... .........I
G
` : C
coca
.(
.
:.
O;:.
��, �
®O� � Wit;
., i �+�� m
cr
� � � �'
e �s ��a
M � .
�c z : �:.
—j�.?:::
M
i
�--i ��-, -�� -�
4�r� �� c:� c� 0
;v474n
0000 0 c Gs
i . 4. '
M OY
. $
': 3
z—,:,:::O:::::—
C; =
^".« ;4
W
I , a �` E5 #
f - N 0 O
. ... :... ...'.':.:. ... b
I ::�:•::.-.....:b .:::::.Z:-,,-.'
4 1. I ;;`..8 {
f {q y� '�1
,.
-: :::-> :, .. :::.:
I
-;:: :jI. `
I.
i .:;
. .:
... .-: .ten
1.
{, >: _ ..
{
„_
.
C M:::.
}
:
,
' ..
.
I:_ .: r
.l .... 1. ,t . :
.
I 1.
i .
`�`:
y1. � ::
E1. ` < : -11, .,.
...
.
eea
v^ CO >s c, (A 4b. cam: ;,j
pt It It IV It IV m 110 It
a3 r° Olt _ i #
# a :cam ➢cam '�a: c i � a
tj Cc
i �, C8? 'eat '�'2 ZJ5 :F2 •C6� �S 6� s i�: > C,�2 � ,� #� �..�
iz zm
co P.
sus .m,
Kia x
ty y a n e CA) pry
i w cs 0
s '
L - _ e _ s to -.a
�46 00
; a # 3 ?T:
s ( � *,A i W
110
,
..
,
t
s
°C�^ pa��p � � '"'� �"�e ` � � .`_3 y T•� ��6 Sm^ etl S � Pte' 7
# 1 s of 11 1113 a to 1 91
9 '
Is Is
s E # r
' S S
VIA S CA CA
2a 7CCA
i
LA
E -21
RR
00
b
'
S � ; # � �•., ems+
{i 3 6n
�, s 6 9 Es
pp � ON
E & 00 i
�sy ? 2:51
s
,
Imo —0 ITT'l
:
0 i Ch c3
<
m ss
qt Flo
H-
IOU!
-44 ziz
4111Z '
i t <
ril. tE g
z
In rn
0 C� cn
i z
• ; i
(D CD ur 2a Et ;
s i a ico 4
✓o
rIn
.
a a
at
•
s '
s
;
s
� s
cn to
s
:
#
3
i
�4 Hu 3� E
r
,r
d
44
IJ
zi
m i f T`3 t i
La
rr
0 o
A 3
0
4 }
E
: S
S : i C-) C)
4 E o a
r � �
7i
.wqy
,
rr,,
:
C 4 :
} ;
} LIN
; .
di
{
r 4 Qq
c f
:
3 r
' f
ON St7 9
3
t; of m 3
:
co
a
;
r '
'
c : '
t tca fi.
9 B ° eo is
r ;
6 �
r
,
r €
,4 z
c
' CiSrn0cn
f
cnrn
�
co
31
r 3
Pea �
fA
3
i
s
r � 3
:
!cn
}
o
M
i
e s °
n.
^
'
#
i •�"i
,
. r
x � '
(d i
5
s
r 7,
a •
' e
s '
6 , r
C
E i cn
' #
co
Y
6OD
les�
a ;
i ; t '
r ^
a t ,
° # r #E
_ E
c na^
a r
Nl�
•
t
^ r i
-
r
s
• r
a