Prepare a Cash Book with Cash and Bank columns from the following information for the month of December 2011 in the Books of O'Neil:

2016

Dec. 1 Cash in Hand ₹ 2,780; Bank Overdraft ₹ 3,125.

2 Cheque worth ₹ 400 issued to the petty cashier.

5 ₹ 350 was paid to Hari & Sons for the supply of stationery on this day.

7 Received a cheque worth ₹ 600 from Pramod against sale of goods.

10 Received ₹ 1,200 for sale of goods.

11 The cheque which was received from Pramod on 7th December was endorsed as favour of Morgan together with ₹ 1,400 in cash.

15 Received ₹ 950 from Sheila.

23 Murarilal paid ₹ 2,000 in cash and ₹ 3,000 in cheque after receiving a discount of ₹ 200 for goods sold to him in November. The cheque was immediately deposited into the Bank.

26 Bought goods worth ₹ 1,700 from Rustom and paid by cheque after receiving a discount of ₹ 170.

30 Interest on overdraft ₹ 50 was charged by the Bank.

30 Cash in excess of ₹ 1,000 was deposited into the Bank.

Open in App

Solution

Cash Book

Dr. Cr.

Date Particulars L.F. Cash (Rs) Bank (Rs) Date Particulars L.F. Cash (Rs) Bank (Rs)

2016 2016

Dec. 01 Balance b/d 2,780 Dec. 01 Balance b/d 3,125

Dec. 10 Sales A/c 1,200 Dec. 02 Petty Expenses A/c 400

Dec. 15 Sheila 950 Dec. 05 Stationery A/c 350

Dec. 23 Murarilal 2,000 3,000 Dec. 11 Morgan 1,400

Dec. 30 Cash A/c C 4,180 Dec. 26 Purchase A/c 1,530

Dec. 30 Interest on O/D 50

Dec. 30 Bank A/c C 4,180

Dec. 30 Balance c/d 1,000 2,075

6,930 7,180 6,930 7,180

2017

Jan. 01 Balance b/d 1,000 2,075

Working Notes:

WN1

Journal Proper

Date Particulars L.F. Debit Amount (Rs) Credit Amount (Rs)

2016

Dec. 07 Cheques-in-Hand A/c Dr. 600

To Pramod 600

(Cheque received from Pramod)

Dec. 11 Morgan Dr. 600

To Cheques-in-Hand A/c 600

(Cheque endorsed to Morgan)

WN2 Cash Deposited into the Bank

Suggest Corrections

Similar questions

The following are the Cash Book and Pass Book extracts of Mr. Anil for the month of May 2011. From this information you are required to prepare a Bank Reconciliation Statement as on 31^st May 2011.

Cash Book (Bank Column Only)
Dr.			Cr.
Date	Particulars	Rs	Date	Particulars	Rs
2011 May 4	Ankita’s A/c	2,300	2011 May 1	By Balance b/d	7,500
11	To Kavita;s A/c	3,700	4	By Roky’s A/c	2,000
14	To Sales A/c	14,500	6	By Mamata’s A/c	2,500
15	To Furniture A/c	2,000	9	By Sonali’s A/c	4,000
22	To Anita’s A/c	1,500	15	By Manjiri’s A/c	1,500
26	To Ganesh’s A/c	4,000	17	By Purchases A/c	7,000
28	To Kamal’s A/c	3,000	20	By Drawings A/c	2,400
30	To Prakash’s A/c	1,000	24	By Machinery A/c	10,000
30	Too Balance’s c/d	8,500	27	By Archan’s A/c	3,600
		40,500			40,500

Pass Book
Dr.			Cr.
Date	Particulars	Rs	Date	Particulars	Rs
2011 May 1	To Sonali’s A/c	4,000	2011 May 1	By Balance b/d	13,400
2	To Manjiri’s A/c	1,500	4	By Anita’s A/c	1,500
14	To Cash A/c	10,000	6	By Ganesh’s A/c	4,000
17	To Archana’s A/c	3,600	17	By Cash A/c	14,500
			18	By Kamal’s	3,000
			19	By Prakash’s A/c	1,000

Q. Prepare a Cash Book with Cash and Bank Columns from the following particulars∶−

2017		(₹)
Feb. 1	Cash in Hand ₹ 14,800; Bank Overdraft ₹ 32,700
4	Sold goods, received cheque (deposited same day)	4,950
5	Sold goods to Navin on Credit	10,000
8	Received from Navin a cheque for ₹ 9,500 in settlement of his account.
10	Sold goods to Murlidhar on Credit	6,000
12	Cheque received from Navin endorsed to Praveen in full settlement of his account	9,800
15	Received cheque from Ram	12,800
	Allowed him discount	200
