Invoice Templates with 5 Columns

Share This Page

Invoice Templates with 5 Columns contains sample invoice templates that have 5 column(s) on the invoice body. Our new web site Free Invoice Templates has the corresponding 5-Column Invoice Templates category which offers an updated list of the invoice templates.

This VAT invoice template supports two vat taxes. Unlike the default invoice template included in the setup program of Excel Invoice Manager, where the two taxes are both applied to each product or item, in this invoice template only one of the two VAT taxes is applied to a product or item, and each product or item in this VAT invoice template has a Tax Type property with which you can specify which VAT tax is suitable for the product item. However if the customer provide its VAT ID then it is Vat free.

If your products have different VAT rates, say some of the products have 6% VAT rate and the others have 19% VAT rate, this template might be suitable for you.

This invoice template does not include the fields for shipping information, but it added several new sections, including: Job section, where you can input job description, VIN#, Ref#, Stock#; Insurance section, where you can enter the name, address, telephone number of the insurance company; Agency section, where you provide the information about the agency, such as name and address.

The invoice template adds/forwards previous balance and shows it on the current invoice form. The amount of "Previous Balance" is retrieved when you pick up a customer by clicking the icon button. The "Total Balance" cell calculates the sum of the current balance and previous balance.

This invoice template demonstrates how to save product category field along with invoice and how to retrieve the product category in the product report so that the report can be organized by the category field.

There are two templates in the downloadable package, one for wholesale customers, and another for retail customers. Both templates are connecting to the same database, sharing the same customer and product list. The main difference is that the wholesale version contains a discount field on the form, with which you can offer a discount to wholesale customers. Music company or store may find the invoice templates interesting.

Some customers are very important so you need to allocate discounts to them whenever you invoice them. This invoice template implements this by adding a custom field, Discount, to both the Customer and InvHdr (Invoice Header) database tables. For each customer, you can set a default discount, either 0 or a non-zero value. Whenever you create invoice for the customer, the discount is applied automatically.

Also in this invoice template the whole PO#, sales rep, ship date and ship via strip, as well as the Shipping and Handling at the bottom, are moved out of the Print_Area (the white area on the center of the form), leaving space for you to type in more information about your company or business.

Same as C4-004, but the Quantity column is moved back into Print_Area. Unlike C4-004, where the Amount column is manually entered, in this invoice template the Amount column is now calculated from Quantity and Price.

A service company provides transportation to various facilities and airports. These trips are billed to many corporate accounts. The invoice format or invoice layout implemented by this template is designed for such companies, and it would also work for any taxi/limousine service.

As a service template, it does not require the fields/cells related to shipping. The oknSalesRepName cell in the original default invoice template now has a new label, "Account Executive Name".

The default invoice template does allow you to choose tax-type with 3 options: no-tax, one tax and two taxes, but this option is applied to all the items on the invoice form. This slightly-customized invoice template differs from the default invoice template in that it allows you, on the single invoice form, to have some products with no tax, some products with one tax (such as GST) and some products with two (such as GST and PST).

With this job invoice template you can enter both materials and labor costs. Compared to the default invoice template shipped with Excel Invoice Manager, this job invoice template does not include the "Ship To" section, but added several new fields to let you enter job-related information, including "Start Date", "Finish Date", "Job Address", "Client Name". Download this invoice template by visiting Job Invoice Template.