Revision : CASH BOOK

Note : Tutor kindly copy the question at below into Microsoft Excel and do the working for the answers .

Q1: Prepare Cash Book for the month of June 2014 from the following particulars:

REVISION: CASH BOOK AND PETTY CASH Question 1 2014 June |Balance brought forward : Cash RM420; Bank RM4,940 2 The following paid us by cheque, in each case deducting a 5% cash discount: S Braga RM820; L Pine RM320; G Hodd RM440 M Rae RM1,040 3 Cash sales paid direct into the bank RM740 5 Paid rent by cash RM340 6 We paid the following accounts by cheque, in each case deducting 2% cash discount: M Peters RM360; G Graham RM960; F Bell RM400 8 Withdrew cash from the bank for business use RM400 10 Cash sales RM1,260 12 B Age paid us their account of RM280 by cheque less RM4 cash discount 14 Paid wages by cash RM540 16 We paid the following accounts by cheque: R Todd RM310 less cash discount RM15, F Dury RM412 less cash discount RM12 20 Bought fixtures by cheque RM4,320 24 Bought lorry paying by cheque RM14,300 29 Received RM324 cheque from A Line 30 Cash sales RM980 30 Bought stationery paying by cash RM56