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 for you to download and use forever, and it is fully customizable so you can change anything in it.
Requirements
Note:-
If you are new to Excel I highly recommend you do this free 5 hr course (book with videos) by Mike Smart. Make sure to select the version that matches your version of Excel. It's well worth it.
Even if you have used Excel for many years, I still recommend doing his free basic course as a refresher, you just might pick up some golden nuggets of information and shortcuts that you weren't aware of - I know I did. If you enjoy it you can then follow on with his courses for more advanced Excel skills at a low cost ($19.99). (Note, this is not an affiliate link, I do not make any money out of this if you purchase the advanced courses).
There are several cashbooks to choose from under the small size, and also under the large size, to accommodate the popular, most used financial year ends. If you have a different year-end, please let me know and the one for your year-end will be uploaded to this page.
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 month.
This large cash book includes:-
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 per month.
This small cash book includes:-
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!
Here's a screenshot:-
Checkout our free video tutorials on inserting columns and rows,
updating the formulas, getting rid of #ref symbol
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 (account headings). 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. |
![]() |
Opening Balance In the January tab (or whatever opening month is in your financial year), in the yellow cell, you must enter the opening balance for the first day of the month (before that day's transactions start ) which you can get off your bank statement. In this example, it is 400.00. If your opening balance is 0.00, you can type in 0.00 or just leave it blank. Note: This opening balance will be the same amount as the closing balance of the previous month. |
![]() |
Reconciliation
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 and 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:
This excel cash book is a great way to keep simple bookkeeping records.
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…
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
Nov 06, 17 11:17 PM
Starting a bookkeeping business with no bookkeeping or business experience is possible. How?
Return to top: Excel Cash Book
Facebook Comments
Leave me a comment in the box below.