Skip to main content main content
Sharing is caring


Commercial Invoice Template offers a blank commercial invoice form that helps you create commercial invoice, bill of sale or receipt in an intuitive way. The commercial invoice template contains required information for a Customs and Border Protection (CBP) Officer to determine if the goods being imported are admissible, and if so, what the correct Harmonized Tariff Schedule (HTS) classification and rate of duty should be.

What is commercial invoice

A commercial invoice is considered the most important document in international trade, because merchandise is not allowed to clear customs at the destination without one. That is even true if the goods are samples and have no commercial value. The form should identify the seller and buyer of goods or services identify invoice number, date, shipping date, delivery and payment terms, and a complete listing and description of the goods or services sold including, quantities, prices, and discounts.

A commercial invoice is used as a customs declaration provided by the person or corporation that is exporting an item across international borders. Although there is no standard format for an invoice, the document must include a few specific pieces of information as what implemented by this free commercial invoice template provided you free of charge by, such as the parties involved in the shipping transaction, the goods being transported, the country of manufacture, and the Harmonized System codes for those goods. A commercial invoice must also include a statement certifying that the invoice is true, and a signature. Commercial invoices are in European countries not normally for payment. The definitive invoice for payment usually has only the words 'invoice'.

The form format

On the top left side of the form there is a logo image and a section for the seller information. In addition to company name, phone number, country, address, city, state and zip, another important field, TAX ID, must also be filled in. To the right of this section, there are 6 fields under the big title 'Commercial Invoice': Invoice Date, Invoice Number, Waybill #, Purchase Order Number, Terms of Sale ((INCOTERM), and Reason for Export. Note that the 'Terms of Sale (Incoterm)' is implemented as a drop-down list, that allows you to choose the content of the field from a list: DAT (Delivered at Terminal), DAP (Delivered at Place), DDP (Delivered Duty Paid), EXW (Ex Works), Shipping point, Freight collect, Freight prepaid). The source of the list is located at $AA$12 on the worksheet (Terms according to the International Commerce terms, updated January 1, 2011 eighth edition, Incoterms 2010.)

The 'Sold To' and 'Ship To' sections are similar to what they look like in a general sales invoice format, except there are two 'Tax ID' fields added.

The next section provides the following fields: Currency Code, Sales Person, Ship Date, Ship Via, Total Packages, Total Weight.

On the invoice body, you can provide complete description of each item being shipped: Units, U/M (Unit of Measure), Description, 'Harm Code' (Harmonised Codes), C/O (Country of Origin), Unit Price, Line Total. Line totals are calculated automatically from Units and Unit Price.

On the bottom of the invoice form, you can find a section for 'Declaration statement'. These are static texts that are not changed from invoice to invoice. To change the default text labels, simply unprotect the form and then type in your own text labels. On the right side, you can find fields that summarize the invoice, including fields such as: subtotal, tax rate (manually editable) and tax amount, discount/rebate (manually editable), shipping and handling (manually editable), insurance (manually editable), other (manually editable), and grand total (auto-calculated using Excel).

The next section is a declaration 'I declare all the information contained in this invoice to be true and correct', and two fields 'Shipper' and 'Date' that are intent for hand-writing signature.

How to use

Before using this free commercial invoice template provided by to create your first commercial invoice, some fields should be modified to meet your business facts, including the default logo image, company name, address and tax ID, declaration statement on the bottom of the invoice form, tax rate. To enter a new text label, simply unprotect the invoice worksheet and then type in your new text. To replace the default logo image, switch to design mode while the invoice worksheet is unprotected, right-click the logo image and choose Properties. Click the '...' button on the Picture property to browse to and open your own logo image. Once everything is ready, you can now create your own professional-looking commercial invoice by filling the form.

The invoice template itself does not create PDF format commercial invoices, but you can install one of those free add-in programs for your Office, such as PrimoPDF. Once such a program is installed, you can create your PDF commercial invoice by simply print to the PDF printer in Microsoft Excel.


Tip: Enlarge an image by clicking on it.

Commercial Receipt Form - printed document

This is how commercial invoice template will look like when you open it with Microsoft Excel.

Commercial Receipt Form - Excel worksheet

The following version of Commercial Invoice Template should be used with Invoice Manager for Excel installed.

Commercial Receipt Form - Invoice Manager for Excel edition

Download Commercial Invoice Template

Quick facts

  • Template#: c7-011
  • Columns: 7


Choose the format you like and download Commercial Invoice Template for free by clicking the corresponding "Download" button. The zip packages include the simplified version for Invoice Manager (Lite).

The Excel template integrated with Invoice Manager for ExcelDownload
Commercial Invoice Template (Commercial Receipt Form) in PDF formatDownload
Commercial Invoice Template and database in a self-extracting zip packageDownload
Commercial Invoice Template, the Excel template (workbook) only (.xls or .xlsx)Download
The Excel template in zip packageDownload

Related Templates