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.
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.
This service vat invoice template does not usefields, but added several new fields on invoice header, such as , , . It also added two new columns, and . 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.
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.
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.
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.
If you offer different product types that have different tax rates, it is better to details this fact on your invoices. InvoicingTemplate.com 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.
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.
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.
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.
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.
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.
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.
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: