Skip to main content
InvoicingTemplate.com main content

Summary

Download our editable commercial invoice templates in Excel spreadsheet format to easily create commercial invoices by simply filling the blank forms. With 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. 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. 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 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.

Commercial Invoicing Templatec7015

Commercial Invoicing Template

"Commercial Billing Form" was found to be relative to Commercial Invoice Templates with the score grade of 97.

... InvoicingTemplate.com 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 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 InvoicingTemplate.com, answered the question in an intuitive way.

... However before using the commercial invoice template to create your first commercial invoice, there are some one-time job you should do, that is to enter your own company information and replace the default logo image. Before you can do this type of customization, you have to firstly unprotect the invoice form, and then switch to design mode.

Blank Commercial Invoice Templatec7004

Blank Commercial Billing Form

"Blank Commercial Invoice Template" was found to be relative to Commercial Invoice Templates with the score grade of 97.

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

... If you don't need the LOGO image and want to delete it, simply hit the DEL key on your keyboard after you selected it with your mouse key. Deleting the LOGO image leaves an empty area to the left of the Company Information section. You may like to move the entire Company Information section to fill in the empty area. To do this: Drag your mouse to select the entire Company Information area, including Company Name, Street Address, City, ST Zip Code, etc.; Push your mouse key on the border of the selected area; drag it to the new location.

Commercial Invoice Template with Colorful Business Namec7022

Commercial Invoicing Form with Colorful Business Name

"Commercial Invoice Template with Colorful Business Name" was found to be relative to Commercial Invoice Templates with the score grade of 87.

... Like the original commercial invoicing form, this commercial invoicing template dressed with Excel text boxes and word arts is also offering all the required fields for a commercial invoice, including: Complete name and address information for both shipper and consignee, phone numbers for both shipper and consignee, Terms of Sale (Incoterm), Reason for export, a complete description of the item, what is the item? what is the item used for? Harmonized Tariff Codes, if known, Country of origin (where manufactured) for each commodity, Number of units, unit value, and total value (purchase price) of each item, number of packages and total weight, shipper's signature and date.

Commercial Invoicing Template (UPS Style)c7025

Commercial Invoicing Template (UPS Style)

"Commercial Invoicing Template (UPS Style)" was found to be relative to Commercial Invoice Templates with the score grade of 82.

... While there is no standard format for a commercial invoice, customs agencies typically require that certain information be presented in clear and easily legible way. We've already provided some samples here on InvoicingTemplate.com, like Free Commercial Invoicing Template, Free Blank Commercial Invoicing Template, and Commercial Invoicing Sample with Colorful Business Name. There are also other pre-made commercial invoice. Numerous websites offer free, pre-made commercial invoice forms that can be printed and filled out manually. Some good examples include the aligned invoice by the United Nations Economic Commission for Europe, and examples by international shipping companies like FedEx and UPS.

... If you are in the business of import and export, you need to understand the difference between pro forma and commercial. These are both key documents while dealing with customers. Goods, merchandise and documents that are imported or exported between countries must typically include appropriate documentation, which may include either a commercial invoice or a pro forma invoice. While both types of documents share a number of features, they have significant differences. Once after agreeing the terms of contract of sale, the buyer has to issue a purchase order or Letter of Credit. Just before this process, the seller has to send a "pro-forma invoice" to buyer, mentioning complete details of agreement of sale. Normally, purchase order or Letter of credit is opened on the basis of this pro-forma invoice sent by the seller. Once the seller receives the purchase order, he gets a confirmation to send the goods. He now ships the goods to the buyer along with a commercial invoice. The commercial invoice is more like an invoice and the legal document of the actual sale. This document is used to record the AR for the seller and AP for the buyer.

Commercial Invoice - FedEx Stylec9002

Commercial Invoice - FedEx Style

"Commercial Invoice - FedEx Style" was found to be relative to Commercial Invoice Templates with the score grade of 79.

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

... 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 InvoicingTemplate.com we provide you with another alternative in Microsoft Excel spreadsheet format (and also a PDF version generated with Excel itself).

Commercial Invoice - FedEx Style (Landscape)c9003

Commercial Invoice Format - FedEx Style (Landscape)

