month of May for Diaz Entertainment are shown below. DIAZ ENTERTAINMENT Cash Account Records May 1, 2018, to May 31, 2018 Cash Balance May 1, 2018 Cash Balance May 31, 2018 Deposits Checks $5,280 $12,040 $12,220 $5,100 Deposits Checks Date Desc Amount Date No. Desc Amount 5/3 5/10 5/17 5/24 5/31 Sales Sales Sales Sales Sales $ 1,460 1,890 2.520 5/7 5/12 5/15 5/22 5/30 5/31 471 472 473 474 475 476 Legal fees Property tax Salaries Advertising Supplies Salaries 2.990 $ 1,300 1,670 3,600 1,500 550 3,600 3,180 $12,040 $12,220 PO Box 162647 Bowlegs, OK 74830 (405) 369-CASH MIDWEST BANK Looking Out For You Member FDIC Account Holder Account Number: 7772854360 Diaz Entertainment 124 Saddle Blvd Bowlegs, OK 74830 Statement Date: May 31, 2018 Withdrawals and Debits Beginning Balance Deposits and Credits Ending Balance May 1, 2018 No Total No Total May 31, 2018 7 $ 6,260 Deposits and Credits $ 10,050 9 $ 10,100 Withdrawals and Debits $ 6,210 Daily Balance Date Amount Desc Date No Amount Desc Date Amount 469 470 471 5/4 5/11 5/18 5/20 5/20 5/25 5/31 $ 1.460 1.890 2.520 1,100 60 2,990 30 DEP DEP DEP NOTE INT DEP INT 5/1 5/2 5/9 5/11 5/12 5/18 5/20 5/25 5/31 472 473 $ 550 430 1,300 400 1,670 3,600 600 1,500 50 CHK CHK CHK NSF CHK CHK EFT CHK SF 5/1 5/2 5/4 5/9 5/11 5/12 5/18 5/20 5/25 $ 5.710 5,280 6,740 5.440 6.930 5.260 4,180 4.740 6.230 474 5/31 $ 6,210 $ 10,050 $10,100 Desc. DEP Customer deposit INT Interest earned SF Service fees NOTE Note collected CHK Customer check NSF Nonsufficient funds EFT Electronic funds transfer Additional information: a. The difference in the beginning balances in the company's records and the bank statement relates to checks #469 and #470, which are outstanding as of April 30, 2018 (prior month). b. The bank made the EFT on May 20 in error. The bank accidentally charged Diaz for payment that should have been made on another account. References Section Break Problem 4-3A Prepare the bank reconciliation and record cash adjustments (L04-5) 6. value: 1.00 points Required Information Problem 4-3A Part 1 Required: 1. Prepare a bank reconciliation for Diaz's checking account on May 31, 2018. (Amounts to be deducted should be indicated with a minus sign. Total entries to the same account together when entering in the bank reconciliation.) DIAZ ENTERTAINMENT Bank Reconciliation May 31, 2018 Company's Cash Balance Per general ledger Bank's Cash Balance Per bank statement Bank balance per reconciliation Company balance per reconciliation References eBook & Resources Worksheet Difficulty: 3 Hard Problem 4-3A Part 1 Learning Objective: 04-05 Reconcile a bank statement. Check my work 7. value: 1.00 points Required Information Problem 4-3A Part 2 2. Record the necessary cash adjustments. (If no entry is required for a transaction/event, select "No journal entry required" in the first Worksheet Difficulty: 3 Hard Problem 4-3A Part 1 Learning Objective: 04-05 Reconcile a bank statement. Check my work 7. value: 1.00 points Required Informa Problem 4-3A Part 2 2. Record the necessary cash adjustments. ( no entry is required for a transaction/event, select "No journal entry required" in the first account field. Total entries to the same acco together when entering in the journal entry carousel.) View transaction list Journal entry worksheet Record the amounts that increase cash. Note: Enter debits before credits. Transaction General Journal Debit Credit 1 Record entry Clear entry View general journal References eBook & Resources General Journal Difficulty: 3 Hard Problem 4-3A Part 2 Learning Objective: 04-05 Reconcile a bank statement Check my work Worksheet Difficulty: 3 Hard Problem 4-3A Part 1 Learning Objective: 04-05 Reconcile a bank statement. Check my work value: 1.00 points Required Informa Problem 4-3A Part 2 2. Record the necessary cash adjustments. ( no entry is required for a transaction/event, select "No journal entry required" in the first account field. Total entries to the same acco together when entering in the journal entry carousel.) View transaction list Journal entry worksheet Record the amounts that decrease cash. Note: Enter debits before credits. Transaction General Journal Debit Credit 2 Record entry Clear entry View general journal References eBook & Resources General Journal Difficulty: 3 Hard Problem 4-3A Part 2 Learning Objective: 04-05 Reconcile a bank statement. Check my work