| Name | Size | Description |
C5-019 |
123 KB |
Invoice template for automotive repair business This invoice template is created for auto repair workshop. It is also released as a free invoice template. Visit Auto repair invoice template for the details. |
C5-018 |
120 KB |
Job Invoice Template 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. |
C5-017 |
119 KB |
Tax By Item Category If you offer both server/labor and general products/items, it is likely that the taxes must be calculated based on different item types. This tutorial implements the customized invoice template by using custom fields. Visit Invoice Template with Support for Product-Type Specific Tax Rates for the detail. |
C5-016 |
123 KB |
Invoice Template with Support for Tax-Exempt, One-Tax and Two-Tax Items 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). |
C5-015 |
121 KB |
Work Order Template The work order template added several new fields to the original invoice template to describe related information about the work or job to be done. |
C5-014 |
136 KB |
Invoice Template for Transportation / Taxi / Limousine Service Company 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". Five columns included in this invoice template are Date, Product code (Product ID in the original invoice template), Passenger, Description, Fare. Since this is a service invoice template, the Quantity column in the original default invoice template is moved out of the Print_Area, with a default value of 1. For information on how to move cells, please see Customizing Invoice Template - Moving Cells/Controls. This invoice template also shows Previous Balance on the invoice form. The implementation details can be found at Forwarding Previous Invoice Balance. |
C5-013 |
132 KB |
Freight Invoice Template You may find this freight invoice template interesting if you are an India-based company. |
C5-012 |
129 KB |
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. |
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 with Support of 5 Levels of Discounts 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 |
Using Product Category on Invoice Form 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 |
Invoice Template with Previous Balance 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 |
Invoice Template with Job Description and Insurance Section 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. |

