Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribedimage text in transcribedimage text in transcribed

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 1, 2021 $5,280 May 31, 2021 $5,100 + Cash Receipts $12,040 Cash Receipts Desc. Sales Sales Sales Sales Sales Date 5/3 5/10 5/17 5/24 5/31 472 Amount $ 1,460 1,890 2,520 2,990 3,180 Cash Disbursements $12,220 Cash Disbursements Check# Desc. 471 Legal fees Property tax 473 Salaries 474 Advertising 475 Supplies Salaries Date 5/7 5/12 5/15 5/22 5/30 5/31 Amount $ 1,300 1,670 3,600 1,500 550 3,600 $12,220 476 $12,040 Member FDIC 7772854360 May 31, 2021 Ending Balance May 31, 2021 $6,210 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 $6,260 7 $10,050 9 $10,100 Account Details Deposits and Credits Withdrawals and Debits Date Amount Desc. Date No. Amount Desc. 5/4 $ 1,460 DEP 5/1 $ 550 CHK 5/11 1,890 DEP 5/2 470 430 CHK 5/18 2,520 DEP 5/9 471 1,300 CHK 5/20 1,100 NOTE 5/11 400 NSF 5/20 60 INT 5/12 472 1,670 CHK 5/25 2.990 DEP 5/18 473 3,600 CHK 5/31 30 INT 5/20 600 EFT 5/25 474 1,500 CHK 5/31 50 SF $ 10,050 $10,100 469 Date 5/1 5/2 5/4 5/9 5/11 5/12 5/18 5/20 5/25 Daily Balance Amount $ 5,710 5,280 6,740 5,440 6,930 5,260 4,180 4,740 6,230 5/31 $ 6,210 Desc. DEP Customer deposit NOTE Note collected EFT Electronic funds transfer INT Interest earned SF Service fees CHK Customer check 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 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 Bank's Cash Balance May 31, 2021 Company's Cash Balance 6,632 Per general ledger Per bank statement $ Deposits outstanding Bank balance per reconciliation Company balance per reconciliation

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting For Executives And MBAs

Authors: Paul Simko, James Wallace, Joseph Comprix

5th Edition

1618533665, 9781618533661

More Books

Students also viewed these Accounting questions

Question

What is the AMT exemption amount? Is it available to all taxpayers?

Answered: 1 week ago

Question

How do todays organizations diff er from those of earlier eras?

Answered: 1 week ago