FREE Sales Invoice Template: 2 Free Sales Invoice Download UK
Our free sales invoice template is available to download and use whenever you need to create an invoice. It works with Microsoft Excel and Google Sheets. If you require any changes or colours to fit in with your business, please get in touch, as we can complete it for a small fee.
We have created two sales invoice templates, a VAT and a non-VAT invoice. We have developed both in Excel; this allows calculating the totals once the figures are entered and reduces the risk of errors.
What is a Sales Invoice?
A sales invoice is a document that a business sends to a customer, acting as an official record of a sale. It functions as a detailed bill. Here’s a breakdown of its key features:
- Request for Payment: It asks the customer for payment for the goods or services provided.
- Transaction Details: This outlines what was sold, the sale date, and the total amount owed.
- Payment Terms: It specifies how and when the payment is due (e.g., net 30 days).
- Legal Record: It serves as a legal record of the transaction for both the buyer and seller.
- Accounting Purposes: It’s an essential document for a business’s accounting processes, helping track income and sales tax.
In essence, it’s a way to ensure everyone is on the same page about what was sold, its cost, and when the payment is due. Using a free invoice template will make the process easier.
Why use Free Sales Invoice Templates?
As a small business owner providing a sales invoice to a client, it’s essential to leave a good, lasting impression. Having a well-designed invoice is one way to achieve this. Another way to get an invoice to stand out is to print it on coloured paper.
Using a blank invoice template UK for your invoices eliminates the repetitive task of entering your company’s details each time you need to issue one. Not only does this save valuable time, but it also reduces the likelihood of errors. Well-designed invoice templates come equipped with the functionality to automatically calculate the total amount due based on the figures you input. This feature ensures accuracy in your billing process.
An alternative to using Excel invoice templates is to use a duplicate book or print a form and complete it by hand.
What are the Alternatives for Issuing Invoices?
Many accounting software packages include invoicing software. They allow you to set up sales invoice templates, upload logos, accept online payments, and email invoices; some also offer recurring invoices. The main advantage of using accounting software is to issue professional-looking invoices and track outstanding invoices.
Many have a built-in professional invoice template, allowing you to change the colours to match the company branding. Others have a selection of sales invoice templates with different layouts. Xero allows you to download sales invoice templates, amend them in Word and upload them.
One advantage of using accounting software is that it includes payment applications. Using them often means that you will receive payment faster.
FreshBooks, QuickBooks, Xero and Sage are the best bookkeeping software to consider. If you are after free accounting software, we recommend Pandle. Check our best invoicing software options.
Best Small Business
| From £16 per month |
| Free Trial |
| Integration with apps |
| 90% Discount – 6 Months |
For Business Owners
| From £15 per month |
| Free Trial |
| Pricing by Client Number |
| 50% Discount – 3 Months |
Best Free
| From £12 per month |
| 1,000 invoices PA Free |
| Integrate with Zoho Apps |
| No Discount |
Instructions for Free Invoice Template UK
Simply download the invoicing spreadsheet below and select either VAT or non-VAT. And open it up in Excel or Google Sheets.
The first step is setting up a template for all your sales invoices. For this, you add your business logo, name and address:
The sheet is protected to ensure that the columns with calculations are not accidentally changed. To add a company logo, the sheet needs unprotecting first – to do this, go to File > Info > Protect workbook > click unprotect (password is blank). Once finished, you can protect it again using the same instructions.
You can add a logo by clicking on the area, selecting insert, a picture from a file, and choosing the correct logo. If you do not have a logo, you can delete this section. If you want a new logo, I have used Fiverr and Legiit for logos and have some great designs.
Complete the section for your company name and business address. At the bottom of making the payment, enter either your bank details or the cheque payee.
Important: If you are a Limited Company, it is a legal requirement to include your company registration number, the business name on the certificate of incorporation and the registered address. There is space on the bottom two rows of the invoice template to include it.
If you are VAT-registered, you must include your VAT number for the business and display the sales tax.
Once all the information has been entered, you now have a template that you can use repeatedly. Save this file so that you can find it easily. If you invoice a customer regularly, it may be worth setting up a template for them so you don’t have to enter the details each time and save it under their client name.
How to Issue Sales Invoices
Get Started with Your Sales Invoice:
- Unique Invoice Number: Open your sales invoice template and assign a unique invoice number. Avoid starting with “1” as it suggests a new business. Consider a numbering system that incorporates the year (e.g., INV-2024-001).
- Invoice Details:
- Date: Include the date the invoice is created.
- Customer Reference: Add any reference provided by your customer, such as a purchase order number or contact name.
- Itemised List:
- Description: Clearly describe the service or item sold.
- Quantity: Enter the number of units sold.
- Unit Price: Indicate the price per unit.
- Detailed Descriptions: Provide as much detail as possible to minimize questions from the customer.
- VAT (if applicable):
- VAT Percentage: For VAT-registered businesses, include the VAT rate for each item.
- Automatic Calculations: Most templates automatically calculate the VAT amount and total invoice amount.
- Payment Terms:
- Due Date: Specify the date payment is due based on your agreed-upon credit terms (e.g., 7, 14, or 30 days from the invoice date, or net monthly).
- Saving and Sending:
- Unique Reference: Save the document with a clear, easy-to-find reference, typically the invoice number.
- Optional Client Reference: Consider including the client name followed by the invoice number (e.g., Acme Ltd – INV-2024-001) for better organisation.
- Delivery Options:
- Email or Post: Send the invoice electronically or by mail to your client.
- Paper Records: Print a copy for your files if you maintain paper records.
Open up your sales invoice template and allocate a unique invoice number. Never start your numbering system from 1, as it will make you look like a new business. Choose a number system that fits, maybe using the year first.
Add the sales invoice date and any reference that your customer has supplied; this might be a purchase order number or contact name.
The description of the service or item sold, quantity, and unit price can then be completed. Ensure you provide as much information as possible; this reduces the chances that the customer will need to query the document.
If you are using the VAT version, enter the VAT percentage on each line. The VAT and total will automatically calculate.
Complete the due date; this is the payment terms agreed upon with the customer on the sale. If you offer credit, it may be 7, 14, 30 days or net monthly.
When everything is finished, save the document with a unique reference that you can find easily. In most cases, it will be the invoice number, but you may want to use the client name followed by the invoice number.
The invoice is available to be emailed or posted to the client. If you keep paper-based records, print off a copy for the records.
For more information on what needs to be included in a sales invoice, read the guide on HMRC.
Sample of Invoice Templates
Below is an example of a VAT sales invoice issued to a customer for accounting services. The sales tax is calculated automatically in the template.
Keeping Track of Your Sales Invoices
One of the most effective ways to manage and track invoices is by using our sales invoice list template. This template allows you to record all your invoices in one organised document, making it easy to keep track of payments and due dates. It also has a section specifically for tracking overdue invoices, ensuring no payment slips through the cracks.
Excel Sales Invoice Template UK – Licence Agreement
By downloading our free invoice templates, you agree to our licence agreement, allowing you to use the templates for your own personal or business use only. You may not share, distribute, or resell the templates to anyone else in any way.
You agree to the licence agreement by downloading the free sales invoice template by clicking on the link.
Sales Forecasting
Sales forecasting is essential to the success of any business, as it allows you to plan for future income. Forecasting sales requires a combination of market research, analysing past performance, and understanding customer needs. To help, we’ve created a sales forecast template.
Statement of Account
Once an invoice is sent to a customer, tracking when it is due for payment and when it is paid is essential. At the end of each month, it is worth sending a statement of account for each customer. Read our guide and download the free spreadsheet.
Conclusion to Excel Free Sales Invoice Template
When issuing sales invoices, it’s crucial to include all the necessary information to avoid confusion or customer queries.
Our free Sales Invoice Template UK can help make the process quick and easy. Check out the Microsoft website if you’re looking for a commercial invoice template alternative.
Excel Bookkeeping Templates
Check out our other Excel Bookkeeping templates, including word receipt template, cash book, profit and loss, balance sheet and petty cash.
We also offer a proforma invoice template.
Return from sales invoice template to Excel Bookkeeping Templates page.
Please read our guide on the best accounting software for small businesses.
