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
Century 21 Accounting General Journal
11th Edition
ISBN:9781337680059
Author:Gilbertson
Publisher:Gilbertson
Chapter22: End-of-fiscal-period Work For A Corporation
Section: Chapter Questions
Problem 3AP
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
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College