BoostExcel.com main content

Download

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

505 KBDownload

Download this if you want this design to be set as the default template by the installer program.

5.98 MBDownload

Screenshots and Images

The printed version.

Commercial Invoicing Template (UPS Style)

Open the template in Excel.

Commercial Invoicing Template (UPS Style) (IMFE Edition)

Detail

UPS freight commercial invoice, designed by InvoicingTemplate.com, has the similar layout and format as the PDF sample template on UPS (United Parcel Service), but in Microsoft Excel format.

While there is no standard format for a commercial invoice, customs agencies typically require that certain information be presented in clear and easily legible way. We've already provided some samples here on InvoicingTemplate.com, like Free Commercial Invoicing Template, Free Blank Commercial Invoicing Template, and Commercial Invoicing Sample with Colorful Business Name. There are also other pre-made commercial invoice. Numerous websites offer free, pre-made commercial invoice forms that can be printed and filled out manually. Some good examples include the aligned invoice by the United Nations Economic Commission for Europe, and examples by international shipping companies like FedEx and UPS.

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

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.

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.

If you are interested in some samples on pro forma invoices, some of the favorite items here on InvoicingTemplate.com are: Simple Proforma Invoicing Template, Proforma Invoicing Template (4th Sample, Landscape Page Orientation), and Proforma (3rd Sample of Customization), Proforma (2nd Sample of Customization), Proforma (1st Sample of Customization), Proforma Invoicing Template. While the above templates will suffice for the majority of transactions, some specific products or formalized commercial transactions may require additional information. These requirements are listed on the United States International Trade Commission's website.

Format and Specification

Template#c7025
NameCommercial Invoicing Template (UPS Style)
CategoryProforma Invoice Template
Release DateMonday, October 19, 2015
Format (XLS or XLSX).xlsx
Feature Gallery
Columns7
Lines12
Line Height (Points)15.00
Print Area$F$3:$P$60
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree (0.00USD)
SystemWindows 7 and later, and Excel 2007 and later.