Loading...
HomeMy WebLinkAboutMINUTES - 01152002 - C.92 TO: BOARD OF SUPERVISORS Contra FROM: John Sweeten, County Administrator Costa County DATE: January 15, 20102 SUBJECT: TREASURER'S MONTHLY RECONCILIATION REPORT Specific Request(s) or Recommendation(s) & Background &Justification Recommendation: Acknowledge the receipt of the Treasurer's Reconciliation Deport as of November 30, 2001, as requested by the 1992 Audit Management Letter of December 30, 1992 from KPMG Peat Markwick. Continued on Attachment:_YES Signature: Recommendation of County Administrator Recommendation of Board Committee ,..-� Approve Other Signature(s): Action of Bo d n:January2�A roved as Recommended XX Other Vote of Supervisors: I HEREBY CERTIFY THAT THIS IS A TRUE AND CORRECT COPY OF AN ACTION TAKEN � x Unanimous(Absent Nn�) AND ENTERED ON THE MINUTES OF THE Ayes: Noes: BOARD OF SUPERVISORS ON DATE SHOWN. Absent: Abstain: Contact: Tony Enea(335-1094) Attested: January 15, 20012 cc: Treasurer-Tax Collector John Sweeten, Clerk of the Board of Supervisors and.County,Administrator By: `` w,t, DEPUTY CONTRA COSTA COUNTY TREASURER-TAX COLLECTOR 625 COURT STREET, ROOM 100-102 MARTINEZ, CA 94653-0053 DATE: (december 17, 2001 TO: John Sweeten, County Administrator FROM: William J. Pollacek, Treasurer-Tax Collector .SUBJECT: TREASURER'S MONTHLY RECONCILIATIO REPORT AS OF NOVEMBER 30, 2001. Submitted herein is the Treasurer's Reconciliation Report as requested by the 1992 Audit Management Letter of december 30, 1992, from KPMG Peat Marwick. Attached are two exhibits: the Treasurer's internal cash and investments report (Exhibit 1); 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 included. WJP:CVJ:beb Attachments cc: Jack. Cooper, Internal Audit $4 Kjt4n t ,,s a ;: Reconciliation Deport as of November 30, 2001 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 Hanoi/In Bank 0002 $77,838,631.02 $77,838,631.02 $0.00 Retirement Investments 0005 $2,766,101,238.13 $2,766,101,238.13 $0.00 District Investments 0015 $593,851,363.45 $593,851,363.45 $0.00 County Investments 0025 $467,632,516.28 $467,632,516.28 $0.00 Trust Investments 0031 $124,158,802.07 $124,158,802.07 $0.00 Bank Settlement 0035 $50.00 $24,885.62 -$24,885.62 ts) Totals $4,029,582,550.95 $4,029,607,436.57 -$24,885.62 Explanation of Differences: 1. Account 0035 shows a beginning balance of$28,391.55 in the Treasurer's Control Fund General Ledger plus a debit of$160,219.73 less a credit of$163,725.66, which includes 'Treasurer Journal number(s)062900, 063600 & 064300. The $24,885.62 represents the difference between the Auditor's office Redeemed Warrant System and the banks redeemed records. (Journal copies and copy of the Treasurer's Control Fund General Ledger attached) CONTRA COSTA COUNTY Exhibit 1 11130101 NEW BALANCE CASH-VAULT&DRAWERS 241,878.15 CHECKS,ETC 9,479,986.82 UNION-REGENCY HILLS 0.00 WFB-ACCT 1312351 25,224,551.00 CASH IN BANKS 42,8921215.05 ***CASH ON HAND*** 77,838,631.02 TRUST-C.D.'S 0.00 TRUST-NEGO.C.D. 2,258,000.00 TRUST-COM'L PAPER 10,056,000.00 TRUST-REPO 0.00 TRUST-BKR'S ACCEPT 0.00 TRUST-U.S.GOVT 109,654,000.00 TRUST-L.A.I.F.TJ#0645 1,929,417.60 TRUST-OTHER(TAX GUARR.&SSI CHILDREN) 261,384.47 ***TRUST ACCOUNTS***8000 124,1:58,802.07 RET.ASSN.-C.D.'S 199,138.42 RET.ASSN.-NEGO.C.D.'S 0.00 RET.ASSN.-REAL ESTATE 135,592,455.07 RET.ASSN.-ALTERNATIVE INV 57,771,385.24 RET.ASSN.-BONDS 1,160,050,145.96 RET.ASSN.-REPO TJ# 3,261,000.00 RET.ASSN.-STKS 1,409,227,113.44 ***RET.ASSN.INVEST***8901 2,766,101,238.13 DIST-C.D.'S 1,540,000.00 DIST-NEGO.C.D.'S 26,336,000.00 DIST-COWL PAPER 29,578,000.00 DIST-ACALANES USD 23,900,000.00 DIST-MT DIABLO USD-GIC 0.00 DIST-BRENTWOOD USD 0.00 DIST-CCC COE 0.00 DIST-JOHN SWETT USD 0.00 DIST-ANTIOCH USD GIC 0.00 DIST-OAKLEY UESD 0.00 DIST-PITTSBURG USD 0.00 DIST-WEST CTY USD-GIC 19,900,000.00 DIST-LAFAYETTE SCHOOL DIST-GIC 0.00 DIST-LIBERTY UHSD-GIC 0.00 DIST-MARTINEZ USD-GIC 0.00 DIST-WALNUT CREEK SD-GIC 0.00 DIST-BKR'S ACCEPT. 0.00 DIST-REPO 0.00 DIST-U.S.GOVT 84,372,000.00 DIST-L.A.I.F.TJ 9 0646 378,985,778.65 DIST-MED TERM NOTE 14,360,000.00 DIST-OTHER&MUNI BOND-CAMP 14,879,584.80 ***DISTRICT TOTAL***1000-7919 593,851,363.45 COUNTY-C.D.'S 0.00 COUNTY BOA Asset Mgmt 25,244,286.00 COUNTY-NEGO.C.D.'S 15,450,000.00 COUNTY-COM'L PAPER 40,000,000.00 COUNTY-BKR'S ACCEPT 0.00 COUNTY-U.S.GOVT 18,424,000.00 COUNTY-REPO 288,739,000.00 COUNTY-L.A.I.F.TJ 9 0647 79,775,230.28 COUNTY-L.A.I.F.Portion Pledged to Fund 1015 0.00 ***COUNTY INVEST***8177 467,632,516.28 ***TOTAL ACCOUNTABILITY"* 41029,582,550.95 ..: ::: .. -::: :. . . . . .. 6Y r :: 4 «•:<a :.;::sit =:`< < :...::.: »: :; :>:... .. ..: sI I. I—I.. �» :>< "� , . ,: :> T M 3 <k�::.<r _ _ :i:::::M - M : 7}}:::.... X ::: >:@x>::.: . . . . ...::::. �.+R CO ..;W - • :',>..:M::..; Od .`;'ST.:;:, C7 CD Lata C3 O £7fii- t'. :is :: :;;.ii:i.:-i :-:� . i.: .':`.:: iC1CJt7 Stt"r::`::... ' �"t :ti:::.i.::i: C•1 0 .:�::: �::::. ::-i::::.�:.;.: ....:}:�is-:..�:: '>-'. # h -u•�y T yw :::i:.... /y� p a� •A ♦p.� rr ::i:..' .�j,p�� iii4!i-:::;:::::: fi �yy� .�+ p T Y �;::�: Q :' T T n� C�M•':'::::::::: •: :::: :::: ::::;z:::.".•::::. :I ..... �.''_wA. '::::.mayy:yy-::::y,. :-.�.iy:•:��"yy-.,-:: � :�:y....:•:::.yy:�#:....+r. --:•:_::::::.. ./ yy :':•:i�.U% Mw�' #./.::*I'T*'o (�.LC) .:•.:iV.S+i.'::•:::::� W .:.:.;-:•1i.: W ... :-.'.":::: :::+r L-;:S>:°:-:T Com'-::'::;.p.�:'>::0 0—,.,.:+'z'::::::;:4:;: :.::�.�.-:�.. ..............�,y�� ,.,{{,,, yA ::::.::y� :....::::::t'r"t�'5:::.::C3 fhCO; ':Sp'S- ....9!!G� :i: `.i..:, ...:M,{.;?�4;: _.•....-._..ii}T' .. ...... ' .�. Y.:iv ::.::.:4.:is % fi # '::.1::::::::.: :..:...�.:..... ...............::j:•;N �L} J((y��-c�"fi::::-.T,'!U'l L{5M 0� Ci�S`.+E::;j:is-:A•5::::LT u -:: ::' #�� �q �µ� ...:•;:v:::W .... Yom!•:: ::: y�,� �yy _.:........... .......-.. :: :::::.:.' :. :' h 4� �{ :':y .. .............. V T : ::':. 00 Lti Lft TH:;.h+- Kt :tl £X7 ttt :: a. c� +tea T 1*Y co :y^ *^ Q r a L1 ..G� c tax �� do , *-:;':*.�: k..:.>...:::..:• :?it} tt t s=.ah7+."... 0% �:r:;-.;:::"t::; ::: C� . "R=:;EC3 Cti'.i:Yia.::>,:..:. S. ry• �y yY�h T :':-:..!:::•:::':-:: :x;:56: ::• :::-•: •.• :;.: -->: - ::;i;i::i : .... :•:. ::f)C 7 L OO:[:: rt0.10 .- .:.%:..:-::. . :...:... C3tG3cc'�C30CSCL+>iiC3:C+CGSCiC7 ;?:GS:;::::: G1 C7 it .000 ;::G3:; t3 >: ::';:t �...ttM uI�CSh•C4�...+?- .U'L N ::ik1::::->:::. MMM MM :: :•:•:•: ::sir. 3<k7tYaY+itketntrtMMc+Ytka ..�' # ::d> 1. '>34'W .6.3.O y 3it1�£3�OV ,ay. QtiC3 W 45 W}t3..':>:::.::... .::r t�igi }� O5::::>;:.: :;.: t Cf7G� CSC3d ::::C':`:2'::::. CSCSCgYCi:::::::;:;?DC7 CL ;; tL" C3 G3 t �yc : ::.: :::. k-# ki%':.-+-- ;4:1�:•:•::•:;•;.:'7i�-i-hF-is::::>:,.,'!;" f-M3„>i:>'>i:i st r ;: i ari%:i'i::'::.... :;: ::: ::::r ,.-.-::::-.:. . :. Z t :;>;::::.... ::ia�` L?1 'z:::;:X cxt ::>..:#3'�. Fa <:Si'2;:N+' i:i: .:.:0 S,i .:... T i:: J-::::.::.:..:.... .�:}. ::: ti✓' .. .tii..::::::y':::: :::,':::..8. u�1[[Y...:::.1:tW.• t"' 15r•:::'::: :.. z �_ f::.:i`:':�ti._OZ.Z ('.T: '::� :.'.':. ..,_. ::.'_-I :::+:'it.. Z;4}"i�d'4'#�= :EsYLL2 F' � #:. iss3—aTiw it3k!!Y`$'i• L'Lflu[LStW Wi .;':...^"�+. ';::; '+`,::'.':;:.•. .::•: y�am.+c JLJ y�uy�.. G.._twt���@gw. '1—rg. �, y�wag��.WW .�} }� {� : y_ ': T'^ _Z_ !_tM= �2+t�'s.'I'�ML.Tr�n�. .' IF VPw+IPw.wR.iG. tFI 1yF.�j�r�y (_F'n"�.}5 r {$ f#� t�3 �-Wtta i Wvmo oxo c�v>snencn� v WW o. zea» lawP '__X��•.' •t'-�M:�,r►-t� �tk- t- r utwww� �rx�--�-cs � � 4'f"F, 3siiL" Q„' `wSiii7,"'C7t1'f.',`,.2'1cJ �C•3,tf3S,3Cll ."14l t '"i[3�f! iLf .` ',"P.'Z }""Si1Si3 f h`Cl>tJ3 1 3R1._. . ,. u = Cl.1ilfY.i # .—>J{alW:*. 47-->to w `.►��� #t?:�^J+CI W6ct iEi i s-: {.: 3W d Q#?;:: i3 F-�F- +.#,k f+ ::."Gh wt1Y 3� q. ?+ttII}-f-M^F-fA.: :::;' C> . .f ftit;;is: iu+ e. DGS-- :4i*..'W).. ;; - ?'":; *l. ._.<:':>:r;ti�fL+ C� N� :: <•: :::•:::-_..::,.::::::W".,. W O «C#�€33{'#- :GL?U53+•Zl '�G7�LtSt-.= c±G.i-!=h-l� ��"� VSVSt#f V#<' isi ^ iL,i� 3fStA .cL xIY" `t-;7�1S: V3 tC� y xu�vl-- - ==; i-� �7 - £L13#` * t <tWtL' #3# £s1s�"—C? *ik1 E=+d- `td3 ttti7C ::; e U)1 0 ). nQ tt�Cdt�3�L { d}t4 i-C1K3 l L¢C3L7i�G1L3 # } F-k . W C} : 3- #3 sC JT', TT �'eV\v RvlV {U{V L31fWi,�?4'�d�Y\4\VNKU LVS21 til"51i 1ilwiLil}it' I9•'1.lT�s'w\ T"T T!!'°'fi`"` -y�.4 t'C .S'.G} C:'CC3a"aY.C:J 'SCSG7C`JJCC7 t^�$'w"'�.YC:3G]C74`5 t*+rTr-Tr-# �,'�itSfl�fN Mr+7M;te¢!�'S "1 - . Mi #J'z i- CsfJ 't 2 7G7L") S808 lg'0 ?l300 0, � �Cat7GSCSC�''�.:)tti:M.o C?r•SCl�St7 � : - -4$:: X o 0C Pt ;'e4`iC?noOG7G� 4 �R0000 t"�t3G.3,:::4 �OC7C5L,' ..;.fi?i ?G7 C+C7Ci;d4" +"t .: - 0 .-. :': :«: s: :;:>:ca >r: ; , >: < . .. t- >s ::::>:::<::: `: » << _-'' .,. :: >: :: ::. :: '::::: :`:*::>: •s::>:...::.> <:: :..:-: : ::�:::::::,,.-, S' • • « -. : `. iz : : I» : . :• ::: ::: i- : : : .at »W: : : _ ;. W s»... r& �.:` : :: .:: : ~ . v - + t: c ::>,w • ''- n >:-a:=::. .. <;s C a >:X , zs>::;;: :>s::::: s .ca 5 x ti t >: c7 N:;:;:;:::>:»>:::::: r :xw a ;::; ::. i by N L y .. - ,,. `�y �y p V .. - :: - - 0 m WV k,0 i .:•.'::• yy 4 1 t- tCS�SCS i :::'::-:':':::':::::.:: :::•:n,5+.:':::-:: iii. .:•y^�T.:::::::.:' yy,Y.�� ,meq wl�y...w� Chu ttri�0:^::L'T.:: :::::':r �!T V 6xtY. SM +rtV W N ::��:-::' p :':• 0 a C71iO a , :::i!.#::; Yom::_:::::.::::::;i:�:: -:•::•::Y 'r`' .1 f�,Na,0.Y"'. j`.-,.-Z'::�'!�-` 0 c2 :::?:::«:; T030JN:::':3.�1�::2:. X;. C7.- k W by *1 .y V ,y. : I 1- 1�.�nmt-:":'t",: :: :::� Yr��o .+W'f4t {: r.moi 7 -Y,'ii:^N:.,., :';} <T % )1" :cid:::>;:::...,.. ..:Cf., :::.'.. -, ' -::::-M l:5i is ' ST is�::: < 5: N �0:: ?::2::_:::. f:i.. 1.....-. --.. V : -: : ' - •' - - � : K µy��Oi :-:t:•:':i - ::-: :$>ii >f A\ 0SCVC 1dJ�1'1T�i:f:::: f} - C ::�::iiii}:-: ,;?Rf :,,{�TT��+}}. �::i:::3�`;:ii: ..:-:.I:::::r::. '::•:.•::..:,: :. ....::::::::::: Y :'::tv.*.N N%::` : 4G:i:Aii O:i:-.`,-<:=:c::: ;: ;;:;fw i#3 i? 1 :>x:N N ...if1.. . :: .. :: Yi:':' :` ::--..I :::. ::::. :. :..`, ::::. :::::::::,- r ....:t::i:::i:2 _ - :ti'::;:^:::-:is ��y ;:<:-h :.:::•H!•::::::: - ::::j!i!':':'i::-i:': ..:..:.......... -::::,4C�::•?::: ;: .,. . ub CG:•:<Cf f:: aX::`>: u13: :: ;: W :: G tJ :r-i:i k :fl.- ... ;>:-is:•:::;- : ::: :::::: :.:<--:.:_ X. •:;->:•: :'::->: ''t::=ter:.:;:.,r �* $5 ... 4 17r...._.. .. .. J kI1.::±t3.. . .._:.......:::. .---:.,. -... ::•i??ad::::::: iii?::::•??.: :: ::::{:.:::is Y::.:..,..... ..., I...?$i7a:::.. {lS:.>; :T,..Y: _ =::: :?" [^ :::t:i`d"v' ::.i% _ :i?:•a:::i:': 'C': . ::CS'+i'r:::?:: - - :2:v:#i.:'r:2:: i: . ::?:W::::?1?: 1.>6:<, ::':::'::; - - - i""r i"'x r�,. .# . TrT ....vrS:�:'ii:7: :.�:::.»: <•z: Yi-�r+.rrar..wrrr-r--..i.... ;.'t^:rG�t�C> ;t=`i:i>i:i;i i::CS ....:..::CJ:t'J is i%is>:::::>: oaf. t LC?C}C? .:::»::'':';:::OC?OC3C1.- i^��y�SOOt C3C7 7 5fi�; W. ::':::';>...;:; :`5::;>:.'.: n OM U- COO M 0OS�fn ::: :::..::> M>ODVDp"J X47 ChC:�1ChMOC ..'.- . . i.7Min"" ":...:;,.;^iia l- Nim„ .. LtltlfhtLVNx�gtkt�arFtN�s ;: d7NNNNLhiLytjstCUNtV ? - ,'': .1. . TYrr..r'r:wrYrrTrw.�r�+.t{y` - ::. ::::h W Z ..._....... :::::::._:. .::::::]::: Q: O N+++.9?+s+:M#torrrrrta;#, }ett.#..!?�!r-G':1�?t�J :i?: ':�::< i::w'NrrT+ftat:t�.?:t�:;F.t:Tw-�rTT+a.;rEt�ritLry3� :•:::::.':::,:�:. or:- >: {J3 t. .: 7 i iG' GG tLCLt"tLtC Qo. . . is >>.2:eiA» 4" streGtt4iR;o� W. ± ............ r G} OC3 r CS t7 i;5 ,�r� {� I 88C}CJ `: GC7 OOf3 -> O 0 --�� Gt 0 ;:: OC70 : 07p Cii�J ...... °ia.'•: i+!44[p 4QU1Chi'"!`'� i7i ::t.'y fi�dOt�N.. �7x r::i:>''>><fr'° h`^^a7Cii' £ai:k+t. :{,err»C°-KSflti ..,f;!!:N!'-"•.`4.+6::; >i i2:i:::[ :• ':::::•::..:•:::: tit �i �:.':: 5 X':#l,t$-". 3tS+ q�"SC �f!SCRNIX?C1h-;:;:;: :,;::.:;-: G}MC�� t,C13 t�ttt?LTCht7 = 5 ti:;:::CS1 3+^.e:' Q74'ilM3+�"Q 'R397' �1lNC7'>: JW', CiMM #tl;QkC�;EK�MpSChiC1.Q!'i+i�1Y�w;:;'"*.: ::: G?kstdCt. tDtt+ T`'we :::rLV dS9C3 : rR'':d�:dflC? "t"'CCJ�C9:4C?id';;:;:e d4 :.* ."C:4 4NMAC�tKYoocoCC3 ..:3 :d�ilk !F- i2 i5i:i#".::. :::::. »:::':> •:• :. Trr :: ::•:O :::::i;W 5:::C .. ::::47 4 L:13«btYYtatG3CSt � Y i" 4L3tt3 F-,,, :;' Z .' ."CZ'Sx'.�'w7."�',"�.',2..`�=ZW .Z::;:#::;:ta3::;.N .&"�wd��"rT. . 7.Z.Z"'� "#wt" ., --.. : ::::::::::::::t7 *" � 3e3c ::t ;:+ :;.`,r-� !:k rk � `�,,`�. <'::i>:>:-,-, .:::::::.::• %• p' :si: iaSi.ts.iLL.L�4i,.ii:Sf:isx�a.i�.�6s.��'6C�"1:>: 7 3-r .NGWL�k�..t}.ia. i»in.u_ts.ir.,i�u.§'a.i�uis.Sait� :0.. :.... .. :. la.ki fi.is::iin#i:4.L6Ltxli..WIi U.:i:}^'ia2 ::::::'S::::::Oc,4 F- Vitas:aiar li;x,...t�.L.U.t d. .LsJ -P-0::2�:Si ::=;;:::l++C?tx,la. <- <.;::r:»:•. o.:�::�.�>:., si u.tLu� : its ='�C>::3�::::::L�::;:F-Nt:.u.s6)4.1 .«t� s u.c+��, ezu fs is tt?i�m :::;?t f54 N4Sktti#i4i.u. 3sitrkt:3f. ::. ::::::.:: ......-, ... ............... :i::#ri<>;6i3� W "..:..-,«.:...�..,: ._ -�®..p...,:-ya W 15::: :-:;<r.w ......,.;«,:�-!- ,w:;.....-..x„-.x., .�.�tiSiii :+x->: ..;SSU e Y:i ti6�2�;t^`"tClG1�C��36:d2°Y'�?�t'-t�-5.,..1..3 ...:..,�:.::- ::,— L�C�L1?t��i�lt'��'1'�IGlm=ozmi".2.>, :.:•>:`fSL1Li II'.c (Y.CG�'ISCc+' iii M :i:->:': Uj SCC ' StrC(-I--h-t/):z:::C 5::;<::::.'Cfl iK f7w�'f:f� - x1W .J 594f47Cft�' 13 XWWW .:?.< :W '' tGi =I===, { :;;'iii -- c� is3 W r7� 33r 3 3 ,. t 3 c3' 3 ae ' v.C�r� 's�cacscac�r5 "' asc z � cs00m rx is rarac�r�a�r� ss z } t,s� �t � `+kifaiE# tkfWt+JwWWyg� pp # tiff i EiFWw. <<C d^ WiJw #i Sil wwtaJWi+t i#k fM W4 ^IYtLf tCCi'�t17 7r4'a rEL'mtf5tC] .::. .....zrx c��u s + .+ c c �c� sic c a c�-- i s� ::. O m t~ �u� , - t * n 0 0 u� aa0 MMM + na++sc ,cnrrrrsmsne+ smmnn ; 388 . oec ] �z 0 COCa000000,C370oli<x` �CO� 88aIR8 00000.3z < CMococe+1. ez c ::? .. cs .:. tt � ; 1 � yy O �S F � � � m c- �r r; rA c N ern C Z V-4 � Q e4 7 p W 6i+ r«{ Ltit Gs � 4 all C p i^ti CC77 OR tn �* Ln pw x tr1 r+ 12, � d � n ey" 01. TEL- f CONTRA COSTA COUNTY TREASURER-TAX COLLECTOR 625 COURT STREET, ROOM 100-102 MARTINEZ, CA 94553-0063 DATE: December 17, 200'1 TO: John Sweeten, County Administrator FROM: William J. Pollacek, Treasurer-Tax Collector SUBJECT: TREASURER'S MONTHLY RECONCILIATIO REPORT AS OF NOVEMBER 30, 2001. Submitted herein is the Treasurer's Reconciliation Report as requested by the 1992 Audit Management Letter of December 30, 1992, from KPMG Peat Marwick. Attached are two exhibits: the Treasurer's internal cash and investments report (Exhibit 1); 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 included. WJP:CVJ:beb Attachments cc: Jack Cooper, Internal Audit a 011iISlN1IC1 h.1.NC100 i .j0 301410 r .ioo ' is Reconciliation Report as of November 30,2001 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 Hand/In Bank 0002 $77,838,631.02 $77,838,631.02 $0.00 Retirement Investments 0005 $2,766,101,238.13 $2,766,101,238.13 $0.00 District Investments 0015 $593,851,363.45 $593,851,363.45 $0.00 County Investments 0025 $467,632,516.28 $467,632,516.28 $0.00 Trust Investments 0031 $124,158,802.07 $124,158,802.07 $0.00 Bank settlement 0035 $0.00 $24,885.62 424,885.62 Totals $4,029,582,550.95 $4,029,607,436.57 -$24,885.62 Explanation of Differences: 1. Account 4035 shows a beginning balance of$28,391.55 in the Treasurer's Control Fund General Ledger plus a debit of$160,21.9.73 less a credit of$163,72..5.66,which includes Treasurer Journal number(s) 062900, 063600 & 064300. The $24,885.62 represents the difference between the Auditor's office Redeemed Warrant System and the banks redeemed records. (Journal copies and copy of the Treasurer's Control Fund General Ledger attached) CONTRA COSTA COUNTY Exhibit 1 11130/01 NEW BALANCE CASH-VAULT&DRAWERS 241,878.15 CHECKS,ETC 9,479,986.82 UNION-REGENCY HILLS 0.00 WFE-ACCT 1312351 25,224,551.00 CASH IN BANKS 42,892,215.05 ***CASH ON HAND*** 77,838,631.62 TRUST-C.D.'S 0.00 TRUST-NEGO.C.D. 2,258,000.00 TRUST-COM'L PAPER 10,056,000.00 TRUST-REPO 0.00 TRUST-BKR'S ACCEPT 0.00 TRUST-U.S.GOVT 109,654,000.00 TRUST-L.A.I.F.TJ 4 0645 1,929,417.60 TRUST-OTHER(TAX GUARR.&SST CHILDREN) 2611384.47 ***TRUST ACCOUNTS***8000 1.24,158,802.07 RET.ASSN.-C.D.'S 199,138.42 RET.ASS'S.-NEGO.C.D.'S 0.00 RET.ASSN.-REAL ESTATE 135,592,455.07 RET.ASSN.-ALTERNATIVE INV 57,771,385.24 RET.ASSN.-BONDS 1,160,050,145.96 RET.ASSN.-REPO TJ 9 3,261,000.00 RET.ASSN.-STKS 1,409,227,113.44 ***RET.ASSN.INVEST***8901 2,766,101,238.13 DISI`-C.D.'S 1,540,000.00 DIST-NEGO.C.D.'S 26,336,000.00 DIST-COM'L PAPER 29,578,000.00 DIST-ACALANES USD 23,900,000.00 DIST-MT DIABLO USD-GIC 0.00 DIST-BRENTWOOD USD 0A0 DIST-CCC COE 0.00 DIST-JOHN SWETT USD 0.00 DIST-ANTIOCH USD GIC 0.00 DIST-OAKLEY UESD 0.00 DIST-PITTSBURG USD 0.00 DIST-WEST CTY USD-GIC 19,900,000.00 DIST-LAFAYETT'E SCHOOL DIST-GIC 0.00 DIST-LIBERTY UHSD-GIC 0.00 DIST-MARTINEZ USD-GIC 0.00 DIST-WALNUT CREEK SD-GIC 0.00 DIST-BKR'S ACCEPT. 0.00 DIST-REPO 0.00 DIST-U.S.GOVT 84,372,000.00 DIST-L.A.I.F.TJ##0646 378,985,778.65 DIST-MED TERM NOTE 14,360,000.00 DIST-OTHER&MUNI BOND-CAMP 14,879,584.80 ***DISTRICT TOTAL***1000-7999 593,851,363.45 COUNTY-C.D.'S 0.00 COUNTY-BOA Asset Mgmt 25,244,286.00 COUNTY-NEGO.C.D.'S 15,450,000.00 COUNTY-COM'L PAPER 40,000,000.00 COUNTY-BKR'S ACCEPT 0.00 COUNTY-U.S.GOVT 18,424,000.00 COUNTY-REPO 288,739,000.00 COUNTY-L.A.I.F.TJ 0 0647 79,775,230.28 COUNTY-L.A.I.F.Portion Pledged to Fund 1015 0.00 ***COUNTY INVEST***8177 467,632,516.28 ***TOTAL ACCOUNTABILITY*** 4,029,582,550.95 <; = := :s.: : :ct� » . >`;.::s- :•: ;.> :;; >: ca d � i > : 1­1 — z ; > <> : w : : :::::: : %`�, ;. :' ::; za : <> : - '»> » :: '. . ..:.. ::,. . > : 'W -<: -`.? : SS '.<c : d :• :;:::;: => iiec ;; : rit: :;<:; N?ice:.ii:i' .; os >: n . :. - r _::k :..^— a, a , :;: ;c :::z:: ::Y >. : : K:i%::>;:zfs>;: ,.,:--, :=O a, as r a, :.:: v _.,ch ....... . . :•s:2d oo arc:;;::::;: is i;;:; `':':&: :::`v:' i:::..' r' `:iii:?:;:;:;:; ::!:::�: :..." ::i:: ?i:•:is :::::. ' :::::'r:-: -ii; : :;:Us - _ :.:ii:is ii'::.: .:•..:-:..:::- •:-:::-::-: •:.:::::-::::::. ::.:.:':::.i:::: �vy •::i:}'{f•.''::::' :: .moi Qom. .'-:::::ii is �Ot :}:�::> is '.t7 - c� '0 C t'J<:::`::::':: •cr ;:^;v:,:%$:.. .. .. :•r:::: �:.�: •r'�:::::::��::. ....,....:.:-...., •::-:::��::.'::: i%-::•:.�is i`:.: :5:= °' Wil:>:-:::.C7:;c #1°1N >:<;3D;<: rp C"'- :: OUA K7 M :-: } :: } t� .A • ::!':i�:v: w•:: A':'i:is:4:•: iA h i:;ii:::,::»i:%%• i w h :'•:::.::::':: i:' ::S:2 i ''?i Chi .3�!,!,. N N i s :S 15. ^'f:> : �- -..- ::: o� u. AL1:>? ::::�t� _...>::::::><::: tiQi:535: 4::::: t7�N +t) e+5 :%•M• h :vti is ii: w-:: - N �yy �+, -': y� .11 1�1 h h t : :: :•-:.may:.-:'':��yY'... -:.y:::%.��:+'�::::� •:::�:�y`y::- °::.M •:r�:.::::':.:,y.�. ::: �::: .............. :-:::'r .i.%-:-:i,.'S aB�"•F3:�y+ib:_,:: � Q ::-:;:`W. ::'•::.:.W.` tm•-y-;:�-:;:.5r:;: �. �. -.: .::.�:::: .... ..... ; tiC+;:.: tN J ' SKk ->s;i+it� C1 S3 k { >;::<::' Aft;;;::::Y:::::tS C1 ...r+?...,.. :•i;tCf ..''::-i�yuy C7'sfU St7 :;: is C?CA ::::-Y:Y..::;::;:;C. +"r,Y•'::: :LG{:::if1 OY":;}}`:;':,;::::;:: _ is::! ;:: +•:t;:.:^) :; :t>+ :i*Wt�+:-:-:too cnasc i ?:::s: ra cc , . .-m:>. :: <;:zG::.... : :: ->::<a:M O "<' ::;at4;:::O acts:>2 is;i:? :a�a::-:, :;warn s:�?+ts cr # ?r :<::: c> o _ `t ©4Q . t . � N: . 4 � � '. . N. y .I} h . _ '-;: -: y r } C;;v , M- �' r . .. �, `,�•,.C[ r- ':''• tY1 +. YS W`�. N 'tCs LTc +11 .u..� • ., :::^-gid '�- :: a , ::;iii:?:asi tT {h:i ::is::;: :ia fh k�R: :;:::, 9Ci: Y§d::: 5:N 3t1 ::;:-:kms:-:: -:-: -:-:-.::::I. :::::::::•.: . :: :-:i:a::*?� *:•. : :::......... r Ch :::tri ". 33'=::: h::-;:<:sit - N t7ti; ::r:i::;: >: ,n"3.... .... so%M ::iN :i::;:::::c :5::: :::;... N - Cci<:ail:%'S4t3 Edi:i? i',_." O47 < G i :-: ::::.:::. i;:::G/ OCa> :i:: »:CRL3 , . .... L3bC9tG3C tG7Cf<st3 :"5{3G30CsGs ;<:::;CS:i:;:•::. 4O OCss >:::<;2:>: ::•-::::::. Ot�S C3CaCi :•::>oOooO:i::;::::::::: N cs--:'::::;:::::;r ,-::::. ::::::. -..,....... ..,,-.-- x ::i:i:i ds rtsr�se s ;;'S> :i::iRh7 r.i : .:::. ;:4"1 .. rrr�+srnMMi+i <:# W +G�C94ts�o 4SEo�Otits i:>:i:r-• C3 :ii::: tL' ®CJ047Q- 300 G7 ;'.'::::. OC704:>;:::::::.. Cs t7 ............. :•::. :- . . ::d r ;;y f::: j i;i:'i 3?2:: '%:: i :'::::,.-::,:::- :w:•:o::::•: -:::: :;:t'::g,: fir;?::»::i>; `"1 :;'.2lI � d :::;>".;:.K::::::::? `i i>:St?D?>?>:: -:::}:;: -.v: ............... d1 ::%2:::: }''7c < a:::::::>:»::: ::>:. :. : .. .. »:::c� : >M `* {,< ; - •:'r.'z::,:;<. t•- :y;,.;y.,,,r.. ."'� I" "`:`ff+:::::.:Ic';sz ",'z 'fR:i';::::::c.... ::a:::: z =<:: >::: dz z?�,k�- �vwr- xu� :;** wt� wt t Nwwww t-t- mt; tt�wrrcnzfi-s�s�st zt�wt5 skr. sc+N�a-+-r- f-sawta zzs 1itt- #to w#�i .: wUs to . -;t�ovsvau�crs ' �M-0 ww �3 >: xa �x�i-- vzwt-- wr� .:.Xwc- s ria-•r :::^:}-•i wwww.: wt-r r�:s:. i - - usxr ct�u t�>rndc�s«c>:::: r»>: t:<:: v3*td vst-r#��t ::: wCt LG B.'2w6 ttt7Lii3w cnw 1 .B."iii,:s ix# Z .G';f: f-•faiiai I triJsiJ}Sis f fii:::': x9 .SCS cii —>�ww �:t£iiw-->m - ttt a►a _. .Q.zit tf�3+ cnwwu#rta :; t:>: 3w d d1- "F- w�� *� ::;Z^F--4A T+'{ t# 'di}-F-t-F�f/i x�i+t i5/� C7.s «Cf�. .. ' o%:':'<O w ssij�-:<:j�-.?tr7 w�--c .,;-::suj3*._ .> _ ar�Uc�c>._; a t.�'- - .;W:;:tiai }^'^ w"'C trd'}^,� Q'}- Usf- ,i'". F.:::. !".t}+}R `'=.: ... i A:GC�G"-- :';::-:'{ "Q1"`�""}"..'''::; '::: :;; ztrJv»�a� - esL�trso ::.:::;:susvitncn.;' t- w o �! -- 9 f 1 �G -O�tt�der�t 7£tt_+�KWC-w0 Wi z:<>:::4.*<- Zcfo. Uy[tC :::;t;: - :: 0 r r.-err: :''': - QCs CNssC3C'i�L433NNNNt�tC'di'Git { 3NNNN #txst'Yftt t1R�1SrFltilscttt�f fGtf't3t!s SCl2-:, ;x­......�­_ 't S 1C3GkCSG7oCst y 5: 5© C>G� S, ire-r-•rr-w{+ f,Sii"4NN mMOOM'ffi 5::: e. � 0 Cs�K4, ���soCSGsC�ti�G�AC�t4'?Oo�}t 3 0000 5�«t�G?.:;�?CrCs+�ooJ . � GCS c�C9C3atas �: ,:: .:: .. *��:j:�:�:�:�:�:�.�:�:�:�: :x:�::::::!:­ �:::::::;:,::_."-"" ...I......... I..... a . .. -!-�-,-:�:,::+:­­ ;�:�:::�:�:::�:�:�:j:�:j:�:�:� .::::: .....—4::.�:,'... ... ��:�� :::!!� :::�:�::::::::::::::!:: :::-:.:.:":�:.!..!.:�:.:: ,:-­:: :: .. ­..­��.- ..­. :­;�:-: :�:ax:-; _...... :_:_l­ ::::!:�::�:!::::::::�:�-w `..l­.-.._l­',,,, :-::""',_.,,+:."­+­ `:::,:::,:.,:, ��i�i��il�:���i��i�� . ,'," ��'� -�-l'l__­l­'-::�::: .::::::-::::'..,­+­ ...� � -:::::�:::�` _,11 ­,­ '_­ .......... -. W., ,,­ , ,­_,..'l ­­ t I.-­," ::-'-:': ::.: .::. .: _ .. .1 .1, .. ::,:::::..:.... _ :C:': �'vi:Q:•:-:-:�: ��„ N.�i:.::::;::: ­­.­ .......­.....I i`� :i :.:::•iii•::•: ... ­.. �:j:j:���:�:�:�:::j��:" .. ..... ..,:.-. ... _�.%, � ­­��%......_. ­.", :i:(.yi:v?e::iii: 'ti•:�:::i ii I j.v�,-- ... :..:•::::::::•}:. -,:::�:•. v::.•. ':. :v::::,: '::i:-:is•; :'':•: 1. :':-i:v:::::•i::• �';::. I i;:::::::::. _ C:i <:- ...is - _ d i+� �,,,+ rt W :'.is 7::�•i::-:-i: :•: i::•:'ii:l::•i:'•: :-:-::•;i�:j::i::;:j:: :: 1,::::;::::`�: ::':?:::•::�i`:::: �::•:::i:•::•;::i:-: i:J.::{•>:-?ilii: ...::::::: •. �y d6 .. ;. :i :. :.:::Q::,:: N�:..X:.:::::ii:'.r f ::=<::to ti �y=: . . 1 ::f r >,;: C3 { b 4 �yyb �+�ryry �3 LL 0 :: ��44 ::`:, V Zd y V .: ,- - ,- w kk tfP >:''- >: ko N st t ....... -. :::•:.::::::-::. :•c-::.t: ::::.:-:.�:::. ::::. O'.:,t;X::? ;i`:Q:;i'% j tt70+7ti41:: i 'i..i::i. f- +� 't b:iS :>::: >: ::�>:;•>:: CAtsrthv,?::::f •:-:>:•:< :;*^" WrCTL:2'S+2x?'? f?±:: .7bN #!>i r C)1 C 1 1%.1SilA '` ;''_i .� . b ped b •Q".:': :, .,: Al Gl4�w �: .1� O .i.. :�.:::::>:i::::::r:i �N is<:C7 S t7� r ::::r btiC3�. F-, $ 7itCFST;Tt3! CCt3^.r4,x3?f.. : b.-j`MP'.,::J.,.`!,!:, : :cn rrNYltd�'Qk"R1:::: ' o .v'„ :�::"i ,: -?: l. ::�;::•ii>7}i` w .b:_:iY I...::?:> w aii:::w:•ir:>." w w w - 'i::fx. :N;z5 :::: Wit^•N ...C3. •:-:. Nita S:.>M Ni'> r:c::w.:_—. a:,- •r --.:reg::: r � :::w+:::"%c<:i >: f:`>:::'' f Ei1ti##ROtC1it\QCSCt3 ?':< rri ::::i Y :> O ek is::a ... CA19e*iMNf CSt ut11T h ::;:i+;::`.:;:;:::i- C5 ::::::if!'i::C 11'v:d?: .. ..:..` .tV iStLOW r Ci:: �'3F-Y!:r t31:::::sC�i:::: ??: ...:..... ;i- - r:>: •;a:::•::;•> —:.P'.':. ..,... ..._:::,}i. :v?: �J ttttll �: ;..i i1 w ::. - - : :' :. (�'. .. ':::.'. '' ':. - : .. .:.':: :::::.. w . . ,::. V r::':r':.:w»::':' - .. ...-. t�; -' ` :: :•:i. d i.. 'i:: 47iY; :'::> 'r :,:: C #f...#R. ;::: . ;:;;>:::'ta>i:r: 4. N ::::Y,�s:::�ri::% �i:43: ti3:::: - - _ ...... ,... :1.::- :::#:i;:: >r: ::::: ....i.. :i+K:::r f.: :' ::`.:�:i;: •.t,-. :: r rr .s* :i: r%r r :;•:;•;•:->: :-:.:':':: x-r?+ti+rwtv%?irwrrrrrri%ryr-.:.:•. Gbt7C7 ::>i: :: 'i'>;`:CY ..:�#C� �ib bC�O �t�i bC7C>b >: ::bbbbCJ : �S.GSCC�Obb: : b : ' O £? ' M ago 99 e6 #s GA ::•: " 6a M1R900atACri "• ?63bOwt�i M >:: :::::= H QS tC99t� ~ala. 1"+' N N NNNNN i*.#d�liMNe+s. :'2:,dfNNNNAI };N.VNK(,jmMik4#k�t, Y?R rr r r tw , :j;,:::. ::::::=>:::'#!its Z b!P:e .�r,.!:+r!+.rrrrrr:rrrar.` V?K?Y7 ;;;;::: �:?: :'�"CJ - itt- , r �•e�++i�•?#tt-° :.:.r N ry ....;� ..?,'.f::r`r r-r-'r#?;r{:;N4 'j - _ ::i:»Sri= i:i>L15GC L7 Na'.�i4..,:es!ri-".r.?? r .. ....... :•X.:.:•::;:::.,•<. C7Ot7 :< N <:=:$# S " x:: :•::::.. > -»:•:<t3: "3:4e'S1...r "r�'6`Cs.Q:=*:i�C�t,..,s',r,.#".+,.'t,Rs�f-F-^ 4 . r.: ."",-::. .+,•....,,+,.:::::. - rr �p C� b +� �"� CSC7 Co i�'':::j::i.;;::'.: :::: Ot O bC7 tom`,•.. J aDi '::;j>S:' C bC>C>88 -, C51 ;` . '.' ChOLbC7 .CJb C7C7 .. fiw �: rr MT.H.T''.Nh- ad:; >';::i::>:: 1` eC>h-tV.::. 1.�BCriCh . . T:: x= M D1 Ery Lh b ::: -`�.�'?h"ail7Vt CAObMi"} ?f►4*,,, c4 .. OJ# G::Lt'S'Stt7'^w,tVNO::: 3:2t:::.•: YMmE6 '! ?7Gtt'+'f0.iCritttC.O.. ;tf3#S't;<:;:`ti::<.�;:i::i>::::: e1f 4C1CGl�tJ.... iCCt)tYJQS3 ..,d3ECTrp`a`�F-::: ::: :3i:: ' t Wo3dCb:,:? :.: t3t4CtiY h CK7:Q,l3...:: :•::::::::.;. b:c;::5>i:.;o:r>:. rrr bb :: .;itrt >:;:c � t�GS G! 'tai::;: : Y k 1 iL 4t LSCibI G3 i SL1 1Ct3K #-°.�-.. .::;.CS Ga C3 Cl IL1 3 <:::::;;C.z ;::a:'::5:2-::13 r`w bbbbb w� : !i"$.b 33b:: ._.....,>:` rb=b ,, "..bb ".:`.. . :;•»: >;>:.; ::.:-::.- ::::,' 1:Ssiisi::ws':Si+Wu.w6c.u,.ty:�i►:ta;,s�.tr>L.I-°t' =OYb::•O�i;>:f Nbia..L�Wii,;U: jiuw,U.,L,LU ti.uSi:,ia:Ul'Wf '' V:>: , >:•: C71. `w " :::::- :..::::•:.-::::: .... £f 1sLrkts:4 itJ}m1 C7 :>:::::,:� :::i 1diL CL U. 4.Lv W tLLd:ii:lx:-.. 2t:;S::'`:; tL M"' �Otia�ai:;.li�:3ia.�.4.7.�ia...4.,.........,....._ ..,L4;...,..:... _ ;' _ = N)s.' ,�#(:•fia-.Y..,L6L.wti.u.S{:�t«f�(:.ft#J:li.^.E�zd. )4� �;:;'f•-N3.+:.imu..fd fa4i#_tt�.�.sa.te.u.i�ta.�t�:4i;F3f:ti#�E 3 .:1C:) + 7:2L�]i7taCiClG�CiDGtLSE"�CSJJ_iti5 :::—"bOG1Y:t"tY3CbG1t�CSC] i`1��1 ►;'. 1. .:..:..::..:..: :::::%:::::: tai 'ffi t ( CL� iL� tL"�h-haF�us:<:<3::::>:i:sct1 awixD"i1X tL*s�'tL' ++ .., .i J ffidlrtLsl:fJG m db w e�s>~aca�tc�taiww 1t :dacsrt>~tu #rocsrts ecce ins ,N W F-- ^a ddddd QtoU)W 5C' F-"�.ddd+f # *�K dQ�Cdd tk## m tat w i33c� # ` 3 :i t>rc3rI' ' �c3� '� r i esC�GxG�iisf etaz ' �t3crc�Lx y 4 t c�c�C5c3Ga .5t 4.w U � t1 twtt+it4iw6u Walassaw*•K¢d -d �J+rwwf tfkk ft# we 3wi+JwWi tEs tl iK z i�aQsf ±^++ cct sra tr= ^� Q rrasCoca : tz�:,:tawxc��s� r�q�r�+crc�t�i�tsw f;+�?�cr? + l >;:i. si s, >. a ,. in usiisCs€cznznusuEu;t"ui#€C�sc§sssncsNsn,s"u1 ::ot7bbc3C3CG<3hCc�bbbcsC3c {3e3C7 .11 ti b M Mftl4#�19YYa+iMMiw5Me+Sff55MSi35ff5mMehMM ::CLSQGCI Gx (3C�G7CiibC7. { ?....11 b ra~?, ? tcYobeacssradbcc�bc+o r- .::bbbbca0O' i? scc�bc5a :i�i::t?:;:: c> ca ? ?tst>bbt�c� ? cxtasoc� ers;:;000t�b�gc?4bboozbpc :: ::•:: G�- <3 ":'.: ".. 1 1 �;+ � mss; �`".';✓ �'�' �� y; �� �w 12) A ° rs 0 CP 4p t2 o tA .- 8 p a ° 2 a Up a u k- 5U M tr1 C7 <. h a W H rM � r4 N -ft yyyy� L c p a LYi 04 a © A ou DO � G3 N ✓C57 N m C w; 10 r- ca o~ L n OQ A a `i � � M w C4 Qu Q Poe. r� l