Question
Checking account reconciliation Use Worksheet 4.1 . Carlos Perez has a NOW account at the First State Bank. His checkbook ledger lists the following checks:
-
Checking account reconciliation
Use Worksheet 4.1. Carlos Perez has a NOW account at the First State Bank. His checkbook ledger lists the following checks:
Check Numbers Amount 654 $206.05 658 55.44 662 103.00 668 98.59 670 6.04 671 50.03 672 24.90 673 32.43 674 44.50 675 30.00 676 30.00 677 111.23 678 38.04 679 97.99 680 486.34 681 43.50 682 74.52 683 98.69 Carlos also made the following withdrawals and deposits at an ATM near his home:
Date Amount Transaction 11/1 $50.00 withdrawal 11/2 $525.60 deposit 11/6 $100.00 deposit 11/14 $75.00 withdrawal 11/21 $525.53 deposit 11/24 $150.00 withdrawal 11/27 $225.00 withdrawal 11/30 $400.14 deposit Carlos' 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 $4.49, 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' checking account. Round your answers to the nearest cent. Enter all answers as positive values. Enter your answers in the given order of Check numbers.
CHECKING ACCOUNT RECONCILIATION For the Month of November, 2015 Accountholder Name(s): Carlos Perez Type of Account: NOW Account - First State Bank 1. Ending balance shown on bank statement $ fill in the blank 1 Add up checks and withdrawals still outstanding: Check Number or Date Amount fill in the blank 2 $ fill in the blank 3 fill in the blank 4 $ fill in the blank 5 fill in the blank 6 $ fill in the blank 7 fill in the blank 8 $ fill in the blank 9 fill in the blank 10 $ fill in the blank 11 fill in the blank 12 $ fill in the blank 13 fill in the blank 14 $ fill in the blank 15 fill in the blank 16 $ fill in the blank 17 ATM 11-24 $ fill in the blank 18 ATM 11-27 $ fill in the blank 19 TOTAL $ fill in the blank 20 2. Deduct total checks/withdrawals still outstanding from bank balance - $ fill in the blank 21 Add up deposits still outstanding: Date Amount 11/21/15 $ fill in the blank 22 11/30/15 $ fill in the blank 23 TOTAL $ fill in the blank 24 3. Add total deposits still outstanding to bank balance + $ fill in the blank 25 A. Adjusted Bank Balance $ fill in the blank 26 4. Ending balance shown in checkbook $ fill in the blank 27 5. Deduct any bank service charges for the period - $ fill in the blank 28 6. Add interest earned for the period + $ fill in the blank 29 B. New Checkbook Balance $ fill in the blank 30 Note: Your account is reconciled when line A equals line B.
Check My Work4 more Check My Work uses remaining.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started