please explain steps

What information do you need? this is everything provided.

Dank Reconciliation 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.c., 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 Junc. 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. 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 -31.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 5/31/2020 Check 3582 3583 3584 3585 3586 3587 3588 3589 Amount $ 4.750 $ 3.285 $ 5,375 S 6,000 $ 1.655 S12.480 $12.800 $ 3.096 551 141 Deposits in Transit 5.30/2020 $42.087 5/31/2020 525.268 S3805 Account 604-17-526-5 Page 1 of 2 Cal's Carwash Greenville, NC 27858 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 $305 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 Pald from Your Account Check 3586 3587 3582 3591 3598 3597 3599 3602 3590 Date 5/02/20 5/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 5/15/20 5/16/20 8/16/20 Amount 1,655 12,480 4.750 129,555 79.355 11.258 113.500 66.541 B6.382 91,420 62.150 1.586 6 000 Check 3589 3603 3604 3609 3583 3584 3608 3611 3594 3595 3600 3605 3590 Dale 6/17/20 6/18/20 6/19/20 6/20/20 6/22/20 6/24/20 6/24/20 6/25/20 6/2820 5/28/20 B730/20 6/30/20 5/30/20 Amount 5,098 12.185 64.149 15,840 3.285 5.375 63.125 19.245 50,250 48.000 2.25 190.450 220, 142 3612 3593 3610 3585 First Citizens Bank Central Bank Operations. DACO2 PO Box 27131 Raleigh, NC 27611-7131 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 5/22/20 6/23/20 6/26/20 6/27/20 5/28/20 Balance 272,822 329.267 278,337 294,309 165,474 Cal's Carwash June 2020 Check Register 8472.048 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/18/20 06/17/20 06/18/20 08/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/28/20 08/28/20 06/28/20 06/28/20 Beginning Cash Balance Amount 86,382 129,555 88,650 62,150 50,250 48.000 220.142 11,258 79,535 113,500 42,235 43,400 56,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 113150 1704224 -1.784 334 Cal's Carwash June 2020 Deposit Ledger Dato 8 20 61520 61720 6 20:20 62520 62720 30/30 Amount 205,350 240. SON 280.133 270.526 185.834 61.795 15.019 LZ 111Z 69.859 Ending Book Balance Cal's Car Wash Bank Reconciliation June 2020 Amount General Account Unadjusted book balance Adhestment (See 1 Below) Adjustment (See 1 Below) Adjustment (See 1 Below) Adjusted book balance Amount Balance per bank statement Add Deposits in transit (See 2 Below) DeductOS Checks (See 3 Below) Adjusted bank balance KU) List and explain all adjustments to the General Account These will be explained under joumal entries on next pare 2) List all deposits in transit 9) List all Outstanding Checko Provide all joumal entries that must be posted after the reconciliation is completed. Account Debit Credit Dank Reconciliation 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.c., 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 Junc. 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. 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 -31.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 5/31/2020 Check 3582 3583 3584 3585 3586 3587 3588 3589 Amount $ 4.750 $ 3.285 $ 5,375 S 6,000 $ 1.655 S12.480 $12.800 $ 3.096 551 141 Deposits in Transit 5.30/2020 $42.087 5/31/2020 525.268 S3805 Account 604-17-526-5 Page 1 of 2 Cal's Carwash Greenville, NC 27858 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 $305 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 Pald from Your Account Check 3586 3587 3582 3591 3598 3597 3599 3602 3590 Date 5/02/20 5/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 5/15/20 5/16/20 8/16/20 Amount 1,655 12,480 4.750 129,555 79.355 11.258 113.500 66.541 B6.382 91,420 62.150 1.586 6 000 Check 3589 3603 3604 3609 3583 3584 3608 3611 3594 3595 3600 3605 3590 Dale 6/17/20 6/18/20 6/19/20 6/20/20 6/22/20 6/24/20 6/24/20 6/25/20 6/2820 5/28/20 B730/20 6/30/20 5/30/20 Amount 5,098 12.185 64.149 15,840 3.285 5.375 63.125 19.245 50,250 48.000 2.25 190.450 220, 142 3612 3593 3610 3585 First Citizens Bank Central Bank Operations. DACO2 PO Box 27131 Raleigh, NC 27611-7131 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 5/22/20 6/23/20 6/26/20 6/27/20 5/28/20 Balance 272,822 329.267 278,337 294,309 165,474 Cal's Carwash June 2020 Check Register 8472.048 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/18/20 06/17/20 06/18/20 08/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/28/20 08/28/20 06/28/20 06/28/20 Beginning Cash Balance Amount 86,382 129,555 88,650 62,150 50,250 48.000 220.142 11,258 79,535 113,500 42,235 43,400 56,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 113150 1704224 -1.784 334 Cal's Carwash June 2020 Deposit Ledger Dato 8 20 61520 61720 6 20:20 62520 62720 30/30 Amount 205,350 240. SON 280.133 270.526 185.834 61.795 15.019 LZ 111Z 69.859 Ending Book Balance Cal's Car Wash Bank Reconciliation June 2020 Amount General Account Unadjusted book balance Adhestment (See 1 Below) Adjustment (See 1 Below) Adjustment (See 1 Below) Adjusted book balance Amount Balance per bank statement Add Deposits in transit (See 2 Below) DeductOS Checks (See 3 Below) Adjusted bank balance KU) List and explain all adjustments to the General Account These will be explained under joumal entries on next pare 2) List all deposits in transit 9) List all Outstanding Checko Provide all joumal entries that must be posted after the reconciliation is completed. Account Debit Credit