← All prebuilt solutions
Bookkeeping & Compliance

Sole Trader Cash Book

Simple record keeping for the self-employed

£20

Secure checkout. Your download link is sent as soon as payment clears.

Sole Trader Cash Book

Overview

Good records don't need to be complicated. This cash book gives you one place to write down every payment in and out of your business – from your bank account and from cash – using categories you choose. It keeps running bank and cash balances, checks every line, totals everything by month, lays your year out in the same order as the self-employment pages of the tax return and estimates the income tax and National Insurance you'll owe, so you know how much to put aside.

Price
£20
Who it’s for
Bookkeeping & Compliance
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Cash Book

Every payment in and out, with running bank and cash balances. What you do: one line per payment.

Cash Book
Invoices

Step 2

Invoices

Invoices you've sent and whether they've been paid. What you do: one line per invoice.

Step 3

Monthly Summary

Each category month by month, business income, expenses, profit and month-end bank balance. What you do: nothing to enter.

Monthly Summary
Year Summary

Step 4

Year Summary

Your year in the order of the tax return, plus the tax and NI estimate. What you do: optionally enter a use-of-home figure.

Who it is for

Made for people like you

  • Example – text
  • New sole traders – A straightforward way to start keeping proper records from day one.
  • Shops, trades and services with cash takings – Separate bank and cash balances, with cash banked recorded as a simple transfer.
  • Anyone who invoices customers – An invoice list showing who owes you money and what's overdue.
  • Anyone who dreads tax return time – Figures grouped under the tax return headings, ready to hand to your accountant or enter yourself.

Quick start

Up and running in minutes

  1. Example – text
  1. Setup – your business – Enter your business name, your name, the date your year starts, your opening bank balance and cash in hand, the tax year for the estimate, any other taxable income, whether you're VAT registered, whether you're a Scottish taxpayer, your student loan plan and whether to include voluntary Class 2 NI.
  2. Setup – your categories – Check the category list. Rename, add or remove categories so they suit your business – each one needs a tax return heading from the drop-down.
  3. Cash Book – every week – Add each payment in or out: date, details, category, amount and whether it went through the bank or cash. Tick 'Reconciled ✓' once it shows on your bank statement.
  4. Invoices – as you send them – Log each invoice. When it's paid, enter the date paid AND record the money in the Cash Book.
  5. Bank Reconciliation – every month – Type the closing balance from your bank statement. The status should say 'Agrees'.
  6. Dashboard and Year Summary – Check your profit and the tax to set aside. At the year end, the Year Summary gives you the figures for your tax return.

Key features

  • Record every payment in and out from your bank and cash, with running balances and automatic checks.
  • Your own categories, mapped to the Self Assessment self-employment headings.
  • Monthly summary, invoice tracker, bank reconciliation and a year-end summary with a tax and NI estimate.
  • Dashboard with income, expenses, profit, tax to set aside and charts.

What’s included

  • Dashboard – Year so far and charts
  • Setup – Business details and categories
  • Cash Book – Every payment in and out
  • Invoices – Who owes you money
  • Monthly Summary – Category totals by month
  • Year Summary – Tax return figures and tax estimate
  • Bank Reconciliation – Check against your bank statements
  • Tax Rates – Rates and allowances
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions