Free Excel Cashbook

This excel cashbook is suitable for any small business that wants an easy bookkeeping method - a simple way to track your income and expenses.

The cashbook is totally free and fully customizable. 


  • You need to have Microsoft Excel on your computer which you can get through Office 365.

  • A little knowledge of how to use Excel would be beneficial but if you know nothing, excel has a really good 'Help' link with heaps of how-to information, and there are plenty of free tutorials on the world wide web.


  1. Use one cashbook per bank account. 

  2. Can be used to enter periodical inventory balances. You can use our Excel Inventory Template to track inventory in detail, and then enter the monthly balances into this cashbook so that your Income Statement and Balance Sheet are up to date.

  3. Cannot be used for tracking income and expenses off a Credit Card. Use our Expense Form Template designed for tracking expenses off credit cards.

  4. Cannot be used for Accounts Payable or Accounts Receivable tracking (bills and sales on account)- click on each for a separate spreadsheet on those.

Excel Cashbook Download

There are four cashbooks to choose from under the small size and four under the large size.  

This is to accommodate the different fiscal years.

  • If your financial year ends in December, choose 'December'.
  • If your year ends in March, choose 'March'.
  • If it ends in June, choose 'June'. 
  • If it ends in September, choose 'September'.

Large Excel Cash Book

Select month below to start download:

Large Cash Book Download





This large cash book is good for (but not limited to) small businesses who require room for growth on the number of income and expenses transactions per day. 

This large cash book includes:-

  • 10 Income Columns
  • 2  Other Funds Received Columns
  • 6 Cost of Goods Sold Columns
  • 20 Expense Columns
  • 4 Other Funds Paid Out Columns
  • Reconciliation Sheet under each month
  • an 'Inventory Balances' page
  • a Profit & Loss Report for each month
  • a Balance Sheet Report for each month

Small Excel Cash Book

Select month below to start download:

Small Cash Book Download





This small cash book is good for (but not limited to) small businesses that don't expect to have lots of different types of income or expenses transactions.

For example, property rentals, small committees, charities and social clubs.

This small cash book includes:-

  • 4 Income Columns
  • 2  Other Funds Received Columns
  • 3 Cost of Goods Sold Columns
  • 8 Expense Columns
  • 4 Other Funds Paid Out Columns
  • Reconciliation Sheet under each month
  • an 'Inventory Balances' page
  • a Profit & Loss Report for each month
  • a Balance Sheet Report for each month

Instructions for Download and Save

Click on the link that you want from the above lists to download the cash book size for your chosen year-end. This opens a zip version of the excel cash book.

Download to your computer.

Unzip the download.

Save it to your documents or desktop.

Open and click on 'save as'. This will let you save the cash book with a different name (like the name of your business) and takes it out of read only mode so you can edit it - in other words use it.

On downloading this cash book Excel may pop up with a yellow bar at the top advising the book is in Protected Mode. You will need to click on 'Enable Editing' to be able to use the book.

Let's go!

Excel Cashbook Example

Here's a screenshot:-

Checkout our free video tutorials on inserting columns and rows,
updating the formulas, getting rid of #ref symbol

Benefits of an Excel Cash Book

  • Instantly see how much is being spent on each expense type every month

  • Instantly see how much is being earned every month 

  • Process bank reconciliations under each month to ensure the cash book balance equals the bank account balance 

  • View a Profit & Loss Report (Income Statement); this is linked to each month and provides month to date and year to date (YTD) totals for each income and expense type and the resulting profit or loss total

  • View a Balance Sheet Report; this is also linked to each month and provides month to date and year to date (YTD) totals for each account type (Assets, Liabilities, Equity).

  • No bookkeeping experience necessary

  • Sample page to show you how it works

  • Free and easy to format to suit your business/personal requirements.

  • Access and edit this excel document from your mobile phone - any time, any place.
Excel Cashbook Template Income Expenses Tracker

Sample Page

The sample page shows you how to enter information into the cash book and gives you an idea of how it will look.

Control Page

The control page is where you can enter in the business name and your income and expense header names. All other monthly tabs are connected to this control page and will automatically pick up the header names you enter here.

