How to prepare a bank reconciliation and record adjustments

Problem 4-3A Prepare The Bank Reconciliation And Record Cash Adjustments (LO5) [The Following Information Applies To The Questions Displayed Below.] The Cash...

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

[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, 2015, to May 31, 2015
Cash Balance
May 1, 2015 + Deposits – Checks = Cash Balance
May 31, 2015



$5,320 $11,840 $11,980 $5,180

Deposits Checks

Date Desc. Amount Date No. Desc. Amount

5/3 Sales $ 1,420 5/7 471 Legal fees $ 1,260
5/10 Sales 1,850 5/12 472 Property tax 1,630
5/17 Sales 2,480 5/15 473 Salaries 3,560
5/24 Sales 2,950 5/22 474 Advertising 1,460
5/31 Sales 3,140 5/30 475 Supplies 510
5/31 476 Salaries 3,560


$11,840 $11,980

P.O. Box 162647
Bowlegs, OK 74830
(405) 369-CASH MIDWEST BANK
Looking Out For You Member FDIC

Account Holder: Diaz Entertainment
124 Saddle Blvd.
Bowlegs, OK 74830 Account Number:

Statement Date: 7772854360

May 31, 2015
Beginning Balance Deposits and Credits Withdrawals
and Debits Ending Balance



May 1, 2015 No. Total No. Total May 31, 2015
$ 6,220 7 $ 9,782 9 $ 9,776 $ 6,226
Deposits and Credits Withdrawals and Debits Daily Balance


Date Amount Desc. Date No. Amount Desc. Date Amount
5/4 $ 1,420 DEP 5/1 469 $ 510 CHK 5/1 $ 5,710
5/11 1,850 DEP 5/2 470 390 CHK 5/2 5,320
5/18 2,480 DEP 5/9 471 1,260 CHK 5/4 6,740
5/20 1,000 NOTE 5/11 360 NSF 5/9 5,480
5/20 56 INT 5/12 472 1,630 CHK 5/11 6,970
5/25 2,950 DEP 5/18 473 3,560 CHK 5/12 5,340
5/31 26 INT 5/20 560 EFT 5/18 4,260
5/25 474 1,460 CHK 5/20 4,756
5/31 46 SF 5/25 6,246


5/31 $ 6,226
$ 9,782 $9,776

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, 2015.

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.