I need to create a bank reconciliation for Diaz's checking account on May 31, 2021 **Bank Statement Overview for Educational Purposes**### Account Summary- **Location:** 124 Saddle Blvd, Bowlegs, OK 74830- **Statement Date:** May 31, 2021| Beginning Balance (May 1, 2021) | Deposits and Credits | Withdrawals and Debits | Ending Balance (May 31, 2021) || --- | --- | --- | --- || $6,130 | NO. 7 | $9,504 | NO. 9 | $9,047 | $6,587 |### Account Details#### Deposits and Credits| Date | Amount | Description || --- | --- | --- || 5/4 | $1,330 | DEP || 5/11 | 1,760 | DEP || 5/18 | 2,390 | DEP || 5/20 | 1,100 | NOTE || 5/20 | 47 | INT || 5/25 | 2,860 | DEP || 5/31 | 17 | INT || **Total** | **$9,504** | |#### Withdrawals and Debits| Date | No. | Amount | Description || --- | --- | --- | --- || 5/1 | 469 | $420 | CHK || 5/2 | 470 | 300 | CHK || 5/9 | 471 | 1,170 | CHK || 5/11 | 472 | 1,540 | CHK || 5/18 | 473 | 3,470 | CHK || 5/20 | 470 | EFT || 5/25 | 474 | 1,370 | CHK || 5/31 | | 37 | SF || **Total** | **$9,047** | |#### Daily Balance| Date | Amount ||--- |--- || 5/1 | $5,710 || 5/2 | 5,410 || 5/4 # Diaz Entertainment Cash Records and Bank Statement for MayBelow are the cash records and bank statement of Diaz Entertainment for the month of May.## Cash Account Records**Period:** May 1, 2021, to May 31, 2021- **Beginning Cash Balance (May 1, 2021):** $5,410- **Cash Receipts:** $11,390- **Cash Disbursements:** $11,440- **Ending Cash Balance (May 31, 2021):** $5,360### Details#### Cash Receipts- **5/3 - Sales:** $1,330- **5/10 - Sales:** $1,760- **5/17 - Sales:** $2,390- **5/24 - Sales:** $2,860- **5/31 - Sales:** $3,050**Total Cash Receipts:** $11,390#### Cash Disbursements- **5/7 - Legal Fees (Check 471):** $1,170- **5/12 - Property Tax (Check 472):** $1,540- **5/15 - Salaries (Check 473):** $3,470- **5/22 - Advertising (Check 474):** $1,370- **5/30 - Supplies (Check 475):** $420- **5/31 - Salaries (Check 476):** $3,470**Total Cash Disbursements:** $11,440---## Bank Statement**Bank:** Midwest Bank **Statement Date:** May 31, 2021- **Account Number:** 7772854360- **Account Holder:** Diaz Entertainment, 124 Saddle Blvd, Bowlegs, OK 74830### Account Summary- **Beginning Balance (May 1, 2021):** $6,130- **Deposits and Credits (7 transactions):** $9,504- **Withdrawals and Debits (9 transactions):** $9,047- **Ending Balance (May 31, 2021):** $6,587### Account Details#### Deposits and Credits- **5/4 - $1,330 DEP** - **5/11 - $1,760 DEP**- **5/

Bank reconciliation is a process in which balance as per bank and as per book is matched by…

