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

Commercial Invoice for Export in Excel

c7015
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

c7004
Blank Commercial Invoice Template

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

Commercial Invoice for International Shipping

c7037
Commercial Invoice Template for International Shipping in Excel

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)

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

c7022
Commercial Invoicing Form with Colorful Business Name

Like most other invoicing templates available here on InvoicingTemplate.com, 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

c9005
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

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

c5024
Environmental Consulting Billing Form

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

c4053
Simple Invoicing Format - Changing Print Orientation

Most template available here on InvoicingTemplate.com 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

c4082
Billing Format 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

c4112
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

c4096
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.