Busines Accounting Basics logo
Free Accounting Basics and Bookkeeping Support for Small Business
Custom Search

Free Excel Bookkeeping Templates

Our Free Excel Bookkeeping Templates are great if you just want to handle basic bookkeeping tasks using Microsoft Excel.

Whilst templates will never be as flexible as a fully blown software package, the ease of use and the simplicity in which 'what if' scenarios can be modelled means that Microsoft Excel is an extremely useful tool for any small company.

We've written a number of Excel Bookkeeping Templates to get you up and running - quickly and easily.

Sponsored Links

BAB Petty Cash template

Free Excel Bookkeeping Templates

Our free petty cash template is designed to assist in the management of your petty cash and save time in the reconciliation. You can list all your transactions and it will calculate your final figure.

Our Excel Bookkeeping templates have been tested and work with Microsoft Excel 2003 and 2007.

Petty Cash Guide  Petty Cash Template Download

Business Expenses

Free Excel Bookkeeping Templates

Most businesses can claim back expenses even if you are self-employed, we have created two templates one for VAT and one non VAT. All the calculations are completed for you once the figures are posted

There is also a guide explaining what you can claim.

Expense Guide  Excel Expense Template Download

BAB Cash Book Spreadsheet

Our cash book template is designed to handle all the bookkeeping needs for a small business. It has been developed for ease of use but still allowing a company to adapt it to their requirements. It helps you with your monthly and year-end figures for the Inland Revenue and gives you all the tools you need to manage your small company accounts. It is not suitable for recording invoices and VAT but is ideal for taking your bank statement and producing the reports that are required.

Excel Cash Book Template Cash Book Example

Sales Invoice Template

Our sales invoice template is easy to use for any business. A template can be saved with your logo and business details, so every time you want to produce a sales invoice it is ready.

Details of the sale can be included in the description, along with quantities and price. All the totals are calculated, to ensure mistakes are not made.

Sales Invoice

Personal or Business Budget and Finance

Personal Budget Template
Our Free Excel personal budget and finance spreadsheet will enable you to set a budget and keep track of spending during the year. It can be used for either personal or business use.The budget is set on one page and can be adjusted during the year if your circumstances change. By entering your bank transactions you will then be able to see the differences between your budget and actual figures. This is a useful template if finaces are tight or you want to make some savings.

Personal Budget Template

Balance Sheet Template

A simple spreadsheet to assist you in the layout of your balance sheet. If you run a limited company then a balance sheet is a legal requirement for submitting your accounts, but your accountant will produce it for you.

Balance Sheet Template

Free Bookkeeping Software

There are some free bookkeeping software packages available on the internet, most of the ones we have viewed are either complicated, only offer a free trial or as your business grows it will not be suitable.

Cash Book Pro

Developed by an accounting practice, it is a useful tool providing you with a simple system. It's an ideal upgrade from a paper-based system without going to the complexity of a full accounting software package.

Visit the Yorkshire Accountancy website.

What are the alternatives?

There are many websites which offer free bookkeeping downloads for Microsoft Excel templates, or you could design your own. There are many different templates to assist you in your accounting records including; balance sheet, forecasting, cash flow, sales invoices and petty cash.

Accounting software packages

Instead of limiting yourself to using Microsoft Excel, most businesses will benefit from having a fully developed software package. Traditionally, these have been expensive and difficult to use but over the past few years, the software has become cheaper and more intuitive.

Cloud accounting software - Online accounts software

Cloud accounting software is also becoming very popular as it allows people to access the accounts from anywhere. There are a few advantages over purchasing a product.

  • No upfront costs, just a monthly fee
  • You can access you accounts from anywhere with internet access by using the cloud
  • No space required on your own computer for a software package
  • You can give other people access to the data, this may be useful for your accountant or bookkeeper
  • Suppliers normally provide a free trial, so you can try before you buy

Find out more

We have also written other Excel accounting templates to assist your business. These include; bank reconciliation, petty cash, balance sheet, cash receipts and a stock control record card.

Find out more about free bookkeeping software.

Return from Free Excel Bookkeeping Templates page to Business Accounting Basics page.