The cash records and bank statement for the month of May for Diaz Entertainment are shown...

Free

60.1K

Verified Solution

Question

Accounting

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       
DepositsChecks
DateDesc.AmountDateNo.Desc.Amount
   5/3Sales$  1,410        5/7471    Legalfees$  1,250     
   5/10Sales1,840        5/12472    Propertytax1,620     
   5/17Sales2,470        5/15473    Salaries3,550     
   5/24Sales2,940        5/22474    Advertising1,450     
   5/31Sales3,130        5/30475    Supplies500     
   5/31476    Salaries3,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 BalanceDeposits and CreditsWithdrawals
and Debits
Ending Balance
May 1, 2018No.TotalNo.TotalMay 31, 2018
$6,2107$9,9409$ 9,695$6,455
Deposits and CreditsWithdrawals and DebitsDaily Balance
DateAmountDesc.DateNo.AmountDesc.DateAmount
     5/4$ 1,410        DEP     5/1469$  500       CHK     5/1$ 5,710   
     5/111,840        DEP     5/2470380      CHK     5/25,330   
     5/182,470        DEP     5/94711,250      CHK     5/46,740   
     5/201,200        NOTE     5/11350      NSF     5/95,490   
     5/2055        INT     5/124721,620      CHK     5/116,980   
     5/252,940        DEP     5/184733,550      CHK     5/125,360   
     5/3125        INT     5/20550      EFT     5/184,280   
     5/254741,450      CHK     5/204,985   
     5/3145      SF     5/256,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 BalanceCompany's CashBalance
Per bankstatementPergeneral ledger
Bank balance per reconciliationCompany 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.)
  

Answer & Explanation Solved by verified expert
4.4 Ratings (831 Votes)

Solution 1:

Diaz Entertainment
Bank Reconciliation - May 31
Bank's Cash balance Company's cash balance
Particulars Amount Particulars Amount
Ending balance as per Bank Statements $6,455.00 Ending Balance as per cash books $5,200.00
Additions: Additions:
Outstanding deposit $3,130.00 Note Collection $1,200.00
Incorrect EFT debited by bank $550.00 Interest revenue $80.00
Deductions: Deductions:
Outstanding Checks (Check 475 and check 476) $4,050.00 NSF Check $350.00
Service Charge $45.00
Up to date cash balance as per bank $6,085.00 Up to date cash balance as per books $6,085.00

Solution 2:

Journal Entries - Diaz Entertainment
Date Particulars Debit Credit
31-May Cash Dr $1,200.00
       To Note receivables $1,200.00
(To record note collected by bank)
31-May Cash Dr $80.00
      To Interest Revenue $80.00
(To record interest revenue)
31-May Accounts receivables Dr $350.00
       To Cash $350.00
(To record NSF check from customer)
31-May Service Charges Dr $45.00
       To Cash $45.00
(Being service charges debited by bank)

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students