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(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 (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
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 Invoice Manager for Excel 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.
Blank Commercial Invoice Template
This Blank Commercial Invoice Template was originally published on office-kit.com as c7004 and is now revised and published here on InvoicingTemplate.com. It differs from the original in that this version includes a logo image on the top of the form.
Commercial Invoice Format with Editable Word Art Logo
The commercial invoice is required by both the exporter and importer. While most logos in our free invoice templates are images, this design of commercial invoice form demonstrates how to create your own logo using Word Art. The approach applies to all our Excel invoice templates.
Commercial Invoice Template with Colorful Business Name
As you can see from this commercial invoice template sample, with a few simple text boxes, a general commercial invoice template could be a beautiful, yet powerful and professional invoice template. With Microsoft Excel, InvoicingTemplate.com takes the "what you see is what you get" approach to a whole new level. The entire invoice creation process is handled on a single page. There is no need to navigate through countless pages of the site to add clients, set up tax schemes or get a preview of the final invoice. It all happens on one single page - how about that for a truly "what you see is what you get" approach? And, if you install Invoice Manager for Excel, there are more you can do with the Excel template - management of your products and client accounts, tracking invoices and payments.
Commercial Invoice for Shipping
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
By installing Invoice Manager for Excel, this pure-Excel spreadsheet commercial invoice format could be a complete invoicing tool for customs declaration.
Commercial Invoicing Template (UPS Style)
With the support of UIS, you can not only draft new invoices, print hard copies or create PDF invoices, but also manage the customers, products, invoices and payments in an easy and quick way. For example, with UIS installed, knowing your account receivable is just one click away. There are also rich reporting features available when you use this template with UIS, such as Sales Report, Product Report, Customer Report, and Customer Statement etc.
Commercial Invoice - FedEx Style
This sample commercial invoice offers a free downloadable and fillable template in Microsoft Excel spreadsheet (xlsx) and Adobe PDF format, with the form layout similar to the sample template on FedEx.
Commercial Invoice - FedEx Style (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 Checkboxes
This sample commercial invoice template explains and demonstrates how to add and use checkboxes to our Excel format commercial invoice form.
Indonesian Invoice Template
This Indonesia Invoice Template translates text inside the printable form from English to Indonesian.
The basic form layout is still copied from the standard invoice shipped with Invoice Manager. The only changed option is its color scheme and the static text. The following tables shows both the Indonesian text and its original English text.
Commercial Template Sample - Complete Incoterms Option
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.
Commercial Template Sample - 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)
Shipping Invoice Template (2)
Since the paper is now in landscape orientation, we need to hide some rows to make the shipping invoicing layout be printable on a single page.
Excel Shipping Invoice with Printable Truck Background Image
- Open the "Page Setup" dialog box as described above.
- Go to the "header / Footer" tab.
- Check "Scale with document" and "Align with paper margins", and then click "Custom Header".
- On the "Header" dialog box, click to activate the "Center section" box.
- Click the "Insert Picture" button on the toolbar.
- Specify the picture / image you want to use, by browsing local computer, or search online.
- Once the picture has been specified, Excel inserts a "&[picture]" placeholder to the "Center section" box.
- Click to select the "&[Picture]" symbol, click the "Format Picture" button on the toolbar. This opens the "Format Picture" dialog box.
- On the "Size and rotate" section, set height and width of the picture to proper values. In this shipping invoice sample, the target paper is standard A4 paper (8.27 inch X 11.69 inch), so we set the image size to 6.89 inch (height) and 8 inch (width). This makes the truck image to be on the center of the printed invoice. If you are following this sample to insert your own image, you should adjust the width and height according to your own image.
- Go to the "Picture" tab. In the "Image Control" section, set "Brightness" to 85%, set contrast to 30%. Again, you should choose these values depending on your image colors.
- Click the "Compress" button to make the inserted image smaller in file size.
- Close the "Format Picture" dialog box.
- Click OK to close the "Header" dialog box.
- Click "Print Preview" on the "Page Setup" dialog box.
- Excel shows what it will like when the "Invoice" worksheet is printed.
- You may need to open again the "Header" dialog box to adjust the size, brightness and contrast to get a best / satisfying background image effect.
- Once everything is done, click "Design Mode" button on the "Invoice" ribbon tab to exit design mode.
- Save the template.
Advanced Sample - Macro-Enabled Invoicing Template
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 Template
On the top-right section are the invoice date, invoice# and customer# fields. The invoice date field is filled automatically with current computer when you click the "Clear & New" button. It is also manually fillable / editable when you create an invoice. Likewise, invoice# field is manually fillable too - but usually, you can just leave it blank, and when you click "Save Invoice" to save an invoice to the back end database, Invoice Manager for Excel will produce a new invoice# for you. The auto generation of invoice# is based on a prefix and a serial number stored in the database, which you can adjust by clicking the "Settings" button on the "Invoice" ribbon tab and then go to the "Database" tab.
Five Price Percentage Levels (Service, Custom Column)
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.