Cash Book Excel 

Features

This cash book Excel template is useful for small businesses to start their bookkeeping when on a tight budget and not ready to pay the monthly subscription costs for online bookkeeping software or the upfront outlay of hundreds for desktop software.

In this Cashbook you can:

  • track income and expenses
  • view a Profit and Loss Report

This Cashbook also has a Balance Sheet so you can track assets and liabilities including:

  • bank and credit card balances
  • inventory totals
  • depreciation
  • loans and loan repayments
  • owner's equity

There is an Examples sheet with various transaction entries so you get an idea of how they should be entered.

Each template comes with a Help Guide which will take you through the set up of the template, tips on using the template, as well as bookkeeping tips along the way.

There are four templates to choose from:

  1. One bank account, no sales tax features
  2. Multi banks/credit cards, no sales tax features
  3. One bank account, including sales tax features
  4. Multi banks/credit cards, including sales tax features

Or try a free sample first.

Or try a free sample first.

Cash Book Excel

1. Cash Book Excel 1 Bank account

US$9.99

One-time payment

What you get with your purchase:
1 x Excel Template for 1 Bank account
1 x e-Book - Help Guide

Cash Book Excel 1Bank Thumbnail

2. Cash Book Excel Multi Bank Accounts& Credit cards

US$14.99

One-time payment

What you get with your purchase:
1 x Excel Template for up to 5 Bank Accounts & 3 Credit Cards
1 x e-Book - Help Guide

Cash Book Excel Multi Banks Thumbnail

3. Cash Book Excel 1 Bank account
Including sales tax features

US$9.99

One-time payment

What you get with your purchase:
1 x Excel Template for 1 Bank account with sales tax features
1 x e-Book - Help Guide

Cash Book Excel 1Bank with Sales Tax Thumbnail

4. Cash Book Excel Multi Bank Accounts  & Credit Cards
Including Sales Tax features

US$14.99

One-time payment

What you get with your purchase:
1 x Excel Template for up to 5 Bank Accounts & 3 Credit Cards
1 x e-Book - Help Guide

Cash Book Excel Multi Banks with Sales Tax Thumbnail

30 day money back guarantee on all purchases.  Please check the Refund Policy.

30 day money back guarantee on all purchases.  Please check the Refund Policy.

Cash Book Excel Sample Templates

Try a sample version for free if you want to check out the template first.

Instant download after selecting a button below.

You can enter data for two months and if you love it, buy the password unlock key so you can keep using the same workbook and get the Help Guide.

Try Sample 1 Bank
Try Sample Multi Banks
Try Sample 1 Bank + Sales Tax
Try Sample Multi Banks + Sales Tax

Note: More accounts cannot be added to the reports in these samples.

Cash Book Excel Sample Templates

Try a sample version for free if you want to check out the template first.

Instant download after selecting a button below.

You can enter data for two months and if you love it, buy the password unlock key so you can keep using the same workbook and get the Help Guide.

Try Sample 1 Bank
Try Sample Multi Banks
Try Sample 1 Bank + Sales Tax
Try Sample Multi Banks + Sales Tax

Note: More accounts cannot be added to the reports in these samples.

Requirements on your device:

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

cash book excel Overview

One Bank Account Template

  • Track One Bank.
  • 14 Income Accounts
  • 10 Cost of Goods Sold Accounts
  • 30 Expense Accounts
  • 13 Balance Sheet Accounts
    Note: More accounts can be added to each category
  • An Inventory balances worksheet
  • A Bank Reconciliation worksheet
  • A Depreciation worksheet
  • A Profit and Loss Report
  • A Balance Sheet Report
  • Quick Start Tips
  • An Examples page so you can see how it works

Version with Sales Tax Includes:

  • 4 Sales Tax Columns Income
  • 4 Sales Tax Columns Expenses
  • Sales Tax rates fields
  • A Sales Tax Report
  • A Sales Tax Summary
  • A Sales Tax Data sheet

Multi Bank Accounts Template

  • Track up to Five Bank accounts and three credit cards. 
  • 14 Income Accounts
  • 10 Cost of Goods Sold Accounts
  • 30 Expense Accounts
  • 13 Balance Sheet Accounts
    Note: More accounts can be added to each category
  • Two columns for inter-bank or inter-credit card transfers and payments.
  • An Inventory balances worksheet
  • A Bank Reconciliation worksheet
  • A Depreciation worksheet
  • A Profit and Loss Report
  • A Balance Sheet Report
  • Quick Start Tips
  • An Examples page so you can see how it works.

Version with Sales Tax Includes:

  • 4 Sales Tax Columns
  • 4 Sales Tax Columns Expenses
  • Sales Tax rates fields
  • A Sales Tax Report
  • A Sales Tax Summary
  • A Sales Tax Data Sheet

cash Book Excel Main Details

The Quick Start Tips gives you a summary of what to do first.

The main first things are to enter your financial year and months and your account names.

Cash Book Excel Quick Start Tips

There are 12 monthly sheets where you will enter your transactions for each month.

The totals from these sheets are linked to the reports so they update automatically.

The Examples page has data in it that will help you see how to enter your income and expenses and other type of transactions.

Cashbook Excel Examples

Here are snips of the Profit and Loss Report and Balance Sheet Report.

Cashbook Excel Profit and Loss Overview
Cashbook Excel Balance Sheet Overview

The Inventory in this cash book in Excel is based on the Periodic method of tracking stock, so it will calculate your Cost of Goods Sold automatically, so long as you can enter your closing stock balances at the end of each month, or just do it once a year.

Cash Book Excel Periodic Inventory Screen Shot

The version with sales tax features includes the sales tax report which is made up of two pivot tables side by side, one for income and one for expenses.

You can select the months you want displayed and then they will list a total for each sales tax rate that you use.

Screenshot of Sales Tax Report Cash Book ExcelCash Book Excel with Sales Tax - Sales Tax Report

You might prefer to try the free Excel Cash Book which doesn't have a balance sheet.

Share this page

Facebook Comments

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