Loading...
HomeMy WebLinkAbout02.01.21 Monthly Treasurer Cash Reconciliation November & December 2020 From:Crane, Joshua To:Alpert, Bruce;Bennett, Robin;Clerk of the Board;Connelly, Bill;Cook, Holly;Cook, Robin;Kimmelshue, Tod;Lambert, Steve; Lucero, Debra;McCracken, Shari;Paulsen, Shaina;Pickett, Andy;Ring, Brian;Ritter, Tami;Rodas, Amalia;Sweeney, Kathleen; Teeter, Doug Cc:Jessee, Meegan Subject:Monthly Treasurer Cash Reconciliation November & December 2020 Date:Monday, February 1, 2021 1:29:10 PM Attachments:Cash Reconciliation - November 2020 signed.pdf Monthly Fund Balance Report November 2020.pdf Cash Reconciliation - December 2020 signed.pdf Monthly Fund Balance Report December 2020.pdf image003.emz image006.png image007.png Office of the Auditor-Controller Graciela Gutierrez, Auditor-Controller 25 County Center Drive Ste. 120 T: 530.552.3600 Oroville, California 95965 F: 530.538.7693 February,1,2021 GoodAfternoon, AttachedisthereconciliationofthecashandinvestmentaccountsbetweenAuditorandTreasurerBooksforthe County.PerGovernmentCode26905,Not later than the last day of each month, the auditor shall reconcile the cash and investment accounts as stated on the auditor’s books with the cash and investment accounts as stated on the treasurer’s books as of the close of business of the preceding month to determine that the amounts in those accounts as stated on the books of the treasurer are in agreement with the amounts in those accounts as stated on the books of the auditor. PerGovernmentCode26920(a)(3), A report to the board of supervisors issued in accordance with the appropriate professional standards, as determined by the county auditor. HereiswhatIamsending: MonthlyTreasuryCashReconciliationforNovemberand December2020 CertifiedSupportingCashReportforNovemberand December2020 TheAuditor'sOfficehascountedcashinCountyTreasuryandverifiedthebeginningandendingbalances, receipts,anddisbursementsmadebytheTreasurerperGovernmentCode26920(a)(2),Verifying that the records of the county treasurer and auditor are reconciled pursuant to Section 26905.TheAuditor'sOffice doesnothavetheexpertisetoassessthesoundnessoftheCounty'sInvestmentPolicyorexpressanopinionon itortheTreasurer'sadherencetoit. Thank You, Josh Crane Internal Auditor Auditor-Controller Office of Butte County http://www.buttecounty.net/auditor/ T: 530.552.3621 F:530.538.7693 Office of the Auditor-Controller Graciela Gutierrez, Auditor-Controller 25 County Center Drive Ste. 120T: 530.552.3600 buttecounty.net/auditor F: 530.538.7693 Oroville, California 95965 MONTHLY TREASURY CASH RECONCILIATION Below is the reconciliation of the cash and investment accounts between Auditor and Treasurer Books for the County. Per Government Code 26905, the amounts in those accounts as stated on the books of the treasurer are in agreement with the amounts in those accounts as stated on the books of the auditor. Per Government Code 26920(a)(3), A report to the board of supervisors issued in accordance with the appropriate professional standards, as determined by the county auditor. Attached is the report with detail for your reference. Treasurer's Balance on the 31st day of October, 2020 was$930,309,535.66 Add Deposits in County Treasury for the Month$272,667,269.01 Sub-Total$1,202,976,804.67 Deduct Warrants Paid for the Month$285,642,353.05 Amount that should be in the County Treasury on the 30th day of November, 2020.$917,334,451.62 The amount and kind of money actually therein is: Coin$241.08 Currency$4,579.00 Checkbook Deposit In-Transit (1-Day)$45,000.00 Checkbook Deposit In-Transit Adjustment (1-Day)$332.47 Checkbook Deposit In-Transit (2-Day)$59,100.00 Checkbook Outstanding Items (1-Day)$1,933,012.31 Checkbook Reconciliation$9,137,728.06 Corporate Notes$103,060,172.25 Federal Agency Notes$208,739,791.80 Muni-Bonds$158,674,447.03 Certificates of Deposit$8,746,015.51 Treasury Security$44,858,655.99 Accrued Premiums/Discounts - Investments$152,836.02 LAIF$311,909,384.94 School Bonds$70,003,100.55 Cal-Trust CAMP$10,054.61 Total$917,334,451.62 The Auditor's Office has counted cash in County Treasury and verified the beginning and ending balances, receipts, and disbursements made bytheTreasurer per Government Code 26920(a)(2),Verifying that the records of the county treasurer and auditor are reconciled pursuant to Section 26905. The Auditor's Office does not have theexpertise to assess the soundness of the County's Investment Policy or express an opinion on it or the Treasurer's adherence toit. Ideclareunder penalty of perjury that the foregoingis true and correct. Executed at Oroville, California this th day of January 2021. Graciela C. Gutierrez Auditor-Controller ________________________________________________________________________ Graciela C. Gutierrez, Auditor-Controller Office of the Auditor-Controller Graciela Gutierrez, Auditor-Controller 25 County Center Drive Ste. 120T: 530.552.3600 buttecounty.net/auditor F: 530.538.7693 Oroville, California 95965 MONTHLY TREASURY CASH RECONCILIATION Below is the reconciliation of the cash and investment accounts between Auditor and Treasurer Books for the County. Per Government Code 26905, the amounts in those accounts as stated on the books of the treasurer are in agreement with the amounts in those accounts as stated on the books of the auditor. Per Government Code 26920(a)(3), A report to the board of supervisors issued in accordance with the appropriate professional standards, as determined by the county auditor. Attached is the report with detail for your reference. Treasurer's Balance on the 30th day of November, 2020 was$917,334,451.62 Add Deposits in County Treasury for the Month$650,393,492.76 Sub-Total$1,567,727,944.38 Deduct Warrants Paid for the Month$537,335,289.24 Amount that should be in the County Treasury on the 31st day of December, 2020.$1,030,392,655.14 The amount and kind of money actually therein is: Coin$302.47 Currency$4,834.00 Checkbook Deposit In-Transit (1-Day)$24,550.00 Checkbook Deposit In-Transit Adjustment (1-Day) Checkbook Deposit In-Transit (2-Day)$26,150.00 Checkbook Outstanding Items (1-Day)$1,110,578.35 Checkbook Reconciliation$27,510,840.50 Corporate Notes$108,340,684.91 Federal Agency Notes$219,007,127.80 Muni-Bonds$158,674,447.03 Certificates of Deposit$8,746,015.51 Treasury Security$44,881,935.51 Accrued Premiums/Discounts - Investments$142,647.84 LAIF$399,717,318.90 School Bonds$62,195,166.59 Cal-Trust CAMP$10,055.73 Total$1,030,392,655.14 The Auditor's Office has counted cash in County Treasury and verified the beginning and ending balances, receipts, and disbursements made by the Treasurer per Government Code 26920(a)(2), Verifying that the records of the county treasurer and auditor are reconciled pursuant to Section 26905. The Auditor's Office does not have the expertise to assess the soundness of the County's Investment Policy or express an opinion on it or the Treasurer's adherence to it. I declare under penalty of perjury that the foregoing is true and correct. Executed at Oroville, California this 28th day of January 2021. Graciela C. Gutierrez Auditor-Controller ________________________________________________________________________ Graciela C. Gutierrez, Auditor-Controller