need help with C

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 Date Explanation Ref Debit Credit Balance 2020 2,657 June 1 Balance 1 750 3407 3 Check 600 625 2.782 3 Check 601 95 2.687 8 Check 602 56 2631 9 1050 3.681 13 Check 603 425 3.256 20 155 3,411 28 Check 8604 297 3,114 28 110 3.224 PREMIER BANK Statement of Account-Cookie Creations June 30, 2020 Date Explanation Checks and Other Debits May 31 Balance June 1 Deposit Deposits Balance 3,256 750 4006 625 3.381 6 Check 8600 3286 95 6 Check 601 8 3.230 56 Check 8602 1,050 4280 9 Deposit NSF check 100 4.100 10 4 145 35 10 NSF-fee 14 Check #cos 452 3,693 PREMIER BANK Statement of Account-Cookie Creations June 30, 2020 Explanation Checks and Other Debits Date Deposits Balance May 31 Balance 3,256 June 1 Deposit 750 4,006 6 Check 600 625 3.381 6 Check #601 95 3.286 8 8 Check#602 56 3.230 9 Deposit 1.050 4,280 10 NSF check 100 4,180 10 NSF-fee 35 4,145 14 Check 603 452 3.693 20 Deposit 125 3,818 23 EFT-Telus 85 3,733 28 Check #599 361 3.372 30 Bank charges 13 3.359 1 2 Additional information: On May 31, there were two outstanding checks: 4595 for $238 and 4599 for $361. Premier Bank made a posting error to the bank statement check #603 was issued for $425, not $452 The deposit made on June 20 was for $125 that Natalie received for teaching a class. Natalie made an error in recording this transaction The electronic funds transfer (EFT) was for Natalie's utilities expense. The NSF check was from Ron Black Natalie received this check for teaching a class to Ron's children. Natalie contacted Ron and be assured her that she will receive a check in the mall for the outstanding amount of the invoice and the NSF bank charge 3 4. 5 The NSF fee will be charged to the customer Prepare Cookie Creations bank reconciliation for June 30. (List Items that increase cash balance first Reconcile cash balance per bank first) COOKIE CREATIONS INC. Bank Reconciliation June 30, 2020 1759 Cash balance per bank statement Add Bank error check no. 603 27 Deposit in transit 110 137 2496 Less V Outstanding checks 535 Adjusted cash balance per bank 2961 Cash balance per books $ 31224 Less Service charge 13 Telus 85 1 NSF check 135 i Error in deposit June 20th 30 250 Adjusted cash balance per books 2.961 Your Answer Correct Answer (Used) Prepare any necessary adjusting entries at June 30. (Credit account titles are automatically indented when amount is entered. Do not Indent manually. If no entry is required, select "No Entry for the account titles and enter for the amounts.) Debit Credit Date Account Titles and Explanation June 30 Miscellaneous Experte 13 Cach 13 (To record bank charges.) Service Revenue June 30 30 cah 30 (To record error in deposit made on June 20.) June 30 Us Experie os Cash 35 (To record EFT charges.) June 30 Accounts Receivable 135 Cash 135 (To record NSF check.) (c) If a balance sheet is prepared for Cookie Creations at June 30, what balance will be reported as cash in the current assets section? If a balance sheet were prepared, cash at June 30th, 2020 would be $ eTextbook and Media List of Accounts Save for Later Attempts: 0 of 3 used Submit