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.

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

... As always, InvoicingTemplate.com offers this Service VAT Invoice Template in two edition, on free edition, and another edition that works with Uniform Invoice Software installed. If you use the Uniform Invoice Software version, which is our invoicing software that turns a simple Excel-format invoice template into a complete invoicing system, note that are a number of fields added to support the requirements of this VAT invoice template. The newly added fields, as compared to those fields defined by the default sales invoice template shipped with Uniform Invoice Software, are called custom fields.

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.

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

... When you click the "Clear & New" button, the sales rep. name and payment term are set to their default value respectively. You can change the list of possible values and default values by clicking the "Settings" button on the "Invoice" ribbon tab, and then go to the "Misc. Data" tab.

... This template does not show currency symbols.

Hourly Service Invoice Template (UK Currency)c4026

Hourly Service Invoice Template (UK Currency)

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

... All our templates are offered to you by InvoicingTemplate.com online in Microsoft Excel spreadsheet format, including this Hourly Service Invoice Template (UK Currency). Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It features calculation, graphing tools, pivot tables, and as a part of Microsoft Office - the other famous Office programs includes Word, PowerPoint and Access. It has been the industry standard for spreadsheets, and thus being an ideal maker and format for creating electronic (paperless) fillable, editable and printable sales orders, purchase orders, estimates, invoices, quotes, letters, brochures, receipts, time sheets, statements and other business forms. Our templates, including Hourly Service Invoice Template (UK Currency), are also available in blank downloadable PDF format. We are also providing Uniform Invoice Software, which utilizes these templates and offer powerful processing and management features.

VAT Service Invoice Template - Price Including Taxc6013

VAT Service Invoice 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.

  • In Excel 2003 click the Design Mode button on the Control Toolbox toolbar. Tip: If the Control Toolbox toolbar is invisible, click Excel menu View > Toolbars > Control Toolbox.
  • In Excel 2007, Excel 2010 and Excel 2013, click the Design Mode button in the Controls group of the Developer tab.

    TIP: If the Developer tab is not available in Excel 2007, do the following to display it: a) Click Microsoft Office Button, and then click Excel Options; b) In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

    Or in Excel 2010 and Excel 2013 to display the Developer tab: a) Click File > Options > Customize Ribbon; b) In the area on the right, ensure that the box next to Developer is checked; c) When you click OK, the Developer tab will appear in the ribbon.

Note that if you use the Uniform Invoice Software and need to show the control on an extracted worksheet, then the control should be named with an "oknWidget_" prefix. For example, if you move the Taxable checkboxes into the

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

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

... On the top of the invoicing form, the invoice date and invoice# are populated by Uniform Invoice Software when you click "Save Invoice".

... This template is implemented as a service invoice template. The "Project Description" box allows you to provide a summary description of services being billed, such as monthly monitoring fees, or warranty programs, additional and/or special services.

Bill Format for Lamp / Lighting Businessc6027

Bill Format 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.

... This template is designed with a UK business in mind, so the layout meets the requirements of a UK VAT invoice. For example, below your business detail section a "VAT Registration #" label was added. The default tax name is also set to "VAT" and the default rate is set to 17.5%. You can change the taxation rules on the "Taxes" tab of the "Settings" window.

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

... Note that "Due Date" field in this sample has an Excel formula assigned:

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.

... 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 Billing Form 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 61.

... When working with Uniform Invoice Software (UIS) version of VAT Invoicing Sample with 2 Separate Rates, how does UIS know to which cell when a field value write to when loading data from the database, and to which field a cell value must save when saving an invoice record, a customer or a product item? That is, how does UIS create the map or relationship between Excel cells on the template VAT Invoicing Sample with 2 Separate Rates and database fields? The answer is by using names. For example, if the field name in the Product table in a database is "ProductType", it is writing to a cell named "oknProductType_?" (where ? is the line number of the invoicing item) when you pick up a product or item on creating an invoice, and when saving an invoice, all cells with the name "oknProductType_?" are saved to the "ProductType" field in the "InvBdy" database table. By using cell names, UIS allows you to move a cell on the form without breaking the feature depending on the field / cell. You can place the "Product Type" column either inside the printable area, which is printed when you issue the Print command in Excel or click the Print command on the "Invoice" worksheet form; or place the Product Type column outside the printable area, which will be included when you print or extract an invoice or receipt.

