BoostExcel main content
Proforma Invoice Template (4th Sample, Landscape Page Orientation)
Proforma Invoice Template (4th Sample, Landscape Page Orientation)

This free sample proforma invoice templates differs from the previous proforma invoice forms in that the layout is customized to be printable on standard A4 paper with landscape page orientation.

Simple Proforma Invoicing Sample
Simple Proforma Invoice Format

In order to create this template from the original Proforma Invoicing Form (c7010), we firstly set the taxing mode of the template to one tax by using Invoice Manager for Excel.

Simple Sample - Default Value
Simple Sample - Default Value

The second category includes "Payment Term", "Shipping Method" (or "Shipping via"), "Customer Category", "Product Category" and "Sales Rep. Name". The default values of these fields can be changed manually by following the steps below.

Handyman Bill Sample (No Tax)
Handyman Billing Template (No Tax)

Handyman Bill Sample (No Tax) is a sample based on c7006 Handyman bill format. Unlick the original template, where the invoicing items are charged with either one or two taxes (GST and PST), this handyman bill format charges no tax.

Proforma (1st Sample of Customization)
Proforma Invoicing Form
  1. First, open the original ".xls" formatted proforma invoice template in Excel 2010 (Excel 2007 and all the later versions support ".xlsx" spreadsheet format).
  2. Click Excel menu File / Save As. If you have Invoice Manager for Excel installed, a warning message appears that says "If you save this workbook with a different file name, you must re-open it to ensure Invoice Manager for Excel functions properly. Are you sure you want to continue? " Choose Yes.
  3. On the "Save As" dialog box, choose "Excel Workbook" from the "Save as type" drop-down list. Name the new template "proforma 1st sample", or something else you like.
  4. If you have Invoice Manager for Excel installed, you may find that after executing Excel "Save As" command, all the buttons on the new template stop working. This is not a bug, bug by design - as stated above, you need to close and then reopen the template if you want to make the buttons work. But for the purpose of this sample, we'll skip this step.
  5. Now unprotect the Invoice worksheet. To do this in Excel 2010, go to the "Review" ribbon tab and click the Unprotect Sheet command.
  6. The background color we used for the labels "SHIP TO", "BILL TO", "SHIPPING DETAILS" and the heading line of the invoice body, as well as the fore color of the big title "PRO FORMA INVOICE", is a custom color defined in Excel palette. You can find this color on many of the templates designed by us here on - In fact, we use this color since 2005 - when we released Excel Invoice Manager for the first time. To make sure all of our templates have a similar style, this color has never been changed.

    However, to make your own invoice template, you may like to change it. Here is how you can do it (Again, we are using Excel 2010 in this tutorial.)

  7. Once returned to the Invoice worksheet, you can find the new color applied to the invoice form. See the figures below to find an example.
Proforma (2nd Sample of Customization)
Proforma Invoicing Form

Now right-click the InvoicingTemplates logo image and choose Properties from the shortcut menu. The Properties box appears. Look for the Picture property, and click the button on that line. Excel shows you a dialog box that allows you to browse to and specify your own logo image. Depending on your Excel version, the supported image file formats may vary, but JPG, PNG and GIF formats are good choices for storing your logo image that are likely supported by your Excel.

Proforma (3rd Sample of Customization)
Proforma Invoicing Form

The default implementation of the Proforma Invoice Template here on has a currency field on the Shipping Details section, which is a manually editable field. In practice the currency usually could be picked up from a limited set. For this reason, it could be implemented as a drop-down list, instead of a manually editable field. The benefit of using a drop-down list here is obvious - it is not only easy to use than a manually editable field, but also avoids typo mistakes. And the best part is that, Microsoft Excel provides direct support for this. Here are the steps to add the currency drop-down list to the pro forma invoice template.

Credit Memo Template
Credit Memo Template

A credit note is also called credit memo (memorandum). It is a commercial document issued by a seller to a buyer and states the amount of money that has been credited to the buyer's account. The credit note format available for free here on was originally a sample on customizing the default sales invoice template shipped with Invoice Manager for Excel, and it is now provided as a free template. The credit note template is offered in Microsoft Excel (.xls) format, which you can easily convert to the new (.xlsx) format by executing the "Save As" command in Microsoft Excel.

Transportation Invoice
Transportation Bill Format

To make the default invoice template suitable for use by transportation / taxi / limousine service company, this customized service invoice template uses several custom fields, as detailed in the following table.

Musician Invoice Template
Musician Invoice Template

The "Advertisement" section is an auxiliary section, which is not directly related to your bills or invoices, but allows you to put a brief description about your business and service, or you can also put your payment term, service term here. Note that this is a static text section - you can modify it once the template is switched to design mode, but when you are creating invoices, this section is protected and thus couldn't be modified. This also means that the section is not defined as a field in the database, and thus cannot be changed from invoice to invoice.

Invoicing Template in Euros
Invoicing Format in Euros

This template has one single tax named "VAT" set by default. To change the tax name or rate using Invoice Manager for Excel, which is our invoicing software program that enhances any Excel invoicing template here on InvoicingTemplate to be a complete invoicing system, first click the "Settings" button on the "Invoice" ribbon tab, go to the "Taxes" tab and then choose the number of taxes applied to this form, the names of the taxes, and the rates of the taxes. You can also enable options like "Tax invoice total including shipping cost" etc. Make sure you click the "Apply" button after modifying the taxing options, otherwise the template layout won't be changed according to the options you choose. If you accept the changes after verifying the form, click the "Save" button on Excel quick access tool bar to make the changes persistent. For more customization samples on VAT, visit VAT invoicing templates. Also refer to VAT invoicing rules on EU Taxation and customs union / European Commission.

Child Care Billing Template
Child Care Invoicing Form

This invoice template is for the companies or organizations who offer parenting services. As compared to the default/standard invoice template, the "Ship To" section is removed, and a new field, Date Of Birth, is added to the Bill To section, with witch you can record the birth date of a child. There are also a number of custom fields for the other customer-related information, such as Mother's Name, Mother's Profession, Mother's Mobile, etc., are added outside the Print_Area. On the invoice body section, Quantity and Price are moved out of the Print_Area, and two new columns, date and Fee, are added.

Sales Invoice Template with Discount Amount Column
Sales Template with Discount Amount Column

What if you need to show discounts in a more detailed manner? For example, show discounts applied to each item on invoice body separately? This requires an additional column on the invoice body, as compared to the 5 columns on the default sales invoice template that shipped with the setup program of Invoice Manager for Excel. So in this customized sample invoice template - Sales Invoice Template with Discount Amount Column, we have 6 columns on the invoice body within the printable invoice body: Product ID, Description, Quantity, Unit Price, Discount, and Line Total. The "Discount" here is an amount value. We'll publish the percentage version of this sample invoice template here on in the near future.