16	Paid into Bank (including Ram's cheque)	15,000
18	Cheque from Ram returned dishonoured and bank debits our account in respect of charges on this cheque ₹ 20. Discount not withdrawn.
19	Received the amount of returned cheque and bank charges in cash from Ram.
20	Instructed the bank to issue a bank draft for ₹ 5,000 in favour of Shyam. Bank charged ₹ 40 for issuing the draft.
22	Murlidhar settled his account by means of a cheque for ₹ 6,200; including ₹ 200 as the interest charged from him. Lodged the cheque into bank.
24	Paid ₹ 5,000 by cheque for cash purchases.
25	Sudhir who owed us ₹ 8,000 became bankrupt and paid us 50 paise per rupee.
28	Paid salary to Manohar Lal	3,000
28	Banked	20,000

Q. Prepare a Cash Book with Cash and Bank Columns from the following transactions:−

2017
March 1	Cash in hand ₹ 1,800 and at Bank ₹ 11,000.
5	Received a cheque for commission ₹ 3,960. Cheque was immediately deposited into bank.
7	Bought goods for cheque ₹ 7,000.
8	Bought goods for cash ₹ 500.
10	Purchased a Computer and payment made by cheque of ₹ 5,000.
14	Paid Trade Expenses ₹ 105.
16	Paid into Bank ₹ 1,000.
18	Ramesh who owed us ₹ 500 became bankrupt and paid us 50 paise in a ₹.
20	Received ₹ 400 from Manohar and allowed him discount ₹ 10.
23	Withdrew from Bank ₹ 400.
23	Paid ₹ 300 to Ghanshyam Dass & Co. They allowed us discount ₹ 10.
24	Received ₹ 2,000 from Hari Ram and deposited the same into Bank.
25	Withdrew from Bank for private expenses ₹ 300.
27	Sold goods for cash ₹ 200.
28	Received cheque for goods sold ₹ 9,000.
29	Received repayment of a loan of ₹ 5,000 and deposited ₹ 3,000 out of it into Bank.
30	Bank charges as per Book ₹ 5.

From the following Cash Book (with cash and Bank columns) prepare necessary Ledger Accounts and balance them.

Cash Book (with Cash & Bank Columns)
Dr.						Cr.
Date	Particulars	L.F.	Cash Rs	Bank Rs	Date		Particulars	L.F	Cash Rs	Bank Rs
2011 Apr.					2011 Apr.
1	To Balance b/d		400	1,000	1		By Purchases A/c		700
2	To Ram ‘s A/c		980		3		By Rent A/c			200
3	To Sales A/c			4,000	10		By Sita’ s A/c		300
7	To Interest A/c		120		8		By Salaries A/c			450
10	To Sales A/c		500		10		By Purchases A/c			1,350
25	To Bank A/c		2,000		30		By Cash A/c			2,000
					30		By Balance c/d		3,000	1,000
			4,000	5,000					4,000	5,000
May 1	To Balance b/d		3,000	1,000

Q. Prepare double column cash book with cash and bank column from the following information:
2017
Sept. 1 Cash in hand Rs. 75,000
Sept. 1 Bank overdraft Rs. 35,000

Join BYJU'S Learning Program

2016
Dec. 1	Cash in Hand ₹ 2,780; Bank Overdraft ₹ 3,125.
2	Cheque worth ₹ 400 issued to the petty cashier.
5	₹ 350 was paid to Hari & Sons for the supply of stationery on this day.
7	Received a cheque worth ₹ 600 from Pramod against sale of goods.
10	Received ₹ 1,200 for sale of goods.
11	The cheque which was received from Pramod on 7th December was endorsed as favour of Morgan together with ₹ 1,400 in cash.
15	Received ₹ 950 from Sheila.
23	Murarilal paid ₹ 2,000 in cash and ₹ 3,000 in cheque after receiving a discount of ₹ 200 for goods sold to him in November. The cheque was immediately deposited into the Bank.
26	Bought goods worth ₹ 1,700 from Rustom and paid by cheque after receiving a discount of ₹ 170.
30	Interest on overdraft ₹ 50 was charged by the Bank.
30	Cash in excess of ₹ 1,000 was deposited into the Bank.

Cash Book
Dr.									Cr.
Date	Particulars	L.F.	Cash (Rs)	Bank (Rs)	Date	Particulars	L.F.	Cash (Rs)	Bank (Rs)
2016					2016
Dec. 01	Balance b/d		2,780		Dec. 01	Balance b/d			3,125
Dec. 10	Sales A/c		1,200		Dec. 02	Petty Expenses A/c			400
Dec. 15	Sheila		950		Dec. 05	Stationery A/c		350
Dec. 23	Murarilal		2,000	3,000	Dec. 11	Morgan		1,400
Dec. 30	Cash A/c	C		4,180	Dec. 26	Purchase A/c			1,530
					Dec. 30	Interest on O/D			50
					Dec. 30	Bank A/c	C	4,180
					Dec. 30	Balance c/d		1,000	2,075
			6,930	7,180				6,930	7,180
2017
Jan. 01	Balance b/d		1,000	2,075

Journal Proper
Date	Particulars			L.F.	Debit Amount (Rs)	Credit Amount (Rs)
2016
Dec. 07	Cheques-in-Hand A/c		Dr.		600
		To Pramod				600
	(Cheque received from Pramod)

Dec. 11	Morgan		Dr.		600
		To Cheques-in-Hand A/c				600
	(Cheque endorsed to Morgan)