Question

Question 1.

Khan is running a flower shop since last five years successfully. He has five employees like two salesmen, one cleaner, one shop manager and one accountant. Business growing continuously and expending, so he has opened some more shops in other cities. Due to too much load in accountant department, he decided to do some task himself like to be maintaining cash book, bank dealing and other cash related issues. Ali is commerce graduate, but he is not good in MS. Excel, being a friend you decided to teach him how to maintain three column cash books in MS. Excel The records for the

month of March 2020 transactions are as mentioned below

2020

March .

1. Cash in hand OMR 17,000 and balance at bank OMR 9,500.
2. Received commission by cheque OMR 5,000.

4. Issued cheque to XYZ LLC for cash purchase of furniture OMR 1,100.
5. Sold goods to M/S Muhammed for cash OMR 2,500.

8. Purchased a used office equipment OMR 1,200. Spent OMR 50 on its repair.

10. Received a purchase order for OMR. 250 from KM LLC.

11 Issued a cheque for OMR 6,500 to ABC Traders in full settlement of his account OMR 6,750.

12. Withdrew from bank OMR 1,000.

15. Received a cheque OMR 2,500 from CDC traders settled his account OMR2,800.  

18. Withdrew for personal use OMR 1,000.  

20. Purchased machinery from ABC LLC for OMR 5,000 and paid 40% by cash and balance paid by         cheque.

24. Paid ROP fine OMR 200. (Online).

26. Received a cheque for commission OMR 500 from R. & Co. and deposited into bank.
27. Paid rent and wages OMR 800 and OMR 2,700 by bank respectively.
28. Received a cheque of OMR 18,900 from Ali in full settlement of his account OMR 19,000.

29. Paid Utility bills OMR 200 by cheque.

31. Paid carriage charges OMR. 50 by cash.

Required: -Prepare three columns cash book for the month using MS Excel.

Answer 1