Spreadsheet: 220696d1363237701-sum-if-formula-financial-accounting-columbia-cu-checking-working-correctly
Sheet: Transactions

 | 2011 Final Montgomery Accounting-Joint Account Transactions
 | Bank Name: |  | Columbia Credit Union |  |  |  |  |  | Account: | Account #: |  | xxxx
 | Accounts Reviewed: |  | [NAME] 7 |  |  |  |  | Account Holder: |  | Account Holder: |  | xxxx
 | Account Timeperiod: |  | January 1, 2011 - December 31, 2011
Account | Date | Category | Payee | Check # | Payment Amount | Deposit Amount | Amounts for Report | Cleared Payment | Cleared Deposit | Account Balance | Check Memo
 | 0/01/11 | AV Starting Account Balance | Deposit |  |  | 4.38
 | 2011-01-03 00:00:00 | AV ACH Qwest Pension | Pension Deposit |  |  | 1060.62
 | 2011-01-03 00:00:00 | AV ACH Social Security | SSA Deposit |  |  | 921
 | 2011-01-04 00:00:00 | AP Check Withdrawals | HSBC Card |  | 350
 | 2011-01-04 00:00:00 | AP Cash Withdrawals |  | 5106 | 200
 | 2011-01-05 00:00:00 | AP Check Withdrawals | Additional Self-Storage | 5105 | 126
 | 2011-01-06 00:00:00 | [NAME] | Transfer from AV Savings |  |  | 600
 | 2011-01-06 00:00:00 | [NAME] | Clark County PUD | 5103 | 163 |  |  |  |  |  | 155-0585-002-2
 | 2011-01-07 00:00:00 | [NAME] | Comcast | 5104 | 120.12 |  |  |  |  |  | 8778-[PHONE]
 | 2011-01-07 00:00:00 | [NAME] | Castle Quality Construction | 5107 | 600 |  |  |  |  |  | Heating-Air
 | 2011-01-10 00:00:00 | Household ACH Withdrawals | Safeco Insurance |  | 167.63
 | 2011-01-27 00:00:00 | AP Cash Withdrawals |  | 5111 | 100
 | 2011-01-27 00:00:00 | Household ACH Withdrawals | Safeco Insurance |  | 77.58
 | 2011-01-27 00:00:00 | Unknown Check Withdrawals | Senior [NAME] | 5110 | 40
 | 2011-01-27 00:00:00 | [NAME] | Comcast | 5109 | 250 |  |  |  |  |  | 8778-[PHONE]
 | 2011-01-27 00:00:00 | Unknown Check Withdrawals | The Columbian | 5108 | 120 |  |  |  |  |  | 48537
 | 2011-02-01 00:00:00 | AV ACH Qwest Pension | Pension Deposit |  |  | 1028.13
 | 2011-02-03 00:00:00 | AV ACH Social Security | SSA Deposit |  |  | 921
 | 2011-02-04 00:00:00 | AV US Treasury Tax Refund | Tax Refund Deposit |  |  | 660
 | 2011-02-10 00:00:00 | Household ACH Withdrawals | Safeco Insurance |  | 167.63
 | 2011-03-01 00:00:00 | AV ACH Qwest Pension | Pension Deposit |  |  | 1028.13
 | 2011-03-03 00:00:00 | AV ACH Social Security | SSA Deposit |  |  | 921
 | 2011-03-07 00:00:00 | AP Check Withdrawals | Clark County Treasurer's Office |  | 2063.92
 | 2011-03-14 00:00:00 | AV Check Deposits | Safeco Insurance Deposit |  |  | 287.48
 | 2011-03-23 00:00:00 | AP Check Withdrawals |  |  | 2500
 | 2011-03-24 00:00:00 | AP Check Withdrawals | Department of Licensing |  | 48.75
 | 2011-03-28 00:00:00 | AP Check Withdrawals | Venitian Blind Repair |  | 191.51
 | 2011-04-01 00:00:00 | AV ACH Qwest Pension | Pension Deposit |  |  | 1028.13
 | 2011-04-01 00:00:00 | AV ACH Social Security | SSA Deposit |  |  | 921
 | 2011-04-07 00:00:00 | Unknown Check Withdrawals |  | 5116 | 163
 | 2011-04-08 00:00:00 | [NAME] | [NAME] | 5118 | 64.92
 | 2011-04-08 00:00:00 | [NAME] | City of Vancouver | 5120 | 39.06
 | 2011-04-11 00:00:00 | [NAME] | Comcast | 5117 | 111.35
 | 2011-04-19 00:00:00 | AP Check Withdrawals |  | 5122 | 1200
 | 2011-04-29 00:00:00 | [NAME] | [NAME] | 5124 | 86.56
 | 2011-05-02 00:00:00 | AV ACH Qwest Pension | Pension Deposit |  |  | 1028.13
 | 2011-05-02 00:00:00 | Unknown Check Withdrawals |  | 5123 | 250
 | 2011-05-03 00:00:00 | AV ACH Social Security | SSA Deposit |  |  | 921
 | 2011-05-10 00:00:00 | AP Check Withdrawals |  | 5125 | 2000 |  |  |  |  |  | loan repayment
 | 2011-06-01 00:00:00 | AV ACH Qwest Pension | Pension Deposit |  |  | 1028.13
 | 2011-06-03 00:00:00 | AV ACH Social Security | SSA Deposit |  |  | 921
 | 2011-06-07 00:00:00 | AP ACH Withdrawals | HSBC Card |  | 1500
 | 2011-06-13 00:00:00 | AP ACH Withdrawals | HSBC Card |  | 500
 | 2011-07-01 00:00:00 | AV ACH Qwest Pension | Pension Deposit |  |  | 1028.13
 | 2011-07-01 00:00:00 | AV ACH Social Security | SSA Deposit |  |  | 921
 | 2011-07-06 00:00:00 | AP ACH Withdrawals | HSBC Card |  | 1800
 | 2011-07-13 00:00:00 | [NAME] | [NAME] |  | 86.56
 | 2011-07-14 00:00:00 | [NAME] | Comcast |  | 111.37 |  |  |  |  |  | 8778-[PHONE]
 | 2011-08-01 00:00:00 | AV ACH Qwest Pension | Pension Deposit |  |  | 1028.13
 | 2011-08-03 00:00:00 | AV ACH Social Security | SSA Deposit |  |  | 921
 | 2011-08-08 00:00:00 | AP ACH Withdrawals | HSBC Card |  | 750
 | 2011-08-08 00:00:00 | [NAME] | Clark County PUD | 5153 | 163 |  |  |  |  |  | 155-0585-002-2
 | 2011-08-08 00:00:00 | Unknown Check Withdrawals | The Columbian | 5156 | 300 |  |  |  |  |  | 48537
 | 2011-08-09 00:00:00 | [NAME] | [NAME] | 5154 | 86.56
 | 2011-08-09 00:00:00 | [NAME] | City of Vancouver | 5157 | 40.53
 | 2011-08-10 00:00:00 | AP ACH Withdrawals | HSBC Card |  | 500
 | 2011-08-10 00:00:00 | [NAME] | Comcast | 5155 | 120.46
 | 2011-08-28 00:00:00 | [NAME] | Transfer from AV Savings |  |  | 30
 | 2011-09-01 00:00:00 | AV ACH Qwest Pension | Pension Deposit |  |  | 1028.13
 | 2011-09-02 00:00:00 | AV ACH Social Security | SSA Deposit |  |  | 921
 | 2011-09-02 00:00:00 | [NAME] | Century Link | 5158 | 45 |  |  |  |  |  | (360) 892-1766  061R
 | 2011-09-07 00:00:00 | [NAME] | [NAME] | 5163 | 108.2
 | 2011-09-08 00:00:00 | [NAME] | Comcast |  | 360.46 |  |  |  |  |  | 8778-[PHONE]
 | 2011-09-08 00:00:00 | [NAME] | Clark County PUD | 5160 | 163 |  |  |  |  |  | 155-0585-002-2
 | 2011-09-09 00:00:00 | Unknown Check Withdrawals | Dr. [NAME] | 5162 | 249
 | 2011-09-14 00:00:00 | Unknown Check Withdrawals | National Geographic | 5161 | 12
 | 2011-09-21 00:00:00 | AP ACH Withdrawals | HSBC Card | 400 | 400
 | 2011-09-26 00:00:00 | AP ACH Withdrawals | HSBC Card | 450 | 450
 | 2011-10-03 00:00:00 | AV ACH Qwest Pension | Pension Deposit |  |  | 1028.13
 | 2011-10-03 00:00:00 | AV ACH Social Security | SSA Deposit |  |  | 921
 | 2011-10-05 00:00:00 | AP ACH Withdrawals | PNC Bank |  | 200
 | 2011-10-05 00:00:00 | AP ACH Withdrawals | HSBC Card |  | 700
 | 2011-10-05 00:00:00 | [NAME] | City of Vancouver |  | 200 |  |  |  |  |  | [PHONE]-00
 | 2011-10-06 00:00:00 | [NAME] | Clark County PUD |  | 163 |  |  |  |  |  | 155-0585-002-2
 | 2011-10-07 00:00:00 | AP Check Withdrawals | Chevron Credit Card | 5167 | 150
 | 2011-10-07 00:00:00 | [NAME] | [NAME] | 5166 | 86.56
 | 2011-10-07 00:00:00 | [NAME] | Comcast | 5168 | 200 |  |  |  |  |  | 8778-[PHONE]
 | 2011-10-12 00:00:00 | AP Check Withdrawals | Additional Self-Storage | 5169 | 252 |  |  |  |  |  | Storage 219
 | 2011-10-17 00:00:00 | AP ACH Withdrawals | HSBC Card |  | 250
 | 2011-10-17 00:00:00 | [NAME] | Transfer from AV Savings |  |  | 12.79
 | 2011-10-17 00:00:00 | Account Overdraft Fees | Overdraft Fees |  | 28
 | 2011-11-01 00:00:00 | AV ACH Qwest Pension | Pension Deposit |  |  | 1028.13
 | 2011-11-03 00:00:00 | AV ACH Social Security | SSA Deposit |  |  | 921
 | 2011-11-04 00:00:00 | AP ACH Withdrawals | HSBC Card |  | 400
 | 2011-11-07 00:00:00 | AP ACH Withdrawals | Chevron Credit Card |  | 381.82
 | 2011-11-07 00:00:00 | AP ACH Withdrawals | PNC Bank |  | 169.84
 | 2011-11-09 00:00:00 | AP ACH Withdrawals | HSBC Card |  | 230
 | 2011-11-12 00:00:00 | AP Transfer Withdrawals | Transfer to AP Account |  | 500
 | 2011-11-14 00:00:00 | AP ACH Withdrawals | HSBC Card |  | 250.18
 | 2011-11-14 00:00:00 | Account Overdraft Fees | Overdraft Fees |  | 28
 | 2011-11-14 00:00:00 | [NAME] | Transfer from AV Savings |  |  | 100
 | 2011-11-15 00:00:00 | AP Cash Withdrawals |  | 2441 | 180
 | 2011-11-15 00:00:00 | Account Overdraft Fees | Overdraft Fees |  | 28
 | 2011-11-21 00:00:00 | AP Cash Deposits | AP Deposit |  |  | 200
 | 2011-12-01 00:00:00 | AV ACH Qwest Pension | Pension Deposit |  |  | 1028.13
 | 2011-12-02 00:00:00 | AV ACH Social Security | SSA Deposit |  |  | 921
 | 2011-12-03 00:00:00 | [NAME] | Transfer to AV Savings |  | 72.13
 | 2011-12-05 00:00:00 | AP ACH Withdrawals | HSBC Card |  | 364.31
 | 2011-12-06 00:00:00 | AP ACH Withdrawals | Chevron Credit Card |  | 435.69
 | 2011-12-06 00:00:00 | AP ACH Withdrawals | PNC Bank Card |  | 200
 | 2011-12-06 00:00:00 | [NAME] | [NAME] | 5171 | 86.56
 | 2011-12-06 00:00:00 | AP Cash Withdrawals |  | 5173 | 100
 | 2011-12-06 00:00:00 | AP Check Withdrawals | Additional Self-Storage | 5172 | 252
 | 2011-12-12 00:00:00 | AP ACH Withdrawals | HSBC Card |  | 450