... ...

Cash Book Excel 


This cash book in Excel template is useful for small businesses to start their bookkeeping when on a tight budget and unable 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
  • see your profit or loss result

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

  • accounts receivable totals
  • accounts payable totals
  • inventory totals
  • depreciation
  • loans and loan repayments
  • owner's equity
Cash Book Excel

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

Here is an overview of what you get in this Cashbook:

  • Track One Bank account (but you can save extra copies of the template to track other bank accounts at no extra cost).
  • 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
  • A Petty Cash Report
  • Quick Start Tips
  • An Examples page so you can see how it works
  • A Help guide for which you can also get a free PDF book for printing.

One time payment

What you get with your purchase:

1 x Excel Template with 26 worksheets
1 x e-Book - Help Guide

Both items can be downloaded to your device.

Please check my Refund Policy.

Help Guide Free eBook when you purchase the template.

Cash Book Excel Sample

Try the sample version for free.

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

Note: More accounts cannot be added to the reports.

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

There is a Help page in this workbook with more in depth instructions on everything including how to add more accounts or hide excess accounts, and how to process the Petty cash transactions and the Inventory procedures. However, when you purchase this template you will also get the free printable e-book of these help instructions.

Overview of Help Menu

If you are looking for a simpler/smaller version of the cashbook you can try our free Excel Cashbook Easy. It's very simple because it has no balance sheet or balance sheet type accounts.

You are here:

Facebook Comments

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

Recent Articles

  1. Cash book in Excel for Tracking Income and Expenses

    Cash book excel with balance sheet to help small businesses track income and expenses

    Read More

  2. Fiscal Year Definition for Business Bookkeeping

    Fiscal year definition: a financial period of 12 consecutive months in which to keep bookkeeping records before paying income tax, and can begin with any month.

    Read More

  3. 10 End of Year Bookkeeping Tips

    10 end of year bookkeeping tips to get ready for tax: 1) When to do these checks, 2) Reconcile the bank, 3) Enter expenses paid with personal money, 4) Check your...

    Read More

Return to top: Cash Book Excel