You cannot use this control page to format all the pages in the cash book. If you need to change row heights or column widths, text type or size, you will have to do this on each and every page.

Total Columns

The grey total columns have formulas in them so they update automatically. Beware! If you manually type anything into the total or bank balance columns you will over-type the formulas and the totals will be messed up.

The only exception is the opening balance as detailed below.

Opening Balance

In the January tab, in the yellow cell, you will need to enter the opening balance for the first day of the month which you can get off your bank statement. In this example, it is 400.00.

If you are starting your cash book in any other month and not January, then simply enter the opening balance into the yellow cell in the month you are starting. 

If your financial year starts in April, enter the opening cash book balance into the yellow cell on the April tab. When you get to January you may need to manually enter December's closing balance into January's opening balance or

You can drag the months into the order you need, just check the opening and closing balances to make sure they are okay, or

Simply rename each tab so that the first tab is the month you want it to be. You will also need to change the month on the top left of each page- and the month names on the profit and loss form and balance sheet (so this requires more work!)


When reconciling the cash book to the bank statement you can select different letters from the drop-down list. R for reconciled; C for checked; X for not reconciled; a dash for whatever reason you may want; you chose which one you want to use.

Excel Cash Book In the Red

When there is not enough funds in the account, in other words, when it goes into overdraft, the cash book shows the number in red as in the example here where it is -$30.00

Income Statement

As mentioned above, the Income Statement is linked to the other pages. The 'Headings' are linked to the Control tab; and the 'Amounts' are linked to all tabs so you get the total for each month.
This is the same throughout the income statement for each section :- Income, COGS, Expenses. 

Balance Sheet

If you traded in a previous tax year and have an opening bank balance then you actually also need to enter the balance sheet balances from your previous tax year into the Opening Balances column on the Balance Sheet tab, otherwise it will not balance.

If you do not have a balance sheet from the previous tax year, but were in business and have an opening bank balance this tax year, you will not be able to use the Balance Sheet in this cash book until you have got one - you should be able to get it from your Tax Accountant (if you used one), or do a separate cash book for the previous year's trading and enter all your income and expenses into it to work out what the balance sheet items from that year are.

The balance sheet headings are linked to the control page, and the monthly columns are linked to each page so you get the total of each column in yellow. These are:

  • Capital
  • Loans Received
  • Loan Repayments
  • Asset Purchases
  • Credit Card Repayments
  • Drawings

    The above type of payments have to be reported on the Balance Sheet not the Profit & Loss Report.

Excel Cash Book Question

Jarod asks: Hi, I downloaded the excel cash book for use of bookkeeping. May I know where to input the initial capital because the opening balance of every month is linked to the previous month?

Answer: The yellow opening balance cell is the place to enter your initial amount.

It does not matter that it is linked to the previous month.

When you type your initial balance into it, the link to the previous month will be removed; you won't need it anyway.

So, say you start in October 2014 and work through the whole year until you come to the end of September 2015 you need to archive this one, download a new, blank cashbook, enter September's closing balance into the October opening balance and start the cycle again.

Rent and Commission Question

Nadeem asks: How do you put in a two column cash book, the following:-

  1. Rent received from tenants,
  2. Then deduct commission,
  3. Balance paid to landlord?

Most of the tenants pay their rent by cheque. Commission is included in the rent payment. For example:-

  1. Tenant pays £1,210.00
  2. 5% commission due to me is £60.50
  3. Payable to landlord is £1,149.50


You would simply show:-

  1. Rent received as money in
  2. Payment to landlord as money out
  3. The balance left will be the amount of the commission which you would have to keep a record of in a notebook if there is no column for it.

See example below (click on image to enlarge).

At the end of the month you can add up the rent and commission columns.

This is helpful if you receive rent from several different tenants because it will enable you to quickly track how much commission you are actually earning.

This excel cash book is a great way to keep simple bookkeeping records.

You are here:

Excel Cash Book

Facebook Comments

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

Recent Articles

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

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

  3. Free Bookkeeping Forms and Accounting Templates | Printable PDF

    Oct 24, 17 09:32 PM

    30 free printable bookkeeping forms and templates in PDF for small business accounting. Click here to download and learn how to use them. Excel templates also available.

    Read More

Return to top: Excel Cash Book