Skip to main content main content
Sharing Is Caring! We do appreciate your time to let others know us!


UK flag

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 Template for UK.

Service VAT Invoice Template

Service VAT Invoice Format

As always, 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.

Invoice Template VAT UK

Invoice Form VAT UK

This service vat invoice template does not use Ship To fields, but added several new fields on invoice header, such as VAT Registration No., Application Type, VAT Total. It also added two new columns, VAT Rate and VAT Amount. For each product or service item, you can set a VAT percentage rate, which is loaded when you pick up a product or service item by clicking one of the icon buttons. For a product where there is no VAT payable there simply will be no figure in the VAT section, therefore, where VAT is zero the price and the total will read the same. The currency symbol of this billing template is set for UK (United Kingdom) format.

Consultant VAT Invoice for U.K. Limited Company

Consultant VAT Invoice Format for UK Limited Company

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.

This templates assumes all items are charged at the same VAT rate.

Hourly Service Invoice Template (UK Currency)

Hourly Service Billing Statement (UK Currency)

If you know Microsoft Excel, you may already know how to change the number format so that it shows a currency symbol before the actual values. If you are not familiar with Microsoft Excel, here are the basic steps to follow.

VAT Service Invoice Template - Price Including Tax

VAT Service Invoicing Template - Price Including Tax

If you don't need the "Service Location" at all, as we did with many other service billing forms here on, 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.

UK Tax Invoice Template

UK Tax Invoice Template

This template might be ideal for UK (United Kingdom) based stores or limited companies. The template shows postcode on a separate line, and an extra column was added for discounting.

Bill Format for Integrated Security Service

Invoicing Template for Integrated Security Service

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

Bill Format for Lamp / Lighting Business

Invoicing Template for Lamp / Lighting Business

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 Tax

VAT Service Invoice Template - Price Excluding Tax

If you offer different product types that have different tax rates, it is better to details this fact on your invoices. has designed such a template for you too, which is available at VAT Invoice Template with VAT Rate Column and VAT Invoice Template with 2 Separate Rates. If you need to show both the VAT rate and VAT amount for each invoicing item, visit VAT Invoice Template with VAT Rate and Amount Column.

VAT Invoicing Sample with 2 Separate Rates

VAT Billing Form with 2 Separate Rates

This sample uses several custom fields to implement the feature that are not found in the default template shipped with Uniform Invoice Software.

VAT Invoice Template with VAT Rate Column

VAT Invoice Template with VAT Rate Column

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.

VAT Sales Invoice Template - Price Including Tax

VAT Sales Invoice Template - Price Including Tax

As the name implies, the price on this template including tax, so that the total, which is calculated by "Price * Quantity", includes the VAT amount. The VAT amount column inside the printable invoicing form is calculated with the formula "Total (VAT) - Total (Net), where the "Total (Net)" is calculated with a formula like "Total including VAT / (1 + VAT Rate)" if the item that is being invoiced is taxable; or the "Total (Net)" equals to "Total (VAT)" if the current item is not taxable.

VAT Sales Invoicing Sample - Price Excluding Tax

VAT Sales Invoicing Template - Price Excluding Tax

When filling in this blank VAT invoicing template, note the following. The first is the invoice#, which is a unique number you assign to identify the invoice in your own accounting system, such as "INV0001". If you have Uniform Invoice Software (UIS), clicking the "Save To DB" will cause the program to generate the invoice number automatically; Invoice Date, this is simply the date the invoice was issued. Usually today's date. Again, if you have UIS installed, clicking the "Clear & New" button will fill in the current date automatically; PO Number: Purchase Order Number - this may be provided by your client to help tie your invoice to a corresponding record on their system; Payment Term: How long your client has to pay your invoice, which is legally binding, and if their payment is overdue you can take action.

Restaurant Dining Invoice Template (VAT)

Restaurant Dining Receipt Format (VAT)

Note If you were coming here when looking for a template for your hotel business, visit Hotel Receipt Template. This template has one tax named VAT set by default. For an edition that has no tax, visit Restaurant Dining Invoice Template (No Tax) here on

Freelance Invoice Template

Freelance Billing Template

On the top of the freelance invoice template, you see a logo image. This is a placeholder image that you should replace with your own image. Download the template and see the instructions included to find out how to do this. Next to the logo is your company or business information, including your company name, your name, address, telephone number and email address or web site address. If you client have any questions about the charges, contacting you should be as easy as possible. On the top-right section there is two required fields, the invoice# and invoicing date. If Uniform Invoice Software - our invoicing software that is able to turn a simple Excel invoice template into a complete invoicing program, is installed, clicking on the "Clear & New" button will fill in the invoicing date automatically (as long as other usual fields such as sales person etc.), and an invoice# is generated automatically when you click "Save To DB". On the client section, you can detail the client's address. Make sure to include the name of the client's contact person who handles your account! A company with three employees can figure out what you're doing; but in big companies, invoices get misplaced, especially if there's confusion over who belongs to which project. So always fill in all the required information as detailed as possible.

Professional Freelance Bill

Professional Freelance Billing Format

You may find many invoicing templates available here on 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 create this new freelance invoice template and offer you for free, Professional Freelance Bill / Professional Freelance Billing Format.

Freelance Writer Invoice

Freelance Writer Invoice

We've already published an invoice format for freelancers, at Freelance Invoice Template; and for a list of invoicing forms that could be used by freelancers like designers, developers etc., visit Freelance Invoice Template For Service Business, Graphic Design Freelance Invoice Template, Freelance Web Design Invoice Template, etc. Unlike Freelance Invoice Template, where the calculation of line totals are done by multiply "Hours * Hourly Rate", in this billing template sample Freelance Writer Invoice Template, the amount of each line is manually fillable - this means that it is more suitable for project or contract - based billing. You can find more invoice samples for hourly-rate based invoicing under the Service Invoice Template and Consulting Invoice Template.

Advanced Invoicing Sample - Macro-Enabled Invoicing Template

Advanced Bill Sample - Macro-Enabled Billing Template

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.

Invoicing Format for HVAC Service

A C invoice template

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)

Proforma (4th Sample)

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