PDA

View Full Version : Can you help with the 3 column cash book?


tanyam
Sep 17, 2012, 10:19 AM
I need you to Write up a 3 Column Cash Book of this Transaction that was done with our company last year (October2011)October1 Balance brought forward :


Cash in Hand : $5000
Cash at Bank : $ 90,000
October2 Received Cash loan of $25 ,000 from Partners .
October3 Bought goods of $156,000
October4 Bought Motor Van paying by check $1,600
October5 Cash Withdrawn from the bank $25,000
October7 Paid Wages in Cash $16,000
October8 Cash Drawings $10,000
October10 Cash Sales paid directly into the bank $28,000
October12 We paid the following Accounts by Check less 10% discount in each case:
Marshal : $2,000: Linda : $1,600
Theresa : $1,800
October13 The following paid us their Accounts by Check in each case deducting 2.5% Discount
Jerry : $980
Martins 450
October15 Receive
A further Loan of $2,500
October16 We paid Brandy his account of $400 by Check
October18 Cash Sales $8,000
October21 Paid Rent in Cash $1,800
October23 Received Commission By Check $7,500
October25 The following persons paid us their Accounts by check in each Case Deducting 5% Discount :Uson $500 ; David : $4,599
October26 We paid the following Accounts paid by check in each case deducting 2% Discount
Joseph : $2000 , Tiola : 1,200
October28 Paid Insurance 8,900October29 Linda Paid Us a Check for $ 2,500 Having Deducted 200 for cash Discount.----------------------

paraclete
Sep 17, 2012, 03:24 PM
Well what you do is this, select suitable column headings one will be the bank balance, another the cash balance a third the transaction amount and write the transactions in date order in the cash book