Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Required: 1) Prepare a bank reconciliation for Diaz's checking account on May 31, 2018. 2) Record the necessary cash adjustments. Additional Information: A)The difference in
Required:
1) Prepare a bank reconciliation for Diaz's checking account on May 31, 2018.
2) Record the necessary cash adjustments.
Additional Information:
A)The difference in the beginning balances in the company's records and the bank statements relating 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 the payment that should have been made on another account.
DIAZ ENTERTAINMENT Cash Account Records May 1, 2018, to May 31, 2018 Cash Balance May 1, 2018 $5,280 Deposits Deposits $12,040 Checks $12,220 Cash Balance May 31, 2018 $5,100 Checks Date Desc. Date No. Desc. 5/3 471 472 5/10 Amount $ 1,460 1,890 2,520 2,990 3,180 Sales Sales Sales Sales Sales 5/17 473 5/7 5/12 5/15 5/22 5/30 5/31 Legal fees Property tax Salaries Advertising Supplies Salaries Amount $ 1,300 1,670 3,600 1,500 550 3,600 $12,220 474 5/24 5/31 475 476 $12,040 . PO, Box 162647 Midwest Bank Member FDIC Bowlegs, OK 74830 Looking Out For You (405) 369-CASH Account Holder: Dlaz Entertainment Account Number: 7772854360 124 Saddle Blvd. Bowlegs, OK 74830 Statement Date: May 31, 2018 Account Summary Beginning Balance Deposits and Credits Withdrawals and Debits Ending Balance May 1, 2018 No. Total No. Total. May 31, 2018 $6,260 $10,050 9 $10,100 $6,210 Account Detalls Deposits and Credits Withdrawals and Debits Daily Balance Date Amount Desc. Date No. Amount Desc. Date Amount 5/4 $1,460 DEP. 5/1 469 $ 550 CHK $5,710 /11 1,890 DEP 5/2 470 430 CHK 5/2 5,280 5/18 2,520 DEP 5/ 9 471 1,300 CAK 5/4 6,740 5/20 1.100 NOTE 5/11 400 NSF 5/9 5,440 5/20 60 INT 5/12 472 1,670 CHK 5/11 6,930 5/25 2,990 DEP 5/18 473 3,600 CHK- 5/12 5,260 5/31 30 INT 5/20 600 EFT 5/18 4.180 5/25 474 1.500 CHK 5/20 4,740 5/31 50 SF 5/25 6,230 $10,050 $10,100 5/31 $6,210 DescDEP Customer deposit INT Interest earned SF Service fees NOTE Note collected CHK Customer check NSF Nonsufficient funds EFT Electronic funds transfer 5/12 Diaz Entertainment Bank Reconciliation May 31, 2018 Bank's Cash Balance Company's Cash Balance Per bank statement Per general ledger Bank balance per reconciliation Company balance per reconciliation Account Name Debit Credit
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