Required:

Write up an updated cash book

Draw up a bank reconciliation Statement.

1. The following is the bank account for Tony Treble for the month of November 2018 CASHBOOK DATE DETAILS AMT ($) DATE DETAILS AMT ($) Nov-01 Balance b/d 25,000 Nov-06 NHT 6,000 Nov-07 T Cowan 15,000 Nov-06 Farers 5,000 Nov-09 Devon House 7,000 Nov-30 HILO Supermarket 4,500 Nov-21 Busby Grange 10,000 Nov-30 Courts Ja. Ltd 12,000 Nov-24 Boscobel Beach 20,000 Nov-06 Vandals 4,000 Nov-29 Club A Bar 20,000 Nov-06 Pagoda 15,000 Nov-30 Tuff Gong 25,000 Nov-06 Bob Pansy 4,000 Nov-06 Derrick Morgan 3,500 Nov-06 Marcia Tulloch 10,000 Nov-30 Balance c/d 58,000 122,000 122,000 However, his bank statement from the National Commercial Bank showed the following details Bank statement DATE DETAILS DR CR BAL Nov-01 Balance b/d 25,000 Nov-02 Direct Debit 4,000 21,000 Nov-10 Farers 5,000 16,000 Nov-12 T Cowan 15,000 31,000 Nov-17 Devon House 7,000 38,000 Nov-21 HILO Supermarket 4,500 33,500 Nov-22 Courts Ja. Ltd 12,000 21,500 Nov-26 Boscobel Beach 20,000 41,500 Nov-29 Vandals 4,000 37,500 Nov-29 Boscobel Beach (refer to drawer) 20,000 17.500 Nov-30 Derrick Morgan 3,500 14,000 Nov-30 Bank charges 2.000 12,000 Nov-30 Credit Transfer 17,000 29,000