Instructions: Prepare a bank reconciliation from Kodiak Kupcake's May 31, 2019 bank statement and cash account general ledger records. Prepare the necessary journal entries from the reconciliation. The reconciliation can be done in Excel, in Word, or on paper. The assignment is included in both Word and Excel. Upload your answers, either in Excel, Word or a photo if done on paper. Best Banke Member FDICE P.O. Box 123878 City In, WA 98000 Account Holder: Account Number: Kodiak Kupcakese 519 Main Street City In, WA 980002 ttttttt 57327523874 ttttt Statement Date: May 31, 2019 Deposits and Creditse Withdraws and Debitse 2 Beginning Balance May 1, 2019 $6,2602 Totalk_ Totalk Ending Balance May 31, 2019 $7,190 $11,0302 $10,1002 e Deposits and Credits Date Amount Desc. ee 5/42 $1,460 DEPO 2 5/112 2,870 DEPO 2 5/18 2520 DEP e 5/20 1100 DEP e 5/20 60 INTA 5/252 | 2990 DEP | | 5/31 304 INTE Date 5/12 5/22 5/9 5/112 5/12e 5/18 5/20 5/252 5/312 Withdraws and Debits No. Amount 4692 $550 4702 4306 4712 1,300 400 472e 1,6704 4732 3600 6006 474 1500 e 50+ $10,100 Desce el CHK e CHK2 e CHKA NSF a CHKe CHKO EFTe e CHKA SFO e e Daily Balance Date Amount 5/12 $5,710 5/2e 5,280 5/42 6,740 5/92 5,440 5/112 7,910 5/12e 6,240 5/18 5,160 5/20 5,720 5/252 7,210 5/312 $7,190 $11,030 e DEP Customer deposit e NOTE Note collectede EFT Electronic funds transfer tttt tt tt Desce INT Interest earned CHK Customer checke SF Service feese NSF Non-sufficient fundse G H I J 1 Chapter 8 Class Activity Name 2 Bank Reconciliation 3 Required: 4 1. From the attached documents prepare a bank reconciliation 5 2. From the reconciliation prepare the necessary journal entries Kodiak Kupcakes Bank Reconciliation 2019/5/31 Date: Check # Amount Bank's Cash Balance Per bank statement Company's Cash Balance (books)__Amount Per general ledger Journal Entries only from the book's side Account Debit Credit Kodiak Kupcakes General Ledger Check No. Debit Credit 1,460 471 1,300 2,870 Cash Account May 2019 Date Explanation 5/1 Beginning Balance 5/3 Sales revenue 5/7 Legal fes 5/10 Sales revenue 5/12 Property tax 5/15 Salaries 5/17 Sales revenue 5/22 Utilities 5/24 Advertising 5/24 Sales revenue 5/31 Sales revenue 5/31 Salaries Totals 472 473 1,650 3,600 Balance $5,280 6,740 5,440 8,310 6,660 3,060 5,580 4,080 3,530 6,520 9,700 6,100 2,520 474 475 1,500 550 2,990 3,180 476 3,600 12,200 13,020 Additional information: a. The difference in the beginning balances in the company's records and the bank statement relates to the previous month's outstanding checks: 469 $ 550 470 $ 430 b. Check #472 is correctly processed by the bank. c. The EFT on May 20 was for office supplies d. The deposit on May 20 was a note receivable collected by the bank for the company