Details of this Paper

I need to Write up a 3 Column Cash Book of the Tra...

Description

Solution


Question

I need to Write up a 3 Column Cash Book of the Transactions below in excel format: June 1 Bal brought forward : Cash in Hand : $5000 Cash at Bank : $ 90,000 June 2 Received Cash loan of $25 ,000 from Partners . June 3 Bought goods of $156,000 June 4 Bought Motor Van paying by check $1,600 June 5 Cash Withdrawn from the bank $25,000 June 7 Paid Wages in Cash $16,000 June 8 Cash Drawings $10,000 June 10 Cash Sales paid directly into the bank $28,000 June 12 We paid the following Accounts by Check less 10% discount in each case: Marshal : $2,000 Linda : $1,600 Theresa : $1,800 June 13 The following paid us thier Accounts by Check in each case deducting 2.5% Discount Jerry : $980 Martins :$450 June 15 Received a futher Loan of $2,500 June 16 We paid Brandy his account of $400 by Check June 18 Cash Sales $8,000 June 21 Paid Rent in Cash $1,800 June 23 Received Commission By Check $7,500 June 25 The following persons paid us thier Accounts by check in each Case Deducting 5% Discount :Uson $500 ; David : $4,599 June 26 We paid the following Accounts paid by check in each case deducting 2% Discount Joseph : $2000 , Tiola : 1,200 June 28 Paid Insurance :$8,900 June 29 Linda Paid Us a Check for $ 2,500 Having Deducted 200 for cash Discount.

 

Paper#11339 | Written in 18-Jul-2015

Price : $25
SiteLock