50.1K

Verified Solution

Link Copied!

The cash records and bank statement for the month of May for Diaz Entertainment are shown below. Cash Balance May 31, 2021 $5,200 DIAZ ENTERTAINMENT Cash Account Records May 1, 2021, to May 31, 2021 Cash Balance May 1, Cash Cash 2021 + Receipts Disbursements $5,330 $11,790 $11,920 Cash Receipts Cash Disbursements Date Desc. Amount Date Check# Desc. 5/3 Sales $ 1,410 5/7 471 Legal fees 5/10 Sales 1,840 5/12 472 Property tax 5/17 Sales 2,470 5/15 473 Salaries 5/24 Sales 2,940 5/22 474 Advertising 5/31 Sales 3,130 5/30 75 Supplies 5/31 476 Salaries $11,790 Amount $ 1,250 1,620 3,550 1,450 500 3,550 $11,920 May 31, 2021 Ending Balance May 31, 2021 $6,455 124 Saadie Biva, Bowlegs, OK 74830 Statement Date: Account Summary Withdrawals and Beginning Balance Deposits and Credits Debits May 1, 2021 NO. Total NO. Total $6,210 7 $9,940 9 $9,695 Account Details Deposits and Credits Withdrawals and Debits Date Amount Desc. Date No. Amount Desc. 5/4 $1,410 DEP 5/1 469 $ 500 CHK 5/11 1,840 DEP 5/2 470 380 CHK 5/18 2,470 DEP 471 1,250 CHK 5/20 1,200 NOTE 5/11 350 NSF 5/20 55 INT 5/12 472 1,620 CHK 5/25 2,940 DEP 5/18 473 3,550 CHK 5/31 25 INT 5/20 550 EFT 5/25 474 1,450 CHK 5/31 45 SF $9,940 $9,695 5/9 Daily Balance Date Amount 5/1 $5,710 5/2 5,330 5/4 6,740 5/9 5,490 5/11 6,980 5/12 5,360 5/18 4,280 5/20 4,985 5/25 6,475 5/31 $6,455 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, 2021 (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, 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.) 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

Answer & Explanation Solved by verified expert

See Answer