Free Excel Cash Book Template for Small Businesses

Keeping on top of your business finances doesn’t have to be complicated. Our free Cash Book with VAT spreadsheet makes it easy to record your income and expenses, calculate VAT, and stay organised for tax time.

Whether you’re VAT registered or just like to keep your records tidy, this tool is perfect for sole traders, limited company directors, and small business owners who want clarity and control over their finances.

Corporation Tax Return

Enter your email address to receive the download.

Download Your Free Cash Book Spreadsheet Template with VAT Management

This Cash Book is designed to simplify your bookkeeping, no need for expensive software or complicated systems. It’s Excel-based, easy to use, and includes columns for gross amounts, VAT, and net figures, so you can stay on top of your tax obligations.

Ideal for anyone managing their own accounts or preparing for their accountant at year-end.

Why Download It?

Accurate bookkeeping is a legal requirement and a financial lifesaver. With this free Cash Book:

  • Track all income and expenses in one place

  • Automatically calculate VAT (if applicable)

  • Separate business from personal spend

  • Keep better records for your accountant or HMRC

  • Make tax returns faster and less stressful

  • Spot cash flow issues early

It’s perfect for business owners who want to stay compliant without spending hours buried in spreadsheets.

What’s Inside the Cash Book with VAT?

This downloadable Excel spreadsheet includes:

  • Pre-built columns for date, description, income, expense, VAT, and payment method

  • Auto-calculations of VAT on income and purchases

  • Clear separation of gross, VAT, and net figures

  • Monthly tabs to track your finances throughout the year

  • Summary sheet for total income, expenses, and VAT position

  • Easy customisation for non-VAT users too

It’s ideal for:

  • Sole traders and freelancers

  • Limited company directors

  • VAT-registered businesses

  • Self-employed professionals

  • Anyone preparing for Making Tax Digital

This tool is designed by professionals who understand what you need, simple, practical functionality that saves time and reduces errors.

And yes, it’s completely free.

Contact Us

Please call or email to arrange your FREE consultation for any of our services.

Meet the Team

We’re a modern, friendly and proactive accountancy service.

team member artwork

Newsletter

Signup for our weekly business newsletter and special offers!

Let's discuss how we can help your business

Our goal is to remove as much time and stress from the accounting side of your business so that you can focus on what matters more to you.