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.
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.
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.
In this commercial invoice template sample, Commercial Invoice Format with Word Art Logo, we first delete the existing ActiveX logo image control from the base template Commercial Template Sample - Complete Incoterms Option (c9005), and then insert a Word Art to create a new text logo. As you'll find from the screenshot images, if you have only limited budget for your logo images, using WordArt to create your logo on commercial invoices could result in ideal effect too.
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.
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.
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).
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.
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.
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.
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.
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.
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.
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).
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.