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