Skip to main content
InvoicingTemplate.com main content

Summary

Whether you are an UK-based sole trader, limited company, freelancer, contractor, or other types of business owner, it is important that you have a structured approach to your invoicing or you may lose track of what payments you are waiting for. Download our Excel invoicing templates and start create professional invoices and bills in seconds!

As required by the United Kingdom government, such as Invoicing and taking payment from customers and VAT record keeping, an invoice should include certain information in order to be legally valid, depending on factors like whether you are VAT-registered. For VAT invoices, it could be full invoice, simplified invoice, modified invoice; and if you invoicing only for exempt or zero-rated sales within the UK, you don't have to issue VAT invoice.

Here are our templates closely related to Free Invoice Templates For Uk.

Service VAT Invoice Templatec4010

Service VAT Invoice Format

"Service VAT Invoice Template" was found to be relative to Free Invoice Templates For Uk with the score grade of 96.

...(105) Although it is easy to create the layout and format of Service VAT Invoice Template with Microsoft Word or other Microsoft Office programs, or even with some PDF programs like Adobe Acrobat, the support for Excel formulas makes doing automated calculations easy to implement and modify. For example, Service VAT Invoice Template uses Excel formulas extensively to do calculations whenever possible and necessary, such as the taxes, totals. If you use the Uniform Invoice Software version of Service VAT Invoice Template, Excel formulas are also used to create the relationship between several fields, such as one field should be the sum of two other fields.

Invoice Template VAT UKc4106

Invoice Template VAT UK

"Invoice Template VAT UK" was found to be relative to Free Invoice Templates For Uk with the score grade of 89.

...(88) After adding the custom field to database, the next step is to specify a cell on your invoice form to put the VAT Registration No. value. That is, the task here is to specify a cell, so that when a customer is selected, the customer's VAT Registration No. is loaded into this cell; and when you save an invoice, the value of this cell is saved into the VAT Registration No. field of the Invoice Header database table. This is implemented by naming a cell, as detailed below.

Consultant VAT Invoice for U.K. Limited Companyc4079

Consultant VAT Invoice Format for UK Limited Company

"Consultant VAT Invoice for U.K. Limited Company" was found to be relative to Free Invoice Templates For Uk with the score grade of 89.

...(125) To change the currency symbol of Consultant VAT Invoice for U.K. Limited Company, first make sure you've unprotected Consultant VAT Invoice for U.K. Limited Company spreadsheet. Select the cells (fields) for which you want to modify the currency symbol, by dragging your mouse to select multiple cells on Consultant VAT Invoice for U.K. Limited Company, you push CTRL key on keyboard and click each cell on Consultant VAT Invoice for U.K. Limited Company one by one, and then right-click one of the selected cell and choose Format Cells. From the Number tab, you can choose either "Currency" or "Accounting" from the Category list. Note that currency formats are used for general monetary values, you should use accounting formats to align decimal points in a column.

Hourly Service Invoice Template (UK Currency)c4026

Hourly Service Billing Statement (UK Currency)

"Hourly Service Billing Statement (UK Currency)" was found to be relative to Free Invoice Templates For Uk with the score grade of 78.

...(121) To change the currency symbol of Hourly Service Invoice Template (UK Currency), first make sure you've unprotected Hourly Service Invoice Template (UK Currency) spreadsheet. Select the cells (fields) for which you want to modify the currency symbol, by dragging your mouse to select multiple cells on Hourly Service Invoice Template (UK Currency), you push CTRL key on keyboard and click each cell on Hourly Service Invoice Template (UK Currency) one by one, and then right-click one of the selected cell and choose Format Cells. From the Number tab, you can choose either "Currency" or "Accounting" from the Category list. Note that currency formats are used for general monetary values, you should use accounting formats to align decimal points in a column.

...(31) If you prefer a currency-neutral version of this service invoice template, see c4025 Hourly Service Invoice Template / Hourly Service Billing Statement where the numbers are shown without any currency symbol.

VAT Service Invoice Template - Price Including Taxc6013

