1 6 Add: m Question 4: Bank Reconciliation (10 Marks) On June 30, 2020, Perfect Smile received its bank statement from the Big Bank. It stated that Perfoot Smile had a balance of $179.424.05 ot November 30th. The company's general ledger showed a cash balance of 586,033.21 at that date. The prior month bank reconcilation contained a deposit in transit of $315.17 and three outstanding cheques 1650 for $755.67, choque #658 for $725.00 and cheque #1654 for $2,964.34 Required: The bank reconciliation was partially completed by the bookkeeper who was unable to complete the reconciliation before leaving on holiday's Compare the prior month bank 2 reconcilation (November 30, 2020), December's bank statement and the accounting records and complete the bank reconcilation for Perfect Smile at June 30, 2020 3 Perfect Smile Company 4 Bank Reconciliation BIG BANK BANK STATE 5 November 30, 2020 Cheques/Charges Bank statement balance $ 95,272.69 Book Balance $ 91.142.86 # 671 12/02 721.10 Deposit of Nov 30. in transit 315.17 # 672 12/02 304.98 $ 95,587.86 # 674 12/07 101.99 0 Deduct: 0/s cheques # 675 12/08 9,2909 650 755.66 # 677 12/10 4694 658 # 686 725.00 12/13 245.9 654 2,964.34 4,445.00 12/14 725. Adjusted bank $ 91,142.86 Adjusted book balance $ 91,142.86 # 654 2,964 NSF 12/23 1,080 # 690 12/29 14 Cash Acct No. 101 SC 12/30 115 Date Explanation PR Debit Credit Balance 30-Nov Balance 91,142.86 1-Dec Cheque # 670 GIS 704.99 90,437 87 Cheque # 671 721.10 89,716.77 1 Cheque # 672 GJ5 30498 89,411.79 1 Cheque # 673 GJS 6438.78 82,973.01 1 Cheque # 674 GUS 101.99 82,87101 > Sheet Question 1 Journal Entries Question 1 Bonus Question 2 Income Statement Question 3 Cash Flow Statement Question 4 Bank Reconciliation Question 2 12/21 1 GAS 3 reconcilition (November 30, 2020), December's bank statement and the accounting records and complete the bank reconcilatie ... TOCH WAS Pally completed by the bookkeeper who was unable to complete the reconciliation be Perfect Smile Company Bank Reconciliation November 30, 2020 Bank statement balance $ 95,272.69 Book Balance $ 91,142.86 4 5 6 7 Add: 8 Deposit of Nov 30. in transit 315.17 9 $ 95,587.86 10 Deduct: o/s cheques 11 650 755.66 12 658 725.00 13 654 2,964 34 4,445.00 14 Adjusted bank $ 91,142.86 Adjusted book balance $ 91,142.86 15 16 17 Cash Acct No. 101 18 Date Explanation PR Debit Credit Balance 19 30-Nov Balance 20 91,142.86 1-Dec Cheque # 670 GJS 21 704.99 90,437.87 1 Cheque # 671 GJS 721.10 22 89,716.77 1 Cheque # 672 GJ5 23 304.98 89,411.79 1 Cheque # 673 GJ5 24 6,438.78 82,973.01 1 Cheque # 674 GJ5 101.99 82,871.01 Sheet Question 1 Journal Entries Question 1 Bonus Question 2 Income Statement Question 3 Cash Flow Sta Calculation Mode: Automatic Workbook Statistics Perfect Smile at June 30, 2020. BIG BANK BANK STATEMENT Cheques/Charges Deposit/Credit Balance 95,272.69 94,551.59 # 671 721.10 12/02 12/02 # 672 304.98 12/01 315.17 # 674 101.99 # 675 12/07 12/08 12/10 94,561.79 94,459.79 86,162.48 175,154.06 9,290.95 12/10 993.64 # 677 469.41 EFT 89,460.99 # 686 12/13 245.94 # 658 12/14 725.00 12/14 9,414.33 # 654 12/21 2,964.34 1,080.00 174,908.12 183,597.45 180,633.11 179,553.11 179,539.05 179,424.05 NSF # 690 12/23 12/29 12/30 14.06 115.00 H M B Question 4: Bank Reconciliation (10 Marks) On June 30, 2020. Perfect Smile received its bank statement from the Big Bank. It stated that Perfect Smile had a balance of 517942405 at November 30th. The company's general ledger showed a cash balance of 586,033.21 at that date. The prior month bank reconciliation contained a deposit in transit of 5315.17 and three outstanding cheques 11650 for $755.67. cheque #658 for $725.00 and cheque 1654 for $2.964.34 Required: The bank reconciliation was partially completed by the bookkeeper who was unable to complete the reconciliation before leaving on holiday's. Compare the prior month bank 2 reconcilation (November 30, 2020), December's bank statement and the accounting records and complete the bank reconcilation for Perfect Smile at June 30, 2020 Perfect Smile Company 1 6 Add: m Question 4: Bank Reconciliation (10 Marks) On June 30, 2020, Perfect Smile received its bank statement from the Big Bank. It stated that Perfoot Smile had a balance of $179.424.05 ot November 30th. The company's general ledger showed a cash balance of 586,033.21 at that date. The prior month bank reconcilation contained a deposit in transit of $315.17 and three outstanding cheques 1650 for $755.67, choque #658 for $725.00 and cheque #1654 for $2,964.34 Required: The bank reconciliation was partially completed by the bookkeeper who was unable to complete the reconciliation before leaving on holiday's Compare the prior month bank 2 reconcilation (November 30, 2020), December's bank statement and the accounting records and complete the bank reconcilation for Perfect Smile at June 30, 2020 3 Perfect Smile Company 4 Bank Reconciliation BIG BANK BANK STATE 5 November 30, 2020 Cheques/Charges Bank statement balance $ 95,272.69 Book Balance $ 91.142.86 # 671 12/02 721.10 Deposit of Nov 30. in transit 315.17 # 672 12/02 304.98 $ 95,587.86 # 674 12/07 101.99 0 Deduct: 0/s cheques # 675 12/08 9,2909 650 755.66 # 677 12/10 4694 658 # 686 725.00 12/13 245.9 654 2,964.34 4,445.00 12/14 725. Adjusted bank $ 91,142.86 Adjusted book balance $ 91,142.86 # 654 2,964 NSF 12/23 1,080 # 690 12/29 14 Cash Acct No. 101 SC 12/30 115 Date Explanation PR Debit Credit Balance 30-Nov Balance 91,142.86 1-Dec Cheque # 670 GIS 704.99 90,437 87 Cheque # 671 721.10 89,716.77 1 Cheque # 672 GJ5 30498 89,411.79 1 Cheque # 673 GJS 6438.78 82,973.01 1 Cheque # 674 GUS 101.99 82,87101 > Sheet Question 1 Journal Entries Question 1 Bonus Question 2 Income Statement Question 3 Cash Flow Statement Question 4 Bank Reconciliation Question 2 12/21 1 GAS 3 reconcilition (November 30, 2020), December's bank statement and the accounting records and complete the bank reconcilatie ... TOCH WAS Pally completed by the bookkeeper who was unable to complete the reconciliation be Perfect Smile Company Bank Reconciliation November 30, 2020 Bank statement balance $ 95,272.69 Book Balance $ 91,142.86 4 5 6 7 Add: 8 Deposit of Nov 30. in transit 315.17 9 $ 95,587.86 10 Deduct: o/s cheques 11 650 755.66 12 658 725.00 13 654 2,964 34 4,445.00 14 Adjusted bank $ 91,142.86 Adjusted book balance $ 91,142.86 15 16 17 Cash Acct No. 101 18 Date Explanation PR Debit Credit Balance 19 30-Nov Balance 20 91,142.86 1-Dec Cheque # 670 GJS 21 704.99 90,437.87 1 Cheque # 671 GJS 721.10 22 89,716.77 1 Cheque # 672 GJ5 23 304.98 89,411.79 1 Cheque # 673 GJ5 24 6,438.78 82,973.01 1 Cheque # 674 GJ5 101.99 82,871.01 Sheet Question 1 Journal Entries Question 1 Bonus Question 2 Income Statement Question 3 Cash Flow Sta Calculation Mode: Automatic Workbook Statistics Perfect Smile at June 30, 2020. BIG BANK BANK STATEMENT Cheques/Charges Deposit/Credit Balance 95,272.69 94,551.59 # 671 721.10 12/02 12/02 # 672 304.98 12/01 315.17 # 674 101.99 # 675 12/07 12/08 12/10 94,561.79 94,459.79 86,162.48 175,154.06 9,290.95 12/10 993.64 # 677 469.41 EFT 89,460.99 # 686 12/13 245.94 # 658 12/14 725.00 12/14 9,414.33 # 654 12/21 2,964.34 1,080.00 174,908.12 183,597.45 180,633.11 179,553.11 179,539.05 179,424.05 NSF # 690 12/23 12/29 12/30 14.06 115.00 H M B Question 4: Bank Reconciliation (10 Marks) On June 30, 2020. Perfect Smile received its bank statement from the Big Bank. It stated that Perfect Smile had a balance of 517942405 at November 30th. The company's general ledger showed a cash balance of 586,033.21 at that date. The prior month bank reconciliation contained a deposit in transit of 5315.17 and three outstanding cheques 11650 for $755.67. cheque #658 for $725.00 and cheque 1654 for $2.964.34 Required: The bank reconciliation was partially completed by the bookkeeper who was unable to complete the reconciliation before leaving on holiday's. Compare the prior month bank 2 reconcilation (November 30, 2020), December's bank statement and the accounting records and complete the bank reconcilation for Perfect Smile at June 30, 2020 Perfect Smile Company