VAT Invoice Template with VAT Rate Columnc6002

VAT Billing 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 58.

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

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

  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 Invoice Template - Price Including Tax

"VAT Sales Invoicing 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. Go to the View tab of the Ribbon.
  3. Click Show/Hide, and then check or uncheck the Gridlines and Headings options.

... (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 Template - Price Excluding Tax" was found to be relative to Free Invoice Templates For Uk with the score grade of 47.

... While all the free invoicing templates available here on InvoicingTemplate.com are results of customization samples of the default sales invoice format shipped with Uniform Invoicing Software, this spreadsheet template, VAT Sales Billing Format - Price Excluding Tax, use custom fields to implement the features that are not available in the default sales invoicing template. If you use the UIS version of this template, you can easily add new fields to the template and make sure they work with UIS with the "Custom Field Manager".

...VAT Sales Invoicing Sample - Price Excluding Tax is provided in two editions - a freeware editions of VAT Sales Invoicing Sample - Price Excluding Tax, and a Uniform Invoice Software (UIS) edition of VAT Sales Invoicing Sample - Price Excluding Tax. Both editions can be downloaded for free from the download page. A PDF edition is also provided at the right section of this page.

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

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

... As you can see from Restaurant Dining Invoice Template (VAT), one benefit of using Excel as your invoice creator, as compared to other template formats like Microsoft Word invoice template and PDF invoice template, HTML format or even Photoshop format, is that you can easily apply formulas to do calculations. This means that, once the basic figures are entered on the form, like Quantity and Unit Price, or Hours and Hourly Rate, or Days and Daily Rate, the calculation of totals and taxes is done automatically.

Freelance Invoice Templatec6018

Freelance Billing Template

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

... Please also see Professional Freelance Bill.

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

... You may find many invoicing templates available here on InvoicingTemplate.com meet the above criterion, including Freelance Invoice Template, Invoice Template Hourly Rate, or visit our service invoice template category. Every business is different. You may like your invoices not only including all the required information, but also looks professional and special to your business. That is why we at InvoicingTemplate.com create this new freelance invoice template and offer you for free, Professional Freelance Bill / Professional Freelance Billing Format.

... The template has no tax set by default (the tax cells are hidden and not printable). With Uniform Invoice Software installed, you can easily change it to one tax or two taxes, depending on your particular needs. Simply click the Settings button on the ribbon tab, and then go to the Taxes tab, choose your tax type (no tax, one tax, two taxes), enter the tax name such as VAT, and the rate, click Apply and you are done! With this flexibility, we can say this template is not only suitable for freelancer, limited company and also sole trader, whether they are VAT-registered or not.

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

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

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

... To convert an Excel workbook or template from ".xlsx" to ".xlsm" format, simply issue the "File" and "Save As" command. We'll skip the detailed steps here as there are already many resource online, such as Create a Macro in Excel - EASY Excel VBA, and How to Use Macros in Excel: 15 Steps (with Pictures), and Quick start: Create a macro.

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

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

... Besides the usual replaceable logo image placeholder located on the top-left corner of the form layout, it also introduces a repairman image located on the top-center, which should be a suitable widget for heating, ventilation and air conditioning services. In fact you can add any images to the template by simply clicking the "Pictures" command on Excel "Insert" ribbon tab. To have the newly added image appear on UIS-generated PDF invoices and bills, you should name the image with "oknWidget" prefix. For example, in this template the repairman image is named "oknWidget_repairman". Visit Customizing Invoice Template for more information. For more samples on templates and images visit Invoice Template Images.

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.

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

  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.

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

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

Website Development Invoicing Samplec2024

Website Development Billing Format

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

... To move the columns out of the printable form, first of all the sheet must be unprotected.

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