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 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 thier Accounts by Check in each case deducting 2.5% Discount
Jerry: $1180
Martins : $550
November 15 Received a futher
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 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.



Answer :

Answer:

| Date       | Particulars                  | Cash      | Bank      |
|------------|------------------------------|-----------|-----------|
| Dec 1      | Balance b/f                  | $100,000  | $95,000   |
| Dec 2      | Cash loan from partners      | $28,000   |           |
| Dec 3      | Bought goods by check        |           | $159,000  |
| Dec 4      | Bought motor van by check    |           | $2,600    |
| Dec 5      | Cash withdrawn from bank     | $27,000   |           |
| Dec 7      | Paid wages in cash           | $18,000   |           |
| Dec 8      | Cash drawings from bank      | $14,000   |           |
| Dec 10     | Cash sales into bank         | $30,000   |           |
| Dec 12     | Paid accounts by check       |           |           |
|            | (Marshal, Linda, Theresa)    | $6,300    |           |
| Dec 13     | Received accounts by check   |           |           |
|            | (Jerry, Martins)             | $1,730    |           |
| Dec 15     | Received further loan        | $3,500    |           |
| Dec 16     | Paid Brandy's account by check|          | $700      |
| Dec 18     | Cash sales                   | $9,000    |           |
| Dec 21     | Paid rent in cash            | $1,900    |           |
| Dec 23     | Received commission by check |           | $9,500    |
| Dec 25     | Received accounts by check   |           |           |
|            | (Uson, David)                | $1,180    | $6,599    |
| Dec 26     | Paid accounts by check       |           |           |
|            | (Joseph, Tiola)              | $3,920    | $1,900    |
| Dec 28     | Paid insurance               | $9,900    |           |
| Dec 29     | Received check from Linda    |           | $1,900    |