Tuesday, June 21, 2011

Cash book extract



The above is an extract of a cash book from an excel format. This is a simple copy highlighting the transactions that normally happen in the cash book. Just to clarify some items, let us start with the columns:
  1. there are are seven columns in this extract. The date, description, Dr and Cr columns are all mandatory while the rest (Check no, Payee and running balance) are optional.
  2. the cash book has to be titled by the company name and be indicated as a cash book ( see the first two lines)
  3. the date is the transaction date, payee is the name of the person paid or issued the check. Take for example line number four of the cash book. ABC ltd purchased three blackberry phones each @$300 from Amazon Ltd. ABC ltd bought the phones on 7th February and issued the check in the name of Amazon Ltd of $900
  4. The running balance represents the amount outstanding on a particular date. On 28th of February the closing balance was  $ 33,827 while on 2nd February the account had a balance of 40,500 

No comments:

Post a Comment