Required Information The following information applies to the questions displayed below The cash records and bank statement for the month of May for Diaz Entertainment are shown below, DIAZ ENTERТAINMENT Cash Account Records May 1, 2821, to May 31, 2021 Fryrme Cash Balance Cash Balance Cash May 1, 2021 $5,478 + Cash Receipts $11,090 Cash Receipts Disbursenents $11,es May 31, 2821 $5,480 Cash Disbursenents Amount 1,270 1,7ee 2,330 2,8ee 2,990 Check Date Date 5/3 5/10 5/17 5/24 5/31 Desc. Desc. Amount Sales Sales Sales Sales Sales Legal fees Property tax Salaries Advertising 1,11e 5/7 5/12 5/15 5/22 471 472 1,480 3,418 1,318 473 474 Supplies Salaries 5/3e 5/31 475 З6е 476 3,418 $11,e9e $11,ese Midwest Bank P.O. Box 162647 Menber FDIC Bowlegs, OK 74830 (485) 369-CASH Account Holder: Looking Out For You Diaz Entertainment 124 Saddle Blvd, Вомlegs, O 74838 Account Number: 7772854368 May 31, 2821 Statenent Date: Account Surmary Beginning Balance May 1, 2021 $6,070 Ending Balances May 31, 2021 $6,761 Deposits and Credits NO. Withdrawals and Debits Total $9,252 Account Details ND. Total $8,561 9 Deposits and Credits Amount withdrawals and Debits Daily Balance Date 5/1 5/2 No. Desc. Date Desc Date Amount Amount $5,718 5,47e 6,748 5/4 1,27e 5/1 5/2 5/9 5/11 5/12 5/18 5/20 5/25 5/31 DEP 469 368 CHK 5/11 1,78e 2,338 DEP 478 248 CHK 5/18 5/28 5/28 5/25 5/31 471 DEP 1,118 снк 5/4 5/9 5/11 5/12 1,180 NOTE 218 NSF 5,638 7,128 5,648 4,560 5,291 6,781 41 INT 472 1,48e 3,418 CHK 2,880 DEP 473 CHK 11 INT 418 EFT 5/18 5/20 474 1,318 сHк 31 SF 5/25 $8,561 9,252 5/31 6,761 DEP Custoner deposit NOTE Note collected EFT Electronic funds transfer SF Service fees NSF Nonsufficient funds Desc INT Interest carned CHK Custoner check Additional information: . 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 thet should have been made on another account Required: 1. Prepare a bank reconciliation for Diez'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.) DIAZ ENTERTAINMENT Bank Reconcllation May 31, 2021 Bank'e Cash Balance Company's Cash Balance 6,761 Per general ledger 2,990 (3,770) 5,480 1,100 52 Per bank statement Deposits outstanding Note collected Checks outstanding Interest earned Bank error 410 (31) Service fees NSF check (210) Bank balance per reconciliation Campany balance per reconciliation
Required Information The following information applies to the questions displayed below The cash records and bank statement for the month of May for Diaz Entertainment are shown below, DIAZ ENTERТAINMENT Cash Account Records May 1, 2821, to May 31, 2021 Fryrme Cash Balance Cash Balance Cash May 1, 2021 $5,478 + Cash Receipts $11,090 Cash Receipts Disbursenents $11,es May 31, 2821 $5,480 Cash Disbursenents Amount 1,270 1,7ee 2,330 2,8ee 2,990 Check Date Date 5/3 5/10 5/17 5/24 5/31 Desc. Desc. Amount Sales Sales Sales Sales Sales Legal fees Property tax Salaries Advertising 1,11e 5/7 5/12 5/15 5/22 471 472 1,480 3,418 1,318 473 474 Supplies Salaries 5/3e 5/31 475 З6е 476 3,418 $11,e9e $11,ese Midwest Bank P.O. Box 162647 Menber FDIC Bowlegs, OK 74830 (485) 369-CASH Account Holder: Looking Out For You Diaz Entertainment 124 Saddle Blvd, Вомlegs, O 74838 Account Number: 7772854368 May 31, 2821 Statenent Date: Account Surmary Beginning Balance May 1, 2021 $6,070 Ending Balances May 31, 2021 $6,761 Deposits and Credits NO. Withdrawals and Debits Total $9,252 Account Details ND. Total $8,561 9 Deposits and Credits Amount withdrawals and Debits Daily Balance Date 5/1 5/2 No. Desc. Date Desc Date Amount Amount $5,718 5,47e 6,748 5/4 1,27e 5/1 5/2 5/9 5/11 5/12 5/18 5/20 5/25 5/31 DEP 469 368 CHK 5/11 1,78e 2,338 DEP 478 248 CHK 5/18 5/28 5/28 5/25 5/31 471 DEP 1,118 снк 5/4 5/9 5/11 5/12 1,180 NOTE 218 NSF 5,638 7,128 5,648 4,560 5,291 6,781 41 INT 472 1,48e 3,418 CHK 2,880 DEP 473 CHK 11 INT 418 EFT 5/18 5/20 474 1,318 сHк 31 SF 5/25 $8,561 9,252 5/31 6,761 DEP Custoner deposit NOTE Note collected EFT Electronic funds transfer SF Service fees NSF Nonsufficient funds Desc INT Interest carned CHK Custoner check Additional information: . 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 thet should have been made on another account Required: 1. Prepare a bank reconciliation for Diez'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.) DIAZ ENTERTAINMENT Bank Reconcllation May 31, 2021 Bank'e Cash Balance Company's Cash Balance 6,761 Per general ledger 2,990 (3,770) 5,480 1,100 52 Per bank statement Deposits outstanding Note collected Checks outstanding Interest earned Bank error 410 (31) Service fees NSF check (210) Bank balance per reconciliation Campany balance per reconciliation
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
100%
In reconciling a bank statement, when a check from the previous month appears on the bank statement (but not the cash balance due to timing), how would you state it on the reconciliation?
The note that was given: 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).
Attached is an image of my current progress.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
Could you please provide an image of the balance reconciliation account? Show what needs to be added and subtracted from each side. Thank you.
Solution
by Bartleby Expert
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education