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.

...(44) Since this VAT invoice template is designed for UK businesses, the currency symbol on this invoice template is formatted with UK currency symbol. This service tax invoice format is offered as an Excel ".xls" format, and for now it does not work with OpenOffice.

...(58) The VAT invoice template has a special VAT Rate column placed outside of the printable VAT invoice form. This column allows you to adjust the VAT rate for each item that is being sold. Since it is placed outside of the printable VAT invoice form, it will not be included on the printed copy of your VAT invoices.

Consultant VAT Invoice for U.K. Limited Companyc4079

Consultant VAT Invoice Format for UK Limited Company

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

...(36) Basically a grayscale styled invoice template for U.K. consultant businesses. The only colorful thing on the printable form is the logo image placeholder. The template comply with the requirements stated at "VAT record keeping" by GOV.UK.

...(106) A consulting project may there may be other documents that further detail the project. So under the "Bill To" section, we added fields for "Our Ref" and "Cust. Ref" for you to enter the indexing number of related reference documents. For other options, visit our category of consulting invoice templates. The "Sales Rep. Name" and "Payment Term" fields here, like they are in the standard invoice template shipped with Uniform Invoice Software, support the "on-sheet picker" button - this is a smart and little button that appears whenever you click the supported cells, you can open a list of possible choices by clicking the picker button.

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 89.

