Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The cash records and bank statement for the month of May for Diaz Entertainment are shown below. Additional information: The difference in the beginning balances
The cash records and bank statement for the month of May for Diaz Entertainment are shown below.
DIAZ ENTERTAINMENT Cash Account Records May 1, 2021, to May 31, 2021 Cash Balance + May 31, 2021 $5,360 Cash Balance Cash May 1, 2021 Receipts $5,410 $11,390 Cash Receipts Date Dese. 5/3 Sales 5/10 Sales 5/17 Sales 5/24 Sales 5/31 Sales Amount $ 1,330 1,760 2,390 2,860 3,050 Date 5/7 5/12 5/15 5/22 5/30 5/31 Cash Disbursements $11, 440 Cash Disbursements Check Desc. 471 Legal fees 472 Property tax 473 Salaries 474 Advertising 475 Supplies 476 Salaries Amount $ 1,170 1,540 3,470 1,370 420 3, 470 $11,440 $11,390 Member FDIC 7772854360 May 31, 2021 I Ending Balance May 31, 2021 $6,587 P.O. Box 162647 Midwest Bank Bowlegs, OK 74830 Looking Out For You (405) 369-CASH Account Holder: Diaz Entertainment Account Number: 124 Saddle Blvd, Bowlegs, OK 74830 Statement Date: Aecount Summary Withdrawals and Beginning Balance - Deposits and Credits Debits May 1, 2021 NO. Total NO. Total $6,130 7 $9,504 9 $9,047 Account Details Deposits and Credits Withdrawals and Debits Date Amount Dese. Date Amount Desc. 5/4 $ 1,330 DEP 5/1 469 $ 420 CHK 5/11 1,760 DEP 5/2 470 300 CHK 5/18 2,390 DEP 5/9 471 1,170 CHK 5/20 1,100 NOTE 5/11 270 NSF 5/20 47 INT 5/12 472 1,540 CHK 5/25 2,860 DEP 5/18 473 3,470 CHK 5/31 17 INT 5/20 470 EFT 5/25 474 1,370 CHK 5/31 37 SF $ 9,504 $9,047 No. Daily Balance Date Amount 5/1 $5,710 5/2 5,410 5/4 6,740 5/9 5,570 5/11 7,060 5/12 5,520 5/18 4,440 5/20 5, 117 5/25 6,607 5/31 $6,587 Desc. DEP Customer deposit NOTE Note collected EFT Electronic funds transfer INT Interest earned CHK Customer check SF Service fees NSF Nonsufficient funds DIAZ ENTERTAINMENT Bank Reconciliation May 31, 2021 Company's Cash Balance Per general ledger Bank's Cash Balance Per bank statement Bank balance per reconciliation Company balance per reconciliation f2 Journal entry worksheet Additional information:
- The difference in the beginning balances in the companys records and the bank statement relates to checks #469 and #470, which are outstanding as of April 30, 2021 (prior month).
- 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. Required: 1. Prepare a bank reconciliation for Diaz's checking account on May 31, 2021. (Amounts to be deducted should be indicated with a minus sign. Total entries to the same account together when entering in the bank reconciliation.)
2. Record the necessary cash adjustments. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field. Total entries to the same account together when entering in the journal entry carousel.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started