free excel invoice templates
 Name Size Description
C5-011 131 KB Applying Discounts to Certain Customers

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.

C5-010 309 KB Invoice Template for Music Company or Store

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.

C5-009 130 KB Invoice Template for Cosmetics Company or Cosmetics Store

This invoice template is designed for cosmetics company or cosmetics store. It supports 5 levels of discount, and for each customer you can specify its discount rate (level) individually.

C5-008 136 KB 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.
C5-007 137 KB

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.

C5-006 97 KB

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.

C5-005 259 KB VAT Invoice Template, VAT taxes

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.

C5-004 97 KB Using Handwriting Signature in Your Invoices

This sample invoice template demonstrates how to add a new image, such as a handwriting signature image, to the invoice form.

C5-003 97 KB Created from C5-002. Invoice summary information is moved to the top of the Invoice worksheet.
C5-002 97 KB Five-column invoice. One tax (configurable). No shipping address. No customer ID.
C5-001 102 KB Shows quantity, description, unit price, taxable status, and amount per line. Sub-total, tax and total amount are computed from the line items.

 

Member Info.
E-mail: 
Password: 
Remember me
    
Home Contact Us Privacy Link to Us
copyright © Office-Kit.com, all rights reserved