Problem 11.21 Bank reconciliation The following information was available from records and the bank statement of Baldacchino Services Ltd, on 31 May The date and the amount of each deposit as recorded during May were as follows. Date Amount Date Amount May 2 $1357.00 1647.40 1897.96 1257.36 1341.20 May 18 $1111.50 1487.16 1516.20 1636.60 1285.80 5 23 25 28 31 The number and amount of each cheque written during the month were recorded in the caslh payments journal as follows. Cheque no Amount Cheque no. Cheque no. 341 342 343 344 345 Amount 329 330 S 966.66 1163.80 1270.26 2015.00 1017.50 165.00 335 336 337 338 339 340 S1546.80 801.30 996.90 960.20 1297.60 241.20 277.40 402.80 330.00 1000.20 348.00 332 The bank statement obtained on 31 May is as shown below Bank Statement Api 30 Date May 1 Balence $17 554.10 Debits 242.00 936.16 1437.60 1163.80 127026 1357.00 1 647.40 334 65.00 101750 2015.00 1 297.60 154680 10.30 99890 332 1 B97.96 1257.38 1341.20 1111.50 18 337 338 241.20 277.40 1487.16 341 343 330.00 May 25 28 1518.20 1636.60 1 00020 31 268.00 Dishon. Cheque 32.00 Account Fees 1250.00 15 538.38 15939.98 May 31 Balance $17955.10 On 31 May, the bank debited the account for S268.00 for a customer cheque (deposited in April returned because of insufficient funds, and for $32.00 for account fees. On 31 May the bank also credited the account for $1250.00 for the proceeds of a non-interest-bearing note receivable that it had collected on behalf of the c ompany Outstanding cheques at the last statement date, 30 April, were: no. 320 for $938.16, no. 328 for S242.00, and no. 326 for $813.00; outstanding deposits were $1437.60. The accountant discovered that cheque no. 336 in payment for the purchase of office equipment) was correctly issued for S810.30 but incorrectly recorded in the cash paynents journal as $801.30 The balance in the Cash at Bank account in the company's records on 1 May was $16 998.54. Required (a) Complete the cash journals and post the totals to the Cash at Bank account. Show the Cash at Bank account (T-account form) after it had been balanced on 31 May (b) Prepare a bank reconciliation statement as at 31 May LO3)