Bookkeeping Templates for Self Employed

Are you looking for bookkeeping templates for self employed?

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

If you do not have Excel, there are a few alternatives, including Neat Office, Numbers for Mac and Google Sheets.

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  – Free 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 cashbook template has been downloaded around 15,000 times and used by lots of small businesses.

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 the differences between what you expect and what you actually 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.

Home Office Expenses

Calculating home office expenses Excel Template

If you run a small business, the chances are you complete some or all of the work from home. When you use your home for business use, you are entitled to claim some expenses.

Our home office expenses section has a calculator for simplifed and a Excel template to calculate the total of all the expenses for home use.

Mileage Log Templatefor self-Employed

If you travel for the business you can claim back mileage at 45p for the first 10,000 miles.

Simple Mileage Log TemplateDownload our free pdf or excel mileage template.

Sales Invoice Template

Sales Invoice Template

Our sales invoice template, allows you to brand your invoice with logo, company and bank details. There are two versions available VAT and non-VAT.

It is important to a customer that as a business, you look professional and having a branded invoice is one way of achieving that.

Excel Bookkeeping Templates for Self Employed Alternatives

If you can’t find the spreadsheet you need, either design a template yourself or hire someone to do it for you. There are lots of useful YouTube videos to help get started.

If you want something more advanced, it may be worth looking into using an accounting package. A couple of the best ones for self-employed are QuickBooks and FreshBooks. They have been designed to be easy to use, lots of instructions to get you started, and will grow as your business grows.

Also check out out best accounting software for self-employed.

For a full list of Bookkeeping templates for self employed Excel check out our complete list of Excel bookkeeping templates.

Similar Posts