Question: plz i need help to complete must be submitted in 2 hours I need you to Write up a 3 Column Cash Book of the


I need you to Write up a 3 Column Cash Book of the Transaction that was done with our company last year (December2007) November 1 Balance brought forward : Cash in Hand : $100,000 Cash at Bank : $95,000 November 2 Received Cash loan of $28,000 from Partners. November 3 Bought goods of $159,000 by Check November 4 Bought Motor Van paying by check $2,600 November 5 Cash Withdrawn from the bank $27,000 November 7 Paid Wages in Cash $18,000 November 8 Cash Drawings $14,000 from the Bank November 10 Cash Sales paid directly into the bank $30,000 November 10 Cash Sales paid directly into the bank $30,000 November 12 We paid the following Accounts by Check less 10% discount in each case: Marshal : $3,000 Linda : $1,800 Theresa : $2,000 November 13 The following paid us their Accounts by Check in each case deducting 2.5% Discount Jerry : $1180 Martins : $550 November 15 Received a further Loan of $3,500 November 16 We paid Brandy his account of $700 by Check November 18 Cash Sales $9,000 November 21 Paid Rent in Cash $1,900 November 23 Received Commission By Check $9,500 November 21 Paid Rent in Cash $1,900 November 23 Received Commission By Check $9,500 November 25 The following persons paid us their Accounts by check in each Case Deducting 5% Discount : Uson $800; David : $6,599 November 26 We paid the following Accounts paid by check in each case deducting 2% Discount Joseph : $4000, Tiola : 1,900 November 28 Paid Insurance :\$9,900 November 29 Linda Paid Us a Check for \$ 2,500 Having Deducted 600 for cash Discount. Have done and submitted in .XLS
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
