N $ Required: Compare the bank statement and the accounting records and prepare the bank reconcilation for Perfect Smile Company at December 31, 2020. A template for the statement is provided below. 2 See the "How to Conditional Formatting" tab for guidance on how to find the reconciling items 3 4 5 Perfect Smile Company 6 Bank Reconciliation 7 November 30, 2020 8 Bank statement balance $93,866.84 Book 96,356,00 9 Add: 10. Deposit of Nov 30, in transit 659.90 11 $94,526.74 12 Deduct: o's cheques Deduct 13 190 833 01 NSF Cheque plus 6,221.61 14 198 725.00 Bank service charge 130.00 6,351,61 15 194 2964.34 4,522 35 16 Adjusted bank $90,004,39 Adjusted book $ 90,004.39 17 18 19. Cash Acc No 101 20 Date Explanation PR Debit Credit Balance 21 30-Nov Balance 90,004.39 22 01-Dec Cheque # 210 GJ5 617 43 89,386.95 23 1 Cheque # 211 GU5 782.48 88,604.47 24 1 Cheque # 212 GJ5 188 25 88,416.22 25 1 Cheque # 213 GJ5 8,928 29 79,487 93 26 1 Cheque # 214 GJ5 859.35 78,628 58 27 1 Cheque # 215 GJ5 9.391.94 69,236.64 28 1 Cheque # 220 GJ6 1,383.70 29 67.85294 9 Deposit GJG 160.66 30 68,013.60 9 Cheque # 217 GJ6 74.21 67 939.40 31 9 Cheque # 226 GU6 4.98452 62,954.88 18 Deposit GJ6 3,112 96 33 66,067 84 20 Cheque # 221 GJ6 34 10.17 66.057.67 27 Cheque # 230 GJG 35 84.79 29 Deposit 65,972.88 GJ6 4,551.22 36 70,524.10 FREE 32 BIG BANK BANK STATEMENT Cheques/Charges Deposit/Credit 659.90 160.66 42,667.06 # 210 # 212 # 213 # 215 # 220 # 226 # 198 # 194 NSF # 221 SC 12/02 12/02 12/07 12/08 12/10 12/13 12/14 12/21 12/23 12/29 12/30 617.43 188.25 12/01 8,928.29 9,391.94 12/10 1,383.70 EFT 4,984.52 725.00 12/14 2,964.34 1,850.00 10.17 115.00 Balance 93,866.84 93,249.41 93,721.05 84,792.76 75,561.49 116,844.85 111,860.34 114,248.30 111,283.96 109,433.96 109,423.78 109,308.78 3,112.96 Perfect Smile Company Bank Reconciliation 31-Dec-20 39 40 41 42 43 44 45 46 47 49 49 50 51 52 53 +