Cash Book Format

Cashbook Design Template

Use these cash book format instructions to make your very own cashbook spreadsheet using plain paper or a school exercise book.

This is ideal if you don’t want to use a computer to keep your cash book and are happy to do it the good old-fashioned manual way.

Simple Bookkeeping

Maintaining a cash book is the only method for simple bookkeeping.

Therefore, the aim of this lesson is to show you how to design and format a simple cash book, or in other words a simple bookkeeping spreadsheet.

If you want one in excel – check out our free excel cash book template. If not, continue reading on.

Cash Book Format

What is a Cash Book?

All money paid into or out of a bank account 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 at the bank.

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.

Let's get started with the cash book format...

For a very basic cash book spreadsheet you need to take a blank sheet of printer paper and do the following using a ruler and pen or pencil:

  • 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:-

  • Date
  • Details (or Description)
  • Money In (or Income)
  • Money Out (or Expenses)
  • Balance

Cash Book Format Sample

Here is cash book format sample (click to enlarge).  Our measurements are listed below.

Paper Size
We used an A4 size printer paper. We gave it a 1cm border all round.

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!

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 Amazon.

Or buy a school exercise book which already has rows printed in it, so all you have to do is draw in the columns.

Cash Book Entries Example

Here is the same sample above that now has some random information entered into it. Click to enlarge.

How to Fix Errors
This 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 it.

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 this looks like.

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. 

You are here:

Cash Book Format


Bb resized even smaller

Subscribe to get our latest content by email.

We won't send you spam. Powered by ConvertKit

Facebook Comments

Have your say about what you just read!
Leave me a comment in the box below.

Recent Articles

  1. What is a Credit Card Balance - Understand Credit Card Statement

    Apr 03, 18 10:44 PM

    What is a Credit Card Balance? Get to know the balances on a credit card statement before you overspend or pay the wrong amount! Compare statement credit card balance with current balance, good credit…

    Read More

  2. Top Business Invoicing Software

    Jan 18, 18 08:59 PM

    Review of top business invoicing software FreshBooks; makes billing clients ridiculously easy without having to learn complicated accounting stuff

    Read More

  3. Starting a Bookkeeping Business. No Bookkeeping Experience Required

    Nov 06, 17 11:17 PM

    Starting a bookkeeping business with no bookkeeping or business experience is possible. How?

    Read More

Back to Top: Cash Book Format