... ...

Free Excel Cashbook

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.

If you have more than one bank account you can save copies of the cash book and use one copy per bank account.

Requirements

  • You need to have Microsoft Excel on your computer which you can get through Office 365, or you can use the free version of Excel online - just sign up for a Microsoft Account (more about that here). 
  • Some 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, or
  • You can watch, for free, the videos I have prepared for Excel beginners on my Excel Tutorial Videos page.

Alternatives to Excel

This template will also work in Google Sheets or Open Office.

Excel Cashbook Easy Download

This Cashbook can be adjusted to suit your financial year-end and is suitable for charities, clubs, sole traders/proprietors or small businesses. It has:-

  • Income Accounts
  • 20 Expense Accounts
  • Bank Reconciliation worksheet
  • Profit and Loss Report (also called Income Summary or Income Statement)
  • An Adjustments section underneath the P&L to remove any Balance Sheet type amounts from the P&L in case you had such payments - there is a suggestion list of these type of accounts - to see your true profit
  • QuickStart guide
  • An Example page so you can see how it works
  • Access to my Free 7-day email course to help you get set up correctly.

This Cashbook can be adjusted to suit your financial year-end and is suitable for charities, clubs, sole traders/proprietors or small businesses. It has:-

  • Income Accounts
  • 20 Expense Accounts
  • Bank Reconciliation worksheet
  • Profit and Loss Report (also called Income Summary or Income Statement)
  • An Adjustments section underneath the P&L to remove any Balance Sheet type amounts from the P&L in case you had such payments - there is a suggestion list of these type of accounts - to see your true profit
  • QuickStart guide
  • An Example page so you can see how it works
  • Access to my Free 7-day email course to help you get set up correctly.
Creative Commons Licence
This Excel Cash Book is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

Rick says:

"I have to tell you, I almost never email or write reviews. I’ve gone into business for myself. It’s pretty cut and dry, so when my father sent me QuickBooks pro as a gift and I started into the bookkeeping, I quickly felt like I had 2 new careers. It put a strain on my brain and on my marriage and honestly made me feel inept. I searched around for a new solution and figured I’d land on paper bookkeeping. I’m just a contractor, building things is my skill. I found your cashbook spreadsheet and use it in “open office”, an alternative to excel. After losing heart and shoving all my receipts for the first year in a box, I realized I’d have to get going on the books, with LOTS to catch up on. I finished last year’s books in a day and a half. I love what you’ve made. In fact, I have confidence I’ve never had. With the cashbook spreadsheet and your online tutorials I feel like a rock-star and I’m spending my time doing what I’m good at."

Marilyn says:

"I just want to thank you for making the Excel Cashbook Easy available.  Up until finding it, I was still entering all my data manually into my ledger for my small business. Finding the cashbook was a miracle  as it has already saved me so much time!!  Math is not a strength of mine but as a small business owner, I must struggle through except for having a bookkeeper who does taxes for me. I think until one tries something new you do not know how easy it can be and how much time it frees up to do other things.  I found the cashbook easy to use and was thrilled that all my calculations were done for me and I could see totals at a glance.  Then to have a tutorial to help me work through the learning stage was such a bonus.  Thank you so much for your generosity in making this available for a beginner bookkeeper with math challenges!!!!  I would recommend your cashbook open-heartedly to others."

How to Download and Save the Excel Cash book Easy

Click on the blue button above that says Get the Cashbook Easy - you will be directed to the landing page where you can enter your details and receive a confirmation email.

When you click on Confirm email the Cash Book will Download directly to your device.

Open it 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.

Cash Book Excel with Balance Sheet

If you are more interested in a Cash Book that includes a Balance Sheet and Balance Sheet type accounts, please go here.

Excel Cash book Easy Overview Layout and Theme

Here is an overview of a month 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.

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 for each month to ensure the cash book balance equals the bank account balance
  • View a Profit & Loss Report (Income Statement or Income Summary); 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
  • No bookkeeping experience necessary
  • 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 using Microsoft Excel mobile app.

Excel Cash book Examples Page

This is a page of example transactions and gives you an idea of how it will look when you enter information into the cashbook.

Excel Cash Book

Quick Start Tips

There is a page of quick tips notes to get you started fast with your bookkeeping.

Accounts|Headers Page

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.

Total Columns

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.

Opening Balance

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.

Bank Reconciliation

When reconciling the cash book to the bank statement you can select different red letters from a drop-down list.

  • R for reconciled
  • C for checked
  • X for not reconciled
  • a dash for whatever reason you may want

Select your choice.

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 -$1,961.00

Wow! I hope this business has an arranged overdraft facility with their bank!

Income Statement

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. 

Balance Sheet

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.

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



Home > Business Bookkeeping Software > Excel Cash Book

Facebook Comments

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