Create a proforma invoice using our free template listed below. A pro forma invoice is very similar to a sales quote because it is used to formally define the value of a trade prior to shipping or the actual completion of the sale. In business, the term pro forma is often used to indicate a planned transaction or statement. A proforma invoice may be similar to a confirmed purchase order and may be legally binding, depending on the circumstances.


Proforma Invoice Template

for Excel, OpenOffice, & Google Docs
Like This Template?
Download Now Type: .XLS (Excel 2003+)
Size: ~50KB
Free Exclusive Content

THEME-ENABLED
Excel 2010 Version

Please share this page via Google +1 or FB Like

Get Excel 2010 Version
Template Details
Requirements
Microsoft Excel® 2002(XP) or Later

License
View Agreement
(not for resale or distribution)

Questions?


Get OpenOffice Version
Google Docs Version

Vertex42's Proforma Invoice Template will help your company generate great looking pro forma invoices. The template is designed for both domestic and international trade, with the same look and feel as our quote template and sales invoice.

A proforma invoice is a common form used in both domestic and international trade, where additional shipping details and the currency need to be defined, as well as details required for customs. We've designed our Pro Forma Invoice Template with this in mind. If you are doing business domestically, you might want to try one of our other invoice templates. See below for more information about using a pro forma invoice.

"No Installation, No Macros - Just a simple spreadsheet - An original creation by Vertex42.com"


Rate and Review this Proforma Invoice Template

Important Disclaimer - The information on this page and the the proforma invoice template are for educational and illustrative purposes only. You should consult the appropriate laws and professionals before using this information, or using the template in your business practices.

How to Use the Proforma Invoice Template

The template follows a typical pro forma invoice format. Simply download and fill out your business and customer information. Then begin filling out details of the proposed transactions including shipping details, payment terms, additional fees, costs and sales terms. Use the tips below and the info to the right of the form for help with specific sections.

Sometimes you'll need to include additional lines of details regarding a particular product. Probably the best approach is to just enter the details on separate rows. If your item description is longer than a single line, increase the height of the row. The text is designed to wrap, but because the cells are merged, the row height doesn't adjust automatically. If you want to include a Return inside the cell description, press Alt+Enter.

If the pro forma will be used for customs, fill out the Reason for Export and sign the document. Otherwise, you might simply delete those sections.

Tips

  • Make your price quote, proforma invoice and commercial invoices similar in layout and appearance so that you can quickly transfer information from one to the other to minimize paper work.
  • If you are shipping freight, you should be familiar with the terms FOB, CIF and C&F
  • Shipping internationally can be confusing and full of different fees. Make sure to do adequate research or seek professional assistance.
  • Make sure to include your company letter head at the top. This is required in some countries.

Why Use a Proforma Invoice?

Proforma invoices are most useful when two companies are doing business together for the first time and for import/export transactions. Below are some of the advantages:

  • Details, Details, Details – A pro forma invoice has all of the details of the transaction so that the customer knows exactly what they will be paying, leaving no room for surprises. This can help companies close deals because it helps customers become more comfortable about the complete terms of the deal.
  • Enabling Payment – A proforma invoice is often used by the buyer to secure credit for the purchase of the goods or services. In the case of international business, this credit is often issued as a Letter of Credit, typically required before the goods will ship. Without a proforma invoice, many international transactions would never occur.
  • Crossing Borders – In many countries, a pro forma invoice can be used to secure customs paperwork, consular invoices and to determine shipment values for calculating custom duties and import taxes. With a proforma invoice, all of this necessary paperwork can be processed before the shipment leaves the suppliers, decreasing total transit time.
  • Expedite Invoicing – Once a pro forma invoice has been finalized, a commercial invoice is quickly finalized and dispatched to the customer for payment.

References and Resources

  • Government Information on Exporting at export.gov - Great collection of information and resources on exporting from the United States.
  • Importing into the US at cbp.gov - A publication form the US government with help on importing into the U.S. Check out page 38 for information on Pro forma Invoices.
  • International Trade Administration at trade.gov - U.S. Government site with articles, links and guides for conducting international trade.
  • International Business Resource Desk at msu.edu - A great resource on international business resources and issues maintained by Michigan State University.
  • Trade Port at tradeport.org - A collection of information and resources for businesses seeking to conduct international trade (with a focus on California)
  • Industry Canada at ic.gc.ca- Canadian Government site with a collection of resources and guides for doing business with Canada.
  • Europe and the CE Mark - Good information on what a CE Mark is and who is required to have one before exporting to Europe.
  • Pro Forma at wikipedia.org - Information about the meaning of "pro forma".

Sharing Our Proforma Template

If you find our free proforma invoice useful, feel free to link to this page from your blog or website, using the following URL:

http://www.vertex42.com/ExcelTemplates/proforma-invoice.html

 

Like This Template?

Become a Fan