Question

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

Answer 1

Al Diwan Dates
nizwa Grand Mall Branch
Cash Book
Date	Particulars	Amount (Debit) (RO)	Date	Particulars	Amount (Credit) (RO)
01-04-2020	To Balance b/f (Opening Balance)	25,000	07-04-2020	By Electricity Charges	5,000
03-04-2020	To Bank Account	62,500	15-04-2020	By M/s Fahmy	10,000
10-04-2020	To Receivables (Old Customers)	7,500	17-04-2020	By Penalty (Fine )	1,000
11-04-2020	To Al Jadidi (Sales)	9,500	25-04-2020	By Al Jamoudi	7,500
20-04-2020	To Abdul Rahman (Receivables)	5,000	27-04-2020	By Resident Card Expenses	1,500
22-04-2020	To Cash Sales	8,750	28-04-2020	By CAT	3,000
			29-04-2020	By Medical Insurance Premium	1,650
			30-04-2020	By Bank	37,500
			30-04-2020	By M/s Fahmy	1,000
			30-04-2020	By Balance C/f	50,100
		1,18,250			1,18,250

Al Diwan Dates
nizwa Grand Mall Branch
Bank Book
Date	Particulars	Amount (Debit) (RO)	Date	Particulars	Amount (Credit) (RO)
01-04-2020	To Balance b/f (Opening Balance)	6,25,000	03-04-2020	By Cash	62,500
30-04-2020	To Cash	37,500	04-04-2020	By Lucent Electricals	1,18,750
			08-04-2020	By Spherehot Trading	37,500
			12-04-2020	By Office Expenses	12,500
			14-04-2020	By M/s Obaidani	15,000
			30-04-2020	By Salaries to Staff	8,750
			30-04-2020	By Balance C/f	4,07,500
		6,62,500			6,62,500