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
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 .
- Cash in hand OMR 17,000 and balance at bank OMR 9,500.
- Received commission by cheque OMR 5,000.
- Issued cheque to XYZ LLC for cash purchase of furniture OMR 1,100.
- 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).
- Received a cheque for commission OMR 500 from R. & Co. and deposited into bank.
- Paid rent and wages OMR 800 and OMR 2,700 by bank respectively.
- Received a cheque of OMR 18,900 from Ali in full settlement of his account OMR 19,000.
- 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started