I need you to Write up a 3 Column Cash Book of the Transaction that was done with a random company last two month (March 2014) November 1Balance...

I need you to Write up a 3 Column Cash Book of the Transaction that was done with a random company last two month (March 2014)

November 1Balance brought forward :

Cash in Hand : $5000

Cash at Bank : $ 90,000

November 2 Received Cash loan of $25 ,000 from Partners .

November 3Bought goods of $156,000

November 4 Bought Motor Van paying by check $1,600

November 5 Cash Withdrawn from the bank $25,000

November 7 Paid Wages in Cash $16,000

November 8 Cash Drawings $10,000

November 10 Cash Sales paid directly into the bank $28,000

November 12 We paid the following Accounts by Check less 10% discount in each case: Marshal : $2,000, Linda : $1,600 Theresa : $1,800

November 13 The following paid us their Accounts by Check in each case deducting 2.5% Discount: Jerry : $980, Martins :$450

November 15 Received a further Loan of $2,500

November 16 We paid Brandy his account of $400 by Check

November 18Cash Sales $8,000

November 21 Paid Rent in Cash $1,800

November 23 Received Commission By Check $7,500

November 25 The following persons paid us their Accounts by check in each

Case Deducting 5% Discount: Uson $500 ; David : $4,599

November 26 We paid the following Accounts paid by check in each case deducting 2% Discount

Joseph : $2000 , Tiola : 1,200

November 28 Paid Insurance :$8,900

November 29 Linda Paid Us a Check for $ 2,500 Having Deducted 200 for cash Discount.