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.
I used an A4 size printer paper.
I gave it a 1cm border all round.
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.
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.