Mrs. Jones has received her bank statement and is ready to reconcile it with her checkbook register. Fill out the reconciliation
worksheet for Mrs. Jones using the data from her bank statement and checkbook register. Assume all transactions on previous pages have already cleared. Great Bank of Home and Work KeepItSimple™ Statement for February 2010 Beginning balance (01/05/2010): $2340.00 Ending balance (02/04/2010): $1864.16 Total of credits: $0.00 Total of debits: $475.84 Date cleared - 01/05/2010 Description - Debit card purchase from XYZ Supermarket and Deli Limited Amount - 145.44 Date cleared - 02/04/2010 Description - Check 1015, Bis Insurance of North America Amount - $320.40 Date cleared - 02/04/2010 Description - Monthly service fee Amount - $10.00 Reconciliation Worksheet Amount 1. Enter the statement closing balance. $ 2. Enter the sum of any outstanding deposits or credits. $ 3. Add lines 1 and 2. $ 4. Enter the sum of any outstanding checks or debits. $ 5. Subtract line 4 from line 3. $ 6. Enter your checkbook balance. $ Note: Lines 5 and 6 should be equal at the end of the reconciliation. Mrs. Jones’s checkbook register: Date Num Payee Payment Clr Deposit Balance 1/1/2010 Balance forward 2,340.00 2,340.00 1/5/2010 Debit XYZ Supermarket 145.44 2194.56 2/1/2010 1014 Rent 600.00 1594.56 2/1/2010 1015 Bis Insurance Company 320.40 1274.16 Consider what must be done, if anything, in order to finish the reconciliation process. a. Line 6 is $10.00 higher than line 5; look back at the statement to find the discrepancy. b. Any transaction that appears on the register must still be added to the bank statement. c. Add lines 5 and 6 together. d. The rent of $600 is in your checkbook but not on your bank statement.
