HomeMy WebLinkAboutRevised 2006 COP Bank Account ReconciliationButte County Treasurer
Monthly Investment Transaction Reporting
Funds Under Management of Trustees
Sources: 1) Wells Fargo Bank Statements, 2) Butte County Administration Office
Wells Fargo Bank, Trustee
2004 Pension Obligation Bonds
Transaction Activity
Total Cash With
Transaction & Month End Date XXXX1106 XXXX1109 XXXX1140 XXXX1141 XXXX1142 XXXX1301 XXXX1305 XXXX1307 Fiscal Agent
1/31/2016 Fair Value 71.86 2,641.09 0.00 23.84 1,041,094.42 12,015.47 902,908.74 0.00 1,958,755.42
Interest Earned 0.02 0.26 0.01 0.03 2.19 232.41 234.92
CSCDA Issuer Fees 0.00
Wire Transfer From Butte County 0.00
Transfer from XXXX1301 0.00
Transfer To XXXX1301 (12,420.17)(12,420.17)
Transfer To XXXX1142 0.00
Principal Paid to Bondholder 0.00
Interest Paid to Bondholder (12,015.47)(12,015.47)
Transfer from XXXX1305 12,420.17 12,420.17
2/29/2016 Fair Value 71.88 2,641.35 0.00 23.85 1,041,094.45 12,422.36 890,720.98 0.00 1,946,974.87
Interest Earned 0.02 0.28 0.01 0.03 0.71 246.93 247.98
CSCDA Issuer Fees 0.00
Wire Transfer From Butte County 0.00
Transfer from XXXX1301 0.00
Transfer To XXXX1301 (13,503.28)(13,503.28)
Transfer To XXXX1142 0.00
Principal Paid to Bondholder 0.00
Interest Paid to Bondholder (12,422.36)(12,422.36)
Transfer from XXXX1305 13,503.28 13,503.28
3/31/2016 Fair Value 71.90 2,641.63 0.00 23.86 1,041,094.48 13,503.99 877,464.63 0.00 1,934,800.49
Interest Earned 0.02 2.20 0.01 0.03 0.39 271.74 274.39
CSCDA Issuer Fees 0.00
Wire Transfer From Butte County 0.00
Transfer from XXXX1301 0.00
Transfer To XXXX1301 (13,421.31)(13,421.31)
Transfer To XXXX1142 0.00
Principal Paid to Bondholder 0.00
Interest Paid to Bondholder (13,503.99)(13,503.99)
Transfer from XXXX1305 13,421.31 13,421.31
4/30/2016 Fair Value 71.92 2,643.83 0.00 23.87 1,041,094.51 13,421.70 864,315.06 0.00 1,921,570.89
Interest Earned 0.02 0.30 0.01 0.03 0.65 259.78 260.79
CSCDA Issuer Fees 0.00
Wire Transfer From Butte County 0.00
Transfer To XXXX1307 (395,000.00)(395,000.00)
Transfer To XXXX1301 (13,073.03)(13,073.03)
Transfer To XXXX1140 (200,000.00)(200,000.00)
Transfer To XXXX1141 (840,542.32)(840,542.32)
Principal Paid to Bondholder 0.00
Interest Paid to Bondholder (13,421.70)(13,421.70)
Transfer from XXXX1142 200,000.00 840,542.32 1,040,542.32
Transfer from XXXX1305 13,073.03 395,000.00 408,073.03
5/31/2016 Fair Value 71.94 2,644.13 200,000.00 840,566.20 552.22 13,073.68 456,501.81 395,000.00 1,908,409.98
Interest Earned 0.02 0.30 11.54 56.71 0.02 0.76 241.54 18.95 329.84
CSCDA Issuer Fees 0.00
Wire Transfer From Butte County 0.00
Transfer To XXXX1307 0.00
Transfer To XXXX1301 (13,139.73)(13,139.73)
Transfer To XXXX1140 0.00
Transfer To XXXX1141 0.00
Transfer To XXXX1142 (71.96) (71.96)
Principal Paid to Bondholder (200,000.00)(395,000.00)(595,000.00)
Interest Paid to Bondholder (840,566.20)(13,073.68)(853,639.88)
Transfer from XXXX1106 71.96 71.96
Transfer from XXXX1305 13,139.73 13,139.73
6/30/2016 Fair Value 0.00 2,644.43 11.54 56.71 624.20 13,140.49 443,603.62 18.95 460,099.94
Interest Earned 2.52 0.02 0.52 131.95 0.01 135.02
CSCDA Issuer Fees 0.00
Transfer To XXXX1307 0.00
Transfer To XXXX1301 (13,755.65)(13,755.65)
Transfer To XXXX1140 0.00
Transfer To XXXX1141 0.00
Transfer To XXXX1142 0.00
Principal Paid to Bondholder 0.00
Interest Paid to Bondholder (13,140.49)(13,140.49)
Transfer from XXXX1106 0.00
Transfer from XXXX1305 13,755.65 13,755.65
7/31/2016 Fair Value 0.00 2,646.95 11.54 56.73 624.20 13,756.17 429,979.92 18.96 447,094.47
Series A Series B
Butte County Treasurer
Monthly Investment Transaction Reports
Investments Under Management of Trustees
Sources: 1) Wells Fargo Bank , 2) Butte County Administration Office
Wells Fargo Bank, Trustee
2006 Certificates of Participation
Transaction Activity
Base Rental
Reserve Fund Payment Fund Expense Fund Escrow Fund Total With
Date Transaction XXXX0800 XXXX0801 XXXX0802 XXXX1300 Fiscal Agent
1/31/2016 Fair Value 1,221,067.90 14,850.53 2,231.32 0.00 1,238,149.75
Transfer to another account (0.02)(0.02)
Transfer from another account 0.02 0.02
Transfer from another account 0.00
ACH TRF 907064 0.00
Interest Earned 0.14 0.19 0.02 0.35
Interest Paid to Bondholder 0.00
Principal Paid to Bondholder 0.00
Unrealized Gain/Loss 3,474.90 3,474.90
2/29/2016 Fair Value 1,224,542.94 14,850.74 2,231.32 0.00 1,241,625.00
Transfer to another account (0.02)(0.02)
Transfer from another account 0.02 0.02
Transfer from another account 0.00
ACH TRF 907064 0.00
Interest Earned 0.09 0.12 0.02 0.23
Interest Paid to Bondholder 0.00
Principal Paid to Bondholder 0.00
Unrealized Gain/Loss 3,357.90 3,357.90
3/31/2016 Fair Value 1,227,900.93 14,850.88 2,231.32 0.00 1,244,983.13
Transfer to another account (0.02)(0.02)
Transfer from another account 0.02 0.02
Transfer from another account 0.00
ACH TRF 907064 0.00
Interest Earned 0.10 0.13 0.02 0.25
Interest Paid to Bondholder 0.00
Principal Paid to Bondholder 0.00
Unrealized Gain/Loss (2,632.50)(2,632.50)
4/30/2016 Fair Value 1,225,268.53 14,851.03 2,231.32 0.00 1,242,350.88
`Transfer to another account (0.02)(0.02)
Transfer from another account 0.02 0.02
Transfer from another account 0.00
ACH TRF 907064 0.00
Interest Earned 0.09 0.12 0.02 0.23
Interest Paid to Bondholder 0.00
Principal Paid to Bondholder 0.00
Unrealized Gain/Loss 6,838.65 6,838.65
5/31/2016 Fair Value 1,232,107.27 14,851.17 2,231.32 0.00 1,249,189.76
`Transfer to another account (0.02)(0.02)
Transfer from another account 0.02 0.02
Transfer from another account 0.00
ACH TRF FOR DEBIT SERVICE 1,081,650.00 1,081,650.00
Interest Earned 4.44 0.13 0.02 4.59
Interest Paid to Bondholder 0.00
Principal Paid to Bondholder 0.00
Unrealized Gain/Loss 0.00
6/30/2016 Fair Value 1,232,111.71 1,096,501.32 2,231.32 0.00 2,330,844.35
`Transfer to another account (0.02)(0.02)
Transfer from acct. XXXX0802 2,231.32 2,231.32
Refunding proceeds from Capital One 4,155,266.09 4,155,266.09
Transfer from another account 0.02 0.02
Transfer from acct. XXXX0800 1,220,807.25 1,220,807.25
Transfer from acct. XXXX0801 14,851.17 14,851.17
ACH TRF FOR DEBIT SERVICE 0.00
Interest Earned 10.13 4.86 0.02 15.01
Interest Paid to Bondholder (131,650.00)(131,650.00)
Principal Paid to Bondholder (950,000.00)(950,000.00)
TRANFSER TO REFUNDING ESCROW ACCOUNT (1,220,807.25)(2,231.32)(1,223,038.57)
TRANSFER TO REFUNDING ESCROW ACCOUNT (14,851.17)(14,851.17)
7/31/2016 Fair Value 11,314.59 5.03 0.00 5,393,155.83 5,404,475.45
Butte County Treasurer
Monthly Investment Transaction Reports
Investments Under Management of Trustees
Source: Umpqua Bank Statement
York Risk Services Group, Claims Administrator
Umpqua Bank
WORKERS' COMPENSATION
Account # XXXXX2601
Transaction Activity - Current Month
Beginning Balance - 6/30/2016 187,014.72
Deposits/Additions
7/1/16 75,465.62
7/12/16 74,968.37
7/18/16 40,834.00
7/18/16 2,295.00
7/18/16 576.35
7/22/16 130,424.84
Withdrawals/Subtractions
Disbursements Checks Paid (309,371.20)
Maintenance Fee 7/20/16 (117.11)
Ending Balance - 7/31/2016 202,090.59