60.1K

Verified Solution

Link Copied!

Problem 4-3A Prepare the bank reconciliation and record cash adjustments (LO4-5)

[The following information applies to the questions displayed below.]

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

+

Cash Receipts

Cash Disbursements

=

May 31, 2021

$5,330

$11,790

$11,920

$5,200

Cash Receipts

Cash Disbursements

Date

Desc.

Amount

Date

Check#

Desc.

Amount

5/3

Sales

$

1,410

5/7

471

Legal fees

$

1,250

5/10

Sales

1,840

5/12

472

Property tax

1,620

5/17

Sales

2,470

5/15

473

Salaries

3,550

5/24

Sales

2,940

5/22

474

Advertising

1,450

5/31

Sales

3,130

5/30

475

Supplies

500

5/31

476

Salaries

3,550

$

11,790

$

11,920

P.O. Box 162647

Midwest Bank

Member FDIC

Bowlegs, OK 74830

Looking Out For You

(405) 369-CASH

Account Holder:

Diaz Entertainment

Account Number:

7772854360

124 Saddle Blvd,

Bowlegs, OK 74830

Statement Date:

May 31, 2021

Account Summary

Beginning Balance

Deposits and Credits

Withdrawals and Debits

Ending Balance

May 1, 2021

NO.

Total

NO.

Total

May 31, 2021

$6,210

7

$9,940

9

$9,695

$6,455

Account Details

Deposits and Credits

Withdrawals and Debits

Daily Balance

Date

Amount

Desc.

Date

No.

Amount

Desc.

Date

Amount

5/4

$

1,410

DEP

5/1

469

$

500

CHK

5/1

$

5,710

5/11

1,840

DEP

5/2

470

380

CHK

5/2

5,330

5/18

2,470

DEP

5/9

471

1,250

CHK

5/4

6,740

5/20

1,200

NOTE

5/11

350

NSF

5/9

5,490

5/20

55

INT

5/12

472

1,620

CHK

5/11

6,980

5/25

2,940

DEP

5/18

473

3,550

CHK

5/12

5,360

5/31

25

INT

5/20

550

EFT

5/18

4,280

5/25

474

1,450

CHK

5/20

4,985

5/31

45

SF

5/25

6,475

$

9,940

$

9,695

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:

1. The difference in the beginning balances in the companys records and the bank statement relates to checks #469 and #470, which are outstanding as of April 30, 2021 (prior month).
2. 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.

Problem 4-3A Part 1

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.)

Answer & Explanation Solved by verified expert

See Answer