VAT Service Invoicing Template - Price Including Tax

"VAT Service Invoice Template - Price Including Tax" was found to be relative to Free Invoice Templates For Uk with the score grade of 76.

...(245) Moving a cell or a group of cells is easy in Excel. First, you click to select the cell or drag your mouse to select all the cells you want to move. And then, drag the border of the selected area to move it to the new location where you want to place the cell or cells. The moving content will overwrite the content in the target location, so make sure the target range is empty (not used) in VAT Service Invoice Template - Price Including Tax before doing the movement. And, if the target location contains merged cells, sometimes the movement fails. So it is also helpful to make sure the target location does not contain merged cell. If the target location VAT Service Invoice Template - Price Including Tax is overlapping the original range and the original range contains merged cells, the movement could also fail because you cannot change part of merged cell - if this happens, you need to first move the cells to a temporal location in VAT Service Invoice Template - Price Including Tax that are empty (i.e. not used), unmerge cells, and then move the cells from the temporal location to the desired location. If you need to unmerge a cell, first select it and then click the "Merge and Center" command on the Format toolbar in Excel 2003; or click the "Merge and Center" command on the Home ribbon tab in Excel 2007, 2010 and Excel 2013.

UK Tax Invoice Templatec6005

UK Tax Billing Form

"UK Tax Invoice Template" was found to be relative to Free Invoice Templates For Uk with the score grade of 75.

...(83) The taxable checkboxes were removed completely, assuming all the products are taxable, no matter whether the Taxable option is checked or not for each product. This avoids an occasionally happened mistake when a taxable product or item must be manually entered on the invoice body, as the Taxable checkbox is not checked by default. The template implements this feature by deleting all the Taxable checkboxes and assigning a value of 1 (TRUE) to all the oknTaxable cells located in the hidden column C.

Bill Format for Integrated Security Servicec4088

Invoicing Template for Integrated Security Service

"Invoicing Template for Integrated Security Service" was found to be relative to Free Invoice Templates For Uk with the score grade of 65.

...(142) The detail section is itemized so you can list your charges one by one. For example, "Hours Labour Only At Above Job Address", " Days Labour Only At Above Job Address", "Installation of CCTV System", "Installation & Commissioning Of Intruder Alarm System At Above Job Address", "Service Call Out", "Supply & Install Replacement VCL 8" Orbitor Gold Dome", "Camera Repair Returns Cost", "Annual Service to CCTV System", "Replacement Acrylic Dome Cover", "Installation Of Alarm System At Above Job Address", "Installation Of Chubb Monitored Lock (Labour Only )". Note that if you have our invoicing software program installed, each product could have an ID, which allows you to quickly enter the product description and unit price into the printable invoicing form by entering the product ID. This feature is called in-cell lookup. All the Excel invoice templates here on InvoicingTemplate.com support this functionality.

Bill Format for Lamp / Lighting Businessc6027

Bill Format for Lamp / Lighting Business

"Invoicing Template for Lamp / Lighting Business" was found to be relative to Free Invoice Templates For Uk with the score grade of 61.

...(70) As a vendor of lamp / lighting solutions, through effectively engaging with your customers and fully understanding their lamp requirements, you provide a service and product which will significantly improve your customer's service aims and reduce equipment down-time. Besides that, you should also provide professional invoices to show your clients that you are not only care about your main business, but also every detail that are related to your business.

...(56) This formula means that if "oknPaymentTerm" equals to "Net 30", the "Due Date" will be the end date of the next month to the invoice date; giving any other values to "oknPaymentTerm" causes the "Due Date" to be the invoice date. The "oknPaymentTerm" cell referenced in the above formula is placed outside the printable invoicing form.

VAT Service Invoice Template - Price Excluding Taxc6014

VAT Service Invoice Template - Price Excluding Tax

"VAT Service Invoicing Template - Price Excluding Tax" was found to be relative to Free Invoice Templates For Uk with the score grade of 58.

