Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The cash records and bank statement for the month of May for Diaz Entertainment are shown below. Cash Balance Cash Receipts + $12,040 Cash
The cash records and bank statement for the month of May for Diaz Entertainment are shown below. Cash Balance Cash Receipts + $12,040 Cash Receipts DIAZ ENTERTAINMENT Cash Account Records May 1, 2024, to May 31, 2024 Cash Disbursements Cash Disbursements Memo May 1, 2024 $5,280 $12,220 Date Description Amount Date. Description 5/3 Sales $1,460 5/7 DC 5/10 Sales 1,890 5/12 DC 5/17 Sales 2,520 5/15 5/24 Sales 2,990 5/22 DC DC 5/31 Sales 3,180 5/30 5/31 CHK number 471 CHK number 472 Salaries. $12,040 Legal fees Property tax Salaries Advertising. Supplies Cash Balance May 31, 2024 $5,100 Amount $1,300 1,670 3,600 1,500 550 3,600 $12,220 P.O. Box 162647 Bowlegs, OK 74830 (405) 369-CASH Account Holder: Beginning Balance May 1, 2024 $6,260 Diaz Entertainment 124 Saddle Blvd, Bowlegs, OK 74830 Midwest Bank Looking Out For You Account Number: Statement Date: Account Summary Deposits and Credits Withdrawals and Debits Number 7 Total $10,050 Number 9 Total $10,100 Member FDIC 7772854360 May 31, 2024 Ending Balance May 31, 2024 $6,210 Account Details Deposits and Credits Withdrawals and Debits Date Amount Description Daily Balance Date Number Amount Description Date Amount 5/4 $1,460 DEP 5/1 469 $550 CHK 5/11 1,890 DEP 5/1 $5,710 5/2 470 430 CHK 5/18 2,520 5/2 DEP 5,280 5/7 1,300 DC 5/4 5/20 1,100 NOTE 6,740 5/11 400 NSF 5/9 5,440 5/20 60 INT 5/12 1,670 DC 5/11 5/25 2,998 DEP 6,930 5/15 3,600 DC 5/12 5/31 30 INT 5,260 5/20 600 EFT 5/18 4,180 5/22 1,500 DC 5/20 4,740 5/31 50 SF 5/25 6,230 $10,050 $10,100 5/31 $6,210 < Previ 7 of 9 Next > Description DEP Customer deposit INT Interest earned SF Service fees NOTE Note collected CHK Customer check NSF Nonsufficient funds EFT Electronic funds transfer DC Debit card Additional information: a. The difference in the beginning balances in the company's records and the bank statement relates to checks number 469 and number 470, which are outstanding as of April 30, 2024 (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, 2024. 2. Record the necessary cash adjustments. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a bank reconciliation for Diaz's checking account on May 31, 2024. (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 Per bank statement May 31, 2024 Company's Cash Balance Per general ledger < Prev 7 of 9 Next 2. Record the necessary cash adjustments. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a bank reconciliation for Diaz's checking account on May 31, 2024. (Amounts to be deducted should be indicated a minus sign. Total entries to the same account together when entering in the bank reconciliation.) DIAZ ENTERTAINMENT Bank Reconciliation Bank's Cash Balance Per bank statement May 31, 2024 Company's Cash Balance Per general ledger Bank balance per reconciliation Company balance per reconciliation Homework i Required 1 Required 2 Saved Record the necessary cash adjustments. (If no entry is required for a transaction/event, select "No Journal Entry Rec account field. Total entries to the same account together when entering in the journal entry carousel.) View transaction list Journal entry worksheet < A B Record the amounts that increase cash. Note: Enter debits before credits. Transaction 1 General Journal Debit Credit Record entry Clear entry View general journal < Required 1 Required 2 Required 1 Required 2 eveu Record the necessary cash adjustments. (If no entry is required for a transaction/event, select "No Journal Entry Requi account field. Total entries to the same account together when entering in the journal entry carousel.) View transaction list Journal entry worksheet A B Record the amounts that decrease cash. Note: Enter debits before credits. Transaction 2 General Journal Debit Credit Record entry Clear entry View general journal < Required 1 Required 2
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started