Prepare Cookie Creations bank reconciliation for June 30

Cookie Creations Natalie decides that she cannot afford to hire John to do her accounting. One way that she can ensure that her cash account does not have any errors and is accurate and up- to-date is to prepare a bank reconciliation at the end of each month. Natalie would like you to help her. She asks you to prepare a bank reconciliation for June 2020 using the following information. GENERAL LEDGER-COOKIE CREATIONS Cash Ref. Explanation Debit Credit Balance Balance 750 Date 2020 June 1 1 3 3 8 9 13 20 28 28 Check #600 Check #601 Check #602 625 95 56 2,657 3,407 2,782 2,687 2,631 3,681 3,256 3,411 3,114 3,224 1,050 Check #603 425 155 Check #604 297 110 Date May 31 June 1 6 6 8 9 10 10 14 20 23 28 30 PREMIER BANK Statement of Account-Cookie Creations June 30, 2020 Explanation Checks and Deposits Balance Deposit 750 Check #600 625 Check #601 95 Check #602 56 Deposit 1,050 NSF check 100 NSF - fee 35 Check #603 452 Deposit 125 EFT-Telus 85 Check #599 361 Bank 13 charges Balance 3,256 4,066 3,381 3,286 3,230 4,280 4,145 3,693 3,818 3,733 3,372 3,359 Additional information: 1. On May 31, there were two outstanding checks: #595 for $238 and #599 for $361. 2. Premier Bank made a posting error to the bank statement: check #603 was issued for $425, not $452. 3. The deposit made on June 20 was for $125 that Natalie received for teaching a class. Natalie made an error in recording this transaction. 4. The electronic funds transfer (EFT) was for Natalie's cellphone use. Remember that she uses this phone only for business. 5. The NSF check was from Ron Black. Natalie received this check for teaching a class to Ron's children. Natalie contacted Ron, and he assured her that she will receive a check in the mail for the outstanding amount of the invoice and the NSF bank charge. Instructions (a) Prepare Cookie Creations' bank reconciliation for June 30