Free Excel Bookkeeping Templates

Our Free Excel Bookkeeping Templates are great if you want to manage basic bookkeeping and accounting tasks using Microsoft. They are available to download for business or personal use. The most popular template is the Cash Book and is suitable for recording your business transactions for Limited companies, self-employed and self-assessment.

Free Accounting spreadsheets

While Microsoft Excel accounting templates will never be as good as full software accounting packages, they are easy to use. You can modify most spreadsheets for your own needs. They are great for keeping track of the financial record of the company.

We have designed 16 Excel templates to help small business owners manage their bookkeeping. Including petty cash, cash book, business expenses, cash flow, sales invoice, statements, income statement and balance sheet. They are simple and easy to use, with full instructions available.

If you can not find what you are looking for, drop us a message. We may be able to create one for you.

If you need help with any of our free templates, please contact us.

Our accounting templates have 100,000+ downloads and are used by many small businesses and charities. 

Advantages and Disadvantages of Excel Bookkeeping Templates

While basic bookkeeping in Excel might be an excellent solution, they are often not enough for reporting for small business owners.

Accounting software integrates all the processes in one package and can often save you time and money. Most of the software available today is easy to use with full instructions.

Some best bookkeeping packages worth looking into are FreshBooks, Zoho Books and  QuickBooks.

Advantages and Disadvantages of Accounting Software

Read our guide on best accounting software, including the pros and cons for each. Below are some recommended software packages, ideal for small or growing businesses. 

 

Accounts Payable Statement Template

The Accounts Payable template is excellent for keeping track of purchase (supplier) invoices. It will show the amount outstanding for payment.

The data can be sorted to help keep track of when invoices are due. There is a comments section, which is helpful if you have a query on an invoice.

Accounts Payable Template

Accounts Receivable Template

The Accounts Receivable statement template allows you to list all your sales invoices issued to customers. It will calculate when an invoice is due and how many days are overdue.

The comments section makes it easy to see the status of an invoice. The data can be sorted by customer or date.

Aged Receivables Template

Balance Sheet Accounting

A simple Microsoft Excel spreadsheet to assist you in the layout of your balance sheet. It shows the financial position at any given time.

If you run a limited company, a balance sheet is a legal requirement for submitting your accounts. Our Excel Bookkeeping Templates balance sheet helps look at financial ratios to see how the business is performing.

Balance Sheet Template

Bank Reconciliation Worksheet

A bank reconciliation worksheet is used when you are comparing the bank position to the accounts.

There can be timing differences between when a transaction takes place and what they show on the bank statement.

Our free bank reconciliation allows you to record the differences and balance the accounts to the bank statement.

Bank reconciliation template

Budget Worksheet Excel Template

The Excel budget worksheet enables you to set a budget and track spending during the year.

Suitable 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 see the differences between your budget and actual figures.

It is a useful Excel bookkeeping template if finances are tight or you want to make some savings.

Personal Budget Template Instructions

Business Expense - 2 Excel Accounting Templates

Most expenditure can be claimed back, even if you are self-employed. There are two spreadsheets, one for VAT and one for non-VAT. All the calculations are completed for you once the figures are posted.

The rules for claiming expenses can be complicated, so we have a guide explaining what you can claim.

Free Excel Business Expense Template

Cash Book - Free Excel Bookkeeping Templates

Our Cash Book template (income and expenses) is simple bookkeeping in Excel single-entry system designed to handle small businesses and charities needs. It has been developed for ease of use but still allows a company to adapt to their needs.

It helps with your monthly and year-end figures for the Inland Revenue. It is not suitable for recording invoices and VAT but is ideal for taking your bank statement and producing your annual figures. You can record the income and expenditure transactions by date for each month on a separate sheet.

Small business owners, charities and individuals use our free Excel bookkeeping template. Also is known as the Income and expenses.

Excel Cash Book Template

If you have multiple bank accounts or a credit card you will need a spreadsheet for each.

Cash Flow Forecast Template

The Free Cash Flow Forecast will enable you to set a forecast for a year. Knowing how much money you may have available in a few months helps with your accounting and business planning.

The Excel accounting template will show the predicted money available. The income and expenses descriptions can be changed to suit the business.

Free cash flow forecast template

Credit Note Template

There may be times when you need to issue a refund to a customer. There are various reasons for raising them, including the return of goods and query on the invoice.

Our Excel credit note template will help you to produce a professional document.

Credit note example for refund

Delivery Note

When delivering goods to a customer a delivery note is required. It is not a legal document.