"Commercial Invoice - FedEx Style (Landscape)" was found to be relative to Commercial Invoice Templates with the score grade of 79.

This commercial invoicing sample was a customized version of "c9002 Commercial Invoice - FedEx Style". This form is still be printable on standard A4 paper, but the paper orientation is changed to landscape.

... While the template at c9002 Commercial Invoice - FedEx Style implemented the layout and fields as the FedEx sample, many of you may find that the space left for the product description field is too small to fill your description text. To deal with this issues, we change the paper orientation from "Portrait" to "Landscape". This design allows you to enter longer description text. However the form has only 7 lines on the detail section now.

Commercial Template Sample - Using Payment Method Checkboxesc9004

Commercial Template Format - Using Payment Method Checkboxes

"Commercial Template Sample - Using Payment Method Checkboxes" was found to be relative to Commercial Invoice Templates with the score grade of 67.

... With the sample, a payment method option is added, which comprises 3 checkbox - "L/C", "T/T" and "Other" - where T/T means telegraphic transfer, or simply wire transfer; and L/C Letter of credit (See the screenshot). For international trade, this payment detail should be useful when it appear on the commercial invoices. Generally, every dutiable shipment sent through FedEx, DHL or UPS must be accompanied with an invoice. The invoice must identify the seller and buyer. It must also clearly indicate the terms and date of sale, quantity, weight and volume of the shipment. It must also indicate a complete description of the shipped goods, shipping, insurance and other charges, unit value and total value as applicable.

Commercial Template Sample - Complete Incoterms Optionc9005

Commercial Template Format - Complete Incoterms Option

"Commercial Template Sample - Complete Incoterms Option" was found to be relative to Commercial Invoice Templates with the score grade of 63.

... As detailed on export.gov, "The term, Incoterms®, is an abbreviation for International Commercial Terms. They are a set of rules which define the responsibilities of sellers and buyers for the delivery of goods under sales contracts for domestic and international trade." With the previous implementations of blank commercial invoice templates (FedEx style), terms of Sale (Incoterms) was limited to 3 options on the printable form - FOB (Free On Board - risk pass to buyer including payment of all transportation and insurance cost once delivered on board the ship by the seller. Used for sea or inland waterway transportation), C&F (Cost and Freight - CFR, Title, risk and insurance cost pass to buyer when delivered on board the ship by seller who pays the transportation cost to the destination port. Used for sea or inland waterway transportation) and CIF (Cost Insurance and Freight - Title and risk pass to buyer when delivered on board the ship by seller who pays transportation and insurance cost to destination port. Used for sea or inland waterway transportation). These options are implemented as checkbox on the bottom of the form. All the 3 options are rules for sea and inland waterway transport. Effective January 2010, the ICC once again updated Incoterms (see Incoterms 2010) to follow the modern trends in international trade. The number of Incoterms® rules has been reduced from 13 to 11.

Commercial Template Sample - Adding Insurance Cost Fieldc9006

Commercial Template Sample - Adding Insurance Cost Field

"Commercial Template Format - Adding Insurance Cost Field" was found to be relative to Commercial Invoice Templates with the score grade of 49.

... Some of the commercial and proforma invoice templates here on InvoicingTemplate.com already contain the insurance cost field, for example in Commercial Invoice Template (UPS Style) the insurance cost field was located near the bottom of the form, above the "Other" field; Simple Proforma Invoice Template has this field too. For the list of all the commercial and proforma templates here on InvoicingTemplate.com, visit Pro forma and Commercial Invoice Template. On the DHL style template, you'll find these fields too.

... These fields - insurance and currency code, provides important information regarding the international shipping / freight and international trading. If you have looked at Commercial Template Sample - Complete Incoterms Rules, you may notice that many Incoterms rules specify how the insurance cost will be handled.

Shipping Invoice Template (1)c5013

Freight Invoice Format (1)

"Freight Invoice Format (1)" was found to be relative to Commercial Invoice Templates with the score grade of 42.

... Unlike the packing slip template, Shipping Invoice Template includes the "Unit Price" and the "Line Total" columns on the invoice body, whereas a packing list usually does not include this type of information.

... The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Shipping Invoice Template (1) without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

Shipping Invoice Template (2)c5048

