Please help!

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 sMe account together when entering in the bank reconciliation.)

May 1, 2021, to May 31, 2021 Cash Balance Cash Balance May 31, 2021 $5,380 May 1, 2021 + Cash Receipts $5,420 $11,340 Cash Receipts Date Desc Amount 5/3 Sales $ 1,320 5/10 Sales 1,750 5/17 Sales 2,380 5/24 Sales 2,850 5/31 Sales 3,040 Date 5/7 5/12 5/15 5/22 5/30 5/31 Cash Disbursements $11,380 Cash Disbursements Check# Desc. 471 Legal fees 472 Property tax 473 Salaries 474 Advertising 475 Supplies 476 Salaries Amount $ 1,160 1,530 3,460 1,360 410 I 3,468 $11,340 $11,380 Member FDIC 7772854360 May 31, 2021 P.O. Box 162647 Midwest Bank Bowlegs, OK 74830 Looking Out For You (405) 369-CASH Account Moldert Diar Entertainment Account Number: 124 Saddle Blvd, Bowlegs, OK 74830 Statement Dates Account Summary Beginning Balance Deposits and Credits withdrawals and Debits Hay 1 2021 NO. Total NO. Total $6,120 7 59562 9 Account Details Deposits and Credits withdrawals and Debits Date Amount Desco Date NO. Amount Ending Balance May 31 2021 $6,716 Daily Balance Date Allount Prov 12 Next > Member FDIC 7772854360 May 31, 2021 Ending Balance May 31, 2021 $6,716 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: Account Summary Beginning Balance Deposits and Credits Withdrawals and Debits May 1, 2021 NO. Total NO. Total 56,120 2 $9,562 9 $8,966 Account Details Deposits and Credits Withdrawals and Debits Date Amount Date No. Amount Desc. 5/4 $ 1,320 DEP 5/1 469 5410 CHK 5/11 1,250 DEP 470 290 CH 5/18 2,380 DEP 5/9 471 1,160 CHK 5/20 1,200 NOTE 5/11 260 NSF 5/20 46 INT 5/12 472 1,530 CHR 5725 2,850 DEP 5/18 473 3,460 CHK 5/31 16 INT 5720 460 EFT 5/25 474 1,360 CHK 5/31 36 SF $9,562 $8,966 Desc 5/2 Daily Balance Date Amount 5/1 55,710 5/2 5,420 5/4 6,748 5/9 5, 580 5/11 7, eze 5/12 5,54e 5/18 4,460 5/20 5,246 5/25 6,736 5/33 56,716 Desc DEP Customer deposit INT Interest earned SE Service fees Prey 12 of 8 !!! Next > $6,120 $8,966 $6,716 Deposits and Credits Date Amount Desc 5/4 $ 1,320 DEP 5/11 1,750 DEP 5/18 2,380 DEP 5/20 1,200 NOTE 5/20 46 INT 5/25 2,850 DEP 5/31 16 INT Desc. CHK CHK CHK Date 5/1 5/2 5/9 5/11 5/12 5/18 5/20 5/25 5/31 $9,562 9 Account Details Withdrawals and Debits No. Amount 469 $ 410 470 290 471 1,160 260 472 1,530 473 3,460 460 474 1,360 36 $8,966 NSF Daily Balance Date Amount 5/1 $5,710 5/2 5,420 5/4 6,740 5/9 5,580 5/11 7,070 5/12 5,540 5/18 4,460 5/20 5,246 5/25 6,736 5/31 $ 6,716 CHK CHK EFT CHK SF $ 9,562 Desc. DEP Customer deposit NOTE Note collected EFT Electronic funds transfer INT Interest earned CHK Customer check Service fees NSF Nonsufficient funds 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 erron The bank accidentally charged Diaz for payment that should have been made on another account Prey 2 of 8 Next > of 2 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.) Book DIAZ ENTERTAINMENT Bank Reconciliation May 31, 2021 Company's Cash Balance Per general ledger $ Note collected Print Bank's Cash Balance Per bank statement 5,380 NSF check Company balance per reconciliation Bank balance per reconciliation Prom 1 2 of 8 !!! Next >