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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
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.

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
Transcribed Image Text: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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
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
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Bank reconciliation statement
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education