Nicolas Cruz has a NOW account at the Second National Bank. His checkbook ledger lists the following checks: Check Check Check Number Number Number Amount Amount Amount 654 206.05 672 24.90 678 38.04 55.22 673 32.45 679 97.99 103.00 674 44.50 680 486.70 99.00 675 30.00 681 43.50 6.10 676 30.00 682 75.00 671 50.25 677 111.23 683 98.50 Nicolas also made the following withdrawals and deposits at an ATM near his home: Date Amount Transaction $50.00 ATM Withdrawal 658 662 668 670 11/1 671 50.25 677 111.23 683 98.50 Nicolas also made the following withdrawals and deposits at an ATM near his home: Date Amount Transaction 11/1 $50.00 ATM Withdrawal 525.60 Deposit 100.00 Deposit 75.00 ATM Withdrawal 525.60 Deposit 150.00 ATM Withdrawal 225.00 ATM Withdrawal 400.00 Deposit 11/2 11/6 11/14 11/21 11/24 11/27 11/30 2 525.60 Deposit 150.00 ATM Withdrawal 225.00 ATM Withdrawal 11/30 400.00 Deposit Nicolas'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.28, 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 Carlos's checking account. 11/21 11/24 11/27 Worksheet 4.1 For the month of Accountholder Name(s Type of Account CHECKING ACCOUNT RECONCILIATION 20 1. Ending balance shown on bank statement Add up checks and withdrawals still outstanding: Check Check Number Number: or Date Amount or Date TOTALES Amount S 2. Deduct total checks/withdrawals still Add up deposits still outstanding: Date Amount 3. Add total deposits still outstanding A Adjusted Bank Balance (1-2+3) TOTAL $ Date TOTAL $ Amount ( S - ZO TOTAL $ 2. Deduct total checks/withdrawals still Add up deposits still outstanding: Date Amount TOTAL $ 3. Add total deposits still outstanding A Adjusted Bank Balance (1-2+3) 4. Ending balance shown in checkbook 5. Deduct any bank service charges for the period Date Amount S $ $ 200 Date Amount TOTAL $ 3. Add total deposits still outstanding A Adjusted Bank Balance (1-2+3) 4. Ending balance shown in checkbook 5. Deduct any bank service charges for the period 6. Add interest earned for the period B New Checkbook Balance (4-5+6) S Note: 1. Enter data in blue area only. Note 2. Your account is reconciled when line A equals line B. Date Amount +$ S S $ $ - 20 Nicolas Cruz has a NOW account at the Second National Bank. His checkbook ledger lists the following checks: Check Check Check Number Number Number Amount Amount Amount 654 206.05 672 24.90 678 38.04 55.22 673 32.45 679 97.99 103.00 674 44.50 680 486.70 99.00 675 30.00 681 43.50 6.10 676 30.00 682 75.00 671 50.25 677 111.23 683 98.50 Nicolas also made the following withdrawals and deposits at an ATM near his home: Date Amount Transaction $50.00 ATM Withdrawal 658 662 668 670 11/1 671 50.25 677 111.23 683 98.50 Nicolas also made the following withdrawals and deposits at an ATM near his home: Date Amount Transaction 11/1 $50.00 ATM Withdrawal 525.60 Deposit 100.00 Deposit 75.00 ATM Withdrawal 525.60 Deposit 150.00 ATM Withdrawal 225.00 ATM Withdrawal 400.00 Deposit 11/2 11/6 11/14 11/21 11/24 11/27 11/30 2 525.60 Deposit 150.00 ATM Withdrawal 225.00 ATM Withdrawal 11/30 400.00 Deposit Nicolas'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.28, 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 Carlos's checking account. 11/21 11/24 11/27 Worksheet 4.1 For the month of Accountholder Name(s Type of Account CHECKING ACCOUNT RECONCILIATION 20 1. Ending balance shown on bank statement Add up checks and withdrawals still outstanding: Check Check Number Number: or Date Amount or Date TOTALES Amount S 2. Deduct total checks/withdrawals still Add up deposits still outstanding: Date Amount 3. Add total deposits still outstanding A Adjusted Bank Balance (1-2+3) TOTAL $ Date TOTAL $ Amount ( S - ZO TOTAL $ 2. Deduct total checks/withdrawals still Add up deposits still outstanding: Date Amount TOTAL $ 3. Add total deposits still outstanding A Adjusted Bank Balance (1-2+3) 4. Ending balance shown in checkbook 5. Deduct any bank service charges for the period Date Amount S $ $ 200 Date Amount TOTAL $ 3. Add total deposits still outstanding A Adjusted Bank Balance (1-2+3) 4. Ending balance shown in checkbook 5. Deduct any bank service charges for the period 6. Add interest earned for the period B New Checkbook Balance (4-5+6) S Note: 1. Enter data in blue area only. Note 2. Your account is reconciled when line A equals line B. Date Amount +$ S S $ $ - 20