BoostExcel main content


invoice price

What is invoice price? According to, "The actual price paid to the manufacturer or distributor by the end-customer retailer, which is known as the invoice price. However, in many industries, the "invoice cost" actually varies from the "net purchase cost," or the actual price of a product. The invoice cost of a product is the price that the merchant pays for the product before marking it up to sell. The invoice cost is sometimes used in industries such as automobile sales to entice customers to buy."

According to, "The invoice price is the initial price that the manufacturer charges the dealer. Due to rebates and incentives from the manufacturer, the price is usually not the dealer's final cost. Freight, also known as the destination charge, is part of the invoice price".

The Cambridge English Dictionary defines invoice price as "the amount of money charged for goods or services on an invoice".

Many templates here on have the "Unit Price" column. If a "Quantity" column does present too, then the "Line total" is calculated from "Unit Price" and "Quantity". The sum of all the line totals, adds up any taxes and shipping cost, subtracted the discount if any, resulting in the "invoice total", which we sometimes refers to as invoice price.

Here are our templates closely related to Invoice Price Definition.

Five Price Levels (Service, Amount)
Five Price Levels (Service, Amount)

This is a variant of 5 Price Levels (Sales, Amount) invoice template. It differs from the original one in that it is service-oriented, i.e. it has no shipping fields.

Five Price Percentage Levels (Sales)
Form with 5 Price Levels

This is a variant of 5 Price Levels (Sales, Amount) invoice template. It differs from the original template in that it uses percentage values in the price fields.

Five Price Levels (Service, Amount, Custom Column)
Five Price Levels (Service, Amount, Custom Column)

This seventh sample in the multiple-price or multiple-discount serial has no shipping fields in the printable section, and the prices are set in amount (instead of percentage).

Five Price Levels (Sales, Amount)
Five Price Levels (Sales, Amount)

With this customization applied, the "invoice form with 5 price levels (sales)" invoice template here on allows you to define 5 prices for each product. When creating an invoice, Invoice Manager for Excel shows both base and discounted price per item on invoice form whenever you choose a product. For each customer, you can assign it a discount level, ranging from 1 to 5. When you pick up a customer, Invoice Manager for Excel will apply the correct price based on the discount level of the customer.

Five Price Percentage Levels (Service, Custom Column)
Five Price Percentage Levels (Service, Custom Column)

Moving the location of a cell or field is easy in Excel. To do this, you first unprotect the sheet (if the sheet is protected), and then select all the cells or fields you want to move, and then drag the border of the selected area to move it to the new location. If you need to move an Active X control, such as the "select a shipping address" icon button, you first need to switch to design mode, and then click and drag the icon button to the new location - in this case, outside the printable area.

Five Price Percentage Levels (Service)
Form with 5 Price Levels

This is a variant of 5 Price Levels (Sales, Amount). It is suitable for service business as it moves out all the shipping-related fields.

Five Price Percentage Levels (Sales, Custom Column)
Five Price Percentage Levels (Sales, Custom Column)

As the name of this invoice template implies, it is a sales invoice template that has shipping information inside the printable range on the invoice form, and the prices or discounts are in percentage.

Basic Service Invoice Template In French
Basic Service Invoice Template In French has categorized this free sample template in the service invoice template category, which is a collection of invoice templates created by for consultants, service providers, and other small businesses, including generic ones where the description and line totals are all manually fillable, and the ones that are specifically for service providers that charge based on hourly rates. If your business sells and ships products, you may be more interested in our sales invoice template. If you are running an consulting business, check out our consultant invoice templates.

Service Proposal and Quote
Proposal and Quote Template provides you this proposal template are free to download and you don't need to pay a single cent. You also don't need to get registered first or signing for a premium membership. All you need is to choose the one you like and click on download button of your favorite free proposal template.

Simple Sample - Discount Amount on Sales Report
Simple Sample - Discount Amount on Sales Report

The default invoice template shipped with Invoice Manager for Excel, as well as all the simple invoice templates created in this serial of tutorials, have the following reports that are based on the "Invoice Header" database table - Sales Report, Customer Report, Sales Rep. Report. All custom fields defined in the "Invoice Header" database table could be added to these reports.

Netherlands Service Invoice Template 2
Netherlands Service Invoice Template 2

Netherland Service Invoice Template 2 is created from c5050 Netherland Sales Billing Form 2. It differs from the original sales invoice template in that it does not include the shipping address section and thus is suitable for those service businesses.

Basic Sales Invoice Template in French
General Sales Invoicing Form in French

This template has two taxes set on the bottom of this invoicing form, " TPS/GST 5.000%" and " TVQ/QST 9.975%", which is suitable for Quebec Canada. If you need to modify this, type in your own tax names and rates in the proper cells. If you use the Invoice Manager for Excel edition of this Basic Sales Invoice Template in French, it offers even more options for you to define your tax system.

Simple Sample - Discount Percentage Field
Simple Invoicing Template - Adding Discount Percentage Field

The implementation of c4051 Simple Invoice Template - Discount Amount Field adds the discount amount field on the bottom of the form at J35 and K35. In this new sample, we'll add percentage fields on the same row but before the discount amount fields, at G35 and H35.

Sample Sales Invoice Template: Using Handwriting Signature
Sales Template with Signature

This sample sales invoice template was original published on, at Invoice Template Sample - Using Handwriting Signature in Your Invoices. We've tested this template here at and released it in two editions - the first template falls into the sales invoice template category that has shipping fields included, and the second template falls into the service invoice template category and has the shipping fields excluded. Each version of the template has two documents offered here - a freeware invoice template that you can use without the installation of Invoice Manager for Excel, and another one that should be used with Invoice Manager for Excel installed. Invoice Manager for Excel is our invoicing software that has the ability to turn a simple Excel invoice template into a complete invoicing program, with the features such as managing customers, products, invoices and payments.

Simple Sample - Changing Print Orientation
Simple Invoicing Format - Changing Print Orientation

As you can see from this tutorial, Microsoft Excel provides complete tool set for customizing invoice form layouts. This, combined the flexibility of Invoice Manager for Excel, make it possible to build an invoicing system that is very specific to your business.

Netherlands Sales Invoice Template 2
Netherlands Sales Billing Form 2

This template adhere to the above requirement statements. In addition to the fields defined in the c6009 Netherland Sales Invoicing Sample, this VAT invoicing Format (Netherland Sales Billing Form 2) also defined a new field VatID in both the Customer and Invoice Header database tables, which is implemented as a custom field.