Freight Invoice Format (2)

"Shipping Invoice Template (2)" was found to be relative to Commercial Invoice Templates with the score grade of 39.

... The protection of the "Invoice" worksheet in Shipping Invoice Template (2) prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in Shipping Invoice Template (2).

... In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Shipping Invoice Template (2). Note that if you have our invoicing program installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products, bills and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.

... To show gridlines and row/column headers in Excel 2000 - 2003:

... The gridlines and row/column headings could help a lot when design the layout of the form.

Excel Shipping Invoice with Printable Truck Background Imagec5087

Excel Shipping Invoice with Printable Truck Background Image

"Excel Shipping Invoice with Printable Truck Background Image" was found to be relative to Commercial Invoice Templates with the score grade of 39.

... On the other hand, to some people it may be not intuitionistic enough when they want to make their invoices stand out from competition by using a background image. Although Microsoft Excel does provided a "Background" command on the "Page Layout" ribbon tab, the background image or picture set in this way is removed (not included) in the printed result.

... In this sample invoice template, we use c5013 Shipping Invoice Template (1) as the basic invoice template, add a truck background image to its print result (as well as the PDF shipping invoice), and discuss the key points involved in the customization process. PDF is an idea format for sending out your electronic shipping invoice. Here on InvoicingTemplate.com we also have a list of PDF invoice templates for you to choose from.

Advanced Invoicing Sample - Macro-Enabled Invoicing Templatec5101

Advanced Invoicing Sample - Macro-Enabled Invoicing Template

"Advanced Bill Sample - Macro-Enabled Billing Template" was found to be relative to Commercial Invoice Templates with the score grade of 34.

... With the Simple Invoice Templates series we demonstrate how to do basic customizations on create and customizing your own bill format for your business, such as how to change fonts, move cells to create a new layout, change formulas to create a new business logic, etc. See this document to find out more information on the rules and guidelines on creating your own invoice template.

... If you are an expert in Microsoft Excel if may want to do more with your invoice template. One of the advanced way is to use Excel macros.

... The sample invoice template used here is c5099 Standard Business Invoicing Template. See our business invoice templates for more samples that are most closely related to "BUSINESS".

Recruitment Agency Invoice Templatec3011

Recruitment Agency Invoice Template

"Recruitment Firm Billing Sample" was found to be relative to Commercial Invoice Templates with the score grade of 31.

... On the top of the form, which we usually refer to as invoice heading, this recruitment firm billing sample provides spaces for your business logo image, your business information, invoice date and invoice# fields. The logo image is a place holder for your own image. To replace this image, click the "Replace Logo Image" command on the "Invoice" ribbon tab (Uniform Invoice Software must be installed in order to show this ribbon tab).

... Underneath the recruitment agency business name, you can enter the address, city state and zip, phone, email and website address. If you have registered for VAT, or operate the business as a licensed company, it is a good idea to detail these facts on the invoice heading too.

Five Price Percentage Levels (Service, Custom Column)c5030

Five Price Percentage Levels (Service, Custom Column)

"Five Price Percentage Levels (Service, Custom Column)" was found to be relative to Commercial Invoice Templates with the score grade of 30.

... Just like the other service invoice templates available here on InvoicingTemplate.com, this invoice form with 5 price percentage levels (service, cosmetic) was created from the sales invoice template by moving all the shipping fields out of the printable area. The printable area is the white area on the center of the "Invoice" worksheet, which is section that is printed when you execute the "Print" command in Excel. It is also the section that is extracted when you execute the "Extract" command in Uniform Invoice Software.

... After moving out the "Shipping Date" field, you may like to expand the size of the neighboring fields to make the layout organized. This is done by expanding the Terms label and field. Expanding the "Terms" label is done by first selecting the original terms cell and the empty cells left by moving out the "Shipping Date" field, and then execute the "Merge and Center" command on Excel ribbon tab. To do this for the Terms field, you first need to move the original Terms cell to the first (left-most) cell of the empty space, and then select all the cells you want to merge, and then execute the "Merge" command.

Five Price Levels (Sales, Amount, Custom Column)c5009

Five Price Levels (Sales, Amount, Custom Column)

