Question 4 of 6 - / 16.7 TIL 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 2023 using the following information. GENERAL LEDGER-COOKIE CREATIONS Cash Date Explanation Ref Debit Credit Balance 2023 June 1 Balance 2,261 1 640 2,901 3 Check #600 530 2,371 3 Check #601 81 2,290 8 Check #602 50 2,240 9 895 3,135 13 Check #603 378 2,757 20 134 2,891 20 134 2,891 28 Check #604 253 2,638 28 93 2,731 PREMIER BANK Statement of Account-Cookie Creations June 30, 2023 Date Explanation Checks and Other Debits Deposits Balance May 31 Balance 2,770 June 1 Deposit 640 3.410 6 Check #600 530 2,880 6 Check #601 81 2,799 8 Check #602 50 2.749 9 Deposit 895 3,644 10 NSF check 85 3,559 10 NSF-fee 33 3,526 10 NSF-fee 33 3,526 14 Check #603 387 3,139 20 Deposit 105 3,244 23 EFT-Telus 73 3,171 28 Check #599 309 2,862 30 Bank charges 15 2,847 Additional information: 1. On May 31, there were two outstanding checks: #595 for $200 and #599 for $309. 2. Premier Bank made a posting error to the bank statement: check #603 was issued for $378, not $387. 3. The deposit made on June 20 was for $105 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. Prepare Cookie Creations' bank reconciliation for June 30. (List items that increase cash balance first. Reconcile cash balance per bank first.) COOKIE CREATIONS Bank Reconciliation June 30, 2023 Cash Balance Per Bank Statement $ Add : $ Less : Outstanding Checks Adjusted Cash Balance Per Bank $ Cash Balance Per Books $ Less : Service Charge $ Error in Deposit June 20th EFT-Telus NSF Check Adjusted Cash Balance Per Books $ Prepare any necessary journal entries at June 30. (Credit account titles are automatically indented when amount is entered. Do not indent manually.) Date Account Titles and Explanation Debit Credit June 30 (To record bank charges.) June 30 (To record error in deposit made on June 20.) June 30 (To record EFT charges.) (To record EFT charges.) June 30 (To record NSF check.) e Textbook and Media List of Accounts If a balance sheet is prepared for Cookie Creations at June 30, what balance will be reported as cash? If a balance sheet were prepared, cash at June 30, 2023 would be $ e Textbook and Media
