Spicy Potato Company's cash T-account shows the following information: Date Cash Description Amount Date 01-Dec Balance 180,000 05-Dec Deposit 9,000 16-Dec Deposit 15,000 31-Dec Deposit 20,000 Description 02-Dec Cheque #910 06-Dec Cheque #905 14-Dec Cheque #917 15-Dec Cheque #911 29-Dec Cheque #920 30-Dec Cheque #921 31-Dec Cheque #922 Amount 16,000 2,000 12,000 9,000 8,000 35,000 14,500 31-Dec 127,500 The following information comes from the company's bank statement: Deposits Balance Date Description (Withdrawals) ie. Running Total 01-Dec Opening balance $ 180,000 $ 180,000 02-Dec Cheque #910 16,000 164,000 05-Dec Deposit 9,000 173,000 06-Dec NSF cheque 5,000 168,000 06-Dec Cheque #905 20,000 148,000 14-Dec Cheque #917 12,000 136,000 15-Dec Cheque #911 9,000 127,000 15-Dec EFT Collection 25,000 152,000 TEAOAA The following information comes from the company's bank statement: Deposits Balance Date Description (Withdrawals) ie. Running Total 01-Dec Opening balance $ 180,000 $ 180,000 02-Dec Cheque #910 16,000 164,000 05-Dec Deposit 9,000 173,000 06-Dec NSF cheque 5,000 168,000 06-Dec Cheque #905) 20,000 148,000 14-Dec Cheque #917 12,000 136,000 15-Dec Cheque #911 9,000 127,000 15-Dec EFT Collection 25,000 152,000 16-Dec EFT Payment 1,200 150,800 16-Dec Deposit 15,000 165,800 29-Dec Cheque #920 8,000 157,800 31-Dec Bank charges 10 157,790 31-Dec Interest 5 157,795 31-Dec Ending balance $ 157,795 Additional information: a. The correct amount of Cheque #905, a payment on account was $20,000. The company's bookkeeper made an error. b. The EFT payment was for monthly maintenance costs. C. The EFT collection was for consulting work the company previously billed. d. The NSF cheque was from a client named A. Hamilton REQUIRED: $ 01-Dec Opening balance 02-Dec Cheque #910 05-Dec Deposit 06-Dec NSF cheque 06-Dec Cheque #905 14-Dec Cheque #917 15-Dec Cheque #911 15-Dec EFT Collection 16-Dec EFT Payment 16-Dec Deposit 29-Dec Cheque #920 31-Dec Bank charges 31-Dec Interest 31-Dec Ending balance 180,000 $ 16,000 9,000 5,000 20,000 12,000 9,000 25,000 1,200 15,000 8,000 10 5 $ 180,000 164,000 173,000 168,000 148,000 136,000 127,000 152,000 150,800 165,800 157,800 157,790 157,795 157,795 Additional information: a. The correct amount of Cheque #905, a payment on account was $20,000. The company's bookkeeper made an error. b. The EFT payment was for monthly maintenance costs. c. The EFT collection was for consulting work the company previously billed. d. The NSF cheque was from a client named A. Hamilton. REQUIRED: Based on the information above, prepare a bank reconciliation. NO JOURNAL ENTRIES ARE REQUIRED