Read our guide with a template in both Excel and PDF.

Excel free delivery note template

Home Office Expenses

If you work from home, there are expenses that you can claim. Read the full guide on what you can claim. They include mortgage, rent, council tax, broadband, insurance and utilities.

To help calculate the figures, the is a simplified calculator and a home expenses Excel bookkeeping template.

Calculating home office expenses Excel Template

Journal

If you need to create an adjustment to the figures, a journal is required. 

A journal is a simple form to move a transaction from one code to another.

Journal Form for Accounting

Mileage Log Template

Do you need to keep track of your business mileage? Our Free simple mileage log allows you to either keep a PDF version or download an Excel Template.

All mileage can be reclaimed. Please read our guide to find out further information about business expenses.

Simple Mileage Log Template

Petty Cash

Our free accounts spreadsheet is a log to assist in the management of your petty cash transactions. You can record all income and expenditure over time. The balance is automatically calculated.

It is designed to save you time calculating the figures. You can then post the totals to your accounting system.

Petty Cash Excel Template

Profit and Loss Statement or Income Statement Template

The Profit and Loss or Income Statement allows you to add a whole year’s figures onto one page. It is helpful to see differences between figures over the year.

A P&L is required by all businesses at year-end to show profits or losses. It is also known as an Income and Expenditure report.

self employed profit and loss template example

Purchase Order

A larger business running a stock system may be required to create purchase orders to send out to suppliers. The purchase order will confirm goods, quantity, delivery date and price.

Our easy to use Purchase Order template will automatically calculate total figures for you. We have also created a purchase order log to record all the orders.

Purchase Order Template Example

Rent Receipt Template

If you are a landlord or tenant, a rent receipt is an important document to record payments.

We have produced an Excel rent receipt, letter and log to help keep track of payments over time.

Rent Receipt Template Example

Sales Invoice and Proforma Invoice

Our sales invoice template is easy to use and looks professional. It can be downloaded and saved with your logo and details, so every time you want to produce a sales invoice, it is ready with your branding.

Add a full description for the sale, along with quantities and price. All the totals are calculated automatically to ensure no mistakes.

Our proforma invoice is for issuing before the supply of the goods or services.

Sales Invoice Template

Sales Receipt Template

The sales receipt template is ideal if you attend fairs and need to issue a receipt to clients for a cash sale. It can be used as proof of purchase and guarantee for goods or services.

The template can either download in Excel or PDF format to complete by hand.

Free cash receipts templates

Statement of Account Spreadsheet

The statement of account or customer account template statement is used to remind customers how much they owe.

The statement template can be branded to your own business by adding a logo and company information. It also includes a remittance to be completed by the customer, so you will know which invoices they have paid.

Excel Statement of Account Free

Supplier Statement of Account Reconciliation

If you receive lots of supplier statements, it may take some time to reconcile them.

Our supplier reconciliation template will help to speed up the process. It allows you to see the total difference and list differences.

Supplier Statement Reconcilation Template Excel

Timesheet Template

If you need to track employee or contractors hours, our timesheet can assist with the process. 

Record the hours worked and customer details, including order references. It makes it easier for calculating how much to invoice clients.

Excel Timesheet Template Example
Free Excel Bookkeeping Templates

Alternatives to Excel Bookkeeping Templates

Free Bookkeeping Software

If you are looking for an alternative to Excel accounting templates, some free bookkeeping packages are available for small businesses. A couple to get started are:

Pandle

Pandle is a full accounting package on the cloud. It is free of charge for small businesses, but there is also a paid-for version.

Zoho Books

Zoho Books has a free version. It offers all the features of a full version up to a turnover of £35,000.

Cloud-Based Accounting Software

Cloud accounting software is popular for business owners as it allows people to access accounts online. There are a few advantages to purchasing a product.

  • You can access your accounts from anywhere.
  • No upfront costs, just a monthly fee
  • Lots of financial reports including income statement and balance sheet
  • Some can track inventory
  • You can give other people access to the data.
  • Most provide a free trial, so you can try before you buy

Alternatives to Microsoft Excel

If you are not using Excel, there are alternatives. We recommend Apache Open Office. It is free to download and use; most of the features are similar to Microsoft.

If you are looking to create your own templates, there are many tutorials available online and on YouTube.

Conclusion to Free Excel Bookkeeping Templates

Using Excel bookkeeping templates are great to get small businesses started on their bookkeeping journey.

We offer a wide range of bookkeeping templates, with support if required. 

Once your business grows, it is worth looking into alternative options of accounting packages.

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