Burnaby Company Bank Reconciliation For October 31-2011 Bank Statement Balance $ 9,843.80 Book Balance $ 10,054.69...

Transcribed Image Text:

Burnaby Company Bank Reconciliation For October 31-2011 Bank Statement Balance $ 9,843.80 Book Balance $ 10,054.69 Add: Deposit of Oct. 31 in transit $ 1,796.50 $ 11,640.30 Deduct: NSF Cheque & service Deduct: Outstanding Cheques: charge Bank Service Charge 285.40 14.95 $ 300.35 #537 #542 Adjusted bank balance $948.24 $937.72 $ 1,885.96 $ 9,754.34 Adjusted book balance The Cash account in the General Ledger appeared as follows on November 30 (Burnaby Company uses only a General Journal to record Transactions): 101-Cash Date Explanation PR Debit Credit Balance 2011 Oct. 31 Balance 9754.34 Nov. 1 Cheque #543 1 Cheque #544 1 Cheque #545 1 Cheque #546 5555 1800 679.12 7954.34 7275.22 921.84 6353.38 910.72 5442.66 1 Cheque #547 J5 891.02 4551.64 1 Cheque #548 16 949.04 3602.6 1 Cheque #549 J6 991.16 2611.44 9 Deposit 16 1908.56 4520.00 9 Cheque #550 16 917.12 3602.88 9 Cheque #551 J6 699.36 2903.52 18 Deposit J6 1970.36 4873.88 20 Cheque #552 16 885.36 3988.52 27 Cheque #553 J6 931.84 3056.68 29 Deposit 16 1776.58 4833.26 The following bank statement is available for November 2011: Bank Statement To: Burnaby Corporation 30-Nov-11 Bank of Canada Cheques/Charges Deposits/Credits Balance 31-Oct 9843.80 #549 11/1 991.16 11/1 1796.50 10649.14 #543 11/2 1800 8849.14 #537 11/7 948.24 7900.90 #551 11/9 699.36 11/9 1908.56 9110.10 #542 11/12 937.72 8172.38 #544 11/14 679.12 7493.26 #547 11/18 891.02 11/18 1970.36 8572.60 #545 11/20 #546 SC 11/30 921.84 11/29 910.72 36.5 7650.76 6740.04 11/30 6703.54 SC= INT= NSF=Not Sufficient Service Funds Charge PMT=Principal Payment Interest Required: a. Prepare a bank reconciliation for Burnaby Company for the month of November 2011 b. Prepare the necessary journal entries resulting from the bank reconciliation. $ 9,754.34 Burnaby Company Bank Reconciliation For October 31-2011 Bank Statement Balance $ 9,843.80 Book Balance $ 10,054.69 Add: Deposit of Oct. 31 in transit $ 1,796.50 $ 11,640.30 Deduct: NSF Cheque & service Deduct: Outstanding Cheques: charge Bank Service Charge 285.40 14.95 $ 300.35 #537 #542 Adjusted bank balance $948.24 $937.72 $ 1,885.96 $ 9,754.34 Adjusted book balance The Cash account in the General Ledger appeared as follows on November 30 (Burnaby Company uses only a General Journal to record Transactions): 101-Cash Date Explanation PR Debit Credit Balance 2011 Oct. 31 Balance 9754.34 Nov. 1 Cheque #543 1 Cheque #544 1 Cheque #545 1 Cheque #546 5555 1800 679.12 7954.34 7275.22 921.84 6353.38 910.72 5442.66 1 Cheque #547 J5 891.02 4551.64 1 Cheque #548 16 949.04 3602.6 1 Cheque #549 J6 991.16 2611.44 9 Deposit 16 1908.56 4520.00 9 Cheque #550 16 917.12 3602.88 9 Cheque #551 J6 699.36 2903.52 18 Deposit J6 1970.36 4873.88 20 Cheque #552 16 885.36 3988.52 27 Cheque #553 J6 931.84 3056.68 29 Deposit 16 1776.58 4833.26 The following bank statement is available for November 2011: Bank Statement To: Burnaby Corporation 30-Nov-11 Bank of Canada Cheques/Charges Deposits/Credits Balance 31-Oct 9843.80 #549 11/1 991.16 11/1 1796.50 10649.14 #543 11/2 1800 8849.14 #537 11/7 948.24 7900.90 #551 11/9 699.36 11/9 1908.56 9110.10 #542 11/12 937.72 8172.38 #544 11/14 679.12 7493.26 #547 11/18 891.02 11/18 1970.36 8572.60 #545 11/20 #546 SC 11/30 921.84 11/29 910.72 36.5 7650.76 6740.04 11/30 6703.54 SC= INT= NSF=Not Sufficient Service Funds Charge PMT=Principal Payment Interest Required: a. Prepare a bank reconciliation for Burnaby Company for the month of November 2011 b. Prepare the necessary journal entries resulting from the bank reconciliation. $ 9,754.34