...(138) The VAT service invoice template helps you to create invoices associated with both professional and non-professional services: legal, medical or accounting, freelance work, consulting, handyman work, housecleaning and babysitting, landscaping and gardening, auto repairs, catering, child care, pet care, tutoring, and other services. It is a simple, easy to use, free Excel invoice template that can be customized to fit your specific circumstance. If you work as an independent contractor or own a small company that performs a specialized service, the odds are that you will need to learn how to write an invoice for services rendered to acquire your due payment. This VAT invoice template could be a handy tool for you to get the job done. If you are a UK-based business, InvoicingTemplate.com has another VAT service invoice template for you at Service VAT Invoice Template.

VAT Invoicing Sample with 2 Separate Ratesc5005

VAT Invoicing Sample with 2 Separate Rates

"VAT Invoicing Sample with 2 Separate Rates" was found to be relative to Free Invoice Templates For Uk with the score grade of 51.

...(134) In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside VAT Invoicing Sample with 2 Separate Rates. Note that if you have our invoicing program installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products, bills and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.

...(11) To show gridlines and row/column headers in Excel 2000 - 2003:

...(36) Once the worksheet is unprotected and switched to design mode, you can move the logo image by dragging and dropping. Or to delete it completely, click to select it and hit DEL key on your keyboard.

VAT Invoice Template with VAT Rate Columnc6002

VAT Invoice Template with VAT Rate Column

"VAT Billing Template with VAT Rate Column" was found to be relative to Free Invoice Templates For Uk with the score grade of 47.

...(40) The original design found on VAT Invoice Template with 2 Separate Rates does not include the VAT Rate column inside the printable invoice form - i.e. the VAT Rate column is put outside the range defined by the Print_Area name.

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. On the Tools menu, click Options, and then click the View tab.
  3. Under Window options, check the Gridlines and Row & Column Headers check boxes.
  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. Go to the View tab of the Ribbon.
  3. Click Show/Hide, and then check or uncheck the Gridlines and Headings options.

VAT Sales Invoice Template - Price Including Taxc6007

VAT Sales Invoicing Template - Price Including Tax

"VAT Sales Invoice Template - Price Including Tax" was found to be relative to Free Invoice Templates For Uk with the score grade of 43.

...(53) Like many other invoicing templates here on Invoicing Templates, VAT Sales Invoicing Template - Price Including Tax has a default logo image on the top of the invoice form. To replace it with your default logo image, you need to first unprotect the invoice worksheet, and then put the spreadsheet into design mode.

...(16) The gridlines and row/column headings could help a lot when design the layout of the form.

