Share
Explore BrainMass

# Three Column Cash Book

Help writing up a 3 Column Cash Book of the Transaction that
was done with our company last month (March2009)

March1 Balance brought forward :
Cash in Hand : \$5000
Cash at Bank : \$ 90,000
March2 Received Cash loan of \$25 ,000 from Partners .
March3 Bought goods of \$156,000
March4 Bought Motor Van paying by check \$1,600
March5 Cash Withdrawn from the bank \$25,000
March7 Paid Wages in Cash \$16,000
March8 Cash Drawings \$10,000
March10 Cash Sales paid directly into the bank \$28,000
March12 We paid the following Accounts by Check less 10% discount in each case:
Marshal : \$2,000

: Linda : \$1,600
Theresa : \$1,800
March13 The following paid us their Accounts by Check in each case
deducting 2.5% Discount
Jerry : \$980
Martins :\$450
March15 Received a further Loan of \$2,500
March16 We paid Brandy his account of \$400 by Check
March18 Cash Sales \$8,000
March21 Paid Rent in Cash \$1,800
March23 Received Commission By Check \$7,500
March25 The following persons paid us their Accounts by check in each
Case Deducting 5% Discount :Uson \$500 ; David : \$4,599
March26 We paid the following Accounts paid by check in each case
deducting 2% Discount
Joseph : \$2000 , Tiola : 1,200
March28 Paid Insurance :\$8,900

March29 Linda Paid Us a Check for \$ 2,500 Having Deducted 200 for cash Discount

#### Solution Preview

Dear student,
Solution to your problem is sent in excel ...

#### Solution Summary

This solution contains a three column cash book of company transactions in an Excel file.

\$2.19