"Five Price Levels (Sales, Amount, Custom Column)" was found to be relative to Commercial Invoice Templates with the score grade of 25.

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.

... The color column is a custom field defined both in the Product and Invoice Body database tables, which is the most noticeable difference between this customized invoice template and the original 5 Price Levels (Sales, Amount) invoice template. This means that for each product, you can set its color property, and the color values are filled automatically when you choose products from the database. Like all the other invoice templates in this serials available here on InvoicingTemplate.com, the full power of the invoice template comes only with the installation of Uniform Invoice Software, although the free version of this "Form with 5 Price Levels (Sales, Amount, Custom Column)" invoice template can also help you create professional and beautiful invoices.

Consulting Invoice Template (3rd Sample - One Tax)c4018

Consulting (3rd Sample - One Tax)

"Consulting (3rd Sample - One Tax)" was found to be relative to Commercial Invoice Templates with the score grade of 25.

... If you use the Uniform Invoice Software version of Consulting Invoice Template (3rd Sample - One Tax), there are additional taxing options on the Taxes tab of the Settings window. The first is the option for choosing the number of tax items; you have 3 choices - no tax, one tax and two taxes. Secondly, you can set the names and rates in percentage for each tax, such as VAT, GST or PST, or simply Sales Tax. Thirdly, there are a group of checkbox options on the dialog box, including: "Tax invoice total including shipping cost", which adds the shipping cost to the taxable amount when checked; "Tax 2 is applied to tax 1", which adds the amount of "tax 1" to the taxable amount if checked; and "tax rate can be zero", which allows you to set any of the tax rates to be the value of zero. If you modify the options on this dialog box, the spreadsheet will be changed accordingly if needed.

... If you are familiar with Microsoft Excel, you probably already know how to do this.

... To show/hide gridlines and row/column headers in Excel 2007, Excel 2010 and Excel 2013:

Proforma (2nd Sample of Customization)c7012

Proforma Invoicing Form

"Proforma Invoicing Form" was found to be relative to Commercial Invoice Templates with the score grade of 25.

... With the first sample on how to customize the proforma invoice template, we learnt how to unprotect the Invoice worksheet and how to modify Excel color palette to change the color theme of an existing template. This second sample of customizing the pro forma invoicing template will be focused on how to enter your company information and replace the default "InvoicingTemplates" logo image.

... Most of the templates available here on InvoicingTemplate.com have the Invoice worksheet protected to avoid accidental modifications on form layout and formula. This is useful and necessary since once the design of the form is finished, you'll not change the design for a long time. However before using the invoice template, you at least need to do two things that are to enter your company information, and to replace the default logo image. Before you do, you first need to unprotect the Invoice worksheet, as detailed in the previous sample.

Simple Template - Moving Shipping Addressc5077

Simple Template - moving-shipping-address

"Simple Template - moving-shipping-address" was found to be relative to Commercial Invoice Templates with the score grade of 7.

