All money paid into or out of a bank account or cash box needs to be
replicated within the bookkeeping system – the book to do this in is the Cash
Book because it is the record of what happens with the money received or spent.
In this case, cash is a lose term covering not only paper
money and coins but also cheques/checks, direct credits, electronic transfer
payments, and so on.
All computerized bookkeeping programs use a cash book but you
might not see the words Cash Book, you might just see something like Bank
Entries, or Spend and Receive Money or Transactions.
Let's get started with the cash book format...
For a very basic cash book spreadsheet, to help you do manual bookkeeping, you need to take a blank sheet of printer paper and do the following using a ruler and pen or pencil (there are picture graphics below):
place the page in front of you either in portrait view or in landscape view – either is fine
draw a border around the page
draw five columns – see our example below for an idea of column sizes
draw one row at the top of the page for entering the heading names of each column
fill up the remainder of the page with rows for writing in daily cash book entries
Your headings will be:-
Details (or Description)
Money In (or Income)
Money Out (or Expenses)
Cash Book Format Sample
Here is cash book format sample (click to enlarge). My measurements are listed here too.
Column Widths The Details column is 9cm wide. The other columns are 2.5cm wide – the cash book format looks more balanced if they are the same size.
You may want to make the left margin (border) bigger and the description column smaller if you know you are going to hole punch the paper on the left and file it away. You don’t want the holes to cut out any information in the date column.
Row Height The rows are 1cm in height but you can make them a bit narrower if you prefer. The top row used for the headings is 1.6cm
And that’s all there is to it!
a school exercise book or lined paper
You could just buy a school exercise book which already has rows printed in it, so all you have to do is draw in the columns.
Exact measurements are not a requirement for keeping a cash book spreadsheet. You just need space to write a description and the money values.
Pre-Printed Cash Books
If that all sounds like too much hard work just go and buy a
cash book, already formatted and printed, from a stationery store or off
Cash Book Entries Example
Here is the same sample above that now has some random information entered into it with my quick (but messy!) handwriting. This is to show you how easy it is to keep a spread sheet to track the money.
The numbers in brackets mean the bank account has gone in to overdraft. This would not occur if you are just dealing with cash at fairs, unless some cash has gone missing.
Click to enlarge.
How to Fix Errors
The above example shows a few deliberate hand-written errors and what you can do to fix them – you can cross them out neatly and write above them, or *use white paper tape and write over them.
How Many Transactions Per Page
You can use one page a month, or if the entries are very few for each month, you can do two or three months on one page.
You just need to show a Closing Balance for the previous month, and an Opening Balance for the new month – this example shows what that looks like.
*Back in the day when everyone was doing manual bookkeeping, whiting out errors and writing over them was a big no-no.
This was to prevent the books being ''cooked'' by fraudulent bookkeepers.
For those of you who don't know what "cooked" means, it means the cashbook was adjusted for crooked, personal gain or just outright theft.
Whiting out errors and writing over them makes it very difficult for anyone to be 100% sure that you have processed the accounts in good order (such as auditors). This is also why it is important to have receipts, invoices and other source documents which prove the transactions are correct.
Simple Profit and Loss Report
Here is what a simple profit and loss report would look like based on these cash book entries. Click to enlarge.
This shows the business making a net loss (Funds introduced and Drawings do not go on the profit and loss report but on the balance sheet – learn more about that here)
Detailed Cash Book
For a more detailed cash book, format it with extra columns – check out the information on this in single entry bookkeeping.
If you have any questions on this cash book Format you can write them on the Facebook comments below, or use the Contact form.
Bookkeeping 101 - 10 steps to help the self-employed learn how to get your business bookkeeping on track with the right systems and the right ideas, answering questions like what is bookkeeping, shoul…