The October 31 bank statement for Henderson Ltd had an ending balance of $xxx (student to work out the balance). The cash account according to the company's records was $16,350 as at the same date. The following additional data was available: 1. 2. There were cheques totalling $3,718 were issued to the suppliers and were recorded as payments in the company's accounting records but were not shown on the bank statement as at October 31. A cheque in the amount of $650.00 deposited by Hanley on October 21st had been returned NSF and the bank charged a $12.00 fee on the item. Hanley had not known about the returned item until it received the bank statement. Our cheque #321, which was a payment for rent of $1,120, was incorrectly recorded in the bank statement as $1,210. The bank statement listed a payment for $630 that was mistakenly put in our company's bank account. It should have gone to another company's account. 3. 4. Required: Prepare the bank reconciliation for Hanley Ltd for the month of October