Dhl Commercial Invoice 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

Commercial Invoicing Templates is an easy way for an individual or a corporation to create commercial invoices. The free commercial invoice form produces professional invoices as good as expensive accounting systems.

Blank Commercial Invoice Template

Blank Commercial Invoice Template

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 for International Shipping

Commercial Invoice for International Shipping

How to fill out a commercial invoice for international shipping? It is easy with our free editable template in Excel. This commercial invoice for international shipping is a revisited version of c7015, but added a watermark image to express the idea of shipping worldwide.

By installing Uniform Invoice Software, this pure-Excel spreadsheet commercial invoice format could be a complete invoicing tool for customs declaration.

Commercial Invoice - FedEx Style (Landscape)

Commercial Invoice Format - FedEx Style (Landscape)

In order to create this template, we've also moved the address fields on the "Shipper/Exporter", "Recipient" and "Importer (If other than recipient)" sections. The purpose of this movement is to make the sections occupy less lines on the vertical orientation. In the original design, each of the section occupy 8 lines for these fields - Tax ID/VAT No, Contact Name, Company Name, Address, City State/Province, Postal Code, Country/Territory, and Phone. Now each of the section uses only 4 lines. With this commercial invoice format design, the lines for "Federal Express International Air Waybill Number" still uses one whole line; "Date of Export" and "Export References" use another whole line. These fields are put on the top of the form because they are the most important cells, at least in the FedEx design. The PDF version of this blank commercial invoice template for shipping, which was created by using Excel's built in feature, has exactly the same layout.

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

Fourth, create the dropdown list by using Excel data validation. Select the "oknIncoterm" cell. Click Excel command on the ribbon: Data, Data Validation, and then Data Validation again. On the "Data Validation" dialog box, choose "List" from the "Allow" box, and then click the "Source" field, enter the range of the source - in this sample, it is "$W$4:$W$14". There are other options you can set on this dialog box too, for example you can specify the error message to show if a user entered an incorrect value. Once finished, click OK.

Commercial Invoice - FedEx Style

Commercial Invoice Format - FedEx Style

Note that there are two styles on FedEx, FedEx Express and FedEx Ground international shipping. This sample follows the one for FedEx Express. The Commercial invoice serves as an important document international trading, especially for the customs clearance process. Customs officials use commercial invoices to classify your merchandise. This in turn will help them in correctly assessing the applicable duties and taxes. Commercial invoices, like a bill of lading, one of the important documents used in international / foreign trade.

Environmental Consulting Invoice Template

Environmental Consulting Invoice Template

This bill form for environmental consulting companies / firms is a service invoice template. It features an "Attention" section near the "Bill To" section, and also a custom field for showing "Previous Balance" on current invoice.

Simple Sample - Changing Print Orientation

Simple Invoicing Format - Changing Print Orientation

Most template available here on using "Portrait" paper orientation / print orientation. In the real business world, there is no one template fits all. Different businesses have very different requirements regarding their invoicing forms. Some businesses need relatively long content on each field, such as address, description etc., and they need less lines on the invoice detail section. This tutorial, based on the result of c4051 Simple Invoice Template - Discount Amount Field, demonstrates how to change the orientation option of the invoicing form to "Landscape".

Invoice Design for Personal Trainer or Fitness Instructor

Invoice Design for Personal Trainer or Fitness Instructor

Although we titled this template with "personal", it is in fact could be used by other business forms too, for example if you are running your training business as a limited company, you can use this template too.

Japanese Invoice Template

Japanese Invoice Template
  1. Switch the template into design mode.
  2. Drag your mouse to select all the cells that you want to make it show the "Yen" currency symbol.
  3. Right-click one of the selected cells, choose "Format Cells".
  4. On the "Number" tab, set the correctly format.
  5. Exit design mode.
  6. Save the template.

Designer Invoicing Format with Bamboo Chinese Painting

Designer Bill Template with Bamboo Chinese Painting

Whether you are a web designer or graphic designer, you want to make your works attractive. Your invoices and bills could be attractive too. This template based on the c4030 designer (gray theme) added a bamboo Chinese painting created using illustrator and exported as PNG.