Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

  1. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Finesse An Accounting Guide For Entrepreneurs

Authors: TaShara Ramese

1st Edition

1732510903, 978-1732510906

More Books

Students also viewed these Accounting questions