Prepare double column cash book from the following transactions for the year August 2017: 01 Cash in hand 17,500 01 Cash at bank 5,000 03 Purchased goods for cash 3,000 05 Received cheque from Jasmeet 10,000 08 Sold goods for cash 7,000 10 Jasmeet’s cheque deposited into bank 12 Purchased goods and paid by cheque 20,000 15 Paid establishment expenses through bank 1,000 18 Cash sales 7,000 20 Deposited into bank 10,000 24 Paid trade expenses 500 27 Received commission by cheque 6,000 29 Paid Rent 2,000 30 Withdrew cash for personal use 1,200 31 Salary paid 6,000
Double Column Cash Book
| Dr. | Cr. | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Date | Receipts | L.F. | Cash ₹ | Bank ₹ | Date | Payments | L.F. | Cash ₹ | Bank ₹ |
| 2017 Aug 01 | Balance b/d | 17,500 | 5,000 | 2017 Aug 03 | Purchases | 3,000 | |||
| Aug 08 | Sales | 7,000 | Aug 12 | Purchases | 20,000 | ||||
| Aug 10 | Jasmeet | 10,000 | Aug 15 | Establishment Exp. | 1,000 | ||||
| Aug 18 | Sales | 7,000 | Aug 20 | Bank (C) | 10,000 | ||||
| Aug 20 | Cash (C) | 10,000 | Aug 24 | Trade Expenses | 500 | ||||
| Aug 27 | Commission | 6,000 | Aug 29 | Rent | 2,000 | ||||
| Aug 30 | Drawings | 1,200 | |||||||
| Aug 31 | Salary | 6,000 | |||||||
| Aug 31 | Balance c/d | 8,800 | 10,000 | ||||||
| Total | 31,500 | 31,000 | Total | 31,500 | 31,000 | ||||
| Sep 01 | Balance b/d | 8,800 | 10,000 |
Answer: Cash in hand = ₹8,800; Cash at bank = ₹10,000
Explanation
This question requires preparing a Double Column Cash Book with Cash and Bank columns. Key points to note:
-
Opening entries: Cash in hand (₹17,500) and Cash at bank (₹5,000) are recorded on the debit side as Balance b/d.
-
Aug 05 transaction: Cheque received from Jasmeet is NOT recorded on this date. It is recorded only when deposited into bank on Aug 10.
-
Contra Entry (Aug 20): When cash is deposited into bank, it affects both columns - Bank column (Debit) and Cash column (Credit). This is marked with 'C' for contra.
-
Aug 27: Commission received by cheque is recorded directly in the Bank column on the debit side, assuming immediate deposit.
-
Balancing: Both columns are balanced separately. The closing balances become opening balances for the next month.
Solution Steps
Step 1: Record opening balances - Cash ₹17,500 and Bank ₹5,000 on debit side as Balance b/d
Step 2: Record cash receipts (Aug 08, 18: Sales ₹7,000 each) in Cash column (Debit side)
Step 3: Record cheque deposits (Aug 10: Jasmeet ₹10,000; Aug 27: Commission ₹6,000) in Bank column (Debit side)
Step 4: Record contra entry on Aug 20 - Bank column (Debit) ₹10,000 and Cash column (Credit) ₹10,000
Step 5: Record payments - Cash: Purchases ₹3,000, Trade Exp ₹500, Rent ₹2,000, Drawings ₹1,200, Salary ₹6,000; Bank: Purchases ₹20,000, Est. Exp ₹1,000
Step 6: Balance Cash column: (17,500 + 7,000 + 7,000) - (3,000 + 10,000 + 500 + 2,000 + 1,200 + 6,000) = 31,500 - 22,700 = ₹8,800
Step 7: Balance Bank column: (5,000 + 10,000 + 10,000 + 6,000) - (20,000 + 1,000) = 31,000 - 21,000 = ₹10,000