BoostExcel.com main content

Summary

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 - 20 Results Found.

Service VAT Invoice Template
c4010
Service VAT Invoice Format

As HMRC states, "If you are registered for VAT, then whenever you supply goods or services to someone else who is also registered for VAT you must give them a VAT invoice." A VAT invoice must show certain VAT details. This VAT invoice template meets the requirements detailed on the HMRC web site. A PDF version is also provided for free. You can use this VAT Service Invoice Template as a sample of your own VAT invoices.

Invoice Template VAT UK
c4106
Invoice Template VAT UK
  1. Unprotect the worksheet.
  2. Click to select the cell or control you want to move, or drag your mouse to select all the cells you want to move (such as a column), or if the cells / controls to move are not adjacent, push CTRL key on your keyboard and click the cells / controls one by one.
  3. Drag the selected cells / controls to the new location.
  4. Move other cells or controls as needed.
  5. Once finished, protect the sheet by exit design mode.
Consultant VAT Invoice for U.K. Limited Company
c4079
Consultant VAT Invoice for U.K. Limited Company

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 Invoice Manager for Excel, 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.

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

Hourly Service Invoice Template (UK Currency)
c4026
Hourly Service Billing Statement (UK Currency)

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.

Personal Invoice Template for UK
c6034
Personal Invoice Form in Excel for UK

This free personal invoice template for UK is an Excel spreadsheet template that features a UK ceremonial soldier on the bottom of the sheet. It also shows the UK Sterling currency symbol on total fields.

VAT Service Invoice Template - Price Including Tax
c6013
VAT Service Invoicing Template - Price Including Tax

VAT Service Invoicing Sample - Price Including Tax (c6013) is a direct variant of c6007 VAT Sales Invoicing Form - Price Including Tax. It differs from the original free invoicing Sample in that it the shipping address section is now labeled with Service Location.

UK Tax Invoice Template
c6005
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
c4088
Bill Format for Integrated Security Service

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

Bill Format for Lamp / Lighting Business
c6027
Bill Format for Lamp / Lighting Business

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.

VAT Service Invoice Template - Price Excluding Tax
c6014
VAT Service Invoice Template - Price Excluding Tax

In this serial of VAT invoice templates, InvoicingTemplate.com also offers you the other two VAT invoicing templates, where the prices include VAT, at VAT Sales Invoice Template - Price Including Tax, and VAT Service Invoice Template - Price Including Tax.

VAT Invoicing Sample with 2 Separate Rates
c5005
VAT Billing Form with 2 Separate Rates
  1. Set VAT tax rates.

    Open the template in Excel. Click the Settings button. On the Taxes tab specify the tax rates for the two VAT taxes. Click Apply.

  2. Create new customer accounts.

    New customers can be added by either clicking the Save As New Customer button on the Excel spreadsheet form, or by using the New Customer window that can be opened by clicking the Customers button on the Invoice worksheet.

    In either way, you can enter the VAT ID (VAT #) of the customer.

    When creating invoices, you pick up a customer by clicking the icon button, the VAT ID of the customer is retrieved along with other customer information. If a VAT ID is present, the invoice is VAT free.

  3. Create product/service items.

    To add new products, click the Products button on the Invoice worksheet, and then click Add Product. On the New Product window, you can find a TaxCategory field on the Custom Fields tab; with this field you can specify the tax category of the current product or service item. Please make sure the tax category you enter here matches the tax name you enter on the Settings window.

VAT Invoice Template with VAT Rate Column
c6002
VAT Invoice Template with VAT Rate Column

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:

VAT Sales Invoice Template - Price Including Tax
c6007
VAT Sales Invoicing Template - Price Including Tax

A counter partner of this free VAT invoice template is also available here on InvoicingTemplate.com, at VAT Sales Invoice Template - Price Excluding Tax, which defines the price in the way that does not include VAT. Choose any template that suits your business requirements and download it for free.

VAT Sales Invoicing Sample - Price Excluding Tax
c6008
VAT Sales Invoicing Sample - Price Excluding Tax

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.

Restaurant Dining Invoice Template (VAT)
c4039
Restaurant Dining Invoice Template (VAT)

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.

Arabic Invoice Template
c5163
Arabic Bill

Unlike c5073 United Arab Emirates Invoice Template that keeps English text on the invoice sheet, this Arabic Invoice Template (c5163) translates the text inside the printable area into Arabic.

Freelance Invoice Template
c6018
Freelance Invoice Template

If you are a freelancer and or running a small business, doing writing, designing or as a consultant or carpenter, a professional looking invoicing template helps you get paid fast. Download Freelance Invoice Template now and start creating invoices in seconds.

Professional Freelance Bill
c4047
Professional Freelance Billing Format

The template has no tax set by default (the tax cells are hidden and not printable). With Invoice Manager for Excel 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 Invoice
c3012
Freelance Writer Billing Template

To getting paid on time for your freelance writing / designing / editing / journalist / website developing / consulting / video production / translation work the best way is to send an invoice, by traditional postal mail or electronical email, in either PDF format, Excel spreadsheet (xlsx / xls) format, or even image format.

Advanced Sample - Macro-Enabled Invoicing Template
c5101
Advanced Bill Sample - Macro-Enabled Billing Template

While most templates here on InvoicingTemplate.com are ".xlsx" and ".xls" formats, Invoice Manager for Excel does work with macro-enabled invoice templates. This sample introduces the steps to use ".xlsm" workbooks and templates.