Question: In this project you are the controller for Cal s Carwash and you will need to prepare the June 2 0 2 0 bank reconciliation.

In this project you are the controller for Cals Carwash and you will need to prepare
the June 2020 bank reconciliation. In order to prepare you will need (and are supplied
with). The June check register. You will need the check register so you will have the
ending cash balance for Cals Carwash. You will also have a list of all of the checks
written and deposits made during the month of June.
You will also need (and are provided) the May 2020 bank reconciliation. You will
need this so you will have a list of the outstanding checks and deposits in transit from
the month of May.
You are also provided the June 2020 bank statement.
You have a separate answer sheet where you are to provide the answers to this
project. On the answer sheet you will:
1) Provide an adjusted book balance
2) Provide an adjusted bank balance (and of course these two amounts must equal,
i.e., reconcile)
3) In the adjustments you will need to explain what your adjustments (if any) are.
You will not need to explain the outstanding checks and deposits in transit. However,
you will have to provide a detail listing of both for the month of June.
4) For every adjustment you make to the book balance you will need to record a
journal entry. The accounts you may use are cash, interest income, revenues, utility
expense, supplies, phone expense. Any errors that you encounter will be considered
to be errors made by Cals Carwash and the journal entry to correct the error will be
posted to miscellaneous expense.
05/31/2020
General Account
Unadjusted book balance 535,750
Bank Adjustments: Credit Memos 5,000
Bank Adjustments: Debit Memos -8,624
Adjusted book balance 532,126
Balance per bank statement $449,978
Add Deposits in transit 168,033
Deduct O/S Checks -85,885
Adjustment to Balance
Adjusted bank balance 532,126
Outstanding Checks
Date Check Amount
5/25/20203582 $4,850
5/28/20203583 $3.590
5/28/20203584 $10,850
5/29/20203585 $12,050
5/30/20203586 $1,585
5/31/20203587 $25,460
5/31/20203588 $14,850
5/31/20203589 $12,650
$85,885
Deposits in Transit
5/30/2020 $35,475
5/31/2020 $132,558
$168,033
Statement Period 6-1-2020 THRU 6-30-2020
Your Previous Balance $449,978
Additions 7 Deposits +1,325,258
1 Other Credit +4,000
Interest Earned this Period +1,500
Deductions 25 Checks -1,486,200
5 Other Debits -22,545
Your Current Balance $271,991
Deposits to Your Account
Date Amount Date Amount
5/30/202035,4756/17/2020268,123
5/31/2020132,5586/20/2020275,268
6/10/2020255,3506/25/2020108,384
6/15/2020250,100
Other Credits and Interest to Your Account
Date Amount Description
6/15/20201,500 Interest
6/18/20204,000 CM - Brite Cleaners
Checks Paid from Your Account
Check Date Amount Check Date Amount
35866/02/201,58535896/17/2012,650
35876/03/2025,46036036/18/2012,185
35826/03/204,85036046/19/2064,149
35916/05/20130,15536066/20/2035,189
35986/06/2078,36535836/22/203,590
35976/09/2011,16935846/24/2010,850
35996/09/20112,50036076/24/2032,198
36026/10/2065,15435926/25/2085,625
35906/11/2065,62035946/28/2050,250
36126/13/2083,12535956/28/2048,000
35936/15/2074,23536016/30/2042,154
36106/16/202,58636056/30/20194,582
35886/16/2014,85035966/30/20225,124
Other Debits to Your Account
Date Amount Description
6/13/207,352 Utilities
6/15/201,940 Verizon
6/15/202,452 AutoZone
6/22/206,485 Wal-Mart
6/28/204,316 Autozone
Balance By Date
Date Balance Date Balance
6/5/20324,2606/22/20272,822
6/6/20320,7286/23/20329,267
6/9/20355,4356/26/20278,337
6/10/20286,4216/27/20373,801
6/11/20216,7876/28/20311,512
June 2020 Check Register
Beginning Cash Balance $532,126
Check # Date Amount
359006/01/2065,620
359106/03/20130,155
359206/05/2085,625
359306/07/2074,235
359406/08/2050,250
359506/09/2048,000
359606/11/20225,124
359706/13/2011,169
359806/15/2078,365
359

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!