This Excel Cash Book is suitable for any small business that wants an easy bookkeeping method - a simple way to track your income and expenses.
This easy version of the Cash Book is 100% free for you to download and use forever, and it is fully customizable so you can change anything in it.
Alternatives to Excel
This template will also work in Google Sheets or OpenOffice or LibreOffice.
Click on the blue button above - the template will download direct to your device.
Open the downloaded file in Excel and click on 'save as'. This will let you save the cash book with a different name (like the name of your business) to a folder of your choice on your device, 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.
Here is a basic course to help you set up and use the template, which includes bookkeeping tips.
Here is an overview of a monthly sheet where you will enter your business transactions.
The shades and fonts of the whole Cash Book can be changed instantly by clicking on Themes under the Page Layout menu.
This is a page of example transactions and gives you an idea of how it will look when you enter information into the cashbook.
There is a page of quick tips notes to get you started fast with your bookkeeping.
The Accounts|Headers page of the Excel Cash Book is where you can enter in the business name, your income and expense header names (account headings) and month names.
All other monthly tabs are connected to this Accounts|Headers page and will automatically pick up the header names you enter here.
The Total columns have formulas in them, so they update automatically.
Beware! If you manually type anything into the Totals or Bank Balance columns you will over-type the formulas and the totals will be messed up.
You can fix it by copying a formula from a row above or below that is working.
In the first monthly worksheet, 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.
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.
When reconciling the cash book to the bank statement you can select different red letters from a drop-down list.
Select your choice.
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 -$1,961.00
Wow! I hope this business has an arranged overdraft facility with their bank!
Profit and Loss / Income Summary
The Profit and Loss Report is linked to all the monthly sheets.
The rows with the "Account 1" etc are the account headings and are linked to the Accounts|Headers sheet
The 0.00 amounts under the months are the totals from each monthly worksheet. The 0.00 amount means no transactions have been entered into those months for the Cash Book.
This is the same throughout the profit and loss report for each section Income, COGS and Expenses.
The Excel Cashbook Easy does not have a balance sheet, which helps to keep it easy.
However, you might have certain types of income or expenses that you have to record in this cashbook to keep your bank account in balance, but which need to be kept out of the profit and loss calculations, and are usually the type of transactions that go on to a Balance Sheet.
These might include personal expenses, or loans to name a few.
This easy cashbook has a section at the bottom of the P&L to help you remove these amounts from the profit calculations.
The cash books with sales tax features have these extra
Sales Tax Rates – where you enter the percentage rates that are applicable to you
Sales Tax Columns – four for the income columns and four for the expense columns
Sales Tax Summary – a simple display of the total sales tax for each month
Sales Tax Report – an interactive report allowing you to select any month or group of months to see sales tax totals
Sales Tax Data – a spreadsheet containing all the data supporting the Sales Tax Report – this is the “data source” of the report.
Note: the Profit and Loss report displays income and expenses excluding sales tax
This excel cash book is a great way to keep simple bookkeeping records.