Loading...
HomeMy WebLinkAboutMINUTES - 02281995 - 1.1 (2) joc TO: BOARD OF SUPERVISORS Contra FROM: Phil Batchelor Costa February 28 1995 �'`"' County .� DATE: �?trudii SUBJECT: Treasurer's Monthly Reconciliation Report SPECIFIC REQUEST(S)OR RECOMMENDATION(S)&BACKGROUND AND JUSTIFICATION Recommendation: 1. Acknowledge receipt of the Treasurer's Monthly Reconciliation Report Background: A 1992 audit report by Peat Marwick recommended that a reconciliation be made each month between the Auditor's General Ledger accounts and the Treasurer's accounting records in order to improve internal controls. The Treasurer's Monthly. Reconciliation Report has been prepared monthly since that recommendation was made. The report is prepared by the Treasurer's staff and reviewed by the Auditor-Controller's staff each month. The report will be filed with the Board of Supervisors each month for your information. Government Code. Section 27063 requires monthly reports of moneys received and disbursed by the Treasurer to be reported to the Board, although that section was made permissive in 1993 by amendments to Government Code Section 53646/ CONTINUED ON ATTACHMENT: YES SIGNATURE: RECOMMENDATION OF COUNTY ADMINISTRATOR RECOMMENDATION OF BOARD COMMITTEE APPROVE OTHER SIGNATURE(S): ACTION OF BOARD ON FEB 19% APPROVED AS RECOMMENDED OTHER VOTE QF SUPERVISORS 1✓// I HEREBY CERTIFY THAT THIS IS A TRUE UNANIMOUS(ABSENT ) AND CORRECT COPY OF AN ACTION TAKEN AYES: NOES: AND ENTERED ON THE MINUTES OF THE BOARD ABSENT: ABSTAIN: OF SUPERVISORS ON THE DATE SHOWN. ATTESTED EM 9 8 "H Contact: PHIL BATCHELOR,CLERK OF THE BOARD OF CC: County Administrator SUPERVISORS AND COUNTY ADMINISTRATOR Treasurer-Tax Collector Auditor-Controller BY DEPUTY County Counsel 1. o0 • Qa.�e.. 2., CONTRA COSTA COUNTY TREASURER-TAX COLLECTOR 625 COURT STREET, ROOM 100 MARTINEZ, CA 94553 DATE: January 18, 1995 TO: Phil Batchelor, County Administrator FROM: Alfred P. Lomeli, Treasurer-Tax Collector SUBJECT: TREASURER'S MONTHLY RECONCILIATION REPORT AS OF DECEMBER 30, 1994 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 which are 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 included. APL :CJ:gm Enclosures cc: Ken Corcoran Leo Schmall CONTRA COSTA COIJJ`_,Vry RECEIVED JAN 2 0 1995 ' OFFICE OF C0UNTYADMIN,ISTI",�TO, 08:16:59 AM 12/29/94 CONTRA COSTA COUNTY 12/30/94 NEW BALANCE CHANGE NEW BALANCE 610,580.76 CASH - VAULT& DRAWERS 621,902.31 4,180,508.53 CHECKS, ETC 920,045.67 46,129,143.88 CASH IN BANKS 58,893,353.79 50,920,233.17 ***CASH ON HAND*** 60,435,301.77 3,654,000.00 TRUST - C.D.'S 3,654,000.00 32„296,000.00 TRUST - NEGO.C.D 32,296,000.00 34:,951,000.00 TRUST - COWL PAPER 34,951,000.00 4„424,000.00 TRUST - POOL#0200 4,424,000.00 7„730,000.00 TRUST - BKR'S ACCEPT 7,730,000.00 2„210,000.00 TRUST - U.S. GOVT 2,210,000.00 1„569,950.00 TRUST - L.A.I.F. TJ # 1,569,950.00 122,186.85 TRUST - OTHER 122,186.85 86 957 136.85 0.00 ***TRUST ACCOUNTS*** 8000 86,957,136.85 0.00 RET. ASSN - C.D.'S 0.00 0.00 RET. ASSN - NEGO. C.D.'S 0.00 0.00 RET. ASSN. - COWL PAPER 0.00 0.00 RET. ASSN. - BKR'S ACCEPT 0.00 5,083,000.00 2,917,000.00 RET. ASSN. - REPO & U.S. GOVT 8,000,000.00 118,038,371.87 RET. ASSN. - L.A.I.F.(REAL ESTATE) 118,038,371.87 636,786,620.66 RET. ASSN. - BONDS 636,786,620.66 141,580.73 RET. ASSN. - BLDGS. TJ # 0853 141,580.73 39,909.82 RET. ASSN. - MTGES. 39,909.82 557,701,061.51 RET. ASSN. - STKS 557,701,061.51 1,317,790,544.59 2,917,00 1.00 ***RET. ASSN. INVEST*** 8901 1,320,707,544.59 5,1597,000.00 92,000.00 DIST - C.D.'S 5,789,000.00 28,674,000.00 DIST - NEGO. C.D.'S 28,674,000.00 20,113,000.00 2,257,000.00 DIST - COWL PAPER 22,370,000.00 3,173,000.00 (874,000.00) DIST - POOL # 0200 2,299,000.00 570,000.00 DIST - BKR'S ACCEPT. 570,000.00 0.00 DIST - REPO 0.00 157,1593,000.00 DIST - U.S. GOVT 157,593,000.00 105,1303,655.81 (722,000.00) DIST - L.A.I.F TJ # 0848 105,181,655.81 18,334,000.00 DIST - MED TERM NOTE 18,334,000.00 10,786,991.22 DIST - OTHER 10,786,991.22 350,844,647.03 753,000.00 ***DISTRICT TOTAL*** 1000 - 7999 351,597,647.03 0.00 COUNTY - C.D.'S 0.00 (18,1300,000.00) COUNTY - REVERSE REPO (18,000,000.00) 73,000,000.00 COUNTY - NEGO. C.D.'S 73,000,000.00 50,000,000.00 COUNTY - COWL PAPER 50,000,000.00 (7,597,000.00) 874,000.00 COUNTY - POOL # 0200 (6,723,000.00) 0.00 COUNTY - BKR'S ACCEPT 0.00 114,750,000.00 COUNTY - U.S. GOVT 114,750,000.00 128,917,000.00 (2,917,000.00) COUNTY - REPO 126,000,000.00 15,079,080.00 (26,000.00) COUNTY - L.A.I.F. TJ # 0849 15,053,080.00 14,450,000.00 COUNTY - OTHER . 14,450,000.00 370,599,080.00 (2,069,000.00) ***COUNTY INVEST***8177 368,530,080.00 2. 111,641.64 1,601,000.00 ***TOTAL ACCOUNTABILITY*** 2,188,227,710.24 GUIDELINhS: TOTAL ACCTBLTY 2,188,227,710.24 LESS RETIREMENT (1,320,707,5"39) $0.00 SUBTOTAL 867,520,165.65 ALLOWABLE CP/NCD 260,2x6,049.70 12/30/94 ACTUAL CP 107,321,000.00 ACTUAL NCD 133,970,000.00 .;. ' ,b� .. . '. . : :... : o v©0000000©oco 0 ooao:::0000 000b::oe0000000Ooo o D ::. :,::::::,.O..00.000000POGo 0 oopo GpOO 0000>peU00000ca0000 zo 0 wwwwwwwwwwwww w NNNN ..-+-� 0000<;OOO0000(a OOOO On A:::: '::%:,OlJt4JYlJ�V1lJ�V1lJ�LJ3USoull1t - V7lJ O%Jj, W1Vwiv %.nu%rimV NAV.NNNNNNNNNN.N . --( --{:.::::: W -i n o .o rn o w.�z.w;o;*;omrnrnrmm2 c t�t� o.v(n ���'i . :vW�c7orivow *icn s DClti*tmmmm�.�.�4�,T (n OQ;z... .=:--i rrjm trtr+7Dmp O. +*;Dpx - 0 0 :O zaavovvc>nnfxn -a ec-d cricn� -i-tt.: ...-.4-0z-iecncsnvz z rn c� .:: .: .Vi ZZ < ....:={ V- 1.t*i; SOT-z-i2-iDT:L�O Z w::: tfS��WSu �rn D �-t ��(� ��3 : :�:fn ���-itn rnZ -I m 0 ..��DDDD� � S,- (� <.< -� mtnm Krt-cnm� O A N rss ���� n a can z -im n "n-i. >:x m vD :: I. f 7J�."0� >:'. :>::;>r O N- < O-4-i- (n -{.:�.... -I -i:;:-{. '{Y*iD D mr t.::,.: -�•,��: �. .rn c czsm..:c:::. z czz :'cti�-izz 2: D-t2Z U1 N <. rL7Gvovo-+=+Op�s3 z oo<Cux w=.-< W<C rnCmr«-Cr mrcv c car p '; M.: --�.�.., , -i i Mme r- 1 mmz :::i:*& mmmzmx�iTso� W ;Om::::,w::::::... . X-s)mrnm-n�7 , wt7N-+ (n D(ntn .. K<tn DNti>< ?aV>33tntn<ti�<33 .- < -cs O rn-Ti �7�7-n-nrnot-,.atw--i c�-1-�rn t2mm c� i-tm .'nom-m-i�mm minz vc) X :. .... ':'. n3 f C/t(n3 n3 (A;f?3-i233c/�3ZA-tZl*1 --JM iTs s�7-nrnm�7�i?n�s^a : omm.*,f O..q im OMM-a.''Om(n-�mm-ias-ltn-t":sW -z :C:C:CCCCCCC cZ.2 tJ> 0:332 CZ."� C2: 223.2:3 ,D O I. .: '22ZZZ2222Z2 Z�-t =MrrI Z--t-AM:x Z 4 -ism-trri -j2 ZD ..; a7G.vovovGC�V -i �cn -i ::. ;: .:a z c� n :::ti:4CbFJFCCOCOGti:SObVi -i f:::: --I .tlf..: -{:::: O is::io.m.%o�o�oW0000LitWCU O - >:.CJ'.;': O ::.0:. : C ':: p.+o�o�oOOp:OOCZ -fi r:-l::; -i -i X gA0000 . r ":r'::: r 7. 4� WWW�c�zi � rz:<.: - =i:<-: _:% i-a -ice:' 'i' -i-i-+-i-i-t-t-t-t-i CG ESES<!C!C<!C'::' LC. GSC Lc..'.::: . ::.-C-c- .LL.0 Y.!:.C. O i` >:'fJ:,-:��...r�-+NATA7A�Tt17':1 00.. .... 00 00 '>"000000OOOOO ;ow :;:Ob.NNNNNN�:=:':{�.a..i::;; OoC�:::::;i:... Ou OoC� G�Oo0ocoCow(;D,CO4O"CRG�: m-{ �wthrWNNNOOC6V>17+V+ FF:"::>::.:::�� lnF IAVVtInFFfiFFfi :::W.0.00\Mo%Dvk. 1p;'. �oG+ :CS.Vt wJ :' :;G+N-+o�OouiTVt,�wN z O�ato�o�o�o•oocaooc>.;: oca::,•...,:o0 00.; O00000Q0oOo: o :.:,0�:�:.FFFFoOOOO::::: 00:::;,;::.-,:0 oO.:.i': ..:A00000OOAOc>. :;:..... ..,:. :.. ::; .". . ..... . ... . .. .%. : .: ... w '::::4i::i;W::. W w '4ia':' !?7;::::..::: . : :::':::::`::: .•.:...: :::::. ...:::;:.::.: c.:::: ::.::. . ::itOO %O O\ :::ipii::'.O.:: . w :[:moi::`i G�:;i: ... O 41 STS 5. . .. i::':N 1Jt O C3.1'r1;>i: J �O .::.+D.:.:kO . :�0 "n rn m..:. :::� J J :C::�I::::;G6::::::: 07 O ;p::w W N W,0'_:;.O:.:::,(7 D N ' Z .::O ,V . O . - O :> .e .. .� G1 O a.:::4:::::: J F ...:,fi5: :. In O 2 .O :W O . .:: 0 .l is < .:i::,::' Vt O W �O N . O .. - ... ::•::::.. �.-... .. ..:...;:. :.; rn :. :>: F :C' 117'>1- wN:;:'')'.'>. '.:..., VN) O� Z �:::':: C3 �O 10:: 'i::N�sfF 1m00\i:<:i:.WI.:N -+O : F0. .i ... .;Aj::'.�� mwN i-+'ODuln •.I-JfO?:i;'1`if�J. ::N OHO -J m .M::: r .::err.: 04;:::::.'�i:,:::?;:i: .'::�:� JInN N N'::::i:.:.OD�0o OOO:: ::O''i::0o 00 .:: Q1 :%p rn;:::c ::,.p: FFO� O 0:::t;:G7Lk0 OOp:: ':::tT :tn 00 C?� �. -3 � -+O\ OJw O GS..::::ODO 000? :10 :b 00 �D fl. N D-::: . ....: .. .. :-: �. :'. r:.r . . . r:: .. �>:.0::.. r r r r:: !� :: " ::000C NFJ O ©':: ' O.O OOO,:' :::1D.':::,0 00 �O 'O :..:::aVt FDIn : O CY;:<:>::iOO:O 000:' :::O:�0 00 : .:.+ Q: r .. .. •::::::.: % ..: ..... -::> >. m ... 1. .::. CJ `:: :. .: .....:.'. ..:::.%:.::::::; :: .. .. .. �.. `: .;I .. NN:;. : 1ON: V 00.::'.:"':"::. ': tp N Jt6:� J "-: : MM::'i::.'. "'"'. N:: F VSD\ LT. O ' NN w%O . poJ O� wq o ":>:::':'>.' rn �Y: :,w �i:%0 :;. OOi:::; ::>''``.c; vrp .I ONp w !i D OP. >O -+WOaFVt.:: 00: 0 W OO'O .�' .:: 11 W::.:.:':O O-iVS0.44:: 00: Wp 1 OOw CD N �(.'y:::'`.0 Fp7: �iV}'; OO::'.'i: `:'<:.:: ;`.JO: w Od•R O c� O : ::. ::. O O :: W ;: t0 In to .. J F D Z :': :.: O X 1. w rn F .::O O� O -,t.:: F -1 U):::::::,:-d,a. Do O O i:: In J :: A O W;>' �D` .3 to O 1 r m \ v z :::: h, A M o : v1. 1. m .. . >.:::: rn D N O :: c w, ..: z O .. . _. ob 1/6/95 - Reconciliation Report as of December 30, 1994 EXHIBIT 2 EXHIBIT 1 AUDITOR'S REPORT TREASURER'S OFFICE TREASURER'S FUND INTERNAL REPORT ACCOUNT FUND GENERAL LEDGER CASH ON HAND DIFFERENCE 0002 Cash On Hand/In Bank 60,435,301.77 60,435,301.77 0.00 0005 Retirement Investments 1,320,707,544.59 1,320,707,544.59 0.00 0015 District Investments 399,597,647.03 351,597,647.03 48,000,000.00 (2) 0025 County Investments 320,530,080.00 368,530,080.00 -48,000,000.00 (2) 0031 Trust Accounts 86,957,136.85 86,957,136.85 0.00 0035 Bank Settlement 5,037,543.63 0.00 5,037,543.63 (1) Grand Total 2,193,265,253.87 2,188,227,710.24 5,037,543.63 Explanation of Variances: 1. The Bank Settlement shows a beginning balance of $5,024,044.37 plus a debit of $25,100.05. The Treasurers office made a credit adjustments of $283.28 and $5,811.15 (please see attached copy of the journal entry). The balance of the variances is the difference between the Auditor's office Redeemed Warrant System and the banks redeemed records. 2. The $48,000,000 difference is for the County Tax Anticipation Note pledge fund. Though the borrowings belongs to the County investment, the pledge fund for the repayment was assigned a District Fund number 1015 by the Auditor's office to fully encumber and isolate the legally required pledged monies in the formal accounting records of the County. coCo co > > > Z - - Z z 0 cn -n > (n c/) mm -n m m — 0 X M M x > (D 0 C: m z r— -K co z m m m (f) rn m m m Z z -n M M Ln 10 0' 0 M C- m 0 m m < cn CO C: (n ..-o 0 0 0 0 cf) mO 0 0 CO > 0 O .. 0 - 0 . 0 .. 0 C/) 0 C)i W co -n (0 > ew Z C) c D z > Ln -TI C) 0 C) x m 0 rri .0 CD rm > > 0 .;o 0 N) -4 m \\44 rn m V co 03. > c � r- x LO K 0 co 0 NO M -4 14 m °- ' 00 r'+ co — ti =O w -4 —. -- _ -- D-- D D - 11 N o 'U' 1 w co cn Z Z ' �f m mco D C7 -- — —I --1 - I' o m Zrn o r � o m v rn m N o mN - ---- --. -n p m - - -- -. _ - - ---1 - A - lz X m c - o loo O s _< (n rn cn D -- — -- -- m ., w N A 0 p D C - — -- - --- - -- _ _ O O O - O -OCO cn m -- -- - O - O O m - - ----- -. _ O o O -_ D O O O a � -n O O O U N ZO .> N p -- o- U D Z N T O 1•r Q --- -- -- - - — -- -- - -- -— _ a D " z r Z C/) m C O (-' Ln Z m — -� m o G D zm I D I I to m - --- - l 1II i o _ m `Q = .J.. m o 1 v �o 0 lV � 0 c r.- y 0 r O n 2 o CO A 1Tm _. ------ —