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

Summary

commercial

How to prepare a commercial invoice in an easy and quick way? Download our editable commercial invoice templates in Excel spreadsheet format to easily create commercial invoices by simply filling the blank forms. With Invoice Manager for Excel (namely Uniform Invoice Software)(UIS), it also creates commercial invoices in PDF formats based on the Excel templates.

Commercial invoices are usually required when shipping internationally to allow your shipment to pass through customs. It is used as a customs declaration provided by the person or corporation that is exporting an item across international borders. (Wikipedia.org)

Compared to general invoices, it usually contains more fields that you should fill in to clearly describe the seller, buyer, goods and services. On this aspect, it is closely related to pro forma invoice templates.

There are different styles of commercial invoice formats that you could find online for Mac / Windows. Note that some samples you could find online, like this one, are not the commercial invoices for cross-board trading. Our staffs at InvoicingTemplate.com did the research and present you with the downloadable Excel spreadsheet template, in either ".xls" or ".xlsx" format.

Feel free to try Invoice Manager for Excel (namely Uniform Invoice Software) (UIS) along with the free commercial invoice forms. UIS is able to provide additional features that couldn't be archived with pure-Excel templates, such as automatic numbering of invoice, easily retrieve data / information about customers and goods, sales and payment reports, etc.

Here are our templates closely related to Commercial Invoice Templates - 20 Results Found.

Commercial Invoice for Export in Excel

c7015
Commercial Invoice for Export in Excel

Whether you are an individual or a corporation, the commercial invoicing template helps you create professional and beautiful invoices with quick and easy. However if you are a corporation we highly recommend the Invoice Manager for Excel (namely Uniform Invoice Software) version. With Invoice Manager for Excel (namely Uniform Invoice Software) installed, the commercial invoicing form becomes a powerful invoicing system, with the ability to manager customers, products, invoices and payments.

Blank Commercial Invoice Template

c7004
Blank Commercial Invoice Template

This simple yet elegant template should be used as a final bill after good have shipped. "Blank Commercial Invoice Template" has detailed buyer, seller, and order information as well as a section to specify agreement terms. This free commercial invoice template is in Microsoft Excel spreadsheet format. The template offers an intuitive blank commercial invoice form that is printable and highly customizable. You can download a high quality blank commercial invoice form to create your own professional commercial invoice for your business.

This Blank Commercial Invoice Template formats prices with US dollars currency symbols.

Commercial Invoice Template with Colorful Business Name

c7022
Commercial Invoice Template with Colorful Business Name

Commercial Invoicing Form with Colorful Business Name is a customized invoicing template based on Commercial Invoicing Template. It has the same number of fields as the original template, but looks professional and beautiful with the additional colorful text boxes.

Commercial Invoice for Shipping

c6036
Commercial Invoice for shipment

This commercial invoice for shipping added a number of custom fields to meet the requirements of international shipment.

On the top-right section we usually put the "Invoice#" and "Invoice Date" cells. This template also has the section redesigned. Now it includes fields like PO Number, Terms (Incoterm), Proforma Invoice Number, Ultimate Consignee Phone, Exporting Carrier, Loading Pier/Terminal, Origination State, Country of Destination, Exporter Contact Name and Exporter Contact Phone.

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.

Commercial Invoicing Template (UPS Style)

c7025
Commercial Invoicing Sample (UPS Format)

This template adheres to the requirements detailed on UPS web site. It includes all the fields found in the UPS pdf sample, and it also provides a similar layout. Unlike the UPS sample, this template created by InvoicingTemplate.com is in Microsoft Excel spreadsheet format, and as always, this template works well with Invoice Manager for Excel (namely Uniform Invoice Software) (UIS).

Commercial Invoice - FedEx Style

c9002
Commercial Invoice - FedEx Style

A pro forma invoice only needs to include sufficient information to allow for a determination of duties and examination. Since there is no required format for either type of invoice, a commercial invoice and a pro forma invoice may appear virtually identical or they may appear radically different. You can find several samples on pro forma invoice templates too here on InvoicingTemplate.com, for example Proforma Invoicing Sample, Simple Proforma Invoice Template, Proforma Invoice Template (4th Sample, Landscape Page Orientation), etc. For a full list of the commercial and proforma invoice template available here, visit the category page at commercial and proforma invoice template.

Commercial Invoice - FedEx Style (Landscape)

c9003
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 Template Sample - Using Payment Method Checkboxes

c9004
Commercial Template Format - Using Payment Method Checkboxes

In Microsoft Excel, there are in fact two ways to add checkbox to a spreadsheet - by using a form control, or by using an ActiveX control. Both options are located on Excel's "Developer" ribbon tab. This tab is not shown by default in Microsoft Excel. To make it visible, firstly you right-click an empty area on the ribbon and then choose "Customize the Ribbon" command from the shortcut menu. On the "Customize the Ribbon" section of the Excel Options dialog box, check the "Developer" option and click OK.

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 Template Sample - Adding Insurance Cost Field

c9006
Commercial Template Format - Adding Insurance Cost Field

With the previous FedEx style commercial invoice samples the insurance cost and currency symbol fields were missed. This template shows how to add it onto the printable commercial form.

Shipping Invoice Template (1)

c5013
Freight Invoice Format (1)

To implement the sample shipping invoice template, Invoicing Templates added a number of custom fields to the default sales invoice template that comes with the setup program of Invoice Manager for Excel (namely Uniform Invoice Software), including: Bill of Loading No, Destination, Cont. Type, Vessel/ Vyoage, Port of Loading, No. Of Pkgs., Gross/Net weight, Ex. Rate.

Shipping Invoice Template (2)

c5048
Shipping Invoice Template (2)

If you are interesting in how we created this customized shipping invoice format from the original shipping invoicing sample, here are the steps: unprotect the Invoice worksheet, switch to design mode, display row headings and gridlines of the Excel spreadsheet, resize columns to make it printable on A4 paper in Landscape orientation.

Excel Shipping Invoice with Printable Truck Background Image

c5087
Shipping Invoice with Printable Truck Background

First, if a cell has a background set, the cell background covers the truck background image. Our original shipping invoice template has background set for a number of cells, like the column heading cells "#", "Description", "Quantity", "Unit Price" and "Line Total". The rows in the invoice detail section are set with striped gray background. To clear all the background settings for all the cells in the Print_Area range, follow the steps below (However, make a backup copy of your current template before modifying it).

Advanced Sample - Macro-Enabled Invoicing Template

c5101
Advanced Bill Sample - Macro-Enabled Billing Template

One of the major concerns about using macro-enabled templates is that security settings of Microsoft Excel. If the macro you create does not have a digital signature, with the default security settings Excel disables it with a warning message shown.

Recruitment Agency Invoice Template

c3011
Recruitment Firm Billing Sample

The invoice body section features 3 columns - "#", "Description" and "Amount". The "#" column is a simple line# column which is assigned automatically using Excel formulas when you fill in the "Description" column, so this column is not manually fillable when you create an invoice. The other two columns, "Description" and "Amount", are all manually fillable.

Five Price Percentage Levels (Service, Custom Column)

c5030
Form with 5 Price Levels

This is the eighth sample of the multiple-price serial invoice templates. The template uses percentage discounts, and has no shipping fields.

Drywall Invoice Example

c3024
Dryall Billing Program

This drywall invoice example is a slightly modified version of c3009 Contractor Billing Format, and a sample in our contractor invoice templates.

Five Price Levels (Sales, Amount, Custom Column)

c5009
Form with 5 Price Levels

This sample of customizing invoice templates is named with the keyword "cosmetic". A new column "Color" was added to meet the requirements of the cosmetic business.