Excise Invoice Template

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:

Considering this VAT invoice template, we use two custom columns (i.e. custom fields), VatAmt and ProdVat. ProdVat means the VAT percentage rate of product or service; VatAmt means VAT amount, which is calculate from VAT percentage rate and Price (as this is a service VAT invoice template and the Quantity is assumed to be 1). Based on this usage analysis, it is clear that ProdVat should be added to both Product and Invoice Body database tables, and VatAmt should be added to Invoice Body database table.

We've also set this template to not show the currency symbol. If you want to change that, simply switch to design mode and then set the number formats of those cells for which you want to change the currency symbols.

An updated version is available here on InvoicingTemplate.com, which implements a drop-down list for the VAT Rate column. See Invoice Template VAT UK to download it.

• The unit price or rate, excluding VAT.
• The quantity of goods or the extent of the services.
• The rate of VAT that applies to what's being sold.
• The total amount payable, excluding VAT.

1. the date of issue of the invoice,
2. a sequential number, based on one or more series, which uniquely identifies the invoice,
3. the full name, address and the registration number of the person who supplied the goods or services to which the invoice relates,
4. the full name and address of the person to whom the goods or services were supplied,
5. in the case of a reverse charge (excluding a supply of construction services subject to Relevant Contracts Tax) supply the Value-Added Tax identification number of the person to whom the supply was made and an indication that a reverse charge applies,
6. in the case of a supply of goods, other than a reverse charge supply, to a person registered for Value-Added Tax in another Member State, the person's Value-Added Tax identification number in that Member State and an indication that the invoice relates to an intra-Community supply of goods,
7. the quantity and nature of the goods supplied or the extent and nature of the services rendered,
8. the date on which the goods or services were supplied or, in the case of early payment prior to the completion of the supply, the date on which the payment on account was made, in so far as that date differs from the date of issue of the invoice,
9. in respect of the goods or services supplied:
   • the unit price exclusive of VAT,
   • any discounts or price reductions not included in the unit price, and
   • the consideration exclusive of VAT.
10. in respect of the goods or services supplied, other than reverse charge supplies:
    • the consideration exclusive of tax for each rate (including zero-rate) of VAT, and
    • the rate of VAT chargeable.
11. the VAT payable in respect of the supply of the goods or services, except in the case of:
    • a reverse charge supply, or
    • goods supplied:
      • under the margin scheme for second-hand goods, or
      • under the special scheme for auctioneers,
      where the invoice should be clearly endorsed ‘Margin Scheme – this invoice does not give the right to an input credit of VAT'.
12. in the case where a tax representative is liable to pay the VAT in another Member State, the full name and address and the Value-Added Tax identification number of that representative.

Note that the "Discount" field used on this template is a custom field, meaning it does not appear in the default template shipped with Invoice Manager for Excel setup program. The discount field is added to the Invoice Header database table.

Unlike the previously released c5005 VAT invoicing sample, InvoicingTemplate.com revised this template and add the default LOGO image back to the invoicing template, at the top center of the spreadsheet. In case you don't need it, you can move it out of the printable area, or delete it completely. To do this, you'll have to first unprotect the spreadsheet, and then switch to design mode.

• Click the Settings button on the Invoice worksheet.
• Go to Database tab.
• Click the Open Database button.
• Browse to the folder where the database file is located and select the database file.
• The Settings window will close if the database is opened without problem.

The form offers an easy way to quickly complete a commercial invoice and print it directly from Microsoft Excel. All the essential information required by a commercial invoice is provided including invoice no, date, shipper/ exporter, consignee, booking #, term of payment, delivery conditions, port of lading, final destination, exporting carrier, currency of sale, total gross weight, cubic meters as well as other costs information such as packing cost, freight cost, insurance cost and duties and taxes.

Before using this Blank Commercial Invoice Template, you should replace the default logo image with your own.

Like they said, a picture is worth a thousand words. This is true even to an invoicing form such as this one designed for painters. The images easily make the form not only professional, but also elegant.

1. Backup your template.
2. Open the template as usual.
3. Switch to design mode by pushing down the "Design Mode" button on the "Invoice" ribbon tab.
4. Click the cell for which you want to modify the formula. The Excel formula bar shows the current formula applied to this cell, like this:

   =oknQuantity_1*oknPrice_1

5. Modify the above formula so that it looks like this:

   =ROUND(oknQuantity_1*oknPrice_1,2)

6. You may need to repeat the above step to modify all formulas of all the line total cells.
7. You may also need to check the formulas of the tax cells, make sure they have only two digits after the decimal point.
8. Once done, exit design mode by clicking the "Design Mode" button again.
9. Save the template.

1. Backup your template (If you have not done so yet).
2. Open the template.
3. Click the Design Mode button on the "Invoice" ribbon tab to push the button down. In design mode, Invoice Manager for Excel will not response to your clicks on buttons. In design mode, it also shows the gridlines and row/column headings of your Excel worksheet.
4. Right-click the row heading of the first tax row on the bottom of the invoicing form. This is sample, it is R35.
5. Choose Insert from the short-cut menu. This inserts a new row above the first tax row.
6. Enter "DISCOUNT (AMOUNT)" underneath the "SUBTOTAL" label, i.e. $J$35.
7. Click to select the cell where the discount amount value should be entered. In this sample, you click $K$35.
8. Enter the cell name "oknDiscountAmount" into the name box on the formula bar. All cells names that work with Invoice Manager for Excel should start with the "okn" prefix, except "Print_Area" and "Print_Titltes".
9. Right-click the cell named "oknDiscountAmount" cell at $K$35, choose Format Cells from the shortcut menu. On the Format Cells dialog box, go to the "Protection" page, clear the "Locked" property. Click "OK" to close the dialog box. By clearing the "Locked" property, the discount amount field will be manually fillable / edition when you are creating an invoice.
10. Click to select the cell next to the label "SUBTOTAL", i.e. the cell named "oknSubtotal" at $K$34. Modify its formula to be "=SUM(oknLineTotal_1:oknLineTotal_12) - oknDiscountAmount".
11. To deduct the discount amount from taxable amount, modify the first tax formula (cell address $K$36 to be "=ROUND(IF(oknTaxType=0,0, oknTax1Rate*(oknLineTotalTaxable - oknDiscountAmount+IF(oknTaxTotalIncludingShippingCost=0,0,oknShippingCost))),2)"; modify the second tax formula (cell address $K$37 to be "=ROUND(IF(oknTaxType<>2,0,oknTax2Rate*(oknLineTotalTaxable - oknDiscountAmount+IF(oknTaxTotalIncludingShippingCost=0,0,oknShippingCost)+IF(oknTax2IsAppliedToTax1=0,0,oknTax1))),2)".
12. Click "Design Mode" button on the "Invoice ribbon tab again to exit design mode.
13. Save the template by clicking the Save command on Excel quick access toolbar.

However if you are not familiar with Photoshop or other image editing applications, you may find it is not easy and time-consuming to create an ideal logo image for use in your commercial invoices. One possible alternative way is to insert some WordArt as your logo image.

This variant format is created based on the Sales Invoice Template with Profit Calculation, by moving the entire shipping address section out of the print area.