Skip to main content main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Commercial Invoicing Template (UPS Style). Double-click the downloaded file to extract all files.
  2. Open the template "commercial-ups.xlsx" or "commercial-ups-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Commercial Invoicing Template (UPS Style)

Commercial Invoicing Template (UPS Style) (c7025)

c7025 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open commercial-ups-uis.xlsx.

Commercial Invoicing Template (UPS Style) (UIS Edition)

Commercial Invoicing Template (UPS Style) - UIS edition

Download Commercial Invoicing Template (UPS Style) (c7025)

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.


Download this if you have already installed UIS, but are looking for additional customized templates.

418 KBDownload

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

2.79 MBDownload


Commercial Invoicing Template (UPS Style), designed by, 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, 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 is in Microsoft Excel spreadsheet format, and as always, this template works well with Uniform Invoice Software (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 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.

As you can see from Commercial Invoicing Template (UPS Style), one benefit of using Excel as your invoice creator, as compared to other template formats like Microsoft Word invoice template and PDF invoice template, HTML format or even Photoshop format, is that you can easily apply formulas to do calculations. This means that, once the basic figures are entered on the form, like Quantity and Unit Price, or Hours and Hourly Rate, or Days and Daily Rate, the calculation of totals and taxes is done automatically.

While the free version of Commercial Invoicing Template (UPS Style) is simple, the result created by using this Microsoft Excel spreadsheet template is as beautiful and professional as many commercial invoicing software program, or even better. It is an ideal tool for small businesses and freelancers who sales products and do need a shipping section on their invoicing form. It is a good invoice generator, but if you need more features, like management of customers, products / items, invoices and payments, just install Uniform Invoice Software to make all the buttons on Commercial Invoicing Template (UPS Style) work for you.

Like other form designs here on, Commercial Invoicing Sample (UPS Format) is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

NameCommercial Invoicing Template (UPS Style)
CategoryProforma Invoice Template
Release DateMonday, October 19, 2015
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Line Height (Points)15.00
Print Area$F$3:$P$60
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)

Sample Templates