...(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.

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 78.

...(53) If you don't need the "Service Location" at all, as we did with many other service billing forms here on InvoicingTemplate.com, you can move the section completely out of the printable invoice form - i.e. the area named "Print_Area", you can easily do this by unprotecting the sheet and then dragging and dropping.

...(69) Once VAT Service Invoice Template - Price Including Tax is unprotected and switched into design mode, you can now move the controls to the new location you like. To do this, click to select a control, or push the CTRL on your keyboard and then select all the controls you want to move using mouse. Then, drag (one of) the select controls to move them to the new location.

Bill Format for Integrated Security Servicec4088

Invoicing Template for Integrated Security Service

"Bill Format for Integrated Security Service" was found to be relative to Free Invoice Templates For Uk with the score grade of 76.

...(40) If you are providing integrated security service to your clients, whether it is physical / electronic security services, special event security service, access control solutions, consulting Services, this invoice template could help you create professional bills with easy and quick.

...(60) Just like the other free bill templates available here on InvoicingTemplate.com, this integrated security invoicing template has a client# cell, you can use this as your customer account number. This client# is automatically generated, like the invoice numbering sub-system that assigns increment and unique numbers to each invoice, is based on a counter implemented by Uniform Invoice Software backend database.

Bill Format for Lamp / Lighting Businessc6027

Invoicing Template for Lamp / Lighting Business

"Bill Format for Lamp / Lighting Business" was found to be relative to Free Invoice Templates For Uk with the score grade of 75.

...(32) For business who are specialists in lamps, bulbs and tubes for many hi-tech and specialized applications, this invoicing format might be helpful. This layout is printable with A4 paper in landscape orientation.

...(64) This sample is designed as a sales invoice template, so it includes the shipping address section where you can specify where the goods will be sent to. Note that the "Same As Bill To" button that we usually put near the "Ship To" section does not work for this template, as the "Bill To" section uses custom fields for address and postal code information.

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 65.

...(38) VAT Service Invoice Template - Price Excluding Tax is a sample invoice template demonstrating how to customize an existing invoice template, VAT Sales Invoice Template - Price Excluding Tax, to create a new design that meets your requirements.

...(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 Billing Form with 2 Separate Rates" was found to be relative to Free Invoice Templates For Uk with the score grade of 61.

...(65) The protection of the "Invoice" worksheet in VAT Invoicing Sample with 2 Separate Rates prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in VAT Invoicing Sample with 2 Separate Rates.

  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 Invoice Template with VAT Rate Columnc6002

VAT Billing Template with VAT Rate Column

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

...(29) According to UK (United Kingdom) HM Revenue & Customs "VAT invoices: what they must show", for each different type of item listed on the VAT invoice, you must show:

...(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.

...(41) So to create this VAT Invoice Template with VAT Rate Column template, all we have to do is to firstly unprotect the Invoice worksheet, and then adjust the existing columns to leave space for the newly moved in (VAT Rate) column.

VAT Sales Invoice Template - Price Including Taxc6007

VAT Sales Invoice 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 51.

  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.

...(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 Sample - 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 47.

...(71) Since the unit price on this free VAT invoicing template excludes VAT, we first calculate the Total (Net) on each line from the Unit Price and Quantity, and then calculate VAT amount based on the Total (Net) and VAT Rate (if that invoicing item is taxable - the "Taxable" checkbox is selected), and finally we add up the Total (net) and VAT amount to get the Total (VAT) for each item.

...(81) The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as VAT Sales Invoicing Sample - Price Excluding Tax without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

Restaurant Dining Invoice Template (VAT)c4039

Restaurant Dining Receipt Format (VAT)

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

...(91) A restaurant is a business which prepares and serves food and drinks to customers. Meals are generally served and eaten on premises, but many restaurants also offer take-out and food delivery services. Restaurants vary greatly in appearance and offerings, including a wide variety of cuisines and service models ranging from inexpensive fast food restaurants to high-priced luxury establishments. If you are providing invoice / receipts / vouchers to the customers, clients, takeaways, home delivery and companies, whether it's a printed paper form or electronic document, make it looks professional and beautiful.

...(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 40.

...(109) This invoice design has 6 columns on the invoice detail section - Description, Date, Hours, Rate / Fee and Amount. The Amount is calculated automatically using Excel formulas once the Hours and Rate / Fee are filled in. The other 5 columns, Description, Date, Hours and Rate / Fee are all fillable in this invoice format. As you can see from the screen shots below, this is basically a hourly service invoice template, like Hourly Service Invoice Template. You can also find other interesting invoice template in the Consulting Invoice Template category or Service Invoice Template category here on InvoicingTemplate.com, including those designed specially with UK (United Kingdom) style.

Professional Freelance Billc4047

Professional Freelance Billing Format

"Professional Freelance Billing Format" was found to be relative to Free Invoice Templates For Uk with the score grade of 35.

...(33) As a freelancer you know it's important to get paid without delay and a professional invoice could be helpful. Being professional means your bill contains all the required information that are formatted properly.

...(104) No matter what freelance service you offer - freelance web design, graphic design, photography, copywriting, computer programming, website development, consulting, video production, translation, etc. - it makes sense to have a number of documents prepared as you tend to use the same ones over and over again. Invoice Template is one of them that you will find useful. If you are not family with invoicing yet, invoices should include: Who the invoice is to (client), Who the invoice is from (you), Date and invoice number, Service(s) carried out, Total costs, Any terms e.g. Payment required on receipt of invoice, A little thank you note.

Freelance Writer Invoicec3012

Freelance Writer Billing Template

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

...(152) Another important invoicing tips for freelancer writers or designers is tracking invoices and payments. While the pure Excel-formatted template does produce beautiful and professional invoices, it is not easy when it comes to number and tracking invoices / payments. With pure Excel spreadsheet template, you have to number invoices manually and track payments manually. And as a freelancer, you may not want to use those expensive and complex accounting / bookkeeping software systems. This is no longer a problem if you have Uniform Invoice Software installed, which is our Excel-based desktop invoicing software app that connect an Excel spreadsheet template with back end database, offers advanced features like management of customers, products, invoices and payments. Feel free to download the fully functional trail version and see how it works for you. The invoicing app is also able to generate PDF copy of your freelance invoice and send it to your customer electronically.

  • Right click the Logo image, and then select Properties from the menu.
  • Click the Picture property, and then click the "..." button.
  • Browse to the folder containing your icon file. Select and open the icon file.
  • Close the Properties dialog box.
  • Drag the border of the image object to resize it, if needed.

Advanced Invoicing Sample - Macro-Enabled Invoicing Templatec5101

Advanced Invoicing Sample - Macro-Enabled Invoicing Template

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

...(59) Uniform Invoice Software supports all the Excel file formats, including the traditional ".xls" and ".xla" formats, and the new ".xlsx" (Excel XML-based file format), ".xlsm" (Excel XML-based and macro-enabled file format), and ".xlsb" (Excel Binary (or BIFF12) file format). ".xlsx" are now the most widely used workbook file format. Feel free to see our Invoice Template ".xlsx" topic page.

...(27) The sample invoice template used here is c5099 Standard Business Invoicing Template. See our business invoice templates for more samples that are most closely related to "BUSINESS".

...(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

Invoicing Format for HVAC Service

"A C invoice template" was found to be relative to Free Invoice Templates For Uk with the score grade of 20.

...(86) This is a service invoice template, featuring a "Bill To" section and a "Service Location" section that allow you to enter different billing address and the location to perform the HVAC service. In the detail section, there are two parts, just like the parts and labor invoice form. The parts and labor could have different tax rates. On the bottom of the form, the "TOTAL AMOUNT PAYABLE" field calculates the grand total from both the parts and labor sections using a simple Excel formula like this:

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

Proforma (4th Sample)

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

...(30) This free sample proforma invoice templates differs from the previous proforma invoice forms in that the layout is customized to be printable on standard A4 paper with landscape page orientation.

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

...(26) Once you have finished your design work for Proforma Invoice Template (4th Sample, Landscape Page Orientation), click the Design Mode button again to exit design mode.

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

Website Development Invoicing Samplec2024

Website Development Invoicing Sample

"Website Development Billing Format" was found to be relative to Free Invoice Templates For Uk with the score grade of 3.

...(125) The "Lock" property is a very useful feature in Excel. When you protect a worksheet such as Website Development Invoicing Sample, all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the "Invoice" worksheet of Website Development Invoicing Sample. To lock a cell or a range of cells, first drag your mouse to select the cell or cells, and then right-click one of the selected cell on the form, choose Format Cells. On the Number tab, check the "Locked" box. To unlock a cell or a range of cells, simply clear the "Locked" box.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c4010
Service VAT Invoice Template
Monday, January 13, 2014,
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
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
c9007
Commercial Invoice Format with Editable Word Art Logo
Wednesday, July 13, 2016,
9
9
A4
Landscape
Pro-forma
c2024
Website Development Invoicing Sample
Wednesday, December 2, 2015,
6
2
A4
Portrait
Service

What Is Hot

Feature Galleries