...(93) (Note that if you have installed the latest version of our invoicing software, Uniform Invoice Software, which is able to upgrade a simple template in Microsoft Excel spreadsheet format into a complete invoicing system, you don't have to replace the logo image manually - you can replace the default logo image by clicking the "Replace Logo Image" button on the ribbon tab in Excel 2007, Excel 2010 and Excel 2013). To replace the default LOGO image in VAT Sales Invoice Template - Price Including Tax with your own image, follow the steps below:

VAT Sales Invoicing Sample - Price Excluding Taxc6008

VAT Sales Invoicing Template - Price Excluding Tax

"VAT Sales Invoicing Sample - Price Excluding Tax" was found to be relative to Free Invoice Templates For Uk with the score grade of 40.

...(122) Effective invoicing procedures are crucial to the financial health of all businesses. Making sure that all details are correct and reflect the terms of your contract – with no room for query to delay payment. It is no doubt that a professional design invoice will help you get payment faster. Browse our free invoicing templates gallery to find out the one that meets your business requirements. In case you can't find the one that meets your business requirements exactly, you can still use our templates as a starting point. Remember that Microsoft Excel already provides all the powerful tools you need to further customize the invoicing form, including the use of formulas to define the new relationship between the fields you need.

Restaurant Dining Invoice Template (VAT)c4039

Restaurant Dining Receipt Format (VAT)

"Restaurant Dining Receipt Format (VAT)" was found to be relative to Free Invoice Templates For Uk with the score grade of 35.

...(121) Although there are already several service invoice templates available here on InvoicingTemplate.com, Restaurant Dining Invoice Template (Restaurant Dining Receipt Format) has been customized to meet the specific business needs. Like all retail businesses, the restaurant deals directly with its customers. A professional and beautiful invoice or bill tells your customer that you are caring about your business even on the particulars. A restaurant invoice is known by many names; in England, it is known as the bill, while in America and other parts of the world, it is also known as the check. No matter how it is named, it shows not only prices quoted in the menu, and also some extra charges like Value Added Taxes (VAT) and service charges.

...(28) By using Excel formulas, Restaurant Dining Invoice Template (Restaurant Dining Receipt Format) is able to is able to calculate line total, subtotal, discount, tax and total payable automatically.

Freelance Invoice Templatec6018

Freelance Billing Template

"Freelance Invoice Template" was found to be relative to Free Invoice Templates For Uk with the score grade of 31.

...(97) As a freelancer, creating invoices might not what you best at but it is necessary. Further more your invoice should be prim and proper, so that you can get paid by your clients efficiently. While invoicing is not a fun task, it's a necessary one: by keeping clients informed of your expectations, you will get paid punctually and reinforce your professionalism. Using a template is the most easy and quick way to get the job done. Our templates online here on InvoicingTemplate.com help you spend less time creating invoices and more time doing the things you love.

Professional Freelance Billc4047

Professional Freelance Bill

"Professional Freelance Bill" was found to be relative to Free Invoice Templates For Uk with the score grade of 22.

...(153) Whenever you have completed a service and are ready to be paid, you must always submit an invoice to your client. Occasionally, clients will not follow up with an invoice request, so it's your job to keep track of the payments due to you. The important part is to keep track of the invoices you submit (using an invoice processing system helps with this a great deal), and follow up on a regular basis with a polite email or phone call asking for a status update on your payment. With Uniform Invoice Software installed, you can find all pending (not paid) invoices with a single click of mouse - i.e. clicking the "Invoices" button on the ribbon tab. You can sort the invoice list by any column - simply double clicking the column heading, or search for an existing invoice by a criterion applied to almost any fields available on the invoicing form.

Freelance Writer Invoicec3012

Freelance Writer Invoice

"Freelance Writer Invoice" was found to be relative to Free Invoice Templates For Uk with the score grade of 20.

...(65) All invoice templates here on InvoicingTemplate.com are in Excel spreadsheet format (xlsx or xls). While Microsoft Word can also be used to procedure beautiful and professional invoices in docx or doc format, the benefits of Excel is clear - it is more suitable for doing calculations. For example, in this template the line totals, subtotal, tax and total are all computed automatically using Excel formulas.

...(88) (Note that if you have installed the latest version of our invoicing software, Uniform Invoice Software, which is able to upgrade a simple template in Microsoft Excel spreadsheet format into a complete invoicing system, you don't have to replace the logo image manually - you can replace the default logo image by clicking the "Replace Logo Image" button on the ribbon tab in Excel 2007, Excel 2010 and Excel 2013). To replace the default LOGO image in Freelance Writer Invoice with your own image, follow the steps below:

Advanced Invoicing Sample - Macro-Enabled Invoicing Templatec5101

Advanced Bill Sample - Macro-Enabled Billing Template

"Advanced Invoicing Sample - Macro-Enabled Invoicing Template" was found to be relative to Free Invoice Templates For Uk with the score grade of 8.

...(65) With the Simple Invoice Templates series we demonstrate how to do basic customizations on create and customizing your own bill format for your business, such as how to change fonts, move cells to create a new layout, change formulas to create a new business logic, etc. See this document to find out more information on the rules and guidelines on creating your own invoice template.

...(40) One of the major concerns about using macro-enabled templates is that security settings of Microsoft Excel. If the macro you create does not have a digital signature, with the default security settings Excel disables it with a warning message shown.

Invoicing Format for HVAC Servicec4089

A C invoice template

"Invoicing Format for HVAC Service" was found to be relative to Free Invoice Templates For Uk with the score grade of 5.

...(86) The "Invoice" ribbon is created by Uniform Invoice Software (UIS) - i.e. you have to install UIS in order to have Excel show the ribbon tab. This ribbon tab provides global commands, that are available to all the worksheets in the Excel spreadsheet template, such as "Customers", "Products", "Invoices", "Reports", "Settings" and "Help"; there are also shortcut to commands that affect the working mode the invoicing form, such as "Hide Task Pane", "Disable On-sheet Picker", "Design Mode", "Replace Logo Image", "Add / Update PayPal Button", etc.

Proforma Invoice Template (4th Sample, Landscape Page Orientation)c7014

Proforma Invoice Template (4th Sample, Landscape Page Orientation)

"Proforma Invoice Template (4th Sample, Landscape Page Orientation)" was found to be relative to Free Invoice Templates For Uk with the score grade of 3.

...(23) Now on the Page tab of the Page Setup dialog box, we choose "Landscape" and then click OK to close the dialog box.

...(135) In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Proforma Invoice Template (4th Sample, Landscape Page Orientation). Note that if you have our invoicing program installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products, bills and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.

...(48) Now adjust the column widths to make it suitable for landscape A4 paper. Remember our goal is to have more space for the description column, so we'll mainly increase the widths of the Excel raw columns that are part of the Description column on the proforma invoice form.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c4010
Service VAT Invoice Template
Monday, January 13, 2014,
12
4
A4
Portrait
Service
c4106
Invoice Template VAT UK
Tuesday, March 21, 2017,
12
4
A4
Portrait
Service
c4079
Consultant VAT Invoice for U.K. Limited Company
Thursday, July 7, 2016,
11
4
A4
Portrait
Consulting
c4026
Hourly Service Invoice Template (UK Currency)
Monday, September 29, 2014,
12
4
A4
Portrait
Service
c6013
VAT Service Invoice Template - Price Including Tax
Wednesday, May 28, 2014,
18
6
A4
Portrait
Service
c6005
UK Tax Invoice Template
Monday, March 20, 2017,
15
6
A4
Portrait
Sales
c4088
Bill Format for Integrated Security Service
Saturday, October 15, 2016,
12
4
A4
Portrait
Service
c6027
Bill Format for Lamp / Lighting Business
Sunday, October 16, 2016,
12
6
A4
Landscape
Sales
c6014
VAT Service Invoice Template - Price Excluding Tax
Thursday, May 29, 2014,
18
6
A4
Portrait
Service
c5005
VAT Invoicing Sample with 2 Separate Rates
Saturday, April 26, 2014,
12
5
A4
Portrait
Sales
c6002
VAT Invoice Template with VAT Rate Column
Wednesday, April 30, 2014,
12
6
A4
Portrait
Sales
c6007
VAT Sales Invoice Template - Price Including Tax
Monday, May 26, 2014,
18
6
A4
Portrait
Sales
c6008
VAT Sales Invoicing Sample - Price Excluding Tax
Tuesday, May 27, 2014,
18
6
A4
Portrait
Sales
c4039
Restaurant Dining Invoice Template (VAT)
Thursday, August 27, 2015,
20
4
A4
Portrait
Receipt
c6018
Freelance Invoice Template
Wednesday, October 1, 2014,
12
6
A4
Portrait
Consulting
c4047
Professional Freelance Bill
Friday, November 13, 2015,
6
4
A4
Portrait
Service
c3012
Freelance Writer Invoice
Saturday, May 14, 2016,
10
3
A4
Portrait
Service
c5101
Advanced Invoicing Sample - Macro-Enabled Invoicing Template
Sunday, November 20, 2016,
12
5
A4
Portrait
Sales
c4089
Invoicing Format for HVAC Service
Thursday, October 20, 2016,
18
4
A4
Portrait
Service
c7014
Proforma Invoice Template (4th Sample, Landscape Page Orientation)
Monday, December 9, 2013,
20
7
A4
Landscape
Pro-forma

What Is Hot

Feature Galleries