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. DIAZ ENTERTAINMENT Cash Account Records May 1, 2021,
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 Cash Balance May 31, 2021 $5,240 May 1, 2021 + Cash Receipts $5,350 $11,690 Cash Receipts Date Desc. Amount 5/3 Sales $ 1,390 5/10 Sales 1,820 5/17 Sales 2,450 5/24 Sales 2,920 5/31 Sales 3,110 Date 5/7 5/12 5/15 5/22 5/30 5/31 Cash Disbursements $11,800 Cash Disbursements Check# Desc. 471 Legal fees 472 Property tax 473 Salaries 474 Advertising 475 Supplies 476 Salaries Amount $ 1,230 1,600 3,530 1,430 480 3,530 $11,800 $11,690 Member FDIC 7772854360 May 31, 2021 Ending Balance May 31, 2021 $6,313 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 Surrmary Beginning Balance Deposits and Credits Withdrawals and Debits May 1, 2021 NO. Total NO. Total $6,190 7 $9,656 9 $9,533 Account Details Deposits and Credits Withdrawals and Debits Date Amount Desc. Date No. Amount Desc. 5/4 $ 1,390 DEP 5/1 469 $ 480 CHK 5/11 1,820 DEP 5/2 470 360 CHK 5/18 2,450 DEP 5/9 471 1,230 CHK 5/20 1,000 NOTE 5/11 330 NSF 5/20 53 INT 5/12 472 1,600 CHK 5/25 2,920 DEP 5/18 473 3,530 CHK 5/31 23 INT 5/20 530 EFT 5/25 474 1,430 CHK 5/31 43 SF $ 9,656 $9,533 Daily Balance Date Amount 5/1 $5,710 5/2 5,350 5/4 6,740 5/9 5,510 5/11 7,000 5/12 5,400 5/18 4,320 5/20 4,843 5/25 6,333 5/31 $6,313 Desc. DEP Customer deposit NOTE Note collected INT Interest earned CHK Customer check SE Service fees NSF Nonsufficient funds 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.) Bank's Cash Balance $ DIAZ ENTERTAINMENT Bank Reconciliation May 31, 2021 Company's Cash Balance 6,313 Per general ledger $ 3,110 Interest earned (1.120) Note collected NSF check Service fees 5,240 Per bank statement Deposits outstanding Checks outstanding Bank error 76 1,000 (330) (43) Bank balance per reconciliation Company balance per reconciliation $ 5,943
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