Use Worksheet. Felipe Aguilar has a NOW account at the Second State Bank. His checkbook ledger lists the following checks:

Check Number                                Amount
654 .................................................. $206.05
658 .................................................. 55.22
662 ................................................. 103.00
668 ................................................. 99.00
670 ................................................. 6.10
671 ................................................. 50.25
672 ................................................. 24.90
673 ................................................. 32.45
674 ................................................. 44.50
675 ................................................. 30.00
676 ................................................. 30.00
677 ................................................. 111.23
678 ................................................. 38.04
679 ................................................. 97.99
680 ................................................. 486.70
681 ................................................. 43.50
682 ................................................. 75.00
683 ................................................. 98.50

 

Felipe's checkbook ledger shows an ending balance of $286.54. He has just received his bank statement for the month of November. It shows an ending balance of $622.44; it also shows that he earned interest for November of $3.22, had a check service charge of $8 for the month, and had another $12 charge for a returned check. His bank statement indicates the following checks have cleared: 654, 662, 672, 674, 675, 676, 677, 678, 679, and 681. ATM withdrawals on 11/1 and 11/14 and deposits on 11/2 and 11/6 have cleared; no other checks or ATM activities are listed on his statement, so anything remaining should be treated as outstanding. Use a checking account reconciliation form like the one in Worksheet 4.1 to reconcile Felipe's checking account.

Date 11/1 11/2 11/6 11/14 11/21 11/24 11/27 11/30 Amount $50.00 $525.60 $100.00 $75.00 $525.60 $150.00 $225.00 $400.00 Transaction Withdrawal Deposit Deposit Withdrawal Deposit Withdrawal Withdrawal Deposit