Al Diwan Dates is a supplier of dates in Dakhliya region. The Business has been expanded to produce Omani Halwa and has a recently set up a retail store in Nizwa Grand Mall. The business in this new store is pretty good and so there is lot of cash and bank transactions during each month. In the month of April 2020 AL Diwan Dates has observed that some of the entries made in the cash book and bank book are not proper. The have recently appointed you as a accountant for the branch in Nizwa Grand Mall. Based on your understanding, about the Topic discussed above, you are required to write the cash /bank book for the month of April 2020. The transaction for the month of April 2020 are given below. Note ** in case of shortage of funds in bank, Overdraft facility has been arranged.

1-Apr Opening Balance of Cash is RO 25,000 and of Bank is RO 625,000

3-Apr Withdraw cash from Bank RO 62,500

4-Apr Purchased goods from Lucent Electricals RO 125,000 and issued cheque after deducting 5% discount

5-Apr Sold goods to Abdur Rahman for RO 5,000 on 15 days credit

7-Apr Paid Elecricity Charges for the month of Mar RO 5000.

8-Apr Purchased Room Heaters from Spherehot Trading for RO 37,500 and paid the bill by cheque

10-Apr Received cash from old customers RO 7,500 for sale made in the last month.

11-Apr Al Jadidi Enterprise purchased goods from us for RO 10,000 less cash discount 5%.

12-Apr Withdrawn from Bank RO 12,500 for office use

14-Apr Purchased goods from M/S Obaidani for RO 15,000 and paid Cheque for RO 15,000

15-Apr Purchased Lockers for office from M/S Fahmy RO 20,000 for 50% was paid in cash the balance amount was to be paid in 10 equal monthly instalment from the end of this month.

17-Apr The police imposed a fine for RO 1,000 for crossing the red signal .

20-Apr Received cash from Abdur Rahman

22-Apr Sold goods to Arabisc for cash RO 8,750

25-Apr Purchased goods from Al Jamoudi for RO 20,000 of which RO 7,500 was to be paid in cash

27-Apr Paid for revewal of resident card for workers RO 1,500

28-Apr Purchased Stone Cutters from CAT for RO 30,000 by paying 10% of the value and balance payable in monthly instalments of RO 500 starting from next month.

29-Apr Paid medical insurance premium of Staff for RO 1,650

30-Apr Deposit in Bank RO 37,500

30-Apr Paid Salary to Staff for April RO 8,750 by direct debit in the staff bank account. Note: need solving in Microsoft Excel