Prepare bank reconciliation

18 Prepare bank reconciliation Cash Rolo Hardware Company's bank statement for the month of 1 April Balance 9130 5 April #301 790 April and its general ledger cash account at the end of April 17 April 3500 6 April 302 900 are as follows: 24 April 2220 6 April # 303 365 Bank Statement 27 April 51008 April # 304 840 Date Disbursements Deposits Other Balance 30 April 1750 11 April 305 2000 1 April $8 250 15 April 306 1180 3 # 300 $1220 7030 16 April # 307 1400 4 $2100 9130 18 April # 308 1260 6 #303 365 8765 20 April # 309 150 9 # 304 840 7925 22 April # 310 560 15 #302 900 7025 23 April # 311 355 16 #307 1 400 5625 3650 26 April #312 18 #305 2000 3625 Other information: Rolo had one deposit in transit of 18 3500 7125 $2100 and one outstanding cheque (#300) of $1220 at 31 19 #308 1620 5505 March. All cancelled cheque amounts agree with the bank statement 22 # 309 150 5355 REQUIRED 25 2220 7575 a Identify all deposits in transit and outstanding cheques at 26 #311 355 7220 30 April 27 +312 3650 3570b Prepare a bank reconciliation for the month of April. 28 5100 8670 c Prepare all journal entries required by Rolo at 30 April. Assume any debit memorandum is a service charge, any 30 $100 8770 credit memorandum is a collection of an account 30 130 8640 receivable, and any error relates to an account payable