Explore BrainMass

Explore BrainMass

    Three Column Cash Book

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com June 3, 2020, 10:43 pm ad1c9bdddf

    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.