Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Prepare a bank reconciliation for Diaz's checking account on May 31, 2018 and record the necessary cash adjustments in journal seen in image. The cash
Prepare a bank reconciliation for Diaz's checking account on May 31, 2018 and record the necessary cash adjustments in journal seen in image.
The cash records and bank statement for the month of May for Diaz Entertainment are shown below. DIAZ ENTERTAINMENT Cash Account Records May 1, 2018, to May 31, 2018 Cash Balance Cash Balance - May 31, 2018 May 1, 2018Deposits $5,420 $11,340 $5.380 Date Desc. Date No 5/7 471Legal tees 5/12 472 Property tax 515 473 Salaries 5/22 474 Advertising 5/30 475 Supplies 5/31 476 Salaries 5/3 S 1,320 $ 1160 1.530 3.460 1360 2,380 2.850 3,040 3.460 $11,340 $11,380 PO. Box 162647 Bowlegs, OK 74830 (405) 369-CASH MIDWEST BANK Looking Out For You Member FDIC Account Holder Diaz Entertalnment 124 Saddle Blvd. Bowlegs, OK 74830 Account Number 7772854360 Statement Date: May 31, 2018 Beginning Balance May 1, 2018 S 6,120 Deposits and Credits and Deblts Ending Balance May 31, 2018 $ 6,716 $9.562 $ 8,966 Deposits and Credits Withdrawals and Debits Daily Balance Amount Amount Desc. Date 1320 DEP 1750 DEP 2.380 DEP 200 NOTE 5/11 469 $ 410 CHK 51 290 CHK 52 1160 CHK 5/4 260 NSF 5/9 1530 CHK 511 3.460 CHK 5/12 460 EFT 518 1360 CHK 5/20 $ 5,710 5,420 6,740 5.580 7070 5/18 5/20 5/20 46 2.850 DEP 5/12 518 4.460 5.246 6,736 $ 6,716 6 INT 5V25 36 S 5/25 $ 9.562 $8,966 Desc. DEP Customer deposit INT Interest earned CHK Customer check SF Service fees NSF Nonsufficient funds NOTE Note collected EFT Electronic funds transfer Desc. DEP Customer deposit INT Interest earned CHK Customer check SF Service fees NSF Nonsufficient funds NOTE Note collected 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 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 reconcilation.) DIAZ ENTERTAINMENT Bank Reconciliation 31, 2018 Bank's Cash Balance Company's Cash Balance Per bank statement 6,716 Per general ledger 5,380 Bank balance per reconciliation Company balance per 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.) View transaction list Journal entry worksheet Record the amounts that increase cash. Note: Enter debits before credits. Transaction General Journal Debit Credit Record entry Clear entry View general journal
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