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.

...(57) 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.

...(100) 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.

Blank Commercial Invoice Templatec7004

Blank Commercial Invoice Template

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

...(54)Blank Commercial Invoice Template is provided in two editions - a freeware editions of Blank Commercial Invoice Template, and a Uniform Invoice Software (UIS) edition of Blank Commercial Invoice Template. Both editions can be downloaded for free from the download page. A PDF edition is also provided at the right section of this page.

...(105) The freeware edition of Blank Commercial Invoice Template provides exactly the same form layout and design in Microsoft Excel format as the UIS edition of Blank Commercial Invoice Template. The most noticeable difference, at the first glance, is that the UIS edition of Blank Commercial Invoice Template contains many buttons on it, such as Customers, Products, Invoices and Reports, etc. These buttons calls features and functionalities implemented by UIS. For example, if you click "Save To DB", UIS validates and checks the current document on Blank Commercial Invoice Template, generate a unique invoice number automatically (if necessary), and then save it to the backend database.

Commercial Invoice Template with Colorful Business Namec7022

Commercial Invoice Template with Colorful Business Name

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

...(39) 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.

  • In Excel 2003 click the Design Mode button on the Control Toolbox toolbar. Tip: If the Control Toolbox toolbar is invisible, click Excel menu View > Toolbars > Control Toolbox.
  • In Excel 2007, Excel 2010 and Excel 2013, click the Design Mode button in the Controls group of the Developer tab.

    TIP: If the Developer tab is not available in Excel 2007, do the following to display it: a) Click Microsoft Office Button, and then click Excel Options; b) In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

    Or in Excel 2010 and Excel 2013 to display the Developer tab: a) Click File > Options > Customize Ribbon; b) In the area on the right, ensure that the box next to Developer is checked; c) When you click OK, the Developer tab will appear in the ribbon.

Commercial Invoicing Template (UPS Style)c7025

Commercial Invoicing Sample (UPS Format)

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

...(194) 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 Format - FedEx Style" was found to be relative to Commercial Invoice Templates with the score grade of 79.

...(103) 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)

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

...(33) 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.

...(77) "Country of Export", "Country of manufacture" and "Country of ultimate destination" also have their locations moved in order to use less lines on the vertical orientation. Like the original design, this template has 8 columns too - "Harm. code", "No. of pkgs" "Type of packaging", "Full description of goods", "Qty", "Units of measure" , "Weight", "Unit Value" and "Total Value". The "SHIPPER" and "DATE" fields on the bottom of the form are designed to be signed manually.

Commercial Template Sample - Using Payment Method Checkboxesc9004

Commercial Template Format - Using Payment Method Checkboxes

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

...(21) This sample commercial invoice template explains and demonstrates how to add and use checkboxes to our Excel format commercial invoice form.

...(93) Now switch to design mode by pushing the "Design Mode" button on the "Invoice" ribbon tab. You have to choose 3 cells that will show the value of the "PaymentMethodTT", "PaymentMethodLC" and "PaymentMethodOther" fields. In this sample, we choose the $AA$40:$AA$42 range for this purpose, and named 3 cell "oknPaymentMethodTT","oknPaymentMethodLC" and "oknPaymentMethodOther" respectively. As you can see from this commercial invoice sample, the map (or link) between the database field and the Excel cell is archived by using names - you name the cell by adding the prefix "okn" to the field name.

...(57) Note that these 3 cells must be unlocked so that when the Invoice worksheet is protected, Uniform Invoice Software is able to write to these cells. To do this, select the 3 cells and right-click one of them, choose Format Cells. On the Format Cells dialog box, clear the "Locked" boxes from the "Protection" tab. Click OK.

Commercial Template Sample - Complete Incoterms Optionc9005

Commercial Template Sample - Complete Incoterms Option

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

...(29) 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.

