Question
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,
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,420 | $11,340 | $11,380 | $5,380 | |||||||||||
| Cash Receipts | Cash Disbursements | |||||||||||||
| Date | Desc. | Amount | Date | Check# | Desc. | Amount | ||||||||
| 5/3 | Sales | $ | 1,320 | 5/7 | 471 | Legal fees | $ | 1,160 | ||||||
| 5/10 | Sales | 1,750 | 5/12 | 472 | Property tax | 1,530 | ||||||||
| 5/17 | Sales | 2,380 | 5/15 | 473 | Salaries | 3,460 | ||||||||
| 5/24 | Sales | 2,850 | 5/22 | 474 | Advertising | 1,360 | ||||||||
| 5/31 | Sales | 3,040 | 5/30 | 475 | Supplies | 410 | ||||||||
| 5/31 | 476 | Salaries | 3,460 | |||||||||||
| $ | 11,340 | $ | 11,380 | |||||||||||
| 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,120 | 7 | $9,562 | 9 | $8,966 | $6,716 | ||||||||||||||||||||
| Account Details | |||||||||||||||||||||||||
| Deposits and Credits | Withdrawals and Debits | Daily Balance | |||||||||||||||||||||||
| Date | Amount | Desc. | Date | No. | Amount | Desc. | Date | Amount | |||||||||||||||||
| 5/4 | $ | 1,320 | DEP | 5/1 | 469 | $ | 410 | CHK | 5/1 | $ | 5,710 | ||||||||||||||
| 5/11 | 1,750 | DEP | 5/2 | 470 | 290 | CHK | 5/2 | 5,420 | |||||||||||||||||
| 5/18 | 2,380 | DEP | 5/9 | 471 | 1,160 | CHK | 5/4 | 6,740 | |||||||||||||||||
| 5/20 | 1,200 | NOTE | 5/11 | 260 | NSF | 5/9 | 5,580 | ||||||||||||||||||
| 5/20 | 46 | INT | 5/12 | 472 | 1,530 | CHK | 5/11 | 7,070 | |||||||||||||||||
| 5/25 | 2,850 | DEP | 5/18 | 473 | 3,460 | CHK | 5/12 | 5,540 | |||||||||||||||||
| 5/31 | 16 | INT | 5/20 | 460 | EFT | 5/18 | 4,460 | ||||||||||||||||||
| 5/25 | 474 | 1,360 | CHK | 5/20 | 5,246 | ||||||||||||||||||||
| 5/31 | 36 | SF | 5/25 | 6,736 | |||||||||||||||||||||
| $ | 9,562 | $ | 8,966 | 5/31 | $ | 6,716 | |||||||||||||||||||
| 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:
- 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).
- 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, 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.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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
Managerial Accounting
Authors: Ray Garrison, Eric Noreen, Peter Brewer
17th Edition
9781260247787
