The sample invoice template implemented here is based on C6-001 for clothing / wear company, who needs the "Size" column on invoice body. The invoice template is in Dutch, and "City, State and ZIP" is shown in Holland format too. Click Invoice Template for Holland Clothing (Wear) Company or Shop to download it.

Download this VAT invoice template by clicking VAT Invoice Template.

Download this VAT invoice template by clicking VAT Invoice Template.

If you have many customers it is likely you need to offer different prices to different types of customers, such as distributor, wholesale, retail, individual, or even special pricing. This invoice template provides a sample on how to implement customer-type based price levels.

By utilizing custom fields, the default invoice template shipped with Excel Invoice Manager setup program was modified / customized to implement the following.

• For each customer, you can set its price type to one of the following: distributor, wholesale, retail, individual, or special.
• For each product, you can set 4 prices, distributor, wholesale, retail and individual.
• When creating an invoice, the price type is loaded / displayed on the invoice form when you select a customer. It is allowed to modify the price type of this customer for this invoice. This information is not included in the printed invoices.
• When selecting a product / service item, by using Excel formulas one of the 4 prices of the current product / service item is chosen according to the customer's price type.
• If the price level is Special, the invoice template allows you to manually enter a price for the current product or service item. This is necessary if the customer is very special, say an employee of your company.

This invoice template might be ideal for UK (United Kingdom) based stores or companies. The template shows postcode on a separate line, and an extra column was added for discounting. In certain trade (UK Construction, for example) it is customary for a list price to be given (on some, but not all products) and then a percentage discount to be applied. I.e. Quantity 1, List price of £81.57, discount of 65%, giving a line total of £28.55.

The Taxable checkboxes were removed completely, assuming all the products are taxable, no matter whether the Taxable option is checked or not for each product. This avoids an occasionally happened mistake when a taxable product or item must be manually entered on the invoice body, as the Taxable checkbox is not checked by default. The template implements this feature by deleting all the Taxable checkboxes and assigning a value of 1 (TRUE) to all the oknTaxable_? cells located in the hidden column C.

The invoice template is designed for golden pearl jeweler shop. It assigns the same Customer ID "A" to all the customers entered and thus in fact it does not maintain customer account information. The invoice template contains 6 columns on the body, including Product ID, Description, Quantity, Weight, Unit Price and Amount. A Discount can be entered on the bottom of the invoice, which is deducted from the total of all the items.

This VAT invoice template is a variant of (C5-005) VAT Invoice Template. It differs from the original VAT invoice template in that the TAX Rate and Tax columns are moved into the Print_Area. This makes the Tax Rate and Tax columns visible on printed invoices.

In Excel Invoice Manager, all cells are movable. Please see the Customizing Invoice Template section in the help document for more information on moving cells/controls.

See also: UK VAT Service Invoice Template

This VAT invoice template is a variant of (C5-005) VAT Invoice Template. It differs from the original VAT invoice template in that the Tax Rate column is moved into the Print_Area. This makes the Tax Rate column visible on printed invoices.

In Excel Invoice Manager, all cells are movable. Please see the Customizing Invoice Template section in the help document for more information on moving cells/controls.

See also: UK VAT Service Invoice Template

The template adds a custom field "Size" to both the Product and Invoice Body (InvBdy) database tables. For example, if you have a clothing retail shop, it is necessary to stock sizes like 2xl 3xl 4xl 5xl 6xl - each product will have these sizes and the size information should be added to invoices too.