Bowlegs, OK 74830 Statement Date: May 31, 2021 Account Summary Withdrawals and Debits Beginning Balance Маy 1, 2021 $6,130 Deposits and Credits NO. Ending Balance May 31, 2021 $6,587 Total NO. Total 7 $9,504 9. $9,047 Account Details Deposits and Credits Amount Withdrawals and Debits Amount 420 Daily Balance Desc. Desc. Date 5/4 5/11 5/18 5/20 5/20 5/25 5/31 Date 5/1 5/2 5/9 5/11 5/12 5/18 5/20 5/25 5/31 No. Date 5/1 5/2 5/4 5/9 5/11 5/12 5/18 5/20 5/25 Amount $ 1,330 1,760 2,390 1,100 47 $5,710 5,410 6,740 5,570 7,060 5,520 4,440 5,117 6,607 DEP 469 470 471 CHK 2$ 300 DEP CHK 1,170 270 1,540 3,470 470 DEP NOTE CHK NSF 472 473 CHK CHK EFT CHK INT DEP 2,860 17 INT 474 1,370 37 SF $ 9,504 $9,047 5/31 $6,587 DEP Customer deposit NOTE Note collected EFT Electronic funds transfer INT Interest earned CHK Customer check SF Service fees NSF Nonsufficient funds Desc. 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, 2021 (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.

Bowlegs, OK 74830 Statement Date: May 31, 2021 Account Summary Withdrawals and Debits Beginning Balance Маy 1, 2021 $6,130 Deposits and Credits NO. Ending Balance May 31, 2021 $6,587 Total NO. Total 7 $9,504 9. $9,047 Account Details Deposits and Credits Amount Withdrawals and Debits Amount 420 Daily Balance Desc. Desc. Date 5/4 5/11 5/18 5/20 5/20 5/25 5/31 Date 5/1 5/2 5/9 5/11 5/12 5/18 5/20 5/25 5/31 No. Date 5/1 5/2 5/4 5/9 5/11 5/12 5/18 5/20 5/25 Amount $ 1,330 1,760 2,390 1,100 47 $5,710 5,410 6,740 5,570 7,060 5,520 4,440 5,117 6,607 DEP 469 470 471 CHK 2$ 300 DEP CHK 1,170 270 1,540 3,470 470 DEP NOTE CHK NSF 472 473 CHK CHK EFT CHK INT DEP 2,860 17 INT 474 1,370 37 SF $ 9,504 $9,047 5/31 $6,587 DEP Customer deposit NOTE Note collected EFT Electronic funds transfer INT Interest earned CHK Customer check SF Service fees NSF Nonsufficient funds Desc. 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, 2021 (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.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Need assistance
explain why it is important for a business to do a bank reconciliation monthly.
A check that has a future date instead of the actual date; it should not be deposited until the date on the check, is known as ____________. Electric Funds Transfer (EFT) Check 21 Bank card Post dated check
Give typing answer with explanation and conclusion He writes a draft from his personal bank account payable to the power company. This draft is known as a(n) _____. certified check accord and satisfaction promissory note check non-negotiable instrument
Use the following bank statement and T-account to prepare any journal entries needed as a result of the May 31 bank recor no entry Is requlred for a transactlon/event, select "No Journal Entry Requlred" In the first account fleld.) BANK STATEMENT
i upload this question but you solve just part 1.. i need all parts. urgently please have a look
Are 1 year certificates of deposit recorded on bank reconciliation?
The folowing are extracts from the cash book and the bank statement of R. Wright. You are required to. (a) Write the cash book up to date and state the new balance as on 28 February 2020. (b) Draw up a bank reconcaliation statement as on 28 February 2020 Cash Book 2005 Feb 8 A. Kirkland 3500 Feb. 15 R. Mason Feb 28 G. Harris Feb 28 W. Mullings 330 2020 Febi Balancel 10500 350 Feb. 7 R. Clarke Feb 22 K. Hughes Feb 25 K. Wood Feb 26 A. Aiken 1230 275 220 300 750 Feb 28 C. Mills Feb 28 Bal ed 220 12395 7115 7115 12395 March I Bal bif Bank Statement 2020 Cr Balance FebI Balance bf Feb 7 R. Clarke Feb 8 A Kirkland Feb 15 R. Mason Feb 22 K. Hughes Feb 23 R. Brooks Feb 24 P. Peart Feb 28 U. Ulet Feb 28 K. Campbel 10500 10850 7350 6120 350 3500 1230 275 6395 6895 6025 7525 8325 500 870 1500 800 Updated Cash Book Date Details Felio Amount Date Detail Foho Amount Bank Reconciliation Statement aat February 28, 2020 Details
Naomi Greenwell fills out a deposit slip for her saving account. She deposits a check for $445.96. She also has $215.44 in cash and $23.17 in coins. What is her total deposit?
The problem below with Corrected Bank reconciliation
Hello, How do I solve this? Thanks