...(41) First, open your commercial invoice template. Make sure the "Invoice" worksheet is active (the current sheet). Push down the "Design Mode" button on the "Invoice" ribbon tab (If you don't see this tab, make sure you have Uniform Invoice Software installed).

...(29) Second, choose a cell to place the Incoterms field. In this sample, we choose the range P38:P41. Clear the existing content / checkboxes. Name the "oknINCOTERM" and unlock it.

Commercial Template Sample - Adding Insurance Cost Fieldc9006

Commercial Template Format - 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.

...(83) In this sample, we placed the insurance and currency cells F15:K15. This was done by unmerge the original "Country of ultimate destination" cell to make space for the new cells. We also rearranged the "Country of Export", "Country of manufacture" cells. By moving the fields and labels, we aligned all the content in the F13:K17 section to make the form look professional and beautiful. Be sure to unlock the cells so that even if the sheet is protected, the cells are still fillable.

Shipping Invoice Template (1)c5013

Freight Invoice Format (1)

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

...(34)Shipping Invoice Template is also called freight invoice template. A shipping invoice is just like a commercial invoice which is used by business that deals in shipment of goods within or across the borders.

...(92) These new custom fields, combined with the default fields defined by the sales invoice template, make the billing template has the ability to detail shipping company, sender, recipient, description of the goods being shipped, total items shipped in one package, cost of shipment, date of shipment, name of the company which is the manufacturer of the goods, shipment code, etc. The shipping invoice sample also defines one tax, named "Service Tax", on the bottom of the form. You can easily change the tax name and tax rate by typing whatever you like.

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.

...(131) 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.

Excel Shipping Invoice with Printable Truck Background Imagec5087

Shipping Invoice with Printable Truck Background

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

...(37) If you are running a shipping business, this Excel-formatted (xlsx) shipping invoice template helps you to create beautiful and professional invoices. On revising the original shipping invoice template, we added a printable Volvo heavy truck background image.

...(60) 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.

  1. Again, make sure the "Invoice" worksheet is in design mode.
  2. Click to select a "pick up" (magnifying glass icons) button.
  3. Hit DEL key on keyboard.

Advanced Invoicing Sample - Macro-Enabled Invoicing Templatec5101

Advanced Invoicing Sample - Macro-Enabled Invoicing Template

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

...(31) While most templates here on InvoicingTemplate.com are ".xlsx" and ".xls" formats, Uniform Invoice Software does work with macro-enabled invoice templates. This sample introduces the steps to use ".xlsm" workbooks and templates.

...(61) To convert an Excel workbook or template from ".xlsx" to ".xlsm" format, simply issue the "File" and "Save As" command. We'll skip the detailed steps here as there are already many resource online, such as Create a Macro in Excel - EASY Excel VBA, and How to Use Macros in Excel: 15 Steps (with Pictures), and Quick start: Create a macro.

Recruitment Agency Invoice Templatec3011

Recruitment Firm Billing Sample

"Recruitment Agency Invoice Template" was found to be relative to Commercial Invoice Templates with the score grade of 31.

...(81) With Uniform Invoice Software installed, when you click a line on the invoice body section, the on-sheet picker button appears. Click this button to pop-up a window that shows all the pre-saved items that are the products you sell or the service you render. This is a time-saving feature that avoids to type in the same / similar text or price again and again from invoice to invoice. The on-sheet picker also works for the "Invoice#" cell, the "Bill To" section.

Five Price Percentage Levels (Service, Custom Column)c5030

Form with 5 Price Levels

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

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

...(99) Moving the location of a cell or field is easy in Excel. To do this, you first unprotect the sheet (if the sheet is protected), and then select all the cells or fields you want to move, and then drag the border of the selected area to move it to the new location. If you need to move an Active X control, such as the "select a shipping address" icon button, you first need to switch to design mode, and then click and drag the icon button to the new location - in this case, outside the printable area.

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

Form with 5 Price Levels

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

...(119) 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.

...(43) From the above description, we know that it is easy to let the consulting invoice form charge or show only one tax - just set the options on the Taxes tab of the Settings window. But how about the free consulting invoice template?

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. On the Tools menu, click Options, and then click the View tab.
  3. Under Window options, check the Gridlines and Row & Column Headers check boxes.

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

Proforma (2nd Sample of Customization)c7012

Proforma (2nd Sample of Customization)

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

...(27) This is the 2nd sample on how to create a new design for pro forma invoice template, focused on entering company information and replacing InvoicingTemplates logo image.

...(80) Now right-click the InvoicingTemplates logo image and choose Properties from the shortcut menu. The Properties box appears. Look for the Picture property, and click the button on that line. Excel shows you a dialog box that allows you to browse to and specify your own logo image. Depending on your Excel version, the supported image file formats may vary, but JPG, PNG and GIF formats are good choices for storing your logo image that are likely supported by your Excel.

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.

...(29) The templates that have no shipping address section are categorized as service invoice template. This simple invoice template demonstrates how to create it by moving out shipping address fields.

...(22) 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