Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

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

From Zero To Zen Secret Keys To Nurturing Your Numbers And Finding Financial Flow

Authors: Liz Lajoie

1st Edition

1683507045, 978-1683507048

More Books

Students also viewed these Accounting questions

Question

=+52-1 Describe the social tasks and challenges of adolescence.

Answered: 1 week ago

Question

How would you assess the value of an approach like this?

Answered: 1 week ago