Bookkeeping Templates for Self Employed

Are you looking for bookkeeping templates for self employed?

Business Accounting Basics have several Excel Spreadsheets that can help to improve your bookkeeping procedures. All templates are free to download and easy to use.

As a small business owner, it is easy to put your accounts to one side and concentrate on the sales and producing the goods needed. It is worth spending the time to keep your bookkeeping up to date and not having to rush it at the end of the year.

HMRC will require you to complete a self assessment tax return. The tax year is from 6th April to 5th April, and the tax return and payment is due 31st January the following year.

Cash Book Template for Self Employed

Templates for self employed cash book template

Our cash book is simple to use and has some good features. Set-up takes under 5 minutes. You can change the names of the sales and expenditure categories to suit your business. All the figures for the year are calculated on an annual profit and loss report. Figures are posted to sales or expenditure using a drop-down list. Full instructions and examples are provided on the website.

Budget and Cash Book

An extension to our cash book includes being able to set a budget and comparing the two. Setting a budget can be important to see where the differences are between what you expect to earn and what you earn.

Expenses for Self-Employed

Free Excel Business Expense Template

Keeping track of all your expenses and making sure you claim for everything is important. It can reduce your tax bill, by lowering profits. The expense template allows you to record mileage and other sundry expenses.


Post the figures when complete to the accounts software or cash book.

If you can’t find the spreadsheet that you need the options are to either design a template yourself or hire someone to do it for you.

If you want something more advanced, it may be worth looking into using an accounting package. One of the best ones for self-employed is Quickbooks. It has been designed to be easy to use, lots of instructions to get you started and will grow as your business grows.

All our templates can be found on free Excel bookkeeping templates.