Question: pleasr explain In this project you are the controller for Cal's Carwash and you will need to prepare the June 2020 bank reconciliation. In order





In this project you are the controller for Cal's Carwash and you will need to prepare the June 2020 bank reconciliation. In order to prepare a bank reconciliation you will need (and are supplied with), the June check register. The check register provides you with the beginning book balance (same as May's ending balance), a list of all 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 complete bank reconciliation (i.e., answers to this project). On the answer sheet you will: 1) Provide an adjusted book balance (show how you calculated this) 2) Provide an adjusted bank balance (show how you calculated this and of course these two amounts must equal, i.e., reconcile) 3) In the adjustments sections 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 outstanding checks and deposits in transit 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 Cal's Carwash and the journal entry to correct the error will be posted to miscellaneous expense. Cal's Car Wash Bank Reconciliation 05/31/2020 General Account Unadjusted book balance Bank Adjustments: Credit Memos Bank Adjustments: Debit Memos Adjusted book balance 475.670 6,000 -9,624 472,046 $385.432 138,055 -51.441 Balance per bank statement Add Deposits in transit Deduct OS Checks Adjustment to Balance Adjusted bank balance 472.046 Outstanding Checks Date 5/25/2020 5/28/2020 5/28/2020 5/29/2020 5/30/2020 5/31/2020 5/31/2020 3/31/2020 Check 3582 3583 3584 3585 3586 3587 3588 3589 Amount S 4.750 S 3.285 S 5.375 S 6,000 S 1.655 $12.480 $12.800 S 5.096 S51441 Danasisiminsit 5/30 2020 5/31/2020 S42.087 $95.968 S138055 Statement Period 6-1-2020 THRU 6-30-2020 Your Previous Balance Additions 7 Deposits 1 Other Credit Interest Earned this Period 25 Checks 5 Other Debits $385,432 +1,320,388 +3,000 +2,000 -1,386,009 -18.869 $13.05.942 Deductions Your Current Balance Deposits to Your Account Date Amount Date Amount 5/30/2020 5/31/2020 6/10/2020 6/15/2020 42,087 95,968 205,350 240.500 6/17/2020 6/20/2020 6/25/2020 280,123 270,526 185,834 Other Credits and Interest to Your Account Date Amount Description 6/15/2020 2,000 Interest 6/18/2020 3.000 CM-Brite Cleaners Checks Paid from Your Account Check 3586 3587 3582 3591 3598 3597 3599 3602 3590 3612 3593 3610 3585 Date 6/02/20 6/03/20 6/03/20 6/05/20 6/06/20 6/09/20 6/09/20 6/10/20 6/11/20 6/13/20 6/15/20 6/16/20 6/16/20 Amount 1,655 12,480 4.750 129,555 79,355 11.258 113,500 66,541 66,382 91,420 62,150 1,586 6.000 Check 3589 3603 3604 3609 3583 3584 3608 3611 3594 3595 3600 3605 3596 Date 6/17/20 6/18/20 6/19/20 6/20/20 6/22/20 6/24/20 6/24/20 6/21 20 6/28/20 8/28/20 6/30/20 6/30/20 6/30/20 Amount 5,096 12,185 64.149 15.840 3,285 5.375 63.125 19,245 50.250 48.000 42.235 190.450 220,142 Account 604-17-526-5 Page 2 of 2 Other Debits to Your Account Date Amount 6/13/20 6,185 6/15/20 2,525 6/15/20 1,485 6/22/20 3,485 6/28/20 5,216 Description Greenville Utilities Verizon AutoZone Wal-Mart AutoZone Balance By Date Date 6/5/20 6/6/20 6/9/20 6/10/20 6/11/20 Balance 365,350 350,310 275,800 295.900 240,306 Date 6/22/20 6/23/20 6/26/20 6/27/20 6/28/20 Balance 272.822 329,267 278,337 294,309 165,474 Cal's Carwash June 2020 Check Register $472.046 Check # 3590 3591 3592 3593 3594 3595 3596 3597 3598 3599 3600 3601 3602 3603 3604 3605 3606 3607 3608 3609 3610 3611 3612 3613 3614 3615 3616 Total Date 06/01/20 06/03/20 06/05/20 06/07/20 06/08/20 06/09/20 06/11/20 06/13/20 06/15/20 06/16/20 06/17/20 06/18/20 06/18/20 06/18/20 06/20/20 06/21/20 06/21/20 06/21/20 06/21/20 06/21/20 06/21/20 06/24/20 06/25/20 06/26/20 06/28/20 06/28/20 06/28/20 Beginning Cash Balance Amount 66,382 129.555 88,650 62,150 50,250 48,000 220,142 11.258 79.535 113,500 42.235 43,400 66,541 12,185 64,149 190,450 37.189 30,210 63,125 15,840 1.586 19,245 91.420 16.485 200.252 9.450 11.150 1784234 ho -1.784,334 Cal's Carwash June 2020 Deposit Ledger Date 6/8/20 6/15/20 6/17/20 6/20/20 6/25/20 6/27/20 6/30/20 Amount 205.350 240,500 280.123 270,526 185.834 64.795 135,019 1.382147 1.382.147 Ending Book Balance 69.859
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