... Sometimes it is useful on a service invoice template to have a "Service Sumarry" field. We'll add this as a custom field.

  1. As always, back up the template and database file. As stated before, in this sample, we'll use the simple invoicing format built in c5076 Simple Invoice Template - Moving Taxable Controls.
  2. Open the template.
  3. Click the "Design Mode" button on the "Invoice" worksheet.
  4. Modify the text label "Ship To" (cell location $I$8) to "Service Summary".
  5. Drag your mouse to select all the fields (including labels) on the shipping address section, ranging from I9 to K14.
  6. Push your mouse key on the border of the selected area, move it to a new location outside the print area. In this sample, it is moved to T9:V14.

    Excel spreadsheets support a special name "Print_Area". If a worksheet has a name defined for a range, then when you issue the print command, only the range defined by this name will be printed. All templates available here on InvoicingTemplate.com have this name defined. If a cell / field is moved out of this area, then it will not be included on printing - we say it is not printable.

  7. Drag your mouse to select all the cells that belongs to the original shipping address fields, i.e. I9:K16.
  8. Click the "Merge and Center" command in the "Alignment" group on Excel "Home" ribbon tab. Push down "Top Align", "Align Left" and "Wrap Text" buttons.
  9. To make this section differs from other fields, you can assign it a border. In this sample, we used dashed borders.
  10. Assign this section a name, "oknSummary". To do this, enter the name "oknSummary" into the name box on the left-end of the formula bar.
  11. Unlock the "oknSummary" field. To do this, right-click the "oknSummary" range, choose Format Cells. On the Protection tab, clear the "Locked" property and then click OK. This is necessary in order to have the field manually editable / fillable when creating invoices.
  12. To create a data validation for this field, go to Excel "Data" ribbon tab. From the "Data Tools" group choose "Data Validation" and then "Data Validation" again. Choose "Text length" from the "Allow" list, enter 1 and 255 into the "Minimum" and "Maximum" field respectively. Click OK. If is an optional step - if you don't create this data validation, Uniform Invoice Software will do this type of checks automatically on saving invoices.
  13. Exit design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab again.
  14. Click the "Invoices" button on the "Invoice" ribbon tab.
  15. Click "Custom Fields" to open the Custom Field Manager.
  16. Click "Add Field" to open the "Add New Custom Field" dialog box.
  17. Fill in the field name "Summary", and fill in size "255" (This is the max field size allowed in an Access database field).
  18. Click OK to close the dialog box.
  19. If you would like to have this field visible as a column on the "Invoices" data list window, click the "Columns" button on the "Invoices" data list window, and then check the "Summary" option.
  20. Save the customized simple invoice format by clicking the "Save" button on Excel quick access toolbar.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c7015
Commercial Invoicing Template
Wednesday, December 11, 2013,
16
7
A4
Portrait
Pro-forma
c7004
Blank Commercial Invoice Template
Wednesday, May 21, 2014,
12
7
Letter (8-1/2 in. x 11 in.)
Landscape
Pro-forma
c9007
Commercial Invoice Format with Editable Word Art Logo
Wednesday, July 13, 2016,
9
9
A4
Landscape
Pro-forma
c7022
Commercial Invoice Template with Colorful Business Name
Saturday, October 4, 2014,
12
7
A4
Portrait
Sales
c7025
Commercial Invoicing Template (UPS Style)
Monday, October 19, 2015,
12
7
A4
Portrait
Pro-forma
c9002
Commercial Invoice - FedEx Style
Friday, November 27, 2015,
12
9
A4
Portrait
Pro-forma
c9003
Commercial Invoice - FedEx Style (Landscape)
Saturday, November 28, 2015,
9
9
A4
Landscape
Pro-forma
c9004
Commercial Template Sample - Using Payment Method Checkboxes
Sunday, November 29, 2015,
9
9
A4
Landscape
Pro-forma
c9005
Commercial Template Sample - Complete Incoterms Option
Monday, November 30, 2015,
9
9
A4
Landscape
Pro-forma
c9006
Commercial Template Sample - Adding Insurance Cost Field
Tuesday, December 1, 2015,
9
9
A4
Landscape
Pro-forma
c5013
Shipping Invoice Template (1)
Tuesday, January 14, 2014,
16
5
A4
Portrait
Sales
c5048
Shipping Invoice Template (2)
Wednesday, January 15, 2014,
16
5
A4
Landscape
Sales
c5087
Excel Shipping Invoice with Printable Truck Background Image
Friday, July 8, 2016,
16
5
A4
Portrait
Sales
c5101
Advanced Invoicing Sample - Macro-Enabled Invoicing Template
Sunday, November 20, 2016,
12
5
A4
Portrait
Sales
c3011
Recruitment Agency Invoice Template
Thursday, February 25, 2016,
12
3
A4
Portrait
Consulting
c5030
Five Price Percentage Levels (Service, Custom Column)
Monday, November 18, 2013,
30
5
A4
Portrait
Service
c5009
Five Price Levels (Sales, Amount, Custom Column)
Friday, November 15, 2013,
30
5
A4
Portrait
Sales
c4018
Consulting Invoice Template (3rd Sample - One Tax)
Friday, December 6, 2013,
16
4
A4
Portrait
Consulting
c7012
Proforma (2nd Sample of Customization)
Wednesday, October 30, 2013,
20
7
A4
Portrait
Pro-forma
c5077
Simple Template - Moving Shipping Address
Wednesday, February 3, 2016,
12
5
A4
Portrait
Service

What Is Hot

Feature Galleries