Skip to main content main content
sharing is caring! we do appreciate your time to let others know us!

Commercial Invoice for Export in Excel

Commercial Invoice in Excel offers this free commercial invoice template in Excel format. The template offers blank invoice forms that are highly customizable and printable. With its intuitive interface, you can fill in it just like filling a paper form with a paper. The commercial invoice is required to be furbished as a customs declaration form when exporting goods across international borders. A commercial invoice form includes necessary fields to help the importer present a detailed invoice to the custom authorities. It is presented while clearing the goods. It also includes the terms of Sale, a harmonized code for every item and tax identification of the seller as well as the buyer. The commercial invoice template helps you draft invoices with easy and quick. While there are commercial invoice templates or examples online in other formats, such as Microsoft Word or PDF, the Excel-format commercial invoice template has some interesting features, for example, the use of formulas. If you use the Invoice Manager for Excel (namely Uniform Invoice Software) edition, the definition of custom fields is another powerful feature that shouldn't ignore. If you are looking for a guide on how to create a commercial invoice, or what is a commercial invoice, or commercial invoice examples, this free commercial invoice form, like the other samples available here on, answered the question in an intuitive way.

Blank Commercial Invoice Template

Blank Commercial Billing Form

This Blank Commercial Invoice Template was originally published on as c7004 and is now revised and published here on It differs from the original in that this version includes a logo image on the top of the form.

Commercial Invoice - FedEx Style (Landscape)

Commercial Invoice - FedEx Style (Landscape)

As detailed on the FedEx web site, all shipments / freight must be accompanied by a FedEx International Air Waybill & two duplicate copies of commercial invoices. With Invoice Manager for Excel (namely Uniform Invoice Software) installed, printing of two copies of your commercial invoices could be done with a single click of mouse. Go to the Print tab on the Settings window to find all the printing options. All forms available here on are printable and fillable. You can adjust the printing and paper options by using Excel's own features too - for example, by choosing the options on Excel's Page Layout tab.

Commercial Invoice Template with Colorful Business Name

Commercial Invoicing Form with Colorful Business Name

Like most other invoicing templates available here on, with the original Commercial Invoicing Template the company/business headings and the big "INVOICE" label are all general Excel cells. They differs from the other text labels on the spreadsheet with only font size and colors. With this customized design - Commercial Invoice Template with Colorful Business Name, they are replaced with text box and a litter bit of word art is also added. Suddenly, the original general commercial invoicing form looks bright and shines.

Commercial Template Sample - Complete Incoterms Option

Commercial Template Format - Complete Incoterms Option

This sample of blank commercial invoice template demonstrates how to add a complete Incoterms option, in the format of the dropdown list, to replace the existing checkbox-based freight rules.

Commercial Invoice - FedEx Style

Commercial Invoice Format - FedEx Style

There are already sample forms on FedEx, such as How to Complete a Commercial Invoice. The templates on FedEx is in either Adobe PDF or HTML format. Here at we provide you with another alternative in Microsoft Excel spreadsheet format (and also a PDF version generated with Excel itself).

Commercial Template Sample - Using Payment Method Checkboxes

Commercial Template Format - Using Payment Method Checkboxes

First, 3 custom fields will be created to store the value of the checkboxes. To do this, click the Invoices button on the "Invoice" ribbon tab. Click Custom Fields, and then Add Field. Enter "PaymentMethodTT" in the "Name" box, and then choose "Integer" from the "Type" list, click OK. Click "Add Field" again, Enter "PaymentMethodLC" in the "Name" box, and then choose "Integer" from the "Type" list, click OK. Click "Add Field" again, Enter "PaymentMethodOther" in the "Name" box, and then choose "Integer" from the "Type" list, click OK.

Child Care Billing Template

Child Care Invoicing Form

This invoice template is for the companies or organizations who offer parenting services. As compared to the default/standard invoice template, the "Ship To" section is removed, and a new field, Date Of Birth, is added to the Bill To section, with witch you can record the birth date of a child. There are also a number of custom fields for the other customer-related information, such as Mother's Name, Mother's Profession, Mother's Mobile, etc., are added outside the Print_Area. On the invoice body section, Quantity and Price are moved out of the Print_Area, and two new columns, date and Fee, are added.

Musician Invoice Template

Musician Billing Format

The "Advertisement" section is an auxiliary section, which is not directly related to your bills or invoices, but allows you to put a brief description about your business and service, or you can also put your payment term, service term here. Note that this is a static text section - you can modify it once the template is switched to design mode, but when you are creating invoices, this section is protected and thus couldn't be modified. This also means that the section is not defined as a field in the database, and thus cannot be changed from invoice to invoice.

Transportation Invoice

Transportation Invoice

This template was originally published on as C5-014. The following description of the template comes from

To make the default invoice template suitable for use by transportation / taxi / limousine service company, this customized service invoice template uses several custom fields, as detailed in the following table.

Bill Format for Lamp / Lighting Business

Invoicing Template for Lamp / Lighting Business

This formula means that if "oknPaymentTerm" equals to "Net 30", the "Due Date" will be the end date of the next month to the invoice date; giving any other values to "oknPaymentTerm" causes the "Due Date" to be the invoice date. The "oknPaymentTerm" cell referenced in the above formula is placed outside the printable invoicing form.

Netherland Sales Invoice Template 2

Netherland Sales Invoice Template 2

By moving out the "Maat" column, this template is now more generic and thus suitable for more sales companies that need the shipping section on their invoicing form. If you are offering services and don't need the shipping address fields, refer to c5051 Netherland Service Invoicing Format 2. If you would like to see a service bill example where the "Size" column has its title changed to "Hours", see Netherland Service Bill Design.

Packing List Template

Packing Slip Form

The template has a default Logo image on the top-left corner. This is a placeholder for your own logo image. To replace it with your own logo, first switch to design mode and then right-click the default image and choose Properties. Click the button on the "Picture" line, choose the image want to use on this Packing List Template.

Bill Format for Quilting Service

Invoicing Sample for Quilting Service

Although this invoicing template is categorized as a service invoice template, we keep the shipping address inside the printable form. In case you don't need it, simply move the section out of the printable area in design mode. To replace the default logo image, simply click the "Replace Logo Image" button on the "Invoice" ribbon tab, which is available only when Invoice Manager for Excel (namely Uniform Invoice Software) is installed.

Simple Sample - Total Quantity on Sales Report

Simple Format - Total Quantity on Sales Report

In this sample template, we take c4062 Simple Tax Invoice Sample with Tax Rate List as the base template (i.e. the starting point of our customization). See how to create your invoice template for more information on the general rules to adhere and the basic technique details.