The cash records and bank statement for the month of May forDiaz Entertainment are shown below.  Â
 Â
DIAZ ENTERTAINMENT Cash Account Records May 1, 2018, to May 31, 2018 |
CashBalance May 1, 2018 | + | Deposits | | – | Checks | = | CashBalance May 31, 2018 |
| | | | | | | |
$5,330Â Â Â Â Â Â Â | | $11,790Â Â Â Â | | | $11,920Â Â Â Â Â Â Â | | $5,200Â Â Â Â Â Â Â |
| | | | | | | |
Deposits | | Checks |
| | |
Date | Desc. | Amount | | Date | No. | Desc. | Amount |
| | | | | | | |
   5/3 | Sales | $  1,410     | |    5/7 | 471 |     Legalfees | $  1,250     |
   5/10 | Sales | 1,840     | |    5/12 | 472 |     Propertytax | 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   Bowlegs, OK 74830   (405) 369-CASH | MIDWEST BANK Looking Out For You | Member FDIC |
| | |
  AccountHolder: |      Diaz Entertainment     124 Saddle Blvd.     Bowlegs, OK 74830 | Account Number:
Statement Date: | 7772854360
May 31, 2018 |
| | | |
Beginning Balance | Deposits and Credits | | Withdrawals and Debits | Ending Balance |
| | | | |
May 1, 2018 | No. | Total | | No. | Total | May 31, 2018 |
| | | | | | |
$6,210 | 7 | $9,940 | | 9 | $ 9,695 | $6,455 |
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Â Â Â |
| | | | | | | Â Â Â Â Â 5/31 | $ 6,455Â Â Â |
| $ 9,940Â Â Â Â | | | | $9,695Â Â Â Â | | | |
| | | | | | | | |
|
  Â
Desc.   DEP Customer deposit                 INTInterest earned            SFService fees
            NOTENote collected                  CHKCustomer check          NSFNonsufficientfunds
            EFTElectronic funds transfer
 Â
Additional information:
a. The difference in the beginning balances in the company’srecords and the bank statement relates to checks #469 and #470,which are outstanding as of April 30, 2018 (prior month).
b. The bank made the EFT on May 20 in error. The bank accidentallycharged Diaz for payment that should have been made on anotheraccount.
1. Prepare a bank reconciliation for Diaz'schecking account on May 31, 2018. (Amountsto be deducted should be indicated with a minus sign.Total entries to the same account together when entering inthe bank reconciliation.)
|
| DIAZ ENTERTAINMENT | Bank Reconciliation | May 31, 2018 | Bank's Cash Balance | Company's CashBalance | Per bankstatement | | Pergeneral ledger | | | | | | | | | | | | | | | | | | | | | | Bank balance per reconciliation | | Company balance per reconciliation | |
|
2. Record the necessary cash adjustments.(If no entry is required for a transaction/event, select"No journal entry required" in the first account field. Totalentries to the same account together when entering in the journalentry carousel.)
 Â