Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Intermediate Accounting - Assignment B. Baylor, the controller of the Baylor Company, provided the following information: Baylor Company Bank Reconciliation Oct 31, 2020 Bank Statement

Intermediate Accounting - Assignment B. Baylor, the controller of the Baylor Company, provided the following information: Baylor Company Bank Reconciliation Oct 31, 2020 Bank Statement Balance $19,687.60 Book Balance $45,548.66 Add: Deposit of Oct 31in transit 4280.45 Deduct Deduct #537 $725.00 NSF cheque $25,140.95 #542 2965.34 3690.34 Bank Service charges 130.00 25,270.95 Adjusted Bank Balance $20,277.34 Adjusted book balance $20,277.71 The cash account in the general ledger appeared as follows on November 30. Cash (101) Date Explanation Debit Credit Balance 2020 Oct. 31 Balance $20,277.71 Nov. 1 Cheque #543 6505.12 13,772.59 1 Cheque #544 854.71 12,917.88 1 Cheque #545 1,156.94 11,760.94 1 Cheque #546 2,564.24 9,196.70 1 Cheque #547 1,345.68 7,851.02 1 Cheque #548 56.45 7,794.57 1 Cheque #549 564.23 7,230.34 9 Deposit 1,548.97 8,779.31 9 Cheque #550 3,457.15 5,322.16 9 Cheque #551 985.64 4,336.52 18 Deposit 5,649.85 9,986.37 20 Cheque #552 5,556.71 4,429.66 27 Cheque #553 964.25 3,465.41 29 Deposit 1,250.65 4,716.06 The following bank statement is available for November 2020: Bank Statement November 30 To Baylor Company Bank of Canada Cheques/Charges Deposits/Credits Balance 19,687.60 #549 11/01 564.23 11/01 4,280.45 23,403.82 #543 11/02 6,505.12 16,898.70 #537 11/07 725.00 16,173.70 #551 11/09 985.64 11/09 1,584.97 16,773.03 #542 11/12 2,965.34 13,807.69 #544 11/14 854.71 12,952.98 #547 11/18 3,145.68 11/18 5,649.85 15,457.15 #545 11/20 1,156.94 14,300.21 #546 11/29 2,564.24 11,735.97 SC 11/30 105.00 11/30 11,630.97 NSF Non Sufficient Fund SC Service Charge IN Interest Earned Q1 Prepare a bank reconciliation for Baylor Company for the month of November 2020. Assume that any error made were by the bookkeeper (cheque #547 was for advertising expenses; the deposit of November 9 was regarding a credit customer, Val Pacino). Q2 Prepare the necessary entries resulting from the bank reconciliation.

image text in transcribed

B.Baylor, the controller of the Baylor Company provided the following information: Baylor Company Bank Reconciliation Oct 31, 2020 $19,687.60 Book Balance $45,548,66 Bank Statement Balance Add: Deposit of Oct Blin transit 4280.45 Deduct Deduct 8537 #1542 Adjusted Bank Balance 5725.00 2965 34 NSF cheque 3690.14 Bank Service charges $20,277.34 Adjusted book balance $25,140.95 130.00 25,270,95 $20,277.71 The cash account in the general ledger appeared as follows on November 30, Cash (101) Debit Explanation Credit Balance Date 2020 Oct. $20,277.71 13,722.59 Nav 6505.12 854.71 1,156.94 12,917.88 11.760.94 2,564.24 1,345,68 56.45 31 Balance 1 Cheque 543 ! 1 Cheque N544 1 Cheque N545 1 Cheque N546 1 Cheque 1547 1 1 Cheque N548 1 Cheque N549 9 Deposit 9 Cheque N550 9 Cheque 1551 18 Deposit 20 Cheque N552 27 Cheque N553 29 Deposit 564.23 1,548.97 9,196.70 7,851.02 7,794,57 7,230.34 8,729.31 5,322.16 4,336.52 9,986,37 4,429.66 3,465,41 3,457.15 985.64 5,649.85 5,556.71 964,25 1,250.65 4,716.06 The following bank statement is available for November 2020: Bank Statement November 30 To Baylor Company Cheques/Charges Bank of Canada Balance Deposits/Credits 4,280.45 564.23 11/01 6,505.12 1549 11/01 1543 11/02 1537 11/07 1551 11/09 1542 11/12 1544 11/14 4547 11/18 1545 11/20 1546 11/29 SC 11/30 NSF - Non Sufficient Fund 1,584.97 19,687.60 23,403.82 16,898.70 16,173.70 16,773.03 13,807,69 12,952.98 15,457.15 725.00 995.64 11/09 2,965.34 854.71 3,145.68 11/18 1,156.94 2,564.24 105.00 11/30 SC-Service Charge 5,649.85 14,300,21 11,735.97 11,630.97 IN-Interest Earned Q1 Prepare a bank reconciliation for Baylor Company for the month of November 2020. Assume that any error made were by the bookkeeper (cheque #547 was for advertising expenses; the deposit of November 9 was regarding a credit customer, Val Pacino). Q2 Prepare the necessary entries resulting from the bank reconciliation

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions