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.
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.
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 (namely Uniform Invoice Software), there are more you can do with the Excel template - management of your products and client accounts, tracking invoices and payments.
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.
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.
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.
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.
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.
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 (namely Uniform Invoice Software) 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.
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.