Free Excel Cash Book Template Our free Excel cash book template has been designed to assist your small business with its bookkeeping. It is based on bank account transactions or if you do not have a separate bank account, you can just post all your transactions. It is not suitable to track sales and purchase invoices or if you are VAT registered.

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 are due 31st January the following year.  There is also a payment on account that is due 31st July. Once your first year’s self-assessment is processed, a tax calculation is available from HMRC. Read more on payment on account.

Cash Book  – Bookkeeping Templates 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.

Our self-employed bookkeeping includes a free download for the cash book from April to March.

Budget and Cash Book template

An extension to our cashbook 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. You can adjust the budget during the year to reflect any changes that may occur in your business. Changes may include gaining an additional contract or unexpected expenses.

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 either designing a template yourself or hiring 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.

Return from Bookkeeping templates for self-employed to free Excel bookkeeping templates.

Similar Posts