OM DATA VIEW ? ?? Font Name - Font Sie E Insert Column Delete Cal 2 TabStop Wrap Text 3 Overline Copy B D I Merge Cell 3. Insert Row 7. Delete Ros CK HERE TO SAVE YOUR WORK 4,800 B216 ? B ? D E F G H 1 ABC Limited 3 Bank Statement 4 June 30 ES Amounts Deducted from Amounts Added to 16 Date Description Account (Debits) Account (Credits) 57 May 31 18 Jun. 1 Cheque, No. 2500 2.560 19 1 Deposit 2 Cheque, No. 2501 1.370 01 4 Deposit 3,720 8 Cheque, No. 2503 6,530 13 9 Retumed cheque NSF, K. Price 925 14 NSF Fee 30 75 11 Deposit 5,875 76 16 Cheque, No. 2504 3.455 17 23 Deposit 6,430 18 29 Cheque, No. 2508 1375 79 30 Bank service charges SO 80 81 ABC's cash receipts and payments for the month of August are presented below: 82 Cash Receipts Cash Payments 83 Date Amount Date Number Amount 84 Jun. 4$ 3,720 Jun. 6 2503 $6,530 85 11 5,875 8 2504 3.455 186 23 6,430 13 2505 1,020 87 30 8.390 15 2506 750 88 24,415 19 2507 1,500 89 22 2508 1375 190 25 2509 2,800 191 29 2510 3.350 92 $ 20,780 193 Balans 15.180 12,620 17.420 16,050 19,770 13.240 12,315 12,285 18,160 14,705 21.135 19,760 19.710 18 ? ? ? ? ? 194 Required: 195 D) (3.5 marks). Calculate the cash balance per books at June 30. prior to reconciliation 03 ii) (1.5 marks). Determine the amount of deposits in transit at June 30. 04 05 06 07 08 09 10 iii) (6 marks). List the outstanding cheques at June 30. 157 C 158 ABC Limited reconciled cash balance per bank, 514.250, agreed with the reconciled cash balance per book after the bank reconciliation at May 31. The 159 reconciliation shows a deposit in transit for 4800 and three outstanding cheques: 12500 - $2.560, 12501 - 51370 and 2502 - $1.200. The Jane bank 160 statement showed the following